[Home] [Help] [Dependency Information]
Object Name: | GHR_MASS_SALARIES |
---|---|
Object Type: | TABLE |
Owner: | HR |
FND Design Data: | GHR.GHR_MASS_SALARIES |
Subobject Name: | |
Status: | VALID |
GHR_MASS_SALARIES table stores the criteria and status for mass salary
action.
Tablespace: | APPS_TS_INTERFACE |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
GHR_MASS_SALARIES_PK | NORMAL | UNIQUE | APPS_TS_INTERFACE | MASS_SALARY_ID |
GHR_MASS_SALARIES_UK | NORMAL | UNIQUE | APPS_TS_INTERFACE | NAME |
GHR_MASS_SALARIES_FK1 | NORMAL | NONUNIQUE | APPS_TS_INTERFACE | PA_REQUEST_ID |
GHR_MASS_SALARIES_FK2 | NORMAL | NONUNIQUE | APPS_TS_INTERFACE | ORGANIZATION_ID |
GHR_MASS_SALARIES_FK3 | NORMAL | NONUNIQUE | APPS_TS_INTERFACE | PERSONNEL_OFFICE_ID |
Table | |
Foreign Table | Foreign Key Column | GHR_MASS_SALARIES | GHR_PA_REQUESTS | GHR_MASS_SALARIES PA_REQUEST_ID | GHR_MASS_SALARIES | GHR_POIS | GHR_MASS_SALARIES PERSONNEL_OFFICE_ID | GHR_MASS_SALARIES | HR_ALL_ORGANIZATION_UNITS | GHR_MASS_SALARIES ORGANIZATION_ID | GHR_MASS_SALARY_CRITERIA | GHR_MASS_SALARIES | GHR_MASS_SALARY_CRITERIA MASS_SALARY_ID |
---|
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
MASS_SALARY_ID | NUMBER | Yes | Primary key generated from sequence GHR_MASS_SALARIES_S. | |
NAME | VARCHAR2 | (30) | Yes | Name for the mass salary. |
PA_REQUEST_ID | NUMBER | (15) | Foreign key to GHR_PA_REQUESTS | |
EFFECTIVE_DATE | DATE | Yes | Effective date for mass salary change. | |
EXECUTIVE_ORDER_NUMBER | VARCHAR2 | (15) | Executive order number. | |
EXECUTIVE_ORDER_DATE | DATE | Date of the executive order. | ||
USER_TABLE_ID | NUMBER | (9) | Pay table id. | |
ORGANIZATION_ID | NUMBER | (15) | Foreign key to HR_ORGANIZATION_UNITS | |
DUTY_STATION_ID | NUMBER | (15) | Reference to GHR_DUTY_STATIONS_F | |
PERSONNEL_OFFICE_ID | VARCHAR2 | (4) | Personnel Office Id | |
AGENCY_CODE_SUBELEMENT | VARCHAR2 | (30) | Agency Code / Sub-element | |
SUBMIT_FLAG | VARCHAR2 | (1) | Indicates whether the mass salary has been submitted or processed. | |
OPM_ISSUANCE_NUMBER | VARCHAR2 | (15) | OPM Issuance Number | |
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. | |
OPM_ISSUANCE_DATE | DATE | OPM Issuance Date | ||
BUSINESS_GROUP_ID | NUMBER | (15) | Business Group ID | |
PROCESS_TYPE | VARCHAR2 | (1) | Process Type | |
LOCALITY_PAY_AREA_CODE | VARCHAR2 | (2) | Locality Pay Area |
Cut, paste (and edit) the following text to query this object:
SELECT MASS_SALARY_ID
, NAME
, PA_REQUEST_ID
, EFFECTIVE_DATE
, EXECUTIVE_ORDER_NUMBER
, EXECUTIVE_ORDER_DATE
, USER_TABLE_ID
, ORGANIZATION_ID
, DUTY_STATION_ID
, PERSONNEL_OFFICE_ID
, AGENCY_CODE_SUBELEMENT
, SUBMIT_FLAG
, OPM_ISSUANCE_NUMBER
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, OPM_ISSUANCE_DATE
, BUSINESS_GROUP_ID
, PROCESS_TYPE
, LOCALITY_PAY_AREA_CODE
FROM HR.GHR_MASS_SALARIES;
HR.GHR_MASS_SALARIES does not reference any database object
HR.GHR_MASS_SALARIES is referenced by following:
|
|
|