DISABILITY_ESP(SQL Table) |
Index Back |
|---|---|
Disability Table - ESPSpanish Disability Table |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  EMPLID |
Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 2 | EFFDT |
Date(10) | DATE | Effective Date |
| 3 | DISABLE_TYPE_ESP | Character(3) | VARCHAR2(3) NOT NULL |
Disability Type
F=Physical Disability N=Non Disability P=Psychological Disability S=Sensorial Disability |
| 4 | HANDICAP_PCNT_ESP | Number(3,0) | SMALLINT NOT NULL | Handicap Percent |
| 5 | DISAB_EVAL_DT_ESP | Date(10) | DATE | Disability Evaluation Dt |
| 6 | DISAB_CARD_NO_ESP | Character(10) | VARCHAR2(10) NOT NULL | Disalbility Card No. |
| 7 | CARD_ISSUE_DT_ESP | Date(10) | DATE | Card Issue Date |
| 8 | CARD_EXP_DT_ESP | Date(10) | DATE | Card Expiration Date |
| 9 | DIS_STATUS_OFF_ESP | Character(4) | VARCHAR2(4) NOT NULL |
Disability Status Office
FST=Social Security Office HFST=Main Social Security Office LAA=Regional Employment Office LRA=District Admin of a Land REGP=Chief Officer - District Admin VA=Land War Pension Office ZST=Document for support of miners |
| 10 | CITY | Character(30) | VARCHAR2(30) NOT NULL | City |
| 11 | POSTAL | Character(12) | VARCHAR2(12) NOT NULL | Postal |
| 12 | HELP_GO_WRK_ESP_SW | Character(1) | VARCHAR2(1) NOT NULL |
Help to Go to Work
Y/N Table Edit |