Segment Value Column Flattened Hierarchies
The segment value column flattened hierarchies view object contains the relationship between various nodes in a given tree version in a column-flattened manner for the general ledger related tree structures. It uses the structure of the FND_TREE_NODE_CF table as a template.
Data Store Key : FscmTopModelAM.FinExtractAM.GlBiccExtractAM.SegmentValueHierarchyExtractPVO
Primary Keys : TreeStructureCode, CfTreeNodeId, EnterpriseId, TreeVersionId, TreeCode
Initial Extract Date : CreationDate
Incremental Extract Date : LastUpdateDate
Attributes
This table provides the list of exposed attributes and their descriptions.
| Name | Description |
|---|---|
| CfTreeNodeId | The identifier of the tree node. This attribute is a part of the composite key of the table FND_TREE_NODE. |
| CreatedBy | The user who created the segment value column flattened hierarchy. |
| CreationDate | The date and time when the segment value column flattened hierarchy was created. |
| Dep0DataSourceId | The identifier of the tree node data source. This attribute is a part of the composite key of the table FND_TS_DATA_SOURCE. |
| Dep0Pk1Value | The unique identifier of the tree node. This is the primary key of the Segment Value Column Flattened Hierarchies view object. |
| Dep0Pk2Value | The unique identifier of the tree node. This is the primary key of the Segment Value Column Flattened Hierarchies view object. |
| Dep10DataSourceId | The identifier of the tree node data source. This attribute is a part of the composite key of the table FND_TS_DATA_SOURCE. |
| Dep10Pk1Value | The unique identifier of the tree node. This is the primary key of the Segment Value Column Flattened Hierarchies view object. |
| Dep10Pk2Value | The unique identifier of the tree node. This is the primary key of the Segment Value Column Flattened Hierarchies view object. |
| Dep11DataSourceId | The identifier of the tree node data source. This attribute is a part of the composite key of the table FND_TS_DATA_SOURCE. |
| Dep11Pk1Value | The unique identifier of the tree node. This is the primary key of the Segment Value Column Flattened Hierarchies view object. |
| Dep11Pk2Value | The unique identifier of the tree node. This is the primary key of the Segment Value Column Flattened Hierarchies view object. |
| Dep12DataSourceId | The identifier of the tree node data source. This attribute is a part of the composite key of the table FND_TS_DATA_SOURCE. |
| Dep12Pk1Value | The unique identifier of the tree node. This is the primary key of the Segment Value Column Flattened Hierarchies view object. |
| Dep12Pk2Value | The unique identifier of the tree node. This is the primary key of the Segment Value Column Flattened Hierarchies view object. |
| Dep13DataSourceId | The identifier of the tree node data source. This attribute is a part of the composite key of the table FND_TS_DATA_SOURCE. |
| Dep13Pk1Value | The unique identifier of the tree node. This is the primary key of the Segment Value Column Flattened Hierarchies view object. |
| Dep13Pk2Value | The unique identifier of the tree node. This is the primary key of the Segment Value Column Flattened Hierarchies view object. |
| Dep14DataSourceId | The identifier of the tree node data source. This attribute is a part of the composite key of the table FND_TS_DATA_SOURCE. |
| Dep14Pk1Value | The unique identifier of the tree node. This is the primary key of the Segment Value Column Flattened Hierarchies view object. |
| Dep14Pk2Value | The unique identifier of the tree node. This is the primary key of the Segment Value Column Flattened Hierarchies view object. |
| Dep15DataSourceId | The identifier of the tree node data source. This attribute is a part of the composite key of the table FND_TS_DATA_SOURCE. |
| Dep15Pk1Value | The unique identifier of the tree node. This is the primary key of the Segment Value Column Flattened Hierarchies view object. |
| Dep15Pk2Value | The unique identifier of the tree node. This is the primary key of the Segment Value Column Flattened Hierarchies view object. |
| Dep16DataSourceId | The identifier of the tree node data source. This attribute is a part of the composite key of the table FND_TS_DATA_SOURCE. |
| Dep16Pk1Value | The unique identifier of the tree node. This is the primary key of the Segment Value Column Flattened Hierarchies view object. |
| Dep16Pk2Value | The unique identifier of the tree node. This is the primary key of the Segment Value Column Flattened Hierarchies view object. |
| Dep17DataSourceId | The identifier of the tree node data source. This attribute is a part of the composite key of the table FND_TS_DATA_SOURCE. |
| Dep17Pk1Value | The unique identifier of the tree node. This is the primary key of the Segment Value Column Flattened Hierarchies view object. |
| Dep17Pk2Value | The unique identifier of the tree node. This is the primary key of the Segment Value Column Flattened Hierarchies view object. |
| Dep18DataSourceId | The identifier of the tree node data source. This attribute is a part of the composite key of the table FND_TS_DATA_SOURCE. |
| Dep18Pk1Value | The unique identifier of the tree node. This is the primary key of the Segment Value Column Flattened Hierarchies view object. |
| Dep18Pk2Value | The unique identifier of the tree node. This is the primary key of the Segment Value Column Flattened Hierarchies view object. |
| Dep19DataSourceId | The identifier of the tree node data source. This attribute is a part of the composite key of the table FND_TS_DATA_SOURCE. |
| Dep19Pk1Value | The unique identifier of the tree node. This is the primary key of the Segment Value Column Flattened Hierarchies view object. |
| Dep19Pk2Value | The unique identifier of the tree node. This is the primary key of the Segment Value Column Flattened Hierarchies view object. |
| Dep1DataSourceId | The identifier of the tree node data source. This attribute is a part of the composite key of the table FND_TS_DATA_SOURCE. |
| Dep1Pk1Value | The unique identifier of the tree node. This is the primary key of the Segment Value Column Flattened Hierarchies view object. |
| Dep1Pk2Value | The unique identifier of the tree node. This is the primary key of the Segment Value Column Flattened Hierarchies view object. |
| Dep20DataSourceId | The identifier of the tree node data source. This attribute is a part of the composite key of the table FND_TS_DATA_SOURCE. |
| Dep20Pk1Value | The unique identifier of the tree node. This is the primary key of the Segment Value Column Flattened Hierarchies view object. |
| Dep20Pk2Value | The unique identifier of the tree node. This is the primary key of the Segment Value Column Flattened Hierarchies view object. |
| Dep21DataSourceId | The identifier of the tree node data source. This attribute is a part of the composite key of the table FND_TS_DATA_SOURCE. |
| Dep21Pk1Value | The unique identifier of the tree node. This is the primary key of the Segment Value Column Flattened Hierarchies view object. |
| Dep21Pk2Value | The unique identifier of the tree node. This is the primary key of the Segment Value Column Flattened Hierarchies view object. |
| Dep22DataSourceId | The identifier of the tree node data source. This attribute is a part of the composite key of the table FND_TS_DATA_SOURCE. |
| Dep22Pk1Value | The unique identifier of the tree node. This is the primary key of the Segment Value Column Flattened Hierarchies view object. |
| Dep22Pk2Value | The unique identifier of the tree node. This is the primary key of the Segment Value Column Flattened Hierarchies view object. |
| Dep23DataSourceId | The identifier of the tree node data source. This attribute is a part of the composite key of the table FND_TS_DATA_SOURCE. |
| Dep23Pk1Value | The unique identifier of the tree node. This is the primary key of the Segment Value Column Flattened Hierarchies view object. |
| Dep23Pk2Value | The unique identifier of the tree node. This is the primary key of the Segment Value Column Flattened Hierarchies view object. |
| Dep24DataSourceId | The identifier of the tree node data source. This attribute is a part of the composite key of the table FND_TS_DATA_SOURCE. |
| Dep24Pk1Value | The unique identifier of the tree node. This is the primary key of the Segment Value Column Flattened Hierarchies view object. |
| Dep24Pk2Value | The unique identifier of the tree node. This is the primary key of the Segment Value Column Flattened Hierarchies view object. |
| Dep25DataSourceId | The identifier of the tree node data source. This attribute is a part of the composite key of the table FND_TS_DATA_SOURCE. |
| Dep25Pk1Value | The unique identifier of the tree node. This is the primary key of the Segment Value Column Flattened Hierarchies view object. |
| Dep25Pk2Value | The unique identifier of the tree node. This is the primary key of the Segment Value Column Flattened Hierarchies view object. |
| Dep26DataSourceId | The identifier of the tree node data source. This attribute is a part of the composite key of the table FND_TS_DATA_SOURCE. |
| Dep26Pk1Value | The unique identifier of the tree node. This is the primary key of the Segment Value Column Flattened Hierarchies view object. |
| Dep26Pk2Value | The unique identifier of the tree node. This is the primary key of the Segment Value Column Flattened Hierarchies view object. |
| Dep27DataSourceId | The identifier of the tree node data source. This attribute is a part of the composite key of the table FND_TS_DATA_SOURCE. |
| Dep27Pk1Value | The unique identifier of the tree node. This is the primary key of the Segment Value Column Flattened Hierarchies view object. |
| Dep27Pk2Value | The unique identifier of the tree node. This is the primary key of the Segment Value Column Flattened Hierarchies view object. |
| Dep28DataSourceId | The identifier of the tree node data source. This attribute is a part of the composite key of the table FND_TS_DATA_SOURCE. |
| Dep28Pk1Value | The unique identifier of the tree node. This is the primary key of the Segment Value Column Flattened Hierarchies view object. |
| Dep28Pk2Value | The unique identifier of the tree node. This is the primary key of the Segment Value Column Flattened Hierarchies view object. |
| Dep29DataSourceId | The identifier of the tree node data source. This attribute is a part of the composite key of the table FND_TS_DATA_SOURCE. |
| Dep29Pk1Value | The unique identifier of the tree node. This is the primary key of the Segment Value Column Flattened Hierarchies view object. |
| Dep29Pk2Value | The unique identifier of the tree node. This is the primary key of the Segment Value Column Flattened Hierarchies view object. |
| Dep2DataSourceId | The identifier of the tree node data source. This attribute is a part of the composite key of the table FND_TS_DATA_SOURCE. |
| Dep2Pk1Value | The unique identifier of the tree node. This is the primary key of the Segment Value Column Flattened Hierarchies view object. |
| Dep2Pk2Value | The unique identifier of the tree node. This is the primary key of the Segment Value Column Flattened Hierarchies view object. |
| Dep30DataSourceId | The identifier of the tree node data source. This attribute is a part of the composite key of the table FND_TS_DATA_SOURCE. |
| Dep30Pk1Value | The unique identifier of the tree node. This is the primary key of the Segment Value Column Flattened Hierarchies view object. |
| Dep30Pk2Value | The unique identifier of the tree node. This is the primary key of the Segment Value Column Flattened Hierarchies view object. |
| Dep31DataSourceId | The identifier of the tree node data source. This attribute is a part of the composite key of the table FND_TS_DATA_SOURCE. |
| Dep31Pk1Value | The unique identifier of the tree node. This is the primary key of the Segment Value Column Flattened Hierarchies view object. |
| Dep31Pk2Value | The unique identifier of the tree node. This is the primary key of the Segment Value Column Flattened Hierarchies view object. |
| Dep3DataSourceId | The identifier of the tree node data source. This attribute is a part of the composite key of the table FND_TS_DATA_SOURCE. |
| Dep3Pk1Value | The unique identifier of the tree node. This is the primary key of the Segment Value Column Flattened Hierarchies view object. |
| Dep3Pk2Value | The unique identifier of the tree node. This is the primary key of the Segment Value Column Flattened Hierarchies view object. |
| Dep4DataSourceId | The identifier of the tree node data source. This attribute is a part of the composite key of the table FND_TS_DATA_SOURCE. |
| Dep4Pk1Value | The unique identifier of the tree node. This is the primary key of the Segment Value Column Flattened Hierarchies view object. |
| Dep4Pk2Value | The unique identifier of the tree node. This is the primary key of the Segment Value Column Flattened Hierarchies view object. |
| Dep5DataSourceId | The identifier of the tree node data source. This attribute is a part of the composite key of the table FND_TS_DATA_SOURCE. |
| Dep5Pk1Value | The unique identifier of the tree node. This is the primary key of the Segment Value Column Flattened Hierarchies view object. |
| Dep5Pk2Value | The unique identifier of the tree node. This is the primary key of the Segment Value Column Flattened Hierarchies view object. |
| Dep6DataSourceId | The identifier of the tree node data source. This attribute is a part of the composite key of the table FND_TS_DATA_SOURCE. |
| Dep6Pk1Value | The unique identifier of the tree node. This is the primary key of the Segment Value Column Flattened Hierarchies view object. |
| Dep6Pk2Value | The unique identifier of the tree node. This is the primary key of the Segment Value Column Flattened Hierarchies view object. |
| Dep7DataSourceId | The identifier of the tree node data source. This attribute is a part of the composite key of the table FND_TS_DATA_SOURCE. |
| Dep7Pk1Value | The unique identifier of the tree node. This is the primary key of the Segment Value Column Flattened Hierarchies view object. |
| Dep7Pk2Value | The unique identifier of the tree node. This is the primary key of the Segment Value Column Flattened Hierarchies view object. |
| Dep8DataSourceId | The identifier of the tree node data source. This attribute is a part of the composite key of the table FND_TS_DATA_SOURCE. |
| Dep8Pk1Value | The unique identifier of the tree node. This is the primary key of the Segment Value Column Flattened Hierarchies view object. |
| Dep8Pk2Value | The unique identifier of the tree node. This is the primary key of the Segment Value Column Flattened Hierarchies view object. |
| Dep9DataSourceId | The identifier of the tree node data source. This attribute is a part of the composite key of the table FND_TS_DATA_SOURCE. |
| Dep9Pk1Value | The unique identifier of the tree node. This is the primary key of the Segment Value Column Flattened Hierarchies view object. |
| Dep9Pk2Value | The unique identifier of the tree node. This is the primary key of the Segment Value Column Flattened Hierarchies view object. |
| Distance | The distance between the current node and the root node. |
| EnterpriseId | The identifier of an enterprise or business group. Used for multiple tenant partitioning. |
| LastUpdateDate | The date when the segment value column flattened hierarchy row was last updated. |
| LastUpdateLogin | The session login associated with the user who last updated the segment value column flattened hierarchy. |
| LastUpdatedBy | The user who last updated the segment value column flattened hierarchy row. |
| TreeCode | Indicates the tree code of the segment tree version that matches the specified primary key. This is a foreign key of the table FND_TREE. |
| TreeStructureCode | Indicates the tree structure code of the segment tree version that matches the specified primary key. This is a foreign key of the table FND_TREE_STRUCTURE. |
| TreeVersionId | The unique identifier of the segment tree version. This is a foreign key of the table FND_TREE_VERSION. |