RPM_TIMEFRAM_V2 (SQL View)	Index Back
Active Timeframe Periods View of all Active Timeframe Periods

RPM_TIMEFRAM_V2

(SQL View)

Active Timeframe Periods

View of all Active Timeframe Periods

SELECT DISTINCT A.PERIOD_TYPE FROM PS_RSF_TF_PERIOD A WHERE A.STATUS = 'A' AND A.RSF_PERIOD_USE IN ( 'A', 'D')

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 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