SCC_NAMES_QVW - Person Names Query View

peoplesoft campus-solutions campus-solutions-reporting

SCC_NAMES_QVW is a version of the Names tables delivered by PeopleSoft for use in Campus Solutions Queries

Detailed Information

PeopleSoft Campus Solutions - CSPRD
PeopleSoft Campus Solutions Reporting - CSRPT

Key	Record.Fieldname	Format	XLAT	Heading Text
	COUNTRY_NM_FORMAT - Format Using	Char3		Use
Key	EFFDT - Effective Date	Date		Eff Date
	EFF_STATUS - Status as of Effective Date	Char1	N	Status
Key	EMPLID - Empl ID	Char11		ID
	FIRST_NAME - First Name	Char30		First Name
	FIRST_NAME_SRCH - First Name	Char30		First Name
	LAST_NAME - Last Name	Char30		Last
	LAST_NAME_PREF_NLD - Last Name Preference	Char1	N	Preference
	LAST_NAME_SRCH - Last Name	Char30		Last
	MIDDLE_NAME - Middle Name	Char30		Middle
	NAME - Name	Char50		Name
	NAME_AC - Alternate Character Name	Char50		AC Name
	NAME_DISPLAY - Display Name	Char50		Display Name
	NAME_FORMAL - Formal Name	Char60		Formal Name
	NAME_INITIALS - Name Initials	Char6		Initials
	NAME_PREFIX - Name Prefix	Char4		Prefix
	NAME_ROYAL_PREFIX - Name Royal Prefix	Char15		Royal Prefix
	NAME_ROYAL_SUFFIX - Name Royal Suffix	Char15		Royal Suffix
	NAME_SUFFIX - Name Suffix	Char15		Suffix
	NAME_TITLE - Title	Char30		Title
Key	NAME_TYPE - Type of Name	Char3		Name Type
	PARTNER_LAST_NAME - Last Name Partner	Char30		Last Name
	PARTNER_ROY_PREFIX - Prefix Partner	Char15		Prefix
	PREF_FIRST_NAME - Preferred First Name	Char30		Preferred First
	SECOND_LAST_NAME - Second Last Name	Char30		Second Last
	SECOND_LAST_SRCH - Second Name	Char30		Second Name

0 reviews