LM_TEAM_PGRM_VW (SQL View)	Index Back
My Team Program Biew Used in Fluid MSS Team Learning page.

LM_TEAM_PGRM_VW

(SQL View)

My Team Program Biew

Used in Fluid MSS Team Learning page.

SELECT DISTINCT MGR.LM_PERSON_ID ,MGR.OPRID ,MGR.LM_MANAGER_ID , MGR.LM_NAME_DISPLAY , LRNR.LM_PRG_ID , LRNR.LM_PRG_LONG_NM , LRNR.LM_PRG_STTS , LRNR.LM_TARGET_CMPL_DT , LRNR.LM_COMPL_DT , LRNR.LM_PRG_TYPE , LRNR.LM_PRG_REG_ID FROM PS_LM_MGR_TEAM_VW MGR , PS_LM_LRNR_PRG_VW LRNR WHERE MGR.LM_PERSON_ID = LRNR.LM_PERSON_ID

# 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 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).

3 LM_MANAGER_ID Number(15,0) DECIMAL(15) NOT NULL Manager ID

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

5 LM_PRG_ID Number(10,0) DECIMAL(10) NOT NULL Program ID is a unique identifier for curriculum and certification Programs.

6 LM_PRG_LONG_NM Character(200) VARCHAR2(200) NOT NULL Program Long Name

7 LM_PRG_STTS Character(4) VARCHAR2(4) NOT NULL Program Reg Status
CANC=Dropped
COMP=Completed
DECL=Decline
ENRL=Registered
EXPR=Expired
INCO=Not Completed
INPO=In-Progress
PEAP=Pending Approval
PEPA=Pending Payment
PLAN=Planned
PPYA=Payment Approval
REIS=Reissue
REVK=Revoked
WAIV=Waived
WARN=Warning

8 LM_TARGET_CMPL_DT Date(10) DATE The target date by which the student should complete the course. This field is only applicable for WBT activity and the Learning Period for the WBT activity is Enforced. If the Learning Period is not enforced, this field will hold no value.

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

10 LM_PRG_TYPE Character(2) VARCHAR2(2) NOT NULL Program Type
CE=Certification
CU=Curriculum

11 LM_PRG_REG_ID Number(10,0) DECIMAL(10) NOT NULL The Program Registration ID is a unique identifier for a learner's program enrollment.

#	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	OPRID	Character(30)	VARCHAR2(30) NOT NULL	A user's ID (see PSOPRDEFN).
3	LM_MANAGER_ID	Number(15,0)	DECIMAL(15) NOT NULL	Manager ID
4	LM_NAME_DISPLAY	Character(50)	VARCHAR2(50) NOT NULL	Name Display field
5	LM_PRG_ID	Number(10,0)	DECIMAL(10) NOT NULL	Program ID is a unique identifier for curriculum and certification Programs.
6	LM_PRG_LONG_NM	Character(200)	VARCHAR2(200) NOT NULL	Program Long Name
7	LM_PRG_STTS	Character(4)	VARCHAR2(4) NOT NULL	Program Reg Status CANC=Dropped COMP=Completed DECL=Decline ENRL=Registered EXPR=Expired INCO=Not Completed INPO=In-Progress PEAP=Pending Approval PEPA=Pending Payment PLAN=Planned PPYA=Payment Approval REIS=Reissue REVK=Revoked WAIV=Waived WARN=Warning
8	LM_TARGET_CMPL_DT	Date(10)	DATE	The target date by which the student should complete the course. This field is only applicable for WBT activity and the Learning Period for the WBT activity is Enforced. If the Learning Period is not enforced, this field will hold no value.
9	LM_COMPL_DT	Date(10)	DATE	The date on which this Enrollment was marked Completed / InComplete
10	LM_PRG_TYPE	Character(2)	VARCHAR2(2) NOT NULL	Program Type CE=Certification CU=Curriculum
11	LM_PRG_REG_ID	Number(10,0)	DECIMAL(10) NOT NULL	The Program Registration ID is a unique identifier for a learner's program enrollment.