LM_ADHEQ_OBJ_VW (SQL View)	Index Back
Adhoc Objectives View Adhoc Objectives View

LM_ADHEQ_OBJ_VW

(SQL View)

Adhoc Objectives View

SELECT A.LM_ADHC_LRN_ID , A.LM_OBJV_ID , B.LM_ADHC_ID , B.LM_PERSON_ID FROM PS_LM_ADHC_EQV_TBL A , PS_LM_ADHC_LRN_TBL B WHERE A.LM_ADHC_LRN_ID = B.LM_ADHC_LRN_ID

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 LM_ADHC_LRN_ID Number(10,0) DECIMAL(10) NOT NULL Adhoc Learning Id

2 LM_OBJ_ID Number(10,0) DECIMAL(10) NOT NULL Object ID - This value is relies upon the Object Type. The Object ID will either be the Catalog Item ID or the Learning Objective ID.

3 LM_ADHC_ID Number(10,0) DECIMAL(10) NOT NULL Adhoc Id

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

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	LM_ADHC_LRN_ID	Number(10,0)	DECIMAL(10) NOT NULL	Adhoc Learning Id
2	LM_OBJ_ID	Number(10,0)	DECIMAL(10) NOT NULL	Object ID - This value is relies upon the Object Type. The Object ID will either be the Catalog Item ID or the Learning Objective ID.
3	LM_ADHC_ID	Number(10,0)	DECIMAL(10) NOT NULL	Adhoc Id
4	LM_PERSON_ID	Number(15,0)	DECIMAL(15) NOT NULL	ELM Person ID