GPMX_IMS_QUOTA(SQL Table) |
Index Back |
---|---|
Social Security QuotasSocial Security Quotas GP Mexico |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | EFFDT | Date(10) | DATE NOT NULL |
Effective Date
Default Value: %date |
2 | GPMX_IMS_BRANCH | Character(4) | VARCHAR2(4) NOT NULL |
IMSS Branch GP Mexico
0010=E Y M PD 0020=E Y M PE 0030=E Y M CF 0040=E Y M E3SM 0050=I Y V 0060=G Y PS 0070=RETIRO 0080=C Y V 0090=INFONAVIT 0100=INFONAVIT AAE 0110=SAR AAE |
3 | GPMX_PYE_QUOTA | Number(19,6) | DECIMAL(18,6) NOT NULL | Payee Quota GP Mexico |
4 | GPMX_ER_QUOTA | Number(19,6) | DECIMAL(18,6) NOT NULL | Employer Quota % GP Mexico |
5 | GPMX_CEIL_DAY | Number(11,6) | DECIMAL(10,6) NOT NULL | Ceiling Days GP Mexico |