LM_ENR_LCDUR_VW (SQL View)	Index Back
Enrollment LC Durations This table stores the student duration for a Learning Component and per hour type.

LM_ENR_LCDUR_VW

(SQL View)

Enrollment LC Durations

This table stores the student duration for a Learning Component and per hour type.

SELECT LM_ENRLMT_ID , LM_LC_ID , LM_HOUR_TYPE , LM_TOTAL_DUR_HRS , %subrec(LM_ROWAUDIT_SBR, PS_LM_ENR_LC_DUR) FROM PS_LM_ENR_LC_DUR

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 LM_ENRLMT_ID Number(10,0) DECIMAL(10) NOT NULL Enrollment ID

2 LM_LC_ID Number(10,0) DECIMAL(10) NOT NULL Learning Component ID - Blended Learning

3 LM_HOUR_TYPE Character(10) VARCHAR2(10) NOT NULL Hour Type
Default Value: 1
Prompt Table: LM_HOUR_TYPE

4 LM_TOTAL_DUR_HRS Number(10,3) DECIMAL(9,3) NOT NULL Total Duration

5 LM_ROW_ADDED_DTTM DateTime(26) TIMESTAMP Datetime Added

6 LM_ROW_ADDED_OPRID Character(30) VARCHAR2(30) NOT NULL Added By

7 LM_ROW_MAINT_DTTM DateTime(26) TIMESTAMP Row Maintainted DateTime

8 LM_ROW_MAINT_OPRID Character(30) VARCHAR2(30) NOT NULL Row Maintained Oprid

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	LM_ENRLMT_ID	Number(10,0)	DECIMAL(10) NOT NULL	Enrollment ID
2	LM_LC_ID	Number(10,0)	DECIMAL(10) NOT NULL	Learning Component ID - Blended Learning
3	LM_HOUR_TYPE	Character(10)	VARCHAR2(10) NOT NULL	Hour Type Default Value: 1 Prompt Table: LM_HOUR_TYPE
4	LM_TOTAL_DUR_HRS	Number(10,3)	DECIMAL(9,3) NOT NULL	Total Duration
5	LM_ROW_ADDED_DTTM	DateTime(26)	TIMESTAMP	Datetime Added
6	LM_ROW_ADDED_OPRID	Character(30)	VARCHAR2(30) NOT NULL	Added By
7	LM_ROW_MAINT_DTTM	DateTime(26)	TIMESTAMP	Row Maintainted DateTime
8	LM_ROW_MAINT_OPRID	Character(30)	VARCHAR2(30) NOT NULL	Row Maintained Oprid