E(0N&l0O&l8D&l88F(s16.66H&a9L&k2G PeopleSoft Report ID: XRFRCFL CROSS REFERENCE -- RECORDS AND FIELDS Page No. 1 Run Date 05/07/2001 Run Time 10:19:43 Record Name Field Name Long Field Name Type Length Format --------------- ------------------ ------------------------------ ---- ------ ------ ABSENCE_CAL ABS_MONTH_END_DT Absence Cal Month End Date Date 10 ABS_MONTH_START_DT Absence Cal Month Start Date Date 10 CALYEAR Year Nbr 4 MONTHCD Month Char 2 Upper ABSENCE_CAL_VW ABSENCE_TYPE Absence Type Char 3 Upper BEGIN_DT Begin Date Date 10 CALYEAR Year Nbr 4 EMPLID EmplID Char 11 Upper EMPL_RCD# Employment Rcd Nbr Nbr 3 MONTHCD Month Char 2 Upper RETURN_DT Return Date Date 10 ABSENCE_HIST ABSENCE_CODE Absence Code Char 3 Upper ABSENCE_TYPE Absence Type Char 3 Upper ABS_APPROVED_DT Date Approved Date 10 ABS_ENTRY_PANEL Absence Entry Panel Char 4 Mixed ABS_RECURRENCE Absence Recurrence Char 1 Upper BEGIN_DT Begin Date Date 10 BEGIN_TM Begin Time Time 15 BIRTH_DT Actual Birth Date Date 10 COUNSELLING Counselling Char 1 Upper DISCIPLINARY Disciplinary Char 1 Upper DOC_CONSULTED Doctor Consulted Char 1 Upper DOC_CONSULT_DT Consultation Date Date 10 DUE_DT Expected Birth Date Date 10 DURATION_DAYS Duration (Days) Nbr 3 DURATION_HOURS Duration (Hours) Nbr 4.1 EMPLID EmplID Char 11 Upper EMPLOYER_APPROVED Employer-Approved Char 1 Upper EMPL_RCD# Employment Rcd Nbr Nbr 3 INCIDENT_NBR Incident Number Char 8 Num INDUSTRIAL_INJURY Work Injury Related Char 1 Upper NOTIFIED_BY Notified of Absence By Whom Char 30 Mixed NOTIFIED_DT Date First Notified Date 10 NOTIFIED_TM Time First Notified Time 15 PAID_UNPAID Paid/Unpaid Char 1 Upper REASON Reason Char 30 Mixed REFER_TO_OHA Refer to Occ. Health Auth. Char 1 Upper RETURN_DT Return Date Date 10 RETURN_TM Return Time Time 15 ABSV_ACCRUAL ABSV_ACCRUAL_DT Accrual Process Date Date 10 ABSV_DYS_CARRYOVER Days Carried Over Sign 4.3 ABSV_DYS_EARN_YTD Days Earned YTD Sign 4.3 ABSV_DYS_TAKE_YTD Days Taken YTD Sign 4.3 BENEFIT_PLAN Benefit Plan Char 6 Upper COMPANY Company Char 3 Upper EMPLID EmplID Char 11 Upper EMPL_RCD# Employment Rcd Nbr Nbr 3 PLAN_TYPE Plan Type Char 2 Upper ABSV_ADDL_TBL ABSV_BONUS_DAYS Bonus Days Nbr 4.3 ABSV_SERVICE_INT Service Intervals Nbr 5 BENEFIT_PLAN Benefit Plan Char 6 Upper PLAN_TYPE Plan Type Char 2 Upper ABSV_PERIOD ABSV_CURR_END_DT Current Period End Date Date 10 ABSV_FUTURE_END_DT Future Period End Date Date 10 BENEFIT_PLAN Benefit Plan Char 6 Upper COMPANY Company Char 3 Upper PLAN_TYPE Plan Type Char 2 Upper ABSV_PLANS_VW LANGUAGE_CD Language Code Char 3 Upper PLAN_TYPE Plan Type Char 2 Upper XLATLONGNAME Translate Long Name Char 30 Mixed ABSV_PLAN_TBL ABSV_ACCRUAL_FREQ Accrual Frequency Char 1 Upper ABSV_MAX_BALANCE Maximum Leave Balance Nbr 5.3 PeopleSoft Report ID: XRFRCFL CROSS REFERENCE -- RECORDS AND FIELDS Page No. 2 Run Date 05/07/2001 Run Time 10:19:43 Record Name Field Name Long Field Name Type Length Format --------------- ------------------ ------------------------------ ---- ------ ------ ABSV_PLAN_TBL ABSV_MAX_CARRYOVER Maximum Leave Carryover Nbr 5.3 ABSV_RATE_FLG Entitlement Flag Char 1 Upper BENEFIT_PLAN Benefit Plan Char 6 Upper PLAN_TYPE Plan Type Char 2 Upper ABSV_RATE_TBL ABSV_DAYS_EARNED Days Earned Nbr 4.3 ABSV_SERVICE_INT Service Intervals Nbr 5 BENEFIT_PLAN Benefit Plan Char 6 Upper PLAN_TYPE Plan Type Char 2 Upper ABSV_REQUEST ABSENCE_TYPE Absence Type Char 3 Upper ABSV_ACCRUAL_DT Accrual Process Date Date 10 ABSV_APPROVED_BY Request Approved By Char 11 Upper ABSV_APPROVED_DT Date Approved Date 10 ABSV_APPROVED_FLG Approved Char 1 Upper ABSV_REQUEST_DT Request Date Date 10 BEGIN_DT Begin Date Date 10 COMPANY Company Char 3 Upper DURATION_DAYS Duration (Days) Nbr 3 EMPLID EmplID Char 11 Upper EMPL_RCD# Employment Rcd Nbr Nbr 3 PLAN_TYPE Plan Type Char 2 Upper RETURN_DT Return Date Date 10 ABSV_RUNCTL ABSV_CURR_END_DT Current Period End Date Date 10 ABSV_FUTURE_END_DT Future Period End Date Date 10 ABSV_REVERSE_FLG Move back one period Char 1 Upper BENEFIT_PLAN Benefit Plan Char 6 Upper COMPANY Company Char 3 Upper OPRID Operator Id Char 8 Mixed PLAN_TYPE Plan Type Char 2 Upper RUN_CNTL_ID Run Control ID Char 30 Mixed ABSW_HOL_VW BEGIN_DT Begin Date Date 10 EMPLID EmplID Char 11 Upper EMPL_RCD# Employment Rcd Nbr Nbr 3 HOLIDAY Holiday Date 10 ABSW_SCHD_DET ABSW_SCHD_ID Work Schedule Char 10 Upper ABSW_SEQ_NO Sequence Number Nbr 2 ABSW_TMPL_ID Work Template Char 10 Upper ABSW_SCHD_TBL ABSW_SCHD_ID Work Schedule Char 10 Upper BEGIN_DT Begin Date Date 10 DESCR50 Description Char 50 Mixed ABSW_SCHD_VW ABSW_DAY_NO Day Number Nbr 2 ABSW_SCHD_ID Work Schedule Char 10 Upper ABSW_SEQ_NO Sequence Number Nbr 2 ABSW_TMPL_ID Work Template Char 10 Upper BEGIN_DT Begin Date Date 10 DURATION_HOURS Duration (Hours) Nbr 4.1 EMPLID EmplID Char 11 Upper EMPL_RCD# Employment Rcd Nbr Nbr 3 END_TIME Interview End Time Time 15 START_TIME Interview Start Time Time 15 ABSW_SCHEDULE ABSW_SCHD_ID Work Schedule Char 10 Upper BEGIN_DT Begin Date Date 10 EMPLID EmplID Char 11 Upper EMPL_RCD# Employment Rcd Nbr Nbr 3 END_DT End Date Date 10 HOLIDAY_SCHEDULE Holiday Schedule Char 4 Upper ABSW_S_TBL_LANG ABSW_SCHD_ID Work Schedule Char 10 Upper DESCR50 Description Char 50 Mixed LANGUAGE_CD Language Code Char 3 Upper ABSW_TMPL_DET ABSW_DAY_NO Day Number Nbr 2 PeopleSoft Report ID: XRFRCFL CROSS REFERENCE -- RECORDS AND FIELDS Page No. 3 Run Date 05/07/2001 Run Time 10:19:43 Record Name Field Name Long Field Name Type Length Format --------------- ------------------ ------------------------------ ---- ------ ------ ABSW_TMPL_DET ABSW_TMPL_ID Work Template Char 10 Upper DESCR Description Char 30 Mixed DURATION_HOURS Duration (Hours) Nbr 4.1 END_TIME Interview End Time Time 15 START_TIME Interview Start Time Time 15 ABSW_TMPL_TBL ABSW_TMPL_ID Work Template Char 10 Upper DESCR50 Description Char 50 Mixed ABSW_T_DET_LANG ABSW_DAY_NO Day Number Nbr 2 ABSW_TMPL_ID Work Template Char 10 Upper DESCR Description Char 30 Mixed LANGUAGE_CD Language Code Char 3 Upper START_TIME Interview Start Time Time 15 ABSW_T_TBL_LANG ABSW_TMPL_ID Work Template Char 10 Upper DESCR50 Description Char 50 Mixed LANGUAGE_CD Language Code Char 3 Upper ABS_BEGIN_DT_VW BEGIN_DT Begin Date Date 10 EMPLID EmplID Char 11 Upper ORIG_EMPL_RCD_BEL Employment Record Nbr Nbr 3 ABS_CD_TBL_LANG ABSENCE_CODE Absence Code Char 3 Upper ABSENCE_TYPE Absence Type Char 3 Upper DESCR Description Char 30 Mixed DESCRSHORT Short Description Char 10 Mixed LANGUAGE_CD Language Code Char 3 Upper SETID SetID Char 5 Upper ABS_CLASS_TBL ABSENCE_CLASS Absence Class Char 4 Upper DESCR Description Char 30 Mixed DESCRSHORT Short Description Char 10 Mixed SETID SetID Char 5 Upper ABS_CL_TBL_LANG ABSENCE_CLASS Absence Class Char 4 Upper DESCR Description Char 30 Mixed DESCRSHORT Short Description Char 10 Mixed LANGUAGE_CD Language Code Char 3 Upper SETID SetID Char 5 Upper ABS_CODE_TBL ABSENCE_CODE Absence Code Char 3 Upper ABSENCE_TYPE Absence Type Char 3 Upper DESCR Description Char 30 Mixed DESCRSHORT Short Description Char 10 Mixed SETID SetID Char 5 Upper ABS_DEPT2_VW ABSENCE_TYPE Absence Type Char 3 Upper ACCESS_CD Access Code Char 1 Upper BEGIN_DT Begin Date Date 10 DEPTID Department Char 10 Upper EMPLID EmplID Char 11 Upper EMPL_RCD# Employment Rcd Nbr Nbr 3 OPRCLASS Operator Class Char 8 Upper RETURN_DT Return Date Date 10 SETID SetID Char 5 Upper ABS_EMPL_RCD_VW EMPLID EmplID Char 11 Upper EMPL_RCD# Employment Rcd Nbr Nbr 3 ABS_HIST_BELSBR ORIG_ABS_TYPE_BEL Original Absence Type Char 3 Upper ORIG_BEGIN_DT_BEL Start Date Date 10 ORIG_EMPL_RCD_BEL Employment Record Nbr Nbr 3 ABS_HIST_CERT ABSENCE_TYPE Absence Type Char 3 Upper BEGIN_DT Begin Date Date 10 CERT_TYPE Certificate Type Char 1 Upper CERT_VALID_FROM_DT Certificate Valid From Date 10 CERT_VALID_TO_DT Certificate Valid To Date 10 PeopleSoft Report ID: XRFRCFL CROSS REFERENCE -- RECORDS AND FIELDS Page No. 4 Run Date 05/07/2001 Run Time 10:19:43 Record Name Field Name Long Field Name Type Length Format --------------- ------------------ ------------------------------ ---- ------ ------ ABS_HIST_CERT EMPLID EmplID Char 11 Upper EMPL_RCD# Employment Rcd Nbr Nbr 3 RECEIVED_DT Certificate Received Date Date 10 ABS_HIST_DET ABSENCE_TYPE Absence Type Char 3 Upper BEGIN_DT Begin Date Date 10 COMMENTS Comments Long 0 COMMENT_DT Comment Date Date 10 EMPLID EmplID Char 11 Upper EMPL_RCD# Employment Rcd Nbr Nbr 3 ABS_HIST_GERSBR PROT_END_DT_GER Protection Period End Date Date 10 PROT_START_DT_GER Protection Period Start Date Date 10 ABS_HIST_LANG ABSENCE_TYPE Absence Type Char 3 Upper BEGIN_DT Begin Date Date 10 EMPLID EmplID Char 11 Upper EMPL_RCD# Employment Rcd Nbr Nbr 3 LANGUAGE_CD Language Code Char 3 Upper NOTIFIED_BY Notified of Absence By Whom Char 30 Mixed REASON Reason Char 30 Mixed ABS_HIST_NLDSBR WAO_DATE_NLD WAO Date Date 10 WAO_PERCENT_NLD WAO Percentage Nbr 3 ABS_HIST_UK_SBR AWC_DT Actual Week of Confinement Date 10 ELIGIBLE Eligible Char 1 Upper ELIG_EXT_LEAVE Eligible for Extended Leave Char 1 Upper EWC_DT Expected Week of Confinement Date 10 EXP_ML_END_DT Expected End of Leave Date 10 MATB1_RECEIVED_DT Form MATB1 Received Date 10 MPP_EARLIEST_DT Earliest Start of MPP Date 10 MPP_EXPECTED_END Expected End of MPP Date 10 MPP_START_DT MPP Actual Start Date Date 10 NOTIFIED_RETURN_DT Notified Return Date Date 10 NOTIF_MLSTART_DT Date Notified of Actual Start Date 10 QW_DT Qualifying Week Date 10 RTN_CONF_RECVD_DT Confirmation Received Date 10 RTN_WRK_REMIND_DT Date Return Reminder Sent Date 10 SMP_ELIGIBLE Eligible for Maternity Pay Char 1 Upper ABS_H_DET_LANG ABSENCE_TYPE Absence Type Char 3 Upper BEGIN_DT Begin Date Date 10 COMMENTS Comments Long 0 COMMENT_DT Comment Date Date 10 EMPLID EmplID Char 11 Upper EMPL_RCD# Employment Rcd Nbr Nbr 3 LANGUAGE_CD Language Code Char 3 Upper ABS_H_D_NLDSBR ILL_PERCENT_NLD Percentage Ill Nbr 3 SAME_ADDRESS_EMPL Same Address/Phone as Employee Char 1 Upper THERAPY_HOURS_NLD Therapy Hours Nbr 2.1 ABS_IMAGE_01_VW ABSENCE_IMAGE_01 Absence Image 01 Img 0 ABSENCE_TYPE_01 Absence Type Field 01 Char 3 Upper ABS_SETID_01 Absence Regulatory Country 01 Char 4 Upper ABS_IMAGE_02_VW ABSENCE_IMAGE_02 Absence Image 02 Img 0 ABSENCE_TYPE_02 Absence Type Field 02 Char 3 Upper ABS_SETID_02 Absence Regulatory Country 02 Char 4 Upper ABS_IMAGE_03_VW ABSENCE_IMAGE_03 Absence Image 03 Img 0 ABSENCE_TYPE_03 Absence Type Field 03 Char 3 Upper ABS_SETID_03 Absence Regulatory Country 03 Char 4 Upper ABS_IMAGE_04_VW ABSENCE_IMAGE_04 Absence Image 04 Img 0 ABSENCE_TYPE_04 Absence Type Field 04 Char 3 Upper ABS_SETID_04 Absence Regulatory Country 04 Char 4 Upper PeopleSoft Report ID: XRFRCFL CROSS REFERENCE -- RECORDS AND FIELDS Page No. 5 Run Date 05/07/2001 Run Time 10:19:43 Record Name Field Name Long Field Name Type Length Format --------------- ------------------ ------------------------------ ---- ------ ------ ABS_IMAGE_05_VW ABSENCE_IMAGE_05 Absence Image 05 Img 0 ABSENCE_TYPE_05 Absence Type Field 05 Char 3 Upper ABS_SETID_05 Absence Regulatory Country 05 Char 4 Upper ABS_IMAGE_06_VW ABSENCE_IMAGE_06 Absence Image 06 Img 0 ABSENCE_TYPE_06 Absence Type Field 06 Char 3 Upper ABS_SETID_06 Absence Regulatory Country 06 Char 4 Upper ABS_IMAGE_07_VW ABSENCE_IMAGE_07 Absence Image 07 Img 0 ABSENCE_TYPE_07 Absence Type Field 07 Char 3 Upper ABS_SETID_07 Absence Regulatory Country 07 Char 4 Upper ABS_IMAGE_08_VW ABSENCE_IMAGE_08 Absence Image 08 Img 0 ABSENCE_TYPE_08 Absence Type Field 08 Char 3 Upper ABS_SETID_08 Absence Regulatory Country 08 Char 4 Upper ABS_IMAGE_09_VW ABSENCE_IMAGE_09 Absence Image 09 Img 0 ABSENCE_TYPE_09 Absence Type Field 09 Char 3 Upper ABS_SETID_09 Absence Regulatory Country 09 Char 4 Upper ABS_IMAGE_10_VW ABSENCE_IMAGE_10 Absence Image 10 Img 0 ABSENCE_TYPE_10 Absence Type Field 10 Char 3 Upper ABS_SETID_10 Absence Regulatory Country 10 Char 4 Upper ABS_IMAGE_11_VW ABSENCE_IMAGE_11 Absence Image 11 Img 0 ABSENCE_TYPE_11 Absence Type Field 11 Char 3 Upper ABS_SETID_11 Absence Regulatory Country 11 Char 4 Upper ABS_IMAGE_12_VW ABSENCE_IMAGE_12 Absence Image 12 Img 0 ABSENCE_TYPE_12 Absence Type Field 12 Char 3 Upper ABS_SETID_12 Absence Regulatory Country 12 Char 4 Upper ABS_IMAGE_13_VW ABSENCE_IMAGE_13 Absence Image 13 Img 0 ABSENCE_TYPE_13 Absence Type Field 13 Char 3 Upper ABS_SETID_13 Absence Regulatory Country 13 Char 4 Upper ABS_IMAGE_14_VW ABSENCE_IMAGE_14 Absence Image 14 Img 0 ABSENCE_TYPE_14 Absence Type Field 14 Char 3 Upper ABS_SETID_14 Absence Regulatory Country 14 Char 4 Upper ABS_IMAGE_15_VW ABSENCE_IMAGE_15 Absence Image 15 Img 0 ABSENCE_TYPE_15 Absence Type Field 15 Char 3 Upper ABS_SETID_15 Absence Regulatory Country 15 Char 4 Upper ABS_IMAGE_16_VW ABSENCE_IMAGE_16 Absence Image 16 Img 0 ABSENCE_TYPE_16 Absence Type Field 16 Char 3 Upper ABS_SETID_16 Absence Regulatory Country 16 Char 4 Upper ABS_IMAGE_17_VW ABSENCE_IMAGE_17 Absence Image 17 Img 0 ABSENCE_TYPE_17 Absence Type Field 17 Char 3 Upper ABS_SETID_17 Absence Regulatory Country 17 Char 4 Upper ABS_IMAGE_18_VW ABSENCE_IMAGE_18 Absence Image 18 Img 0 ABSENCE_TYPE_18 Absence Type Field 18 Char 3 Upper ABS_SETID_18 Absence Regulatory Country 18 Char 4 Upper ABS_IMAGE_19_VW ABSENCE_IMAGE_19 Absence Image 19 Img 0 ABSENCE_TYPE_19 Absence Type Field 19 Char 3 Upper ABS_SETID_19 Absence Regulatory Country 19 Char 4 Upper ABS_IMAGE_20_VW ABSENCE_IMAGE_20 Absence Image 20 Img 0 ABSENCE_TYPE_20 Absence Type Field 20 Char 3 Upper ABS_SETID_20 Absence Regulatory Country 20 Char 4 Upper ABS_IMAGE_21_VW ABSENCE_IMAGE_21 Absence Image 21 Img 0 ABSENCE_TYPE_21 Absence Type Field 21 Char 3 Upper ABS_SETID_21 Absence Regulatory Country 21 Char 4 Upper ABS_IMAGE_22_VW ABSENCE_IMAGE_22 Absence Image 22 Img 0 PeopleSoft Report ID: XRFRCFL CROSS REFERENCE -- RECORDS AND FIELDS Page No. 6 Run Date 05/07/2001 Run Time 10:19:43 Record Name Field Name Long Field Name Type Length Format --------------- ------------------ ------------------------------ ---- ------ ------ ABS_IMAGE_22_VW ABSENCE_TYPE_22 Absence Type Field 22 Char 3 Upper ABS_SETID_22 Absence Regulatory Country 22 Char 4 Upper ABS_IMAGE_23_VW ABSENCE_IMAGE_23 Absence Image 23 Img 0 ABSENCE_TYPE_23 Absence Type Field 23 Char 3 Upper ABS_SETID_23 Absence Regulatory Country 23 Char 4 Upper ABS_IMAGE_24_VW ABSENCE_IMAGE_24 Absence Image 24 Img 0 ABSENCE_TYPE_24 Absence Type Field 24 Char 3 Upper ABS_SETID_24 Absence Regulatory Country 24 Char 4 Upper ABS_IMAGE_25_VW ABSENCE_IMAGE_25 Absence Image 25 Img 0 ABSENCE_TYPE_25 Absence Type Field 25 Char 3 Upper ABS_SETID_25 Absence Regulatory Country 25 Char 4 Upper ABS_IMAGE_26_VW ABSENCE_IMAGE_26 Absence Image 26 Img 0 ABSENCE_TYPE_26 Absence Type Field 26 Char 3 Upper ABS_SETID_26 Absence Regulatory Country 26 Char 4 Upper ABS_IMAGE_27_VW ABSENCE_IMAGE_27 Absence Image 27 Img 0 ABSENCE_TYPE_27 Absence Type Field 27 Char 3 Upper ABS_SETID_27 Absence Regulatory Country 27 Char 4 Upper ABS_IMAGE_28_VW ABSENCE_IMAGE_28 Absence Image 28 Img 0 ABSENCE_TYPE_28 Absence Type Field 28 Char 3 Upper ABS_SETID_28 Absence Regulatory Country 28 Char 4 Upper ABS_IMAGE_29_VW ABSENCE_IMAGE_29 Absence Image 29 Img 0 ABSENCE_TYPE_29 Absence Type Field 29 Char 3 Upper ABS_SETID_29 Absence Regulatory Country 29 Char 4 Upper ABS_IMAGE_30_VW ABSENCE_IMAGE_30 Absence Image 30 Img 0 ABSENCE_TYPE_30 Absence Type Field 30 Char 3 Upper ABS_SETID_30 Absence Regulatory Country 30 Char 4 Upper ABS_IMAGE_31_VW ABSENCE_IMAGE_31 Absence Image 31 Img 0 ABSENCE_TYPE_31 Absence Type Field 31 Char 3 Upper ABS_SETID_31 Absence Regulatory Country 31 Char 4 Upper ABS_IMAGE_32_VW ABSENCE_IMAGE_32 Absence Image 32 Img 0 ABSENCE_TYPE_32 Absence Type Field 32 Char 3 Upper ABS_SETID_32 Absence Regulatory Country 32 Char 4 Upper ABS_IMAGE_33_VW ABSENCE_IMAGE_33 Absence Image 33 Img 0 ABSENCE_TYPE_33 Absence Type Field 33 Char 3 Upper ABS_SETID_33 Absence Regulatory Country 33 Char 4 Upper ABS_IMAGE_34_VW ABSENCE_IMAGE_34 Absence Image 34 Img 0 ABSENCE_TYPE_34 Absence Type Field 34 Char 3 Upper ABS_SETID_34 Absence Regulatory Country 34 Char 4 Upper ABS_IMAGE_35_VW ABSENCE_IMAGE_35 Absence Image 35 Img 0 ABSENCE_TYPE_35 Absence Type Field 35 Char 3 Upper ABS_SETID_35 Absence Regulatory Country 35 Char 4 Upper ABS_IMAGE_36_VW ABSENCE_IMAGE_36 Absence Image 36 Img 0 ABSENCE_TYPE_36 Absence Type Field 36 Char 3 Upper ABS_SETID_36 Absence Regulatory Country 36 Char 4 Upper ABS_IMAGE_37_VW ABSENCE_IMAGE_37 Absence Image 37 Img 0 ABSENCE_TYPE_37 Absence Type Field 37 Char 3 Upper ABS_SETID_37 Absence Regulatory Country 37 Char 4 Upper ABS_IMAGE_38_VW ABSENCE_IMAGE_38 Absence Image 38 Img 0 ABSENCE_TYPE_38 Absence Type Field 38 Char 3 Upper ABS_SETID_38 Absence Regulatory Country 38 Char 4 Upper ABS_IMAGE_39_VW ABSENCE_IMAGE_39 Absence Image 39 Img 0 ABSENCE_TYPE_39 Absence Type Field 39 Char 3 Upper PeopleSoft Report ID: XRFRCFL CROSS REFERENCE -- RECORDS AND FIELDS Page No. 7 Run Date 05/07/2001 Run Time 10:19:43 Record Name Field Name Long Field Name Type Length Format --------------- ------------------ ------------------------------ ---- ------ ------ ABS_IMAGE_39_VW ABS_SETID_39 Absence Regulatory Country 39 Char 4 Upper ABS_IMAGE_40_VW ABSENCE_IMAGE_40 Absence Image 40 Img 0 ABSENCE_TYPE_40 Absence Type Field 40 Char 3 Upper ABS_SETID_40 Absence Regulatory Country 40 Char 4 Upper ABS_IMAGE_41_VW ABSENCE_IMAGE_41 Absence Image 41 Img 0 ABSENCE_TYPE_41 Absence Type Field 41 Char 3 Upper ABS_SETID_41 Absence Regulatory Country 41 Char 4 Upper ABS_IMAGE_42_VW ABSENCE_IMAGE_42 Absence Image 42 Img 0 ABSENCE_TYPE_42 Absence Type Field 42 Char 3 Upper ABS_SETID_42 Absence Regulatory Country 42 Char 4 Upper ABS_INJVW_LNG DT_REPORTED Date Reported Date 10 EMPLID EmplID Char 11 Upper EMPL_RCD# Employment Rcd Nbr Nbr 3 INCIDENT_DT Incident Date Date 10 INCIDENT_NBR Incident Number Char 8 Num LANGUAGE_CD Language Code Char 3 Upper LOCATION_NAME Location Name Char 30 Mixed NON_EMPLOYEE_ID Non-Employee ID Char 11 Num ABS_INJ_ILL_VW DT_REPORTED Date Reported Date 10 EMPLID EmplID Char 11 Upper EMPL_RCD# Employment Rcd Nbr Nbr 3 INCIDENT_DT Incident Date Date 10 INCIDENT_NBR Incident Number Char 8 Num LOCATION_NAME Location Name Char 30 Mixed NON_EMPLOYEE_ID Non-Employee ID Char 11 Num ABS_MT_SRCH_UK NATIONAL_ID Social Security No Char 15 CtSec NATIONAL_ID_TYPE National ID Type Char 4 Upper NID_COUNTRY National ID Country Char 3 Upper NID_DESCRSHORT NID Short Description Char 10 Upper STD_HOURS Standard Hours Nbr 2.2 ABS_PARAMETERS CONT_ABSENCE_IND Continuing Absence Indicator Char 1 Upper MULTI_ABSENCE_IND Multiple Absence Indicator Char 1 Upper ABS_PARAMETERS2 EMPL_CLASS Employee Classification Char 1 Upper ABS_PAR_NLDSBR AGE_CAT1_NLD Age Category 1 Nbr 2 AGE_CAT2_NLD Age Category 2 Nbr 2 AGE_CAT3_NLD Age Category 3 Nbr 2 AGE_CAT4_NLD Age Category 4 Nbr 2 AGE_CAT5_NLD Age Category 5 Nbr 2 AGE_CAT6_NLD Age Category 6 Nbr 2 AGE_CAT7_NLD Age Category 7 Nbr 2 AGE_CAT8_NLD Age Category 8 Nbr 2 ILL_LENG_CAT1_NLD Illness Length Category 1 Nbr 3 ILL_LENG_CAT2_NLD Illness Length Category 2 Nbr 3 ILL_LENG_CAT3_NLD Illness Length Category 3 Nbr 3 ILL_LENG_CAT4_NLD Illness Length Category 4 Nbr 3 ILL_LENG_CAT5_NLD Illness Length Category 5 Nbr 3 ILL_LENG_CAT6_NLD Illness Length Category 6 Nbr 3 ILL_LENG_CAT7_NLD Illness Length Category 7 Nbr 3 ILL_LENG_CAT8_NLD Illness Length Category 8 Nbr 3 ILL_LENG_TYP1_NLD Illness Length Type 1 Char 1 Num ILL_LENG_TYP2_NLD Illness Length Type 2 Char 1 Num ILL_LENG_TYP3_NLD Illness Length Type 3 Char 1 Num ILL_LENG_TYP4_NLD Illness Length Type 4 Char 1 Num ILL_LENG_TYP5_NLD Illness Length Type 5 Char 1 Num ILL_LENG_TYP6_NLD Illness Length Type 6 Char 1 Num ILL_LENG_TYP7_NLD Illness Length Type 7 Char 1 Num ILL_LENG_TYP8_NLD Illness Length Type 8 Char 1 Num IND_LV_NLD Indicator Longtime Illness Char 1 Upper IND_PV_NLD Indicator Partial Illness Char 1 Upper IND_ZV_NLD Indicator Maternity Illness Char 1 Upper PeopleSoft Report ID: XRFRCFL CROSS REFERENCE -- RECORDS AND FIELDS Page No. 8 Run Date 05/07/2001 Run Time 10:19:43 Record Name Field Name Long Field Name Type Length Format --------------- ------------------ ------------------------------ ---- ------ ------ ABS_PAR_UK_SBR BASIC_LEAVE_PERIOD Maternity Leave Period (Weeks) Nbr 2 CONT_EMPL_WEEKS Continuous Employment Weeks Nbr 2 EXTENDED_LEAVE_WKS Extended Leave Period Nbr 3 EXT_ELIG_FULLTIME Yrs F/T Service for Ext Leave Nbr 2 EXT_ELIG_PARTTIME Yrs P/T Service for Ext. Leave Nbr 2 MIN_NOTIFY_DAYS Minimum Notification Days Nbr 3 MPP_BEFORE_WEEKS MPP Before Weeks Nbr 2 QW_BEFORE_WEEKS Qualifying Week Before EWC Nbr 2 SMP_PAYABLE_WEEKS SMP Payable Weeks Nbr 2 ABS_STAT_NLD ABSENCE_TYPE Absence Type Char 3 Upper AGE_NLD Age Nbr 3 BEGIN_DT Begin Date Date 10 CREATION_DT Creation Date Date 10 DEPTID Department Char 10 Upper EMPLID EmplID Char 11 Upper EMPL_RCD# Employment Rcd Nbr Nbr 3 EMPL_RCD_ELI_NLD Number of Employments Excl LI Nbr 10.3 EMPL_RCD_ILI_NLD Number of Employments Incl LI Nbr 10.3 FTE_ELI_NLD Number of FTE's Excl LI Nbr 10.3 FTE_ILI_NLD Number of FTE's Incl LI Nbr 10.3 ILL_AVDAYS_ELI_NLD Available days Excl LI Nbr 10.3 ILL_AVDAYS_ILI_NLD Available days Incl LI Nbr 10.3 ILL_DAYEPI_ELI_NLD Days Ill Excl PI Excl LI Nbr 10.3 ILL_DAYEPI_ILI_NLD Days Ill Excl PI Incl LI Nbr 10.3 ILL_DAYIPI_ELI_NLD Days Ill Incl PI Excl LI Nbr 10.3 ILL_DAYIPI_ILI_NLD Days Ill Incl PI Excl LI Nbr 10.3 ILL_ENDEPI_ELI_NLD Ind Illn Ended Excl PI Excl LI Char 1 Upper ILL_ENDEPI_ILI_NLD Ind Illn Ended Excl PI Incl LI Char 1 Upper ILL_ENDIPI_ELI_NLD Ind Illn Ended Incl PI Excl LI Char 1 Upper ILL_ENDIPI_ILI_NLD Ind Illn Ended Incl PI Incl LI Char 1 Upper ILL_LENEPI_ELI_NLD Ill Leng Excl PI Excl LI Nbr 10.3 ILL_LENEPI_ILI_NLD Ill Leng Excl PI Incl LI Nbr 10.3 ILL_LENIPI_ELI_NLD Ill Leng Incl PI Excl LI Nbr 10.3 ILL_LENIPI_ILI_NLD Ill Leng Incl PI Incl LI Nbr 10.3 ILL_START_FULL_NLD Illness Started Fulltime Char 1 Upper ILL_START_PART_NLD Illness Start Partial Char 1 Upper NL_FROM_MONTH Month from Nbr 2 NL_FROM_YEAR Year from Nbr 4 SEX Gender Char 1 Upper ABS_SUMM_VW ABSENCE_TYPE Absence Type Char 3 Upper BEGIN_DT Begin Date Date 10 BEGIN_TM Begin Time Time 15 DURATION_DAYS Duration (Days) Nbr 3 DURATION_HOURS Duration (Hours) Nbr 4.1 EMPLID EmplID Char 11 Upper EMPL_RCD# Employment Rcd Nbr Nbr 3 REASON Reason Char 30 Mixed RETURN_DT Return Date Date 10 RETURN_TM Return Time Time 15 ABS_SUM_DEPT_VW ABSENCE_TYPE Absence Type Char 3 Upper BEGIN_DT Begin Date Date 10 DEPTID Department Char 10 Upper EMPLID EmplID Char 11 Upper EMPL_RCD# Employment Rcd Nbr Nbr 3 RETURN_DT Return Date Date 10 ABS_TYPE_BELSBR MAND_REPL_BEL Mandatory Replacement Char 1 Upper MAND_R_PERIOD_BEL Number of Months Nbr 3 PROLONG_PROB_BEL Prolongation Probation Char 1 Upper ABS_TYPE_PNL_VW ABSENCE_TYPE Absence Type Char 3 Upper ABS_ENTRY_PANEL Absence Entry Panel Char 4 Mixed DESCR Description Char 30 Mixed SETID SetID Char 5 Upper PeopleSoft Report ID: XRFRCFL CROSS REFERENCE -- RECORDS AND FIELDS Page No. 9 Run Date 05/07/2001 Run Time 10:19:43 Record Name Field Name Long Field Name Type Length Format --------------- ------------------ ------------------------------ ---- ------ ------ ABS_TYPE_TBL ABSENCE_CLASS Absence Class Char 4 Upper ABSENCE_IMAGE Absence Type Image Img 0 ABSENCE_TYPE Absence Type Char 3 Upper ABS_ENTRY_PANEL Absence Entry Panel Char 4 Mixed ABS_TRACK_INCIDENT Track Incident Number Char 1 Upper ABS_TRACK_MAT Track Maternity Dates Char 1 Upper CERT_PERIOD Certificate Period Nbr 2 CERT_PERIOD_TYPE Certificate Period Type Char 3 Upper CERT_REQUIRED Certificate Required Char 1 Upper DESCR Description Char 30 Mixed DESCRSHORT Short Description Char 10 Mixed PAID_UNPAID_IND Paid/Unpaid Indicator Char 2 Upper SETID SetID Char 5 Upper ABS_TYPE_VW ABSENCE_TYPE Absence Type Char 3 Upper DESCR Description Char 30 Mixed EMPLID EmplID Char 11 Upper ORIG_BEGIN_DT_BEL Start Date Date 10 ORIG_EMPL_RCD_BEL Employment Record Nbr Nbr 3 ORIG_SETID_BEL Original SetID Char 5 Upper ABS_TYPNLVW_LNG ABSENCE_TYPE Absence Type Char 3 Upper ABS_ENTRY_PANEL Absence Entry Panel Char 4 Mixed DESCR Description Char 30 Mixed LANGUAGE_CD Language Code Char 3 Upper SETID SetID Char 5 Upper ABS_TYPVW_LNG ABSENCE_TYPE Absence Type Char 3 Upper DESCR Description Char 30 Mixed EMPLID EmplID Char 11 Upper LANGUAGE_CD Language Code Char 3 Upper ORIG_BEGIN_DT_BEL Start Date Date 10 ORIG_EMPL_RCD_BEL Employment Record Nbr Nbr 3 SETID SetID Char 5 Upper ABS_TY_TBL_LANG ABSENCE_TYPE Absence Type Char 3 Upper DESCR Description Char 30 Mixed DESCRSHORT Short Description Char 10 Mixed LANGUAGE_CD Language Code Char 3 Upper SETID SetID Char 5 Upper ACCDNT_TYPE_LNG ACCIDENT_TYPE_CD Accident Type Char 5 Upper DESCR100 Description Char 100 Mixed DESCRSHORT Short Description Char 10 Mixed EFFDT Effective Date Date 10 LANGUAGE_CD Language Code Char 3 Upper SETID SetID Char 5 Upper ACCDNT_TYPE_TBL ACCIDENT_TYPE_CD Accident Type Char 5 Upper DESCR100 Description Char 100 Mixed DESCRSHORT Short Description Char 10 Mixed EFFDT Effective Date Date 10 EFF_STATUS Status as of Effective Date Char 1 Upper SETID SetID Char 5 Upper ACCDT_INS_HAZ ACCDT_HAZ_CLS Accident Ins. Hazard class Nbr 3.1 ACCIDENT_INS Accident Insurance Char 3 Upper DESCR100 Description Char 100 Mixed EFFDT Effective Date Date 10 HAZARD Hazard Char 4 Upper ACCDT_INS_HAZ_L ACCIDENT_INS Accident Insurance Char 3 Upper DESCR100 Description Char 100 Mixed EFFDT Effective Date Date 10 HAZARD Hazard Char 4 Upper LANGUAGE_CD Language Code Char 3 Upper ACCDT_INS_LANG ACCIDENT_INS Accident Insurance Char 3 Upper DESCR100 Description Char 100 Mixed PeopleSoft Report ID: XRFRCFL CROSS REFERENCE -- RECORDS AND FIELDS Page No. 10 Run Date 05/07/2001 Run Time 10:19:43 Record Name Field Name Long Field Name Type Length Format --------------- ------------------ ------------------------------ ---- ------ ------ ACCDT_INS_LANG DESCRSHORT Short Description Char 10 Mixed EFFDT Effective Date Date 10 LANGUAGE_CD Language Code Char 3 Upper ACCDT_INS_TBL ACCIDENT_INS Accident Insurance Char 3 Upper DESCR100 Description Char 100 Mixed DESCRSHORT Short Description Char 10 Mixed EFFDT Effective Date Date 10 EFF_STATUS Status as of Effective Date Char 1 Upper ACCESS_GRP_TBL ACCESS_GROUP Access Group Char 20 Upper DESCR Description Char 30 Mixed DESCRLONG Description Long 0 ACCOMPLISHMENTS ACCOMPLISHMENT Accomplishment Char 8 Upper DESCR Description Char 30 Mixed DT_ISSUED Issue Date Date 10 EMPLID EmplID Char 11 Upper MAJOR_CODE Major Code Char 10 Upper ORG Organization Char 30 Mixed ACCOMPLISHMT_VW ACCOMPLISHMENT Accomplishment Char 8 Upper ACCOMP_CATEGORY Accomplishment Category Char 3 Upper DESCR Description Char 30 Mixed DT_ISSUED Issue Date Date 10 EMPLID EmplID Char 11 Upper MAJOR_CODE Major Code Char 10 Upper ORG Organization Char 30 Mixed ACCOMPLISH_LANG ACCOMPLISHMENT Accomplishment Char 8 Upper DESCR Description Char 30 Mixed DT_ISSUED Issue Date Date 10 EDUCATOR Educator Char 50 Mixed EMPLID EmplID Char 11 Upper GRANTOR Grantor Char 20 Mixed ISSUED_BY Issued By Char 30 Mixed LANGUAGE_CD Language Code Char 3 Upper MAJOR Major Char 30 Mixed MAJOR_CODE Major Code Char 10 Upper MANDATE Mandate Char 15 Upper MANDATE_FUNCTION Mandate Position Char 15 Upper ORG Organization Char 30 Mixed SCHOOL School Name Char 30 Mixed ACCOMPLI_VW_LNG ACCOMPLISHMENT Accomplishment Char 8 Upper DESCR Description Char 30 Mixed DT_ISSUED Issue Date Date 10 EMPLID EmplID Char 11 Upper LANGUAGE_CD Language Code Char 3 Upper MAJOR_CODE Major Code Char 10 Upper ORG Organization Char 30 Mixed ACCOMPLVW_LNG ACCOMPLISHMENT Accomplishment Char 8 Upper DESCR Description Char 30 Mixed DT_ISSUED Issue Date Date 10 EDUCATOR Educator Char 50 Mixed EMPLID EmplID Char 11 Upper ISSUED_BY Issued By Char 30 Mixed LANGUAGE_CD Language Code Char 3 Upper MAJOR Major Char 30 Mixed MAJOR_CODE Major Code Char 10 Upper ORG Organization Char 30 Mixed SCHOOL School Name Char 30 Mixed ACCOMP_TBL ACCOMPLISHMENT Accomplishment Char 8 Upper ACCOMP_CATEGORY Accomplishment Category Char 3 Upper DESCR Description Char 30 Mixed DESCRSHORT Short Description Char 10 Mixed PeopleSoft Report ID: XRFRCFL CROSS REFERENCE -- RECORDS AND FIELDS Page No. 11 Run Date 05/07/2001 Run Time 10:19:43 Record Name Field Name Long Field Name Type Length Format --------------- ------------------ ------------------------------ ---- ------ ------ ACCOMP_TBL_LANG ACCOMPLISHMENT Accomplishment Char 8 Upper ACCOMP_CATEGORY Accomplishment Category Char 3 Upper DESCR Description Char 30 Mixed DESCRSHORT Short Description Char 10 Mixed LANGUAGE_CD Language Code Char 3 Upper NVQ_TITLE Title Char 90 Mixed ACCOM_DIAGNOSIS ACCOMMODATION_ID Accommodation ID Nbr 4 DIAGNOSIS_CD Diagnosis Code Char 6 Upper EMPLID EmplID Char 11 Upper EMPL_RCD# Employment Rcd Nbr Nbr 3 REG_REGION Regulatory Region Char 5 Upper ACCOM_JOB_TASK ACCOMMODATION_ID Accommodation ID Nbr 4 BUSINESS_UNIT Business Unit Char 5 Upper EMPLID EmplID Char 11 Upper EMPL_RCD# Employment Rcd Nbr Nbr 3 JOBCODE Job Code Char 6 Upper JOB_TASK Job Task Char 6 Upper LOCATION Location Code Char 10 Upper ACCOM_OPTION ACCOMMODATION_ID Accommodation ID Nbr 4 ACCOMMODATION_OPT Accommodation Options Nbr 3 ACCOMMODATION_TYPE Accommodation Type Char 6 Upper ACCOM_COST Cost of Accommodation Nbr 15.3 ACCOM_STATUS Accommodation Status Char 1 Upper CURRENCY_CD Currency Code Char 3 Upper DESCRLONG Description Long 0 EMPLID EmplID Char 11 Upper EMPLOYER_SUGGESTED Employer Suggested Option Char 1 Upper EMPL_RCD# Employment Rcd Nbr Nbr 3 STATUS_DT Status Date Date 10 ACCOM_OP_LNG ACCOMMODATION_ID Accommodation ID Nbr 4 ACCOMMODATION_OPT Accommodation Options Nbr 3 DESCRLONG Description Long 0 EMPLID EmplID Char 11 Upper EMPL_RCD# Employment Rcd Nbr Nbr 3 LANGUAGE_CD Language Code Char 3 Upper ACCOM_REQUEST ACCOMMODATION_ID Accommodation ID Nbr 4 COMMENTS Comments Long 0 DT_REQUESTED Date of Request Date 10 EMPLID EmplID Char 11 Upper EMPL_RCD# Employment Rcd Nbr Nbr 3 REQUEST_STATUS Request Status Char 1 Upper RESPONSIBLE_ID Responsible ID Char 11 Upper STATUS_DT Status Date Date 10 ACCOM_TYPE_LANG ACCOMMODATION_TYPE Accommodation Type Char 6 Upper DESCR Description Char 30 Mixed DESCRSHORT Short Description Char 10 Mixed EFFDT Effective Date Date 10 LANGUAGE_CD Language Code Char 3 Upper ACCOM_TYPE_TBL ACCOMMODATION_TYPE Accommodation Type Char 6 Upper DESCR Description Char 30 Mixed DESCRSHORT Short Description Char 10 Mixed EFFDT Effective Date Date 10 EFF_STATUS Status as of Effective Date Char 1 Upper ACCRUAL_RUNCTL ACCRUAL_PROC_DT Accrual Process Date Date 10 BENEFIT_PLAN Benefit Plan Char 6 Upper COMPANY Company Char 3 Upper OPRID Operator Id Char 8 Mixed PLAN_TYPE Plan Type Char 2 Upper RUN_CNTL_ID Run Control ID Char 30 Mixed ACCT_CD_LANG ACCT_CD Account Code Char 25 Upper PeopleSoft Report ID: XRFRCFL CROSS REFERENCE -- RECORDS AND FIELDS Page No. 12 Run Date 05/07/2001 Run Time 10:19:43 Record Name Field Name Long Field Name Type Length Format --------------- ------------------ ------------------------------ ---- ------ ------ ACCT_CD_LANG DESCR Description Char 30 Mixed DESCRSHORT Short Description Char 10 Mixed EFFDT Effective Date Date 10 LANGUAGE_CD Language Code Char 3 Upper ACCT_CD_TBL ACCOUNT Account Char 6 Upper ACCT_CD Account Code Char 25 Upper AFFILIATE Affiliate Char 5 Upper BUDGET_PERIOD Budget Period Char 8 Upper CLASS_FLD Class Field Char 5 Upper DEPTID Department Char 10 Upper DESCR Description Char 30 Mixed DESCRSHORT Short Description Char 10 Mixed DIRECT_CHARGE Direct Charge Char 1 Upper EFFDT Effective Date Date 10 EFF_STATUS Status as of Effective Date Char 1 Upper ENCUMB_ACCOUNT Encumbrance Account Char 6 Upper FUND_CODE Fund Code Char 5 Upper PRE_ENCUMB_ACCOUNT Pre-Encumbrance Account Char 6 Upper PROGRAM_CODE Program Code Char 5 Upper PROJECT_ID Project/Grant Char 15 Upper PRORATE_LIABILITY Prorate Liability Indicator Char 1 Upper SCENARIO Scenario Char 10 Upper SETID SetID Char 5 Upper ACCT_CD_TBL_LNG ACCT_CD Account Code Char 25 Upper DESCR Description Char 30 Mixed DESCRSHORT Short Description Char 10 Mixed EFFDT Effective Date Date 10 LANGUAGE_CD Language Code Char 3 Upper ACCT_CD_VW ACCOUNT Account Char 6 Upper ACCT_CD Account Code Char 25 Upper AFFILIATE Affiliate Char 5 Upper BUDGET_PERIOD Budget Period Char 8 Upper CLASS_FLD Class Field Char 5 Upper DEPTID Department Char 10 Upper DESCR Description Char 30 Mixed DESCRSHORT Short Description Char 10 Mixed DIRECT_CHARGE Direct Charge Char 1 Upper EFFDT Effective Date Date 10 EFF_STATUS Status as of Effective Date Char 1 Upper ENCUMB_ACCOUNT Encumbrance Account Char 6 Upper FUND_CODE Fund Code Char 5 Upper PRE_ENCUMB_ACCOUNT Pre-Encumbrance Account Char 6 Upper PROGRAM_CODE Program Code Char 5 Upper PROJECT_ID Project/Grant Char 15 Upper PRORATE_LIABILITY Prorate Liability Indicator Char 1 Upper SCENARIO Scenario Char 10 Upper SETID SetID Char 5 Upper ACCT_DED_VW ACCOUNT Account Char 6 Upper ACCT_CD_DED Account Code (Deductions) Char 25 Upper AFFILIATE Affiliate Char 5 Upper BUDGET_PERIOD Budget Period Char 8 Upper CLASS_FLD Class Field Char 5 Upper DEPTID Department Char 10 Upper DESCR Description Char 30 Mixed DESCRSHORT Short Description Char 10 Mixed DIRECT_CHARGE Direct Charge Char 1 Upper EFFDT Effective Date Date 10 EFF_STATUS Status as of Effective Date Char 1 Upper ENCUMB_ACCOUNT Encumbrance Account Char 6 Upper FUND_CODE Fund Code Char 5 Upper PRE_ENCUMB_ACCOUNT Pre-Encumbrance Account Char 6 Upper PROGRAM_CODE Program Code Char 5 Upper PROJECT_ID Project/Grant Char 15 Upper PRORATE_LIABILITY Prorate Liability Indicator Char 1 Upper SCENARIO Scenario Char 10 Upper PeopleSoft Report ID: XRFRCFL CROSS REFERENCE -- RECORDS AND FIELDS Page No. 13 Run Date 05/07/2001 Run Time 10:19:43 Record Name Field Name Long Field Name Type Length Format --------------- ------------------ ------------------------------ ---- ------ ------ ACCT_DED_VW SETID SetID Char 5 Upper ACCT_FMLY_ACCT ACCT_CD Account Code Char 25 Upper ACCT_FAMILY_CD Account Family Code Char 4 Upper EFFDT Effective Date Date 10 ACCT_FMLY_TBL ACCT_FAMILY_CD Account Family Code Char 4 Upper DESCR Description Char 30 Mixed DESCRSHORT Short Description Char 10 Mixed EFFDT Effective Date Date 10 EFF_STATUS Status as of Effective Date Char 1 Upper ACCT_FY_VW COMPANY Company Char 3 Upper FISCAL_YEAR Fiscal Year Nbr 4 ACCT_PERIOD_VW ACCOUNTING_PERIOD Accounting Period Nbr 3 BEGIN_DT Begin Date Date 10 COMPANY Company Char 3 Upper END_DT End Date Date 10 FISCAL_YEAR Fiscal Year Nbr 4 ACCT_TAX_VW ACCOUNT Account Char 6 Upper ACCT_CD_TAX Account Code (Tax) Char 25 Upper AFFILIATE Affiliate Char 5 Upper BUDGET_PERIOD Budget Period Char 8 Upper CLASS_FLD Class Field Char 5 Upper DEPTID Department Char 10 Upper DESCR Description Char 30 Mixed DESCRSHORT Short Description Char 10 Mixed DIRECT_CHARGE Direct Charge Char 1 Upper EFFDT Effective Date Date 10 EFF_STATUS Status as of Effective Date Char 1 Upper ENCUMB_ACCOUNT Encumbrance Account Char 6 Upper FUND_CODE Fund Code Char 5 Upper PRE_ENCUMB_ACCOUNT Pre-Encumbrance Account Char 6 Upper PROGRAM_CODE Program Code Char 5 Upper PROJECT_ID Project/Grant Char 15 Upper PRORATE_LIABILITY Prorate Liability Indicator Char 1 Upper SCENARIO Scenario Char 10 Upper SETID SetID Char 5 Upper ACCT_TYPE_TBL ACCOUNT_TYPE Account Type Char 1 Upper BALANCE_FWD_SW Balance Forward Char 1 Upper BUD_CONTROL_IND Budgetary Control Char 1 Upper DESCR Description Char 30 Mixed DESCRSHORT Short Description Char 10 Mixed SETID SetID Char 5 Upper ACCT_TYPE_VW DESCR Description Char 30 Mixed SETID SetID Char 5 Upper ACTION_SPVW_LNG ACTION Action Char 3 Upper DESCR Description Char 30 Mixed DESCRSHORT Short Description Char 10 Mixed EFFDT Effective Date Date 10 LANGUAGE_CD Language Code Char 3 Upper ACTION_SP_VW ACTION Action Char 3 Upper DESCR Description Char 30 Mixed DESCRSHORT Short Description Char 10 Mixed EFFDT Effective Date Date 10 ACTION_XLAT_VW ACTION Action Char 3 Upper DESCR Description Char 30 Mixed DESCRSHORT Short Description Char 10 Mixed EFFDT Effective Date Date 10 ACTN_DCNGVW_LNG ACTION Action Char 3 Upper ACTION_REASON Reason Code Char 3 Upper PeopleSoft Report ID: XRFRCFL CROSS REFERENCE -- RECORDS AND FIELDS Page No. 14 Run Date 05/07/2001 Run Time 10:19:43 Record Name Field Name Long Field Name Type Length Format --------------- ------------------ ------------------------------ ---- ------ ------ ACTN_DCNGVW_LNG DESCR50 Description Char 50 Mixed EFFDT Effective Date Date 10 LANGUAGE_CD Language Code Char 3 Upper WRKS_CNCL_DECISION Works Council Decision Char 3 Upper ACTN_DCN_GER_VW ACTION Action Char 3 Upper ACTION_REASON Reason Code Char 3 Upper DECISIONGRP_GER Works Council Decision Grp Char 3 Upper DESCR50 Description Char 50 Mixed EFFDT Effective Date Date 10 NOTIFY_MGR_SW_GER Notify HR Manager Char 1 Upper REASONS_REQ_GER Reasons Required Char 1 Upper WRKS_CNCL_DECISION Works Council Decision Char 3 Upper ACTN_REASON_TBL ACTION Action Char 3 Upper ACTION_REASON Reason Code Char 3 Upper BAS_ACTION Benefits Administration Action Char 3 Upper BEN_STATUS Benefits Employee Status Char 4 Upper COBRA_ACTION COBRA Action Char 3 Upper DESCR Description Char 30 Mixed DESCRSHORT Short Description Char 10 Mixed EFFDT Effective Date Date 10 EFF_STATUS Status as of Effective Date Char 1 Upper UH_ACTION_TRANS Action Char 3 Upper UH_TRANS_TYPE UH Trans Type Char 1 Upper ACTN_RSN_LANG ACTION Action Char 3 Upper ACTION_REASON Reason Code Char 3 Upper DESCR Description Char 30 Mixed DESCRSHORT Short Description Char 10 Mixed EFFDT Effective Date Date 10 LANGUAGE_CD Language Code Char 3 Upper ACTN_XLATVW_LNG ACTION Action Char 3 Upper DESCR Description Char 30 Mixed DESCRSHORT Short Description Char 10 Mixed EFFDT Effective Date Date 10 LANGUAGE_CD Language Code Char 3 Upper ACTRSN_CAN_SBR ROE_REASON Canadian ROE Reason Char 1 Upper ACTRSN_GER_SBR COMP_DR_APPR_GER Company Doctor's Approval Char 1 Upper DECISIONGRP_GER Works Council Decision Grp Char 3 Upper SPK_MAN_APPR_GER Spokesmen Committee Approval Char 1 Upper WRKS_CNCL_APPR_GER Works Council Approval Char 1 Upper ACTUALS_APPT_VW ACCT_CD Account Code Char 25 Upper DEPTID Department Char 10 Upper EMPLID EmplID Char 11 Upper EMPL_RCD# Employment Rcd Nbr Nbr 3 FISCAL_YEAR Fiscal Year Nbr 4 POSTED_ACTUAL_AMT Posted Actual Amount Sign 14.2 POSTED_ENCUMB_AMT Posted Encumbrance Amount Sign 14.2 POSTED_SUM_AMT Posted Total Amount Sign 15.2 SETID SetID Char 5 Upper ACTUALS_DEPT_VW ACCT_CD Account Code Char 25 Upper DEPTID Department Char 10 Upper FISCAL_YEAR Fiscal Year Nbr 4 POSTED_ACTUAL_AMT Posted Actual Amount Sign 14.2 POSTED_ENCUMB_AMT Posted Encumbrance Amount Sign 14.2 POSTED_SUM_AMT Posted Total Amount Sign 15.2 SETID SetID Char 5 Upper ACTUALS_JBCD_VW ACCT_CD Account Code Char 25 Upper DEPTID Department Char 10 Upper FISCAL_YEAR Fiscal Year Nbr 4 JOBCODE Job Code Char 6 Upper POSTED_ACTUAL_AMT Posted Actual Amount Sign 14.2 PeopleSoft Report ID: XRFRCFL CROSS REFERENCE -- RECORDS AND FIELDS Page No. 15 Run Date 05/07/2001 Run Time 10:19:43 Record Name Field Name Long Field Name Type Length Format --------------- ------------------ ------------------------------ ---- ------ ------ ACTUALS_JBCD_VW POSTED_ENCUMB_AMT Posted Encumbrance Amount Sign 14.2 POSTED_SUM_AMT Posted Total Amount Sign 15.2 SETID SetID Char 5 Upper SETID_JOBCODE Job Code SetID Char 5 Upper ACTUALS_POOL_VW ACCT_CD Account Code Char 25 Upper DEPTID Department Char 10 Upper FISCAL_YEAR Fiscal Year Nbr 4 POSITION_POOL_ID Position Pool ID Char 3 Upper POSTED_ACTUAL_AMT Posted Actual Amount Sign 14.2 POSTED_ENCUMB_AMT Posted Encumbrance Amount Sign 14.2 POSTED_SUM_AMT Posted Total Amount Sign 15.2 SETID SetID Char 5 Upper ACTUALS_POSN_VW ACCT_CD Account Code Char 25 Upper DEPTID Department Char 10 Upper FISCAL_YEAR Fiscal Year Nbr 4 POSITION_NBR Position Number Char 8 Upper POSTED_ACTUAL_AMT Posted Actual Amount Sign 14.2 POSTED_ENCUMB_AMT Posted Encumbrance Amount Sign 14.2 POSTED_SUM_AMT Posted Total Amount Sign 15.2 SETID SetID Char 5 Upper ACT_FML_TL_LNG ACCT_FAMILY_CD Account Family Code Char 4 Upper DESCR Description Char 30 Mixed DESCRSHORT Short Description Char 10 Mixed EFFDT Effective Date Date 10 LANGUAGE_CD Language Code Char 3 Upper ADDL_PAY_DATA ACCT_CD Account Code Char 25 Upper ADDLPAY_REASON Reason for Additional Pay Char 3 Upper ADDL_PAY_FREQUENCY Tax Frequency Char 1 Upper ADDL_PAY_SHIFT Additional Pay Shift Char 1 Upper ADDL_SEQ Additional Pay Sequence Number Nbr 2 BUSINESS_UNIT Business Unit Char 5 Upper COMP_RATECD Comp Rate Code Char 6 Upper DED_SUBSET_ID Deduction Subset Id Char 3 Upper DED_TAKEN Deductions Taken Char 1 Upper DEPTID Department Char 10 Upper DISABLE_DIR_DEP Disable Direct Deposit Char 1 Upper EARNINGS_END_DT Earnings End Date Date 10 EFFDT Effective Date Date 10 EMPLID EmplID Char 11 Upper EMPL_RCD# Employment Rcd Nbr Nbr 3 ERNCD Earnings Code Char 3 Upper GL_PAY_TYPE General Ledger Pay Type Char 6 Upper GOAL_AMT Goal Amount Sign 8.2 GOAL_BAL Current Goal Balance Sign 8.2 HOURLY_RT Hourly Rate Nbr 12.6 JOBCODE Job Code Char 6 Upper LOCALITY Locality Char 10 Upper OK_TO_PAY OK to Pay Char 1 Upper OTH_HRS Other Hours Sign 4.2 OTH_PAY Other Pay Sign 8.2 PAY_PERIOD1 First Pay Period Char 1 Upper PAY_PERIOD2 Second Pay Period Char 1 Upper PAY_PERIOD3 Third Pay Period Char 1 Upper PAY_PERIOD4 Fourth Pay Period Char 1 Upper PAY_PERIOD5 Fifth Pay Period Char 1 Upper PLAN_TYPE Plan Type Char 2 Upper POSITION_NBR Position Number Char 8 Upper PRORATE_ADDL_PAY Prorate Additional Pay Char 1 Upper PRORATE_CUI_WEEKS Prorate EI Weeks Char 1 Upper RECORD_SOURCE Record Source Char 1 Upper SEPCHK Separate Check # Nbr 1 STATE State Char 6 Upper TAX_METHOD Tax Method Char 1 Upper TAX_PERIODS Tax Periods Nbr 2 PeopleSoft Report ID: XRFRCFL CROSS REFERENCE -- RECORDS AND FIELDS Page No. 16 Run Date 05/07/2001 Run Time 10:19:43 Record Name Field Name Long Field Name Type Length Format --------------- ------------------ ------------------------------ ---- ------ ------ ADDL_PAY_EFFDT EFFDT Effective Date Date 10 EMPLID EmplID Char 11 Upper EMPL_RCD# Employment Rcd Nbr Nbr 3 ERNCD Earnings Code Char 3 Upper RECORD_SOURCE Record Source Char 1 Upper ADDL_PAY_ERNCD EMPLID EmplID Char 11 Upper EMPL_RCD# Employment Rcd Nbr Nbr 3 ERNCD Earnings Code Char 3 Upper RECORD_SOURCE Record Source Char 1 Upper ADDRESSES ADDRESS1_AC Alternate Character Address 1 Char 35 Mixed ADDRESS2_AC Alternate Character Address 2 Char 35 Mixed ADDRESS3_AC Alternate Character Address 3 Char 35 Mixed ADDRESS_TYPE Address Type Char 4 Upper CITY_AC Alternate Character City Char 30 Mixed EFFDT Effective Date Date 10 EFF_STATUS Status as of Effective Date Char 1 Upper EMPLID EmplID Char 11 Upper REG_REGION Regulatory Region Char 5 Upper ADDRESS_LNG_SBR ADDRESS1 Address Line 1 Char 35 Upper ADDRESS2 Address Line 2 Char 35 Upper ADDRESS3 Address Line 3 Char 35 Upper ADDRESS4 Address Line 4 Char 35 Upper CITY City Char 30 Upper COUNTY County Char 30 Mixed NUM1 Number 1 Char 6 Mixed NUM2 Number 2 Char 4 Mixed STATE State Char 6 Upper ADDRESS_SBR ADDRESS1 Address Line 1 Char 35 Upper ADDRESS2 Address Line 2 Char 35 Upper ADDRESS3 Address Line 3 Char 35 Upper ADDRESS4 Address Line 4 Char 35 Upper CITY City Char 30 Upper COUNTRY Country Char 3 Upper COUNTY County Char 30 Mixed GEO_CODE Tax Vendor Geographical Code Char 11 Upper HOUSE_TYPE House Type Char 2 Upper IN_CITY_LIMIT In City Limit Char 1 Upper NUM1 Number 1 Char 6 Mixed NUM2 Number 2 Char 4 Mixed POSTAL Postal Code Char 12 CtSec STATE State Char 6 Upper ADDRESS_TYPE ADDRESS_TYPE Address Type Char 4 Upper DESCR Description Char 30 Mixed EMPLID EmplID Char 11 Upper ADDR_JPN_WRK JPN_ADDR_LBL Furigana Char 1 Upper ADDR_OTR_SBR ADDRESS1_OTHER Address Line 1 Char 35 Upper ADDRESS2_OTHER Address Line 2 Char 35 Upper ADDRESS3_OTHER Address Line 3 Char 35 Upper ADDRESS4_OTHER Address Line 4 Char 35 Upper CITY_OTHER City - Other Char 30 Upper COUNTRY_OTHER Country - Other Char 3 Upper COUNTY_OTHER County - Other Char 30 Upper GEO_CODE_OTHER Geo Code Other Char 11 Upper HOUSE_TYPE_OTHER House Type Other Char 2 Upper IN_CITY_LMT_OTHER In City Limit Other Char 1 Upper NUM1_OTHER Number 1 Other Char 6 Mixed NUM2_OTHER Number 2 Other Char 4 Mixed POSTAL_OTHER Postal Code - Other Char 12 CtSec STATE_OTHER State - Other Char 6 Upper ADD_OTR_LNG_SBR ADDRESS1_OTHER Address Line 1 Char 35 Upper ADDRESS2_OTHER Address Line 2 Char 35 Upper PeopleSoft Report ID: XRFRCFL CROSS REFERENCE -- RECORDS AND FIELDS Page No. 17 Run Date 05/07/2001 Run Time 10:19:43 Record Name Field Name Long Field Name Type Length Format --------------- ------------------ ------------------------------ ---- ------ ------ ADD_OTR_LNG_SBR ADDRESS3_OTHER Address Line 3 Char 35 Upper ADDRESS4_OTHER Address Line 4 Char 35 Upper CITY_OTHER City - Other Char 30 Upper COUNTY_OTHER County - Other Char 30 Upper NUM1_OTHER Number 1 Other Char 6 Mixed NUM2_OTHER Number 2 Other Char 4 Mixed STATE_OTHER State - Other Char 6 Upper ADD_PAY_DTA_NLD ADDLPAY_REASON Reason for Additional Pay Char 3 Upper ADDL_SEQ Additional Pay Sequence Number Nbr 2 EARNINGS_END_DT Earnings End Date Date 10 EFFDT Effective Date Date 10 EMPLID EmplID Char 11 Upper EMPL_RCD# Employment Rcd Nbr Nbr 3 ERNCD Earnings Code Char 3 Upper GOAL_AMT Goal Amount Sign 8.2 HOURLY_RT Hourly Rate Nbr 12.6 OK_TO_PAY OK to Pay Char 1 Upper OTH_HRS Other Hours Sign 4.2 OTH_PAY Other Pay Sign 8.2 ADD_PAY_ERN_NLD EMPLID EmplID Char 11 Upper EMPL_RCD# Employment Rcd Nbr Nbr 3 ERNCD Earnings Code Char 3 Upper ADJ_ARR_BAL ADJ_MODE Adjustment Mode Char 1 Upper ADJ_REASON Adjustment Reason Char 50 Mixed ADJ_SUSPEND Suspend Adjustment Char 1 Upper ARREARS_BAL Arrears Balance Sign 8.2 ARR_ADJ Arrears Balance Adjustment Sign 8.2 BENEFIT_PLAN Benefit Plan Char 6 Upper COMPANY Company Char 3 Upper DEDCD Deduction Code Char 6 Upper DED_CLASS Deduction Classification Char 1 Upper EMPLID EmplID Char 11 Upper PLAN_TYPE Plan Type Char 2 Upper ADJ_CHK_BAL ADJ_MODE Adjustment Mode Char 1 Upper ADJ_REASON Adjustment Reason Char 50 Mixed ADJ_SUSPEND Suspend Adjustment Char 1 Upper BALANCE_ID Balance ID Char 2 Upper BALANCE_PERIOD Balances for Period Nbr 3 BALANCE_QTR Balances for Quarter Nbr 3 BALANCE_YEAR Balances for Year Nbr 4 COMPANY Company Char 3 Upper EMPLID EmplID Char 11 Upper NET_PAY_ADJ Net Pay Adjustment Sign 8.2 NET_PAY_YTD Net Pay YTD Sign 8.2 NET_PAY_YTD_ADJ Net Pay YTD Adjusted Sign 8.2 TOTAL_DEDNS_YTD Total Deductions YTD Sign 8.2 TOTAL_GROSS_YTD Total Gross YTD Sign 8.2 TOTAL_TAXES_YTD Total Taxes YTD Sign 8.2 TOT_DED_ADJ Total Deductions Adjustment Sign 8.2 TOT_DED_YTD_ADJ Total Deductions YTD Adjusted Sign 8.2 TOT_GRS_ADJ Total Gross Adjustment Sign 8.2 TOT_GRS_YTD_ADJ Total Gross YTD Adjusted Sign 8.2 TOT_TAX_ADJ Total Taxes Adjustment Sign 8.2 TOT_TAX_YTD_ADJ Total Taxes YTD Adjusted Sign 8.2 ADJ_CN_CHK_BAL ADJ_MODE Adjustment Mode Char 1 Upper ADJ_REASON Adjustment Reason Char 50 Mixed ADJ_SUSPEND Suspend Adjustment Char 1 Upper BALANCE_ID Balance ID Char 2 Upper BALANCE_PERIOD Balances for Period Nbr 3 BALANCE_QTR Balances for Quarter Nbr 3 BALANCE_YEAR Balances for Year Nbr 4 COMPANY Company Char 3 Upper EMPLID EmplID Char 11 Upper NET_PAY_ADJ Net Pay Adjustment Sign 8.2 PeopleSoft Report ID: XRFRCFL CROSS REFERENCE -- RECORDS AND FIELDS Page No. 18 Run Date 05/07/2001 Run Time 10:19:43 Record Name Field Name Long Field Name Type Length Format --------------- ------------------ ------------------------------ ---- ------ ------ ADJ_CN_CHK_BAL NET_PAY_YTD Net Pay YTD Sign 8.2 NET_PAY_YTD_ADJ Net Pay YTD Adjusted Sign 8.2 PROVINCE Province Char 6 Upper TOTAL_DEDNS_YTD Total Deductions YTD Sign 8.2 TOTAL_GROSS_YTD Total Gross YTD Sign 8.2 TOTAL_TAXES_YTD Total Taxes YTD Sign 8.2 TOT_DED_ADJ Total Deductions Adjustment Sign 8.2 TOT_DED_YTD_ADJ Total Deductions YTD Adjusted Sign 8.2 TOT_GRS_ADJ Total Gross Adjustment Sign 8.2 TOT_GRS_YTD_ADJ Total Gross YTD Adjusted Sign 8.2 TOT_TAX_ADJ Total Taxes Adjustment Sign 8.2 TOT_TAX_YTD_ADJ Total Taxes YTD Adjusted Sign 8.2 WAGE_LOSS_PLAN Wage Loss Replacement Plan Char 3 Upper ADJ_CN_DED_BAL ADJ_MODE Adjustment Mode Char 1 Upper ADJ_REASON Adjustment Reason Char 50 Mixed ADJ_SUSPEND Suspend Adjustment Char 1 Upper BALANCE_ID Balance ID Char 2 Upper BALANCE_PERIOD Balances for Period Nbr 3 BALANCE_QTR Balances for Quarter Nbr 3 BALANCE_YEAR Balances for Year Nbr 4 BENEFIT_PLAN Benefit Plan Char 6 Upper COMPANY Company Char 3 Upper DEDCD Deduction Code Char 6 Upper DED_ADJ Deduction Balance Adjustment Sign 8.2 DED_CLASS Deduction Classification Char 1 Upper DED_MTD Deduction Balance MTD Sign 8.2 DED_MTD_ADJ Deduction Balance MTD Adjusted Sign 8.2 DED_QTD Deduction Balance QTD Sign 8.2 DED_QTD_ADJ Deduction Balance QTD Adjusted Sign 8.2 DED_SLSTX_CLASS Sales Tax Type Char 1 Upper DED_YTD Deduction Balance YTD Sign 8.2 DED_YTD_ADJ Deduction Balance YTD Adjusted Sign 8.2 EMPLID EmplID Char 11 Upper PLAN_TYPE Plan Type Char 2 Upper PROVINCE Province Char 6 Upper WAGE_LOSS_PLAN Wage Loss Replacement Plan Char 3 Upper ADJ_CN_ERN_BAL ADJ_MODE Adjustment Mode Char 1 Upper ADJ_REASON Adjustment Reason Char 50 Mixed ADJ_SUSPEND Suspend Adjustment Char 1 Upper BALANCE_ID Balance ID Char 2 Upper BALANCE_PERIOD Balances for Period Nbr 3 BALANCE_QTR Balances for Quarter Nbr 3 BALANCE_YEAR Balances for Year Nbr 4 COMPANY Company Char 3 Upper EMPLID EmplID Char 11 Upper ERNCD Earnings Code Char 3 Upper GRS_ADJ Gross Earnings Adjustment Sign 8.2 GRS_MTD Gross Earnings MTD Sign 8.2 GRS_MTD_ADJ Gross Earnings MTD Adjusted Sign 8.2 GRS_QTD Gross Earnings QTD Sign 8.2 GRS_QTD_ADJ Gross Earnings QTD Adjusted Sign 8.2 GRS_YTD Gross Earnings YTD Sign 8.2 GRS_YTD_ADJ Gross Earnings YTD Adjusted Sign 8.2 HRS_ADJ Hours Adjustment Sign 4.2 HRS_MTD Hours Mtd Sign 4.2 HRS_MTD_ADJ Hours MTD Adjusted Sign 4.2 HRS_QTD Hours QTD Sign 4.2 HRS_QTD_ADJ Hours QTD Adjusted Sign 4.2 HRS_YTD Hours YTD Sign 4.2 HRS_YTD_ADJ Hours YTD Adjusted Sign 4.2 PROVINCE Province Char 6 Upper SPCL_BALANCE Special Balance Char 1 Upper WAGE_LOSS_PLAN Wage Loss Replacement Plan Char 3 Upper ADJ_CN_SPC_BAL ADJ_MODE Adjustment Mode Char 1 Upper ADJ_REASON Adjustment Reason Char 50 Mixed ADJ_SUSPEND Suspend Adjustment Char 1 Upper PeopleSoft Report ID: XRFRCFL CROSS REFERENCE -- RECORDS AND FIELDS Page No. 19 Run Date 05/07/2001 Run Time 10:19:43 Record Name Field Name Long Field Name Type Length Format --------------- ------------------ ------------------------------ ---- ------ ------ ADJ_CN_SPC_BAL BALANCE_ID Balance ID Char 2 Upper BALANCE_PERIOD Balances for Period Nbr 3 BALANCE_QTR Balances for Quarter Nbr 3 BALANCE_YEAR Balances for Year Nbr 4 COMPANY Company Char 3 Upper EMPLID EmplID Char 11 Upper ERNCD Earnings Code Char 3 Upper GRS_ADJ Gross Earnings Adjustment Sign 8.2 GRS_MTD Gross Earnings MTD Sign 8.2 GRS_MTD_ADJ Gross Earnings MTD Adjusted Sign 8.2 GRS_QTD Gross Earnings QTD Sign 8.2 GRS_QTD_ADJ Gross Earnings QTD Adjusted Sign 8.2 GRS_YTD Gross Earnings YTD Sign 8.2 GRS_YTD_ADJ Gross Earnings YTD Adjusted Sign 8.2 HRS_ADJ Hours Adjustment Sign 4.2 HRS_MTD Hours Mtd Sign 4.2 HRS_MTD_ADJ Hours MTD Adjusted Sign 4.2 HRS_QTD Hours QTD Sign 4.2 HRS_QTD_ADJ Hours QTD Adjusted Sign 4.2 HRS_YTD Hours YTD Sign 4.2 HRS_YTD_ADJ Hours YTD Adjusted Sign 4.2 PROVINCE Province Char 6 Upper SPCL_BALANCE Special Balance Char 1 Upper WAGE_LOSS_PLAN Wage Loss Replacement Plan Char 3 Upper ADJ_CN_TAX_BAL ADJ_MODE Adjustment Mode Char 1 Upper ADJ_REASON Adjustment Reason Char 50 Mixed ADJ_SUSPEND Suspend Adjustment Char 1 Upper BALANCE_ID Balance ID Char 2 Upper BALANCE_PERIOD Balances for Period Nbr 3 BALANCE_QTR Balances for Quarter Nbr 3 BALANCE_YEAR Balances for Year Nbr 4 COMPANY Company Char 3 Upper EMPLID EmplID Char 11 Upper NLGRS_ADJ No Limit Gross Adjustment Sign 8.2 NLGRS_MTD No Limit Gross MTD Sign 8.2 NLGRS_MTD_ADJ No Limit Gross MTD Adjusted Sign 8.2 NLGRS_QTD No Limit Gross QTD Sign 8.2 NLGRS_QTD_ADJ No Limit Gross QTD Adjusted Sign 8.2 NLGRS_YTD No Limit Gross YTD Sign 8.2 NLGRS_YTD_ADJ No Limit Gross YTD Adjusted Sign 8.2 PROVINCE Province Char 6 Upper TAX_ADJ Tax Adjustment Sign 8.2 TAX_CLASS_CAN Canadian Tax Type Char 3 Upper TAX_MTD Tax MTD Sign 8.2 TAX_MTD_ADJ Tax MTD Adjusted Sign 8.2 TAX_QTD Tax QTD Sign 8.2 TAX_QTD_ADJ Tax QTD Adjusted Sign 8.2 TAX_YTD Tax YTD Sign 8.2 TAX_YTD_ADJ Tax YTD Adjusted Sign 8.2 TXGRS_ADJ Taxable Gross Adjustment Sign 8.2 TXGRS_MTD Taxable Gross MTD Sign 8.2 TXGRS_MTD_ADJ Taxable Gross MTD Adjusted Sign 8.2 TXGRS_QTD Taxable Gross QTD Sign 8.2 TXGRS_QTD_ADJ Taxable Gross QTD Adjusted Sign 8.2 TXGRS_YTD Taxable Gross YTD Sign 8.2 TXGRS_YTD_ADJ Taxable Gross YTD Adjusted Sign 8.2 WAGE_LOSS_PLAN Wage Loss Replacement Plan Char 3 Upper ADJ_DED_BAL ADJ_MODE Adjustment Mode Char 1 Upper ADJ_REASON Adjustment Reason Char 50 Mixed ADJ_SUSPEND Suspend Adjustment Char 1 Upper BALANCE_ID Balance ID Char 2 Upper BALANCE_PERIOD Balances for Period Nbr 3 BALANCE_QTR Balances for Quarter Nbr 3 BALANCE_YEAR Balances for Year Nbr 4 BENEFIT_PLAN Benefit Plan Char 6 Upper COMPANY Company Char 3 Upper DEDCD Deduction Code Char 6 Upper PeopleSoft Report ID: XRFRCFL CROSS REFERENCE -- RECORDS AND FIELDS Page No. 20 Run Date 05/07/2001 Run Time 10:19:43 Record Name Field Name Long Field Name Type Length Format --------------- ------------------ ------------------------------ ---- ------ ------ ADJ_DED_BAL DED_ADJ Deduction Balance Adjustment Sign 8.2 DED_CLASS Deduction Classification Char 1 Upper DED_MTD Deduction Balance MTD Sign 8.2 DED_MTD_ADJ Deduction Balance MTD Adjusted Sign 8.2 DED_QTD Deduction Balance QTD Sign 8.2 DED_QTD_ADJ Deduction Balance QTD Adjusted Sign 8.2 DED_YTD Deduction Balance YTD Sign 8.2 DED_YTD_ADJ Deduction Balance YTD Adjusted Sign 8.2 EMPLID EmplID Char 11 Upper PLAN_TYPE Plan Type Char 2 Upper ADJ_ERN_BAL ADJ_MODE Adjustment Mode Char 1 Upper ADJ_REASON Adjustment Reason Char 50 Mixed ADJ_SUSPEND Suspend Adjustment Char 1 Upper BALANCE_ID Balance ID Char 2 Upper BALANCE_PERIOD Balances for Period Nbr 3 BALANCE_QTR Balances for Quarter Nbr 3 BALANCE_YEAR Balances for Year Nbr 4 COMPANY Company Char 3 Upper EMPLID EmplID Char 11 Upper ERNCD Earnings Code Char 3 Upper GRS_ADJ Gross Earnings Adjustment Sign 8.2 GRS_MTD Gross Earnings MTD Sign 8.2 GRS_MTD_ADJ Gross Earnings MTD Adjusted Sign 8.2 GRS_QTD Gross Earnings QTD Sign 8.2 GRS_QTD_ADJ Gross Earnings QTD Adjusted Sign 8.2 GRS_YTD Gross Earnings YTD Sign 8.2 GRS_YTD_ADJ Gross Earnings YTD Adjusted Sign 8.2 HRS_ADJ Hours Adjustment Sign 4.2 HRS_MTD Hours Mtd Sign 4.2 HRS_MTD_ADJ Hours MTD Adjusted Sign 4.2 HRS_QTD Hours QTD Sign 4.2 HRS_QTD_ADJ Hours QTD Adjusted Sign 4.2 HRS_YTD Hours YTD Sign 4.2 HRS_YTD_ADJ Hours YTD Adjusted Sign 4.2 SPCL_BALANCE Special Balance Char 1 Upper ADJ_GRN_BAL ADJ_MODE Adjustment Mode Char 1 Upper ADJ_REASON Adjustment Reason Char 50 Mixed ADJ_SUSPEND Suspend Adjustment Char 1 Upper BALANCE_ID Balance ID Char 2 Upper BALANCE_PERIOD Balances for Period Nbr 3 BALANCE_QTR Balances for Quarter Nbr 3 BALANCE_YEAR Balances for Year Nbr 4 BENEFIT_PLAN Benefit Plan Char 6 Upper COMPANY Company Char 3 Upper DEDCD Deduction Code Char 6 Upper DED_ADJ Deduction Balance Adjustment Sign 8.2 DED_CFEE_ADJ Ded Cpmny Fee Bal Adjustment Sign 8.2 DED_CFEE_MTD Ded Company Fee Balance MTD Sign 8.2 DED_CFEE_MTD_ADJ Ded Cmpny Fee Bal MTD Adjusted Sign 8.2 DED_CFEE_QTD Ded Company Fee Balance QTD Sign 8.2 DED_CFEE_QTD_ADJ Ded Cmpny Fee Bal QTD Adjusted Sign 8.2 DED_CFEE_YTD Ded Company Fee Balance YTD Sign 8.2 DED_CFEE_YTD_ADJ Ded Cmpny Fee Bal YTD Adjusted Sign 8.2 DED_CLASS Deduction Classification Char 1 Upper DED_GARN_ADJ Deduction Garn Bal Adjustment Sign 8.2 DED_GARN_MTD Deduction Garnish Balance MTD Sign 8.2 DED_GARN_MTD_ADJ Deduction Grn Bal MTD Adjusted Sign 8.2 DED_GARN_QTD Deduction Garnish Balance QTD Sign 8.2 DED_GARN_QTD_ADJ Deduction Grn Bal QTD Adjusted Sign 8.2 DED_GARN_YTD Deduction Garnish Balance YTD Sign 8.2 DED_GARN_YTD_ADJ Deduction Grn Bal YTD Adjusted Sign 8.2 DED_MTD Deduction Balance MTD Sign 8.2 DED_MTD_ADJ Deduction Balance MTD Adjusted Sign 8.2 DED_PFEE_ADJ Ded Payee Fee Bal Adjustment Sign 8.2 DED_PFEE_MTD Ded Payee Fee Balance MTD Sign 8.2 DED_PFEE_MTD_ADJ Ded Payee Fee Bal MTD Adjusted Sign 8.2 DED_PFEE_QTD Ded Payee Fee Balance QTD Sign 8.2 PeopleSoft Report ID: XRFRCFL CROSS REFERENCE -- RECORDS AND FIELDS Page No. 21 Run Date 05/07/2001 Run Time 10:19:43 Record Name Field Name Long Field Name Type Length Format --------------- ------------------ ------------------------------ ---- ------ ------ ADJ_GRN_BAL DED_PFEE_QTD_ADJ Ded Payee Fee Bal QTD Adjusted Sign 8.2 DED_PFEE_YTD Ded Payee Fee Balance YTD Sign 8.2 DED_PFEE_YTD_ADJ Ded Payee Fee Bal YTD Adjusted Sign 8.2 DED_QTD Deduction Balance QTD Sign 8.2 DED_QTD_ADJ Deduction Balance QTD Adjusted Sign 8.2 DED_YTD Deduction Balance YTD Sign 8.2 DED_YTD_ADJ Deduction Balance YTD Adjusted Sign 8.2 EMPLID EmplID Char 11 Upper GARNID Garnish ID Char 6 Upper PLAN_TYPE Plan Type Char 2 Upper ADJ_SPC_BAL ADJ_MODE Adjustment Mode Char 1 Upper ADJ_REASON Adjustment Reason Char 50 Mixed ADJ_SUSPEND Suspend Adjustment Char 1 Upper BALANCE_ID Balance ID Char 2 Upper BALANCE_PERIOD Balances for Period Nbr 3 BALANCE_QTR Balances for Quarter Nbr 3 BALANCE_YEAR Balances for Year Nbr 4 COMPANY Company Char 3 Upper EMPLID EmplID Char 11 Upper ERNCD Earnings Code Char 3 Upper GRS_ADJ Gross Earnings Adjustment Sign 8.2 GRS_MTD Gross Earnings MTD Sign 8.2 GRS_MTD_ADJ Gross Earnings MTD Adjusted Sign 8.2 GRS_QTD Gross Earnings QTD Sign 8.2 GRS_QTD_ADJ Gross Earnings QTD Adjusted Sign 8.2 GRS_YTD Gross Earnings YTD Sign 8.2 GRS_YTD_ADJ Gross Earnings YTD Adjusted Sign 8.2 HRS_ADJ Hours Adjustment Sign 4.2 HRS_MTD Hours Mtd Sign 4.2 HRS_MTD_ADJ Hours MTD Adjusted Sign 4.2 HRS_QTD Hours QTD Sign 4.2 HRS_QTD_ADJ Hours QTD Adjusted Sign 4.2 HRS_YTD Hours YTD Sign 4.2 HRS_YTD_ADJ Hours YTD Adjusted Sign 4.2 SPCL_BALANCE Special Balance Char 1 Upper ADJ_TAX1042_BAL ADJ_MODE Adjustment Mode Char 1 Upper ADJ_REASON Adjustment Reason Char 50 Mixed ADJ_SUSPEND Suspend Adjustment Char 1 Upper BALANCE_ID Balance ID Char 2 Upper BALANCE_PERIOD Balances for Period Nbr 3 BALANCE_QTR Balances for Quarter Nbr 3 BALANCE_YEAR Balances for Year Nbr 4 COMPANY Company Char 3 Upper COUNTRY Country Char 3 Upper EMPLID EmplID Char 11 Upper INCOME_CD_1042 Income Code (for 1042-S) Char 2 Num STATE State Char 6 Upper TAX_1042_ADJ Tax (1042) Adjustment Sign 8.2 TAX_1042_MTD Tax (1042) MTD Sign 8.2 TAX_1042_MTD_ADJ Tax (1042) MTD Adjusted Sign 8.2 TAX_1042_QTD Tax (1042) QTD Sign 8.2 TAX_1042_QTD_ADJ Tax (1042) QTD Adjusted Sign 8.2 TAX_1042_YTD Tax (1042) YTD Sign 8.2 TAX_1042_YTD_ADJ Tax (1042) YTD Adjusted Sign 8.2 TAX_RT Tax Rate Sign 0.6 TXGRS_1042_ADJ Taxable Gross(1042) Adjustment Sign 8.2 TXGRS_1042_MTD Taxable Gross (1042) MTD Sign 8.2 TXGRS_1042_MTD_ADJ Taxable Grs(1042) MTD Adjusted Sign 8.2 TXGRS_1042_QTD Taxable Gross (1042) QTD Sign 8.2 TXGRS_1042_QTD_ADJ Taxable Grs(1042) QTD Adjusted Sign 8.2 TXGRS_1042_YTD Taxable Gross (1042) YTD Sign 8.2 TXGRS_1042_YTD_ADJ Taxable Grs(1042) YTD Adjusted Sign 8.2 WH_ALLOW_ADJ WH Allowance Adjustment Sign 8.2 WH_ALLOW_MTD Withholding Allowances MTD Sign 8.2 WH_ALLOW_MTD_ADJ WH Allowance MTD Adjusted Sign 8.2 WH_ALLOW_QTD Withholding Allowance QTD Sign 8.2 WH_ALLOW_QTD_ADJ WH Allowance QTD Adjusted Sign 8.2 PeopleSoft Report ID: XRFRCFL CROSS REFERENCE -- RECORDS AND FIELDS Page No. 22 Run Date 05/07/2001 Run Time 10:19:43 Record Name Field Name Long Field Name Type Length Format --------------- ------------------ ------------------------------ ---- ------ ------ ADJ_TAX1042_BAL WH_ALLOW_YTD Withholding Allowance YTD Sign 8.2 WH_ALLOW_YTD_ADJ WH Allowance YTD Adjusted Sign 8.2 ADJ_TAX_BAL ADJ_MODE Adjustment Mode Char 1 Upper ADJ_REASON Adjustment Reason Char 50 Mixed ADJ_SUSPEND Suspend Adjustment Char 1 Upper BALANCE_ID Balance ID Char 2 Upper BALANCE_PERIOD Balances for Period Nbr 3 BALANCE_QTR Balances for Quarter Nbr 3 BALANCE_YEAR Balances for Year Nbr 4 COMPANY Company Char 3 Upper EMPLID EmplID Char 11 Upper LOCALITY Locality Char 10 Upper NLGRS_ADJ No Limit Gross Adjustment Sign 8.2 NLGRS_MTD No Limit Gross MTD Sign 8.2 NLGRS_MTD_ADJ No Limit Gross MTD Adjusted Sign 8.2 NLGRS_QTD No Limit Gross QTD Sign 8.2 NLGRS_QTD_ADJ No Limit Gross QTD Adjusted Sign 8.2 NLGRS_YTD No Limit Gross YTD Sign 8.2 NLGRS_YTD_ADJ No Limit Gross YTD Adjusted Sign 8.2 STATE State Char 6 Upper TAX_ADJ Tax Adjustment Sign 8.2 TAX_CLASS Tax Balance Class Char 1 Upper TAX_MTD Tax MTD Sign 8.2 TAX_MTD_ADJ Tax MTD Adjusted Sign 8.2 TAX_QTD Tax QTD Sign 8.2 TAX_QTD_ADJ Tax QTD Adjusted Sign 8.2 TAX_YTD Tax YTD Sign 8.2 TAX_YTD_ADJ Tax YTD Adjusted Sign 8.2 TIPS_ADJ Tip Adjustment Sign 8.2 TIPS_MTD MTD Taxable Tips Sign 8.2 TIPS_MTD_ADJ MTD Tips Adjusted Sign 8.2 TXGRS_ADJ Taxable Gross Adjustment Sign 8.2 TXGRS_MTD Taxable Gross MTD Sign 8.2 TXGRS_MTD_ADJ Taxable Gross MTD Adjusted Sign 8.2 TXGRS_QTD Taxable Gross QTD Sign 8.2 TXGRS_QTD_ADJ Taxable Gross QTD Adjusted Sign 8.2 TXGRS_YTD Taxable Gross YTD Sign 8.2 TXGRS_YTD_ADJ Taxable Gross YTD Adjusted Sign 8.2 ADJ_UI_BAL_CAN ADJ_MODE Adjustment Mode Char 1 Upper ADJ_REASON Adjustment Reason Char 50 Mixed ADJ_SUSPEND Suspend Adjustment Char 1 Upper CAN_WLP_TO Wage Loss Plan Char 3 Upper COMPANY Company Char 3 Upper EARNS_END_DT Earnings End Date Date 10 EARN_END_DT_TO Earnings End Date Date 10 EMPLID EmplID Char 11 Upper INS_EARNS_AMENDED Insurable Earnings Amended Char 1 Upper INS_EARNS_AMEND_TO Insurable Earnings Amended Char 1 Upper ROE# Record of Employment Number Char 8 Upper ROE_NO_TO Record of Employment Number Char 8 Upper UI_EARN_ADJ EI Earnings Adjustment Sign 8.2 UI_EARN_ADJ_TO EI Earnings Adjustment Sign 8.2 UI_HOURS_ADJ EI Hours Adjustment Sign 3.2 UI_HOURS_ADJ_TO EI Hours Adjustment Sign 3.2 UI_PD_DT_TO EI Period Date Date 10 UI_PERIODS_PER_YR EI Pay Periods Per Year Nbr 2 UI_PERIOD_DT EI Period Date Date 10 UI_WKLY_EARNS EI Weekly Earnings(No Limit) Sign 8.2 UI_WKLY_EARN_TO EI Weekly Earnings (No Limit) Sign 8.2 UI_WKLY_HOURS EI Weekly Hours Sign 3.2 UI_WKLY_HRS_TO EI Weekly Hours Sign 3.2 UI_WK_EARN_ADJ EI Weekly Earnings Adjusted Sign 8.2 UI_WK_EARN_ADJ_TO EI Weekly Earnings Adjusted Sign 8.2 UI_WK_HRS_ADJ EI Weekly Hours Adjusted Sign 3.2 UI_WK_HRS_ADJ_TO EI Weekly Hours Adjusted Sign 3.2 WAGE_LOSS_PLAN Wage Loss Replacement Plan Char 3 Upper PeopleSoft Report ID: XRFRCFL CROSS REFERENCE -- RECORDS AND FIELDS Page No. 23 Run Date 05/07/2001 Run Time 10:19:43 Record Name Field Name Long Field Name Type Length Format --------------- ------------------ ------------------------------ ---- ------ ------ AEAPPLVW AE_APPLID Application Char 18 Upper AE_SECTION Section Char 8 Upper DB_PLATFORM Database Platform Char 1 Upper DESCR Description Char 30 Mixed EFFDT Effective Date Date 10 EFF_STATUS Status as of Effective Date Char 1 Upper AECOMPCALC_TAO1 COMPANY Company Char 3 Upper COMPRATE Compensation Rate Nbr 12.6 COMP_FREQUENCY Compensation Frequency Char 1 Upper CURRENCY_CD Currency Code Char 3 Upper EFFDT Effective Date Date 10 EFFSEQ Effective Sequence Nbr 3 EMPLID EmplID Char 11 Upper EMPL_RCD# Employment Rcd Nbr Nbr 3 OPRID Operator Id Char 8 Mixed PAY_MONTHS_PER_YR Pay Months Per Year Nbr 2.1 RUN_CNTL_ID Run Control ID Char 30 Mixed STD_HOURS Standard Hours Nbr 2.2 AECOMPCALC_TAO2 COMPANY Company Char 3 Upper COMPRATE Compensation Rate Nbr 12.6 COMP_FREQUENCY Compensation Frequency Char 1 Upper CURRENCY_CD Currency Code Char 3 Upper EFFDT Effective Date Date 10 EFFSEQ Effective Sequence Nbr 3 EMPLID EmplID Char 11 Upper EMPL_RCD# Employment Rcd Nbr Nbr 3 OPRID Operator Id Char 8 Mixed PAY_MONTHS_PER_YR Pay Months Per Year Nbr 2.1 RUN_CNTL_ID Run Control ID Char 30 Mixed STD_HOURS Standard Hours Nbr 2.2 AEMESSAGEVW AE_APPLID Application Char 18 Upper LANGUAGE_CD Language Code Char 3 Upper MESSAGE_SET_NBR Message Set Number Nbr 5 AEPOSTFLDVW AE_POST_RECNAME Post Step Record Char 18 Upper FIELDNAME Field Name Char 18 Upper FIELDNUM Field Number Nbr 4 FIELDTYPE Field Type Nbr 2 LONGNAME Field Long Name Char 30 Mixed SHORTNAME Field Short Name Char 15 Mixed AEPREFLDVW AE_PRE_RECNAME Pre Step Record Char 18 Upper FIELDNAME Field Name Char 18 Upper FIELDNUM Field Number Nbr 4 FIELDTYPE Field Type Nbr 2 LONGNAME Field Long Name Char 30 Mixed SHORTNAME Field Short Name Char 15 Mixed AEPROCESSMVW DTTM_STAMP_SEC Last Update DateTime Dttm 26 Scnds OPRID Operator Id Char 8 Mixed PROCESS_INSTANCE Process Instance Nbr 10 RUN_CNTL_ID Run Control ID Char 30 Mixed AEPROCESSVW DTTM_STAMP_SEC Last Update DateTime Dttm 26 Scnds OPRID Operator Id Char 8 Mixed PROCESS_INSTANCE Process Instance Nbr 10 RUN_CNTL_ID Run Control ID Char 30 Mixed AERECDEFNVW DESCR Description Char 30 Mixed RECNAME Record (Table) Name Char 15 Upper AEREQUESTVW AE_RUN_CONTROL Run Control Char 18 Upper OPRID Operator Id Char 8 Mixed AESECTIONVW AE_DO_APPL_ID Application Char 18 Upper AE_DO_SECTION Do Section Char 8 Upper PeopleSoft Report ID: XRFRCFL CROSS REFERENCE -- RECORDS AND FIELDS Page No. 24 Run Date 05/07/2001 Run Time 10:19:43 Record Name Field Name Long Field Name Type Length Format --------------- ------------------ ------------------------------ ---- ------ ------ AESECTIONVW DESCR Description Char 30 Mixed AESTATEFLDVW AE_APPLID Application Char 18 Upper AE_STATE_RECNAME State Record Char 18 Upper DESCR Description Char 30 Mixed FIELDNAME Field Name Char 18 Upper AESTATERECVW AE_APPLID Application Char 18 Upper DESCR Description Char 30 Mixed RECNAME Record (Table) Name Char 15 Upper AESTATEVW DESCR Description Char 30 Mixed RECNAME Record (Table) Name Char 15 Upper AETOOLSCHKVW AE_ADJUST_STATUS Adjust Status Char 1 Upper AE_APPLID Application Char 18 Upper AE_REUSE_STMT Re-Use Statement Char 1 Upper AE_SECTION Section Char 8 Upper AE_STEP Name Char 8 Upper AE_STMT Statement Long *** AE_STMT_TYPE Type Char 1 Upper DB_PLATFORM Database Platform Char 1 Upper EFFDT Effective Date Date 10 AETOOLSSAVEVW AE_ADJUST_STATUS Adjust Status Char 1 Upper AE_APPLID Application Char 18 Upper AE_REUSE_STMT Re-Use Statement Char 1 Upper AE_SECTION Section Char 8 Upper AE_STEP Name Char 8 Upper AE_STMT Statement Long *** AE_STMT_TYPE Type Char 1 Upper DB_PLATFORM Database Platform Char 1 Upper EFFDT Effective Date Date 10 AETOOLSWRK AE_MENU_ADJ_DEL Remove Char 1 Upper AE_MENU_ADJ_LOAD Load Char 1 Upper AE_MENU_ADJ_STMT Adjust Statements Char 1 Upper AE_MENU_CHECK Check Char 1 Upper AE_MENU_DELETE Delete Char 1 Upper AE_MENU_NEW New Char 1 Upper AE_MENU_OPEN Open Char 1 Upper AE_MENU_OPTIONS Options Char 3 Upper AE_MENU_REBUILD Rebuild Char 1 Upper AE_MENU_REPLACE Replace Char 1 Upper AE_MENU_SAVEAS Save As Char 1 Upper AE_MENU_SEARCH Search Char 1 Upper AE_ROW_NUM Row Number Nbr 4 AE_STMT_TYPE Type Char 1 Upper MESSAGE_TEXT Message Text Char 100 Mixed AEWRK AE_ADD_SECTION New Section Char 1 Upper AE_ADJ_AUTO_CNT Automatic Changes Nbr 4 AE_ADJ_MAN_CNT Manual Changes Nbr 4 AE_ADJ_REJECT_CNT Rejected Changes Nbr 4 AE_ADJ_ROW_NUM Row number Nbr 4 AE_ADVANCED Advanced Char 1 Upper AE_APPLID Application Char 18 Upper AE_ASOF_EFFDT Effdt Override Date 10 AE_BOTTOM Move Current step to Bottom Char 1 Upper AE_CHUNK_1 One Char 1 Upper AE_CHUNK_2 Two Char 1 Upper AE_CHUNK_3 Three Char 1 Upper AE_CHUNK_4 Four Char 1 Upper AE_CHUNK_5 Five Char 1 Upper AE_CHUNK_DESC (nnn-nnn) Char 35 Upper AE_CHUNK_LOAD Load Chunk Char 4 Upper AE_CHUNK_MAX Chunk Max Char 4 Upper AE_CLIENT_DIALOG Client Dialog Char 1 Upper AE_COMPILE Compile Char 1 Upper PeopleSoft Report ID: XRFRCFL CROSS REFERENCE -- RECORDS AND FIELDS Page No. 25 Run Date 05/07/2001 Run Time 10:19:43 Record Name Field Name Long Field Name Type Length Format --------------- ------------------ ------------------------------ ---- ------ ------ AEWRK AE_COMPILE_OPTS Compile Options Char 1 Upper AE_COMPRESS_SQL Compress SQL Char 1 Upper AE_COPY_SECTION Save As Char 1 Upper AE_DECIDE I've decided to Char 1 Upper AE_DECIDE_B4 Prev contents of AE_DECIDE Char 1 Upper AE_DELETE_SECTION Delete Char 1 Upper AE_DETAIL_SW Detail Char 1 Upper AE_DONE Done Char 1 Upper AE_DOWN Move Current step down 1 Char 1 Upper AE_DYNAMIC_DO Dynamic DO Char 1 Upper AE_EDIT_CACHE_REC Edit Cache Record Char 1 Upper AE_EDIT_MSGS Edit Messages Char 1 Upper AE_EDIT_STMT Edit Char 1 Upper AE_EXCLUDE Exclude Options Char 1 Upper AE_EXECUTE Execute Char 1 Upper AE_EXPLAIN Explain First Char 1 Upper AE_EXPLAIN_FIRST Explain First Char 1 Upper AE_GO Search for Char 1 Upper AE_GOTO_APPL Application Char 1 Upper AE_GOTO_NEXT Next Char 1 Upper AE_GOTO_PREV Previous Char 1 Upper AE_GOTO_REQUEST Request Char 1 Upper AE_MENU_ADJUST Adjust Char 3 Upper AE_MENU_BAR Menu Bar Char 1 Upper AE_MENU_EDIT Edit Char 3 Upper AE_MENU_FILE File Char 3 Upper AE_MENU_OPTIONS Options Char 3 Upper AE_MODE Mode Char 1 Upper AE_PARAMETERS Parameters Char 1 Upper AE_PENDING_CNT Changes Pending Nbr 4 AE_PI_OPTION Process Instance option Char 1 Upper AE_POST_PC_SW Post Step Char 1 Upper AE_PRE_PC_SW Pre Step Char 1 Upper AE_PRODUCT Product Char 2 Upper AE_PROPERTIES Properties Char 1 Upper AE_REBUILD_STMTS Rebuild SQL Statements Char 1 Upper AE_REFRESH Refresh Char 1 Upper AE_RENAME_SECTION Rename Char 1 Upper AE_REPLACE_STRING Replace Char 100 Upper AE_ROW_COUNT in Scroll Nbr 4 AE_ROW_NUM Row Number Nbr 4 AE_RUN_ADHOC Execute Now Char 1 Upper AE_SAVE_MODE Save Mode Char 1 Upper AE_SEARCH Search Char 100 Upper AE_SECTION Section Char 8 Upper AE_SHOW_ORIGINAL Show Original Statement Char 1 Upper AE_SHOW_OUTPUT Show Output Char 1 Upper AE_STMT_CNT in Application Nbr 4 AE_STMT_TYPE Type Char 1 Upper AE_TIME_DISPLAY Just the Time Char 8 Upper AE_TOOLS GoTo Char 1 Upper AE_TOOLS_FUNC Function Char 1 Upper AE_TOOLS_OPTIONS Options Char 1 Upper AE_TOP Move Current step to Top Char 1 Upper AE_TOTAL_CHANGES Changes Commited Nbr 4 AE_UP Move Current step up 1 Char 1 Upper AE_VIEW_MESSAGES Messages Char 1 Upper AE_VIEW_MODE View Mode Char 1 Upper DB_PLATFORM Database Platform Char 1 Upper FUNCLIB Function Library Char 1 Upper MESSAGE_NBR Message Number Nbr 5 MESSAGE_SET_NBR Message Set Number Nbr 5 MESSAGE_TEXT Message Text Char 100 Mixed PROCESS_INSTANCE Process Instance Nbr 10 AE_APPL_TBL AE_ADJ_DTTM Last Adjustments Dttm 26 AE_APPL_ID Application Char 8 Upper AE_CACHE_RECNAME Cache Record Char 15 Upper AE_CHUNK_FACTOR Chunk Factor Nbr 3 PeopleSoft Report ID: XRFRCFL CROSS REFERENCE -- RECORDS AND FIELDS Page No. 26 Run Date 05/07/2001 Run Time 10:19:43 Record Name Field Name Long Field Name Type Length Format --------------- ------------------ ------------------------------ ---- ------ ------ AE_APPL_TBL AE_CHUNK_METHOD Chunking Method Char 1 Upper AE_COMMIT_MSG Issue Message for each Commit Char 1 Upper AE_DATE_OVERRIDE Override Current Date Char 1 Upper AE_DEBUG_MODE Debug Application Char 1 Upper AE_DEF_TRN_CTL Default Transaction Control Char 1 Upper AE_DISABLE_RESTART Disable Restart Char 1 Upper AE_FILTER_PROG_1 Filter 1 Char 8 Upper AE_FILTER_PROG_2 Filter 2 Char 8 Upper AE_FILTER_PROG_3 Filter 3 Char 8 Upper AE_FORCE_ABEND Force Abend after each Commit Char 1 Upper AE_FORCE_COMMIT Force Commit after each Step Char 1 Upper AE_PRODUCT Product Char 2 Upper AE_SYMBOLICS_PROG Symbolics Handler Char 8 Upper AE_TRACE Trace Application Steps Char 1 Upper AE_USE_PLATFORM Platform Override Char 1 Upper AE_VERSION Version Nbr 3.2 ASOF_DT As Of Date Date 10 DESCR Description Char 30 Mixed LAST_DTTM_UPDATE Last Change Date Dttm 26 Scnds MESSAGE_SET_NBR Message Set Number Nbr 5 OPRID Operator Id Char 8 Mixed AE_APPL_TMP AE_APPL_ID Application Char 8 Upper AE_CACHE_RECNAME Cache Record Char 15 Upper AE_CHUNK_FACTOR Chunk Factor Nbr 3 AE_CHUNK_METHOD Chunking Method Char 1 Upper AE_COMMIT_MSG Issue Message for each Commit Char 1 Upper AE_DATE_OVERRIDE Override Current Date Char 1 Upper AE_DEBUG_MODE Debug Application Char 1 Upper AE_DEF_TRN_CTL Default Transaction Control Char 1 Upper AE_DISABLE_RESTART Disable Restart Char 1 Upper AE_FILTER_PROG_1 Filter 1 Char 8 Upper AE_FILTER_PROG_2 Filter 2 Char 8 Upper AE_FILTER_PROG_3 Filter 3 Char 8 Upper AE_FORCE_ABEND Force Abend after each Commit Char 1 Upper AE_FORCE_COMMIT Force Commit after each Step Char 1 Upper AE_PRODUCT Product Char 2 Upper AE_SYMBOLICS_PROG Symbolics Handler Char 8 Upper AE_TRACE Trace Application Steps Char 1 Upper AE_USE_PLATFORM Platform Override Char 1 Upper AE_VERSION Version Nbr 3.2 ASOF_DT As Of Date Date 10 DESCR Description Char 30 Mixed LAST_DTTM_UPDATE Last Change Date Dttm 26 Scnds MESSAGE_SET_NBR Message Set Number Nbr 5 OPRID Operator Id Char 8 Mixed AE_APPL_VW AE_APPL_ID Application Char 8 Upper AE_PRODUCT Product Char 2 Upper AE_SECTION Section Char 8 Upper DB_PLATFORM Database Platform Char 1 Upper DESCR Description Char 30 Mixed EFFDT Effective Date Date 10 EFF_STATUS Status as of Effective Date Char 1 Upper AE_CACHE_FLD_VW AE_CACHE_RECNAME Cache Record Char 15 Upper DESCR Description Char 30 Mixed FIELDNAME Field Name Char 18 Upper AE_CACHE_REC_VW DESCR Description Char 30 Mixed RECNAME Record (Table) Name Char 15 Upper AE_CHK_LOAD_VW AE_CHUNK_MAX Chunk Max Char 4 Upper EFFDT Effective Date Date 10 EFF_STATUS Status as of Effective Date Char 1 Upper LANGUAGE_CD Language Code Char 3 Upper XLATLONGNAME Translate Long Name Char 30 Mixed AE_DO_APPL_VW AE_DO_APPLID Do Application Char 8 Upper PeopleSoft Report ID: XRFRCFL CROSS REFERENCE -- RECORDS AND FIELDS Page No. 27 Run Date 05/07/2001 Run Time 10:19:43 Record Name Field Name Long Field Name Type Length Format --------------- ------------------ ------------------------------ ---- ------ ------ AE_DO_APPL_VW AE_DO_PRODUCT Do Product Char 2 Upper DESCR Description Char 30 Mixed AE_DO_PROD_VW AE_DO_PRODUCT Do Product Char 2 Upper AE_DO_SEC_VW AE_APPL_ID Application Char 8 Upper AE_PRODUCT Product Char 2 Upper DESCR Description Char 30 Mixed FIELDNAME Field Name Char 18 Upper AE_INTTEST_AET AE_INT_1 Number Work Field Nbr 1 AE_INT_10 Number Work Field Nbr 10 AE_INT_11 Number Work Field Nbr 11 AE_INT_12 Number Work Field Nbr 12 AE_INT_13 Number Work Field Nbr 13 AE_INT_14 Number Work Field Nbr 14 AE_INT_15 Number Work Field Nbr 15 AE_INT_2 Number Work Field Nbr 2 AE_INT_3 Number Work Field Nbr 3 AE_INT_4 Number Work Field Nbr 4 AE_INT_5 Number Work Field Nbr 5 AE_INT_6 Number Work Field Nbr 6 AE_INT_7 Number Work Field Nbr 7 AE_INT_8 Number Work Field Nbr 8 AE_INT_9 Number Work Field Nbr 9 AE_SECTION Section Char 8 Upper AE_STEP Name Char 8 Upper PROCESS_INSTANCE Process Instance Nbr 10 AE_MENU_ITEM_VW AE_MENU_BAR Menu Bar Char 1 Upper AE_MENU_ITEM Menu Item Char 2 Upper EFFDT Effective Date Date 10 EFF_STATUS Status as of Effective Date Char 1 Upper XLATLONGNAME Translate Long Name Char 30 Mixed AE_OPTIONS AE_CHUNK_SIZE Chunk Nbr 6 AE_INS_SEL_LONGS Insert/Select Longs supported Char 1 Upper AE_PROCESS_VW DTTM_STAMP_SEC Last Update DateTime Dttm 26 Scnds OPRID Operator Id Char 8 Mixed PROCESS_INSTANCE Process Instance Nbr 10 RUN_CNTL_ID Run Control ID Char 30 Mixed AE_RECFIELD AE_RELEASE Release Nbr 4.2 FIELDNAME Field Name Char 18 Upper RECNAME Record (Table) Name Char 15 Upper AE_REQUEST AE_APPL_ID Application Char 8 Upper AE_PROCESS_STATUS Process Status Char 1 Upper AE_PRODUCT Product Char 2 Upper GOTO_PROCESS_STAT Go To Process Status Char 1 Upper LAST_RUN_DTM Last Run On Dttm 26 Scnds OPRID Operator Id Char 8 Mixed PROCESS_FREQUENCY Process Frequency Char 1 Upper PROCESS_INSTANCE Process Instance Nbr 10 PROCESS_ORIG Process Origin Char 1 Upper REQUEST_NBR Request Number Nbr 4 RUN_CNTL_ID Run Control ID Char 30 Mixed AE_REQUEST_OPT AE_BIND_VAR Bind Variable Name Char 18 Upper OPRID Operator Id Char 8 Mixed OPTION_VALUE_1 Option Value Field #1 Char 30 Upper OPTION_VALUE_2 Option Value Field #2 Char 30 Upper OPTION_VALUE_TYPE Option Value Type Char 1 Upper REQUEST_NBR Request Number Nbr 4 RUN_CNTL_ID Run Control ID Char 30 Mixed AE_RUN_CONTROL AE_APPL_ID Application Char 8 Upper AE_CRITICAL_PHASE Critical Char 1 Upper PeopleSoft Report ID: XRFRCFL CROSS REFERENCE -- RECORDS AND FIELDS Page No. 28 Run Date 05/07/2001 Run Time 10:19:43 Record Name Field Name Long Field Name Type Length Format --------------- ------------------ ------------------------------ ---- ------ ------ AE_RUN_CONTROL AE_PRODUCT Product Char 2 Upper AE_RTNCD Return Code Nbr 5 AE_RUN_DATA_1 Run Data 1 Char 250 Upper AE_RUN_DATA_2 Run Data 2 Char 250 Upper AE_RUN_DATA_3 Run Data 3 Char 250 Upper AE_SECTION Section Char 8 Upper AE_STEP Name Char 8 Upper AE_THREAD Thread Nbr 3 OPRID Operator Id Char 8 Mixed PROCESS_INSTANCE Process Instance Nbr 10 REQUEST_NBR Request Number Nbr 4 RUN_CNTL_ID Run Control ID Char 30 Mixed RUN_DTTM Run Date and Time Dttm 26 Scnds AE_SECTION_TBL AE_APPL_ID Application Char 8 Upper AE_AUTO_COMMIT Commit after each step Char 1 Upper AE_PRODUCT Product Char 2 Upper AE_SECTION Section Char 8 Upper AE_SECTION_TYPE Section Type Char 1 Upper AE_STMT_CHUNK_SIZE Statement Chunk Size Nbr 3 DB_PLATFORM Database Platform Char 1 Upper DESCR Description Char 30 Mixed EFFDT Effective Date Date 10 EFF_STATUS Status as of Effective Date Char 1 Upper AE_SECTION_TMP AE_APPL_ID Application Char 8 Upper AE_AUTO_COMMIT Commit after each step Char 1 Upper AE_PRODUCT Product Char 2 Upper AE_SECTION Section Char 8 Upper AE_SECTION_TYPE Section Type Char 1 Upper AE_STMT_CHUNK_SIZE Statement Chunk Size Nbr 3 DB_PLATFORM Database Platform Char 1 Upper DESCR Description Char 30 Mixed EFFDT Effective Date Date 10 EFF_STATUS Status as of Effective Date Char 1 Upper AE_SECTION_VW AE_DO_APPLID Do Application Char 8 Upper AE_DO_PRODUCT Do Product Char 2 Upper AE_DO_SECTION Do Section Char 8 Upper DESCR Description Char 30 Mixed AE_STEP_TBL AE_ABEND_ACTION On False Return Char 1 Upper AE_APPL_ID Application Char 8 Upper AE_COMMIT_AFTER Commit After Char 1 Upper AE_DO_APPLID Do Application Char 8 Upper AE_DO_PRODUCT Do Product Char 2 Upper AE_DO_SECTION Do Section Char 8 Upper AE_DO_SELECT Select Char 1 Upper AE_DO_SELECT_TYPE Type of Do Select Char 1 Upper AE_DO_UNTIL Until Char 1 Upper AE_DO_WHEN When Char 1 Upper AE_DO_WHILE While Char 1 Upper AE_PRODUCT Product Char 2 Upper AE_SECTION Section Char 8 Upper AE_SELECT_END_DO Select ends the Do Char 1 Upper AE_SEQ_NUM Sequence Nbr 3 AE_SQL_SELECT SELECT Present Char 1 Upper AE_SQL_UPDATE Edit SQL Char 1 Upper AE_STEP Name Char 8 Upper AE_STEP_TYPE Step Type Char 1 Upper DB_PLATFORM Database Platform Char 1 Upper EFFDT Effective Date Date 10 EFF_STATUS Status as of Effective Date Char 1 Upper MC_DEFN_ID Mass Change Definition Char 30 Mixed PROGRAM_NAME Program Name Char 8 Upper AE_STEP_TMP AE_ABEND_ACTION On False Return Char 1 Upper AE_APPL_ID Application Char 8 Upper AE_COMMIT_AFTER Commit After Char 1 Upper PeopleSoft Report ID: XRFRCFL CROSS REFERENCE -- RECORDS AND FIELDS Page No. 29 Run Date 05/07/2001 Run Time 10:19:43 Record Name Field Name Long Field Name Type Length Format --------------- ------------------ ------------------------------ ---- ------ ------ AE_STEP_TMP AE_DO_APPLID Do Application Char 8 Upper AE_DO_PRODUCT Do Product Char 2 Upper AE_DO_SECTION Do Section Char 8 Upper AE_DO_SELECT Select Char 1 Upper AE_DO_SELECT_TYPE Type of Do Select Char 1 Upper AE_DO_UNTIL Until Char 1 Upper AE_DO_WHEN When Char 1 Upper AE_DO_WHILE While Char 1 Upper AE_PRODUCT Product Char 2 Upper AE_SECTION Section Char 8 Upper AE_SELECT_END_DO Select ends the Do Char 1 Upper AE_SEQ_NUM Sequence Nbr 3 AE_SQL_SELECT SELECT Present Char 1 Upper AE_SQL_UPDATE Edit SQL Char 1 Upper AE_STEP Name Char 8 Upper AE_STEP_TYPE Step Type Char 1 Upper DB_PLATFORM Database Platform Char 1 Upper EFFDT Effective Date Date 10 EFF_STATUS Status as of Effective Date Char 1 Upper MC_DEFN_ID Mass Change Definition Char 30 Mixed PROGRAM_NAME Program Name Char 8 Upper AE_STMT_B_TBL AE_APPL_ID Application Char 8 Upper AE_PRODUCT Product Char 2 Upper AE_SECTION Section Char 8 Upper AE_SEQ_NUM Sequence Nbr 3 AE_STEP Name Char 8 Upper AE_STMT_SEG AE Statement Segment Char 254 Upper AE_STMT_TYPE Type Char 1 Upper DB_PLATFORM Database Platform Char 1 Upper EFFDT Effective Date Date 10 AE_STMT_B_TMP AE_APPL_ID Application Char 8 Upper AE_PRODUCT Product Char 2 Upper AE_SECTION Section Char 8 Upper AE_SEQ_NUM Sequence Nbr 3 AE_STEP Name Char 8 Upper AE_STMT_SEG AE Statement Segment Char 254 Upper AE_STMT_TYPE Type Char 1 Upper DB_PLATFORM Database Platform Char 1 Upper EFFDT Effective Date Date 10 AE_STMT_COMPILE AE_APPL_ID Application Char 8 Upper AE_PRODUCT Product Char 2 Upper AE_REUSE_STMT Re-Use Statement Char 1 Upper AE_SECTION Section Char 8 Upper AE_STEP Name Char 8 Upper AE_STMT Statement Long *** AE_STMT_TYPE Type Char 1 Upper AE_USE_CURSOR Use Cursor Nbr 1 DB_PLATFORM Database Platform Char 1 Upper EFFDT Effective Date Date 10 AE_STMT_TBL AE_ADJUST_STATUS Adjust Status Char 1 Upper AE_APPL_ID Application Char 8 Upper AE_PRODUCT Product Char 2 Upper AE_REUSE_STMT Re-Use Statement Char 1 Upper AE_SECTION Section Char 8 Upper AE_STEP Name Char 8 Upper AE_STMT Statement Long *** AE_STMT_TYPE Type Char 1 Upper AE_USE_CURSOR Use Cursor Nbr 1 DB_PLATFORM Database Platform Char 1 Upper EFFDT Effective Date Date 10 AE_STMT_TBL_TMP AE_APPL_ID Application Char 8 Upper AE_PRODUCT Product Char 2 Upper AE_SECTION Section Char 8 Upper AE_STEP Name Char 8 Upper PeopleSoft Report ID: XRFRCFL CROSS REFERENCE -- RECORDS AND FIELDS Page No. 30 Run Date 05/07/2001 Run Time 10:19:43 Record Name Field Name Long Field Name Type Length Format --------------- ------------------ ------------------------------ ---- ------ ------ AE_STMT_TBL_TMP AE_STMT_TYPE Type Char 1 Upper DB_PLATFORM Database Platform Char 1 Upper EFFDT Effective Date Date 10 AE_STMT_TMP AE_ADJUST_STATUS Adjust Status Char 1 Upper AE_APPL_ID Application Char 8 Upper AE_PRODUCT Product Char 2 Upper AE_REUSE_STMT Re-Use Statement Char 1 Upper AE_SECTION Section Char 8 Upper AE_STEP Name Char 8 Upper AE_STMT Statement Long *** AE_STMT_TYPE Type Char 1 Upper AE_USE_CURSOR Use Cursor Nbr 1 DB_PLATFORM Database Platform Char 1 Upper EFFDT Effective Date Date 10 AE_TESTAPPL_AET AE_APPL_ID Application Char 8 Upper AE_INT_1 Number Work Field Nbr 1 AE_INT_10 Number Work Field Nbr 10 AE_INT_11 Number Work Field Nbr 11 AE_INT_12 Number Work Field Nbr 12 AE_INT_13 Number Work Field Nbr 13 AE_INT_14 Number Work Field Nbr 14 AE_INT_15 Number Work Field Nbr 15 AE_INT_2 Number Work Field Nbr 2 AE_INT_3 Number Work Field Nbr 3 AE_INT_4 Number Work Field Nbr 4 AE_INT_5 Number Work Field Nbr 5 AE_INT_6 Number Work Field Nbr 6 AE_INT_7 Number Work Field Nbr 7 AE_INT_8 Number Work Field Nbr 8 AE_INT_9 Number Work Field Nbr 9 AE_PRODUCT Product Char 2 Upper AE_SECTION Section Char 8 Upper AE_STEP Name Char 8 Upper PROCESS_INSTANCE Process Instance Nbr 10 AE_TOOLS_CHK_VW AE_ADJUST_STATUS Adjust Status Char 1 Upper AE_APPL_ID Application Char 8 Upper AE_PRODUCT Product Char 2 Upper AE_REUSE_STMT Re-Use Statement Char 1 Upper AE_SECTION Section Char 8 Upper AE_STEP Name Char 8 Upper AE_STMT Statement Long *** AE_STMT_TYPE Type Char 1 Upper AE_USE_CURSOR Use Cursor Nbr 1 DB_PLATFORM Database Platform Char 1 Upper EFFDT Effective Date Date 10 AE_TOOLS_MSG_VW AE_APPL_ID Application Char 8 Upper AE_DO_APPLID Do Application Char 8 Upper AE_DO_PRODUCT Do Product Char 2 Upper AE_DO_SECTION Do Section Char 8 Upper AE_PRODUCT Product Char 2 Upper AE_SECTION Section Char 8 Upper AE_STEP Name Char 8 Upper AE_STEP_TYPE Step Type Char 1 Upper DB_PLATFORM Database Platform Char 1 Upper EFFDT Effective Date Date 10 LANGUAGE_CD Language Code Char 3 Upper MESSAGE_NBR Message Number Nbr 5 MESSAGE_TEXT Message Text Char 100 Mixed AE_TOOLS_SAV_VW AE_ADJUST_STATUS Adjust Status Char 1 Upper AE_APPL_ID Application Char 8 Upper AE_PRODUCT Product Char 2 Upper AE_REUSE_STMT Re-Use Statement Char 1 Upper AE_SECTION Section Char 8 Upper AE_STEP Name Char 8 Upper PeopleSoft Report ID: XRFRCFL CROSS REFERENCE -- RECORDS AND FIELDS Page No. 31 Run Date 05/07/2001 Run Time 10:19:43 Record Name Field Name Long Field Name Type Length Format --------------- ------------------ ------------------------------ ---- ------ ------ AE_TOOLS_SAV_VW AE_STMT Statement Long *** AE_STMT_TYPE Type Char 1 Upper AE_USE_CURSOR Use Cursor Nbr 1 DB_PLATFORM Database Platform Char 1 Upper EFFDT Effective Date Date 10 AE_TOOLS_WRK AE_ROW_NUM Row Number Nbr 4 AE_STMT_TYPE Type Char 1 Upper MESSAGE_TEXT Message Text Char 100 Mixed AE_USER_PROMPT AE_DTTM DTM Stamp Dttm 26 Scnds AE_REPLACE_STRING Replace Char 100 Upper AE_SEARCH Search Char 100 Upper OPRID Operator Id Char 8 Mixed AE_WRK AE_ADD_SECTION New Section Char 1 Upper AE_ADJ_AUTO_CNT Automatic Changes Nbr 4 AE_ADJ_MAN_CNT Manual Changes Nbr 4 AE_ADJ_REJECT_CNT Rejected Changes Nbr 4 AE_ADJ_ROW_NUM Row number Nbr 4 AE_APPL_ID Application Char 8 Upper AE_ASOF_EFFDT Effdt Override Date 10 AE_BOTTOM Move Current step to Bottom Char 1 Upper AE_CHUNK_1 One Char 1 Upper AE_CHUNK_2 Two Char 1 Upper AE_CHUNK_3 Three Char 1 Upper AE_CHUNK_4 Four Char 1 Upper AE_CHUNK_5 Five Char 1 Upper AE_CHUNK_DESC (nnn-nnn) Char 35 Upper AE_CHUNK_LOAD Load Chunk Char 4 Upper AE_CHUNK_MAX Chunk Max Char 4 Upper AE_COMPILE Compile Char 1 Upper AE_COMPILE_OPTS Compile Options Char 1 Upper AE_COMPRESS_SQL Compress SQL Char 1 Upper AE_COPY_SECTION Save As Char 1 Upper AE_DECIDE I've decided to Char 1 Upper AE_DECIDE_B4 Prev contents of AE_DECIDE Char 1 Upper AE_DELETE_SECTION Delete Char 1 Upper AE_DETAIL_SW Detail Char 1 Upper AE_DOWN Move Current step down 1 Char 1 Upper AE_DO_SECTION_TEXT DO Product.Appl ID.Section Char 20 Upper AE_DYNAMIC_DO Dynamic DO Char 1 Upper AE_EDIT_CACHE_REC Edit Cache Record Char 1 Upper AE_EXCLUDE Exclude Options Char 1 Upper AE_EXPLAIN Explain First Char 1 Upper AE_EXPLAIN_FIRST Explain First Char 1 Upper AE_EXPORT Export Char 1 Upper AE_GO Search for Char 1 Upper AE_GOTO_NEXT Next Char 1 Upper AE_GOTO_PREV Previous Char 1 Upper AE_IMPORT Import Char 1 Upper AE_MENU_ADJUST Adjust Char 3 Upper AE_MENU_BAR Menu Bar Char 1 Upper AE_MENU_EDIT Edit Char 3 Upper AE_MENU_FILE File Char 3 Upper AE_MENU_OPTIONS Options Char 3 Upper AE_MODE Mode Char 1 Upper AE_PENDING_CNT Changes Pending Nbr 4 AE_PI_OPTION Process Instance option Char 1 Upper AE_PRODUCT Product Char 2 Upper AE_REBUILD_STMTS Rebuild SQL Statements Char 1 Upper AE_REFRESH Refresh Char 1 Upper AE_RENAME_SECTION Rename Char 1 Upper AE_REPLACE_STRING Replace Char 100 Upper AE_RETURN Return Char 1 Upper AE_ROW_COUNT in Scroll Nbr 4 AE_ROW_NUM Row Number Nbr 4 AE_RUN_ADHOC Execute Now Char 1 Upper AE_SAVE_MODE Save Mode Char 1 Upper PeopleSoft Report ID: XRFRCFL CROSS REFERENCE -- RECORDS AND FIELDS Page No. 32 Run Date 05/07/2001 Run Time 10:19:43 Record Name Field Name Long Field Name Type Length Format --------------- ------------------ ------------------------------ ---- ------ ------ AE_WRK AE_SEARCH Search Char 100 Upper AE_SECTION Section Char 8 Upper AE_SET_SECTION Edit DO Section Properties Char 1 Upper AE_SHOW_ORIGINAL Show Original Statement Char 1 Upper AE_SHOW_OUTPUT Show Output Char 1 Upper AE_STMT_CNT in Application Nbr 4 AE_STMT_TYPE Type Char 1 Upper AE_TIME_DISPLAY Just the Time Char 8 Upper AE_TOOLS_FUNC Function Char 1 Upper AE_TOOLS_OPTIONS Options Char 1 Upper AE_TOP Move Current step to Top Char 1 Upper AE_TOTAL_CHANGES Changes Commited Nbr 4 AE_UP Move Current step up 1 Char 1 Upper AE_VIEW_MODE View Mode Char 1 Upper DB_PLATFORM Database Platform Char 1 Upper FUNCLIB Function Library Char 1 Upper MESSAGE_NBR Message Number Nbr 5 MESSAGE_SET_NBR Message Set Number Nbr 5 MESSAGE_TEXT Message Text Char 100 Mixed PROCESS_INSTANCE Process Instance Nbr 10 AFFILIATE_VW AFFILIATE Affiliate Char 5 Upper DESCR Description Char 30 Mixed DESCRSHORT Short Description Char 10 Mixed AFF_ACTN_GOALS AA_PLAN_GOAL Aff Action Plan Goal Nbr 4 AA_PLAN_ID Aff Action Plan ID Char 3 Upper AA_PLAN_QTRCD Aff Action Plan Qtr Char 1 Upper AA_PLAN_YR Aff Action Plan Year Nbr 4 DEPTID Department Char 10 Upper ETHNIC_GROUP Ethnic Group Char 1 Upper SETID SetID Char 5 Upper AFF_ACTN_PLAN AAP_RESPONSIBLE_ID Person Responsible Char 11 Upper AA_PLAN_ID Aff Action Plan ID Char 3 Upper AA_PLAN_QTRCD Aff Action Plan Qtr Char 1 Upper AA_PLAN_YR Aff Action Plan Year Nbr 4 DEPTID Department Char 10 Upper FEMALE_GOAL Female Goal Nbr 4 SETID SetID Char 5 Upper AFF_ACTN_PL_LNG AA_PLAN_ID Aff Action Plan ID Char 3 Upper DESCR Description Char 30 Mixed DESCRSHORT Short Description Char 10 Mixed EFFDT Effective Date Date 10 LANGUAGE_CD Language Code Char 3 Upper AFF_ACTN_PL_TBL AA_PLAN_ID Aff Action Plan ID Char 3 Upper DESCR Description Char 30 Mixed DESCRSHORT Short Description Char 10 Mixed EFFDT Effective Date Date 10 EFF_STATUS Status as of Effective Date Char 1 Upper AGE_COVG_TBL AGE_RANGE_HIGH Age Range High Nbr 3 AGE_RANGE_LOW Age Range Low Nbr 3 AGE_RATE_SEX Insurance Rate Sex Char 1 Upper AGE_RATE_TBL_ID Age-Graded Rate Table ID Char 4 Upper EFFDT Effective Date Date 10 EMPLR_RATE_NONSMOK Employer Rate - Nonsmoker Nbr 2.3 EMPLR_RATE_SMOKER Employer Rate - Smoker Nbr 2.3 EMPL_RATE_NONSMOK Employee Rate - Nonsmoker Nbr 2.3 EMPL_RATE_SMOKER Employee Rate - Smoker Nbr 2.3 TOTAL_RATE_NONSMOK Total Rate - Nonsmoker Nbr 2.3 TOTAL_RATE_SMOKER Total Rate - Smoker Nbr 2.3 AGE_RATE_TBL AGE_RATE_TBL_ID Age-Graded Rate Table ID Char 4 Upper EFFDT Effective Date Date 10 PAY_FREQUENCY Pay Frequency Char 1 Upper RATE_UNIT Rate per Unit Char 1 Upper PeopleSoft Report ID: XRFRCFL CROSS REFERENCE -- RECORDS AND FIELDS Page No. 33 Run Date 05/07/2001 Run Time 10:19:43 Record Name Field Name Long Field Name Type Length Format --------------- ------------------ ------------------------------ ---- ------ ------ AGREEMENT_FRA AGREEMENT_DT_FRA Agreement Date Date 10 AGREEMENT_NBR_FRA Agreement Number Char 11 Upper AGREEMENT_TYPE_FRA Agreement Type Char 1 Upper COMPANY Company Char 3 Upper VENDOR Vendor ID Char 6 Upper AGREEMNT_FRA_VW AGREEMENT_DT_FRA Agreement Date Date 10 COMPANY Company Char 3 Upper VENDOR Vendor ID Char 6 Upper ALLOC_BASWK_TBL ACCOUNT Account Char 6 Upper ACCOUNTING_PERIOD Accounting Period Nbr 3 AFFILIATE Affiliate Char 5 Upper BUDGET_PERIOD Budget Period Char 8 Upper BUSINESS_UNIT Business Unit Char 5 Upper CLASS_FLD Class Field Char 5 Upper CURRENCY_CD Currency Code Char 3 Upper DEPTID Department Char 10 Upper FISCAL_YEAR Fiscal Year Nbr 4 FUND_CODE Fund Code Char 5 Upper POSTED_TOTAL_AMT Posted Total Amount Sign 13.2 PROCESS_INSTANCE Process Instance Nbr 10 PROGRAM_CODE Program Code Char 5 Upper PROJECT_ID Project/Grant Char 15 Upper STATISTICS_CODE Statistics Code Char 3 Upper ALLOC_CALC_LOG ACCOUNT Account Char 6 Upper ACCOUNTING_PERIOD Accounting Period Nbr 3 AFFILIATE Affiliate Char 5 Upper ALLOC_BASIS_AMT Alloc Basis Amt - numerator Sign 13.2 ALLOC_BASIS_TOT Alloc Basis Total denominator Sign 13.2 ALLOC_POOL_AMT Allocations Pool Amount Sign 13.2 ALLOC_POOL_PBA Allocations Pool PBA Amount Sign 13.2 ALLOC_TARG_OFF_AMT Alloc Target/Offset Amount Sign 13.2 ALLOC_TARG_OFF_PBA Alloc Target/Offset PBA Amt Sign 13.2 BUDGET_PERIOD Budget Period Char 8 Upper BUSINESS_UNIT Business Unit Char 5 Upper CLASS_FLD Class Field Char 5 Upper CURRENCY_CD Currency Code Char 3 Upper DEPTID Department Char 10 Upper FISCAL_YEAR Fiscal Year Nbr 4 FOREIGN_CURRENCY Foreign Currency Code Char 3 Upper FUND_CODE Fund Code Char 5 Upper LOGICAL_RECORD Allocations Logical Record Char 1 Upper PROCESS_INSTANCE Process Instance Nbr 10 PROCESS_STEP Process Step Char 10 Upper PROGRAM_CODE Program Code Char 5 Upper PROJECT_ID Project/Grant Char 15 Upper SEQ_NBR Sequence Number Nbr 15 STATISTICS_CODE Statistics Code Char 3 Upper ALL_CRS_SRCH_VW COURSE Course Code Char 6 Upper COURSE_TYPE Course Type Char 1 Upper CREATION_DT Creation Date Date 10 DESCR Description Char 30 Mixed INTERNAL_EXTERNAL Internal/External Char 1 Upper ALL_CRS_S_LNG COURSE Course Code Char 6 Upper DESCR Description Char 30 Mixed LANGUAGE_CD Language Code Char 3 Upper ALT_CHAR_TBL ALT_CHARACTER Aternate Character Type Char 1 Upper LANGUAGE_CD Language Code Char 3 Upper ANALYSIS_DB ANALYSIS_DB_ID Cube Template ID Char 15 Upper ANALYSIS_MODEL_ID Analysis Model ID Char 15 Upper ANALYSIS_PLATFORM Analysis Platform Char 3 Upper DESCR Description Char 30 Mixed PeopleSoft Report ID: XRFRCFL CROSS REFERENCE -- RECORDS AND FIELDS Page No. 34 Run Date 05/07/2001 Run Time 10:19:43 Record Name Field Name Long Field Name Type Length Format --------------- ------------------ ------------------------------ ---- ------ ------ ANALYSIS_DB DESCRLONG Description Long 0 LANGUAGE_CD Language Code Char 3 Upper ANALYSIS_DB_DIM ANALYSIS_DB_ID Cube Template ID Char 15 Upper DESCR Description Char 30 Mixed ANALYSIS_DB_ESS ANALYSIS_DB_APP Application Name Char 8 Mixed ANALYSIS_DB_NAME Database Name Char 8 Mixed ANALYSIS_DB_SERVER Database Server Char 30 Mixed ANL_DB_LOGON_ID User Name Char 30 Mixed ANL_DB_LOGON_PASS Logon Password Char 30 Mixed DATA_UPDATE_ACTION Data Update Action Char 1 Upper ESS_AUTO_SPARSITY Auto Configure Sparsity Char 1 Upper ESS_INTEL_RECALC Intelligent Recalc Char 1 Upper ESS_INTEL_RESTRUCT Intelligent Restructure Char 1 Upper ESS_RUN_DEF_CALC Run Default Calc Char 1 Upper ESS_USER_ACCESS User Access Char 1 Upper MD_UPDATE_ACTION Meta-Data Update Action Char 1 Upper ANALYSIS_DB_PPL PPL_DATA_PATHFILE Data Working Directory Char 253 Upper PPL_MDC_PATHFILE PowerCube Path/File (.MDC) Char 253 Upper PPL_MDL_PATHFILE Model Path/File (.MDL) Char 253 Upper ANALYSIS_DB_WRK ANALYSIS_MODEL_ID Analysis Model ID Char 15 Upper PB_ESS_OPTIONS Essbase Avanced Options Char 1 Upper PB_OPEN_ANL_MODEL Open Analysis Model Char 1 Upper ANALYSIS_MODEL ANALYSIS_MODEL_ID Analysis Model ID Char 15 Upper DESCR Description Char 30 Mixed DESCRLONG Description Long 0 ANIMAL_TBL ANIMAL_CD Animal Char 6 Upper DESCR50 Description Char 50 Mixed DESCRSHORT Short Description Char 10 Mixed ANIMAL_TBL_LANG ANIMAL_CD Animal Char 6 Upper DESCR50 Description Char 50 Mixed DESCRSHORT Short Description Char 10 Mixed LANGUAGE_CD Language Code Char 3 Upper ANL_DB_BIND_VAL BIND_VALUE Bind Value Char 254 Mixed DESCR Description Char 30 Mixed OPRID Operator Id Char 8 Mixed RUN_CNTL_ID Run Control ID Char 30 Mixed ANL_DB_DIM_ESS DIMENSION_LOCK No Structure Updates Char 1 Upper ESS_DIM_SPARSITY Sparsity Char 1 Upper ANL_DB_DIM_PPL DIMENSION_OMIT Omit Dimension Char 1 Upper ANL_DB_LANG ANALYSIS_DB_ID Cube Template ID Char 15 Upper LANGUAGE_CD Language Code Char 3 Upper ANL_MOD_DAT_SRC ANALYSIS_MODEL_ID Analysis Model ID Char 15 Upper DESCR Description Char 30 Mixed QRYNAME Query Name Char 30 Upper ANL_MOD_DIM ANALYSIS_MODEL_ID Analysis Model ID Char 15 Upper DESCR Description Char 30 Mixed DIMENSION_ID Dimension ID Char 15 Upper MEASURES_DIM_FLG Measure Char 1 Upper SEQUENCE_NBR_6 Sequence Nbr 6 ANL_MOD_DIM_FLD ANALYSIS_MODEL_ID Analysis Model ID Char 15 Upper DESCR Description Char 30 Mixed QRYFLDNAME Query Field Name Char 30 Mixed QRYNAME Query Name Char 30 Upper ANL_MOD_DIM_WRK DESCR Description Char 30 Mixed PeopleSoft Report ID: XRFRCFL CROSS REFERENCE -- RECORDS AND FIELDS Page No. 35 Run Date 05/07/2001 Run Time 10:19:43 Record Name Field Name Long Field Name Type Length Format --------------- ------------------ ------------------------------ ---- ------ ------ ANL_MOD_DIM_WRK DIMENSION_ID Dimension ID Char 15 Upper PB_OPEN_DIMENSION Open Dimension Char 1 Upper ANL_MOD_WRK DIMENSION_ID Dimension ID Char 15 Upper PB_DAT_SRC_FLDS Data Source Fields Char 1 Upper APE_FRA_LANG APE_INDSTRY_CD_FRA APE Code Char 4 Upper DESCR Description Char 30 Mixed DESCRSHORT Short Description Char 10 Mixed LANGUAGE_CD Language Code Char 3 Upper APE_INDSTRY_FRA APE_INDSTRY_CD_FRA APE Code Char 4 Upper DESCR Description Char 30 Mixed DESCRSHORT Short Description Char 10 Mixed APLICNT_DTA_LNG EMPLID EmplID Char 11 Upper LANGUAGE_CD Language Code Char 3 Upper NAME Name Char 50 Name APLICNT_HST_LNG ADDRESS1 Address Line 1 Char 35 Upper ADDRESS1_OTHER Address Line 1 Char 35 Upper ADDRESS2 Address Line 2 Char 35 Upper ADDRESS2_OTHER Address Line 2 Char 35 Upper ADDRESS3 Address Line 3 Char 35 Upper ADDRESS3_OTHER Address Line 3 Char 35 Upper ADDRESS4 Address Line 4 Char 35 Upper ADDRESS4_OTHER Address Line 4 Char 35 Upper APP_DT Application Date Date 10 CITY City Char 30 Upper CITY_OTHER City - Other Char 30 Upper COUNTRY Country Char 3 Upper COUNTRY_CODE Country Code Char 3 Upper COUNTRY_OTHER Country - Other Char 3 Upper COUNTY County Char 30 Mixed COUNTY_OTHER County - Other Char 30 Upper EMPLID EmplID Char 11 Upper LANGUAGE_CD Language Code Char 3 Upper NAME Name Char 50 Name NAME_PREFIX Name Prefix Char 4 Mixed STATE State Char 6 Upper STATE_OTHER State - Other Char 6 Upper APLIGER_DTA_LNG EMPLID EmplID Char 11 Upper LANGUAGE_CD Language Code Char 3 Upper NAME Name Char 50 Name APPLICANTS ADDRESS1 Address Line 1 Char 35 Upper ADDRESS1_OTHER Address Line 1 Char 35 Upper ADDRESS2 Address Line 2 Char 35 Upper ADDRESS2_OTHER Address Line 2 Char 35 Upper ADDRESS3 Address Line 3 Char 35 Upper ADDRESS3_OTHER Address Line 3 Char 35 Upper ADDRESS4 Address Line 4 Char 35 Upper ADDRESS4_OTHER Address Line 4 Char 35 Upper AGE_STATUS Age 18 or Older Char 1 Upper APP_DT Application Date Date 10 APP_PER_STATUS Applicant Status Char 1 Upper APP_STATUS Application Status Char 1 Upper APP_STATUS_DT Application Status Date Date 10 ASOFDATE As Of Date Date 10 BIRTHDATE Date of Birth Date 10 BIRTHPLACE Birth Location Char 30 Mixed CAN_ABORIGINAL Aboriginal Person Char 1 Upper CAN_VISBL_MINORITY Visible Minority Char 1 Upper CITIZENSHIP_STATUS Citizenship Status Char 1 Upper CITIZEN_PROOF1 Citizenship (Proof 1) Char 10 Upper CITIZEN_PROOF2 Citizenship (Proof 2) Char 10 Upper CITY City Char 30 Upper CITY_OTHER City - Other Char 30 Upper PeopleSoft Report ID: XRFRCFL CROSS REFERENCE -- RECORDS AND FIELDS Page No. 36 Run Date 05/07/2001 Run Time 10:19:43 Record Name Field Name Long Field Name Type Length Format --------------- ------------------ ------------------------------ ---- ------ ------ APPLICANTS COUNTRY Country Char 3 Upper COUNTRY_OTHER Country - Other Char 3 Upper COUNTY County Char 30 Mixed COUNTY_OTHER County - Other Char 30 Upper DISABLED Disabled Char 1 Upper DISABLED_VET Disabled Veteran Char 1 Upper DT_OF_DEATH Date of Death Date 10 EMPLID EmplID Char 11 Upper ETHNIC_GROUP Ethnic Group Char 1 Upper FROMDATE From Date Date 10 HIGHEST_EDUC_LVL Highest Education Level Char 1 Upper HOME_PHONE Home Phone # Char 24 CtSec LANGUAGE_CD Language Code Char 3 Upper MAR_STATUS Marital Status Char 1 Upper MILITARY_STATUS Military Status Char 1 Upper NAME Name Char 50 Name NAME_PREFIX Name Prefix Char 4 Mixed NATIONAL_ID Social Security No Char 15 CtSec NATIONAL_ID_TYPE National ID Type Char 4 Upper NID_COUNTRY National ID Country Char 3 Upper NID_DESCRSHORT NID Short Description Char 10 Upper ORIG_HIRE_DT Original Hire Date Date 10 PER_STATUS Personnel Status Char 1 Upper POSTAL Postal Code Char 12 CtSec POSTAL_OTHER Postal Code - Other Char 12 CtSec REFERRAL_SOURCE Referral Source Char 2 Upper SEX Gender Char 1 Upper SMOKER Smoker Char 1 Upper STATE State Char 6 Upper STATE_OTHER State - Other Char 6 Upper US_WORK_ELIGIBILTY Eligible to Work in U.S. Char 1 Upper APPLICANTS_LNG ADDRESS1 Address Line 1 Char 35 Upper ADDRESS1_OTHER Address Line 1 Char 35 Upper ADDRESS2 Address Line 2 Char 35 Upper ADDRESS2_OTHER Address Line 2 Char 35 Upper ADDRESS3 Address Line 3 Char 35 Upper ADDRESS3_OTHER Address Line 3 Char 35 Upper ADDRESS4 Address Line 4 Char 35 Upper ADDRESS4_OTHER Address Line 4 Char 35 Upper APP_DT Application Date Date 10 CITY City Char 30 Upper CITY_OTHER City - Other Char 30 Upper COUNTRY Country Char 3 Upper COUNTRY_OTHER Country - Other Char 3 Upper COUNTY County Char 30 Mixed COUNTY_OTHER County - Other Char 30 Upper EMPLID EmplID Char 11 Upper LANGUAGE_CD Language Code Char 3 Upper NAME Name Char 50 Name NAME_PREFIX Name Prefix Char 4 Mixed STATE State Char 6 Upper STATE_OTHER State - Other Char 6 Upper APPLICANT_BEL EMPLID EmplID Char 11 Upper NAME Name Char 50 Name APPLICANT_CAN EMPLID EmplID Char 11 Upper NAME Name Char 50 Name NATIONAL_ID Social Security No Char 15 CtSec NATIONAL_ID_TYPE National ID Type Char 4 Upper NID_COUNTRY National ID Country Char 3 Upper NID_DESCRSHORT NID Short Description Char 10 Upper APPLICANT_DATA EMPLID EmplID Char 11 Upper NAME Name Char 50 Name NATIONAL_ID Social Security No Char 15 CtSec NATIONAL_ID_TYPE National ID Type Char 4 Upper NID_COUNTRY National ID Country Char 3 Upper PeopleSoft Report ID: XRFRCFL CROSS REFERENCE -- RECORDS AND FIELDS Page No. 37 Run Date 05/07/2001 Run Time 10:19:43 Record Name Field Name Long Field Name Type Length Format --------------- ------------------ ------------------------------ ---- ------ ------ APPLICANT_DATA NID_DESCRSHORT NID Short Description Char 10 Upper APPLICANT_FRA EMPLID EmplID Char 11 Upper NAME Name Char 50 Name NATIONAL_ID Social Security No Char 15 CtSec NATIONAL_ID_TYPE National ID Type Char 4 Upper NID_COUNTRY National ID Country Char 3 Upper NID_DESCRSHORT NID Short Description Char 10 Upper APPLICANT_GBL EMPLID EmplID Char 11 Upper NAME Name Char 50 Name NAME_AC Alternate Character Name Char 50 Mixed NATIONAL_ID Social Security No Char 15 CtSec NATIONAL_ID_TYPE National ID Type Char 4 Upper NID_COUNTRY National ID Country Char 3 Upper NID_DESCRSHORT NID Short Description Char 10 Upper APPLICANT_GER EMPLID EmplID Char 11 Upper NAME Name Char 50 Name NATIONAL_ID Social Security No Char 15 CtSec NATIONAL_ID_TYPE National ID Type Char 4 Upper NID_COUNTRY National ID Country Char 3 Upper NID_DESCRSHORT NID Short Description Char 10 Upper APPLICANT_HIST ADDRESS1 Address Line 1 Char 35 Upper ADDRESS1_OTHER Address Line 1 Char 35 Upper ADDRESS2 Address Line 2 Char 35 Upper ADDRESS2_OTHER Address Line 2 Char 35 Upper ADDRESS3 Address Line 3 Char 35 Upper ADDRESS3_OTHER Address Line 3 Char 35 Upper ADDRESS4 Address Line 4 Char 35 Upper ADDRESS4_OTHER Address Line 4 Char 35 Upper AGE_STATUS Age 18 or Older Char 1 Upper APP_DT Application Date Date 10 APP_PER_STATUS Applicant Status Char 1 Upper APP_STATUS Application Status Char 1 Upper APP_STATUS_DT Application Status Date Date 10 BIRTHDATE Date of Birth Date 10 BIRTHPLACE Birth Location Char 30 Mixed CAN_ABORIGINAL Aboriginal Person Char 1 Upper CAN_VISBL_MINORITY Visible Minority Char 1 Upper CITIZENSHIP_STATUS Citizenship Status Char 1 Upper CITIZEN_PROOF1 Citizenship (Proof 1) Char 10 Upper CITIZEN_PROOF2 Citizenship (Proof 2) Char 10 Upper CITY City Char 30 Upper CITY_OTHER City - Other Char 30 Upper COUNTRY Country Char 3 Upper COUNTRY_CODE Country Code Char 3 Upper COUNTRY_OTHER Country - Other Char 3 Upper COUNTY County Char 30 Mixed COUNTY_OTHER County - Other Char 30 Upper DISABLED Disabled Char 1 Upper DISABLED_VET Disabled Veteran Char 1 Upper DT_OF_DEATH Date of Death Date 10 EMPLID EmplID Char 11 Upper ETHNIC_GROUP Ethnic Group Char 1 Upper HIGHEST_EDUC_LVL Highest Education Level Char 1 Upper LANGUAGE_CD Language Code Char 3 Upper MAR_STATUS Marital Status Char 1 Upper MILITARY_STATUS Military Status Char 1 Upper NAME Name Char 50 Name NAME_PREFIX Name Prefix Char 4 Mixed NATIONAL_ID Social Security No Char 15 CtSec NATIONAL_ID_TYPE National ID Type Char 4 Upper NID_COUNTRY National ID Country Char 3 Upper NID_DESCRSHORT NID Short Description Char 10 Upper ORIG_HIRE_DT Original Hire Date Date 10 PER_STATUS Personnel Status Char 1 Upper PHONE Telephone Char 24 CtSec PeopleSoft Report ID: XRFRCFL CROSS REFERENCE -- RECORDS AND FIELDS Page No. 38 Run Date 05/07/2001 Run Time 10:19:43 Record Name Field Name Long Field Name Type Length Format --------------- ------------------ ------------------------------ ---- ------ ------ APPLICANT_HIST POSTAL Postal Code Char 12 CtSec POSTAL_OTHER Postal Code - Other Char 12 CtSec REFERRAL_SOURCE Referral Source Char 2 Upper SEX Gender Char 1 Upper SMOKER Smoker Char 1 Upper STATE State Char 6 Upper STATE_OTHER State - Other Char 6 Upper US_WORK_ELIGIBILTY Eligible to Work in U.S. Char 1 Upper APPLICANT_NLD EMPLID EmplID Char 11 Upper NAME Name Char 50 Name NATIONAL_ID Social Security No Char 15 CtSec NATIONAL_ID_TYPE National ID Type Char 4 Upper NID_COUNTRY National ID Country Char 3 Upper NID_DESCRSHORT NID Short Description Char 10 Upper APPLICANT_UK EMPLID EmplID Char 11 Upper NAME Name Char 50 Name NATIONAL_ID Social Security No Char 15 CtSec NATIONAL_ID_TYPE National ID Type Char 4 Upper NID_COUNTRY National ID Country Char 3 Upper NID_DESCRSHORT NID Short Description Char 10 Upper APPLICANT_US EMPLID EmplID Char 11 Upper NAME Name Char 50 Name NATIONAL_ID Social Security No Char 15 CtSec NATIONAL_ID_TYPE National ID Type Char 4 Upper NID_COUNTRY National ID Country Char 3 Upper NID_DESCRSHORT NID Short Description Char 10 Upper APPLICATN_DATA APPLIC_PURGE_DT Application Purge Date Date 10 APP_DT Application Date Date 10 APP_PER_STATUS Applicant Status Char 1 Upper APP_STATUS Application Status Char 1 Upper APP_STATUS_DT Application Status Date Date 10 BUSINESS_UNIT Business Unit Char 5 Upper CURRENCY_CD Currency Code Char 3 Upper DESIRED_FULL_PART Full/Part-Time Char 1 Upper DESIRED_HOURS Desired Hours Per Week Nbr 2.1 DESIRED_LOCATN1 First Choice Char 10 Upper DESIRED_LOCATN2 Second Choice Char 10 Upper DESIRED_REG_TEMP Regular/Temporary Char 1 Upper DESIRED_SHIFT Desired Shift Char 1 Upper DESIRED_START_DT Desired Start Date Date 10 EMPLID EmplID Char 11 Upper EMPL_REFERRAL_ID Employee Referral ID Char 11 Upper FRI Friday Char 1 Upper LETTER_CD Letter Code Char 3 Upper LETTER_PRINTED_DT Date Letter Printed Date 10 MIN_RATE Minimum Acceptable Pay Rate Nbr 12.6 MON Monday Char 1 Upper PAY_FREQ_ABBRV Pay Frequency Char 1 Upper PREV_EMPL_BY_COMPY Previously Employed by Compny Char 1 Upper REFERRAL_SOURCE Referral Source Char 2 Upper RELATIVE_IN_COMPNY Relative in Company Char 1 Upper RELOCATE Willing to Relocate Char 1 Upper SAT Saturday Char 1 Upper SPECIFIC_REFER_SRC Specific Referral Source Char 30 Mixed SUN Sunday Char 1 Upper THURS Thursday Char 1 Upper TRAVELLING Willing to Travel Char 1 Upper TUES Tuesday Char 1 Upper UNION_CD Union Code Char 3 Upper WED Wednesday Char 1 Upper APPLICATN_ROUTE EMPLID EmplID Char 11 Upper JOBCODE Job Code Char 6 Upper JOB_REQUISITION# Job Requisition # Char 6 Num POSITION_NBR Position Number Char 8 Upper PeopleSoft Report ID: XRFRCFL CROSS REFERENCE -- RECORDS AND FIELDS Page No. 39 Run Date 05/07/2001 Run Time 10:19:43 Record Name Field Name Long Field Name Type Length Format --------------- ------------------ ------------------------------ ---- ------ ------ APPLICATN_ROUTE RESPONSE_CD Response Code Char 3 Upper RESPONSE_DT Response Date Date 10 RESPONSE_DUE_DT Response Due Date Date 10 ROUTE_DT Route Date Date 10 ROUTE_TO_ID Route To ID Char 11 Upper SETID SetID Char 5 Upper APPLIC_GBL_LNG EMPLID EmplID Char 11 Upper LANGUAGE_CD Language Code Char 3 Upper NAME Name Char 50 Name NAME_AC Alternate Character Name Char 50 Mixed APPL_RCRDS_VIEW RECNAME Record (Table) Name Char 15 Upper SQLTABLENAME SQL Table Name Char 18 Upper APPL_RECORDS RECNAME Record (Table) Name Char 15 Upper REC_USED_BY_APPL Include Record Char 1 Upper APPL_SCHFRA_LNG EMPLID EmplID Char 11 Upper LANGUAGE_CD Language Code Char 3 Upper LAST_NAME_SRCH Last Name Char 30 Upper NAME Name Char 50 Name APPL_SCHUS_LNG EMPLID EmplID Char 11 Upper LANGUAGE_CD Language Code Char 3 Upper LAST_NAME_SRCH Last Name Char 30 Upper NAME Name Char 50 Name APPL_SCH_LNG EMPLID EmplID Char 11 Upper LANGUAGE_CD Language Code Char 3 Upper LAST_NAME_SRCH Last Name Char 30 Upper NAME Name Char 50 Name APPL_SRCGBL_LNG EMPLID EmplID Char 11 Upper LANGUAGE_CD Language Code Char 3 Upper LAST_NAME_SRCH Last Name Char 30 Upper NAME Name Char 50 Name NAME_AC Alternate Character Name Char 50 Mixed APPL_SRCH EMPLID EmplID Char 11 Upper LAST_NAME_SRCH Last Name Char 30 Upper NAME Name Char 50 Name NATIONAL_ID Social Security No Char 15 CtSec NATIONAL_ID_TYPE National ID Type Char 4 Upper NID_COUNTRY National ID Country Char 3 Upper NID_DESCRSHORT NID Short Description Char 10 Upper APPL_SRCH_BEL EMPLID EmplID Char 11 Upper LAST_NAME_SRCH Last Name Char 30 Upper NAME Name Char 50 Name APPL_SRCH_CN EMPLID EmplID Char 11 Upper LAST_NAME_SRCH Last Name Char 30 Upper NAME Name Char 50 Name NATIONAL_ID Social Security No Char 15 CtSec NATIONAL_ID_TYPE National ID Type Char 4 Upper NID_COUNTRY National ID Country Char 3 Upper NID_DESCRSHORT NID Short Description Char 10 Upper APPL_SRCH_FRA EMPLID EmplID Char 11 Upper LAST_NAME_SRCH Last Name Char 30 Upper NAME Name Char 50 Name NATIONAL_ID Social Security No Char 15 CtSec NATIONAL_ID_TYPE National ID Type Char 4 Upper NID_COUNTRY National ID Country Char 3 Upper NID_DESCRSHORT NID Short Description Char 10 Upper APPL_SRCH_GBL EMPLID EmplID Char 11 Upper LAST_NAME_SRCH Last Name Char 30 Upper PeopleSoft Report ID: XRFRCFL CROSS REFERENCE -- RECORDS AND FIELDS Page No. 40 Run Date 05/07/2001 Run Time 10:19:43 Record Name Field Name Long Field Name Type Length Format --------------- ------------------ ------------------------------ ---- ------ ------ APPL_SRCH_GBL NAME Name Char 50 Name NAME_AC Alternate Character Name Char 50 Mixed NATIONAL_ID Social Security No Char 15 CtSec NATIONAL_ID_TYPE National ID Type Char 4 Upper NID_COUNTRY National ID Country Char 3 Upper NID_DESCRSHORT NID Short Description Char 10 Upper APPL_SRCH_GER EMPLID EmplID Char 11 Upper LAST_NAME_SRCH Last Name Char 30 Upper NAME Name Char 50 Name NATIONAL_ID Social Security No Char 15 CtSec NATIONAL_ID_TYPE National ID Type Char 4 Upper NID_COUNTRY National ID Country Char 3 Upper NID_DESCRSHORT NID Short Description Char 10 Upper APPL_SRCH_NLD EMPLID EmplID Char 11 Upper LAST_NAME_SRCH Last Name Char 30 Upper NAME Name Char 50 Name NATIONAL_ID Social Security No Char 15 CtSec NATIONAL_ID_TYPE National ID Type Char 4 Upper NID_COUNTRY National ID Country Char 3 Upper NID_DESCRSHORT NID Short Description Char 10 Upper APPL_SRCH_UK EMPLID EmplID Char 11 Upper LAST_NAME_SRCH Last Name Char 30 Upper NAME Name Char 50 Name NATIONAL_ID Social Security No Char 15 CtSec NATIONAL_ID_TYPE National ID Type Char 4 Upper NID_COUNTRY National ID Country Char 3 Upper NID_DESCRSHORT NID Short Description Char 10 Upper APPL_SRCH_US EMPLID EmplID Char 11 Upper LAST_NAME_SRCH Last Name Char 30 Upper NAME Name Char 50 Name NATIONAL_ID Social Security No Char 15 CtSec NATIONAL_ID_TYPE National ID Type Char 4 Upper NID_COUNTRY National ID Country Char 3 Upper NID_DESCRSHORT NID Short Description Char 10 Upper APPL_VWFRA_LNG EMPLID EmplID Char 11 Upper LANGUAGE_CD Language Code Char 3 Upper NAME Name Char 50 Name APPL_VW_LNG EMPLID EmplID Char 11 Upper LANGUAGE_CD Language Code Char 3 Upper NAME Name Char 50 Name NAME_AC Alternate Character Name Char 50 Mixed APPROP_KEY_TBL CLASS_FLD Class Field Char 5 Upper DESCR Description Char 30 Mixed EFFDT Effective Date Date 10 EFF_STATUS Status as of Effective Date Char 1 Upper SETID SetID Char 5 Upper APPRV_SRCH ACCESS_CD Access Code Char 1 Upper EFFSEQ Effective Sequence Nbr 3 EMPLID EmplID Char 11 Upper EMPL_RCD# Employment Rcd Nbr Nbr 3 JOB_EFFDT Job Effective Date Date 10 LAST_NAME_SRCH Last Name Char 30 Upper NAME Name Char 50 Name NAME_AC Alternate Character Name Char 50 Mixed NATIONAL_ID Social Security No Char 15 CtSec NATIONAL_ID_TYPE National ID Type Char 4 Upper NID_COUNTRY National ID Country Char 3 Upper NID_DESCRSHORT NID Short Description Char 10 Upper OPRCLASS Operator Class Char 8 Upper APPR_FIELDS_WRK ACTIVITYNAME Activity Name Char 30 Mixed PeopleSoft Report ID: XRFRCFL CROSS REFERENCE -- RECORDS AND FIELDS Page No. 41 Run Date 05/07/2001 Run Time 10:19:43 Record Name Field Name Long Field Name Type Length Format --------------- ------------------ ------------------------------ ---- ------ ------ APPR_FIELDS_WRK AMT1 Amount 1 Sign 13.2 AMT2 Amount 2 Sign 13.2 AMT3 Amount 3 Sign 13.2 AMT4 Amount 4 Sign 13.2 AMT5 Amount 5 Sign 13.2 APPR_ACTION Approval Action Char 1 Upper APPR_CURRENT_PATH Current Approval Path Char 1 Upper APPR_CURRENT_STEP Current Approval Step Char 1 Upper APPR_INSTANCE Approval Instance Nbr 9 APPR_RULE_SET Approval Rule Set Char 30 Mixed APPR_STATUS Approval Status Char 1 Upper APPR_VR_ROW Virtual Router Current Row Nbr 3 APP_NUMBER_PASSED Application Row# Supplied Char 1 Upper APP_ROW_NUMBER Application Row Number Nbr 3 BUSPROCNAME Business Process Name Char 30 Mixed CURRENCY_CD Currency Code Char 3 Upper CUR_RT_TYPE Exchange Rate Type Char 5 Upper EVENTNAME Event Name Char 30 Mixed FLD1 Field 1 Char 100 Mixed FLD2 Field 2 Char 100 Mixed FLD3 Field 3 Char 100 Mixed FLD4 Field 4 Char 100 Mixed FLD5 Field 5 Char 100 Mixed GET_HISTORY_SW Get History Char 1 Upper MSG_AGENT_TRIGGER Msg Agent Trigger Char 1 Upper OVERRIDE_ROLEUSER Over-ride Role User Char 30 Mixed PREV_ROLEUSER Previous Roleuser Char 30 Mixed QTY1 Quantity 1 Nbr 4.2 QTY2 Quantity 2 Nbr 4.2 QTY3 Quantity 3 Nbr 4.2 QTY4 Quantity 4 Nbr 4.2 QTY5 Quantity 5 Nbr 4.2 ROLENAME Role Name Char 30 Mixed ROLEUSER Role User Char 30 Mixed RTE_CNTL_TYPE1 Appr Field Type 1 Char 30 Mixed RTE_CNTL_TYPE2 Appr Field Type 2 Char 30 Mixed RTE_CNTL_TYPE3 Appr Field Type 3 Char 30 Mixed RTE_CNTL_TYPE4 Appr Field Type 4 Char 30 Mixed RTE_CNTL_TYPE5 Appr Field Type 5 Char 30 Mixed TREE_NAME4 Tree Name 4 Char 18 Upper UNIT_OF_MEASURE Unit of Measure Char 3 Upper APPR_INST_LOG APPR_INSTANCE Approval Instance Nbr 9 APPR_INST_STATUS Approval Instance Status Char 1 Upper APPR_PATH Approval Path Char 1 Upper APPR_RULE_SET Approval Rule Set Char 30 Mixed APPR_STEP Approval Step Char 1 Upper BUSPROCNAME Business Process Name Char 30 Mixed DTTM_STAMP Date/Time Stamp Dttm 26 Scnds ROLEUSER Role User Char 30 Mixed APPR_INST_SRCH APPR_INSTANCE Approval Instance Nbr 9 APPR_INST_TBL APPR_INSTANCE Approval Instance Nbr 9 APPR_IN_USE_SW In Use Switch Char 1 Upper APPR_INST_VW APPR_INSTANCE Approval Instance Nbr 9 APPR_INST_STATUS Approval Instance Status Char 1 Upper APPR_PATH Approval Path Char 1 Upper APPR_RULE_SET Approval Rule Set Char 30 Mixed APPR_STEP Approval Step Char 1 Upper BUSPROCNAME Business Process Name Char 30 Mixed DTTM_STAMP Date/Time Stamp Dttm 26 Scnds ROLEUSER Role User Char 30 Mixed APPR_RULE_AMT APPR_PATH Approval Path Char 1 Upper APPR_RULE_SEQ Approval Rule Sequence Nbr 1 APPR_RULE_SET Approval Rule Set Char 30 Mixed APPR_STEP Approval Step Char 1 Upper PeopleSoft Report ID: XRFRCFL CROSS REFERENCE -- RECORDS AND FIELDS Page No. 42 Run Date 05/07/2001 Run Time 10:19:43 Record Name Field Name Long Field Name Type Length Format --------------- ------------------ ------------------------------ ---- ------ ------ APPR_RULE_AMT BUSPROCNAME Business Process Name Char 30 Mixed CURRENCY_CD Currency Code Char 3 Upper EFFDT Effective Date Date 10 FIELD_PNLFIELD Field Panelfield Char 18 Upper MAX_CREDIT_AMT Minimum Sign 13.2 MAX_DEBIT_AMT Maximum Sign 13.2 RECNAME Record (Table) Name Char 15 Upper APPR_RULE_DATE APPR_PATH Approval Path Char 1 Upper APPR_RULE_SEQ Approval Rule Sequence Nbr 1 APPR_RULE_SET Approval Rule Set Char 30 Mixed APPR_STEP Approval Step Char 1 Upper BUSPROCNAME Business Process Name Char 30 Mixed DATE1_PNLFIELD Date 1 Panelfield Char 18 Upper DATE2_PNLFIELD Date 2 Panelfield Char 18 Upper DATE_OPERATION Date Operation Char 2 Upper EFFDT Effective Date Date 10 RECNAME Record (Table) Name Char 15 Upper APPR_RULE_DETL ACTIVITYNAME Activity Name Char 30 Mixed APPR_AMT_SW Approval Amount Switch Char 1 Upper APPR_FLD_SW Route Control Char 1 Upper APPR_PATH Approval Path Char 1 Upper APPR_QTY_SW Approval Quantity Switch Char 1 Upper APPR_RULE_SET Approval Rule Set Char 30 Mixed APPR_SKIP_SW Approval Skip Switch Char 1 Upper APPR_STEP Approval Step Char 1 Upper APPR_WF_ERR_SW Workflow/Error Switch Char 1 Upper BUSPROCNAME Business Process Name Char 30 Mixed DENY_ACTIVITYNAME Deny Activity Name Char 30 Mixed DENY_EVENTNAME Deny Event Char 30 Mixed EFFDT Effective Date Date 10 EVENTNAME Event Name Char 30 Mixed MESSAGE_NBR Message Number Nbr 5 MESSAGE_SET_NBR Message Set Number Nbr 5 RECYCLE_ACTIVITY Recycle Activity Name Char 30 Mixed RECYCLE_EVENTNAME Recyle Event Name Char 30 Mixed ROLENAME Role Name Char 30 Mixed APPR_RULE_FIELD APPR_PATH Approval Path Char 1 Upper APPR_RULE_SEQ Approval Rule Sequence Nbr 1 APPR_RULE_SET Approval Rule Set Char 30 Mixed APPR_STEP Approval Step Char 1 Upper BUSPROCNAME Business Process Name Char 30 Mixed EFFDT Effective Date Date 10 FIELD_PNLFIELD Field Panelfield Char 18 Upper RECNAME Record (Table) Name Char 15 Upper RTE_CNTL_TYPE Route Control Type Char 30 Mixed APPR_RULE_HDR ACTIVITYNAME Activity Name Char 30 Mixed APPR_ACTIVE_SW Approval Check Active Char 1 Upper APPR_RULE_SET Approval Rule Set Char 30 Mixed BUSPROCNAME Business Process Name Char 30 Mixed CURRENCY_CD Currency Code Char 3 Upper CUR_RT_TYPE Exchange Rate Type Char 5 Upper EVENTNAME Event Name Char 30 Mixed FIELDNAME_CUR Currency Field Char 18 Upper RECNAME_CUR Currency Record Char 15 Upper UNIT_OF_MEASURE Unit of Measure Char 3 Upper APPR_RULE_LN APPR_RULE_SET Approval Rule Set Char 30 Mixed BUSPROCNAME Business Process Name Char 30 Mixed EFFDT Effective Date Date 10 APPR_RULE_QTY APPR_PATH Approval Path Char 1 Upper APPR_RULE_SEQ Approval Rule Sequence Nbr 1 APPR_RULE_SET Approval Rule Set Char 30 Mixed APPR_STEP Approval Step Char 1 Upper BUSPROCNAME Business Process Name Char 30 Mixed PeopleSoft Report ID: XRFRCFL CROSS REFERENCE -- RECORDS AND FIELDS Page No. 43 Run Date 05/07/2001 Run Time 10:19:43 Record Name Field Name Long Field Name Type Length Format --------------- ------------------ ------------------------------ ---- ------ ------ APPR_RULE_QTY DESCR Description Char 30 Mixed EFFDT Effective Date Date 10 FIELD_PNLFIELD Field Panelfield Char 18 Upper FROM_QTY From Quantity Nbr 4.2 RECNAME Record (Table) Name Char 15 Upper TO_QTY To Quantity Nbr 4.2 APPR_RULE_ROLE APPR_PATH Approval Path Char 1 Upper APPR_RULE_SET Approval Rule Set Char 30 Mixed APPR_STEP Approval Step Char 1 Upper BUSPROCNAME Business Process Name Char 30 Mixed EFFDT Effective Date Date 10 ROLENAME Role Name Char 30 Mixed APPR_RULE_VW ACTIVITYNAME Activity Name Char 30 Mixed APPR_ACTIVE_SW Approval Check Active Char 1 Upper APPR_ACTIVITYNAME Approval Activity Name Char 30 Mixed APPR_AMT_SW Approval Amount Switch Char 1 Upper APPR_EVENTNAME Approval Event Name Char 30 Mixed APPR_FLD_SW Route Control Char 1 Upper APPR_PATH Approval Path Char 1 Upper APPR_QTY_SW Approval Quantity Switch Char 1 Upper APPR_RULE_SET Approval Rule Set Char 30 Mixed APPR_SKIP_SW Approval Skip Switch Char 1 Upper APPR_STEP Approval Step Char 1 Upper APPR_WF_ERR_SW Workflow/Error Switch Char 1 Upper BUSPROCNAME Business Process Name Char 30 Mixed CURRENCY_CD Currency Code Char 3 Upper CUR_RT_TYPE Exchange Rate Type Char 5 Upper DENY_ACTIVITYNAME Deny Activity Name Char 30 Mixed DENY_EVENTNAME Deny Event Char 30 Mixed EFFDT Effective Date Date 10 EVENTNAME Event Name Char 30 Mixed FIELDNAME_CUR Currency Field Char 18 Upper MESSAGE_NBR Message Number Nbr 5 MESSAGE_SET_NBR Message Set Number Nbr 5 RECNAME_CUR Currency Record Char 15 Upper RECYCLE_ACTIVITY Recycle Activity Name Char 30 Mixed RECYCLE_EVENTNAME Recyle Event Name Char 30 Mixed ROLENAME Role Name Char 30 Mixed UNIT_OF_MEASURE Unit of Measure Char 3 Upper APPR_VA0_WRK ACTIVITYNAME Activity Name Char 30 Mixed AMT1 Amount 1 Sign 13.2 AMT2 Amount 2 Sign 13.2 APPR_ACTION Approval Action Char 1 Upper APPR_ACTIVE_SW Approval Check Active Char 1 Upper APPR_ACTIVITYNAME Approval Activity Name Char 30 Mixed APPR_EVENTNAME Approval Event Name Char 30 Mixed APPR_INSTANCE Approval Instance Nbr 9 APPR_REQ_SW Approval Required Switch Char 1 Upper APPR_RULE_SET Approval Rule Set Char 30 Mixed APPR_TRIGGER_ACT Approval Activity Trigger Char 50 Mixed APPR_TRIGGER_BP Approval BP Trigger Char 50 Mixed APPR_TRIGGER_EVT Approval Event Trigger Char 50 Mixed APP_NUMBER_PASSED Application Row# Supplied Char 1 Upper APP_ROW_NUMBER Application Row Number Nbr 3 BUSPROCNAME Business Process Name Char 30 Mixed CONVERSION_RATE Conversion Rate Sign 7.8 CURRENCY_CD Currency Code Char 3 Upper CUR_EXCHNG_RT Exchange Rate Nbr 7.8 CUR_RT_TYPE Exchange Rate Type Char 5 Upper DENY_ACTIVITYNAME Deny Activity Name Char 30 Mixed DENY_EVENTNAME Deny Event Char 30 Mixed DTTM_STAMP Date/Time Stamp Dttm 26 Scnds EFFDT Effective Date Date 10 EVENTNAME Event Name Char 30 Mixed FUNCLIB_01 Functions Char 1 Upper FUNCLIB_02 Functions Char 1 Upper PeopleSoft Report ID: XRFRCFL CROSS REFERENCE -- RECORDS AND FIELDS Page No. 44 Run Date 05/07/2001 Run Time 10:19:43 Record Name Field Name Long Field Name Type Length Format --------------- ------------------ ------------------------------ ---- ------ ------ APPR_VA0_WRK FUNCLIB_03 Functions Char 1 Upper FUNCLIB_04 Functions Char 1 Upper RECYCLE_ACTIVITY Recycle Activity Name Char 30 Mixed RECYCLE_EVENTNAME Recyle Event Name Char 30 Mixed ROLEUSER Role User Char 30 Mixed UNIT_OF_MEASURE Unit of Measure Char 3 Upper APPR_VA1_WRK ACTIVITYNAME Activity Name Char 30 Mixed APPR_ACTION Approval Action Char 1 Upper APPR_AMT_FLAG Amount Approved Flag Char 1 Upper APPR_INSTANCE Approval Instance Nbr 9 APPR_QTY_FLAG Approval Qty Flag Char 1 Upper APPR_REQ_SW Approval Required Switch Char 1 Upper APPR_RULE_SET Approval Rule Set Char 30 Mixed APP_ROW_NUMBER Application Row Number Nbr 3 BUSPROCNAME Business Process Name Char 30 Mixed EVENTNAME Event Name Char 30 Mixed VI_ROW_NUMBER Virtual Scroll Row Number Nbr 3 APPR_VA2_WRK ACTIVITYNAME Activity Name Char 30 Mixed AMT1 Amount 1 Sign 13.2 AMT1_PNLFIELD Amount 1 Panelfield Char 35 Upper AMT2 Amount 2 Sign 13.2 AMT2_PNLFIELD Amount 2 Panelfield Char 35 Upper AMT3 Amount 3 Sign 13.2 AMT3_PNLFIELD Amount 3 Panelfield Char 35 Upper AMT4 Amount 4 Sign 13.2 AMT4_PNLFIELD Amount 4 Panelfield Char 35 Upper AMT5 Amount 5 Sign 13.2 AMT5_PNLFIELD Amount 5 Panlefield Char 35 Upper APPR_ACTION Approval Action Char 1 Upper APPR_AMT_SW Approval Amount Switch Char 1 Upper APPR_FLD_SW Route Control Char 1 Upper APPR_INST_STATUS Approval Instance Status Char 1 Upper APPR_PATH Approval Path Char 1 Upper APPR_QTY_SW Approval Quantity Switch Char 1 Upper APPR_RULE_SET Approval Rule Set Char 30 Mixed APPR_SKIP_SW Approval Skip Switch Char 1 Upper APPR_STEP Approval Step Char 1 Upper APPR_WF_ERR_SW Workflow/Error Switch Char 1 Upper BUSPROCNAME Business Process Name Char 30 Mixed DENY_ACTIVITYNAME Deny Activity Name Char 30 Mixed DENY_EVENTNAME Deny Event Char 30 Mixed EVENTNAME Event Name Char 30 Mixed FLD1 Field 1 Char 100 Mixed FLD1_FIELDVALUE Field 1 Field Value Char 30 Upper FLD1_PNLFIELD Field 1 Panelfield Char 35 Upper FLD2 Field 2 Char 100 Mixed FLD2_FIELDVALUE Field 2 Field Value Char 30 Upper FLD2_PNLFIELD Field 2 Panelfield Char 35 Upper FLD3 Field 3 Char 100 Mixed FLD3_PNLFIELD Field 3 Char 35 Upper FLD4 Field 4 Char 100 Mixed FLD4_PNLFIELD Field 4 Char 35 Upper FLD5 Field 5 Char 100 Mixed FLD5_PNLFIELD Field 5 Char 35 Upper FROM_QTY1 From Qty 1 Nbr 4.2 FROM_QTY2 From Qty 2 Nbr 4.2 FROM_QTY3 From Qty 3 Nbr 4.2 FROM_QTY4 From Qty 4 Nbr 4.2 FROM_QTY5 From Qty 5 Nbr 4.2 MAX_CREDIT_AMT1 Max Credit Amount 1 Sign 13.2 MAX_CREDIT_AMT2 Max Credit 2 Sign 13.2 MAX_CREDIT_AMT3 Max Credit 3 Sign 13.2 MAX_CREDIT_AMT4 Max Credit 4 Sign 13.2 MAX_CREDIT_AMT5 Max Credit 5 Sign 13.2 MAX_DEBIT_AMT1 Maximum Debit Amount 1 Sign 13.2 MAX_DEBIT_AMT2 Max Debit 2 Sign 13.2 MAX_DEBIT_AMT3 Max Debit 3 Sign 13.2 PeopleSoft Report ID: XRFRCFL CROSS REFERENCE -- RECORDS AND FIELDS Page No. 45 Run Date 05/07/2001 Run Time 10:19:43 Record Name Field Name Long Field Name Type Length Format --------------- ------------------ ------------------------------ ---- ------ ------ APPR_VA2_WRK MAX_DEBIT_AMT4 Max Debit 4 Sign 13.2 MAX_DEBIT_AMT5 Max Debit 5 Sign 13.2 MESSAGE_NBR Message Number Nbr 5 MESSAGE_SET_NBR Message Set Number Nbr 5 QTY1 Quantity 1 Nbr 4.2 QTY1_PNLFIELD Qty1 Panelfield Char 35 Upper QTY2 Quantity 2 Nbr 4.2 QTY2_PNLFIELD Qty2 Field Char 35 Upper QTY3 Quantity 3 Nbr 4.2 QTY3_PNLFIELD Qty3 Field Char 35 Upper QTY4 Quantity 4 Nbr 4.2 QTY4_PNLFIELD Qty4 Field Char 35 Upper QTY5 Quantity 5 Nbr 4.2 QTY5_PNLFIELD Qty5 Field Char 35 Upper RECYCLE_ACTIVITY Recycle Activity Name Char 30 Mixed RECYCLE_EVENTNAME Recyle Event Name Char 30 Mixed ROLENAME Role Name Char 30 Mixed ROLEUSER Role User Char 30 Mixed RTE_CNTL_TYPE1 Appr Field Type 1 Char 30 Mixed RTE_CNTL_TYPE2 Appr Field Type 2 Char 30 Mixed RTE_CNTL_TYPE3 Appr Field Type 3 Char 30 Mixed RTE_CNTL_TYPE4 Appr Field Type 4 Char 30 Mixed RTE_CNTL_TYPE5 Appr Field Type 5 Char 30 Mixed TO_QTY1 To Qty1 Nbr 4.2 TO_QTY2 To Qty2 Nbr 4.2 TO_QTY3 To Qty3 Nbr 4.2 TO_QTY4 To Qty4 Nbr 4.2 TO_QTY5 To Qty5 Nbr 4.2 APP_EMPSRCH_BEL EMPLID EmplID Char 11 Upper EMPL_RCD# Employment Rcd Nbr Nbr 3 LAST_NAME_SRCH Last Name Char 30 Upper NAME Name Char 50 Name NATIONAL_ID Social Security No Char 15 CtSec NATIONAL_ID_TYPE National ID Type Char 4 Upper NID_COUNTRY National ID Country Char 3 Upper NID_DESCRSHORT NID Short Description Char 10 Upper APP_EXPENSES BUSINESS_UNIT Business Unit Char 5 Upper CHARGE_DT Charge Date Date 10 CURRENCY_CD Currency Code Char 3 Upper DEPTID Department Char 10 Upper EMPLID EmplID Char 11 Upper EXPENSE_AMT Expense Amount Sign 15.3 EXPENSE_CD Expense Code Char 2 Upper JOBCODE Job Code Char 6 Upper JOB_REQUISITION# Job Requisition # Char 6 Num POSITION_NBR Position Number Char 8 Upper SETID SetID Char 5 Upper APP_GEOG_PREFER APP_DT Application Date Date 10 EMPLID EmplID Char 11 Upper GEOG_PREFERENCE Geographic Preferences Char 2 Upper APP_RTE_JOB_REQ EMPLID EmplID Char 11 Upper JOBCODE Job Code Char 6 Upper JOB_REQUISITION# Job Requisition # Char 6 Num POSITION_NBR Position Number Char 8 Upper RESPONSE_CD Response Code Char 3 Upper RESPONSE_DT Response Date Date 10 ROUTE_DT Route Date Date 10 ROUTE_TO_ID Route To ID Char 11 Upper SETID SetID Char 5 Upper APRV_SCH_LNG EFFSEQ Effective Sequence Nbr 3 EMPLID EmplID Char 11 Upper EMPL_RCD# Employment Rcd Nbr Nbr 3 JOB_EFFDT Job Effective Date Date 10 LANGUAGE_CD Language Code Char 3 Upper PeopleSoft Report ID: XRFRCFL CROSS REFERENCE -- RECORDS AND FIELDS Page No. 46 Run Date 05/07/2001 Run Time 10:19:43 Record Name Field Name Long Field Name Type Length Format --------------- ------------------ ------------------------------ ---- ------ ------ APRV_SCH_LNG LAST_NAME_SRCH Last Name Char 30 Upper NAME Name Char 50 Name NAME_AC Alternate Character Name Char 50 Mixed OPRCLASS Operator Class Char 8 Upper ASGN_CMPSRC_LNG EMPLID EmplID Char 11 Upper LANGUAGE_CD Language Code Char 3 Upper LAST_NAME_SRCH Last Name Char 30 Upper NAME Name Char 50 Name NAME_AC Alternate Character Name Char 50 Mixed OPRCLASS Operator Class Char 8 Upper PAY_INSTR_TYPE Payment Instruction Type Char 1 Upper ASGN_CMP_EFFDT ASGN_COMP_FREQ Amount Frequency Char 1 Upper EFFDT Effective Date Date 10 EMPLID EmplID Char 11 Upper PAY_INSTR_TYPE Payment Instruction Type Char 1 Upper ASGN_CMP_HOMHST CUR_EXCHNG_RT Exchange Rate Nbr 7.8 CUR_RT_TYPE Exchange Rate Type Char 5 Upper EFFDT Effective Date Date 10 EMPLID EmplID Char 11 Upper FROM_CUR From Currency Code Char 3 Upper HOME_HOST Home or Host Char 1 Upper PAY_INSTR_TYPE Payment Instruction Type Char 1 Upper TO_CUR To Currency Code Char 3 Upper ASGN_CMP_SCH_JP ACCESS_CD Access Code Char 1 Upper EMPLID EmplID Char 11 Upper LAST_NAME_SRCH Last Name Char 30 Upper NAME Name Char 50 Name NAME_AC Alternate Character Name Char 50 Mixed NATIONAL_ID Social Security No Char 15 CtSec NATIONAL_ID_TYPE National ID Type Char 4 Upper NID_COUNTRY National ID Country Char 3 Upper NID_DESCRSHORT NID Short Description Char 10 Upper OPRCLASS Operator Class Char 8 Upper PAY_INSTR_TYPE Payment Instruction Type Char 1 Upper ASGN_CMP_SRCH ACCESS_CD Access Code Char 1 Upper EMPLID EmplID Char 11 Upper LAST_NAME_SRCH Last Name Char 30 Upper NAME Name Char 50 Name NAME_AC Alternate Character Name Char 50 Mixed NATIONAL_ID Social Security No Char 15 CtSec NATIONAL_ID_TYPE National ID Type Char 4 Upper NID_COUNTRY National ID Country Char 3 Upper NID_DESCRSHORT NID Short Description Char 10 Upper OPRCLASS Operator Class Char 8 Upper PAY_INSTR_TYPE Payment Instruction Type Char 1 Upper ASGN_DEDUCTIONS DEDCD Deduction Code Char 6 Upper EFFDT Effective Date Date 10 EMPLID EmplID Char 11 Upper HOME_AMT Home Amount Nbr 10.2 HOME_HOST Home or Host Char 1 Upper HOST_AMT Host Amount Nbr 10.2 PAY_INSTR_TYPE Payment Instruction Type Char 1 Upper ASGN_EARNINGS BASE_COMP Base Compensation Char 1 Upper EFFDT Effective Date Date 10 EMPLID EmplID Char 11 Upper ERNCD Earnings Code Char 3 Upper HOME_AMT Home Amount Nbr 10.2 HOME_HOST Home or Host Char 1 Upper HOST_AMT Host Amount Nbr 10.2 PAY_INSTR_TYPE Payment Instruction Type Char 1 Upper ASGN_HOME_HOST BEGIN_DT Begin Date Date 10 PeopleSoft Report ID: XRFRCFL CROSS REFERENCE -- RECORDS AND FIELDS Page No. 47 Run Date 05/07/2001 Run Time 10:19:43 Record Name Field Name Long Field Name Type Length Format --------------- ------------------ ------------------------------ ---- ------ ------ ASGN_HOME_HOST EMPLID EmplID Char 11 Upper HOME_HOST Home or Host Char 1 Upper HOME_HOST_EMPL_RCD Home/Host Employment Record # Char 3 Upper ASGN_HOMHST_VW EFFDT Effective Date Date 10 EMPLID EmplID Char 11 Upper HOME_HOST Home or Host Char 1 Upper HOME_HOST_EMPL_RCD Home/Host Employment Record # Char 3 Upper ASSGNMT_LNG BEGIN_DT Begin Date Date 10 CITY City Char 30 Upper COMMENTS Comments Long 0 CONTACT_ID Company Contact ID Char 11 Upper EMPLID EmplID Char 11 Upper LANGUAGE_CD Language Code Char 3 Upper ASSGN_SUM_VW ASSGN_TYPE Assignment Type Char 3 Upper BEGIN_DT Begin Date Date 10 EMPLID EmplID Char 11 Upper END_DT End Date Date 10 HOME_HOST Home or Host Char 1 Upper HOME_HOST_EMPL_RCD Home/Host Employment Record # Char 3 Upper ASSGN_TYPE_LANG ASSGN_TYPE Assignment Type Char 3 Upper DESCR Description Char 30 Mixed DESCRSHORT Short Description Char 10 Mixed EFFDT Effective Date Date 10 LANGUAGE_CD Language Code Char 3 Upper ASSGN_TYPE_TBL ASSGN_TYPE Assignment Type Char 3 Upper DESCR Description Char 30 Mixed DESCRSHORT Short Description Char 10 Mixed EFFDT Effective Date Date 10 EFF_STATUS Status as of Effective Date Char 1 Upper ASSIGNMENT ASSGN_TYPE Assignment Type Char 3 Upper BEGIN_DT Begin Date Date 10 CITY City Char 30 Upper COMMENTS Comments Long 0 CONTACT_ID Company Contact ID Char 11 Upper COUNTRY Country Char 3 Upper DT_ARRIVE Arrival Date Date 10 DT_DEPART Departure Date Date 10 EMPLID EmplID Char 11 Upper END_DT End Date Date 10 STATE State Char 6 Upper ASSIGNMENT_VW ASSGN_TYPE Assignment Type Char 3 Upper BEGIN_DT Begin Date Date 10 CITY City Char 30 Upper COUNTRY Country Char 3 Upper EFFDT Effective Date Date 10 EMPLID EmplID Char 11 Upper END_DT End Date Date 10 STATE State Char 6 Upper AUDIOMETRIC_LNG COMMENTS Comments Long 0 DESCR Description Char 30 Mixed EMPLID EmplID Char 11 Upper EXAM_DT Exam Date Date 10 EXAM_TYPE_CD Type of Exam Char 3 Upper LANGUAGE_CD Language Code Char 3 Upper PHYSICIAN_NAME Physician Name Char 50 Mixed AUDIOMETRIC_TST AUDIOMTR_SERIAL# Audiometer Serial # Char 5 Upper BASELINE Baseline Char 1 Upper COMMENTS Comments Long 0 DESCR Description Char 30 Mixed EMPLID EmplID Char 11 Upper PeopleSoft Report ID: XRFRCFL CROSS REFERENCE -- RECORDS AND FIELDS Page No. 48 Run Date 05/07/2001 Run Time 10:19:43 Record Name Field Name Long Field Name Type Length Format --------------- ------------------ ------------------------------ ---- ------ ------ AUDIOMETRIC_TST EXAM_DT Exam Date Date 10 EXAM_TYPE_CD Type of Exam Char 3 Upper HEARING_CLASS Hearing Classification Char 2 Upper LF_1000_DB Left 1000 Decibel Nbr 3 LF_1000_FREQ Left 1000 Frequency Char 1 Upper LF_2000_DB Left 2000 Decibel Nbr 3 LF_2000_FREQ Left 2000 Frequency Char 1 Upper LF_250_DB Left 250 Decibel Nbr 3 LF_250_FREQ Left 250 Frequency Char 1 Upper LF_3000_DB Left 3000 Decibel Nbr 3 LF_3000_FREQ Left 3000 Frequency Char 1 Upper LF_4000_DB Left 4000 Decibel Nbr 3 LF_4000_FREQ Left 4000 Frequency Char 1 Upper LF_5000_DB Left 5000 Decibel Nbr 3 LF_5000_FREQ Left 5000 Frequency Char 1 Upper LF_500_DB Left 500 Decibel Nbr 3 LF_500_FREQ Left 500 Frequency Char 1 Upper LF_6000_DB Left 6000 Decibel Nbr 3 LF_6000_FREQ Left 6000 Frequency Char 1 Upper LF_7000_DB Left 7000 Decibel Nbr 3 LF_7000_FREQ Left 7000 Frequency Char 1 Upper LF_8000_DB Left 8000 Decibel Nbr 3 LF_8000_FREQ Left 8000 Frequency Char 1 Upper NEXT_EXAM_DT Next Exam Date Date 10 PHYSICIAN_ID Physician ID Char 11 Num PHYSICIAN_NAME Physician Name Char 50 Mixed REFERRAL Referral Char 1 Upper RT_1000_DB Right 1000 Decibel Nbr 3 RT_1000_FREQ Right 1000 Frequency Char 1 Upper RT_2000_DB Right 2000 Decibel Nbr 3 RT_2000_FREQ Right 2000 Frequency Char 1 Upper RT_250_DB Right 250 Decibel Nbr 3 RT_250_FREQ Right 250 Frequency Char 1 Upper RT_3000_DB Right 3000 Decibel Nbr 3 RT_3000_FREQ Right 3000 Frequency Char 1 Upper RT_4000_DB Right 4000 Decibel Nbr 3 RT_4000_FREQ Right 4000 Frequency Char 1 Upper RT_5000_DB Right 5000 Decibel Nbr 3 RT_5000_FREQ Right 5000 Frequency Char 1 Upper RT_500_DB Right 500 Decibel Nbr 3 RT_500_FREQ Right 500 Frequency Char 1 Upper RT_6000_DB Right 6000 Decibel Nbr 3 RT_6000_FREQ Right 6000 Frequency Char 1 Upper RT_7000_DB Right 7000 Decibel Nbr 3 RT_7000_FREQ Right 7000 Frequency Char 1 Upper RT_8000_DB Right 8000 Decibel Nbr 3 RT_8000_FREQ Right 8000 Frequency Char 1 Upper AUDIO_TST_LANG COMMENTS Comments Long 0 DESCR Description Char 30 Mixed EMPLID EmplID Char 11 Upper EXAM_DT Exam Date Date 10 EXAM_TYPE_CD Type of Exam Char 3 Upper LANGUAGE_CD Language Code Char 3 Upper AUDIT_PERSONAL AUDIT_ACTN Action Char 1 Upper AUDIT_OPRID Operator ID Char 8 Upper AUDIT_STAMP Date and Time Stamp Dttm 26 McroS EMPLID EmplID Char 11 Upper NAME Name Char 50 Name PER_STATUS Personnel Status Char 1 Upper SIN Social Insurance # Char 9 SIN SSN Social Security # Char 9 SSN AUTHORITY_LANG AUTHORITY_CD Authority Char 4 Upper DESCR50 Description Char 50 Mixed DESCRSHORT Short Description Char 10 Mixed EFFDT Effective Date Date 10 LANGUAGE_CD Language Code Char 3 Upper PeopleSoft Report ID: XRFRCFL CROSS REFERENCE -- RECORDS AND FIELDS Page No. 49 Run Date 05/07/2001 Run Time 10:19:43 Record Name Field Name Long Field Name Type Length Format --------------- ------------------ ------------------------------ ---- ------ ------ BALANCES_LNG_VW BALANCE_ID Balance ID Char 2 Upper BALANCE_PERIOD Balances for Period Nbr 3 BALANCE_QTR Balances for Quarter Nbr 3 BALANCE_YEAR Balances for Year Nbr 4 BEGIN_DT Begin Date Date 10 DESCRSHORT Short Description Char 10 Mixed DETL_PERIOD_FROM Detail Calendar From Period Nbr 3 DETL_PERIOD_TO Detail Calendar To Period Nbr 3 END_DT End Date Date 10 LANGUAGE_CD Language Code Char 3 Upper SETID SetID Char 5 Upper BALANCES_VW BALANCE_ID Balance ID Char 2 Upper BALANCE_PERIOD Balances for Period Nbr 3 BALANCE_QTR Balances for Quarter Nbr 3 BALANCE_YEAR Balances for Year Nbr 4 BEGIN_DT Begin Date Date 10 DESCRSHORT Short Description Char 10 Mixed DETL_PERIOD_FROM Detail Calendar From Period Nbr 3 DETL_PERIOD_TO Detail Calendar To Period Nbr 3 END_DT End Date Date 10 SETID SetID Char 5 Upper BALANCE_ID_DEF BALANCE_ID Balance ID Char 2 Upper BALANCE_PERIOD Balances for Period Nbr 3 BALANCE_YEAR Balances for Year Nbr 4 BEGIN_DT Begin Date Date 10 END_DT End Date Date 10 PERIOD_ABBRV Abbreviation Char 3 Mixed PERIOD_NAME Period Name Char 30 Mixed SETID SetID Char 5 Upper BALANCE_ID_LANG BALANCE_ID Balance ID Char 2 Upper DESCR Description Char 30 Mixed DESCRSHORT Short Description Char 10 Mixed LANGUAGE_CD Language Code Char 3 Upper SETID SetID Char 5 Upper BALANCE_ID_QTR BALANCE_ID Balance ID Char 2 Upper BALANCE_QTR Balances for Quarter Nbr 3 BALANCE_YEAR Balances for Year Nbr 4 DETL_PERIOD_FROM Detail Calendar From Period Nbr 3 DETL_PERIOD_TO Detail Calendar To Period Nbr 3 PERIOD_ABBRV Abbreviation Char 3 Mixed PERIOD_NAME Period Name Char 30 Mixed SETID SetID Char 5 Upper BALANCE_ID_TBL BALANCE_ID Balance ID Char 2 Upper BAL_FOR_CAL_YEAR Balances for Calendar Year Char 1 Upper DATE_TO_USE Date to Use Char 1 Upper DESCR Description Char 30 Mixed DESCRSHORT Short Description Char 10 Mixed MAINTAIN_CHK_BAL Maintain Check Balance Char 1 Upper MAINTAIN_DED_BAL Maintain Deduction Balance Char 1 Upper MAINTAIN_EARN_BAL Maintain Earnings Balance Char 1 Upper MAINTAIN_GARN_BAL Maintain Garnishments Balance Char 1 Upper MAINTAIN_TAX_BAL Maintain Tax Balance Char 1 Upper NUMBER_OF_PERIODS Periods in a Year Nbr 3 NUMBER_OF_QTRS Quarters in a Year Nbr 3 SETID SetID Char 5 Upper BALANCE_YR_VW BALANCE_ID Balance ID Char 2 Upper BALANCE_YEAR Balances for Year Nbr 4 SETID SetID Char 5 Upper BALPRD_NO_CO_VW BALANCE_ID Balance ID Char 2 Upper BALANCE_PERIOD Balances for Period Nbr 3 BALANCE_YEAR Balances for Year Nbr 4 PeopleSoft Report ID: XRFRCFL CROSS REFERENCE -- RECORDS AND FIELDS Page No. 50 Run Date 05/07/2001 Run Time 10:19:43 Record Name Field Name Long Field Name Type Length Format --------------- ------------------ ------------------------------ ---- ------ ------ BALQTR_NO_CO_V BALANCE_ID Balance ID Char 2 Upper BALANCE_QTR Balances for Quarter Nbr 3 BALANCE_YEAR Balances for Year Nbr 4 BAL_ADJ_ARR ADJ_REASON Adjustment Reason Char 50 Mixed ARREARS_BAL Arrears Balance Sign 8.2 ARR_ADJ Arrears Balance Adjustment Sign 8.2 BAL_ADJ_SEQ Balance Adjust Sequence Number Nbr 3 BENEFIT_PLAN Benefit Plan Char 6 Upper COMPANY Company Char 3 Upper DEDCD Deduction Code Char 6 Upper DED_CLASS Deduction Classification Char 1 Upper DT_ENTERED Date Entered Date 10 EMPLID EmplID Char 11 Upper PLAN_TYPE Plan Type Char 2 Upper BAL_ADJ_CHK ADJ_REASON Adjustment Reason Char 50 Mixed BALANCE_ID Balance ID Char 2 Upper BALANCE_PERIOD Balances for Period Nbr 3 BALANCE_QTR Balances for Quarter Nbr 3 BALANCE_YEAR Balances for Year Nbr 4 BAL_ADJ_SEQ Balance Adjust Sequence Number Nbr 3 COMPANY Company Char 3 Upper DT_ENTERED Date Entered Date 10 EMPLID EmplID Char 11 Upper NET_PAY_ADJ Net Pay Adjustment Sign 8.2 NET_PAY_YTD Net Pay YTD Sign 8.2 NET_PAY_YTD_ADJ Net Pay YTD Adjusted Sign 8.2 TOTAL_DEDNS_YTD Total Deductions YTD Sign 8.2 TOTAL_GROSS_YTD Total Gross YTD Sign 8.2 TOTAL_TAXES_YTD Total Taxes YTD Sign 8.2 TOT_DED_ADJ Total Deductions Adjustment Sign 8.2 TOT_DED_YTD_ADJ Total Deductions YTD Adjusted Sign 8.2 TOT_GRS_ADJ Total Gross Adjustment Sign 8.2 TOT_GRS_YTD_ADJ Total Gross YTD Adjusted Sign 8.2 TOT_TAX_ADJ Total Taxes Adjustment Sign 8.2 TOT_TAX_YTD_ADJ Total Taxes YTD Adjusted Sign 8.2 BAL_ADJ_CN_CHK ADJ_REASON Adjustment Reason Char 50 Mixed BALANCE_ID Balance ID Char 2 Upper BALANCE_PERIOD Balances for Period Nbr 3 BALANCE_QTR Balances for Quarter Nbr 3 BALANCE_YEAR Balances for Year Nbr 4 BAL_ADJ_SEQ Balance Adjust Sequence Number Nbr 3 COMPANY Company Char 3 Upper DT_ENTERED Date Entered Date 10 EMPLID EmplID Char 11 Upper NET_PAY_ADJ Net Pay Adjustment Sign 8.2 NET_PAY_YTD Net Pay YTD Sign 8.2 NET_PAY_YTD_ADJ Net Pay YTD Adjusted Sign 8.2 PROVINCE Province Char 6 Upper TOTAL_DEDNS_YTD Total Deductions YTD Sign 8.2 TOTAL_GROSS_YTD Total Gross YTD Sign 8.2 TOTAL_TAXES_YTD Total Taxes YTD Sign 8.2 TOT_DED_ADJ Total Deductions Adjustment Sign 8.2 TOT_DED_YTD_ADJ Total Deductions YTD Adjusted Sign 8.2 TOT_GRS_ADJ Total Gross Adjustment Sign 8.2 TOT_GRS_YTD_ADJ Total Gross YTD Adjusted Sign 8.2 TOT_TAX_ADJ Total Taxes Adjustment Sign 8.2 TOT_TAX_YTD_ADJ Total Taxes YTD Adjusted Sign 8.2 WAGE_LOSS_PLAN Wage Loss Replacement Plan Char 3 Upper BAL_ADJ_CN_DED ADJ_REASON Adjustment Reason Char 50 Mixed BALANCE_ID Balance ID Char 2 Upper BALANCE_PERIOD Balances for Period Nbr 3 BALANCE_QTR Balances for Quarter Nbr 3 BALANCE_YEAR Balances for Year Nbr 4 BAL_ADJ_SEQ Balance Adjust Sequence Number Nbr 3 PeopleSoft Report ID: XRFRCFL CROSS REFERENCE -- RECORDS AND FIELDS Page No. 51 Run Date 05/07/2001 Run Time 10:19:43 Record Name Field Name Long Field Name Type Length Format --------------- ------------------ ------------------------------ ---- ------ ------ BAL_ADJ_CN_DED BENEFIT_PLAN Benefit Plan Char 6 Upper COMPANY Company Char 3 Upper DEDCD Deduction Code Char 6 Upper DED_ADJ Deduction Balance Adjustment Sign 8.2 DED_CLASS Deduction Classification Char 1 Upper DED_MTD Deduction Balance MTD Sign 8.2 DED_MTD_ADJ Deduction Balance MTD Adjusted Sign 8.2 DED_QTD Deduction Balance QTD Sign 8.2 DED_QTD_ADJ Deduction Balance QTD Adjusted Sign 8.2 DED_SLSTX_CLASS Sales Tax Type Char 1 Upper DED_YTD Deduction Balance YTD Sign 8.2 DED_YTD_ADJ Deduction Balance YTD Adjusted Sign 8.2 DT_ENTERED Date Entered Date 10 EMPLID EmplID Char 11 Upper PLAN_TYPE Plan Type Char 2 Upper PROVINCE Province Char 6 Upper WAGE_LOSS_PLAN Wage Loss Replacement Plan Char 3 Upper BAL_ADJ_CN_ERN ADJ_REASON Adjustment Reason Char 50 Mixed BALANCE_ID Balance ID Char 2 Upper BALANCE_PERIOD Balances for Period Nbr 3 BALANCE_QTR Balances for Quarter Nbr 3 BALANCE_YEAR Balances for Year Nbr 4 BAL_ADJ_SEQ Balance Adjust Sequence Number Nbr 3 COMPANY Company Char 3 Upper DT_ENTERED Date Entered Date 10 EMPLID EmplID Char 11 Upper ERNCD Earnings Code Char 3 Upper GRS_ADJ Gross Earnings Adjustment Sign 8.2 GRS_MTD Gross Earnings MTD Sign 8.2 GRS_MTD_ADJ Gross Earnings MTD Adjusted Sign 8.2 GRS_QTD Gross Earnings QTD Sign 8.2 GRS_QTD_ADJ Gross Earnings QTD Adjusted Sign 8.2 GRS_YTD Gross Earnings YTD Sign 8.2 GRS_YTD_ADJ Gross Earnings YTD Adjusted Sign 8.2 HRS_ADJ Hours Adjustment Sign 4.2 HRS_MTD Hours Mtd Sign 4.2 HRS_MTD_ADJ Hours MTD Adjusted Sign 4.2 HRS_QTD Hours QTD Sign 4.2 HRS_QTD_ADJ Hours QTD Adjusted Sign 4.2 HRS_YTD Hours YTD Sign 4.2 HRS_YTD_ADJ Hours YTD Adjusted Sign 4.2 PROVINCE Province Char 6 Upper SPCL_BALANCE Special Balance Char 1 Upper WAGE_LOSS_PLAN Wage Loss Replacement Plan Char 3 Upper BAL_ADJ_CN_TAX ADJ_REASON Adjustment Reason Char 50 Mixed BALANCE_ID Balance ID Char 2 Upper BALANCE_PERIOD Balances for Period Nbr 3 BALANCE_QTR Balances for Quarter Nbr 3 BALANCE_YEAR Balances for Year Nbr 4 BAL_ADJ_SEQ Balance Adjust Sequence Number Nbr 3 COMPANY Company Char 3 Upper DT_ENTERED Date Entered Date 10 EMPLID EmplID Char 11 Upper NLGRS_ADJ No Limit Gross Adjustment Sign 8.2 NLGRS_MTD No Limit Gross MTD Sign 8.2 NLGRS_MTD_ADJ No Limit Gross MTD Adjusted Sign 8.2 NLGRS_QTD No Limit Gross QTD Sign 8.2 NLGRS_QTD_ADJ No Limit Gross QTD Adjusted Sign 8.2 NLGRS_YTD No Limit Gross YTD Sign 8.2 NLGRS_YTD_ADJ No Limit Gross YTD Adjusted Sign 8.2 PROVINCE Province Char 6 Upper TAX_ADJ Tax Adjustment Sign 8.2 TAX_CLASS_CAN Canadian Tax Type Char 3 Upper TAX_MTD Tax MTD Sign 8.2 TAX_MTD_ADJ Tax MTD Adjusted Sign 8.2 TAX_QTD Tax QTD Sign 8.2 TAX_QTD_ADJ Tax QTD Adjusted Sign 8.2 PeopleSoft Report ID: XRFRCFL CROSS REFERENCE -- RECORDS AND FIELDS Page No. 52 Run Date 05/07/2001 Run Time 10:19:43 Record Name Field Name Long Field Name Type Length Format --------------- ------------------ ------------------------------ ---- ------ ------ BAL_ADJ_CN_TAX TAX_YTD Tax YTD Sign 8.2 TAX_YTD_ADJ Tax YTD Adjusted Sign 8.2 TXGRS_ADJ Taxable Gross Adjustment Sign 8.2 TXGRS_MTD Taxable Gross MTD Sign 8.2 TXGRS_MTD_ADJ Taxable Gross MTD Adjusted Sign 8.2 TXGRS_QTD Taxable Gross QTD Sign 8.2 TXGRS_QTD_ADJ Taxable Gross QTD Adjusted Sign 8.2 TXGRS_YTD Taxable Gross YTD Sign 8.2 TXGRS_YTD_ADJ Taxable Gross YTD Adjusted Sign 8.2 WAGE_LOSS_PLAN Wage Loss Replacement Plan Char 3 Upper BAL_ADJ_DED ADJ_REASON Adjustment Reason Char 50 Mixed BALANCE_ID Balance ID Char 2 Upper BALANCE_PERIOD Balances for Period Nbr 3 BALANCE_QTR Balances for Quarter Nbr 3 BALANCE_YEAR Balances for Year Nbr 4 BAL_ADJ_SEQ Balance Adjust Sequence Number Nbr 3 BENEFIT_PLAN Benefit Plan Char 6 Upper COMPANY Company Char 3 Upper DEDCD Deduction Code Char 6 Upper DED_ADJ Deduction Balance Adjustment Sign 8.2 DED_CLASS Deduction Classification Char 1 Upper DED_MTD Deduction Balance MTD Sign 8.2 DED_MTD_ADJ Deduction Balance MTD Adjusted Sign 8.2 DED_QTD Deduction Balance QTD Sign 8.2 DED_QTD_ADJ Deduction Balance QTD Adjusted Sign 8.2 DED_YTD Deduction Balance YTD Sign 8.2 DED_YTD_ADJ Deduction Balance YTD Adjusted Sign 8.2 DT_ENTERED Date Entered Date 10 EMPLID EmplID Char 11 Upper PLAN_TYPE Plan Type Char 2 Upper BAL_ADJ_ERN ADJ_REASON Adjustment Reason Char 50 Mixed BALANCE_ID Balance ID Char 2 Upper BALANCE_PERIOD Balances for Period Nbr 3 BALANCE_QTR Balances for Quarter Nbr 3 BALANCE_YEAR Balances for Year Nbr 4 BAL_ADJ_SEQ Balance Adjust Sequence Number Nbr 3 COMPANY Company Char 3 Upper DT_ENTERED Date Entered Date 10 EMPLID EmplID Char 11 Upper ERNCD Earnings Code Char 3 Upper GRS_ADJ Gross Earnings Adjustment Sign 8.2 GRS_MTD Gross Earnings MTD Sign 8.2 GRS_MTD_ADJ Gross Earnings MTD Adjusted Sign 8.2 GRS_QTD Gross Earnings QTD Sign 8.2 GRS_QTD_ADJ Gross Earnings QTD Adjusted Sign 8.2 GRS_YTD Gross Earnings YTD Sign 8.2 GRS_YTD_ADJ Gross Earnings YTD Adjusted Sign 8.2 HRS_ADJ Hours Adjustment Sign 4.2 HRS_MTD Hours Mtd Sign 4.2 HRS_MTD_ADJ Hours MTD Adjusted Sign 4.2 HRS_QTD Hours QTD Sign 4.2 HRS_QTD_ADJ Hours QTD Adjusted Sign 4.2 HRS_YTD Hours YTD Sign 4.2 HRS_YTD_ADJ Hours YTD Adjusted Sign 4.2 SPCL_BALANCE Special Balance Char 1 Upper BAL_ADJ_GRN ADJ_REASON Adjustment Reason Char 50 Mixed BALANCE_ID Balance ID Char 2 Upper BALANCE_PERIOD Balances for Period Nbr 3 BALANCE_QTR Balances for Quarter Nbr 3 BALANCE_YEAR Balances for Year Nbr 4 BAL_ADJ_SEQ Balance Adjust Sequence Number Nbr 3 BENEFIT_PLAN Benefit Plan Char 6 Upper COMPANY Company Char 3 Upper DEDCD Deduction Code Char 6 Upper DED_ADJ Deduction Balance Adjustment Sign 8.2 DED_CFEE_ADJ Ded Cpmny Fee Bal Adjustment Sign 8.2 PeopleSoft Report ID: XRFRCFL CROSS REFERENCE -- RECORDS AND FIELDS Page No. 53 Run Date 05/07/2001 Run Time 10:19:43 Record Name Field Name Long Field Name Type Length Format --------------- ------------------ ------------------------------ ---- ------ ------ BAL_ADJ_GRN DED_CFEE_MTD Ded Company Fee Balance MTD Sign 8.2 DED_CFEE_MTD_ADJ Ded Cmpny Fee Bal MTD Adjusted Sign 8.2 DED_CFEE_QTD Ded Company Fee Balance QTD Sign 8.2 DED_CFEE_QTD_ADJ Ded Cmpny Fee Bal QTD Adjusted Sign 8.2 DED_CFEE_YTD Ded Company Fee Balance YTD Sign 8.2 DED_CFEE_YTD_ADJ Ded Cmpny Fee Bal YTD Adjusted Sign 8.2 DED_CLASS Deduction Classification Char 1 Upper DED_GARN_ADJ Deduction Garn Bal Adjustment Sign 8.2 DED_GARN_MTD Deduction Garnish Balance MTD Sign 8.2 DED_GARN_MTD_ADJ Deduction Grn Bal MTD Adjusted Sign 8.2 DED_GARN_QTD Deduction Garnish Balance QTD Sign 8.2 DED_GARN_QTD_ADJ Deduction Grn Bal QTD Adjusted Sign 8.2 DED_GARN_YTD Deduction Garnish Balance YTD Sign 8.2 DED_GARN_YTD_ADJ Deduction Grn Bal YTD Adjusted Sign 8.2 DED_MTD Deduction Balance MTD Sign 8.2 DED_MTD_ADJ Deduction Balance MTD Adjusted Sign 8.2 DED_PFEE_ADJ Ded Payee Fee Bal Adjustment Sign 8.2 DED_PFEE_MTD Ded Payee Fee Balance MTD Sign 8.2 DED_PFEE_MTD_ADJ Ded Payee Fee Bal MTD Adjusted Sign 8.2 DED_PFEE_QTD Ded Payee Fee Balance QTD Sign 8.2 DED_PFEE_QTD_ADJ Ded Payee Fee Bal QTD Adjusted Sign 8.2 DED_PFEE_YTD Ded Payee Fee Balance YTD Sign 8.2 DED_PFEE_YTD_ADJ Ded Payee Fee Bal YTD Adjusted Sign 8.2 DED_QTD Deduction Balance QTD Sign 8.2 DED_QTD_ADJ Deduction Balance QTD Adjusted Sign 8.2 DED_YTD Deduction Balance YTD Sign 8.2 DED_YTD_ADJ Deduction Balance YTD Adjusted Sign 8.2 DT_ENTERED Date Entered Date 10 EMPLID EmplID Char 11 Upper GARNID Garnish ID Char 6 Upper PLAN_TYPE Plan Type Char 2 Upper BAL_ADJ_TAX ADJ_REASON Adjustment Reason Char 50 Mixed BALANCE_ID Balance ID Char 2 Upper BALANCE_PERIOD Balances for Period Nbr 3 BALANCE_QTR Balances for Quarter Nbr 3 BALANCE_YEAR Balances for Year Nbr 4 BAL_ADJ_SEQ Balance Adjust Sequence Number Nbr 3 COMPANY Company Char 3 Upper DT_ENTERED Date Entered Date 10 EMPLID EmplID Char 11 Upper LOCALITY Locality Char 10 Upper NLGRS_ADJ No Limit Gross Adjustment Sign 8.2 NLGRS_MTD No Limit Gross MTD Sign 8.2 NLGRS_MTD_ADJ No Limit Gross MTD Adjusted Sign 8.2 NLGRS_QTD No Limit Gross QTD Sign 8.2 NLGRS_QTD_ADJ No Limit Gross QTD Adjusted Sign 8.2 NLGRS_YTD No Limit Gross YTD Sign 8.2 NLGRS_YTD_ADJ No Limit Gross YTD Adjusted Sign 8.2 STATE State Char 6 Upper TAX_ADJ Tax Adjustment Sign 8.2 TAX_CLASS Tax Balance Class Char 1 Upper TAX_MTD Tax MTD Sign 8.2 TAX_MTD_ADJ Tax MTD Adjusted Sign 8.2 TAX_QTD Tax QTD Sign 8.2 TAX_QTD_ADJ Tax QTD Adjusted Sign 8.2 TAX_YTD Tax YTD Sign 8.2 TAX_YTD_ADJ Tax YTD Adjusted Sign 8.2 TIPS_ADJ Tip Adjustment Sign 8.2 TIPS_MTD MTD Taxable Tips Sign 8.2 TIPS_MTD_ADJ MTD Tips Adjusted Sign 8.2 TXGRS_ADJ Taxable Gross Adjustment Sign 8.2 TXGRS_MTD Taxable Gross MTD Sign 8.2 TXGRS_MTD_ADJ Taxable Gross MTD Adjusted Sign 8.2 TXGRS_QTD Taxable Gross QTD Sign 8.2 TXGRS_QTD_ADJ Taxable Gross QTD Adjusted Sign 8.2 TXGRS_YTD Taxable Gross YTD Sign 8.2 TXGRS_YTD_ADJ Taxable Gross YTD Adjusted Sign 8.2 PeopleSoft Report ID: XRFRCFL CROSS REFERENCE -- RECORDS AND FIELDS Page No. 54 Run Date 05/07/2001 Run Time 10:19:43 Record Name Field Name Long Field Name Type Length Format --------------- ------------------ ------------------------------ ---- ------ ------ BAL_ADJ_TAX1042 ADJ_REASON Adjustment Reason Char 50 Mixed BALANCE_ID Balance ID Char 2 Upper BALANCE_PERIOD Balances for Period Nbr 3 BALANCE_QTR Balances for Quarter Nbr 3 BALANCE_YEAR Balances for Year Nbr 4 BAL_ADJ_SEQ Balance Adjust Sequence Number Nbr 3 COMPANY Company Char 3 Upper COUNTRY Country Char 3 Upper DT_ENTERED Date Entered Date 10 EMPLID EmplID Char 11 Upper INCOME_CD_1042 Income Code (for 1042-S) Char 2 Num STATE State Char 6 Upper TAX_1042_ADJ Tax (1042) Adjustment Sign 8.2 TAX_1042_MTD Tax (1042) MTD Sign 8.2 TAX_1042_MTD_ADJ Tax (1042) MTD Adjusted Sign 8.2 TAX_1042_QTD Tax (1042) QTD Sign 8.2 TAX_1042_QTD_ADJ Tax (1042) QTD Adjusted Sign 8.2 TAX_1042_YTD Tax (1042) YTD Sign 8.2 TAX_1042_YTD_ADJ Tax (1042) YTD Adjusted Sign 8.2 TAX_RT Tax Rate Sign 0.6 TXGRS_1042_ADJ Taxable Gross(1042) Adjustment Sign 8.2 TXGRS_1042_MTD Taxable Gross (1042) MTD Sign 8.2 TXGRS_1042_MTD_ADJ Taxable Grs(1042) MTD Adjusted Sign 8.2 TXGRS_1042_QTD Taxable Gross (1042) QTD Sign 8.2 TXGRS_1042_QTD_ADJ Taxable Grs(1042) QTD Adjusted Sign 8.2 TXGRS_1042_YTD Taxable Gross (1042) YTD Sign 8.2 TXGRS_1042_YTD_ADJ Taxable Grs(1042) YTD Adjusted Sign 8.2 WH_ALLOW_ADJ WH Allowance Adjustment Sign 8.2 WH_ALLOW_MTD Withholding Allowances MTD Sign 8.2 WH_ALLOW_MTD_ADJ WH Allowance MTD Adjusted Sign 8.2 WH_ALLOW_QTD Withholding Allowance QTD Sign 8.2 WH_ALLOW_QTD_ADJ WH Allowance QTD Adjusted Sign 8.2 WH_ALLOW_YTD Withholding Allowance YTD Sign 8.2 WH_ALLOW_YTD_ADJ WH Allowance YTD Adjusted Sign 8.2 BAL_ADJ_UI_CAN ADJ_REASON Adjustment Reason Char 50 Mixed BAL_ADJ_SEQ Balance Adjust Sequence Number Nbr 3 COMPANY Company Char 3 Upper DT_ENTERED Date Entered Date 10 EARNS_END_DT Earnings End Date Date 10 EMPLID EmplID Char 11 Upper UI_EARN_ADJ EI Earnings Adjustment Sign 8.2 UI_HOURS_ADJ EI Hours Adjustment Sign 3.2 UI_PERIOD_DT EI Period Date Date 10 UI_WKLY_EARNS EI Weekly Earnings(No Limit) Sign 8.2 UI_WKLY_HOURS EI Weekly Hours Sign 3.2 UI_WK_EARN_ADJ EI Weekly Earnings Adjusted Sign 8.2 UI_WK_HRS_ADJ EI Weekly Hours Adjusted Sign 3.2 WAGE_LOSS_PLAN Wage Loss Replacement Plan Char 3 Upper BAL_ID_DEF_LANG BALANCE_ID Balance ID Char 2 Upper BALANCE_PERIOD Balances for Period Nbr 3 BALANCE_YEAR Balances for Year Nbr 4 LANGUAGE_CD Language Code Char 3 Upper PERIOD_ABBRV Abbreviation Char 3 Mixed PERIOD_NAME Period Name Char 30 Mixed SETID SetID Char 5 Upper BAL_ID_QTR_LANG BALANCE_ID Balance ID Char 2 Upper BALANCE_QTR Balances for Quarter Nbr 3 BALANCE_YEAR Balances for Year Nbr 4 LANGUAGE_CD Language Code Char 3 Upper PERIOD_ABBRV Abbreviation Char 3 Mixed PERIOD_NAME Period Name Char 30 Mixed SETID SetID Char 5 Upper BAL_YR_NO_CO_VW BALANCE_ID Balance ID Char 2 Upper BALANCE_YEAR Balances for Year Nbr 4 PeopleSoft Report ID: XRFRCFL CROSS REFERENCE -- RECORDS AND FIELDS Page No. 55 Run Date 05/07/2001 Run Time 10:19:43 Record Name Field Name Long Field Name Type Length Format --------------- ------------------ ------------------------------ ---- ------ ------ BANK_ACCNT_FRA ACCOUNT_ID Account ID Nbr 3 ACCOUNT_NAME Account Name Char 50 Mixed ACCOUNT_NBR_FRA Account ID Char 11 Upper ACCOUNT_TYPE_FRA Account Type - France Char 1 Upper ACCT_PURPOSE_FRA Purpose of Account Char 1 Upper ACCT_STATUS Account Status Char 1 Upper BANK_CD_CALC_FRA RIB Key Char 2 Num BANK_CD_FRA Bank ID Char 5 Upper COUNTER_ID_FRA Counter ID Char 5 Upper EMPLID EmplID Char 11 Upper BANK_ACCNT_LNG ACCOUNT_ID Account ID Nbr 3 ACCOUNT_NAME Account Name Char 50 Mixed EMPLID EmplID Char 11 Upper LANGUAGE_CD Language Code Char 3 Upper BANK_ACCNT_UK ACCOUNT#_UK Account Number Char 8 Num ACCOUNT_ID Account ID Nbr 3 ACCOUNT_NAME Account Name Char 50 Mixed ACCOUNT_PURPOSE Purpose of Account Char 1 Upper ACCOUNT_TYPE_UK Account Type Char 1 Upper ACCT_STATUS Account Status Char 1 Upper BANK_BS_NAME Bank/Building Society Name Char 20 Mixed BANK_BS_TYPE Bank/Building Society Type Char 2 Upper EMPLID EmplID Char 11 Upper ROLL_NAME Roll Name Char 50 Mixed ROLL_NUMBER Roll Number Char 12 Upper SORT_CODE Sort Code Char 6 Upper BANK_ACCOUNT ACCOUNT# Account Number Char 17 Upper ACCOUNT_ID Account ID Nbr 3 ACCOUNT_PURPOSE Purpose of Account Char 1 Upper ACCOUNT_TYPE Account Type Char 1 Upper ACCT_STATUS Account Status Char 1 Upper CLEARING_NUMBER Branch Clearing # Char 8 Num EMPLID EmplID Char 11 Upper TRANSIT# Bank Transit # Char 9 Upper BANK_ACCUK_LNG ACCOUNT_ID Account ID Nbr 3 ACCOUNT_NAME Account Name Char 50 Mixed EMPLID EmplID Char 11 Upper LANGUAGE_CD Language Code Char 3 Upper ROLL_NAME Roll Name Char 50 Mixed BANK_BANK_VW_UK BANK_BS_NAME Bank/Building Society Name Char 20 Mixed BANK_BCH_UK_LNG BANK_BS_NAME Bank/Building Society Name Char 20 Mixed DESCR Description Char 30 Mixed DESCRSHORT Short Description Char 10 Mixed LANGUAGE_CD Language Code Char 3 Upper SORT_CODE Sort Code Char 6 Upper BANK_BLNG_EC_WD CLEARING_NUMBER Branch Clearing # Char 8 Num DESCR Description Char 30 Mixed DESCRSHORT Short Description Char 10 Mixed ECFILEROWID File Row ID Char 3 Upper LANGUAGE_CD Language Code Char 3 Upper TRANSIT# Bank Transit # Char 9 Upper BANK_BRANCH_FRA BANK_CD_FRA Bank ID Char 5 Upper COUNTER_ID_FRA Counter ID Char 5 Upper DESCR Description Char 30 Mixed DESCRSHORT Short Description Char 10 Mixed BANK_BRANCH_LNG CLEARING_NUMBER Branch Clearing # Char 8 Num DESCR Description Char 30 Mixed DESCRSHORT Short Description Char 10 Mixed LANGUAGE_CD Language Code Char 3 Upper TRANSIT# Bank Transit # Char 9 Upper PeopleSoft Report ID: XRFRCFL CROSS REFERENCE -- RECORDS AND FIELDS Page No. 56 Run Date 05/07/2001 Run Time 10:19:43 Record Name Field Name Long Field Name Type Length Format --------------- ------------------ ------------------------------ ---- ------ ------ BANK_BRANCH_TBL CLEARING_NUMBER Branch Clearing # Char 8 Num DESCR Description Char 30 Mixed DESCRSHORT Short Description Char 10 Mixed TRANSIT# Bank Transit # Char 9 Upper BANK_BRANCH_UK BANK_BS_NAME Bank/Building Society Name Char 20 Mixed DESCR Description Char 30 Mixed DESCRSHORT Short Description Char 10 Mixed SORT_CODE Sort Code Char 6 Upper BANK_BRA_EC_WD CLEARING_NUMBER Branch Clearing # Char 8 Num DESCR Description Char 30 Mixed DESCRSHORT Short Description Char 10 Mixed ECFILEROWID File Row ID Char 3 Upper TRANSIT# Bank Transit # Char 9 Upper BANK_BS_VW_UK BANK_BS_NAME Bank/Building Society Name Char 20 Mixed BANK_EC_VW DEPOSIT_MEDIUM Deposit Medium Char 1 Upper DESCR Description Char 30 Mixed DESCRSHORT Short Description Char 10 Mixed ECQUEUEINSTANCE EC Queue Instance Nbr 9 ECTRANSID EC Transaction ID Char 15 Mixed ECTRANSINOUTSW Inbound / Outbound Switch Char 1 Upper PRENOTE_WAIT_DAYS Prenote Wait Days (U.S.) Nbr 3 TRANSIT# Bank Transit # Char 9 Upper BANK_EC_WD DEPOSIT_MEDIUM Deposit Medium Char 1 Upper DESCR Description Char 30 Mixed DESCRSHORT Short Description Char 10 Mixed ECFILEROWID File Row ID Char 3 Upper PRENOTE_WAIT_DAYS Prenote Wait Days (U.S.) Nbr 3 TRANSIT# Bank Transit # Char 9 Upper BANK_ESTAB_FRA BANK_CD_FRA Bank ID Char 5 Upper DESCR Description Char 30 Mixed DESCRSHORT Short Description Char 10 Mixed BANK_FRA_LANG BANK_CD_FRA Bank ID Char 5 Upper DESCR Description Char 30 Mixed DESCRSHORT Short Description Char 10 Mixed LANGUAGE_CD Language Code Char 3 Upper BANK_LNG_EC_WD DESCR Description Char 30 Mixed DESCRSHORT Short Description Char 10 Mixed ECFILEROWID File Row ID Char 3 Upper LANGUAGE_CD Language Code Char 3 Upper TRANSIT# Bank Transit # Char 9 Upper BANK_TBL DEPOSIT_MEDIUM Deposit Medium Char 1 Upper DESCR Description Char 30 Mixed DESCRSHORT Short Description Char 10 Mixed PRENOTE_WAIT_DAYS Prenote Wait Days (U.S.) Nbr 3 TRANSIT# Bank Transit # Char 9 Upper BANK_TBL_FRA BANK_CD_FRA Bank ID Char 5 Upper DESCR Description Char 30 Mixed DESCRSHORT Short Description Char 10 Mixed BANK_TBL_LANG DESCR Description Char 30 Mixed DESCRSHORT Short Description Char 10 Mixed LANGUAGE_CD Language Code Char 3 Upper TRANSIT# Bank Transit # Char 9 Upper BANK_TBL_UK BANK_BS_DESCR Long Name Char 40 Mixed BANK_BS_NAME Bank/Building Society Name Char 20 Mixed BS_ACCOUNT# Account Number Char 8 Num BS_ACCOUNT_NAME Account Name Char 50 Mixed PeopleSoft Report ID: XRFRCFL CROSS REFERENCE -- RECORDS AND FIELDS Page No. 57 Run Date 05/07/2001 Run Time 10:19:43 Record Name Field Name Long Field Name Type Length Format --------------- ------------------ ------------------------------ ---- ------ ------ BANK_TBL_UK BS_FLAG Building Society? Char 1 Upper BS_SORT_CODE Sort Code Char 6 Num DEPOSIT_MEDIUM Deposit Medium Char 1 Upper BANK_UKVW_LNG BANK_BS_NAME Bank/Building Society Name Char 20 Mixed LANGUAGE_CD Language Code Char 3 Upper BANK_UK_LANG BANK_BS_DESCR Long Name Char 40 Mixed BANK_BS_NAME Bank/Building Society Name Char 20 Mixed LANGUAGE_CD Language Code Char 3 Upper BASE_RATECD_VW COMPRATE Compensation Rate Nbr 12.6 COMP_BASE_PAY_SW Comp Base Pay Switch Char 1 Upper COMP_FREQUENCY Compensation Frequency Char 1 Upper COMP_PCT Comp Percent Nbr 3.3 COMP_RATECD Comp Rate Code Char 6 Upper COMP_RATE_TYPE Comp Rate Type Char 2 Upper CURRENCY_CD Currency Code Char 3 Upper DESCR Description Char 30 Mixed DESCRSHORT Short Description Char 10 Mixed EFFDT Effective Date Date 10 EFF_STATUS Status as of Effective Date Char 1 Upper ERNCD Earnings Code Char 3 Upper PAY_SYSTEM_FLG Payroll System Char 2 Upper PIN_NUM PIN Number Nbr 9 USE_HIGHEST_RT_SW Use Highest Rate Char 1 Upper BAS_ACTIVITY BAS_ACTION Benefits Administration Action Char 3 Upper BAS_ACTION_SOURCE Source of Action Char 2 Upper BENEFIT_RCD# Benefit Record Number Nbr 3 COBRA_ACTION COBRA Action Char 3 Upper EMPLID EmplID Char 11 Upper EMPL_RCD# Employment Rcd Nbr Nbr 3 EVENT_DT Event Date Date 10 EVENT_EFFSEQ Effective Sequence of Event Nbr 3 BAS_BENF_ENR_VW DEPENDENT_ID Dependent ID Char 2 Num EMPLID EmplID Char 11 Upper NAME Name Char 50 Name RELATIONSHIP Relationship to Employee Char 2 Upper BAS_BIRTH_DT_WL ACTIVITYNAME Activity Name Char 30 Mixed BUSPROCNAME Business Process Name Char 30 Mixed EMPLID EmplID Char 11 Upper EVENTNAME Event Name Char 30 Mixed INSTANCEID Instance ID Nbr 10 Cent TRANSACTIONID Transaction ID Nbr 10 Cent WORKLISTNAME Work List Name Char 30 Mixed BAS_DPND_ENR_VW DEPENDENT_ID Dependent ID Char 2 Num EMPLID EmplID Char 11 Upper NAME Name Char 50 Name RELATIONSHIP Relationship to Employee Char 2 Upper BAS_ELIG_BNSTAT BEN_STATUS Benefits Employee Status Char 4 Upper EFFDT Effective Date Date 10 ELIG_RULES_ID Eligibility Rules ID Char 4 Upper BAS_ELIG_CNFIG1 EFFDT Effective Date Date 10 ELIG_CONFIG1 Eligibility Config Field 1 Char 10 Upper ELIG_RULES_ID Eligibility Rules ID Char 4 Upper BAS_ELIG_CNFIG2 EFFDT Effective Date Date 10 ELIG_CONFIG2 Eligibility Config Field 2 Char 10 Upper ELIG_RULES_ID Eligibility Rules ID Char 4 Upper BAS_ELIG_CNFIG3 EFFDT Effective Date Date 10 ELIG_CONFIG3 Eligibility Config Field 3 Char 10 Upper ELIG_RULES_ID Eligibility Rules ID Char 4 Upper PeopleSoft Report ID: XRFRCFL CROSS REFERENCE -- RECORDS AND FIELDS Page No. 58 Run Date 05/07/2001 Run Time 10:19:43 Record Name Field Name Long Field Name Type Length Format --------------- ------------------ ------------------------------ ---- ------ ------ BAS_ELIG_CNFIG4 EFFDT Effective Date Date 10 ELIG_CONFIG4 Eligibility Config Field 4 Char 10 Upper ELIG_RULES_ID Eligibility Rules ID Char 4 Upper BAS_ELIG_CNFIG5 EFFDT Effective Date Date 10 ELIG_CONFIG5 Eligibility Config Field 5 Char 10 Upper ELIG_RULES_ID Eligibility Rules ID Char 4 Upper BAS_ELIG_CNFIG6 EFFDT Effective Date Date 10 ELIG_CONFIG6 Eligibility Config Field 6 Char 10 Upper ELIG_RULES_ID Eligibility Rules ID Char 4 Upper BAS_ELIG_CNFIG7 EFFDT Effective Date Date 10 ELIG_CONFIG7 Eligibility Config Field 7 Char 10 Upper ELIG_RULES_ID Eligibility Rules ID Char 4 Upper BAS_ELIG_CNFIG8 EFFDT Effective Date Date 10 ELIG_CONFIG8 Eligibility Config Field 8 Char 10 Upper ELIG_RULES_ID Eligibility Rules ID Char 4 Upper BAS_ELIG_CNFIG9 EFFDT Effective Date Date 10 ELIG_CONFIG9 Eligibility Config Field 9 Char 10 Upper ELIG_RULES_ID Eligibility Rules ID Char 4 Upper BAS_ELIG_DBG BENEFIT_PROGRAM Benefit Program Char 3 Upper BENEFIT_RCD# Benefit Record Number Nbr 3 ELIG_FLG_TEST Eligible or Ineligible Char 2 Upper ELIG_RULES_ID Eligibility Rules ID Char 4 Upper EMPLID EmplID Char 11 Upper OPTION_TYPE Option Type Char 1 Upper PROCESS_DT Process Date Date 10 RULE_OR_GEOG Rule or Geographic Eligibility Char 1 Upper SCHED_ID Schedule ID Char 6 Upper BAS_ELIG_DBGFLD BENEFIT_PROGRAM Benefit Program Char 3 Upper BENEFIT_RCD# Benefit Record Number Nbr 3 ELIG_FIELD Field Compared Char 4 Upper ELIG_FLG_TEST Eligible or Ineligible Char 2 Upper ELIG_RULES_ID Eligibility Rules ID Char 4 Upper ELIG_VALUE Field Value Char 20 Mixed EMPLID EmplID Char 11 Upper OPTION_TYPE Option Type Char 1 Upper RULE_OR_GEOG Rule or Geographic Eligibility Char 1 Upper SEQ_NUM Sequence Nbr 3 BAS_ELIG_DBGSCH BENEFIT_RCD# Benefit Record Number Nbr 3 EMPLID EmplID Char 11 Upper NAME Name Char 50 Name BAS_ELIG_EECLAS EFFDT Effective Date Date 10 ELIG_RULES_ID Eligibility Rules ID Char 4 Upper EMPL_CLASS Employee Classification Char 1 Upper BAS_ELIG_EETYPE EFFDT Effective Date Date 10 ELIG_RULES_ID Eligibility Rules ID Char 4 Upper EMPL_TYPE Employee Type Char 1 Upper BAS_ELIG_FLPART EFFDT Effective Date Date 10 ELIG_RULES_ID Eligibility Rules ID Char 4 Upper FULL_PART_TIME Full/Part Time Char 1 Upper BAS_ELIG_FLSA EFFDT Effective Date Date 10 ELIG_RULES_ID Eligibility Rules ID Char 4 Upper FLSA_STATUS FLSA Status Char 1 Upper BAS_ELIG_GRADE EFFDT Effective Date Date 10 ELIG_RULES_ID Eligibility Rules ID Char 4 Upper GRADE Salary Grade Char 5 Upper PeopleSoft Report ID: XRFRCFL CROSS REFERENCE -- RECORDS AND FIELDS Page No. 59 Run Date 05/07/2001 Run Time 10:19:43 Record Name Field Name Long Field Name Type Length Format --------------- ------------------ ------------------------------ ---- ------ ------ BAS_ELIG_GRADE SAL_ADMIN_PLAN Salary Administration Plan Char 3 Upper SETID SetID Char 5 Upper BAS_ELIG_LOCN EFFDT Effective Date Date 10 ELIG_RULES_ID Eligibility Rules ID Char 4 Upper LOCATION Location Code Char 10 Upper SETID SetID Char 5 Upper BAS_ELIG_OFFICR EFFDT Effective Date Date 10 ELIG_RULES_ID Eligibility Rules ID Char 4 Upper OFFICER_CD Officer Code Char 1 Upper BAS_ELIG_OVRD BENEFIT_RCD# Benefit Record Number Nbr 3 EFFDT Effective Date Date 10 ELIG_OVRD_CD Eligibility Override Char 1 Upper ELIG_RULES_ID Eligibility Rules ID Char 4 Upper EMPLID EmplID Char 11 Upper BAS_ELIG_OVRD_V BENEFIT_RCD# Benefit Record Number Nbr 3 EMPLID EmplID Char 11 Upper EMPL_RCD# Employment Rcd Nbr Nbr 3 BAS_ELIG_PYGRP COMPANY Company Char 3 Upper EFFDT Effective Date Date 10 ELIG_RULES_ID Eligibility Rules ID Char 4 Upper PAYGROUP Pay Group Char 3 Upper BAS_ELIG_REGN EFFDT Effective Date Date 10 ELIG_RULES_ID Eligibility Rules ID Char 4 Upper REG_REGION Regulatory Region Char 5 Upper BAS_ELIG_REGTMP EFFDT Effective Date Date 10 ELIG_RULES_ID Eligibility Rules ID Char 4 Upper REG_TEMP Regular/Temporary Char 1 Upper BAS_ELIG_RULES AGE_AS_OF_CD Age As Of Code Char 1 Upper AGE_AS_OF_DD Age As Of Day Nbr 2 AGE_AS_OF_MM Age As Of Month Nbr 2 COMBINE_MULT_HRS Combine Hours for Multi Jobs Char 1 Upper DESCR Description Char 30 Mixed DESCRSHORT Short Description Char 10 Mixed EFFDT Effective Date Date 10 EFF_STATUS Status as of Effective Date Char 1 Upper ELIG_FLG_BNSTAT Eligible or Ineligible Char 1 Upper ELIG_FLG_CNFIG1 Eligible or Ineligible Char 1 Upper ELIG_FLG_CNFIG2 Eligible or Ineligible Char 1 Upper ELIG_FLG_CNFIG3 Eligible or Ineligible Char 1 Upper ELIG_FLG_CNFIG4 Eligible or Ineligible Char 1 Upper ELIG_FLG_CNFIG5 Eligible or Ineligible Char 1 Upper ELIG_FLG_CNFIG6 Eligible or Ineligible Char 1 Upper ELIG_FLG_CNFIG7 Eligible or Ineligible Char 1 Upper ELIG_FLG_CNFIG8 Eligible or Ineligible Char 1 Upper ELIG_FLG_CNFIG9 Eligible or Ineligible Char 1 Upper ELIG_FLG_EECLAS Eligible or Ineligible Char 1 Upper ELIG_FLG_EETYPE Eligible or Ineligible Char 1 Upper ELIG_FLG_FLPART Eligible or Ineligible Char 1 Upper ELIG_FLG_FLSA Eligible or Ineligible Char 1 Upper ELIG_FLG_GRADE Eligible or Ineligible Char 1 Upper ELIG_FLG_LOCN Eligible or Ineligible Char 1 Upper ELIG_FLG_OFFICR Eligible or Ineligible Char 1 Upper ELIG_FLG_PYGRP Eligible or Ineligible Char 1 Upper ELIG_FLG_REGN Eligible or Ineligible Char 1 Upper ELIG_FLG_REGTMP Eligible or Ineligible Char 1 Upper ELIG_FLG_STATE Eligible or Ineligible Char 1 Upper ELIG_FLG_UNION Eligible or Ineligible Char 1 Upper ELIG_RULES_ID Eligibility Rules ID Char 4 Upper ELIG_USE_BNSTAT Rules Use Benefits Status Char 1 Upper ELIG_USE_CNFIG1 Rules Use Elig Config 1 Char 1 Upper ELIG_USE_CNFIG2 Rules Use Elig Config 2 Char 1 Upper PeopleSoft Report ID: XRFRCFL CROSS REFERENCE -- RECORDS AND FIELDS Page No. 60 Run Date 05/07/2001 Run Time 10:19:43 Record Name Field Name Long Field Name Type Length Format --------------- ------------------ ------------------------------ ---- ------ ------ BAS_ELIG_RULES ELIG_USE_CNFIG3 Rules Use Elig Config 3 Char 1 Upper ELIG_USE_CNFIG4 Rules Use Elig Config 4 Char 1 Upper ELIG_USE_CNFIG5 Rules Use Elig Config 5 Char 1 Upper ELIG_USE_CNFIG6 Rules Use Elig Config 6 Char 1 Upper ELIG_USE_CNFIG7 Rules Use Elig Config 7 Char 1 Upper ELIG_USE_CNFIG8 Rules Use Elig Config 8 Char 1 Upper ELIG_USE_CNFIG9 Rules Use Elig Config 9 Char 1 Upper ELIG_USE_EECLAS Rules Use Employee Class Char 1 Upper ELIG_USE_EETYPE Rules Use Employee Type Char 1 Upper ELIG_USE_FLPART Rules Use Full/Part Time Char 1 Upper ELIG_USE_FLSA Rules Use FLSA Status Char 1 Upper ELIG_USE_GRADE Rules Use Salary Plan/Grade Char 1 Upper ELIG_USE_LOCN Rules Use Location Char 1 Upper ELIG_USE_OFFICR Rules Use Officer Code Char 1 Upper ELIG_USE_OVRD Rules Use Emplid Override Char 1 Upper ELIG_USE_PYGRP Rules Use Company/Pay Group Char 1 Upper ELIG_USE_REGN Rules Use Reg Region Char 1 Upper ELIG_USE_REGTMP Rules Use Regular/Temporary Char 1 Upper ELIG_USE_STATE Rules Use State Char 1 Upper ELIG_USE_UNION Rules Use Union Code Char 1 Upper INCLUDE_LOC Include Work Location Char 1 Upper MAX_AGE Maximum Age Nbr 3 MAX_SERVICE_MM Maximum Service Months Nbr 3 MAX_STD_HRS Maximum Standard Hours Nbr 2.2 MIN_AGE Minimum Age Nbr 3 MIN_SERVICE_MM Minimum Service Months Nbr 3 MIN_STD_HRS Minimum Standard Hours Nbr 2.2 SERVICE_AS_OF_CD Service As Of Code Char 1 Upper SERVICE_AS_OF_DD Service As Of Day Nbr 2 SERVICE_AS_OF_MM Service As Of Month Nbr 2 BAS_ELIG_STATE EFFDT Effective Date Date 10 ELIG_RULES_ID Eligibility Rules ID Char 4 Upper STATE State Char 6 Upper BAS_ELIG_UNION EFFDT Effective Date Date 10 ELIG_RULES_ID Eligibility Rules ID Char 4 Upper UNION_CD Union Code Char 3 Upper BAS_ENR_DPLANVW BENEFIT_PROGRAM Benefit Program Char 3 Upper BENEFIT_RCD# Benefit Record Number Nbr 3 DISPLAY_PLN_SEQ Display Plan-type Sequence Char 2 Upper EMPLID EmplID Char 11 Upper EVENT_DT Event Date Date 10 EVENT_ID Event Identification Nbr 6 PLAN_TYPE Plan Type Char 2 Upper SCHED_ID Schedule ID Char 6 Upper BAS_ENR_DPWRKVW BAS_ERROR BAS Error Type Char 1 Upper BENEFIT_PROGRAM Benefit Program Char 3 Upper BENEFIT_RCD# Benefit Record Number Nbr 3 BENEF_PCT Percent Beneficiary Paid Nbr 3 CONTINGENT Contingent Char 1 Upper DEPENDENT_BENEF Dependent/Beneficiary ID Char 2 Num DISPLAY_PLN_SEQ Display Plan-type Sequence Char 2 Upper EMPLID EmplID Char 11 Upper ENROLL_ACTION Enroll Action Char 1 Upper EVENT_DT Event Date Date 10 EVENT_ID Event Identification Nbr 6 EXCESS Excess Char 1 Upper FLAT_AMOUNT Flat Amount Nbr 8 HLTH_PROVIDER_ID Health Provider ID Char 30 Upper PLAN_TYPE Plan Type Char 2 Upper PREVIOUSLY_SEEN Previously Seen Char 1 Upper SCHED_ID Schedule ID Char 6 Upper BAS_ENR_EMPL BAS_ACTION_SOURCE Source of Action Char 2 Upper EMPLID EmplID Char 11 Upper EMPL_RCD# Employment Rcd Nbr Nbr 3 PeopleSoft Report ID: XRFRCFL CROSS REFERENCE -- RECORDS AND FIELDS Page No. 61 Run Date 05/07/2001 Run Time 10:19:43 Record Name Field Name Long Field Name Type Length Format --------------- ------------------ ------------------------------ ---- ------ ------ BAS_ENR_EMPL EVENT_DT Event Date Date 10 EVENT_EFFSEQ Effective Sequence of Event Nbr 3 OPRID Operator Id Char 8 Mixed RUN_CNTL_ID Run Control ID Char 30 Mixed BAS_ENR_EMPL_V1 EMPLID EmplID Char 11 Upper NAME Name Char 50 Name BAS_ENR_PARTIC BENEFIT_RCD# Benefit Record Number Nbr 3 EMPLID EmplID Char 11 Upper EVENT_ID Event Identification Nbr 6 OPRID Operator Id Char 8 Mixed RUN_CNTL_ID Run Control ID Char 30 Mixed BAS_ENR_PAR_V1 EMPLID EmplID Char 11 Upper NAME Name Char 50 Name SCHED_ID Schedule ID Char 6 Upper BAS_ENR_PAR_V2 BENEFIT_RCD# Benefit Record Number Nbr 3 EMPLID EmplID Char 11 Upper SCHED_ID Schedule ID Char 6 Upper BAS_ENR_PAR_V3 BENEFIT_RCD# Benefit Record Number Nbr 3 EMPLID EmplID Char 11 Upper EVENT_ID Event Identification Nbr 6 SCHED_ID Schedule ID Char 6 Upper BAS_ENR_PASSIVE OPRID Operator Id Char 8 Mixed PASSIVE_EVENT_ID Passive Event Id Char 3 Upper PASSIVE_FROM_DT Passive Event From Date Date 10 PASSIVE_TO_DT Passive Event To Date Date 10 RUN_CNTL_ID Run Control ID Char 30 Mixed BAS_ENR_PLAN BENEFIT_PROGRAM Benefit Program Char 3 Upper OPRID Operator Id Char 8 Mixed PLAN_TYPE Plan Type Char 2 Upper RUN_CNTL_ID Run Control ID Char 30 Mixed BAS_ENR_PLAN_V1 BENEFIT_PROGRAM Benefit Program Char 3 Upper OE_DEFN_ID Open Enrollment Definition ID Char 4 Upper BAS_ENR_PLAN_V2 BENEFIT_PROGRAM Benefit Program Char 3 Upper OE_DEFN_ID Open Enrollment Definition ID Char 4 Upper PLAN_TYPE Plan Type Char 2 Upper BAS_ENR_RUNCTL BAS_PROCESS_STATUS Process Status Char 2 Upper BENEFIT_PROGRAM Benefit Program Char 3 Upper BENEFIT_RCD# Benefit Record Number Nbr 3 CHKPT_INTERVAL Check Point Interval in Minute Nbr 2 DEBUG_ELIG Record Eligibility Results Char 1 Upper EMPLID EmplID Char 11 Upper EVENT_DT Event Date Date 10 EVENT_ID Event Identification Nbr 6 FINALIZE_ENROLL Finalize/Apply Defaults Char 1 Upper OPRID Operator Id Char 8 Mixed PARTIC_LIST_IND Process From Participant List? Char 1 Upper PARTIC_NEW_IND Schedule New Participants? Char 1 Upper PASSIVE_EVENT_ID Passive Event Id Char 3 Upper PASSIVE_EVENT_IND Passive Events Processing Char 1 Upper PLAN_LIST_IND Include/Exclude Plans Char 1 Upper PROCESS_DT Process Date Date 10 PROCESS_IND Process Indicator Char 1 Upper PROCESS_PHASE BAS Processing Phase Char 1 Upper REPROCESS_IND Reprocess Indicator Char 1 Upper RUN_CNTL_ID Run Control ID Char 30 Mixed SCHED_ID Schedule ID Char 6 Upper BAS_ETCLASS_LNG DESCR Description Char 30 Mixed DESCRSHORT Short Description Char 10 Mixed PeopleSoft Report ID: XRFRCFL CROSS REFERENCE -- RECORDS AND FIELDS Page No. 62 Run Date 05/07/2001 Run Time 10:19:43 Record Name Field Name Long Field Name Type Length Format --------------- ------------------ ------------------------------ ---- ------ ------ BAS_ETCLASS_LNG EVENT_CLASS Event Classification Char 3 Upper LANGUAGE_CD Language Code Char 3 Upper BAS_ETMANL_LNG BAS_ACTION Benefits Administration Action Char 3 Upper DESCR Description Char 30 Mixed LANGUAGE_CD Language Code Char 3 Upper BAS_EVENT_CLASS BILL_ACTION Billing Action Char 1 Upper BILL_DATE_CD Billing Starts On Char 1 Upper BILL_DELAY_DD Delay Billing Days Nbr 3 BILL_DELAY_MM Delay Billing Months Nbr 2 COVERAGE_BEGINS_CD Coverage Begins Code Char 1 Upper COVERAGE_ENDS_CD Coverage Ends Code Char 1 Upper DED_FLXCR_BEGIN_CD Deduction+Flex Credits Begin Char 1 Upper DED_FLXCR_END_CD Deduction+Flex Credits End Char 1 Upper DFLT_CREDIT_IND Provide Flex Credits? Char 1 Upper DFLT_METHOD Default Method Char 1 Upper EFFDT Effective Date Date 10 ELECT_REQUIRED Elect Required Char 1 Upper ELIG_CHG_LVL Eligibility Change Levels Nbr 2 EVENT_CLASS Event Classification Char 3 Upper EVENT_RULES_ID Event Rules ID Char 4 Upper FLAT_CALC Flat Amount of Char 1 Upper GRACE_PERIOD_DD Grace Period Days Nbr 3 GRACE_PERIOD_MM Grace Period Months Nbr 2 IGNORE_DEPBEN_EDIT Ignore Dep/Ben Edits Char 1 Upper IGNORE_INVEST_EDIT Ignore Investment Edits Char 1 Upper IGNORE_PLAN Ignore Plan Char 1 Upper PERCENT_CALC Percent Calculation Char 1 Upper PRE_ENTER Pre_enter Char 1 Upper PROOF_CHG_LVL Change Levels Until Proof Req Nbr 2 PROOF_START_FLT Proof Start at Flat Amount Nbr 8 PROOF_START_LVL Proof Start at Level Nbr 2 RATE_AMOUNT Rate Amount Sign 5.2 RATE_PERCENT Rate Percent Nbr 3 RATE_QUALIFIER Rate Qualifier Char 1 Upper SELECT_ALLOW Select Allowed Char 1 Upper USE_EXIST_WAIT Use Existing Waiting Period Char 1 Upper USE_HISTORY Use History Char 1 Upper WAIT_PERIOD_DD Wait Period Days Nbr 3 WAIT_PERIOD_MM Wait Period Months Nbr 2 WV_ELIG_CHG_LVL Waive Eligibilit Change Levels Nbr 2 WV_PROOF_START_FLT Waive Proof Start Flat Amount Nbr 8 WV_PROOF_START_LVL Waive Proof Start Level Nbr 2 BAS_EVENT_RULES DESCR Description Char 30 Mixed DESCRSHORT Short Description Char 10 Mixed EFFDT Effective Date Date 10 EFF_STATUS Status as of Effective Date Char 1 Upper EVENT_RULES_ID Event Rules ID Char 4 Upper BAS_EVTVW_LNG EMPLID EmplID Char 11 Upper LANGUAGE_CD Language Code Char 3 Upper NAME Name Char 50 Name BAS_EVT_CLASS ALLOW_SELF_SERVICE Available through Self Service Char 1 Upper DESCR Description Char 30 Mixed DESCRSHORT Short Description Char 10 Mixed EFF_STATUS Status as of Effective Date Char 1 Upper EVENT_CLASS Event Classification Char 3 Upper EVENT_CLASS_USE BAS Event Class Usage Char 1 Upper EVENT_PRIORITY Event Priority Nbr 3 MANUAL_EVT_ALLOWED Manual Events Allowed Char 1 Upper BAS_EVT_EMPLID EMPLID EmplID Char 11 Upper NAME Name Char 50 Name BAS_EVT_MANUAL BAS_ACTION Benefits Administration Action Char 3 Upper DESCR Description Char 30 Mixed PeopleSoft Report ID: XRFRCFL CROSS REFERENCE -- RECORDS AND FIELDS Page No. 63 Run Date 05/07/2001 Run Time 10:19:43 Record Name Field Name Long Field Name Type Length Format --------------- ------------------ ------------------------------ ---- ------ ------ BAS_GROUP_TBL BAS_GROUP_ID BAS Group ID Char 3 Upper DESCR Description Char 30 Mixed DESCRSHORT Short Description Char 10 Mixed BAS_MESSAGE BENEFIT_RCD# Benefit Record Number Nbr 3 COST_ID Cost Identification Nbr 4 EMPLID EmplID Char 11 Upper EVENT_ID Event Identification Nbr 6 MSGDATA1 Message Data Char 35 Mixed MSGDATA2 Message Data Char 35 Mixed MSGDATA3 Message Data Char 35 Mixed MSGID Message ID Char 6 Upper OPTION_ID Option Id Nbr 4 PRCSINSTANCE Process Instance Nbr 10 Cent SCHED_ID Schedule ID Char 6 Upper BAS_ODEM_PRNCTL OPRID Operator Id Char 8 Mixed OUTDEST Output Destination Char 127 Mixed OUTDESTTYPE Output Destination Type Char 1 Upper RUNLOCATION Run Location Char 1 Upper SERVERNAME Server Name Char 8 Upper BAS_OE_DEFN DESCR Description Char 30 Mixed DESCRSHORT Short Description Char 10 Mixed OE_DEFN_ID Open Enrollment Definition ID Char 4 Upper PERIOD_BEGIN_DT Period Begin Date Date 10 PERIOD_END_DT Period End Date Date 10 BAS_OE_DEFN_PLN BENEFIT_PROGRAM Benefit Program Char 3 Upper OE_DEFN_ID Open Enrollment Definition ID Char 4 Upper PLAN_TYPE Plan Type Char 2 Upper BAS_OE_DE_PL_V1 BENEFIT_PROGRAM Benefit Program Char 3 Upper EFFDT Effective Date Date 10 BAS_OE_DE_PL_V2 BENEFIT_PROGRAM Benefit Program Char 3 Upper EFFDT Effective Date Date 10 PLAN_TYPE Plan Type Char 2 Upper BAS_PARTIC ADDR_EFFDT Address Effective Date Date 10 ADDR_ELIG_CHG Address Eligibility Changed Char 1 Upper ADDR_ELIG_CHG_DT Address Elig Changed Date Date 10 ALLOW_SELF_SERVICE Available through Self Service Char 1 Upper BAS_ACTION_SOURCE Source of Action Char 2 Upper BAS_EVENT_CHG Event Out of Sequence Char 1 Upper BAS_EVENT_CHG_DT Event Changed Date Date 10 BAS_EVT_DISCONNECT Event Disconnected Char 1 Upper BAS_EVT_DISC_DT Event Disconnect Date Date 10 BAS_PROCESS_STATUS Process Status Char 2 Upper BENEFIT_PROGRAM Benefit Program Char 3 Upper BENEFIT_RCD# Benefit Record Number Nbr 3 COBRA_ACTION COBRA Action Char 3 Upper CONFIRM_NOTIFY_DT Date Notified of Confirmation Date 10 CONFIRM_RCVD_DT Confirmation Received Date Date 10 CREDIT_ROLLOVER Excess Credit Rollover To Char 1 Upper ELECT_RCVD_DT Elections Received Date Date 10 ELECT_SOURCE Election Source Char 1 Upper EMPLID EmplID Char 11 Upper EMPL_RCD# Employment Rcd Nbr Nbr 3 EVENT_CLASS Event Classification Char 3 Upper EVENT_DT Event Date Date 10 EVENT_EFFSEQ Effective Sequence of Event Nbr 3 EVENT_EMPLRCD Event Empl Rcd# Nbr 3 EVENT_ID Event Identification Nbr 6 EVENT_PRIORITY Event Priority Nbr 3 EVENT_STATUS Event Status Char 1 Upper FINALIZE_ENROLL Finalize/Apply Defaults Char 1 Upper JOB_EFFDT Job Effective Date Date 10 PeopleSoft Report ID: XRFRCFL CROSS REFERENCE -- RECORDS AND FIELDS Page No. 64 Run Date 05/07/2001 Run Time 10:19:43 Record Name Field Name Long Field Name Type Length Format --------------- ------------------ ------------------------------ ---- ------ ------ BAS_PARTIC JOB_EFFSEQ Job Effective Sequence Nbr 1 JOB_ELIG_CHG Job Eligibility Changed Char 1 Upper JOB_ELIG_CHG_DT Job Elig Changed Date Date 10 MULTI_ACTIVITY_IND Multi-Activity Indicator Char 1 Upper OPTION_NOTIFY_DT Date Notified of Options Date 10 PROCESS_IND Process Indicator Char 1 Upper SCHED_ID Schedule ID Char 6 Upper SERVICE_DT Service Date Date 10 STATUS_DT Status Date Date 10 UNION_CD Union Code Char 3 Upper UNION_EFFDT Union Effective Date Date 10 UNION_EFFSEQ Union Effective Sequence Nbr 3 UNION_ELIG_CHG Union Eligibility Changed Char 1 Upper UNION_ELIG_CHG_DT Union Elig Changed Date Date 10 BAS_PARTIC_COST ANNUAL_AMT Annual Amount Sign 8.2 BENEFIT_PROGRAM Benefit Program Char 3 Upper BENEFIT_RCD# Benefit Record Number Nbr 3 COST_ID Cost Identification Nbr 4 COST_TYPE Cost Type Char 1 Upper DEDUCT_AMT Deducted Amount Sign 8.2 DISPLAY_OPT_SEQ Display Option Sequence Nbr 3 DISPLAY_PLN_SEQ Display Plan-type Sequence Char 2 Upper EMPLID EmplID Char 11 Upper ERNCD Earnings Code Char 3 Upper EVENT_DT Event Date Date 10 EVENT_ID Event Identification Nbr 6 OPTION_ID Option Id Nbr 4 PLAN_TYPE Plan Type Char 2 Upper SCHED_ID Schedule ID Char 6 Upper BAS_PARTIC_DPND BAS_ERROR BAS Error Type Char 1 Upper BENEFIT_PROGRAM Benefit Program Char 3 Upper BENEFIT_RCD# Benefit Record Number Nbr 3 BENEF_PCT Percent Beneficiary Paid Nbr 3 CONTINGENT Contingent Char 1 Upper DEPENDENT_BENEF Dependent/Beneficiary ID Char 2 Num DISPLAY_PLN_SEQ Display Plan-type Sequence Char 2 Upper EMPLID EmplID Char 11 Upper ENROLL_ACTION Enroll Action Char 1 Upper EVENT_DT Event Date Date 10 EVENT_ID Event Identification Nbr 6 EXCESS Excess Char 1 Upper FLAT_AMOUNT Flat Amount Nbr 8 HLTH_PROVIDER_ID Health Provider ID Char 30 Upper PLAN_TYPE Plan Type Char 2 Upper PREVIOUSLY_SEEN Previously Seen Char 1 Upper SCHED_ID Schedule ID Char 6 Upper BAS_PARTIC_INVT BAS_ERROR BAS Error Type Char 1 Upper BENEFIT_PROGRAM Benefit Program Char 3 Upper BENEFIT_RCD# Benefit Record Number Nbr 3 DISPLAY_PLN_SEQ Display Plan-type Sequence Char 2 Upper EMPLID EmplID Char 11 Upper ENROLL_ACTION Enroll Action Char 1 Upper EVENT_DT Event Date Date 10 EVENT_ID Event Identification Nbr 6 INVESTMENT_OPT Investment Option Char 1 Upper INVESTMENT_PCT Investment Percent Nbr 3.2 PLAN_TYPE Plan Type Char 2 Upper SCHED_ID Schedule ID Char 6 Upper BAS_PARTIC_OPTN BENEFIT_PLAN Benefit Plan Char 6 Upper BENEFIT_PROGRAM Benefit Program Char 3 Upper BENEFIT_RCD# Benefit Record Number Nbr 3 CALCULATED_BASE Coverage Base Nbr 8.2 COVRG_CD Coverage Code Char 1 Upper DED_CLASS Deduction Classification Char 1 Upper DEFAULT_IND Default Election Char 1 Upper PeopleSoft Report ID: XRFRCFL CROSS REFERENCE -- RECORDS AND FIELDS Page No. 65 Run Date 05/07/2001 Run Time 10:19:43 Record Name Field Name Long Field Name Type Length Format --------------- ------------------ ------------------------------ ---- ------ ------ BAS_PARTIC_OPTN DISPLAY_OPT_SEQ Display Option Sequence Nbr 3 DISPLAY_PLN_SEQ Display Plan-type Sequence Char 2 Upper EMPLID EmplID Char 11 Upper EVENT_DT Event Date Date 10 EVENT_ID Event Identification Nbr 6 HISTORY_ONLY History Only Char 1 Upper OPTION_CD Option Code Char 3 Upper OPTION_ID Option Id Nbr 4 OPTION_LVL Option Level Nbr 3 OPTION_TYPE Option Type Char 1 Upper PAY_PERIOD1 First Pay Period Char 1 Upper PAY_PERIOD2 Second Pay Period Char 1 Upper PAY_PERIOD3 Third Pay Period Char 1 Upper PAY_PERIOD4 Fourth Pay Period Char 1 Upper PAY_PERIOD5 Fifth Pay Period Char 1 Upper PLAN_TYPE Plan Type Char 2 Upper PREMIUM_BASE Premium Base Nbr 8.2 PROOF_REQ_IND Proof Required Indicator Char 1 Upper SCHED_ID Schedule ID Char 6 Upper BAS_PARTIC_PLAN ANNUAL_PLEDGE Annual Pledge Nbr 5.2 ANN_EX_CREDITS Annual Excess Credits Nbr 6.2 ANN_EX_CREDIT_FSA Annual Credit Rollover FSA Nbr 5.2 APAY_EFFDT Additional Pay Date Date 10 BAS_ERROR BAS Error Type Char 1 Upper BENEFITS_BASE Benefits Base Char 1 Upper BENEFIT_PLAN_RA Benefit Plan ATAX Rollover Char 6 Upper BENEFIT_PLAN_RB Benefit Plan BTAX Rollover Char 6 Upper BENEFIT_PROGRAM Benefit Program Char 3 Upper BENEFIT_RCD# Benefit Record Number Nbr 3 BILL_ACTION Billing Action Char 1 Upper BILL_EFFDT Billing Begin Date Date 10 COVERAGE_BEGIN_DT Coverage Begin Date Date 10 COVERAGE_ELECT Coverage Election Char 1 Upper COVERAGE_ELECT_DT Coverage Elect Date Date 10 CUR_ELECT_IND Current Election Indicator Char 1 Upper DEDCD_RA Deduction Code ATAX Rollover Char 6 Upper DEDCD_RB Deduction Code BTAX Rollover Char 6 Upper DEDUCTION_BEGIN_DT Deduction Begin Date Date 10 DED_CLASS_RA Deduction Class ATAX Rollover Char 1 Upper DED_CLASS_RB Deduction Class BTAX Rollover Char 1 Upper DEFAULT_ASSIGNED Default Assigned Char 1 Upper DISPLAY_PLN_SEQ Display Plan-type Sequence Char 2 Upper ELECTION_MADE Employee Made an Election Char 1 Upper ELECT_ALLOWED Elections Allowed Char 1 Upper EMPLID EmplID Char 11 Upper EMPL_CONTRBUTN_AMT Employee Contribution Amount Nbr 4.2 ENROLL_ACTION Enroll Action Char 1 Upper EVENT_DT Event Date Date 10 EVENT_ID Event Identification Nbr 6 FACTOR_XSALARY Factor x Salary Nbr 1.3 FLAT_AMOUNT Flat Amount Nbr 8 FLAT_CALC Flat Amount of Char 1 Upper FLAT_DED_AMT Flat Deduction Amount Nbr 6.2 FLAT_DED_AMT_ATAX Flat Deduction Amt After-Tax Nbr 6.2 GOAL_AMT Goal Amount Sign 8.2 HLTH_PROVIDER_ID Health Provider ID Char 30 Upper IGNORE_PLAN Ignore Plan Char 1 Upper LIFE_ADD_COVRG Coverage Char 1 Upper OPTION_CD Option Code Char 3 Upper PCT_GROSS Percent of Gross Nbr 3.3 PCT_GROSS_ATAX Percent of Gross After-Tax Nbr 3.3 PENSION_BASE Salary for Pension Calc Nbr 8.2 PERCENT_CALC Percent Calculation Char 1 Upper PLAN_ENROLL_DT Plan Enroll Date Date 10 PLAN_TYPE Plan Type Char 2 Upper PLAN_TYPE_RA Plan Type ATAX Rollover Char 2 Upper PLAN_TYPE_RB Plan Type BTAX Rollover Char 2 Upper PREVIOUSLY_SEEN Previously Seen Char 1 Upper PeopleSoft Report ID: XRFRCFL CROSS REFERENCE -- RECORDS AND FIELDS Page No. 66 Run Date 05/07/2001 Run Time 10:19:43 Record Name Field Name Long Field Name Type Length Format --------------- ------------------ ------------------------------ ---- ------ ------ BAS_PARTIC_PLAN PROOF_RCVD Proof Received Char 1 Upper RATE_AMOUNT Rate Amount Sign 5.2 RATE_PERCENT Rate Percent Nbr 3 RATE_QUALIFIER Rate Qualifier Char 1 Upper SAVINGS_COVRG Savings Coverage Char 1 Upper SAVINGS_COVRG_ATAX Savings Coverage After-Tax Char 1 Upper SCHED_ID Schedule ID Char 6 Upper VACN_BUY_FLAT_AMT Vacation Buy Flat Amount Nbr 5.2 VACN_HOURS Vacation Buy/Sell Hours Nbr 4.2 VACN_SELL_FLAT_AMT Vacation Sell Flat Amount Nbr 5.2 VOLUNTARY_AMT Voluntary Contr. Amt Nbr 8.2 VOLUNTARY_PCT Voluntary Contr. Pct Nbr 3.3 BAS_PAR_CONFBVW BENEFIT_RCD# Benefit Record Number Nbr 3 EMPLID EmplID Char 11 Upper EVENT_ID Event Identification Nbr 6 SCHED_ID Schedule ID Char 6 Upper BAS_PAR_CONFEVW BENEFIT_RCD# Benefit Record Number Nbr 3 EMPLID EmplID Char 11 Upper EVENT_ID Event Identification Nbr 6 SCHED_ID Schedule ID Char 6 Upper BAS_PAR_CONF_VW BENEFIT_RCD# Benefit Record Number Nbr 3 EMPLID EmplID Char 11 Upper EVENT_ID Event Identification Nbr 6 SCHED_ID Schedule ID Char 6 Upper BAS_PAR_COST_VW ANNUAL_AMT Annual Amount Sign 8.2 BENEFIT_RCD# Benefit Record Number Nbr 3 COST_ID Cost Identification Nbr 4 COST_TYPE Cost Type Char 1 Upper DEDUCT_AMT Deducted Amount Sign 8.2 DISPLAY_OPT_SEQ Display Option Sequence Nbr 3 DISPLAY_PLN_SEQ Display Plan-type Sequence Char 2 Upper EMPLID EmplID Char 11 Upper ERNCD Earnings Code Char 3 Upper EVENT_ID Event Identification Nbr 6 SCHED_ID Schedule ID Char 6 Upper BAS_PAR_DPND_VW BAS_ERROR BAS Error Type Char 1 Upper BENEFIT_RCD# Benefit Record Number Nbr 3 BENEF_PCT Percent Beneficiary Paid Nbr 3 CONTINGENT Contingent Char 1 Upper DEPENDENT_BENEF Dependent/Beneficiary ID Char 2 Num DISPLAY_PLN_SEQ Display Plan-type Sequence Char 2 Upper EMPLID EmplID Char 11 Upper ENROLL_ACTION Enroll Action Char 1 Upper EVENT_ID Event Identification Nbr 6 EXCESS Excess Char 1 Upper FLAT_AMOUNT Flat Amount Nbr 8 HLTH_PROVIDER_ID Health Provider ID Char 30 Upper PREVIOUSLY_SEEN Previously Seen Char 1 Upper SCHED_ID Schedule ID Char 6 Upper BAS_PAR_ENRL_VW BENEFIT_RCD# Benefit Record Number Nbr 3 EMPLID EmplID Char 11 Upper EVENT_ID Event Identification Nbr 6 SCHED_ID Schedule ID Char 6 Upper BAS_PAR_ENTP_SV BENEFIT_RCD# Benefit Record Number Nbr 3 EMPLID EmplID Char 11 Upper EVENT_CLASS Event Classification Char 3 Upper EVENT_DT Event Date Date 10 EVENT_ID Event Identification Nbr 6 SCHED_ID Schedule ID Char 6 Upper BAS_PAR_ENTS_SV SCHED_ID Schedule ID Char 6 Upper PeopleSoft Report ID: XRFRCFL CROSS REFERENCE -- RECORDS AND FIELDS Page No. 67 Run Date 05/07/2001 Run Time 10:19:43 Record Name Field Name Long Field Name Type Length Format --------------- ------------------ ------------------------------ ---- ------ ------ BAS_PAR_ENT_KEY BAS_VALIDATE_MODE Validation Mode Char 1 Upper BENEFIT_RCD# Benefit Record Number Nbr 3 EMPLID EmplID Char 11 Upper EVENT_ID Event Identification Nbr 6 SCHED_ID Schedule ID Char 6 Upper BAS_PAR_INVT_VW BAS_ERROR BAS Error Type Char 1 Upper BENEFIT_RCD# Benefit Record Number Nbr 3 DISPLAY_PLN_SEQ Display Plan-type Sequence Char 2 Upper EMPLID EmplID Char 11 Upper ENROLL_ACTION Enroll Action Char 1 Upper EVENT_ID Event Identification Nbr 6 INVESTMENT_OPT Investment Option Char 1 Upper INVESTMENT_PCT Investment Percent Nbr 3.2 SCHED_ID Schedule ID Char 6 Upper BAS_PAR_ONDM_VW BENEFIT_PROGRAM Benefit Program Char 3 Upper BENEFIT_RCD# Benefit Record Number Nbr 3 CUR_ELECT_IND Current Election Indicator Char 1 Upper DISPLAY_PLN_SEQ Display Plan-type Sequence Char 2 Upper ELECTION_MADE Employee Made an Election Char 1 Upper ELECT_ALLOWED Elections Allowed Char 1 Upper EMPLID EmplID Char 11 Upper ENROLL_ACTION Enroll Action Char 1 Upper EVENT_DT Event Date Date 10 EVENT_ID Event Identification Nbr 6 EVENT_STATUS Event Status Char 1 Upper IGNORE_PLAN Ignore Plan Char 1 Upper OPTION_CD Option Code Char 3 Upper PLAN_TYPE Plan Type Char 2 Upper SCHED_ID Schedule ID Char 6 Upper BAS_PAR_OPEN_VW BENEFIT_RCD# Benefit Record Number Nbr 3 EMPLID EmplID Char 11 Upper EVENT_ID Event Identification Nbr 6 SCHED_ID Schedule ID Char 6 Upper BAS_PAR_OPTN_V2 BENEFIT_PLAN Benefit Plan Char 6 Upper BENEFIT_RCD# Benefit Record Number Nbr 3 COVRG_CD Coverage Code Char 1 Upper DISPLAY_PLN_SEQ Display Plan-type Sequence Char 2 Upper EMPLID EmplID Char 11 Upper EVENT_ID Event Identification Nbr 6 OPTION_CD Option Code Char 3 Upper OPTION_ID Option Id Nbr 4 OPTION_TYPE Option Type Char 1 Upper PAY_PERIOD1 First Pay Period Char 1 Upper PAY_PERIOD2 Second Pay Period Char 1 Upper PAY_PERIOD3 Third Pay Period Char 1 Upper PAY_PERIOD4 Fourth Pay Period Char 1 Upper PAY_PERIOD5 Fifth Pay Period Char 1 Upper PROOF_REQ_IND Proof Required Indicator Char 1 Upper SCHED_ID Schedule ID Char 6 Upper BAS_PAR_OPTN_VW BENEFIT_PLAN Benefit Plan Char 6 Upper BENEFIT_RCD# Benefit Record Number Nbr 3 CALCULATED_BASE Coverage Base Nbr 8.2 COVRG_CD Coverage Code Char 1 Upper DED_CLASS Deduction Classification Char 1 Upper DEFAULT_IND Default Election Char 1 Upper DISPLAY_OPT_SEQ Display Option Sequence Nbr 3 DISPLAY_PLN_SEQ Display Plan-type Sequence Char 2 Upper EMPLID EmplID Char 11 Upper EVENT_ID Event Identification Nbr 6 HISTORY_ONLY History Only Char 1 Upper OPTION_CD Option Code Char 3 Upper OPTION_ID Option Id Nbr 4 OPTION_LVL Option Level Nbr 3 OPTION_TYPE Option Type Char 1 Upper PeopleSoft Report ID: XRFRCFL CROSS REFERENCE -- RECORDS AND FIELDS Page No. 68 Run Date 05/07/2001 Run Time 10:19:43 Record Name Field Name Long Field Name Type Length Format --------------- ------------------ ------------------------------ ---- ------ ------ BAS_PAR_OPTN_VW PAY_PERIOD1 First Pay Period Char 1 Upper PAY_PERIOD2 Second Pay Period Char 1 Upper PAY_PERIOD3 Third Pay Period Char 1 Upper PAY_PERIOD4 Fourth Pay Period Char 1 Upper PAY_PERIOD5 Fifth Pay Period Char 1 Upper PREMIUM_BASE Premium Base Nbr 8.2 PROOF_REQ_IND Proof Required Indicator Char 1 Upper SCHED_ID Schedule ID Char 6 Upper BAS_PAR_PLAN_VW ANNUAL_PLEDGE Annual Pledge Nbr 5.2 ANN_EX_CREDITS Annual Excess Credits Nbr 6.2 ANN_EX_CREDIT_FSA Annual Credit Rollover FSA Nbr 5.2 APAY_EFFDT Additional Pay Date Date 10 BAS_ERROR BAS Error Type Char 1 Upper BENEFITS_BASE Benefits Base Char 1 Upper BENEFIT_PLAN_RA Benefit Plan ATAX Rollover Char 6 Upper BENEFIT_PLAN_RB Benefit Plan BTAX Rollover Char 6 Upper BENEFIT_RCD# Benefit Record Number Nbr 3 BILL_ACTION Billing Action Char 1 Upper BILL_EFFDT Billing Begin Date Date 10 COVERAGE_BEGIN_DT Coverage Begin Date Date 10 COVERAGE_ELECT Coverage Election Char 1 Upper COVERAGE_ELECT_DT Coverage Elect Date Date 10 CUR_ELECT_IND Current Election Indicator Char 1 Upper DEDCD_RA Deduction Code ATAX Rollover Char 6 Upper DEDCD_RB Deduction Code BTAX Rollover Char 6 Upper DEDUCTION_BEGIN_DT Deduction Begin Date Date 10 DED_CLASS_RA Deduction Class ATAX Rollover Char 1 Upper DED_CLASS_RB Deduction Class BTAX Rollover Char 1 Upper DEFAULT_ASSIGNED Default Assigned Char 1 Upper DISPLAY_PLN_SEQ Display Plan-type Sequence Char 2 Upper ELECTION_MADE Employee Made an Election Char 1 Upper ELECT_ALLOWED Elections Allowed Char 1 Upper EMPLID EmplID Char 11 Upper EMPL_CONTRBUTN_AMT Employee Contribution Amount Nbr 4.2 ENROLL_ACTION Enroll Action Char 1 Upper EVENT_ID Event Identification Nbr 6 FACTOR_XSALARY Factor x Salary Nbr 1.3 FLAT_AMOUNT Flat Amount Nbr 8 FLAT_CALC Flat Amount of Char 1 Upper FLAT_DED_AMT Flat Deduction Amount Nbr 6.2 FLAT_DED_AMT_ATAX Flat Deduction Amt After-Tax Nbr 6.2 GOAL_AMT Goal Amount Sign 8.2 HLTH_PROVIDER_ID Health Provider ID Char 30 Upper IGNORE_PLAN Ignore Plan Char 1 Upper LIFE_ADD_COVRG Coverage Char 1 Upper OPTION_CD Option Code Char 3 Upper PCT_GROSS Percent of Gross Nbr 3.3 PCT_GROSS_ATAX Percent of Gross After-Tax Nbr 3.3 PENSION_BASE Salary for Pension Calc Nbr 8.2 PERCENT_CALC Percent Calculation Char 1 Upper PLAN_ENROLL_DT Plan Enroll Date Date 10 PLAN_TYPE Plan Type Char 2 Upper PLAN_TYPE_RA Plan Type ATAX Rollover Char 2 Upper PLAN_TYPE_RB Plan Type BTAX Rollover Char 2 Upper PREVIOUSLY_SEEN Previously Seen Char 1 Upper PROOF_RCVD Proof Received Char 1 Upper RATE_AMOUNT Rate Amount Sign 5.2 RATE_PERCENT Rate Percent Nbr 3 RATE_QUALIFIER Rate Qualifier Char 1 Upper SAVINGS_COVRG Savings Coverage Char 1 Upper SAVINGS_COVRG_ATAX Savings Coverage After-Tax Char 1 Upper SCHED_ID Schedule ID Char 6 Upper VACN_BUY_FLAT_AMT Vacation Buy Flat Amount Nbr 5.2 VACN_HOURS Vacation Buy/Sell Hours Nbr 4.2 VACN_SELL_FLAT_AMT Vacation Sell Flat Amount Nbr 5.2 VOLUNTARY_AMT Voluntary Contr. Amt Nbr 8.2 VOLUNTARY_PCT Voluntary Contr. Pct Nbr 3.3 PeopleSoft Report ID: XRFRCFL CROSS REFERENCE -- RECORDS AND FIELDS Page No. 69 Run Date 05/07/2001 Run Time 10:19:43 Record Name Field Name Long Field Name Type Length Format --------------- ------------------ ------------------------------ ---- ------ ------ BAS_PAR_PRC_KEY ADDR_ELIG_CHG Address Eligibility Changed Char 1 Upper BAS_EVENT_CHG Event Out of Sequence Char 1 Upper BAS_EVT_DISCONNECT Event Disconnected Char 1 Upper BAS_PROCESS_STATUS Process Status Char 2 Upper BAS_SELECT_DATA Select Participants Char 1 Upper BENEFIT_PROGRAM Benefit Program Char 3 Upper EFFDT Effective Date Date 10 EMPLID EmplID Char 11 Upper EVENT_CLASS Event Classification Char 3 Upper EVENT_STATUS Event Status Char 1 Upper FINALIZE_ENROLL Finalize/Apply Defaults Char 1 Upper JOB_ELIG_CHG Job Eligibility Changed Char 1 Upper PROCESS_IND Process Indicator Char 1 Upper SCHED_ID Schedule ID Char 6 Upper UNION_ELIG_CHG Union Eligibility Changed Char 1 Upper BAS_PAR_PRC_SCH SCHED_ID Schedule ID Char 6 Upper BAS_PAR_STS_KEY BAS_OPEN_IND BAS Open Event Status Ind Char 1 Upper BENEFIT_RCD# Benefit Record Number Nbr 3 EMPLID EmplID Char 11 Upper BAS_PAR_STS_SCH BENEFIT_RCD# Benefit Record Number Nbr 3 EMPLID EmplID Char 11 Upper BAS_PAR_STS_WL ACTIVITYNAME Activity Name Char 30 Mixed BENEFIT_RCD# Benefit Record Number Nbr 3 BUSPROCNAME Business Process Name Char 30 Mixed EMPLID EmplID Char 11 Upper EVENTNAME Event Name Char 30 Mixed EVENT_ID Event Identification Nbr 6 INSTANCEID Instance ID Nbr 10 Cent NAME Name Char 50 Name SCHED_ID Schedule ID Char 6 Upper TRANSACTIONID Transaction ID Nbr 10 Cent WORKLISTNAME Work List Name Char 30 Mixed BAS_PAR_SUM_DTA BAS_CNT_AE_Y Address Elig Changed Cnt/Yes Nbr 7 BAS_CNT_EC_Y Event Out of Sequence Cnt/Yes Nbr 7 BAS_CNT_ED_Y Event Disconnected Cnt/Yes Nbr 7 BAS_CNT_ES_C Event Stat Cnt/Closed Nbr 7 BAS_CNT_ES_O Event Stat Cnt/Open Nbr 7 BAS_CNT_ES_V Event Stat Cnt/Voided Nbr 7 BAS_CNT_FE_Y Finalize Enroll Cnt/Yes Nbr 7 BAS_CNT_JE_Y Job Elig Changed Cnt/Yes Nbr 7 BAS_CNT_PAR Total Participant Count Nbr 7 BAS_CNT_PI_A Process Ind Cnt/Assign Nbr 7 BAS_CNT_PI_E Process Ind Cnt/Elect Nbr 7 BAS_CNT_PI_N Process Ind Cnt/Normal Nbr 7 BAS_CNT_PI_P Process Ind Cnt/Prepare Nbr 7 BAS_CNT_PI_R Process Ind Cnt/Re-Enter Nbr 7 BAS_CNT_PI_V Process Ind Cnt/Void Nbr 7 BAS_CNT_PS_AE Process Stat Cnt/Assign Error Nbr 7 BAS_CNT_PS_AN Process Stat Cnt/Assign None Nbr 7 BAS_CNT_PS_AS Process Stat Cnt/Assigned Nbr 7 BAS_CNT_PS_EE Process Stat Cnt/Elect Error Nbr 7 BAS_CNT_PS_ET Process Stat Cnt/Entered Nbr 7 BAS_CNT_PS_FA Process Stat Cnt/Final Pgm No Nbr 7 BAS_CNT_PS_FE Process Stat Cnt/Enrolled Nbr 7 BAS_CNT_PS_FP Process Stat Cnt/Final Prep No Nbr 7 BAS_CNT_PS_NT Process Stat Cnt/Notified Nbr 7 BAS_CNT_PS_PE Process Stat Cnt/Prepare Error Nbr 7 BAS_CNT_PS_PR Process Stat Cnt/Prepared Nbr 7 BAS_CNT_PS_RE Process Stat Cnt/Re-Enter Nbr 7 BAS_CNT_UE_Y Union Elig Changed Cnt/Yes Nbr 7 BAS_PCT_AE_Y Address Elig Changed Pct/Yes Nbr 3.2 BAS_PCT_EC_Y Event Out of Sequence Pct/Yes Nbr 3.2 BAS_PCT_ED_Y Event Disconnected Pct/Yes Nbr 3.2 BAS_PCT_ES_C Event Stat Pct/Closed Nbr 3.2 PeopleSoft Report ID: XRFRCFL CROSS REFERENCE -- RECORDS AND FIELDS Page No. 70 Run Date 05/07/2001 Run Time 10:19:43 Record Name Field Name Long Field Name Type Length Format --------------- ------------------ ------------------------------ ---- ------ ------ BAS_PAR_SUM_DTA BAS_PCT_ES_O Event Stat Pct/Open Nbr 3.2 BAS_PCT_ES_V Event Stat Pct/Voided Nbr 3.2 BAS_PCT_FE_Y Finalize Enroll Pct/Yes Nbr 3.2 BAS_PCT_JE_Y Job Elig Changed Pct/Yes Nbr 3.2 BAS_PCT_PI_A Process Ind Pct/Assign Nbr 3.2 BAS_PCT_PI_E Process Ind Pct/Elect Nbr 3.2 BAS_PCT_PI_N Process Ind Pct/Normal Nbr 3.2 BAS_PCT_PI_P Process Ind Pct/Prepare Nbr 3.2 BAS_PCT_PI_R Process Ind Pct/Re-Enter Nbr 3.2 BAS_PCT_PI_V Process Ind Pct/Void Nbr 3.2 BAS_PCT_PS_AE Process Stat Pct/Assign Error Nbr 3.2 BAS_PCT_PS_AN Process Stat Pct/Assign None Nbr 3.2 BAS_PCT_PS_AS Process Stat Pct/Assigned Nbr 3.2 BAS_PCT_PS_EE Process Stat Pct/Elect Error Nbr 3.2 BAS_PCT_PS_ET Process Stat Pct/Entered Nbr 3.2 BAS_PCT_PS_FA Process Stat Pct/Final Pgm No Nbr 3.2 BAS_PCT_PS_FE Process Stat Pct/Enrolled Nbr 3.2 BAS_PCT_PS_FP Process Stat Pct/Final Prep No Nbr 3.2 BAS_PCT_PS_NT Process Stat Pct/Notified Nbr 3.2 BAS_PCT_PS_PE Process Stat Pct/Prepare Error Nbr 3.2 BAS_PCT_PS_PR Process Stat Pct/Prepared Nbr 3.2 BAS_PCT_PS_RE Process Stat Pct/Re-Enter Nbr 3.2 BAS_PCT_UE_Y Union Elig Changed Pct/Yes Nbr 3.2 BAS_PAR_SUM_SCH SCHED_ID Schedule ID Char 6 Upper BAS_PAR_V2 BENEFIT_RCD# Benefit Record Number Nbr 3 EMPLID EmplID Char 11 Upper EVENT_ID Event Identification Nbr 6 SCHED_ID Schedule ID Char 6 Upper BAS_PAR_VW ADDR_EFFDT Address Effective Date Date 10 ADDR_ELIG_CHG Address Eligibility Changed Char 1 Upper ADDR_ELIG_CHG_DT Address Elig Changed Date Date 10 ALLOW_SELF_SERVICE Available through Self Service Char 1 Upper BAS_ACTION_SOURCE Source of Action Char 2 Upper BAS_EVENT_CHG Event Out of Sequence Char 1 Upper BAS_EVENT_CHG_DT Event Changed Date Date 10 BAS_EVT_DISCONNECT Event Disconnected Char 1 Upper BAS_EVT_DISC_DT Event Disconnect Date Date 10 BAS_PROCESS_STATUS Process Status Char 2 Upper BENEFIT_PROGRAM Benefit Program Char 3 Upper BENEFIT_RCD# Benefit Record Number Nbr 3 COBRA_ACTION COBRA Action Char 3 Upper CONFIRM_NOTIFY_DT Date Notified of Confirmation Date 10 CONFIRM_RCVD_DT Confirmation Received Date Date 10 CREDIT_ROLLOVER Excess Credit Rollover To Char 1 Upper EFFDT Effective Date Date 10 ELECT_RCVD_DT Elections Received Date Date 10 ELECT_SOURCE Election Source Char 1 Upper EMPLID EmplID Char 11 Upper EMPL_RCD# Employment Rcd Nbr Nbr 3 EVENT_CLASS Event Classification Char 3 Upper EVENT_DT Event Date Date 10 EVENT_EFFSEQ Effective Sequence of Event Nbr 3 EVENT_EMPLRCD Event Empl Rcd# Nbr 3 EVENT_ID Event Identification Nbr 6 EVENT_PRIORITY Event Priority Nbr 3 EVENT_STATUS Event Status Char 1 Upper FINALIZE_ENROLL Finalize/Apply Defaults Char 1 Upper JOB_EFFDT Job Effective Date Date 10 JOB_EFFSEQ Job Effective Sequence Nbr 1 JOB_ELIG_CHG Job Eligibility Changed Char 1 Upper JOB_ELIG_CHG_DT Job Elig Changed Date Date 10 MULTI_ACTIVITY_IND Multi-Activity Indicator Char 1 Upper OPTION_NOTIFY_DT Date Notified of Options Date 10 PROCESS_IND Process Indicator Char 1 Upper SCHED_ID Schedule ID Char 6 Upper SERVICE_DT Service Date Date 10 PeopleSoft Report ID: XRFRCFL CROSS REFERENCE -- RECORDS AND FIELDS Page No. 71 Run Date 05/07/2001 Run Time 10:19:43 Record Name Field Name Long Field Name Type Length Format --------------- ------------------ ------------------------------ ---- ------ ------ BAS_PAR_VW STATUS_DT Status Date Date 10 UNION_CD Union Code Char 3 Upper UNION_EFFDT Union Effective Date Date 10 UNION_EFFSEQ Union Effective Sequence Nbr 3 UNION_ELIG_CHG Union Eligibility Changed Char 1 Upper UNION_ELIG_CHG_DT Union Elig Changed Date Date 10 BAS_PASSIVE_EVT COBRA_EVENT_CLASS COBRA Event Classification Char 3 Upper DESCR Description Char 30 Mixed DESCRSHORT Short Description Char 10 Mixed EFF_STATUS Status as of Effective Date Char 1 Upper EVENT_CLASS Event Classification Char 3 Upper PASSIVE_EVENT_DD Event Limit - Days Nbr 3 PASSIVE_EVENT_ID Passive Event Id Char 3 Upper PASSIVE_EVENT_MM Event Limit - Months Nbr 4 PASSIVE_EVENT_USE Passive Event Type Char 1 Upper BAS_PASS_HIST PASSIVE_EVENT_ID Passive Event Id Char 3 Upper PASSIVE_EVENT_SEQ Passive Event Sequence Nbr 3 PASSIVE_FROM_DT Passive Event From Date Date 10 PASSIVE_TO_DT Passive Event To Date Date 10 PROCESS_DT Process Date Date 10 BAS_PRNT PRINT_ID Print ID Char 6 Upper SCHED_ID Schedule ID Char 6 Upper BAS_PRNT_PARTIC BENEFIT_RCD# Benefit Record Number Nbr 3 EMPLID EmplID Char 11 Upper EVENT_ID Event Identification Nbr 6 PRINT_ID Print ID Char 6 Upper BAS_PRNT_PAR_V1 EMPLID EmplID Char 11 Upper NAME Name Char 50 Name SCHED_ID Schedule ID Char 6 Upper BAS_PRNT_PAR_V2 BENEFIT_RCD# Benefit Record Number Nbr 3 EMPLID EmplID Char 11 Upper SCHED_ID Schedule ID Char 6 Upper BAS_PRNT_PAR_V3 BENEFIT_RCD# Benefit Record Number Nbr 3 EMPLID EmplID Char 11 Upper EVENT_ID Event Identification Nbr 6 SCHED_ID Schedule ID Char 6 Upper BAS_RATCDVW_LNG COMP_RATECD Comp Rate Code Char 6 Upper DESCR Description Char 30 Mixed DESCRSHORT Short Description Char 10 Mixed EFFDT Effective Date Date 10 LANGUAGE_CD Language Code Char 3 Upper BAS_SCHED ALLOW_SELF_SERVICE Available through Self Service Char 1 Upper BAS_GROUP_ID BAS Group ID Char 3 Upper BAS_TYPE Ben Admin Type Char 1 Upper COMPANY Company Char 3 Upper DESCR Description Char 30 Mixed DESCRSHORT Short Description Char 10 Mixed OE_DEFN_ID Open Enrollment Definition ID Char 4 Upper OE_STATUS_IND Open Enrollment Status Flag Char 1 Upper SCHED_ID Schedule ID Char 6 Upper SNAP_DEFN_ID Snapshot Definition ID Char 4 Upper SNAP_STATUS_IND Snapshot Status Flag Char 1 Upper BAS_SERV_DT_WL ACTIVITYNAME Activity Name Char 30 Mixed BUSPROCNAME Business Process Name Char 30 Mixed EMPLID EmplID Char 11 Upper EMPL_RCD# Employment Rcd Nbr Nbr 3 EVENTNAME Event Name Char 30 Mixed INSTANCEID Instance ID Nbr 10 Cent TRANSACTIONID Transaction ID Nbr 10 Cent PeopleSoft Report ID: XRFRCFL CROSS REFERENCE -- RECORDS AND FIELDS Page No. 72 Run Date 05/07/2001 Run Time 10:19:43 Record Name Field Name Long Field Name Type Length Format --------------- ------------------ ------------------------------ ---- ------ ------ BAS_SERV_DT_WL WORKLISTNAME Work List Name Char 30 Mixed BAS_SNP_DFN ALLOW_FINALIZE Allow Finalization Char 1 Upper CALC_PRICES Calculate Option Prices Char 1 Upper DESCR Description Char 30 Mixed DESCRSHORT Short Description Char 10 Mixed PERIOD_BEGIN_DT Period Begin Date Date 10 SNAP_DEFN_ID Snapshot Definition ID Char 4 Upper VALIDATE_CURRENT Validate Current Elections Char 1 Upper BAS_SNP_DFN_PLN BENEFIT_PROGRAM Benefit Program Char 3 Upper SNAP_DEFN_ID Snapshot Definition ID Char 4 Upper BAS_STANDARD_VW COUNTRY Country Char 3 Upper DESCR50 Description Char 50 Mixed REG_REGION Regulatory Region Char 5 Upper BAS_STDVW_LNG DESCR50 Description Char 50 Mixed LANGUAGE_CD Language Code Char 3 Upper REG_REGION Regulatory Region Char 5 Upper BATCH_MSGS_WRK DESCRLONG Description Long 0 LANGUAGE_CD Language Code Char 3 Upper MESSAGE_TEXT Message Text Char 100 Mixed BA_CD_TBL BA_CD BA Code Char 3 Upper DESCR100 Description Char 100 Mixed DESCRSHORT Short Description Char 10 Mixed EFFDT Effective Date Date 10 EFF_STATUS Status as of Effective Date Char 1 Upper BA_CD_TBL_LANG BA_CD BA Code Char 3 Upper DESCR100 Description Char 100 Mixed DESCRSHORT Short Description Char 10 Mixed EFFDT Effective Date Date 10 LANGUAGE_CD Language Code Char 3 Upper BDGT_BENEF_GRP BDGT_BENEF_GRP Budget Benefit Group Char 10 Upper EFFDT Effective Date Date 10 PLAN_TYPE Plan Type Char 2 Upper BDGT_BENEF_LANG BDGT_BENEF_GRP Budget Benefit Group Char 10 Upper DESCR Description Char 30 Mixed DESCRSHORT Short Description Char 10 Mixed EFFDT Effective Date Date 10 LANGUAGE_CD Language Code Char 3 Upper BDGT_BENEF_TBL BDGT_BENEF_GRP Budget Benefit Group Char 10 Upper DESCR Description Char 30 Mixed DESCRSHORT Short Description Char 10 Mixed EFFDT Effective Date Date 10 BDGT_EXPORT_WRK ACCT_CD Account Code Char 25 Upper BUDGET_AMT Budget Amount Nbr 8.2 CURRENCY_CD Currency Code Char 3 Upper DEPTID Department Char 10 Upper EFFDT Effective Date Date 10 EMPLID EmplID Char 11 Upper EMPL_RCD# Employment Rcd Nbr Nbr 3 JOBCODE Job Code Char 6 Upper OUT_PROC_INDC Output Budget Process Indic. Nbr 2 POSITION_NBR Position Number Char 8 Upper POSITION_POOL_ID Position Pool ID Char 3 Upper BD_JOBCODES CURRENCY_CD Currency Code Char 3 Upper DESCR Description Char 30 Mixed EFFDT Effective Date Date 10 EFF_STATUS Status as of Effective Date Char 1 Upper GRADE Salary Grade Char 5 Upper PeopleSoft Report ID: XRFRCFL CROSS REFERENCE -- RECORDS AND FIELDS Page No. 73 Run Date 05/07/2001 Run Time 10:19:43 Record Name Field Name Long Field Name Type Length Format --------------- ------------------ ------------------------------ ---- ------ ------ BD_JOBCODES JOBCODE Job Code Char 6 Upper REG_TEMP Regular/Temporary Char 1 Upper SAL_ADMIN_PLAN Salary Administration Plan Char 3 Upper SETID SetID Char 5 Upper STD_HOURS Standard Hours Nbr 2.2 STEP Step Char 5 Upper SURVEY_SALARY Survey Salary Nbr 8 BD_LISTS_WRK ASSET_CATALOG_WRK Asset Catalog - Run Rpt Char 1 Upper EMPLOYEE_WRK Employee - Run Rpt Char 1 Upper JOBCODES_WRK Job Codes - Run Rpt Char 1 Upper POSITION_WRK Positions - Run Rpt Char 1 Upper PROPOSAL_WRK Proposals - Run Rpt Char 1 Upper SCENARIOS_WRK Scenarios - Run Rpt Char 1 Upper BD_POSITION_TBL ACCOUNT Account Char 6 Upper AFFILIATE Affiliate Char 5 Upper ANNUAL_SALARY Annual Salary Amount Nbr 15.3 BD_UPDATE_FLAG Budgets Update flag Char 1 Upper BUDGET_AMT Budget Amount Nbr 8.2 BUDGET_PERIOD Budget Period Char 8 Upper BUDGET_SEQ Budget Sequence Nbr 2 BUSINESS_UNIT Business Unit Char 5 Upper BUSINESS_UNIT_HR Business Unit for HRMS Char 5 Upper CLASS_FLD Class Field Char 5 Upper CURRENCY_CD Currency Code Char 3 Upper DEPTID Department Char 10 Upper DESCR Description Char 30 Mixed DIST_PCT Percent of Distribution Nbr 3.3 EARNS_DIST_TYPE Earnings Distribution Type Char 1 Upper EMPLID EmplID Char 11 Upper EMPL_RCD# Employment Rcd Nbr Nbr 3 EMPL_STATUS Employee Status Char 1 Upper END_PERIOD End Period Sign 3 END_YEAR End Year Sign 4 EXISTING_POSN_FLG Existing Position Flag Char 1 Upper FULL_PART_TIME Full/Part Time Char 1 Upper FUND_CODE Fund Code Char 5 Upper GRADE Salary Grade Char 5 Upper JOBCODE Job Code Char 6 Upper LOCATION Location Code Char 10 Upper NAME Name Char 50 Name POSITION_NBR Position Number Char 8 Upper POSITION_NBR_HR Position Number - HR Char 8 Num POSN_STATUS Position Status Char 1 Upper PROGRAM_CODE Program Code Char 5 Upper PROJECT_ID Project/Grant Char 15 Upper REG_TEMP Regular/Temporary Char 1 Upper SAL_ADMIN_PLAN Salary Administration Plan Char 3 Upper SCENARIO Scenario Char 10 Upper SPREADTYPE Spread Type Nbr 5.3 START_PERIOD Start Period Sign 3 START_YEAR Start Year Sign 4 STATISTICS_CODE Statistics Code Char 3 Upper STD_HOURS Standard Hours Nbr 2.2 STEP Step Char 5 Upper BD_POS_POOL_WRK EFFDT Effective Date Date 10 FTE FTE Nbr 1.2 POSITION_NBR Position Number Char 8 Upper POSITION_POOL_ID Position Pool ID Char 3 Upper BD_SCENARIO_TBL DESCR Description Char 30 Mixed DESCRSHORT Short Description Char 10 Mixed EFFDT Effective Date Date 10 EFF_STATUS Status as of Effective Date Char 1 Upper SCENARIO Scenario Char 10 Upper SETID SetID Char 5 Upper PeopleSoft Report ID: XRFRCFL CROSS REFERENCE -- RECORDS AND FIELDS Page No. 74 Run Date 05/07/2001 Run Time 10:19:43 Record Name Field Name Long Field Name Type Length Format --------------- ------------------ ------------------------------ ---- ------ ------ BENEFITS_DATA ANNUAL_PLEDGE Annual Pledge Nbr 5.2 BEF_PLAN_DESCR Benefit Plan Description Char 30 Mixed BENEFIT_PLAN Benefit Plan Char 6 Upper BENEFIT_PROGRAM Benefit Program Char 3 Upper BENEFIT_PROG_DESCR Benefit Program Description Char 30 Mixed BENEF_PCT Percent Beneficiary Paid Nbr 3 BIRTHDATE Date of Birth Date 10 CALCULATED_BASE Coverage Base Nbr 8.2 COBRA_EVENT_ID COBRA Event Identification Nbr 3 COMPANY Company Char 3 Upper COMPANY_DESCR Company Descr Char 30 Mixed CONTINGENT Contingent Char 1 Upper COVERAGE_BEGIN_DT Coverage Begin Date Date 10 COVERAGE_ELECT Coverage Election Char 1 Upper COVERAGE_END_DT Coverage End Date Date 10 COVRG_CD Coverage Code Char 1 Upper COVRG_CODE_DESCR Coverage Code Descr Char 30 Mixed CURRENCY_CD Currency Code Char 3 Upper CURRENCY_DESCR Currency Code Description Char 30 Mixed DEDUCTION_BEGIN_DT Deduction Begin Date Date 10 DEDUCTION_END_DT Deduction End Date Date 10 DED_CUR Current Deduction Sign 8.2 DEPENDENT_BENEF Dependent/Beneficiary ID Char 2 Num EFFDT Effective Date Date 10 EMPLID EmplID Char 11 Upper EMPL_RCD# Employment Rcd Nbr Nbr 3 ENROLLMENT_DT Original Enrollment Date Date 10 EXCESS Excess Char 1 Upper FIRST_NAME First Name Char 30 Mixed FLAT_AMOUNT Flat Amount Nbr 8 FLAT_DED_AMT Flat Deduction Amount Nbr 6.2 FLAT_DED_AMT_ATAX Flat Deduction Amt After-Tax Nbr 6.2 GROUP# Group Number Char 10 Upper HLTH_PROVIDER_ID Health Provider ID Char 30 Upper HOME_PHONE Home Phone # Char 24 CtSec LAST_NAME Last Name Char 30 Mixed NAME Name Char 50 Name NAME_PREFIX Name Prefix Char 4 Mixed NATIONAL_ID Social Security No Char 15 CtSec PAYGROUP Pay Group Char 3 Upper PAYGROUP_DESCR Paygroup Descr Char 30 Mixed PAY_END_DT Pay Period End Date Date 10 PCT_GROSS Percent of Gross Nbr 3.3 PCT_GROSS_ATAX Percent of Gross After-Tax Nbr 3.3 PLAN_TYPE Plan Type Char 2 Upper PLAN_TYPE_DESCR Plan Type Description Char 30 Mixed POLICY# Policy Number Char 10 Upper PREVIOUSLY_SEEN Previously Seen Char 1 Upper PROVIDER Provider ID Char 6 Upper PROVIDER_DESCR Provider Description Char 30 Mixed RELATIONSHIP Relationship to Employee Char 2 Upper RELATION_DESCR Relationship Descr Char 30 Mixed SEX Gender Char 1 Upper VACN_BUY_FLAT_AMT Vacation Buy Flat Amount Nbr 5.2 VACN_HOURS Vacation Buy/Sell Hours Nbr 4.2 VACN_SELL_FLAT_AMT Vacation Sell Flat Amount Nbr 5.2 BENEFITS_DED_VW BENEFIT_PLAN Benefit Plan Char 6 Upper CALCULATED_BASE Coverage Base Nbr 8.2 DED_CLASS Deduction Classification Char 1 Upper DED_CUR Current Deduction Sign 8.2 EMPLID EmplID Char 11 Upper EMPL_RCD# Employment Rcd Nbr Nbr 3 PAY_END_DT Pay Period End Date Date 10 PLAN_TYPE Plan Type Char 2 Upper BENEFITS_SAV_VW BENEFIT_PLAN Benefit Plan Char 6 Upper DED_CLASS Deduction Classification Char 1 Upper DED_CUR Current Deduction Sign 8.2 PeopleSoft Report ID: XRFRCFL CROSS REFERENCE -- RECORDS AND FIELDS Page No. 75 Run Date 05/07/2001 Run Time 10:19:43 Record Name Field Name Long Field Name Type Length Format --------------- ------------------ ------------------------------ ---- ------ ------ BENEFITS_SAV_VW DED_SLSTX_CLASS Sales Tax Type Char 1 Upper EMPLID EmplID Char 11 Upper EMPL_RCD# Employment Rcd Nbr Nbr 3 PAY_END_DT Pay Period End Date Date 10 PLAN_TYPE Plan Type Char 2 Upper BENEFITS_VW BENEFIT_PLAN Benefit Plan Char 6 Upper CALCULATED_BASE Coverage Base Nbr 8.2 DED_CLASS Deduction Classification Char 1 Upper DED_CUR Current Deduction Sign 8.2 DED_SLSTX_CLASS Sales Tax Type Char 1 Upper EMPLID EmplID Char 11 Upper EMPL_RCD# Employment Rcd Nbr Nbr 3 PAY_END_DT Pay Period End Date Date 10 PLAN_TYPE Plan Type Char 2 Upper BENEFIT_PARTIC BENEFIT# Benefit Number Nbr 3 COBRA_EVENT_ID COBRA Event Identification Nbr 3 EMPLID EmplID Char 11 Upper EMPL_RCD# Employment Rcd Nbr Nbr 3 PLAN_TYPE Plan Type Char 2 Upper BENEF_COMMENT ACTION_DT Action Date Date 10 COMMENTS Comments Long 0 COMMENTS_BY_NAME Comments By Char 50 Mixed COMMENT_DT Comment Date Date 10 DEPENDENT_BENEF Dependent/Beneficiary ID Char 2 Num EMPLID EmplID Char 11 Upper EMPL_RCD# Employment Rcd Nbr Nbr 3 BENEF_PB_WRK BEN_COURT_ORDER_FL Court Order Flag Char 1 Upper COURT_ORDERS_PB Court Orders Char 1 Upper CROSS_PLAN_LOAD_PB Load Cross Plan Values Char 1 Upper ODEM_CONF_STMT_PB Confirmation Statement Char 1 Upper ODEM_ELECT_ENTR_PB Election Entry Char 1 Upper ODEM_ENRL_STMT_PB Enrollment Statement Char 1 Upper ODEM_PREP_OPTN_PB Prepare Options Char 1 Upper ODEM_REPROC_PB Reprocess Char 1 Upper ODEM_SCHED_ACTY_PB Schedule/Prepare Activity Char 1 Upper ODEM_SHOW_ACTYS_PB Show Activities Char 1 Upper ODEM_SHOW_ERR_PB Show Errors Char 1 Upper ODEM_SHOW_PLANS_PB Show Plans Char 1 Upper ODEM_ST_UPD_PB Event Status Update Char 1 Upper ODEM_VAL_FINAL_PB Validate/Finalize Char 1 Upper BENEF_PGM_LANG BENEFIT_PROGRAM Benefit Program Char 3 Upper DESCR Description Char 30 Mixed DESCRSHORT Short Description Char 10 Mixed EFFDT Effective Date Date 10 LANGUAGE_CD Language Code Char 3 Upper BENEF_PLAN_LANG BENEFIT_PLAN Benefit Plan Char 6 Upper DESCR Description Char 30 Mixed DESCRSHORT Short Description Char 10 Mixed EFFDT Effective Date Date 10 LANGUAGE_CD Language Code Char 3 Upper PLAN_TYPE Plan Type Char 2 Upper BENEF_PLAN_TBL BENEFIT_PLAN Benefit Plan Char 6 Upper DEDCD Deduction Code Char 6 Upper DESCR Description Char 30 Mixed DESCRSHORT Short Description Char 10 Mixed EFFDT Effective Date Date 10 GROUP# Group Number Char 10 Upper INCLUDE_IN_NDT Include in Nondiscrimination Char 1 Upper PLAN_TYPE Plan Type Char 2 Upper PROVIDER Provider ID Char 6 Upper BEN_BI_ADJSTMNT ADJUST_TYPE Adjustment Type Char 3 Upper PeopleSoft Report ID: XRFRCFL CROSS REFERENCE -- RECORDS AND FIELDS Page No. 76 Run Date 05/07/2001 Run Time 10:19:43 Record Name Field Name Long Field Name Type Length Format --------------- ------------------ ------------------------------ ---- ------ ------ BEN_BI_ADJSTMNT ADJ_DESCR Adjustment Description Char 250 Upper ADJ_ENTRY_DT Adjustment Entry Date Date 10 BILL_ADJ_ID Billing Adjustment ID Sign 7 BILL_CHARGE_ID Billing Charge Id Nbr 7 BILL_PAY_ID Payment Id Nbr 7 EMPLID EmplID Char 11 Upper NET_ADJUSTMENT Net Adjustment Sign 5.2 POSTING_DATE Posting Date Date 10 POSTING_SEQUENCE Posting Sequence Nbr 2 PRINT_PERIOD Print Period Char 4 Upper BEN_BI_ADJST_VW ADJUST_TYPE Adjustment Type Char 3 Upper ADJ_DESCR Adjustment Description Char 250 Upper EMPLID EmplID Char 11 Upper NET_ADJUSTMENT Net Adjustment Sign 5.2 POSTING_DATE Posting Date Date 10 BEN_BI_BLNC_VW AMOUNT_DUE Amount Due Sign 5.2 AMOUNT_PAID Total Payments For Charge Sign 5.2 BENEFIT_PLAN Benefit Plan Char 6 Upper BENEFIT_PROGRAM Benefit Program Char 3 Upper BILLING_REASON Billing Reason Char 1 Upper BILL_CHARGE_ID Billing Charge Id Nbr 7 BILL_PER_CD Billing Period Char 4 Upper BILL_PROCESS_DT Date Entered Date 10 BILL_SOURCE Billing Source Char 1 Upper CHARGE Original Charge Sign 5.2 CHRG_ADJUST Charge Adjustments Sign 5.2 COBRA_EVENT_ID COBRA Event Identification Nbr 3 COVRG_CD Coverage Code Char 1 Upper DATE_DUE Date Due Date 10 DATE_OVERDUE Date Overdue Date 10 DEDCD Deduction Code Char 6 Upper DED_SLSTX_CLASS Sales Tax Type Char 1 Upper EMPLID EmplID Char 11 Upper EMPL_RCD# Employment Rcd Nbr Nbr 3 PLAN_TYPE Plan Type Char 2 Upper PMT_ADJUST Payment Adjustments Sign 5.2 PRINT_PERIOD Print Period Char 4 Upper TOTAL_CHARGE Total Charge Sign 5.2 TOTAL_PAYMENT Total Payment Sign 5.2 BEN_BI_CALENDAR BILL_CALC_RUN Billing Calculation Run Char 1 Upper BILL_DUE Payment Due Date 10 BILL_PER_CD Billing Period Char 4 Upper BILL_STATEMENT_RUN Billing Statements Printed Char 1 Upper COBRA_DUE COBRA Payment Due Date 10 COMMENTS Comments Long 0 PERIOD_BEGIN_DT Period Begin Date Date 10 PERIOD_END_DT Period End Date Date 10 BEN_BI_CHARGE BENEFIT_PLAN Benefit Plan Char 6 Upper BENEFIT_PROGRAM Benefit Program Char 3 Upper BILLING_REASON Billing Reason Char 1 Upper BILL_CHARGE_ID Billing Charge Id Nbr 7 BILL_PER_CD Billing Period Char 4 Upper BILL_PROCESS_DT Date Entered Date 10 BILL_SOURCE Billing Source Char 1 Upper COBRA_EVENT_ID COBRA Event Identification Nbr 3 COUNTRY Country Char 3 Upper COVRG_CD Coverage Code Char 1 Upper DATE_DUE Date Due Date 10 DATE_OVERDUE Date Overdue Date 10 DEDCD Deduction Code Char 6 Upper DED_SLSTX_CLASS Sales Tax Type Char 1 Upper EMPLID EmplID Char 11 Upper EMPL_RCD# Employment Rcd Nbr Nbr 3 PLAN_TYPE Plan Type Char 2 Upper PRINT_PERIOD Print Period Char 4 Upper PeopleSoft Report ID: XRFRCFL CROSS REFERENCE -- RECORDS AND FIELDS Page No. 77 Run Date 05/07/2001 Run Time 10:19:43 Record Name Field Name Long Field Name Type Length Format --------------- ------------------ ------------------------------ ---- ------ ------ BEN_BI_CHARGE PROCESS_PERIOD Processing Period Char 4 Upper PROVINCE Province Char 6 Upper BEN_BI_CHG_VW AMOUNT_DUE Amount Due Sign 5.2 AMOUNT_PAID Total Payments For Charge Sign 5.2 BENEFIT_PLAN Benefit Plan Char 6 Upper BENEFIT_PROGRAM Benefit Program Char 3 Upper BILLING_REASON Billing Reason Char 1 Upper BILL_CHARGE_ID Billing Charge Id Nbr 7 BILL_PER_CD Billing Period Char 4 Upper BILL_PROCESS_DT Date Entered Date 10 BILL_SOURCE Billing Source Char 1 Upper CHARGE Original Charge Sign 5.2 CHRG_ADJUST Charge Adjustments Sign 5.2 COBRA_EVENT_ID COBRA Event Identification Nbr 3 COUNTRY Country Char 3 Upper COVRG_CD Coverage Code Char 1 Upper DATE_DUE Date Due Date 10 DATE_OVERDUE Date Overdue Date 10 DEDCD Deduction Code Char 6 Upper DED_SLSTX_CLASS Sales Tax Type Char 1 Upper EMPLID EmplID Char 11 Upper EMPL_RCD# Employment Rcd Nbr Nbr 3 PLAN_TYPE Plan Type Char 2 Upper PMT_ADJUST Payment Adjustments Sign 5.2 PRINT_PERIOD Print Period Char 4 Upper PROCESS_PERIOD Processing Period Char 4 Upper PROVINCE Province Char 6 Upper TOTAL_CHARGE Total Charge Sign 5.2 BEN_BI_CSB_SRCH BILL_PER_CD Billing Period Char 4 Upper NATIONAL_ID Social Security No Char 15 CtSec NATIONAL_ID_TYPE National ID Type Char 4 Upper NID_COUNTRY National ID Country Char 3 Upper NID_DESCRSHORT NID Short Description Char 10 Upper BEN_BI_CSP_SRCH NATIONAL_ID Social Security No Char 15 CtSec NATIONAL_ID_TYPE National ID Type Char 4 Upper NID_COUNTRY National ID Country Char 3 Upper NID_DESCRSHORT NID Short Description Char 10 Upper PLAN_TYPE Plan Type Char 2 Upper BEN_BI_DETAIL BILL_ADJ_ID Billing Adjustment ID Sign 7 BILL_CHARGE_ID Billing Charge Id Nbr 7 BILL_PAY_ID Payment Id Nbr 7 CHARGE_AMT Charge Amount Sign 5.2 CHRG_ADJUST Charge Adjustments Sign 5.2 DETAIL_TYPE Action Type Char 4 Upper EMPLID EmplID Char 11 Upper EXCESS_CASH Excess Cash Sign 5.2 GL_POST_DT General Ledger Posting Date Date 10 PAY_AMT Payment Amount Sign 5.2 PMT_ADJUST Payment Adjustments Sign 5.2 POSTED_DATE Date Posted Date 10 BEN_BI_EMP_PARM BILL_PER_CD Billing Period Char 4 Upper BILL_TO_ZERO Produce Statements Char 1 Upper COMMENTS Comments Long 0 COMMENT_PRINT Print Comments Char 3 Upper EFFDT Effective Date Date 10 EMPLID EmplID Char 11 Upper HOLD_BILLING Hold Billing Char 1 Upper HOLD_PRINT Hold Statements Char 1 Upper BEN_BI_ENR_CBR COBRA COBRA Char 1 Upper COBRA_EVENT_ID COBRA Event Identification Nbr 3 EMPLID EmplID Char 11 Upper EMPL_RCD# Employment Rcd Nbr Nbr 3 PLAN_TYPE Plan Type Char 2 Upper PeopleSoft Report ID: XRFRCFL CROSS REFERENCE -- RECORDS AND FIELDS Page No. 78 Run Date 05/07/2001 Run Time 10:19:43 Record Name Field Name Long Field Name Type Length Format --------------- ------------------ ------------------------------ ---- ------ ------ BEN_BI_ENR_EFDT BILLING_REASON Billing Reason Char 1 Upper BILLING_STATUS Billing Status Char 1 Upper COBRA_EVENT_ID COBRA Event Identification Nbr 3 EFFDT Effective Date Date 10 EMPLID EmplID Char 11 Upper EMPL_RCD# Employment Rcd Nbr Nbr 3 EVENT_ID Event Identification Nbr 6 FLAT_CALC Flat Amount of Char 1 Upper PERCENT_CALC Percent Calculation Char 1 Upper PLAN_TYPE Plan Type Char 2 Upper RATE_AMOUNT Rate Amount Sign 5.2 RATE_PERCENT Rate Percent Nbr 3 RATE_QUALIFIER Rate Qualifier Char 1 Upper BEN_BI_ENR_PLAN EMPLID EmplID Char 11 Upper EMPL_RCD# Employment Rcd Nbr Nbr 3 PLAN_TYPE Plan Type Char 2 Upper BEN_BI_MESSAGE BILL_PER_CD Billing Period Char 4 Upper EMPLID EmplID Char 11 Upper MSGDATA1 Message Data Char 35 Mixed MSGDATA2 Message Data Char 35 Mixed MSGDATA3 Message Data Char 35 Mixed MSGID Message ID Char 6 Upper BEN_BI_PARMS BILL_DAYS_DUE Days Due Sign 2 BILL_DAYS_OVERDUE Days to Overdue Sign 2 BILL_FREQ Billing Frequency Char 1 Upper CBR_DAYS_DUE COBRA Days Due Sign 2 CBR_DAYS_OVERDUE Days to Overdue Sign 2 BEN_BI_PAYMENT BILL_PAY_ID Payment Id Nbr 7 EMPLID EmplID Char 11 Upper PAYMENT_ENTRY_DT Payment Entry Date Date 10 PAYMENT_FORM Form of Payment Char 3 Upper PAYMENT_SOURCE Payment Source Char 1 Upper POSTING_DATE Posting Date Date 10 POSTING_SEQUENCE Posting Sequence Nbr 2 PRINT_PERIOD Print Period Char 4 Upper BEN_BI_PAY_VW ACTUAL_PAYMENT Actual Payment Sign 5.2 AMOUNT_PAID Total Payments For Charge Sign 5.2 BILL_PAY_ID Payment Id Nbr 7 EMPLID EmplID Char 11 Upper PAYMENT_ENTRY_DT Payment Entry Date Date 10 PAYMENT_FORM Form of Payment Char 3 Upper PAYMENT_SOURCE Payment Source Char 1 Upper PMT_ADJUST Payment Adjustments Sign 5.2 POSTING_DATE Posting Date Date 10 POSTING_SEQUENCE Posting Sequence Nbr 2 PRINT_PERIOD Print Period Char 4 Upper BEN_BI_PRNT BILL_PER_CD Billing Period Char 4 Upper PRINT_ID Print ID Char 6 Upper BEN_BI_PRNT_PAR EMPLID EmplID Char 11 Upper PRINT_ID Print ID Char 6 Upper BEN_BI_PRVW_VW AMOUNT_DUE Amount Due Sign 5.2 AMOUNT_PAID Total Payments For Charge Sign 5.2 BENEFIT_PLAN Benefit Plan Char 6 Upper BENEFIT_PROGRAM Benefit Program Char 3 Upper BILLING_REASON Billing Reason Char 1 Upper BILL_CHARGE_ID Billing Charge Id Nbr 7 BILL_PAY_ID Payment Id Nbr 7 BILL_PER_CD Billing Period Char 4 Upper BILL_PROCESS_DT Date Entered Date 10 BILL_SOURCE Billing Source Char 1 Upper PeopleSoft Report ID: XRFRCFL CROSS REFERENCE -- RECORDS AND FIELDS Page No. 79 Run Date 05/07/2001 Run Time 10:19:43 Record Name Field Name Long Field Name Type Length Format --------------- ------------------ ------------------------------ ---- ------ ------ BEN_BI_PRVW_VW CHARGE Original Charge Sign 5.2 CHRG_ADJUST Charge Adjustments Sign 5.2 COBRA_EVENT_ID COBRA Event Identification Nbr 3 COUNTRY Country Char 3 Upper COVRG_CD Coverage Code Char 1 Upper DATE_DUE Date Due Date 10 DATE_OVERDUE Date Overdue Date 10 DEDCD Deduction Code Char 6 Upper DED_SLSTX_CLASS Sales Tax Type Char 1 Upper EMPLID EmplID Char 11 Upper EMPL_RCD# Employment Rcd Nbr Nbr 3 PLAN_TYPE Plan Type Char 2 Upper PMT_ADJUST Payment Adjustments Sign 5.2 PRINT_PERIOD Print Period Char 4 Upper PROCESS_PERIOD Processing Period Char 4 Upper PROVINCE Province Char 6 Upper TOTAL_CHARGE Total Charge Sign 5.2 TOTAL_PAID Total Amount Paid Sign 5.2 BEN_BI_PYMNT_VW AMOUNT_DUE Amount Due Sign 5.2 AMOUNT_PAID Total Payments For Charge Sign 5.2 BENEFIT_PLAN Benefit Plan Char 6 Upper BENEFIT_PROGRAM Benefit Program Char 3 Upper BILLING_REASON Billing Reason Char 1 Upper BILL_CHARGE_ID Billing Charge Id Nbr 7 BILL_PER_CD Billing Period Char 4 Upper BILL_PROCESS_DT Date Entered Date 10 BILL_SOURCE Billing Source Char 1 Upper CHARGE Original Charge Sign 5.2 CHRG_ADJUST Charge Adjustments Sign 5.2 COBRA_EVENT_ID COBRA Event Identification Nbr 3 COVRG_CD Coverage Code Char 1 Upper DATE_DUE Date Due Date 10 DATE_OVERDUE Date Overdue Date 10 DEDCD Deduction Code Char 6 Upper DED_SLSTX_CLASS Sales Tax Type Char 1 Upper EMPLID EmplID Char 11 Upper EMPL_RCD# Employment Rcd Nbr Nbr 3 PLAN_TYPE Plan Type Char 2 Upper PMT_ADJUST Payment Adjustments Sign 5.2 PRINT_PERIOD Print Period Char 4 Upper TOTAL_CHARGE Total Charge Sign 5.2 BEN_BI_PYS_SRCH NATIONAL_ID Social Security No Char 15 CtSec NATIONAL_ID_TYPE National ID Type Char 4 Upper NID_COUNTRY National ID Country Char 3 Upper NID_DESCRSHORT NID Short Description Char 10 Upper BEN_BI_PYS_VW ACTUAL_PAYMENT Actual Payment Sign 5.2 AMOUNT_PAID Total Payments For Charge Sign 5.2 BILL_PAY_ID Payment Id Nbr 7 EMPLID EmplID Char 11 Upper PAYMENT_ENTRY_DT Payment Entry Date Date 10 PAYMENT_FORM Form of Payment Char 3 Upper PAYMENT_SOURCE Payment Source Char 1 Upper PMT_ADJUST Payment Adjustments Sign 5.2 POSTING_DATE Posting Date Date 10 POSTING_SEQUENCE Posting Sequence Nbr 2 PRINT_PERIOD Print Period Char 4 Upper BEN_BI_PY_SRCH NATIONAL_ID Social Security No Char 15 CtSec NATIONAL_ID_TYPE National ID Type Char 4 Upper NID_COUNTRY National ID Country Char 3 Upper NID_DESCRSHORT NID Short Description Char 10 Upper POSTING_DATE Posting Date Date 10 POSTING_SEQUENCE Posting Sequence Nbr 2 BEN_BI_RUNCTL BILL_DUE Payment Due Date 10 BILL_PAY_ID Payment Id Nbr 7 PeopleSoft Report ID: XRFRCFL CROSS REFERENCE -- RECORDS AND FIELDS Page No. 80 Run Date 05/07/2001 Run Time 10:19:43 Record Name Field Name Long Field Name Type Length Format --------------- ------------------ ------------------------------ ---- ------ ------ BEN_BI_RUNCTL BILL_PER_CD Billing Period Char 4 Upper BILL_PROC_PHASE Billing Processing Phase Char 1 Upper CHKPT_INTERVAL Check Point Interval in Minute Nbr 2 COBRA_DUE COBRA Payment Due Date 10 EMPLID EmplID Char 11 Upper EMPL_RCD# Employment Rcd Nbr Nbr 3 OPRID Operator Id Char 8 Mixed PROCESS_DT Process Date Date 10 RUN_CNTL_ID Run Control ID Char 30 Mixed BEN_BI_SRCH_VW BILL_CHARGE_ID Billing Charge Id Nbr 7 BILL_PER_CD Billing Period Char 4 Upper DED_SLSTX_CLASS Sales Tax Type Char 1 Upper NATIONAL_ID Social Security No Char 15 CtSec NATIONAL_ID_TYPE National ID Type Char 4 Upper NID_COUNTRY National ID Country Char 3 Upper NID_DESCRSHORT NID Short Description Char 10 Upper PLAN_TYPE Plan Type Char 2 Upper BEN_COURT_ORDER DEPENDENT_BENEF Dependent/Beneficiary ID Char 2 Num EMPLID EmplID Char 11 Upper END_DT End Date Date 10 GVT_COURT_ORDR_NUM Court Order Number Char 30 Upper GVT_COURT_ORDR_RMK Court Order Remarks Long 275 PLAN_TYPE Plan Type Char 2 Upper START_DT Start Date Date 10 STATE State Char 6 Upper BEN_DED_SAV_VW BENEFIT_PLAN Benefit Plan Char 6 Upper DED_CLASS Deduction Classification Char 1 Upper DED_CUR Current Deduction Sign 8.2 EMPLID EmplID Char 11 Upper EMPL_RCD# Employment Rcd Nbr Nbr 3 PAY_END_DT Pay Period End Date Date 10 PLAN_TYPE Plan Type Char 2 Upper BEN_DEFN_COST BENEFIT_PROGRAM Benefit Program Char 3 Upper CALC_RULES_ID Calculation Rules Table ID Char 4 Upper COST_ID Cost Identification Nbr 4 COST_TYPE Cost Type Char 1 Upper EFFDT Effective Date Date 10 ERNCD Earnings Code Char 3 Upper OPTION_ID Option Id Nbr 4 PLAN_TYPE Plan Type Char 2 Upper RATE_TBL_ID Rate Table ID Char 4 Upper RATE_TYPE Rate Type Char 1 Upper BEN_DEFN_OPTN BENEFIT_PLAN Benefit Plan Char 6 Upper BENEFIT_PROGRAM Benefit Program Char 3 Upper COVERAGE_LIMIT_PCT Cross Coverage Limit Pct Nbr 3.2 COVRG_CD Coverage Code Char 1 Upper CROSS_BENEF_PLAN Cross Benefit Plan Char 6 Upper CROSS_PLAN_TYPE Cross Plan Type Char 2 Upper CROSS_PLN_DPND_CHK Cross Plan Dependent Check Char 1 Upper DEDCD Deduction Code Char 6 Upper DFLT_OPTION_IND Default Option Indicator Char 1 Upper DISPLAY_OPT_SEQ Display Option Sequence Nbr 3 EFFDT Effective Date Date 10 ELIG_RULES_ID Eligibility Rules ID Char 4 Upper LOCATION_TBL_ID Location Table ID Char 4 Upper OPTION_CD Option Code Char 3 Upper OPTION_ID Option Id Nbr 4 OPTION_LVL Option Level Nbr 3 OPTION_TYPE Option Type Char 1 Upper PLAN_TYPE Plan Type Char 2 Upper BEN_DEFN_PGM BENEFIT_PROGRAM Benefit Program Char 3 Upper COBRA_DISABL_SURCG COBRA Disabled Surcharge % Nbr 2 COBRA_SURCHARGE COBRA Surcharge % Nbr 2 PeopleSoft Report ID: XRFRCFL CROSS REFERENCE -- RECORDS AND FIELDS Page No. 81 Run Date 05/07/2001 Run Time 10:19:43 Record Name Field Name Long Field Name Type Length Format --------------- ------------------ ------------------------------ ---- ------ ------ BEN_DEFN_PGM CURRENCY_CD Currency Code Char 3 Upper DEPENDENT_MARRIAGE Dep Ineligible if Married Char 1 Upper DEP_AGE_LIMIT COBRA Dependent Age Limit Nbr 2 DESCR Description Char 30 Mixed DESCRSHORT Short Description Char 10 Mixed DFLT_CREDIT_RLLOVR Apply Excess Credits to Char 1 Upper DFLT_EXPIRATION_DD Number of Days Before Defaults Nbr 3 EFFDT Effective Date Date 10 EFF_STATUS Status as of Effective Date Char 1 Upper EXCL_DISABLED_AGE Exclude Disabled from Age Lmt. Char 1 Upper FMLA_PLAN_ID FMLA Plan ID Char 3 Upper FSA_MAX_ANNL_PLDG FSA Maximum Annual Pledge Nbr 6.2 FSA_MIN_CHECK_AMT FSA Minimum Check Amount Nbr 4.2 FSA_RUN_ID Flexible Spending Acct Run ID Char 3 Upper PROGRAM_TYPE Program Type Char 1 Upper STUDENT_AGE_LIMIT COBRA Student Age Limit Nbr 2 BEN_DEFN_PGM_VW BENEFIT_PROGRAM Benefit Program Char 3 Upper CURR_EFFDT Current Benefit Program Effdt Date 10 BEN_DEFN_PLAN BENEFIT_PROGRAM Benefit Program Char 3 Upper COBRA_PLAN COBRA Plan? Char 1 Upper DISPLAY_PLN_SEQ Display Plan-type Sequence Char 2 Upper EFFDT Effective Date Date 10 EVENT_RULES_ID Event Rules ID Char 4 Upper HIPAA_PLAN HIPAA Plan Char 1 Upper MAX_ANNUAL_CONTRIB Maximum Annual Contribution Nbr 8.2 MIN_ANNUAL_CONTRIB Minimum Annual Contribution Nbr 4.2 PLAN_TYPE Plan Type Char 2 Upper RESTRICT_ENTRY_MM Months to Restrict Data Entry Nbr 2 WAIVE_COVERAGE Waive Coverage Permitted Char 1 Upper BEN_PER_DATA BIRTHDATE Date of Birth Date 10 COBRA_EVENT_ID COBRA Event Identification Nbr 3 DEPENDENT_BENEF Dependent/Beneficiary ID Char 2 Num EMPLID EmplID Char 11 Upper FIRST_NAME First Name Char 30 Mixed HOME_PHONE Home Phone # Char 24 CtSec LAST_NAME Last Name Char 30 Mixed NAME Name Char 50 Name NAME_PREFIX Name Prefix Char 4 Mixed NATIONAL_ID Social Security No Char 15 CtSec RELATIONSHIP Relationship to Employee Char 2 Upper RELATION_DESCR Relationship Descr Char 30 Mixed SEX Gender Char 1 Upper BEN_PLAN_DATA ANNUAL_PLEDGE Annual Pledge Nbr 5.2 BEF_PLAN_DESCR Benefit Plan Description Char 30 Mixed BENEFIT_PLAN Benefit Plan Char 6 Upper BENEFIT_PROGRAM Benefit Program Char 3 Upper BENEFIT_PROG_DESCR Benefit Program Description Char 30 Mixed BENEF_PCT Percent Beneficiary Paid Nbr 3 CALCULATED_BASE Coverage Base Nbr 8.2 COBRA_EVENT_ID COBRA Event Identification Nbr 3 COMPANY Company Char 3 Upper COMPANY_DESCR Company Descr Char 30 Mixed CONTINGENT Contingent Char 1 Upper COVERAGE_BEGIN_DT Coverage Begin Date Date 10 COVERAGE_ELECT Coverage Election Char 1 Upper COVERAGE_END_DT Coverage End Date Date 10 COVRG_CD Coverage Code Char 1 Upper COVRG_CODE_DESCR Coverage Code Descr Char 30 Mixed CURRENCY_CD Currency Code Char 3 Upper CURRENCY_DESCR Currency Code Description Char 30 Mixed DEDUCTION_BEGIN_DT Deduction Begin Date Date 10 DEDUCTION_END_DT Deduction End Date Date 10 DED_CUR Current Deduction Sign 8.2 DEPENDENT_BENEF Dependent/Beneficiary ID Char 2 Num EFFDT Effective Date Date 10 PeopleSoft Report ID: XRFRCFL CROSS REFERENCE -- RECORDS AND FIELDS Page No. 82 Run Date 05/07/2001 Run Time 10:19:43 Record Name Field Name Long Field Name Type Length Format --------------- ------------------ ------------------------------ ---- ------ ------ BEN_PLAN_DATA EMPLID EmplID Char 11 Upper EMPL_RCD# Employment Rcd Nbr Nbr 3 ENROLLMENT_DT Original Enrollment Date Date 10 EXCESS Excess Char 1 Upper FLAT_AMOUNT Flat Amount Nbr 8 FLAT_DED_AMT Flat Deduction Amount Nbr 6.2 FLAT_DED_AMT_ATAX Flat Deduction Amt After-Tax Nbr 6.2 GROUP# Group Number Char 10 Upper HLTH_PROVIDER_ID Health Provider ID Char 30 Upper PAYGROUP Pay Group Char 3 Upper PAYGROUP_DESCR Paygroup Descr Char 30 Mixed PAY_END_DT Pay Period End Date Date 10 PCT_GROSS Percent of Gross Nbr 3.3 PCT_GROSS_ATAX Percent of Gross After-Tax Nbr 3.3 PLAN_TYPE Plan Type Char 2 Upper PLAN_TYPE_DESCR Plan Type Description Char 30 Mixed POLICY# Policy Number Char 10 Upper PREVIOUSLY_SEEN Previously Seen Char 1 Upper PROVIDER Provider ID Char 6 Upper PROVIDER_DESCR Provider Description Char 30 Mixed VACN_BUY_FLAT_AMT Vacation Buy Flat Amount Nbr 5.2 VACN_HOURS Vacation Buy/Sell Hours Nbr 4.2 VACN_SELL_FLAT_AMT Vacation Sell Flat Amount Nbr 5.2 BEN_PLAN_TYP_VW DESCR Description Char 30 Mixed DESCRSHORT Short Description Char 10 Mixed EFFDT Effective Date Date 10 FIELDVALUE Field Value Char 4 Upper LANGUAGE_CD Language Code Char 3 Upper BEN_PLNTPVW_LNG DESCR Description Char 30 Mixed DESCRSHORT Short Description Char 10 Mixed EFFDT Effective Date Date 10 FIELDVALUE Field Value Char 4 Upper LANGUAGE_CD Language Code Char 3 Upper BEN_PLN_EFF_VW BENEFIT_PLAN Benefit Plan Char 6 Upper CROSS_PLAN_TYPE Cross Plan Type Char 2 Upper DESCRSHORT Short Description Char 10 Mixed BEN_PLN_RA_VW BENEFIT_PLAN_RA Benefit Plan ATAX Rollover Char 6 Upper DESCRSHORT Short Description Char 10 Mixed PLAN_TYPE_RA Plan Type ATAX Rollover Char 2 Upper BEN_PLN_RB_VW BENEFIT_PLAN_RB Benefit Plan BTAX Rollover Char 6 Upper DESCRSHORT Short Description Char 10 Mixed PLAN_TYPE_RB Plan Type BTAX Rollover Char 2 Upper BEN_PRGNLD_LNG BENEFIT_PROGRAM Benefit Program Char 3 Upper DEDCD Deduction Code Char 6 Upper DESCR Description Char 30 Mixed DESCRSHORT Short Description Char 10 Mixed EFFDT Effective Date Date 10 LANGUAGE_CD Language Code Char 3 Upper BEN_PRG_GNL_NLD BENEFIT_PROGRAM Benefit Program Char 3 Upper DEDCD Deduction Code Char 6 Upper DESCR Description Char 30 Mixed DESCRSHORT Short Description Char 10 Mixed EFFDT Effective Date Date 10 BEN_PRG_LINK_VW BENEFIT_PROGRAM Benefit Program Char 3 Upper EFFDT Effective Date Date 10 EMPLID EmplID Char 11 Upper EMPL_RCD# Employment Rcd Nbr Nbr 3 BEN_PRG_PRTC_VW BENEFIT_PROGRAM Benefit Program Char 3 Upper EFFDT Effective Date Date 10 EMPLID EmplID Char 11 Upper PeopleSoft Report ID: XRFRCFL CROSS REFERENCE -- RECORDS AND FIELDS Page No. 83 Run Date 05/07/2001 Run Time 10:19:43 Record Name Field Name Long Field Name Type Length Format --------------- ------------------ ------------------------------ ---- ------ ------ BEN_PRG_PRTC_VW EMPL_RCD# Employment Rcd Nbr Nbr 3 BEN_PROGVW_LNG BENEFIT_PLAN Benefit Plan Char 6 Upper BENEFIT_PROGRAM Benefit Program Char 3 Upper DESCR Description Char 30 Mixed DESCRSHORT Short Description Char 10 Mixed EFFDT Effective Date Date 10 LANGUAGE_CD Language Code Char 3 Upper PLAN_TYPE Plan Type Char 2 Upper BEN_PROG_BENCVC BENEFIT_PLAN Benefit Plan Char 6 Upper BENEFIT_PROGRAM Benefit Program Char 3 Upper COVRG_CD Coverage Code Char 1 Upper DESCR Description Char 30 Mixed EFFDT Effective Date Date 10 OPTION_CD Option Code Char 3 Upper PLAN_TYPE Plan Type Char 2 Upper PROGRAM_TYPE Program Type Char 1 Upper BEN_PROG_BENDED BENEFIT_PLAN Benefit Plan Char 6 Upper BENEFIT_PROGRAM Benefit Program Char 3 Upper DEDCD Deduction Code Char 6 Upper DESCR Description Char 30 Mixed DESCRSHORT Short Description Char 10 Mixed EFFDT Effective Date Date 10 PLAN_TYPE Plan Type Char 2 Upper BEN_PROG_BENPLN BENEFIT_PLAN Benefit Plan Char 6 Upper BENEFIT_PROGRAM Benefit Program Char 3 Upper DEPENDENT_MARRIAGE Dep Ineligible if Married Char 1 Upper DEP_AGE_LIMIT COBRA Dependent Age Limit Nbr 2 DESCR Description Char 30 Mixed DESCRSHORT Short Description Char 10 Mixed EFFDT Effective Date Date 10 EXCL_DISABLED_AGE Exclude Disabled from Age Lmt. Char 1 Upper OPTION_CD Option Code Char 3 Upper PLAN_TYPE Plan Type Char 2 Upper PROGRAM_TYPE Program Type Char 1 Upper STUDENT_AGE_LIMIT COBRA Student Age Limit Nbr 2 BEN_PROG_GNLDED BENEFIT_PROGRAM Benefit Program Char 3 Upper DEDCD Deduction Code Char 6 Upper DESCR Description Char 30 Mixed DESCRSHORT Short Description Char 10 Mixed EFFDT Effective Date Date 10 BEN_PROG_PARTIC BENEFIT_PROGRAM Benefit Program Char 3 Upper COBRA_EVENT_ID COBRA Event Identification Nbr 3 EFFDT Effective Date Date 10 EMPLID EmplID Char 11 Upper EMPL_RCD# Employment Rcd Nbr Nbr 3 BEN_PROG_PAYCVC BENEFIT_PLAN Benefit Plan Char 6 Upper COVRG_CD Coverage Code Char 1 Upper DESCR Description Char 30 Mixed EFFDT Effective Date Date 10 OPTION_CD Option Code Char 3 Upper PLAN_TYPE Plan Type Char 2 Upper PROGRAM_TYPE Program Type Char 1 Upper BEN_SYSTEM_WL ACTIVITYNAME Activity Name Char 30 Mixed BUSPROCNAME Business Process Name Char 30 Mixed EMPLID EmplID Char 11 Upper EMPL_RCD# Employment Rcd Nbr Nbr 3 EVENTNAME Event Name Char 30 Mixed INSTANCEID Instance ID Nbr 10 Cent TRANSACTIONID Transaction ID Nbr 10 Cent WORKLISTNAME Work List Name Char 30 Mixed PeopleSoft Report ID: XRFRCFL CROSS REFERENCE -- RECORDS AND FIELDS Page No. 84 Run Date 05/07/2001 Run Time 10:19:43 Record Name Field Name Long Field Name Type Length Format --------------- ------------------ ------------------------------ ---- ------ ------ BIRTHSTATE_VW BIRTHCOUNTRY Birth Country Char 3 Upper DESCR Description Char 30 Mixed NUMERIC_CD Numeric Code Char 2 Num STATE State Char 6 Upper BIRTH_STVW_LNG BIRTHCOUNTRY Birth Country Char 3 Upper DESCR Description Char 30 Mixed LANGUAGE_CD Language Code Char 3 Upper STATE State Char 6 Upper BIRTSTATEVW_LNG BIRTHCOUNTRY Birth Country Char 3 Upper DESCR Description Char 30 Mixed LANGUAGE_CD Language Code Char 3 Upper STATE State Char 6 Upper BNKGP_ACC_EC_VW ACCOUNT_EC_ID Account # Char 35 Upper ACCOUNT_ID Account ID Nbr 3 ACCOUNT_NAME Account Name Char 50 Mixed ACCOUNT_TYPE Account Type Char 1 Upper BANK_CD Bank ID Char 11 Upper BRANCH_EC_CD Bank Branch ID Char 17 Upper ECQUEUEINSTANCE EC Queue Instance Nbr 9 ECTRANSID EC Transaction ID Char 15 Mixed ECTRANSINOUTSW Inbound / Outbound Switch Char 1 Upper PAYEE_ID1 Payee ID1 Char 11 Upper STATUS Status Char 1 Upper BNKGP_ACC_EC_WD ACCOUNT_EC_ID Account # Char 35 Upper ACCOUNT_ID Account ID Nbr 3 ACCOUNT_NAME Account Name Char 50 Mixed ACCOUNT_TYPE Account Type Char 1 Upper BANK_CD Bank ID Char 11 Upper BRANCH_EC_CD Bank Branch ID Char 17 Upper ECFILEROWID File Row ID Char 3 Upper PAYEE_ID1 Payee ID1 Char 11 Upper STATUS Status Char 1 Upper BNKGP_BRA_EC_VW BANK_CD Bank ID Char 11 Upper BRANCH_EC_CD Bank Branch ID Char 17 Upper DESCR Description Char 30 Mixed DESCRSHORT Short Description Char 10 Mixed EFT_NM Electronic File Transfer Name Char 4 Upper BNKGP_BRA_EC_WD BANK_CD Bank ID Char 11 Upper BRANCH_EC_CD Bank Branch ID Char 17 Upper DESCR Description Char 30 Mixed DESCRSHORT Short Description Char 10 Mixed ECFILEROWID File Row ID Char 3 Upper EFT_NM Electronic File Transfer Name Char 4 Upper BNKGP_EC_VW BANK_CD Bank ID Char 11 Upper BANK_NM Bank Name Char 40 Mixed DESCRSHORT Short Description Char 10 Mixed ECQUEUEINSTANCE EC Queue Instance Nbr 9 ECTRANSID EC Transaction ID Char 15 Mixed ECTRANSINOUTSW Inbound / Outbound Switch Char 1 Upper EFT_NM Electronic File Transfer Name Char 4 Upper BNKGP_EC_WD BANK_CD Bank ID Char 11 Upper BANK_NM Bank Name Char 40 Mixed DESCRSHORT Short Description Char 10 Mixed ECFILEROWID File Row ID Char 3 Upper EFT_NM Electronic File Transfer Name Char 4 Upper BNK_BRA_FRA_LNG BANK_CD_FRA Bank ID Char 5 Upper COUNTER_ID_FRA Counter ID Char 5 Upper DESCR Description Char 30 Mixed DESCRSHORT Short Description Char 10 Mixed LANGUAGE_CD Language Code Char 3 Upper PeopleSoft Report ID: XRFRCFL CROSS REFERENCE -- RECORDS AND FIELDS Page No. 85 Run Date 05/07/2001 Run Time 10:19:43 Record Name Field Name Long Field Name Type Length Format --------------- ------------------ ------------------------------ ---- ------ ------ BNK_BRA_UK_LNG ADDRESS1 Address Line 1 Char 35 Upper ADDRESS2 Address Line 2 Char 35 Upper ADDRESS3 Address Line 3 Char 35 Upper BANK_BS_NAME Bank/Building Society Name Char 20 Mixed CITY City Char 30 Upper DESCR Description Char 30 Mixed DESCRSHORT Short Description Char 10 Mixed LANGUAGE_CD Language Code Char 3 Upper SORT_CODE Sort Code Char 6 Upper BNK_BRNCH_MC_VW CLEARING_NUMBER Branch Clearing # Char 8 Num DESCR Description Char 30 Mixed TRANSIT# Bank Transit # Char 9 Upper BNK_EST_FRA_LNG BANK_CD_FRA Bank ID Char 5 Upper DESCR Description Char 30 Mixed DESCRSHORT Short Description Char 10 Mixed LANGUAGE_CD Language Code Char 3 Upper BNK_TBL_FRA_LNG BANK_CD_FRA Bank ID Char 5 Upper DESCR Description Char 30 Mixed DESCRSHORT Short Description Char 10 Mixed LANGUAGE_CD Language Code Char 3 Upper BNPRG_DEDCLS_VW DEDCD Deduction Code Char 6 Upper DED_CLASS Deduction Classification Char 1 Upper EFFDT Effective Date Date 10 PLAN_TYPE Plan Type Char 2 Upper BNPRG_SLSTX_VW DEDCD Deduction Code Char 6 Upper DED_CLASS Deduction Classification Char 1 Upper DED_SLSTX_CLASS Sales Tax Type Char 1 Upper EFFDT Effective Date Date 10 PLAN_TYPE Plan Type Char 2 Upper BODY_PART_LANG BODY_PART_CD Body Part Code Char 5 Upper DESCR100 Description Char 100 Mixed DESCRSHORT Short Description Char 10 Mixed EFFDT Effective Date Date 10 LANGUAGE_CD Language Code Char 3 Upper SETID SetID Char 5 Upper BODY_PART_TBL BODY_PART_CD Body Part Code Char 5 Upper BODY_PART_CLASS Body Part Classification Char 2 Upper DESCR100 Description Char 100 Mixed DESCRSHORT Short Description Char 10 Mixed EFFDT Effective Date Date 10 EFF_STATUS Status as of Effective Date Char 1 Upper SETID SetID Char 5 Upper BOND_LOG BOND_ACCUM_AMT Bond Accumulated Amount Sign 5.2 BOND_COLLECT_AMT Bond Collection Amount Sign 5.2 BOND_DISBURSE_AMT Bond Disbursement Amount Nbr 5.2 BOND_ID Savings Bond ID Char 3 Upper BOND_LOG_SEQ Bond Activity Seq # Nbr 3 BOND_LOG_STATUS Bond Activity Status Char 1 Upper BOND_OTH_REG_ID Bond Other Registrant Id Char 2 Upper BOND_OTH_REG_TYPE Bond Other Registrant Type Char 1 Upper BOND_OWNER_ID Bond Owner ID Char 2 Upper BOND_PURCH_UNITS Bond Purchase Units Nbr 3 CHECK# Paycheck Number Nbr 7 CHECK_DT Paycheck Issue Date Date 10 COMPANY Company Char 3 Upper EMPLID EmplID Char 11 Upper FORM_ID Form Identification Char 6 Upper OFF_CYCLE Off Cycle ? Char 1 Upper PAYGROUP Pay Group Char 3 Upper PAY_END_DT Pay Period End Date Date 10 PeopleSoft