BN_834_PAYER_VW (SQL View)	Index Back
HIPAA 834 Stage Payer View View on the HIPAA 834 Stage Payer table used to populate the File Layout Sponsor/Payer (level 1) segments.

BN_834_PAYER_VW

(SQL View)

HIPAA 834 Stage Payer View

View on the HIPAA 834 Stage Payer table used to populate the File Layout Sponsor/Payer (level 1) segments.

SELECT PROCESS_INSTANCE , SETID , VENDOR_ID , COMPANY , BN_EDI_TRANS_NBR , BN_EDI_PAYER_EIN , BN_NTNL_PROV_ID , BN_EDI_SPONSOR_EIN , BN_ACTION_CODE , BN_SCRTY_RQST , BN_SCRTY_PWD , BN_MSTR_POLICY_NBR , BN_EDI_TS_ID , PLAN_DESCR , COMPANY_DESCR , BN_EDI_DATE , BN_EDI_TIME , BN_EDI_TIME_ZN , BN_834_FL_EFFDT , BN_834_FL_ENRLDT , BN_EDI_NBR_SEGS , BN_EDI_SEP_SEGMENT , BN_EDI_SEP_FIELD , BN_EDI_SEP_FIELD , BN_EDI_SEP_FIELD , BN_EDI_SEP_FIELD , BN_EDI_SEP_FIELD , BN_EDI_SEP_FIELD , BN_EDI_SEP_FIELD , BN_EDI_SEP_FIELD , INCL_DTP348 , SEQ_DTP348 FROM PS_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_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.

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

32 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

#	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.
31	INCL_DTP348	Character(1)	VARCHAR2(1) NOT NULL	Include DTP 348 row for terminations in the HIPAA file Y/N Table Edit
32	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