LM_LPLN_MGR_CUR (SQL View)	Index Back
Team Members Cur Learning Plan Team Members Current Learning Plan

LM_LPLN_MGR_CUR

(SQL View)

Team Members Cur Learning Plan

Team Members Current Learning Plan

SELECT LRN.LM_LPLN_ID , LRN.LM_PERSON_ID , MGR.LM_MANAGER_ID , PLN.LM_LPLN_NAME , LRN.LM_LPLN_STATUS , LRN.LM_LPLN_DEFAULT , LRN.LM_COMPL_DATE , LRN.LM_ASSIGNED_BY , PLN.LM_LPLN_CREATED_BY , PLN.LM_LPLN_CREATED_DT FROM PS_LM_LPLN PLN , PS_LM_LPLN_LRN LRN , PS_LM_MGR_VW MGR WHERE PLN.LM_LPLN_ID = LRN.LM_LPLN_ID AND LRN.LM_PERSON_ID = MGR.LM_PERSON_ID AND LRN.LM_LPLN_STATUS <> 'C'

Related Language Record: LM_LPLN_MGR_LG

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 LM_LPLN_ID Number(10,0) DECIMAL(10) NOT NULL Learning Plan ID

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

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

4 LM_LPLN_NAME Character(30) VARCHAR2(30) NOT NULL Learning Plan Code or Title

5 LM_LPLN_STATUS Character(1) VARCHAR2(1) NOT NULL Learning Plan Status
A=Active
C=Complete
I=Inactive
Default Value: A

6 LM_LPLN_DEFAULT Character(1) VARCHAR2(1) NOT NULL Learning Plan Default
Y/N Table Edit
Default Value: N

7 LM_COMPL_DATE Date(10) DATE Learning Plan Completion Date

8 LM_ASSIGNED_BY Number(15,0) DECIMAL(15) NOT NULL Assigned By

9 LM_LPLN_CREATED_BY Number(15,0) DECIMAL(15) NOT NULL Assigned By

10 LM_LPLN_CREATED_DT Date(10) DATE Learning Plan Creation Date

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	LM_LPLN_ID	Number(10,0)	DECIMAL(10) NOT NULL	Learning Plan ID
2	LM_PERSON_ID	Number(15,0)	DECIMAL(15) NOT NULL	ELM Person ID
3	LM_MANAGER_ID	Number(15,0)	DECIMAL(15) NOT NULL	Manager ID
4	LM_LPLN_NAME	Character(30)	VARCHAR2(30) NOT NULL	Learning Plan Code or Title
5	LM_LPLN_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Learning Plan Status A=Active C=Complete I=Inactive Default Value: A
6	LM_LPLN_DEFAULT	Character(1)	VARCHAR2(1) NOT NULL	Learning Plan Default Y/N Table Edit Default Value: N
7	LM_COMPL_DATE	Date(10)	DATE	Learning Plan Completion Date
8	LM_ASSIGNED_BY	Number(15,0)	DECIMAL(15) NOT NULL	Assigned By
9	LM_LPLN_CREATED_BY	Number(15,0)	DECIMAL(15) NOT NULL	Assigned By
10	LM_LPLN_CREATED_DT	Date(10)	DATE	Learning Plan Creation Date