GPMY_PESBNK_VW1 (SQL View)	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_PESBNK_VW1

(SQL View)

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

SELECT PAY_ENTITY ,ORG_LINK_OPTN FROM PS_GP_PE_SBANK

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 PAY_ENTITY Character(10) VARCHAR2(10) NOT NULL Pay Entity

2 ORG_LINK_OPTN Character(2) VARCHAR2(2) NOT NULL Identifies at what org level source banks are assigned. Value set at this time: Company, Dept, Location, Pay Entity, Pay Group
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	PAY_ENTITY	Character(10)	VARCHAR2(10) NOT NULL	Pay Entity
2	ORG_LINK_OPTN	Character(2)	VARCHAR2(2) NOT NULL	Identifies at what org level source banks are assigned. Value set at this time: Company, Dept, Location, Pay Entity, Pay Group CO=Company DE=Department ET=Establishment LO=Location PG=Pay Group Default Value: CO