| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 COUNTRY |
Character(3) |
VARCHAR2(3) NOT NULL |
Country
|
| 2 |
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
|
| 3 |
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
|
| 4 |
DESCR |
Character(30) |
VARCHAR2(30) NOT NULL |
Description
|
| 5 |
DESCRSHORT |
Character(10) |
VARCHAR2(10) NOT NULL |
Short Description
|
| 6 |
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
Default Value: N
|
| 7 |
ALLW_CORR_TYPE_IND |
Character(1) |
VARCHAR2(1) NOT NULL |
YesNo toggle controlling whether user can enter Correction Type
Y/N Table Edit
Default Value: Y
|
| 8 |
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
Default Value: N
|
| 9 |
ALLW_RTO_MTHD_IND |
Character(1) |
VARCHAR2(1) NOT NULL |
YesNo edit controls whether user can enter Retro Method
Y/N Table Edit
Default Value: Y
|
| 10 |
HIDE_SECTION2_IND |
Character(1) |
VARCHAR2(1) NOT NULL |
YesNo edit controls the display of a section (group box)
Y/N Table Edit
Default Value: N
|
| 11 |
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
Default Value: U
Prompt Table:
GP_X_PMTMTHD_VW
|
| 12 |
ALLW_PMT_MTHD_IND |
Character(1) |
VARCHAR2(1) NOT NULL |
YesNo edit controls whether user can enter payment method
Y/N Table Edit
Default Value: Y
|
| 13 |
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
Default Value: A
|
| 14 |
ALLW_ELEM_PRC_IND |
Character(1) |
VARCHAR2(1) NOT NULL |
Allow entry of Element Select
Y/N Table Edit
Default Value: Y
|
| 15 |
PIN_ELEM_GRP_NUM |
Number(8,0) |
INTEGER NOT NULL |
PIN Number for Element Group
Prompt Table:
GP_PIN_EG1_VW
|