BN_834_MBRSCHVW (SQL View)	Index Back
Member Search View Member Search View used to create rowsets in many places in BN_834_HIPAA application engine.

BN_834_MBRSCHVW

(SQL View)

Member Search View

Member Search View used to create rowsets in many places in BN_834_HIPAA application engine.

SELECT DISTINCT PROCESS_INSTANCE , SETID , VENDOR_ID , COMPANY , BN_EDI_TRANS_NBR , EMPLID , BENEFIT_RCD_NBR , COBRA_EVENT_ID , DEPENDENT_BENEF FROM PS_BN_834_MEMBER

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

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

2 SETID Character(5) VARCHAR2(5) NOT NULL SetID

3 VENDOR_ID Character(10) VARCHAR2(10) NOT NULL Vendor Identifier

4 COMPANY Character(3) VARCHAR2(3) NOT NULL Company

5 BN_EDI_TRANS_NBR Character(9) VARCHAR2(9) NOT NULL Transaction Set Number

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

7 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.

8 COBRA_EVENT_ID Number(3,0) SMALLINT NOT NULL Uniquely identifies a COBRA event within an employee's benefits records, and is system-generated.

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

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
2	SETID	Character(5)	VARCHAR2(5) NOT NULL	SetID
3	VENDOR_ID	Character(10)	VARCHAR2(10) NOT NULL	Vendor Identifier
4	COMPANY	Character(3)	VARCHAR2(3) NOT NULL	Company
5	BN_EDI_TRANS_NBR	Character(9)	VARCHAR2(9) NOT NULL	Transaction Set Number
6	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
7	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.
8	COBRA_EVENT_ID	Number(3,0)	SMALLINT NOT NULL	Uniquely identifies a COBRA event within an employee's benefits records, and is system-generated.
9	DEPENDENT_BENEF	Character(2)	VARCHAR2(2) NOT NULL	Dependent Benefit 01=default