ReportHTML

Entity [Package]

Description

This entity captures the package level information of a DDP referal.

Need to be mapped to existing DAD database structure.

List of attributes

Package ID

The GUID primary key.

Char (32)

Referral ID

A candidate key.

The Referral ID is created by SAMS and sent to DAD via a nightly batch, together with client information.

Integer

Member ID

Member ID is the reference key to the Client entity,

Integer

SADIE Send Date

The datetime when the package information (Referral ID, Member ID) is sent to SADIE.
Note: the package status will be sync'd with SADIE constantly, this element will not reflect the sync datetime.

Date & Time

SAMS Creation Date

The date this referral package information is first sent to DAD.

Date

Cancellation Date

The date this referral package is cancelled (by SAMS).

Date

Status Code

The status code of this package, including:
Created
Partial Submitted
Submitted
Adjudication in Process
Rejected.
Cancelled
......

Varchar (20)

Submission Completion Date

The date time the full mandatory submission received.

This date should not be changed if additional information is received as the result of acquisition during the adjudication process.

Date & Time

Adjudication Start Date

The date when adjudication process started. Normally, this date should be later than Submission Completion Date.

Date & Time

Date Created

The data and time this record was created.

Date & Time

Date Updated

The data and time this record was last updated. For the full update history should be captured with an audit table.

Date & Time

Created By

The ID/Code of the user/system component who created this record.

Varchar (20)

Updated By

The ID/Code of the user/system component who last updated this record.

Varchar (20)

Home