JOB_REQ_NBRJOBCODEACCOMPLISHMENTPrompt Table: ACCOMP_TBL
1=1-Low
2=2-Below Average
3=3-Average
4=4-Above Average
5=5-High
A=Augmenting Factor
M=Minimum Qualification
Q=Quality Ranking Factor
S=Selective Factor
Y/N Table Edit
Default Value: N
GVT_CR_PLN_ACMP(SQL Table) |
Index Back |
|---|---|
Crediting Plan Accomplishments |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | JOB_REQ_NBR |
Character(6) | VARCHAR2(6) NOT NULL | Job requisition number |
| 2 | JOBCODE |
Character(6) | VARCHAR2(6) NOT NULL | Job Code |
| 3 | ACCOMPLISHMENT |
Character(8) | VARCHAR2(8) NOT NULL |
Accomplishment
Prompt Table: ACCOMP_TBL |
| 4 | 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 |
| 5 | GVT_RECR_USE | Character(1) | VARCHAR2(1) NOT NULL |
Recruiting Use
A=Augmenting Factor M=Minimum Qualification Q=Quality Ranking Factor S=Selective Factor |
| 6 | GVT_REQUIRED | Character(1) | VARCHAR2(1) NOT NULL |
Required
Y/N Table Edit Default Value: N |
| 7 | POINTS | Number(4,0) | SMALLINT NOT NULL | Points |