LM_MAND_ENRL_VW

(SQL View)
Index Back

View mapping the class & pers

View mapping the class & pers

SELECT A.LM_ACT_ID ,B.LM_PERSON_ID ,B.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 ,B.LM_ENRLMT_ID ,B.LM_STTS ,B.LM_TARGET_CMPL_DT ,B.LM_COMPL_DT ,B.LM_EMPL_RCD ,A.LM_RENEWAL_TYPE ,A.LM_RENW_DATE ,A.LM_HISTCREDIT_TYPE ,A.LM_HIST_DATE FROM PS_LM_ACT_ML A ,PS_LM_ML_ENR_AL_VW B , PS_LM_ACT_CI_VW C ,PS_LM_CURR_JOB_VW D WHERE A.LM_ACT_ID=B.LM_ACT_ID AND A.LM_ACT_ID=C.LM_ACT_ID AND C.LM_ACT_STATUS='1' AND (C.LM_END_DT>=%CurrentDateIn OR C.LM_END_DT IS NULL) AND B.LM_PERSON_ID = D.LM_PERSON_ID AND D.LM_ACTIVE = 'Y' AND %CurrentDateIn BETWEEN D.EFFDT AND D.LM_END_EFFDT

# 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_CI_ID Number(10,0) DECIMAL(10) NOT NULL Catalog Item ID - System Generated ID Number associated with each Catalog Item
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_HIST_CRD_PRD Number(3,0) SMALLINT NOT NULL Historical credit period days
7 LM_RNW_REQ Character(1) VARCHAR2(1) NOT NULL Renewal Needed
N=No
Y=Yes
8 LM_RNW_PD_DAYS Number(3,0) SMALLINT NOT NULL Renewal period
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_ENRLMT_ID Number(10,0) DECIMAL(10) NOT NULL Enrollment ID
12 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
13 LM_TARGET_CMPL_DT Date(10) DATE The target date by which the student should complete the course. This field is only applicable for WBT activity and the Learning Period for the WBT activity is Enforced. If the Learning Period is not enforced, this field will hold no value.
14 LM_COMPL_DT Date(10) DATE The date on which this Enrollment was marked Completed / InComplete
15 LM_EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Record umber
16 LM_RENEWAL_TYPE Character(1) VARCHAR2(1) NOT NULL Renewal Type
D=Renewal Threshold Date
P=Renewal Period

Default Value: P

17 LM_RENW_DATE Date(10) DATE Renewal date
18 LM_HISTCREDIT_TYPE Character(1) VARCHAR2(1) NOT NULL Historical Credit Type
D=Credit Threshold Date
P=Historical Credit Period

Default Value: P

19 LM_HIST_DATE Date(10) DATE Historical Date