Skip to content
  1. Home > Subject Areas > Group Consistency Edits for FCPEMP file

Group Consistency Edits for FCPEMP file

In Group Error Number Order

Group Error no. Field Ref nos. Description of edit
101 C148, C161, C162 If the employee is covered by AD&D insurance, CADCVG (C161) should not be blank, ADPRINSUM (C148) should not be 0, and ADEFFDT (C162) should not be blank.

If the employee does not have AD&D coverage, CADCVG should be blank, ADPRINSUM should be 0, and ADEFFDT should be blank.
102 C125, C129, C253 If the employee is covered by dental insurance, then CDENTPLN (C125) should not be blank, DENTEFFDT (C129) should not be blank and CDENTCVG (C253) should not be blank.

If the employee is not covered by dental insurance, then CDENTPLN should be blank, DENTEFFDT should be blank and CDENTCVG should be blank.
104 C272, C953, C957 If the employee is covered by medical insurance, CHPPCVG (C272) should not be blank, CHPPPLN (C953) should not be blank and HPPEFFDT (C957) should not be blank.

If the employee is not covered by medical insurance, CHPPCVG should be blank, CHPPPLN should be blank and HPPEFFDT should be blank.
107 C803, C944 If the employee is covered by a retirement plan other than Safe Harbor, CRETSYS (C803) should not be blank, "N", or "H" and CNDIPLN (C944) should not be blank.

If the employee is not covered by a retirement plan other than Safe Harbor (CRETSYS is blank, "N", or "H"), CNDIPLN should be blank.
108 C903, C904 Either PERMADR1 (C903) or PERMADR2 (C904) must not be blank.
109 C158, C927, C937, C938 If an employee is on a paid or unpaid leave of absence, CEMPSTAT (C927) should be "N" or "P", LOABEGDT (C937), LOARETDT (C158), and CLOATYP (C938) should not be blank.

If CEMPSTAT is not "N" or "P", LOABEGDT, LOARETDT, and CLOATYP should all be blank.
110 C152, C927, C992 If an employee is separated, CEMPSTAT (C927) should be "S", and CSEPRSN (C152) and SEPDT (C992) should not be blank.
111 C925, C926 If the employee has a position type which is likely to be deemed "confidential" – CEMPRELPOS (C926) is "1" (Manager), "2" (Supervisor), or "3" (Other), EMPRELCONF (C925) should be "Y" or "N".

If CEMPRELPOS is "4" (out-of-state), EMPRELCONF should be "X" (Does not apply).
112 C2496, C2495, C2497 If the employee is covered by vision insurance, then CVISPLN (C2495) should not be blank, VISEFFDT (C2496)should not be blank and CVISCVG (C2497) should not be blank.

If the employee is not covered by vision insurance, then CVISPLN should be blank, VISEFFDT should be blank and CVISCVG should be blank.
113 C2797, C2795, C2796 If the employee is covered by legal insurance, then CLGLPLN (C2795) should not be blank, LGLEFFDT (C2797) should not be blank and CLGLCVG (C2796) should not be blank.

If the employee is not covered by legal insurance, then CLGLPLN should be blank, LGLEFFDT should be blank and CLGLCVG should be blank.
114 C021, B4069 The employee's primary title code, PRITPPS (B4069) must not be blank and must be in the campus title code table.
116 C803, B4065 If the employee is covered by a retirement plan other than Safe Harbor, then CRETSYS (C803) should not be blank, "N", or "H, and EDISPLN (B4065) should not be blank.

If the employee is not covered by a retirement plan or is covered by Safe Harbor, CRETSYS should be blank, "N", or "H", and EDISPLN should be blank or "N".
118 B0704, C915 The ORIGHIREDT (B0704) should be earlier than or the same as the most recent hire date - EMPDT (C915).
119 B0451, B0704 If the employee is covered by UC-paid life insurance, LFEFFDTUC (B0451) should not be blank and ORIGHIREDT (B0704) should be earlier than or equal to LFEFFDTUC.
120 C4307, C4306 If the Home Department Code (C0114) is not blank, then the Home Department Name (B0114) should also be non-blank.
121 C0143, C156 If the employee is a resident of a foreign country, CCOUNTRYRES (C0143) should not be blank and CCITSTAT (C156) should be "E", "N", "X", "F", "P", "R", or "S".

If the employee is not a resident of a foreign country, CCOUNTRYRES should be blank and CCITSTAT should be "C" or "R" (a CCITSTAT of "R" does not require that Country of Residency be blank since some Permanent Residents are only residents for tax purposes, not citizenship purposes).
122 B0110, B156 If the employee holds a visa, VISATYPE (B0110) should not be blank and CCITSTAT (C156) should be "E", "N", "X", F, "P", "R", or "S".  A Permanent Resident (CCITSTAT=R) does not necessarily have to have a Visatype of "PR".

If the employee does not have a visa, VISATYPE should be blank and CCITSTAT should be "C".
123 B0452, B3325 If the employee is covered by Executive Life Insurance, then EXECLFEFFDT (B0452) should not be blank and EXECLFPLN(B3325) should be "2" or "3".

If the employee is not covered by Executive Life Insurance, then EXECLFEFFDT should be blank and EXECLFPLN should be blank, "0", "X", or "*".
124 B0451, C2013 If the employee is covered by UC-paid life insurance, LFEFFDTUC (B0451) should not be blank and LFBSAMTUC (C2013) should be greater than 0.
125 BSQ1, BSQD1

If the Primary BELI Status Qualification Code (BSQ1) is not blank, then the Primary BELI Status Qualification Date (BSQD1) should also not be blank.
126 BSQ2, BSQD2

If the Secondary BELI Status Qualification Code (BSQ2) is not blank, then the Secondary BELI Status Qualification Date (BSQD2) should also not be blank.
127 C1850, C3752

If the employee is enrolled in the DEPCARE program, the Dependent Care Salary Reduction Plan Code (C1850) should not be blank or "N", and the Year to Date Dependent Care Deduction  amount (C3752) should be greater than zero.
128 U6338, G6338

If the employee is enrolled in HCRA, the Health Care Reimbursement Account Indicator (G6338) should not be blank or "N", and the Health Care Reimbursement Annual Amount (U6338) should be greater than zero.
129 C0495, C0496, C0497 If the employee is enrolled in the START program, START Reduction Percentage (C0495) should not be blank or 0, and the START Begin Date(C0496) and the START End Date (C0497) should not be blank.
130 C1850, U6335 If the employee is enrolled in the DEPCARE program, the Dependent Care Salary Reduction Plan Code (C1850) should not be blank or "N", and the DEPCARE Annual Amount (C6335) should be greater than zero.
131 C992, D6335 If the employee is separated, the Separation Date (C992) should contain a valid date, and the DEPCARE Termination Date  (D6335) should contain a valid date.
132 C3332, C3333, C4069 If the employee is eligible for Postdoc benefits, either the Benefits Eligibility Level Indicator-Assigned (C3332) or the Benefits Eligibility Level Indicator-Derived (C3333) should equal "P", and the Title Code Primary Appointment-PPS  (C4069) should equal "3252", "3253", or "3254".
133 C3332, C3333, C0953 If the employee is eligible for Postdoc benefits, either the Benefits Eligibility Level Indicator-Assigned (C3332) or the Benefits Eligibility Level Indicator-Derived (C3333) should equal "P", and the Medical Insurance Plan Code  (C0953) should equal blank, "P1" or "P2".
134 C3332, C3333, C0125 If the employee is eligible for Postdoc benefits, either the Benefits Eligibility Level Indicator-Assigned (C3332) or the Benefits Eligibility Level Indicator-Derived (C3333) should equal "P", and the Dental Plan Code  (C0125) should equal blank, "P3" or "P4".
135 C3332, C3333, C2495 If the employee is eligible for Postdoc benefits, either the Benefits Eligibility Level Indicator-Assigned (C3332) or the Benefits Eligibility Level Indicator-Derived (C3333) should equal "P", and the Vision Plan Code  (C2495) should equal blank or "P5".
136 C3332, C3333, C1850 If the employee is eligible for Postdoc benefits, either the Benefits Eligibility Level Indicator-Assigned (C3332) or the Benefits Eligibility Level Indicator-Derived (C3333) should equal "P", and the Dependent Care Salary Reduction Plan Code (C1850) should be blank or "N".
137 C3332, C3333, G6338 If the employee is eligible for Postdoc benefits, either the Benefits Eligibility Level Indicator-Assigned (C3332) or the Benefits Eligibility Level Indicator-Derived (C3333) should equal "P", and the Health Care Reimbursement Account Indicator (G6338) should be blank or "N".
138 C3332, C3333, B4065 If the employee is eligible for Postdoc benefits, either the Benefits Eligibility Level Indicator-Assigned (C3332) or the Benefits Eligibility Level Indicator-Derived (C3333) should equal "P", and the Employee Paid Disability Insurance Plan Code (B4065) should be blank or "N".
139 C3332, C3333, C147 If the employee is eligible for Postdoc benefits, either the Benefits Eligibility Level Indicator-Assigned (C3332) or the Benefits Eligibility Level Indicator-Derived (C3333) should equal "P", and the Dependent Life Insurance Plan Code (C147) should be blank.
140 C3332, C3333, C940 If the employee is eligible for Postdoc benefits, either the Benefits Eligibility Level Indicator-Assigned (C3332) or the Benefits Eligibility Level Indicator-Derived (C3333) should equal "P", and the Life Insurance Plan Code (C940) should be blank.
141 C3332, C3333, C161 If the employee is eligible for Postdoc benefits, either the Benefits Eligibility Level Indicator-Assigned (C3332) or the Benefits Eligibility Level Indicator-Derived (C3333) should equal "P", and the Accidental Death and Dismemberment Coverage Code   (C161) should be blank or "N".
142 C3332, C3333, C2795 If the employee is eligible for Postdoc benefits, either the Benefits Eligibility Level Indicator-Assigned (C3332) or the Benefits Eligibility Level Indicator-Derived (C3333) should equal "P", and the Legal Plan Code  (C2795) should be blank.
143 C0388, C0389 If the employee is a member of the Senior Leadership Compensation Group, the SLCG Grade Code (C0388) should be populated and the SLCG Grade Effective Date (C0389) should not be blank or zeroes.
200 C032 The employee's BDATE (C032) should be greater than 15 years prior to the current date.