GPHK_IR56_PR_VW (SQL View)	Index Back
Primary Job Record Information This view is required for retrieving information from the JOB record identified as Primary Job. This view is required for associating the job information to an employee IR56 record. Since HR information is not stored on the IR56 tables, we need to use a view to retrieve the basic information of an employee and use them as related display fields on the IR56 inquiry page.

GPHK_IR56_PR_VW

(SQL View)

Primary Job Record Information

This view is required for retrieving information from the JOB record identified as Primary Job. This view is required for associating the job information to an employee IR56 record. Since HR information is not stored on the IR56 tables, we need to use a view to retrieve the basic information of an employee and use them as related display fields on the IR56 inquiry page.

SELECT A.EMPLID ,A.JOBCODE ,A.FULL_PART_TIME FROM PS_JOB A WHERE A.JOB_INDICATOR = 'P' AND A.EFFDT = ( SELECT MAX(A1.EFFDT) FROM PS_JOB A1 WHERE A1.EMPLID = A.EMPLID)

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

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

2 JOBCODE Character(6) VARCHAR2(6) NOT NULL Job Code

3 FULL_PART_TIME Character(1) VARCHAR2(1) NOT NULL Full/Part Time
D=On Demand
F=Full-Time
P=Part-Time

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
2	JOBCODE	Character(6)	VARCHAR2(6) NOT NULL	Job Code
3	FULL_PART_TIME	Character(1)	VARCHAR2(1) NOT NULL	Full/Part Time D=On Demand F=Full-Time P=Part-Time