LM_OWNERID_VW(SQL View) |
Index Back |
---|---|
Ownerid viewA view of ownerid to prompt from |
SELECT LM_PERSON_ID , LAST_NAME , FIRST_NAME , LAST_NAME_SRCH , FIRST_NAME_SRCH , LM_NAME_DISPLAY , NAME , LM_HR_EMPLID FROM PS_LM_PERS_NAME_VW |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | LM_OWNER_ID | Number(15,0) | DECIMAL(15) NOT NULL | Owner ID |
2 | LAST_NAME | Character(30) | VARCHAR2(30) NOT NULL | Last Name Field |
3 | FIRST_NAME | Character(30) | VARCHAR2(30) NOT NULL | First Name field |
4 | LAST_NAME_SRCH | Character(30) | VARCHAR2(30) NOT NULL | Last Name |
5 | FIRST_NAME_SRCH | Character(30) | VARCHAR2(30) NOT NULL | First Name |
6 | LM_NAME_DISPLAY | Character(50) | VARCHAR2(50) NOT NULL | Name Display field |
7 | NAME | Character(50) | VARCHAR2(50) NOT NULL | Name |
8 | LM_HR_EMPLID | Character(11) | VARCHAR2(11) NOT NULL | EMPLID from the HR System |