LM_PERSON_IDPrompt Table: COUNTRY_TBL
LM_PERSNMFUT_VW(SQL View) |
Index Back |
|---|---|
Person NamesContains a Person's name for the lowest sequence name type |
| SELECT 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 , A.LM_HR_EMPLID , C.LM_LE_ID , B.COUNTRY_NM_FORMAT , B.NAME_AC , 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 (B.EFFDT = ( SELECT MAX(D.EFFDT) FROM PS_LM_PERSON_NAME D WHERE D.LM_PERSON_ID = B.LM_PERSON_ID AND D.LM_NAME_TYPE = B.LM_NAME_TYPE AND D.EFFDT <= %CurrentDateIn AND EXISTS ( SELECT D1.EFFDT FROM PS_LM_PERSON_NAME D1 WHERE D1.LM_PERSON_ID = B.LM_PERSON_ID AND D1.LM_NAME_TYPE = B.LM_NAME_TYPE AND D1.EFFDT <= %CurrentDateIn)) OR B.EFFDT = ( SELECT MIN(E.EFFDT) FROM PS_LM_PERSON_NAME E WHERE E.LM_PERSON_ID = B.LM_PERSON_ID AND E.LM_NAME_TYPE = B.LM_NAME_TYPE AND E.EFFDT > %CurrentDateIn AND NOT EXISTS ( SELECT E1.EFFDT FROM PS_LM_PERSON_NAME E1 WHERE E1.LM_PERSON_ID = B.LM_PERSON_ID AND E1.LM_NAME_TYPE = B.LM_NAME_TYPE AND E1.EFFDT <= %CurrentDateIn))) AND C.LM_PERSON_ID = A.LM_PERSON_ID 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'))) |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | LM_PERSON_ID |
Number(15,0) | DECIMAL(15) NOT NULL | ELM Person ID |
| 2 | LM_NAME_TYPE | Character(3) | VARCHAR2(3) NOT NULL | Name Type |
| 3 | NAME | Character(50) | VARCHAR2(50) NOT NULL | Name |
| 4 | NAME_PREFIX | Character(4) | VARCHAR2(4) NOT NULL | Name Prefix |
| 5 | NAME_SUFFIX | Character(15) | VARCHAR2(15) NOT NULL | Name Suffix |
| 6 | LAST_NAME_SRCH | Character(30) | VARCHAR2(30) NOT NULL | Last Name |
| 7 | FIRST_NAME_SRCH | Character(30) | VARCHAR2(30) NOT NULL | First Name |
| 8 | LAST_NAME | Character(30) | VARCHAR2(30) NOT NULL | Last Name Field |
| 9 | FIRST_NAME | Character(30) | VARCHAR2(30) NOT NULL | First Name field |
| 10 | MIDDLE_NAME | Character(30) | VARCHAR2(30) NOT NULL | Middle Name |
| 11 | LM_EXT_PERSON_FLG | Character(1) | VARCHAR2(1) NOT NULL | External Person Flag |
| 12 | LM_HR_EMPLID | Character(11) | VARCHAR2(11) NOT NULL | EMPLID from the HR System |
| 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 | NAME_AC | Character(50) | VARCHAR2(50) NOT NULL | Name |
| 16 | LM_NAME_DISPLAY | Character(50) | VARCHAR2(50) NOT NULL | Name Display field |