BN_834HIPAA_AET

(SQL Table)
Index Back

State record for HIPAA 834 AE

State 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.