GPTH_SI_BRANCH

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	COMPANY	Character(3)	VARCHAR2(3) NOT NULL	Company Prompt Table: COMPANY_TBL
2	EFFDT	Date(10)	DATE NOT NULL	Effective Date Default Value: %date
3	GPTH_SI_BRANCH_NO	Character(6)	VARCHAR2(6) NOT NULL	Social Security Branch Number
4	GPTH_SI_BRANCH_NM	Character(50)	VARCHAR2(50) NOT NULL	Social Security Branch Name
5	COUNTRY	Character(3)	VARCHAR2(3) NOT NULL	Country Prompt Table: COUNTRY_TBL
6	ADDRESS1	Character(55)	VARCHAR2(55) NOT NULL	Address 1
7	ADDRESS2	Character(55)	VARCHAR2(55) NOT NULL	Address 2
8	ADDRESS3	Character(55)	VARCHAR2(55) NOT NULL	Address 3
9	ADDRESS4	Character(55)	VARCHAR2(55) NOT NULL	Address 4
10	CITY	Character(30)	VARCHAR2(30) NOT NULL	City
11	NUM1	Character(6)	VARCHAR2(6) NOT NULL	Number 1
12	NUM2	Character(6)	VARCHAR2(6) NOT NULL	Number 2
13	HOUSE_TYPE	Character(2)	VARCHAR2(2) NOT NULL	House Type AB=House Boat Reference WW=House Trailer Reference
14	ADDR_FIELD1	Character(2)	VARCHAR2(2) NOT NULL	Address Field 1
15	ADDR_FIELD2	Character(4)	VARCHAR2(4) NOT NULL	Address Field 2
16	ADDR_FIELD3	Character(4)	VARCHAR2(4) NOT NULL	Address Field 3
17	COUNTY	Character(30)	VARCHAR2(30) NOT NULL	County
18	STATE	Character(6)	VARCHAR2(6) NOT NULL	State Prompt Table: STATE_TBL
19	POSTAL	Character(12)	VARCHAR2(12) NOT NULL	Postal
20	GEO_CODE	Character(11)	VARCHAR2(11) NOT NULL	Geo Code
21	IN_CITY_LIMIT	Character(1)	VARCHAR2(1) NOT NULL	In City Limit Y/N Table Edit
22	COUNTRY_CODE	Character(3)	VARCHAR2(3) NOT NULL	Country Code
23	PHONE	Character(24)	VARCHAR2(24) NOT NULL	Telephone
24	EXTENSION	Character(6)	VARCHAR2(6) NOT NULL	Phone number extension
25	FAX	Character(24)	VARCHAR2(24) NOT NULL	Fax Number
26	GPTH_SI_BRANCH_AP	Character(40)	VARCHAR2(40) NOT NULL	This field will be used to store social security area/province information.