HRS_JO_SCR_ITEM(SQL Table) |
Index Back |
|---|---|
JO Content Screen CriteriaJob opening Content screening criteria. This stores the key fields for an item that will be used in screening for all content types and items in a JO |
| # | 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_SUMM |
| 2 | HRS_JO_SCR_SEQ |
Number(3,0) | SMALLINT NOT NULL |
Job opening screening sequence
Prompt Table: HRS_JO_SCR_LVL |
| 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 | EFFDT | Date(10) | DATE |
Effective Date
Default Value: %date |
| 10 | JPM_ITEM_KEY_ID | Number(12,0) | DECIMAL(12) NOT NULL | Unique identifier of an item within a profile. This is the primary key of profile items. It is a generic autoassigned value (a number). The unique key permits the addition of items that are not inheritently unique. They may have the same effective date, item type, item id, yet differ in a property or other value. The concept of key fields in a profile is a loose term as an object in a profile can have very different needs in identification. |
| 11 | POINTS | Signed Number(5,0) | DECIMAL(4) NOT NULL | Points |
| 12 | HRS_JO_SCR_REQD | Character(1) | VARCHAR2(1) NOT NULL |
Job Opening Screening Requirement Required
Y/N Table Edit Default Value: N |
| 13 | HRS_RVW_REQUIRED | Character(1) | VARCHAR2(1) NOT NULL | Required |
| 14 | HRS_JO_SCR_AUGMENT | Character(1) | VARCHAR2(1) NOT NULL |
Augmentation factor
Y/N Table Edit Default Value: N |
| 15 | HRS_JO_SCR_SELECT | Character(1) | VARCHAR2(1) NOT NULL |
Selective factor
Y/N Table Edit Default Value: N |
| 16 | HRS_ROW_ADD_DTTM | DateTime(26) | TIMESTAMP | Row Added DateTime |
| 17 | HRS_ROW_ADD_OPRID | Character(30) | VARCHAR2(30) NOT NULL | Row Added Operator Id |
| 18 | HRS_ROW_UPD_DTTM | DateTime(26) | TIMESTAMP | Row Updated DateTime |
| 19 | HRS_ROW_UPD_OPRID | Character(30) | VARCHAR2(30) NOT NULL | Row Updated Operator Id |