PV_CAT_SEC_TYPE

(SQL Table)
 Index Back

Security Types Table

Rule Based Catalog

  • Related Language Record: PV_CAT_SEC_T_LN

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 SETID_SECTYPE Character(5) VARCHAR2(5) NOT NULL Security Type SetID

    Default Value: OPR_DEF_TBL_FS.SETID

    Prompt Table: SP_SETID_NONVW

    2 PV_SECURITY_TYPE Character(30) VARCHAR2(30) NOT NULL Security Type
    3 PACKAGEROOT Character(30) VARCHAR2(30) NOT NULL Root Package ID

    Prompt Table: APPPACKAGE_VW

    4 PV_APPCLASS_PATH Character(157) VARCHAR2(157) NOT NULL Application Class Path

    Prompt Table: PV_APPCLPATH_VW

    5 DESCR100 Character(100) VARCHAR2(100) NOT NULL Length 100 Description
    6 DEFAULT_ACCESS Character(1) VARCHAR2(1) NOT NULL Default Access
    N=No Access
    Y=Full Access
    7 SETID_FLAG Character(1) VARCHAR2(1) NOT NULL SetID Control
    N=Setid in Value
    X=No Setid
    Y=Setid in Field

    Y/N Table Edit

    Default Value: N

    8 QRYNAME Character(30) VARCHAR2(30) NOT NULL Query Name

    Prompt Table: PV_ROLEQRY_VW

    9 PROMPT_TABLE Character(15) VARCHAR2(15) NOT NULL Record Name

    Prompt Table: PSRECDEFNPVW

    10 PV_ENABLED Character(1) VARCHAR2(1) NOT NULL A flag indicates whether this row is enabled or not.
    N=No
    Y=Yes