This table requires activation of Grants Management functional area. This table stores deflated structure of organization hierarchy.
Module: Grants Management
TREE_STRUCTURE_CODE, CHILD_ORGANIZATION_ID, TREE_CODE, TREE_VERSION_ID, PARENT_ORGANIZATION_ID
| Name | Datatype | Length | Precision | Not Null | Comments | Referred Table | Referred Column |
|---|---|---|---|---|---|---|---|
| PARENT_ORGANIZATION_ID | NUMBER | True | Identifier of the parent organization | ||||
| CHILD_ORGANIZATION_ID | NUMBER | True | Identifier of the child organization | ||||
| TREE_STRUCTURE_CODE | VARCHAR2 | 32 | True | TREE_STRUCTURE_CODE | |||
| TREE_CODE | VARCHAR2 | 32 | True | TREE_CODE | |||
| TREE_VERSION_ID | VARCHAR2 | 64 | True | SponsorBasePEOLocNumber | |||
| SOURCE_RECORD_ID | VARCHAR2 | 256 | This column is for Oracle Internal use only. System | ||||
| OBJECT_VERSION_NUMBER | NUMBER | 38 | 0 | Used to implement optimistic locking. | |||
| PARENT_LEVEL | NUMBER | 38 | 0 | Stores the level of the parent organization | |||
| CHILD_LEVEL | NUMBER | 38 | 0 | Stores the level of the child organization | |||
| CREATION_DATE | TIMESTAMP | Who column: indicates the date and time of the creation of the row. | |||||
| LAST_UPDATE_DATE | TIMESTAMP | Who column: indicates the date and time of the last update of the row. |
Copyright © 2019, 2024, Oracle and/or its affiliates.