RECRUITER_IDADM_APPL_NBREMPLIDPrompt Table: PEOPLE_SRCH
APPL_RCR_VW2(SQL View) |
Index Back |
|---|---|
Recruiter Applicants by CatagyAPPL_RCR_VW summaries all Applications of the Recruiter by catagory. |
| SELECT DISTINCT A.RECRUITER_ID , A.ADM_APPL_NBR , B.EMPLID FROM PS_ADM_APPL_RCTER A , PS_ADM_APPL_DATA B , PS_RECRUIT_CAT_TBL C WHERE A.INSTITUTION = B.INSTITUTION AND A.ACAD_CAREER = B.ACAD_CAREER AND A.ADM_APPL_NBR = B.ADM_APPL_NBR AND A.EMPLID = B.EMPLID AND A.INSTITUTION = C.INSTITUTION AND A.RECRUITMENT_CAT = C.RECRUITMENT_CAT |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | RECRUITER_ID |
Character(11) | VARCHAR2(11) NOT NULL | Recruiter ID |
| 2 | ADM_APPL_NBR |
Character(8) | VARCHAR2(8) NOT NULL | Application Nbr |
| 3 | EMPLID |
Character(11) | VARCHAR2(11) NOT NULL |
Employee ID
Prompt Table: PEOPLE_SRCH |