LM_ENRMNT_HSTVW

(SQL View)
 Index Back

Enrollment

Enrollment Record

SELECT PSARCH_ID , PSARCH_BATCHNUM , 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_HST A

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 PSARCH_ID Character(8) VARCHAR2(8) NOT NULL Archive ID (see PSARCHTEMPLATE).
2 PSARCH_BATCHNUM Number(30,0) DECIMAL(30) NOT NULL Archive Batch Number
3 LM_ENRLMT_ID Number(10,0) DECIMAL(10) NOT NULL Enrollment ID
4 LM_ADHC_LRN_ID Number(10,0) DECIMAL(10) NOT NULL Adhoc Learning Id
5 LM_CI_ID Number(10,0) DECIMAL(10) NOT NULL Catalog Item ID - System Generated ID Number associated with each Catalog Item
6 LM_ACT_ID Number(10,0) DECIMAL(10) NOT NULL Activity ID
7 LM_PERSON_ID Number(15,0) DECIMAL(15) NOT NULL ELM Person ID
8 LM_ORGANIZATION_ID Number(15,0) DECIMAL(15) NOT NULL Organization ID
9 LM_ACT_REQ Character(1) VARCHAR2(1) NOT NULL Activity Required
N=No
Y=Yes
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_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
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_WTLST_NBR Number(10,0) DECIMAL(10) NOT NULL Number on the Waitlist for an Activity.
14 LM_APPR_ID Number(15,0) DECIMAL(15) NOT NULL Approver ID field
15 LM_APPROVED_ON DateTime(26) TIMESTAMP The date on which this Enrollment is Approved
16 LM_STTS_CHANGE_DT Date(10) DATE Status Chage Date
17 LM_REQUESTOR_ID Number(15,0) DECIMAL(15) NOT NULL Requestor
18 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code
19 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
20 LM_HAS_INITIATED Character(1) VARCHAR2(1) NOT NULL Has the student launched the course.

Y/N Table Edit

21 LM_INITIATED_DT Date(10) DATE The date on which the course was launched by the student. This applies only for WBT.
22 LM_ENRL_DT Date(10) DATE Enrollment/Registration Date
23 LM_COMPL_DT Date(10) DATE The date on which this Enrollment was marked Completed / InComplete
24 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.
25 LM_DP_DT Date(10) DATE Drop Date
26 LM_GRADE_VAL_ID Number(10,0) DECIMAL(10) NOT NULL This will uniquely identify the combination of User Label / Grade value.
27 LM_SCORE Character(30) VARCHAR2(30) NOT NULL Score for this Enrollment. Score will be passed by Content Vendor.
28 LM_ENRLMT_DESCR Long Character(2000) VARCHAR2(2000) Comments
29 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.
30 LM_EXT_INFO Character(100) VARCHAR2(100) NOT NULL Enrollment External Info. This field is used in case of integrating with Thirdparty systems.
31 LM_PASS_VAL_ID Number(10,0) DECIMAL(10) NOT NULL Passing Scheme Value ID
32 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
33 LM_EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Record umber
34 LM_ACT_FEE Number(19,3) DECIMAL(18,3) NOT NULL Activity Fee -- The cost to the learner of enrolling in a class
35 LM_DP_CHGES Number(23,3) DECIMAL(22,3) NOT NULL Drop Charges
36 LM_FEE_NO_OF_TUS Number(14,3) DECIMAL(13,3) NOT NULL No of Training Units available/used.
37 LM_FEE_DP_TUS Number(14,3) DECIMAL(13,3) NOT NULL No of Training Units available/used.
38 LM_AMT_PAID Number(23,3) DECIMAL(22,3) NOT NULL Amount Paid so far towards the Enrollment Fee
39 LM_PAID_DP_CHGES Number(23,3) DECIMAL(22,3) NOT NULL Drop Charges
40 LM_PAID_TUS Number(14,3) DECIMAL(13,3) NOT NULL No of Training Units available/used.
41 LM_PAID_DP_TUS Number(14,3) DECIMAL(13,3) NOT NULL No of Training Units available/used.
42 LM_ROW_ADDED_DTTM DateTime(26) TIMESTAMP Datetime Added
43 LM_ROW_ADDED_OPRID Character(30) VARCHAR2(30) NOT NULL Added By
44 LM_ROW_MAINT_DTTM DateTime(26) TIMESTAMP Row Maintainted DateTime
45 LM_ROW_MAINT_OPRID Character(30) VARCHAR2(30) NOT NULL Row Maintained Oprid
46 LM_TRAINING_CLASS Character(10) VARCHAR2(10) NOT NULL Training Class

Default Value: 9

Prompt Table: LM_TRAIN_CLASS

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

Y/N Table Edit

Default Value: N

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

Y/N Table Edit