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 INF_CV_SCALES
9 RANGES INF_CV_RANGES
10 GLSEGMENTVALUES INF_CV_GLSEGMENTVALUES
11 UNITS INF_CV_UNITS
12 GROUPS INF_CV_GROUPS
12.1 PREMIUM_TYPES
13 PREMIUMS INF_CV_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 INF_CV_CDNPAYRULES
21 USPAYRULES INF_CV_USPAYRULES
22 MILITARIES INF_CV_MILITARIES
23 CONTACTS INF_CV_CONTACTS
24 PAYMENTRULES INF_CV_PAYMENTRULES
25 DISTRIBUTIONS
25.1 REVIEW_CATEGORY
26 REVIEWS INF_CV_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 INF_CV_STATISTICS
28 SUNDRYLINES INF_CV_SUNDRYLINES
29 TODATES INF_CV_TODATES
30 EXPERIENCES INF_CV_EXPERIENCES
31 MATRICES INF_CV_MATRICES
31.1 LEAVE_TYPES
32 ACCRUALS INF_CV_ACCRUALS
33 LEAVELINES INF_CV_LEAVELINES
34 ENROLLMENTS INF_CV_ENROLLMENTS
35 RECIPIENTS INF_CV_RECIPIENTS
36 PAYRUNS INF_CV_PAYRUNS
37 PAYHEADERS INF_CV_PAYHEADERS
38 PAYLINES INF_CV_PAYLINES
39 PAYPCAMOUNTS INF_CV_PAYPCAMOUNTS
40 DISBURSEMENTS INF_CV_DISBURSEMENTS


Notes #

Click to create a new notes page