BN_834_SEL_WRK (SQL Table)	Index Back
HIPAA 834 EDI Select Work Tbl Stores all sponsor/payer/plan type combinations that will be included in the HIPAA 834 EDI file, loaded from the Benefits Enrollment Snapshot tables and filtered by the selection criteria (vendors, companies and plan types) entered on the run control page. Also stores the last asofdate and rundate of the last HIPAA extract for each sponsor/payer/plan type combination, to avoid resending terminations over and over again.

BN_834_SEL_WRK

(SQL Table)

HIPAA 834 EDI Select Work Tbl

Stores all sponsor/payer/plan type combinations that will be included in the HIPAA 834 EDI file, loaded from the Benefits Enrollment Snapshot tables and filtered by the selection criteria (vendors, companies and plan types) entered on the run control page. Also stores the last asofdate and rundate of the last HIPAA extract for each sponsor/payer/plan type combination, to avoid resending terminations over and over again.

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

6 ASOFDATE Date(10) DATE As of Date

7 RUNDATE Date(10) DATE Process Scheduler Run Date

#	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	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.
6	ASOFDATE	Date(10)	DATE	As of Date
7	RUNDATE	Date(10)	DATE	Process Scheduler Run Date