BAS_STMT_DB_VW (SQL View)	Index Back
Benefits statement dependents

BAS_STMT_DB_VW

(SQL View)

Benefits statement dependents

SELECT BAS_STMT_TYPE , SCHED_ID , EMPLID , BENEFIT_RCD_NBR , EVENT_ID , EFFDT , EFFSEQ , DEPENDENT_BENEF , EVENT_DT , BIRTHDATE , RELATIONSHIP , MAR_STATUS , DEP_BENEF_TYPE FROM PS_BAS_STMT_DEPEN

Parent record: BAS_STMT_SUMM

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 BAS_STMT_TYPE Character(1) VARCHAR2(1) NOT NULL Benefits Statement Type
C=Confirmation Statement
E=Enrollment Preview
S=Submitted Enrollment

2 SCHED_ID Character(6) VARCHAR2(6) NOT NULL Schedule ID

3 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

4 BENEFIT_RCD_NBR Number(3,0) SMALLINT NOT NULL Specifies a sequence number associated with each of multiple concurrent jobs for a one employee. It is used to determine the applicable benefit program for each job. The first job entered for an employee is automatically assigned a Benefit Record Number of zero (0). This field is linked with EMPL_RCD#, the Employment Record Number.

5 EVENT_ID Number(6,0) INTEGER NOT NULL Event Identification

6 EFFDT Date(10) DATE Effective Date
Default Value: %date

7 EFFSEQ Number(3,0) SMALLINT NOT NULL Effective Sequence

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

9 EVENT_DT Date(10) DATE Event Date

10 BIRTHDATE Date(10) DATE Date of Birth

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

12 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

13 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

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	BAS_STMT_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Benefits Statement Type C=Confirmation Statement E=Enrollment Preview S=Submitted Enrollment
2	SCHED_ID	Character(6)	VARCHAR2(6) NOT NULL	Schedule ID
3	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
4	BENEFIT_RCD_NBR	Number(3,0)	SMALLINT NOT NULL	Specifies a sequence number associated with each of multiple concurrent jobs for a one employee. It is used to determine the applicable benefit program for each job. The first job entered for an employee is automatically assigned a Benefit Record Number of zero (0). This field is linked with EMPL_RCD#, the Employment Record Number.
5	EVENT_ID	Number(6,0)	INTEGER NOT NULL	Event Identification
6	EFFDT	Date(10)	DATE	Effective Date Default Value: %date
7	EFFSEQ	Number(3,0)	SMALLINT NOT NULL	Effective Sequence
8	DEPENDENT_BENEF	Character(2)	VARCHAR2(2) NOT NULL	Dependent Benefit 01=default
9	EVENT_DT	Date(10)	DATE	Event Date
10	BIRTHDATE	Date(10)	DATE	Date of Birth
11	RELATIONSHIP	Character(2)	VARCHAR2(2) NOT NULL	Relationship to Employee
12	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
13	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