COMPILED_ASSIGNMENT_DATA

Description: |
This table holds the External System Identifier Bundles and roster identifiers for which compiled roster assignment data was loaded.

Primary Key

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

Column Information

| Name | Type | Discontinued? |
--- | --- | --- | --- | ---
1 | ASGN_DATA_ID | NUMERIC | No |
The unique identifier (.1 item) for the assignment data record.
2 | LINE | INTEGER | No |
The line number for the information associated with this assignment data record. Multiple pieces of information can be associated with this record.
3 | CM_LOG_OWNER_ID | VARCHAR | No |
The Community ID (CID) of the instance from which this record or line was extracted. This is only populated if you use IntraConnect.
4 | ROSTER_IDENTIFIER_C_NAME | VARCHAR | No |
The roster population that this line contains compiled tracking data for.
May contain organization-specific values: Yes
Category Entries:
general
LFM Rost
CFB Roster
5 | ASSIGNMENT_PERIOD_EFF_DATE | DATETIME | No |
The start date of this compiled roster assignment period.
6 | ASSIGNMENT_PERIOD_TERM_DATE | DATETIME | No |
The end date of this compiled roster assignment period.