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

GPNZ_PESBNK_VW1

(SQL View)

PE Source Bank Link Def-No PC

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