LM_LRNR_GROUP_IDLM_PERSON_IDLANGUAGE_CDLM_GRPPRSN_LVW(SQL View) |
Index Back |
|---|
| SELECT LG.LM_LRNR_GROUP_ID , P.LM_PERSON_ID , GL.LANGUAGE_CD , P.FIRST_NAME , P.LAST_NAME , P.NAME , P.LM_NAME_DISPLAY , P.LM_HR_EMPLID FROM PS_LM_LRNR_GROUPS LG , PS_LM_GROUP_LANG GL , PS_LM_GROUP_PERSON GP , PS_LM_PERS_NAME_VW P WHERE LG.LM_LRNR_GROUP_ID = GL.LM_LRNR_GROUP_ID AND LG.LM_ACTIVE='Y' AND LG.LM_LRNR_GROUP_ID = GP.LM_LRNR_GROUP_ID AND GP.LM_PERSON_ID = P.LM_PERSON_ID |
| # | 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 |
| 3 | LANGUAGE_CD |
Character(3) | VARCHAR2(3) NOT NULL | Language Code |
| 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 |