19.17 Adding a New Scenario
User can define their own scenarios in the FCC_SCENARIO_MASTER table.
Table 19-10 FCC_SCENARIO_MASTER Table
| Column Name | Primary Key | Column Type |
|---|---|---|
| N_SCENARIO_SKEY | Y | NUMBER(22) |
| V_SCENARIO_NAME | VARCHAR2(250 CHAR) | |
| V_SCENARIO_DESCRIPTION | VARCHAR2(4000 CHAR) | |
| V_SCENARIO_CLASS_CD | VARCHAR2(250 CHAR) | |
| V_SCENARIO_DISPLAY_NAME | VARCHAR2(250 CHAR) | |
| V_SCENARIO_CATALOG_ID | VARCHAR2(250 CHAR) | |
| V_SCENARIO_FOCUS_ENTITY_CD | VARCHAR2(250 CHAR) | |
| N_SCENARIO_SCORE | NUMBER(22) | |
| ORIG_SCENARIO_SKEY | NUMBER(22) |
- N_SCENARIO_SKEY – Unique Sequence ID
- V_SCENARIO_NAME – Name of the Scenario
- V_SCENARIO_DESCRIPTION – Description of the Scenario
- V_SCENARIO_CLASS_CD – Class of scenario
- V_SCENARIO_DISPLAY_NAME – Display name of the scenario
- V_SCENARIO_CATALOG_ID – Catalog ID of scenario
- V_SCENARIO_FOCUS_ENTITY_CD – Focus entity code of the scenario
- N_SCENARIO_SCORE – Scenario score. This column can be Null.
- ORIG_SCENARIO_SKEY – Scenario ID from the Source system