| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 PROCESS_INSTANCE |
Number(10,0) |
DECIMAL(10) NOT NULL |
Process Instance
|
| 2 |
GP_PAYGROUP |
Character(10) |
VARCHAR2(10) NOT NULL |
Global Payroll pay group
|
| 3 |
BGN_DT |
Date(10) |
DATE |
Begin Date
|
| 4 |
END_DT |
Date(10) |
DATE |
end date
|
| 5 |
AE_APPLID |
Character(12) |
VARCHAR2(12) NOT NULL |
Program Name (see PSAEAPPLDEFN).
|
| 6 |
AE_SECTION |
Character(8) |
VARCHAR2(8) NOT NULL |
Section
|
| 7 |
EMPLID |
Character(11) |
VARCHAR2(11) NOT NULL |
Employee ID
|
| 8 |
EMPL_RCD |
Number(3,0) |
SMALLINT NOT NULL |
Empl Rcd Nbr
|
| 9 |
EFFDT |
Date(10) |
DATE |
Effective Date
Default Value: %Date
|
| 10 |
TERMINATION_DT |
Date(10) |
DATE |
Termination Date
|
| 11 |
SERVICE_DT |
Date(10) |
DATE |
Service Date
|
| 12 |
SETID_LOCATION |
Character(5) |
VARCHAR2(5) NOT NULL |
Location SetID
|
| 13 |
LOCATION |
Character(10) |
VARCHAR2(10) NOT NULL |
Location Code
|
| 14 |
DAILY_RT |
Number(19,3) |
DECIMAL(18,3) NOT NULL |
Daily Rate
|
| 15 |
GPMX_SRTY |
Number(8,3) |
DECIMAL(7,3) NOT NULL |
Seniority GP Mexico
|
| 16 |
GPMX_MINWG_AZN |
Number(15,2) |
DECIMAL(14,2) NOT NULL |
Minimum Wage A Zone GP Mexico
|
| 17 |
GPMX_MINWG_EZN |
Number(15,2) |
DECIMAL(14,2) NOT NULL |
Minimum Wage Employee Zone GP Mexico
|
| 18 |
GPMX_CEIL_DAY_EM |
Number(15,2) |
DECIMAL(14,2) NOT NULL |
Ceiling Days Maternity & Illness GP Mexico
|
| 19 |
GPMX_MAX_EM |
Number(15,2) |
DECIMAL(14,2) NOT NULL |
Max Ceiling Maternity & Illness GP Mexico
|
| 20 |
GPMX_CEIL_DAY_IV |
Number(15,2) |
DECIMAL(14,2) NOT NULL |
Ceiling Days Disability and Life GP Mexico
|
| 21 |
GPMX_MAX_IV |
Number(15,2) |
DECIMAL(14,2) NOT NULL |
Max Ceiling Disability and Life GP Mexico
|
| 22 |
GPMX_SDI_FIX |
Number(15,2) |
DECIMAL(14,2) NOT NULL |
Fixed SDI GP Mexico
|
| 23 |
GPMX_SDI_VAR |
Number(15,2) |
DECIMAL(14,2) NOT NULL |
Variable SDI GP Mexico
|
| 24 |
GPMX_SDI_FACTOR |
Number(19,6) |
DECIMAL(18,6) NOT NULL |
SDI Factor GP Mexico
|
| 25 |
GPMX_MIN_SAL_DIF |
Number(15,2) |
DECIMAL(14,2) NOT NULL |
Difference SMG and Daily Rate GP Mexico
|
| 26 |
GPMX_SDI_TOT |
Number(15,2) |
DECIMAL(14,2) NOT NULL |
SDI Total GP Mexico
|
| 27 |
SEQNUM |
Number(3,0) |
SMALLINT NOT NULL |
Sequence Number
|
| 28 |
ESTABID |
Character(12) |
VARCHAR2(12) NOT NULL |
Establishment ID
|
| 29 |
WAGE_ZONE_MEX |
Character(4) |
VARCHAR2(4) NOT NULL |
Wage Zone for Mexico
10=A Economic Zone
20=B Economic Zone
30=C Economic Zone
|
| 30 |
GPMX_PIN_ERN_NUM |
Number(8,0) |
INTEGER NOT NULL |
Earning Pin Num
|
| 31 |
GPMX_FIXSDI_TYPE |
Character(4) |
VARCHAR2(4) NOT NULL |
Fix SDI Type MEX
0010=General
0020=By Payee
|
| 32 |
GPMX_CALC_BASE |
Character(4) |
VARCHAR2(4) NOT NULL |
Fix SDI Calc Base MEX
0010=Daily Rate
0020=SDI
0030=Minimun Wage
0040=Amount
0050=# of Days
|
| 33 |
GPMX_BASE_AMOUNT |
Signed Number(16,2) |
DECIMAL(14,2) NOT NULL |
Fix SDI Base Amount MEX
|
| 34 |
GPMX_BASE_DAY |
Signed Number(7,2) |
DECIMAL(5,2) NOT NULL |
Fix SDI Base Day MEX
|
| 35 |
GPMX_BASE_PCTG |
Signed Number(11,6) |
DECIMAL(9,6) NOT NULL |
Fix SDI Base Pctg MEX
|
| 36 |
GPMX_BASE_WG_ZONE |
Character(4) |
VARCHAR2(4) NOT NULL |
Fix SDI Base Wg Zone MEX
0010=A Economic Zone
0020=B Econimic Zone
0030=C Economic Zone
0040=Payee's Economic Zone
|
| 37 |
GPMX_INT_BASE |
Character(4) |
VARCHAR2(4) NOT NULL |
Fix SDI Int Base MEX
0010=Daily Rate
0020=SDI
0030=Minimun Wage
0040=All
|
| 38 |
GPMX_INT_PCTG_LOW |
Signed Number(11,6) |
DECIMAL(9,6) NOT NULL |
Fix SDI Int Pctg Low MEX
|
| 39 |
GPMX_INT_PCTG_TOP |
Signed Number(11,6) |
DECIMAL(9,6) NOT NULL |
Fix SDI Int Pctg Top MEX
|
| 40 |
GPMX_INT_WGZN_LOW |
Character(4) |
VARCHAR2(4) NOT NULL |
Fix SDI Int Wg Zone Low MEX
0010=A Economic Zone
0020=B Economic Zone
0030=C Economic Zone
0040=Payee's Economic Zone
|
| 41 |
GPMX_INT_WGZN_TOP |
Character(4) |
VARCHAR2(4) NOT NULL |
Fix SDI Int Wgzn Top MEX
0010=A Economic Zone
0020=B Economic Zone
0030=C Economic Zone
0040=Payee's Economic Zone
|
| 42 |
GPMX_MIN_WAGE_B |
Number(19,6) |
DECIMAL(18,6) NOT NULL |
Min Wage Zone B
|
| 43 |
GPMX_MIN_WAGE_C |
Number(19,6) |
DECIMAL(18,6) NOT NULL |
Min Wage Zone C
|
| 44 |
GPMX_BASE |
Number(15,2) |
DECIMAL(14,2) NOT NULL |
Base for Variability Report
|
| 45 |
GPMX_INTEG_BASE |
Number(15,2) |
DECIMAL(14,2) NOT NULL |
Integrable base for Variable SDI Report
|
| 46 |
GPMX_SDI_TYPE |
Character(4) |
VARCHAR2(4) NOT NULL |
SDI Type by Anniversary or SMG Change
0010=SDI by Anniversary
0020=SDI by SMG Change
0030=SDI Mass Calculation
0040=SDI Triggers
|
| 47 |
GPMX_BIMONTH_CD |
Character(2) |
VARCHAR2(2) NOT NULL |
Bimonth Code
01=1st Bimonth
02=2nd Bimonth
03=3rd Bimonth
04=4th Bimonth
05=5th Bimonth
06=6th Bimonth
|
| 48 |
GPMX_BALANCE_YEAR |
Number(4,0) |
SMALLINT NOT NULL |
Balance Year GP Mexico
|