GP_PKG_IDCOUNTRYRTO_PRC_IDRTO_MTHDC=Corrective
F=Forwarding
EFFDTOVR_SET_NUMPIN_NUMA=Always Recalculate
D=Use Element Definition
N=Do Not Recalculate
GP_NRP_RTOVP_AD(SQL Table) |
Index Back |
|---|---|
Retro Definition Override -PinThis record contains the elements (PINs) that are part of a given override set for a given retro process definition override. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | GP_PKG_ID |
Character(10) | VARCHAR2(10) NOT NULL | Field used for element packaging |
| 2 | COUNTRY |
Character(3) | VARCHAR2(3) NOT NULL | Country |
| 3 | RTO_PRC_ID |
Character(10) | VARCHAR2(10) NOT NULL | Retro Process Definition ID |
| 4 | RTO_MTHD |
Character(1) | VARCHAR2(1) NOT NULL |
Default Retroactive Method
C=Corrective F=Forwarding |
| 5 | EFFDT |
Date(10) | DATE | Effective Date |
| 6 | OVR_SET_NUM |
Number(2,0) | SMALLINT NOT NULL | Override Set Number |
| 7 | PIN_NUM |
Number(8,0) | INTEGER NOT NULL | PIN Number |
| 8 | ENTRY_TYPE_ID | Character(3) | VARCHAR2(3) NOT NULL | Element Entry Type ID |
| 9 | RTO_RECALC_OPTN | Character(1) | VARCHAR2(1) NOT NULL |
Retro Recalculation Option
A=Always Recalculate D=Use Element Definition N=Do Not Recalculate |
| 10 | FWD_IND | Character(1) | VARCHAR2(1) NOT NULL | Forward |
| 11 | FWD2_DIFF_PIN_IND | Character(1) | VARCHAR2(1) NOT NULL | Forward To Different Element |
| 12 | ENTRY_TYPE_RTO_ADJ | Character(3) | VARCHAR2(3) NOT NULL | Entry (element) type field |
| 13 | PIN_RTO_ADJ_NUM | Number(8,0) | INTEGER NOT NULL | Element number field |