CLASSIDPrompt Table: PSCLASSDEFN
SCRTY_SET_CDPrompt Table: SCRTY_SET_TBL
SCRTY_TYPE_CDPrompt Table: SCRTY_SETCLS_VW
LANGUAGE_CDSJT_CLS_VW2_LNG(SQL View) |
Index Back |
|---|---|
SJT record for CLASS |
| SELECT DISTINCT A.CLASSID , A.SCRTY_SET_CD , A.scrty_type_cd ,D.LANGUAGE_CD , D.descr FROM PS_SJT_CLASS A , PS_SCRTY_TYPE_LNG D WHERE A.SCRTY_SET_CD = D.SCRTY_SET_CD AND A.SCRTY_TYPE_CD = D.SCRTY_TYPE_CD |
| # | 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 | LANGUAGE_CD |
Character(3) | VARCHAR2(3) NOT NULL | Language Code |
| 5 | DESCR_ACCESS_TYPE | Character(30) | VARCHAR2(30) NOT NULL | Access Type Description |