HRS_JOB_OPENING_IDJOBCODEHRS_JO_SCR_SUMM_IDHRS_JO_SCR_SEQHRS_SCREENING_IDN=No
Y=Yes
HRS_JO_SCR_SM_V(SQL View) |
Index Back |
|---|---|
Screenign ViewScreening View used on Job Opening |
| SELECT SCR.HRS_JOB_OPENING_ID , SCR.JOBCODE , SCR.HRS_JO_SCR_SUMM_ID , SCR.HRS_JO_SCR_SEQ , SCR.HRS_SCREENING_ID , SCR.JOBCODE_DESCR , SCR.hrs_jo_prm_jcd_flg , SCR.HRS_SCR_DESCR , SCR.HRS_JO_SCR_LVL_NM , SCR.HRS_JO_SCR_TOTAL , SCR.HRS_JO_SCR_PASSED , SCR.HRS_JO_SCR_FAILED , SCR.HRS_JO_SCR_UNAPPL , HIST.name_display , HIST.last_run_date FROM PS_HRS_JOSCRLVL_VW SCR LEFT OUTER JOIN PS_HRS_SCRPERHSTVW HIST ON scr.hrs_job_opening_id = hist.hrs_job_opening_id AND scr.hrs_screening_id = hist.hrs_screening_id |
| # | 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 | JOBCODE |
Character(6) | VARCHAR2(6) NOT NULL | Job Code |
| 3 | HRS_JO_SCR_SUMM_ID |
Number(15,0) | DECIMAL(15) NOT NULL | JO Screening Summary ID |
| 4 | HRS_JO_SCR_SEQ |
Number(3,0) | SMALLINT NOT NULL | Job opening screening sequence |
| 5 | HRS_SCREENING_ID |
Number(15,0) | DECIMAL(15) NOT NULL | Screening ID |
| 6 | HRS_JOB_CODE_NAME | Character(50) | VARCHAR2(50) NOT NULL | Job Code Name |
| 7 | HRS_JO_PRM_JCD_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Primary job code for job opening
N=No Y=Yes |
| 8 | HRS_SCR_DESCR | Character(30) | VARCHAR2(30) NOT NULL | Screening Level |
| 9 | HRS_JO_SCR_LVL_NM | Character(50) | VARCHAR2(50) NOT NULL | Screening Level |
| 10 | HRS_JO_SCR_TOTAL | Number(8,0) | INTEGER NOT NULL | Applicants Screened |
| 11 | HRS_JO_SCR_PASSED | Number(8,0) | INTEGER NOT NULL | Applicants Passed |
| 12 | HRS_JO_SCR_FAILED | Number(8,0) | INTEGER NOT NULL | Applicants Failed |
| 13 | HRS_JO_SCR_UNAPPL | Number(8,0) | INTEGER NOT NULL | Unapplied Results |
| 14 | NAME_DISPLAY | Character(50) | VARCHAR2(50) NOT NULL | Display Name - name formatted for Display based on the Country |
| 15 | HRS_RUN_DATETIME | DateTime(26) | TIMESTAMP | Run Date |