eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

DBA Data [Home] [Help] [Dependency Information]

TABLE: HR.GHR_MASS_SALARIES

Object Details

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.

Storage Details

Tablespace:	APPS_TS_INTERFACE
PCT Free:	10
PCT Used:

Primary Key: GHR_MASS_SALARIES_PK

MASS_SALARY_ID

Unique Key: GHR_MASS_SALARIES_UK

NAME

Indexes

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

Foreign Keys

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

Columns

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

Query Text

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;

Dependencies

[top of page]

HR.GHR_MASS_SALARIES does not reference any database object

HR.GHR_MASS_SALARIES is referenced by following:

APPS: GHR_MASS_SALARIES; GHR_MASS_SALARIES_WHO
PUBLIC: GHR_MASS_SALARIES