GVT_SINQPAC_TMP(SQL Table) |
Index Back |
|---|---|
Federal NFC PACT SINQ Temp RcdFederal NFC PACT SINQ Temp Rcd |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | SSN | Character(9) | VARCHAR2(9) NOT NULL | Social Security # |
| 2 | GVT_SUB_AGENCY | Character(2) | VARCHAR2(2) NOT NULL | Sub-Agency |
| 3 | GVT_POI | Character(4) | VARCHAR2(4) NOT NULL | Personnel Office ID |
| 4 | COMPANY | Character(3) | VARCHAR2(3) NOT NULL | Company |
| 5 | GVT_NFC_DOC_TYPE | Character(3) | VARCHAR2(3) NOT NULL | NFC Document Type |
| 6 | GVT_PP_NBR | Number(3,0) | SMALLINT NOT NULL | Pay Period Number |
| 7 | GVT_NFC_AUTHCTN_DT | Date(10) | DATE | Federal NFC Field |
| 8 | GVT_STATUS_TYPE | Character(3) | VARCHAR2(3) NOT NULL |
Status Type
CAN=Cancelled COM=Completed COR=Corrected IRR=IRR Reported WIP=Work-in-progress |
| 9 | GVT_NOA_CODE | Character(3) | VARCHAR2(3) NOT NULL | Nature of Action Code |
| 10 | EFFDT | Date(10) | DATE | Effective Date |
| 11 | BATCH_NUM | Number(4,0) | SMALLINT NOT NULL | Batch Number |
| 12 | USERID | Character(30) | VARCHAR2(30) NOT NULL | A user's ID |
| 13 | GVT_NFC_ERROR_CD | Character(3) | VARCHAR2(3) NOT NULL | Error Code |
| 14 | GVT_NFC_ERROR_MSG | Character(100) | VARCHAR2(100) NOT NULL | Error Message |