GPCH_NNSS_AET

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
2	OPRID	Character(30)	VARCHAR2(30) NOT NULL	A user's ID (see PSOPRDEFN).
3	RUN_CNTL_ID	Character(30)	VARCHAR2(30) NOT NULL	Run Control ID
4	GPCH_FILENAME	Character(30)	VARCHAR2(30) NOT NULL	Load Source Tax Rates
5	GPCH_DIRECTORY	Character(100)	VARCHAR2(100) NOT NULL	Load Source Tax Rates
6	GPCH_TX_RATES_SW	Character(1)	VARCHAR2(1) NOT NULL	Load Source Tax Rates Y/N Table Edit
7	GPCH_OLD_SSN	Character(20)	VARCHAR2(20) NOT NULL	Old social security number. Used in process GPCH_AH_LOAD
8	GPCH_NEW_SSN	Character(20)	VARCHAR2(20) NOT NULL	Old social security number. Used in process GPCH_AH_LOAD
9	BIRTHDATE	Date(10)	DATE	Date of Birth
10	LAST_NAME_SRCH	Character(30)	VARCHAR2(30) NOT NULL	Last Name
11	FIRST_NAME_SRCH	Character(30)	VARCHAR2(30) NOT NULL	First Name
12	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
13	EMPLID_NEW	Character(11)	VARCHAR2(11) NOT NULL	ID
14	EMPLID_OLD	Character(11)	VARCHAR2(11) NOT NULL	Previous Employee ID
15	SEX	Character(1)	VARCHAR2(1) NOT NULL	Gender F=Female M=Male U=Unknown
16	NAME	Character(50)	VARCHAR2(50) NOT NULL	Name