COUNTRYRTO_PRC_IDPrompt Table: GP_RTO_PRC_DEFN
RTO_MTHDC=Corrective
F=Forwarding
EFFDTDefault Value: %DATE
Prompt Table: GP_PIN_FM2_VW
GP_RTO_OVR_DEFN(SQL Table) |
Index Back |
|---|---|
Retro Process Override DefnThis record contains the Retro Process Override definition. It contains the formula to be used for the override. |
| # | 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
Prompt Table: GP_RTO_PRC_DEFN |
| 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
Default Value: %DATE |
| 5 | PIN_FRML_NUM | Number(8,0) | INTEGER NOT NULL |
Element number field
Prompt Table: GP_PIN_FM2_VW |