EMPLIDPrompt Table: PERSON
ORDER_BY_SEQNAME_TYPEPrompt Table: NAME_TYPE_TBL
NAME_TYPE_VW(SQL View) |
Index Back |
|---|---|
Employee Name TypesNAME_TYPE_VW is a view of NAMES that allows for a level 1 scroll that controls the NAME_TYPES. |
| SELECT DISTINCT A.EMPLID ,B.ORDER_BY_SEQ ,A.NAME_TYPE FROM PS_NAMES A , PS_NAME_TYPE_TBL B WHERE A.NAME_TYPE = B.NAME_TYPE |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | EMPLID |
Character(11) | VARCHAR2(11) NOT NULL |
Employee ID
Prompt Table: PERSON |
| 2 | ORDER_BY_SEQ |
Number(2,0) | SMALLINT NOT NULL | Order by Sequence |
| 3 | NAME_TYPE |
Character(3) | VARCHAR2(3) NOT NULL |
Type of Name
Prompt Table: NAME_TYPE_TBL |