Second Wave Conversions

Conversion Strategy

• Conversion Strategy

The use of these scripts and files are outlined in the Conversion Strategy document. Please review this document before downloading these files.

Conversion Crystal Reports

• CSU_CONV_EE_LISTING.RPT
• CSU_CONV_UNION_ACTIVITY.RPT

Conversion File Layout (.xls)

• Dental Covered Dependents
• Dental
• EE
• EmergencyCntct
• Flexcash
• Map-EE-To-PositionNbr
• Medical
• PERS-Dependents
• Sick Vacation Hol Accrual Balance
• SS Accrual Balance

Conversion Mapping

• Action Reason (.xls)
• EE Data (.xls)
• Empl Class
• Empl Status
• PIMS Mapping Tops
• Relationship

Conversion SQLs

• CONV_EE2_02_v8.sql
• DELETE_DENTAL_BENEF.sql
• DELETE_DENTAL_COVRD_DEP.sql
• DELETE_FLEXCASH.sql
• DELETE_MEDICAL_BENEF.sql
• MED_DENTAL.sql
• TRUNC_ALL_EE_TBLS_v8.sql
  
• TRUNC_DEPENDENT_BENEF.sql
• TRUNC_EMERGENCY_CNTCTS.sql
• TRUNC_LOAD_EE_TBLS_v8.sql
  
• UNDO_CONV_EE2_01_v8.sql

Conversion SQRs

• 4matname.sqc
• conv_ee.sqr
• csuprmxd.sqc
• getacntr.sqc
• getdegre.sqc
• getrelat.sqc
• lddental.sqr
• lddntldp.sqr
• lddpndnt.sqr
• ldemrgnc.sqr
• ldflxcsh.sqr
• ldlevbal.sqr
• ldmedicl.sqr
• ldssbal.sqr
• pims_ps.sqr
• str8cnv.sqr
• vrify_ee.sqr
• xtractxl.sqr