HRS_LVL_LST_LVW(SQL View) |
Index Back |
---|---|
Screening Level ListsReturns a list of screening levels associated with the job opening/jobcode. Used on the screening component |
SELECT DISTINCT A.HRS_JOB_OPENING_ID ,A.JOBCODE ,A.HRS_SCREENING_ID ,B.LANGUAGE_CD ,B.DESCR FROM PS_HRS_SCR_RSLT A , PS_HRS_SCREEN_LN_I B WHERE A.HRS_SCREENING_ID = B.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_SCREENING_ID | Number(15,0) | DECIMAL(15) NOT NULL | Screening ID |
4 | LANGUAGE_CD | Character(3) | VARCHAR2(3) NOT NULL | Language Code |
5 | HRS_SCR_DESCR | Character(30) | VARCHAR2(30) NOT NULL | Screening Level |