The employee spouse and child/children information for benefits purposes. Attributes include dependent name, birth date, relationship to employee and benefit coverage dates. The data originates from the Employee Data Base (EDB).
The unique dependent number is assigned by the benefits coordinator entering the data
rather than the system.
| Field Name | Business Name | Data Type | Description |
|---|---|---|---|
| DEP_ADC_CODE | DEPENENT ADD/DELETE/CHANGE CODE | VARCHAR2(1) | The code indicating the most recent update activity applied to the associated dependent data.(values are A=add, C=change, or D=delete) |
| DEP_BIRTH_DATE | DEPENDENT BIRTH DATE | DATE | The date on which the dependent of the employee was born. |
| DEP_DENTL_COVEFFDT | DEPENDENT DENTAL COVERAGE DATE | DATE | The date on which dental insurance coverage with the current dental insurance carrier becomes effective for the dependent of the employee. |
| DEP_DISABLED_CODE | DEPENDENT DISABLED CODE | VARCHAR2(1) | The code indicating whether the dependent of the employee (other than spouse) is disabled. (values are Y=yes, N=no, or BLANK=unknown) |
| DEP_HLTH_COVEFFDT | DEPENDENT MEDICAL COVERAGE DATE | DATE | The date on which medical insurance coverage with the current medical insurance carrier becomes effective for the dependent of the employee. |
| DEP_INS_DEENROLL | DEPENDENT INSURANCE DEENROLL FLAG | VARCHAR2(1) | The code indicating that the dependent is to be de-enrolled from insurance coverage(s) because of achieving the de-enrollment age in the current month. (values are D=delete, or BLANK & N=no) |
| DEP_LEGAL_COVEFFDT | DEPENDENT LEGAL COVERAGE DATE | DATE | The date on which legal insurance coverage with the current legal insurance carrier becomes effective for the dependent of the employee. |
| DEP_NAME | DEPENDENT NAME | VARCHAR2(26) | The name of the dependent of the employee. |
| DEP_NUM | UNIQUE DEPENDENT NUMBER | VARCHAR2(2) | A unique number identifying a dependent of the employee. |
| DEP_REL_TO_EMP | RELATIONSHIP TO EMPLOYEE FLAG | VARCHAR2(1) | The code indicating the familial relationship of the dependent to the employee. (values are S=spouse, C=child-natural or adopted, O=other child-foster or grandchild, P=stepchild, or W=legal ward) |
| DEP_SEX_CODE | DEPENDENT SEX | VARCHAR2(1) | The code identifying the dependent of the employee as male or female. (values are M=male, F=female, or BLANK=unknown) |
| DEP_SSN | DEPENDENT SSN | VARCHAR2(9) | The number assigned to the dependent of the employee by the Social Security Administration. |
| DEP_VIS_COVEFFDT | DEPENDENT VISION COVERAGE DATE | DATE | The date on which optical insurance coverage with the current vision insurance carrier becomes effective for the dependent of the employee. |
| EMPLOYEE_ID | EMPLOYEE ID NUMBER | VARCHAR2(9) | The unique employee identification number. |
| Top of this page | Data Dictionary | PPS Main Menu |
Sent Comment to: PPS Data
Warehouse Support
Last Updated: February 5, 1999