Skip to content

Dependent Data Dictionary

BCSKEY BCSKEY
DEPENDENT COUNT CNTDEP
DEPENDENT COUNT-CHILDREN CNTCHI
DEPENDENT COUNT-OTHER CHILDREN CNTOTH
DEPENDENT COUNT-OVERAGE DEPENDENTS CNTOVER
DEPENDENT DATE OF BIRTH DEPDOB
DEPENDENT DENTAL COVERAGE EFFECTIVE DATE DDENCVGDT
DEPENDENT DISABLED CODE DEPDIS
DEPENDENT LEGAL COVERAGE EFFECTIVE DATE DLGLCVGDT
DEPENDENT MEDICAL COVERAGE EFFECTIVE DATE DMEDCVGDT
DEPENDENT NAME DEPNAME
DEPENDENT OPTICAL COVERAGE EFFECTIVE DATE DVISCVGDT
DEPENDENT RELATION TO EMPLOYEE CODE DEPREL
DEPENDENT SEX CODE DEPSEXCD
DEPENDENT SOCIAL SECURITY NUMBER DEPSSN
EFFECTIVE DATE-DEPENDENT FILE CYCLE
EMPLOYEE SOCIAL SECURITY NUMBER EMPSSN
FCPKEY FCPKEY
IDENTIFICATION NUMBER-DEPENDENT DEPNO
IDENTIFICATION NUMBER-EMPLOYEE DEMPNO 

System Number:

DEP0102

User Access Name:

BCSKEY

Name:

BCSKEY

Type:

ALPHANUMERIC

Length:

11

Format:

N/A

General Description:

Concatenation of CCAMPUS and the Employee id in BCS. Used to match records from DEP to BCS.

Code Interpretation:

N/A

Comments:

Source - PPS

The difference between the EMPNO in BCS and CPS is that BCS accepts the EMPNO the three DOE labs provide as is - 6 numbers with 3 blanks at the end. CPS right-justifies the EMPNO from the three labs and fills the first three positions of EMPNO with zeroes. For example, the EMPNO '636540 ' from BCS will appear in CPS as '000636540'.

Revision Date:

System Number:

DEP0104

User Access Name:

CNTDEP

Name:

DEPENDENT COUNT

Type:

NUMERIC

Length:

4

Format:

N/A

General Description:

The total number of covered dependents the employee has.

Code Interpretation:

N/A

Comments:

Source - Calculated

The total number of dependents will be stored in each of the dependent records for an employee. This field cannot be summed accurately.

Revision Date:

System Number:

DEP0105

User Access Name:

CNTCHI

Name:

DEPENDENT COUNT-CHILDREN

Type:

NUMERIC

Length:

4

Format:

N/A

General Description:

The total number of covered children (natural or adopted, DEPREL="C") the employee has.

Code Interpretation:

N/A

Comments:

Source - Calculated

The total number of children will be stored in each of the dependent records for an employee. This field cannot be summed accurately.

Revision Date:

System Number:

DEP0106

User Access Name:

CNTOTH

Name:

DEPENDENT COUNT-OTHER CHILDREN

Type:

NUMERIC

Length:

4

Format:

N/A

General Description:

The total number of covered "other" children (DEPREL="O") the employee has.

Code Interpretation:

N/A

Comments:

Source - Calculated

The total number of "other" children will be stored in each of the dependent records for an employee. This field cannot be summed accurately.

Revision Date:

System Number:

DEP0107

User Access Name:

CNTOVER

Name:

DEPENDENT COUNT-OVERAGE DEPENDENTS

Type:

NUMERIC

Length:

4

Format:

N/A

General Description:

The total number of overage dependents the employee has.

Code Interpretation:

N/A

Comments:

Source - Calculated

The total number of overage dependents will be stored in each of the dependent records for an employee. This field cannot be summed accurately.

Revision Date:

System Number:

DEP0634

User Access Name:

DEPDOB

Name:

DEPENDENT DATE OF BIRTH

Type:

NUMERIC

Length:

6

Format:

MM/DD/YY

General Description:

The date on which the dependent of the employee was born.

Code Interpretation:

N/A

Comments:

Source - PPS

Revision Date:

System Number:

DEP0640

User Access Name:

DDENCVGDT

Name:

DEPENDENT DENTAL COVERAGE EFFECTIVE DATE

Type:

NUMERIC

Length:

6

Format:

YYMMDD

Code Interpretation:

N/A

General Description:

The date on which insurance coverage with the current dental insurance carrier becomes effective for the
dependent of the employee.

Comments:

Source - PPS

Revision Date:

System Number:

DEP0638

User Access Name:

DEPDIS

Name:

DEPENDENT DISABLED CODE

Type:

ALPHANUMERIC

Length:

1

Format:

N/A

Code Interpretation:

Y - Yes, disabled Child, Stepchild, Other Child, or Child/Grandchild of Domestic Partner

N - No, not disabled

blank - Not disabled, not ineligible for Medicare

I - Ineligible for Medicare (applies to Adult Dependent Relative only)

M - New Mexico Dependent over 23

General Description:

Code indicating whether the dependent of the employee is eligible to be covered for benefits past the usual de-enrollment age.

Comments:

Source - PPS

Changed from Dependent Disabled Code to Dependent De-enrollment Control Code in PPS.

Revision Date:

System Number:

DEP0642

User Access Name:

DLGLCVGDT

Name:

DEPENDENT LEGAL COVERAGE EFFECTIVE DATE

Type:

NUMERIC

Length:

6

Format:

YYMMDD

Code Interpretation:

N/A

General Description:

The date on which insurance coverage with the current legal insurance carrier becomes effective for the dependent of the employee.

Comments:

Source - PPS

Revision Date:

System Number:

DEP0639

User Access Name:

DMEDCVGDT

Name:

DEPENDENT MEDICAL COVERAGE EFFECTIVE DATE

Type:

NUMERIC

Length:

6

Format:

YYMMDD

Code Interpretation:

N/A

General Description:

The date on which medical insurance coverage with the current medical insurance carrier becomes effective for the
dependent of the employee.

Comments:

  • Source - PPS

Revision Date:

System Number:

DEP0633

User Access Name:

DEPNAME

Name:

DEPENDENT NAME

Type:

ALPHANUMERIC

Length:

26

Format:

Last name, comma, first name, space, middle initial. For example: Doe,John A

General Description:

The name of the dependent of the employee.

Code Interpretation:

N/A

Comments:

Source - PPS

Revision Date:

System Number:

DEP0641

User Access Name:

DVISCVGDT

Name:

DEPENDENT OPTICAL COVERAGE EFFECTIVE DATE

Type:

NUMERIC

Length:

6

Format:

YYMMDD

Code Interpretation:

N/A

General Description:

The date on which insurance coverage with the current vision insurance carrier becomes effective for the
dependent of the employee.

Comments:

Source - PPS

Revision Date:

System Number:

DEP0635

User Access Name:

DEPREL

Name:

DEPENDENT RELATION TO EMPLOYEE CODE

Type:

ALPHANUMERIC

Length:

1

Format:

N/A

Code Interpretation:

S Spouse

C Child (natural or adopted)

O Other Child (e.g., foster child)

P Stepchild

W Legal ward

G Grandchild

D Domestic Partner

K Child/Grandchild of Domestic Partner

A Adult Dependent Relative

L Opposite Sex Domestic Partner

N Non Tax-dependent Overage Disabled Child

T Non Tax Dependent Child (natural or adopted)

General Description:

Code indicating the familial relationship of the dependent to the employee.

Comments:

Source - PPS

Revision Date:

10/17/2006

System Number:

DEP0637

User Access Name:

DEPSEXCD

Name:

DEPENDENT SEX CODE

Type:

ALHANUMERIC

Length:

1

Format:

N/A

General Description:

Code identifying the dependent of the employee as male or female.

Code Interpretation:

M - Male

F - Female

blank - unknown

Comments:

Source - PPS

Revision Date:

System Number:

DEP0636

User Access Name:

DEPSSN

Name:

DEPENDENT SOCIAL SECURITY NUMBER

Type:

ALPHANUMERIC

Length:

9

Format:

N/A

Code Interpretation:

N/A

General Description:

The number assigned to the dependent of the employee by the Social Security Administration.

Comments:

Source - PPS

Revision Date:

System Number:

DEP0108

User Access Name:

CYCLE

Name:

EFFECTIVE DATE-DEPENDENT FILE

Type:

ALPHANUMERIC

Length:

5

Format:

MMMYY where 'MMM'=abbreviation for month and 'YY'=last two digits of year. For example, a cycle will appear as 'JUN00'.

General Description:

The effective date of the Dependent file.

Code Interpretation:

N/A

Comments:

Source - System-generated

Revision Date:

System Number:

DEP0101

User Access Name:

EMPSSN

Name:

EMPLOYEE SOCIAL SECURITY NUMBER

Type:

ALPHANUMERIC

Length:

9

Format:

N/A

General Description:

The current number assigned to an individual by the Social Security Administration.

Code Interpretation:

N/A

Comments:

Source - PPS

Revision Date:



System Number:

DEP0103

User Access Name:

FCPKEY

Name:

FCPKEY

Type:

ALPHANUMERIC

Length:

11

Format:

N/A

General Description:

Concatenation of CCAMPUS and the Employee id in CPS. Used to match records from DEP to CPS.

Code Interpretation:

N/A

Comments:

Source - PPS

The difference between the EMPNO in BCS and CPS is that BCS accepts the EMPNO the three DOE labs provide as is - 6 numbers with 3 blanks at the end. CPS right-justifies the EMPNO from the three labs and fills the first three positions of EMPNO with zeroes. For example, the EMPNO '636540 ' from BCS will appear in CPS as '000636540'.

Revision Date:

System Number:

DEP0632

User Access Name:

DEPNO

Name:

IDENTIFICATION NUMBER-DEPENDENT

Type:

ALPHANUMERIC

Length:

2

Format:

N/A

General Description:

A unique number identifying a dependent of the employee.

Code Interpretation:

N/A

Comments:

Source: PPS

Revision Date:

System Number:

DEP0041

User Access Name:

DEMPNO

Name:

IDENTIFICATION NUMBER-EMPLOYEE

Type:

ALPHANUMERIC

Length:

9

Format:

N/A

General Description:

The unique employee identification number.

Code Interpretation:

N/A

Comments:

Source - PPS

Revision Date: