BN_834_HDR_VW

(SQL View)
 Index Back

HIPAA 834 Stage Header View

View on the HIPAA 834 Stage Header table used to populate the File Layout Header segments.

SELECT PROCESS_INSTANCE , BN_EDI_PARTNER_ID , BN_EDI_INT_TP_ID , BN_EDI_APP_SNDR_ID , BN_EDI_EXT_TP_ID , BN_EDI_APP_RCVR_ID , BN_SCRTY_RQST , BN_SCRTY_PWD , BN_ACK_REQUESTED , BN_USAGE_IND , BN_EDI_CNTL_NBR , BN_EDI_NBR_TRANS , BN_EDI_DATE , BN_EDI_TIME , BN_EDI_SEP_FIELD %Concat ' ' %Concat BN_EDI_SEP_FIELD , BN_EDI_SECRTY_INFO , BN_EDI_SEP_ELEMENT , BN_EDI_SEP_SEGMENT , BN_EDI_SEP_REPET , 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 , BN_EDI_SEP_FIELD , BN_EDI_SEP_FIELD , BN_EDI_SEP_FIELD , BN_EDI_SEP_FIELD FROM PS_BN_834_HEADER

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
2 BN_EDI_PARTNER_ID Character(15) VARCHAR2(15) NOT NULL Identification of Trading Partner for the Benefits EDI transactions.
3 BN_EDI_INT_TP_ID Character(15) VARCHAR2(15) NOT NULL Identifier for the sender of an EDI transmission (Interchange Sender ID). This must be agreed upon by sender and receiver.
4 BN_EDI_APP_SNDR_ID Character(15) VARCHAR2(15) NOT NULL Stores Application Sender Code for HIPAA EDI File.

Default Value: BN_EDI_PARTNERS.BN_EDI_INT_TP_ID

5 BN_EDI_EXT_TP_ID Character(15) VARCHAR2(15) NOT NULL Identifier for the receiver of an EDI transmission (Interchange Receiver ID). This must be agreed upon by sender and receiver.
6 BN_EDI_APP_RCVR_ID Character(15) VARCHAR2(15) NOT NULL Stores Application Reciever Code for HIPAA EDI File.

Default Value: BN_EDI_PARTNERS.BN_EDI_EXT_TP_ID

7 BN_SCRTY_RQST Character(2) VARCHAR2(2) NOT NULL Stores the Security Password Request. 0 - Security Password NOT requested. 1 - Security Password requested.
8 BN_SCRTY_PWD Character(10) VARCHAR2(10) NOT NULL Stores the Security Password for HIPAA EDI File
9 BN_ACK_REQUESTED Character(1) VARCHAR2(1) NOT NULL Acknowledgement Request Indicator, used as a checkbox on Create HIPAA EDI file page.
10 BN_USAGE_IND Character(1) VARCHAR2(1) NOT NULL Benefits Usage Indicator, stores whether a file is Production or Test File. Used as a checkbox on Create HIPAA EDI File page.
P=Production File
T=Test File
11 BN_EDI_CNTL_NBR Number(9,0) DECIMAL(9) NOT NULL Used as a Transmission Control Number on the Benefits EDI transactions. Stored on the Benefits EDI Partner table.
12 BN_EDI_NBR_TRANS Number(6,0) INTEGER NOT NULL Number of transaction sets on the HIPAA 834 EDI file.
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_AUTHOR_INFO Character(12) VARCHAR2(12) NOT NULL Stores the Authorization Information used on the Benefits EDI transactions.
16 BN_EDI_SECRTY_INFO Character(12) VARCHAR2(12) NOT NULL Security Information used on the Benefits EDI transactions.
17 BN_EDI_SEP_ELEMENT Character(1) VARCHAR2(1) NOT NULL Delimiter used to separate subelements on the Benefits EDI transactions.
18 BN_EDI_SEP_SEGMENT Character(1) VARCHAR2(1) NOT NULL Delimiter used to separate segments on the Benefits EDI transactions.
19 BN_EDI_SEP_REPET Character(1) VARCHAR2(1) NOT NULL Delimiter used to separate repeated occurrences of a simple data element or a composite data structure on the Benefits EDI transactions.
20 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.
21 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.
22 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.
23 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.
24 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.
25 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.
26 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.
27 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.
28 BN_EDI_SEP_FIELD09 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_FIELD10 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_FIELD11 Character(1) VARCHAR2(1) NOT NULL Stores the value of the delimiter used to separate fields on the Benefits EDI transactions.
31 BN_EDI_SEP_FIELD12 Character(1) VARCHAR2(1) NOT NULL Stores the value of the delimiter used to separate fields on the Benefits EDI transactions.