RUN_DTGVT_NFC_SEQNUMCAN=Cancelled
COM=Completed
COR=Corrected
IRR=IRR Reported
WIP=Work-in-progress
E=Error
U=Unprocessed Record
GVT_SINQERRP_VW(SQL View) |
Index Back |
|---|---|
Federal NFC PACT Unprocessd VwFederal NFC PACT Unprocessd Transactions view |
| SELECT RUN_DT ,GVT_NFC_SEQNUM ,SSN ,GVT_NFC_DOC_TYPE ,GVT_POI ,EFFDT ,GVT_PP_NBR ,GVT_NOA_CODE ,GVT_STATUS_TYPE ,GVT_NFC_ERROR_CD ,GVT_NFC_ERROR_TYPE ,GVT_NFC_ERROR_MSG FROM PS_GVT_SINQERR_PAC WHERE GVT_NFC_ERROR_TYPE = 'U' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | RUN_DT |
Date(10) | DATE | Run Date |
| 2 | GVT_NFC_SEQNUM |
Number(6,0) | INTEGER NOT NULL | Sequence Number |
| 3 | SSN | Character(9) | VARCHAR2(9) NOT NULL | Social Security # |
| 4 | GVT_NFC_DOC_TYPE | Character(3) | VARCHAR2(3) NOT NULL | NFC Document Type |
| 5 | GVT_POI | Character(4) | VARCHAR2(4) NOT NULL | Personnel Office ID |
| 6 | EFFDT | Date(10) | DATE | Effective Date |
| 7 | GVT_PP_NBR | Number(3,0) | SMALLINT NOT NULL | Pay Period Number |
| 8 | GVT_NOA_CODE | Character(3) | VARCHAR2(3) NOT NULL | Nature of Action Code |
| 9 | GVT_STATUS_TYPE | Character(3) | VARCHAR2(3) NOT NULL |
Status Type
CAN=Cancelled COM=Completed COR=Corrected IRR=IRR Reported WIP=Work-in-progress |
| 10 | GVT_NFC_ERROR_CD | Character(3) | VARCHAR2(3) NOT NULL | Error Code |
| 11 | GVT_NFC_ERROR_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
NFC Import Error Type
E=Error U=Unprocessed Record |
| 12 | GVT_NFC_ERROR_MSG | Character(100) | VARCHAR2(100) NOT NULL | Error Message |