RSF_TF_ROLL_VW(SQL View) |
Index Back |
|---|---|
Distinct Timeframe Rollup VW |
| SELECT DISTINCT TIMEFRAME_ID , PERIOD_ROLLUP_ID , PERIOD_ID , ROLLUP_SEQNUM , BEGIN_DT , END_DT FROM PS_RSF_TF_ROLLUP |
| # | 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_ID | Character(15) | VARCHAR2(15) NOT NULL | Period |
| 4 | ROLLUP_SEQNUM | Number(3,0) | SMALLINT NOT NULL | Sequence Number |
| 5 | BEGIN_DT | Date(10) | DATE | Begin Date |
| 6 | END_DT | Date(10) | DATE | This field stores the end date values. |