CLASSIDSCRTY_TYPE_CDPrompt Table: SCRTY_TYPE_TBL
SCRTY_KEY1Prompt Table: %EDITTABLE
SCRTY_KEY2Prompt Table: %EDITTABLE2
SCRTY_KEY3Prompt Table: %EDITTABLE3
Y/N Table Edit
Default Value: N
SJT_CLASS_AL2VW(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 CLASSID ,SCRTY_TYPE_CD ,SCRTY_KEY1 ,SCRTY_KEY2 ,SCRTY_KEY3 ,TREE FROM PS_SJT_CLASS_ALL |
| # | 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_TYPE_CD |
Character(3) | VARCHAR2(3) NOT NULL |
Security Type for RowLevelSecurty
Prompt Table: SCRTY_TYPE_TBL |
| 3 | 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 |
| 4 | SCRTY_KEY2 |
Character(20) | VARCHAR2(20) NOT NULL |
Contains the value of the field used for Rowlevelsecurity access to JOB
Prompt Table: %EDITTABLE2 |
| 5 | SCRTY_KEY3 |
Character(20) | VARCHAR2(20) NOT NULL |
Contains the value of the field used for Rowlevelsecurity access to JOB
Prompt Table: %EDITTABLE3 |
| 6 | TREE | Character(1) | VARCHAR2(1) NOT NULL |
Tree
Y/N Table Edit Default Value: N |