LM_SES(SQL Table) |
Index Back |
---|---|
Session TableSession Table |
# | 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_LC_ID | Number(10,0) | DECIMAL(10) NOT NULL | Learning Component ID - Blended Learning |
3 | LM_SES_ID | Number(10,0) | DECIMAL(10) NOT NULL | Session ID |
4 | LM_SES_DT | Date(10) | DATE NOT NULL | Session Date |
5 | LM_START_TM | Time(15) | TIMESTAMP NOT NULL | Start Time |
6 | LM_END_DT | Date(10) | DATE |
End Date
Default Value: LM_SES.LM_SES_DT |
7 | LM_END_TM | Time(15) | TIMESTAMP NOT NULL | End Time |
8 | TIMEZONE | Character(9) | VARCHAR2(9) NOT NULL |
Time Zone
Prompt Table: PSTIMEZONE |
9 | LM_FCLTY_ID | Number(10,0) | DECIMAL(10) NOT NULL |
Facility ID
Prompt Table: LM_FCLTY_SRCH |
10 | LM_ROOM_ID | Number(10,0) | DECIMAL(10) NOT NULL |
Room ID
Prompt Table: LM_ROOM_SRCH |
11 | LM_SS_FCLTY_DISP | Character(1) | VARCHAR2(1) NOT NULL |
Display facility through self service
Y/N Table Edit Default Value: Y |
12 | LM_ROW_ADDED_DTTM | DateTime(26) | TIMESTAMP | Datetime Added |
13 | LM_ROW_ADDED_OPRID | Character(30) | VARCHAR2(30) NOT NULL | Added By |
14 | LM_ROW_MAINT_DTTM | DateTime(26) | TIMESTAMP | Row Maintainted DateTime |
15 | LM_ROW_MAINT_OPRID | Character(30) | VARCHAR2(30) NOT NULL | Row Maintained Oprid |
16 | LM_NOTE | Long Character | CLOB | Notes and Comments |