GPMY_TAX_ORG (SQL Table)	Index Back
Tax Reference Nbr Link Def Tax Reference numbers can be assigned to different org units. The assignment options are Location, Department, Pay Group, Company and Establishment

GPMY_TAX_ORG

(SQL Table)

Tax Reference Nbr Link Def

Tax Reference numbers can be assigned to different org units. The assignment options are Location, Department, Pay Group, Company and Establishment

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 EFFDT Date(10) DATE NOT NULL Effective Date

2 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
Prompt Table: BUSUNIT_HR_VW

3 ORG_LINK_UNIT Character(12) VARCHAR2(12) NOT NULL Contains ID of an org unit to which a source bank is assigned. can be Company, Dept, Location, Pay Group or Pay Entity ID
Prompt Table: %GP_EDIT_FLD1

4 GPMY_TAX_NBR Character(12) VARCHAR2(12) NOT NULL GPMY_TAX_NBR
Prompt Table: GPMY_TAX_TBL

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	EFFDT	Date(10)	DATE NOT NULL	Effective Date
2	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit Prompt Table: BUSUNIT_HR_VW
3	ORG_LINK_UNIT	Character(12)	VARCHAR2(12) NOT NULL	Contains ID of an org unit to which a source bank is assigned. can be Company, Dept, Location, Pay Group or Pay Entity ID Prompt Table: %GP_EDIT_FLD1
4	GPMY_TAX_NBR	Character(12)	VARCHAR2(12) NOT NULL	GPMY_TAX_NBR Prompt Table: GPMY_TAX_TBL