Benefits Counseling System Master
Benefits Counseling System Master
FILENAME=BCSFOC, SUFFIX=FOC
| SEGNAME=EMPSEG, SEGTYPE=S1 | ||||
| FIELD=EMPKEY | , | ,A11 | , FIELDTYPE=I | DESCRIP=CONCAT. OF CCAMPUS AND EMPNO
|
| FIELD=EMPNAME | , | ,A35 | , | DESCRIP=EMPLOYEE NAME
|
| FIELD=BDATE | , | ,I6YMD | , | DESCRIP=BIRTH DATE
|
| FIELD=CSEX | , | ,A1 | , | DESCRIP=SEX
|
| FIELD=SOCSECNO | , | ,A9 | , FIELDTYPE=I | DESCRIP=SOCIAL SECURITY NUMBER
|
| FIELD=EMPDT | , | ,I6YMD | , | DESCRIP=DATE OF EMPLOYMENT
|
| FIELD=LOABEGDT | , | ,I6YMD | , | DESCRIP=LEAVE-OF-ABSENCE BEGIN DATE
|
| FIELD=LOARETDT | , | ,I6YMD | , | DESCRIP=LEAVE-OF-ABSENCE RETURN DATE
|
| FIELD=LOATYPE | , | ,A2 | , | DESCRIP=LEAVE-OF-ABSENCE TYPE CODE
|
| FIELD=SEPARDT | , | ,I6YMD | , | DESCRIP=SEPARATION DATE
|
| FIELD=CITIZEN | , | ,A1 | , | DESCRIP=CITIZENSHIP STATUS CODE
|
| FIELD=FICADED | , | ,A1 | , | DESCRIP=FICA ELIGIBILITY CODE
|
| FIELD=CRETSYS | , | ,A1 | , | DESCRIP=RETIREMENT SYSTEM CODE
|
| FIELD=CNDIPLN | , | ,A1 | , | DESCRIP=NDI INSURANCE CODE
|
| FIELD=CFMARITAL | , | ,A1 | , | DESCRIP=MARITAL STATUS CODE - FEDERAL
|
| FIELD=FEDWTHLD | , | ,A3 | , | DESCRIP=FEDERAL TAX WITHHOLDING ALLOW
|
| FIELD=CSMARITAL | , | ,A1 | , | DESCRIP=MARITAL STATUS CODE - STATE TX
|
| FIELD=STAWTHLD | , | ,A3 | , | DESCRIP=STATE TAX WITHHOLDING ALLOW.
|
| FIELD=STAWTHITM | , | ,A3 | , | DESCRIP=STATE TAX WITHHOLD. ITEMIZED
|
| FIELD=CEMPSTAT | , | ,A1 | , | DESCRIP=EMPLOYMENT STATUS CODE
|
| FIELD=CMGTBEN | , | ,A1 | , | DESCRIP=MANAGEMENT BENEFIT CODE
|
| FIELD=UELIGDATE | , | ,I6YMD | , | DESCRIP=UCRS ELIGIBILITY DATE
|
| FIELD=PERMADD1 | , | ,A30 | , | DESCRIP=ADDRESS - PERMANENT - LINE 1
|
| FIELD=PERMADD2 | , | ,A30 | , | DESCRIP=ADDRESS - PERMANENT - LINE 2
|
| FIELD=PERMCITY | , | ,A21 | , | DESCRIP=ADDRESS - PERMANENT - CITY
|
| FIELD=PERMSTATE | , | ,A2 | , | DESCRIP=ADDRESS - PERMANENT - STATE
|
| FIELD=PERMPOST | , | ,A5 | , | DESCRIP=ADDRESS - PERMANENT - ZIP
|
| FIELD=CEUC | , | ,A2 | , | DESCRIP=EMPLOYEE UNIT CODE
|
| FIELD=CDENTAL | , | ,A2 | , | DESCRIP=DENTAL PLAN CODE
|
| FIELD=CDENTCOV | , | ,A3 | , | DESCRIP=DENTAL PLAN COVERAGE CODE
|
| FIELD=DENTEFFDT | , | ,I6YMD | , | DESCRIP=DENTAL PLAN EARN. EFFEC. DATE
|
| FIELD=LFBASAMT | , | ,I3 | , | DESCRIP=LIFE INSURANCE SALARY BASE
|
| FIELD=LFBASAMTUC | , | ,I3 | , | DESCRIP=UC-PAID LIFE INS. SALARY BASE
|
| FIELD=CLFPLN | , | ,A1 | , | DESCRIP=LIFE INSURANCE PLAN CODE
|
| FIELD=LFEFFDT | , | ,I6YMD | , | DESCRIP=LIFE INS. COV. EFFECTIVE DATE
|
| FIELD=LFDEPPLN | , | ,A1 | , | DESCRIP=DEPENDENT LIFE INS. PLAN CODE
|
| FIELD=EXECLFPLN | , | ,A1 | , | DESCRIP=EXEC LIFE ELIG FLAG (PLAN CODE)
|
| FIELD=EXECLFAMT | , | ,I3 | , | DESCRIP=EXEC LIFE INSURANCE SALARY BASE
|
| FIELD=ADPRINSUM | , | ,I3 | , | DESCRIP=AD&D INSURANCE PRINCIPAL SUM
|
| FIELD=CADCVG | , | ,A1 | , | DESCRIP=AD&D COVERAGE CODE
|
| FIELD=ADEFFDT | , | ,I6YMD | , | DESCRIP=AD&D COVERAGE EFFECTIVE DATE
|
| FIELD=CHPPPLN | , | ,A2 | , | DESCRIP=PRIMARY HEALTH PLAN CODE
|
| FIELD=CPHCOVER | , | ,A3 | , | DESCRIP=PRIM HEALTH PLN COVERAGE CODE
|
| FIELD=HPPEFFDT | , | ,I6YMD | , | DESCRIP=PRIM HEALTH PLN COV EFF DATE
|
| FIELD=CERC | , | ,A1 | , | DESCRIP=EMPLOYEE REPRESENTATION CODE
|
| FIELD=CINSRED | , | ,A1 | , | DESCRIP=INSURANCE REDUCTION CODE
|
| FIELD=SICKHRSBAL | , | ,I5 | , | DESCRIP=SICK LEAVE HOURS BALANCE
|
| FIELD=VACHRSBAL | , | ,I5 | , | DESCRIP=VACATION HOURS BALANCE
|
| FIELD=CVISPLN | , | ,A2 | , | DESCRIP=VISION PLAN CODE
|
| FIELD=CVISCVG | , | ,A3 | , | DESCRIP=VISION PLAN COVERAGE CODE
|
| FIELD=VISEFFDT | , | ,I6YMD | , | DESCRIP=VISION PLAN COV. EFFEC. DATE
|
| FIELD=CLGLPLN | , | ,A2 | , | DESCRIP=LEGAL PLAN CODE
|
| FIELD=CLGLCVG | , | ,A3 | , | DESCRIP=LEGAL PLAN COVERAGE CODE
|
| FIELD=LGLEFFDT | , | ,I6YMD | , | DESCRIP=LEGAL PLAN COV. EFFEC. DATE
|
| FIELD=BELIASI | , | ,A1 | , | DESCRIP=BEN ELIG LEVEL IND - ASSIGNED
|
| FIELD=BELIDER | , | ,A1 | , | DESCRIP=BEN ELIG LEVEL IND - DERIVED
|
| FIELD=BELICDT | , | ,I4YM | , | DESCRIP=BEN ELIG IND NON-COMPLIANCE DATE
|
| FIELD=MEDOPTOUT | , | ,A1 | , | DESCRIP=MEDICAL OPT OUT INDICATOR
|
| FIELD=DENOPTOUT | , | ,A1 | , | DESCRIP=DENTAL OPT OUT INDICATOR
|
| FIELD=VISOPTOUT | , | ,A1 | , | DESCRIP=VISION OPT OUT INDICATOR
|
| FIELD=AVGHRSWK | , | ,P6.2 | , | DESCRIP=AVERAGE HOURS PER WEEK
|
| FIELD=USC1PRE | , | ,P8.4 | , | DESCRIP=FILLER
|
| FIELD=USC1POST | , | ,P8.4 | , | DESCRIP=BASIC SERVICE CREDIT
|
| FIELD=USC2PRE | , | ,P8.4 | , | DESCRIP=MT. ZION SERVICE CREDIT
|
| FIELD=USC2POST | , | ,P8.4 | , | DESCRIP=TIER TWO SERVICE CREDIT
|
| FIELD=UCGAVGSAL | , | ,P10.2M | , | DESCRIP=UCRS COV. GROSS 36-MO AVG SALARY
|
| FIELD=UFINALSAL | , | ,P10.2M | , | DESCRIP=UCRS FINAL SALARY
|
| FIELD=USPCONPLN | , | ,A2 | , | DESCRIP=UCRS SPECIAL CONTRIB. PLAN CODE
|
| FIELD=UPRE82SC | , | ,A1 | , | DESCRIP=UCRS PRE-1982 SERVICE CREDIT FLAG
|
| FIELD=URETCODE | , | ,A1 | , | DESCRIP=UCRS RETIREMENT CODE
|
| FIELD=UMEMSTAT | , | ,A1 | , | DESCRIP=UCRS MEMBER STATUS CODE
|
| FIELD=ULIENCODE | , | ,A1 | , | DESCRIP=UCRS LIEN TYPE CODE
|
| FIELD=UECTYCNTRB | , | ,P10.2M | , | DESCRIP=UCRS CURR TAX YTD VLNTRY CNTRB
|
| FIELD=UECMOCNTRB | , | ,P10.2M | , | DESCRIP=UCRS CURRENT MONTH VLNTRY CNTRB
|
| FIELD=UECFYCNTRB | , | ,P10.2M | , | DESCRIP=UCRS CURR FISCAL YTD VLNTRY CNTRB
|
| FIELD=UEPTYCNTRB | , | ,P10.2M | , | DESCRIP=UCRS PRIOR TAX YTD VLNTRY CNTRB
|
| FIELD=UEPFYCNTRB | , | ,P10.2M | , | DESCRIP=UCRS PRIOR FISCAL YTD VLNTRY CNTRB
|
| FIELD=UPRE89TDAC | , | ,P10M | , | DESCRIP=UCRS PRE-1989 TAX DEFERRED ACCUM
|
| FIELD=LFDEPEFFDT | , | ,I6YMD | , | DESCRIP=DEPENDENT LIFE INS. EFFECT DATE
|
| FIELD=EDISPLN | , | ,A1 | , | DESCRIP=EMP PD DISABIL INSUR PLAN CODE
|
| FIELD=EDISWTPER | , | ,I3 | , | DESCRIP=EPD WAITING PERIOD
|
| FIELD=EDISBSAMT | , | ,I5 | , | DESCRIP=EPD INSURANCE SALARY BASE
|
| FIELD=EDISEFFDT | , | ,I6YMD | , | DESCRIP=EPD INS. COVERAGE EFFEC. DATE
|
| FIELD=NDIEFFDT | , | ,I6YMD | , | DESCRIP=UC PD TEMP DIS COV. EFF. DATE
|
| FIELD=DISELEARN | , | ,I5 | , | DESCRIP=DISABILITY BENEFIT ELIG EARN
|
| FIELD=BELISQC1 | , | ,A2 | , | DESCRIP=BELI PRIM STAT. QUALIFIER CODE
|
| FIELD=BELISQCDT1 | , | ,I6YMD | , | DESCRIP=BELI PRIM STAT. QUALIFIER DATE
|
| FIELD=BELISQC2 | , | ,A2 | , | DESCRIP=BELI SEC. STAT. QUALIFIER CODE
|
| FIELD=BELISQCDT2 | , | ,I6YMD | , | DESCRIP=BELI SEC. STAT. QUALIFIER DATE
|
| FIELD=TRIPPCT | , | ,I2 | , | DESCRIP=TRIP PERCENT
|
| FIELD=TRIPPER | , | ,I2 | , | DESCRIP=TRIP DURATION
|
| FIELD=TRIPBGDT | , | ,A2 | , | DESCRIP=TRIP BEGIN MONTH |
| FIELD =PLNCHGDTE | , | ,I6YMD | ||
| FIELD =PLNANNLMT | , | ,P8.2 | ||
| SEGNAME=SEVPAY, SEGTYPE=U, PARENT=EMPSEG | ||||
| FIELD=EXSPCONTP | , | ,P10.2M | , | DESCRIP=EXEC SEV PAY CONTRIB WITH INT
|
| FIELD=EXSPINTR | , | ,P10.2M | , | DESCRIP=EXEC SEV PAY TOTAL INTEREST
|
| FIELD=EXSPPOSTDT | , | ,I6YMD | , | DESCRIP=EXEC SEV PAY INT POSTING DATE
|
| FIELD=EXSPCONTNP | , | ,P10.2M | , | DESCRIP=EXEC SEV PAY CONT WITHOUT INT
|
| FIELD=EXSPCMCONT | , | ,P10.2M | , | DESCRIP=EXEC SEV PAY CURRENT MON CONT
|
| FIELD=HSSPCONTP | , | ,P10.2M | , | DESCRIP=HEALTH SC PAY CONTRIB WITH INT
|
| FIELD=HSSPINTR | , | ,P10.2M | , | DESCRIP=HEALTH SC PAY TOTAL INTEREST
|
| FIELD=HSSPPOSTDT | , | ,I6YMD | , | DESCRIP=HEALTH SC PAY INT POSTING DATE
|
| FIELD=HSSPCONTNP | , | ,P10.2M | , | DESCRIP=HEALTH SC PAY CONT WITHOUT INT
|
| FIELD=HSSPCMCONT | , | ,P10.2M | , | DESCRIP=EXEC SEV PAY CURRENT MON CONT
|
| SEGNAME=APPTSEG, SEGTYPE=S1, PARENT=EMPSEG | ||||
| FIELD=APPTNO | , | ,A2 | , | DESCRIP=APPOINTMENT NUMBER
|
| FIELD=APTBEGDT | , | ,I6YMD | , | DESCRIP=APPOINTMENT BEGIN DATE
|
| FIELD=APTENDDT | , | ,I6YMD | , | DESCRIP=APPOINTMENT END DATE
|
| FIELD=CTITLE | , | ,A4 | , | DESCRIP=TITLE CODE
|
| FIELD=APTPCT | , | ,P6.4 | , | DESCRIP=TIME APPOINTMENT (ANTICIPATED)
|
| FIELD=CTTLSH | , | ,A1 | , | DESCRIP=TITLE SPECIAL HANDLING CODE
|
| FIELD=CAPTREP | , | ,A1 | , | DESCRIP=APPOINTMENT REPRESENT. CODE
|
| FIELD=CAPTTYP | , | ,A1 | , | DESCRIP=APPOINTMENT TYPE CODE - PPS
|
| FIELD=CSPECBEN | , | ,A1 | , | DESCRIP=SPECIAL BENEFITS CONT. CODE
|
| FIELD=TUC | , | ,A2 | , | DESCRIP=TITLE UNIT CODE (TUC)
|
| FIELD=CDISTIND | , | ,A1 | , | DESCRIP=C-DISTRIBUTION INDICATOR
|
| FIELD=MONGRS | , | ,P10.2M | , | DESCRIP=MONTHLY AVERAGE GROSS SALARY .
|
| FIELD=ACTCVGROSS | , | ,P10.2M | , | DESCRIP=ACTUAL MONTHLY COV. GROSS SAL.
|
| FIELD=FTEFRAC | , | ,P6.4 | , | DESCRIP=TIME-WORKED FRACTION
|
| FIELD=SCACCRATE | , | ,P6.4 | , | DESCRIP=SERVICE CREDIT ACCRUAL RATE
|
| FIELD=LSCVGROSS | , | ,P10.2M | , | DESCRIP=LUMP SUM MON. COV. GROSS SAL.
|
| FIELD=CWOS | , | ,A1 | , | DESCRIP=WITHOUT SALARY CODE
|
| FIELD=CTIMRPTG | , | ,A1 | , | DESCRIP=TIME REPORTING CODE
|
| FIELD=CPAYSCHED | , | ,A1 | , | DESCRIP=PAY SCHEDULE CODE (PAR)
|
| SEGNAME=ACCTSEG, SEGTYPE=S1, PARENT=EMPSEG | ||||
| FIELD=UPLANCODE | , | ,A2 | , | DESCRIP=UCRS PLAN CODE
|
| FIELD=UPRICONT | , | ,P10.2M | , | DESCRIP=PRIOR YEARS ACTIVITY
|
| FIELD=UPRIINTR | , | ,P10.2M | , | DESCRIP=PRIOR YEARS INTEREST/GAIN/LOSS
|
| FIELD=UPRIUNIT | , | ,P10.3 | , | DESCRIP=PRIOR YEARS UNITS
|
| FIELD=UCURCONT | , | ,P10.2M | , | DESCRIP=CURRENT YEAR ACTIVITY
|
| FIELD=UCURINTR | , | ,P10.2M | , | DESCRIP=CURRENT YEAR INTEREST/GAIN/LOSS
|
| FIELD=UCURUNIT | , | ,P10.3 | , | DESCRIP=CURRENT YEAR UNITS
|
| FIELD=UPLANAMD | , | ,P10.2M | , | DESCRIP=AVERAGE MONTHLY DEDUCTION
|
| FIELD=UPLANCMD | , | ,P10.2M | , | DESCRIP=CURRENT MONTHLY DEDUCTION
|
| FIELD=UFYCNTRB | , | ,P10.2M | , | DESCRIP=LAST FISCAL YEAR ACTIVITY
|
| FIELD=UFYCURBAL | , | ,P10.2M | , | DESCRIP=LAST FISCAL YEAR CURRENT BAL.
|
| FIELD=UPAYCYCL | , | ,A1 | , | DESCRIP=UCRS DEDUCTION PAY CYCLE TYPE
|
| FIELD=UPLANPPD | , | ,P10.2M | , | DESCRIP=DEDUCTION PER PAY PERIOD
|
| FIELD=UCURCONT1 | , | ,P10.2M | , | DESCRIP=CURRENT YEAR CONTRIBUTIONS
|
| SEGNAME=LOANSEG, SEGTYPE=S1, PARENT=EMPSEG | ||||
| FIELD=ULNID | , | ,A6 | , | DESCRIP=UCRS LOAN I.D.
|
| FIELD=ULNORIGDT | , | ,I6YMD | , | DESCRIP=LOAN ORIGINATION DATE
|
| FIELD=ULNTYPE | , | ,A1 | , | DESCRIP=LOAN TYPE (SHORT/LONG)
|
| FIELD=ULNAMT | , | ,P10.2M | , | DESCRIP=ORIGINAL LOAN AMOUNT
|
| FIELD=ULNINTRTOT | , | ,P6.2 | , | DESCRIP=LOAN INTEREST RATE (TOTAL)
|
| FIELD=ULNINTRSVC | , | ,P6.2 | , | DESCRIP=LOAN INTEREST RATE (SVC. FEE)
|
| FIELD=ULNTERM | , | ,I3 | , | DESCRIP=LOAN TERM (MONTHS)
|
| FIELD=ULNPYMNT | , | ,P10.2M | , | DESCRIP=MONTHLY PAYMENT AMOUNT
|
| FIELD=ULNREFI | , | ,A1 | , | DESCRIP=REFINANCE STATUS FLAG
|
| FIELD=ULNCURBAL | , | ,P10.2M | , | DESCRIP=CURRENT BALANCE
|
| FIELD=ULNCLYRINT | , | ,P10.2M | , | DESCRIP=CALENDAR YEAR INTEREST PAID
|
| FIELD=ULNFRESAV | , | ,P5.1 | , | DESCRIP=PCT BORROWED F/ EMP SAVINGS
|
| FIELD=ULNFREBND | , | ,P5.1 | , | DESCRIP=PCT BORROWED F/ EMP BOND FUND
|
| FIELD=ULNFREEQU | , | ,P5.1 | , | DESCRIP=PCT BORROWED F/ EMP EQUITY FN
|
| FIELD=ULNFREGIC | , | ,P5.1 | , | DESCRIP=PCT BORROWED F/ EMP GIC FUND
|
| FIELD=ULNFREMNY | , | ,P5.1 | , | DESCRIP=PCT BORROWED F/ EMP MNY MKT
|
| FIELD=ULNFREMAF | , | ,P5.1 | , | DESCRIP=PCT BORROWED F/ EMP MULT ASSET
|
| FIELD=ULNFRRSV1 | , | ,P5.1 | , | DESCRIP=PCT BORROWED F/ (reserve 1)
|
| FIELD=ULNFRRSV2 | , | ,P5.1 | , | DESCRIP=PCT BORROWED F/ (reserve 2)
|
| FIELD=ULNFRRSV3 | , | ,P5.1 | , | DESCRIP=PCT BORROWED (reserve 3)
|
| FIELD=ULNFRRSV4 | , | ,P5.1 | , | DESCRIP=PCT BORROWED (reserve 4)
|
| FIELD=ULNLRPESAV | , | ,P10.2M | , | DESCRIP=LAST RPMNT AMT TO EMP SAVINGS
|
| FIELD=ULNLRPEBND | , | ,P10.2M | , | DESCRIP=LAST RPMNT AMT TO EMP BOND FND
|
| FIELD=ULNLRPEEQU | , | ,P10.2M | , | DESCRIP=LAST RPMNT AMT TO EMP EQUITY
|
| FIELD=ULNLRPEGIC | , | ,P10.2M | , | DESCRIP=LAST RPMNT AMT TO EMP GIC FUND
|
| FIELD=ULNLRPEMNY | , | ,P10.2M | , | DESCRIP=LAST RPMNT AMT TO EMP MNY MKT
|
| FIELD=ULNLRPEMAF | , | ,P10.2M | , | DESCRIP=LAST RPMNT AMT TO EMP MUL ASSE
|
| FIELD=ULNLRPRSV1 | , | ,P10.2M | , | DESCRIP=LAST RPMNT AMT (reserve 1)
|
| FIELD=ULNLRPRSV2 | , | ,P10.2M | , | DESCRIP=LAST RPMNT AMT (reserve 2)
|
| FIELD=ULNLRPRSV3 | , | ,P10.2M | , | DESCRIP=LAST RPMNT AMT (reserve 3)
|
| FIELD=ULNLRPRSV4 | , | ,P10.2M | , | DESCRIP=LAST RPMNT AMT (reserve 4)
|
| FIELD=ULNLDPMNT | , | ,I6YMD | , | DESCRIP=LAST DATE OF REPAYMENT
|
| FIELD=ULNSVCFEE | , | ,P10.2M | , | DESCRIP=SERVICE FEE AMOUNT
|
| FIELD=ULNAVNLAMT | , | ,P10.2M | , | DESCRIP=AVAILABLE NEW LOAN AMOUNT
|
| FIELD=ULNAVRFAMT | , | ,P10.2M | , | DESCRIP=AVAILABLE LOAN REFINANCE AMT
|
| FIELD=ULNHBAL12 | , | ,P10.2M | , | DESCRIP=HIGHEST BAL. W/IN LAST 12 MO.
|
| FIELD=ULNDTFINAL | , | ,I6YMD | , | DESCRIP=FINAL INSTALLMENT DATE
|
| FIELD=ULNCURPMNT | , | ,P10.2M | , | DESCRIP=CURRENT FISCAL YEAR REPAYMENTS
|
| FIELD=ULNSTATUS | , | ,A1 | , | DESCRIP=LOAN STATUS
|
| FIELD=ULNSTATDT | , | ,I6YMD | , | DESCRIP=LOAN STATUS DATE |