UPG_JOB_CMP_TAO(SQL Table) |
Index Back |
|---|---|
Requirements Srch-CompetenciesJOB_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 |