GPIT_ESPATR_EE(SQL Table) |
Index Back |
|---|---|
Data for employee assignmentData for employee assignment |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  EMPLID |
Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 2 | EMPL_RCD |
Number(3,0) | SMALLINT NOT NULL | Empl Rcd Nbr |
| 3 | EFFDT |
Date(10) | DATE NOT NULL |
Effective Date
Default Value: %date |
| 4 | EFF_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Effective Status
A=Active I=Inactive Default Value: A |
| 5 | GPIT_ESP_DATFIN | Date(10) | DATE | Assignee in/out end date |
| 6 | COUNTRY | Character(3) | VARCHAR2(3) NOT NULL |
Country
Prompt Table: COUNTRY_TBL |
| 7 | GPIT_ESP_TIPO | Character(1) | VARCHAR2(1) NOT NULL |
Type of Assignee
E=Assignee out I=Assignee in |
| 8 | GPIT_ESP_CONTRIB | Character(2) | VARCHAR2(2) NOT NULL |
Contributive status
1E=Assignee out in EEC country 1I=Assignee in from EEC country 2E=Assignee out conventionate 2I=Assignee in partial convent 3E=Assignee out partial convent 3I=Assignee in non conventionate 4E=Assignee out non Conventionate |
| 9 | GPIT_ESP_TASSAZ | Character(2) | VARCHAR2(2) NOT NULL |
Taxation status
1T=Fiscally Exempt 2T=Fiscally Convent 3T=Fiscally Non Conventionate |