LM_INSTR_VW(SQL View) |
Index Back |
|---|---|
Instructor ViewInstructor View |
| SELECT A.LM_PERSON_ID , A.LM_INSTR_STAT , A.LM_MONDAY , A.LM_TUESDAY , A.LM_WEDNESDAY , A.LM_THURSDAY , A.LM_FRIDAY , A.LM_SATURDAY , A.LM_SUNDAY , A.LM_LANG_CD1 , A.LM_DMTHD_TYPE_ID , A.LM_VENDOR_ID , A.LM_COST , A.CURRENCY_CD , A.LM_COST_TYPE , A.LM_AREA_OF_EXPER , A.LM_INSTR_NOTES , %subrec(LM_INS_FRA_SBR,A) FROM PS_LM_INSTR A |
| # | 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_ACTIVE_NM_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_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 |
| 12 | LM_VENDOR_ID | Number(15,0) | DECIMAL(15) NOT NULL | Vendor ID |
| 13 | LM_COST | Number(19,3) | DECIMAL(18,3) NOT NULL | Cost |
| 14 | CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL |
Currency Code
Prompt Table: CURRENCY_CD_TBL |
| 15 | 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 |
| 16 | LM_AREA_OF_EXPER | Character(30) | VARCHAR2(30) NOT NULL | Area of Expertise |
| 17 | LM_INSTR_NOTES | Long Character | CLOB | Instructor Notes |
| 18 | LM_FULL_TIME_INST | Character(1) | VARCHAR2(1) NOT NULL |
Full-Time instructor
Y/N Table Edit Default Value: N |