ASSIGNMENTEXTERNALREFERENCE¶
This source table is a linking table between systems. Records in this table link CLASSIC / Back Office Assignment records to the records in other systems, such as Req Hired in BOLD / Front Office.
Columns¶
| Column | Data type | Description |
|---|---|---|
ASSIGNMENTEXTERNALREFERENCEID |
NUMBER | The identifier for the row. |
ASSIGNMENTGUID |
VARCHAR | The identifier for the assignment, formatted as a GUID. |
BUILDID |
VARCHAR | Avionté’s unique identifier for each of its customers’ instances or builds. The value in this field is the same for all rows. |
CDCSTATUS |
VARCHAR | For Avionté internal use only. |
EXTERNALSYSTEMID |
VARCHAR | The identifier for the Assignment in a system external to the Avionté CLASSIC / Back Office system. For example, if EXTERNALSYSTMENAME is 'Compas', this field contains the REQHIREDID from BOLD / Front Office. |
EXTERNALSYSTEMNAME |
VARCHAR | The name of the external system that this record links to. For linking between CLASSIC / Back Office and BOLD / Front Office, this field will contain 'Compas'. |
LASTUPDATEDDATE |
TIMESTAMP_NTZ | The timestamp when the row was last updated. |
OFFSETVALUE |
NUMBER | For Avionté internal use only. |