GP_NRP_OCS_C_AD(SQL Table) |
Index Back |
|---|---|
Correction ConfigurationConfiguration for Off cycle Corrections interface |
| # | 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 | GP_TX_TYPE |
Character(1) | VARCHAR2(1) NOT NULL |
Transaction Type (introduced with Off-cycle). Identifies an offcycle request as correction,manual payment, unscheduled payment or advance.
XLAT values are assigned to support batch processing order
A=Advance M=Manual Payment R=Correction U=Additional Payment |
| 4 | GP_TX_REASON |
Character(18) | VARCHAR2(18) NOT NULL | Off Cycle (Transaction) Reason Identifies a particular configuration to be applied to the presentation of off cycle request information |
| 5 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 6 | DESCRSHORT | Character(10) | VARCHAR2(10) NOT NULL | Short Description |
| 7 | GP_CORR_TYPE_LTD | Character(1) | VARCHAR2(1) NOT NULL |
Correction Type - Limited (Field used in combination with RTO_MTHD) to represent the master set of options found in GP_CORR_TYPE
N=Replacement R=Forced Reversal |
| 8 | ALLW_CORR_TYPE_IND | Character(1) | VARCHAR2(1) NOT NULL | YesNo toggle controlling whether user can enter Correction Type |
| 9 | RTO_MTHD_OPTN | Character(1) | VARCHAR2(1) NOT NULL |
Retro Processing Rule. Allows user to indicate whether to use the normal setting or to force corrective retro
C=Forced Corrective N=Use Existing Retro Rules |
| 10 | ALLW_RTO_MTHD_IND | Character(1) | VARCHAR2(1) NOT NULL | YesNo edit controls whether user can enter Retro Method |
| 11 | HIDE_SECTION2_IND | Character(1) | VARCHAR2(1) NOT NULL | YesNo edit controls the display of a section (group box) |
| 12 | PAYMENT_MTHD | Character(1) | VARCHAR2(1) NOT NULL |
Payment Method
A=Cash C=Check O=Pay Primary Account Only P=Postal Order T=Bank Transfer U=Use Normal Distribution W=Wire Transfer |
| 13 | ALLW_PMT_MTHD_IND | Character(1) | VARCHAR2(1) NOT NULL | YesNo edit controls whether user can enter payment method |
| 14 | GP_ELEM_PRC_OPTN | Character(1) | VARCHAR2(1) NOT NULL |
Helps user select what "Big Stuff" elements to process during a given calendar (off cycle). All, only those with PI, or a limited identified set
A=All L=Limited Element Set P=Elements with Positive Input |
| 15 | ALLW_ELEM_PRC_IND | Character(1) | VARCHAR2(1) NOT NULL | Allow entry of Element Select |
| 16 | PIN_ELEM_GRP_NUM | Number(8,0) | INTEGER NOT NULL | PIN Number for Element Group |