HRS_SCR_CRT_LVW(SQL View) |
Index Back |
---|---|
Screening Lic/CertProvides a unique list of accomplishments (licenses/certifications) that are used as screening critiera in any screening level associated with a job opening. This view is used to provide a list of accomplishment on which an applicant should be rated through the "Rate Applicants" component. |
SELECT DISTINCT A.HRS_JOB_OPENING_ID ,A.JOBCODE ,A.HRS_JO_SCR_SUMM_ID ,B.HRS_JO_SCR_SEQ ,B.HRS_SCREENING_ID , C.ACCOMPLISHMENT , E.LANGUAGE_CD , E.DESCR FROM PS_HRS_RATE_JC_VW A , PS_HRS_RATE_SCR_VW B , PS_HRS_JO_SCR_AC_I C , PS_ACCOMP_TBL D , PS_ACCOMP_TBL_LANG E WHERE A.HRS_JO_SCR_SUMM_ID = B.HRS_JO_SCR_SUMM_ID AND B.HRS_JO_SCR_SUMM_ID = C.HRS_JO_SCR_SUMM_ID AND B.HRS_JO_SCR_SEQ = C.HRS_JO_SCR_SEQ AND C.ACCOMPLISHMENT = D.ACCOMPLISHMENT AND D.ACCOMP_CATEGORY = 'LIC' AND E.ACCOMPLISHMENT = D.ACCOMPLISHMENT |
# | 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 | ACCOMPLISHMENT | Character(8) | VARCHAR2(8) NOT NULL |
Accomplishment
Prompt Table: HRS_ACCOM_TBL_I |
7 | LANGUAGE_CD | Character(3) | VARCHAR2(3) NOT NULL | Language Code |
8 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |