SEGNAME=IDCAMP,SEGTYPE=S1, NEW FCP DATA 11/11/96 CMS.
|
| FIELD=CCAMPUS | , | ,A2 | ,
| DECRIP=UC LOCATION CODE 1 - MAJOR LOCATION
|
SEGNAME=IDEMPL,SEGTYPE=S1,PARENT=IDCAMP
|
| FIELD=EMPNO | , | ,A9 | ,
| DECRIP=IDENTIFICATION NUMBER - EMPLOYEE
|
| FIELD=EMPLID | , | ,A11 | ,INDEX=I |
DECRIP=CCAMPUS³³EMPNO
|
| FIELD=APPTPRI | , | ,A2 | ,
| DECRIP=APPT NUMBER - PRIMARY APPT
|
| FIELD=TITLEPRI | , | ,A4 | ,
| DECRIP=TITLE CODE - PRIMARY APPT
|
| FIELD=EMPACTIVT | , | ,A1 | ,
| DECRIP=EMPLOYEE ACTIVE THIS MONTH CODE
|
| FIELD=EMPACTIVL | , | ,A1 | ,
| DECRIP=EMPLOYEE ACTIVE LAST MONTH CODE
|
SEGNAME=EMPLOYEE,SEGTYPE=U,PARENT=IDEMPL
|
| FIELD=EMPNAME | , | ,A35 | ,
| DECRIP=NAME - EMPLOYEE
|
| FIELD=SOCSECNO | ,SSN | ,A9 | ,
| DECRIP=SOCIAL SECURITY NUMBER
|
| FIELD=CEMPSTAT | , | ,A1 | ,
| DECRIP=EMPLOYMENT STATUS CODE
|
| FIELD=CSEX | , | ,A1 | ,
| DECRIP=SEX CODE
|
| FIELD=BDATE | , | ,A6YMD | ,
| DECRIP=DATE OF BIRTH
|
| FIELD=CETHNIC | , | ,A2 | ,
| DECRIP=ETHNIC ORIGIN CODE-EMPLOYEE
|
| FIELD=CCBU | , | ,A2 | ,
| DECRIP=COLLECTIVE BARGAINING UNIT CODE
|
| FIELD=EMPDT | , | ,A6YMD | ,
| DECRIP=DATE OF MOST RECENT HIRE
|
| FIELD=MERITPCT | , | ,F5.2 | ,
| DECRIP=MERIT PERCENT
|
| FIELD=SEPDT | , | ,A6YMD | ,
| DECRIP=SEPARATION DATE
|
| FIELD=CSEPRSN | , | ,A2 | ,
| DECRIP=SEPARATION REASON CODE
|
SEGNAME=APPTMT,SEGTYPE=S2,PARENT=IDEMPL
|
| FIELD=APPTNO | , | ,A2 | ,
| DECRIP=APPOINTMENT NUMBER
|
| FIELD=CTITLE | , | ,A4 | ,
| DECRIP=TITLE CODE
|
| FIELD=APTACTIVT | , | ,A1 | ,
| DECRIP=APPOINTMENT ACTIVE THIS MONTH CODE
|
| FIELD=APTACTIVL | , | ,A1 | ,
| DECRIP=APPOINTMENT ACTIVE LAST MONTH CODE
|
| FIELD=APTBEGDT | , | ,A6YMD | ,
| DECRIP=APPOINTMENT BEGIN DATE
|
| FIELD=APTENDDT | , | ,A6YMD | ,
| DECRIP=APPOINTMENT END DATE
|
| FIELD=APTPAYRT | , | ,D11.4 | ,
| DECRIP=APPOINTMENT PAY RATE
|
| FIELD=CAPTRT | , | ,A1 | ,
| DECRIP=APPOINTMENT RATE CODE
|
| FIELD=CAPTTYP | , | ,A1 | ,
| DECRIP=APPOINTMENT TYPE CODE - PPS
|
| FIELD=COFFABSCA | , | ,A1 | ,
| DECRIP=OFF/ABOVE SCALE CODE
|
| FIELD=CPDOVER | , | ,A2 | ,
| DECRIP=PAID OVER CODE
|
| FIELD=SALMGTGD | , | ,A2 | ,
| DECRIP=SALARY STEP/MGMT SALARY GRADE
|
| FIELD=APTPCT | , | ,F6.4 | ,
| DECRIP=TIME - APPOINTMENT (ANTICIPATED)
|
| FIELD=TITLE | , | ,A30 | ,
| DECRIP=TITLE NAME
|
| FIELD=CCTO | , | ,A3 | ,
| DECRIP=CLASS TITLE OUTLINE CODE
|
| FIELD=CFOCSUB | , | ,A2 | ,
| DECRIP=FEDERAL OCCUPATION SUBCATEGORY CODE
|
| FIELD=CACRANK | , | ,A1 | ,
| DECRIP=ACADEMIC RANK CODE
|
SEGNAME=DISTRIB,SEGTYPE=S7,PARENT=APPTMT
|
| FIELD=CLOC2 | , | ,A1 | ,
| DECRIP=UC LOCATION CODE 2 - UWIDE INDIC
|
| FIELD=CLOC3 | , | ,A1 | ,
| DECRIP=UC LOCATION CODE 3 - ORG CATEGORY
|
| FIELD=ACCTNO | , | ,A6 | ,
| DECRIP=ACCOUNT NUMBER
|
| FIELD=FUNDNO | , | ,A5 | ,
| DECRIP=FUND NUMBER
|
| FIELD=CSUBACCT | , | ,A2 | ,
| DECRIP=SUBACCOUNT CODE
|
| FIELD=CDOS | , | ,A2 | ,
| DECRIP=DESCRIPTION OF SERVICE CODE
|
| FIELD=PDOS | , | ,A3 | ,
| DECRIP=PAYROLL DOS
|
| FIELD=DSTPAYRT | , | ,D11.4 | ,
| DECRIP=DISTRIBUTION PAY RATE
|
| FIELD=MONGRSJUL | , | ,D12.2 | ,
| DECRIP=GROSS EARNINGS - JULY
|
| FIELD=MONGRSAUG | , | ,D12.2 | ,
| DECRIP=GROSS EARNINGS - AUGUST
|
| FIELD=MONGRSSEP | , | ,D12.2 | ,
| DECRIP=GROSS EARNINGS - SEPTEMBER
|
| FIELD=MONGRSOCT | , | ,D12.2 | ,
| DECRIP=GROSS EARNINGS - OCTOBER
|
| FIELD=MONGRSNOV | , | ,D12.2 | ,
| DECRIP=GROSS EARNINGS - NOVEMBER
|
| FIELD=MONGRSDEC | , | ,D12.2 | ,
| DECRIP=GROSS EARNINGS - DECEMBER
|
| FIELD=MONGRSJAN | , | ,D12.2 | ,
| DECRIP=GROSS EARNINGS - JANUARY
|
| FIELD=MONGRSFEB | , | ,D12.2 | ,
| DECRIP=GROSS EARNINGS - FEBRUARY
|
| FIELD=MONGRSMAR | , | ,D12.2 | ,
| DECRIP=GROSS EARNINGS - MARCH
|
| FIELD=MONGRSAPR | , | ,D12.2 | ,
| DECRIP=GROSS EARNINGS - APRIL
|
| FIELD=MONGRSMAY | , | ,D12.2 | ,
| DECRIP=GROSS EARNINGS - MAY
|
| FIELD=MONGRSJUN | , | ,D12.2 | ,
| DECRIP=GROSS EARNINGS - JUNE
|
| FIELD=MONFTEJUL | , | ,F6.4 | ,
| DECRIP=TIME DISTRIBUTION - JULY
|
| FIELD=MONFTEAUG | , | ,F6.4 | ,
| DECRIP=TIME DISTRIBUTION - AUGUST
|
| FIELD=MONFTESEP | , | ,F6.4 | ,
| DECRIP=TIME DISTRIBUTION - SEPTEMBER
|
| FIELD=MONFTEOCT | , | ,F6.4 | ,
| DECRIP=TIME DISTRIBUTION - OCTOBER
|
| FIELD=MONFTENOV | , | ,F6.4 | ,
| DECRIP=TIME DISTRIBUTION - NOVEMBER
|
| FIELD=MONFTEDEC | , | ,F6.4 | ,
| DECRIP=TIME DISTRIBUTION - DECEMBER
|
| FIELD=MONFTEJAN | , | ,F6.4 | ,
| DECRIP=TIME DISTRIBUTION - JANUARY
|
| FIELD=MONFTEFEB | , | ,F6.4 | ,
| DECRIP=TIME DISTRIBUTION - FEBRUARY
|
| FIELD=MONFTEMAR | , | ,F6.4 | ,
| DECRIP=TIME DISTRIBUTION - MARCH
|
| FIELD=MONFTEAPR | , | ,F6.4 | ,
| DECRIP=TIME DISTRIBUTION - APRIL
|
| FIELD=MONFTEMAY | , | ,F6.4 | ,
| DECRIP=TIME DISTRIBUTION - MAY
|
| FIELD=MONFTEJUN | , | ,F6.4 | ,
| DECRIP=TIME DISTRIBUTION - JUNE
|
| FIELD=CORGUNIT | , | ,A7 | ,
| DECRIP=ORGANIZATION UNIT CODE
|
| FIELD=ORGUNIT | , | ,A30 | ,
| DECRIP=ORGANIZATION UNIT NAME
|
| FIELD=CORGGRP | , | ,A7 | ,
| DECRIP=ORGANIZATION UNIT GROUP CODE
|
| FIELD=CUASDISC | , | ,A3 | ,
| DECRIP=UAS DISCIPLINE CODE
|
| FIELD=CORG2 | , | ,A7 | ,
| DECRIP=ORGANIZATION UNIT GROUP CODE 2
|
| FIELD=CORG2NM | , | ,A30 | ,
| DECRIP=ORG 2 LEVEL NAME
|
SEGNAME=CTOATTR,PARENT=APPTMT,SEGTYPE=KU,
CRFILE=CTO,CRKEY=CCTO
|
SEGNAME=UASATTR,PARENT=DISTRIB,SEGTYPE=KU,
CRFILE=UAS,CRKEY=CUASDISC
|
SEGNAME=ORGGATTR,PARENT=DISTRIB,SEGTYPE=KU,
CRFILE=ORGUGRP,CRKEY=CORGGRP
|
Fiscal Year Academic Subset Master