GPMY_EPF_ORG_DT (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_EPF_ORG_DT

(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

Parent Record Of GPMY_ORG_K_SBR

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 EFFDT Date(10) DATE NOT NULL Effective Date
Default Value: %date

2 EFF_STATUS Character(1) VARCHAR2(1) NOT NULL Effective Status
A=Active
I=Inactive
Default Value: A

3 GPMY_ORG_LINK_OPTN Character(2) VARCHAR2(2) NOT NULL Organizational Link Option
CO=Company
DE=Department
ET=Establishment
LO=Location
PG=Pay Group
Default Value: CO

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	EFFDT	Date(10)	DATE NOT NULL	Effective Date Default Value: %date
2	EFF_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Effective Status A=Active I=Inactive Default Value: A
3	GPMY_ORG_LINK_OPTN	Character(2)	VARCHAR2(2) NOT NULL	Organizational Link Option CO=Company DE=Department ET=Establishment LO=Location PG=Pay Group Default Value: CO