GPJP_TAX_ESTAB

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	GPJP_TAX_ESTAB	Character(15)	VARCHAR2(15) NOT NULL	Salary Payer Reference Number
2	GPJP_TAX_ESTAB_TYP	Character(2)	VARCHAR2(2) NOT NULL	Tax Establishment Type. IT=Tax Establishment LA=Labor Ins Establishment SC=Social Ins Establishment
3	EFFDT	Date(10)	DATE NOT NULL	Effective Date Default Value: %date
4	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description
5	DESCRSHORT	Character(10)	VARCHAR2(10) NOT NULL	Short Description
6	GPJP_NAME	Character(50)	VARCHAR2(50) NOT NULL	Free format Name field
7	GPJP_TITLE	Character(50)	VARCHAR2(50) NOT NULL	Title of Owner
8	GPJP_SC_ESTAB_REF1	Character(10)	VARCHAR2(10) NOT NULL	Establishment Reference Number.
9	GPJP_SC_ESTAB_REF2	Character(10)	VARCHAR2(10) NOT NULL	Establishment Reference Number 2.
10	GPJP_SC_ESTAB_NO	Character(12)	VARCHAR2(12) NOT NULL	Social Insurance Establishment Number.
11	GPJP_LA_IND_TYPE	Character(2)	VARCHAR2(2) NOT NULL	Industry Type 10=Industry Type A 20=Industry Type B 30=Industry Type B - Construction
12	GPJP_CALC_METHOD	Character(2)	VARCHAR2(2) NOT NULL	Calculation Method. 10=Computerized Method 20=Table Lookup Default Value: 10
13	COUNTRY	Character(3)	VARCHAR2(3) NOT NULL	Country Prompt Table: COUNTRY_TBL
14	ADDRESS1	Character(55)	VARCHAR2(55) NOT NULL	Address 1
15	ADDRESS2	Character(55)	VARCHAR2(55) NOT NULL	Address 2
16	ADDRESS3	Character(55)	VARCHAR2(55) NOT NULL	Address 3
17	ADDRESS4	Character(55)	VARCHAR2(55) NOT NULL	Address 4
18	CITY	Character(30)	VARCHAR2(30) NOT NULL	City
19	NUM1	Character(6)	VARCHAR2(6) NOT NULL	Number 1
20	NUM2	Character(6)	VARCHAR2(6) NOT NULL	Number 2
21	HOUSE_TYPE	Character(2)	VARCHAR2(2) NOT NULL	House Type AB=House Boat Reference WW=House Trailer Reference
22	ADDR_FIELD1	Character(2)	VARCHAR2(2) NOT NULL	Address Field 1
23	ADDR_FIELD2	Character(4)	VARCHAR2(4) NOT NULL	Address Field 2
24	ADDR_FIELD3	Character(4)	VARCHAR2(4) NOT NULL	Address Field 3
25	COUNTY	Character(30)	VARCHAR2(30) NOT NULL	County
26	STATE	Character(6)	VARCHAR2(6) NOT NULL	State Prompt Table: STATE_TBL
27	POSTAL	Character(12)	VARCHAR2(12) NOT NULL	Postal
28	GEO_CODE	Character(11)	VARCHAR2(11) NOT NULL	Geo Code
29	IN_CITY_LIMIT	Character(1)	VARCHAR2(1) NOT NULL	In City Limit Y/N Table Edit
30	COUNTRY_CODE	Character(3)	VARCHAR2(3) NOT NULL	Country Code
31	PHONE	Character(24)	VARCHAR2(24) NOT NULL	Telephone
32	GPJP_LA_ESTAB_NO	Character(13)	VARCHAR2(13) NOT NULL	Unemployment Cert.
33	GPJP_COMP_INS_RT	Number(8,5)	DECIMAL(7,5) NOT NULL	Workers Compensation Insurance Rate
34	GPJP_SC_ESTAB2	Character(5)	VARCHAR2(5) NOT NULL	Establishment Number
35	GPJP_GVT_MANAGED	Character(1)	VARCHAR2(1) NOT NULL	Government Managed Default Value: N
36	GPJP_PENS_FUND_FLG	Character(1)	VARCHAR2(1) NOT NULL	Employee's Pension Fund Default Value: N
37	GPJP_SC_ROUND	Character(1)	VARCHAR2(1) NOT NULL	Round Up if >= 0.501 Y/N Table Edit Default Value: N
38	GPJP_YEA_TERM_DEC	Character(1)	VARCHAR2(1) NOT NULL	YEA Flag for Employees who are Terminated in December Y/N Table Edit Default Value: N
39	GPJP_YEA_ADD_PRIOR	Character(1)	VARCHAR2(1) NOT NULL	Add Prior Employment Details Y/N Table Edit Default Value: Y
40	GPJP_YEA_PRINT_INS	Character(1)	VARCHAR2(1) NOT NULL	Print Insurance Details Y/N Table Edit Default Value: Y
41	GPJP_ESTAB_NM_AC	Character(40)	VARCHAR2(40) NOT NULL	Used in Inhabitant Tax File creation process.
42	GPJP_ESTAB_LCN_AC	Character(50)	VARCHAR2(50) NOT NULL	Used in Inhabitant Tax File creation process.
43	GPJP_TAX_REF_NO1	Character(10)	VARCHAR2(10) NOT NULL	Tax Reference number 1
44	GPJP_TAX_REF_NO2	Character(10)	VARCHAR2(10) NOT NULL	Tax Reference number 2
45	FIRM_NUM_JPN	Number(13,0)	DECIMAL(13) NOT NULL	This field stores the Corporate Number of Japan Tax Establishments, SI establishments and LI establishments.
46	GPJP_PREFECTURE_CD	Character(2)	VARCHAR2(2) NOT NULL	Prefecture Code
47	GPJP_RECEIVER	Character(12)	VARCHAR2(12) NOT NULL	Name of Public Employment Agency