[Home] [Help] [Dependency Information]
Object Name: | PER_ORG_STRUCTURE_VERSIONS |
---|---|
Object Type: | TABLE |
Owner: | HR |
FND Design Data: | PER.PER_ORG_STRUCTURE_VERSIONS |
Subobject Name: | |
Status: | VALID |
PER_ORG_STRUCTURE_VERSIONS holds information about different versions
of an organization hierarchy, including version number with start and
end dates, and whether the current version has been copied from an
existing version. Only one version of a specific organization
hierarchy can exist at any one time.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
PER_ORG_STRUCTURE_VERSIONS_PK | NORMAL | UNIQUE | APPS_TS_TX_IDX | ORG_STRUCTURE_VERSION_ID |
PER_ORG_STRUCTURE_VERSIONS_FK1 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | BUSINESS_GROUP_ID |
PER_ORG_STRUCTURE_VERSIONS_FK2 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | ORGANIZATION_STRUCTURE_ID |
Table | |
Foreign Table | Foreign Key Column | PER_ORG_STRUCTURE_VERSIONS | HR_ALL_ORGANIZATION_UNITS | PER_ORG_STRUCTURE_VERSIONS BUSINESS_GROUP_ID | PER_ORG_STRUCTURE_VERSIONS | PER_ORGANIZATION_STRUCTURES | PER_ORG_STRUCTURE_VERSIONS ORGANIZATION_STRUCTURE_ID | GHR_MASS_REALIGNMENT | PER_ORG_STRUCTURE_VERSIONS | GHR_MASS_REALIGNMENT OLD_ORG_STRUCTURE_VERSION_ID | GHR_MASS_TRANSFERS | PER_ORG_STRUCTURE_VERSIONS | GHR_MASS_TRANSFERS OLD_ORG_STRUCTURE_VERSION_ID | PER_ORG_STRUCTURE_ELEMENTS | PER_ORG_STRUCTURE_VERSIONS | PER_ORG_STRUCTURE_ELEMENTS ORG_STRUCTURE_VERSION_ID |
---|
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ORG_STRUCTURE_VERSION_ID | NUMBER | Yes | Primary key from PER_ORG_STRUCTURE_VERSIONS_S. | |
BUSINESS_GROUP_ID | NUMBER | (15) | Foreign key to HR_ORGANIZATION_UNITS. | |
ORGANIZATION_STRUCTURE_ID | NUMBER | (15) | Yes | Foreign key to PER_ORGANIZATION_STRUCTURES. |
DATE_FROM | DATE | Yes | Start date of this version. | |
VERSION_NUMBER | NUMBER | Yes | User enterable version number, not necessarily contiguous. | |
COPY_STRUCTURE_VERSION_ID | NUMBER | (15) | Foreign key to PER_ORG_STRUCTURE_VERSIONS. Used if this version is copied from a previously existing structure. | |
DATE_TO | DATE | End date of this version. | ||
REQUEST_ID | NUMBER | (15) | Standard Who Column. | |
PROGRAM_APPLICATION_ID | NUMBER | (15) | Standard Who column. | |
PROGRAM_ID | NUMBER | (15) | Standard Who Column. | |
PROGRAM_UPDATE_DATE | DATE | Standard Who column. | ||
LAST_UPDATE_DATE | DATE | Standard Who column. | ||
LAST_UPDATED_BY | NUMBER | (15) | Standard Who column. | |
LAST_UPDATE_LOGIN | NUMBER | (15) | Standard Who column. | |
CREATED_BY | NUMBER | (15) | Standard Who column. | |
CREATION_DATE | DATE | Standard Who column. | ||
OBJECT_VERSION_NUMBER | NUMBER | (9) | Yes | System-generated version of row. Increments by one with each update. |
TOPNODE_POS_CTRL_ENABLED_FLAG | VARCHAR2 | (10) | Indicates top node position controlled hierarchy |
Cut, paste (and edit) the following text to query this object:
SELECT ORG_STRUCTURE_VERSION_ID
, BUSINESS_GROUP_ID
, ORGANIZATION_STRUCTURE_ID
, DATE_FROM
, VERSION_NUMBER
, COPY_STRUCTURE_VERSION_ID
, DATE_TO
, REQUEST_ID
, PROGRAM_APPLICATION_ID
, PROGRAM_ID
, PROGRAM_UPDATE_DATE
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
, CREATED_BY
, CREATION_DATE
, OBJECT_VERSION_NUMBER
, TOPNODE_POS_CTRL_ENABLED_FLAG
FROM HR.PER_ORG_STRUCTURE_VERSIONS;
HR.PER_ORG_STRUCTURE_VERSIONS does not reference any database object
HR.PER_ORG_STRUCTURE_VERSIONS is referenced by following:
|
|
|