BN_834_VEND_VW (SQL View)	Index Back
HIPAA 834 Vendor Prompt View Used as a prompt table on the HIPAA 834 EDI run control page to limit the 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_VEND_VW

(SQL View)

HIPAA 834 Vendor Prompt View

Used as a prompt table on the HIPAA 834 EDI run control page to limit the 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 , VENDOR_ID , VENDOR_NAME_SHORT , NAME1 FROM PS_VENDOR WHERE SETID %Concat VENDOR_ID IN ( SELECT DISTINCT A.SETID %Concat A.VENDOR_ID 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 VENDOR_ID Character(10) VARCHAR2(10) NOT NULL Vendor Identifier

3 VENDOR_NAME_SHORT Character(14) VARCHAR2(14) NOT NULL Short Vendor Name

4 NAME1 Character(40) VARCHAR2(40) NOT NULL Name 1

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	SETID	Character(5)	VARCHAR2(5) NOT NULL	SetID
2	VENDOR_ID	Character(10)	VARCHAR2(10) NOT NULL	Vendor Identifier
3	VENDOR_NAME_SHORT	Character(14)	VARCHAR2(14) NOT NULL	Short Vendor Name
4	NAME1	Character(40)	VARCHAR2(40) NOT NULL	Name 1