LM_PRG_SECVERVW (SQL View)	Index Back
Program securtiy SES:Program security The LM_LRNR_GROUP_ID = 999999999999999 is joined on the SQL. This is needed if you want to get all the programs regardless of the program security group.

LM_PRG_SECVERVW

(SQL View)

Program securtiy

SES:Program security The LM_LRNR_GROUP_ID = 999999999999999 is joined on the SQL. This is needed if you want to get all the programs regardless of the program security group.

SELECT A1.LM_PRG_ID , %NumToChar(A1.LM_LRNR_GROUP_ID) FROM PS_LM_PRG_SEC A1 ,PS_LM_LRNR_GROUPS B1 , PS_LM_PRG C1 WHERE A1.LM_PRG_ID = C1.LM_PRG_ID AND A1.LM_LRNR_GROUP_ID = B1.LM_LRNR_GROUP_ID AND %CurrentDateIn BETWEEN A1.EFFDT AND A1.LM_END_EFFDT AND A1.EFFDT = C1.EFFDT AND %CurrentDateIn BETWEEN C1.EFFDT AND C1.LM_END_EFFDT AND C1.LM_PRG_STATUS = '10' UNION SELECT C2.LM_PRG_ID , '999999999999999' FROM PS_LM_PRG C2 WHERE %CurrentDateIn BETWEEN C2.EFFDT AND C2.LM_END_EFFDT AND C2.LM_PRG_STATUS = '10'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

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

2 LM_LRNR_SRCHGRP_ID Character(26) VARCHAR2(26) NOT NULL Learner Group ID - Business Role/ Student Group ID

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	LM_PRG_ID	Number(10,0)	DECIMAL(10) NOT NULL	Program ID is a unique identifier for curriculum and certification Programs.
2	LM_LRNR_SRCHGRP_ID	Character(26)	VARCHAR2(26) NOT NULL	Learner Group ID - Business Role/ Student Group ID