LM_HR_EMPLIDPrompt Table: COUNTRY_TBL
LM_HREMPL_NM_VW(SQL View) |
Index Back |
|---|---|
Person NamesPerson Name view with HR Emplid as alternate key. |
| SELECT A.LM_HR_EMPLID ,A.LM_PERSON_ID , B.LM_NAME_TYPE , B.NAME , B.NAME_PREFIX , B.NAME_SUFFIX , B.LAST_NAME_SRCH , B.FIRST_NAME_SRCH , B.LAST_NAME , B.FIRST_NAME , B.MIDDLE_NAME , A.LM_EXT_PERSON_FLG , C.LM_LE_ID , B.COUNTRY_NM_FORMAT , B.LM_NAME_DISPLAY FROM PS_LM_PERSON A , PS_LM_PERSON_NAME B , PS_LM_CURR_JOB_VW C WHERE B.LM_PERSON_ID = A.LM_PERSON_ID AND B.LM_DISPLAY_FLAG = 'Y' AND %CurrentDateIn BETWEEN B.EFFDT AND B.LM_END_EFFDT AND C.LM_PERSON_ID = A.LM_PERSON_ID AND (LM_HR_EMPLID <> ' ' AND LM_HR_EMPLID IS NOT NULL) |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | LM_HR_EMPLID |
Character(11) | VARCHAR2(11) NOT NULL | EMPLID from the HR System |
| 2 | LM_PERSON_ID | Number(15,0) | DECIMAL(15) NOT NULL | ELM Person ID |
| 3 | LM_NAME_TYPE | Character(3) | VARCHAR2(3) NOT NULL | Name Type |
| 4 | NAME | Character(50) | VARCHAR2(50) NOT NULL | Name |
| 5 | NAME_PREFIX | Character(4) | VARCHAR2(4) NOT NULL | Name Prefix |
| 6 | NAME_SUFFIX | Character(15) | VARCHAR2(15) NOT NULL | Name Suffix |
| 7 | LAST_NAME_SRCH | Character(30) | VARCHAR2(30) NOT NULL | Last Name |
| 8 | FIRST_NAME_SRCH | Character(30) | VARCHAR2(30) NOT NULL | First Name |
| 9 | LAST_NAME | Character(30) | VARCHAR2(30) NOT NULL | Last Name Field |
| 10 | FIRST_NAME | Character(30) | VARCHAR2(30) NOT NULL | First Name field |
| 11 | MIDDLE_NAME | Character(30) | VARCHAR2(30) NOT NULL | Middle Name |
| 12 | LM_EXT_PERSON_FLG | Character(1) | VARCHAR2(1) NOT NULL | External Person Flag |
| 13 | LM_LE_ID | Number(10,0) | DECIMAL(10) NOT NULL | Learning Environment ID - System Generated number |
| 14 | COUNTRY_NM_FORMAT | Character(3) | VARCHAR2(3) NOT NULL |
Format for Country
Prompt Table: COUNTRY_TBL |
| 15 | LM_NAME_DISPLAY | Character(50) | VARCHAR2(50) NOT NULL | Name Display field |