EMPLIDPrompt Table: PERSON
Prompt Table: %EDITTABLE
CM_EMPL_SRCH_VW(SQL View) |
Index Back |
|---|---|
Employee prompt view |
| SELECT B.EMPLID , B.NAME , B.NAME_AC , A.DESCR , A.JPM_JP_TYPE FROM PS_PERSON_NAME B ,PS_JPM_PROFILE A WHERE A.EMPLID = B.EMPLID AND A.JPM_JP_PRFL_STATUS = 'A' AND A.JPM_PROFILE_USAGE='P' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | EMPLID |
Character(11) | VARCHAR2(11) NOT NULL |
Employee ID
Prompt Table: PERSON |
| 2 | NAME | Character(50) | VARCHAR2(50) NOT NULL | Name |
| 3 | NAME_AC | Character(50) | VARCHAR2(50) NOT NULL | Alternate Character Name |
| 4 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 5 | JPM_JP_TYPE | Character(12) | VARCHAR2(12) NOT NULL |
Profile Type name for a JPM Profile Type
Prompt Table: %EDITTABLE |