HRS_PERSON_IDHRS_PROFILE_SEQA=External Applicant
E=Employee
N=Non-Employee
HRS_APPLCANT_VW(SQL View) |
Index Back |
|---|---|
Job ApplicantsView of all job applicants. Used to build Applicant Profile search index. |
| SELECT STG.HRS_PERSON_ID , STG.HRS_PROFILE_SEQ , B.HRS_SUBMITTED_DTTM , A.APP_PER_STATUS , A.STATUS_CODE , C.NAME_DISPLAY , B.PREV_EMPL_BY_COMPY , B.HRS_ROW_ADD_DTTM , B.HRS_ROW_ADD_OPRID , STG. HRS_ROW_UPD_DTTM , B.HRS_ROW_UPD_OPRID FROM PS_HRS_APPLICANT A , PS_HRS_APP_PROFILE B , PS_HRS_APP_NAMES C , PS_HRS_APPCNT_STG STG WHERE A.HRS_PERSON_ID = B.HRS_PERSON_ID AND A.HRS_PERSON_ID = C.HRS_PERSON_ID AND STG.HRS_PERSON_ID=A.HRS_PERSON_ID AND STG.HRS_PROFILE_SEQ=B.HRS_PROFILE_SEQ |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | HRS_PERSON_ID |
Number(15,0) | DECIMAL(15) NOT NULL | Person Id |
| 2 | HRS_PROFILE_SEQ |
Number(3,0) | SMALLINT NOT NULL | Profile sequece |
| 3 | HRS_SUBMITTED_DTTM | DateTime(26) | TIMESTAMP | Submitted Date Time |
| 4 | APP_PER_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Identifies the type of applicant - External Applicant, Employee or Non-Employee
A=External Applicant E=Employee N=Non-Employee |
| 5 | STATUS_CODE | Character(3) | VARCHAR2(3) NOT NULL | Identifies a status. |
| 6 | NAME_DISPLAY | Character(50) | VARCHAR2(50) NOT NULL | Display Name - name formatted for Display based on the Country |
| 7 | HRS_FORMER_EMPL | Character(1) | VARCHAR2(1) NOT NULL | Are you a former employee? |
| 8 | HRS_ROW_ADD_DTTM | DateTime(26) | TIMESTAMP | Row Added DateTime |
| 9 | HRS_ROW_ADD_OPRID | Character(30) | VARCHAR2(30) NOT NULL | Row Added Operator Id |
| 10 | HRS_ROW_UPD_DTTM | DateTime(26) | TIMESTAMP | Row Updated DateTime |
| 11 | HRS_ROW_UPD_OPRID | Character(30) | VARCHAR2(30) NOT NULL | Row Updated Operator Id |