GPBR_DEPEND_VW

(SQL View)
 Index Back

Dependents View

Dependents view for Write Array

SELECT A.EMPLID , B.EDUCATION_IND_BRA , A.DEPENDENT_BENEF , B.EFFDT , A.NAME , A.RELATIONSHIP , A.DEP_BENEF_TYPE , A.MAR_STATUS , A.SEX , A.BIRTHDATE , A.DT_OF_DEATH , B.STUDENT_BRA , B.DISABLED_BRA , B.VACCINE_CERT_BRA , B.FAM_ALLOW_TERM_BRA , B.FAM_TERM_DT_BRA FROM PS_DEPENDENT_VW A ,PS_DEP_BEN_EFF_BRA B WHERE A.EMPLID = B.EMPLID AND A.DEPENDENT_BENEF = B.DEPENDENT_BENEF

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
2 EDUCATION_IND_BRA Number(1,0) SMALLINT NOT NULL Dependent - Brazil University or Technical Level

1/0 Table Edit (1=True, 0=False)

Default Value: 0

3 DEPENDENT_BENEF Character(2) VARCHAR2(2) NOT NULL Dependent Benefit
01=default
4 EFFDT Date(10) DATE Effective Date

Default Value: %date

5 NAME Character(50) VARCHAR2(50) NOT NULL Name
6 RELATIONSHIP Character(2) VARCHAR2(2) NOT NULL Relationship to Employee
7 DEP_BENEF_TYPE Character(1) VARCHAR2(1) NOT NULL Dependent Beneficiary Type
B=Beneficiary
C=COBRA Dependent Only
D=Dependent
E=QDRO Estate
N=None
O=Both
Q=QDRO Representative - Employee
R=QDRO Representative -Recipient
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 SEX Character(1) VARCHAR2(1) NOT NULL Gender
F=Female
M=Male
U=Unknown
X=Indeterminate/Intersex/Unspec
10 BIRTHDATE Date(10) DATE Date of Birth
11 DT_OF_DEATH Date(10) DATE Date of Death
12 STUDENT_BRA Number(1,0) SMALLINT NOT NULL Dependents - Brazil Student 1/0

1/0 Table Edit (1=True, 0=False)

Default Value: 0

13 DISABLED_BRA Number(1,0) SMALLINT NOT NULL Dependents - Brazil Disabled 1/0

1/0 Table Edit (1=True, 0=False)

Default Value: 0

14 VACCINE_CERT_BRA Number(1,0) SMALLINT NOT NULL Dependents - Brazil Vaccination Certificate

Default Value: 0

15 FAM_ALLOW_TERM_BRA Character(2) VARCHAR2(2) NOT NULL Family Allowance Termination Code
10=Dependent exceeds ceiling age
20=Child Abandonment
30=Dependent's Death
40=End Disability
50=Court Decision
60=Child Custody
70=Termination
16 FAM_TERM_DT_BRA Date(10) DATE Family Allowance Termination Date Brazil