EMPLOYEEEXTERNALREFERENCE¶
This source table is a linking table between systems. Records in this table link CLASSIC / Back Office Employee records to the records in other systems, such as Applicants 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. |
EMPLOYEEEXTERNALREFERENCEID |
NUMBER | The identifier for this record. |
EMPLOYEEGUID |
VARCHAR | The unique identifier for the employee in CLASSIC / Back Office, formatted as a GUID. |
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. |