BN_834HIPAA_AET

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