GPHK_I56_PRD_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_I56_PRD_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 EMPLID ,SEX ,MAR_STATUS FROM PS_PERSONAL_DT_FST

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

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

2 SEX Character(1) VARCHAR2(1) NOT NULL Gender
F=Female
M=Male
U=Unknown
X=Indeterminate/Intersex/Unspec

3 MAR_STATUS Character(1) VARCHAR2(1) NOT NULL Marital Status
C=Common-Law
D=Divorced
E=Separated
H=Head of Household
L=DissDeclLost Civil Partner
M=Married
P=Civil Partnership
S=Single
T=Surviving Civil Partner
U=Unknown
V=Dissolved Civil Partnership
W=Widowed

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
2	SEX	Character(1)	VARCHAR2(1) NOT NULL	Gender F=Female M=Male U=Unknown X=Indeterminate/Intersex/Unspec
3	MAR_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Marital Status C=Common-Law D=Divorced E=Separated H=Head of Household L=DissDeclLost Civil Partner M=Married P=Civil Partnership S=Single T=Surviving Civil Partner U=Unknown V=Dissolved Civil Partnership W=Widowed