HRS_JO_SCR_TMP(SQL Table) |
Index Back |
|---|---|
Job Opening Screening Temp RecTemporary record for job opening screening criteria setup |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  HRS_JO_SCR_TYPE |
Character(2) | VARCHAR2(2) NOT NULL |
Job opening screening criteria type
10=General Requirement 20=Accomplishment 30=Competency 40=Education & Experience 50=Screening Question |
| 2 | HRS_JO_SCR_RQMT |
Character(10) | VARCHAR2(10) NOT NULL | Screening Criteria Requirement |
| 3 | DESCR50 | Character(50) | VARCHAR2(50) NOT NULL | Description of length 50 |
| 4 | HRS_JO_SCR_USE | Character(1) | VARCHAR2(1) NOT NULL |
Flag to mark usage in screening
Y/N Table Edit Default Value: N |
| 5 | HRS_JO_SCR_REQD | Character(1) | VARCHAR2(1) NOT NULL |
Job Opening Screening Requirement Required
Y/N Table Edit Default Value: N |
| 6 | HRS_JO_SCR_AUGMENT | Character(1) | VARCHAR2(1) NOT NULL |
Augmentation factor
Y/N Table Edit Default Value: N |
| 7 | HRS_JO_SCR_SELECT | Character(1) | VARCHAR2(1) NOT NULL |
Selective factor
Y/N Table Edit Default Value: N |
| 8 | POINTS | Number(4,0) | SMALLINT NOT NULL | Points |