GPTH_SSO2_TMP

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
2	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
3	EFFDT	Date(10)	DATE	Effective Date Default Value: %date
4	COMPANY	Character(3)	VARCHAR2(3) NOT NULL	Company
5	ACTION	Character(3)	VARCHAR2(3) NOT NULL	Action
6	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description
7	NAME_PREFIX	Character(4)	VARCHAR2(4) NOT NULL	Name Prefix
8	DESCRSHORT	Character(10)	VARCHAR2(10) NOT NULL	Short Description
9	GPTH_NAME1	Character(80)	VARCHAR2(80) NOT NULL	Tax-Payee's First Name
10	LAST_NAME	Character(30)	VARCHAR2(30) NOT NULL	Last Name
11	FIRST_NAME	Character(30)	VARCHAR2(30) NOT NULL	First Name
12	NATIONAL_ID	Character(20)	VARCHAR2(20) NOT NULL	National ID
13	GPTH_SI_ER_ACCT	Character(10)	VARCHAR2(10) NOT NULL	GPTH_SI_ER_ACCT
14	GPTH_SI_EE_ACCT	Character(20)	VARCHAR2(20) NOT NULL	Payee Social Security Number
15	GPTH_SI_BRANCH_NO	Character(6)	VARCHAR2(6) NOT NULL	Social Security Branch Number
16	GPTH_SI_BRANCH_NM	Character(50)	VARCHAR2(50) NOT NULL	Social Security Branch Name
17	GPTH_SI_BRANCH_NO2	Character(6)	VARCHAR2(6) NOT NULL	Social Security Branch Number
18	GPTH_SI_FLAG	Character(1)	VARCHAR2(1) NOT NULL	No work before/No SS Number flag Default Value: N
19	COUNTRY	Character(3)	VARCHAR2(3) NOT NULL	Country
20	ADDRESS1	Character(55)	VARCHAR2(55) NOT NULL	Address 1
21	ADDRESS2	Character(55)	VARCHAR2(55) NOT NULL	Address 2
22	ADDRESS3	Character(55)	VARCHAR2(55) NOT NULL	Address 3
23	ADDRESS4	Character(55)	VARCHAR2(55) NOT NULL	Address 4
24	CITY	Character(30)	VARCHAR2(30) NOT NULL	City
25	STATE	Character(6)	VARCHAR2(6) NOT NULL	State
26	DESCR1	Character(30)	VARCHAR2(30) NOT NULL	Descr
27	POSTAL	Character(12)	VARCHAR2(12) NOT NULL	Postal
28	COUNTY	Character(30)	VARCHAR2(30) NOT NULL	County
29	PHONE	Character(24)	VARCHAR2(24) NOT NULL	Telephone
30	LAST_DATE_WORKED	Date(10)	DATE	Last Date Worked
31	DT_OF_DEATH	Date(10)	DATE	Date of Death
32	ACTION_REASON	Character(3)	VARCHAR2(3) NOT NULL	Reason Code
33	GPTH_TER_RSN	Character(3)	VARCHAR2(3) NOT NULL	Termination Reason for mapping 1=1-Resignation 2=2-Contract Expiry 3=3-Termination 4=4-Retirement 5=5-Fried 6=6-Death 7=7-Branch Transfer
34	GPTH_SI_BRANCH_AP	Character(40)	VARCHAR2(40) NOT NULL	This field will be used to store social security area/province information.
35	TERMINATION_DT	Date(10)	DATE	Termination Date
36	BIRTHDATE	Date(10)	DATE	Date of Birth