HS_SS_ADM_VW (SQL View)	Index Back
Primary Job View - HR HS_PRI_JOB_VW is used to return the most current Primary Job information at a certain Effective Date for an Employee. The goal of this view is to find the most current active primary job row of an employee that is a Health and Safety administrator so we can get their REG_REGION.

HS_SS_ADM_VW

(SQL View)

Primary Job View - HR

HS_PRI_JOB_VW is used to return the most current Primary Job information at a certain Effective Date for an Employee. The goal of this view is to find the most current active primary job row of an employee that is a Health and Safety administrator so we can get their REG_REGION.

SELECT I1.INCIDENT_NBR , R1.ROLENAME , R1.ROLEUSER , R1.OPRID , R1.EMAILID FROM PS_HS_SS_INCDT_DAT I1 , PS_HS_ROLEUSER_VW R1 , PS_OPR_DEF_TBL_HR OPR1 , PSOPRDEFN OPR2 WHERE OPR1.REG_REGION = I1.REG_REGION AND OPR2.OPRCLASS = OPR1.OPRCLASS AND R1.OPRID = OPR2.OPRID

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 INCIDENT_NBR Character(8) VARCHAR2(8) NOT NULL Incident Number

2 ROLENAME Character(30) VARCHAR2(30) NOT NULL The name of a Role in the Role Definition Table (see PSROLEDEFN).

3 ROLEUSER Character(30) VARCHAR2(30) NOT NULL Role User

4 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).

5 EMAILID Character(70) VARCHAR2(70) NOT NULL A user's E-mail address

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	INCIDENT_NBR	Character(8)	VARCHAR2(8) NOT NULL	Incident Number
2	ROLENAME	Character(30)	VARCHAR2(30) NOT NULL	The name of a Role in the Role Definition Table (see PSROLEDEFN).
3	ROLEUSER	Character(30)	VARCHAR2(30) NOT NULL	Role User
4	OPRID	Character(30)	VARCHAR2(30) NOT NULL	A user's ID (see PSOPRDEFN).
5	EMAILID	Character(70)	VARCHAR2(70) NOT NULL	A user's E-mail address