ASOFDATEFEHB_SEQ_NBRBENEFIT_PLANGVT_INT_HIST(SQL Table) |
Index Back |
|---|---|
FEHB Carrier Interface HistoryThis record is used to store history information on the runs of the FEHB carrier Interface, FGBN001.sqr. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | ASOFDATE |
Date(10) | DATE | As of Date |
| 2 | FEHB_SEQ_NBR |
Character(3) | VARCHAR2(3) NOT NULL | This field will be used on the FEHB Carrier Interface Temporary Table |
| 3 | BENEFIT_PLAN |
Character(6) | VARCHAR2(6) NOT NULL | Benefit Plan |
| 4 | FROMDATE | Date(10) | DATE | From Date |
| 5 | THRUDATE | Date(10) | DATE | End Date |
| 6 | FEHB_TOTAL_UNITS | Character(8) | VARCHAR2(8) NOT NULL | This field will be used on the FEHB Carrier Interface Temporary Table |
| 7 | FEHB_HASH_TOTAL | Character(24) | VARCHAR2(24) NOT NULL | This field will be used on the FEHB Carrier Interface Temporary Table |
| 8 | GVT_AGENCY | Character(6) | VARCHAR2(6) NOT NULL | Agency |