BN_834_PAYER_VW

#	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	BN_EDI_PAYER_EIN	Number(9,0)	DECIMAL(9) NOT NULL	Federal Employee Identification Number (FEIN) of the payer (plan provider). Used on the Benefits EDI transactions.
7	BN_NTNL_PROV_ID	Number(10,0)	DECIMAL(10) NOT NULL	National Provider ID
8	BN_EDI_SPONSOR_EIN	Number(9,0)	DECIMAL(9) NOT NULL	Federal Employee Identification Number (FEIN) of the sponsor (company employee works for). Used in the Benefits EDI transmissions.
9	BN_ACTION_CODE	Character(2)	VARCHAR2(2) NOT NULL	File Type Code is stored in this field. Values used are as follows: 2- Update Only File 4- Full File Audit RX- Full File Replacement. Used as a drop down on Create HIPAA EDI file page. 2=Update Only File 4=Full File Audit RX=Full File Replacement
10	BN_SCRTY_RQST	Character(2)	VARCHAR2(2) NOT NULL	Stores the Security Password Request. 0 - Security Password NOT requested. 1 - Security Password requested.
11	BN_SCRTY_PWD	Character(10)	VARCHAR2(10) NOT NULL	Stores the Security Password for HIPAA EDI File
12	BN_MSTR_POLICY_NBR	Character(30)	VARCHAR2(30) NOT NULL	Stores the Master Policy Number for HIPAA 834 EDI file.
13	BN_EDI_TS_ID	Character(30)	VARCHAR2(30) NOT NULL	Transaction Set ID for Benefits EDI transmissions.
14	PLAN_DESCR	Character(40)	VARCHAR2(40) NOT NULL	Plan Description
15	COMPANY_DESCR	Character(30)	VARCHAR2(30) NOT NULL	Company Descr
16	BN_EDI_DATE	Date(10)	DATE	Transmission Date used on the Benefits EDI transactions.
17	BN_EDI_TIME	Character(4)	VARCHAR2(4) NOT NULL	Stores the Time used on the Benefits EDI transactions. Format is HHMM.
18	BN_EDI_TIME_ZN	Character(2)	VARCHAR2(2) NOT NULL	Stores the mapped value of the Time Zone used on the Benefits EDI transactions.
19	BN_834_FL_EFFDT	Date(10)	DATE	Stores File Effective Date for HIPAA EDI File
20	BN_834_FL_ENRLDT	Date(10)	DATE	Stores File Enrollment Date for HIPAA EDI File
21	BN_EDI_NBR_SEGS	Number(10,0)	DECIMAL(10) NOT NULL	Number of segments included in a transaction set on the HIPAA 834 EDI file.
22	BN_EDI_SEP_SEGMENT	Character(1)	VARCHAR2(1) NOT NULL	Delimiter used to separate segments on the Benefits EDI transactions.
23	BN_EDI_SEP_FIELD01	Character(1)	VARCHAR2(1) NOT NULL	Stores the value of the delimiter used to separate fields on the Benefits EDI transactions.
24	BN_EDI_SEP_FIELD02	Character(1)	VARCHAR2(1) NOT NULL	Stores the value of the delimiter used to separate fields on the Benefits EDI transactions.
25	BN_EDI_SEP_FIELD03	Character(1)	VARCHAR2(1) NOT NULL	Stores the value of the delimiter used to separate fields on the Benefits EDI transactions.
26	BN_EDI_SEP_FIELD04	Character(1)	VARCHAR2(1) NOT NULL	Stores the value of the delimiter used to separate fields on the Benefits EDI transactions.
27	BN_EDI_SEP_FIELD05	Character(1)	VARCHAR2(1) NOT NULL	Stores the value of the delimiter used to separate fields on the Benefits EDI transactions.
28	BN_EDI_SEP_FIELD06	Character(1)	VARCHAR2(1) NOT NULL	Stores the value of the delimiter used to separate fields on the Benefits EDI transactions.
29	BN_EDI_SEP_FIELD07	Character(1)	VARCHAR2(1) NOT NULL	Stores the value of the delimiter used to separate fields on the Benefits EDI transactions.
30	BN_EDI_SEP_FIELD08	Character(1)	VARCHAR2(1) NOT NULL	Stores the value of the delimiter used to separate fields on the Benefits EDI transactions.