BEG	|MAGIC-EMPLOYEE/POSITION	|REPORTS	|1	|20061207	|130151	|reports2000.sbcss.k12.ca.us	|Reports2000_D86	|86~
CAT	|MAGIC-EMPLOYEE/POSITION	|MAGIC-EMPLOYEE/POSITION~
DAT	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|PROVIDER=SQLOLEDB;SERVER=reports2000.sbcss.k12.ca.us;DATABASE=DataWarehousing;USER ID=reports2000;pwd=reports2000;Network Library=DBMSSOCN~
TAB	|MAGIC-EMPLOYEE/POSITION	|AddInfoView_01	|	|0	|AddInfoView	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|ADDITIONAL INFO~
TAB	|MAGIC-EMPLOYEE/POSITION	|AddInfoView_02	|	|0	|AddInfoView	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|Addinfoview 02~
TAB	|MAGIC-EMPLOYEE/POSITION	|AddInfoView_10	|	|0	|AddInfoView	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|ADDITIONAL INFO~
TAB	|MAGIC-EMPLOYEE/POSITION	|AddInfoView_15	|	|0	|AddInfoView	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|ADDITIONAL INFO~
TAB	|MAGIC-EMPLOYEE/POSITION	|AddInfoView_28	|	|0	|AddInfoView	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|ADDITIONAL INFO~
TAB	|MAGIC-EMPLOYEE/POSITION	|C_ASSIGN_ACCT	|corsys	|0	|C_ASSIGN_ACCT	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|ADDL EARNINGS ACCOUNT/STAFF DATA~
TAB	|MAGIC-EMPLOYEE/POSITION	|C_ASSIGN_EARNING	|corsys	|0	|C_ASSIGN_EARNING	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|ADDITIONAL EARNINGS~
TAB	|MAGIC-EMPLOYEE/POSITION	|C_ATTACH_POSN_VIEW	|corsys	|2	|CAP	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|Employee Position~
TAB	|MAGIC-EMPLOYEE/POSITION	|C_EMPE_ADDRESS	|corsys	|0	|C_EMPE_ADDRESS	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|ADDRESS~
TAB	|MAGIC-EMPLOYEE/POSITION	|C_EMPE_AFFIRM	|corsys	|3	|CEA	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|AFFIRMATIVE ACTION~
TAB	|MAGIC-EMPLOYEE/POSITION	|C_EMPE_CONTACT	|corsys	|0	|C_EMPE_CONTACT	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|C_EMPE_CONTACT~
TAB	|MAGIC-EMPLOYEE/POSITION	|C_EMPE_CRED	|corsys	|0	|C_EMPE_CRED	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|C_EMPE_CRED~
TAB	|MAGIC-EMPLOYEE/POSITION	|C_EMPE_DEGREE	|corsys	|0	|C_EMPE_DEGREE	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|C_EMPE_DEGREE~
TAB	|MAGIC-EMPLOYEE/POSITION	|C_EMPE_EMERG	|corsys	|0	|C_EMPE_EMERG	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|C_EMPE_EMERG~
TAB	|MAGIC-EMPLOYEE/POSITION	|C_EMPE_INSERVICE	|corsys	|0	|C_EMPE_INSERVICE	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|C_EMPE_INSERVICE~
TAB	|MAGIC-EMPLOYEE/POSITION	|C_EMPE_SKILLS	|corsys	|0	|C_EMPE_SKILLS	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|C_EMPE_SKILLS~
TAB	|MAGIC-EMPLOYEE/POSITION	|C_EMPE_SUBJECT	|corsys	|0	|C_EMPE_SUBJECT	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|C_EMPE_SUBJECT~
TAB	|MAGIC-EMPLOYEE/POSITION	|C_EMPE_TABLE	|corsys	|0	|C_EMPE_TABLE	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|C_EMPE_TABLE~
TAB	|MAGIC-EMPLOYEE/POSITION	|C_EMPE_TAXRET	|corsys	|0	|C_EMPE_TAXRET	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|TAX/RETIREMENT~
TAB	|MAGIC-EMPLOYEE/POSITION	|C_EMPE_YRS_EXP	|corsys	|0	|C_EMPE_YRS_EXP	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|C_EMPE_YRS_EXP~
TAB	|MAGIC-EMPLOYEE/POSITION	|C_GROUP_ORDER	|corsys	|0	|C_GROUP_ORDER	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|C_GROUP_ORDER~
TAB	|MAGIC-EMPLOYEE/POSITION	|C_POSITION	|corsys	|5	|CP	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|C_POSITION~
TAB	|MAGIC-EMPLOYEE/POSITION	|C_POSN_ACCT	|	|0	|C_POSN_ACCT	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|POSITION ACCOUNT/STAFF DATA~
TAB	|MAGIC-EMPLOYEE/POSITION	|C_PRO_RULE_FR_TO	|	|0	|C_PRO_RULE_FR_TO	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|C_PRO_RULE_FR_TO~
TAB	|MAGIC-EMPLOYEE/POSITION	|C_SAL_TYPE_AMT	|	|0	|C_SAL_TYPE_AMT	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|SALARY TYPE AMOUNT~
TAB	|MAGIC-EMPLOYEE/POSITION	|C_WORKCAL	|	|0	|C_WORKCAL	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|WORK CALENDAR DAYS/YEAR~
TAB	|MAGIC-EMPLOYEE/POSITION	|C_WORKCAL_CODE	|	|0	|C_WORKCAL_CODE	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|C_WORKCAL_CODE~
TAB	|MAGIC-EMPLOYEE/POSITION	|CREDIT	|	|0	|CREDIT	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|Credit~
TAB	|MAGIC-EMPLOYEE/POSITION	|EmployeeAddInfo_view	|	|0	|EmployeeAddInfo_view	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|ADDITIONAL INFO CODE/DESCRIPTION~
TAB	|MAGIC-EMPLOYEE/POSITION	|EmployeeAttributeView	|	|1	|CE	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|EMPLOYEE/POSITION~
TAB	|MAGIC-EMPLOYEE/POSITION	|EmployeeCheckList_view	|	|0	|EmployeeCheckList_view	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|CHECKLIST CODE/DATE~
TAB	|MAGIC-EMPLOYEE/POSITION	|EventsView_01	|	|0	|EventsView	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|EVENTS~
TAB	|MAGIC-EMPLOYEE/POSITION	|EventsView_02	|	|0	|EventsView	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|Eventsview 02~
TAB	|MAGIC-EMPLOYEE/POSITION	|EventsView_10	|	|0	|EventsView	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|EVENTS~
TAB	|MAGIC-EMPLOYEE/POSITION	|EventsView_15	|	|0	|EventsView	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|EVENTS~
TAB	|MAGIC-EMPLOYEE/POSITION	|EventsView_28	|	|0	|EventsView	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|EVENTS~
TAB	|MAGIC-EMPLOYEE/POSITION	|NOTE	|	|0	|NOTE	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|NOTES~
TAB	|MAGIC-EMPLOYEE/POSITION	|P2K_DistrictCredential	|	|0	|P2K_DistrictCredential	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|CREDENTIAL-DISTRICT~
TAB	|MAGIC-EMPLOYEE/POSITION	|P2K_EmergencyInfo	|	|0	|P2K_EmergencyInfo	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|EMERGENCY INFO~
TAB	|MAGIC-EMPLOYEE/POSITION	|P2K_Employee_View	|	|0	|P2K_Employee	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|EXPERIENCE/UNITS~
TAB	|MAGIC-EMPLOYEE/POSITION	|P2K_EmployeeClassifiedEducation	|	|0	|P2K_EmployeeClassifiedEducation	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|DEGREE-CLASSIFIED~
TAB	|MAGIC-EMPLOYEE/POSITION	|P2K_EmployeeClassifiedSkill	|	|0	|P2K_EmployeeClassifiedSkill	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|SKILL-CLASSIFIED~
TAB	|MAGIC-EMPLOYEE/POSITION	|P2K_EmployeeContact	|	|0	|P2K_EmployeeContact	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|CONTACTS~
TAB	|MAGIC-EMPLOYEE/POSITION	|P2K_EmployeeEducation	|	|0	|P2K_EmployeeEducation	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|DEGREE-CERTIFICATED~
TAB	|MAGIC-EMPLOYEE/POSITION	|P2K_EmployeeInService	|	|0	|P2K_EmployeeInService	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|UNITS-CERTIFICATED~
TAB	|MAGIC-EMPLOYEE/POSITION	|P2K_EmployeeMedCond	|	|0	|P2K_EmployeeMedCond	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|MEDICAL CONDITION~
TAB	|MAGIC-EMPLOYEE/POSITION	|P2K_EmployeeMedication	|	|0	|P2K_EmployeeMedication	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|MEDICATION~
TAB	|MAGIC-EMPLOYEE/POSITION	|P2K_EmployeeSkill	|	|0	|P2K_EmployeeSkill	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|SKILL-CERTIFICATED~
TAB	|MAGIC-EMPLOYEE/POSITION	|P2K_ProfessionalGrowth	|	|0	|P2K_ProfessionalGrowth	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|PROFESSIONAL GROWTH-CLASSIFIED~
TAB	|MAGIC-EMPLOYEE/POSITION	|PositionFTE	|	|0	|PositionFTE	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|~
TAB	|MAGIC-EMPLOYEE/POSITION	|PositionView	|	|0	|PositionView	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|POSITION~
TAB	|MAGIC-EMPLOYEE/POSITION	|SalaryScheduleView	|	|0	|SalaryScheduleView	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|SALARY SCHEDULE~
TAB	|MAGIC-EMPLOYEE/POSITION	|ScheduleMatrixView	|	|0	|ScheduleMatrixView	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|SALARY SCHEDULE AMOUNT~
TAB	|MAGIC-EMPLOYEE/POSITION	|SUPERVISORVIEW	|	|0	|SupervisorView	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|SUPERVISOR~
TAB	|MAGIC-EMPLOYEE/POSITION	|TC_REQUIREMENTS	|cred	|0	|TC_REQUIREMENTS	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|TC_REQUIREMENTS~
TAB	|MAGIC-EMPLOYEE/POSITION	|USER_RECORD	|cred	|0	|USER_RECORD	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|USER_RECORD~
TAB	|MAGIC-EMPLOYEE/POSITION	|USER_SCOPE	|cred	|0	|USER_SCOPE	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|USER_SCOPE~
TAB	|MAGIC-EMPLOYEE/POSITION	|view_EmployeeEvents	|	|0	|view_EmployeeEvents	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|EVENTS CODE/DATE~
FLD	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|AddInfoView_01	|DI_SSN	|DI SSN	|DI_SSN	|	|1440	|N	|N	|0	|1	|	|1	|12	|0	|0	|Full	|	|DI SSN	|N	|	|	|	|0	|	|True	|False~
FLD	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|AddInfoView_02	|DI_SSN	|DI SSN	|DI_SSN	|	|1440	|N	|N	|0	|1	|	|1	|12	|0	|0	|Full	|	|DI SSN	|N	|	|	|	|0	|	|True	|False~
FLD	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|AddInfoView_10	|DI_SSN	|DI SSN	|DI_SSN	|	|1440	|N	|N	|0	|1	|	|1	|12	|0	|0	|Full	|	|DI SSN	|N	|	|	|	|0	|	|True	|False~
FLD	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|AddInfoView_15	|DI_SSN	|DI SSN	|DI_SSN	|	|1440	|N	|N	|0	|1	|	|1	|12	|0	|0	|Full	|	|DI SSN	|N	|	|	|	|0	|	|True	|False~
FLD	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|AddInfoView_28	|DI_SSN	|DI SSN	|DI_SSN	|	|1440	|N	|N	|0	|1	|	|1	|12	|0	|0	|Full	|	|DI SSN	|N	|	|	|	|0	|	|True	|False~
FLD	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|C_ASSIGN_ACCT	|ACCOUNT	|ACCT-ADDL EARN	|ACCOUNT	|	|1440	|Y	|N	|0	|1	|	|1	|26	|17	|0	|Full	|	|ACCT-ADDL EARN	|N	|	|	|0	|0	|	|True	|False~
FLD	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|C_ASSIGN_ACCT	|ASSIGN_TYPE	|ASSIGN TYPE-STAFF DATA-ADDL EARN	|ASSIGN_TYPE	|	|1440	|Y	|N	|0	|1	|	|1	|2	|0	|0	|Full	|	|ASSIGN TYPE-STAFF DATA-ADDL EARN	|N	|	|	|0	|0	|	|True	|False~
FLD	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|C_ASSIGN_ACCT	|CSS	|CSS CODE-STAFF DATA-ADDL EARN	|CSS	|	|1440	|Y	|N	|0	|1	|	|1	|6	|0	|0	|Full	|	|CSS CODE-STAFF DATA-ADDL EARN	|N	|	|	|0	|0	|	|True	|False~
FLD	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|C_ASSIGN_ACCT	|DI_EIN	|DI_EIN	|DI_EIN	|	|1440	|N	|N	|0	|1	|	|1	|12	|0	|0	|Full	|	|DI_EIN	|N	|	|	|0	|0	|	|True	|False~
FLD	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|C_ASSIGN_ACCT	|DI_YR_SSN	|DI_YR_SSN	|DI_YR_SSN	|	|1440	|N	|N	|0	|1	|	|1	|16	|0	|0	|Full	|	|DI_YR_SSN	|N	|	|	|0	|0	|	|True	|False~
FLD	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|C_ASSIGN_ACCT	|EARN_TYPE	|EARN_TYPE	|EARN_TYPE	|	|1440	|Y	|N	|0	|1	|	|1	|4	|0	|0	|Full	|	|EARN_TYPE	|N	|	|	|0	|0	|	|True	|False~
FLD	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|C_ASSIGN_ACCT	|EFF_DATE	|EFF_DATE	|EFF_DATE	|	|1440	|N	|N	|0	|1	|	|2	|8	|0	|0	|Full	|	|EFF_DATE	|N	|	|	|0	|0	|	|True	|False~
FLD	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|C_ASSIGN_ACCT	|END_EFF_DATE	|END_EFF_DATE	|END_EFF_DATE	|	|1440	|N	|N	|0	|1	|	|2	|8	|0	|0	|Full	|	|END_EFF_DATE	|N	|	|	|0	|0	|	|True	|False~
FLD	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|C_ASSIGN_ACCT	|ID_DTE_TIM_STAMP	|ID_DTE_TIM_STAMP	|ID_DTE_TIM_STAMP	|	|1440	|N	|N	|0	|1	|	|1	|24	|0	|0	|Full	|	|ID_DTE_TIM_STAMP	|N	|	|	|0	|0	|	|True	|False~
FLD	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|C_ASSIGN_ACCT	|PERCENT_P	|ACCT %-ADDL EARN	|PERCENT_P1	|	|1440	|Y	|N	|0	|1	|	|8	|8	|12	|0	|Full	|	|ACCT %-ADDL EARN	|N	|	|	|0	|0	|	|True	|False~
FLD	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|C_ASSIGN_ACCT	|RFU_FILLER	|RFU_FILLER	|RFU_FILLER	|	|1440	|N	|N	|0	|1	|	|1	|4	|0	|0	|Full	|	|RFU_FILLER	|N	|	|	|0	|0	|	|True	|False~
FLD	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|C_ASSIGN_ACCT	|SI_DY_AL	|SI_DY_AL	|SI_DY_AL	|	|1440	|N	|N	|0	|1	|	|1	|32	|0	|0	|Full	|	|SI_DY_AL	|N	|	|	|0	|0	|	|True	|False~
FLD	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|C_ASSIGN_ACCT	|SI_DY_SDEI_T_ACC	|SI_DY_SDEI_T_ACC	|SI_DY_SDEI_T_ACC	|	|1440	|N	|N	|0	|1	|	|1	|58	|0	|0	|Full	|	|SI_DY_SDEI_T_ACC	|N	|	|	|0	|0	|	|True	|False~
FLD	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|C_ASSIGN_ACCT	|SI_DY_SDEI_TYI	|SI_DY_SDEI_TYI	|SI_DY_SDEI_TYI	|	|1440	|N	|N	|0	|1	|	|1	|56	|0	|0	|Full	|	|SI_DY_SDEI_TYI	|N	|	|	|0	|0	|	|True	|False~
FLD	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|C_ASSIGN_ACCT	|SI_DY_SNTY_SDTI	|SI_DY_SNTY_SDTI	|SI_DY_SNTY_SDTI	|	|1440	|N	|N	|0	|1	|	|1	|44	|0	|0	|Full	|	|SI_DY_SNTY_SDTI	|N	|	|	|0	|0	|	|True	|False~
FLD	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|C_ASSIGN_ACCT	|TWIN_FLAG	|TWIN_FLAG	|TWIN_FLAG	|	|1440	|N	|N	|0	|1	|	|1	|2	|0	|0	|Full	|	|TWIN_FLAG	|N	|	|	|0	|0	|	|True	|False~
FLD	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|C_ASSIGN_EARNING	|AMOUNT	|UNIT AMOUNT-ADDL EARN	|UNIT_AMOUNT	|	|1440	|Y	|N	|0	|1	|	|8	|8	|0	|0	|Full	|	|UNIT AMOUNT-ADDL EARN	|N	|	|	|0	|0	|	|True	|False~
FLD	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|C_ASSIGN_EARNING	|AVER_WKLY_HOURS	|AVG  WEEKLY  HRS-ADDL EARN	|AVER_WKLY_HOURS	|	|1440	|Y	|N	|0	|1	|	|8	|8	|12	|0	|Full	|	|AVG  WEEKLY  HRS-ADDL EARN	|N	|	|	|0	|0	|	|True	|False~
FLD	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|C_ASSIGN_EARNING	|CAMPUS_NO	|CAMPUS NO.-ADDL EARN	|CAMPUS_NO	|	|1440	|Y	|N	|0	|1	|	|1	|2	|0	|0	|Full	|	|CAMPUS NO.-ADDL EARN	|N	|	|	|0	|0	|	|True	|False~
FLD	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|C_ASSIGN_EARNING	|CONTRACT_DURATION_AD	|CONTRACT DURATION-ADDL EARN	|CONTRACT_DURATION_ADDL_EARN	|	|1440	|Y	|N	|0	|1	|	|1	|1	|0	|0	|Full	|	|CONTRACT_DURATION_ADDL_EARN	|N	|	|	|0	|0	|	|True	|False~
FLD	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|C_ASSIGN_EARNING	|DI_EIN	|DI_EIN	|DI_EIN10	|	|1440	|N	|N	|0	|1	|	|1	|12	|0	|0	|Full	|	|DI_EIN	|N	|	|	|0	|0	|	|True	|False~
FLD	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|C_ASSIGN_EARNING	|DI_YR_SSN	|DI_YR_SSN	|DI_YR_SSN3	|	|1440	|N	|N	|0	|1	|	|1	|16	|0	|0	|Full	|	|DI_YR_SSN	|N	|	|	|0	|0	|	|True	|False~
FLD	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|C_ASSIGN_EARNING	|EARN_TYPE	|EARN TYPE-ADDL EARN	|EARN_TYPE1	|	|1440	|Y	|N	|0	|1	|AERN	|1	|4	|0	|0	|Full	|	|EARN TYPE -ADDL EARN	|N	|	|	|0	|0	|	|True	|False~
FLD	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|C_ASSIGN_EARNING	|EARN_UNIT_TY_ADDL_EA	|EARN UNITS-ADDL EARN	|EARN_UNIT_TY_ADDL_EARN	|	|1440	|Y	|N	|0	|1	|	|8	|8	|15	|0	|Full	|	|EARN UNITS-ADDL EARN	|N	|	|	|0	|0	|	|True	|False~
FLD	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|C_ASSIGN_EARNING	|EARN_UNIT_TYPE	|EARN UNIT TYPE	|EARN_UNIT_TYPE	|	|1440	|Y	|N	|0	|1	|	|1	|1	|0	|0	|Full	|	|EARN_UNIT_TYPE	|N	|	|	|0	|0	|	|True	|False~
FLD	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|C_ASSIGN_EARNING	|EEO_CODE	|EEO CODE-ADDL EARN	|EEO_CODE1	|	|1440	|Y	|N	|0	|1	|	|1	|2	|0	|0	|Full	|	|EEO CODE-ADDL EARN	|N	|	|	|0	|0	|	|True	|False~
FLD	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|C_ASSIGN_EARNING	|EFF_DATE	|EFF_DATE	|EFF_DATE	|	|1440	|N	|N	|0	|1	|	|2	|8	|0	|0	|Full	|	|EFF_DATE	|N	|	|	|0	|0	|	|True	|False~
FLD	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|C_ASSIGN_EARNING	|END_EFF_DATE	|END_EFF_DATE	|END_EFF_DATE	|	|1440	|N	|N	|0	|1	|	|2	|8	|0	|0	|Full	|	|END_EFF_DATE	|N	|	|	|	|0	|	|True	|False~
FLD	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|C_ASSIGN_EARNING	|FILLER8	|FILLER8	|FILLER8	|	|1440	|N	|N	|0	|1	|	|1	|8	|0	|0	|Full	|	|FILLER8	|N	|	|	|0	|0	|	|True	|False~
FLD	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|C_ASSIGN_EARNING	|FTE	|FTE-ADDL EARN	|FTE1	|	|1440	|Y	|N	|0	|1	|	|8	|8	|16	|0	|Full	|	|FTE-ADDL EARN	|N	|	|	|0	|0	|	|True	|False~
FLD	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|C_ASSIGN_EARNING	|GROUP_RULE	|GROUP RULE-ADDL EARN	|GROUP_RULE2	|	|1440	|Y	|N	|0	|3	|GroupRule	|1	|2	|0	|0	|Full	|	|GROUP RULE-ADDL EARN	|N	|	|	|0	|0	|	|True	|False~
FLD	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|C_ASSIGN_EARNING	|HW_ELIGIBLE_FLAG_ADD	|H/W ELIGIBLE-ADDL EARN	|HW_ELIGIBLE_FLAG_ADDL_EARN	|	|1440	|Y	|N	|0	|1	|	|1	|1	|0	|0	|Full	|	|H/W ELIGIBLE-ADDL EARN	|N	|	|	|0	|0	|	|True	|False~
FLD	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|C_ASSIGN_EARNING	|ID_DTE_TIM_STAMP	|ADD EARNINGS DATE TIME	|ID_DTE_TIM_STAMP7	|	|1440	|N	|N	|0	|1	|	|1	|24	|0	|0	|Full	|	|ADD EARNINGS DATE TIME	|N	|	|	|0	|0	|	|True	|False~
FLD	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|C_ASSIGN_EARNING	|LEAVE_STATUS_ADDL_EA	|LEAVE STATUS-ADDL EARN	|LEAVE_STATUS_ADDL_EARN	|	|1440	|Y	|N	|0	|1	|	|1	|1	|0	|0	|Full	|	|LEAVE_STATUS_ADDL_EARN	|N	|	|	|0	|0	|	|True	|False~
FLD	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|C_ASSIGN_EARNING	|NBR_WKS	|WEEKS PER YEAR-ADDL EARN	|NBR_WKS	|	|1440	|Y	|N	|0	|1	|	|8	|8	|0	|0	|Full	|	|WEEKS PER YEAR-ADDL EARN	|N	|	|	|0	|0	|	|True	|False~
FLD	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|C_ASSIGN_EARNING	|RANGE	|RANGE-ADDL EARN	|RANGE4	|	|1440	|Y	|N	|0	|1	|	|1	|6	|0	|0	|Full	|	|RANGE-ADDL EARN	|N	|	|	|0	|0	|	|True	|False~
FLD	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|C_ASSIGN_EARNING	|RFU_FILLER	|RFU_FILLER	|RFU_FILLER	|	|1440	|N	|N	|0	|1	|	|1	|4	|0	|0	|Full	|	|RFU_FILLER	|N	|	|	|0	|0	|	|True	|False~
FLD	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|C_ASSIGN_EARNING	|SAL_SCHED	|SALARY SCHEDULE-ADDL EARN	|SAL_SCHED	|	|1440	|Y	|N	|0	|1	|	|1	|6	|0	|0	|Full	|	|SALARY SCHEDULE-ADDL EARN	|N	|	|	|0	|0	|	|True	|False~
FLD	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|C_ASSIGN_EARNING	|SI_DY_RULE	|SI_DY_RULE	|SI_DY_RULE	|	|0	|N	|N	|0	|1	|	|1	|8	|0	|0	|Full	|	|SI_DY_RULE	|N	|	|	|0	|0	|	|True	|False~
FLD	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|C_ASSIGN_EARNING	|SI_DY_SDEI_TYI	|SI_DY_SDEI_TYI	|SI_DY_SDEI_TYI	|	|0	|N	|N	|0	|1	|	|1	|56	|0	|0	|Full	|	|SI_DY_SDEI_TYI	|N	|	|	|0	|0	|	|True	|False~
FLD	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|C_ASSIGN_EARNING	|SI_DY_TYP_SDEI	|SI_DY_TYP_SDEI	|SI_DY_TYP_SDEI	|	|0	|N	|N	|0	|1	|	|1	|32	|0	|0	|Full	|	|SI_DY_TYP_SDEI	|N	|	|	|0	|0	|	|True	|False~
FLD	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|C_ASSIGN_EARNING	|STEP	|STEP-ADDL EARN	|STEP2	|	|1440	|Y	|N	|0	|1	|	|1	|6	|0	|0	|Full	|	|STEP-ADDL EARN	|N	|	|	|0	|0	|	|True	|False~
FLD	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|C_ASSIGN_EARNING	|TYPE	|EDUC/BONUS CODE-ADDL EARN	|TYPE1	|	|1440	|Y	|N	|0	|1	|	|1	|2	|0	|0	|Full	|	|EDUC/BONUS CODE-ADDL EARN	|N	|	|	|0	|0	|	|True	|False~
FLD	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|C_EMPE_ADDRESS	|ADDR1_HOME	|ADDRESS STREET-HOME	|ADDR1	|	|2880	|Y	|N	|0	|1	|	|1	|30	|0	|0	|FULL	|case C_EMPE_ADDRESS.RESTRICT_FLAG when 'Y' then '[RESTRICTED]' else C_EMPE_ADDRESS.ADDR1_HOME end	|ADDRESS STREET-HOME	|Y|1	|	|	|0	|0	|	|True	|False~
FLD	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|C_EMPE_ADDRESS	|ADDR1_MAIL	|ADDRESS STREET-MAIL	|ADDR1_MAIL	|	|2880	|Y	|N	|0	|1	|	|1	|30	|0	|0	|FULL	|case C_EMPE_ADDRESS.RESTRICT_FLAG when 'Y' then '[RESTRICTED]' else C_EMPE_ADDRESS.ADDR1_MAIL end	|STREET	|Y|2	|	|	|0	|0	|	|True	|False~
FLD	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|C_EMPE_ADDRESS	|ADDR2_HOME	|ADDRESS SEC.-HOME	|ADDR2	|	|1440	|Y	|N	|0	|1	|	|1	|30	|0	|0	|FULL	|case C_EMPE_ADDRESS.RESTRICT_FLAG when 'Y' then '[RESTRICTED]' else C_EMPE_ADDRESS.ADDR2_HOME end	|ADDRESS SEC.-HOME	|Y|1	|	|	|0	|0	|	|True	|False~
FLD	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|C_EMPE_ADDRESS	|ADDR2_MAIL	|ADDRESS SEC.-MAIL	|ADDR2_MAIL	|	|2880	|Y	|N	|0	|1	|	|1	|30	|0	|0	|FULL	|case C_EMPE_ADDRESS.RESTRICT_FLAG when 'Y' then '[RESTRICTED]' else C_EMPE_ADDRESS.ADDR2_MAIL end	|ADDR2	|Y|2	|	|	|0	|0	|	|True	|False~
FLD	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|C_EMPE_ADDRESS	|CITY_HOME	|ADDRESS CITY-HOME	|CITY	|	|2880	|Y	|N	|0	|3	|P2K_CITY	|1	|20	|0	|0	|FULL	|Case C_EMPE_ADDRESS.RESTRICT_FLAG When 'Y' Then '' Else C_EMPE_ADDRESS.CITY_HOME End	|ADDRESS CITY-HOME	|Y|1	|	|	|0	|0	|	|True	|False~
FLD	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|C_EMPE_ADDRESS	|CITY_MAIL	|ADDRESS CITY-MAIL	|CITY_MAIL	|	|2880	|Y	|N	|0	|3	|P2K_CITY	|1	|20	|0	|0	|FULL	|Case C_EMPE_ADDRESS.RESTRICT_FLAG When 'Y' Then '' Else C_EMPE_ADDRESS.CITY_MAIL End	|CITY	|Y|2	|	|	|0	|0	|	|True	|False~
FLD	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|C_EMPE_ADDRESS	|COUNTRY_HOME	|ADDRESS CNTRY-HOME	|COUNTRY	|	|1440	|Y	|N	|0	|1	|COUNTRY	|1	|14	|0	|0	|FULL	|Case C_EMPE_ADDRESS.RESTRICT_FLAG When 'Y' Then '' Else C_EMPE_ADDRESS.COUNTRY_HOME End	|ADDRESS-CNTRY-HOME	|Y|1	|	|	|0	|0	|	|True	|False~
FLD	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|C_EMPE_ADDRESS	|COUNTRY_MAIL	|ADDRESS CNTRY-MAIL	|COUNTRY_MAIL	|	|1440	|Y	|N	|0	|1	|COUNTRY	|1	|14	|0	|0	|FULL	|Case C_EMPE_ADDRESS.RESTRICT_FLAG When 'Y' Then '' Else C_EMPE_ADDRESS.COUNTRY_MAIL End	|COUNTRY	|Y|2	|	|	|0	|0	|	|True	|False~
FLD	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|C_EMPE_ADDRESS	|DI_EIN	|DI_EIN	|DI_EIN12	|	|1440	|N	|N	|0	|1	|	|1	|12	|0	|0	|FULL	|	|DI_EIN	|N	|	|	|0	|0	|	|True	|False~
FLD	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|C_EMPE_ADDRESS	|DI_SSN	|DI_SSN	|DI_SSN2	|	|1440	|N	|N	|0	|1	|	|1	|50	|0	|0	|FULL	|	|DI_SSN	|N	|	|	|0	|0	|	|True	|False~
FLD	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|C_EMPE_ADDRESS	|DISPLAY_ORDER	|DISPLAY_ORDER	|DISPLAY_ORDER	|	|1440	|N	|N	|0	|1	|	|1	|2	|0	|0	|FULL	|	|DISPLAY_ORDER	|N	|	|	|0	|0	|	|True	|False~
FLD	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|C_EMPE_ADDRESS	|EFF_DATE	|ADDRESS EFFECTIVE DATE	|EFF_DATE5	|	|1440	|N	|N	|0	|1	|	|2	|16	|0	|0	|FULL	|	|ADDRESS EFFECTIVE DATE	|N	|	|	|0	|0	|	|True	|False~
FLD	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|C_EMPE_ADDRESS	|END_EFF_DATE	|ADDRESS END DATE	|END_EFF_DATE2	|	|1440	|N	|N	|0	|1	|	|2	|16	|0	|0	|FULL	|	|ADDRESS END DATE	|N	|	|	|0	|0	|	|True	|False~
FLD	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|C_EMPE_ADDRESS	|ID_DTE_TIM_STAMP	|EMPE ADDRESS ID_DTE_TIM_STAMP	|ID_DTE_TIM_STAMP22	|	|1440	|N	|N	|0	|1	|	|1	|24	|0	|0	|FULL	|	|EMPE ADDRESS ID_DTE_TIM_STAMP	|N	|	|	|0	|0	|	|True	|False~
FLD	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|C_EMPE_ADDRESS	|RESTRICT_FLAG	|ADDRESS RESTRICT FLAG	|RESTRICT_FLAG	|	|1440	|Y	|N	|0	|1	|	|1	|1	|0	|0	|FULL	|	|RESTRICT_FLAG	|N	|	|	|0	|0	|	|True	|False~
FLD	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|C_EMPE_ADDRESS	|RFU_FILLER	|RFU_FILLER	|RFU_FILLER	|	|1440	|N	|N	|0	|1	|	|1	|4	|0	|0	|FULL	|	|RFU_FILLER	|N	|	|	|0	|0	|	|True	|False~
FLD	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|C_EMPE_ADDRESS	|STATE_HOME	|ADDRESS STATE-HOME	|STATE	|	|1440	|Y	|N	|0	|3	|P2K_STATE	|1	|2	|0	|0	|FULL	|Case C_EMPE_ADDRESS.RESTRICT_FLAG When 'Y' Then '' Else C_EMPE_ADDRESS.STATE_HOME End	|ADDRESS STATE-HOME	|Y|1	|	|	|0	|0	|	|True	|False~
FLD	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|C_EMPE_ADDRESS	|STATE_MAIL	|ADDRESS STATE-MAIL	|STATE_MAIL	|	|1440	|Y	|N	|0	|3	|P2K_STATE	|1	|2	|0	|0	|FULL	|Case C_EMPE_ADDRESS.RESTRICT_FLAG When 'Y' Then '' Else C_EMPE_ADDRESS.STATE_MAIL End	|STATE	|Y|2	|	|	|0	|0	|	|True	|False~
FLD	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|C_EMPE_ADDRESS	|ZIP_HOME	|ADDRESS ZIP-HOME	|ZIP	|	|1440	|Y	|N	|0	|1	|	|1	|10	|19	|0	|FULL	|Case C_EMPE_ADDRESS.RESTRICT_FLAG When 'Y' Then '' Else C_EMPE_ADDRESS.ZIP_HOME End	|ADDRESS ZIP-HOME	|Y|1	|	|	|0	|0	|	|True	|False~
FLD	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|C_EMPE_ADDRESS	|ZIP_MAIL	|ADDRESS ZIP-MAIL	|ZIP_MAIL	|	|1440	|Y	|N	|0	|1	|	|1	|10	|19	|0	|FULL	|Case C_EMPE_ADDRESS.RESTRICT_FLAG When 'Y' Then '' Else C_EMPE_ADDRESS.ZIP_MAIL End	|ZIP	|Y|2	|	|	|0	|0	|	|True	|False~
FLD	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|C_EMPE_AFFIRM	|CITIZEN_FLAG	|CITIZEN	|CITIZEN_FLAG	|CITIZEN_DESC	|1440	|Y	|N	|0	|3	|CITIZEN_FLAG	|1	|2	|0	|0	|Full	|	|CITIZEN	|N	|	|	|0	|0	|	|True	|False~
FLD	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|C_EMPE_AFFIRM	|COMMENT	|COMMENT-AFFIRM  ACTN	|COMMENT16	|	|1440	|Y	|N	|0	|1	|	|1	|255	|0	|0	|Full	|	|COMMENT-AFFIRM  ACTN	|N	|	|	|0	|0	|	|True	|False~
FLD	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|C_EMPE_AFFIRM	|DI_EIN	|DI_EIN	|DI_EIN4	|	|1440	|N	|N	|0	|1	|	|1	|12	|0	|0	|Full	|	|DI_EIN	|N	|	|	|0	|0	|	|True	|False~
FLD	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|C_EMPE_AFFIRM	|DI_SSN	|SSN	|DISSN_Affirm	|	|1440	|N	|N	|0	|1	|	|1	|12	|0	|0	|Audit	|	|SSN	|N	|	|	|0	|0	|	|True	|False~
FLD	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|C_EMPE_AFFIRM	|DISABILITYTYPE	|DISABILITY TYPE	|DISABILITYTYPE	|	|1440	|Y	|N	|0	|1	|DISA	|1	|1	|0	|0	|Full	|	|DISABILITY TYPE	|N	|	|	|	|0	|	|True	|False~
FLD	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|C_EMPE_AFFIRM	|DISABLE_TYPE	|DISABILITY	|DISABLE_TYPE	|DISABILITY_DESC	|1440	|Y	|N	|0	|3	|DISABLE_TYPE	|1	|2	|0	|0	|Full	|	|DISABILITY	|N	|	|	|0	|0	|	|True	|False~
FLD	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|C_EMPE_AFFIRM	|ETHNIC	|ETHNICITY	|ETHNIC	|ETHN_DESC	|1440	|Y	|N	|0	|3	|ETHN	|1	|2	|0	|0	|Full	|	|ETHNICITY	|N	|	|	|0	|0	|	|True	|False~
FLD	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|C_EMPE_AFFIRM	|ID_DTE_TIM_STAMP	|EMPE AFFIRMATIVE ACTION ID_DTE_TIM_STAMP	|ID_DTE_TIM_STAMP1	|	|1440	|N	|N	|0	|1	|	|1	|24	|0	|0	|Full	|	|EMPE AFFIRMATIVE ACTION ID_DTE_TIM_STAMP	|N	|	|	|0	|0	|	|True	|False~
FLD	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|C_EMPE_AFFIRM	|NOTE50	|U.S. ELIGIBLE-NOTES	|NOTE50	|	|1440	|Y	|N	|0	|1	|	|1	|50	|0	|0	|Full	|	|U.S. ELIGIBLE-NOTES	|N	|	|	|0	|0	|	|True	|False~
FLD	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|C_EMPE_AFFIRM	|RFU_FILLER	|RFU_FILLER	|RFU_FILLER	|	|1440	|N	|N	|0	|1	|	|1	|4	|0	|0	|Full	|	|RFU_FILLER	|N	|	|	|0	|0	|	|True	|False~
FLD	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|C_EMPE_AFFIRM	|SEX	|GENDER	|SEX	|SEX_DESC	|1440	|Y	|N	|0	|3	|GENDER	|1	|2	|0	|0	|Full	|	|GENDER	|N	|	|	|0	|0	|	|True	|False~
FLD	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|C_EMPE_AFFIRM	|SI_DI_SSNDEIN	|SI_DI_SSNDEIN	|SI_DI_SSNDEIN	|	|1440	|N	|N	|0	|1	|	|1	|24	|0	|0	|Full	|	|SI_DI_SSNDEIN	|N	|	|	|0	|0	|	|True	|False~
FLD	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|C_EMPE_AFFIRM	|VETERAN_DISABLE	|VETERAN DISABLE	|VETERAN_DISABLE	|	|1440	|Y	|N	|0	|3	|VETERAN_DISABLE	|1	|1	|0	|0	|Full	|	|VETERAN DISABLE	|N	|	|	|0	|0	|	|True	|False~
FLD	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|C_EMPE_AFFIRM	|VETERAN_VIETNAM	|VETERAN VIETNAM	|VETERAN_VIETNAM	|	|2160	|Y	|N	|0	|3	|VETERAN_VIETNAM	|1	|1	|0	|0	|Full	|	|VETERAN VIETNAM	|N	|	|	|0	|0	|	|True	|False~
FLD	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|C_EMPE_AFFIRM	|VETRAN	|VETERAN	|VETRAN	|VETERAN_DESC	|2448	|Y	|N	|0	|3	|VETRAN	|1	|4	|0	|0	|Full	|	|VETERAN	|N	|	|	|0	|0	|	|True	|False~
FLD	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|C_EMPE_CONTACT	|COMMENT	|CONTACT COMMENT	|COMMENT5	|	|1440	|N	|N	|0	|1	|	|1	|60	|0	|0	|FULL	|	|CONTACT COMMENT	|N	|	|	|0	|0	|	|True	|False~
FLD	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|C_EMPE_CONTACT	|DI_EIN	|DI_EIN	|DI_EIN3	|	|1440	|N	|N	|0	|1	|	|1	|12	|0	|0	|FULL	|	|DI_EIN	|N	|	|	|0	|0	|	|True	|False~
FLD	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|C_EMPE_CONTACT	|DI_SSN	|DI_SSN	|DI_SSN5	|	|1440	|N	|N	|0	|1	|	|1	|12	|0	|0	|FULL	|	|DI_SSN	|N	|	|	|0	|0	|	|True	|False~
FLD	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|C_EMPE_CONTACT	|DISPLAY_ORDER	|CONTACT ORDER NUMBER	|DISPLAY_ORDER1	|	|1440	|N	|N	|0	|1	|	|1	|1	|0	|0	|FULL	|	|CONTACT ORDER NUMBER	|N	|	|	|0	|0	|	|True	|False~
FLD	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|C_EMPE_CONTACT	|ID_DTE_TIM_STAMP	|CONTACT DATE TIME	|ID_DTE_TIM_STAMP5	|	|1440	|N	|N	|0	|1	|	|1	|24	|0	|0	|FULL	|	|CONTACT DATE TIME	|N	|	|	|0	|0	|	|True	|False~
FLD	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|C_EMPE_CONTACT	|NAME	|CONTACT NAME	|NAME2	|	|1440	|N	|N	|0	|1	|	|1	|36	|0	|0	|FULL	|	|CONTACT NAME	|N	|	|	|0	|0	|	|True	|False~
FLD	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|C_EMPE_CONTACT	|OCCUPATION	|CONTACT OCCUPATION	|OCCUPATION	|	|1440	|N	|N	|0	|1	|	|1	|30	|0	|0	|FULL	|	|CONTACT OCCUPATION	|N	|	|	|0	|0	|	|True	|False~
FLD	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|C_EMPE_CONTACT	|PHONE_HOME	|CONTACT HOME PHONE	|PHONE_HOME3	|	|1440	|N	|N	|0	|1	|	|1	|16	|10	|0	|FULL	|	|CONTACT HOME PHONE	|N	|	|	|0	|0	|	|True	|False~
FLD	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|C_EMPE_CONTACT	|PHONE_WORK	|CONTACT WORK PHONE	|PHONE_WORK3	|	|1440	|N	|N	|0	|1	|	|1	|16	|10	|0	|FULL	|	|CONTACT WORK PHONE	|N	|	|	|0	|0	|	|True	|False~
FLD	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|C_EMPE_CONTACT	|RELATION	|CONTACT RELATIONSHIP	|RELATION1	|	|1440	|N	|N	|0	|1	|	|1	|30	|0	|0	|FULL	|	|CONTACT RELATIONSHIP	|N	|	|	|0	|0	|	|True	|False~
FLD	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|C_EMPE_CONTACT	|RFU_FILLER	|RFU_FILLER	|RFU_FILLER	|	|1440	|N	|N	|0	|1	|	|1	|4	|0	|0	|FULL	|	|RFU_FILLER	|N	|	|	|0	|0	|	|True	|False~
FLD	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|C_EMPE_CONTACT	|SI_DY_SSNDEIN_DO	|SI_DY_SSNDEIN_DO	|SI_DY_SSNDEIN_DO	|	|1440	|N	|N	|0	|1	|	|1	|26	|0	|0	|FULL	|	|SI_DY_SSNDEIN_DO	|N	|	|	|0	|0	|	|True	|False~
FLD	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|C_EMPE_CRED	|CERT_LEVEL	|CERT_LEVEL	|CERT_LEVEL	|	|1440	|N	|N	|0	|1	|	|1	|2	|0	|0	|FULL	|	|CERT_LEVEL	|N	|	|	|0	|0	|	|True	|False~
FLD	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|C_EMPE_CRED	|CERT_NBR	|CERT_NBR	|CERT_NBR	|	|1440	|N	|N	|0	|1	|	|1	|10	|0	|0	|FULL	|	|CERT_NBR	|N	|	|	|0	|0	|	|True	|False~
FLD	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|C_EMPE_CRED	|CREDENTIAL	|CREDENTIAL	|CREDENTIAL	|	|1440	|N	|N	|0	|1	|	|1	|8	|0	|0	|FULL	|	|CREDENTIAL	|N	|	|	|0	|0	|	|True	|False~
FLD	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|C_EMPE_CRED	|DATE_EXPIRE	|DATE_EXPIRE	|DATE_EXPIRE	|	|1440	|N	|N	|0	|1	|	|2	|16	|0	|0	|FULL	|	|DATE_EXPIRE	|N	|	|	|0	|0	|	|True	|False~
FLD	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|C_EMPE_CRED	|DI_EIN	|DI_EIN	|DI_EIN	|	|1440	|N	|N	|0	|1	|	|1	|12	|0	|0	|FULL	|	|DI_EIN	|N	|	|	|0	|0	|	|True	|False~
FLD	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|C_EMPE_CRED	|DI_SSN	|DI_SSN	|DI_SSN	|	|1440	|N	|N	|0	|1	|	|1	|12	|0	|0	|FULL	|	|DI_SSN	|N	|	|	|0	|0	|	|True	|False~
FLD	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|C_EMPE_CRED	|ID_DTE_TIM_STAMP	|ID_DTE_TIM_STAMP	|ID_DTE_TIM_STAMP	|	|1440	|N	|N	|0	|1	|	|1	|24	|0	|0	|FULL	|	|ID_DTE_TIM_STAMP	|N	|	|	|0	|0	|	|True	|False~
FLD	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|C_EMPE_CRED	|NAME	|NAME	|NAME	|	|1440	|N	|N	|0	|1	|	|1	|36	|0	|0	|FULL	|	|NAME	|N	|	|	|0	|0	|	|True	|False~
FLD	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|C_EMPE_CRED	|RFU_FILLER	|RFU_FILLER	|RFU_FILLER	|	|1440	|N	|N	|0	|1	|	|1	|4	|0	|0	|FULL	|	|RFU_FILLER	|N	|	|	|0	|0	|	|True	|False~
FLD	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|C_EMPE_CRED	|SI_D_SSNDEIN_C_N	|SI_D_SSNDEIN_C_N	|SI_D_SSNDEIN_C_N	|	|1440	|N	|N	|0	|1	|	|1	|68	|0	|0	|FULL	|	|SI_D_SSNDEIN_C_N	|N	|	|	|0	|0	|	|True	|False~
FLD	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|C_EMPE_CRED	|TYPE	|TYPE	|TYPE	|	|1440	|N	|N	|0	|1	|	|1	|2	|0	|0	|FULL	|	|TYPE	|N	|	|	|0	|0	|	|True	|False~
FLD	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|C_EMPE_DEGREE	|CODE	|CODE	|CODE	|	|1440	|N	|N	|0	|1	|	|1	|6	|0	|0	|FULL	|	|CODE	|N	|	|	|0	|0	|	|True	|False~
FLD	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|C_EMPE_DEGREE	|DATE_GRAD	|DATE GRADUATED	|DATE_GRAD	|	|1440	|N	|N	|0	|1	|	|2	|16	|0	|0	|FULL	|	|DATE GRADUATED	|N	|	|	|0	|0	|	|True	|False~
FLD	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|C_EMPE_DEGREE	|DEGREE	|DEGREE	|DEGREE	|	|1440	|N	|N	|0	|1	|	|1	|2	|0	|0	|FULL	|	|DEGREE	|N	|	|	|0	|0	|	|True	|False~
FLD	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|C_EMPE_DEGREE	|DI_EIN	|DI_EIN	|DI_EIN	|	|1440	|N	|N	|0	|1	|	|1	|12	|0	|0	|FULL	|	|DI_EIN	|N	|	|	|0	|0	|	|True	|False~
FLD	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|C_EMPE_DEGREE	|DI_SSN	|SSN	|DI_SSN	|	|1440	|N	|N	|0	|1	|	|1	|12	|7	|0	|FULL	|	|SSN	|N	|	|	|0	|0	|	|True	|False~
FLD	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|C_EMPE_DEGREE	|ID_DTE_TIM_STAMP	|ID_DTE_TIM_STAMP	|ID_DTE_TIM_STAMP	|	|1440	|N	|N	|0	|1	|	|1	|24	|0	|0	|FULL	|	|ID_DTE_TIM_STAMP	|N	|	|	|0	|0	|	|True	|False~
FLD	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|C_EMPE_DEGREE	|MAJOR	|DEGREE MAJOR	|MAJOR	|	|1440	|N	|N	|0	|1	|	|1	|4	|0	|0	|FULL	|	|DEGREE MAJOR	|N	|	|	|0	|0	|	|True	|False~
FLD	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|C_EMPE_DEGREE	|MINOR	|DEGREE MINOR	|MINOR	|	|1440	|N	|N	|0	|1	|	|1	|4	|0	|0	|FULL	|	|DEGREE MINOR	|N	|	|	|0	|0	|	|True	|False~
FLD	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|C_EMPE_DEGREE	|RFU_FILLER	|RFU_FILLER	|RFU_FILLER	|	|1440	|N	|N	|0	|1	|	|1	|4	|0	|0	|FULL	|	|RFU_FILLER	|N	|	|	|0	|0	|	|True	|False~
FLD	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|C_EMPE_DEGREE	|SI_D_SSNDEIN_D	|SI_D_SSNDEIN_D	|SI_D_SSNDEIN_D	|	|1440	|N	|N	|0	|1	|	|1	|26	|0	|0	|FULL	|	|SI_D_SSNDEIN_D	|N	|	|	|0	|0	|	|True	|False~
FLD	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|C_EMPE_DEGREE	|UNITS	|UNITS	|UNITS	|	|1440	|N	|N	|0	|1	|	|8	|8	|0	|0	|FULL	|	|UNITS	|N	|	|	|0	|0	|	|True	|False~
FLD	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|C_EMPE_EMERG	|COMMENT	|EMPE EMERG COMMENT	|COMMENT6	|	|1440	|N	|N	|0	|1	|	|1	|60	|0	|0	|Full	|	|EMPE EMERG COMMENT	|N	|	|	|0	|0	|	|True	|False~
FLD	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|C_EMPE_EMERG	|CONT_NAME	|CONTACT NAME	|CONT_NAME	|	|1440	|N	|N	|0	|1	|	|1	|30	|0	|0	|Full	|	|CONTACT NAME	|N	|	|	|0	|0	|	|True	|False~
FLD	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|C_EMPE_EMERG	|DI_EIN	|DI_EIN	|DI_EIN11	|	|1440	|N	|N	|0	|1	|	|1	|12	|0	|0	|Full	|	|DI_EIN	|N	|	|	|0	|0	|	|True	|False~
FLD	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|C_EMPE_EMERG	|DI_SSN	|DI_SSN	|DI_SSN4	|	|1440	|N	|N	|0	|1	|	|1	|12	|0	|0	|Full	|	|DI_SSN	|N	|	|	|0	|0	|	|True	|False~
FLD	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|C_EMPE_EMERG	|DOCTOR	|DOCTOR	|DOCTOR	|	|1440	|N	|N	|0	|1	|	|1	|30	|0	|0	|Full	|	|DOCTOR	|N	|	|	|0	|0	|	|True	|False~
FLD	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|C_EMPE_EMERG	|HOSPITAL_CODE	|PREFERRED HOSPITAL CODE	|HOSPITAL_CODE	|	|1440	|N	|N	|0	|1	|	|1	|4	|0	|0	|Full	|	|PREFERRED HOSPITAL CODE	|N	|	|	|0	|0	|	|True	|False~
FLD	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|C_EMPE_EMERG	|ID_DTE_TIM_STAMP	|EMPE EMERG ID_DTE_TIM_STAMP	|ID_DTE_TIM_STAMP	|	|1440	|N	|N	|0	|1	|	|1	|24	|0	|0	|Full	|	|EMPE EMERG ID_DTE_TIM_STAMP	|N	|	|	|0	|0	|	|True	|False~
FLD	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|C_EMPE_EMERG	|INSUR_CODE	|INSURANCE CARRIER CODE	|INSUR_CODE	|	|1440	|N	|N	|0	|1	|	|1	|4	|0	|0	|Full	|	|INSURANCE CARRIER CODE	|N	|	|	|0	|0	|	|True	|False~
FLD	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|C_EMPE_EMERG	|MEDICAL_CODE_1	|MEDICAL INFO CODE1	|MEDICAL_CODE_1	|	|1440	|N	|N	|0	|1	|	|1	|4	|0	|0	|Full	|	|MEDICAL INFO CODE1	|N	|	|	|0	|0	|	|True	|False~
FLD	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|C_EMPE_EMERG	|MEDICAL_CODE_2	|MEDICAL INFO CODE2	|MEDICAL_CODE_2	|	|1440	|N	|N	|0	|1	|	|1	|4	|0	|0	|Full	|	|MEDICAL INFO CODE2	|N	|	|	|0	|0	|	|True	|False~
FLD	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|C_EMPE_EMERG	|MEDICAL_CODE_3	|MEDICAL INFO CODE3	|MEDICAL_CODE_3	|	|1440	|N	|N	|0	|1	|	|1	|4	|0	|0	|Full	|	|MEDICAL INFO CODE3	|N	|	|	|0	|0	|	|True	|False~
FLD	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|C_EMPE_EMERG	|MEDICAL_CODE_4	|MEDICAL INFO CODE4	|MEDICAL_CODE_4	|	|1440	|N	|N	|0	|1	|	|1	|4	|0	|0	|Full	|	|MEDICAL INFO CODE4	|N	|	|	|0	|0	|	|True	|False~
FLD	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|C_EMPE_EMERG	|MEDICAL_CODE_5	|MEDICAL INFO CODE5	|MEDICAL_CODE_5	|	|1440	|N	|N	|0	|1	|	|1	|4	|0	|0	|Full	|	|MEDICAL INFO CODE5	|N	|	|	|0	|0	|	|True	|False~
FLD	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|C_EMPE_EMERG	|MISC1	|MEDICATION	|MISC1	|	|1440	|N	|N	|0	|1	|	|1	|20	|0	|0	|Full	|	|MEDICATION	|N	|	|	|0	|0	|	|True	|False~
FLD	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|C_EMPE_EMERG	|PHONE_CAR	|CELL PHONE	|PHONE_CAR	|	|1440	|N	|N	|0	|1	|	|1	|16	|10	|0	|Full	|	|CELL PHONE	|N	|	|	|0	|0	|	|True	|False~
FLD	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|C_EMPE_EMERG	|PHONE_FAX	|PHONE_FAX	|PHONE_FAX	|	|1440	|N	|N	|0	|1	|	|1	|16	|10	|0	|Full	|	|PHONE_FAX	|N	|	|	|0	|0	|	|True	|False~
FLD	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|C_EMPE_EMERG	|PHONE_HOME	|CONTACT HOME PHONE	|PHONE_HOME2	|	|1440	|N	|N	|0	|1	|	|1	|16	|10	|0	|Full	|	|CONTACT HOME PHONE	|N	|	|	|0	|0	|	|True	|False~
FLD	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|C_EMPE_EMERG	|PHONE_MESS	|MESSAGE PHONE	|PHONE_MESS1	|	|1440	|N	|N	|0	|1	|	|1	|16	|10	|0	|Full	|	|MESSAGE PHONE	|N	|	|	|0	|0	|	|True	|False~
FLD	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|C_EMPE_EMERG	|PHONE_WORK	|CONTACT WORK PHONE	|PHONE_WORK2	|	|1440	|N	|N	|0	|1	|	|1	|16	|10	|0	|Full	|	|CONTACT WORK PHONE	|N	|	|	|0	|0	|	|True	|False~
FLD	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|C_EMPE_EMERG	|PHYSICAL_DATE	|LAST PHYSICAL	|PHYSICAL_DATE	|	|1440	|N	|N	|0	|1	|	|2	|8	|8	|0	|Full	|	|LAST PHYSICAL	|N	|	|	|0	|0	|	|True	|False~
FLD	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|C_EMPE_EMERG	|RELATION	|CONTACT RELATIONSHIP	|RELATION	|	|1440	|N	|N	|0	|1	|	|1	|30	|0	|0	|Full	|	|CONTACT RELATIONSHIP	|N	|	|	|0	|0	|	|True	|False~
FLD	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|C_EMPE_EMERG	|RFU_FILLER	|RFU_FILLER	|RFU_FILLER	|	|1440	|N	|N	|0	|1	|	|1	|4	|0	|0	|Full	|	|RFU_FILLER	|N	|	|	|0	|0	|	|True	|False~
FLD	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|C_EMPE_EMERG	|SI_D_SSNDEIN	|SI_D_SSNDEIN	|SI_D_SSNDEIN	|	|1440	|N	|N	|0	|1	|	|1	|24	|0	|0	|Full	|	|SI_D_SSNDEIN	|N	|	|	|0	|0	|	|True	|False~
FLD	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|C_EMPE_EMERG	|SPOUSE_NAME	|SPOUSE NAME	|SPOUSE_NAME	|	|1440	|N	|N	|0	|1	|	|1	|30	|0	|0	|Full	|	|SPOUSE NAME	|N	|	|	|0	|0	|	|True	|False~
FLD	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|C_EMPE_EMERG	|SPOUSE_SSN	|SPOUSE SSN	|SPOUSE_SSN	|	|1440	|N	|N	|0	|1	|	|1	|10	|7	|0	|Full	|	|SPOUSE SSN	|N	|	|	|0	|0	|	|True	|False~
FLD	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|C_EMPE_INSERVICE	|CODE	|CODE	|CODE	|	|1440	|N	|N	|0	|1	|	|1	|6	|0	|0	|FULL	|	|CODE	|N	|	|	|0	|0	|	|True	|False~
FLD	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|C_EMPE_INSERVICE	|COMPENS_CODE	|COMPENSATION CODE	|COMPENS_CODE	|	|1440	|N	|N	|0	|1	|	|1	|8	|0	|0	|FULL	|	|COMPENSATION CODE	|N	|	|	|0	|0	|	|True	|False~
FLD	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|C_EMPE_INSERVICE	|DI_EIN	|DI_EIN	|DI_EIN	|	|1440	|N	|N	|0	|1	|	|1	|12	|0	|0	|FULL	|	|DI_EIN	|N	|	|	|0	|0	|	|True	|False~
FLD	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|C_EMPE_INSERVICE	|DI_SSN	|DI_SSN	|DI_SSN	|	|1440	|N	|N	|0	|1	|	|1	|12	|0	|0	|FULL	|	|DI_SSN	|N	|	|	|0	|0	|	|True	|False~
FLD	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|C_EMPE_INSERVICE	|END_DATE	|END DATE	|END_DATE	|	|1440	|N	|N	|0	|1	|	|2	|16	|0	|0	|FULL	|	|END DATE	|N	|	|	|0	|0	|	|True	|False~
FLD	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|C_EMPE_INSERVICE	|HOURS_INST	|HOURS	|HOURS_INST	|	|1440	|N	|N	|0	|1	|	|8	|8	|0	|0	|FULL	|	|HOURS	|N	|	|	|0	|0	|	|True	|False~
FLD	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|C_EMPE_INSERVICE	|ID_DTE_TIM_STAMP	|ID_DTE_TIM_STAMP	|ID_DTE_TIM_STAMP	|	|1440	|N	|N	|0	|1	|	|1	|24	|0	|0	|FULL	|	|ID_DTE_TIM_STAMP	|N	|	|	|0	|0	|	|True	|False~
FLD	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|C_EMPE_INSERVICE	|RFU_FILLER	|RFU_FILLER	|RFU_FILLER	|	|1440	|N	|N	|0	|1	|	|1	|4	|0	|0	|FULL	|	|RFU_FILLER	|N	|	|	|0	|0	|	|True	|False~
FLD	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|C_EMPE_INSERVICE	|SI_D_SSNDEIN_CC	|SI_D_SSNDEIN_CC	|SI_D_SSNDEIN_CC	|	|1440	|N	|N	|0	|1	|	|1	|32	|0	|0	|FULL	|	|SI_D_SSNDEIN_CC	|N	|	|	|0	|0	|	|True	|False~
FLD	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|C_EMPE_INSERVICE	|START_DATE	|START DATE	|START_DATE	|	|1440	|N	|N	|0	|1	|	|2	|16	|0	|0	|FULL	|	|START DATE	|N	|	|	|0	|0	|	|True	|False~
FLD	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|C_EMPE_INSERVICE	|SUBJECT	|SUBJECT	|SUBJECT	|	|1440	|N	|N	|0	|1	|	|1	|4	|0	|0	|FULL	|	|SUBJECT	|N	|	|	|0	|0	|	|True	|False~
FLD	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|C_EMPE_SKILLS	|CERT_NBR	|CERTIFICATE #	|CERT_NBR	|	|1440	|N	|N	|0	|1	|	|1	|10	|0	|0	|FULL	|	|CERTIFICATE #	|N	|	|	|0	|0	|	|True	|False~
FLD	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|C_EMPE_SKILLS	|DATE_AWARD	|AWARDED	|DATE_AWARD	|	|1440	|N	|N	|0	|1	|	|2	|16	|0	|0	|FULL	|	|AWARDED	|N	|	|	|0	|0	|	|True	|False~
FLD	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|C_EMPE_SKILLS	|DATE_EXPIRE	|EXPIRES	|DATE_EXPIRE	|	|1440	|N	|N	|0	|1	|	|2	|16	|0	|0	|FULL	|	|EXPIRES	|N	|	|	|0	|0	|	|True	|False~
FLD	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|C_EMPE_SKILLS	|DI_EIN	|DI_EIN	|DI_EIN2	|	|1440	|N	|N	|0	|1	|	|1	|12	|0	|0	|FULL	|	|DI_EIN	|N	|	|	|0	|0	|	|True	|False~
FLD	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|C_EMPE_SKILLS	|DI_SSN	|DI_SSN	|DI_SSN6	|	|1440	|N	|N	|0	|1	|	|1	|12	|0	|0	|FULL	|	|DI_SSN	|N	|	|	|0	|0	|	|True	|False~
FLD	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|C_EMPE_SKILLS	|ID_DTE_TIM_STAMP	|EMPE SKILLS ID_DTE_TIM_STAMP	|ID_DTE_TIM_STAMP6	|	|1440	|N	|N	|0	|1	|	|1	|24	|0	|0	|FULL	|	|EMPE SKILLS ID_DTE_TIM_STAMP	|N	|	|	|0	|0	|	|True	|False~
FLD	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|C_EMPE_SKILLS	|RFU_FILLER	|RFU_FILLER	|RFU_FILLER	|	|1440	|N	|N	|0	|1	|	|1	|4	|0	|0	|FULL	|	|RFU_FILLER	|N	|	|	|0	|0	|	|True	|False~
FLD	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|C_EMPE_SKILLS	|SI_D_SSNDEIN_K	|EMPE SKILS SI_D_SSNDEIN_K	|SI_D_SSNDEIN_K	|	|1440	|N	|N	|0	|1	|	|1	|28	|0	|0	|FULL	|	|EMPE SKILS SI_D_SSNDEIN_K	|N	|	|	|0	|0	|	|True	|False~
FLD	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|C_EMPE_SKILLS	|SKILLS_CODE	|SKILL CODE	|SKILLS_CODE	|	|1440	|N	|N	|0	|1	|	|1	|4	|0	|0	|FULL	|	|SKILL CODE	|N	|	|	|0	|0	|	|True	|False~
FLD	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|C_EMPE_SKILLS	|TYPE	|CERTIFICATE TYPE	|TYPE2	|	|1440	|N	|N	|0	|1	|	|1	|2	|0	|0	|FULL	|	|CERTIFICATE TYPE	|N	|	|	|0	|0	|	|True	|False~
FLD	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|C_EMPE_SUBJECT	|CERT_LEVEL	|CERT_LEVEL	|CERT_LEVEL	|	|1440	|N	|N	|0	|1	|	|1	|2	|0	|0	|FULL	|	|CERT_LEVEL	|N	|	|	|0	|0	|	|True	|False~
FLD	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|C_EMPE_SUBJECT	|CREDENTIAL	|CREDENTIAL	|CREDENTIAL	|	|1440	|N	|N	|0	|1	|	|1	|8	|0	|0	|FULL	|	|CREDENTIAL	|N	|	|	|0	|0	|	|True	|False~
FLD	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|C_EMPE_SUBJECT	|DI_EIN	|DI_EIN	|DI_EIN	|	|1440	|N	|N	|0	|1	|	|1	|12	|0	|0	|FULL	|	|DI_EIN	|N	|	|	|0	|0	|	|True	|False~
FLD	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|C_EMPE_SUBJECT	|DI_SSN	|DI_SSN	|DI_SSN	|	|1440	|N	|N	|0	|1	|	|1	|12	|0	|0	|FULL	|	|DI_SSN	|N	|	|	|0	|0	|	|True	|False~
FLD	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|C_EMPE_SUBJECT	|ID_DTE_TIM_STAMP	|ID_DTE_TIM_STAMP	|ID_DTE_TIM_STAMP	|	|1440	|N	|N	|0	|1	|	|1	|24	|0	|0	|FULL	|	|ID_DTE_TIM_STAMP	|N	|	|	|0	|0	|	|True	|False~
FLD	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|C_EMPE_SUBJECT	|RFU_FILLER	|RFU_FILLER	|RFU_FILLER	|	|1440	|N	|N	|0	|1	|	|1	|4	|0	|0	|FULL	|	|RFU_FILLER	|N	|	|	|0	|0	|	|True	|False~
FLD	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|C_EMPE_SUBJECT	|SI_D_SSNDEIN_CS	|SI_D_SSNDEIN_CS	|SI_D_SSNDEIN_CS	|	|1440	|N	|N	|0	|1	|	|1	|36	|0	|0	|FULL	|	|SI_D_SSNDEIN_CS	|N	|	|	|0	|0	|	|True	|False~
FLD	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|C_EMPE_SUBJECT	|SUBJECT	|SUBJECT	|SUBJECT	|	|1440	|N	|N	|0	|1	|	|1	|4	|0	|0	|FULL	|	|SUBJECT	|N	|	|	|0	|0	|	|True	|False~
FLD	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|C_EMPE_TABLE	|DESC	|DESC	|DESC	|	|1440	|N	|N	|0	|1	|	|1	|30	|0	|0	|Full	|	|DESC	|N	|	|	|0	|0	|	|True	|False~
FLD	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|C_EMPE_TABLE	|DI_EIN	|DI_EIN	|DI_EIN	|	|1440	|N	|N	|0	|1	|	|1	|12	|0	|0	|Full	|	|DI_EIN	|N	|	|	|0	|0	|	|True	|False~
FLD	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|C_EMPE_TABLE	|DI_SSN	|DI_SSN	|DI_SSN	|	|1440	|N	|N	|0	|1	|	|1	|12	|0	|0	|Full	|	|DI_SSN	|N	|	|	|0	|0	|	|True	|False~
FLD	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|C_EMPE_TABLE	|ID_DTE_TIM_STAMP	|ID_DTE_TIM_STAMP	|ID_DTE_TIM_STAMP	|	|1440	|N	|N	|0	|1	|	|1	|24	|0	|0	|Full	|	|ID_DTE_TIM_STAMP	|N	|	|	|0	|0	|	|True	|False~
FLD	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|C_EMPE_TABLE	|RFU_FILLER	|RFU_FILLER	|RFU_FILLER	|	|1440	|N	|N	|0	|1	|	|1	|4	|0	|0	|Full	|	|RFU_FILLER	|N	|	|	|0	|0	|	|True	|False~
FLD	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|C_EMPE_TABLE	|SI_DI_SSNDEIN_TC	|SI_DI_SSNDEIN_TC	|SI_DI_SSNDEIN_TC	|	|1440	|N	|N	|0	|1	|	|1	|38	|0	|0	|Full	|	|SI_DI_SSNDEIN_TC	|N	|	|	|0	|0	|	|True	|False~
FLD	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|C_EMPE_TABLE	|SI_EVDATE	|SI_EVDATE	|SI_EVDATE	|	|1440	|N	|N	|0	|1	|	|1	|8	|0	|0	|Full	|	|SI_EVDATE	|N	|	|	|0	|0	|	|True	|False~
FLD	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|C_EMPE_TABLE	|TBL_CODE	|TBL_CODE	|TBL_CODE	|	|1440	|N	|N	|0	|1	|	|1	|10	|0	|0	|Full	|	|TBL_CODE	|N	|	|	|0	|0	|	|True	|False~
FLD	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|C_EMPE_TABLE	|TBL_TYPE	|TBL_TYPE	|TBL_TYPE	|	|1440	|N	|N	|0	|1	|	|1	|4	|0	|0	|Full	|	|TBL_TYPE	|N	|	|	|0	|0	|	|True	|False~
FLD	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|C_EMPE_TAXRET	|AMOUNT1	|ADDITIONAL TAX1	|TAX1_AMOUNT1	|	|0	|N	|N	|0	|1	|	|8	|8	|0	|0	|Full	|	|ADDITIONAL TAX1	|N	|	|	|0	|0	|	|True	|False~
FLD	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|C_EMPE_TAXRET	|AMOUNT2	|ADDITIONAL TAX2	|AMOUNT2	|	|0	|N	|N	|0	|1	|	|8	|8	|0	|0	|Full	|	|ADDITIONAL TAX2	|N	|	|	|0	|0	|	|True	|False~
FLD	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|C_EMPE_TAXRET	|AMOUNT3	|ADDITIONAL TAX3	|ADD_AMOUNT3	|	|0	|N	|N	|0	|1	|	|8	|8	|0	|0	|Full	|	|ADDITIONAL TAX3	|N	|	|	|0	|0	|	|True	|False~
FLD	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|C_EMPE_TAXRET	|AMOUNT4	|ADDITIONAL TAX4	|ADD_AMOUNT4	|	|0	|N	|N	|0	|1	|	|8	|8	|0	|0	|Full	|	|ADDITIONAL TAX4	|N	|	|	|0	|0	|	|True	|False~
FLD	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|C_EMPE_TAXRET	|AMOUNT5	|ADDITIONAL TAX5	|AMOUNT5	|	|0	|N	|N	|0	|1	|	|8	|8	|0	|0	|Full	|	|ADDITIONAL TAX5	|N	|	|	|0	|0	|	|True	|False~
FLD	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|C_EMPE_TAXRET	|AMOUNT6	|ADDITIONAL TAX6	|AMOUNT6	|	|0	|N	|N	|0	|1	|	|8	|8	|0	|0	|Full	|	|ADDITIONAL TAX6	|N	|	|	|0	|0	|	|True	|False~
FLD	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|C_EMPE_TAXRET	|AMOUNT7	|ADDITIONAL TAX7	|AMOUNT7	|	|0	|N	|N	|0	|1	|	|8	|8	|0	|0	|Full	|	|ADDITIONAL TAX7	|N	|	|	|0	|0	|	|True	|False~
FLD	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|C_EMPE_TAXRET	|AMOUNT8	|ADDITIONAL TAX8	|AMOUNT8	|	|0	|N	|N	|0	|1	|	|8	|8	|0	|0	|Full	|	|ADDITIONAL TAX8	|N	|	|	|0	|0	|	|True	|False~
FLD	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|C_EMPE_TAXRET	|AMOUNT9	|ADDITIONAL TAX9	|AMOUNT9	|	|0	|N	|N	|0	|1	|	|8	|8	|0	|0	|Full	|	|ADDITIONAL TAX9	|N	|	|	|0	|0	|	|True	|False~
FLD	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|C_EMPE_TAXRET	|BEN_CYCLE_FQ	|PAY-BENEFIT CYCLE FQ	|BEN_CYCLE_FQ	|	|1440	|Y	|N	|0	|1	|	|1	|2	|0	|0	|Full	|	|PAY-BENEFIT CYCLE FQ	|N	|	|	|0	|0	|	|True	|False~
FLD	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|C_EMPE_TAXRET	|COMMENT	|COMMENT-TAX/RET	|COMMENT13	|	|1440	|Y	|N	|0	|1	|	|1	|60	|0	|0	|Full	|	|COMMENT-TAX/RET	|N	|	|	|0	|0	|	|True	|False~
FLD	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|C_EMPE_TAXRET	|DI_EIN	|DI_EIN	|DI_EIN1	|	|0	|N	|N	|0	|1	|	|1	|12	|0	|0	|Full	|	|DI_EIN	|N	|	|	|0	|0	|	|True	|False~
FLD	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|C_EMPE_TAXRET	|DI_SSN	|DI_SSN	|DI_SSN1	|	|0	|N	|N	|0	|1	|	|1	|12	|0	|0	|Full	|	|DI_SSN	|N	|	|	|0	|0	|	|True	|False~
FLD	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|C_EMPE_TAXRET	|DNP_CYCLE_TYPE_1	|PAY-DNP PAYOUT CYCLE1	|DNP_CYCLE_TYPE_1	|	|1440	|Y	|N	|0	|1	|	|1	|6	|0	|0	|Full	|	|PAY-DNP PAYOUT CYCLE1	|N	|	|	|0	|0	|	|True	|False~
FLD	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|C_EMPE_TAXRET	|DNP_CYCLE_TYPE_2	|PAY-DNP PAYOUT CYCLE2	|DNP_CYCLE_TYPE_2	|	|1440	|Y	|N	|0	|1	|	|1	|6	|0	|0	|Full	|	|PAY-DNP PAYOUT CYCLE2	|N	|	|	|0	|0	|	|True	|False~
FLD	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|C_EMPE_TAXRET	|DNP_CYCLE_TYPE_3	|PAY-DNP PAYOUT CYCLE3	|DNP_CYCLE_TYPE_3	|	|1440	|Y	|N	|0	|1	|	|1	|6	|0	|0	|Full	|	|PAY-DNP PAYOUT CYCLE3	|N	|	|	|0	|0	|	|True	|False~
FLD	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|C_EMPE_TAXRET	|DNP_EIC	|EIC	|DNP_EIC	|	|0	|N	|N	|0	|1	|	|1	|2	|0	|0	|Full	|	|EIC	|N	|	|	|0	|0	|	|True	|False~
FLD	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|C_EMPE_TAXRET	|EARN_CYCLE_FQ	|PAY-EARN CYCLE FQ	|EARN_CYCLE_FQ	|	|1440	|Y	|N	|0	|1	|	|1	|2	|0	|0	|Full	|	|PAY-EARN CYCLE FQ	|N	|	|	|0	|0	|	|True	|False~
FLD	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|C_EMPE_TAXRET	|EFF_DATE	|EFF DATE-TAX/RET	|EFF_DATE4	|	|1440	|Y	|N	|0	|1	|	|2	|8	|0	|0	|Full	|	|EFF DATE-TAX/RET	|N	|	|	|0	|0	|	|True	|False~
FLD	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|C_EMPE_TAXRET	|END_EFF_DATE	|TAXRET END EFF DATE	|END_EFF_DATE12	|	|1440	|N	|N	|0	|1	|	|2	|8	|0	|0	|Full	|	|TAXRET END EFF DATE	|N	|	|	|0	|0	|	|True	|False~
FLD	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|C_EMPE_TAXRET	|EXEMPTIONS_1	|EXEMPTIONS1	|EXEMPTIONS_1	|	|0	|N	|N	|0	|1	|	|1	|2	|0	|0	|Full	|	|EXEMPTIONS1	|N	|	|	|0	|0	|	|True	|False~
FLD	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|C_EMPE_TAXRET	|EXEMPTIONS_10	|EXEMPTIONS10	|EXEMPTIONS_10	|	|0	|N	|N	|0	|1	|	|1	|2	|0	|0	|Full	|	|EXEMPTIONS10	|N	|	|	|0	|0	|	|True	|False~
FLD	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|C_EMPE_TAXRET	|EXEMPTIONS_2	|EXEMPTIONS2	|EXEMPTIONS_2	|	|0	|N	|N	|0	|1	|	|1	|2	|0	|0	|Full	|	|EXEMPTIONS2	|N	|	|	|0	|0	|	|True	|False~
FLD	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|C_EMPE_TAXRET	|EXEMPTIONS_3	|EXEMPTIONS3	|EXEMPTIONS_3	|	|0	|N	|N	|0	|1	|	|1	|2	|0	|0	|Full	|	|EXEMPTIONS3	|N	|	|	|0	|0	|	|True	|False~
FLD	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|C_EMPE_TAXRET	|EXEMPTIONS_4	|EXEMPTIONS4	|EXEMPTIONS_4	|	|0	|N	|N	|0	|1	|	|1	|2	|0	|0	|Full	|	|EXEMPTIONS4	|N	|	|	|0	|0	|	|True	|False~
FLD	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|C_EMPE_TAXRET	|EXEMPTIONS_5	|EXEMPTIONS5	|EXEMPTIONS_5	|	|0	|N	|N	|0	|1	|	|1	|2	|0	|0	|Full	|	|EXEMPTIONS5	|N	|	|	|0	|0	|	|True	|False~
FLD	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|C_EMPE_TAXRET	|EXEMPTIONS_6	|EXEMPTIONS6	|EXEMPTIONS_6	|	|0	|N	|N	|0	|1	|	|1	|2	|0	|0	|Full	|	|EXEMPTIONS6	|N	|	|	|0	|0	|	|True	|False~
FLD	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|C_EMPE_TAXRET	|EXEMPTIONS_7	|EXEMPTIONS7	|EXEMPTIONS_7	|	|0	|N	|N	|0	|1	|	|1	|2	|0	|0	|Full	|	|EXEMPTIONS7	|N	|	|	|0	|0	|	|True	|False~
FLD	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|C_EMPE_TAXRET	|EXEMPTIONS_8	|EXEMPTIONS8	|EXEMPTIONS_8	|	|0	|N	|N	|0	|1	|	|1	|2	|0	|0	|Full	|	|EXEMPTIONS8	|N	|	|	|0	|0	|	|True	|False~
FLD	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|C_EMPE_TAXRET	|EXEMPTIONS_9	|EXEMPTIONS9	|EXEMPTIONS_9	|	|0	|N	|N	|0	|1	|	|1	|2	|0	|0	|Full	|	|EXEMPTIONS9	|N	|	|	|0	|0	|	|True	|False~
FLD	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|C_EMPE_TAXRET	|FICA_MED	|FICA-MED	|FICA_MED1	|	|0	|N	|N	|0	|1	|	|1	|2	|0	|0	|Full	|	|FICA-MED	|N	|	|	|0	|0	|	|True	|False~
FLD	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|C_EMPE_TAXRET	|FILING_STATUS_1	|FILING STATUS1	|FILING_STATUS_1	|	|0	|N	|N	|0	|1	|	|1	|1	|0	|0	|Full	|	|FILING STATUS1	|N	|	|	|0	|0	|	|True	|False~
FLD	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|C_EMPE_TAXRET	|FILING_STATUS_10	|FILING STATUS10	|FILING_STATUS_10	|	|0	|N	|N	|0	|1	|	|1	|1	|0	|0	|Full	|	|FILING STATUS10	|N	|	|	|0	|0	|	|True	|False~
FLD	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|C_EMPE_TAXRET	|FILING_STATUS_2	|FILING STATUS2	|FILING_STATUS_2	|	|0	|N	|N	|0	|1	|	|1	|1	|0	|0	|Full	|	|FILING STATUS2	|N	|	|	|0	|0	|	|True	|False~
FLD	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|C_EMPE_TAXRET	|FILING_STATUS_3	|FILING STATUS3	|FILING_STATUS_3	|	|0	|N	|N	|0	|1	|	|1	|1	|0	|0	|Full	|	|FILING STATUS3	|N	|	|	|0	|0	|	|True	|False~
FLD	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|C_EMPE_TAXRET	|FILING_STATUS_4	|FILING STATUS4	|FILING_STATUS_4	|	|0	|N	|N	|0	|1	|	|1	|1	|0	|0	|Full	|	|FILING STATUS4	|N	|	|	|0	|0	|	|True	|False~
FLD	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|C_EMPE_TAXRET	|FILING_STATUS_5	|FILING STATUS5	|FILING_STATUS_5	|	|0	|N	|N	|0	|1	|	|1	|1	|0	|0	|Full	|	|FILING STATUS5	|N	|	|	|0	|0	|	|True	|False~
FLD	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|C_EMPE_TAXRET	|FILING_STATUS_6	|FILING STATUS6	|FILING_STATUS_6	|	|0	|N	|N	|0	|1	|	|1	|1	|0	|0	|Full	|	|FILING STATUS6	|N	|	|	|0	|0	|	|True	|False~
FLD	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|C_EMPE_TAXRET	|FILING_STATUS_7	|FILING STATUS7	|FILING_STATUS_7	|	|0	|N	|N	|0	|1	|	|1	|1	|0	|0	|Full	|	|FILING STATUS7	|N	|	|	|0	|0	|	|True	|False~
FLD	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|C_EMPE_TAXRET	|FILING_STATUS_8	|FILING STATUS8	|FILING_STATUS_8	|	|0	|N	|N	|0	|1	|	|1	|1	|0	|0	|Full	|	|FILING STATUS8	|N	|	|	|0	|0	|	|True	|False~
FLD	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|C_EMPE_TAXRET	|FILING_STATUS_9	|FILING STATUS9	|FILING_STATUS_9	|	|0	|N	|N	|0	|1	|	|1	|1	|0	|0	|Full	|	|FILING STATUS9	|N	|	|	|0	|0	|	|True	|False~
FLD	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|C_EMPE_TAXRET	|GROUP_RULE	|GROUP RULE-TAX/RET	|GROUP_RULE1	|	|1440	|Y	|N	|0	|3	|GroupRule	|1	|2	|0	|0	|Full	|	|GROUP RULE-TAX/RET	|N	|	|	|0	|0	|	|True	|False~
FLD	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|C_EMPE_TAXRET	|ID_DTE_TIM_STAMP	|TAXRET ID_DTE_TIM_STAMP	|ID_DTE_TIM_STAMP9	|	|1440	|N	|N	|0	|1	|	|1	|24	|0	|0	|Full	|	|TAXRET ID_DTE_TIM_STAMP	|N	|	|	|0	|0	|	|True	|False~
FLD	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|C_EMPE_TAXRET	|LAST_DATE_TO_PAY	|LAST DATE TO PAY	|LAST_DATE_TO_PAY	|	|1440	|Y	|N	|0	|1	|	|2	|8	|8	|0	|Full	|	|LAST DATE TO PAY	|N	|	|	|	|0	|	|True	|False~
FLD	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|C_EMPE_TAXRET	|LAST_ER_HW_DATE	|LAST ER HW DATE	|LAST_ER_HW_DATE	|	|1440	|Y	|N	|0	|1	|	|2	|8	|8	|0	|Full	|	|LAST ER HW DATE	|N	|	|	|	|0	|	|True	|False~
FLD	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|C_EMPE_TAXRET	|PAY_CALENDAR	|PAY CALENDAR	|PAY_CALENDAR2	|	|1440	|Y	|N	|0	|1	|	|1	|6	|0	|0	|Full	|	|PAY CALENDAR	|N	|	|	|0	|0	|	|True	|False~
FLD	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|C_EMPE_TAXRET	|PAY_DNP	|PAY-DNP	|PAY_DNP	|	|1440	|Y	|N	|0	|1	|	|1	|1	|0	|0	|Full	|	|PAY-DNP	|N	|	|	|0	|0	|	|True	|False~
FLD	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|C_EMPE_TAXRET	|PAY_LOCATION	|PAY LOCATION CODE	|PAY_LOCATION	|	|1440	|Y	|N	|0	|3	|ZLOC	|1	|4	|0	|0	|Full	|	|PAY LOCATION CODE	|N	|	|	|0	|0	|	|True	|False~
FLD	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|C_EMPE_TAXRET	|PAYCAL_ER_HW	|PAYCAL ER HW	|PAYCAL_ER_HW	|	|1440	|Y	|N	|0	|1	|	|1	|6	|0	|0	|Full	|	|PAYCAL ER HW	|N	|	|	|	|0	|	|True	|False~
FLD	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|C_EMPE_TAXRET	|PAYCAL_LDP	|PAYCAL LDP	|PAYCAL_LDP	|	|1440	|Y	|N	|0	|1	|	|1	|6	|0	|0	|Full	|	|PAYCAL LDP	|N	|	|	|	|0	|	|True	|False~
FLD	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|C_EMPE_TAXRET	|PERCENT1	|PERCENT1	|PERCENT1	|	|0	|N	|N	|0	|1	|	|8	|8	|0	|0	|Full	|	|PERCENT1	|N	|	|	|0	|0	|	|True	|False~
FLD	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|C_EMPE_TAXRET	|PERCENT2	|PERCENT2	|PERCENT2	|	|0	|N	|N	|0	|1	|	|8	|8	|0	|0	|Full	|	|PERCENT2	|N	|	|	|0	|0	|	|True	|False~
FLD	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|C_EMPE_TAXRET	|PERCENT3	|PERCENT3	|PERCENT3	|	|0	|N	|N	|0	|1	|	|8	|8	|0	|0	|Full	|	|PERCENT3	|N	|	|	|0	|0	|	|True	|False~
FLD	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|C_EMPE_TAXRET	|PERCENT4	|PERCENT4	|PERCENT4	|	|0	|N	|N	|0	|1	|	|8	|8	|0	|0	|Full	|	|PERCENT4	|N	|	|	|0	|0	|	|True	|False~
FLD	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|C_EMPE_TAXRET	|PERCENT5	|PERCENT5	|PERCENT5	|	|0	|N	|N	|0	|1	|	|8	|8	|0	|0	|Full	|	|PERCENT5	|N	|	|	|0	|0	|	|True	|False~
FLD	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|C_EMPE_TAXRET	|PERCENT6	|PERCENT6	|PERCENT6	|	|0	|N	|N	|0	|1	|	|8	|8	|0	|0	|Full	|	|PERCENT6	|N	|	|	|0	|0	|	|True	|False~
FLD	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|C_EMPE_TAXRET	|PERCENT7	|PERCENT7	|PERCENT7	|	|0	|N	|N	|0	|1	|	|8	|8	|0	|0	|Full	|	|PERCENT7	|N	|	|	|0	|0	|	|True	|False~
FLD	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|C_EMPE_TAXRET	|PERCENT8	|PERCENT8	|PERCENT8	|	|0	|N	|N	|0	|1	|	|8	|8	|0	|0	|Full	|	|PERCENT8	|N	|	|	|0	|0	|	|True	|False~
FLD	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|C_EMPE_TAXRET	|PERCENT9	|PERCENT9	|PERCENT9	|	|0	|N	|N	|0	|1	|	|8	|8	|0	|0	|Full	|	|PERCENT9	|N	|	|	|0	|0	|	|True	|False~
FLD	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|C_EMPE_TAXRET	|RET_CODE_SYS1	|RET CODE1	|RET_CODE_SYS1	|	|0	|N	|N	|0	|1	|	|1	|14	|0	|0	|Full	|	|RET CODE1	|N	|	|	|0	|0	|	|True	|False~
FLD	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|C_EMPE_TAXRET	|RET_CODE_SYS2	|RET CODE2	|RET_CODE_SYS2	|	|0	|N	|N	|0	|1	|	|1	|14	|0	|0	|Full	|	|RET CODE2	|N	|	|	|0	|0	|	|True	|False~
FLD	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|C_EMPE_TAXRET	|RET_SYSTEM	|RET SYSTEM	|RET_SYSTEM	|	|0	|N	|N	|0	|1	|	|1	|2	|0	|0	|Full	|	|RET SYSTEM	|N	|	|	|0	|0	|	|True	|False~
FLD	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|C_EMPE_TAXRET	|RETIRE_CODE_1000	|RETIRE CODE-1000	|RETIRE_CODE_1000	|	|1440	|Y	|N	|0	|3	|RETC	|1	|2	|0	|0	|Full	|	|RETIRE CODE-1000	|N	|	|	|0	|0	|	|True	|False~
FLD	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|C_EMPE_TAXRET	|RETIRE_CODE_2000	|RETIRE CODE-2000	|RETIRE_CODE_2000	|	|1440	|Y	|N	|0	|3	|RETC	|1	|2	|0	|0	|Full	|	|RETIRE CODE-2000	|N	|	|	|0	|0	|	|True	|False~
FLD	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|C_EMPE_TAXRET	|RETIRE_DISPLAY_PAY_1000	|RETIRE DISPLAY PAY-1000	|RETIRE_DISPLAY_PAY_1000	|	|1440	|Y	|N	|0	|1	|	|1	|1	|0	|0	|Full	|	|RETIRE DISPLAY PAY-1000	|N	|	|	|0	|0	|	|True	|False~
FLD	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|C_EMPE_TAXRET	|RETIRE_DISPLAY_PAY_2000	|RETIRE DISPLAY PAY-2000	|RETIRE_DISPLAY_PAY_2000	|	|1440	|Y	|N	|0	|1	|	|1	|1	|0	|0	|Full	|	|RETIRE DISPLAY PAY-2000	|N	|	|	|0	|0	|	|True	|False~
FLD	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|C_EMPE_TAXRET	|RETIRE_OPTION_1000	|RETIRE OPTION-1000	|RETIRE_OPTION_1000	|	|1440	|Y	|N	|0	|3	|RETOPT	|1	|8	|0	|0	|Full	|	|RETIRE OPTION-1000	|N	|	|	|0	|0	|	|True	|False~
FLD	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|C_EMPE_TAXRET	|RETIRE_OPTION_2000	|RETIRE OPTION-2000	|RETIRE_OPTION_2000	|	|1440	|Y	|N	|0	|3	|RETOPT	|1	|8	|0	|0	|Full	|	|RETIRE OPTION-2000	|N	|	|	|0	|0	|	|True	|False~
FLD	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|C_EMPE_TAXRET	|SB_SDI	|SDI	|SB_SDI	|	|0	|N	|N	|0	|1	|	|1	|2	|0	|0	|Full	|	|SDI	|N	|	|	|0	|0	|	|True	|False~
FLD	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|C_EMPE_TAXRET	|TAX_AFIT	|TAX-AFIT	|TAX_AFIT	|	|1440	|Y	|N	|0	|1	|	|8	|8	|0	|0	|Full	|	|TAX-AFIT	|N	|	|	|0	|0	|	|True	|False~
FLD	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|C_EMPE_TAXRET	|TAX_ASIT	|TAX-ASIT	|TAX_ASIT	|	|1440	|Y	|N	|0	|1	|	|8	|8	|0	|0	|Full	|	|TAX-ASIT	|N	|	|	|0	|0	|	|True	|False~
FLD	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|C_EMPE_TAXRET	|TAX_EIC	|TAX-EIC	|TAX_EIC	|	|1440	|Y	|N	|0	|1	|	|1	|1	|0	|0	|Full	|	|TAX-EIC	|N	|	|	|0	|0	|	|True	|False~
FLD	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|C_EMPE_TAXRET	|TAX_FICA_MEDI_ADDL	|TAX-FICA/MEDI-ADDL	|TAX_FICA_MEDI_ADDL	|	|1440	|Y	|N	|0	|1	|	|1	|1	|0	|0	|Full	|	|TAX-FICA/MEDI-ADDL	|N	|	|	|0	|0	|	|True	|False~
FLD	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|C_EMPE_TAXRET	|TAX_FICA_MEDI_BASE	|TAX-FICA/MEDI-BASE	|TAX_FICA_MEDI_BASE	|	|1440	|Y	|N	|0	|1	|	|1	|1	|0	|0	|Full	|	|TAX-FICA/MEDI-BASE	|N	|	|	|0	|0	|	|True	|False~
FLD	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|C_EMPE_TAXRET	|TAX_FIT_W4	|TAX-FIT W4	|TAX_FIT_W4	|	|1440	|Y	|N	|0	|1	|	|1	|3	|0	|0	|Full	|	|TAX-FIT W4	|N	|	|	|0	|0	|	|True	|False~
FLD	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|C_EMPE_TAXRET	|TAX_SDI	|TAX-SDI	|TAX_SDI	|	|1440	|Y	|N	|0	|1	|	|1	|1	|0	|0	|Full	|	|TAX-SDI	|N	|	|	|0	|0	|	|True	|False~
FLD	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|C_EMPE_TAXRET	|TAX_SIT_W4	|TAX-SIT W4	|TAX_SIT_W4	|	|1440	|Y	|N	|0	|1	|	|1	|3	|0	|0	|Full	|	|TAX-SIT W4	|N	|	|	|0	|0	|	|True	|False~
FLD	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|C_EMPE_TAXRET	|TAX_SURVIVOR_BENEFIT	|TAX-SURVIVOR BENEFIT	|TAX_SURVIVOR_BENEFIT	|	|1440	|Y	|N	|0	|1	|	|1	|1	|0	|0	|Full	|	|TAX-SURVIVOR BENEFIT	|N	|	|	|0	|0	|	|True	|False~
FLD	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|C_EMPE_YRS_EXP	|DI_EIN	|DI_EIN	|DI_EIN	|	|1440	|N	|N	|0	|1	|	|1	|12	|0	|0	|FULL	|	|DI_EIN	|N	|	|	|0	|0	|	|True	|False~
FLD	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|C_EMPE_YRS_EXP	|DI_SSN	|DI_SSN	|DI_SSN	|	|1440	|N	|N	|0	|1	|	|1	|12	|0	|0	|FULL	|	|DI_SSN	|N	|	|	|0	|0	|	|True	|False~
FLD	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|C_EMPE_YRS_EXP	|ID_DTE_TIM_STAMP	|ID_DTE_TIM_STAMP	|ID_DTE_TIM_STAMP	|	|1440	|N	|N	|0	|1	|	|1	|24	|0	|0	|FULL	|	|ID_DTE_TIM_STAMP	|N	|	|	|0	|0	|	|True	|False~
FLD	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|C_EMPE_YRS_EXP	|RFU_FILLER	|RFU_FILLER	|RFU_FILLER	|	|1440	|N	|N	|0	|1	|	|1	|4	|0	|0	|FULL	|	|RFU_FILLER	|N	|	|	|0	|0	|	|True	|False~
FLD	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|C_EMPE_YRS_EXP	|SI_D_SSNDEIN	|SI_D_SSNDEIN	|SI_D_SSNDEIN	|	|1440	|N	|N	|0	|1	|	|1	|24	|0	|0	|FULL	|	|SI_D_SSNDEIN	|N	|	|	|0	|0	|	|True	|False~
FLD	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|C_EMPE_YRS_EXP	|UNITS_ADDL	|ADDITIONAL UNITS	|UNITS_ADDL	|	|1440	|N	|N	|0	|1	|	|8	|8	|0	|0	|FULL	|	|ADDITIONAL UNITS	|N	|	|	|0	|0	|	|True	|False~
FLD	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|C_EMPE_YRS_EXP	|UNITS_INSERVICE	|INSERVICE UNITS	|UNITS_INSERVICE	|	|1440	|N	|N	|0	|1	|	|8	|8	|0	|0	|FULL	|	|INSERVICE UNITS	|N	|	|	|0	|0	|	|True	|False~
FLD	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|C_EMPE_YRS_EXP	|YRS_DISTRICT	|YRS DISTRICT	|YRS_DISTRICT	|	|1440	|N	|N	|0	|1	|	|1	|2	|0	|0	|FULL	|	|YRS DISTRICT	|N	|	|	|0	|0	|	|True	|False~
FLD	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|C_EMPE_YRS_EXP	|YRS_IN_STATE	|YRS IN STATE	|YRS_IN_STATE	|	|1440	|N	|N	|0	|1	|	|1	|2	|0	|0	|FULL	|	|YRS IN STATE	|N	|	|	|0	|0	|	|True	|False~
FLD	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|C_EMPE_YRS_EXP	|YRS_OUT_STATE	|YRS OUT STATE	|YRS_OUT_STATE	|	|1440	|N	|N	|0	|1	|	|1	|2	|0	|0	|FULL	|	|YRS OUT STATE	|N	|	|	|0	|0	|	|True	|False~
FLD	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|C_GROUP_ORDER	|COMMENT	|COMMENT	|COMMENT10	|	|0	|N	|N	|0	|1	|	|1	|60	|0	|0	|Full	|	|COMMENT	|N	|	|	|0	|0	|	|True	|False~
FLD	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|C_GROUP_ORDER	|DESC	|GROUP ORDER RULE DESCRIPTION	|DESC_GROUP	|	|0	|N	|N	|0	|1	|	|1	|30	|0	|0	|Full	|	|GROUP ORDER RULE DESCRIPTION	|N	|	|	|0	|0	|	|True	|False~
FLD	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|C_GROUP_ORDER	|DI_GROUP_RULE	| GROUP ORDER RULE	|DI_GROUP_RULE	|	|0	|N	|N	|0	|1	|	|1	|4	|0	|0	|Full	|	| GROUP ORDER RULE	|N	|	|	|0	|0	|	|True	|False~
FLD	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|C_GROUP_ORDER	|GROUP_CALC_1	|GROUP CALC1	|GROUP_CALC_1	|	|0	|N	|N	|0	|1	|	|1	|4	|0	|0	|Full	|	|GROUP CALC1	|N	|	|	|0	|0	|	|True	|False~
FLD	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|C_GROUP_ORDER	|GROUP_CALC_10	|GROUP CALC10	|GROUP_CALC_10	|	|0	|N	|N	|0	|1	|	|1	|4	|0	|0	|Full	|	|GROUP CALC10	|N	|	|	|0	|0	|	|True	|False~
FLD	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|C_GROUP_ORDER	|GROUP_CALC_11	|GROUP CALC11	|GROUP_CALC_11	|	|0	|N	|N	|0	|1	|	|1	|4	|0	|0	|Full	|	|GROUP CALC11	|N	|	|	|0	|0	|	|True	|False~
FLD	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|C_GROUP_ORDER	|GROUP_CALC_12	|GROUP CALC12	|GROUP_CALC_12	|	|0	|N	|N	|0	|1	|	|1	|4	|0	|0	|Full	|	|GROUP CALC12	|N	|	|	|0	|0	|	|True	|False~
FLD	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|C_GROUP_ORDER	|GROUP_CALC_13	|GROUP CALC13	|GROUP_CALC_13	|	|0	|N	|N	|0	|1	|	|1	|4	|0	|0	|Full	|	|GROUP CALC13	|N	|	|	|0	|0	|	|True	|False~
FLD	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|C_GROUP_ORDER	|GROUP_CALC_14	|GROUP CALC14	|GROUP_CALC_14	|	|0	|N	|N	|0	|1	|	|1	|4	|0	|0	|Full	|	|GROUP CALC14	|N	|	|	|0	|0	|	|True	|False~
FLD	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|C_GROUP_ORDER	|GROUP_CALC_15	|GROUP CALC15	|GROUP_CALC_15	|	|0	|N	|N	|0	|1	|	|1	|4	|0	|0	|Full	|	|GROUP CALC15	|N	|	|	|0	|0	|	|True	|False~
FLD	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|C_GROUP_ORDER	|GROUP_CALC_16	|GROUP CALC16	|GROUP_CALC_16	|	|0	|N	|N	|0	|1	|	|1	|4	|0	|0	|Full	|	|GROUP CALC16	|N	|	|	|0	|0	|	|True	|False~
FLD	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|C_GROUP_ORDER	|GROUP_CALC_17	|GROUP CALC17	|GROUP_CALC_17	|	|0	|N	|N	|0	|1	|	|1	|4	|0	|0	|Full	|	|GROUP CALC17	|N	|	|	|0	|0	|	|True	|False~
FLD	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|C_GROUP_ORDER	|GROUP_CALC_18	|GROUP CALC18	|GROUP_CALC_18	|	|0	|N	|N	|0	|1	|	|1	|4	|0	|0	|Full	|	|GROUP CALC18	|N	|	|	|0	|0	|	|True	|False~
FLD	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|C_GROUP_ORDER	|GROUP_CALC_19	|GROUP CALC19	|GROUP_CALC_19	|	|0	|N	|N	|0	|1	|	|1	|4	|0	|0	|Full	|	|GROUP CALC19	|N	|	|	|0	|0	|	|True	|False~
FLD	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|C_GROUP_ORDER	|GROUP_CALC_2	|GROUP CALC2	|GROUP_CALC_2	|	|0	|N	|N	|0	|1	|	|1	|4	|0	|0	|Full	|	|GROUP CALC2	|N	|	|	|0	|0	|	|True	|False~
FLD	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|C_GROUP_ORDER	|GROUP_CALC_20	|GROUP CALC20	|GROUP_CALC_20	|	|0	|N	|N	|0	|1	|	|1	|4	|0	|0	|Full	|	|GROUP CALC20	|N	|	|	|0	|0	|	|True	|False~
FLD	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|C_GROUP_ORDER	|GROUP_CALC_21	|GROUP CALC21	|GROUP_CALC_21	|	|0	|N	|N	|0	|1	|	|1	|4	|0	|0	|Full	|	|GROUP CALC21	|N	|	|	|0	|0	|	|True	|False~
FLD	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|C_GROUP_ORDER	|GROUP_CALC_22	|GROUP CALC22	|GROUP_CALC_22	|	|0	|N	|N	|0	|1	|	|1	|4	|0	|0	|Full	|	|GROUP CALC22	|N	|	|	|0	|0	|	|True	|False~
FLD	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|C_GROUP_ORDER	|GROUP_CALC_3	|GROUP CALC3	|GROUP_CALC_3	|	|0	|N	|N	|0	|1	|	|1	|4	|0	|0	|Full	|	|GROUP CALC3	|N	|	|	|0	|0	|	|True	|False~
FLD	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|C_GROUP_ORDER	|GROUP_CALC_4	|GROUP CALC4	|GROUP_CALC_4	|	|0	|N	|N	|0	|1	|	|1	|4	|0	|0	|Full	|	|GROUP CALC4	|N	|	|	|0	|0	|	|True	|False~
FLD	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|C_GROUP_ORDER	|GROUP_CALC_5	|GROUP CALC5	|GROUP_CALC_5	|	|0	|N	|N	|0	|1	|	|1	|4	|0	|0	|Full	|	|GROUP CALC5	|N	|	|	|0	|0	|	|True	|False~
FLD	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|C_GROUP_ORDER	|GROUP_CALC_6	|GROUP CALC6	|GROUP_CALC_6	|	|0	|N	|N	|0	|1	|	|1	|4	|0	|0	|Full	|	|GROUP CALC6	|N	|	|	|0	|0	|	|True	|False~
FLD	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|C_GROUP_ORDER	|GROUP_CALC_7	|GROUP CALC7	|GROUP_CALC_7	|	|0	|N	|N	|0	|1	|	|1	|4	|0	|0	|Full	|	|GROUP CALC7	|N	|	|	|0	|0	|	|True	|False~
FLD	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|C_GROUP_ORDER	|GROUP_CALC_8	|GROUP CALC8	|GROUP_CALC_8	|	|0	|N	|N	|0	|1	|	|1	|4	|0	|0	|Full	|	|GROUP CALC8	|N	|	|	|0	|0	|	|True	|False~
FLD	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|C_GROUP_ORDER	|GROUP_CALC_9	|GROUP CALC9	|GROUP_CALC_9	|	|0	|N	|N	|0	|1	|	|1	|4	|0	|0	|Full	|	|GROUP CALC9	|N	|	|	|0	|0	|	|True	|False~
FLD	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|C_GROUP_ORDER	|GROUP_DISPLAY_1	|GROUP DISPLAY1	|GROUP_DISPLAY_1	|	|0	|N	|N	|0	|1	|	|1	|4	|0	|0	|Full	|	|GROUP DISPLAY1	|N	|	|	|0	|0	|	|True	|False~
FLD	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|C_GROUP_ORDER	|GROUP_DISPLAY_10	|GROUP DISPLAY10	|GROUP_DISPLAY_10	|	|0	|N	|N	|0	|1	|	|1	|4	|0	|0	|Full	|	|GROUP DISPLAY10	|N	|	|	|0	|0	|	|True	|False~
FLD	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|C_GROUP_ORDER	|GROUP_DISPLAY_11	|GROUP DISPLAY11	|GROUP_DISPLAY_11	|	|0	|N	|N	|0	|1	|	|1	|4	|0	|0	|Full	|	|GROUP DISPLAY11	|N	|	|	|0	|0	|	|True	|False~
FLD	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|C_GROUP_ORDER	|GROUP_DISPLAY_12	|GROUP DISPLAY12	|GROUP_DISPLAY_12	|	|0	|N	|N	|0	|1	|	|1	|4	|0	|0	|Full	|	|GROUP DISPLAY12	|N	|	|	|0	|0	|	|True	|False~
FLD	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|C_GROUP_ORDER	|GROUP_DISPLAY_13	|GROUP DISPLAY13	|GROUP_DISPLAY_13	|	|0	|N	|N	|0	|1	|	|1	|4	|0	|0	|Full	|	|GROUP DISPLAY13	|N	|	|	|0	|0	|	|True	|False~
FLD	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|C_GROUP_ORDER	|GROUP_DISPLAY_14	|GROUP DISPLAY14	|GROUP_DISPLAY_14	|	|0	|N	|N	|0	|1	|	|1	|4	|0	|0	|Full	|	|GROUP DISPLAY14	|N	|	|	|0	|0	|	|True	|False~
FLD	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|C_GROUP_ORDER	|GROUP_DISPLAY_15	|GROUP DISPLAY15	|GROUP_DISPLAY_15	|	|0	|N	|N	|0	|1	|	|1	|4	|0	|0	|Full	|	|GROUP DISPLAY15	|N	|	|	|0	|0	|	|True	|False~
FLD	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|C_GROUP_ORDER	|GROUP_DISPLAY_16	|GROUP DISPLAY16	|GROUP_DISPLAY_16	|	|0	|N	|N	|0	|1	|	|1	|4	|0	|0	|Full	|	|GROUP DISPLAY16	|N	|	|	|0	|0	|	|True	|False~
FLD	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|C_GROUP_ORDER	|GROUP_DISPLAY_17	|GROUP DISPLAY17	|GROUP_DISPLAY_17	|	|0	|N	|N	|0	|1	|	|1	|4	|0	|0	|Full	|	|GROUP DISPLAY17	|N	|	|	|0	|0	|	|True	|False~
FLD	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|C_GROUP_ORDER	|GROUP_DISPLAY_18	|GROUP DISPLAY18	|GROUP_DISPLAY_18	|	|0	|N	|N	|0	|1	|	|1	|4	|0	|0	|Full	|	|GROUP DISPLAY18	|N	|	|	|0	|0	|	|True	|False~
FLD	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|C_GROUP_ORDER	|GROUP_DISPLAY_19	|GROUP DISPLAY19	|GROUP_DISPLAY_19	|	|0	|N	|N	|0	|1	|	|1	|4	|0	|0	|Full	|	|GROUP DISPLAY19	|N	|	|	|0	|0	|	|True	|False~
FLD	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|C_GROUP_ORDER	|GROUP_DISPLAY_2	|GROUP DISPLAY2	|GROUP_DISPLAY_2	|	|0	|N	|N	|0	|1	|	|1	|4	|0	|0	|Full	|	|GROUP DISPLAY2	|N	|	|	|0	|0	|	|True	|False~
FLD	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|C_GROUP_ORDER	|GROUP_DISPLAY_20	|GROUP DISPLAY20	|GROUP_DISPLAY_20	|	|0	|N	|N	|0	|1	|	|1	|4	|0	|0	|Full	|	|GROUP DISPLAY20	|N	|	|	|0	|0	|	|True	|False~
FLD	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|C_GROUP_ORDER	|GROUP_DISPLAY_21	|GROUP DISPLAY21	|GROUP_DISPLAY_21	|	|0	|N	|N	|0	|1	|	|1	|4	|0	|0	|Full	|	|GROUP DISPLAY21	|N	|	|	|0	|0	|	|True	|False~
FLD	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|C_GROUP_ORDER	|GROUP_DISPLAY_22	|GROUP DISPLAY22	|GROUP_DISPLAY_22	|	|0	|N	|N	|0	|1	|	|1	|4	|0	|0	|Full	|	|GROUP DISPLAY22	|N	|	|	|0	|0	|	|True	|False~
FLD	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|C_GROUP_ORDER	|GROUP_DISPLAY_3	|GROUP DISPLAY3	|GROUP_DISPLAY_3	|	|0	|N	|N	|0	|1	|	|1	|4	|0	|0	|Full	|	|GROUP DISPLAY3	|N	|	|	|0	|0	|	|True	|False~
FLD	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|C_GROUP_ORDER	|GROUP_DISPLAY_4	|GROUP DISPLAY4	|GROUP_DISPLAY_4	|	|0	|N	|N	|0	|1	|	|1	|4	|0	|0	|Full	|	|GROUP DISPLAY4	|N	|	|	|0	|0	|	|True	|False~
FLD	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|C_GROUP_ORDER	|GROUP_DISPLAY_5	|GROUP DISPLAY5	|GROUP_DISPLAY_5	|	|0	|N	|N	|0	|1	|	|1	|4	|0	|0	|Full	|	|GROUP DISPLAY5	|N	|	|	|0	|0	|	|True	|False~
FLD	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|C_GROUP_ORDER	|GROUP_DISPLAY_6	|GROUP DISPLAY6	|GROUP_DISPLAY_6	|	|0	|N	|N	|0	|1	|	|1	|4	|0	|0	|Full	|	|GROUP DISPLAY6	|N	|	|	|0	|0	|	|True	|False~
FLD	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|C_GROUP_ORDER	|GROUP_DISPLAY_7	|GROUP DISPLAY7	|GROUP_DISPLAY_7	|	|0	|N	|N	|0	|1	|	|1	|4	|0	|0	|Full	|	|GROUP DISPLAY7	|N	|	|	|0	|0	|	|True	|False~
FLD	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|C_GROUP_ORDER	|GROUP_DISPLAY_8	|GROUP DISPLAY8	|GROUP_DISPLAY_8	|	|0	|N	|N	|0	|1	|	|1	|4	|0	|0	|Full	|	|GROUP DISPLAY8	|N	|	|	|0	|0	|	|True	|False~
FLD	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|C_GROUP_ORDER	|GROUP_DISPLAY_9	|GROUP DISPLAY9	|GROUP_DISPLAY_9	|	|0	|N	|N	|0	|1	|	|1	|4	|0	|0	|Full	|	|GROUP DISPLAY9	|N	|	|	|0	|0	|	|True	|False~
FLD	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|C_GROUP_ORDER	|ID_DTE_TIM_STAMP	|COGOUP DATE/TIME	|ID_DTE_TIM_STAMP8	|	|0	|N	|N	|0	|1	|	|1	|24	|0	|0	|Full	|	|COGOUP DATE/TIME	|N	|	|	|0	|0	|	|True	|False~
FLD	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|C_GROUP_ORDER	|RFU_FILLER	|COGOUP RFU_FILLER	|RFU_FILLER	|	|0	|N	|N	|0	|1	|	|1	|4	|0	|0	|Full	|	|COGOUP RFU_FILLER	|N	|	|	|0	|0	|	|True	|False~
FLD	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|C_GROUP_ORDER	|SI_DI_RULE	|COGOUP SI_DI_RULE	|SI_DI_RULE	|	|0	|N	|N	|0	|1	|	|1	|4	|0	|0	|Full	|	|COGOUP SI_DI_RULE	|N	|	|	|0	|0	|	|True	|False~
FLD	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|C_POSITION	|DESC	|DESC	|DESC	|	|5040	|Y	|N	|0	|1	|	|1	|50	|0	|0	|Full	|	|DESC	|N	|	|	|	|0	|	|True	|False~
FLD	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|C_POSITION	|EVALUATOR_POSN	|EVALUATOR POSN	|EVALUATOR_POSN	|	|1440	|Y	|N	|0	|1	|	|1	|10	|0	|0	|Full	|	|EVALUATOR POSN	|N	|	|	|	|0	|	|True	|False~
FLD	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|C_POSITION	|SUPRVR_POSN	|SUPRVR POSN	|SUPRVR_POSN	|	|1440	|Y	|N	|0	|1	|	|1	|10	|0	|0	|Full	|	|SUPRVR POSN	|N	|	|	|	|0	|	|True	|False~
FLD	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|C_POSN_ACCT	|ACCOUNT	|ACCT-POSN	|ACCOUNT	|	|1440	|Y	|N	|0	|1	|	|1	|26	|17	|0	|FULL	|	|ACCT-POSN	|N	|	|	|0	|0	|	|True	|False~
FLD	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|C_POSN_ACCT	|ASSIGN_TYPE	|ASSIGN TYPE-STAFF DATA-POSN	|ASSIGN_TYPE	|	|1440	|Y	|N	|0	|1	|	|1	|2	|0	|0	|FULL	|	|ASSIGN TYPE-STAFF DATA-POSN	|N	|	|	|0	|0	|	|True	|False~
FLD	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|C_POSN_ACCT	|CHANGE_FLAG	|CHANGE_FLAG	|CHANGE_FLAG	|	|1440	|N	|N	|0	|1	|	|1	|2	|0	|0	|FULL	|	|CHANGE_FLAG	|N	|	|	|0	|0	|	|True	|False~
FLD	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|C_POSN_ACCT	|CSS	|CSS CODE-STAFF DATA-POSN	|CSS	|	|1440	|Y	|N	|0	|1	|	|1	|6	|0	|0	|FULL	|	|CSS CODE-STAFF DATA-POSN	|N	|	|	|0	|0	|	|True	|False~
FLD	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|C_POSN_ACCT	|DI_YR_PC_MO	|DI_YR_PC_MO	|DI_YR_PC_MO	|	|1440	|N	|N	|0	|1	|	|1	|18	|0	|0	|FULL	|	|DI_YR_PC_MO	|N	|	|	|0	|0	|	|True	|False~
FLD	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|C_POSN_ACCT	|EFF_DATE	|EFF_DATE	|EFF_DATE	|	|1440	|N	|N	|0	|1	|	|2	|16	|0	|0	|FULL	|	|EFF_DATE	|N	|	|	|0	|0	|	|True	|False~
FLD	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|C_POSN_ACCT	|END_EFF_DATE	|END_EFF_DATE	|END_EFF_DATE	|	|1440	|N	|N	|0	|1	|	|2	|16	|0	|0	|FULL	|	|END_EFF_DATE	|N	|	|	|0	|0	|	|True	|False~
FLD	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|C_POSN_ACCT	|ID_DTE_TIM_STAMP	|ID_DTE_TIM_STAMP	|ID_DTE_TIM_STAMP	|	|1440	|N	|N	|0	|1	|	|1	|24	|0	|0	|FULL	|	|ID_DTE_TIM_STAMP	|N	|	|	|0	|0	|	|True	|False~
FLD	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|C_POSN_ACCT	|PERCENT_P	|ACCT %-POSN	|PERCENT_P	|	|1440	|Y	|N	|0	|1	|	|8	|8	|15	|0	|FULL	|	|ACCT %-POSN	|N	|	|	|0	|0	|	|True	|False~
FLD	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|C_POSN_ACCT	|RFU_FILLER1	|RFU_FILLER1	|RFU_FILLER1	|	|1440	|N	|N	|0	|1	|	|1	|2	|0	|0	|FULL	|	|RFU_FILLER1	|N	|	|	|0	|0	|	|True	|False~
FLD	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|C_POSN_ACCT	|TWIN_FLAG	|TWIN_FLAG	|TWIN_FLAG	|	|1440	|N	|N	|0	|1	|	|1	|2	|0	|0	|FULL	|	|TWIN_FLAG	|N	|	|	|0	|0	|	|True	|False~
FLD	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|C_PRO_RULE_FR_TO	|AMOUNT	|AMOUNT	|AMOUNT12	|	|1440	|N	|N	|0	|1	|	|8	|8	|0	|0	|FULL	|	|AMOUNT	|N	|	|	|0	|0	|	|True	|False~
FLD	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|C_PRO_RULE_FR_TO	|DI_YR_PAY_TYPE	|PAY TYPE TO INCLUDE	|DI_YR_PAY_TYPE	|	|1440	|N	|N	|0	|1	|	|1	|10	|0	|0	|FULL	|	|PAY TYPE TO INCLUDE	|N	|	|	|0	|0	|	|True	|False~
FLD	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|C_PRO_RULE_FR_TO	|ID_DTE_TIM_STAMP	|ID_DTE_TIM_STAMP	|ID_DTE_TIM_STAMP	|	|1440	|N	|N	|0	|1	|	|1	|24	|0	|0	|FULL	|	|ID_DTE_TIM_STAMP	|N	|	|	|0	|0	|	|True	|False~
FLD	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|C_PRO_RULE_FR_TO	|PERCENT_P	|PRORATE PERCENT	|PERCENT_P	|	|1440	|N	|N	|0	|1	|	|8	|8	|0	|0	|FULL	|	|PRORATE PERCENT	|N	|	|	|0	|0	|	|True	|False~
FLD	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|C_PRO_RULE_FR_TO	|PRO_FROM	|PRORATE FROM	|PRO_FROM	|	|1440	|N	|N	|0	|1	|	|8	|8	|0	|0	|FULL	|	|PRORATE FROM	|N	|	|	|0	|0	|	|True	|False~
FLD	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|C_PRO_RULE_FR_TO	|PRO_TO	|PRORATE TO	|PRO_TO	|	|1440	|N	|N	|0	|1	|	|8	|8	|0	|0	|FULL	|	|PRORATE TO	|N	|	|	|0	|0	|	|True	|False~
FLD	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|C_PRO_RULE_FR_TO	|RFU_FILLER	|RULE CODE	|RFU_FILLER2	|	|1440	|N	|N	|0	|1	|	|1	|4	|0	|0	|FULL	|	|RULE CODE	|N	|	|	|0	|0	|	|True	|False~
FLD	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|C_SAL_TYPE_AMT	|AMOUNT	|SAL SCHED AMOUNT	|AMOUNT	|	|1440	|N	|N	|0	|1	|	|8	|8	|12	|0	|FULL	|	|AMOUNT	|N	|	|	|0	|0	|	|True	|False~
FLD	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|C_SAL_TYPE_AMT	|DI_YR_UN_SC_MO	|DI_YR_UN_SC_MO	|DI_YR_UN_SC_MO	|	|1440	|N	|N	|0	|1	|	|1	|16	|0	|0	|FULL	|	|DI_YR_UN_SC_MO	|N	|	|	|0	|0	|	|True	|False~
FLD	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|C_SAL_TYPE_AMT	|EFF_DATE	|EFF_DATE	|EFF_DATE	|	|1440	|N	|N	|0	|1	|	|2	|16	|0	|0	|FULL	|	|EFF_DATE	|N	|	|	|0	|0	|	|True	|False~
FLD	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|C_SAL_TYPE_AMT	|END_EFF_DATE	|END_EFF_DATE	|END_EFF_DATE	|	|1440	|N	|N	|0	|1	|	|2	|16	|0	|0	|FULL	|	|END_EFF_DATE	|N	|	|	|0	|0	|	|True	|False~
FLD	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|C_SAL_TYPE_AMT	|ID_DTE_TIM_STAMP	|ID_DTE_TIM_STAMP	|ID_DTE_TIM_STAMP	|	|1440	|N	|N	|0	|1	|	|1	|24	|0	|0	|FULL	|	|ID_DTE_TIM_STAMP	|N	|	|	|0	|0	|	|True	|False~
FLD	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|C_SAL_TYPE_AMT	|PERCENT	|PERCENT	|PERCENT	|	|1440	|N	|N	|0	|1	|	|8	|8	|0	|0	|FULL	|	|PERCENT	|N	|	|	|0	|0	|	|True	|False~
FLD	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|C_SAL_TYPE_AMT	|RFU_FILLER	|RFU_FILLER	|RFU_FILLER	|	|1440	|N	|N	|0	|1	|	|1	|4	|0	|0	|FULL	|	|RFU_FILLER	|N	|	|	|0	|0	|	|True	|False~
FLD	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|C_SAL_TYPE_AMT	|TYPE	|TYPE	|TYPE	|	|1440	|N	|N	|0	|1	|	|1	|2	|0	|0	|FULL	|	|TYPE	|N	|	|	|0	|0	|	|True	|False~
FLD	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|C_SAL_TYPE_AMT	|TYPE_DESC	|TYPE DESCRIPTION	|TYPE_DESC	|	|1440	|N	|N	|0	|1	|	|1	|16	|0	|0	|FULL	|	|TYPE DESCRIPTION	|N	|	|	|0	|0	|	|True	|False~
FLD	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|C_SAL_TYPE_AMT	|TYPE_RANGE_CODE	|TYPE_RANGE_CODE	|TYPE_RANGE_CODE	|	|1440	|N	|N	|0	|1	|	|1	|4	|0	|0	|FULL	|	|TYPE_RANGE_CODE	|N	|	|	|0	|0	|	|True	|False~
FLD	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|C_WORKCAL	|COMMENT	|WORK CALENDAR COMMENT	|COMMENT14	|	|1440	|N	|N	|0	|1	|	|1	|60	|0	|0	|Full	|	|WORK CALENDAR COMMENT	|N	|	|	|0	|0	|	|True	|False~
FLD	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|C_WORKCAL	|CONTRACTDAYS	|CONTRACTDAYS	|CONTRACTDAYS	|	|1440	|Y	|N	|0	|1	|	|4	|8	|11	|2	|Full	|	|CONTRACTDAYS	|N	|	|	|	|0	|	|True	|False~
FLD	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|C_WORKCAL	|DAILY_RATE_1	|DAILY RATE JULY	|DAILY_RATE_1	|	|1440	|N	|N	|0	|1	|	|1	|1	|0	|0	|Full	|	|DAILY RATE JULY	|N	|	|	|0	|0	|	|True	|False~
FLD	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|C_WORKCAL	|DAILY_RATE_10	|DAILY RATE APRIL	|DAILY_RATE_10	|	|1440	|N	|N	|0	|1	|	|1	|1	|0	|0	|Full	|	|DAILY RATE APRIL	|N	|	|	|0	|0	|	|True	|False~
FLD	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|C_WORKCAL	|DAILY_RATE_11	|DAILY RATE MAY	|DAILY_RATE_11	|	|1440	|N	|N	|0	|1	|	|1	|1	|0	|0	|Full	|	|DAILY RATE MAY	|N	|	|	|0	|0	|	|True	|False~
FLD	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|C_WORKCAL	|DAILY_RATE_12	|DAILY RATE JUNE	|DAILY_RATE_12	|	|1440	|N	|N	|0	|1	|	|1	|1	|0	|0	|Full	|	|DAILY RATE JUNE	|N	|	|	|0	|0	|	|True	|False~
FLD	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|C_WORKCAL	|DAILY_RATE_2	|DAILY RATE AUGUST	|DAILY_RATE_2	|	|1440	|N	|N	|0	|1	|	|1	|1	|0	|0	|Full	|	|DAILY RATE AUGUST	|N	|	|	|0	|0	|	|True	|False~
FLD	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|C_WORKCAL	|DAILY_RATE_3	|DAILY RATE SEPTEMBER	|DAILY_RATE_3	|	|1440	|N	|N	|0	|1	|	|1	|1	|0	|0	|Full	|	|DAILY RATE SEPTEMBER	|N	|	|	|0	|0	|	|True	|False~
FLD	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|C_WORKCAL	|DAILY_RATE_4	|DAILY RATE OCTOBER	|DAILY_RATE_4	|	|1440	|N	|N	|0	|1	|	|1	|1	|0	|0	|Full	|	|DAILY RATE OCTOBER	|N	|	|	|0	|0	|	|True	|False~
FLD	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|C_WORKCAL	|DAILY_RATE_5	|DAILY RATE NOVEMBER	|DAILY_RATE_5	|	|1440	|N	|N	|0	|1	|	|1	|1	|0	|0	|Full	|	|DAILY RATE NOVEMBER	|N	|	|	|0	|0	|	|True	|False~
FLD	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|C_WORKCAL	|DAILY_RATE_6	|DAILY RATE DECEMBER	|DAILY_RATE_6	|	|1440	|N	|N	|0	|1	|	|1	|1	|0	|0	|Full	|	|DAILY RATE DECEMBER	|N	|	|	|0	|0	|	|True	|False~
FLD	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|C_WORKCAL	|DAILY_RATE_7	|DAILY RATE JANUARY	|DAILY_RATE_7	|	|1440	|N	|N	|0	|1	|	|1	|1	|0	|0	|Full	|	|DAILY RATE JANUARY	|N	|	|	|0	|0	|	|True	|False~
FLD	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|C_WORKCAL	|DAILY_RATE_8	|DAILY RATE FEBRUARY	|DAILY_RATE_8	|	|1440	|N	|N	|0	|1	|	|1	|1	|0	|0	|Full	|	|DAILY RATE FEBRUARY	|N	|	|	|0	|0	|	|True	|False~
FLD	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|C_WORKCAL	|DAILY_RATE_9	|DAILY RATE MARCH	|DAILY_RATE_9	|	|1440	|N	|N	|0	|1	|	|1	|1	|0	|0	|Full	|	|DAILY RATE MARCH	|N	|	|	|0	|0	|	|True	|False~
FLD	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|C_WORKCAL	|DAYS_PER_YEAR	|TOTAL PAID DAYS PER YEAR	|DAYS_PER_YEAR1	|	|1440	|Y	|N	|0	|1	|	|8	|8	|0	|0	|Full	|	|TOTAL PAID DAYS PER YEAR	|N	|	|	|0	|0	|	|True	|False~
FLD	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|C_WORKCAL	|DESC	|WORK CALENDAR DESCRIPTION	|DESC_CAL1	|	|1440	|N	|N	|0	|1	|	|1	|30	|0	|0	|Full	|	|WORK CALENDAR DESCRIPTION	|N	|	|	|0	|0	|	|True	|False~
FLD	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|C_WORKCAL	|DI_WC	|DI_WC	|DI_WC	|	|1440	|N	|N	|0	|1	|	|1	|8	|0	|0	|FULL	|	|DI_WC	|N	|	|	|0	|0	|	|True	|False~
FLD	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|C_WORKCAL	|DI_YR_WC_MO	|WORK CALENDAR CODE	|DI_YR_WC_MO	|	|1440	|N	|N	|0	|1	|	|1	|14	|0	|0	|Full	|	|WORK CALENDAR CODE	|N	|	|	|0	|0	|	|True	|False~
FLD	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|C_WORKCAL	|DISTRICTNUMBER	|DISTRICTNUMBER	|DISTRICTNUMBER	|	|1440	|N	|N	|0	|1	|	|1	|2	|0	|0	|FULL	|	|DISTRICTNUMBER	|N	|	|	|0	|0	|	|True	|False~
FLD	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|C_WORKCAL	|EFF_DATE	|EFF_DATE	|EFF_DATE	|	|1440	|N	|N	|0	|1	|	|2	|8	|0	|0	|Full	|	|EFF_DATE	|N	|	|	|0	|0	|	|True	|False~
FLD	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|C_WORKCAL	|END_EFF_DATE	|END_EFF_DATE	|END_EFF_DATE	|	|1440	|N	|N	|0	|1	|	|2	|8	|0	|0	|Full	|	|END_EFF_DATE	|N	|	|	|0	|0	|	|True	|False~
FLD	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|C_WORKCAL	|EXTRA_DAYS_1	|EXTRA DAYS JULY	|EXTRA_DAYS_1	|	|1440	|N	|N	|0	|1	|	|8	|8	|0	|0	|Full	|	|EXTRA DAYS JULY	|N	|	|	|0	|0	|	|True	|False~
FLD	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|C_WORKCAL	|EXTRA_DAYS_10	|EXTRA DAYS APRIL	|EXTRA_DAYS_10	|	|1440	|N	|N	|0	|1	|	|8	|8	|0	|0	|Full	|	|EXTRA DAYS APRIL	|N	|	|	|0	|0	|	|True	|False~
FLD	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|C_WORKCAL	|EXTRA_DAYS_11	|EXTRA DAYS MAY	|EXTRA_DAYS_11	|	|1440	|N	|N	|0	|1	|	|8	|8	|0	|0	|Full	|	|EXTRA DAYS MAY	|N	|	|	|0	|0	|	|True	|False~
FLD	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|C_WORKCAL	|EXTRA_DAYS_12	|EXTRA DAYS JUNE	|EXTRA_DAYS_12	|	|1440	|N	|N	|0	|1	|	|8	|8	|0	|0	|Full	|	|EXTRA DAYS JUNE	|N	|	|	|0	|0	|	|True	|False~
FLD	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|C_WORKCAL	|EXTRA_DAYS_2	|EXTRA DAYS AUGUST	|EXTRA_DAYS_2	|	|1440	|N	|N	|0	|1	|	|8	|8	|0	|0	|Full	|	|EXTRA DAYS AUGUST	|N	|	|	|0	|0	|	|True	|False~
FLD	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|C_WORKCAL	|EXTRA_DAYS_3	|EXTRA DAYS SEPTEMBER	|EXTRA_DAYS_3	|	|1440	|N	|N	|0	|1	|	|8	|8	|0	|0	|Full	|	|EXTRA DAYS SEPTEMBER	|N	|	|	|0	|0	|	|True	|False~
FLD	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|C_WORKCAL	|EXTRA_DAYS_4	|EXTRA DAYS OCTOBER	|EXTRA_DAYS_4	|	|1440	|N	|N	|0	|1	|	|8	|8	|0	|0	|Full	|	|EXTRA DAYS OCTOBER	|N	|	|	|0	|0	|	|True	|False~
FLD	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|C_WORKCAL	|EXTRA_DAYS_5	|EXTRA DAYS NOVEMBER	|EXTRA_DAYS_5	|	|1440	|N	|N	|0	|1	|	|8	|8	|0	|0	|Full	|	|EXTRA DAYS NOVEMBER	|N	|	|	|0	|0	|	|True	|False~
FLD	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|C_WORKCAL	|EXTRA_DAYS_6	|EXTRA DAYS DECEMBER	|EXTRA_DAYS_6	|	|1440	|N	|N	|0	|1	|	|8	|8	|0	|0	|Full	|	|EXTRA DAYS DECEMBER	|N	|	|	|0	|0	|	|True	|False~
FLD	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|C_WORKCAL	|EXTRA_DAYS_7	|EXTRA DAYS JANUARY	|EXTRA_DAYS_7	|	|1440	|N	|N	|0	|1	|	|8	|8	|0	|0	|Full	|	|EXTRA DAYS JANUARY	|N	|	|	|0	|0	|	|True	|False~
FLD	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|C_WORKCAL	|EXTRA_DAYS_8	|EXTRA DAYS FEBRUARY	|EXTRA_DAYS_8	|	|1440	|N	|N	|0	|1	|	|8	|8	|0	|0	|Full	|	|EXTRA DAYS FEBRUARY	|N	|	|	|0	|0	|	|True	|False~
FLD	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|C_WORKCAL	|EXTRA_DAYS_9	|EXTRA DAYS MARCH	|EXTRA_DAYS_9	|	|1440	|N	|N	|0	|1	|	|8	|8	|0	|0	|Full	|	|EXTRA DAYS MARCH	|N	|	|	|0	|0	|	|True	|False~
FLD	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|C_WORKCAL	|FIRSTWORKDATE	|CONTRACTDAYS	|FIRSTWORKDATE	|	|1440	|N	|N	|0	|1	|	|2	|8	|11	|2	|Full	|	|CONTRACTDAYS	|N	|	|	|	|0	|	|True	|False~
FLD	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|C_WORKCAL	|FIRSTWORKDATE	|WC-FIRSTWORKDATE	|FIRSTWORKDATE	|	|1440	|Y	|N	|0	|1	|	|2	|8	|8	|0	|EmpeCat	|	|WC-FIRSTWORKDATE	|N	|	|	|	|0	|	|True	|False~
FLD	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|C_WORKCAL	|ID_DTE_TIM_STAMP	|WORK CALENDAR ID_DTE_TIM_STAMP	|ID_DTE_TIM_STAMP10	|	|1440	|N	|N	|0	|1	|	|1	|24	|0	|0	|Full	|	|WORK CALENDAR ID_DTE_TIM_STAMP	|N	|	|	|0	|0	|	|True	|False~
FLD	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|C_WORKCAL	|LASTWORKDATE	|WC-LASTWORKDATE	|LASTWORKDATE	|	|1440	|Y	|N	|0	|1	|	|2	|8	|8	|0	|EmpeCat	|	|WC-LASTWORKDATE	|N	|	|	|	|0	|	|True	|False~
FLD	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|C_WORKCAL	|MONTHLY_PERCENT_1	|MONTHLY PERCENT JULY	|MONTHLY_PERCENT_1	|	|1440	|N	|N	|0	|1	|	|8	|8	|0	|0	|Full	|	|MONTHLY PERCENT JULY	|N	|	|	|0	|0	|	|True	|False~
FLD	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|C_WORKCAL	|MONTHLY_PERCENT_10	|MONTHLY PERCENT APRIL	|MONTHLY_PERCENT_10	|	|1440	|N	|N	|0	|1	|	|8	|8	|0	|0	|Full	|	|MONTHLY PERCENT APRIL	|N	|	|	|0	|0	|	|True	|False~
FLD	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|C_WORKCAL	|MONTHLY_PERCENT_11	|MONTHLY PERCENT MAY	|MONTHLY_PERCENT_11	|	|1440	|N	|N	|0	|1	|	|8	|8	|0	|0	|Full	|	|MONTHLY PERCENT MAY	|N	|	|	|0	|0	|	|True	|False~
FLD	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|C_WORKCAL	|MONTHLY_PERCENT_12	|MONTHLY PERCENT JUNE	|MONTHLY_PERCENT_12	|	|1440	|N	|N	|0	|1	|	|8	|8	|0	|0	|Full	|	|MONTHLY PERCENT JUNE	|N	|	|	|0	|0	|	|True	|False~
FLD	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|C_WORKCAL	|MONTHLY_PERCENT_2	|MONTHLY PERCENT AUGUST	|MONTHLY_PERCENT_2	|	|1440	|N	|N	|0	|1	|	|8	|8	|0	|0	|Full	|	|MONTHLY PERCENT AUGUST	|N	|	|	|0	|0	|	|True	|False~
FLD	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|C_WORKCAL	|MONTHLY_PERCENT_3	|MONTHLY PERCENT SEPTEMBER	|MONTHLY_PERCENT_3	|	|1440	|N	|N	|0	|1	|	|8	|8	|0	|0	|Full	|	|MONTHLY PERCENT SEPTEMBER	|N	|	|	|0	|0	|	|True	|False~
FLD	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|C_WORKCAL	|MONTHLY_PERCENT_4	|MONTHLY PERCENT OCTOBER	|MONTHLY_PERCENT_4	|	|1440	|N	|N	|0	|1	|	|8	|8	|0	|0	|Full	|	|MONTHLY PERCENT OCTOBER	|N	|	|	|0	|0	|	|True	|False~
FLD	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|C_WORKCAL	|MONTHLY_PERCENT_5	|MONTHLY PERCENT NOVEMBER	|MONTHLY_PERCENT_5	|	|1440	|N	|N	|0	|1	|	|8	|8	|0	|0	|Full	|	|MONTHLY PERCENT NOVEMBER	|N	|	|	|0	|0	|	|True	|False~
FLD	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|C_WORKCAL	|MONTHLY_PERCENT_6	|MONTHLY PERCENT DECEMBER	|MONTHLY_PERCENT_6	|	|1440	|N	|N	|0	|1	|	|8	|8	|0	|0	|Full	|	|MONTHLY PERCENT DECEMBER	|N	|	|	|0	|0	|	|True	|False~
FLD	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|C_WORKCAL	|MONTHLY_PERCENT_7	|MONTHLY PERCENT JANUARY	|MONTHLY_PERCENT_7	|	|1440	|N	|N	|0	|1	|	|8	|8	|0	|0	|Full	|	|MONTHLY PERCENT JANUARY	|N	|	|	|0	|0	|	|True	|False~
FLD	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|C_WORKCAL	|MONTHLY_PERCENT_8	|MONTHLY PERCENT FEBRUARY	|MONTHLY_PERCENT_8	|	|1440	|N	|N	|0	|1	|	|8	|8	|0	|0	|Full	|	|MONTHLY PERCENT FEBRUARY	|N	|	|	|0	|0	|	|True	|False~
FLD	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|C_WORKCAL	|MONTHLY_PERCENT_9	|MONTHLY PERCENT MARCH	|MONTHLY_PERCENT_9	|	|1440	|N	|N	|0	|1	|	|8	|8	|0	|0	|Full	|	|MONTHLY PERCENT MARCH	|N	|	|	|0	|0	|	|True	|False~
FLD	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|C_WORKCAL	|PAY_PERIOD_FROM	|PAY PERIOD FROM	|PAY_PERIOD_FROM	|	|1440	|N	|N	|0	|1	|	|1	|2	|0	|0	|Full	|	|PAY PERIOD FROM	|N	|	|	|0	|0	|	|True	|False~
FLD	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|C_WORKCAL	|PAY_PERIOD_TO	|PAY PERIOD TO	|PAY_PERIOD_TO	|	|1440	|N	|N	|0	|1	|	|1	|2	|0	|0	|Full	|	|PAY PERIOD TO	|N	|	|	|0	|0	|	|True	|False~
FLD	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|C_WORKCAL	|RFU_FILLER	|RFU_FILLER	|RFU_FILLER	|	|1440	|N	|N	|0	|1	|	|1	|4	|0	|0	|Full	|	|RFU_FILLER	|N	|	|	|0	|0	|	|True	|False~
FLD	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|C_WORKCAL	|SI_DY_WC_IDTS	|SI_DY_WC_IDTS	|SI_DY_WC_IDTS	|	|1440	|N	|N	|0	|1	|	|1	|36	|0	|0	|Full	|	|SI_DY_WC_IDTS	|N	|	|	|0	|0	|	|True	|False~
FLD	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|C_WORKCAL	|SI_DY_WC_MO	|SI_DY_WC_MO	|SI_DY_WC_MO	|	|1440	|N	|N	|0	|1	|	|1	|14	|0	|0	|Full	|	|SI_DY_WC_MO	|N	|	|	|0	|0	|	|True	|False~
FLD	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|C_WORKCAL	|SI_WM1	|SI_WM1	|SI_WM1	|	|1440	|N	|N	|0	|1	|	|1	|2	|0	|0	|Full	|	|SI_WM1	|N	|	|	|0	|0	|	|True	|False~
FLD	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|C_WORKCAL	|SI_WM10	|SI_WM10	|SI_WM10	|	|1440	|N	|N	|0	|1	|	|1	|2	|0	|0	|Full	|	|SI_WM10	|N	|	|	|0	|0	|	|True	|False~
FLD	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|C_WORKCAL	|SI_WM11	|SI_WM11	|SI_WM11	|	|1440	|N	|N	|0	|1	|	|1	|2	|0	|0	|Full	|	|SI_WM11	|N	|	|	|0	|0	|	|True	|False~
FLD	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|C_WORKCAL	|SI_WM12	|SI_WM12	|SI_WM12	|	|1440	|N	|N	|0	|1	|	|1	|2	|0	|0	|Full	|	|SI_WM12	|N	|	|	|0	|0	|	|True	|False~
FLD	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|C_WORKCAL	|SI_WM2	|SI_WM2	|SI_WM2	|	|1440	|N	|N	|0	|1	|	|1	|2	|0	|0	|Full	|	|SI_WM2	|N	|	|	|0	|0	|	|True	|False~
FLD	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|C_WORKCAL	|SI_WM3	|SI_WM3	|SI_WM3	|	|1440	|N	|N	|0	|1	|	|1	|2	|0	|0	|Full	|	|SI_WM3	|N	|	|	|0	|0	|	|True	|False~
FLD	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|C_WORKCAL	|SI_WM4	|SI_WM4	|SI_WM4	|	|1440	|N	|N	|0	|1	|	|1	|2	|0	|0	|Full	|	|SI_WM4	|N	|	|	|0	|0	|	|True	|False~
FLD	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|C_WORKCAL	|SI_WM5	|SI_WM5	|SI_WM5	|	|1440	|N	|N	|0	|1	|	|1	|2	|0	|0	|Full	|	|SI_WM5	|N	|	|	|0	|0	|	|True	|False~
FLD	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|C_WORKCAL	|SI_WM6	|SI_WM6	|SI_WM6	|	|1440	|N	|N	|0	|1	|	|1	|2	|0	|0	|Full	|	|SI_WM6	|N	|	|	|0	|0	|	|True	|False~
FLD	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|C_WORKCAL	|SI_WM7	|SI_WM7	|SI_WM7	|	|1440	|N	|N	|0	|1	|	|1	|2	|0	|0	|Full	|	|SI_WM7	|N	|	|	|0	|0	|	|True	|False~
FLD	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|C_WORKCAL	|SI_WM8	|SI_WM8	|SI_WM8	|	|1440	|N	|N	|0	|1	|	|1	|2	|0	|0	|Full	|	|SI_WM8	|N	|	|	|0	|0	|	|True	|False~
FLD	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|C_WORKCAL	|SI_WM9	|SI_WM9	|SI_WM9	|	|1440	|N	|N	|0	|1	|	|1	|2	|0	|0	|Full	|	|SI_WM9	|N	|	|	|0	|0	|	|True	|False~
FLD	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|C_WORKCAL	|VACATIONDAYS	|WC-VACATION DAYS	|VACATIONDAYS	|	|1440	|Y	|N	|0	|1	|	|4	|8	|0	|0	|EmpeCat	|VacationDays	|WC-VACATION DAYS	|N	|	|	|0	|0	|	|True	|False~
FLD	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|C_WORKCAL	|VACATIONDAYS	|WC-VACATION DAYS	|VACATIONDAYS	|	|1440	|Y	|N	|0	|1	|	|4	|8	|0	|0	|EmpeCat	|VacationDays	|WC-VACATION DAYS	|N	|	|	|	|0	|	|True	|False~
FLD	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|C_WORKCAL	|WRK_MONTH1	|JULY	|WRK_MONTH1	|	|1440	|N	|N	|0	|1	|	|1	|32	|0	|0	|Full	|	|JULY	|N	|	|	|0	|0	|	|True	|False~
FLD	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|C_WORKCAL	|WRK_MONTH10	|APRIL	|WRK_MONTH10	|	|1440	|N	|N	|0	|1	|	|1	|32	|0	|0	|Full	|	|APRIL	|N	|	|	|0	|0	|	|True	|False~
FLD	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|C_WORKCAL	|WRK_MONTH11	|MAY	|WRK_MONTH11	|	|1440	|N	|N	|0	|1	|	|1	|32	|0	|0	|Full	|	|MAY	|N	|	|	|0	|0	|	|True	|False~
FLD	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|C_WORKCAL	|WRK_MONTH12	|JUNE	|WRK_MONTH12	|	|1440	|N	|N	|0	|1	|	|1	|32	|0	|0	|Full	|	|JUNE	|N	|	|	|0	|0	|	|True	|False~
FLD	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|C_WORKCAL	|WRK_MONTH2	|AUGUST	|WRK_MONTH2	|	|1440	|N	|N	|0	|1	|	|1	|32	|0	|0	|Full	|	|AUGUST	|N	|	|	|0	|0	|	|True	|False~
FLD	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|C_WORKCAL	|WRK_MONTH3	|SEPTEMBER	|WRK_MONTH3	|	|1440	|N	|N	|0	|1	|	|1	|32	|0	|0	|Full	|	|SEPTEMBER	|N	|	|	|0	|0	|	|True	|False~
FLD	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|C_WORKCAL	|WRK_MONTH4	|OCTOBER	|WRK_MONTH4	|	|1440	|N	|N	|0	|1	|	|1	|32	|0	|0	|Full	|	|OCTOBER	|N	|	|	|0	|0	|	|True	|False~
FLD	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|C_WORKCAL	|WRK_MONTH5	|NOVEMBER	|WRK_MONTH5	|	|1440	|N	|N	|0	|1	|	|1	|32	|0	|0	|Full	|	|NOVEMBER	|N	|	|	|0	|0	|	|True	|False~
FLD	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|C_WORKCAL	|WRK_MONTH6	|DECEMBER	|WRK_MONTH6	|	|1440	|N	|N	|0	|1	|	|1	|32	|0	|0	|Full	|	|DECEMBER	|N	|	|	|0	|0	|	|True	|False~
FLD	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|C_WORKCAL	|WRK_MONTH7	|JANUARY	|WRK_MONTH7	|	|1440	|N	|N	|0	|1	|	|1	|32	|0	|0	|Full	|	|JANUARY	|N	|	|	|0	|0	|	|True	|False~
FLD	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|C_WORKCAL	|WRK_MONTH8	|FEBRUARY	|WRK_MONTH8	|	|1440	|N	|N	|0	|1	|	|1	|32	|0	|0	|Full	|	|FEBRUARY	|N	|	|	|0	|0	|	|True	|False~
FLD	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|C_WORKCAL	|WRK_MONTH9	|MARCH	|WRK_MONTH9	|	|1440	|N	|N	|0	|1	|	|1	|32	|0	|0	|Full	|	|MARCH	|N	|	|	|0	|0	|	|True	|False~
FLD	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|C_WORKCAL	|YEARROUND_FLAG	|YEAR ROUND	|YEARROUND_FLAG	|	|1440	|N	|N	|0	|1	|	|1	|2	|0	|0	|Full	|	|YEAR ROUND	|N	|	|	|0	|0	|	|True	|False~
FLD	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|C_WORKCAL_CODE	|DESC	|WORK CALENDAR DESCRIPTION	|DESC_CAL2	|	|1440	|N	|N	|0	|1	|	|1	|30	|0	|0	|FULL	|	|WORK CALENDAR DESCRIPTION	|N	|	|	|0	|0	|	|True	|False~
FLD	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|C_WORKCAL_CODE	|DI_YR_CD	|WORK CALENDAR CODE	|DI_YR_CD	|	|1440	|N	|N	|0	|1	|	|1	|8	|0	|0	|FULL	|	|WORK CALENDAR CODE	|N	|	|	|0	|0	|	|True	|False~
FLD	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|C_WORKCAL_CODE	|ID_DTE_TIM_STAMP	|WORK CALENDAR ID_DTE_TIM_STAMP	|ID_DTE_TIM_STAMP	|	|1440	|N	|N	|0	|1	|	|1	|24	|0	|0	|FULL	|	|WORK CALENDAR ID_DTE_TIM_STAMP	|N	|	|	|0	|0	|	|True	|False~
FLD	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|C_WORKCAL_CODE	|PERCENT	|PERCENTAGE	|PERCENT	|	|1440	|N	|N	|0	|1	|	|8	|8	|0	|0	|FULL	|	|PERCENTAGE	|N	|	|	|0	|0	|	|True	|False~
FLD	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|C_WORKCAL_CODE	|RFU_FILLER	|RFU_FILLER	|RFU_FILLER	|	|1440	|N	|N	|0	|1	|	|1	|4	|0	|0	|FULL	|	|RFU_FILLER	|N	|	|	|0	|0	|	|True	|False~
FLD	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|C_WORKCAL_CODE	|SI_DY_IDTS	|SI_DY_IDTS	|SI_DY_IDTS	|	|1440	|N	|N	|0	|1	|	|1	|30	|0	|0	|FULL	|	|SI_DY_IDTS	|N	|	|	|0	|0	|	|True	|False~
FLD	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|C_WORKCAL_CODE	|SI_DY_WKCD	|SI_DY_WKCD	|SI_DY_WKCD	|	|1440	|N	|N	|0	|1	|	|1	|8	|0	|0	|FULL	|	|SI_DY_WKCD	|N	|	|	|0	|0	|	|True	|False~
FLD	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|EmployeeAddInfo_view	|ADDINFOCODE	|ADDITIONAL INFO	|ADDINFOCODE	|	|4752	|Y	|N	|0	|1	|P2K_ADDL	|1	|50	|0	|0	|Full	|	|ADDITIONAL INFO	|N	|	|	|	|0	|	|True	|False~
FLD	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|EmployeeAddInfo_view	|ADDINFODESCRIPTION	|ADDITIONAL INFO DESCRIPTION	|ADDINFODESCRIPTION	|	|2880	|Y	|N	|0	|1	|	|1	|255	|0	|0	|Full	|	|ADDITIONAL INFO DESCRIPTION	|N	|	|	|	|0	|	|True	|False~
FLD	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|EmployeeAddInfo_view	|DI_SSN	|Di Ssn	|DI_SSN	|	|1440	|N	|N	|0	|1	|	|1	|12	|0	|0	|Full	|	|DI_SSN	|N	|	|	|	|0	|	|True	|False~
FLD	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|EmployeeAddInfo_view	|DISTRICT	|District	|DISTRICT	|	|1440	|N	|N	|0	|1	|	|1	|2	|0	|0	|Full	|	|DISTRICT	|N	|	|	|	|0	|	|True	|False~
FLD	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|EmployeeAddInfo_view	|EFF_DATE	|Additional Eff Date	|EFF_DATE	|	|1440	|N	|N	|0	|1	|	|2	|8	|8	|0	|Full	|	|Additional Eff Date	|N	|	|	|	|0	|	|True	|False~
FLD	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|EmployeeAddInfo_view	|END_EFF_DATE	|Additional End Eff Date	|END_EFF_DATE	|	|1440	|N	|N	|0	|1	|	|2	|8	|8	|0	|Full	|	|Additional End Eff Date	|N	|	|	|	|0	|	|True	|False~
FLD	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|EmployeeAttributeView	|BIRTHDATE	|BIRTHDATE	|BIRTHDATE1	|	|1440	|Y	|N	|0	|1	|	|2	|8	|8	|0	|Full	|	|BIRTHDATE	|N	|	|	|0	|0	|	|True	|False~
FLD	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|EmployeeAttributeView	|CLASSIFICATION	|CLASSIFICATION-EMPE	|CLASSIFICATION	|CLAS_DESC	|2880	|Y	|N	|0	|3	|P2K_CLAS	|1	|2	|0	|0	|Full	|	|CLASS	|N	|	|	|0	|0	|	|True	|False~
FLD	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|EmployeeAttributeView	|COMMENT	|COMMENT-ATTRIBUTE	|COMMENT12	|	|2880	|Y	|N	|0	|1	|	|1	|60	|0	|0	|Full	|	|COMMENT-ATTRIBUTE	|N	|	|	|0	|0	|	|True	|False~
FLD	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|EmployeeAttributeView	|DI_EIN	|EIN	|DI_EIN5	|	|1440	|N	|N	|0	|1	|	|1	|12	|0	|0	|Full	|	|EIN	|N	|	|	|0	|0	|	|True	|False~
FLD	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|EmployeeAttributeView	|DI_SSN	|SSN	|DISSN_Attribute	|	|1440	|N	|N	|0	|1	|	|1	|12	|7	|0	|Audit	|	|SSN	|N	|	|	|0	|0	|	|True	|False~
FLD	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|EmployeeAttributeView	|DRIVER_EXP	|DRIVERS LICENSE EXP.	|DRIVER_EXP	|	|1440	|Y	|N	|0	|1	|	|2	|8	|8	|0	|Audit	|	|DRIVERS LICENSE EXP.	|N	|	|	|0	|0	|	|True	|False~
FLD	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|EmployeeAttributeView	|DRIVER_LIC	|DRIVERS LICENSE NO.	|DRIVER_LIC	|	|1440	|Y	|N	|0	|1	|	|1	|8	|0	|0	|Audit	|	|DRIVERS LICENSE NO.	|N	|	|	|0	|0	|	|True	|False~
FLD	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|EmployeeAttributeView	|EFF_DATE	|EFF DATE-ATTRIBUTE	|EFF_DATE3	|	|1440	|Y	|N	|0	|1	|	|2	|8	|0	|0	|Full	|	|EFF DATE-ATTRIBUTE	|N	|	|	|0	|0	|	|True	|False~
FLD	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|EmployeeAttributeView	|EIN	|EIN	|EIN	|	|1440	|Y	|N	|0	|1	|	|1	|10	|0	|0	|Full	|	|EIN	|N	|	|	|0	|0	|	|True	|False~
FLD	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|EmployeeAttributeView	|EMAIL	|EMAIL	|EMAIL	|	|1440	|Y	|N	|0	|1	|	|1	|255	|0	|0	|Full	|	|EMAIL	|N	|	|	|0	|0	|	|True	|False~
FLD	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|EmployeeAttributeView	|EMP_DISTRICT	|Emp District	|EMP_DISTRICT	|	|1440	|N	|N	|0	|1	|	|1	|2	|0	|0	|Full	|	|EMP_DISTRICT	|N	|	|	|	|0	|	|True	|False~
FLD	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|EmployeeAttributeView	|EMPE_TYPE	|TYPE-EMPE	|EMPE_TYPE	|EMTY_DESC	|3600	|Y	|N	|0	|3	|P2K_EMTY	|1	|2	|0	|0	|Full	|	|TYPE	|N	|	|	|0	|0	|	|True	|False~
FLD	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|EmployeeAttributeView	|END_EFF_DATE	|EMPLOYEE END DATE	|END_EFF_DATE8	|	|1440	|N	|N	|0	|1	|	|2	|8	|0	|0	|Full	|	|EMPLOYEE END DATE	|N	|	|	|0	|0	|	|True	|False~
FLD	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|EmployeeAttributeView	|FIRSTNAME	|NAME-FIRST	|FIRSTNAME	|	|2160	|Y	|N	|0	|1	|	|1	|15	|0	|0	|Full	|	|FIRST	|N	|	|	|0	|0	|	|True	|False~
FLD	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|EmployeeAttributeView	|FLUENCY1	|FLUENCY1	|FLUENCY1	|	|1440	|Y	|N	|0	|3	|FLUENCY	|1	|1	|0	|0	|Full	|	|FLUENCY1	|N	|	|	|0	|0	|	|True	|False~
FLD	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|EmployeeAttributeView	|FLUENCY2	|FLUENCY2	|FLUENCY2	|	|1440	|Y	|N	|0	|3	|FLUENCY	|1	|1	|0	|0	|Full	|	|FLUENCY2	|N	|	|	|0	|0	|	|True	|False~
FLD	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|EmployeeAttributeView	|ID_DTE_TIM_STAMP	|EMPLOYEE  ATTRIBUTE DATE TIME	|ID_DTE_TIM_STAMP3	|	|1440	|Y	|N	|0	|1	|	|1	|24	|0	|0	|Full	|	|EMPLOYEE  ATTRIBUTE DATE TIME	|N	|	|	|0	|0	|	|True	|False~
FLD	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|EmployeeAttributeView	|INTERPRETER1	|INTERPRETER1	|INTERPRETER1	|	|1440	|Y	|N	|0	|1	|	|1	|1	|0	|0	|Full	|	|INTERPRETER1	|N	|	|	|0	|0	|	|True	|False~
FLD	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|EmployeeAttributeView	|INTERPRETER2	|INTERPRETER2	|INTERPRETER2	|	|1440	|Y	|N	|0	|1	|	|1	|1	|0	|0	|Full	|	|INTERPRETER2	|N	|	|	|0	|0	|	|True	|False~
FLD	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|EmployeeAttributeView	|LANGUAGE1	|LANGUAGE 1	|BILINGUAL1	|LANG_DESC	|1728	|Y	|N	|0	|3	|	|1	|50	|0	|0	|Full	|	|LANGUAGE 1	|N	|	|	|0	|0	|	|True	|False~
FLD	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|EmployeeAttributeView	|LANGUAGE2	|LANGUAGE 2	|BILINGUAL2	|	|1728	|Y	|N	|0	|3	|	|1	|50	|0	|0	|Full	|	|LANGUAGE 2	|N	|	|	|0	|0	|	|True	|False~
FLD	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|EmployeeAttributeView	|LASTNAME	|NAME-LAST	|LASTNAME	|	|2160	|Y	|N	|0	|1	|	|1	|20	|0	|0	|Full	|	|LAST	|N	|	|	|0	|0	|	|True	|False~
FLD	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|EmployeeAttributeView	|LASTNAMEFIRSTNAME	|NAME-LAST AND FIRST	|LASTNAMEFIRSTNAME	|	|3600	|Y	|N	|0	|1	|	|1	|37	|0	|0	|Full	|	|LAST AND FIRST NAME	|N	|	|	|	|0	|	|True	|False~
FLD	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|EmployeeAttributeView	|MI	|NAME-MIDDLE	|MI	|	|1440	|Y	|N	|0	|1	|	|1	|1	|0	|0	|Full	|	|MI	|N	|	|	|0	|0	|	|True	|False~
FLD	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|EmployeeAttributeView	|PHONE_CAR	|PHONE-CAR	|PHONE_CAR1	|	|1440	|Y	|N	|0	|1	|	|1	|16	|10	|0	|Audit	|	|PHONE-CAR	|N	|	|	|0	|0	|	|True	|False~
FLD	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|EmployeeAttributeView	|PHONE_FAX	|PHONE-FAX	|PHONE_FAX	|	|1440	|Y	|N	|0	|1	|	|1	|16	|10	|0	|Full	|	|PHONE-FAX	|N	|	|	|0	|0	|	|True	|False~
FLD	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|EmployeeAttributeView	|PHONE_HOME	|PHONE-HOME	|PHONE_HOME1	|	|1440	|Y	|N	|0	|1	|	|1	|16	|10	|0	|Audit	|case CE.RESTRICT_FLAG when 'Y' then '[RESTRICTED]' else CE.PHONE_HOME end	|PHONE-HOME	|Y|3	|	|	|0	|0	|	|True	|False~
FLD	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|EmployeeAttributeView	|PHONE_MESS	|PHONE-MESSAGE	|PHONE_MESS	|	|1440	|Y	|N	|0	|1	|	|1	|16	|10	|0	|Full	|	|PHONE-MESSAGE	|N	|	|	|0	|0	|	|True	|False~
FLD	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|EmployeeAttributeView	|PHONE_PAGER	|PHONE-PAGER	|PHONE_PAGER	|	|1440	|Y	|N	|0	|1	|	|1	|16	|10	|0	|Full	|	|PHONE-PAGER	|N	|	|	|0	|0	|	|True	|False~
FLD	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|EmployeeAttributeView	|PHONE_WORK	|PHONE-WORK-ATTRIBUTES	|PHONE_WORK1	|	|1440	|Y	|N	|0	|1	|	|1	|16	|10	|0	|Full	|	|PHONE-WORK-ATTRIBUTES	|N	|	|	|0	|0	|	|True	|False~
FLD	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|EmployeeAttributeView	|PREVIOUS_NAME	|NAME-PREVIOUS	|PREVIOUS_NAME	|	|2160	|Y	|N	|0	|1	|	|1	|20	|0	|0	|Full	|	|NAME-PREVIOUS	|N	|	|	|0	|0	|	|True	|False~
FLD	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|EmployeeAttributeView	|RESTRICT_FLAG	|PHONE-RESTRICT	|RESTRICT_FLAG	|	|1440	|Y	|N	|0	|1	|	|1	|2	|0	|0	|Full	|	|PHONE-RESTRICT	|N	|	|	|0	|0	|	|True	|False~
FLD	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|EmployeeAttributeView	|SSN	|SSN	|SSN	|	|1440	|Y	|N	|0	|1	|	|1	|9	|7	|0	|Full	|	|SSN	|N	|	|	|0	|0	|	|True	|False~
FLD	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|EmployeeAttributeView	|STATUS	|STATUS-EMPE	|STATUS1	|EMST_DESC	|2160	|Y	|N	|0	|3	|P2K_EMST	|1	|2	|0	|0	|Full	|	|STATUS	|N	|	|	|0	|0	|	|True	|False~
FLD	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|EmployeeAttributeView	|TITLE	|TITLE	|TITLE4	|	|1440	|Y	|N	|0	|1	|	|1	|4	|0	|0	|Full	|	|TITLE	|N	|	|	|0	|0	|	|True	|False~
FLD	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|EmployeeAttributeView	|TRANSLATOR1	|TRANSLATOR1	|TRANSLATOR1	|	|1440	|Y	|N	|0	|1	|	|1	|1	|0	|0	|Full	|	|TRANSLATOR1	|N	|	|	|0	|0	|	|True	|False~
FLD	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|EmployeeAttributeView	|TRANSLATOR2	|TRANSLATOR2	|TRANSLATOR2	|	|1440	|Y	|N	|0	|1	|	|1	|1	|0	|0	|Full	|	|TRANSLATOR2	|N	|	|	|0	|0	|	|True	|False~
FLD	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|EmployeeAttributeView	|WORK_MAIL	|WORK MAIL	|WORK_MAIL	|	|3600	|Y	|N	|0	|3	|LOCN_POS2000	|1	|4	|0	|0	|Full	|	|WORK MAIL CODE	|N	|	|	|0	|0	|	|True	|False~
FLD	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|EmployeeCheckList_view	|CHECKLISTCODE	|CHECKLIST CODE	|CHECKLISTCODE	|	|4752	|Y	|N	|0	|1	|	|1	|50	|0	|0	|Full	|	|CHECKLIST CODE	|N	|	|	|	|0	|	|True	|False~
FLD	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|EmployeeCheckList_view	|CHECKLISTDATE	|CHECKLIST DATE	|CHECKLISTDATE	|	|1440	|Y	|N	|0	|1	|	|2	|8	|8	|0	|Full	|	|CHECKLIST DATE	|N	|	|	|	|0	|	|True	|False~
FLD	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|EmployeeCheckList_view	|DI_SSN	|Di Ssn	|DI_SSN	|	|1440	|N	|N	|0	|1	|	|1	|12	|0	|0	|Full	|	|DI_SSN	|N	|	|	|	|0	|	|True	|False~
FLD	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|EmployeeCheckList_view	|DISTRICT	|District	|DISTRICT	|	|1440	|N	|N	|0	|1	|	|1	|2	|0	|0	|Full	|	|DISTRICT	|N	|	|	|	|0	|	|True	|False~
FLD	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|EmployeeCheckList_view	|EFF_DATE	|Check List Eff Date	|EFF_DATE	|	|1440	|N	|N	|0	|1	|	|2	|8	|8	|0	|Full	|	|Check List Eff Date	|N	|	|	|	|0	|	|True	|False~
FLD	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|EmployeeCheckList_view	|END_EFF_DATE	|Check List End Eff Date	|END_EFF_DATE	|	|1440	|N	|N	|0	|1	|	|2	|8	|8	|0	|Full	|	|Check List End Eff Date	|N	|	|	|	|0	|	|True	|False~
FLD	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|EventsView_01	|DI_SSN	|DI SSN-DI SSN	|DI_SSN	|	|1440	|N	|N	|0	|1	|	|1	|12	|0	|0	|Full	|	|DI SSN	|N	|	|	|	|0	|	|True	|False~
FLD	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|EventsView_02	|DI_SSN	|DI SSN	|DI_SSN	|	|1440	|N	|N	|0	|1	|	|1	|12	|0	|0	|Full	|	|DI SSN	|N	|	|	|	|0	|	|True	|False~
FLD	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|EventsView_10	|DI_SSN	|DI SSN-DI SSN	|DI_SSN	|	|1440	|N	|N	|0	|1	|	|1	|12	|0	|0	|Full	|	|DI SSN	|N	|	|	|	|0	|	|True	|False~
FLD	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|EventsView_15	|DI_SSN	|DI SSN-DI SSN	|DI_SSN	|	|1440	|N	|N	|0	|1	|	|1	|12	|0	|0	|Full	|	|DI SSN	|N	|	|	|	|0	|	|True	|False~
FLD	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|EventsView_28	|DI_SSN	|DI SSN-DI SSN	|DI_SSN	|	|1440	|N	|N	|0	|1	|	|1	|12	|0	|0	|Full	|	|DI SSN	|N	|	|	|	|0	|	|True	|False~
FLD	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|NOTE	|DI_SSN	|DI_SSN	|DI_SSN	|	|1440	|N	|N	|0	|1	|	|1	|12	|0	|0	|Full	|	|DI_SSN	|N	|	|	|0	|0	|	|True	|False~
FLD	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|NOTE	|DISPLAYFORMNAME	|NOTE SCREEN	|DISPLAYFORMNAME	|	|1440	|Y	|N	|0	|1	|	|1	|50	|0	|0	|Full	|	|NOTE SCREEN	|N	|	|	|0	|0	|	|True	|False~
FLD	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|NOTE	|ID	|ID	|ID	|	|1440	|N	|N	|0	|1	|	|6	|4	|0	|0	|Full	|	|ID	|N	|	|	|0	|0	|	|True	|False~
FLD	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|NOTE	|NOTEDATE	|NOTE DATE	|NOTEDATE	|	|1440	|Y	|N	|0	|1	|	|2	|8	|0	|0	|Full	|	|NOTE DATE	|N	|	|	|0	|0	|	|True	|False~
FLD	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|NOTE	|NOTETEXT	|NOTE TEXT	|NOTETEXT	|	|1440	|Y	|N	|0	|1	|	|1	|5000	|0	|0	|Full	|	|NOTE TEXT	|N	|	|	|0	|0	|	|True	|False~
FLD	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|NOTE	|SI_DATE_TIME	|SI_DATE_TIME	|SI_DATE_TIME	|	|1440	|N	|N	|0	|1	|	|1	|14	|0	|0	|Full	|	|SI_DATE_TIME	|N	|	|	|0	|0	|	|True	|False~
FLD	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|NOTE	|USERLOGON	|NOTE USER LOGON	|USERLOGON	|	|1440	|Y	|N	|0	|1	|	|1	|50	|0	|0	|Full	|	|NOTE USER LOGON	|N	|	|	|0	|0	|	|True	|False~
FLD	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|P2K_DistrictCredential	|CLBCL	|CLBCL	|CLBCL	|	|1440	|Y	|N	|0	|1	|	|1	|50	|0	|0	|Full	|	|CLBCL	|N	|	|	|	|0	|	|True	|False~
FLD	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|P2K_DistrictCredential	|DATETIMESTAMP	|DATETIMESTAMP	|DATETIMESTAMP	|	|1440	|N	|N	|0	|1	|	|1	|14	|0	|0	|Full	|	|DATETIMESTAMP	|N	|	|	|	|0	|	|True	|False~
FLD	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|P2K_DistrictCredential	|DISTRICTNUMBER	|DISTRICTNUMBER	|DISTRICTNUMBER	|	|1440	|N	|N	|0	|1	|	|1	|2	|0	|0	|Full	|	|DISTRICTNUMBER	|N	|	|	|	|0	|	|True	|False~
FLD	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|P2K_DistrictCredential	|EFFECTIVEDATE	|CREDENTIAL EFFECTIVE DATE-DISTRICT	|EFFECTIVEDATE	|	|1440	|Y	|N	|0	|1	|	|2	|8	|8	|0	|Full	|	|CREDENTIAL EFFECTIVE DATE-DISTRICT	|N	|	|	|	|0	|	|True	|False~
FLD	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|P2K_DistrictCredential	|EMPLOYEEID	|EMPLOYEEID	|EMPLOYEEID	|	|1440	|N	|N	|0	|1	|	|6	|4	|0	|0	|Full	|	|EMPLOYEEID	|N	|	|	|	|0	|	|True	|False~
FLD	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|P2K_DistrictCredential	|EXPIRATIONDATE	|CREDENTIAL EXPIRATION DATE-DISTRICT	|EXPIRATIONDATE	|	|1440	|Y	|N	|0	|1	|	|2	|8	|8	|0	|Full	|	|CREDENTIAL EXPIRATION DATE-DISTRICT	|N	|	|	|	|0	|	|True	|False~
FLD	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|P2K_DistrictCredential	|ID	|ID	|ID	|	|1440	|N	|N	|0	|1	|	|6	|4	|0	|0	|Full	|	|ID	|N	|	|	|	|0	|	|True	|False~
FLD	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|P2K_DistrictCredential	|SUBJECT	|CREDENTIAL SUBJECT-DISTRICT	|SUBJECT	|	|1440	|Y	|N	|0	|1	|	|1	|50	|0	|0	|Full	|	|CREDENTIAL SUBJECT-DISTRICT	|N	|	|	|	|0	|	|True	|False~
FLD	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|P2K_DistrictCredential	|SUPPLEMENTALSUBJECT	|CREDENTIAL SUPPLEMENTALSUBJECT-DISTRICT	|SUPPLEMENTALSUBJECT	|	|1440	|Y	|N	|0	|1	|	|1	|50	|0	|0	|Full	|	|CREDENTIAL SUPPLEMENTAL SUBJECT-DISTRICT	|N	|	|	|	|0	|	|True	|False~
FLD	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|P2K_DistrictCredential	|TERM	|CREDENTIAL TERM-DISTRICT	|TERM	|	|1440	|Y	|N	|0	|1	|	|1	|50	|0	|0	|Full	|	|CREDENTIAL TERM-DISTRICT	|N	|	|	|	|0	|	|True	|False~
FLD	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|P2K_DistrictCredential	|TITLE	|CREDENTIAL TITLE-DISTRICT	|TITLE	|	|1440	|Y	|N	|0	|1	|	|1	|50	|0	|0	|Full	|	|CREDENTIAL TITLE-DISTRICT	|N	|	|	|	|0	|	|True	|False~
FLD	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|P2K_DistrictCredential	|TOCOUNTYDATE	|TO COUNTY DATE	|TOCOUNTYDATE	|	|1440	|Y	|N	|0	|1	|	|2	|8	|8	|0	|Full	|	|TO COUNTY DATE	|N	|	|	|	|0	|	|True	|False~
FLD	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|P2K_DistrictCredential	|TTC	|TCC	|TTC	|	|1440	|Y	|N	|0	|1	|	|1	|50	|0	|0	|Full	|	|TCC	|N	|	|	|	|0	|	|True	|False~
FLD	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|P2K_EmergencyInfo	|DATETIMESTAMP	|DATETIMESTAMP	|DATETIMESTAMP	|	|1440	|N	|N	|0	|1	|	|1	|14	|0	|0	|Full	|	|DATETIMESTAMP	|N	|	|	|	|0	|	|True	|False~
FLD	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|P2K_EmergencyInfo	|DISTRICTNUMBER	|DISTRICTNUMBER	|DISTRICTNUMBER	|	|1440	|N	|N	|0	|1	|	|1	|2	|0	|0	|Full	|	|DISTRICTNUMBER	|N	|	|	|	|0	|	|True	|False~
FLD	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|P2K_EmergencyInfo	|EMPLOYEEID	|EMPLOYEEID	|EMPLOYEEID	|	|1440	|N	|N	|0	|1	|	|6	|4	|0	|0	|Full	|	|EMPLOYEEID	|N	|	|	|	|0	|	|True	|False~
FLD	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|P2K_EmergencyInfo	|HOSPITALCODE	|PREFERRED HOSPITAL	|HOSPITALCODE	|	|1440	|Y	|N	|0	|1	|P2K_HOSPITAL	|1	|50	|0	|0	|Full	|	|PREFERRED HOSPITAL	|N	|	|	|	|0	|	|True	|False~
FLD	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|P2K_EmergencyInfo	|ID	|ID	|ID	|	|1440	|N	|N	|0	|1	|	|6	|4	|0	|0	|Full	|	|ID	|N	|	|	|	|0	|	|True	|False~
FLD	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|P2K_EmergencyInfo	|INSURANCECODE	|INSURANCE CARRIER	|INSURANCECODE	|	|1440	|Y	|N	|0	|1	|P2K_INSURANCE	|1	|50	|0	|0	|Full	|	|INSURANCE CARRIER	|N	|	|	|	|0	|	|True	|False~
FLD	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|P2K_EmergencyInfo	|LASTPHYSICAL	|LAST PHYSICAL	|LASTPHYSICAL	|	|1440	|Y	|N	|0	|1	|	|2	|8	|8	|0	|Full	|	|LAST PHYSICAL	|N	|	|	|	|0	|	|True	|False~
FLD	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|P2K_Employee_View	|BATOTAL	|BA UNITS-CERTIFICATED	|BATOTAL	|	|1440	|Y	|N	|0	|1	|	|4	|8	|16	|0	|Full	|	|BA UNITS-CERTIFICATED	|N	|	|	|	|0	|	|True	|False~
FLD	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|P2K_Employee_View	|CLASSIFIEDDISTRICTEXPERIENCE	|DISTRICT EXPERIENCE-CLASSIFIED	|CLASSIFIEDDISTRICTEXPERIENCE	|	|1440	|Y	|N	|0	|1	|	|6	|4	|12	|0	|Full	|	|DISTRICT EXPERIENCE-CLASSIFIED	|N	|	|	|	|0	|	|True	|False~
FLD	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|P2K_Employee_View	|CLASSIFIEDOTHERDISTRICT	|OTHER DISTRICT-CLASSIFIED	|CLASSIFIEDOTHERDISTRICT	|	|1440	|Y	|N	|0	|1	|	|4	|8	|12	|0	|Full	|	|OTHER DISTRICT-CLASSIFIED	|N	|	|	|	|0	|	|True	|False~
FLD	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|P2K_Employee_View	|CLASSIFIEDOTHEREXPERIENCE	|OTHER EXPERIENCE-CLASSIFIED	|CLASSIFIEDOTHEREXPERIENCE	|	|1440	|Y	|N	|0	|1	|	|4	|8	|12	|0	|Full	|	|OTHER EXPERIENCE-CLASSIFIED	|N	|	|	|	|0	|	|True	|False~
FLD	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|P2K_Employee_View	|CLASSIFIEDTOTALDISTRICTEXPERIENCE	|TOTAL EXPERIENCE-CLASSIFIED	|CLASSIFIEDTOTALDISTRICTEXPERIENCE	|	|1440	|Y	|N	|0	|1	|	|4	|8	|12	|0	|Full	|	|TOTAL EXPERIENCE-CLASSIFIED	|N	|	|	|	|0	|	|True	|False~
FLD	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|P2K_Employee_View	|DATETIMESTAMP	|DATETIMESTAMP	|DATETIMESTAMP	|	|1440	|N	|N	|0	|1	|	|1	|14	|0	|0	|Full	|	|DATETIMESTAMP	|N	|	|	|	|0	|	|True	|False~
FLD	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|P2K_Employee_View	|DISTRICTEXPERIENCE	|DISTRICT EXPERIENCE-CERTIFICATED	|DISTRICTEXPERIENCE	|	|1440	|Y	|N	|0	|1	|	|6	|4	|12	|0	|Full	|	|DISTRICT EXPERIENCE-CERTIFICATED	|N	|	|	|	|0	|	|True	|False~
FLD	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|P2K_Employee_View	|DISTRICTEXPERIENCEDATE	|DISTRICTEXPERIENCEDATE	|DISTRICTEXPERIENCEDATE	|	|1440	|N	|N	|0	|1	|	|2	|8	|0	|0	|Full	|	|DISTRICT EXPERIENCE DATE-CERTIFICATED	|N	|	|	|	|0	|	|True	|False~
FLD	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|P2K_Employee_View	|DISTRICTNUMBER	|DISTRICTNUMBER	|DISTRICTNUMBER	|	|1440	|N	|N	|0	|1	|	|1	|2	|0	|0	|Full	|	|DISTRICTNUMBER	|N	|	|	|	|0	|	|True	|False~
FLD	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|P2K_Employee_View	|ELL	|ELL-CERTIFICATED	|ELL	|	|1440	|Y	|N	|0	|1	|	|1	|1	|0	|0	|Full	|	|ELL-CERTIFICATED	|N	|	|	|	|0	|	|True	|False~
FLD	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|P2K_Employee_View	|ID	|ID	|ID	|	|1440	|N	|N	|0	|1	|	|6	|4	|0	|0	|Full	|	|ID	|N	|	|	|	|0	|	|True	|False~
FLD	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|P2K_Employee_View	|INCREMENTDUEDATE	|INCREMENT DUE DATE-CLASSIFIED	|INCREMENTDUEDATE	|	|1440	|Y	|N	|0	|1	|	|2	|8	|8	|0	|Full	|	|INCREMENT DUE DATE-CLASSIFIED	|N	|	|	|	|0	|	|True	|False~
FLD	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|P2K_Employee_View	|MASTERS	|MASTERS CHECKBOX-CERTIFICATED	|MASTERS	|	|1440	|Y	|N	|0	|1	|	|1	|1	|0	|0	|Full	|	|MASTERS CHECKBOX-CERTIFICATED	|N	|	|	|	|0	|	|True	|False~
FLD	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|P2K_Employee_View	|MATOTAL	|MA UNITS-CERTIFICATED	|MATOTAL	|	|1440	|Y	|N	|0	|1	|	|4	|8	|16	|0	|Full	|	|MA UNITS-CERTIFICATED	|N	|	|	|	|0	|	|True	|False~
FLD	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|P2K_Employee_View	|PARTTIMEID	|PART TIME-CLASSIFIED	|PARTTIMEID	|	|1440	|Y	|N	|0	|1	|P2K_PartTime	|6	|4	|0	|0	|Full	|	|PART TIME-CLASSIFIED	|N	|	|	|	|0	|	|True	|False~
FLD	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|P2K_Employee_View	|PARTTIMEIDCERTIFICATED	|PART TIME-CERTIFICATED	|PARTTIMEIDCERTIFICATED	|	|1440	|N	|N	|0	|1	|P2K_PartTime	|6	|4	|0	|0	|Full	|	|PART TIME-CERTIFICATED	|N	|	|	|	|0	|	|True	|False~
FLD	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|P2K_Employee_View	|SEMESTERUNITS	|TOTAL SEMESTER UNITS-CLASSIFIED	|SEMESTERUNITS	|	|1440	|Y	|N	|0	|1	|	|4	|8	|16	|0	|Full	|	|TOTAL SEMESTER UNITS-CLASSIFIED	|N	|	|	|	|0	|	|True	|False~
FLD	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|P2K_Employee_View	|SSN	|SSN	|SSN	|	|1440	|N	|N	|0	|1	|	|1	|9	|0	|0	|Full	|	|SSN	|N	|	|	|	|0	|	|True	|False~
FLD	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|P2K_Employee_View	|TOTALDISTRICTEXPERIENCE	|TOTAL EXPERIENCE-CERTIFICATED	|TOTALDISTRICTEXPERIENCE	|	|1440	|Y	|N	|0	|1	|	|4	|8	|12	|0	|Full	|	|TOTAL EXPERIENCE-CERTIFICATED	|N	|	|	|	|0	|	|True	|False~
FLD	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|P2K_Employee_View	|YEARSINSTATE	|OTHER DISTRICT-CERTIFICATED	|YEARSINSTATE	|	|1440	|Y	|N	|0	|1	|	|4	|8	|12	|0	|Full	|	|OTHER DISTRICT -CERTIFICATED	|N	|	|	|	|0	|	|True	|False~
FLD	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|P2K_Employee_View	|YEARSOUTSTATE	|OTHER EXPERIENCE-CERTIFICATED	|YEARSOUTSTATE	|	|1440	|Y	|N	|0	|1	|	|4	|8	|12	|0	|Full	|	|OTHER EXPERIENCE-CERTIFICATED	|N	|	|	|	|0	|	|True	|False~
FLD	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|P2K_EmployeeClassifiedEducation	|CLASSIFIEDDEGREECODE	|DEGREE-CLASSIFIED	|CLASSIFIEDDEGREECODE	|	|1440	|Y	|N	|0	|1	|	|1	|50	|0	|0	|Full	|	|DEGREE-CLASSIFIED	|N	|	|	|	|0	|	|True	|False~
FLD	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|P2K_EmployeeClassifiedEducation	|CLASSIFIEDINSTITUTIONCODE	|DEGREE INSTITUTION-CLASSIFIED	|CLASSIFIEDINSTITUTIONCODE	|	|1440	|Y	|N	|0	|1	|	|1	|50	|0	|0	|Full	|	|DEGREE INSTITUTION-CLASSIFIED	|N	|	|	|	|0	|	|True	|False~
FLD	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|P2K_EmployeeClassifiedEducation	|DATETIMESTAMP	|DATETIMESTAMP	|DATETIMESTAMP	|	|1440	|N	|N	|0	|1	|	|1	|14	|0	|0	|Full	|	|DATETIMESTAMP	|N	|	|	|	|0	|	|True	|False~
FLD	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|P2K_EmployeeClassifiedEducation	|DEGREETBL_CODE	|DEGREE CODE-CLASSIFIED	|DEGREETBL_CODE	|	|1440	|N	|N	|0	|1	|	|1	|50	|0	|0	|Full	|	|DEGREE CODE-CLASSIFIED	|N	|	|	|	|0	|	|True	|False~
FLD	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|P2K_EmployeeClassifiedEducation	|DEGREETBL_TYPE	|DEGREE-CLASSIFIED	|DEGREETBL_TYPE	|	|1440	|N	|N	|0	|1	|	|1	|50	|0	|0	|Full	|	|DEGREE-CLASSIFIED	|N	|	|	|	|0	|	|True	|False~
FLD	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|P2K_EmployeeClassifiedEducation	|DISTRICTNUMBER	|DISTRICTNUMBER	|DISTRICTNUMBER	|	|1440	|N	|N	|0	|1	|	|1	|2	|0	|0	|Full	|	|DISTRICTNUMBER	|N	|	|	|	|0	|	|True	|False~
FLD	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|P2K_EmployeeClassifiedEducation	|EMPLOYEEID	|EMPLOYEEID	|EMPLOYEEID	|	|1440	|N	|N	|0	|1	|	|6	|4	|0	|0	|Full	|	|EMPLOYEEID	|N	|	|	|	|0	|	|True	|False~
FLD	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|P2K_EmployeeClassifiedEducation	|GRADUATIONDATE	|GRADUATION DATE-CLASSIFIED	|GRADUATIONDATE	|	|1440	|Y	|N	|0	|1	|	|2	|8	|8	|0	|Full	|	|GRADUATION DATE-CLASSIFIED	|N	|	|	|	|0	|	|True	|False~
FLD	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|P2K_EmployeeClassifiedEducation	|ID	|ID	|ID	|	|1440	|N	|N	|0	|1	|	|6	|4	|0	|0	|Full	|	|ID	|N	|	|	|	|0	|	|True	|False~
FLD	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|P2K_EmployeeClassifiedEducation	|INSTITUTIONTBL_CODE	|INSTITUTUIONTBL_CODE	|INSTITUTIONTBL_CODE	|	|1440	|N	|N	|0	|1	|	|1	|50	|0	|0	|Full	|	|INSITUTIONTBL_CODE	|N	|	|	|	|0	|	|True	|False~
FLD	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|P2K_EmployeeClassifiedEducation	|INSTITUTIONTBL_TYPE	|INSTITUTIONTBL_TYPE	|INSTITUTIONTBL_TYPE	|	|1440	|N	|N	|0	|1	|	|1	|50	|0	|0	|Full	|	|INSTITUTIONTBL_TYPE	|N	|	|	|	|0	|	|True	|False~
FLD	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|P2K_EmployeeClassifiedEducation	|MAJORDESC	|MAJOR-CLASSIFIED	|MAJORDESC	|	|1440	|Y	|N	|0	|1	|	|1	|50	|0	|0	|Full	|	|MAJOR-CLASSIFIED	|N	|	|	|	|0	|	|True	|False~
FLD	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|P2K_EmployeeClassifiedEducation	|MINORDESC	|MINOR-CLASSIFIED	|MINORDESC	|	|1440	|Y	|N	|0	|1	|	|1	|50	|0	|0	|Full	|	|MINOR-CLASSIFIED	|N	|	|	|	|0	|	|True	|False~
FLD	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|P2K_EmployeeClassifiedSkill	|AWARDDATE	|AWARD DATE-CLASSIFIED	|AWARDDATE	|	|1440	|Y	|N	|0	|1	|	|2	|8	|8	|0	|Full	|	|AWARD DATE-CLASSIFIED SKILL	|N	|	|	|	|0	|	|True	|False~
FLD	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|P2K_EmployeeClassifiedSkill	|DATETIMESTAMP	|DATETIMESTAMP	|DATETIMESTAMP	|	|1440	|N	|N	|0	|1	|	|1	|14	|0	|0	|Full	|	|DATETIMESTAMP	|N	|	|	|	|0	|	|True	|False~
FLD	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|P2K_EmployeeClassifiedSkill	|DISTRICTNUMBER	|DISTRICTNUMBER	|DISTRICTNUMBER	|	|1440	|N	|N	|0	|1	|	|1	|2	|0	|0	|Full	|	|DISTRICTNUMBER	|N	|	|	|	|0	|	|True	|False~
FLD	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|P2K_EmployeeClassifiedSkill	|EMPLOYEEID	|EMPLOYEEID	|EMPLOYEEID	|	|1440	|N	|N	|0	|1	|	|6	|4	|0	|0	|Full	|	|EMPLOYEEID	|N	|	|	|	|0	|	|True	|False~
FLD	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|P2K_EmployeeClassifiedSkill	|EXPIRATIONDATE	|EXPIRATION DATE-CLASSIFIED	|EXPIRATIONDATE	|	|1440	|Y	|N	|0	|1	|	|2	|8	|8	|0	|Full	|	|EXPIRATION DATE-CLASSIFIED SKILL	|N	|	|	|	|0	|	|True	|False~
FLD	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|P2K_EmployeeClassifiedSkill	|ID	|ID	|ID	|	|1440	|N	|N	|0	|1	|	|6	|4	|0	|0	|Full	|	|ID	|N	|	|	|	|0	|	|True	|False~
FLD	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|P2K_EmployeeClassifiedSkill	|SKILL	|SKILL-CLASSIFIED	|SKILL	|	|1440	|Y	|N	|0	|1	|	|1	|50	|0	|0	|Full	|	|SKILL-CLASSIFIED	|N	|	|	|	|0	|	|True	|False~
FLD	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|P2K_EmployeeContact	|DATETIMESTAMPE	|DATETIMESTAMPE	|DATETIMESTAMPE	|	|1440	|N	|N	|0	|1	|	|1	|14	|0	|0	|Full	|	|DATE TIME STAMP	|N	|	|	|	|0	|	|True	|False~
FLD	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|P2K_EmployeeContact	|DISTRICTNUMBER	|DISTRICTNUMBER	|DISTRICTNUMBER	|	|1440	|N	|N	|0	|1	|	|1	|2	|0	|0	|Full	|	|DISTRICTNUMBER	|N	|	|	|	|0	|	|True	|False~
FLD	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|P2K_EmployeeContact	|EMPLOYEEID	|EMPLOYEEID	|EMPLOYEEID	|	|1440	|N	|N	|0	|1	|	|6	|4	|0	|0	|Full	|	|EMPLOYEEID	|N	|	|	|	|0	|	|True	|False~
FLD	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|P2K_EmployeeContact	|ID	|ID	|ID	|	|1440	|N	|N	|0	|1	|	|6	|4	|0	|0	|Full	|	|ID	|N	|	|	|	|0	|	|True	|False~
FLD	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|P2K_EmployeeContact	|RELATIONSHIPCODE	|CONTACT RELATIONSHIP	|RELATIONSHIPCODE	|	|1440	|Y	|N	|0	|1	|	|1	|50	|0	|0	|Full	|	|CONTACT RELATIONSHIP	|N	|	|	|	|0	|	|True	|False~
FLD	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|P2K_EmployeeContact	|TITLECODE	|CONTACT TITLE	|TITLECODE	|	|1440	|Y	|N	|0	|1	|	|1	|50	|0	|0	|Full	|	|CONTACT TITLE	|N	|	|	|	|0	|	|True	|False~
FLD	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|P2K_EmployeeEducation	|DATETIMESTAMP	|DATETIMESTAMP	|DATETIMESTAMP	|	|1440	|N	|N	|0	|1	|	|1	|14	|0	|0	|Full	|	|DATETIMESTAMP	|N	|	|	|	|0	|	|True	|False~
FLD	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|P2K_EmployeeEducation	|DEGREECODE	|DEGREE-CERTIFICATED	|DEGREECODE	|	|1440	|Y	|N	|0	|1	|P2K_DEGREE	|1	|50	|0	|0	|Full	|	|DEGREE-CERTIFICATED	|N	|	|	|	|0	|	|True	|False~
FLD	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|P2K_EmployeeEducation	|DISTRICTNUMBER	|DISTRICTNUMBER	|DISTRICTNUMBER	|	|1440	|N	|N	|0	|1	|	|1	|2	|0	|0	|Full	|	|DISTRICTNUMBER	|N	|	|	|	|0	|	|True	|False~
FLD	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|P2K_EmployeeEducation	|EMPLOYEEID	|EMPLOYEEID	|EMPLOYEEID	|	|1440	|N	|N	|0	|1	|	|6	|4	|0	|0	|Full	|	|EMPLOYEEID	|N	|	|	|	|0	|	|True	|False~
FLD	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|P2K_EmployeeEducation	|GRADUATIONDATE	|DEGREE CONFERRED-CERTIFICATED	|GRADUATIONDATE	|	|1440	|Y	|N	|0	|1	|	|2	|8	|8	|0	|Full	|	|DEGREE CONFERRED-CERTIFICATED	|N	|	|	|	|0	|	|True	|False~
FLD	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|P2K_EmployeeEducation	|ID	|ID	|ID	|	|1440	|N	|N	|0	|1	|	|6	|4	|0	|0	|Full	|	|ID	|N	|	|	|	|0	|	|True	|False~
FLD	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|P2K_EmployeeEducation	|INSTITUTIONCODE	|COLLEGE/UNIVERSITY-CERTIFICATED	|INSTITUTIONCODE	|	|1440	|Y	|N	|0	|1	|P2K_INSTITUTION	|1	|50	|0	|0	|Full	|	|COLLEGE/UNIVERSITY-CERTIFICATED	|N	|	|	|	|0	|	|True	|False~
FLD	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|P2K_EmployeeEducation	|MAJORDESC	|MAJOR-CERTIFICATED	|MAJORDESC	|	|1440	|Y	|N	|0	|1	|	|1	|50	|0	|0	|Full	|	|MAJOR-CERTIFICATED	|N	|	|	|	|0	|	|True	|False~
FLD	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|P2K_EmployeeEducation	|MINORDESC	|MINOR-CERTIFICATED	|MINORDESC	|	|1440	|Y	|N	|0	|1	|	|1	|50	|0	|0	|Full	|	|MINOR-CERTIFICATED	|N	|	|	|	|0	|	|True	|False~
FLD	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|P2K_EmployeeInService	|COURSEDATE	|COURSE DATE-CERTIFICATED	|COURSEDATE	|	|1440	|Y	|N	|0	|1	|	|2	|8	|8	|0	|Full	|	|COURSE DATE-CERTIFICATED	|N	|	|	|	|0	|	|True	|False~
FLD	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|P2K_EmployeeInService	|COURSENUMBER	|COURSE NUMBER-CERTIFICATED	|COURSENUMBER	|	|1440	|Y	|N	|0	|1	|	|1	|10	|0	|0	|Full	|	|COURSE NUMBER-CERTIFICATED	|N	|	|	|	|0	|	|True	|False~
FLD	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|P2K_EmployeeInService	|COURSETITLE	|COURSE TITLE-CERTIFICATED	|COURSETITLE	|	|1440	|Y	|N	|0	|1	|	|1	|255	|0	|0	|Full	|	|COURSE TITLE-CERTIFICATED	|N	|	|	|	|0	|	|True	|False~
FLD	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|P2K_EmployeeInService	|DATETIMESTAMP	|DATETIMESTAMP	|DATETIMESTAMP	|	|1440	|N	|N	|0	|1	|	|1	|14	|0	|0	|Full	|	|DATETIMESTAMP	|N	|	|	|	|0	|	|True	|False~
FLD	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|P2K_EmployeeInService	|DISTRICTNUMBER	|DISTRICTNUMBER	|DISTRICTNUMBER	|	|1440	|N	|N	|0	|1	|	|1	|2	|0	|0	|Full	|	|DISTRICTNUMBER	|N	|	|	|	|0	|	|True	|False~
FLD	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|P2K_EmployeeInService	|EMPLOYEEID	|EMPLOYEEID	|EMPLOYEEID	|	|1440	|N	|N	|0	|1	|	|6	|4	|0	|0	|Full	|	|EMPLOYEEID	|N	|	|	|	|0	|	|True	|False~
FLD	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|P2K_EmployeeInService	|HOURUNITS	|HOURS-CERTIFICATED	|HOURUNITS	|	|1440	|Y	|N	|0	|1	|	|4	|8	|16	|0	|Full	|	|HOURS-CERTIFICATED	|N	|	|	|	|0	|	|True	|False~
FLD	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|P2K_EmployeeInService	|ID	|ID	|ID	|	|1440	|N	|N	|0	|1	|	|6	|4	|0	|0	|Full	|	|ID	|N	|	|	|	|0	|	|True	|False~
FLD	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|P2K_EmployeeInService	|INSTITUTIONCODE	|COLLEGE/UNIVERSITY-CERT UNITS	|INSTITUTIONCODE	|	|1440	|Y	|N	|0	|1	|P2K_INSTITUTION	|1	|50	|0	|0	|Full	|	|COLLEGE/UNIVERSITY-CERT UNITS	|N	|	|	|	|0	|	|True	|False~
FLD	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|P2K_EmployeeInService	|MASTERSCREDITS	|MASTERS COLUMN-CERTIFICATED	|MASTERSCREDITS	|	|1440	|Y	|N	|0	|1	|	|1	|1	|0	|0	|Full	|	|MASTERS COLUMN-CERTIFICATED	|N	|	|	|	|0	|	|True	|False~
FLD	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|P2K_EmployeeInService	|QUARTERUNITS	|QUARTER-CERTIFICATED	|QUARTERUNITS	|	|1440	|Y	|N	|0	|1	|	|4	|8	|16	|0	|Full	|	|QUARTER-CERTIFICATED	|N	|	|	|	|0	|	|True	|False~
FLD	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|P2K_EmployeeInService	|SEMESTERUNITS	|SEMESTER-CERTIFICATED	|SEMESTERUNITS	|	|1440	|Y	|N	|0	|1	|	|4	|8	|16	|0	|Full	|	|SEMESTER-CERTIFICATED	|N	|	|	|	|0	|	|True	|False~
FLD	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|P2K_EmployeeMedCond	|DATETIMESTAMP	|DATE-MEDICAL CONDITION	|DATETIMESTAMP	|	|1440	|Y	|N	|0	|1	|	|1	|14	|8	|0	|Full	|	|DATE-MEDICAL CONDITION	|N	|	|	|	|0	|	|True	|False~
FLD	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|P2K_EmployeeMedCond	|DISTRICTNUMBER	|DISTRICTNUMBER	|DISTRICTNUMBER	|	|1440	|N	|N	|0	|1	|	|1	|2	|0	|0	|Full	|	|DISTRICTNUMBER	|N	|	|	|	|0	|	|True	|False~
FLD	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|P2K_EmployeeMedCond	|EMPLOYEEID	|EMPLOYEEID	|EMPLOYEEID	|	|1440	|N	|N	|0	|1	|	|6	|4	|0	|0	|Full	|	|EMPLOYEEID	|N	|	|	|	|0	|	|True	|False~
FLD	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|P2K_EmployeeMedCond	|ID	|ID	|ID	|	|1440	|N	|N	|0	|1	|	|6	|4	|0	|0	|Full	|	|ID	|N	|	|	|	|0	|	|True	|False~
FLD	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|P2K_EmployeeMedCond	|MEDCONDCODE	|MEDICAL CONDITION	|MEDCONDCODE	|	|1440	|Y	|N	|0	|1	|	|1	|50	|0	|0	|Full	|	|MEDICAL CONDITION	|N	|	|	|	|0	|	|True	|False~
FLD	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|P2K_EmployeeMedication	|DATETIMESTAMP	|MEDICATION DATE	|DATETIMESTAMP	|	|1440	|Y	|N	|0	|1	|	|1	|14	|8	|0	|Full	|	|MEDICATION DATE	|N	|	|	|	|0	|	|True	|False~
FLD	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|P2K_EmployeeMedication	|DISTRICTNUMBER	|DISTRICTNUMBER	|DISTRICTNUMBER	|	|1440	|N	|N	|0	|1	|	|1	|2	|0	|0	|Full	|	|DISTRICTNUMBER	|N	|	|	|	|0	|	|True	|False~
FLD	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|P2K_EmployeeMedication	|EMPLOYEEID	|EMPLOYEEID	|EMPLOYEEID	|	|1440	|N	|N	|0	|1	|	|6	|4	|0	|0	|Full	|	|EMPLOYEEID	|N	|	|	|	|0	|	|True	|False~
FLD	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|P2K_EmployeeMedication	|ID	|ID	|ID	|	|1440	|N	|N	|0	|1	|	|6	|4	|0	|0	|Full	|	|ID	|N	|	|	|	|0	|	|True	|False~
FLD	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|P2K_EmployeeMedication	|MEDICATIONCODE	|MEDICATION	|MEDICATIONCODE	|	|1440	|Y	|N	|0	|1	|	|1	|50	|0	|0	|Full	|	|MEDICATION	|N	|	|	|	|0	|	|True	|False~
FLD	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|P2K_EmployeeSkill	|AWARDDATE	|AWARD DATE-CERTIFICATED	|AWARDDATE	|	|1440	|Y	|N	|0	|1	|	|2	|8	|8	|0	|Full	|	|AWARD DATE-CERTIFICATED	|N	|	|	|	|0	|	|True	|False~
FLD	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|P2K_EmployeeSkill	|CERTIFICATIONNO	|CERTIFICATION NO.-CERTIFICATED	|CERTIFICATIONNO	|	|1440	|Y	|N	|0	|1	|	|1	|10	|0	|0	|Full	|	|CERTIFICATION NO.-CERTIFICATED	|N	|	|	|	|0	|	|True	|False~
FLD	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|P2K_EmployeeSkill	|DATETIMESTAMP	|DATETIMESTAMP	|DATETIMESTAMP	|	|1440	|N	|N	|0	|1	|	|1	|14	|0	|0	|Full	|	|DATETIMESTAMP	|N	|	|	|	|0	|	|True	|False~
FLD	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|P2K_EmployeeSkill	|DISTRICTNUMBER	|DISTRICTNUMBER	|DISTRICTNUMBER	|	|1440	|N	|N	|0	|1	|	|1	|2	|0	|0	|Full	|	|DISTRICTNUMBER	|N	|	|	|	|0	|	|True	|False~
FLD	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|P2K_EmployeeSkill	|EMPLOYEEID	|EMPLOYEEID	|EMPLOYEEID	|	|1440	|N	|N	|0	|1	|	|6	|4	|0	|0	|Full	|	|EMPLOYEEID	|N	|	|	|	|0	|	|True	|False~
FLD	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|P2K_EmployeeSkill	|EXPIRATIONDATE	|EXPIRATION DATE-CLASS SKILL	|EXPIRATIONDATE	|	|1440	|Y	|N	|0	|1	|	|2	|8	|8	|0	|Full	|	|EXPIRATION DATE-CLASS SKILL	|N	|	|	|	|0	|	|True	|False~
FLD	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|P2K_EmployeeSkill	|ID	|ID	|ID	|	|1440	|N	|N	|0	|1	|	|6	|4	|0	|0	|Full	|	|ID	|N	|	|	|	|0	|	|True	|False~
FLD	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|P2K_EmployeeSkill	|SKILL	|SKILL-CERTIFICATED	|SKILL	|	|1440	|Y	|N	|0	|1	|	|1	|255	|0	|0	|Full	|	|SKILL-CERTIFICATED	|N	|	|	|	|0	|	|True	|False~
FLD	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|P2K_ProfessionalGrowth	|ACCEPTED	|ACCEPTED	|ACCEPTED	|	|1440	|Y	|N	|0	|1	|	|1	|1	|0	|0	|Full	|	|ACCEPTED	|N	|	|	|	|0	|	|True	|False~
FLD	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|P2K_ProfessionalGrowth	|COMPLETIONDATE	|COMPLETION DATE-CLASSIFIED	|COMPLETIONDATE	|	|1440	|Y	|N	|0	|1	|	|2	|8	|8	|0	|Full	|	|COMPLETION DATE-CLASSIFIED	|N	|	|	|	|0	|	|True	|False~
FLD	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|P2K_ProfessionalGrowth	|COURSEDATE	|COURSE DATE-CLASSIFIED	|COURSEDATE	|	|1440	|Y	|N	|0	|1	|	|2	|8	|8	|0	|Full	|	|COURSE DATE-CLASSIFIED	|N	|	|	|	|0	|	|True	|False~
FLD	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|P2K_ProfessionalGrowth	|COURSENUMBER	|COURSE NO.-CLASSIFIED	|COURSENUMBER	|	|1440	|Y	|N	|0	|1	|	|1	|50	|0	|0	|Full	|	|COURSE NO.-CLASSIFIED	|N	|	|	|	|0	|	|True	|False~
FLD	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|P2K_ProfessionalGrowth	|COURSETITLE	|COURSE TITLE-CLASSIFIED	|COURSETITLE	|	|1440	|Y	|N	|0	|1	|	|1	|255	|0	|0	|Full	|	|COURSE TITLE-CLASSIFIED	|N	|	|	|	|0	|	|True	|False~
FLD	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|P2K_ProfessionalGrowth	|DATESUBMITTED	|SUBMITTED DATE-CLASSIFIED	|DATESUBMITTED	|	|1440	|Y	|N	|0	|1	|	|2	|8	|8	|0	|Full	|	|SUBMITTED DATE-CLASSIFIED	|N	|	|	|	|0	|	|True	|False~
FLD	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|P2K_ProfessionalGrowth	|DATETIMESTAMP	|DATETIMESTAMP	|DATETIMESTAMP	|	|1440	|N	|N	|0	|1	|	|1	|14	|0	|0	|Full	|	|DATETIMESTAMP	|N	|	|	|	|0	|	|True	|False~
FLD	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|P2K_ProfessionalGrowth	|DISTRICTNUMBER	|DISTRICTNUMBER	|DISTRICTNUMBER	|	|1440	|N	|N	|0	|1	|	|1	|2	|0	|0	|Full	|	|DISTRICTNUMBER	|N	|	|	|	|0	|	|True	|False~
FLD	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|P2K_ProfessionalGrowth	|EMPLOYEEID	|EMPLOYEEID	|EMPLOYEEID	|	|1440	|N	|N	|0	|1	|	|6	|4	|0	|0	|Full	|	|EMPLOYEEID	|N	|	|	|	|0	|	|True	|False~
FLD	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|P2K_ProfessionalGrowth	|HOURUNITS	|HOURS-CLASSIFIED	|HOURUNITS	|	|1440	|Y	|N	|0	|1	|	|4	|8	|16	|0	|Full	|	|HOURS-CLASSIFIED	|N	|	|	|	|0	|	|True	|False~
FLD	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|P2K_ProfessionalGrowth	|ID	|ID	|ID	|	|1440	|N	|N	|0	|1	|	|6	|4	|0	|0	|Full	|	|ID	|N	|	|	|	|0	|	|True	|False~
FLD	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|P2K_ProfessionalGrowth	|JOBRELATED	|JOB RELATED	|JOBRELATED	|	|1440	|Y	|N	|0	|1	|	|1	|1	|0	|0	|Full	|	|JOB RELATED	|N	|	|	|	|0	|	|True	|False~
FLD	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|P2K_ProfessionalGrowth	|QUARTERUNITS	|QUARTER-CLASSIFIED	|QUARTERUNITS	|	|1440	|Y	|N	|0	|1	|	|4	|8	|16	|0	|Full	|	|QUARTER-CLASSIFIED	|N	|	|	|	|0	|	|True	|False~
FLD	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|P2K_ProfessionalGrowth	|SEMESTERUNITS	|SEMESTER-CLASSIFIED	|SEMESTERUNITS	|	|1440	|Y	|N	|0	|1	|	|4	|8	|16	|0	|Full	|	|SEMESTER-CLASSIFIED	|N	|	|	|	|0	|	|True	|False~
FLD	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|P2K_ProfessionalGrowth	|VENUE	|INSTITUTION/CONFERENCE-CLASSIFIED	|VENUE	|	|1440	|Y	|N	|0	|1	|	|1	|255	|0	|0	|Full	|	|INSTITUTION/CONFERENCE-CLASSIFIED	|N	|	|	|	|0	|	|True	|False~
FLD	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|PositionFTE	|ALLOCATEDFTE	|ALLOCATEDFTE	|ALLOCATEDFTE	|	|1440	|Y	|N	|0	|1	|	|4	|8	|11	|2	|	|	|ALLOCATEDFTE	|N	|	|	|	|0	|	|True	|False~
FLD	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|PositionFTE	|DATETIMESTAMP	|DATETIMESTAMP	|DATETIMESTAMP	|	|1440	|N	|N	|0	|1	|	|1	|14	|0	|0	|	|	|DATETIMESTAMP	|N	|	|	|	|0	|	|True	|False~
FLD	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|PositionFTE	|DI_CODE	|DI CODE	|DI_CODE	|	|5040	|N	|N	|0	|1	|	|1	|52	|0	|0	|	|	|DI CODE	|N	|	|	|	|0	|	|True	|False~
FLD	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|PositionFTE	|DISTRICTNUMBER	|DISTRICTNUMBER	|DISTRICTNUMBER	|	|1440	|Y	|N	|0	|1	|	|1	|2	|0	|0	|	|	|DISTRICTNUMBER	|N	|	|	|	|0	|	|True	|False~
FLD	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|PositionFTE	|EFFDATE	|EFFDATE	|EFFDATE	|	|1440	|Y	|N	|0	|1	|	|2	|8	|8	|0	|	|	|EFFDATE	|N	|	|	|	|0	|	|True	|False~
FLD	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|PositionFTE	|ENDEFFDATE	|ENDEFFDATE	|ENDEFFDATE	|	|1440	|Y	|N	|0	|1	|	|2	|8	|8	|0	|	|	|ENDEFFDATE	|N	|	|	|	|0	|	|True	|False~
FLD	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|PositionFTE	|FISCALYEAR	|FISCALYEAR	|FISCALYEAR	|	|1440	|Y	|N	|0	|1	|	|1	|4	|0	|0	|	|	|FISCALYEAR	|N	|	|	|	|0	|	|True	|False~
FLD	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|PositionFTE	|ID	|ID	|ID	|	|1440	|N	|N	|0	|1	|	|6	|4	|0	|2	|	|	|ID	|N	|	|	|	|0	|	|True	|False~
FLD	|MAGIC-EMPLOYEE/POSITION	|Data Warehousing	|PositionFTE	|POSITIONCODE	|POSITIONCODE	|POSITIONCODE	|	|4752