HR_SS_EMPL_VW (SQL View)	Index Back
Self Svc Emplmt Srch This record is used as the level 0 record in manager self-service transactions. It is a "dummy" view since it selects against the INSTALLATION table as it's just a holder for the EMPLID and EMPL_RCD fields when entering the HR_EE_INF_MGR component.

HR_SS_EMPL_VW

(SQL View)

Self Svc Emplmt Srch

This record is used as the level 0 record in manager self-service transactions. It is a "dummy" view since it selects against the INSTALLATION table as it's just a holder for the EMPLID and EMPL_RCD fields when entering the HR_EE_INF_MGR component.

SELECT ' ' , 0 FROM PS_INSTALLATION

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

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

2 EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Rcd Nbr

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
2	EMPL_RCD	Number(3,0)	SMALLINT NOT NULL	Empl Rcd Nbr