RE_JOB_LOC_VW (SQL View)	Index Back
Location+BU of employees A group by of LOCATION and BU over the employees in the temp table. Thus, SQL will give us all the unique locations for the employees existing in the populated temp table.

RE_JOB_LOC_VW

(SQL View)

Location+BU of employees

A group by of LOCATION and BU over the employees in the temp table. Thus, SQL will give us all the unique locations for the employees existing in the populated temp table.

SELECT BUSINESS_UNIT , LOCATION , COUNT(*) AS NUM_OF FROM %Table(RE_CAFM_EMP_STG) GROUP BY LOCATION , BUSINESS_UNIT

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

2 LOCATION Character(10) VARCHAR2(10) NOT NULL Location Code

3 NUM_OF Number(25,1) DECIMAL(24,1) NOT NULL Number of

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
2	LOCATION	Character(10)	VARCHAR2(10) NOT NULL	Location Code
3	NUM_OF	Number(25,1)	DECIMAL(24,1) NOT NULL	Number of