LM_SES_HST

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PSARCH_ID	Character(8)	VARCHAR2(8) NOT NULL	Archive ID (see PSARCHTEMPLATE).
2	PSARCH_BATCHNUM	Number(30,0)	DECIMAL(30) NOT NULL	Archive Batch Number
3	LM_ACT_ID	Number(10,0)	DECIMAL(10) NOT NULL	Activity ID
4	LM_LC_ID	Number(10,0)	DECIMAL(10) NOT NULL	Learning Component ID - Blended Learning
5	LM_SES_ID	Number(10,0)	DECIMAL(10) NOT NULL	Session ID
6	LM_SES_DT	Date(10)	DATE NOT NULL	Session Date
7	LM_START_TM	Time(15)	TIMESTAMP NOT NULL	Start Time
8	LM_END_DT	Date(10)	DATE	End Date
9	LM_END_TM	Time(15)	TIMESTAMP NOT NULL	End Time
10	TIMEZONE	Character(9)	VARCHAR2(9) NOT NULL	Time Zone Prompt Table: PSTIMEZONE
11	LM_FCLTY_ID	Number(10,0)	DECIMAL(10) NOT NULL	Facility ID Prompt Table: LM_FCLTY_SRCH
12	LM_ROOM_ID	Number(10,0)	DECIMAL(10) NOT NULL	Room ID Prompt Table: LM_ROOM_SRCH
13	LM_SS_FCLTY_DISP	Character(1)	VARCHAR2(1) NOT NULL	Display facility through self service Y/N Table Edit Default Value: Y
14	LM_ROW_ADDED_DTTM	DateTime(26)	TIMESTAMP	Datetime Added
15	LM_ROW_ADDED_OPRID	Character(30)	VARCHAR2(30) NOT NULL	Added By
16	LM_ROW_MAINT_DTTM	DateTime(26)	TIMESTAMP	Row Maintainted DateTime
17	LM_ROW_MAINT_OPRID	Character(30)	VARCHAR2(30) NOT NULL	Row Maintained Oprid
18	LM_NOTE	Long Character	CLOB	Notes and Comments