$ 09/15/05 VW REMOVE FIELDS E_MER AND MER
$ 06/14/06 DMC MIGRATE FROM VM/CMS AND CHANGED THE CRKEY
$ TO CXASPRI IN SEGNAME=UASATTR.
FILENAME=HISTORY,SUFFIX=FOC,$ ADDED COP AND MER CODES 7/2001 CMS S
SEGNAME=IDCAMP,SEGTYPE=S1,$SALSTEP - SEP02 MAKE IT A4
FIELD=CCAMPUS , ,A2 ,$
DESCRIP=UC LOCATION CODE 1 - MAJOR LOCATION,$
SEGNAME=IDEMPL,SEGTYPE=S1,PARENT=IDCAMP,$
FIELD=EMPNO ,EMPNUM ,A9 ,$
DESCRIP=IDENTIFICATION NUMBER - EMPLOYEE,$
SEGNAME=EMPLOYEE,SEGTYPE=U,PARENT=IDEMPL,LOCATION=FCPHST01,$
FIELD=EMPNAME , ,A35 ,$
DESCRIP=NAME - EMPLOYEE,$
FIELD=SOCSECNO ,SSN ,A9 ,$
DESCRIP=SOCIAL SECURITY NUMBER,$
FIELD=CSEX , ,A1 ,$
DESCRIP=SEX CODE,$
FIELD=CETHNIC , ,A2 ,$
DESCRIP=ETHNIC ORIGIN CODE-EMPLOYEE,$
FIELD=EDLVLYR , ,A2 ,$
DESCRIP=EDUCATION LEVEL YEAR,$
FIELD=BDATE , ,A6YMD ,$
DESCRIP=DATE OF BIRTH,$
FIELD=EMPDT , ,A6YMD ,$
DESCRIP=DATE OF MOST RECENT HIRE,$
FIELD=MERITPCT , ,F5.2 ,$
DESCRIP=MERIT PERCENT,$
FIELD=CPRSVC , ,A1 ,$
DESCRIP=PRIOR SERVICE CODE,$
FIELD=CPRINST ,CODE ,A3 ,$
DESCRIP=PRIOR INSTITUTION CODE,$
FIELD=CEMPDEST , ,A1 ,$
DESCRIP=SEPARATED EMPLOYEE DEST CODE,$
FIELD=CSEPRSN , ,A2 ,$
DESCRIP=SEPARATION REASON CODE,$
FIELD=CFUTINST ,CODE ,A3 ,$
DESCRIP=FUTURE INSTITUTION CODE,$
FIELD=CVOLSEP , ,A1 ,$
DESCRIP=VOLUNTARY SEPARATION CODE,$
FIELD=EUC , ,A2 ,$
DESCRIP=HEERA_EMPLOYEE UNIT CODE,$
FIELD=CEMPSH , ,A1 ,$
DESCRIP=HEERA_EMPLOYEE SPECIAL HANDLING CODE,$
FIELD=EDUC , ,A1 ,$
DESCRIP=HEERA_EMPLOYEE DISTRIBUTION UNIT CODE,$
FIELD=CEMPREP , ,A1 ,$
DESCRIP=HEERA_EMPLOYEE REPRESENTATION CODE,$
FIELD=CCBU , ,A2 ,$
DESCRIP=COLLECTIVE BARGAINING UNIT CODE,$
FIELD=PREMPNO , ,A9 ,$
DESCRIP= PREVIOUS EMPLOYEE NUMBER,$
FIELD=CSEPRSNA , ,A2 ,$
DESCRIP= SEPARATION RSN CODE - ACAD,$
FIELD=E_COP , ,A1 ,$
DESCRIP=FLAG INDICATING UCOP ANR OR MERC,$
SEGNAME=ACTION,SEGTYPE=S2,PARENT=IDEMPL,LOCATION=FCPHST02,$
FIELD=PERACTDT , ,A6YMD ,$
DESCRIP=PERSONNEL ACTION DATE,$
FIELD=CPERACT , ,A2 ,$
DESCRIP=PERSONNEL ACTION CODE,$
FIELD=CINTCAMP , ,A1 ,$
DESCRIP=INTERCAMPUS ACTION CODE,$
FIELD=CRECLASS , ,A1 ,$
DESCRIP=RECLASSIFICATION TYPE CODE,$
FIELD=CCHNGPAYRT , ,A1 ,$
DESCRIP=CHANGE OF PAYRATE CODE,$
FIELD=COP , ,A1 ,$
DESCRIP=FLAG INDICATING UCOP ANR OR MERC,$
SEGNAME=APPTMT,SEGTYPE=S2,PARENT=ACTION,LOCATION=FCPHST03,$
FIELD=APPTNO , ,A2 ,$
DESCRIP=APPOINTMENT NUMBER,$
FIELD=CTITLE , ,A4 ,$
DESCRIP=TITLE CODE,$
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=SALMGTGD , ,A2 ,$
DESCRIP=SALARY STEP/MGMT SALARY GRADE,$
FIELD=SALSTEP , ,A4 ,$
DESCRIP=SALARY STEP,$
FIELD=APTPCT , ,F6.4 ,$
DESCRIP=TIME - APPOINTMENT (ANTICIPATED),$
SEGNAME=APPTMT1,SEGTYPE=U,PARENT=APPTMT,LOCATION=FCPHST04,$
FIELD=CAPTTYPT , ,A1 ,$
DESCRIP=APPOINTMENT TYPE CODE - TCS,$
FIELD=TITLE , ,A30 ,$
DESCRIP=TITLE NAME,$
FIELD=CCTO , ,A3 ,$
DESCRIP=CLASS TITLE OUTLINE CODE,$
FIELD=CFOCSUB , ,A2 ,$
DESCRIP=FEDERAL OCCUPATION SUBCATEGORY CODE,$
FIELD=CACRANK , ,A1 ,$
DESCRIP=ACADEMIC RANK CODE,$
FIELD=ACCTNOPRI , ,A6 ,$
DESCRIP=ACCOUNT NUMBER - PRIMARY,$
SEGNAME=APPTMT2,SEGTYPE=U,PARENT=APPTMT1,LOCATION=FCPHST05,$
FIELD=CLOC2PRI , ,A1 ,$
DESCRIP=UC LOCATION CODE 2 - PRIMARY,$
FIELD=CLOC3PRI , ,A1 ,$
DESCRIP=UC LOCATION CODE 3 - PRIMARY,$
FIELD=CORGUPRI , ,A7 ,$
DESCRIP=ORGANIZATION UNIT CODE - PRIMARY,$
FIELD=ORGUPRI , ,A30 ,$
DESCRIP=ORGANIZATION UNIT NAME - PRIMARY,$
$ FIELD=CUASPRI , ,A3 , *** TEMP CHANGE FOR TEST ***
FIELD=CXASPRI , ,A3 ,$
DESCRIP=UAS DISCIPLINE CODE - PRIMARY,$
SEGNAME=SUBAPPT,SEGTYPE=U,PARENT=APPTMT2,LOCATION=FCPHST06,$
FIELD=FILLSAPPT , ,A6 ,$
SEGNAME=PRINSTS,PARENT=EMPLOYEE,SEGTYPE=KU,
CRFILE=FCPSCH,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=REST OF SCHOOL RECORD,$
SEGNAME=PRINSTL,PARENT=PRINSTS,SEGTYPE=KU,
CRFILE=CSSLOC,CRSEG=LOC,CRKEY=CPRINSTLOC
FIELD=CXPRINSTLOC ,LOC_CD ,A3 ,FIELDTYPE=I,$
DESCRIP= ,$
FIELD=PRINSTLNAME , ,A28 ,$
DESCRIP=PRIOR INSTITUTION LOCATION NAME,$
FIELD=FILLPRL , ,A5 ,$
DESCRIP=REST OF LOCATION RECORD,$
SEGNAME=FUTINSTS,PARENT=EMPLOYEE,SEGTYPE=KU,
CRFILE=FCPSCH,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=REST OF SCHOOL RECORD,$
SEGNAME=FUTINSTL,PARENT=FUTINSTS,SEGTYPE=KU,
CRFILE=CSSLOC,CRSEG=LOC,CRKEY=CFUTINSTLOC
FIELD=CXFUTINSTLOC,LOC_CD ,A3 ,FIELDTYPE=I,$
DESCRIP= ,$
FIELD=FUTINSTLNAME, ,A28 ,$
DESCRIP=FUTURE INSTITUTION LOCATION NAME,$
SEGNAME=CTOATTR,PARENT=APPTMT,SEGTYPE=KU,
CRFILE=FCPCTO,CRKEY=CCTO,$
SEGNAME=UASATTR,PARENT=APPTMT,SEGTYPE=KU,
$ CRFILE=FCPUAS,CRKEY=CUASPRI, ALIAS CHANGED IN FCPUAS TO CXASPRI
CRFILE=FCPUAS,CRKEY=CXASPRI,$ LINK CRKEY TO ALIAS IN CRFILE