GPCH_NNSS_LOG

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
2	GPCH_OLD_SSN	Character(20)	VARCHAR2(20) NOT NULL	Old social security number. Used in process GPCH_AH_LOAD
3	FILENAME	Character(80)	VARCHAR2(80) NOT NULL	File Name
4	GPCH_NEW_SSN	Character(20)	VARCHAR2(20) NOT NULL	Old social security number. Used in process GPCH_AH_LOAD
5	NAME	Character(50)	VARCHAR2(50) NOT NULL	Name
6	SEX	Character(1)	VARCHAR2(1) NOT NULL	Gender F=Female M=Male U=Unknown X=Indeterminate/Intersex/Unspec
7	BIRTHDATE	Date(10)	DATE	Date of Birth
8	GPCH_SSNN_MODE	Character(1)	VARCHAR2(1) NOT NULL	Load social security number process - GPCH_AH_LOAD Run mode: Y = insert in PERS_NID N = test mode Y/N Table Edit
9	GPCH_SSNN_ST	Character(3)	VARCHAR2(3) NOT NULL	Load social security number process - GPCH_AH_LOAD Status
10	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
11	NATIONAL_ID	Character(20)	VARCHAR2(20) NOT NULL	National ID
12	GPCH_SI_KTG_MBR_ID	Character(20)	VARCHAR2(20) NOT NULL	Health Insurance ID
13	NAME_AC	Character(50)	VARCHAR2(50) NOT NULL	Alternate Character Name
14	SEX_ALL	Character(1)	VARCHAR2(1) NOT NULL	All Genders
15	BIRTHDATE_C	Character(10)	VARCHAR2(10) NOT NULL	Birthdate C