CST_STD_RESOURCE_RATES_HISTORY
This table contains resource rate records which have been obsoleted by publish process from cost planning because the old rates and the new rates have the same effective date and are overwritten.
Details
-
Schema: FUSION
-
Object owner: CST
-
Object type: TABLE
-
Tablespace: FUSION_TS_TX_DATA
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| STD_RESOURCE_RATE_ID | NUMBER | 18 | Yes | Indicates the surrogate identifier for the standard resource rate. | |
| COST_ORG_ID | NUMBER | 18 | Yes | Indicates the cost organization to which the resource rates are published from cost planning. | |
| COST_BOOK_ID | NUMBER | 18 | Yes | Indicates the cost book to which the resource rates are published from cost planning. | |
| RESOURCE_ID | NUMBER | 18 | Yes | Indicates the resource for which the rates are published. | |
| UOM_CODE | VARCHAR2 | 3 | Yes | Indicates the unit of measure for the resource. | |
| EFFECTIVE_START_DATE | DATE | Yes | Date Effective Entity: indicates the date at the beginning of the date range within which the row is effective. | ||
| EFFECTIVE_END_DATE | DATE | Yes | Date Effective Entity: indicates the date at the end of the date range within which the row is effective. | ||
| CURRENCY_CODE | VARCHAR2 | 15 | Yes | Indicates the currency code in which the resource rate is maintained. | |
| SCENARIO_EVENT_ID | NUMBER | 18 | Yes | Indicates the scenario event from which the standard resource rate was published from. | |
| PREVIOUS_STD_RESOURCE_RATE_ID | NUMBER | 18 | Indicates the standard resource rate which this resource rate record is replacing. | ||
| PREVIOUS_EFFECTIVE_START_DATE | DATE | Indicates the start date of the previously effective standard resource rate. | |||
| PREVIOUS_EFFECTIVE_END_DATE | DATE | Indicates the end date of the previously effective standard resource rate. | |||
| LAST_USED_TRANSACTION_ID | NUMBER | 18 | Indicates the last resource transaction which used this standard resource rate for accounting purposes. | ||
| PLANNING_RESOURCE_RATE_ID | NUMBER | 18 | Yes | Indicates the reference of the cost planning resource rate from which the standard resource rate is published. | |
| 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. | ||
| REQUEST_ID | NUMBER | 18 | Enterprise Service Scheduler: indicates the request ID of the job that created or last updated the row. | ||
| JOB_DEFINITION_NAME | VARCHAR2 | 100 | Enterprise Service Scheduler: indicates the name of the job that created or last updated the row. | ||
| JOB_DEFINITION_PACKAGE | VARCHAR2 | 900 | Enterprise Service Scheduler: indicates the package name of the job that created or last updated the row. | ||
| SCENARIO_PUBLISH_HEADER_ID | NUMBER | 18 | Yes | Indicates the surrogate key reference of the scenario publish header. | |
| LAST_USED_DATE | DATE | Indicates the last date that this resource rate was used for transaction processing. | |||
| SCENARIO_ROLLUP_HEADER_ID | NUMBER | 18 | Indicates the reference of scenario rollup header when the record is published from cost planning. |
Foreign Keys
| Table | Foreign Table | Foreign Key Column |
|---|---|---|
| CST_STD_RESOURCE_RATES_HISTORY | cst_std_resource_rates | STD_RESOURCE_RATE_ID |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| CST_STD_RSRC_RATES_HIST_PK | Unique | FUSION_TS_TX_DATA | STD_RESOURCE_RATE_ID |