GPMX_SDI_AET

(SQL Table)
Index Back

SDI AET

SDI By Anniversary and SMG Change

# 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 Record
9 EFFDT Date(10) DATE Effective Date

Default Value: %Date

10 EFFSEQ Number(3,0) SMALLINT NOT NULL Effective Sequence
11 TERMINATION_DT Date(10) DATE Termination Date
12 SERVICE_DT Date(10) DATE Service Date
13 SETID_LOCATION Character(5) VARCHAR2(5) NOT NULL Location Set ID
14 LOCATION Character(10) VARCHAR2(10) NOT NULL Location Code
15 DAILY_RT Number(19,3) DECIMAL(18,3) NOT NULL Daily Rate
16 GPMX_SRTY Number(8,3) DECIMAL(7,3) NOT NULL Seniority GP Mexico
17 GPMX_MINWG_AZN Number(15,2) DECIMAL(14,2) NOT NULL Minimum Wage A Zone GP Mexico
18 GPMX_MINWG_EZN Number(15,2) DECIMAL(14,2) NOT NULL Minimum Wage Employee Zone GP Mexico
19 GPMX_CEIL_DAY_EM Number(15,2) DECIMAL(14,2) NOT NULL Ceiling Days Maternity & Illness GP Mexico
20 GPMX_MAX_EM Number(15,2) DECIMAL(14,2) NOT NULL Max Ceiling Maternity & Illness GP Mexico
21 GPMX_CEIL_DAY_IV Number(15,2) DECIMAL(14,2) NOT NULL Ceiling Days Disability and Life GP Mexico
22 GPMX_MAX_IV Number(15,2) DECIMAL(14,2) NOT NULL Max Ceiling Disability and Life GP Mexico
23 GPMX_SDI_FIX Number(15,2) DECIMAL(14,2) NOT NULL Fixed SDI GP Mexico
24 GPMX_SDI_VAR Number(15,2) DECIMAL(14,2) NOT NULL Variable SDI GP Mexico
25 GPMX_SDI_FACTOR Number(19,6) DECIMAL(18,6) NOT NULL SDI Factor GP Mexico
26 GPMX_MIN_SAL_DIF Number(15,2) DECIMAL(14,2) NOT NULL Difference SMG and Daily Rate GP Mexico
27 GPMX_SDI_TOT Number(15,2) DECIMAL(14,2) NOT NULL SDI Total GP Mexico
28 SEQNUM Number(3,0) SMALLINT NOT NULL Sequence Number
29 ESTABID Character(12) VARCHAR2(12) NOT NULL Establishment ID
30 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
31 GPMX_PIN_ERN_NUM Number(8,0) INTEGER NOT NULL Earning Pin Num
32 GPMX_FIXSDI_TYPE Character(4) VARCHAR2(4) NOT NULL Fix SDI Type MEX
0010=General
0020=By Payee
33 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
34 GPMX_BASE_AMOUNT Signed Number(16,2) DECIMAL(14,2) NOT NULL Fix SDI Base Amount MEX
35 GPMX_BASE_DAY Signed Number(7,2) DECIMAL(5,2) NOT NULL Fix SDI Base Day MEX
36 GPMX_BASE_PCTG Signed Number(11,6) DECIMAL(9,6) NOT NULL Fix SDI Base Pctg MEX
37 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
38 GPMX_INT_BASE Character(4) VARCHAR2(4) NOT NULL Fix SDI Int Base MEX
0010=Daily Rate
0020=SDI
0030=Minimun Wage
0040=All
39 GPMX_INT_PCTG_LOW Signed Number(11,6) DECIMAL(9,6) NOT NULL Fix SDI Int Pctg Low MEX
40 GPMX_INT_PCTG_TOP Signed Number(11,6) DECIMAL(9,6) NOT NULL Fix SDI Int Pctg Top MEX
41 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
42 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
43 GPMX_MIN_WAGE_B Number(19,6) DECIMAL(18,6) NOT NULL Min Wage Zone B
44 GPMX_MIN_WAGE_C Number(19,6) DECIMAL(18,6) NOT NULL Min Wage Zone C
45 GPMX_BASE Number(15,2) DECIMAL(14,2) NOT NULL Base for Variability Report
46 GPMX_INTEG_BASE Number(15,2) DECIMAL(14,2) NOT NULL Integrable base for Variable SDI Report
47 GPMX_SDI_TYPE Character(4) VARCHAR2(4) NOT NULL SDI Type by Anniversary or SMG Change
0010=SDI by Anniversary
0020=SDI by UMA Change
0030=SDI Mass Calculation
0040=SDI Triggers
48 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
49 GPMX_BALANCE_YEAR Number(4,0) SMALLINT NOT NULL Balance Year GP Mexico