LM_GROUPPRSN_VW

(SQL View)
 Index Back

Group Person Name View

Group Person Name View

SELECT LG.LM_LRNR_GROUP_ID ,A.LM_PERSON_ID ,LG.LM_LRNR_GRP_DESCR ,B.FIRST_NAME ,B.LAST_NAME ,B.NAME ,B.LM_NAME_DISPLAY ,A.LM_HR_EMPLID FROM PS_LM_LRNR_GROUPS LG , PS_LM_GROUP_PERSON GP , PS_LM_PERSON A , PS_LM_PERSON_NAME B WHERE LG.LM_LRNR_GROUP_ID = GP.LM_LRNR_GROUP_ID AND GP.LM_PERSON_ID = A.LM_PERSON_ID AND LG.LM_ACTIVE='Y' AND B.LM_PERSON_ID = A.LM_PERSON_ID AND B.LM_DISPLAY_FLAG = 'Y' AND ((B.LM_NAME_TYPE = 'PRF') OR (B.LM_NAME_TYPE = 'PRI' AND NOT EXISTS ( SELECT LM_NAME_TYPE FROM PS_LM_PERSON_NAME WHERE LM_PERSON_ID = B.LM_PERSON_ID AND LM_NAME_TYPE = 'PRF' AND %CurrentDateIn BETWEEN EFFDT AND LM_END_EFFDT))) AND B.EFFDT <= %CurrentDateIn AND B.LM_END_EFFDT >= %CurrentDateIn

  • Related Language Record: LM_GRPPRSN_LVW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 LM_LRNR_GROUP_ID Number(15,0) DECIMAL(15) NOT NULL Learner Group ID - Business Role/ Student Group ID
    2 LM_PERSON_ID Number(15,0) DECIMAL(15) NOT NULL ELM Person ID

    Prompt Table: LM_PERS_NAME_VW

    3 LM_LRNR_GRP_DESCR Character(50) VARCHAR2(50) NOT NULL Learner Group Description

    Prompt Table: LM_LRNR_GROUPS

    4 FIRST_NAME Character(30) VARCHAR2(30) NOT NULL First Name field
    5 LAST_NAME Character(30) VARCHAR2(30) NOT NULL Last Name Field
    6 NAME Character(50) VARCHAR2(50) NOT NULL Name
    7 LM_NAME_DISPLAY Character(50) VARCHAR2(50) NOT NULL Name Display field
    8 LM_HR_EMPLID Character(11) VARCHAR2(11) NOT NULL EMPLID from the HR System