index back

Role User View

select roleuser, descr, oprid, emailid, formid, worklist_user_sw, email_user_sw, forms_user_sw, emplid, roleuser_alt, roleuser_supr from ps_rolexlatopr

  • Related language record: ROLEXLATOPR_LVW
  • PeopleSoft Field NameField TypeColumn TypeDescription
    ROLEUSERCharacter(30)VARCHAR2(30) NOT NULLRole User
    DESCRCharacter(30)VARCHAR2(30) NOT NULLDescription
    OPRIDCharacter(30)VARCHAR2(30) NOT NULLA user's ID (see PSOPRDEFN).

    Prompt Table: OPRDEFN2

    EMAILIDCharacter(70)VARCHAR2(70) NOT NULLA user's E-mail address
    FORMIDCharacter(70)VARCHAR2(70) NOT NULLForm ID
    WORKLIST_USER_SWCharacter(1)VARCHAR2(1) NOT NULLUsed to determine if the user gets a worklist generated
    EMAIL_USER_SWCharacter(1)VARCHAR2(1) NOT NULLUsed to determine if the user gets workflow email generated
    FORMS_USER_SWCharacter(1)VARCHAR2(1) NOT NULLUsed to determine if the user gets workflow Lotus forms generated
    EMPLIDCharacter(11)VARCHAR2(11) NOT NULLEmployee ID
    ROLEUSER_ALTCharacter(30)VARCHAR2(30) NOT NULLAlternate Role User
    ROLEUSER_SUPRCharacter(30)VARCHAR2(30) NOT NULLSupervisor Role User
    index back(c)David Kurtz 2019, 8.54
    PTRef generated on 09-JUN-19