Source tables¶
Source tables store unprocessed data from the source systems, such as BOLD and CLASSIC.
| Table | Description | Columns |
|---|---|---|
| APPACTIVITY | This source table stores information about applicant activities. | 24 |
| APPLICANTSOURCESTAGESHISTORICALDATA | This source table stores information about historical applicant source stages. | 7 |
| APPLICANTTASKRECORDS | This source table stores information about applicant onboarding tasks. | 10 |
| APPLICANT_CONTRACTS | This source table stores information about applicant contracts. | 18 |
| APPLICANT_CONTRACT_TYPES | This source table stores information about applicant contract types. | 5 |
| 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. | 8 |
| CONFIGCHOICE | This source table stores information about CLASSIC / Back Office Configuration Choices. | 13 |
| CONFIGTRANSACTIONTYPE | This source table stores information about CLASSIC / Back Office Configuration Transaction Types. | 28 |
| CUSTOMEREXTERNALREFERENCE | This source table is a linking table between systems. Records in this table link CLASSIC / Back Office Customer records to records in other systems, such as Customers in BOLD / Front Office. | 8 |
| EEO_DATA | This source table stores information related to equal employment opportunity (EEO) tracking. | 17 |
| 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. | 8 |
| EVERIFY | This source table stores information about the E-Verify cases. | 15 |
| EVERIFY_STATUS | This source table stores information about E-Verify statuses. | 3 |
| EXTRAVALUE | This source table stores information about CLASSIC / Back Office user defined fields, also known as Extras. | 14 |
| FEDERALW42020 | This source table stores information about Federal W-4s. | 17 |
| OPPORTUNITIES | This source table stores information about BOLD / Front Office Opportunities. | 26 |
| OPPORTUNITY_AUDIT | This source table stores audit information about BOLD / Front Office Opportunities. | 10 |
| PAYMENTBATCH | This source table stores information about CLASSIC / Back Office Payment Batches. | 39 |
| PAYMENTCHECK | This source table stores information about CLASSIC / Back Office Payment Checks. | 33 |
| REQ_ATTACHMENTS | This source table stores information about documents that have been attached to a BOLD / Front Office Req. | 15 |
| 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. | 8 |
| TRANSACTIONENTRYITEM | This source table stores information about CLASSIC / Back Office Transaction Entry Items. | 24 |