CTZ_DTA_ESP_TBL(SQL Table) |
Index Back |
|---|---|
Contribution Concept Tbl - ESPContribution Concept Table - ESP |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  SCHEME_ID_ESP |
Character(4) | VARCHAR2(4) NOT NULL | Scheme ID - ESP |
| 2 | CURRENCY_CD |
Character(3) | VARCHAR2(3) NOT NULL |
Currency Code
Prompt Table: CURRENCY_CD_TBL |
| 3 | EFFDT |
Date(10) | DATE NOT NULL |
Effective Date
Default Value: %date |
| 4 | CONTRIB_ID_ESP |
Character(5) | VARCHAR2(5) NOT NULL | Soc.Sec. Contribution ID - ESP |
| 5 | CONCEPT_ESP |
Character(2) | VARCHAR2(2) NOT NULL |
Social Security contribution concept
10=Common Contingency 20=Temporal Disability 30=Permanent Disability D & S 40=Professional Training 50=FOGASA 60=Unemployment 70=Structural Overtime 80=Non Structural Overtime |
| 6 | EE_PERCENT_ESP | Signed Number(11,6) | DECIMAL(9,6) NOT NULL | Employee Percentage - ESP |
| 7 | ER_PERCENT_ESP | Signed Number(11,6) | DECIMAL(9,6) NOT NULL | Employer Percentage - ESP |
| 8 | EE_RATE_ESP | Signed Number(20,6) | DECIMAL(18,6) NOT NULL | Employee Rate - ESP |
| 9 | ER_RATE_ESP | Signed Number(20,6) | DECIMAL(18,6) NOT NULL | Employer Rate - ESP |