LM_INSTR_FCLTY (SQL Table)	Index Back
Instructor Facility Preference Stores the facilities at which an instructor prefers to teach.

LM_INSTR_FCLTY

(SQL Table)

Instructor Facility Preference

Stores the facilities at which an instructor prefers to teach.

Parent record: LM_INSTR

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

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

2 LM_FCLTY_ID Number(10,0) DECIMAL(10) NOT NULL Facility ID
Prompt Table: %EDITTABLE

3 LM_ROW_ADDED_DTTM DateTime(26) TIMESTAMP Datetime Added

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

5 LM_ROW_MAINT_DTTM DateTime(26) TIMESTAMP Row Maintainted DateTime

6 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_PERSON_ID	Number(15,0)	DECIMAL(15) NOT NULL	ELM Person ID
2	LM_FCLTY_ID	Number(10,0)	DECIMAL(10) NOT NULL	Facility ID Prompt Table: %EDITTABLE
3	LM_ROW_ADDED_DTTM	DateTime(26)	TIMESTAMP	Datetime Added
4	LM_ROW_ADDED_OPRID	Character(30)	VARCHAR2(30) NOT NULL	Added By
5	LM_ROW_MAINT_DTTM	DateTime(26)	TIMESTAMP	Row Maintainted DateTime
6	LM_ROW_MAINT_OPRID	Character(30)	VARCHAR2(30) NOT NULL	Row Maintained Oprid