CSE_FA_ASSOCIATIONS
The association table that connects the operational assets to their financial counterparts and vice versa. This bridge will be used to sync operational activities to the finalcial books when impacts are understood.
Details
-
Schema: FUSION
-
Object owner: CSE
-
Object type: TABLE
-
Tablespace: Default
Primary Key
Name | Columns |
---|---|
CSE_FA_ASSOCIATIONS_PK |
FA_ASSOCIATION_ID |
Columns
Name | Datatype | Length | Precision | Not-null | Comments |
---|---|---|---|---|---|
FA_ASSOCIATION_ID | NUMBER | 18 | Yes | The fixed asset association identifier. This is the primary key of the entity. | |
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. | |
ASSET_ID | NUMBER | 18 | Yes | The assets that are associated to their financial counterparts. The foreign key to the asset entity. | |
FA_ASSET_ID | NUMBER | 18 | Yes | The financial asset identifier. The finiancial assets are defined in fixed assets module and are being associated to the operational counterparts. | |
ACTIVE_START_DATE | TIMESTAMP | The date when the association between the operational and financial asset begins. | |||
ACTIVE_END_DATE | TIMESTAMP | The date when the association between the operational and financial asset is severed. | |||
AUTO_TERMINATION_FLAG | VARCHAR2 | 1 | Yes | When the operational asset moves outside the boundaries of the financial constraints, it auto terminates the relationship. | |
TERMINATION_REASON_CODE | VARCHAR2 | 30 | When the relationship between the operational and financial asset is severed automatically, the reason for which is recorded here. | ||
VALIDATED_FLAG | VARCHAR2 | 1 | This flag indicates that the association is valid and is eligible for synchronization between the two systems. | ||
SYNCHRONIZATION_STATUS_CODE | VARCHAR2 | 30 | The status captured for enabling and tracking auto synchronization. | ||
ERROR_MESSAGE | VARCHAR2 | 4000 | Stores any errors encountered during the synchronization process. | ||
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. |
Foreign Keys
Table | Foreign Table | Foreign Key Column |
---|---|---|
CSE_FA_ASSOCIATIONS | cse_assets_b | ASSET_ID |
Indexes
Index | Uniqueness | Tablespace | Columns |
---|---|---|---|
CSE_FA_ASSOCIATIONS_N01 | Non Unique | Default | ASSET_ID |
CSE_FA_ASSOCIATIONS_N02 | Non Unique | Default | FA_ASSET_ID |
CSE_FA_ASSOCIATIONS_U01 | Unique | Default | FA_ASSOCIATION_ID |