PSROLEDEFN

 index back

Role Definition

This table stores PeopleSoft Role definitions. (User get permissions to PeopleSoft objects through Roles, which are assigned Permission Lists.)

  • Related language record: PSROLEDEFNLANG

  • Parent record of PSCDBROLEUSER PSDISTROLE_VW PSROLEDYNMEMBER PSROLEMEMBER PSROLEUSER PSROLEUSER_RMT PSROLEUSER_VW

    • PeopleSoft Field Name Field Type Column Type Description
    ROLENAME Character(30) VARCHAR2(30) NOT NULL The name of a Role in the Role Definition Table
    VERSION Number(10,0) DECIMAL(10) NOT NULL Version. Internal PeopleTools version for controlling caching of object. - Version/Table reference
    ROLETYPE Character(1) VARCHAR2(1) NOT NULL Role Type
    Q=Query
    U=User List

    Default: U

    DESCR Character(30) VARCHAR2(30) NOT NULL Description
    QRYNAME Character(30) VARCHAR2(30) NOT NULL Query Name

    Prompt Table: PSROLERULQRY_VW

    ROLESTATUS Character(1) VARCHAR2(1) NOT NULL Role Status
    A=Active
    I=Inactive

    Default: A

    RECNAME Character(15) VARCHAR2(15) NOT NULL Record (Table) Name (see PSRECDEFN).

    Prompt Table: ROLERECDEFN_VW
    Set Control Field: RECNAME

    FIELDNAME Character(18) VARCHAR2(18) NOT NULL Field Name (see PSDBFIELD).

    Prompt Table: PSRECFLDNOSR

    PC_EVENT_TYPE Character(14) VARCHAR2(14) NOT NULL PeopleCode Event Name

    Prompt Table: PSPCEVENTVW

    QRYNAME_SEC Character(30) VARCHAR2(30) NOT NULL Query Name

    Prompt Table: PSROLERULQRY_VW

    PC_FUNCTION_NAME Character(30) VARCHAR2(30) NOT NULL PeopleCode Function Name
    ROLE_PCODE_RULE_ON Character(1) VARCHAR2(1) NOT NULL PeopleCode Rule Enabled
    N=No
    Y=Yes

    Default: N

    ROLE_QUERY_RULE_ON Character(1) VARCHAR2(1) NOT NULL Query Role Enabled
    N=No
    Y=Yes

    Default: N

    LDAP_RULE_ON Character(1) VARCHAR2(1) NOT NULL Directory Rule Enabled
    N=No
    Y=Yes

    Default: N

    DESCRLONG Long Character CLOB Long Description
    ALLOWNOTIFY Character(1) VARCHAR2(1) NOT NULL Allow notification

    Y/N Table Edit

    Default: Y

    ALLOWLOOKUP Character(1) VARCHAR2(1) NOT NULL Allow Recipient Lookup

    Y/N Table Edit

    Default: Y

    LASTUPDDTTM DateTime(26) TIMESTAMP Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.
    LASTUPDOPRID Character(30) VARCHAR2(30) NOT NULL Specifies the User ID which made the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.
    index back (c)David Kurtz 2020, www.go-faster.co.uk PeopleTools 8.58
    PTRef generated on 21-DEC-20