BN_SNAP_HIST(SQL Table) |
Index Back |
|---|---|
Enrollment Snapshot HistoryBN_SNAP_HIST contains a history of Enrollment Reporting Snapshot (Table Population) runs, and Carrier Interface runs. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  RUNDTTM |
DateTime(26) | TIMESTAMP | Run Date/Time |
| 2 | RUNDATE |
Date(10) | DATE | Process Scheduler Run Date |
| 3 | ASOFDATE |
Date(10) | DATE | As of Date |
| 4 | BN_SNAP_HIST_TYPE |
Character(1) | VARCHAR2(1) NOT NULL |
Determines whether the row in BN_SNAP_HIST refers to an Enrollment Reporting Snapshot run, or a Carrier Interface run.
1=Snapshot (Table Population) 2=Carrier Interface 3=Supplier Integration A=Health Extract B=Life/AD&D Extract C=Disability Extract D=Savings Extract E=FSA Extract F=Retirement Extract G=Pension Extract H=Vacation Extract I=HIPAA Extract |
| 5 | SETID |
Character(5) | VARCHAR2(5) NOT NULL | SetID |
| 6 | VENDOR_ID |
Character(10) | VARCHAR2(10) NOT NULL | Vendor Identifier |
| 7 | 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. |
| 8 | OPRID | Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). |
| 9 | BN_EDI_PARTNER_ID | Character(15) | VARCHAR2(15) NOT NULL | Identification of Trading Partner for the Benefits EDI transactions. |
| 10 | FILENAME | Character(80) | VARCHAR2(80) NOT NULL | File Name |
| 11 | RECORD_COUNT | Number(7,0) | INTEGER NOT NULL | Count of Records |
| 12 | SCHED_ID | Character(6) | VARCHAR2(6) NOT NULL | Schedule ID |
| 13 | PUBLISHTIMESTAMP | DateTime(26) | TIMESTAMP | Pub/Sub Timestamp |
| 14 | SUBSCRIBE_DTTM | DateTime(26) | TIMESTAMP | Subscription Date Time |