RSF_TF_ROLLUP(SQL Table) |
Index Back |
|---|---|
Timeframe Rollup Table |
| # | 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. |