LM_ITM_PRG_LVW(SQL View) |
Index Back |
---|---|
Program Items viewProgm Items Language view |
SELECT DISTINCT PER.OPRID , PER.LM_PERSON_ID , P.LM_PRG_ID , P.EFFDT , I.LM_OBJ_ID ,LANG.LANGUAGE_CD , LANG.LM_PRG_LONG_NM FROM PS_LM_OPRID_GRP_VW PER , PS_LM_PRG_SEC SEC , PS_LM_PRG P , PS_LM_PRG_ITEM I , PS_LM_PRG_LANG LANG WHERE 1 = 1 AND (PER.LM_LRNR_GROUP_ID = SEC.LM_LRNR_GROUP_ID OR SEC.LM_LRNR_GROUP_ID IN ( SELECT A.LM_LRNR_GROUP_ID FROM PS_LM_GROUPS_CRIT A , PS_LM_GROUP_PERSON B WHERE A.LM_FIELDNAME = 'LM_LRNR_GROUP_ID' AND B.LM_PERSON_ID=PER.LM_PERSON_ID AND A.LM_CRITERIA_VALUE = %NumToChar(B.LM_LRNR_GROUP_ID) GROUP BY A.LM_LRNR_GROUP_ID HAVING COUNT(*) = ( SELECT COUNT(*) FROM PS_LM_GROUPS_CRIT C WHERE C.LM_LRNR_GROUP_ID = A.LM_LRNR_GROUP_ID))) AND P.LM_PRG_ID = SEC.LM_PRG_ID AND P.LM_PRG_ID=LANG.LM_PRG_ID AND P.EFFDT=LANG.EFFDT AND P.LM_PRG_STATUS = '10' AND p.LM_ENRL_AUTO_REG ='Y' AND %CurrentDateIn BETWEEN P.EFFDT AND P.LM_END_EFFDT AND P.LM_PRG_ID = I.LM_PRG_ID AND I.LM_OBJ_TYPE = '10' |
# | 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_PERSON_ID | Number(15,0) | DECIMAL(15) NOT NULL | ELM Person ID |
3 | LM_PRG_ID | Number(10,0) | DECIMAL(10) NOT NULL | Program ID is a unique identifier for curriculum and certification Programs. |
4 | EFFDT | Date(10) | DATE |
Effective Date
Default Value: %date |
5 | LM_OBJ_ID | Number(10,0) | DECIMAL(10) NOT NULL | Object ID - This value is relies upon the Object Type. The Object ID will either be the Catalog Item ID or the Learning Objective ID. |
6 | LANGUAGE_CD | Character(3) | VARCHAR2(3) NOT NULL | Language Code |
7 | LM_PRG_LONG_NM | Character(200) | VARCHAR2(200) NOT NULL | Program Long Name |