PROCESS_INSTANCESETIDVENDOR_IDCOMPANYY/N Table Edit
Default Value: N
A=DTP 348 after 349
B=DTP 348 before 349
Default Value: B
BN_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 |
| 10 | INCL_DTP348 | Character(1) | VARCHAR2(1) NOT NULL |
Include DTP 348 row for terminations in the HIPAA file
Y/N Table Edit Default Value: N |
| 11 | SEQ_DTP348 | Character(1) | VARCHAR2(1) NOT NULL |
Sequence of DTP 348 row for terminations in the HIPAA file
A=DTP 348 after 349 B=DTP 348 before 349 Default Value: B |