ROLEXLATOPR

index back

Role User Table


  • Related language record: ROLEXLATOPR_LNG
  • PeopleSoft Field Name Field Type Column Type Description
    ROLEUSER Character(30) VARCHAR2(30) NOT NULL Role User
    DESCR Character(30) VARCHAR2(30) NOT NULL Description
    OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).

    Prompt Table: OPERATOR_VW

    EMAILID Character(70) VARCHAR2(70) NOT NULL A user's E-mail address
    FORMID Character(70) VARCHAR2(70) NOT NULL Form ID
    WORKLIST_USER_SW Character(1) VARCHAR2(1) NOT NULL Used to determine if the user gets a worklist generated

    Y/N Table Edit

    Default: Y

    EMAIL_USER_SW Character(1) VARCHAR2(1) NOT NULL Used to determine if the user gets workflow email generated

    Y/N Table Edit

    Default: Y

    FORMS_USER_SW Character(1) VARCHAR2(1) NOT NULL Used to determine if the user gets workflow Lotus forms generated

    Y/N Table Edit

    Default: Y

    EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

    Prompt Table: PERSONAL_DATA

    ROLEUSER_ALT Character(30) VARCHAR2(30) NOT NULL Alternate Role User

    Prompt Table: ROLEXLATOPR

    ROLEUSER_SUPR Character(30) VARCHAR2(30) NOT NULL Supervisor Role User

    Prompt Table: ROLEXLATOPR

    EFFDT_FROM Date(10) DATE Effective Date From
    EFFDT_TO Date(10) DATE Effective Date To
    index back (c)David Kurtz 2020, www.go-faster.co.uk PeopleTools 8.58
    PTRef generated on 21-DEC-20