LM_INSTR_HST

(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 - History Table

  • Related Language Record: LM_INSTRLNG_HST

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 PSARCH_ID Character(8) VARCHAR2(8) NOT NULL Archive ID (see PSARCHTEMPLATE).
    2 PSARCH_BATCHNUM Number(30,0) DECIMAL(30) NOT NULL Archive Batch Number
    3 LM_PERSON_ID Number(15,0) DECIMAL(15) NOT NULL ELM Person ID

    Prompt Table: LM_PERSON_VW

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

    Default Value: 01

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

    Y/N Table Edit

    Default Value: N

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

    Y/N Table Edit

    Default Value: N

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

    Y/N Table Edit

    Default Value: N

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

    Y/N Table Edit

    Default Value: N

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

    Y/N Table Edit

    Default Value: N

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

    Y/N Table Edit

    Default Value: N

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

    Y/N Table Edit

    Default Value: N

    12 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    13 LM_LANG_CD1 Character(3) VARCHAR2(3) NOT NULL Language Code
    14 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

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

    Prompt Table: LM_ACT_VENDR_VW

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

    Prompt Table: CURRENCY_CD_TBL

    18 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
    19 LM_AREA_OF_EXPER Character(30) VARCHAR2(30) NOT NULL Area of Expertise
    20 LM_ROW_ADDED_DTTM DateTime(26) TIMESTAMP Datetime Added
    21 LM_ROW_ADDED_OPRID Character(30) VARCHAR2(30) NOT NULL Added By
    22 LM_ROW_MAINT_DTTM DateTime(26) TIMESTAMP Row Maintainted DateTime
    23 LM_ROW_MAINT_OPRID Character(30) VARCHAR2(30) NOT NULL Row Maintained Oprid
    24 LM_INSTR_NOTES Long Character CLOB Instructor Notes
    25 LM_FULL_TIME_INST Character(1) VARCHAR2(1) NOT NULL Full-Time instructor

    Y/N Table Edit

    Default Value: N

    26 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