RSFD_TIMEPRD_VW (SQL View)	Index Back
All Timeframe Periods A view of all Timeframe Periods for use within dashboards.

RSFD_TIMEPRD_VW

(SQL View)

All Timeframe Periods

A view of all Timeframe Periods for use within dashboards.

SELECT A.TIMEFRAME_PERIOD , A.PERIOD_TYPE , A.BEGIN_DT , A.END_DT , A.ROLLUP_SEQNUM FROM PS_RSF_TF_PERIOD A WHERE A.RSF_PERIOD_USE = 'A' AND A.STATUS = 'A'

Parent record: RSF_TF_DEFN

# 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