LM_ENRLMT_MG_VW

(SQL View)
 Index Back

Manager Enrollment

Manager Enrollment

SELECT B.OPRID , B.LM_MANAGER_ID , A.LM_PERSON_ID , A.LM_ENRLMT_ID , C.FIRST_NAME , C.LAST_NAME , A.LM_CI_ID , A.LM_ACT_ID , A.LM_ACT_REQ , A.LM_TYPE , A.LM_STTS , A.LM_ACT_FEE , A.LM_COMPL_DT , A.LM_GRADE_VAL_ID , E.LM_GRADE_LABEL , A.LM_SCORE , A.LM_REQUESTOR_ID , A.LM_ENRLMT_DESCR , A.LM_TARGET_CMPL_DT , A.LM_PASS_VAL_ID , D.LM_PASS_STTS , A.LM_ENRL_DT , A.LM_ADHC_LRN_ID ,%subrec(LM_ROWAUDIT_SBR, A) , C.LM_NAME_DISPLAY FROM PS_LM_ENRLMT_VW A , PS_LM_MGR_SRCH_VW B , PS_LM_PERS_DTL_VW C , PS_LM_GRD_SCH_VAL E , PS_LM_PASS_SCH_VAL D WHERE B.LM_PERSON_ID = A.LM_PERSON_ID AND A.LM_STTS IN ('ENRL','INPO','PEAP','PLAN','WTLT','COMP','INCO','PEPA','PPYA','WAIV') AND A.LM_PERSON_ID = C.LM_PERSON_ID AND A.LM_GRADE_VAL_ID = E.LM_GRADE_VAL_ID AND A.LM_PASS_VAL_ID = D.LM_PASS_VAL_ID AND C.LM_ACTIVE='Y'

  • Related Language Record: LM_ENRLMTMG_LVW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
    2 LM_MANAGER_ID Number(15,0) DECIMAL(15) NOT NULL Manager ID
    3 LM_PERSON_ID Number(15,0) DECIMAL(15) NOT NULL ELM Person ID
    4 LM_ENRLMT_ID Number(10,0) DECIMAL(10) NOT NULL Enrollment ID
    5 FIRST_NAME Character(30) VARCHAR2(30) NOT NULL First Name field
    6 LAST_NAME Character(30) VARCHAR2(30) NOT NULL Last Name Field
    7 LM_CI_ID Number(10,0) DECIMAL(10) NOT NULL Catalog Item ID - System Generated ID Number associated with each Catalog Item
    8 LM_ACT_ID Number(10,0) DECIMAL(10) NOT NULL Activity ID
    9 LM_ACT_REQ Character(1) VARCHAR2(1) NOT NULL Activity Required
    N=No
    Y=Yes

    Y/N Table Edit

    Default Value: N

    10 LM_TYPE Character(4) VARCHAR2(4) NOT NULL Type of the Enrollment. This field for now will have only one value STDD
    ADHC=Adhoc
    PLAN=Planned
    RSRV=Reserved
    STDD=Standard
    11 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
    12 LM_ACT_FEE Number(19,3) DECIMAL(18,3) NOT NULL Activity Fee -- The cost to the learner of enrolling in a class
    13 LM_COMPL_DT Date(10) DATE The date on which this Enrollment was marked Completed / InComplete
    14 LM_GRADE_VAL_ID Number(10,0) DECIMAL(10) NOT NULL This will uniquely identify the combination of User Label / Grade value.
    15 LM_GRADE_LABEL Character(30) VARCHAR2(30) NOT NULL Grade
    16 LM_SCORE Character(30) VARCHAR2(30) NOT NULL Score for this Enrollment. Score will be passed by Content Vendor.
    17 LM_REQUESTOR_ID Number(15,0) DECIMAL(15) NOT NULL Requestor
    18 LM_ENRLMT_DESCR Long Character(2000) VARCHAR2(2000) Comments
    19 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.
    20 LM_PASS_VAL_ID Number(10,0) DECIMAL(10) NOT NULL Passing Scheme Value ID
    21 LM_PASS_STTS Character(4) VARCHAR2(4) NOT NULL Passing Status
    FAIL=Fail
    NOMK=Not Marked
    NORQ=Not Required
    PASS=Pass
    PEND=Pending
    22 LM_ENRL_DT Date(10) DATE Enrollment/Registration Date
    23 LM_ADHC_LRN_ID Number(10,0) DECIMAL(10) NOT NULL Adhoc Learning Id
    24 LM_ROW_ADDED_DTTM DateTime(26) TIMESTAMP Datetime Added
    25 LM_ROW_ADDED_OPRID Character(30) VARCHAR2(30) NOT NULL Added By
    26 LM_ROW_MAINT_DTTM DateTime(26) TIMESTAMP Row Maintainted DateTime
    27 LM_ROW_MAINT_OPRID Character(30) VARCHAR2(30) NOT NULL Row Maintained Oprid
    28 LM_NAME_DISPLAY Character(50) VARCHAR2(50) NOT NULL Name Display field