[Home] [Help] [Dependency Information]
Object Name: | GHR_LOCALITY_PAY_AREAS_F |
---|---|
Object Type: | TABLE |
Owner: | HR |
FND Design Data: | GHR.GHR_LOCALITY_PAY_AREAS_F |
Subobject Name: | |
Status: | VALID |
This table is a date tracked table that holds information like
name, code, adjustment percentage etc about Locality Pay Areas.
Tablespace: | APPS_TS_SEED |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
GHR_LOCALITY_PAY_AREAS_F_PK | NORMAL | UNIQUE | APPS_TS_SEED |
LOCALITY_PAY_AREA_ID
EFFECTIVE_START_DATE EFFECTIVE_END_DATE |
GHR_LOCALITY_PAY_AREAS_F_UK | NORMAL | UNIQUE | APPS_TS_SEED |
LOCALITY_PAY_AREA_CODE
EFFECTIVE_END_DATE EFFECTIVE_START_DATE |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
LOCALITY_PAY_AREA_ID | NUMBER | (15) | Yes | Primary key generated from sequence GHR_LOCALITY_PAY_AREAS_F_S. |
EFFECTIVE_START_DATE | DATE | Yes | Effective start date. | |
EFFECTIVE_END_DATE | DATE | Yes | Effective end date. | |
LOCALITY_PAY_AREA_CODE | VARCHAR2 | (2) | Yes | Locality pay area code. |
ABBREVIATION | VARCHAR2 | (3) | Yes | Abbreviation for the locality pay area. |
SHORT_NAME | VARCHAR2 | (30) | Yes | Short name for the locality pay area. |
LONG_NAME | VARCHAR2 | (80) | Long name for the locality pay area. | |
ADJUSTMENT_PERCENTAGE | NUMBER | (5) | Yes | Adjustment percentage. |
LEO_ADJUSTMENT_PERCENTAGE | NUMBER | (5) | LEO Adjustment percentage. | |
LAST_UPDATE_DATE | DATE | Yes | Standard who column. | |
LAST_UPDATE_LOGIN | NUMBER | (15) | Standard who column. | |
CREATED_BY | NUMBER | (15) | Yes | Standard who column. |
CREATION_DATE | DATE | Yes | Standard who column. | |
LAST_UPDATED_BY | NUMBER | (15) | Yes | Standard who column. |
Cut, paste (and edit) the following text to query this object:
SELECT LOCALITY_PAY_AREA_ID
, EFFECTIVE_START_DATE
, EFFECTIVE_END_DATE
, LOCALITY_PAY_AREA_CODE
, ABBREVIATION
, SHORT_NAME
, LONG_NAME
, ADJUSTMENT_PERCENTAGE
, LEO_ADJUSTMENT_PERCENTAGE
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
FROM HR.GHR_LOCALITY_PAY_AREAS_F;
HR.GHR_LOCALITY_PAY_AREAS_F does not reference any database object
HR.GHR_LOCALITY_PAY_AREAS_F is referenced by following:
|
|
|