TIMEFRAME_IDPERIOD_IDA=Annual
B=Bi-Weekly
D=Daily
M=Monthly
Q=Quarterly
S=Semi-Annual
W=Weekly
RSF_TF_PER_VW(SQL View) |
Index Back |
|---|---|
RSF_TF_PER_VW for DashboardRecord Added RSF_TF_PER_VW for sales Dashboard |
| SELECT TIMEFRAME_ID ,PERIOD_ID ,PERIOD_TYPE , BEGIN_DT , END_DT , DESCR , DESCRSHORT FROM PS_RSF_TF_PERIOD |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | TIMEFRAME_ID |
Character(15) | VARCHAR2(15) NOT NULL | Time Frame |
| 2 | PERIOD_ID |
Character(15) | VARCHAR2(15) NOT NULL | Period |
| 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. |
| 6 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 7 | DESCRSHORT | Character(10) | VARCHAR2(10) NOT NULL | Short Description |