PSROLEDEFN

Return to Index

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 NameField TypeDescription
    ROLENAMEVARCHAR2(30) NOT NULLThe name of a Role in the Role Definition Table
    VERSIONDECIMAL(10) NOT NULLVersion
    ROLETYPEVARCHAR2(1) NOT NULLRole Type
    Q=Query
    U=User List

    Default: U

    DESCRVARCHAR2(30) NOT NULLDescription
    QRYNAMEVARCHAR2(30) NOT NULLQuery Name

    Prompt Table: PSROLERULQRY_VW

    ROLESTATUSVARCHAR2(1) NOT NULLRole Status
    A=Active
    I=Inactive

    Default: A

    RECNAMEVARCHAR2(15) NOT NULLRecord (Table) Name

    Prompt Table: ROLERECDEFN_VW
    Set Control Field: RECNAME

    FIELDNAMEVARCHAR2(18) NOT NULLField Name

    Prompt Table: PSRECFLDNOSR

    PC_EVENT_TYPEVARCHAR2(14) NOT NULLPeopleCode Event Name

    Prompt Table: PSPCEVENTVW

    QRYNAME_SECVARCHAR2(30) NOT NULLQuery Name

    Prompt Table: PSROLERULQRY_VW

    PC_FUNCTION_NAMEVARCHAR2(30) NOT NULLPeopleCode Function Name
    ROLE_PCODE_RULE_ONVARCHAR2(1) NOT NULLPeopleCode Rule Enabled
    N=No
    Y=Yes

    Default: N

    ROLE_QUERY_RULE_ONVARCHAR2(1) NOT NULLQuery Role Enabled
    N=No
    Y=Yes

    Default: N

    LDAP_RULE_ONVARCHAR2(1) NOT NULLDirectory Rule Enabled
    N=No
    Y=Yes

    Default: N

    DESCRLONGLONG VARCHARLong Description
    ALLOWNOTIFYVARCHAR2(1) NOT NULLAllow notification

    Y/N Table Edit

    Default: Y

    ALLOWLOOKUPVARCHAR2(1) NOT NULLAllow Recipient Lookup

    Y/N Table Edit

    Default: Y

    LASTUPDDTTMDATESpecifies 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.
    LASTUPDOPRIDVARCHAR2(30) NOT NULLSpecifies 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.

    Author: PeopleTools

    Return to Index

    © Go-Faster Consultancy Ltd.  Last updated 06 February 2013