SAE_TARGET_IDSAE_PRSN_DEF_FLAGD=Default
U=User Defined
Default Value: U
SAE_LIS_NAME_TYPEALIA=Alias
CONT=Contact
FORM=Former
FULL=Full
MAID=Maiden
PREF=Preferred
NAME_TYPEPrompt Table: NAME_TYPE_TBL
SAE_LIS_NAMEMAP(SQL Table) |
Index Back |
|---|
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | SAE_TARGET_ID |
Character(50) | VARCHAR2(50) NOT NULL | SAIP Target ID |
| 2 | SAE_PRSN_DEF_FLAG |
Character(4) | VARCHAR2(4) NOT NULL |
Default Flag
D=Default U=User Defined Default Value: U |
| 3 | SAE_LIS_NAME_TYPE |
Character(4) | VARCHAR2(4) NOT NULL |
LIS Name Type
ALIA=Alias CONT=Contact FORM=Former FULL=Full MAID=Maiden PREF=Preferred |
| 4 | NAME_TYPE |
Character(3) | VARCHAR2(3) NOT NULL |
Type of Name
Prompt Table: NAME_TYPE_TBL |