| # |
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 |
HIDE_SECTION_IND |
Character(1) |
VARCHAR2(1) NOT NULL |
Hide Calendar Controls
Y/N Table Edit
Default Value: N
|
| 7 |
ALLW_BGN_DT_IND |
Character(1) |
VARCHAR2(1) NOT NULL |
Allow entry of Begin Date
Y/N Table Edit
Default Value: Y
|
| 8 |
ALLW_END_DT_IND |
Character(1) |
VARCHAR2(1) NOT NULL |
Allow entry of End Date
Y/N Table Edit
Default Value: Y
|
| 9 |
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
|
| 10 |
RUN_TYPE |
Character(10) |
VARCHAR2(10) NOT NULL |
Run Type Name
Prompt Table:
GP_RUN_TYPEP_VW
|
| 11 |
ALLW_RUN_TYPE_IND |
Character(1) |
VARCHAR2(1) NOT NULL |
Allow entry of Run Type
Y/N Table Edit
Default Value: Y
|
| 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
Default Value: U
Prompt Table:
GP_X_PMTMTHD_VW
|
| 13 |
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
|
| 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
Default Value: A
|
| 15 |
ALLW_ELEM_PRC_IND |
Character(1) |
VARCHAR2(1) NOT NULL |
Allow entry of Element Select
Y/N Table Edit
Default Value: Y
|
| 16 |
PIN_ELEM_GRP_NUM |
Number(8,0) |
INTEGER NOT NULL |
PIN Number for Element Group
Prompt Table:
GP_PIN_EG1_VW
|
| 17 |
ALLW_PMT_KEYS_IND |
Character(1) |
VARCHAR2(1) NOT NULL |
Allow entry of Payment Keys
Y/N Table Edit
Default Value: Y
|