LM_ROLE_TBL

(SQL Table)
Index Back

Role Table

Roles definition table

  • Related Language Record: LM_ROLETBL_LANG
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 LM_ROLE_ID Number(10,0) DECIMAL(10) NOT NULL Role ID
    2 LM_ROLE_TYPE Character(4) VARCHAR2(4) NOT NULL Role Type
    0010=Contact Role
    0020=Instructor Role
    3 LM_ROLE Character(50) VARCHAR2(50) NOT NULL Role Description
    4 LM_ROLE_SHORT Character(10) VARCHAR2(10) NOT NULL Role Short Description
    5 LM_DEFROLE_ID Character(1) VARCHAR2(1) NOT NULL Default Instructor Type

    Y/N Table Edit

    Default Value: N