LM_ENRMNT_VW

(SQL View)
 Index Back

Enrollment

Enrollment Record

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

# 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_ADHC_LRN_ID Number(10,0) DECIMAL(10) NOT NULL Adhoc Learning 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_ACT_ID Number(10,0) DECIMAL(10) NOT NULL Activity ID
5 LM_PERSON_ID Number(15,0) DECIMAL(15) NOT NULL ELM Person ID
6 LM_ORGANIZATION_ID Number(15,0) DECIMAL(15) NOT NULL Organization ID
7 LM_ACT_REQ Character(1) VARCHAR2(1) NOT NULL Activity Required
N=No
Y=Yes
8 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
9 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
10 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
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_EXT_ID Character(30) VARCHAR2(30) NOT NULL External ID for the Enrollment. This field is used in case of integrating with Thirdparty systems.
28 LM_EXT_INFO Character(100) VARCHAR2(100) NOT NULL Enrollment External Info. This field is used in case of integrating with Thirdparty systems.
29 LM_PASS_VAL_ID Number(10,0) DECIMAL(10) NOT NULL Passing Scheme Value ID
30 LM_ATT_VAL_ID Number(10,0) DECIMAL(10) NOT NULL Attendance Scheme Value Id. This will identify the combination of User Label / Attendance uniquely
31 LM_EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Record umber
32 LM_ACT_FEE Number(19,3) DECIMAL(18,3) NOT NULL Activity Fee -- The cost to the learner of enrolling in a class
33 LM_DP_CHGES Number(23,3) DECIMAL(22,3) NOT NULL Drop Charges
34 LM_FEE_NO_OF_TUS Number(14,3) DECIMAL(13,3) NOT NULL No of Training Units available/used.
35 LM_FEE_DP_TUS Number(14,3) DECIMAL(13,3) NOT NULL No of Training Units available/used.
36 LM_AMT_PAID Number(23,3) DECIMAL(22,3) NOT NULL Amount Paid so far towards the Enrollment Fee
37 LM_PAID_DP_CHGES Number(23,3) DECIMAL(22,3) NOT NULL Drop Charges
38 LM_PAID_TUS Number(14,3) DECIMAL(13,3) NOT NULL No of Training Units available/used.
39 LM_PAID_DP_TUS Number(14,3) DECIMAL(13,3) NOT NULL No of Training Units available/used.
40 LM_ROW_ADDED_DTTM DateTime(26) TIMESTAMP Datetime Added
41 LM_ROW_ADDED_OPRID Character(30) VARCHAR2(30) NOT NULL Added By
42 LM_ROW_MAINT_DTTM DateTime(26) TIMESTAMP Row Maintainted DateTime
43 LM_ROW_MAINT_OPRID Character(30) VARCHAR2(30) NOT NULL Row Maintained Oprid
44 LM_TRAINING_CLASS Character(10) VARCHAR2(10) NOT NULL Training Class

Default Value: 9

Prompt Table: LM_TRAIN_CLASS

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

Y/N Table Edit

Default Value: N

46 LM_TRG_PLN_CTGY Character(10) VARCHAR2(10) NOT NULL Training Plan Category
47 LM_IS_APPR_LAUNCHD Character(1) VARCHAR2(1) NOT NULL This flag indicates whether approval was launched for the transaction.

Y/N Table Edit