RSFD_TFP_ALL_VW (SQL View)	Index Back
Quarterly Timeframe Periods A view of all Quarterly Timeframe Periods

RSFD_TFP_ALL_VW

(SQL View)

Quarterly Timeframe Periods

A view of all Quarterly Timeframe Periods

SELECT MAX(A.TIMEFRAME_PERIOD) , MAX(A.PERIOD_TYPE) , A.BEGIN_DT , A.END_DT , MAX(A.ROLLUP_SEQNUM) FROM PS_RSF_TF_PERIOD A WHERE A.STATUS = 'A' GROUP BY BEGIN_DT, END_DT

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 TIMEFRAME_PERIOD Character(32) VARCHAR2(32) NOT NULL Time Frame

2 PERIOD_TYPE Character(1) VARCHAR2(1) NOT NULL Quota Definition Period Type
A=Annual
B=Bi-Weekly
D=Daily
M=Monthly
Q=Quarterly
S=Semi-Annual
W=Weekly

3 BEGIN_DT Date(10) DATE NOT NULL Begin Date

4 END_DT Date(10) DATE NOT NULL This field stores the end date values.

5 ROLLUP_SEQNUM Number(3,0) SMALLINT NOT NULL Sequence Number

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	TIMEFRAME_PERIOD	Character(32)	VARCHAR2(32) NOT NULL	Time Frame
2	PERIOD_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Quota Definition Period Type A=Annual B=Bi-Weekly D=Daily M=Monthly Q=Quarterly S=Semi-Annual W=Weekly
3	BEGIN_DT	Date(10)	DATE NOT NULL	Begin Date
4	END_DT	Date(10)	DATE NOT NULL	This field stores the end date values.
5	ROLLUP_SEQNUM	Number(3,0)	SMALLINT NOT NULL	Sequence Number