LM_PRG_GRP_VW

(SQL View)
 Index Back

Learning Programs and Items

Learning Programs and Items

SELECT A.LM_PRG_ID , B.EFFDT , A.LM_LRNR_GROUP_ID , C.LM_LRNR_GRP_DESCR , B.LM_END_EFFDT , B.LM_PRG_STATUS , B.LM_PRG_TYPE , B.LM_PRG_CD , B.LM_VERSION , B.LM_PRG_LONG_NM , B.LM_PRG_SHORT_NM , B.LM_PRG_DESCR FROM PS_LM_PRG_SEC A ,PS_LM_PRG B ,PS_LM_LRNR_GROUPS C WHERE B.LM_PRG_STATUS = '10' AND A.LM_PRG_ID = B.LM_PRG_ID AND A.LM_LRNR_GROUP_ID = C.LM_LRNR_GROUP_ID AND C.LM_HRTALENTPOOL = 'Y' AND %EffdtCheck(LM_PRG B, A, %currentdatein)

  • Related Language Record: LM_PRG_GRP_LVW

    • # 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 LM_LRNR_GRP_DESCR Character(50) VARCHAR2(50) NOT NULL Learner Group Description
    5 LM_END_EFFDT Date(10) DATE The end effective date, automatically maintained, there's a doc on how this works, so read it
    6 LM_PRG_STATUS Character(2) VARCHAR2(2) NOT NULL Program Status
    10=Active
    20=Inactive
    30=Pending
    7 LM_PRG_TYPE Character(2) VARCHAR2(2) NOT NULL Program Type
    CE=Certification
    CU=Curriculum
    8 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.
    9 LM_VERSION Character(30) VARCHAR2(30) NOT NULL Program Version
    10 LM_PRG_LONG_NM Character(200) VARCHAR2(200) NOT NULL Program Long Name
    11 LM_PRG_SHORT_NM Character(10) VARCHAR2(10) NOT NULL Program Short Name
    12 LM_PRG_DESCR Character(254) VARCHAR2(254) NOT NULL Program Description