BN_834_HEADER

(SQL Table)
Index Back

HIPAA 834 Stage Header Table

Stores the data required for the HIPAA 834 EDI file header (level 0) segments.

# 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.
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.
7 BN_MSTR_POLICY_NBR Character(30) VARCHAR2(30) NOT NULL Stores the Master Policy Number for HIPAA 834 EDI file.
8 BN_SCRTY_RQST Character(2) VARCHAR2(2) NOT NULL Stores the Security Password Request. 0 - Security Password NOT requested. 1 - Security Password requested.
9 BN_SCRTY_PWD Character(10) VARCHAR2(10) NOT NULL Stores the Security Password for HIPAA EDI File
10 BN_EDI_SECRTY_INFO Character(12) VARCHAR2(12) NOT NULL Security Information used on the Benefits EDI transactions.
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_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 FROMDATE Date(10) DATE From Date
18 THRUDATE Date(10) DATE End Date
19 RUNDTTM DateTime(26) TIMESTAMP Run Date/Time
20 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
21 BN_ACK_REQUESTED Character(1) VARCHAR2(1) NOT NULL Acknowledgement Request Indicator, used as a checkbox on Create HIPAA EDI file page.
22 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
23 BN_834_FL_EFFDT Date(10) DATE Stores File Effective Date for HIPAA EDI File
24 BN_834_FL_ENRLDT Date(10) DATE Stores File Enrollment Date for HIPAA EDI File
25 FILE_DIRECTORY Character(80) VARCHAR2(80) NOT NULL File Directory
26 FILE_NAME Character(80) VARCHAR2(80) NOT NULL File Name
27 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
28 BN_EDI_SEP_FIELD Character(1) VARCHAR2(1) NOT NULL Delimiter used to separate fields on the Benefits EDI transactions.
29 BN_EDI_SEP_ELEMENT Character(1) VARCHAR2(1) NOT NULL Delimiter used to separate subelements on the Benefits EDI transactions.
30 BN_EDI_SEP_SEGMENT Character(1) VARCHAR2(1) NOT NULL Delimiter used to separate segments on the Benefits EDI transactions.
31 BN_834_MAX_MEMBERS Number(5,0) INTEGER NOT NULL Stores the maximum number of members to be included in each transaction set on the HIPAA 834 EDI file.
32 BN_834_WRK_CI_MODE Character(1) VARCHAR2(1) NOT NULL Flag indicating the mode when calling the BN_834_WORK component: "C" - Chunking mode "M" - Member mode
C=Chunking Mode
M=Member Mode
33 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.