PC_EX_PER_VW (SQL View)	Index Back
Expenses Timesheet Periods View of distinct Timesheet periods by GL Business Unit

PC_EX_PER_VW

(SQL View)

Expenses Timesheet Periods

View of distinct Timesheet periods by GL Business Unit

SELECT DISTINCT BUSINESS_UNIT_GL , PERIOD_END_DT FROM PS_EX_TIME_HDR

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 BUSINESS_UNIT_GL Character(5) VARCHAR2(5) NOT NULL GL Business Unit

2 PERIOD_END_DT Date(10) DATE Represents the date termination point for a given time set utilized in cash worksheet processing.

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	BUSINESS_UNIT_GL	Character(5)	VARCHAR2(5) NOT NULL	GL Business Unit
2	PERIOD_END_DT	Date(10)	DATE	Represents the date termination point for a given time set utilized in cash worksheet processing.