HRS_SCR_CMP_VW(SQL View) |
Index Back |
---|---|
Screening CompetenciesProvides a unique list of competencies that are used as screening critiera in any screening level associated with a job opening. This view is used to provide a list of competencies 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.COMPETENCY , D.DESCR , C.POINTS , C.HRS_JO_SCR_REQD , C.HRS_JO_SCR_AUGMENT , C.HRS_JO_SCR_SELECT , D.RATING_MODEL , %subrec(HRS_AUDIT_SBR, C) FROM PS_HRS_RATE_JC_VW A , PS_HRS_RATE_SCR_VW B , PS_HRS_JO_SCR_CM_I C , PS_COMPETENCY_TBL D 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.COMPETENCY = D.COMPETENCY |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | Number(15,0) | DECIMAL(15) NOT NULL | Job Opening Clone | |
2 | Character(6) | VARCHAR2(6) NOT NULL | Job Code | |
3 | Number(15,0) | DECIMAL(15) NOT NULL | JO Screening Summary ID | |
4 | Number(3,0) | SMALLINT NOT NULL | Job opening screening sequence | |
5 | Number(15,0) | DECIMAL(15) NOT NULL | Screening ID | |
6 | Character(8) | VARCHAR2(8) NOT NULL | Competency | |
7 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
8 | POINTS | Number(4,0) | SMALLINT NOT NULL | Points |
9 | HRS_JO_SCR_REQD | Character(1) | VARCHAR2(1) NOT NULL |
Job Opening Screening Requirement Required
Y/N Table Edit Default Value: N |
10 | HRS_JO_SCR_AUGMENT | Character(1) | VARCHAR2(1) NOT NULL |
Augmentation factor
Y/N Table Edit Default Value: N |
11 | HRS_JO_SCR_SELECT | Character(1) | VARCHAR2(1) NOT NULL |
Selective factor
Y/N Table Edit Default Value: N |
12 | RATING_MODEL | Character(4) | VARCHAR2(4) NOT NULL | Rating Model |
13 | HRS_ROW_ADD_DTTM | DateTime(26) | TIMESTAMP | Row Added DateTime |
14 | HRS_ROW_ADD_OPRID | Character(30) | VARCHAR2(30) NOT NULL | Row Added Operator Id |
15 | HRS_ROW_UPD_DTTM | DateTime(26) | TIMESTAMP | Row Updated DateTime |
16 | HRS_ROW_UPD_OPRID | Character(30) | VARCHAR2(30) NOT NULL | Row Updated Operator Id |