RUN_DTOPRIDGVT_SINQ_PRCESS_TYPACA=PACT Admin Notification
PACT=PACT SINQ Load
PMSA=PMSO Admin Notification
PMSO=PMSO SINQ Load
Y/N Table Edit
Default Value: N
Y/N Table Edit
Default Value: N
GVT_SINQ_NOTIFY(SQL Table) |
Index Back |
|---|---|
Federal NFC SINQ NotificationFederal NFC SINQ Notification Record. Updated by AE FGSINQLOAD |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | RUN_DT |
Date(10) | DATE | Run Date |
| 2 | OPRID |
Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). |
| 3 | GVT_SINQ_PRCESS_TY |
Character(4) | VARCHAR2(4) NOT NULL |
NFC Process Type
PACA=PACT Admin Notification PACT=PACT SINQ Load PMSA=PMSO Admin Notification PMSO=PMSO SINQ Load |
| 4 | GVT_NFC_WRLST_SENT | Character(1) | VARCHAR2(1) NOT NULL |
Worklist Item Added
Y/N Table Edit Default Value: N |
| 5 | GVT_NFC_EMAIL_SENT | Character(1) | VARCHAR2(1) NOT NULL |
Email Sent
Y/N Table Edit Default Value: N |