SQL-001 Get next 1502 transfer sequence value¶

Retrieves the next sequence value used to key a new DCBS 1502 transfer row, though Create() actually obtains its key via DataPortalInfo.GetNextSeqNum rather than this declared SQL property.*

Classification¶

Field	Value
SQL ID	SQL-001
Operation type	Sequence
Execution method	Inline SQL
Database	Oracle
Schema	`[unqualified]**`
Command type	Text
Business object	`cls1502Transfer`
Criteria property	`CreateSQL`
Lifecycle method	`(declared, not wired)*`

Tables¶

Table	Access	Columns used
CL_1502_DCBS_TRANSFER	N/A	N/A — sequence read from DUAL

Sample SQL¶

-- Next sequence value for CL_1502_DCBS_TRANSFER_SEQ
SELECT CL_1502_DCBS_TRANSFER_SEQ.NEXTVAL
  FROM DUAL

Operations and processes¶

DCBS 1502 transfer handling

Business rules¶

BR-001: 1502 transfer claim ID required

Sources¶

SAIF.Business.Claim/cls1502Transfer.vb