BN_834HIPAA_AET(SQL Table) |
Index Back |
---|---|
State record for HIPAA 834 AEState record for the HIPAA 834 EDI file application engine programs: BN_834_HIPAA and BN_HIPA5010. |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | PROCESS_INSTANCE | Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
2 | OPRID | Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). |
3 | RUN_CNTL_ID | Character(30) | VARCHAR2(30) NOT NULL | Run Control ID |
4 | ASOFDATE | Date(10) | DATE | As of Date |
5 | FROMDATE | Date(10) | DATE | From Date |
6 | THRUDATE | Date(10) | DATE | End Date |
7 | 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 Default Value: 2 |
8 | BN_ACK_REQUESTED | Character(1) | VARCHAR2(1) NOT NULL |
Acknowledgement Request Indicator, used as a checkbox on Create HIPAA EDI file page.
Default Value: 0 |
9 | 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 Default Value: P |
10 | BN_834_FL_EFFDT | Date(10) | DATE | Stores File Effective Date for HIPAA EDI File |
11 | BN_834_FL_ENRLDT | Date(10) | DATE | Stores File Enrollment Date 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_ALT_GRP_NBR_IND | Character(1) | VARCHAR2(1) NOT NULL |
Stores Alternate Transaction Set Identifier Group Number Indicator.
'0' - When Unchecked External Partner ID will be used in BGN02
'1' - When Checked Alternate Transaction Set Identifier Group Number will be used in BGN02
Y/N Table Edit Default Value: N |
14 | BN_EDI_ALT_GRP_NBR | Character(15) | VARCHAR2(15) NOT NULL | Stores Alternate Transaction Set Identifier Group Number. When has no value External Partner ID will be used in BGN02 When has a value Alternate Transaction Set Identifier Group Number will be used in BGN02 |
15 | BN_834_ALL_VD_FLG | Character(1) | VARCHAR2(1) NOT NULL | Flag that allows the selection of all vendors represented in the Benefits Enrollment Snapshot tables to be included in the HIPAA 834 EDI file. |
16 | BN_834_ALL_CO_FLG | Character(1) | VARCHAR2(1) NOT NULL | Flag that allows the selection of all companies represented in the Benefits Enrollment Snapshot tables to be included in the HIPAA 834 EDI file. |
17 | BN_834_ALL_PT_FLG | Character(1) | VARCHAR2(1) NOT NULL | Flag that allows the selection of all plan types represented in the Benefits Enrollment Snapshot tables to be included in the HIPAA 834 EDI file. |
18 | BN_834_ALL_PLANS | Character(1) | VARCHAR2(1) NOT NULL | Include all Benefit Plans |
19 | BN_834_ALL_GRPNBR | Character(1) | VARCHAR2(1) NOT NULL | Include all Group Numbers |
20 | 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. |
21 | BN_EDI_PARTNER_ID | Character(15) | VARCHAR2(15) NOT NULL | Identification of Trading Partner for the Benefits EDI transactions. |
22 | NAME_AC | Character(50) | VARCHAR2(50) NOT NULL | Alternate Character Name |
23 | 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. |
24 | 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 |
25 | 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. |
26 | 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 |
27 | BN_SCRTY_RQST | Character(2) | VARCHAR2(2) NOT NULL |
Stores the Security Password Request.
0 - Security Password NOT requested.
1 - Security Password requested.
Default Value: 00 |
28 | BN_SCRTY_PWD | Character(10) | VARCHAR2(10) NOT NULL | Stores the Security Password for HIPAA EDI File |
29 | BN_EDI_SUBSCBR_ID | Character(1) | VARCHAR2(1) NOT NULL |
This field stores the option for Subscriber ID in EDI Partner page.
E=EMPLID S=SSN |
30 | 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. |
31 | BN_EDI_SEP_FIELD | Character(1) | VARCHAR2(1) NOT NULL | Delimiter used to separate fields on the Benefits EDI transactions. |
32 | BN_EDI_SEP_ELEMENT | Character(1) | VARCHAR2(1) NOT NULL | Delimiter used to separate subelements on the Benefits EDI transactions. |
33 | BN_EDI_SEP_SEGMENT | Character(1) | VARCHAR2(1) NOT NULL | Delimiter used to separate segments on the Benefits EDI transactions. |
34 | RUNDTTM | DateTime(26) | TIMESTAMP | Run Date/Time |
35 | BN_EDI_DATE | Date(10) | DATE | Transmission Date used on the Benefits EDI transactions. |
36 | BN_EDI_TIME | Character(4) | VARCHAR2(4) NOT NULL | Stores the Time used on the Benefits EDI transactions. Format is HHMM. |
37 | BN_EDI_TIME_ZN | Character(2) | VARCHAR2(2) NOT NULL | Stores the mapped value of the Time Zone used on the Benefits EDI transactions. |
38 | FILE_DIRECTORY | Character(80) | VARCHAR2(80) NOT NULL | File Directory |
39 | FILE_NAME | Character(80) | VARCHAR2(80) NOT NULL | File Name |
40 | 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. |