BN_834_SETID_VW (SQL View)	Index Back
HIPAA 834 SetIDPrompt View Used as a prompt table on the HIPAA 834 EDI run control page to limit the setids of vendors (plan providers) that can be selected to those represented on the Benefits Enrollment Snapshot tables (as long as they are also on the vendor table).

BN_834_SETID_VW

(SQL View)

HIPAA 834 SetIDPrompt View

Used as a prompt table on the HIPAA 834 EDI run control page to limit the setids of vendors (plan providers) that can be selected to those represented on the Benefits Enrollment Snapshot tables (as long as they are also on the vendor table).

SELECT SETID , DESCR FROM PS_SETID_TBL WHERE SETID IN ( SELECT DISTINCT A.SETID FROM PS_BN_SNAP_PLAN A WHERE %Substring(A.PLAN_TYPE, 1, 1) = '1' AND A.COVERAGE_ELECT IN ('E','T'))

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

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

2 DESCR Character(30) VARCHAR2(30) NOT NULL Description

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	SETID	Character(5)	VARCHAR2(5) NOT NULL	SetID
2	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description