GP_NRP_RTOVP_VW(SQL View) |
Index Back |
|---|---|
Retro Defn Override -Pin - VieThis record contains the elements (PINs) that are part of a given override set for a given retro process definition override - Packaging Viedw |
| SELECT COUNTRY ,RTO_PRC_ID ,RTO_MTHD ,EFFDT ,OVR_SET_NUM ,PIN_NUM + 50000000 ,ENTRY_TYPE_ID ,RTO_RECALC_OPTN ,FWD_IND ,FWD2_DIFF_PIN_IND ,ENTRY_TYPE_RTO_ADJ ,PIN_RTO_ADJ_NUM + 50000000 FROM PS_GP_RTO_OVR_PIN |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  COUNTRY |
Character(3) | VARCHAR2(3) NOT NULL | Country |
| 2 | RTO_PRC_ID |
Character(10) | VARCHAR2(10) NOT NULL | Retro Process Definition ID |
| 3 | RTO_MTHD |
Character(1) | VARCHAR2(1) NOT NULL |
Default Retroactive Method
C=Corrective F=Forwarding |
| 4 | EFFDT |
Date(10) | DATE NOT NULL | Effective Date |
| 5 | OVR_SET_NUM |
Number(2,0) | SMALLINT NOT NULL | Override Set Number |
| 6 | PIN_NUM |
Number(8,0) | INTEGER NOT NULL |
PIN Number
Prompt Table: %GP_EDIT_FLD1 |
| 7 | ENTRY_TYPE_ID | Character(3) | VARCHAR2(3) NOT NULL |
Element Entry Type ID
Prompt Table: GP_ENT_RTOVR_VW |
| 8 | RTO_RECALC_OPTN | Character(1) | VARCHAR2(1) NOT NULL |
Retro Recalculation Option
A=Always Recalculate D=Use Element Definition N=Do Not Recalculate |
| 9 | FWD_IND | Character(1) | VARCHAR2(1) NOT NULL |
Forward
Y/N Table Edit |
| 10 | FWD2_DIFF_PIN_IND | Character(1) | VARCHAR2(1) NOT NULL |
Forward To Different Element
Y/N Table Edit |
| 11 | ENTRY_TYPE_RTO_ADJ | Character(3) | VARCHAR2(3) NOT NULL |
Entry (element) type field
Prompt Table: GP_ENT_E_D_VW |
| 12 | PIN_RTO_ADJ_NUM | Number(8,0) | INTEGER NOT NULL |
Element number field
Prompt Table: %GP_EDIT_FLD2 |