GPMX_SDI_WA_AET(SQL Table) |
Index Back |
---|---|
SDI AETSDI Process 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 | GPMX_SRTY | Number(8,3) | DECIMAL(7,3) NOT NULL | Seniority GP Mexico |
4 | GPMX_MINWG_EZN | Number(15,2) | DECIMAL(14,2) NOT NULL | Minimum Wage Employee Zone GP Mexico |
5 | GPMX_CEIL_DAY_EM | Number(15,2) | DECIMAL(14,2) NOT NULL | Ceiling Days Maternity & Illness GP Mexico |
6 | GPMX_CEIL_DAY_IV | Number(15,2) | DECIMAL(14,2) NOT NULL | Ceiling Days Disability and Life GP Mexico |
7 | GPMX_MAX_EM | Number(15,2) | DECIMAL(14,2) NOT NULL | Max Ceiling Maternity & Illness GP Mexico |
8 | GPMX_MAX_IV | Number(15,2) | DECIMAL(14,2) NOT NULL | Max Ceiling Disability and Life GP Mexico |
9 | GPMX_SDI_FACTOR | Number(19,6) | DECIMAL(18,6) NOT NULL | SDI Factor GP Mexico |
10 | GPMX_MIN_SAL_DIF | Number(15,2) | DECIMAL(14,2) NOT NULL | Difference SMG and Daily Rate GP Mexico |
11 | GPMX_MINWG_AZN | Number(15,2) | DECIMAL(14,2) NOT NULL | Minimum Wage A Zone GP Mexico |
12 | GPMX_SDI_FIX | Number(15,2) | DECIMAL(14,2) NOT NULL | Fixed SDI GP Mexico |
13 | GPMX_SDI_VAR | Number(15,2) | DECIMAL(14,2) NOT NULL | Variable SDI GP Mexico |
14 | GPMX_SDI_TOT | Number(15,2) | DECIMAL(14,2) NOT NULL | SDI Total GP Mexico |
15 | SEQNUM | Number(3,0) | SMALLINT NOT NULL | Sequence Number |