LM_PERS_MAND_VW

(SQL View)
 Index Back

View mapping the class & pers

View mapping the class & pers

SELECT A.LM_ACT_ID , A.LM_PERSON_ID , A.LM_LRNR_GROUP_ID ,A.LM_CI_ID ,A.LM_ML_SEL ,A.LM_HST_CRD_ALLOW ,A.LM_HIST_CRD_PRD ,A.LM_RNW_REQ ,A.LM_RNW_PD_DAYS ,A.LM_DUE_DT_MTHD ,A.LM_DUE_DATE FROM PS_LM_MAND_LG_VW A WHERE A.LM_LRNR_GROUP_ID= ( SELECT MIN(B.LM_LRNR_GROUP_ID) FROM PS_LM_MAND_LG_VW B WHERE A.LM_ACT_ID=B.LM_ACT_ID AND A.LM_PERSON_ID=B.LM_PERSON_ID) AND NOT EXISTS( SELECT 'X' FROM PS_LM_MAND_LRNR_VW C WHERE C.LM_ACT_ID=A.LM_ACT_ID AND C.LM_PERSON_ID=A.LM_PERSON_ID) UNION SELECT A.LM_ACT_ID , A.LM_PERSON_ID , A.LM_LRNR_GROUP_ID ,A.LM_CI_ID ,A.LM_ML_SEL ,A.LM_HST_CRD_ALLOW ,A.LM_HIST_CRD_PRD ,A.LM_RNW_REQ ,A.LM_RNW_PD_DAYS ,A.LM_DUE_DT_MTHD ,A.LM_DUE_DATE FROM PS_LM_MAND_LRNR_VW A

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 LM_ACT_ID Number(10,0) DECIMAL(10) NOT NULL Activity ID
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_CI_ID Number(10,0) DECIMAL(10) NOT NULL Catalog Item ID - System Generated ID Number associated with each Catalog Item
5 LM_ML_SEL Character(1) VARCHAR2(1) NOT NULL Selection Criteria
G=Learner Group
L=Learner
6 LM_HST_CRD_ALLOW Character(1) VARCHAR2(1) NOT NULL Allow historical credit

Y/N Table Edit

7 LM_HIST_CRD_PRD Number(3,0) SMALLINT NOT NULL Historical credit period days
8 LM_RNW_REQ Character(1) VARCHAR2(1) NOT NULL Renewal Needed
N=No
Y=Yes
9 LM_RNW_PD_DAYS Number(3,0) SMALLINT NOT NULL Renewal period
10 LM_DUE_DT_MTHD Character(2) VARCHAR2(2) NOT NULL Due date method
DT=Date
LP=Learning Period
11 LM_DUE_DATE Date(10) DATE Due Date