[Home] [Help] [Dependency Information]
Object Name: | GHR_MASS_REALIGNMENT |
---|---|
Object Type: | TABLE |
Owner: | HR |
FND Design Data: | GHR.GHR_MASS_REALIGNMENT |
Subobject Name: | |
Status: | VALID |
GHR_MASS_REALIGNMENT is used to store criteria for mass realignment.
It is also used to store the target information for employee
/ position.
Tablespace: | APPS_TS_INTERFACE |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
GHR_MASS_REALIGNMENT_PK | NORMAL | UNIQUE | APPS_TS_INTERFACE | MASS_REALIGNMENT_ID |
GHR_MASS_REALIGNMENT_UK | NORMAL | UNIQUE | APPS_TS_INTERFACE | NAME |
GHR_MASS_REALIGNMENT_FK1 | NORMAL | NONUNIQUE | APPS_TS_INTERFACE | OLD_ORGANIZATION_ID |
GHR_MASS_REALIGNMENT_FK2 | NORMAL | NONUNIQUE | APPS_TS_INTERFACE | NEW_ORGANIZATION_ID |
GHR_MASS_REALIGNMENT_FK4 | NORMAL | NONUNIQUE | APPS_TS_INTERFACE | OLD_ORG_STRUCTURE_VERSION_ID |
GHR_MASS_REALIGNMENT_FK5 | NORMAL | NONUNIQUE | APPS_TS_INTERFACE | OLD_POS_STRUCTURE_VERSION_ID |
GHR_MASS_REALIGNMENT_FK6 | NORMAL | NONUNIQUE | APPS_TS_INTERFACE | TARGET_PERSONNEL_OFFICE_ID |
GHR_MASS_REALIGNMENT_FK7 | NORMAL | NONUNIQUE | APPS_TS_INTERFACE | PERSONNEL_OFFICE_ID |
GHR_MASS_REALIGNMENT_FK8 | NORMAL | NONUNIQUE | APPS_TS_INTERFACE | TARGET_POSITION_ORG_ID |
GHR_MASS_REALIGNMENT_FK9 | NORMAL | NONUNIQUE | APPS_TS_INTERFACE | PA_REQUEST_ID |
Table | |
Foreign Table | Foreign Key Column | GHR_MASS_REALIGNMENT | GHR_PA_REQUESTS | GHR_MASS_REALIGNMENT PA_REQUEST_ID | GHR_MASS_REALIGNMENT | GHR_POIS | GHR_MASS_REALIGNMENT TARGET_PERSONNEL_OFFICE_ID | GHR_MASS_REALIGNMENT | GHR_POIS | GHR_MASS_REALIGNMENT PERSONNEL_OFFICE_ID | GHR_MASS_REALIGNMENT | HR_ALL_ORGANIZATION_UNITS | GHR_MASS_REALIGNMENT OLD_ORGANIZATION_ID | GHR_MASS_REALIGNMENT | HR_ALL_ORGANIZATION_UNITS | GHR_MASS_REALIGNMENT TARGET_POSITION_ORG_ID | GHR_MASS_REALIGNMENT | HR_ALL_ORGANIZATION_UNITS | GHR_MASS_REALIGNMENT NEW_ORGANIZATION_ID | GHR_MASS_REALIGNMENT | PER_ORG_STRUCTURE_VERSIONS | GHR_MASS_REALIGNMENT OLD_ORG_STRUCTURE_VERSION_ID |
---|
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
MASS_REALIGNMENT_ID | NUMBER | (15) | Yes | Primary key generated from sequence GHR_MASS_REALIGNMENT_S |
EFFECTIVE_DATE | DATE | Yes | Effective Date of mass realignment | |
NAME | VARCHAR2 | (32) | Yes | User defined name for mass realignment |
REASON | VARCHAR2 | (2000) | Reason for de-selecting | |
STATUS | VARCHAR2 | (1) | Yes | Current status of mass realignment e.g. E(rror), P(rocessed) |
PA_REQUEST_ID | NUMBER | (15) | Foreign key to GHR_PA_REQUESTS | |
NEW_ORGANIZATION_ID | NUMBER | (15) | Yes | Foreign Key to HR_ORGANIZATION_UNITS |
AGENCY_CODE_SUBELEMENT | VARCHAR2 | (30) | Agency Code / Sub-element | |
NEW_ORGANIZATION_NAME | VARCHAR2 | (240) | Organization Name | |
OLD_ORGANIZATION_ID | NUMBER | (15) | Foreign Key to HR_ORGANIZATION_UNITS | |
OLD_ORGANIZATION_NAME | VARCHAR2 | (240) | Organization Name | |
OLD_ORG_STRUCTURE_VERSION_ID | NUMBER | (15) | Organization hierarchy's version | |
OLD_ORG_STRUCTURE_NAME | VARCHAR2 | (30) | Organization hierarchy's name | |
OLD_POSITION_ID | NUMBER | (15) | Foreign key to PER_POSITIONS | |
OLD_POSITION_NAME | VARCHAR2 | (240) | Position Name | |
OLD_POS_STRUCTURE_VERSION_ID | NUMBER | (15) | Position hierarchy version | |
OLD_POS_STRUCTURE_NAME | VARCHAR2 | (30) | Position hierarchy name | |
ORG_STRUCTURE_ID | VARCHAR2 | (20) | Organization structure Id | |
OFFICE_SYMBOL | VARCHAR2 | (18) | Office Symbol | |
PERSONNEL_OFFICE_ID | VARCHAR2 | (4) | Personnel Office Id | |
TARGET_AGENCY_CODE_SUBELEMENT | VARCHAR2 | (30) | Agency Code / Sub-element | |
TARGET_APPROPRIATION_CODE1 | VARCHAR2 | (30) | First appropration code | |
TARGET_APPROPRIATION_CODE2 | VARCHAR2 | (30) | Second appropration code | |
TARGET_DUTY_STN_LOCATION_ID | NUMBER | (15) | Location Id of duty station | |
TARGET_DUTY_STATION_ID | NUMBER | (15) | Duty Station Id | |
TARGET_DUTY_STATION_CODE | VARCHAR2 | (9) | Duty station code as defined by OPM | |
TARGET_OFFICE_SYMBOL | VARCHAR2 | (18) | Office Symbol | |
TARGET_ORG_FUNCTION_CODE | VARCHAR2 | (30) | Organization functional code | |
TARGET_PAYROLL_OFFICE_ID | VARCHAR2 | (30) | Payroll office Id | |
TARGET_PERSONNEL_OFFICE_ID | VARCHAR2 | (4) | Personnel Office Id | |
TARGET_POSITION_ORG_ID | NUMBER | (15) | Position's organization Id | |
TARGET_POSITION_ORG_NAME | VARCHAR2 | (240) | Organization Name | |
CREATED_BY | NUMBER | (15) | Yes | Standard who column. |
CREATION_DATE | DATE | Yes | Standard who column. | |
LAST_UPDATED_BY | NUMBER | (15) | Yes | Standard who column. |
LAST_UPDATE_DATE | DATE | Yes | Standard who column. | |
LAST_UPDATE_LOGIN | NUMBER | (15) | Standard who column. | |
BUSINESS_GROUP_ID | NUMBER | (15) | Business Group ID |
Cut, paste (and edit) the following text to query this object:
SELECT MASS_REALIGNMENT_ID
, EFFECTIVE_DATE
, NAME
, REASON
, STATUS
, PA_REQUEST_ID
, NEW_ORGANIZATION_ID
, AGENCY_CODE_SUBELEMENT
, NEW_ORGANIZATION_NAME
, OLD_ORGANIZATION_ID
, OLD_ORGANIZATION_NAME
, OLD_ORG_STRUCTURE_VERSION_ID
, OLD_ORG_STRUCTURE_NAME
, OLD_POSITION_ID
, OLD_POSITION_NAME
, OLD_POS_STRUCTURE_VERSION_ID
, OLD_POS_STRUCTURE_NAME
, ORG_STRUCTURE_ID
, OFFICE_SYMBOL
, PERSONNEL_OFFICE_ID
, TARGET_AGENCY_CODE_SUBELEMENT
, TARGET_APPROPRIATION_CODE1
, TARGET_APPROPRIATION_CODE2
, TARGET_DUTY_STN_LOCATION_ID
, TARGET_DUTY_STATION_ID
, TARGET_DUTY_STATION_CODE
, TARGET_OFFICE_SYMBOL
, TARGET_ORG_FUNCTION_CODE
, TARGET_PAYROLL_OFFICE_ID
, TARGET_PERSONNEL_OFFICE_ID
, TARGET_POSITION_ORG_ID
, TARGET_POSITION_ORG_NAME
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, BUSINESS_GROUP_ID
FROM HR.GHR_MASS_REALIGNMENT;
HR.GHR_MASS_REALIGNMENT does not reference any database object
HR.GHR_MASS_REALIGNMENT is referenced by following:
|
|
|