LM_TPLN_REG_VW (SQL View)	Index Back
Training Plan Enrollment Training plan program enrollment view

LM_TPLN_REG_VW

(SQL View)

Training Plan Enrollment

Training plan program enrollment view

SELECT A.LM_PRG_REG_ID , A.LM_PRG_ID , A.LM_PERSON_ID , A.LM_EMPL_RCD , B.LM_ORGANIZATION_ID , B.LM_LE_ID , B.LM_HR_COMPANY , B.BUSINESS_UNIT , A.LM_ENRL_DT , A.LM_COMPL_DT , A.LM_PRG_STTS FROM PS_LM_PRG_REG A , PS_LM_PERSON_ATTRB B , PS_LM_PRG C WHERE A.LM_PERSON_ID = B.LM_PERSON_ID AND %CurrentDateIn BETWEEN B.EFFDT AND B.LM_END_EFFDT AND %CurrentDateIn BETWEEN C.EFFDT AND C.LM_END_EFFDT AND A.LM_PRG_ID = C.LM_PRG_ID AND A.LM_EMPL_RCD = B.LM_EMPL_RCD

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 LM_PRG_REG_ID Number(10,0) DECIMAL(10) NOT NULL The Program Registration ID is a unique identifier for a learner's program enrollment.

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

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

4 LM_EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Record umber

5 LM_ORGANIZATION_ID Number(15,0) DECIMAL(15) NOT NULL Organization ID

6 LM_LE_ID Number(10,0) DECIMAL(10) NOT NULL Learning Environment ID - System Generated number

7 LM_HR_COMPANY Character(3) VARCHAR2(3) NOT NULL HR's Company ID brought over during synchronization.

8 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

9 LM_ENRL_DT Date(10) DATE Enrollment/Registration Date

10 LM_COMPL_DT Date(10) DATE The date on which this Enrollment was marked Completed / InComplete

11 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

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	LM_PRG_REG_ID	Number(10,0)	DECIMAL(10) NOT NULL	The Program Registration ID is a unique identifier for a learner's program enrollment.
2	LM_PRG_ID	Number(10,0)	DECIMAL(10) NOT NULL	Program ID is a unique identifier for curriculum and certification Programs.
3	LM_PERSON_ID	Number(15,0)	DECIMAL(15) NOT NULL	ELM Person ID
4	LM_EMPL_RCD	Number(3,0)	SMALLINT NOT NULL	Empl Record umber
5	LM_ORGANIZATION_ID	Number(15,0)	DECIMAL(15) NOT NULL	Organization ID
6	LM_LE_ID	Number(10,0)	DECIMAL(10) NOT NULL	Learning Environment ID - System Generated number
7	LM_HR_COMPANY	Character(3)	VARCHAR2(3) NOT NULL	HR's Company ID brought over during synchronization.
8	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
9	LM_ENRL_DT	Date(10)	DATE	Enrollment/Registration Date
10	LM_COMPL_DT	Date(10)	DATE	The date on which this Enrollment was marked Completed / InComplete
11	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