CLASSIDSCRTY_SET_CDPrompt Table: SCRTY_SET_TBL
SCRTY_TYPE_CDPrompt Table: SCRTY_TYPE_TBL
SCRTY_KEY1Prompt Table: %EDITTABLE
SCRTY_KEY2Prompt Table: %EDITTABLE2
SCRTY_KEY3Prompt Table: %EDITTABLE3
SJT_CLS_TMP(SQL Table) |
Index Back |
|---|---|
SJT for POI accessCombines the SCRTY_POI_CLASS and PSOPRCLS tables. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | CLASSID |
Character(30) | VARCHAR2(30) NOT NULL | The name of the class (see PSCLASSDEFN). |
| 2 | SCRTY_SET_CD |
Character(10) | VARCHAR2(10) NOT NULL |
Security Set
Prompt Table: SCRTY_SET_TBL |
| 3 | SCRTY_TYPE_CD |
Character(3) | VARCHAR2(3) NOT NULL |
Security Type for RowLevelSecurty
Prompt Table: SCRTY_TYPE_TBL |
| 4 | SCRTY_KEY1 |
Character(20) | VARCHAR2(20) NOT NULL |
Contains the value of the field used for row level security for Job access - setid.
Prompt Table: %EDITTABLE |
| 5 | SCRTY_KEY2 |
Character(20) | VARCHAR2(20) NOT NULL |
Contains the value of the field used for Rowlevelsecurity access to JOB
Prompt Table: %EDITTABLE2 |
| 6 | SCRTY_KEY3 |
Character(20) | VARCHAR2(20) NOT NULL |
Contains the value of the field used for Rowlevelsecurity access to JOB
Prompt Table: %EDITTABLE3 |
| 7 | TREE | Character(1) | VARCHAR2(1) NOT NULL | Tree |