|
Name |
Type |
Discontinued? |
|
1 |
ASGN_DATA_ID |
NUMERIC |
No |
|
|
|
The unique identifier (.1 item) for the assignment data record. |
|
|
2 |
RECORD_STATUS_2_C_NAME |
VARCHAR |
No |
|
|
|
Stores the record status (hidden, soft-deleted, etc...) |
May contain organization-specific values: No |
Category Entries: |
Soft Deleted |
Hidden |
Hidden and Soft Deleted |
|
|
3 |
ROSTER_IDENTIFIER_C_NAME |
VARCHAR |
No |
|
|
|
The roster population that this record contains tracking data for. |
May contain organization-specific values: Yes |
Category Entries: |
general |
LFM Rost |
CFB Roster |
|
|
4 |
PAT_ID |
VARCHAR |
No |
|
|
|
The patient for whom this record contains roster tracking data. |
|
|
5 |
ASSIGNMENT_EFF_DATE |
DATETIME |
No |
|
|
|
The start date of the roster assignment period. |
|
|
6 |
ASSIGNMENT_TERM_DATE |
DATETIME |
No |
|
|
|
The end date of the roster assignment period. |
|
|
7 |
ATTRIBUTED_PROV_ID_PROV_NAME |
VARCHAR |
No |
|
|
|
The name of the service provider. This item may be hidden in a public view of the CLARITY_SER table. |
|
|
8 |
LAST_MODIFIED_INSTANT_UTC_DTTM |
DATETIME (UTC) |
No |
|
|
|
The instant that this roster assignment period was last loaded or backed out. |
|
|
9 |
EXTERNAL_DEMOG_ID |
NUMERIC |
No |
|
|
|
The unique ID of the External Demographic Set that this assignment is loaded to. |
|
|
10 |
EXTERNAL_IDENT_BUNDLE_ID |
NUMERIC |
No |
|
|
|
The unique ID of the External System Identifier Bundle that this assignment is loaded to. |
|
|