CN_TP_CALC_SIMULATION_ALL
This table is used to store calculation simulation objects.
Details
-
Schema: FUSION
-
Object owner: CN
-
Object type: TABLE
-
Tablespace: Default
Primary Key
| Name | Columns |
|---|---|
|
CN_TP_CALC_SIMULATION_ALL_PK |
SIMULATION_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| SIMULATION_ID | NUMBER | 18 | Yes | Unique identifier for a calculation simulation. | |
| SIMULATION_NAME | VARCHAR2 | 160 | Optional user-friendly name to identify the calculation simulation. At the time the simulation is processed, the field IS_LATEST will be set to 'N' for all the existing simulations using the same name, while it will be set to 'Y' for the current calculation simulation. | ||
| IS_LATEST_FLAG | VARCHAR2 | 1 | Indicates whether a simulation is the latest among all simulations processed which have the same SIMULATION_NAME value. | ||
| SIMULATION_TYPE | VARCHAR2 | 30 | Yes | Defines the type of processing that needs to be used in this simulation. | |
| SOURCE_OBJECT_TYPE | VARCHAR2 | 30 | The type of the source object used to generate this Calculation Simulation. | ||
| SOURCE_OBJECT_ID | NUMBER | 18 | The identifier of the source object used to generate this Calculation Simulation. | ||
| SOURCE_OBJECT_NUMBER | VARCHAR2 | 30 | Alternate identifier of the source object used to generate this Calculation Simulation. | ||
| OWNER_ID | NUMBER | 18 | The identifier of the Participant that owns this Calculation Simulation. Used to determine the users that have access to the results. | ||
| PROCESSING_STATUS | VARCHAR2 | 20 | The status of the calculation simulation, used to know if the simulation is ready to be processed, is being processed, has completed, or has ended in error. | ||
| PROCESSING_DATE | DATE | The date when this calculation simulation was processed. | |||
| ASYNC_REQUEST_ID | NUMBER | 18 | Indicates the request ID of the job used to execute the calculation simulation asynchronously. | ||
| SIMULATION_START_PERIOD_ID | NUMBER | 18 | The starting period id used for this calculation simulation. If null the period id would be automatically calculated. | ||
| SIMULATION_END_PERIOD_ID | NUMBER | 18 | The ending period id used for this calculation simulation. If null the period id would be automatically calculated. | ||
| ORG_ID | NUMBER | 18 | Yes | Indicates the identifier of the business unit associated to the row. | |
| PROCESS_AUDIT_ID | NUMBER | 18 | Foreign key to relate the processing logs stored in cn_process_audits_all table. | ||
| ERROR_CODE | VARCHAR2 | 30 | When the calculation simulation ends in error status, this value indicates the error type. | ||
| CURRENT_EARNINGS_SUM_CALC | NUMBER | The sum of the earnings in calculation currency already earned by a participant before the calculation simulation. | |||
| CURRENT_EARNINGS_SUM_HOME | NUMBER | The sum of the earnings in home currency already earned by a participant before the calculation simulation. | |||
| CURRENT_EARNINGS_SUM_FUNC | NUMBER | The sum of the earnings in functional currency already earned by a participant before the calculation simulation. | |||
| GAIN_SUM_CALC | NUMBER | The sum of the gain in calculation currency calculated during the calculation simulation. | |||
| GAIN_SUM_HOME | NUMBER | The sum of the gain in home currency calculated during the calculation simulation. | |||
| GAIN_SUM_FUNC | NUMBER | The sum of the gain in functional currency calculated during the calculation simulation. | |||
| CALC_CURRENCY_CODE | VARCHAR2 | 15 | Calculation currency code. | ||
| HOME_CURRENCY_CODE | VARCHAR2 | 15 | Participant's home currency code | ||
| START_PAY_PERIOD_ID | NUMBER | 18 | The lowest pay period id for the earnings in this calculation simulation. | ||
| END_PAY_PERIOD_ID | NUMBER | 18 | The highest pay period id for the earnings in this calculation simulation. | ||
| UPDATE_QUEUED | VARCHAR2 | 1 | Indicates there is a new simulation with the same name in queue to be processed. | ||
| QUEUE_NUMBER | NUMBER | 9 | Internal number used distribute the processing of queued simulations. | ||
| BLOCKING_REQUEST_ID | NUMBER | 18 | Identifier of the job that needs to complete to process this simulation. | ||
| 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. | |
| 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_UPDATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who last updated the row. | |
| LAST_UPDATE_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the last update of the row. | ||
| LAST_UPDATE_LOGIN | VARCHAR2 | 32 | Who column: indicates the session login associated to the user who last updated the row. |
Foreign Keys
| Table | Foreign Table | Foreign Key Column |
|---|---|---|
| CN_TP_CALC_SIMULATION_ALL | cn_process_audits_all | PROCESS_AUDIT_ID |
| cn_sim_calc_jobs_all | cn_tp_calc_simulation_all | SIMULATION_ID |
| cn_sim_srp_per_form_metr_all | cn_tp_calc_simulation_all | SIMULATION_ID |
| cn_sim_credits_all | cn_tp_calc_simulation_all | SIMULATION_ID |
| cn_sim_process_batches_all | cn_tp_calc_simulation_all | SIMULATION_ID |
| cn_tp_calc_simulation_srp_all | cn_tp_calc_simulation_all | SIMULATION_ID |
| cn_sim_earnings_all | cn_tp_calc_simulation_all | SIMULATION_ID |
| cn_sim_measure_results_all | cn_tp_calc_simulation_all | SIMULATION_ID |
| cn_sim_srp_per_form_exts_all | cn_tp_calc_simulation_all | SIMULATION_ID |
| cn_sim_transactions_all | cn_tp_calc_simulation_all | SIMULATION_ID |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| CN_TP_CALC_SIMULATION_ALL_U1 | Unique | Default | SIMULATION_ID |
| CN_TP_CALC_SIMULATION_N1 | Non Unique | Default | SIMULATION_NAME, IS_LATEST_FLAG |
| CN_TP_CALC_SIMULATION_N2 | Non Unique | Default | ASYNC_REQUEST_ID, PROCESSING_STATUS, ORG_ID |
| CN_TP_CALC_SIMULATION_N3 | Non Unique | Default | QUEUE_NUMBER, BLOCKING_REQUEST_ID, SIMULATION_NAME |