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 NameDescription
    ROLENAMEThe name of a Role in the Role Definition Table
    VERSIONInternal PeopleTools version to control reloading of Security Role objects in cache.

    OBJECTTYPE = 'ROLM', Security Role.  Also on PSLOCK

    ROLETYPERole Type
    Q=Query
    U=User List (default)
    DESCRDescription
    QRYNAMEQuery Name

    Prompt Table: PSROLERULQRY_VW

    ROLESTATUSRole Status
    A=Active (default)
    I=Inactive
    RECNAMERecord (Table) Name

    Prompt Table: ROLERECDEFN_VW
    Set Control Field: RECNAME

    FIELDNAMEField Name

    Prompt Table: PSRECFLDNOSR

    PC_EVENT_TYPEPeopleCode Event Name

    Prompt Table: PSPCEVENTVW

    QRYNAME_SECQuery Name

    Prompt Table: PSROLERULQRY_VW

    PC_FUNCTION_NAMEPeopleCode Function Name
    ROLE_PCODE_RULE_ONPeopleCode Rule Enabled
    N=No (default)
    Y=Yes
    ROLE_QUERY_RULE_ONQuery Role Enabled
    N=No (default)
    Y=Yes
    LDAP_RULE_ONDirectory Rule Enabled
    N=No (default)
    Y=Yes
    DESCRLONGLong Description
    ALLOWNOTIFYAllow notification

    Y/N Table Edit

    Default: Y

    ALLOWLOOKUPAllow Recipient Lookup

    Y/N Table Edit

    Default: Y

    LASTUPDDTTMSpecifies 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.
    LASTUPDOPRIDSpecifies 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 03 September 2010