GP_RTO_PRC_DEFN(SQL Table) |
Index Back |
|---|---|
Retro Process DefinitionThis contains the Retro Process definition. |
| # | 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 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 4 | DESCRSHORT | Character(10) | VARCHAR2(10) NOT NULL |
Short Description
Default Value: GP_RTO_PRC_DEFN.DESCR |
| 5 | RTO_MTHD | Character(1) | VARCHAR2(1) NOT NULL |
Default Retroactive Method
C=Corrective F=Forwarding |
| 6 | CHG_RTO_MTHD_IND | Character(1) | VARCHAR2(1) NOT NULL |
Y/N Indicates whether the retro method can ever vary (forwarding v. corrective) over time. Is used when defining the retro process.
Y/N Table Edit Default Value: N |
| 7 | MTHD_BASED_ON | Character(3) | VARCHAR2(3) NOT NULL |
Retro Method Decided By
PEC=Pay Entity Calendar Year PEF=Pay Entity Fiscal Year PGF=Pay Group Fiscal Year |
| 8 | DETERMINE_YEAR_BY | Character(1) | VARCHAR2(1) NOT NULL |
Determine Year By
E=Period End Date P=Payment Date |
| 9 | BEFORE_MTHD | Character(1) | VARCHAR2(1) NOT NULL |
Retro - Before Method
C=Corrective F=Forwarding |
| 10 | AFTER_MTHD | Character(1) | VARCHAR2(1) NOT NULL |
Retro - After Method
C=Corrective F=Forwarding |