!!!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 Area||Table
|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                |
|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             |