FISCAL YEAR DATABASE MASTER

FILENAME=FY,SUFFIX=FOC REMOVED OLD TRIP FIELDS. 4/98 CMS
SEGNAME=IDCAMP,SEGTYPE=S1
FIELD=CCAMPUS , ,A2 , DESCRIP=UC LOCATION CODE 1 - MAJOR LOCATION
SEGNAME=CONTROL,SEGTYPE=S1,PARENT=IDCAMP
FIELD=MONPROCESS , ,A2 , DESCRIP=MONTH PROCESSED
FIELD=ERECSIN , ,D7C , DESCRIP=NUMBER OF EMPLOYEE RECORDS - INPUT
FIELD=ARECSIN , ,D7C , DESCRIP=NUMBER OF APPT RECORDS - INPUT
FIELD=DRECSIN , ,D7C , DESCRIP=NUMBER OF DIST RECORDS - INPUT
FIELD=AMTMONIN , ,D13.2C , DESCRIP=TOTAL AMT PAID THIS MONTH - INPUT
FIELD=AMTYTDIN , ,D13.2C , DESCRIP=TOTAL AMT PAID YTD - INPUT
FIELD=ERECSED , ,D7C , DESCRIP=NUMBER OF EMPLOYEE RECORDS - EDITED
FIELD=ARECSED , ,D7C , DESCRIP=NUMBER OF APPT RECORDS - EDITED
FIELD=DRECSED , ,D7C , DESCRIP=NUMBER OF DIST RECORDS - EDITED
FIELD=AMTMONED , ,D13.2C , DESCRIP=TOTAL AMT PAID THIS MONTH - EDITED
FIELD=AMTYTDED , ,D13.2C , DESCRIP=TOTAL AMT PAID YTD - EDITED
FIELD=ESEGSDB , ,D7C , DESCRIP=NUMBER OF EMPLOYEE SEGMENTS
FIELD=ASEGSDB , ,D7C , DESCRIP=NUMBER OF APPT SEGMENTS
FIELD=DSEGSDB , ,D7C , DESCRIP=NUMBER OF DIST SEGMENTS
FIELD=ACTIVEMPDB , ,D7C , DESCRIP=NUMBER OF ACTIVE EMPLOYEES
FIELD=AMTYTDDB , ,D13.2 , DESCRIP=TOTAL AMT PAID YTD - DB
SEGNAME=IDEMPL,SEGTYPE=S1,PARENT=IDCAMP
FIELD=EMPNO , ,A9 , DESCRIP=IDENTIFICATION NUMBER - EMPLOYEE
FIELD=APPTPRI , ,A2 , DESCRIP=APPT NUMBER - PRIMARY APPT
FIELD=TITLEPRI , ,A4 , DESCRIP=TITLE CODE - PRIMARY APPT
FIELD=LTITLEPRI , ,A4 , DESCRIP=LAST MONTH'S PRIMARY TITLE CODE
FIELD=EMPACTIVT , ,A1 , DESCRIP=EMPLOYEE ACTIVE THIS MONTH CODE
FIELD=EMPACTIVL , ,A1 , DESCRIP=EMPLOYEE ACTIVE LAST MONTH CODE
FIELD=MULTAPPT , ,A1 , DESCRIP=MULTIPLE APPOINTMENT INDICATOR
FIELD=FEDOCPRI , ,A2 , DESCRIP=FED. OCCUPATION SUBCAT-PRIMARY
FIELD=APTYPRI , ,A1 , DESCRIP=APPT TYPE CODE PPS-PRIMARY TITLE
FIELD=PROGPRI , ,A1 , DESCRIP=APPT TYPE CODE TCS-PRIMARY TITLE
FIELD=CTOPRI ,CCTOA ,A3 , DESCRIP=CLASS TITLE OUTLINE-PRIMARY TITLE
SEGNAME=PERSONAL,SEGTYPE=U,PARENT=IDEMPL,LOCATION=FCPFY001
FIELD=EMPNAME , ,A35 , DESCRIP=NAME - EMPLOYEE
FIELD=SOCSECNO ,SSN ,A9 , DESCRIP=SOCIAL SECURITY NUMBER
FIELD=PERMADR1 , ,A30 , DESCRIP=ADDRESS-PERMANENT-LINE ONE
FIELD=PERMADR2 , ,A30 , DESCRIP=ADDRESS-PERMANENT-LINE TWO
FIELD=PERMCITY , ,A21 , DESCRIP=ADDRESS-PERMANENT-CITY
FIELD=PERMSTATE , ,A2 , DESCRIP=ADDRESS-PERMANENT-STATE
FIELD=PERMPOST , ,A10 , DESCRIP=ADDRESS-PERMANENT-POSTAL CODE
FIELD=ADRDISCIND , ,A1 , DESCRIP=HOME ADDRESS DISCLOSURE CODE
FIELD=MAILADR1 , ,A30 , DESCRIP=ADDRESS-MAILING-UC-LINE ONE
FIELD=MAILADR2 , ,A30 , DESCRIP=ADDRESS-MAILING-UC-LINE TWO
FIELD=MAILCAMPUS , ,A13 , DESCRIP=ADDRESS-MAILING-UC-CAMPUS
FIELD=MAILCSC , ,A30 , DESCRIP=ADDRESS-MAILING-UC-CITY/ST/CNTRY
FIELD=MAILPOST , ,A10 , DESCRIP=ADDRESS-MAILING-UC-POSTAL CODE
SEGNAME=EMPLOYEE,SEGTYPE=U,PARENT=IDEMPL,LOCATION=FCPFY002
FIELD=CSEX , ,A1 , DESCRIP=SEX CODE
FIELD=BDATE , ,A6YMD , DESCRIP=DATE OF BIRTH
FIELD=CCITSTAT , ,A1 , DESCRIP=CITIZENSHIP STATUS CODE-EMPLOYEE
FIELD=CETHNIC , ,A2 , DESCRIP=ETHNIC ORIGIN CODE-EMPLOYEE
FIELD=CRETSYS , ,A1 , DESCRIP=RETIREMENT SYSTEM CODE
FIELD=FICADED , ,A1 , DESCRIP=FICA DEDUCTION CODE
FIELD=UNINSCVG , ,A1 , DESCRIP=UNEMPLOYMENT INSURANCE CVG CODE
FIELD=CUCSTUDENT , ,A1 , DESCRIP=UC STUDENT STATUS CODE
FIELD=PREMPNO , ,A9 , DESCRIP=PREVIOUS ID NUMBER - EMPLOYEE
FIELD=PRSVCMOS , ,F3 , DESCRIP=PRIOR SERVICE MONTHS
FIELD=CCBU , ,A2 , DESCRIP=COLLECTIVE BARGAINING UNIT CODE
FIELD=CEMPORG1 ,CEMPORG ,A4 , DESCRIP=EMPLOYEE ORG CODE DUES/BEN 1
FIELD=CEMPORG2 ,CEMPORG ,A4 , DESCRIP=EMPLOYEE ORG CODE DUES/BEN 2
FIELD=CEMPORG3 ,CEMPORG ,A4 , DESCRIP=EMPLOYEE ORG CODE DUES/BEN 3
FIELD=CEMPORG4 ,CEMPORG ,A4 , DESCRIP=EMPLOYEE ORG CODE DUES/BEN 4
FIELD=CEMPRELPOS , ,A1 , DESCRIP=EMPLOYEE REL-POSITION TYPE CODE
FIELD=EMPRELCONF , ,A1 , DESCRIP=EMPLOYEE REL-CONFIDENTIAL INFO CODE
FIELD=EUC , ,A2 , DESCRIP=HEERA_EMPLOYEE UNIT CODE
FIELD=CEMPREP , ,A1 , DESCRIP=HEERA_EMPLOYEE REPRESENTATION CODE
FIELD=EMPDT , ,A6YMD , DESCRIP=DATE OF MOST RECENT HIRE
FIELD=SALREVDT , ,A4YM , DESCRIP=NEXT SALARY REVIEW DATE
FIELD=CSALREVTYP , ,A1 , DESCRIP=NEXT SALARY REVIEW TYPE CODE
FIELD=CEMPSTAT , ,A1 , DESCRIP=EMPLOYMENT STATUS CODE
FIELD=MERITPCT , ,F5.2 , DESCRIP=MERIT PERCENT
FIELD=SEPDT , ,A6YMD , DESCRIP=SEPARATION DATE
FIELD=CSEPRSN , ,A2 , DESCRIP=SEPARATION REASON CODE
FIELD=LOABEGDT , ,A6YMD , DESCRIP=LEAVE OF ABSENCE BEGIN DATE
FIELD=LOARETDT , ,A6YMD , DESCRIP=LEAVE OF ABSENCE RETURN DATE
FIELD=CLOATYP , ,A2 , DESCRIP=LEAVE OF ABSENCE TYPE CODE
FIELD=MONERNJUL , ,A1 , DESCRIP=MONTHLY EARNINGS CODE - JUL
FIELD=MONERNAUG , ,A1 , DESCRIP=MONTHLY EARNINGS CODE - AUG
FIELD=MONERNSEP , ,A1 , DESCRIP=MONTHLY EARNINGS CODE - SEP
FIELD=MONERNOCT , ,A1 , DESCRIP=MONTHLY EARNINGS CODE - OCT
FIELD=MONERNNOV , ,A1 , DESCRIP=MONTHLY EARNINGS CODE - NOV
FIELD=MONERNDEC , ,A1 , DESCRIP=MONTHLY EARNINGS CODE - DEC
FIELD=MONERNJAN , ,A1 , DESCRIP=MONTHLY EARNINGS CODE - JAN
FIELD=MONERNFEB , ,A1 , DESCRIP=MONTHLY EARNINGS CODE - FEB
FIELD=MONERNMAR , ,A1 , DESCRIP=MONTHLY EARNINGS CODE - MAR
FIELD=MONERNAPR , ,A1 , DESCRIP=MONTHLY EARNINGS CODE - APR
FIELD=MONERNMAY , ,A1 , DESCRIP=MONTHLY EARNINGS CODE - MAY
FIELD=MONERNJUN , ,A1 , DESCRIP=MONTHLY EARNINGS CODE - JUN
FIELD=ADEFFDT , ,A6YMD , DESCRIP=ACCIDENTAL DEATH & DISMEM EFF DATE
FIELD=CADCVG , ,A1 , DESCRIP=ACCIDENTAL DEATH & DISMEM CVG CODE
FIELD=ADPRINSUM , ,F3 , DESCRIP=ACCIDENTAL DEATH & DISMEM PRIN SUM
FIELD=DENTEFFDT , ,A6YMD , DESCRIP=DENTAL PLAN EFF DATE
FIELD=CDENTPLN , ,A2 , DESCRIP=DENTAL PLAN CODE
FIELD=LFEFFDT , ,A6YMD , DESCRIP=LIFE INSURANCE EFF DATE
FIELD=CLFPLN , ,A1 , DESCRIP=LIFE INSURANCE PLAN CODE
FIELD=LFBASAMT , ,F3 , DESCRIP=LIFE INSURANCE SALARY BASE
FIELD=LFDEPPLN , ,A1 , DESCRIP=DEPENDENT LIFE INSURANCE PLAN CODE
FIELD=HPPEFFDT , ,A6YMD , DESCRIP=PRIMARY HEALTH PLAN EFF DATE
FIELD=CHPPPLN , ,A2 , DESCRIP=PRIMARY HEALTH PLAN CODE
FIELD=CHPPCVG , ,A3 , DESCRIP=PRIMARY HEALTH PLAN CVG CODE
FIELD=CNDIPLN , ,A1 , DESCRIP=NON-INDUSTRIAL DISAB INSURANCE CODE
FIELD=CINSRED , ,A1 , DESCRIP=INSURANCE REDUCTION CODE
FIELD=CPERACT1 , ,A2 , DESCRIP=PERSONNEL ACTION CODE - 1
FIELD=CPERACT2 , ,A2 , DESCRIP=PERSONNEL ACTION CODE - 2
FIELD=CPERACT3 , ,A2 , DESCRIP=PERSONNEL ACTION CODE - 3
FIELD=CPERACT4 , ,A2 , DESCRIP=PERSONNEL ACTION CODE - 4
FIELD=CPERACT5 , ,A2 , DESCRIP=PERSONNEL ACTION CODE - 5
FIELD=PERACTDT , ,A6YMD , DESCRIP=PERSONNEL ACTION DATE
FIELD=CPRSVC , ,A1 , DESCRIP=PRIOR SERVICE CODE
FIELD=CPRINST ,CODE ,A3 , DESCRIP=PRIOR INSTITUTION CODE
FIELD=CEDLVL , ,A1 , DESCRIP=EDUCATION LEVEL CODE
FIELD=EDLVLYR , ,A2 , DESCRIP=EDUCATION LEVEL YEAR
FIELD=CEDINST ,CODE ,A3 , DESCRIP=EDUCATION INSTITUTION CODE
FIELD=CEDFLD , ,A4 , DESCRIP=EDUCATION FIELD CODE
FIELD=CEMPDEST , ,A1 , DESCRIP=SEPARATED EMPLOYEE DEST CODE
FIELD=CFUTINST ,CODE ,A3 , DESCRIP=FUTURE INSTITUTION CODE
FIELD=CSEPRSNA , ,A2 , DESCRIP=SEPARATION RSN CODE - ACAD
FIELD=DEPCAREPLN , ,A1 , DESCRIP=DEPENDENT CARE SALARY REDUCTION PLAN
FIELD=CDENTCVG , ,A3 , DESCRIP=DENTAL PLAN CVG CODE
FIELD=VISEFFDT , ,A6YMD , DESCRIP=VISION PLAN EFF DATE
FIELD=CVISPLN , ,A2 , DESCRIP=VISION PLAN CODE
FIELD=CVISCVG , ,A3 , DESCRIP=VISION PLAN COVERAGE CODE
FIELD=LFBASAMTUC , ,F3 , DESCRIP=LIFE INS SALARY BASE - UC PAID
FIELD=VLPSTERM , ,A1 , DESCRIP=VOLUNTARY LOAN PLN - SHORT TERM
FIELD=VLPLTERM , ,A1 , DESCRIP=VOLUNTARY LOAN PLN - LONG TERM
FIELD=CVETSTAT , ,A1 , DESCRIP=VETERAN STATUS CODE
FIELD=CVETDISAB , ,A1 , DESCRIP=VETERAN DISABILITY STATUS CODE
FIELD=CHNDCPSTAT , ,A1 , DESCRIP=HANDICAPPED STATUS CODE
FIELD=LGLEFFDT , ,A6YMD , DESCRIP=LEGAL PLAN EFF DATE
FIELD=CLGLPLN , ,A2 , DESCRIP=LEGAL PLAN CODE
FIELD=CLGLCVG , ,A3 , DESCRIP=LEGAL PLAN COVERAGE CODE
FIELD=EXECLFPLN , ,A1 , DESCRIP=EXEC LIFE ELIGIBILITY FLAG
FIELD=EXECLFAMT , ,F3 , DESCRIP=EXEC LIFE SALARY BASE AMOUNT ,&
FIELD=BELIASI , ,A1 , DESCRIP=BENEFITS ELIG. LVL IND-ASSIGNED
FIELD=BELIDER , ,A1 , DESCRIP=BENEFITS ELIG. LVL IND-DERIVED
FIELD=BELICDT , ,A4 , DESCRIP=BENEFITS ELIG. LVL CONFLICT DATE
FIELD=MEDOPTOUT , ,A1 , DESCRIP=OPT OUT INDICATOR- MEDICAL
FIELD=DENOPTOUT , ,A1 , DESCRIP=OPT OUT INDICATOR- DENTAL
FIELD=VISOPTOUT , ,A1 , DESCRIP=OPT OUT INDICATOR- OPTICAL
FIELD=AVGHRSWK , ,F6.2 , DESCRIP=AVERAGE PAID HOURS PER WEEK
FIELD=LFDEPEFFDT , ,A6YMD , DESCRIP=DEP LIFE EFF EARNINGS DATE
FIELD=YTDTOTGR , ,F9.2 , DESCRIP=Y-T-D TOTAL GROSS
FIELD=YTDFWTGR , ,F9.2 , DESCRIP=Y-T-D TAXABLE GROSS
FIELD=YTDDEPDE , ,F9.2 , DESCRIP=Y-T-D DEPCARE DEDUCTION
FIELD=DCPFUND , ,A1 , DESCRIP=DCP FUND PLAN CODE
FIELD=PRYTDTOT , ,F9.2 , DESCRIP=PRIOR CAL Y-T-D TOTAL GROSS
FIELD=PRYTDFWT , ,F9.2 , DESCRIP=PRIOR CAL Y-T-D FWT GROSS
FIELD=LPAYDT , ,A6YMD , DESCRIP=LAST DAY ON PAY STATUS
FIELD=EDISPLN , ,A1 , DESCRIP=EMPLOYEE PD.-DISABIL. PLN CODE
FIELD=EDISWTPER , ,A3 , DESCRIP=EMPLOYEE PD.-DISABIL. WAIT PER
FIELD=EDISBSAMT , ,I5 , DESCRIP=EMPLOYEE PD.-DISABIL. BASE AMT
FIELD=EDISEFFDT , ,A6YMD , DESCRIP=EMPLOYEE PD.-DISABIL. EFF DATE
FIELD=PRITPPS , ,A4 , DESCRIP=TITLE CODE PRIMARY - PPS
FIELD=W2_FLAG , ,A1 , DESCRIP=PRYTDTOT/PRYTDFWT FROM W2
FIELD=NDIEFFDT , ,A6YMD , DESCRIP=NON INDUSTRIAL DISABIL. EFF DATE
FIELD=FYTDFWTG , ,F9.2 , DESCRIP=FISCAL YTD TAXABLE GROSS
FIELD=FLLEMPL1 , ,A2 , DESCRIP=
FIELD=FLLEMPL2 , ,A2 , DESCRIP=
FIELD=FLLEMPL3 , ,A2 , DESCRIP=
FIELD=FILLEMPL , ,A26 , DESCRIP=
SEGNAME=HOURS,SEGTYPE=U,PARENT=IDEMPL,LOCATION=FCPFY003
FIELD=SICKHRSJUL , ,F5 , DESCRIP=SICK LEAVE HOURS USED - JULY
FIELD=SICKHRSAUG , ,F5 , DESCRIP=SICK LEAVE HOURS USED - AUGUST
FIELD=SICKHRSSEP , ,F5 , DESCRIP=SICK LEAVE HOURS USED - SEPTEMBER
FIELD=SICKHRSOCT , ,F5 , DESCRIP=SICK LEAVE HOURS USED - OCTOBER
FIELD=SICKHRSNOV , ,F5 , DESCRIP=SICK LEAVE HOURS USED - NOVEMBER
FIELD=SICKHRSDEC , ,F5 , DESCRIP=SICK LEAVE HOURS USED - DECEMBER
FIELD=SICKHRSJAN , ,F5 , DESCRIP=SICK LEAVE HOURS USED - JANUARY
FIELD=SICKHRSFEB , ,F5 , DESCRIP=SICK LEAVE HOURS USED - FEBRUARY
FIELD=SICKHRSMAR , ,F5 , DESCRIP=SICK LEAVE HOURS USED - MARCH
FIELD=SICKHRSAPR , ,F5 , DESCRIP=SICK LEAVE HOURS USED - APRIL
FIELD=SICKHRSMAY , ,F5 , DESCRIP=SICK LEAVE HOURS USED - MAY
FIELD=SICKHRSJUN , ,F5 , DESCRIP=SICK LEAVE HOURS USED - JUNE
FIELD=SICKHRSBAL , ,F5 , DESCRIP=SICK LEAVE HOURS BALANCE
FIELD=VACHRSJUL , ,F5 , DESCRIP=VACATION HOURS USED - JULY
FIELD=VACHRSAUG , ,F5 , DESCRIP=VACATION HOURS USED - AUGUST
FIELD=VACHRSSEP , ,F5 , DESCRIP=VACATION HOURS USED - SEPTEMBER
FIELD=VACHRSOCT , ,F5 , DESCRIP=VACATION HOURS USED - OCTOBER
FIELD=VACHRSNOV , ,F5 , DESCRIP=VACATION HOURS USED - NOVEMBER
FIELD=VACHRSDEC , ,F5 , DESCRIP=VACATION HOURS USED - DECEMBER
FIELD=VACHRSJAN , ,F5 , DESCRIP=VACATION HOURS USED - JANUARY
FIELD=VACHRSFEB , ,F5 , DESCRIP=VACATION HOURS USED - FEBRUARY
FIELD=VACHRSMAR , ,F5 , DESCRIP=VACATION HOURS USED - MARCH
FIELD=VACHRSAPR , ,F5 , DESCRIP=VACATION HOURS USED - APRIL
FIELD=VACHRSMAY , ,F5 , DESCRIP=VACATION HOURS USED - MAY
FIELD=VACHRSJUN , ,F5 , DESCRIP=VACATION HOURS USED - JUNE
FIELD=VACHRSBAL , ,F5 , DESCRIP=VACATION HOURS BALANCE
FIELD=VACHRSLOST , ,F5 , DESCRIP=VACATION NOT ACCUMULATED (LOST)
FIELD=COMPHRSJUL , ,F5 , DESCRIP=COMP TIME HRS USED - JULY
FIELD=COMPHRSAUG , ,F5 , DESCRIP=COMP TIME HRS USED - AUGUST
FIELD=COMPHRSSEP , ,F5 , DESCRIP=COMP TIME HRS USED - SEPTEMBER
FIELD=COMPHRSOCT , ,F5 , DESCRIP=COMP TIME HRS USED - OCTOBER
FIELD=COMPHRSNOV , ,F5 , DESCRIP=COMP TIME HRS USED - NOVEMBER
FIELD=COMPHRSDEC , ,F5 , DESCRIP=COMP TIME HRS USED - DECEMBER
FIELD=COMPHRSJAN , ,F5 , DESCRIP=COMP TIME HRS USED - JANUARY
FIELD=COMPHRSFEB , ,F5 , DESCRIP=COMP TIME HRS USED - FEBRUARY
FIELD=COMPHRSMAR , ,F5 , DESCRIP=COMP TIME HRS USED - MARCH
FIELD=COMPHRSAPR , ,F5 , DESCRIP=COMP TIME HRS USED - APRIL
FIELD=COMPHRSMAY , ,F5 , DESCRIP=COMP TIME HRS USED - MAY
FIELD=COMPHRSJUN , ,F5 , DESCRIP=COMP TIME HRS USED - JUNE
FIELD=COMPHRSBAL , ,F5 , DESCRIP=COMP TIME HOURS BALANCE
FIELD=OTHRSPDJUL , ,D10.2 , DESCRIP=OVERTIME HOURS PAID - JULY
FIELD=OTHRSPDAUG , ,D10.2 , DESCRIP=OVERTIME HOURS PAID - AUGUST
FIELD=OTHRSPDSEP , ,D10.2 , DESCRIP=OVERTIME HOURS PAID - SEPTEMBER
FIELD=OTHRSPDOCT , ,D10.2 , DESCRIP=OVERTIME HOURS PAID - OCTOBER
FIELD=OTHRSPDNOV , ,D10.2 , DESCRIP=OVERTIME HOURS PAID - NOVEMBER
FIELD=OTHRSPDDEC , ,D10.2 , DESCRIP=OVERTIME HOURS PAID - DECEMBER
FIELD=OTHRSPDJAN , ,D10.2 , DESCRIP=OVERTIME HOURS PAID - JANUARY
FIELD=OTHRSPDFEB , ,D10.2 , DESCRIP=OVERTIME HOURS PAID - FEBRUARY
FIELD=OTHRSPDMAR , ,D10.2 , DESCRIP=OVERTIME HOURS PAID - MARCH
FIELD=OTHRSPDAPR , ,D10.2 , DESCRIP=OVERTIME HOURS PAID - APRIL
FIELD=OTHRSPDMAY , ,D10.2 , DESCRIP=OVERTIME HOURS PAID - MAY
FIELD=OTHRSPDJUN , ,D10.2 , DESCRIP=OVERTIME HOURS PAID - JUNE
FIELD=OTHRSWKJUL , ,D10.2 , DESCRIP=OVERTIME HOURS WORKED - JULY
FIELD=OTHRSWKAUG , ,D10.2 , DESCRIP=OVERTIME HOURS WORKED - AUGUST
FIELD=OTHRSWKSEP , ,D10.2 , DESCRIP=OVERTIME HOURS WORKED - SEPTEMBER
FIELD=OTHRSWKOCT , ,D10.2 , DESCRIP=OVERTIME HOURS WORKED - OCTOBER
FIELD=OTHRSWKNOV , ,D10.2 , DESCRIP=OVERTIME HOURS WORKED - NOVEMBER
FIELD=OTHRSWKDEC , ,D10.2 , DESCRIP=OVERTIME HOURS WORKED - DECEMBER
FIELD=OTHRSWKJAN , ,D10.2 , DESCRIP=OVERTIME HOURS WORKED - JANUARY
FIELD=OTHRSWKFEB , ,D10.2 , DESCRIP=OVERTIME HOURS WORKED - FEBRUARY
FIELD=OTHRSWKMAR , ,D10.2 , DESCRIP=OVERTIME HOURS WORKED - MARCH
FIELD=OTHRSWKAPR , ,D10.2 , DESCRIP=OVERTIME HOURS WORKED - APRIL
FIELD=OTHRSWKMAY , ,D10.2 , DESCRIP=OVERTIME HOURS WORKED - MAY
FIELD=OTHRSWKJUN , ,D10.2 , DESCRIP=OVERTIME HOURS WORKED - JUNE
FIELD=OTHRSWKYTD , ,D10.2 , DESCRIP=OVERTIME HOURS WORKED YTD
SEGNAME=APPTMT,SEGTYPE=S2,PARENT=IDEMPL,LOCATION=FCPFY004
FIELD=APPTNO , ,A2 , DESCRIP=APPOINTMENT NUMBER
FIELD=CTITLE , ,A4 , DESCRIP=TITLE CODE
FIELD=APTACTIVT , ,A1 , DESCRIP=APPOINTMENT ACTIVE THIS MONTH CODE
FIELD=APTACTIVL , ,A1 , DESCRIP=APPOINTMENT ACTIVE LAST MONTH CODE
FIELD=APTBASIS , ,A2 , DESCRIP=APPOINTMENT BASIS CODE
FIELD=APTBEGDT , ,A6YMD , DESCRIP=APPOINTMENT BEGIN DATE
FIELD=APTENDDT , ,A6YMD , DESCRIP=APPOINTMENT END DATE
FIELD=APTPAYRT , ,D11.4 , DESCRIP=APPOINTMENT PAY RATE
FIELD=CAPTRT , ,A1 , DESCRIP=APPOINTMENT RATE CODE
FIELD=CAPTTYP , ,A1 , DESCRIP=APPOINTMENT TYPE CODE - PPS
FIELD=COFFABSCA , ,A1 , DESCRIP=OFF/ABOVE SCALE CODE
FIELD=CPDOVER , ,A2 , DESCRIP=PAID OVER CODE
FIELD=CPAYSKED , ,A2 , DESCRIP=PAY SCHEDUDE CODE
FIELD=TUC , ,A2 , DESCRIP=TITLE UNIT CODE
FIELD=SALMGTGD , ,A2 , DESCRIP=SALARY STEP/MGMT SALARY GRADE
FIELD=APTPCT , ,F6.4 , DESCRIP=TIME - APPOINTMENT (ANTICIPATED)
FIELD=TITLE , ,A30 , DESCRIP=TITLE NAME
FIELD=CCTO ,CCTOB ,A3 , DESCRIP=CLASS TITLE OUTLINE CODE
FIELD=CFOCSUB , ,A2 , DESCRIP=FEDERAL OCCUPATION SUBCATEGORY CODE
FIELD=CACRANK , ,A1 , DESCRIP=ACADEMIC RANK CODE
FIELD=SABACCR , ,A1 , DESCRIP=SABBATICAL ACCRUAL CODE
FIELD=CLVACCSICK , ,A1 , DESCRIP=LEAVE ACCRUAL CODE - SICK LEAVE
FIELD=CLVACCVAC , ,A1 , DESCRIP=LEAVE ACCRUAL CODE - VACATION
FIELD=CWOS , ,A1 , DESCRIP=WITHOUT SALARY CODE
FIELD=CTTLSH , ,A1 , DESCRIP=HEERA_TITLE SPECIAL HANDLING CODE
FIELD=CAPTREP , ,A1 , DESCRIP=HEERA_APPOINTMENT REPRESENTATION CODE
FIELD=FROZNFLG , ,A1 , DESCRIP=FROZEN FLAG
FIELD=SOC , ,A3 , DESCRIP=STANDARD OCCUPATIONAL CLASS.
FIELD=FILLAPPT , ,A03 , DESCRIP=
SEGNAME=TTLATTR,SEGTYPE=U,PARENT=APPTMT,LOCATION=FCPFY005
FIELD=CAPTTYPT , ,A1 , DESCRIP=APPOINTMENT TYPE CODE - TCS
FIELD=GRADEIND , ,A1 , DESCRIP=GRADE INDICATOR - TCS
FIELD=ACSVCLIM , ,I2 , DESCRIP=ACADEMIC SERVICE LIMIT
FIELD=SALMIN , ,D12.4 , DESCRIP=SALARY RANGE - MINIMUM
FIELD=SALMID , ,D12.4 , DESCRIP=SALARY RANGE - MIDPOINT
FIELD=SALMAX , ,D12.4 , DESCRIP=SALARY RANGE - MAXIMUM
FIELD=NUMSTEPS , ,I2 , DESCRIP=NUMBER OF PAY INTERVALS/WHOLE STEPS
FIELD=CUSETITLE , ,A1 , DESCRIP=USE OF TITLE CODE
FIELD=RESTRFLG , ,A1 , DESCRIP=RESTRICTED TITLE CODE FLAG
FIELD=OTEXEMP , ,A1 , DESCRIP=OVERTIME EXEMPTION STATUS CODE
FIELD=CRETIRE1 , ,A1 , DESCRIP=RETIREMENT CODE 1 - UCRS
FIELD=CRETIRE2 , ,A1 , DESCRIP=RETIREMENT CODE 2 - SPECIAL RATES
FIELD=CACAPTBAS , ,A1 , DESCRIP=ACADEMIC APPT BASIS
FIELD=CACAPTTYP , ,A1 , DESCRIP=ACADEMIC APPT TYPE CODE
FIELD=CACPAYPER , ,A1 , DESCRIP=ACADEMIC PAY PERIOD
FIELD=ACSICKELIG , ,A1 , DESCRIP=SICK LEAVE ELIG CODE (ACADEMIC)
FIELD=STFEXCPFLG , ,A1 , DESCRIP=STAFF STEP/SCALE EXCEPTION FLAG
FIELD=BYAGREE , ,A1 , DESCRIP=BY-AGREEMENT CODE
FIELD=TUCT , ,A2 , DESCRIP=TUC UNIT ASSIGNMENT
FIELD=SUPVFLAG , ,A1 , DESCRIP=SUPERVISORY FLAG
FIELD=SDELIG , ,A1 , DESCRIP=SHIFT DIFFERENTIAL ELIG CODE
FIELD=ONCALLELIG , ,A1 , DESCRIP=ON CALL RATE ELIG CODE
FIELD=CLINKAGE , ,A3 , DESCRIP=LINKAGE CODE
FIELD=CCOMPGRP , ,A3 , DESCRIP=ACADEMIC COMPENSATION GROUP
FIELD=MERIT , ,A1 , DESCRIP=MERIT-BASED APPT. FLAG
FIELD=FILLATTR , ,A03 , DESCRIP=
SEGNAME=DISTRIB,SEGTYPE=S7,PARENT=APPTMT,LOCATION=FCPFY006
FIELD=CLOC2 , ,A1 , DESCRIP=UC LOCATION CODE 2 - UWIDE INDIC
FIELD=CLOC3 , ,A1 , DESCRIP=UC LOCATION CODE 3 - ORG CATEGORY
FIELD=ACCTNO , ,A6 , DESCRIP=ACCOUNT NUMBER
FIELD=FUNDNO , ,A5 , DESCRIP=FUND NUMBER
FIELD=CSUBACCT , ,A2 , DESCRIP=SUBACCOUNT CODE
FIELD=CDOS , ,A2 , DESCRIP=DESCRIPTION OF SERVICE CODE
FIELD=PDOS , ,A3 , DESCRIP=PAYROLL DESC. OF SERVICE CODE
FIELD=CDISTRT , ,A1 , DESCRIP=DISTRIBUTION RATE CODE
FIELD=DUC , ,A1 , DESCRIP=HEERA_DISTRIBUTION UNIT CODE
FIELD=DSTPAYRT , ,D11.4 , DESCRIP=DISTRIBUTION PAY RATE
FIELD=WORKSTDY , ,D12.2 , DESCRIP=WORK STUDY - CUR YR GROSS EARN
FIELD=MONGRSJUL , ,D12.2 , DESCRIP=GROSS EARNINGS - JULY
FIELD=MONGRSAUG , ,D12.2 , DESCRIP=GROSS EARNINGS - AUGUST
FIELD=MONGRSSEP , ,D12.2 , DESCRIP=GROSS EARNINGS - SEPTEMBER
FIELD=MONGRSOCT , ,D12.2 , DESCRIP=GROSS EARNINGS - OCTOBER
FIELD=MONGRSNOV , ,D12.2 , DESCRIP=GROSS EARNINGS - NOVEMBER
FIELD=MONGRSDEC , ,D12.2 , DESCRIP=GROSS EARNINGS - DECEMBER
FIELD=MONGRSJAN , ,D12.2 , DESCRIP=GROSS EARNINGS - JANUARY
FIELD=MONGRSFEB , ,D12.2 , DESCRIP=GROSS EARNINGS - FEBRUARY
FIELD=MONGRSMAR , ,D12.2 , DESCRIP=GROSS EARNINGS - MARCH
FIELD=MONGRSAPR , ,D12.2 , DESCRIP=GROSS EARNINGS - APRIL
FIELD=MONGRSMAY , ,D12.2 , DESCRIP=GROSS EARNINGS - MAY
FIELD=MONGRSJUN , ,D12.2 , DESCRIP=GROSS EARNINGS - JUNE
FIELD=MONHRSJUL , ,F6.2 , DESCRIP=HOURS PAID - JULY
FIELD=MONHRSAUG , ,F6.2 , DESCRIP=HOURS PAID - AUGUST
FIELD=MONHRSSEP , ,F6.2 , DESCRIP=HOURS PAID - SEPTEMBER
FIELD=MONHRSOCT , ,F6.2 , DESCRIP=HOURS PAID - OCTOBER
FIELD=MONHRSNOV , ,F6.2 , DESCRIP=HOURS PAID - NOVEMBER
FIELD=MONHRSDEC , ,F6.2 , DESCRIP=HOURS PAID - DECEMBER
FIELD=MONHRSJAN , ,F6.2 , DESCRIP=HOURS PAID - JANUARY
FIELD=MONHRSFEB , ,F6.2 , DESCRIP=HOURS PAID - FEBRUARY
FIELD=MONHRSMAR , ,F6.2 , DESCRIP=HOURS PAID - MARCH
FIELD=MONHRSAPR , ,F6.2 , DESCRIP=HOURS PAID - APRIL
SEGNAME=DIST2,SEGTYPE=U,PARENT=DISTRIB,LOCATION=FCPFY007
FIELD=MONHRSMAY , ,F6.2 , DESCRIP=HOURS PAID - MAY
FIELD=MONHRSJUN , ,F6.2 , DESCRIP=HOURS PAID - JUNE
FIELD=MONFTEJUL , ,F6.4 , DESCRIP=TIME DISTRIBUTION - JULY
FIELD=MONFTEAUG , ,F6.4 , DESCRIP=TIME DISTRIBUTION - AUGUST
FIELD=MONFTESEP , ,F6.4 , DESCRIP=TIME DISTRIBUTION - SEPTEMBER
FIELD=MONFTEOCT , ,F6.4 , DESCRIP=TIME DISTRIBUTION - OCTOBER
FIELD=MONFTENOV , ,F6.4 , DESCRIP=TIME DISTRIBUTION - NOVEMBER
FIELD=MONFTEDEC , ,F6.4 , DESCRIP=TIME DISTRIBUTION - DECEMBER
FIELD=MONFTEJAN , ,F6.4 , DESCRIP=TIME DISTRIBUTION - JANUARY
FIELD=MONFTEFEB , ,F6.4 , DESCRIP=TIME DISTRIBUTION - FEBRUARY
FIELD=MONFTEMAR , ,F6.4 , DESCRIP=TIME DISTRIBUTION - MARCH
FIELD=MONFTEAPR , ,F6.4 , DESCRIP=TIME DISTRIBUTION - APRIL
FIELD=MONFTEMAY , ,F6.4 , DESCRIP=TIME DISTRIBUTION - MAY
FIELD=MONFTEJUN , ,F6.4 , DESCRIP=TIME DISTRIBUTION - JUNE
FIELD=PRFYGRS , ,D15.2 , DESCRIP=GROSS EARNINGS - PRIOR FISCAL YEARS
FIELD=PRFYHRS , ,D10.2 , DESCRIP=HOURS PAID - PRIOR FISCAL YEARS
FIELD=PRFYFTE , ,D10.4 , DESCRIP=TIME DIST - PRIOR FISCAL YEARS
FIELD=CORGUNIT , ,A7 , DESCRIP=ORGANIZATION UNIT CODE
FIELD=ORGUNIT , ,A30 , DESCRIP=ORGANIZATION UNIT NAME
FIELD=CORGGRP , ,A7 , DESCRIP=ORGANIZATION UNIT GROUP CODE
FIELD=CUASDISC , ,A3 , DESCRIP=UAS DISCIPLINE CODE
FIELD=CNSF , ,A3 , DESCRIP=NSF CODE
FIELD=CORG2 , ,A7 , DESCRIP=ORG UNIT 2
FIELD=CORG2NM , ,A30 , DESCRIP=ORG UNIT 2 NAME
FIELD=ACCTGROUP ,AGC ,A06 , DESCRIP=ACCOUNT GROUP CODE FROM AFP
FIELD=FUNDGROUP ,FGC ,A06 , DESCRIP=FUND GROUP CODE FROM AFP
FIELD=FUNCTION , ,A02 , DESCRIP=FUNCTION CODE
SEGNAME=EMPOATT1,PARENT=EMPLOYEE,SEGTYPE=KU, CRFILE=EMPLORG,CRSEG=EMPOATTR,CRKEY=CEMPORG1
FIELD=C1XEMPORG ,CEMPORG ,A4 ,FIELDTYPE=I DESCRIP=
FIELD=EMPORG1 , ,A34 , DESCRIP=EMPLOYEE ORG NAME 1
FIELD=CBARG1 , ,A1 , DESCRIP=BARGAINING AGENT CODE 1
FIELD=CDEDTYP1 , ,A1 , DESCRIP=DEDUCTION TYPE CODE 1
SEGNAME=EMPOATT2,PARENT=EMPLOYEE,SEGTYPE=KU, CRFILE=EMPLORG,CRSEG=EMPOATTR,CRKEY=CEMPORG2
FIELD=C2XEMPORG ,CEMPORG ,A4 ,FIELDTYPE=I DESCRIP=
FIELD=EMPORG2 , ,A34 , DESCRIP=EMPLOYEE ORG NAME 2
FIELD=CBARG2 , ,A1 , DESCRIP=BARGAINING AGENT CODE 2
FIELD=CDEDTYP2 , ,A1 , DESCRIP=DEDUCTION TYPE CODE 2
SEGNAME=EMPOATT3,PARENT=EMPLOYEE,SEGTYPE=KU, CRFILE=EMPLORG,CRSEG=EMPOATTR,CRKEY=CEMPORG3
FIELD=C3XEMPORG ,CEMPORG ,A4 ,FIELDTYPE=I DESCRIP=
FIELD=EMPORG3 , ,A34 , DESCRIP=EMPLOYEE ORG NAME 3
FIELD=CBARG3 , ,A1 , DESCRIP=BARGAINING AGENT CODE 3
FIELD=CDEDTYP3 , ,A1 , DESCRIP=DEDUCTION TYPE CODE 3
SEGNAME=EMPOATT4,PARENT=EMPLOYEE,SEGTYPE=KU CRFILE=EMPLORG,CRSEG=EMPOATTR,CRKEY=CEMPORG4
FIELD=C4XEMPORG ,CEMPORG ,A4 ,FIELDTYPE=I DESCRIP=
FIELD=EMPORG4 , ,A34 , DESCRIP=EMPLOYEE ORG NAME 4
FIELD=CBARG4 , ,A1 , DESCRIP=BARGAINING AGENT CODE 4
FIELD=CDEDTYP4 , ,A1 , DESCRIP=DEDUCTION TYPE CODE 4
SEGNAME=PRINSTS,PARENT=EMPLOYEE,SEGTYPE=KU, CRFILE=SCHOOL,CRSEG=SCH,CRKEY=CPRINST
FIELD=CXPRINST ,CODE ,A3 ,FIELDTYPE=I DESCRIP=
FIELD=PRINSTNAME , ,A40 , DESCRIP=PRIOR INSTITUTION NAME
FIELD=PRINSTCITY , ,A18 , DESCRIP=PRIOR INSTITUTION CITY
FIELD=PRINSTFCP , ,A1 , DESCRIP=PRIOR INSTITUTION FCP CODE
FIELD=PRINSTTYPE , ,A1 , DESCRIP=PRIOR INSTITUTION TYPE CODE
FIELD=PRINSTCA , ,A6 , DESCRIP=PRIOR INSTITUTION CA STATE CODE
FIELD=CPRINSTLOC ,LOC_CD ,A3 , DESCRIP=PRIOR INSTITUTION LOCATION CODE
FIELD=FILLPRS , ,A6 , DESCRIP=
SEGNAME=PRINSTL,PARENT=PRINSTS,SEGTYPE=KU, CRFILE=LOCATION,CRSEG=LOC,CRKEY=CPRINSTLOC
FIELD=CXPRINSTLOC ,LOC_CD ,A3 ,FIELDTYPE=I DESCRIP=
FIELD=PRINSTLNAME , ,A28 , DESCRIP=PRIOR INSTITUTION LOCATION NAME
FIELD=FILLPRL , ,A5 , DESCRIP=
SEGNAME=FUTINSTS,PARENT=EMPLOYEE,SEGTYPE=KU, CRFILE=SCHOOL,CRSEG=SCH,CRKEY=CFUTINST
FIELD=CXFUTINST ,CODE ,A3 ,FIELDTYPE=I DESCRIP=
FIELD=FUTINSTNAME , ,A40 , DESCRIP=FUTURE INSTITUTION NAME
FIELD=FUTINSTCITY , ,A18 , DESCRIP=FUTURE INSTITUTION CITY
FIELD=FUTINSTFCP , ,A1 , DESCRIP=FUTURE INSTITUTION FCP CODE
FIELD=FUTINSTTYPE , ,A1 , DESCRIP=FUTURE INSTITUTION TYPE CODE
FIELD=FUTINSTCA , ,A6 , DESCRIP=FUTURE INSTITUTION CA STATE CODE
FIELD=CFUTINSTLOC ,LOC_CD ,A3 , DESCRIP=FUTURE INSTITUTION LOCATION CODE
FIELD=FILLFUTS , ,A6 , DESCRIP=
SEGNAME=FUTINSTL,PARENT=FUTINSTS,SEGTYPE=KU, CRFILE=LOCATION,CRSEG=LOC,CRKEY=CFUTINSTLOC
FIELD=CXFUTINSTLOC ,LOC_CD ,A3 ,FIELDTYPE=I DESCRIP=
FIELD=FUTINSTLNAME , ,A28 , DESCRIP=FUTURE INSTITUTION LOCATION NAME
SEGNAME=EDINSTS,PARENT=EMPLOYEE,SEGTYPE=KU, CRFILE=SCHOOL,CRSEG=SCH,CRKEY=CEDINST
FIELD=CXEDINST ,CODE ,A3 ,FIELDTYPE=I DESCRIP=
FIELD=EDINSTNAME , ,A40 , DESCRIP=EDUC INSTITUTION NAME
FIELD=EDINSTCITY , ,A18 , DESCRIP=EDUC INSTITUTION CITY
FIELD=EDINSTFCP , ,A1 , DESCRIP=EDUC INSTITUTION FCP CODE
FIELD=EDINSTTYPE , ,A1 , DESCRIP=EDUC INSTITUTION TYPE CODE
FIELD=EDINSTCA , ,A6 , DESCRIP=EDUC INSTITUTION CA STATE CODE
FIELD=CEDINSTLOC ,LOC_CD ,A3 , DESCRIP=EDUC INSTITUTION LOCATION CODE
FIELD=FILLEDS , ,A6 , DESCRIP=
SEGNAME=EDINSTL,PARENT=EDINSTS,SEGTYPE=KU, CRFILE=LOCATION,CRSEG=LOC,CRKEY=CEDINSTLOC
FIELD=CXEDINSTLOC ,LOC_CD ,A3 ,FIELDTYPE=I DESCRIP=
FIELD=EDINSTLNAME , ,A28 , DESCRIP=EDUC INSTITUTION LOCATION NAME
SEGNAME=EDFATTR,PARENT=EMPLOYEE,SEGTYPE=KU, CRFILE=EDUCFLD,CRKEY=CEDFLD SEGNAME=CTOATTR1,PARENT=IDEMPL,SEGTYPE=KU, CRFILE=CTO,CRSEG=CTOATTR,CRKEY=CTOPRI
FIELD=CCTO ,CCTOA ,A3 ,FIELDTYPE=I DESCRIP=
FIELD=CTOA , ,A30 , DESCRIP=
SEGNAME=CTOATTR2,PARENT=APPTMT,SEGTYPE=KU, CRFILE=CTO,CRSEG=CTOATTR,CRKEY=CCTO
FIELD=CCTO ,CCTOB ,A3 ,FIELDTYPE=I DESCRIP=
FIELD=CTO ,CTOB ,A30 , DESCRIP=
SEGNAME=UASATTR,PARENT=DISTRIB,SEGTYPE=KU, CRFILE=UAS,CRKEY=CUASDISC
SEGNAME=ORGGATTR,PARENT=DISTRIB,SEGTYPE=KU, CRFILE=ORGUGRP,CRKEY=CORGGRP