GPMY_EPFORG_LNG (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_EPFORG_LNG

(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_EPF_NBR Character(10) VARCHAR2(10) NOT NULL EPF Number

5 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code

6 GPMY_REGISTERED_NM Character(50) VARCHAR2(50) NOT NULL Registered Name

7 RESPONSIBLE_ROLE Character(30) VARCHAR2(30) NOT NULL Responsible Role

#	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_EPF_NBR	Character(10)	VARCHAR2(10) NOT NULL	EPF Number
5	LANGUAGE_CD	Character(3)	VARCHAR2(3) NOT NULL	Language Code
6	GPMY_REGISTERED_NM	Character(50)	VARCHAR2(50) NOT NULL	Registered Name
7	RESPONSIBLE_ROLE	Character(30)	VARCHAR2(30) NOT NULL	Responsible Role