LM_TMPL_DTL(SQL Table) |
Index Back |
|---|---|
Session Template Detail TableSession Template Detail Table |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  LM_TMPL_ID |
Number(15,0) | DECIMAL(15) NOT NULL | Template ID |
| 2 | LM_TMPL_DTL_ID |
Number(3,0) | SMALLINT NOT NULL | Template Detail ID |
| 3 | LM_FCLTY_ID | Number(10,0) | DECIMAL(10) NOT NULL |
Facility ID
Prompt Table: LM_FCLTY_SRCH |
| 4 | LM_ROOM_ID | Number(10,0) | DECIMAL(10) NOT NULL |
Room ID
Prompt Table: LM_ROOM_SRCH |
| 5 | LM_DURN_DAYS | Number(4,0) | SMALLINT NOT NULL | Length of Activity in Days |
| 6 | LM_START_TM | Time(15) | TIMESTAMP NOT NULL | Start Time |
| 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_MONDAY | Character(1) | VARCHAR2(1) NOT NULL |
Monday
Y/N Table Edit Default Value: N |
| 10 | LM_TUESDAY | Character(1) | VARCHAR2(1) NOT NULL |
Tuesday
Y/N Table Edit Default Value: N |
| 11 | LM_WEDNESDAY | Character(1) | VARCHAR2(1) NOT NULL |
Wednesday
Y/N Table Edit Default Value: N |
| 12 | LM_THURSDAY | Character(1) | VARCHAR2(1) NOT NULL |
Thursday
Y/N Table Edit Default Value: N |
| 13 | LM_FRIDAY | Character(1) | VARCHAR2(1) NOT NULL |
Friday
Y/N Table Edit Default Value: N |
| 14 | LM_SATURDAY | Character(1) | VARCHAR2(1) NOT NULL |
Saturday
Y/N Table Edit Default Value: N |
| 15 | LM_SUNDAY | Character(1) | VARCHAR2(1) NOT NULL |
Sunday
Y/N Table Edit Default Value: N |
| 16 | LM_ROW_ADDED_DTTM | DateTime(26) | TIMESTAMP | Datetime Added |
| 17 | LM_ROW_ADDED_OPRID | Character(30) | VARCHAR2(30) NOT NULL | Added By |
| 18 | LM_ROW_MAINT_DTTM | DateTime(26) | TIMESTAMP | Row Maintainted DateTime |
| 19 | LM_ROW_MAINT_OPRID | Character(30) | VARCHAR2(30) NOT NULL | Row Maintained Oprid |
| 20 | LM_NOTE | Long Character | CLOB | Notes and Comments |