LM_RGSTN_ML_VW (SQL View)	Index Back
View mapping the class & pers View mapping the class & pers

LM_RGSTN_ML_VW

(SQL View)

View mapping the class & pers

SELECT A.LM_PRG_ID , C.LM_PERSON_ID , A.LM_LRNR_GROUP_ID ,A.LM_ML_SEL ,A.LM_HST_CRD_ALLOW ,A.LM_HISTCREDIT_TYPE ,A.LM_HIST_CRD_PRD , A.LM_HIST_DATE ,A.LM_DUE_DT_MTHD ,A.LM_DUE_DATE ,A.LM_MAN_LRN_PD ,A.CUB_STARTMONTH ,A.CUB_BEGINDAY FROM PS_LM_PRG_ML A ,PS_LM_PRG_VW B ,PS_LM_PERS_LGRP_VW C ,PS_LM_CURR_JOB_VW D WHERE A.LM_PRG_ID = B.LM_PRG_ID AND A.LM_LRNR_GROUP_ID<>0 AND B.LM_PRG_STATUS='10' AND A.LM_LRNR_GROUP_ID=C.LM_LRNR_GROUP_ID AND D.LM_PERSON_ID = C.LM_PERSON_ID AND D.LM_ACTIVE = 'Y' AND %CurrentDateIn BETWEEN D.EFFDT AND D.LM_END_EFFDT AND NOT EXISTS ( SELECT 'X' FROM PS_LM_PRG_ML E WHERE E.LM_PRG_ID=A.LM_PRG_ID AND E.LM_PERSON_ID=C.LM_PERSON_ID) UNION SELECT A.LM_PRG_ID , A.LM_PERSON_ID , A.LM_LRNR_GROUP_ID ,A.LM_ML_SEL ,A.LM_HST_CRD_ALLOW ,A.LM_HISTCREDIT_TYPE ,A.LM_HIST_CRD_PRD , A.LM_HIST_DATE ,A.LM_DUE_DT_MTHD ,A.LM_DUE_DATE ,A.LM_MAN_LRN_PD ,A.CUB_STARTMONTH ,A.CUB_BEGINDAY FROM PS_LM_PRG_ML A ,PS_LM_PRG_VW B ,PS_LM_CURR_JOB_VW C WHERE A.LM_PRG_ID = B.LM_PRG_ID AND A.LM_PERSON_ID<>0 AND B.LM_PRG_STATUS='10' AND C.LM_PERSON_ID = A.LM_PERSON_ID AND C.LM_ACTIVE = 'Y' AND %CurrentDateIn BETWEEN C.EFFDT AND C.LM_END_EFFDT

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

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

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

3 LM_LRNR_GROUP_ID Number(15,0) DECIMAL(15) NOT NULL Learner Group ID - Business Role/ Student Group ID

4 LM_ML_SEL Character(1) VARCHAR2(1) NOT NULL Selection Criteria
G=Learner Group
L=Learner

5 LM_HST_CRD_ALLOW Character(1) VARCHAR2(1) NOT NULL Allow historical credit
Y/N Table Edit

6 LM_HISTCREDIT_TYPE Character(1) VARCHAR2(1) NOT NULL Historical Credit Type
D=Credit Threshold Date
P=Historical Credit Period

7 LM_HIST_CRD_PRD Number(3,0) SMALLINT NOT NULL Historical credit period days

8 LM_HIST_DATE Date(10) DATE Historical Date

9 LM_DUE_DT_MTHD Character(2) VARCHAR2(2) NOT NULL Due date method
DT=Date
LP=Learning Period

10 LM_DUE_DATE Date(10) DATE Due Date

11 LM_MAN_LRN_PD Number(3,0) SMALLINT NOT NULL Mandatory Learning Period

12 CUB_STARTMONTH Character(2) VARCHAR2(2) NOT NULL Month
1=01 - January
10=10 - October
11=11 - November
12=12 - December
2=02 - February
3=03 - March
4=04 - April
5=05 - May
6=06 - June
7=07 - July
8=08 - August
9=09 - September

13 CUB_BEGINDAY Character(2) VARCHAR2(2) NOT NULL Day

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	LM_PRG_ID	Number(10,0)	DECIMAL(10) NOT NULL	Program ID is a unique identifier for curriculum and certification Programs.
2	LM_PERSON_ID	Number(15,0)	DECIMAL(15) NOT NULL	ELM Person ID
3	LM_LRNR_GROUP_ID	Number(15,0)	DECIMAL(15) NOT NULL	Learner Group ID - Business Role/ Student Group ID
4	LM_ML_SEL	Character(1)	VARCHAR2(1) NOT NULL	Selection Criteria G=Learner Group L=Learner
5	LM_HST_CRD_ALLOW	Character(1)	VARCHAR2(1) NOT NULL	Allow historical credit Y/N Table Edit
6	LM_HISTCREDIT_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Historical Credit Type D=Credit Threshold Date P=Historical Credit Period
7	LM_HIST_CRD_PRD	Number(3,0)	SMALLINT NOT NULL	Historical credit period days
8	LM_HIST_DATE	Date(10)	DATE	Historical Date
9	LM_DUE_DT_MTHD	Character(2)	VARCHAR2(2) NOT NULL	Due date method DT=Date LP=Learning Period
10	LM_DUE_DATE	Date(10)	DATE	Due Date
11	LM_MAN_LRN_PD	Number(3,0)	SMALLINT NOT NULL	Mandatory Learning Period
12	CUB_STARTMONTH	Character(2)	VARCHAR2(2) NOT NULL	Month 1=01 - January 10=10 - October 11=11 - November 12=12 - December 2=02 - February 3=03 - March 4=04 - April 5=05 - May 6=06 - June 7=07 - July 8=08 - August 9=09 - September
13	CUB_BEGINDAY	Character(2)	VARCHAR2(2) NOT NULL	Day