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]

VIEW: HR.GHR_MASS_ACTIONS_PREVIEW#

Object Details

Object Name:	GHR_MASS_ACTIONS_PREVIEW#
Object Type:	VIEW
Owner:	HR
Subobject Name:
Status:	VALID

[View Source]

Columns

Name	Datatype	Length	Mandatory
MASS_ACTION_PREVIEW_ID	NUMBER	(15)	Yes
SESSION_ID	NUMBER	(9)	Yes
EFFECTIVE_DATE	DATE		Yes
UI_TYPE	VARCHAR2	(10)	Yes
AGENCY_CODE	VARCHAR2	(30)
AGENCY_DESC	VARCHAR2	(80)
AGENCY_CODE_TRANSFER_FROM	VARCHAR2	(30)
AGENCY_CODE_TRANSFER_TO	VARCHAR2	(30)
DUTY_STATION_CODE	VARCHAR2	(9)
DUTY_STATION_DESC	VARCHAR2	(150)
EMPLOYEE_DATE_OF_BIRTH	DATE
FIRST_ACTION_LA_CODE1	VARCHAR2	(30)
FIRST_ACTION_LA_CODE2	VARCHAR2	(30)
FIRST_NOA_CODE	VARCHAR2	(4)
FIRST_NOA_CODE_DESC	VARCHAR2	(240)
FROM_BASIC_PAY	NUMBER	(15)
FROM_TOTAL_SALARY	NUMBER	(15)
FROM_LOCALITY_ADJ	NUMBER	(15)
FROM_OTHER_PAY	NUMBER	(15)
FROM_AVAILABILITY_PAY	NUMBER	(15)
FROM_AUO_PAY	NUMBER	(15)
FULL_NAME	VARCHAR2	(240)
GRADE_OR_LEVEL	VARCHAR2	(30)
MASS_ACTION_TYPE	VARCHAR2	(30)
NATIONAL_IDENTIFIER	VARCHAR2	(30)
OCC_CODE	VARCHAR2	(30)
OFFICE_SYMBOL	VARCHAR2	(30)
ORG_STRUCTURE_ID	VARCHAR2	(30)
ORGANIZATION_ID	NUMBER	(15)
ORGANIZATION_NAME	VARCHAR2	(240)
PAY_PLAN	VARCHAR2	(2)
PAY_PLAN_DESC	VARCHAR2	(80)
PAY_RATE_DETERMINANT	VARCHAR2	(30)
PERSONNEL_OFFICE_ID	VARCHAR2	(4)
PERSON_ID	NUMBER	(10)
POSITION_TITLE	VARCHAR2	(240)
POSITION_ID	NUMBER	(15)
POSITION_NUMBER	VARCHAR2	(15)
POSITION_SEQ_NO	NUMBER	(15)
POSITIONS_ORGANIZATION	NUMBER	(15)
POSITIONS_ORGANIZATION_NAME	VARCHAR2	(240)
POI_DESC	VARCHAR2	(80)
REPORT_TYPE	VARCHAR2	(30)
SELECT_FLAG	VARCHAR2	(1)
STEP_OR_RATE	VARCHAR2	(30)
TENURE	VARCHAR2	(30)
TO_TOTAL_SALARY	NUMBER	(15)
TO_LOCALITY_ADJ	NUMBER	(15)
TO_BASIC_PAY	NUMBER	(15)
TO_OTHER_PAY	NUMBER	(15)
TO_AVAILABILITY_PAY	NUMBER	(15)
TO_AUO_PAY	NUMBER	(15)
TO_PERSONNEL_OFFICE_ID	VARCHAR2	(30)
TO_POI_DESC	VARCHAR2	(80)
TO_AGENCY_CODE	VARCHAR2	(30)
TO_AGENCY_DESC	VARCHAR2	(80)
TO_DUTY_STATION_ID	VARCHAR2	(9)
TO_DUTY_STATION_CODE	VARCHAR2	(9)
TO_DUTY_STATION_DESC	VARCHAR2	(150)
TO_OFFICE_SYMBOL	VARCHAR2	(30)
TO_PAYROLL_OFFICE_ID	VARCHAR2	(30)
TO_ORG_FUNC_CODE	VARCHAR2	(30)
TO_APPROPRIATION_CODE1	VARCHAR2	(30)
TO_APPROPRIATION_CODE1_DESC	VARCHAR2	(80)
TO_APPROPRIATION_CODE2	VARCHAR2	(30)
TO_APPROPRIATION_CODE2_DESC	VARCHAR2	(80)
TO_POSITIONS_ORGANIZATION	NUMBER	(15)
TO_POSITIONS_ORG_NAME	VARCHAR2	(240)
USER_ATTRIBUTE1	VARCHAR2	(255)
USER_ATTRIBUTE2	VARCHAR2	(255)
USER_ATTRIBUTE3	VARCHAR2	(255)
USER_ATTRIBUTE4	VARCHAR2	(255)
USER_ATTRIBUTE5	VARCHAR2	(255)
USER_ATTRIBUTE6	VARCHAR2	(255)
USER_ATTRIBUTE7	VARCHAR2	(255)
USER_ATTRIBUTE8	VARCHAR2	(255)
USER_ATTRIBUTE9	VARCHAR2	(255)
USER_ATTRIBUTE10	VARCHAR2	(255)
USER_ATTRIBUTE11	VARCHAR2	(255)
USER_ATTRIBUTE12	VARCHAR2	(255)
USER_ATTRIBUTE13	VARCHAR2	(255)
USER_ATTRIBUTE14	VARCHAR2	(255)
USER_ATTRIBUTE15	VARCHAR2	(255)
USER_ATTRIBUTE16	VARCHAR2	(255)
USER_ATTRIBUTE17	VARCHAR2	(255)
USER_ATTRIBUTE18	VARCHAR2	(255)
USER_ATTRIBUTE19	VARCHAR2	(255)
USER_ATTRIBUTE20	VARCHAR2	(255)
LAST_UPDATE_DATE	DATE		Yes
LAST_UPDATE_LOGIN	NUMBER	(15)	Yes
CREATED_BY	NUMBER	(15)
CREATION_DATE	DATE		Yes
LAST_UPDATED_BY	NUMBER	(15)	Yes
FROM_ADJ_BASIC_PAY	NUMBER	(15)
FROM_SUPERVISORY_DIFFERENTIAL	NUMBER	(15)
FROM_CAPPED_OTHER_PAY	NUMBER	(15)
USER_ATTRIBUTE22	VARCHAR2	(255)
USER_ATTRIBUTE23	VARCHAR2	(255)
FROM_RETENTION_ALLOWANCE	NUMBER	(15)
TO_ADJ_BASIC_PAY	NUMBER	(15)
TO_CAPPED_OTHER_PAY	NUMBER	(15)
TO_SUPERVISORY_DIFFERENTIAL	NUMBER	(15)
TO_POSITION_ORG_STRUCTURE_ID	VARCHAR2	(20)
TO_RETENTION_ALLOWANCE	NUMBER	(15)
USER_ATTRIBUTE25	VARCHAR2	(255)
USER_ATTRIBUTE26	VARCHAR2	(255)
USER_ATTRIBUTE27	VARCHAR2	(255)
USER_ATTRIBUTE28	VARCHAR2	(255)
USER_ATTRIBUTE29	VARCHAR2	(255)
USER_ATTRIBUTE30	VARCHAR2	(255)
USER_ATTRIBUTE21	VARCHAR2	(255)
USER_ATTRIBUTE24	VARCHAR2	(255)
INCREASE_PERCENT	NUMBER	(7)
INPUT_PAY_RATE_DETERMINANT	VARCHAR2	(30)
FROM_PAY_TABLE_IDENTIFIER	NUMBER	(9)
TO_PAY_TABLE_IDENTIFIER	NUMBER	(9)
EMPLOYEE_NUMBER	VARCHAR2	(30)

Query Text

Cut, paste (and edit) the following text to query this object:


SELECT MASS_ACTION_PREVIEW_ID
,      SESSION_ID
,      EFFECTIVE_DATE
,      UI_TYPE
,      AGENCY_CODE
,      AGENCY_DESC
,      AGENCY_CODE_TRANSFER_FROM
,      AGENCY_CODE_TRANSFER_TO
,      DUTY_STATION_CODE
,      DUTY_STATION_DESC
,      EMPLOYEE_DATE_OF_BIRTH
,      FIRST_ACTION_LA_CODE1
,      FIRST_ACTION_LA_CODE2
,      FIRST_NOA_CODE
,      FIRST_NOA_CODE_DESC
,      FROM_BASIC_PAY
,      FROM_TOTAL_SALARY
,      FROM_LOCALITY_ADJ
,      FROM_OTHER_PAY
,      FROM_AVAILABILITY_PAY
,      FROM_AUO_PAY
,      FULL_NAME
,      GRADE_OR_LEVEL
,      MASS_ACTION_TYPE
,      NATIONAL_IDENTIFIER
,      OCC_CODE
,      OFFICE_SYMBOL
,      ORG_STRUCTURE_ID
,      ORGANIZATION_ID
,      ORGANIZATION_NAME
,      PAY_PLAN
,      PAY_PLAN_DESC
,      PAY_RATE_DETERMINANT
,      PERSONNEL_OFFICE_ID
,      PERSON_ID
,      POSITION_TITLE
,      POSITION_ID
,      POSITION_NUMBER
,      POSITION_SEQ_NO
,      POSITIONS_ORGANIZATION
,      POSITIONS_ORGANIZATION_NAME
,      POI_DESC
,      REPORT_TYPE
,      SELECT_FLAG
,      STEP_OR_RATE
,      TENURE
,      TO_TOTAL_SALARY
,      TO_LOCALITY_ADJ
,      TO_BASIC_PAY
,      TO_OTHER_PAY
,      TO_AVAILABILITY_PAY
,      TO_AUO_PAY
,      TO_PERSONNEL_OFFICE_ID
,      TO_POI_DESC
,      TO_AGENCY_CODE
,      TO_AGENCY_DESC
,      TO_DUTY_STATION_ID
,      TO_DUTY_STATION_CODE
,      TO_DUTY_STATION_DESC
,      TO_OFFICE_SYMBOL
,      TO_PAYROLL_OFFICE_ID
,      TO_ORG_FUNC_CODE
,      TO_APPROPRIATION_CODE1
,      TO_APPROPRIATION_CODE1_DESC
,      TO_APPROPRIATION_CODE2
,      TO_APPROPRIATION_CODE2_DESC
,      TO_POSITIONS_ORGANIZATION
,      TO_POSITIONS_ORG_NAME
,      USER_ATTRIBUTE1
,      USER_ATTRIBUTE2
,      USER_ATTRIBUTE3
,      USER_ATTRIBUTE4
,      USER_ATTRIBUTE5
,      USER_ATTRIBUTE6
,      USER_ATTRIBUTE7
,      USER_ATTRIBUTE8
,      USER_ATTRIBUTE9
,      USER_ATTRIBUTE10
,      USER_ATTRIBUTE11
,      USER_ATTRIBUTE12
,      USER_ATTRIBUTE13
,      USER_ATTRIBUTE14
,      USER_ATTRIBUTE15
,      USER_ATTRIBUTE16
,      USER_ATTRIBUTE17
,      USER_ATTRIBUTE18
,      USER_ATTRIBUTE19
,      USER_ATTRIBUTE20
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      FROM_ADJ_BASIC_PAY
,      FROM_SUPERVISORY_DIFFERENTIAL
,      FROM_CAPPED_OTHER_PAY
,      USER_ATTRIBUTE22
,      USER_ATTRIBUTE23
,      FROM_RETENTION_ALLOWANCE
,      TO_ADJ_BASIC_PAY
,      TO_CAPPED_OTHER_PAY
,      TO_SUPERVISORY_DIFFERENTIAL
,      TO_POSITION_ORG_STRUCTURE_ID
,      TO_RETENTION_ALLOWANCE
,      USER_ATTRIBUTE25
,      USER_ATTRIBUTE26
,      USER_ATTRIBUTE27
,      USER_ATTRIBUTE28
,      USER_ATTRIBUTE29
,      USER_ATTRIBUTE30
,      USER_ATTRIBUTE21
,      USER_ATTRIBUTE24
,      INCREASE_PERCENT
,      INPUT_PAY_RATE_DETERMINANT
,      FROM_PAY_TABLE_IDENTIFIER
,      TO_PAY_TABLE_IDENTIFIER
,      EMPLOYEE_NUMBER
FROM HR.GHR_MASS_ACTIONS_PREVIEW#;

Dependencies

[top of page]

HR.GHR_MASS_ACTIONS_PREVIEW# references the following:

HR: GHR_MASS_ACTIONS_PREVIEW

HR.GHR_MASS_ACTIONS_PREVIEW# is referenced by following:

APPS: GHR_MASS_ACTIONS_PREVIEW; GHR_MASS_ACTIONS_PREVIEW_INS; GHR_MASS_ACTIONS_PREVIEW_WHO