LM_INSTR

(SQL Table)
 Index Back

Instructor Table

Instructor Table. The prompt on LM_VENDOR_ID has been changed to LM_ACT_VENDR_VW to include only Active Vendors in search results.

  • Related Language Record: LM_INSTR_LANG

  • Parent Record Of LM_INSTR_ATCH LM_INSTR_FCLTY LM_INSTR_LE LM_INSTR_QUAL

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 LM_PERSON_ID Number(15,0) DECIMAL(15) NOT NULL ELM Person ID

    Prompt Table: LM_PERSON_VW

    2 LM_INSTR_STAT Character(2) VARCHAR2(2) NOT NULL Instructor Status
    01=Active
    02=Inactive

    Default Value: 01

    3 LM_MONDAY Character(1) VARCHAR2(1) NOT NULL Monday

    Y/N Table Edit

    Default Value: N

    4 LM_TUESDAY Character(1) VARCHAR2(1) NOT NULL Tuesday

    Y/N Table Edit

    Default Value: N

    5 LM_WEDNESDAY Character(1) VARCHAR2(1) NOT NULL Wednesday

    Y/N Table Edit

    Default Value: N

    6 LM_THURSDAY Character(1) VARCHAR2(1) NOT NULL Thursday

    Y/N Table Edit

    Default Value: N

    7 LM_FRIDAY Character(1) VARCHAR2(1) NOT NULL Friday

    Y/N Table Edit

    Default Value: N

    8 LM_SATURDAY Character(1) VARCHAR2(1) NOT NULL Saturday

    Y/N Table Edit

    Default Value: N

    9 LM_SUNDAY Character(1) VARCHAR2(1) NOT NULL Sunday

    Y/N Table Edit

    Default Value: N

    10 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    11 LM_LANG_CD1 Character(3) VARCHAR2(3) NOT NULL Language Code
    12 LM_DMTHD_TYPE_ID Number(10,0) DECIMAL(10) NOT NULL Delivery Method Type ID - This is a unique identifier for each delivery method type

    Prompt Table: LM_DMTH_TYP_TBL

    13 LM_VENDOR_ID Number(15,0) DECIMAL(15) NOT NULL Vendor ID

    Prompt Table: LM_ACT_VENDR_VW

    14 LM_COST Number(19,3) DECIMAL(18,3) NOT NULL Cost
    15 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code

    Prompt Table: CURRENCY_CD_TBL

    16 LM_COST_TYPE Character(2) VARCHAR2(2) NOT NULL Cost Type Units
    01=Per Hour
    02=Per Day
    03=Per Week
    04=Fixed Cost
    05=Per Student
    17 LM_AREA_OF_EXPER Character(30) VARCHAR2(30) NOT NULL Area of Expertise
    18 LM_ROW_ADDED_DTTM DateTime(26) TIMESTAMP Datetime Added
    19 LM_ROW_ADDED_OPRID Character(30) VARCHAR2(30) NOT NULL Added By
    20 LM_ROW_MAINT_DTTM DateTime(26) TIMESTAMP Row Maintainted DateTime
    21 LM_ROW_MAINT_OPRID Character(30) VARCHAR2(30) NOT NULL Row Maintained Oprid
    22 LM_INSTR_NOTES Long Character CLOB Instructor Notes
    23 LM_FULL_TIME_INST Character(1) VARCHAR2(1) NOT NULL Full-Time instructor

    Y/N Table Edit

    Default Value: N

    24 LM_COMPLETED_DUR Character(2) VARCHAR2(2) NOT NULL Display Classes Completed (in Months)
    1=1
    10=10
    11=11
    12=12
    2=2
    3=3
    4=4
    5=5
    6=6
    7=7
    8=8
    9=9

    Default Value: 1