LM_PRG_IDEFFDTDefault Value: %date
LM_LRNR_GROUP_IDLANGUAGE_CDLM_PRG_GRP_LVW(SQL View) |
Index Back |
|---|---|
Learning Programs and ItemsLearning Programs and Items |
| SELECT SEC1.LM_PRG_ID , SEC1.EFFDT , SEC1.LM_LRNR_GROUP_ID , PGL1.LANGUAGE_CD , GPL1.LM_LRNR_GRP_DESCR , PGL1.LM_PRG_LONG_NM , PGL1.LM_PRG_SHORT_NM , PGL1.LM_PRG_DESCR FROM PS_LM_LRNR_GROUPS GRP1 , PS_LM_GROUP_LANG GPL1 , PS_LM_PRG PRG1 , PS_LM_PRG_LANG PGL1 , PS_LM_PRG_SEC SEC1 WHERE SEC1.LM_PRG_ID = PRG1.LM_PRG_ID AND SEC1.EFFDT = PRG1.EFFDT AND SEC1.LM_LRNR_GROUP_ID = GRP1.LM_LRNR_GROUP_ID AND PRG1.LM_PRG_ID = PGL1.LM_PRG_ID AND PRG1.EFFDT = PGL1.EFFDT AND GRP1.LM_LRNR_GROUP_ID = GPL1.LM_LRNR_GROUP_ID AND PGL1.LANGUAGE_CD = GPL1.LANGUAGE_CD AND GRP1.LM_HRTALENTPOOL = 'Y' AND PRG1.LM_PRG_STATUS = '10' AND %EffdtCheck(LM_PRG X1, PRG1, %CurrentDateIn) UNION SELECT SEC2.LM_PRG_ID , SEC2.EFFDT , SEC2.LM_LRNR_GROUP_ID , GPL2.LANGUAGE_CD , GPL2.LM_LRNR_GRP_DESCR , PRG2.LM_PRG_LONG_NM , PRG2.LM_PRG_SHORT_NM , PRG2.LM_PRG_DESCR FROM PS_LM_LRNR_GROUPS GRP2 , PS_LM_GROUP_LANG GPL2 , PS_LM_PRG PRG2 , PS_LM_PRG_SEC SEC2 WHERE SEC2.LM_PRG_ID = PRG2.LM_PRG_ID AND SEC2.EFFDT = PRG2.EFFDT AND SEC2.LM_LRNR_GROUP_ID = GRP2.LM_LRNR_GROUP_ID AND GRP2.LM_LRNR_GROUP_ID = GPL2.LM_LRNR_GROUP_ID AND NOT EXISTS ( SELECT 1 FROM PS_LM_PRG_LANG PGL2 WHERE PGL2.LM_PRG_ID = PRG2.LM_PRG_ID AND PGL2.EFFDT = PRG2.EFFDT AND PGL2.LANGUAGE_CD = GPL2.LANGUAGE_CD) AND GRP2.LM_HRTALENTPOOL = 'Y' AND PRG2.LM_PRG_STATUS = '10' AND %EffdtCheck(LM_PRG X2, PRG2, %CurrentDateIn) UNION SELECT SEC3.LM_PRG_ID , SEC3.EFFDT , SEC3.LM_LRNR_GROUP_ID , PGL3.LANGUAGE_CD , GRP3.LM_LRNR_GRP_DESCR , PGL3.LM_PRG_LONG_NM , PGL3.LM_PRG_SHORT_NM , PGL3.LM_PRG_DESCR FROM PS_LM_LRNR_GROUPS GRP3 , PS_LM_PRG PRG3 , PS_LM_PRG_LANG PGL3 , PS_LM_PRG_SEC SEC3 WHERE SEC3.LM_PRG_ID = PRG3.LM_PRG_ID AND SEC3.EFFDT = PRG3.EFFDT AND SEC3.LM_LRNR_GROUP_ID = GRP3.LM_LRNR_GROUP_ID AND PRG3.LM_PRG_ID = PGL3.LM_PRG_ID AND PRG3.EFFDT = PGL3.EFFDT AND NOT EXISTS ( SELECT 1 FROM PS_LM_GROUP_LANG GPL3 WHERE GRP3.LM_LRNR_GROUP_ID = GPL3.LM_LRNR_GROUP_ID AND PGL3.LANGUAGE_CD = GPL3.LANGUAGE_CD) AND GRP3.LM_HRTALENTPOOL = 'Y' AND PRG3.LM_PRG_STATUS = '10' AND %EffdtCheck(LM_PRG X3, PRG3, %CurrentDateIn) |
| # | 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 | EFFDT |
Date(10) | DATE |
Effective Date
Default Value: %date |
| 3 | LM_LRNR_GROUP_ID |
Number(15,0) | DECIMAL(15) NOT NULL | Learner Group ID - Business Role/ Student Group ID |
| 4 | LANGUAGE_CD |
Character(3) | VARCHAR2(3) NOT NULL | Language Code |
| 5 | LM_LRNR_GRP_DESCR | Character(50) | VARCHAR2(50) NOT NULL | Learner Group Description |
| 6 | LM_PRG_LONG_NM | Character(200) | VARCHAR2(200) NOT NULL | Program Long Name |
| 7 | LM_PRG_SHORT_NM | Character(10) | VARCHAR2(10) NOT NULL | Program Short Name |
| 8 | LM_PRG_DESCR | Character(254) | VARCHAR2(254) NOT NULL | Program Description |