STAFFINGORDEREXTERNALREFERENCE¶
This source table is a linking table between the systems. Records in this table link CLASSIC / Back Office Staffing Order records to the records in other systems, such as Reqs in BOLD / Front Office.
Columns¶
| Column | Data type | Description |
|---|---|---|
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 from the external system. |
EXTERNALSYSTEMNAME |
VARCHAR | The name of the external system. |
LASTUPDATEDDATE |
TIMESTAMP_NTZ | The timestamp when the row was last updated. |
OFFSETVALUE |
NUMBER | For Avionté internal use only. |
STAFFINGORDEREXTERNALREFERENCEID |
NUMBER | The unique identifier for the Staffing Order External Reference, formatted as a GUID. |
STAFFINGORDERGUID |
VARCHAR | The unique identifier for the Staffing Order in CLASSIC / Back Office, formatted as a GUID. |