Field Edits for FCPEMP (Employee) file

In Focus Field Name Order

Data Element FOCUS Field name	Field reference no.	Valid Values
Accidental Death & Dismemberment Coverage Effective Date ADEFFDT	C162	Must be blank or a valid date
Accidental Death & Dismemberment Principal Sum ADPRINSUM	C148	blank, 000, 010, 015, 020, 025, 030, 035, 040, 045, 050, 055, 060, 065, 070, 075, 080, 085, 090, 095, 100, 125, 150, 175, 200, 300, 400, 500
Home Address Disclosure Code ADRDISCIND	C998	Y, N
Armed Forces Service Medal Veteran Code AF_SVC_MEDAL	C1204	blank, M, N
Average Paid Hours Per Week AVGHRSWK	C3330	Must be a valid number
Date of Birth BDATE	C032	Must be a valid date and must be more than 15 years prior to current date
Benefits Eligibility Level Indicator - Assigned BELIASI	C3332	See data dictionary
Benefits Eligibility Level Conflict Date BELICDT	C3331	valid YYMM date
Benefits Eligibility Level Indicator - Derived BELIDER	C3333	See data dictionary
Hours Toward Benefits Eligibility BENELHRS	B5142	Must be blank or numeric
Primary BELI Status Qualification Code BSQ1	BSQ1	blank, 20, 25, 30, 40, 60, 70, and 90
Secondary BELI Status Qualification Code BSQ2	BSQ2	blank, 20, 25, 30, 40, 60, 70, and 90
Primary BELI Status Qualification Effective Date BSQD1	BSQD1	Must be blank or a valid YYMMDD date
Secondary BELI Status Qualification Effective Date BSQD2	BSQD2	Must be blank or a valid YYMMDD date
Accidental Death & Dismemberment Coverage Code CADCVG	C161	blank, F, M, S
Hours Toward Career Status Eligibility-Total CARELHRS	B0426	Must be numeric or blank
Citizenship Status Code - Employee CCITSTAT	C156	See data dictionary
Dental Plan Coverage Code CDENTCVG	C253	blank, U, UA, UC, UAC
Dental Plan Code CDENTPLN	C125	See data dictionary
Employee Organization Code- Dues/Benefits 1,2,3,4 CEMPORG1/2/3/4	C924	Must be in the Employee Organization Table
Employee Relations - Position Type Code CEMPRELPOS	C926	1, 2, 3, 4
Employee Representation Code CEMPREP	C882	C, S, U, ?, *
Employment Status Code CEMPSTAT	C927	A, I, N, P, S
Ethnic Origin Code - Employee CETHNIC	C043	01, 02, 03, 04, 05, 06, 07, 08,09, 10, 11, 12, 13, 14, 15
Federal Tax - Marital Status Code CFMARITAL	C2002	blank, M, S
Handicapped Status Code CHNDCPSTAT	C2801	blank, N, H
Home Department Code CHOMEDEPT	C0114	Must be alphanumeric
Medical Insurance Plan Coverage Code CHPPCVG	C272	See data dictionary
Medical Insurance Plan Code CHPPPLN	C953	See data dictionary
Insurance Reduction Code CINSRED	C893	blank, H, N, Y
Life Insurance Plan Code CLFPLN	C940	blank, 1, 2, 3, 4, F
Legal Plan Code CLGLPLN	C2795	blank, J2, XC, XD
Legal Plan Coverage Code CLGLCVG	C2796	blank, U, UA, UC, UAC
Leave of Absence Type Code CLOATYP	C938	See data dictionary
Temporary Disability Insurance Code - UC-Paid CNDIPLN	C944	blank, A
Compensatory Time Hours Used by Month COMPHOURS	C988	Must be numeric
Compensatory Time Hours Balance COMPHRSBAL	C914	Must be numeric
Retirement System Code CRETSYS	C803	blank, B, F, H, N, O, P, S, U, 1
Separation Reason Code CSEPRSN	C152	See data dictionary
Gender Code CSEX	C100	blank, M, F
State Tax - Marital Status Code CSMARITAL	C2003	blank, H, M, S
UC Student Status Code CUCSTUDENT	C114	1, 2, 3, 4, 5, 6, 7
Veteran Disability Status Code CVETDISAB	C2800	blank, N, S
Veteran Status Code CVETSTAT	C2799	blank, N, V
Vision Plan Coverage Code CVISCVG	C2497	blank, U, UA, UC, UAC
Vision Plan Code CVISPLN	C2495	blank, VI, DV, P5, XX, XC, XD
DCP Fund Selection Code DCPFUND	C4014	blank, Y, N
Opt-out Indicator - Dental DENOPTOUT	C3329	blank, X, D, C
Dental Plan Coverage Effective Date DENTEFFDT	C129	Must be blank or a valid YYMMDD date
Depcare Annual Amount DEPANNAMT	U6335	blank or numeric
Dependent Care Salary Reduction Code DEPCAREPLN	C1850	Y, N
Employee-Paid Disability Salary Base EDISBSAMT	B4067	Must be a valid number
Employee-Paid Disability Coverage Effective Date EDISEFFDT	B4068	Must be blank or a valid YYMMDD date
Employee-Paid Disability Insurance Plan Code EDISPLN	B4065	blank, Y, N
Employee Paid Disability Waiting Period EDISWTPER	B4066	blank, 007, 030, 090, 180
Date of Most Recent Hire EMPDT	C915	Must not be blank and must be a valid date in YYMMDD format
Employee Name EMPNAME	C074	Must not be blank and must contain a comma
Employee Relations - Confidential Info Code EMPRELCONF	C925	Y, N, X
Employee Unit Code EUC	C880	See data dictionary
Life Insurance Salary Base - Executive EXECLFAMT	C3326	Must be numeric
Executive Life Insurance Coverage Effective Date EXECLFEFFDT	B0452	Must be blank or a valid YYMMDD date
Life Insurance Coverage Code - Executive EXECLFPLN	C3325	blank, 2, 0, X
Federal Tax Withholding Allowance Code FEDWTHLD	C3019	Must be numeric
FICA/Medicare Eligibility Code FICADED	C928	E, M, N
Taxable Gross Earnings- Fiscal YTD FTYDFWTG	FYTD	Must be a valid number
Health Care Reimbursement Account Indicator HCRAIND	G6338	blank, Y, or N
Medical Insurance Plan Coverage Effective Date HPPEFFDT	C957	Must be blank or a valid YYMMDD date
Health Care Reimbursement Account Termination Date HCRATTD	T6338	blank or a valid date
Health Care Reimbursement Annual Amount HCRAAMT	U6338	Must be numeric
Health Care Reimbursement Account Deductions Year-to-Date HCRAYTD	Y6338	Must be numeric
Home Department Name HOMEDEPT	B0114	Must be alphanumeric
Life Insurance Salary Base LFBASAMT	C941	Must be numeric
Life Insurance Coverage Amount - UC Paid LFBASAMTUC	C2013	Must be numeric
Dependent Life Insurance Coverage Effective Date LFDEPEFFDT	C3390	Must be blank or a valid YYMMDD date
Dependent Life Insurance Plan Code LFDEPPLN	C147	blank, Y, S, B, C
Life Insurance Coverage Effective Date LFEFFDT	C939	Must be blank or a valid YYMMDD date
UC-Paid Life Insurance Coverage Effective Date LFEFFDTUC	B0451	Must be blank or a valid YYMMDD date
Legal Plan Coverage Effective Date LGLEFFDT	C2797	Must be blank or a valid YYMMDD date
Leave of Absence Begin Date LOABEGDT	C937	Must be blank or a valid YYMMDD date
Leave of Absence Return Date LOARETDT	C158	Must be blank or a valid YYMMDD date
Department Location Indicator LOCIND	C6777	blank, A, B, C, E, J, L, M, P, V
Last Day on Pay Status LPAYDT	C0189	Must be blank or a valid date
Medical Contribution Base-Current Year MEDBASCUR	A6770	blank or numeric
Medical Contribution Base-Next Year MEDBASNXT	A6771	blank or numeric
Opt-out Indicator - Medical MEDOPTOUT	C3328	blank, X, D, C
Merit Percent MERITPCT	C990	Must be numeric
Monthly Earnings-April MONERNAPR	C871	Y, N
Monthly Earnings-August MONERNAUG	C875	Y, N
Monthly Earnings-December MONERNDEC	C879	Y, N
Monthly Earnings-February MONERNFEB	C869	Y, N
Monthly Earnings-January MONERNJAN	C260	Y, N
Monthly Earnings-June MONERNJUN	C873	Y, N
Monthly Earnings-July MONERNJUL	C874	Y, N
Monthly Earnings-March MONERNMAR	C870	Y, N
Monthly Earnings-May MONERNMAY	C872	Y, N
Monthly Earnings-September MONERNSEP	C876	Y, N
Monthly Earnings-October MONERNOCT	C877	Y, N
Monthly Earnings-November MONERNNOV	C878	Y, N
Temporary Disability Insurance-UC-Paid Coverage Effective Date NDIEFFDT	NDID	Must be blank or a valid YYMMDD date
Number of Registered UC Student Units NUMREGUC	B0237	blank or numeric
Original Date of Hire ORIGHIREDT	B0704	Must be a valid YYMMDD date
Overtime Hours Paid by Month OTHOURSPD	C962	Must be numeric
Overtime Hours Worked by Month OTHOURSWK	C948	Must be numeric
Overtime Hours Worked Year-to-Date OTHRSWKYTD	C949	Must be numeric
Permanent Address - City PERMCITY	C901	Must not be blank
Prior Service Months PRSVCMOS	C960	Must be a valid number
Retirement/FICA Derivation Indicator RETDEVIND	B0238	L, N, R, Y, 1,2, 3, 4
Next Salary Review Date SALREVDT	C942	Must not be blank and must be a valid date in MMYY format
Separation Date SEPDT	C992	Must be blank or a valid YYMMDD date
Recently Separated Veteran Date SEPVETDT	A6772	blank or numeric
Sick Leave Hours Used by Month SICKHOURS	C899	Must be numeric
Sick Leave Hours Balance SICKHRSBAL	C972	Must be numeric
SLCG Grade Effective Date SLCG_Eff_Date	C0389	Must be blank or a valid date
SLCG Grade_Code SLCG_Grade	C0388	blank, 102, 103, 104, 105, 106, 107, 108, 109, 110, 111, 112, 113, 114, 115, 116, 117, 118, 999
Social Security Number SOCSECNO	C101	Must be numeric and have each position filled
Special Training Code SPECTRNG	C7005	blank, S
Start Effective Begin Date STARTBEGDT	C0496	Must be blank or greater than or equal to 7/1/2008
Start Effective End Date STARTENDDT	C0496	Must be blank or less than or equal to 6/30/2010
Start Reduction Percentage STARTPCT	C0495	Must be blank or between 10 and 50
Number of State Tax Itemized Deduction Allowances STAWTHITM	C3020	Must be numeric
State Tax Withholding Allowance Code STAWTHLD	C3021	Must be numeric
Unemployment Insurance Coverage Code UNINSCVG	C157	C, N
Vacation Hours Used by Month VACHOURS	C923	Must be numeric
Vacation Hours Balance VACHRSBAL	C983	Must be numeric
Vacation Not Accumulated (Lost) VACHRSLOST	C984	Must be numeric
Visa Type Code VISATYPE	B0110	See CPS data dictionary
Vision Plan Coverage Effective Date VISEFFDT	C2496	Must be blank or a valid YYMMDD date
Opt-out Indicator - Vision VISOPTOUT	C3327	blank, X, D, C
UCRS Voluntary Long Term Loan Plan Code VLPLTERM	C2753	blank, Y, N
UCRS Voluntary Short Term Loan Plan Code VLPSTERM	C2754	blank, Y, N
War/Campaign/Expedition Veteran Status Code WCEVETSTAT	B5123	Must be blank, N, or E
Employee Level WOS Indicator WOS_CODE	B0778	blank, Y, N
Depcare Deduction - Year to Date YTDDEPDE	C3752	Must be a valid number
Taxable Gross Calendar Year to Date YTDFWTGR	C3751	Must be a valid number
Total Gross Calendar Year to Date YTDTOTGR	C3750	Must be a valid number