LM_PRG_NOTIF (SQL View)	Index Back
Curriculum Search View Curriculum Search View

LM_PRG_NOTIF

(SQL View)

Curriculum Search View

SELECT A.OPRID , B.LM_PRG_ID , B.EFFDT , B.LM_END_EFFDT , B.LM_PRG_CD , B.LM_VERSION , B.LM_PRG_LONG_NM , B.LM_PRG_SHORT_NM , B.LM_PRG_TYPE , B.LM_OWNER_ID , B.LM_PRG_STATUS , B.LM_CERT_ID FROM PS_LM_OPRID_LE_VW A , PS_LM_PRG B , PS_LM_PRG_LE C WHERE A.LM_LE_ID=C.LM_LE_ID AND B.LM_PRG_ID = C.LM_PRG_ID AND B.EFFDT = C.EFFDT UNION SELECT PEROPR.OPRID , B.LM_PRG_ID , B.EFFDT , B.LM_END_EFFDT , B.LM_PRG_CD , B.LM_VERSION , B.LM_PRG_LONG_NM , B.LM_PRG_SHORT_NM , B.LM_PRG_TYPE , B.LM_OWNER_ID , B.LM_PRG_STATUS , B.LM_CERT_ID FROM PS_LM_PERSON_OPRID PEROPR , PS_LM_PRG B , PS_LM_PERSON_JOB PERJOB , PS_LM_PERSON PER , PS_LM_MGR_VW MGR , PS_LM_PRG_REG REG WHERE PERJOB.LM_PERSON_ID = PEROPR.LM_PERSON_ID AND PER.LM_PERSON_ID = PEROPR.LM_PERSON_ID AND %CurrentDateIn BETWEEN PERJOB.EFFDT AND PERJOB.LM_END_EFFDT AND PERJOB.LM_ACTIVE = 'Y' AND PEROPR.LM_PERSON_ID = MGR.LM_MANAGER_ID AND MGR.LM_PERSON_ID = REG.LM_PERSON_ID AND REG.LM_PRG_ID = B.LM_PRG_ID

Related Language Record: LM_PRG_SRCH_LNG

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).

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

3 EFFDT Date(10) DATE Effective Date
Default Value: %date

4 LM_END_EFFDT Date(10) DATE The end effective date, automatically maintained, there's a doc on how this works, so read it

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_VERSION Character(30) VARCHAR2(30) NOT NULL Program Version

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

8 LM_PRG_SHORT_NM Character(10) VARCHAR2(10) NOT NULL Program Short Name

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

10 LM_OWNER_ID Number(15,0) DECIMAL(15) NOT NULL Owner ID

11 LM_PRG_STATUS Character(2) VARCHAR2(2) NOT NULL Program Status
10=Active
20=Inactive
30=Pending

12 LM_CERT_ID Number(10,0) DECIMAL(10) NOT NULL Certification ID

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	OPRID	Character(30)	VARCHAR2(30) NOT NULL	A user's ID (see PSOPRDEFN).
2	LM_PRG_ID	Number(10,0)	DECIMAL(10) NOT NULL	Program ID is a unique identifier for curriculum and certification Programs.
3	EFFDT	Date(10)	DATE	Effective Date Default Value: %date
4	LM_END_EFFDT	Date(10)	DATE	The end effective date, automatically maintained, there's a doc on how this works, so read it
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_VERSION	Character(30)	VARCHAR2(30) NOT NULL	Program Version
7	LM_PRG_LONG_NM	Character(200)	VARCHAR2(200) NOT NULL	Program Long Name
8	LM_PRG_SHORT_NM	Character(10)	VARCHAR2(10) NOT NULL	Program Short Name
9	LM_PRG_TYPE	Character(2)	VARCHAR2(2) NOT NULL	Program Type CE=Certification CU=Curriculum
10	LM_OWNER_ID	Number(15,0)	DECIMAL(15) NOT NULL	Owner ID
11	LM_PRG_STATUS	Character(2)	VARCHAR2(2) NOT NULL	Program Status 10=Active 20=Inactive 30=Pending
12	LM_CERT_ID	Number(10,0)	DECIMAL(10) NOT NULL	Certification ID