PSROLEDEFN

(SQL Table)
 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 AUC_ROLEUSER AUC_USERROLE_VW FSFB_ROLEUSER FSFB_ROLEUSER2 FSFB_ROLEUSER3 PSCDBROLEUSER PSDISTROLE_VW PSROLEDYNMEMBER PSROLEMEMBER PSROLEUSER PSROLEUSER_RMT PSROLEUSER_VW PV_CAT_ROLE_VW PV_USERROLE_VW

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

    Default Value: U

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

    Prompt Table: PSROLERULQRY_VW

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

    Default Value: A

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

    Prompt Table: ROLERECDEFN_VW
    Set Control Field: RECNAME

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

    Prompt Table: PSRECFLDNOSR

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

    Prompt Table: PSPCEVENTVW

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

    Prompt Table: PSROLERULQRY_VW

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

    Default Value: N

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

    Default Value: N

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

    Default Value: N

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

    Y/N Table Edit

    Default Value: Y

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

    Y/N Table Edit

    Default Value: Y

    18 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.
    19 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.