ZSF_FCST_SERIES
Master table which stores the forecast series defintion in forecasting application
Details
-
Schema: FUSION
-
Object owner: ZSF
-
Object type: TABLE
-
Tablespace: Default
Primary Key
| Name | Columns |
|---|---|
|
ZSF_FCST_SERIES_PK |
FCST_SERIES_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| FCST_SERIES_ID | NUMBER | 18 | Yes | Primary Key representing the series ID . This will be used to represent a forecast series setup | |
| ITEM_TYPE_CODE | VARCHAR2 | 30 | Type of Forecast Series. Currently we forecast only on Revenue | ||
| FCST_PERIOD_UNIT_CODE | VARCHAR2 | 30 | Forecast period. This is dervived from GL calendar | ||
| ADJ_PERIOD_UNIT_CODE | VARCHAR2 | 30 | Adjustment period corresponding to the GL calendar selected. | ||
| NUMBER_OF_FORECASTS | NUMBER | 9 | Number of Forecasts for a given forecast period | ||
| FIRST_FCST_DUE_DATE_OFFSET | NUMBER | Number of days before/after the start date , when the forecast is due | |||
| DUE_DATE_OFFSET_TYPE | VARCHAR2 | 30 | Represents whether the due date offset is before or after | ||
| TERR_HIER_FREEZE_OFFSET | NUMBER | 9 | Territory Hierarchy freeze date offset, before the start date. | ||
| ACTIVE_FLAG | VARCHAR2 | 1 | Indicates if the forecast series is active or draft | ||
| SUBMITTED_REQUEST_ID | NUMBER | 20 | Ess Request Id of the current forecast stored for reference | ||
| PIPELINE_REVN_FLAG | VARCHAR2 | 1 | If this is selected pipeline revenue metric is enabled | ||
| BEST_CASE_FCST_FLAG | VARCHAR2 | 1 | If this is selected bestcase revenue metric is enabled | ||
| WORST_CASE_FCST_FLAG | VARCHAR2 | 1 | If this is selected worst case revenue metric is enabled | ||
| CLOSED_REVENUE_FLAG | VARCHAR2 | 1 | If this is selected closed revenue metric is enabled | ||
| PREDICTED_ADJUSTMENT_FLAG | VARCHAR2 | 1 | If this is selected predicted adjustment metric is enabled | ||
| QUOTA_FLAG | VARCHAR2 | 1 | If this is selected quota metric is enabled | ||
| EXPECTED_REVN_FLAG | VARCHAR2 | 1 | If this is selected expected revenue metric is enabled | ||
| FCST_CRITERIA_OVERRIDE_FLAG | VARCHAR2 | 1 | This flag indicates if the criteria override is permitted for the forecast setup | ||
| CALENDAR_ID | NUMBER | 18 | Reference to the GL calendar selected for CRM | ||
| CORP_CURR_CODE | VARCHAR2 | 30 | Corporate Currency Code selected for the CRM | ||
| CORP_CURR_RATE_TYPE | VARCHAR2 | 30 | Corporate Currency Rate Type of the CRM currency | ||
| NON_REVN_FCST_FLAG | VARCHAR2 | 1 | Flag to enable non revenue forecasting for the setup | ||
| REMOVE_FROZEN_FORECAST | VARCHAR2 | 1 | This flag indicates if the user wants to remove frozen forecasts before a regenerate. | ||
| PROD_SUMMARY_ADJUST_FLAG | VARCHAR2 | 1 | Indicates whether the product summary adjustment is enabled. | ||
| PROD_HIER_ADJUST_LEVEL | NUMBER | Level of product hierarachy upto which summary adjustment can be handled | |||
| LAST_REFRESH_DATE | TIMESTAMP | Date on which the product hierarchy snapshot was last refreshed from the product schema | |||
| NEXT_SUMMARY_REFRESH_DATE | TIMESTAMP | Stores the time at which the next scheduled metrics refresh process will start. | |||
| SCHEDULED_PERIODS | NUMBER | Stores the number of scheduled current and future periods for which forecasts can be generated. | |||
| CONCURRENT_FORECASTS | NUMBER | Stores the number of concurrent forecasts to be generated | |||
| REVN_METRICS_REFRESH_DATE | TIMESTAMP | This column has the last refresh date of revenue metrics data. | |||
| TREND_GRAPH_FLAG | VARCHAR2 | 1 | Control whether trend graph flag is displayed in the Fuse Overview Page | ||
| ADJUSTMENT_NOTES_FLAG | VARCHAR2 | 1 | ADJUSTMENT_NOTES_FLAG | ||
| AUTO_PILOT_STATUS | VARCHAR2 | 30 | 'AUTOPILOT' if the user clicked on the 'Enable Forecasting' checkbox. (Check box is ON) NULL if the application is upgraded from an earlier release. (Check box is ON) 'MANUAL' if the application is upgraded from an earlier release and admin has manually enabled autopilot (Check box is ON) | ||
| AUTO_PILOT_REQUEST_ID | NUMBER | 18 | Request ID of the recurring job scheduled for forecasting autopilot | ||
| AUTO_PILOT_NOTIFY_EMAILS | VARCHAR2 | 4000 | Comma separated list of email addresses to which notifications about autopilot jobs should be sent | ||
| LAST_DIAGNOSTICS_JOB_ID | NUMBER | 18 | Last Run Diagnostic job id to be fetched on page load in admin UI. | ||
| RESOURCE_FORECASTING_FLAG | VARCHAR2 | 1 | This column indicates if customer has enabled Resource Based Forecasting | ||
| CREATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who created the row. | |
| CREATION_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the creation of the row. | ||
| LAST_UPDATE_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the last update of the row. | ||
| LAST_UPDATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who last updated the row. | |
| LAST_UPDATE_LOGIN | VARCHAR2 | 32 | Who column: indicates the session login associated to the user who last updated the row. | ||
| CONFLICT_ID | NUMBER | 18 | Yes | Disconnected Mobile: this value is used to guarantee the uniqueness of the row when duplicates are created in different databases (i.e. mobile databases or the server). | |
| OBJECT_VERSION_NUMBER | NUMBER | 9 | Yes | Used to implement optimistic locking. This number is incremented every time that the row is updated. The number is compared at the start and end of a transaction to detect whether another session has updated the row since it was queried. | |
| USER_LAST_UPDATE_DATE | TIMESTAMP | Disconnected Mobile: indicates the date and time of the last update of the row. This value is different from LAST_UPDATE_DATE if the update originally happened in a different database (i.e. a different mobile database or the server). |
Foreign Keys
| Table | Foreign Table | Foreign Key Column |
|---|---|---|
| zsf_fcst_header | zsf_fcst_series | FCST_SERIES_ID |
| zsf_fcst_series_criteria | zsf_fcst_series | FCST_SERIES_ID |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| ZSF_FCST_SERIES_PK | Unique | Default | FCST_SERIES_ID |