LM_LDGR_PROG_VW (SQL View)	Index Back
Program view program view

LM_LDGR_PROG_VW

(SQL View)

Program view

program view

SELECT DISTINCT C.LM_ENRLMT_ID ,A.LM_PERSON_ID ,A.LM_PRG_STTS ,A.LM_PRG_ID ,B.LM_PRG_CD ,B.LM_PRG_LONG_NM ,B.LM_PRG_TYPE ,A.LM_ACT_FEE ,A.CURRENCY_CD ,A.LM_DP_CHGES ,A.LM_FEE_NO_OF_TUS ,A.LM_FEE_DP_TUS ,A.LM_DP_DT ,C.LM_PYMT_MTHD FROM PS_LM_PRG_REG_VW A , PS_LM_PRG_VW B , PS_LM_ENPYMT_VW C WHERE A.LM_PRG_ID =B.LM_PRG_ID AND C.LM_ENRLMT_ID = A.LM_PRG_REG_ID

Related Language Record: LM_LDGR_PRG_LVW

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

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

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

3 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

4 LM_PRG_ID Number(10,0) DECIMAL(10) NOT NULL Program ID is a unique identifier for curriculum and certification Programs.

5 LM_PRG_CD Character(30) VARCHAR2(30) NOT NULL Program Code is a user defined field. This field allows duplicates and is not part of the primary key structure.

6 LM_PRG_LONG_NM Character(200) VARCHAR2(200) NOT NULL Program Long Name

7 LM_PRG_TYPE Character(2) VARCHAR2(2) NOT NULL Program Type
CE=Certification
CU=Curriculum

8 LM_ACT_FEE Number(19,3) DECIMAL(18,3) NOT NULL Activity Fee -- The cost to the learner of enrolling in a class

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

10 LM_DP_CHGES Number(23,3) DECIMAL(22,3) NOT NULL Drop Charges

11 LM_FEE_NO_OF_TUS Number(14,3) DECIMAL(13,3) NOT NULL No of Training Units available/used.

12 LM_FEE_DP_TUS Number(14,3) DECIMAL(13,3) NOT NULL No of Training Units available/used.

13 LM_DP_DT Date(10) DATE Drop Date

14 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

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	LM_ENRLMT_ID	Number(10,0)	DECIMAL(10) NOT NULL	Enrollment ID
2	LM_PERSON_ID	Number(15,0)	DECIMAL(15) NOT NULL	ELM Person ID
3	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
4	LM_PRG_ID	Number(10,0)	DECIMAL(10) NOT NULL	Program ID is a unique identifier for curriculum and certification Programs.
5	LM_PRG_CD	Character(30)	VARCHAR2(30) NOT NULL	Program Code is a user defined field. This field allows duplicates and is not part of the primary key structure.
6	LM_PRG_LONG_NM	Character(200)	VARCHAR2(200) NOT NULL	Program Long Name
7	LM_PRG_TYPE	Character(2)	VARCHAR2(2) NOT NULL	Program Type CE=Certification CU=Curriculum
8	LM_ACT_FEE	Number(19,3)	DECIMAL(18,3) NOT NULL	Activity Fee -- The cost to the learner of enrolling in a class
9	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Currency Code
10	LM_DP_CHGES	Number(23,3)	DECIMAL(22,3) NOT NULL	Drop Charges
11	LM_FEE_NO_OF_TUS	Number(14,3)	DECIMAL(13,3) NOT NULL	No of Training Units available/used.
12	LM_FEE_DP_TUS	Number(14,3)	DECIMAL(13,3) NOT NULL	No of Training Units available/used.
13	LM_DP_DT	Date(10)	DATE	Drop Date
14	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