Dependent Data Dictionary

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:

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: