COUNTRYGP_TX_TYPEA=Advance
M=Manual Payment
R=Correction
U=Additional Payment
GP_TX_REASONGPBR_OC_SETUP_A(SQL View) |
Index Back |
|---|---|
Adv. OffCycle Config GP BrazilAdvance OffCycle Config GP Brazil |
| SELECT COUNTRY , GP_TX_TYPE , GP_TX_REASON , DESCR , DESCRSHORT FROM PS_GP_OC_SETUP_A WHERE COUNTRY = 'BRA' AND GP_TX_TYPE = 'A' |
| # | 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 |