This table stores deflated structure of organization hierarchy.
Module: Grants Management
CHILD_ORGANIZATION_ID, TREE_STRUCTURE_CODE, TREE_CODE, PARENT_ORGANIZATION_ID, TREE_VERSION_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 | 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, 2023, Oracle and/or its affiliates.