BN_DEPEND_WK (SQL Table)	Index Back
Used for managing Depend List This work record is used as the basis for managing a cache of Dependent information for benefit cost calculations. This work record is intended for use in association with SQL BN_CACHE_DEPEND.

BN_DEPEND_WK

(SQL Table)

Used for managing Depend List

This work record is used as the basis for managing a cache of Dependent information for benefit cost calculations. This work record is intended for use in association with SQL BN_CACHE_DEPEND.

Parent record: JOB

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 DEPENDENT_BENEF Character(2) VARCHAR2(2) NOT NULL Dependent Benefit
01=default

2 NAME_DISPLAY Character(50) VARCHAR2(50) NOT NULL Display Name - name formatted for Display based on the Country

3 RELATIONSHIP Character(2) VARCHAR2(2) NOT NULL Relationship to Employee

4 COVERED_PERSON_TYP Character(2) VARCHAR2(2) NOT NULL Covered Person Type: Added fields for Benefits ERISA implementation. Groups relationship codes into categories, i.e. Son, Daughter => Child
AC=Adult Child
CH=Child
DP=Domestic Partner
EE=Employee
NQ=Non-Qualified Dependent
OD=Other Qualified Dependent
SP=Spouse
SS=US Same-Sex Spouse
XS=ExSpouse

5 BIRTHDATE Date(10) DATE Date of Birth

6 SEX Character(1) VARCHAR2(1) NOT NULL Gender
F=Female
M=Male
U=Unknown
X=Indeterminate/Intersex/Unspec

7 SMOKER Character(1) VARCHAR2(1) NOT NULL A flag that indicates whether or not (Y or N) an employee or dependent is a smoker.
N=Non Smoker
Y=Smoker

8 MAR_STATUS Character(1) VARCHAR2(1) NOT NULL Marital Status
C=Common-Law
D=Divorced
E=Separated
H=Head of Household
L=DissDeclLost Civil Partner
M=Married
P=Civil Partnership
S=Single
T=Surviving Civil Partner
U=Unknown
V=Dissolved Civil Partnership
W=Widowed

9 STUDENT Character(1) VARCHAR2(1) NOT NULL Student
N=No
Y=Yes

10 DISABLED Character(1) VARCHAR2(1) NOT NULL A flag that indicates whether or not (Y or N) a dependent is a disabled.
Y/N Table Edit

11 EFFDT Date(10) DATE NOT NULL Effective Date

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	DEPENDENT_BENEF	Character(2)	VARCHAR2(2) NOT NULL	Dependent Benefit 01=default
2	NAME_DISPLAY	Character(50)	VARCHAR2(50) NOT NULL	Display Name - name formatted for Display based on the Country
3	RELATIONSHIP	Character(2)	VARCHAR2(2) NOT NULL	Relationship to Employee
4	COVERED_PERSON_TYP	Character(2)	VARCHAR2(2) NOT NULL	Covered Person Type: Added fields for Benefits ERISA implementation. Groups relationship codes into categories, i.e. Son, Daughter => Child AC=Adult Child CH=Child DP=Domestic Partner EE=Employee NQ=Non-Qualified Dependent OD=Other Qualified Dependent SP=Spouse SS=US Same-Sex Spouse XS=ExSpouse
5	BIRTHDATE	Date(10)	DATE	Date of Birth
6	SEX	Character(1)	VARCHAR2(1) NOT NULL	Gender F=Female M=Male U=Unknown X=Indeterminate/Intersex/Unspec
7	SMOKER	Character(1)	VARCHAR2(1) NOT NULL	A flag that indicates whether or not (Y or N) an employee or dependent is a smoker. N=Non Smoker Y=Smoker
8	MAR_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Marital Status C=Common-Law D=Divorced E=Separated H=Head of Household L=DissDeclLost Civil Partner M=Married P=Civil Partnership S=Single T=Surviving Civil Partner U=Unknown V=Dissolved Civil Partnership W=Widowed
9	STUDENT	Character(1)	VARCHAR2(1) NOT NULL	Student N=No Y=Yes
10	DISABLED	Character(1)	VARCHAR2(1) NOT NULL	A flag that indicates whether or not (Y or N) a dependent is a disabled. Y/N Table Edit
11	EFFDT	Date(10)	DATE NOT NULL	Effective Date