EFFDTDefault Value: %date
A=Active
I=Inactive
Default Value: A
Prompt Table: CURRENCY_CD_TBL
GPES_STATUTORY(SQL Table) |
Index Back |
|---|---|
Statutory ratesStatutory rates to calculate other earnings excess amounts. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | EFFDT |
Date(10) | DATE NOT NULL |
Effective Date
Default Value: %date |
| 2 | EFF_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Effective Status
A=Active I=Inactive Default Value: A |
| 3 | CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL |
Currency Code
Prompt Table: CURRENCY_CD_TBL |
| 4 | GPES_SMI_MTHLY | Number(11,2) | DECIMAL(10,2) NOT NULL | Monthly SMI (Salario Minimo Interprofessional) |
| 5 | GPES_SMI_DAILY | Number(11,2) | DECIMAL(10,2) NOT NULL | Daily SMI (Salario Minimo Interprofessional) |
| 6 | GPES_STATRY_INT | Number(6,2) | DECIMAL(5,2) NOT NULL | Statutory interest rate |
| 7 | GPES_EX_PCT_IPREM | Number(6,2) | DECIMAL(5,2) NOT NULL | Excess percentage over SMI (Salario Minimo Interprofesional) |
| 8 | GPES_IPREM_MTHLY | Number(11,2) | DECIMAL(10,2) NOT NULL | IPREM Monthly rate |
| 9 | GPES_IPREM_DAILY | Number(11,2) | DECIMAL(10,2) NOT NULL | Global Payroll Spain |
| 10 | GPES_SMI_PART_TIME | Number(11,2) | DECIMAL(10,2) NOT NULL | Daily SMI (Salario Minimo Interprofessional) |