HRS_JO_ACMP_TAO(SQL Table) |
Index Back |
|---|---|
Requirements Srch-AccomplshmntJOB_RQMT_LICENS 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 professional licenses or certifications required for a job requisition or job code. You can create multiple JOB_RQMT_LICENS records per requisition or job code. |
| # | 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 | 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 | ACCOMPLISHMENT |
Character(8) | VARCHAR2(8) NOT NULL | Accomplishment |
| 5 | 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 |
| 6 | CM_IMPORTANCE_NBR | Number(3,0) | SMALLINT NOT NULL |
Competency Importance
Default Value: 3 |
| 7 | REQUIRED | Character(8) | VARCHAR2(8) NOT NULL |
Required
Y/N Table Edit Default Value: N |
| 8 | GVT_RECR_USE | Character(1) | VARCHAR2(1) NOT NULL |
Recruiting Use
A=Augmenting Factor M=Minimum Qualification Q=Quality Ranking Factor S=Selective Factor |
| 9 | POINTS | Number(4,0) | SMALLINT NOT NULL | Points |