HRS_JO_APPA_VW2(SQL View) |
Index Back |
|---|
| SELECT A.HRS_JOB_OPENING_ID ,A.STATUS_CODE ,A.HRS_PERSON_ID ,A.HRS_RCMNT_ID ,A.HRS_PROFILE_SEQ ,A.HRS_APP_INTEREST ,A.ENTRY_DATE ,A.STATUS_REASON ,B.DESCRSHORT ,B.DESCR ,A.HRS_STATUS_DT ,B.STATUS_PHASE ,NM.LAST_NAME ,APP.APP_PER_STATUS ,A.HRS_ROW_UPD_DTTM ,PROF.PREV_EMPL_BY_COMPY FROM PS_HRS_RCMNT A , PS_HRS_APPLICANT APP , PS_HRS_APP_PROFILE PROF , PS_HRS_STS_TBL B , PS_HRS_APP_NAMES NM WHERE APP.HRS_PERSON_ID = A.HRS_PERSON_ID AND PROF.HRS_PERSON_ID = A.HRS_PERSON_ID AND PROF.HRS_PROFILE_SEQ = A.HRS_PROFILE_SEQ AND B.STATUS_CODE = A.STATUS_CODE AND NM.HRS_PERSON_ID = A.HRS_PERSON_ID AND B.STATUS_AREA = '3' AND B.HRS_DRFT_STS_IND IN ('N', ' ') AND NM.NAME_TYPE = 'PRI' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | HRS_JOB_OPENING_ID | Number(15,0) | DECIMAL(15) NOT NULL | Job Opening Clone |
| 2 | STATUS_CODE | Character(3) | VARCHAR2(3) NOT NULL | Identifies a status. |
| 3 | HRS_PERSON_ID | Number(15,0) | DECIMAL(15) NOT NULL | Person Id |
| 4 | HRS_RCMNT_ID | Number(15,0) | DECIMAL(15) NOT NULL | App Tracking Recruitment ID |
| 5 | HRS_PROFILE_SEQ | Number(3,0) | SMALLINT NOT NULL | Profile sequece |
| 6 | HRS_APP_INTEREST | Character(1) | VARCHAR2(1) NOT NULL |
Applicant Interest
1=Low 2=Medium 3=High |
| 7 | ENTRY_DATE | Date(10) | DATE | Date Entered |
| 8 | STATUS_REASON | Character(3) | VARCHAR2(3) NOT NULL | Identifies a reason associated with a particular status. |
| 9 | DESCRSHORT | Character(10) | VARCHAR2(10) NOT NULL | Short Description |
| 10 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 11 | HRS_STATUS_DT | Date(10) | DATE | Recruiting Solutions Status Date field |
| 12 | STATUS_PHASE | Character(1) | VARCHAR2(1) NOT NULL |
Identifies a phase within a status area.
1=1-Applied 2=2-Reviewed 3=3-Screen 4=4-Route 5=5-Interview 6=6-Offer 7=7-Hire 8=8-Hold 9=9-Reject |
| 13 | LAST_NAME | Character(30) | VARCHAR2(30) NOT NULL | Last Name |
| 14 | 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 |
| 15 | HRS_ROW_UPD_DTTM | DateTime(26) | TIMESTAMP | Row Updated DateTime |
| 16 | PREV_EMPL_BY_COMPY | Character(1) | VARCHAR2(1) NOT NULL |
Previously Employed by Company
N=No Y=Yes |