FISCAL
YEAR DATABASE MASTER
FISCAL
YEAR DATABASE MASTERFILENAME=FY,SUFFIX=FOC,$SR 15121. ADD 13 FLDS. 7/2000;REMOVE ADDR DATA;
| SEGNAME=IDCAMP,SEGTYPE=S1, $ CHG. SEGS, ADD TCS DATA;EMP FIELDS | ||||
| 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=EMPNAME | , | ,A35 | , | DESCRIP=NAME - EMPLOYEE |
| FIELD=SOCSECNO | ,SSN | ,A9 | , | DESCRIP=SOCIAL SECURITY NUMBER |
| FIELD=ADRDISCIND | , | ,A1 | , | DESCRIP=HOME ADDRESS DISCLOSURE CODE |
| 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 |
| FIELD=COP | , | ,A1 | , | DESCRIP=FLAG INDICATING UCOP DANR OR MERC |
| FIELD=MER | ,MERFLG | ,A1 | , | DESCRIP=FLAG INDICATING MERCED |
| 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=ORIGHIREDT | , | ,A6YMD | , | DESCRIP=ORIGINAL DATE OF 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=LFEFFDTUC | , | ,A6YMD | , | DESCRIP=LIFE INS COV EFF DATE - 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=WCEVETSTAT | , | ,A1 | , | DESCRIP=WAR/CAMPAIGN/EXP. VET STATUS CD |
| 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=EXECLFEFFDT | , | ,A6YMD | , | DESCRIP=EXEC LIFE COV EFF DATE |
| FIELD=EXSPINTR | , | ,D12.2 | , | DESCRIP=SPPP TOTAL INT. SR MGMT |
| FIELD=EXSPCONTP | , | ,D13.2 | , | DESCRIP=SPPP TOTAL CONT-INT POSTED |
| FIELD=EXSPCONTNP | , | D13.2 | , | DESCRIP=SPPP TOTAL CONT- NO INT POSTED |
| FIELD=EXSPCONTNP | , | ,D12.2 | , | DESCRIP=SPPP CURRENT MO CONT |
| 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=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 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 | , | ,D13.2C | , | DESCRIP=FISCAL YTD TAXABLE GROSS |
| FIELD=CHOMEDEPT | , HDEPT | ,A6 | , | DESCRIP= HOME DEPARTMENT CODE |
| FIELD=HOMEDEPT | ,NDEPT | ,A30 | , | DESCRIP= HOME DEPARTMENT NAME |
| FIELD=CCOUNTRYRES | , RES | ,A2 | , | DESCRIP= COUNTRY OF RESIDENCE CODE |
| FIELD=COUNTRYRES | , NRES | ,A30 | , | DESCRIP=COUNTRY OF RESIDENCE NAME |
| FIELD=VISATYPE | ,VISA | ,A2 | , | DESCRIP=VISA TYPE CODE |
| FIELD=YTDSEVPAY | ,TOTSEV | ,D13.2C | , | DESCRIP=ACCUMUL YTD SEVERANCE PAY |
| FIELD=FILLEMPL | , | ,A6 | , | 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=SUBLOC | , | ,A2 | , | DESCRIP=SUBLOCATION |
| 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=FILLER | , | ,A2 | , | DESCRIP=, |
| 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=FILLAPPT | , | A4 | , | 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=FROZNFLG | , | ,A1 | , | DESCRIP=FROZEN FLAG |
| FIELD=SOC | , | ,A3 | , | DESCRIP=STANDARD OCCUPATIONAL CLASS. |
| FIELD=REPIND | , | ,A1 | , | DESCRIP=REPRESENTED FLAG |
| FIELD=REL99 | , | ,A2 | , | DESCRIP=RELATED 99 TUC |
| FIELD=BARGAIN | , | ,A1 | , | DESCRIP=BARGAIN TYPE |
| 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 |
| 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=SAU | , | ,A1 | , | DESCRIP=SAU CODE FROM CAMPUS |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 | ||||