ROLEXLATOPR

(SQL Table)
 Index Back

Role User Table

  • Related Language Record: ROLEXLATOPR_LNG

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 ROLEUSER Character(30) VARCHAR2(30) NOT NULL Role User
    2 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    3 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).

    Prompt Table: OPERATOR_VW

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

    Y/N Table Edit

    Default Value: Y

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

    Y/N Table Edit

    Default Value: Y

    8 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 Value: Y

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

    Prompt Table: PERSONAL_DATA

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

    Prompt Table: ROLEXLATOPR

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

    Prompt Table: ROLEXLATOPR

    12 EFFDT_FROM Date(10) DATE Effective Date From
    13 EFFDT_TO Date(10) DATE Effective Date To