TIMEFRAME_IDPERIOD_ROLLUP_IDPrompt Table: RSF_TF_RP_VW
A=Annual
B=Bi-Weekly
D=Daily
M=Monthly
Q=Quarterly
S=Semi-Annual
W=Weekly
RSF_TF_PD_R_VW(SQL View) |
Index Back |
|---|---|
Period - Rollup ID ViewView which supports the use of timeframes within pipeline. |
| SELECT TIMEFRAME_ID , PERIOD_ID , PERIOD_TYPE , BEGIN_DT , END_DT FROM PS_RSF_PIPE_TF_VW |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | TIMEFRAME_ID |
Character(15) | VARCHAR2(15) NOT NULL | Time Frame |
| 2 | PERIOD_ROLLUP_ID |
Character(15) | VARCHAR2(15) NOT NULL |
Quota Rollup Period
Prompt Table: RSF_TF_RP_VW |
| 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 | BEGIN_DT | Date(10) | DATE NOT NULL | Begin Date |
| 5 | END_DT | Date(10) | DATE NOT NULL | This field stores the end date values. |