ASSIGNMENT_DATA

Description: |
This table holds the patients and roster identifiers for whom specific roster assignment data was loaded.

Primary Key

Column Name | Ordinal Position |
--- | --- | ---
ASGN_DATA_ID | 1 |

Column Information

| 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.
11 | SOURCE_ORG_ID | NUMERIC | No |
The source organization for an assignment record.
12 | SOURCE_ORG_ID_EXTERNAL_NAME | VARCHAR | No |
Organization's external name used as the display name on forms and user interfaces.
13 | BLK_DTA_MESSAGE_ID | NUMERIC | No |
The AMS record that most recently created or updated this assignment record.
14 | SOURCE_ENTITY_KEY_TYPE | VARCHAR | No |
An identifier for the external system's record key type, or ID assignment system.
15 | SOURCE_ENTITY_KEY | VARCHAR | No |
The key, or unique identifier, for the record provided by the source system.
16 | SOURCE_GEN_DTTM_ASN_UTC_DTTM | DATETIME (UTC) | No |
The timestamp of the source record from the external system.