[Home] [Help] [Dependency Information]
Object Name: | GHR_MASS_TRANSFERS |
---|---|
Object Type: | TABLE |
Owner: | HR |
FND Design Data: | GHR.GHR_MASS_TRANSFERS |
Subobject Name: | |
Status: | VALID |
GHR_MASS_TRANSFERS stores criteria and status for a mass transfer
action.
Tablespace: | APPS_TS_INTERFACE |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
GHR_MASS_TRANSFERS_PK | NORMAL | UNIQUE | APPS_TS_INTERFACE | MASS_TRANSFER_ID |
GHR_MASS_TRANSFERS_UK | NORMAL | UNIQUE | APPS_TS_INTERFACE |
NAME
TRANSFER_TYPE |
GHR_MASS_TRANSFERS_FK1 | NORMAL | NONUNIQUE | APPS_TS_INTERFACE | OLD_ORGANIZATION_ID |
GHR_MASS_TRANSFERS_FK3 | NORMAL | NONUNIQUE | APPS_TS_INTERFACE | OLD_ORG_STRUCTURE_VERSION_ID |
GHR_MASS_TRANSFERS_FK4 | NORMAL | NONUNIQUE | APPS_TS_INTERFACE | OLD_POS_STRUCTURE_VERSION_ID |
GHR_MASS_TRANSFERS_FK5 | NORMAL | NONUNIQUE | APPS_TS_INTERFACE | PERSONNEL_OFFICE_ID |
GHR_MASS_TRANSFERS_FK6 | NORMAL | NONUNIQUE | APPS_TS_INTERFACE | PA_REQUEST_ID |
Table | |
Foreign Table | Foreign Key Column | GHR_MASS_TRANSFERS | GHR_PA_REQUESTS | GHR_MASS_TRANSFERS PA_REQUEST_ID | GHR_MASS_TRANSFERS | GHR_POIS | GHR_MASS_TRANSFERS PERSONNEL_OFFICE_ID | GHR_MASS_TRANSFERS | HR_ALL_ORGANIZATION_UNITS | GHR_MASS_TRANSFERS OLD_ORGANIZATION_ID | GHR_MASS_TRANSFERS | PER_ORG_STRUCTURE_VERSIONS | GHR_MASS_TRANSFERS OLD_ORG_STRUCTURE_VERSION_ID | GHR_MASS_TRANSFERS | PER_POS_STRUCTURE_VERSIONS | GHR_MASS_TRANSFERS OLD_POS_STRUCTURE_VERSION_ID | GHR_MASS_TRANSFER_CRITERIA | GHR_MASS_TRANSFERS | GHR_MASS_TRANSFER_CRITERIA MASS_TRANSFER_ID |
---|
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
MASS_TRANSFER_ID | NUMBER | (15) | Yes | Primary key generated from sequence GHR_MASS_TRANSFERS_S |
EFFECTIVE_DATE | DATE | Yes | Effective Date of mass transfer | |
INTERFACE_FLAG | VARCHAR2 | (1) | Interface information required or not. | |
NAME | VARCHAR2 | (32) | Yes | User defined name for mass transfer |
REASON | VARCHAR2 | (2000) | Reason for de-selecting | |
STATUS | VARCHAR2 | (1) | Yes | Current status of mass transfer e.g. E(rror), P(rocessed) |
PA_REQUEST_ID | NUMBER | (15) | Foreign key to GHR_PA_REQUESTS | |
TRANSFER_TYPE | VARCHAR2 | (30) | Yes | IN or OUT |
WITHIN_BG_TRANSFER | VARCHAR2 | (1) | Within Business group transfer (Y/N) | |
AGENCY_CODE_SUBELEMENT | VARCHAR2 | (30) | Agency Code / Sub-element | |
DUTY_STATION_CODE | VARCHAR2 | (9) | Duty station code as defined by OPM | |
DUTY_STATION_ID | NUMBER | (15) | Reference to GHR_DUTY_STATIONS_F | |
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 | |
TO_AGENCY_CODE_SUBELEMENT | VARCHAR2 | (30) | Agency Code / Sub-element | |
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 of the Record |
Cut, paste (and edit) the following text to query this object:
SELECT MASS_TRANSFER_ID
, EFFECTIVE_DATE
, INTERFACE_FLAG
, NAME
, REASON
, STATUS
, PA_REQUEST_ID
, TRANSFER_TYPE
, WITHIN_BG_TRANSFER
, AGENCY_CODE_SUBELEMENT
, DUTY_STATION_CODE
, DUTY_STATION_ID
, 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
, TO_AGENCY_CODE_SUBELEMENT
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, BUSINESS_GROUP_ID
FROM HR.GHR_MASS_TRANSFERS;
HR.GHR_MASS_TRANSFERS does not reference any database object
HR.GHR_MASS_TRANSFERS is referenced by following:
|
|
|