Import Order of Data
Because of the dependencies (that is, foreign key constraints) between various data types, the order of data import is strictly enforced. Standard Import Process imports data in this order:
| Import order | Data type | Staging table |
|---|---|---|
| 1 | External keys | ALEX_EXTERNAL_KEY |
| 2 | Group definitions | ALEX_USER_GROUP_DEFN |
| 3 | Group memberships and User Group Accesses | ALEX_USER_GROUP |
| 4 | Locations and associated group memberships | ALEX_LOCATION |
| 5 | Companies and associated group memberships | ALEX_COMPANY |
| 6 | Divisions and associated group memberships | ALEX_DIVISION |
| 7 | Departments and associated group memberships | ALEX_DEPARTMENT |
| 8 | Cost Center segment and associated group memberships | ALEX_COST_CENTER_SEGMENT |
| 9 | Cost Center Review segment and associated group memberships | ALEX_COST_CENTER_REV_SEGMENT |
| 10 | Cost Centers and associated group memberships | ALEX_COST_CENTER |
| 11 | Offices and associated group memberships | ALEX_OFFICE |
| 12 | Job classifications and associated group memberships | ALEX_JOB_CLASSIFICATION |
| 13 | Clients and associated group memberships | ALEX_CLIENTS |
| 14 | Units of Measure and associated group memberships | ALEX_UNIT_OF_MEASURE |
| 15 | Addresses and associated group memberships | ALEX_ADDRESS |
| 16 | Payment Request Vendor Terms and associated group memberships | ALEX_PR_VENDOR_TERMS |
| 17 | Users, TS user attributes, ER user preferences, associated group memberships, and credit card transaction filters | ALEX_USER |
| 18 | User approvers and user proxies | ALEX_PROXY |
| 19 | Cost center approvers | ALEX_COST_CENTER |
| 20 | Credit cards | ALEX_CREDIT_CARD |
| 21 | PR Vendors, vendor addresses, and associated group memberships | ALEX_PR_VENDOR |
| 22 | Project Codes and associated group memberships and application filters | ALEX_PROJECT_CODE |
| 23 | Guests and associated group memberships | ALEX_GUEST |
| 24 | TS user billable rates | ALEX_TS_USER_BILLABLE_RATES |
| 25 | External users | ALEX_EXTERNAL_USER |
| 26 | User accesses | ALEX_USER_ACCESS |
| 27 | Foreign exchange rates | ALEX_FX_RATE |
| 28 | Benefit items | ALEX_BENEFIT_ITEM |
| 29 | Reviewer permissions | ALEX_REVIEWER_PERMISSION |
| 30 | European per diem Rates | ALEX_PD_EUR_RATE |
| 31 | User reporting permissions | ALEX_REPORTING_PERMISSION |
| 32 | Company reporting permissions | ALEX_REPORTING_PERMISSION |
| 33 | Division reporting permissions | ALEX_REPORTING_PERMISSION |
| 34 | Department reporting permissions | ALEX_REPORTING_PERMISSION |
| 35 | Cost center reporting permissions | ALEX_REPORTING_PERMISSION |
| 36 | Project reporting permissions | ALEX_REPORTING_PERMISSION |
| 37 | User work item filters | ALEX_USER_WORK_ITEM_FILTER |