SQL-004 Insert a new 1502 DCBS transfer record

Inserts a new DCBS 1502 transfer file record queued for transfer to the state.

Classification

Field	Value
SQL ID	SQL-004
Operation type	Create
Execution method	Inline SQL
Database	Oracle
Schema	[unqualified]**
Command type	Text
Business object	cls1502Transfer
Criteria property	InsertSQL
Lifecycle method	BeforeInsert

Parameters

Parameter	Direction	Type	Max length	Description
FileId	Input	String	36	Transfer file GUID identifier
ClaimId	Input	Decimal	—	Claim identifier
FileName	Input	String	40	Generated 1502 file name
TransferDate	Input	Date	—	Date the file was queued for transfer
ProcessedDate	Input	Date	—	Null until the DCBS transfer is processed
UpdateUser	Input	String	30	Auditing user

Tables

Table	Access	Columns used
CL_1502_DCBS_TRANSFER	INSERT	FILE_ID, CLAIM_ID, FILE_NAME, TRANSFER_DATE, PROCESSED_DATE, UPDATE_NUM, UPDATE_USER_ID, UPDATE_DATE

Sample SQL

-- Insert a new 1502 DCBS transfer record
INSERT INTO CL_1502_DCBS_TRANSFER
       (FILE_ID,
        CLAIM_ID,
        FILE_NAME,
        TRANSFER_DATE,
        PROCESSED_DATE,
        UPDATE_NUM,
        UPDATE_USER_ID,
        UPDATE_DATE)
VALUES (:FileId,
        :ClaimId,
        :FileName,
        :TransferDate,
        :ProcessedDate,
        0,
        :UpdateUser,
        SYSDATE)

Operations and processes

• DCBS 1502 transfer handling

Business rules

• BR-001: 1502 transfer claim ID required
• BR-002: 1502 transfer filing reason required
• BR-012: Optimistic concurrency contention check

Sources

• SAIF.Business.Claim/cls1502Transfer.vb