HRS_HIRE_DESP(SQL View) |
Index Back |
|---|---|
Hire - Disability SpainHire Integration - Disability Spain |
| SELECT B.EMPLID ,A.HRS_PERSON_ID ,A.EFFDT ,A.DISABLE_TYPE_ESP ,A.HANDICAP_PCNT_ESP ,A.DISAB_EVAL_DT_ESP ,A.DISAB_CARD_NO_ESP ,A.CARD_ISSUE_DT_ESP ,A.CARD_EXP_DT_ESP ,A.DIS_STATUS_OFF_ESP ,A.CITY ,A.POSTAL ,B.HRS_HIRE_SEQ FROM PS_HRS_APP_DIS_ESP A , PS_HRS_HIRE B WHERE A.HRS_PERSON_ID = B.HRS_PERSON_ID |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  EMPLID |
Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 2 | HRS_PERSON_ID |
Number(15,0) | DECIMAL(15) NOT NULL | Person Id |
| 3 | EFFDT |
Date(10) | DATE |
Effective Date
Default Value: %date |
| 4 | DISABLE_TYPE_ESP | Character(3) | VARCHAR2(3) NOT NULL |
Disability Type
F=Physical Disability N=Non Disability P=Psychological Disability S=Sensorial Disability |
| 5 | HANDICAP_PCNT_ESP | Number(3,0) | SMALLINT NOT NULL | Handicap Percent |
| 6 | DISAB_EVAL_DT_ESP | Date(10) | DATE | Disability Evaluation Dt |
| 7 | DISAB_CARD_NO_ESP | Character(10) | VARCHAR2(10) NOT NULL | Disalbility Card No. |
| 8 | CARD_ISSUE_DT_ESP | Date(10) | DATE | Card Issue Date |
| 9 | CARD_EXP_DT_ESP | Date(10) | DATE | Card Expiration Date |
| 10 | 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 |
| 11 | CITY | Character(30) | VARCHAR2(30) NOT NULL | City |
| 12 | POSTAL | Character(12) | VARCHAR2(12) NOT NULL | Postal |
| 13 | HRS_HIRE_SEQ | Number(10,0) | DECIMAL(10) NOT NULL | Hire Sequence ID |