SCC_LONG_NAMES

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID Prompt Table: PERSON
2	NAME_TYPE	Character(3)	VARCHAR2(3) NOT NULL	Type of Name Prompt Table: NAME_TYPE_TBL
3	EFFDT	Date(10)	DATE NOT NULL	Effective Date Default Value: %date
4	LONG_INITIALS	Character(15)	VARCHAR2(15) NOT NULL	Long Initials
5	LONG_PREFIX	Character(50)	VARCHAR2(50) NOT NULL	Long Prefix
6	LONG_FIRST_NAME	Character(150)	VARCHAR2(150) NOT NULL	Long First Name
7	LONG_MIDDLE_NAME	Character(100)	VARCHAR2(100) NOT NULL	Long Middle Name
8	LONG_LAST_NAME	Character(150)	VARCHAR2(150) NOT NULL	Long Last Name
9	LONG_SUFFIX	Character(50)	VARCHAR2(50) NOT NULL	Long Suffix
10	LONG_FULL_NAME	Long Character(450)	VARCHAR2(450)	Long Full Name