RSF_TF_PERIOD (SQL Table)	Index Back
Period Timeframe and period record with use and rollup information.

RSF_TF_PERIOD

(SQL Table)

Period

Timeframe and period record with use and rollup information.

Related Language Record: RSF_TF_PERD_LNG

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 TIMEFRAME_ID Character(15) VARCHAR2(15) NOT NULL Time Frame

2 PERIOD_ID Character(15) VARCHAR2(15) NOT NULL Period

3 RSF_PERIOD_USE Character(1) VARCHAR2(1) NOT NULL Field used in identifying period usage
A=All
D=Planning & Portfolio
P=Pipeline Only
S=Forecast & Pipeline
U=Survey
Default Value: A

4 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

5 BEGIN_DT Date(10) DATE NOT NULL Begin Date

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

7 PERIOD_ROLLUP_ID Character(15) VARCHAR2(15) NOT NULL Quota Rollup Period
Prompt Table: RSF_TF_RP_VW

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

9 STATUS Character(1) VARCHAR2(1) NOT NULL Status Indicator
A=Active
I=Inactive
Default Value: A

10 DESCR Character(30) VARCHAR2(30) NOT NULL Description

11 DESCRSHORT Character(10) VARCHAR2(10) NOT NULL Short Description

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

13 ROW_ADDED_DTTM DateTime(26) TIMESTAMP This is a datetime field for record creation.

14 ROW_ADDED_OPRID Character(30) VARCHAR2(30) NOT NULL ID of user who added the row.

15 ROW_LASTMANT_DTTM DateTime(26) TIMESTAMP The date and time that the row was last updated.

16 ROW_LASTMANT_OPRID Character(30) VARCHAR2(30) NOT NULL ID of user who last modified the row.

17 SYNCID Number(10,0) DECIMAL(10) NOT NULL The Synchronization ID field stores a value generated by the sync processor. The value is used to identify the type of object that the sync processor is about to handle.

18 SYNCDTTM DateTime(26) TIMESTAMP Synchronization Last Update Date Time

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	TIMEFRAME_ID	Character(15)	VARCHAR2(15) NOT NULL	Time Frame
2	PERIOD_ID	Character(15)	VARCHAR2(15) NOT NULL	Period
3	RSF_PERIOD_USE	Character(1)	VARCHAR2(1) NOT NULL	Field used in identifying period usage A=All D=Planning & Portfolio P=Pipeline Only S=Forecast & Pipeline U=Survey Default Value: A
4	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
5	BEGIN_DT	Date(10)	DATE NOT NULL	Begin Date
6	END_DT	Date(10)	DATE NOT NULL	This field stores the end date values.
7	PERIOD_ROLLUP_ID	Character(15)	VARCHAR2(15) NOT NULL	Quota Rollup Period Prompt Table: RSF_TF_RP_VW
8	ROLLUP_SEQNUM	Number(3,0)	SMALLINT NOT NULL	Sequence Number
9	STATUS	Character(1)	VARCHAR2(1) NOT NULL	Status Indicator A=Active I=Inactive Default Value: A
10	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description
11	DESCRSHORT	Character(10)	VARCHAR2(10) NOT NULL	Short Description
12	TIMEFRAME_PERIOD	Character(32)	VARCHAR2(32) NOT NULL	Time Frame
13	ROW_ADDED_DTTM	DateTime(26)	TIMESTAMP	This is a datetime field for record creation.
14	ROW_ADDED_OPRID	Character(30)	VARCHAR2(30) NOT NULL	ID of user who added the row.
15	ROW_LASTMANT_DTTM	DateTime(26)	TIMESTAMP	The date and time that the row was last updated.
16	ROW_LASTMANT_OPRID	Character(30)	VARCHAR2(30) NOT NULL	ID of user who last modified the row.
17	SYNCID	Number(10,0)	DECIMAL(10) NOT NULL	The Synchronization ID field stores a value generated by the sync processor. The value is used to identify the type of object that the sync processor is about to handle.
18	SYNCDTTM	DateTime(26)	TIMESTAMP	Synchronization Last Update Date Time