HRS_JO_SCR_IP_I(SQL View) |
Index Back |
|---|---|
JO Qstn Scr Criteria Intfc.Interface for job opening screening JPM Points for screening criteria. |
| SELECT A.HRS_JO_SCR_SUMM_ID , A.HRS_JO_SCR_SEQ , A.JPM_PROFILE_ID , A.JPM_CAT_TYPE , A.JPM_CAT_ITEM_ID , A.JPM_CAT_ITEM_QUAL , A.JPM_CAT_ITEM_QUAL2 , A.FIELDNAME , A.HRS_REVIEW_RATING , A.EFFDT , A.POINTS , %subrec(HRS_AUDIT_SBR, A) FROM PS_HRS_JO_SCR_ITMP A |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  HRS_JO_SCR_SUMM_ID |
Number(15,0) | DECIMAL(15) NOT NULL |
JO Screening Summary ID
Prompt Table: HRS_JO_SCR_SM_I |
| 2 | HRS_JO_SCR_SEQ |
Number(3,0) | SMALLINT NOT NULL |
Job opening screening sequence
Prompt Table: HRS_JO_SCR_LV_I |
| 3 | JPM_PROFILE_ID |
Character(12) | VARCHAR2(12) NOT NULL | The id, autoassigned or user assigned of the profile. This id is used to group items and other related material together into one coherent profile. |
| 4 | JPM_CAT_TYPE |
Character(12) | VARCHAR2(12) NOT NULL | The name of the type of items that will be used in a Catalog and or in a Profile. |
| 5 | JPM_CAT_ITEM_ID |
Character(12) | VARCHAR2(12) NOT NULL | Catalog Item Id. Identifies a unique catalog item defintion within a catalog type. |
| 6 | JPM_CAT_ITEM_QUAL |
Character(12) | VARCHAR2(12) NOT NULL | Low Order Item key for Catalog Items when appearing in a Profile. For most Catalog Types, this will be blank - but is available if an Item needs to have multiple instances for a given Effdt in a Profile. Example: for CatalogType = Compentency, there can be multiple instances for a particular Competency, each representing a different evaluation source (Self-Eval, Mgr Eval, Approved/Official, Learning, Recruiting). |
| 7 | JPM_CAT_ITEM_QUAL2 |
Character(12) | VARCHAR2(12) NOT NULL | Low Order Item key for Catalog Items when appearing in a Profile. For most Catalog Types, this will be blank - but is available if an Item needs to have multiple instances for a given Effdt in a Profile. Example: for CatalogType = Compentency, there can be multiple instances for a particular Competency, each representing a different evaluation source (Self-Eval, Mgr Eval, Approved/Official, Learning, Recruiting). |
| 8 | FIELDNAME |
Character(18) | VARCHAR2(18) NOT NULL | Field Name (see PSDBFIELD). |
| 9 | HRS_REVIEW_RATING |
Character(3) | VARCHAR2(3) NOT NULL |
Review Rating
Prompt Table: HRS_RATING_I |
| 10 | EFFDT | Date(10) | DATE |
Effective Date
Default Value: %date |
| 11 | POINTS | Signed Number(5,0) | DECIMAL(4) NOT NULL | Points |
| 12 | HRS_ROW_ADD_DTTM | DateTime(26) | TIMESTAMP | Row Added DateTime |
| 13 | HRS_ROW_ADD_OPRID | Character(30) | VARCHAR2(30) NOT NULL | Row Added Operator Id |
| 14 | HRS_ROW_UPD_DTTM | DateTime(26) | TIMESTAMP | Row Updated DateTime |
| 15 | HRS_ROW_UPD_OPRID | Character(30) | VARCHAR2(30) NOT NULL | Row Updated Operator Id |