SCRTY_SET_CDSCRTY_TYPE_CDPrompt Table: SCRTY_TYPE_TBL
CLASSIDSCRTY_KEY1Prompt Table: %EDITTABLE
SCRTY_KEY2Prompt Table: %EDITTABLE2
SCRTY_KEY3Prompt Table: %EDITTABLE3
Y/N Table Edit
Default Value: N
SJT_CLASS_AL5VW(SQL View) |
Index Back |
|---|---|
SJT for Operator Access ViewCombines the SCRTY_POI_CLASS and PSOPRCLS tables. This is loaded only thru APp Engines and Component save Peoplecode. It is the Operator Access Security Join Table for Row level security. It is used in the security views. |
| SELECT DISTINCT SCRTY_SET_CD ,SCRTY_TYPE_CD ,CLASSID , SCRTY_KEY1 ,SCRTY_KEY2 ,SCRTY_KEY3 ,TREE FROM PS_SJT_CLASS_ALL |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | SCRTY_SET_CD |
Character(10) | VARCHAR2(10) NOT NULL | Security Set |
| 2 | SCRTY_TYPE_CD |
Character(3) | VARCHAR2(3) NOT NULL |
Security Type for RowLevelSecurty
Prompt Table: SCRTY_TYPE_TBL |
| 3 | CLASSID |
Character(30) | VARCHAR2(30) NOT NULL | The name of the class (see PSCLASSDEFN). |
| 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
Y/N Table Edit Default Value: N |