|
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. |
|
|
