|
This entity captures the SA client information, replicated from SAMS. A client can have multiple DDP referrals over time, but can only have one active DDP referral active at any point-in-time. Sync with SAMS required? |
|
Name |
Description |
Data Type |
|
Member ID |
The primary key, generated from SAMS. |
Integer |
|
First Name |
First name of the client. |
Varchar (50) |
|
Middle Name |
Middle name of the client. |
Varchar (50) |
|
Last Name |
Last name of the client. |
Varchar (50) |
|
DOB |
Date of Birth. |
Date |
|
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) |
|
|
|