CLASSIDPrompt Table: PSCLASSDEFN
SCRTY_SET_CDPrompt Table: SCRTY_SET_TBL
SCRTY_TYPE_CDPrompt Table: SCRTY_SETCLS_VW
SCRTY_KEY1Prompt Table: %EDITTABLE
SCRTY_KEY2Prompt Table: %EDITTABLE2
SCRTY_KEY3Prompt Table: %EDITTABLE3
SJT_CLASS(SQL Table) |
Index Back |
|---|---|
SJT record for CLASS |
| # | 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).
Prompt Table: 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_SETCLS_VW |
| 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 |