EMPLIDHRS_APP_EMP_VW(SQL View) |
Index Back |
|---|---|
Appl- Empl View (Sal pacakge)Applicant view to conver APPLID to EMPLID as used by salary packaging |
| SELECT A.EMPLID ,B.NAME FROM PS_HRS_APPLICANT A , PS_HRS_APP_NAMES 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 | NAME | Character(50) | VARCHAR2(50) NOT NULL | Name |