GPGB_ER_NAME_VW (SQL View)	Index Back
Employer Name View This view selects the Employer Name from the UK Pay Entity table.

GPGB_ER_NAME_VW

(SQL View)

Employer Name View

This view selects the Employer Name from the UK Pay Entity table.

SELECT A.EMPLID ,A.EFFDT ,C.GPGB_ER_NAME FROM PS_JOB A ,PS_GP_PYGRP B ,PS_GPGB_PYENT C WHERE A.GP_PAYGROUP = B.GP_PAYGROUP AND B.PAY_ENTITY = C.PAY_ENTITY AND A.JOB_INDICATOR = 'P'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

2 EFFDT Date(10) DATE Effective Date
Default Value: %date

3 GPGB_ER_NAME Character(36) VARCHAR2(36) NOT NULL Employer's name

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
2	EFFDT	Date(10)	DATE	Effective Date Default Value: %date
3	GPGB_ER_NAME	Character(36)	VARCHAR2(36) NOT NULL	Employer's name