LM_INST_FILTER (SQL Table)	Index Back
Instructor Filter Record Record used to save filters created by Instructor.

LM_INST_FILTER

(SQL Table)

Instructor Filter Record

Record used to save filters created by Instructor.

Related Language Record: LM_INST_FLT_LNG

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 LM_SEQNO Number(5,0) INTEGER NOT NULL Sequence Number

2 LM_PERSON_ID Number(15,0) DECIMAL(15) NOT NULL ELM Person ID

3 LM_ORDER_BY_SEQ Number(2,0) SMALLINT NOT NULL Order By Sequence
Default Value: 0

4 LM_SYSTEM_DATA_FLG Character(1) VARCHAR2(1) NOT NULL System data flag used to distinguish development system data from customer entries

5 LM_SRCH_DESC Character(50) VARCHAR2(50) NOT NULL Description

6 LM_DESCR90 Character(100) VARCHAR2(100) NOT NULL Description

7 LM_ACT_CD Character(30) VARCHAR2(30) NOT NULL Activity Code
Prompt Table: LM_ACT_INS_VW3

8 LM_ACTPRG_TYPE Character(15) VARCHAR2(15) NOT NULL Act/Program Type
Prompt Table: LM_UI_DMTH_VW

9 LM_LANG_CD1 Character(3) VARCHAR2(3) NOT NULL Language Code

10 LM_ACT_STATUS Character(1) VARCHAR2(1) NOT NULL Activity Status
1=Active
2=Inactive
3=Closed
4=Pending
5=Concluded

11 LM_FCLTY Character(50) VARCHAR2(50) NOT NULL Facility Description

12 LM_FCLTY_ID Number(10,0) DECIMAL(10) NOT NULL Facility ID

13 LM_COM_IN_FLT Character(3) VARCHAR2(3) NOT NULL My Learning Fluid Page filter
21=Last 3 weeks
30=Last 1 month
365=Last 1 year
7=Last 1 week
ALL=Anytime

14 LM_COM_IN_FILTER Character(3) VARCHAR2(3) NOT NULL My Learning Fluid Page filter
180=Last 6 Months
30=Last 1 Month
365=Last 12 Months
7=Last 1 Week
90=Last 3 Months

15 SYSTEM_DATA_FLG Character(1) VARCHAR2(1) NOT NULL System Data
Y/N Table Edit
Default Value: N

16 LASTUPDOPRID Character(30) VARCHAR2(30) NOT NULL Specifies the User ID which made the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.

17 LASTUPDDTTM DateTime(26) TIMESTAMP Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	LM_SEQNO	Number(5,0)	INTEGER NOT NULL	Sequence Number
2	LM_PERSON_ID	Number(15,0)	DECIMAL(15) NOT NULL	ELM Person ID
3	LM_ORDER_BY_SEQ	Number(2,0)	SMALLINT NOT NULL	Order By Sequence Default Value: 0
4	LM_SYSTEM_DATA_FLG	Character(1)	VARCHAR2(1) NOT NULL	System data flag used to distinguish development system data from customer entries
5	LM_SRCH_DESC	Character(50)	VARCHAR2(50) NOT NULL	Description
6	LM_DESCR90	Character(100)	VARCHAR2(100) NOT NULL	Description
7	LM_ACT_CD	Character(30)	VARCHAR2(30) NOT NULL	Activity Code Prompt Table: LM_ACT_INS_VW3
8	LM_ACTPRG_TYPE	Character(15)	VARCHAR2(15) NOT NULL	Act/Program Type Prompt Table: LM_UI_DMTH_VW
9	LM_LANG_CD1	Character(3)	VARCHAR2(3) NOT NULL	Language Code
10	LM_ACT_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Activity Status 1=Active 2=Inactive 3=Closed 4=Pending 5=Concluded
11	LM_FCLTY	Character(50)	VARCHAR2(50) NOT NULL	Facility Description
12	LM_FCLTY_ID	Number(10,0)	DECIMAL(10) NOT NULL	Facility ID
13	LM_COM_IN_FLT	Character(3)	VARCHAR2(3) NOT NULL	My Learning Fluid Page filter 21=Last 3 weeks 30=Last 1 month 365=Last 1 year 7=Last 1 week ALL=Anytime
14	LM_COM_IN_FILTER	Character(3)	VARCHAR2(3) NOT NULL	My Learning Fluid Page filter 180=Last 6 Months 30=Last 1 Month 365=Last 12 Months 7=Last 1 Week 90=Last 3 Months
15	SYSTEM_DATA_FLG	Character(1)	VARCHAR2(1) NOT NULL	System Data Y/N Table Edit Default Value: N
16	LASTUPDOPRID	Character(30)	VARCHAR2(30) NOT NULL	Specifies the User ID which made the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.
17	LASTUPDDTTM	DateTime(26)	TIMESTAMP	Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.