GM_PM_OPT_PC_BU (SQL View)	Index Back
BU PC OPT using BU_PC

GM_PM_OPT_PC_BU

(SQL View)

BU PC OPT using BU_PC

SELECT A.BUSINESS_UNIT ,A.UOM_HOURS ,A.DAYS_UOM ,B.HOLIDAY_LIST_ID ,B.PC_HOURS_PER_DAY FROM PS_BUS_UNIT_TBL_PC A , PS_BUS_UNIT_OPT_PC B WHERE A.BUSINESS_UNIT = B.BUSINESS_UNIT

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 BUSINESS_UNIT_PC Character(5) VARCHAR2(5) NOT NULL PC Business Unit

2 UOM_HOURS Character(3) VARCHAR2(3) NOT NULL The Unit of Measure that represents Hours.

3 DAYS_UOM Character(3) VARCHAR2(3) NOT NULL the unit of measure for days

4 HOLIDAY_LIST_ID Character(10) VARCHAR2(10) NOT NULL This is used to identify what holiday calendar to use. This is the access field for all financials groups.

5 STD_HOURS_DAY Number(5,2) DECIMAL(4,2) NOT NULL Standard Hours Day

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	BUSINESS_UNIT_PC	Character(5)	VARCHAR2(5) NOT NULL	PC Business Unit
2	UOM_HOURS	Character(3)	VARCHAR2(3) NOT NULL	The Unit of Measure that represents Hours.
3	DAYS_UOM	Character(3)	VARCHAR2(3) NOT NULL	the unit of measure for days
4	HOLIDAY_LIST_ID	Character(10)	VARCHAR2(10) NOT NULL	This is used to identify what holiday calendar to use. This is the access field for all financials groups.
5	STD_HOURS_DAY	Number(5,2)	DECIMAL(4,2) NOT NULL	Standard Hours Day