LM_ENRLMT_VW

(SQL View)
 Index Back

Enrollment

Enrollment Record

SELECT A.LM_ENRLMT_ID , A.LM_CI_ID , A.LM_ACT_ID , A.LM_PERSON_ID , A.LM_ORGANIZATION_ID , A.LM_ACT_REQ , A.LM_TYPE , A.LM_OLD_STTS , A.LM_STTS , A.LM_PASS_VAL_ID , A.LM_WTLST_NBR , A.LM_APPR_ID , A.LM_APPROVED_ON , A.LM_STTS_CHANGE_DT , A.LM_REQUESTOR_ID , A.CURRENCY_CD , A.LM_PYMT_MTHD , A.LM_HAS_INITIATED , A.LM_INITIATED_DT , A.LM_ENRL_DT , A.LM_COMPL_DT , A.LM_TARGET_CMPL_DT , A.LM_DP_DT , A.LM_GRADE_VAL_ID , A.LM_SCORE , A.LM_ENRLMT_DESCR , A.LM_ADHC_LRN_ID , A.LM_EXT_ID , A.LM_EXT_INFO , A.LM_EMPL_RCD , A.LM_MAND_ENRL_FLG , A.LM_LRNR_GROUP_ID , %subrec(LM_ACT_PRCE_SBR,A) , %subrec(LM_AMT_PRCE_SBR,A) , %subrec(LM_ENRL_FRA_SBR,A) , %subrec(LM_ROWAUDIT_SBR,A) FROM PS_LM_ENRLMT A

  • Related Language Record: LM_ENRLMT_LANG

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 LM_ENRLMT_ID Number(10,0) DECIMAL(10) NOT NULL Enrollment ID
    2 LM_CI_ID Number(10,0) DECIMAL(10) NOT NULL Catalog Item ID - System Generated ID Number associated with each Catalog Item
    3 LM_ACT_ID Number(10,0) DECIMAL(10) NOT NULL Activity ID
    4 LM_PERSON_ID Number(15,0) DECIMAL(15) NOT NULL ELM Person ID
    5 LM_ORGANIZATION_ID Number(15,0) DECIMAL(15) NOT NULL Organization ID
    6 LM_ACT_REQ Character(1) VARCHAR2(1) NOT NULL Activity Required
    N=No
    Y=Yes
    7 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
    8 LM_OLD_STTS Character(4) VARCHAR2(4) NOT NULL Old Enrollment Status. This field will be loaded with the Actual Enrollment Status whenver the person is marked Completed / Incomplete. Before attendance marking this field will not hold any value.
    CANC=Dropped
    COMP=Completed
    DECL=Declined
    ENRL=Enrolled
    INCO=Not Completed
    INPO=In-Progress
    PEAP=Pending Approval
    PEPA=Pending Payment
    PLAN=Planned
    PPYA=Payment Approval
    WAIV=Waived
    WTLT=Waitlisted
    9 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
    10 LM_PASS_VAL_ID Number(10,0) DECIMAL(10) NOT NULL Passing Scheme Value ID
    11 LM_WTLST_NBR Number(10,0) DECIMAL(10) NOT NULL Number on the Waitlist for an Activity.
    12 LM_APPR_ID Number(15,0) DECIMAL(15) NOT NULL Approver ID field
    13 LM_APPROVED_ON DateTime(26) TIMESTAMP The date on which this Enrollment is Approved
    14 LM_STTS_CHANGE_DT Date(10) DATE Status Chage Date
    15 LM_REQUESTOR_ID Number(15,0) DECIMAL(15) NOT NULL Requestor
    16 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code
    17 LM_PYMT_MTHD Character(4) VARCHAR2(4) NOT NULL Payment Method. The payment method can be ChargeBack, Training Units
    CASH=Cash
    CHCK=Check
    CHGB=ChargeBack
    CRCD=Credit Card
    NOAP=Not Applicable
    PO=Purchase Order
    SEL=Select...
    TU=Training Units
    18 LM_HAS_INITIATED Character(1) VARCHAR2(1) NOT NULL Has the student launched the course.

    Y/N Table Edit

    19 LM_INITIATED_DT Date(10) DATE The date on which the course was launched by the student. This applies only for WBT.
    20 LM_ENRL_DT Date(10) DATE Enrollment/Registration Date
    21 LM_COMPL_DT Date(10) DATE The date on which this Enrollment was marked Completed / InComplete
    22 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.
    23 LM_DP_DT Date(10) DATE Drop Date
    24 LM_GRADE_VAL_ID Number(10,0) DECIMAL(10) NOT NULL This will uniquely identify the combination of User Label / Grade value.
    25 LM_SCORE Character(30) VARCHAR2(30) NOT NULL Score for this Enrollment. Score will be passed by Content Vendor.
    26 LM_ENRLMT_DESCR Long Character(2000) VARCHAR2(2000) Comments
    27 LM_ADHC_LRN_ID Number(10,0) DECIMAL(10) NOT NULL Adhoc Learning Id
    28 LM_EXT_ID Character(30) VARCHAR2(30) NOT NULL External ID for the Enrollment. This field is used in case of integrating with Thirdparty systems.
    29 LM_EXT_INFO Character(100) VARCHAR2(100) NOT NULL Enrollment External Info. This field is used in case of integrating with Thirdparty systems.
    30 LM_EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Record umber
    31 LM_MAND_ENRL_FLG Character(1) VARCHAR2(1) NOT NULL Mandatory Learning Flag
    32 LM_LRNR_GROUP_ID Number(15,0) DECIMAL(15) NOT NULL Learner Group ID - Business Role/ Student Group ID
    33 LM_ACT_FEE Number(19,3) DECIMAL(18,3) NOT NULL Activity Fee -- The cost to the learner of enrolling in a class
    34 LM_DP_CHGES Number(23,3) DECIMAL(22,3) NOT NULL Drop Charges
    35 LM_FEE_NO_OF_TUS Number(14,3) DECIMAL(13,3) NOT NULL No of Training Units available/used.
    36 LM_FEE_DP_TUS Number(14,3) DECIMAL(13,3) NOT NULL No of Training Units available/used.
    37 LM_AMT_PAID Number(23,3) DECIMAL(22,3) NOT NULL Amount Paid so far towards the Enrollment Fee
    38 LM_PAID_DP_CHGES Number(23,3) DECIMAL(22,3) NOT NULL Drop Charges
    39 LM_PAID_TUS Number(14,3) DECIMAL(13,3) NOT NULL No of Training Units available/used.
    40 LM_PAID_DP_TUS Number(14,3) DECIMAL(13,3) NOT NULL No of Training Units available/used.
    41 LM_TRAINING_CLASS Character(10) VARCHAR2(10) NOT NULL Training Class

    Default Value: 9

    Prompt Table: LM_TRAIN_CLASS

    42 LM_ACT_DIF_FLG Character(1) VARCHAR2(1) NOT NULL DIF Enrollment

    Y/N Table Edit

    Default Value: N

    43 LM_TRG_PLN_CTGY Character(10) VARCHAR2(10) NOT NULL Training Plan Category
    44 LM_ROW_ADDED_DTTM DateTime(26) TIMESTAMP Datetime Added
    45 LM_ROW_ADDED_OPRID Character(30) VARCHAR2(30) NOT NULL Added By
    46 LM_ROW_MAINT_DTTM DateTime(26) TIMESTAMP Row Maintainted DateTime
    47 LM_ROW_MAINT_OPRID Character(30) VARCHAR2(30) NOT NULL Row Maintained Oprid