Table Description
Financial Component Relationship: A relationship between two financial components.

This table supports the creation of the necessary link between primary and secondary financial components.

Example

Child support payments are automatically deducted from John Smith's payment and paid to another nominee (ex-wife). The relationship between these components is stored on this table.
Relationship Diagram
Click the diagram to manipulate and zoom. Traverse the diagram using Click-and-Drag motions.
Model Details
Location in Model: Logical View::MetaModel::Curam::Core::Reference Model::Financial::Entity Objects::FinancialComponentRelation::FinancialComponentRelation
Controlling File: core\model\Packages\Financial Manager Packages\FinancialComponentRelation_cat.efx
Table Options
ALLOW_OPTIMISTIC_LOCKINGyes
Attributes (7)
AttributeStereotypeNullableDescriptionDomain DefinitionCodetableDDL Type
financialCompRelationIDkeynoUnique reference number assigned by the system for this FinancialComponentRelationFINANCIAL_COMPONENT_RELATION_ID SVR_INT64
financialCompIDdetailsnoFinancialComponentID for the first FinancialComponent in the relationshipFINANCIAL_COMPONENT_ID SVR_INT64
relatedFcIDdetailsnoFinancialComponentID for the second FinancialComponent in the relationshipFINANCIAL_COMPONENT_ID SVR_INT64
typeCodedetails Code value to indicate the relationship between the Financial Components. Populated from the FinancialComponentRelationship code table.FIN_COMPONENT_RELATIONSHIP_CODEFinComponentRelationshipSVR_STRING<10>
statusCodedetails Code value to indicate the status of the Financial Component Relationship.FIN_COMP_RELATION_STATUS_CODEFinCompRelationStatusSVR_STRING<10>
startDatedetails Commencement Date of the Financial Component Relationship.CURAM_DATE SVR_DATE
endDatedetails Expiry Date of Financial Component Relationship.CURAM_DATE SVR_DATE
Foreign Keys (2)
ChildParent
FinancialComponentRelation.financialCompIDFinancialComponent.financialCompID
FinancialComponentRelation.relatedFcIDFinancialComponent.financialCompID
Indices (2)
Index NameAttributes
FCRelRelatedFcIDstrelatedFcID, statusCode
FCRelFinCompIDStatfinancialCompID, statusCode, typeCode
Operations (5)
OperationStereotypeOptionsDescriptionSQL
insertinsert Standard Operation 
readByStatusRelatedFCidnsread To get a primary Financial Component ID for a secondary financial component ID with a particular statusCode. 
modifyStatusEndDatensmodifyOPTIMISTIC_LOCKING: yes
Updates the statusCode and endDate on a financial component relationship record. 
searchByStatusFinCompIDnsreadmulti To get a list of related FC ID's for a primary financial component ID with a particular status. 
readRelatedFCidnsread To get the primary Financial Component ID for a secondary financial component ID. 
Related Pages (22)