BN_834_PLAN

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
2	SETID	Character(5)	VARCHAR2(5) NOT NULL	SetID
3	VENDOR_ID	Character(10)	VARCHAR2(10) NOT NULL	Vendor Identifier
4	COMPANY	Character(3)	VARCHAR2(3) NOT NULL	Company
5	BN_EDI_TRANS_NBR	Character(9)	VARCHAR2(9) NOT NULL	Transaction Set Number
6	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
7	BENEFIT_RCD_NBR	Number(3,0)	SMALLINT NOT NULL	Specifies a sequence number associated with each of multiple concurrent jobs for a one employee. It is used to determine the applicable benefit program for each job. The first job entered for an employee is automatically assigned a Benefit Record Number of zero (0). This field is linked with EMPL_RCD#, the Employment Record Number.
8	COBRA_EVENT_ID	Number(3,0)	SMALLINT NOT NULL	Uniquely identifies a COBRA event within an employee's benefits records, and is system-generated.
9	DEPENDENT_BENEF	Character(2)	VARCHAR2(2) NOT NULL	Dependent Benefit 01=default
10	PLAN_TYPE	Character(2)	VARCHAR2(2) NOT NULL	Identifies a category of benefit plan, such as Medical, Dental, and Life (Insurance). A set of plan type codes, as well as rules for creating new codes, is provided by PeopleSoft. Plan Type codes determine how the system processes and defines eligibility for the various benefit plans.
11	COVERAGE_ELECT	Character(1)	VARCHAR2(1) NOT NULL	Coverage Election E=Elect T=Terminate W=Waive
12	BENEFIT_PLAN	Character(6)	VARCHAR2(6) NOT NULL	Benefit Plan
13	COVRG_CD	Character(2)	VARCHAR2(2) NOT NULL	Coverage Code
14	ENROLLMENT_DT	Date(10)	DATE	Original Enrollment Date
15	COVERAGE_BEGIN_DT	Date(10)	DATE	Coverage Begin Date
16	COVERAGE_ELECT_DT	Date(10)	DATE	Coverage Elect Date
17	DEDUCTION_BEGIN_DT	Date(10)	DATE	Deduction Begin Date
18	ASOFDATE	Date(10)	DATE	As of Date
19	GROUP_NBR	Character(30)	VARCHAR2(30) NOT NULL	Group Number
20	BN_834_GRP_NBR	Character(30)	VARCHAR2(30) NOT NULL	Stores the Group Number for Loop 2000 and 2300 in HIPAA EDI file
21	HLTH_PROVIDER_ID	Character(30)	VARCHAR2(30) NOT NULL	Health Provider ID
22	PREVIOUSLY_SEEN	Character(1)	VARCHAR2(1) NOT NULL	Previously Seen
23	BN_834_PLAN_TYPE	Character(3)	VARCHAR2(3) NOT NULL	Stores the mapped value of the Insurance Line Code (plan type) used on the HIPAA 834 EDI file.
24	BN_834_PLN_CVG_DSC	Character(50)	VARCHAR2(50) NOT NULL	Stores the Plan Coverage Description used on the HIPAA 834 EDI file. It is populated on the Benefits Plan table. This field is not mandatory.
25	BN_834_MAINT_CD	Character(3)	VARCHAR2(3) NOT NULL	Stores the Maintenace Type Code used on the HIPAA 834 EDI file. Default Value: 030
26	BN_834_COVRG_CD	Character(3)	VARCHAR2(3) NOT NULL	Stores the mapped value of the Coverage Level Code used on the HIPAA 834 EDI file.
27	BN_834_DATE_QUAL	Character(3)	VARCHAR2(3) NOT NULL	Stores the Date Time Qualifier used on the HIPAA 834 EDI file. Default Value: 348
28	BN_834_PREV_SEEN	Character(2)	VARCHAR2(2) NOT NULL	Stores the mapped value of the Entity Relationship Code (Previously Seen Provider) used on the HIPAA 834 EDI file. Default Value: 26
29	BN_EDI_SEP_SEGMENT	Character(1)	VARCHAR2(1) NOT NULL	Delimiter used to separate segments on the Benefits EDI transactions.
30	BN_EDI_SEP_FIELD	Character(1)	VARCHAR2(1) NOT NULL	Delimiter used to separate fields on the Benefits EDI transactions.
31	BN_834_PLN_SEG_HD	Character(62)	VARCHAR2(62) NOT NULL	Stores the concatenation of the HD02 to HD05 plan segment fields on the HIPAA 834 EDI file. Required to eliminate empty spaces and trailing empty fields.
32	ORIG_ENROLL_DT	Date(10)	DATE	Original enrollment date