SCRTY_TYPE_PVW

(SQL View)
 Index Back

Security Type Table

Setup Table for Row Level Security types used to access People.

SELECT SCRTY_TYPE_CD ,ENABLED ,KEY2_PROMPT_REC ,KEY2_PROMPT_FLD ,KEY3_PROMPT_REC ,KEY3_PROMPT_FLD FROM PS_SCRTY_TYPE_TBL WHERE SCRTY_SET_CD = 'PPLPOI'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 SCRTY_TYPE_CD Character(3) VARCHAR2(3) NOT NULL Security Type for RowLevelSecurty
2 ENABLED Character(1) VARCHAR2(1) NOT NULL A flag indicates whether this row is enabled or not.

Y/N Table Edit

Default Value: Y

3 KEY2_PROMPT_REC Character(15) VARCHAR2(15) NOT NULL Scrty_type_tbl prompt field for security Key 1

Prompt Table: KEY2_PRMPT_VW

4 KEY2_PROMPT_FLD Character(18) VARCHAR2(18) NOT NULL Scrty_type_tbl prompt field for security Key 1

Prompt Table: %EDITTABLE2

5 KEY3_PROMPT_REC Character(15) VARCHAR2(15) NOT NULL Scrty_type_tbl prompt field for security Key 1

Prompt Table: KEY3_PRMPT_VW

6 KEY3_PROMPT_FLD Character(18) VARCHAR2(18) NOT NULL Scrty_type_tbl prompt field for security Key 1

Prompt Table: %EDITTABLE3