TIMEFRAME_PERIODA=All
D=Planning & Portfolio
P=Pipeline Only
S=Forecast & Pipeline
U=Survey
Default Value: P
A=Annual
B=Bi-Weekly
D=Daily
M=Monthly
Q=Quarterly
S=Semi-Annual
W=Weekly
RSP_TF_VW(SQL View) |
Index Back |
|---|---|
View on Timeframe TableView on Timeframe used by Strategic Account Planning |
| SELECT A.TIMEFRAME_PERIOD , A.RSF_PERIOD_USE , A.PERIOD_TYPE , A.BEGIN_DT , A.END_DT , A.TIMEFRAME_ID , A.PERIOD_ID FROM PS_RSF_TF_PERIOD A WHERE A.RSF_PERIOD_USE IN ('A', 'D') AND A.STATUS = 'A' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | TIMEFRAME_PERIOD |
Character(32) | VARCHAR2(32) NOT NULL | Time Frame |
| 2 | 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: P |
| 3 | 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 |
| 4 | START_DATE | Date(10) | DATE | Start Date for Gen Standing PO |
| 5 | END_DATE | Date(10) | DATE | End date field to store an end date. |
| 6 | TIMEFRAME_ID | Character(15) | VARCHAR2(15) NOT NULL | Time Frame |
| 7 | PERIOD_ID | Character(15) | VARCHAR2(15) NOT NULL | Period |