Names and preferred names
Notes will go here. Call with PS_SCC_NAMES_QVW
- Emplid [VARCHAR2 (11)]
- Name_Type [VARCHAR2 (3)]: Use this to determine preferred name with max(EFFDT) in the SELECT statement or row_number() method
- PRF for preferred name
- EFFDT [DATE]
- EFF_Status [VARCHAR2 (1)]
- Country_NM_Format [VARCHAR2 (3)]
- Name [VARCHAR2 (50)]
- Name_Initials [VARCHAR2 (6)]
- Name_Prefix [VARCHAR2 (4)]
- Name_Suffix [VARCHAR2 (15)]
- Name_Royal_Prefix [VARCHAR2 (15)]
- Name_Royal_Suffix [VARCHAR2 (15)]
- Name_Title [VARCHAR2 (30)]
- Last_Name_SRCH [VARCHAR2 (30)]
- First_Name_SRCH [VARCHAR2 (30)]
- Last_Name [VARCHAR2 (30)]
- First_Name [VARCHAR2 (30)]
- Middle_Name [VARCHAR2 (30)]
- Second_Last_Name [VARCHAR2 (30)]
- Second_Last_SRCH [VARCHAR2 (30)]
- Name_AC [VARCHAR2 (30)]
- Pref_First_Name [VARCHAR2 (30)]
- Partner_Last_Name [VARCHAR2 (30)]
- Partner_ROY_Prefix [VARCHAR2 (15)]
- Last_Name_Pref_NLD [VARCHAR2 (1)]
- Display_Name [VARCHAR2 (50)]
- Name_Formal [VARCHAR2 (60)]: Legal name usage only