LM_ACT_IDLM_SES_IDLM_INSTR_IDPrompt Table: LM_INSTR_SRCH
LM_ROLE_IDPrompt Table: LM_INSTR_ROLEVW
Prompt Table: CURRENCY_CD_TBL
01=Per Hour
02=Per Day
03=Per Week
04=Fixed Cost
05=Per Student
LM_SES_INSTR_VW(SQL View) |
Index Back |
|---|---|
Session Instructor ViewSession Instructor View |
| SELECT A.LM_ACT_ID , A.LM_SES_ID , A.LM_INSTR_ID , A.LM_ROLE_ID , B.NAME , B.LAST_NAME , B.FIRST_NAME ,C.LM_SES_DT ,C.LM_START_TM ,C.LM_END_TM ,TIMEZONE ,D.LM_COST ,D.CURRENCY_CD ,D.LM_COST_TYPE , B.LM_NAME_DISPLAY FROM PS_LM_SES_INSTR A , PS_LM_PERS_NAME_VW B , PS_LM_SES C , PS_LM_INSTR D WHERE A.LM_INSTR_ID = B.LM_PERSON_ID AND A.LM_ACT_ID = C.LM_ACT_ID AND A.LM_SES_ID = C.LM_SES_ID AND A.LM_INSTR_ID = D.LM_PERSON_ID |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | LM_ACT_ID |
Number(10,0) | DECIMAL(10) NOT NULL | Activity ID |
| 2 | LM_SES_ID |
Number(10,0) | DECIMAL(10) NOT NULL | Session ID |
| 3 | LM_INSTR_ID |
Number(15,0) | DECIMAL(15) NOT NULL |
Instructor ID
Prompt Table: LM_INSTR_SRCH |
| 4 | LM_ROLE_ID |
Number(10,0) | DECIMAL(10) NOT NULL |
Role ID
Prompt Table: LM_INSTR_ROLEVW |
| 5 | NAME | Character(50) | VARCHAR2(50) NOT NULL | Name |
| 6 | LAST_NAME | Character(30) | VARCHAR2(30) NOT NULL | Last Name Field |
| 7 | FIRST_NAME | Character(30) | VARCHAR2(30) NOT NULL | First Name field |
| 8 | LM_SES_DT | Date(10) | DATE | Session Date |
| 9 | LM_START_TM | Time(15) | TIMESTAMP | Start Time |
| 10 | LM_END_TM | Time(15) | TIMESTAMP | End Time |
| 11 | TIMEZONE | Character(9) | VARCHAR2(9) NOT NULL | Time Zone |
| 12 | LM_COST | Number(19,3) | DECIMAL(18,3) NOT NULL | Cost |
| 13 | CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL |
Currency Code
Prompt Table: CURRENCY_CD_TBL |
| 14 | 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 |
| 15 | LM_NAME_DISPLAY | Character(50) | VARCHAR2(50) NOT NULL | Name Display field |