BN_834_PAYER (SQL Table)	Index Back
HIPAA 834 Stage Payer Table Stores the data required for the HIPAA 834 EDI file sponsor/payer (level 1) segments.

BN_834_PAYER

(SQL Table)

HIPAA 834 Stage Payer Table

Stores the data required for the HIPAA 834 EDI file sponsor/payer (level 1) segments.

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

38 INCL_DTP348 Character(1) VARCHAR2(1) NOT NULL Include DTP 348 row for terminations in the HIPAA file
Y/N Table Edit
Default Value: N

39 SEQ_DTP348 Character(1) VARCHAR2(1) NOT NULL Sequence of DTP 348 row for terminations in the HIPAA file
A=DTP 348 after 349
B=DTP 348 before 349
Default Value: B

#	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.
38	INCL_DTP348	Character(1)	VARCHAR2(1) NOT NULL	Include DTP 348 row for terminations in the HIPAA file Y/N Table Edit Default Value: N
39	SEQ_DTP348	Character(1)	VARCHAR2(1) NOT NULL	Sequence of DTP 348 row for terminations in the HIPAA file A=DTP 348 after 349 B=DTP 348 before 349 Default Value: B