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 NameField TypeColumn TypeDescription
    ROLENAMECharacter(30)VARCHAR2(30) NOT NULLThe name of a Role in the Role Definition Table
    VERSIONNumber(10,0)DECIMAL(10) NOT NULLVersion. Internal PeopleTools version for controlling caching of object. - Version/Table reference
    ROLETYPECharacter(1)VARCHAR2(1) NOT NULLRole Type
    Q=Query
    U=User List

    Default: U

    DESCRCharacter(30)VARCHAR2(30) NOT NULLDescription
    QRYNAMECharacter(30)VARCHAR2(30) NOT NULLQuery Name

    Prompt Table: PSROLERULQRY_VW

    ROLESTATUSCharacter(1)VARCHAR2(1) NOT NULLRole Status
    A=Active
    I=Inactive

    Default: A

    RECNAMECharacter(15)VARCHAR2(15) NOT NULLRecord (Table) Name (see PSRECDEFN).

    Prompt Table: ROLERECDEFN_VW
    Set Control Field: RECNAME

    FIELDNAMECharacter(18)VARCHAR2(18) NOT NULLField Name (see PSDBFIELD).

    Prompt Table: PSRECFLDNOSR

    PC_EVENT_TYPECharacter(14)VARCHAR2(14) NOT NULLPeopleCode Event Name

    Prompt Table: PSPCEVENTVW

    QRYNAME_SECCharacter(30)VARCHAR2(30) NOT NULLQuery Name

    Prompt Table: PSROLERULQRY_VW

    PC_FUNCTION_NAMECharacter(30)VARCHAR2(30) NOT NULLPeopleCode Function Name
    ROLE_PCODE_RULE_ONCharacter(1)VARCHAR2(1) NOT NULLPeopleCode Rule Enabled
    N=No
    Y=Yes

    Default: N

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

    Default: N

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

    Default: N

    DESCRLONGLong CharacterCLOBLong Description
    ALLOWNOTIFYCharacter(1)VARCHAR2(1) NOT NULLAllow notification

    Y/N Table Edit

    Default: Y

    ALLOWLOOKUPCharacter(1)VARCHAR2(1) NOT NULLAllow Recipient Lookup

    Y/N Table Edit

    Default: Y

    LASTUPDDTTMDateTime(26)TIMESTAMPSpecifies 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.
    LASTUPDOPRIDCharacter(30)VARCHAR2(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.
    index back(c)David Kurtz 2019, www.go-faster.co.ukPeopleTools 8.54
    PTRef generated on 09-JUN-19