Order of Conversion#

Since the data that is being loaded into the environment builds on each other, the tables need to be loaded in a specific order so that the data validation that occurs during the conversion process will find the needed records. The order that the records need to be loaded in are basically the same that the records need to be keyed in, if they were being entered by hand through the application screens.

The chart, shown below, can be used as a guideline for converting records into the application. The first column shows the order number that the table will need to be loaded in. If the number does not contain a whole number (IE 0.1 for USERS), then the table does not have a conversion process associated to it. These records will have to be keyed into the application using the appropriate screen. The entries in this table with whole numbers (IE 1 for LOCATIONS, or 2 for ENTITIES), can be loaded in. However, if the table only contains a small quantity of data and the data does not need to be reloaded after being refreshed from PILOT, this data can be keyed into the appropriate screen. If this data is keyed into the PILOT database, this data will be taken to the CONV/PROD database during the EXPORT/IMPORT process.

Sequence Conversion AreaTable
0.1 USERS
0.2 WORK_STATUS
0.3 CHANGE_REASONS
0.4 TERMINATION_REASONS
0.5 GEO
0.6 LEXICONS
1 LOCATIONS INF_CV_LOCATIONS
1.1 CALENDARS
1.2 GLCOMPANIES
2 ENTITIES INF_CV_ENTITIES
3 BANKS INF_CV_BANKS
3.1 PAYROLLS
3.2 HOLIDAYS
4 AUTHORIZATIONS INF_CV_AUTHORIZATIONS
5 DEPARTMENTS INF_CV_DEPARTMENTS
5.1 ORG_LEVEL_TYPES
6 ORGLEVELS INF_CV_ORGLEVELS
7 WORKRULES INF_CV_WORKRULES
8 SCALES
9 RANGES
10 GLSEGMENTVALUES
11 UNITS INF_CV_UNITS
12 GROUPS INF_CV_GROUPS
12.1 PREMIUM_TYPES
13 PREMIUMS
14 JOBS INF_CV_JOBS
15 POSITIONS INF_CV_POSITIONS
16 PERSONALS INF_CV_PERSONALS
17 EMPLOYMENTS INF_CV_EMPLOYMENTS
18 ASSIGNMENTS INF_CV_ASSIGNMENTS
19 PROPERTIES INF_CV_PROPERTIES
20 CDNPAYRULES
21 USPAYRULES
22 MILITARIES INF_CV_MILITARIES
23 CONTACTS INF_CV_CONTACTS
24 PAYMENTRULES
25 DISTRIBUTIONS
25.1 REVIEW_CATEGORY
26 REVIEWS
26.1 PAYPOINTS
26.2 GLACCOUNTS
26.3 USERVARS
26.4 USPAYCATEGORIES
26.5 PAYCOMPONENTS
26.6 STATCOMP
26.7 FREQUENCIES
26.8 PAYCALENDARS
27 STATISTICS
28 SUNDRYLINES
29 TODATES
30 EXPERIENCES
31 MATRICES
31.1 LEAVE_TYPES
32 ACCRUALS
33 LEAVELINES
34 ENROLLMENTS
35 RECIPIENTS
36 PAYRUNS
37 PAYHEADERS
38 PAYLINES
39 PAYPCAMOUNTS
40 DISBURSEMENTS