UPG_JOB_CMP_TAO

(SQL Table)
Index Back

Requirements Srch-Competencies

JOB_RQMT_SKILL is part of a group of records used in Recruitment and Human Resources to search the database for applicants or employees who meet a set of search criteria. Use this record to identify skills required for a job requisition or job code. You can create multiple JOB_RQMT_SKILL records per requisition or job code.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 JOB_REQ_NBR Character(6) VARCHAR2(6) NOT NULL Job requisition number

Prompt Table: %RECNAME_EDIT

2 SCREENING_FLAG Character(1) VARCHAR2(1) NOT NULL Screening Flag
F=Final Screening
P=Preliminary Screening

Default Value: P

3 JOBCODE Character(6) VARCHAR2(6) NOT NULL Job Code
4 COMPETENCY Character(8) VARCHAR2(8) NOT NULL Competency

Prompt Table: COMPETENCY_TBL

5 PROFICIENCY Character(1) VARCHAR2(1) NOT NULL Proficiency

Default Value: 0

Prompt Table: REVW_RATING_TBL

6 CM_IMPORTANCE Character(1) VARCHAR2(1) NOT NULL Competency Importance
1=1-Low
2=2-Below Average
3=3-Average
4=4-Above Average
5=5-High

Default Value: 3

7 CM_IMPORTANCE_NBR Number(3,0) SMALLINT NOT NULL Competency Importance

Default Value: 3

8 REQUIRED Character(8) VARCHAR2(8) NOT NULL Required

Y/N Table Edit

Default Value: N

9 PROFICIENCY_MAND Character(1) VARCHAR2(1) NOT NULL Proficiency mandatory

Y/N Table Edit

Default Value: N

10 GVT_RECR_USE Character(1) VARCHAR2(1) NOT NULL Recruiting Use
A=Augmenting Factor
M=Minimum Qualification
Q=Quality Ranking Factor
S=Selective Factor