BN_834_HEADER(SQL Table) |
Index Back |
---|---|
HIPAA 834 Stage Header TableStores 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. |