| # |
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_CI_ID |
Number(10,0) |
DECIMAL(10) NOT NULL |
Catalog Item ID - System Generated ID Number associated with each Catalog Item
|
| 5 |
LM_ACT_ID |
Number(10,0) |
DECIMAL(10) NOT NULL |
Activity ID
|
| 6 |
LM_PERSON_ID |
Number(15,0) |
DECIMAL(15) NOT NULL |
ELM Person ID
|
| 7 |
LM_ORGANIZATION_ID |
Number(15,0) |
DECIMAL(15) NOT NULL |
Organization ID
|
| 8 |
LM_ACT_REQ |
Character(1) |
VARCHAR2(1) NOT NULL |
Activity Required
N=No
Y=Yes
|
| 9 |
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
|
| 10 |
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
|
| 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_WTLST_NBR |
Number(10,0) |
DECIMAL(10) NOT NULL |
Number on the Waitlist for an Activity.
|
| 13 |
LM_APPR_ID |
Number(15,0) |
DECIMAL(15) NOT NULL |
Approver ID field
|
| 14 |
LM_APPROVED_ON |
DateTime(26) |
TIMESTAMP |
The date on which this Enrollment is Approved
|
| 15 |
LM_STTS_CHANGE_DT |
Date(10) |
DATE |
Status Chage Date
|
| 16 |
LM_REQUESTOR_ID |
Number(15,0) |
DECIMAL(15) NOT NULL |
Requestor
|
| 17 |
CURRENCY_CD |
Character(3) |
VARCHAR2(3) NOT NULL |
Currency Code
|
| 18 |
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
|
| 19 |
LM_HAS_INITIATED |
Character(1) |
VARCHAR2(1) NOT NULL |
Has the student launched the course.
Y/N Table Edit
|
| 20 |
LM_INITIATED_DT |
Date(10) |
DATE |
The date on which the course was launched by the student. This applies only for WBT.
|
| 21 |
LM_ENRL_DT |
Date(10) |
DATE |
Enrollment/Registration Date
|
| 22 |
LM_COMPL_DT |
Date(10) |
DATE |
The date on which this Enrollment was marked Completed / InComplete
|
| 23 |
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.
|
| 24 |
LM_DP_DT |
Date(10) |
DATE |
Drop Date
|
| 25 |
LM_GRADE_VAL_ID |
Number(10,0) |
DECIMAL(10) NOT NULL |
This will uniquely identify the combination of User Label / Grade value.
|
| 26 |
LM_SCORE |
Character(30) |
VARCHAR2(30) NOT NULL |
Score for this Enrollment. Score will be passed by Content Vendor.
|
| 27 |
LM_ENRLMT_DESCR |
Long Character(2000) |
VARCHAR2(2000) |
Comments
|
| 28 |
LM_ADHC_LRN_ID |
Number(10,0) |
DECIMAL(10) NOT NULL |
Adhoc Learning Id
|
| 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
|
| 50 |
LM_LRQ_ID |
Number(10,0) |
DECIMAL(10) NOT NULL |
New field for ELM 9.0, stores unique identifier for a single learning request.
|
| 51 |
LM_MAND_ENRL_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Mandatory Learning Flag
Y/N Table Edit
Default Value: N
|
| 52 |
LM_LRNR_GROUP_ID |
Number(15,0) |
DECIMAL(15) NOT NULL |
Learner Group ID - Business Role/ Student Group ID
|