RSFD_TFP_ANN_VW (SQL View)	Index Back
Annual Timeframe Periods A view of all Annual Timeframe Periods

RSFD_TFP_ANN_VW

(SQL View)

Annual Timeframe Periods

A view of all Annual Timeframe Periods

SELECT MAX(A.TIMEFRAME_PERIOD) , MAX(A.PERIOD_TYPE) , A.BEGIN_DT , A.END_DT , MAX(A.ROLLUP_SEQNUM) , A.STATUS , B.XLATSHORTNAME FROM PS_RSF_TF_PERIOD A , PSXLATITEM B WHERE A.STATUS = B.FIELDVALUE AND B.FIELDNAME = 'STATUS' AND B.EFF_STATUS = 'A' AND %EffdtCheck(PSXLATITEM C, B, %CurrentDateIn) AND A.STATUS = 'A' AND A.PERIOD_TYPE = 'A' GROUP BY A.BEGIN_DT, A.END_DT, A.STATUS, B.XLATSHORTNAME

# 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

6 STATUS Character(1) VARCHAR2(1) NOT NULL Status Indicator
A=Active
I=Inactive

7 STATUS_CAT_SDESCR Character(10) VARCHAR2(10) NOT NULL Used for contact center dashboard to display status category short description.

#	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
6	STATUS	Character(1)	VARCHAR2(1) NOT NULL	Status Indicator A=Active I=Inactive
7	STATUS_CAT_SDESCR	Character(10)	VARCHAR2(10) NOT NULL	Used for contact center dashboard to display status category short description.