LM_SUBLEDGER_VW (SQL View)	Index Back
Sub-Ledger Inquiry View

LM_SUBLEDGER_VW

(SQL View)

Sub-Ledger Inquiry View

SELECT A.LM_SUBLEDGER_ID , B.NAME , A.LM_SUBLEDGR_LN_NUM , A.LM_PYMT_ID , A.LM_SUBLEDG_GL_STAT , A.LM_ENRLMT_ID , A.LM_ENRLMT_TYPE , A.LM_STTS , A.LM_PRG_STTS , A.LM_GL_AMOUNT , A.LM_PYMT_MTHD , A.CURRENCY_CD , A.LM_DEBIT_CREDIT , B.LM_PERSON_ID FROM PS_LM_SUBLEDGER A , PS_LM_PER_NAME_VW B WHERE A.LM_PERSON_ID= B.LM_PERSON_ID AND LM_DEBIT_CREDIT='DEB'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 LM_SUBLEDGER_ID Number(15,0) DECIMAL(15) NOT NULL Sub-Ledger ID. System Generated.
Prompt Table: LM_SUBLEDGER_ID

2 NAME Character(50) VARCHAR2(50) NOT NULL Name

3 LM_SUBLEDGR_LN_NUM Number(20,0) DECIMAL(20) NOT NULL Subledger Line Number

4 LM_PYMT_ID Number(10,0) DECIMAL(10) NOT NULL Payment ID

5 LM_SUBLEDG_GL_STAT Character(3) VARCHAR2(3) NOT NULL Subledger Flag is used on the ELM Subledger. It indicates if a row on the Subledger has already been sent to GL.
ERR=Error
OLD=History Item Not Posted
PEN=Pending
POS=Posted
UPD=Updated Since Posting

6 LM_ENRLMT_ID Number(10,0) DECIMAL(10) NOT NULL Enrollment ID

7 LM_ENRLMT_TYPE Character(3) VARCHAR2(3) NOT NULL Enrollment Type could be activity, curriculum or adhoc learning
ACT=Activity Enrollment
ADH=Adhoc Enrollment
CUR=Curriculum Enrollment

8 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

9 LM_PRG_STTS Character(4) VARCHAR2(4) NOT NULL Program Reg Status
CANC=Dropped
COMP=Completed
DECL=Decline
ENRL=Registered
EXPR=Expired
INCO=Not Completed
INPO=In-Progress
PEAP=Pending Approval
PEPA=Pending Payment
PLAN=Planned
PPYA=Payment Approval
REIS=Reissue
REVK=Revoked
WAIV=Waived
WARN=Warning

10 LM_GL_AMOUNT Signed Number(28,3) DECIMAL(26,3) NOT NULL GL Amount

11 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

12 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code

13 LM_DEBIT_CREDIT Character(3) VARCHAR2(3) NOT NULL Debit or Credit Indicator
CRD=Credit
DEB=Debit

14 LM_PERSON_ID Number(15,0) DECIMAL(15) NOT NULL ELM Person ID

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	LM_SUBLEDGER_ID	Number(15,0)	DECIMAL(15) NOT NULL	Sub-Ledger ID. System Generated. Prompt Table: LM_SUBLEDGER_ID
2	NAME	Character(50)	VARCHAR2(50) NOT NULL	Name
3	LM_SUBLEDGR_LN_NUM	Number(20,0)	DECIMAL(20) NOT NULL	Subledger Line Number
4	LM_PYMT_ID	Number(10,0)	DECIMAL(10) NOT NULL	Payment ID
5	LM_SUBLEDG_GL_STAT	Character(3)	VARCHAR2(3) NOT NULL	Subledger Flag is used on the ELM Subledger. It indicates if a row on the Subledger has already been sent to GL. ERR=Error OLD=History Item Not Posted PEN=Pending POS=Posted UPD=Updated Since Posting
6	LM_ENRLMT_ID	Number(10,0)	DECIMAL(10) NOT NULL	Enrollment ID
7	LM_ENRLMT_TYPE	Character(3)	VARCHAR2(3) NOT NULL	Enrollment Type could be activity, curriculum or adhoc learning ACT=Activity Enrollment ADH=Adhoc Enrollment CUR=Curriculum Enrollment
8	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
9	LM_PRG_STTS	Character(4)	VARCHAR2(4) NOT NULL	Program Reg Status CANC=Dropped COMP=Completed DECL=Decline ENRL=Registered EXPR=Expired INCO=Not Completed INPO=In-Progress PEAP=Pending Approval PEPA=Pending Payment PLAN=Planned PPYA=Payment Approval REIS=Reissue REVK=Revoked WAIV=Waived WARN=Warning
10	LM_GL_AMOUNT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	GL Amount
11	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
12	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Currency Code
13	LM_DEBIT_CREDIT	Character(3)	VARCHAR2(3) NOT NULL	Debit or Credit Indicator CRD=Credit DEB=Debit
14	LM_PERSON_ID	Number(15,0)	DECIMAL(15) NOT NULL	ELM Person ID