SCRTY_TYPE_CDPrompt Table: SCRTY_TYPE_TBL
SCRTY_KEY1SCRTY_KEY2SCRTY_KEY3HRS_SJT_JO_VW(SQL View) |
Index Back |
|---|---|
Job Opening Security Join TblJob Opening Security Join Table - this table contains the denormalized security related attributes from Job Opening. This table is used to join to the HRMS Security framework. |
| SELECT SCRTY_TYPE_CD ,SCRTY_KEY1 ,SCRTY_KEY2 ,SCRTY_KEY3 ,HRS_JOB_OPENING_ID ,EMPLID ,FUTURE_FLG FROM PS_HRS_SJT_JO |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | SCRTY_TYPE_CD |
Character(3) | VARCHAR2(3) NOT NULL |
Security Type for RowLevelSecurty
Prompt Table: SCRTY_TYPE_TBL |
| 2 | SCRTY_KEY1 |
Character(20) | VARCHAR2(20) NOT NULL | Contains the value of the field used for row level security for Job access - setid. |
| 3 | SCRTY_KEY2 |
Character(20) | VARCHAR2(20) NOT NULL | Contains the value of the field used for Rowlevelsecurity access to JOB |
| 4 | SCRTY_KEY3 |
Character(20) | VARCHAR2(20) NOT NULL | Contains the value of the field used for Rowlevelsecurity access to JOB |
| 5 | HRS_JOB_OPENING_ID | Number(15,0) | DECIMAL(15) NOT NULL | Job Opening Clone |
| 6 | EMPLID | Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 7 | FUTURE_FLG | Character(1) | VARCHAR2(1) NOT NULL | Flag for the SJT_*** record that indicates whether this is a future dated row or not. Y = Future N = Current |