LM_PERSON_IDPrompt Table: COUNTRY_TBL
LM_CT_NAME_VW4(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.LM_NAME_DISPLAY , 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 FROM PS_LM_PERSON A , PS_LM_PERSON_NAME B ,PS_LM_PERSON_ATTRB 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 C.LM_EMPL_RCD = ( SELECT MIN(C1.LM_EMPL_RCD) FROM PS_LM_PERSON_ATTRB C1 WHERE C1.LM_PERSON_ID = C.LM_PERSON_ID AND C1.EFFDT = C.EFFDT) |
| # | 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 | LM_NAME_DISPLAY | Character(50) | VARCHAR2(50) NOT NULL | Name Display field |
| 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_HR_EMPLID | Character(11) | VARCHAR2(11) NOT NULL | EMPLID from the HR System |
| 14 | LM_LE_ID | Number(10,0) | DECIMAL(10) NOT NULL | Learning Environment ID - System Generated number |
| 15 | COUNTRY_NM_FORMAT | Character(3) | VARCHAR2(3) NOT NULL |
Format for Country
Prompt Table: COUNTRY_TBL |
| 16 | NAME_AC | Character(50) | VARCHAR2(50) NOT NULL | Name |