GP_LINK_ES_VW (SQL View)	Index Back
Establishment Link View View of Establishment Description

GP_LINK_ES_VW

(SQL View)

Establishment Link View

View of Establishment Description

SELECT A.ESTABID , A.EFFDT , A.DESCR FROM PS_ESTAB_TBL A

Related Language Record: GP_LINK_ES_LVW

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 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

2 EFFDT Date(10) DATE Effective Date

3 DESCR Character(30) VARCHAR2(30) NOT NULL Description

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	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
2	EFFDT	Date(10)	DATE	Effective Date
3	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description