GPMY_SOC_ORG (SQL Table)	Index Back
PE Source Bank Link Def Source Banks can be assigned to different org units by Pay Entity. The assignment options are Department, Pay Group, Company and Establishment

GPMY_SOC_ORG

(SQL Table)

PE Source Bank Link Def

Source Banks can be assigned to different org units by Pay Entity. The assignment options are 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_SOCSO_NBR Character(12) VARCHAR2(12) NOT NULL SOCSO Number
Prompt Table: GPMY_SOC_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_SOCSO_NBR	Character(12)	VARCHAR2(12) NOT NULL	SOCSO Number Prompt Table: GPMY_SOC_TBL