BN_834_STDNT_VW (SQL View)	Index Back
Student View View to get Non-Disabled & Non-Spouse & Non-Domestic Partner Adult Dependents from Member Staging Table

BN_834_STDNT_VW

(SQL View)

Student View

View to get Non-Disabled & Non-Spouse & Non-Domestic Partner Adult Dependents from Member Staging Table

SELECT DISTINCT PROCESS_INSTANCE , EMPLID , DEPENDENT_BENEF , BIRTHDATE , BENEFIT_PROGRAM , STUDENT FROM PS_BN_834_MEMBER WHERE DEPENDENT_BENEF <> ' ' AND DISABLED = 'N' AND BN_834_DEPEND_IND = 'N' AND RELATIONSHIP NOT IN ('SP', 'NA', 'SS')

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance

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

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

4 BIRTHDATE Date(10) DATE Date of Birth

5 BENEFIT_PROGRAM Character(3) VARCHAR2(3) NOT NULL Defines a collection of benefit plans and their associated rate and calculation rules.

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

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
2	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
3	DEPENDENT_BENEF	Character(2)	VARCHAR2(2) NOT NULL	Dependent Benefit 01=default
4	BIRTHDATE	Date(10)	DATE	Date of Birth
5	BENEFIT_PROGRAM	Character(3)	VARCHAR2(3) NOT NULL	Defines a collection of benefit plans and their associated rate and calculation rules.
6	STUDENT	Character(1)	VARCHAR2(1) NOT NULL	Student N=No Y=Yes