OPP Database Master

OPP DATABASE MASTER

FILENAME=SNAPSHOT,SUFFIX=FOC,$OPP SR 15121 7/00 CMS. ADD 18 NEW ELEMENTS.
SEGNAME=IDEMPL,SEGTYPE=S2,$ MER,SUBLOC,REL99 ETAL,HOMEDEPT ETC

FIELD=CCAMPUS ,CCDE ,A2 , DESCRIP=UC LOCATION CODE 1 - MAJOR LOCATION

FIELD=EMPNO , ,A9 , DESCRIP=IDENTIFICATION NUMBER - EMPLOYEE

FIELD=CYCLE , ,A5 , DESCRIP=MMMYY OF THIS FILE

FIELD=COP , ,A1 , DESCRIP=FLAG INDICATING UCOP EMPLOYEE

FIELD=MER ,MERFLG ,A1 , DESCRIP=FLAG INDICATING MERCED EMPLOYEE

FIELD=CMPEMP ,CEMPNO ,A11 ,INDEX=I DESCRIP=CONCATENATION OF CCAMPUS & EMPNO

FIELD=APPTPRI , ,A2 , DESCRIP=APPT NUMBER - PRIMARY APPT

FIELD=TITLEPRI , ,A4 , DESCRIP=TITLE CODE - PRIMARY APPT

FIELD=EMPACTIVT , ,A1 , DESCRIP=EMPLOYEE ACTIVE THIS 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

FIELD=HCLFLAG , ,A1 , DESCRIP=HIGHLY COMP FLAG LOOKBACK YEAR

FIELD=ACTIVANR , ,A1 , DESCRIP=EMPLOYEE ACTIVE THIS MONTH-ANR

FIELD=ACTIVOP , ,A1 , DESCRIP=EMPLOYEE ACTIVE THIS MONTH CODE-OP

FIELD=EMPNAME , ,A35 , DESCRIP=NAME - EMPLOYEE

FIELD=SOCSECNO ,SSN ,A9 , DESCRIP=SOCIAL SECURITY NUMBER

FIELD=PERMPOST , ,A10 , DESCRIP=ADDRESS-PERMANENT-POSTAL CODE

FIELD=ADRDISCIND , ,A1 , DESCRIP=HOME ADDRESS DISCLOSURE CODE

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=PRIOR ID NUMBER - EMPLOYEE

FIELD=PRSVCMOS , ,F3 , DESCRIP=PRIOR SERVICE MONTHS

FIELD=CCBU , ,A2 ,INDEX=I 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=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=CDENTCVG , ,A3 , DESCRIP=DENTAL PLAN CVG 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=DISEFFDT , ,A6YMD , DESCRIP=SHORT TERM DISABILITY EFF DATE

FIELD=DISPLN , ,A1 , DESCRIP=SHORT TERM DISABILITY PLAN CODE

FIELD=DISWAITPER , ,A3 , DESCRIP=SHORT TERM DISABILITY WAITING PER

FIELD=DISBASAMT , ,F5 , DESCRIP=SHORT TERM DISABILITY SALARY BASE

FIELD=CNDIPLN , ,A1 , DESCRIP=NON-INDUSTRIAL DISAB INSURANCE CODE

FIELD=CSUBCBU , ,A3 , DESCRIP=COLL BARG UNIT CODE SUBGROUP

FIELD=CINSRED , ,A1 , DESCRIP=INSURANCE REDUCTION CODE

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=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 AMT

FIELD=LFEFFDTUC , ,A6YMD , DESCRIP=UC PAID LIFE COVERAGE EFF DATE

FIELD=EXECLFEFFDT , ,A6YMD , DESCRIP=EXEC LIFE COVERAGE EFF DATE

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 , ,D13.2C , DESCRIP=Y-T-D TOTAL GROSS

FIELD=YTDFWTGR , ,D13.2C , DESCRIP=Y-T-D TAXABLE GROSS

FIELD=YTDDEPDE , ,D13.2C , DESCRIP=Y-T-D DEPCARE DEDUCTION

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=DCPFUND , ,A1 , DESCRIP=DCP FUND PLAN CODE

FIELD=PRYTDTOT , ,D13.2C , DESCRIP=PRIOR CAL Y-T-D TOTAL GROSS

FIELD=PRYTDFWT , ,D13.2C , DESCRIP=PRIOR CAL Y-T-D TAXABLE GROSS

FIELD=NDIEFFDT , ,A6YMD , DESCRIP=NON INDUSTRIAL DISABIL EFF DATE

FIELD=FYTDFWTG , ,F9.2 , DESCRIP=FISCAL YTD TAXABLE GROSS

FIELD=EMPLL1 , ,A2 , DESCRIP=

FIELD=EMPLL2 , ,A2 , DESCRIP=

FIELD=EMPLL3 , ,A2 , DESCRIP=

FIELD=PERACTDT , ,A6YMD , DESCRIP=PERSONNEL ACTION DATE

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=SICKHRSBAL , ,F5 , DESCRIP=SICK LEAVE HOURS BALANCE

FIELD=VACHRSBAL , ,F5 , DESCRIP=VACATION HOURS BALANCE

FIELD=VACHRSLOST , ,F5 , DESCRIP=VACATION NOT ACCUMULATED (LOST)

FIELD=COMPHRSBAL , ,F5 , DESCRIP=COMP TIME HOURS BALANCE

FIELD=OTHRSWKYTD , ,D10.2 , DESCRIP=OVERTIME HOURS WORKED YTD

FIELD=SICKHRS , ,F5 , DESCRIP=SICK LEAVE HOURS USED

FIELD=VACHRS , ,F5 , DESCRIP=VACATION HOURS USED

FIELD=COMPHRS , ,F5 , DESCRIP=COMP TIME HRS USED

FIELD=OTHRSPD , ,D10.2 , DESCRIP=OVERTIME HOURS PAID

FIELD=OTHRSWK , ,D10.2 , DESCRIP=OVERTIME HOURS WORKED

FIELD=EXSPINTR , ,D12.2 , DESCRIP=SPP TOTAL INT SR MGMT

FIELD=EXSPCONTP , ,D13.2 , DESCRIP=SPP CONT-INT POSTED

FIELD=EXSPCONTNP , ,D13.2 , DESCRIP=SPP CONT- NO INT POSTED

FIELD=EXSPCMCONT , ,D12.2 , DESCRIP=SPP CURRENT MO CONT

FIELD=YTDSEVPAY , ,D13.2 , DESCRIP=YTD SEVERANCE PAY

FIELD=CHOMEDEPT , ,A6 , DESCRIP=HOME DEPT CODE

FIELD=HOMEDEPT , ,A30 , DESCRIP=HOME DEPT NAME

FIELD=CCOUNTRYRES , ,A2 , DESCRIP=COUNTRY OF RESIDENCE CODE

FIELD=COUNTRYRES , ,A30 , DESCRIP=COUNTRY OF RESIDENCE NAME

FIELD=VISATYPE , ,A2 , DESCRIP=VISA TYPE CODE

FIELD=ORIGHIREDT , ,A6YMD , DESCRIP=ORIGINAL DATE OF HIRE

FIELD=WCEVETSTAT , ,A1 , DESCRIP=WAR CAMPAIGN EXPED VET STATUS

SEGNAME=APPTMT,SEGTYPE=S1,PARENT=IDEMPL

FIELD=CTITLE , ,A4 , DESCRIP=TITLE CODE

FIELD=ANRKEY , ,A15 ,INDEX=I DESCRIP=CONCAT. OF CAMPUS & EMP NO & TITLE

FIELD=SUBLOC , ,A2 , DESCRIP=SUBLOCATION CODE

FIELD=APTACTIVT , ,A1 , DESCRIP=APPOINTMENT ACTIVE THIS 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 ,INDEX=I DESCRIP=APPOINTMENT TYPE CODE - FCP

FIELD=COFFABSCA , ,A1 , DESCRIP=OFF/ABOVE SCALE CODE

FIELD=CPDOVER , ,A2 , DESCRIP=PAID OVER CODE

FIELD=CPAYSKED , ,A2 , DESCRIP=PAY SCHEDULE CODE

FIELD=TUC ,CPERBUNIT ,A2 ,INDEX=I DESCRIP=TITLE UNIT CODE

FIELD=SALMGTGD , ,A2 , DESCRIP=SALARY STEP/MGMT SALARY GRADE

FIELD=FILLER , ,A2 , DESCRIP=FILLER

FIELD=APTPCT , ,F6.4 , DESCRIP=TIME - APPOINTMENT (ANTICIPATED)

FIELD=TITLE , ,A30 , DESCRIP=TITLE NAME

FIELD=CCTO ,CCTOB ,A3 ,INDEX=I 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=REPIND , ,A1 , DESCRIP=REPRESENTATION FLAG

FIELD=REL99 , ,A2 , DESCRIP=RELATED 99 TUC

FIELD=BARGAIN , ,A1 , DESCRIP=BARGAIN TYPE

SEGNAME=TTLATTR,SEGTYPE=U,PARENT=APPTMT

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=MERIT , ,A1 , DESCRIP=MERIT-FLAG

SEGNAME=DISTRIB,SEGTYPE=S6,PARENT=APPTMT

FIELD=CLOC2 ,CL2 ,A1 , DESCRIP=UC LOCATION CODE 2 - UWIDE INDIC

FIELD=CLOC3 ,CL3 ,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=SAU , ,A1 , DESCRIP=SYSTEMWIDE ADMINISTRATIVE UNIT

FIELD=DSTPAYRT , ,D11.4 , DESCRIP=DISTRIBUTION PAY RATE

FIELD=MONGRS , ,D12.2 , DESCRIP=GROSS EARNINGS

FIELD=MONHRS , ,F6.2 , DESCRIP=HOURS PAID

FIELD=MONFTE , ,F6.4 , DESCRIP=TIME DISTRIBUTION

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=CUCOPUNIT , ,A6 , DESCRIP= ADMINISTRATIVE UNIT CODE

FIELD=UCOPUNIT , ,A30 , DESCRIP= ADMINISTRATIVE UNIT NAME

FIELD=CORG2 , ,A7 , DESCRIP=ORG 2 CODE

FIELD=CORG2NM , ,A30 , DESCRIP=ORG 2 NAME

FIELD=ACCTGROUP , ,A6 , DESCRIP=ACCOUNT GROUP CODE

FIELD=FUNDGROUP , ,A6 , DESCRIP=FUND GROUP CODE

FIELD=FUNCTION , ,A2 , DESCRIP=FUNCTION CODE

SEGNAME=EMPOATT1,PARENT=IDEMPL,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=IDEMPL,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=IDEMPL,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=IDEMPL,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=EDFATTR,PARENT=IDEMPL,SEGTYPE=KU, CRFILE=EDUCFLD,CRKEY=CEDFLD

SEGNAME=CTOATTR1,PARENT=IDEMPL,SEGTYPE=KU, CRFILE=CTO,CRSEG=CTOATTR,CRKEY=CTOPRI

FIELD=CCTO ,CCTOA ,A3 ,FIELDTYPE=I

FIELD=CTOA , ,A30 ,

SEGNAME=CTOATTR2,PARENT=APPTMT,SEGTYPE=KU, CRFILE=CTO,CRSEG=CTOATTR,CRKEY=CCTO

FIELD=CCTO ,CCTOB ,A3 ,FIELDTYPE=I

FIELD=CTO ,CTOB ,A30 ,

SEGNAME=UASATTR,PARENT=DISTRIB,SEGTYPE=KU, CRFILE=UAS,CRKEY=CUASDISC

SEGNAME=ORGGATT,PARENT=DISTRIB,SEGTYPE=KU, CRFILE=ORGUGRP,CRKEY=CORGGRP

SEGNAME=PUMROOT,PARENT=IDEMPL,SEGTYPE=KU, CRFILE=PUM,CRSEG=PUMROOT,CRKEY=CMPEMP

SEGNAME=IDSUP,PARENT=PUMROOT,SEGTYPE=KU, CRFILE=SNAPSHOT,CRSEG=IDEMPL,CRKEY=CMPSUP

FIELD=FILL1 , ,A2 , DESCRIP=UC LOCATION CODE 1 - MAJOR LOCATION

FIELD=SUPNO , ,A9 , DESCRIP=IDENTIFICATION NUMBER - EMPLOYEE

FIELD=FILL1AA , ,A6 ,

FIELD=CMPSUP ,CMPEMP ,A11 ,INDEX=I

FIELD=FILL1A , ,A2 ,

FIELD=SUPTITLEPRI , ,A4 , DESCRIP=PRIMARY TITLE CODE - SUPERVISOR

FIELD=FILL2 , ,A12 ,

FIELD=SUPNAME , ,A35 , DESCRIP=NAME - SUPERVISOR

FIELD=FILL3 , ,A70 ,

FIELD=SUPEMPDT , ,A6YMD , DESCRIP=DATE OF MOST RECENT HIRE - SUPERV

FIELD=FILL4 , ,A100 ,

FIELD=FILL4A , ,A100 ,

FIELD=FILL4B , ,A102 ,

SEGNAME=SUPAPPT,PARENT=IDSUP,SEGTYPE=KL, CRFILE=SNAPSHOT,CRSEG=APPTMT

FIELD=CSUPTITLE , ,A4 , DESCRIP=TITLE CODE - SUPERVISOR

FIELD=SUPANRKEY , ,A15 ,INDEX=I

FIELD=FILL5 , ,A24 ,

FIELD=CSUPAPTTYP , ,A1 , DESCRIP=APPOINTMENT TYPE CODE - SUPERVISOR

FIELD=FILL6 , ,A7 ,

FIELD=SUPSTEP , ,A2 , DESCRIP=SALARY/STEP MGMT GRADE -SUPERVISOR

FIELD=FILL7 , ,A4 ,

FIELD=SUPTITLE , ,A30 , DESCRIP=TITLE NAME - SUPERVISOR

FIELD=FILL8 , ,A16 ,

SEGNAME=SUPDIST,PARENT=SUPAPPT,SEGTYPE=KL, CRFILE=SNAPSHOT,CRSEG=DISTRIB

FIELD=FILL9 , ,A15 ,

FIELD=CSUPDOS , ,A2 , DESCRIP=SERVICE CODE DESCRIP. - SUPERVISOR

FIELD=CSUPPDOS , ,A3 , DESCRIP=SERVICE CODE PAYROLL. - SUPERVISOR

FIELD=FILL10 , ,A10 ,

FIELD=SUPMONGRS , ,D12.2 , DESCRIP=GROSS EARNINGS - SUPERVISOR

FIELD=FILL11 , ,A8 ,

FIELD=CSUPORGUNT , ,A7 , DESCRIP=ORGANIZATION UNIT CODE-SUPERVISOR

FIELD=SUPORGUNT , ,A30 , DESCRIP=ORGANIZATION UNIT NAME-SUPERVISOR

FIELD=CSUPORGGRP ,CRORGGRP ,A7 , DESCRIP=ORGANIZATION UNIT GRP CODE-SUPER

FIELD=FILL12 , ,A6 ,

FIELD=CSUPUCOPUN , ,A3 , DESCRIP=UCOP UNIT CODE-SUPERVISOR

FIELD=SUPUCOPUN , ,A30 , DESCRIP=UCOP UNIT TITLE - SUPERVISOR

FIELD=FILL12A , ,A51 ,

SEGNAME=SUPORGRP,PARENT=SUPDIST,SEGTYPE=KU, CRFILE=ORGUGRP,CRSEG=ORGGATTR,CRKEY=CSUPORGGRP

FIELD=CORGGRP ,CRORGGRP ,A7 ,FIELDTYPE=I

FIELD=SUPORGGRP , ,A30 , DESCRIP=ORGANIZATION UNIT GROUP NAME-SUPER

SEGNAME=DEPT,PARENT=PUMROOT,SEGTYPE=KU, CRFILE=HOMEDEPT,CRSEG=HD,CRKEY=CHOMEDEPT

FILENAME=SNAPSHOT,SUFFIX=FOC,$OPP SR 15121 7/00 CMS. ADD 18 NEW ELEMENTS. SEGNAME=IDEMPL,SEGTYPE=S2,$ MER,SUBLOC,REL99 ETAL,HOMEDEPT ETC
FIELD=CCAMPUS	,CCDE	,A2	,	DESCRIP=UC LOCATION CODE 1 - MAJOR LOCATION
FIELD=EMPNO	,	,A9	,	DESCRIP=IDENTIFICATION NUMBER - EMPLOYEE
FIELD=CYCLE	,	,A5	,	DESCRIP=MMMYY OF THIS FILE
FIELD=COP	,	,A1	,	DESCRIP=FLAG INDICATING UCOP EMPLOYEE
FIELD=MER	,MERFLG	,A1	,	DESCRIP=FLAG INDICATING MERCED EMPLOYEE
FIELD=CMPEMP	,CEMPNO	,A11	,INDEX=I	DESCRIP=CONCATENATION OF CCAMPUS & EMPNO
FIELD=APPTPRI	,	,A2	,	DESCRIP=APPT NUMBER - PRIMARY APPT
FIELD=TITLEPRI	,	,A4	,	DESCRIP=TITLE CODE - PRIMARY APPT
FIELD=EMPACTIVT	,	,A1	,	DESCRIP=EMPLOYEE ACTIVE THIS 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
FIELD=HCLFLAG	,	,A1	,	DESCRIP=HIGHLY COMP FLAG LOOKBACK YEAR
FIELD=ACTIVANR	,	,A1	,	DESCRIP=EMPLOYEE ACTIVE THIS MONTH-ANR
FIELD=ACTIVOP	,	,A1	,	DESCRIP=EMPLOYEE ACTIVE THIS MONTH CODE-OP
FIELD=EMPNAME	,	,A35	,	DESCRIP=NAME - EMPLOYEE
FIELD=SOCSECNO	,SSN	,A9	,	DESCRIP=SOCIAL SECURITY NUMBER
FIELD=PERMPOST	,	,A10	,	DESCRIP=ADDRESS-PERMANENT-POSTAL CODE
FIELD=ADRDISCIND	,	,A1	,	DESCRIP=HOME ADDRESS DISCLOSURE CODE
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=PRIOR ID NUMBER - EMPLOYEE
FIELD=PRSVCMOS	,	,F3	,	DESCRIP=PRIOR SERVICE MONTHS
FIELD=CCBU	,	,A2	,INDEX=I	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=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=CDENTCVG	,	,A3	,	DESCRIP=DENTAL PLAN CVG 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=DISEFFDT	,	,A6YMD	,	DESCRIP=SHORT TERM DISABILITY EFF DATE
FIELD=DISPLN	,	,A1	,	DESCRIP=SHORT TERM DISABILITY PLAN CODE
FIELD=DISWAITPER	,	,A3	,	DESCRIP=SHORT TERM DISABILITY WAITING PER
FIELD=DISBASAMT	,	,F5	,	DESCRIP=SHORT TERM DISABILITY SALARY BASE
FIELD=CNDIPLN	,	,A1	,	DESCRIP=NON-INDUSTRIAL DISAB INSURANCE CODE
FIELD=CSUBCBU	,	,A3	,	DESCRIP=COLL BARG UNIT CODE SUBGROUP
FIELD=CINSRED	,	,A1	,	DESCRIP=INSURANCE REDUCTION CODE
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=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 AMT
FIELD=LFEFFDTUC	,	,A6YMD	,	DESCRIP=UC PAID LIFE COVERAGE EFF DATE
FIELD=EXECLFEFFDT	,	,A6YMD	,	DESCRIP=EXEC LIFE COVERAGE EFF DATE
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	,	,D13.2C	,	DESCRIP=Y-T-D TOTAL GROSS
FIELD=YTDFWTGR	,	,D13.2C	,	DESCRIP=Y-T-D TAXABLE GROSS
FIELD=YTDDEPDE	,	,D13.2C	,	DESCRIP=Y-T-D DEPCARE DEDUCTION
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=DCPFUND	,	,A1	,	DESCRIP=DCP FUND PLAN CODE
FIELD=PRYTDTOT	,	,D13.2C	,	DESCRIP=PRIOR CAL Y-T-D TOTAL GROSS
FIELD=PRYTDFWT	,	,D13.2C	,	DESCRIP=PRIOR CAL Y-T-D TAXABLE GROSS
FIELD=NDIEFFDT	,	,A6YMD	,	DESCRIP=NON INDUSTRIAL DISABIL EFF DATE
FIELD=FYTDFWTG	,	,F9.2	,	DESCRIP=FISCAL YTD TAXABLE GROSS
FIELD=EMPLL1	,	,A2	,	DESCRIP=
FIELD=EMPLL2	,	,A2	,	DESCRIP=
FIELD=EMPLL3	,	,A2	,	DESCRIP=
FIELD=PERACTDT	,	,A6YMD	,	DESCRIP=PERSONNEL ACTION DATE
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=SICKHRSBAL	,	,F5	,	DESCRIP=SICK LEAVE HOURS BALANCE
FIELD=VACHRSBAL	,	,F5	,	DESCRIP=VACATION HOURS BALANCE
FIELD=VACHRSLOST	,	,F5	,	DESCRIP=VACATION NOT ACCUMULATED (LOST)
FIELD=COMPHRSBAL	,	,F5	,	DESCRIP=COMP TIME HOURS BALANCE
FIELD=OTHRSWKYTD	,	,D10.2	,	DESCRIP=OVERTIME HOURS WORKED YTD
FIELD=SICKHRS	,	,F5	,	DESCRIP=SICK LEAVE HOURS USED
FIELD=VACHRS	,	,F5	,	DESCRIP=VACATION HOURS USED
FIELD=COMPHRS	,	,F5	,	DESCRIP=COMP TIME HRS USED
FIELD=OTHRSPD	,	,D10.2	,	DESCRIP=OVERTIME HOURS PAID
FIELD=OTHRSWK	,	,D10.2	,	DESCRIP=OVERTIME HOURS WORKED
FIELD=EXSPINTR	,	,D12.2	,	DESCRIP=SPP TOTAL INT SR MGMT
FIELD=EXSPCONTP	,	,D13.2	,	DESCRIP=SPP CONT-INT POSTED
FIELD=EXSPCONTNP	,	,D13.2	,	DESCRIP=SPP CONT- NO INT POSTED
FIELD=EXSPCMCONT	,	,D12.2	,	DESCRIP=SPP CURRENT MO CONT
FIELD=YTDSEVPAY	,	,D13.2	,	DESCRIP=YTD SEVERANCE PAY
FIELD=CHOMEDEPT	,	,A6	,	DESCRIP=HOME DEPT CODE
FIELD=HOMEDEPT	,	,A30	,	DESCRIP=HOME DEPT NAME
FIELD=CCOUNTRYRES	,	,A2	,	DESCRIP=COUNTRY OF RESIDENCE CODE
FIELD=COUNTRYRES	,	,A30	,	DESCRIP=COUNTRY OF RESIDENCE NAME
FIELD=VISATYPE	,	,A2	,	DESCRIP=VISA TYPE CODE
FIELD=ORIGHIREDT	,	,A6YMD	,	DESCRIP=ORIGINAL DATE OF HIRE
FIELD=WCEVETSTAT	,	,A1	,	DESCRIP=WAR CAMPAIGN EXPED VET STATUS
SEGNAME=APPTMT,SEGTYPE=S1,PARENT=IDEMPL
FIELD=CTITLE	,	,A4	,	DESCRIP=TITLE CODE
FIELD=ANRKEY	,	,A15	,INDEX=I	DESCRIP=CONCAT. OF CAMPUS & EMP NO & TITLE
FIELD=SUBLOC	,	,A2	,	DESCRIP=SUBLOCATION CODE
FIELD=APTACTIVT	,	,A1	,	DESCRIP=APPOINTMENT ACTIVE THIS 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	,INDEX=I	DESCRIP=APPOINTMENT TYPE CODE - FCP
FIELD=COFFABSCA	,	,A1	,	DESCRIP=OFF/ABOVE SCALE CODE
FIELD=CPDOVER	,	,A2	,	DESCRIP=PAID OVER CODE
FIELD=CPAYSKED	,	,A2	,	DESCRIP=PAY SCHEDULE CODE
FIELD=TUC	,CPERBUNIT	,A2	,INDEX=I	DESCRIP=TITLE UNIT CODE
FIELD=SALMGTGD	,	,A2	,	DESCRIP=SALARY STEP/MGMT SALARY GRADE
FIELD=FILLER	,	,A2	,	DESCRIP=FILLER
FIELD=APTPCT	,	,F6.4	,	DESCRIP=TIME - APPOINTMENT (ANTICIPATED)
FIELD=TITLE	,	,A30	,	DESCRIP=TITLE NAME
FIELD=CCTO	,CCTOB	,A3	,INDEX=I	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=REPIND	,	,A1	,	DESCRIP=REPRESENTATION FLAG
FIELD=REL99	,	,A2	,	DESCRIP=RELATED 99 TUC
FIELD=BARGAIN	,	,A1	,	DESCRIP=BARGAIN TYPE
SEGNAME=TTLATTR,SEGTYPE=U,PARENT=APPTMT
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=MERIT	,	,A1	,	DESCRIP=MERIT-FLAG
SEGNAME=DISTRIB,SEGTYPE=S6,PARENT=APPTMT
FIELD=CLOC2	,CL2	,A1	,	DESCRIP=UC LOCATION CODE 2 - UWIDE INDIC
FIELD=CLOC3	,CL3	,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=SAU	,	,A1	,	DESCRIP=SYSTEMWIDE ADMINISTRATIVE UNIT
FIELD=DSTPAYRT	,	,D11.4	,	DESCRIP=DISTRIBUTION PAY RATE
FIELD=MONGRS	,	,D12.2	,	DESCRIP=GROSS EARNINGS
FIELD=MONHRS	,	,F6.2	,	DESCRIP=HOURS PAID
FIELD=MONFTE	,	,F6.4	,	DESCRIP=TIME DISTRIBUTION
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=CUCOPUNIT	,	,A6	,	DESCRIP= ADMINISTRATIVE UNIT CODE
FIELD=UCOPUNIT	,	,A30	,	DESCRIP= ADMINISTRATIVE UNIT NAME
FIELD=CORG2	,	,A7	,	DESCRIP=ORG 2 CODE
FIELD=CORG2NM	,	,A30	,	DESCRIP=ORG 2 NAME
FIELD=ACCTGROUP	,	,A6	,	DESCRIP=ACCOUNT GROUP CODE
FIELD=FUNDGROUP	,	,A6	,	DESCRIP=FUND GROUP CODE
FIELD=FUNCTION	,	,A2	,	DESCRIP=FUNCTION CODE
SEGNAME=EMPOATT1,PARENT=IDEMPL,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=IDEMPL,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=IDEMPL,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=IDEMPL,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=EDFATTR,PARENT=IDEMPL,SEGTYPE=KU, CRFILE=EDUCFLD,CRKEY=CEDFLD
SEGNAME=CTOATTR1,PARENT=IDEMPL,SEGTYPE=KU, CRFILE=CTO,CRSEG=CTOATTR,CRKEY=CTOPRI
FIELD=CCTO	,CCTOA	,A3	,FIELDTYPE=I
FIELD=CTOA	,	,A30	,
SEGNAME=CTOATTR2,PARENT=APPTMT,SEGTYPE=KU, CRFILE=CTO,CRSEG=CTOATTR,CRKEY=CCTO
FIELD=CCTO	,CCTOB	,A3	,FIELDTYPE=I
FIELD=CTO	,CTOB	,A30	,
SEGNAME=UASATTR,PARENT=DISTRIB,SEGTYPE=KU, CRFILE=UAS,CRKEY=CUASDISC
SEGNAME=ORGGATT,PARENT=DISTRIB,SEGTYPE=KU, CRFILE=ORGUGRP,CRKEY=CORGGRP
SEGNAME=PUMROOT,PARENT=IDEMPL,SEGTYPE=KU, CRFILE=PUM,CRSEG=PUMROOT,CRKEY=CMPEMP
SEGNAME=IDSUP,PARENT=PUMROOT,SEGTYPE=KU, CRFILE=SNAPSHOT,CRSEG=IDEMPL,CRKEY=CMPSUP
FIELD=FILL1	,	,A2	,	DESCRIP=UC LOCATION CODE 1 - MAJOR LOCATION
FIELD=SUPNO	,	,A9	,	DESCRIP=IDENTIFICATION NUMBER - EMPLOYEE
FIELD=FILL1AA	,	,A6	,
FIELD=CMPSUP	,CMPEMP	,A11	,INDEX=I
FIELD=FILL1A	,	,A2	,
FIELD=SUPTITLEPRI	,	,A4	,	DESCRIP=PRIMARY TITLE CODE - SUPERVISOR
FIELD=FILL2	,	,A12	,
FIELD=SUPNAME	,	,A35	,	DESCRIP=NAME - SUPERVISOR
FIELD=FILL3	,	,A70	,
FIELD=SUPEMPDT	,	,A6YMD	,	DESCRIP=DATE OF MOST RECENT HIRE - SUPERV
FIELD=FILL4	,	,A100	,
FIELD=FILL4A	,	,A100	,
FIELD=FILL4B	,	,A102	,
SEGNAME=SUPAPPT,PARENT=IDSUP,SEGTYPE=KL, CRFILE=SNAPSHOT,CRSEG=APPTMT
FIELD=CSUPTITLE	,	,A4	,	DESCRIP=TITLE CODE - SUPERVISOR
FIELD=SUPANRKEY	,	,A15	,INDEX=I
FIELD=FILL5	,	,A24	,
FIELD=CSUPAPTTYP	,	,A1	,	DESCRIP=APPOINTMENT TYPE CODE - SUPERVISOR
FIELD=FILL6	,	,A7	,
FIELD=SUPSTEP	,	,A2	,	DESCRIP=SALARY/STEP MGMT GRADE -SUPERVISOR
FIELD=FILL7	,	,A4	,
FIELD=SUPTITLE	,	,A30	,	DESCRIP=TITLE NAME - SUPERVISOR
FIELD=FILL8	,	,A16	,
SEGNAME=SUPDIST,PARENT=SUPAPPT,SEGTYPE=KL, CRFILE=SNAPSHOT,CRSEG=DISTRIB
FIELD=FILL9	,	,A15	,
FIELD=CSUPDOS	,	,A2	,	DESCRIP=SERVICE CODE DESCRIP. - SUPERVISOR
FIELD=CSUPPDOS	,	,A3	,	DESCRIP=SERVICE CODE PAYROLL. - SUPERVISOR
FIELD=FILL10	,	,A10	,
FIELD=SUPMONGRS	,	,D12.2	,	DESCRIP=GROSS EARNINGS - SUPERVISOR
FIELD=FILL11	,	,A8	,
FIELD=CSUPORGUNT	,	,A7	,	DESCRIP=ORGANIZATION UNIT CODE-SUPERVISOR
FIELD=SUPORGUNT	,	,A30	,	DESCRIP=ORGANIZATION UNIT NAME-SUPERVISOR
FIELD=CSUPORGGRP	,CRORGGRP	,A7	,	DESCRIP=ORGANIZATION UNIT GRP CODE-SUPER
FIELD=FILL12	,	,A6	,
FIELD=CSUPUCOPUN	,	,A3	,	DESCRIP=UCOP UNIT CODE-SUPERVISOR
FIELD=SUPUCOPUN	,	,A30	,	DESCRIP=UCOP UNIT TITLE - SUPERVISOR
FIELD=FILL12A	,	,A51	,
SEGNAME=SUPORGRP,PARENT=SUPDIST,SEGTYPE=KU, CRFILE=ORGUGRP,CRSEG=ORGGATTR,CRKEY=CSUPORGGRP
FIELD=CORGGRP	,CRORGGRP	,A7	,FIELDTYPE=I
FIELD=SUPORGGRP	,	,A30	,	DESCRIP=ORGANIZATION UNIT GROUP NAME-SUPER
SEGNAME=DEPT,PARENT=PUMROOT,SEGTYPE=KU, CRFILE=HOMEDEPT,CRSEG=HD,CRKEY=CHOMEDEPT