HRS_JOB_OPENING_IDSCREENING_FLAGF=Final Screening
P=Preliminary Screening
Default Value: P
JOBCODECOMPETENCYPrompt Table: COMPETENCY_TBL
REVIEW_RATINGHRS_JO_CMPT_TAO(SQL Table) |
Index Back |
|---|---|
Proficiency Scores for Comp |
| # | 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 | COMPETENCY |
Character(8) | VARCHAR2(8) NOT NULL |
Competency
Prompt Table: COMPETENCY_TBL |
| 5 | REVIEW_RATING |
Character(1) | VARCHAR2(1) NOT NULL | Review Rating |
| 6 | POINTS | Number(4,0) | SMALLINT NOT NULL | Points |