LM_LRN_CHART_VW (SQL View)	Index Back
Enroll Chart View Enroll Chart View

LM_LRN_CHART_VW

(SQL View)

Enroll Chart View

SELECT A.LM_PERSON_ID ,A.LM_STTS ,A.COUNT1 FROM PS_LM_ENR_CHART_VW A UNION ALL SELECT A.LM_PERSON_ID , ( CASE WHEN A.LM_ADHC_LRN_STTS ='PEAP' THEN 'NOTS' ELSE A.LM_ADHC_LRN_STTS END ) AS LM_STTS , COUNT(*) FROM PS_LM_SUPP_FL_VW A WHERE A.LM_ENRL_DT BETWEEN %Coalesce(( SELECT LM_FROM_DT FROM PS_LM_IN_DFLT_TBL), %DateAdd(%CurrentDateIn, - 365) ) AND %Coalesce(( SELECT LM_TO_DT FROM PS_LM_IN_DFLT_TBL), %CurrentDateIn ) AND A.LM_ADHC_LRN_STTS IN ('INPO','PEAP','COMP') GROUP BY A.LM_PERSON_ID, A.LM_ADHC_LRN_STTS

# 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 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

3 COUNT1 Number(10,0) DECIMAL(10) NOT NULL Counter

#	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	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
3	COUNT1	Number(10,0)	DECIMAL(10) NOT NULL	Counter