LM_SUBLEDG_UPDT (SQL Table)	Index Back
Sub-ledger Update Options Sub-ledger Update Options

LM_SUBLEDG_UPDT

(SQL Table)

Sub-ledger Update Options

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 LM_ACT_TYPE Character(4) VARCHAR2(4) NOT NULL Activity Type
BLND=Blended
SCHD=Scheduled
SELF=Self Paced

2 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

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	LM_ACT_TYPE	Character(4)	VARCHAR2(4) NOT NULL	Activity Type BLND=Blended SCHD=Scheduled SELF=Self Paced
2	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