SALUTATION_TYPESALU_USAGEBLO=Address Block Name
SAL=Salutation Name
Default Value: SAL
EFFDTDefault Value: %date
NAME_ORDERPrompt Table: HCR_NM_TYP_I
F=First
L=Last
M=Middle
T=Title
U=Full
NAME2_ORDER_TBL(SQL Table) |
Index Back |
|---|---|
2nd name orders for salu setup |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | SALUTATION_TYPE |
Character(3) | VARCHAR2(3) NOT NULL | Salutation Type |
| 2 | SALU_USAGE |
Character(3) | VARCHAR2(3) NOT NULL |
Salutation Type Usage
BLO=Address Block Name SAL=Salutation Name Default Value: SAL |
| 3 | EFFDT |
Date(10) | DATE NOT NULL |
Effective Date
Default Value: %date |
| 4 | NAME_ORDER |
Number(4,0) | SMALLINT NOT NULL | Name Order |
| 5 | NAME_TYPE | Character(3) | VARCHAR2(3) NOT NULL |
Type of Name
Prompt Table: HCR_NM_TYP_I |
| 6 | NAME_PART | Character(1) | VARCHAR2(1) NOT NULL |
Part of Name
F=First L=Last M=Middle T=Title U=Full |