GVT_RUN_TYPEB=Biweekly
Q=Quarterly
GVT_BATCH_NBRGVT_NH_CONTROL(SQL Table) |
Index Back |
|---|---|
Federal New Hire Rpt HistoryThis record will be used for storing key information on the historical runs of the Federal New Hire Reporting (aka Federal Parent Locator) functionality. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | GVT_RUN_TYPE |
Character(1) | VARCHAR2(1) NOT NULL |
Run Type
B=Biweekly Q=Quarterly |
| 2 | GVT_BATCH_NBR |
Number(6,0) | INTEGER NOT NULL | Batch Nbr to Reprocess |
| 3 | FROM_DATE | Date(10) | DATE | From Date |
| 4 | TO_DATE | Date(10) | DATE | Latest Date to be sent to PYR |
| 5 | BALANCE_QTR | Number(3,0) | SMALLINT NOT NULL | Balances for Quarter |
| 6 | FILE_NAME | Character(80) | VARCHAR2(80) NOT NULL | File Name |
| 7 | OPRID | Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). |
| 8 | ASOFDATE | Date(10) | DATE | As of Date |
| 9 | EMPL_CNT | Number(12,0) | DECIMAL(12) NOT NULL | Employee Count |