LM_MGR_HIST_VW (SQL View)	Index Back
Manager History View Displays a team member's certification history to a manager.

LM_MGR_HIST_VW

(SQL View)

Manager History View

Displays a team member's certification history to a manager.

SELECT D.OPRID , D.LM_MANAGER_ID , A.LM_PRG_REG_ID , A.LM_PERSON_ID , A.LM_PRG_ID , C.LM_PRG_LONG_NM , C.LM_PRG_TYPE , A.LM_ENRL_DT , A.LM_COMPL_DT , B.LM_PRG_STTS , B.LM_STTS_CHNG_DT , C.LM_CERT_ID , A.LM_CERT_EFFDT FROM PS_LM_PRG_REG_VW A , PS_LM_PRG_REG_STTS B , PS_LM_PRG C , PS_LM_MGR_SRCH_VW D WHERE A.LM_PRG_ID = C.LM_PRG_ID AND C.LM_PRG_TYPE = 'CE' AND B.LM_PRG_REG_ID = A.LM_PRG_REG_ID AND A.LM_PERSON_ID = D.LM_PERSON_ID AND A.LM_ENRL_DT BETWEEN C.EFFDT AND C.LM_END_EFFDT

Related Language Record: LM_MGR_HIST_LNG

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).

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

3 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.

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

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_TYPE Character(2) VARCHAR2(2) NOT NULL Program Type
CE=Certification
CU=Curriculum

8 LM_ENRL_DT Date(10) DATE Enrollment/Registration Date

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

10 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

11 LM_STTS_CHNG_DT Date(10) DATE Status Change Date

12 LM_CERT_ID Number(10,0) DECIMAL(10) NOT NULL Certification ID

13 LM_CERT_EFFDT Date(10) DATE Current Certification Date

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	OPRID	Character(30)	VARCHAR2(30) NOT NULL	A user's ID (see PSOPRDEFN).
2	LM_MANAGER_ID	Number(15,0)	DECIMAL(15) NOT NULL	Manager ID
3	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.
4	LM_PERSON_ID	Number(15,0)	DECIMAL(15) NOT NULL	ELM Person ID
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_TYPE	Character(2)	VARCHAR2(2) NOT NULL	Program Type CE=Certification CU=Curriculum
8	LM_ENRL_DT	Date(10)	DATE	Enrollment/Registration Date
9	LM_COMPL_DT	Date(10)	DATE	The date on which this Enrollment was marked Completed / InComplete
10	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
11	LM_STTS_CHNG_DT	Date(10)	DATE	Status Change Date
12	LM_CERT_ID	Number(10,0)	DECIMAL(10) NOT NULL	Certification ID
13	LM_CERT_EFFDT	Date(10)	DATE	Current Certification Date