| FILENAME=SNAPSHOT,SUFFIX=FOC |
|
| SEGNAME=IDCAMP,SEGTYPE=S1, |
|
| FIELD=CCAMPUS |
, |
,A2 |
, |
DESCRIP=UC LOCATION CODE 1 - MAJOR LOCATION, |
|
| FIELD=CYCLE |
, |
,A5 |
, |
DESCRIP=MMMYY OF THIS FILE, |
|
| SEGNAME=IDEMPL,SEGTYPE=S1,PARENT=IDCAMP, |
|
| FIELD=EMPNO |
, |
,A9 |
, |
DESCRIP=IDENTIFICATION NUMBER - EMPLOYEE, |
|
| FIELD=COP |
, |
,A1 |
, |
DESCRIP=FLAG INDICATING UCOP EMPLOYEE, |
|
| FIELD=MER |
,MERFLG |
,A1 |
, |
DESCRIP=FLAG INDICATING MERCED EMPLOYEE, |
|
| 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, |
|
| SEGNAME=EMPLOYEE,SEGTYPE=U,PARENT=IDEMPL, |
|
| FIELD=EMPNAME |
, |
,A35 |
, |
DESCRIP=NAME - EMPLOYEE, |
|
| FIELD=SOCSECNO |
,SSN |
,A9 |
, |
DESCRIP=SOCIAL SECURITY NUMBER, |
|
| 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=PREVIOUS EMPLOYEE NUMBER, |
|
| 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=CNDIPLN |
, |
,A1 |
, |
DESCRIP=NON-INDUSTRIAL DISAB INSURANCE CODE, |
|
| 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=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=BELISQC1 |
, |
,A2 |
, |
DESCRIP=PRIMARY BELI STATUS QUAL CODE, |
|
| FIELD=BELISQD1 |
, |
,A6YMD |
, |
DESCRIP=PRIMARY BELI STATUS QUAL DATE, |
|
| FIELD=BELISQC2 |
, |
,A2 |
, |
DESCRIP=SECONDARY BELI STATUS QUAL CODE, |
|
| FIELD=BELISQD2 |
, |
,A6YMD |
, |
DESCRIP=SECONDARY BELI STATUS QUAL 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.2 |
, |
DESCRIP=Y-T-D TOTAL GROSS, |
|
| FIELD=YTDFWTGR |
, |
,D13.2 |
, |
DESCRIP=Y-T-D TAXABLE GROSS, |
|
| FIELD=YTDDEPDE |
, |
,D13.2 |
, |
DESCRIP=Y-T-D DEPCARE DEDUCTION, |
|
| FIELD=DCPFUND |
, |
,A1 |
, |
DESCRIP=DCP FUND PLAN CODE, |
|
| FIELD=PRYTDTOT |
, |
,D13.2 |
, |
DESCRIP=PRIOR CAL Y-T-D TOTAL GROSS, |
|
| FIELD=PRYTDFWT |
, |
,D13.2 |
, |
DESCRIP=PRIOR CAL Y-T-D TAXABLE 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 |
, |
,D13.2 |
, |
DESCRIP=FISCAL YTD TAXABLE GROSS, |
|
| FIELD=EXSPINTR |
, |
,D12.2 |
, |
DESCRIP=SPP TOTAL INT ST MGT, |
|
| FIELD=EXSPCONTP |
, |
,D12.2 |
, |
DESCRIP=SPP CONT INT POSTED, |
|
| FIELD=EXSPCONTNP |
, |
,D12.2 |
, |
DESCRIP=SPP CONT NO INT POSTED, |
|
| FIELD=EXSPCMCONTP |
, |
,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=LFEFFDTUC |
, |
,A6YMD |
, |
DESCRIP=UC PD LIFE INS COV EFF DT, |
|
| FIELD=EXECLFEFFDT |
, |
,A6YMD |
, |
DESCRIP=EXEC LIFE INS COV EFF DT, |
|
| FIELD=CCOUNTRYRES |
, |
,A2 |
, |
DESCRIP=COUNTRY OF RESIDENCE CODE, |
|
| FIELD=COUNTRYRES |
, |
,A30 |
, |
DESCRIP=COUNTRY OF RESIDENCE, |
|
| FIELD=VISATYPE |
, |
,A2 |
, |
DESCRIP=VISA TYPE CODE, |
|
| FIELD=ORIGHIREDT |
, |
,A6YMD |
, |
DESCRIP=ORIGINAL DATE OF HIRE, |
|
| FIELD=WCEVETSTAT |
, |
,A1 |
, |
DESCRIP=WAR CAMP EXP VET STAT, |
|
| FIELD=NUMREGUC |
, |
,P4.1 |
, |
DESCRIP=NUM REGISTERED UNITS-UC, |
|
| FIELD=RETDEVIND |
, |
,A1 |
, |
DESCRIP=RETIRE-FICA DERIV IND, |
|
| FIELD=CARELHRS |
, |
,D9.2 |
, |
DESCRIP=HRS TOWARD CAREER ELIGIBILITY, |
|
| FIELD=BENELHRS |
, |
,D9.2 |
, |
DESCRIP=HRS TOWARD BENEFITS ELIGIBILITY, |
|
| 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=MEDBASCUR |
, |
,F3 |
, |
DESCRIP=MEDICAL CONTRIB BASE CURR
YEAR, |
|
| FIELD=MEDBASNXT |
, |
,F3 |
, |
DESCRIP=MEDICAL CONTRIB BASE NEXT
YEAR, |
|
| FIELD=SEPVETDT |
, |
,A4YM |
, |
DESCRIP=RECENTLY SEPARATED VETERAN
DATE, |
|
| FIELD=HCRAIND |
, |
,A1 |
, |
DESCRIP=HEALTH CARE REIMBUSEMENT
ACCT IND, |
|
| FIELD=HCRAAMT |
, |
,F5 |
, |
DESCRIP=HCRA ANNUAL AMOUNT, |
|
| FIELD=HCRATDT |
, |
,A6YMD |
, |
DESCRIP=HCRA TERMINATION DATE, |
|
| FIELD=HCRAYTD |
, |
,A6YMD |
, |
DESCRIP=HCRA YEAR-TO-DATE DEDUCTION, |
|
| FIELD=STARTPCT |
, |
,F2 |
, |
DESCRIP=START PERCENTAGE, |
|
| FIELD=STARTBEGDT |
, |
,A6YMD |
, |
DESCRIP=START BEGIN DATE, |
|
| FIELD=STARTENDDT |
, |
,A6YMD |
, |
DESCRIP=START END DATE, |
|
| FIELD=FILLEMP |
, |
,A12 |
, |
DESCRIP=FILLER, |
|
| SEGNAME=APPTMT,SEGTYPE=S1,PARENT=IDEMPL, |
|
| FIELD=CTITLE |
, |
,A4 |
, |
DESCRIP=TITLE CODE, |
|
| FIELD=SUBLOC |
, |
,A2 |
, |
DESCRIP=SUBLOCATION, |
|
| 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 - 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 |
,CPERBUNIT |
,A2 |
,INDEX=I, |
DESCRIP=TITLE UNIT CODE, |
|
| FIELD=SALMGTGD |
, |
,A2 |
, |
DESCRIP=SALARY GRADE, |
|
| FIELD=SALSTEP |
, |
,A4 |
, |
DESCRIP=SALARY STEP, |
|
| 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=REP FLAG, |
|
| FIELD=REL99 |
, |
,A2 |
, |
DESCRIP=RELATED 99 TUC, |
|
| FIELD=BARGAIN |
, |
A1 |
, |
DESCRIP=BARGAINING TYPE, |
|
| FIELD=FLSASTAT |
, |
A1 |
, |
DESCRIP=FLSA STATUS CODE, |
|
| 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-BASED APPT. FLAG, |
|
| SEGNAME=DISTRIB,SEGTYPE=S6,PARENT=APPTMT, |
|
| 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=SAU |
, |
,A1 |
, |
DESCRIP=SAU CODE FROM CAMPUS, |
|
| 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=ORGANIZATIONAL UNIT CODE, |
|
| FIELD=ORGUNIT |
, |
,A30 |
, |
DESCRIP=ORGANIZATIONAL UNIT NAME, |
|
| FIELD=CORGGRP |
, |
,A7 |
, |
DESCRIP=ORGANIZATIONAL GROUP CODE, |
|
| FIELD=ORGGRP |
, |
,A30 |
, |
DESCRIP=ORGANIZATIONAL GROUP NAME, |
|
| FIELD=CUASDISC |
, |
,A3 |
, |
DESCRIP=UAS DISCIPLINE CODE, |
|
| FIELD=CNSF |
, |
,A3 |
, |
DESCRIP=NSF CODE, |
|
| FIELD=CORG2 |
, |
,A7 |
, |
DESCRIP=ORGANIZATIONAL TWO CODE, |
|
| FIELD=CORG2NM |
, |
,A30 |
, |
DESCRIP=ORGANIZATIONAL TWO NAME, |
|
| FIELD=ACCTGROUP |
,AGC |
,A06 |
, |
DESCRIP=ACCOUNT GROUP CODE, |
|
| FIELD=FUNDGROUP |
,FGC |
,A06 |
, |
DESCRIP=FUND GROUP CODE, |
|
| FIELD=FUNCTION |
, |
,A2 |
, |
DESCRIP=FUNCTION CODE, |
|
| FIELD=BDGTCODE |
, |
,A1 |
, |
DESCRIP=BUDGETED FUND 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=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, |
|
|
| 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, |
|
SNAPSHOT DATABASE MASTER