PROCESS_INSTANCESETIDVENDOR_IDCOMPANYBN_834_PYR_WRK(SQL Table) |
Index Back |
|---|---|
HIPAA 834 EDI Payer Work TblStores all sponsor/payer combinations (level1) 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. |
| # | 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 | COMPANY_DESCR | Character(30) | VARCHAR2(30) NOT NULL | Company Descr |
| 6 | BN_EDI_SPONSOR_EIN | Number(9,0) | DECIMAL(9) NOT NULL | Federal Employee Identification Number (FEIN) of the sponsor (company employee works for). Used in the Benefits EDI transmissions. |
| 7 | PLAN_DESCR | Character(40) | VARCHAR2(40) NOT NULL | Plan Description |
| 8 | BN_EDI_PAYER_EIN | Number(9,0) | DECIMAL(9) NOT NULL | Federal Employee Identification Number (FEIN) of the payer (plan provider). Used on the Benefits EDI transactions. |
| 9 | BN_NTNL_PROV_ID | Number(10,0) | DECIMAL(10) NOT NULL | National Provider ID |