LM_OBJ_LRN_VW (SQL View)	Index Back
Learning Objective View Learning Objective View

LM_OBJ_LRN_VW

(SQL View)

Learning Objective View

SELECT A.LM_OBJV_ID , D.LM_OBJV_DESC , 'Objective' , A.LM_OBJV_STATUS , B.XLATLONGNAME , %DatePart(A.LM_OBJV_STAT_DTTM) , A.LM_REQUESTOR_ID , A.LM_PERSON_ID , C.LM_NAME_DISPLAY , A.LM_OBJV_ASGN_DT , A.LM_LRNR_OBJV_ID FROM PS_LM_LRNR_OBJV A , XLATTABLE_VW B , PS_LM_PERSON_NAME C , PS_LM_OBJV_TBL D WHERE B.FIELDNAME = 'LM_OBJV_STATUS' AND B.FIELDVALUE = A.LM_OBJV_STATUS AND C.LM_PERSON_ID = A.LM_REQUESTOR_ID AND A.LM_OBJV_ID = D.LM_OBJV_ID AND C.LM_DISPLAY_FLAG = 'Y' AND %CurrentDateIn BETWEEN C.EFFDT AND C.LM_END_EFFDT

Related Language Record: LM_OBJ_LRN_LVW

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

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

2 LM_PER_TRN_NM Character(254) VARCHAR2(254) NOT NULL Personal Training Name. This field is used in case of Adhoc training. This field will carry the name of the Course / Catalog Item the person took training.

3 LM_LRN_TYPE_DESC Character(15) VARCHAR2(15) NOT NULL Type

4 LM_STTS Character(4) VARCHAR2(4) NOT NULL Enrollment Status
CANC=Dropped
COMP=Completed
DECL=Denied
ENRL=Enrolled
INCO=Not Completed
INPO=In-Progress
MACT=Moved to New Activity
NOTS=Not Started
PEAP=Pending Approval
PEPA=Pending Payment
PLAN=Planned
PPYA=Payment Approval
RQST=Learning Request
WAIV=Waived
WTLT=Waitlisted

5 XLATLONGNAME Character(30) VARCHAR2(30) NOT NULL Translate Long Name

6 LM_COMPL_DT Date(10) DATE The date on which this Enrollment was marked Completed / InComplete

7 LM_REQUESTOR_ID Number(15,0) DECIMAL(15) NOT NULL Requestor

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

9 LM_NAME_DISPLAY Character(50) VARCHAR2(50) NOT NULL Name Display field

10 LM_ENRL_DT Date(10) DATE Enrollment/Registration Date

11 LM_CONFIRM_ID Number(10,0) DECIMAL(10) NOT NULL Confirmation ID for Activity , Program , Adhoc

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	LM_LRN_ID	Number(10,0)	DECIMAL(10) NOT NULL	Learning Id
2	LM_PER_TRN_NM	Character(254)	VARCHAR2(254) NOT NULL	Personal Training Name. This field is used in case of Adhoc training. This field will carry the name of the Course / Catalog Item the person took training.
3	LM_LRN_TYPE_DESC	Character(15)	VARCHAR2(15) NOT NULL	Type
4	LM_STTS	Character(4)	VARCHAR2(4) NOT NULL	Enrollment Status CANC=Dropped COMP=Completed DECL=Denied ENRL=Enrolled INCO=Not Completed INPO=In-Progress MACT=Moved to New Activity NOTS=Not Started PEAP=Pending Approval PEPA=Pending Payment PLAN=Planned PPYA=Payment Approval RQST=Learning Request WAIV=Waived WTLT=Waitlisted
5	XLATLONGNAME	Character(30)	VARCHAR2(30) NOT NULL	Translate Long Name
6	LM_COMPL_DT	Date(10)	DATE	The date on which this Enrollment was marked Completed / InComplete
7	LM_REQUESTOR_ID	Number(15,0)	DECIMAL(15) NOT NULL	Requestor
8	LM_PERSON_ID	Number(15,0)	DECIMAL(15) NOT NULL	ELM Person ID
9	LM_NAME_DISPLAY	Character(50)	VARCHAR2(50) NOT NULL	Name Display field
10	LM_ENRL_DT	Date(10)	DATE	Enrollment/Registration Date
11	LM_CONFIRM_ID	Number(10,0)	DECIMAL(10) NOT NULL	Confirmation ID for Activity , Program , Adhoc