LM_SBLDGR_VW

#	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	LM_SUBLEDGR_LN_NUM	Number(20,0)	DECIMAL(20) NOT NULL	Subledger Line Number
3	LM_ENRLMT_ID	Number(10,0)	DECIMAL(10) NOT NULL	Enrollment ID
4	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
5	LM_PERSON_ID	Number(15,0)	DECIMAL(15) NOT NULL	ELM Person ID
6	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
7	LM_DT_PYMT_RECV	DateTime(26)	TIMESTAMP	Date on which the payment was received
8	LM_PYMT_ID	Number(10,0)	DECIMAL(10) NOT NULL	Payment ID
9	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
10	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
11	LM_GL_AMOUNT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	GL Amount
12	LM_DEBIT_CREDIT	Character(3)	VARCHAR2(3) NOT NULL	Debit or Credit Indicator CRD=Credit DEB=Debit
13	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
14	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Currency Code
15	BUSINESS_UNIT_GL	Character(5)	VARCHAR2(5) NOT NULL	General Ledger Business Unit
16	LM_ACCOUNT	Character(20)	VARCHAR2(20) NOT NULL	Account Chart Field Prompt Table: %EDITTABLE9
17	LM_ALTACCT	Character(20)	VARCHAR2(20) NOT NULL	Alternate Account Chartfield Prompt Table: %EDITTABLE11
18	LM_BUDGET_REF	Character(20)	VARCHAR2(20) NOT NULL	Budget Reference Chartfield Prompt Table: %EDITTABLE13
19	LM_CHARTFIELD1	Character(20)	VARCHAR2(20) NOT NULL	Chartfield 1 Prompt Table: %EDITTABLE15
20	LM_CHARTFIELD2	Character(20)	VARCHAR2(20) NOT NULL	Chartfield 2 Prompt Table: %EDITTABLE16
21	LM_CHARTFIELD3	Character(20)	VARCHAR2(20) NOT NULL	Chartfield 3 Prompt Table: %EDITTABLE17
22	LM_CLASS_FLD	Character(20)	VARCHAR2(20) NOT NULL	Class Chart Field Prompt Table: %EDITTABLE7
23	LM_FUND_CODE	Character(20)	VARCHAR2(20) NOT NULL	Fund Code Prompt Table: %EDITTABLE6
24	LM_HR_DEPTID	Character(10)	VARCHAR2(10) NOT NULL	Department Prompt Table: LM_DEPT_CF_VW
25	LM_OPERATING_UNIT	Character(20)	VARCHAR2(20) NOT NULL	Operating Unit ChartField Prompt Table: %EDITTABLE12
26	LM_PRODUCT	Character(20)	VARCHAR2(20) NOT NULL	Product Chartfield Prompt Table: %EDITTABLE14
27	LM_PROGRAM_CODE	Character(20)	VARCHAR2(20) NOT NULL	Program Chart Field Prompt Table: %EDITTABLE8
28	LM_PROJECT_ID	Character(20)	VARCHAR2(20) NOT NULL	Project Chart Field Prompt Table: %EDITTABLE10
29	LM_SUBLEDGER_DT	DateTime(26)	TIMESTAMP	SubLedger Date - Date and Time row was written to SubLedger
30	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
31	OPRID	Character(30)	VARCHAR2(30) NOT NULL	A user's ID (see PSOPRDEFN).