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 |