BN_834_PAYER

#	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_EDI_TS_ID	Character(30)	VARCHAR2(30) NOT NULL	Transaction Set ID for Benefits EDI transmissions.
11	COMPANY_DESCR	Character(30)	VARCHAR2(30) NOT NULL	Company Descr
12	PLAN_DESCR	Character(40)	VARCHAR2(40) NOT NULL	Plan Description
13	BN_EDI_DATE	Date(10)	DATE	Transmission Date used on the Benefits EDI transactions.
14	BN_EDI_TIME	Character(4)	VARCHAR2(4) NOT NULL	Stores the Time used on the Benefits EDI transactions. Format is HHMM.
15	BN_EDI_TIME_ZN	Character(2)	VARCHAR2(2) NOT NULL	Stores the mapped value of the Time Zone used on the Benefits EDI transactions.
16	ASOFDATE	Date(10)	DATE	As of Date
17	BN_834_FL_EFFDT	Date(10)	DATE	Stores File Effective Date for HIPAA EDI File
18	BN_834_FL_ENRLDT	Date(10)	DATE	Stores File Enrollment Date for HIPAA EDI File
19	BN_SCRTY_RQST	Character(2)	VARCHAR2(2) NOT NULL	Stores the Security Password Request. 0 - Security Password NOT requested. 1 - Security Password requested.
20	BN_SCRTY_PWD	Character(10)	VARCHAR2(10) NOT NULL	Stores the Security Password for HIPAA EDI File
21	BN_MSTR_POLICY_NBR	Character(30)	VARCHAR2(30) NOT NULL	Stores the Master Policy Number for 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_FIELD	Character(1)	VARCHAR2(1) NOT NULL	Delimiter used to separate fields on the Benefits EDI transactions.
24	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.
25	BN_834_NBR_SEG_INS	Number(10,0)	DECIMAL(10) NOT NULL	Stores the count of the INS segments in a transaction set on the HIPAA 834 EDI file.
26	BN_834_NBR_SEG_SUB	Number(10,0)	DECIMAL(10) NOT NULL	Number of Subscribers
27	BN_834_NBR_SEG_DTP	Number(10,0)	DECIMAL(10) NOT NULL	No. of DTP 338 & 339 segments
28	BN_834_NBR_SEG_NM1	Number(10,0)	DECIMAL(10) NOT NULL	Stores the count of the NM1 segments in a transaction set on the HIPAA 834 EDI file.
29	BN_834_NBR_SEG_PER	Number(10,0)	DECIMAL(10) NOT NULL	Stores the count of the PER (phone) segments in a transaction set on the HIPAA 834 EDI file.
30	BN_834_NBR_SEG_N3H	Number(10,0)	DECIMAL(10) NOT NULL	Stores the count of the N3 (home address) segments in a transaction set on the HIPAA 834 EDI file.
31	BN_834_NBR_SEG_N4H	Number(10,0)	DECIMAL(10) NOT NULL	Stores the count of the N4 (home address) segments in a transaction set on the HIPAA 834 EDI file.
32	BN_834_NBR_SEG_OTH	Number(10,0)	DECIMAL(10) NOT NULL	Stores the count of the OTH (mailing address) segments in a transaction set on the HIPAA 834 EDI file.
33	BN_834_NBR_SEG_N4O	Number(10,0)	DECIMAL(10) NOT NULL	Stores the count of the N4 (mailing address) segments in a transaction set on the HIPAA 834 EDI file.
34	BN_834_NBR_SEG_HD	Number(10,0)	DECIMAL(10) NOT NULL	Stores the count of the HD segments in a transaction set on the HIPAA 834 EDI file.
35	BN_834_NBR_SEG_REF	Number(10,0)	DECIMAL(10) NOT NULL	Stores the count of the REF segments in a transaction set on the HIPAA 834 EDI file.
36	BN_834_NBR_PLN_REF	Number(10,0)	DECIMAL(10) NOT NULL	Count of REF segments at the plan level i.e. Loop 2300 for each Transaction is stored in this field
37	BN_834_NBR_SEG_LX	Number(10,0)	DECIMAL(10) NOT NULL	Stores the count of the LX segments in a transaction set on the HIPAA 834 EDI file.