LM_SES_PTRN

#	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_PTRN_ID	Number(3,0)	SMALLINT NOT NULL	Session Pattern ID
4	LM_FCLTY_ID	Number(10,0)	DECIMAL(10) NOT NULL	Facility ID Prompt Table: LM_FCLTY_SRCH
5	LM_ROOM_ID	Number(10,0)	DECIMAL(10) NOT NULL	Room ID Prompt Table: LM_ROOM_SRCH
6	LM_START_DT	Date(10)	DATE NOT NULL	Start Date Default Value: LM_ACT.LM_START_DT
7	LM_END_DT	Date(10)	DATE	End Date Default Value: LM_SES_PTRN.LM_START_DT
8	LM_DURN_DAYS	Number(4,0)	SMALLINT NOT NULL	Length of Activity in Days
9	LM_START_TM	Time(15)	TIMESTAMP NOT NULL	Start Time
10	LM_END_TM	Time(15)	TIMESTAMP NOT NULL	End Time
11	TIMEZONE	Character(9)	VARCHAR2(9) NOT NULL	Time Zone Prompt Table: PSTIMEZONE
12	LM_MONDAY	Character(1)	VARCHAR2(1) NOT NULL	Monday Y/N Table Edit Default Value: N
13	LM_TUESDAY	Character(1)	VARCHAR2(1) NOT NULL	Tuesday Y/N Table Edit Default Value: N
14	LM_WEDNESDAY	Character(1)	VARCHAR2(1) NOT NULL	Wednesday Y/N Table Edit Default Value: N
15	LM_THURSDAY	Character(1)	VARCHAR2(1) NOT NULL	Thursday Y/N Table Edit Default Value: N
16	LM_FRIDAY	Character(1)	VARCHAR2(1) NOT NULL	Friday Y/N Table Edit Default Value: N
17	LM_SATURDAY	Character(1)	VARCHAR2(1) NOT NULL	Saturday Y/N Table Edit Default Value: N
18	LM_SUNDAY	Character(1)	VARCHAR2(1) NOT NULL	Sunday Y/N Table Edit Default Value: N
19	LM_ROW_ADDED_DTTM	DateTime(26)	TIMESTAMP	Datetime Added
20	LM_ROW_ADDED_OPRID	Character(30)	VARCHAR2(30) NOT NULL	Added By
21	LM_ROW_MAINT_DTTM	DateTime(26)	TIMESTAMP	Row Maintainted DateTime
22	LM_ROW_MAINT_OPRID	Character(30)	VARCHAR2(30) NOT NULL	Row Maintained Oprid