NAME_USAGEPrompt Table: NAME_USAGE_TBL
NAME_USAGE_ORDERPrompt Table: %EDITTABLE
F=First
L=Last
M=Middle
T=Title
U=Full
NAME_ORDER_TBL(SQL Table) |
Index Back |
|---|---|
Name Order TableNAME_ORDER_TBL indicates the order in which the selection of an individual's names is to occur. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | NAME_USAGE |
Character(10) | VARCHAR2(10) NOT NULL |
Name Usage
Prompt Table: NAME_USAGE_TBL |
| 2 | NAME_USAGE_ORDER |
Number(4,0) | SMALLINT NOT NULL | Name Usage Order |
| 3 | NAME_TYPE | Character(3) | VARCHAR2(3) NOT NULL |
Type of Name
Prompt Table: %EDITTABLE |
| 4 | NAME_PART | Character(1) | VARCHAR2(1) NOT NULL |
Part of Name
F=First L=Last M=Middle T=Title U=Full |