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_RIF_REGISTERS#

Object Details

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

[View Source]

Columns

Name	Datatype	Length	Mandatory
RIF_REGISTER_ID	NUMBER	(15)	Yes
SESSION_ID	NUMBER	(9)	Yes
RIF_CRITERIA_ID	NUMBER	(15)
EFFECTIVE_DATE	DATE		Yes
PERSON_ID	NUMBER	(10)	Yes
POSITION_ID	NUMBER	(15)
FULL_NAME	VARCHAR2	(240)
LAST_NAME	VARCHAR2	(150)
FIRST_NAME	VARCHAR2	(150)
MIDDLE_NAMES	VARCHAR2	(60)
NATIONAL_IDENTIFIER	VARCHAR2	(30)
TENURE	VARCHAR2	(30)
TENURE_DESC	VARCHAR2	(80)
TENURE_GROUP	VARCHAR2	(30)
TENURE_GROUP_DESC	VARCHAR2	(80)
TENURE_GROUP_ORDER	NUMBER	(3)
VETERANS_PREF_FOR_RIF	VARCHAR2	(30)
VETERANS_PREFERENCE	VARCHAR2	(30)
VETERANS_PREFERENCE_DESC	VARCHAR2	(80)
VETERANS_PREF_SUB_GROUP	VARCHAR2	(30)
VETERANS_PREF_SUB_GROUP_DESC	VARCHAR2	(80)
VETERANS_PREF_SUB_GROUP_ORDER	NUMBER	(3)
SERVICE_COMP_DATE_RIF	DATE
PERFORMANCE_SCORE	NUMBER	(3)
ADJUSTED_SERVICE_COMP_DATE	DATE
OCC_CODE	VARCHAR2	(30)
OCC_CODE_DESC	VARCHAR2	(80)
JOB_NAME	VARCHAR2	(240)
PAY_PLAN	VARCHAR2	(30)
GRADE_OR_LEVEL	VARCHAR2	(30)
STEP_OR_RATE	VARCHAR2	(30)
WGI_DUE_DATE	DATE
ENTERED_GRADE_DATE	DATE
SERVICE_COMP_DATE_CIVILIAN	DATE
RATING_OF_RECORD1	VARCHAR2	(30)
RATING_OF_RECORD1_DESC	VARCHAR2	(80)
RATING_OF_RECORD1_DATE	DATE
RATING_OF_RECORD2	VARCHAR2	(30)
RATING_OF_RECORD2_DESC	VARCHAR2	(80)
RATING_OF_RECORD2_DATE	DATE
RATING_OF_RECORD3	VARCHAR2	(30)
RATING_OF_RECORD3_DESC	VARCHAR2	(80)
RATING_OF_RECORD3_DATE	DATE
POSITION_OCCUPIED	VARCHAR2	(30)
POSITION_OCCUPIED_DESC	VARCHAR2	(80)
POSITION_TITLE	VARCHAR2	(240)
POSITION_NAME	VARCHAR2	(240)
OBLIGATED_POSN_TYPE	VARCHAR2	(30)
OBLIGATED_POSN_TYPE_DESC	VARCHAR2	(80)
ORGANIZATION_ID	NUMBER	(15)
ORGANIZATION_NAME	VARCHAR2	(240)
ORG_STRUCTURE_ID	VARCHAR2	(20)
OFFICE_SYMBOL	VARCHAR2	(18)
AGENCY_CODE_SUBELEMENT	VARCHAR2	(30)
AGENCY_CODE_SUBELEMENT_DESC	VARCHAR2	(80)
OBLIGATED_EXPIRATION_DATE	DATE
COMP_AREA	VARCHAR2	(30)
COMP_LEVEL	VARCHAR2	(30)
CREATED_BY	NUMBER	(15)	Yes
CREATION_DATE	DATE		Yes
LAST_UPDATED_BY	NUMBER	(15)	Yes
LAST_UPDATE_DATE	DATE		Yes
LAST_UPDATE_LOGIN	NUMBER	(15)

Query Text

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


SELECT RIF_REGISTER_ID
,      SESSION_ID
,      RIF_CRITERIA_ID
,      EFFECTIVE_DATE
,      PERSON_ID
,      POSITION_ID
,      FULL_NAME
,      LAST_NAME
,      FIRST_NAME
,      MIDDLE_NAMES
,      NATIONAL_IDENTIFIER
,      TENURE
,      TENURE_DESC
,      TENURE_GROUP
,      TENURE_GROUP_DESC
,      TENURE_GROUP_ORDER
,      VETERANS_PREF_FOR_RIF
,      VETERANS_PREFERENCE
,      VETERANS_PREFERENCE_DESC
,      VETERANS_PREF_SUB_GROUP
,      VETERANS_PREF_SUB_GROUP_DESC
,      VETERANS_PREF_SUB_GROUP_ORDER
,      SERVICE_COMP_DATE_RIF
,      PERFORMANCE_SCORE
,      ADJUSTED_SERVICE_COMP_DATE
,      OCC_CODE
,      OCC_CODE_DESC
,      JOB_NAME
,      PAY_PLAN
,      GRADE_OR_LEVEL
,      STEP_OR_RATE
,      WGI_DUE_DATE
,      ENTERED_GRADE_DATE
,      SERVICE_COMP_DATE_CIVILIAN
,      RATING_OF_RECORD1
,      RATING_OF_RECORD1_DESC
,      RATING_OF_RECORD1_DATE
,      RATING_OF_RECORD2
,      RATING_OF_RECORD2_DESC
,      RATING_OF_RECORD2_DATE
,      RATING_OF_RECORD3
,      RATING_OF_RECORD3_DESC
,      RATING_OF_RECORD3_DATE
,      POSITION_OCCUPIED
,      POSITION_OCCUPIED_DESC
,      POSITION_TITLE
,      POSITION_NAME
,      OBLIGATED_POSN_TYPE
,      OBLIGATED_POSN_TYPE_DESC
,      ORGANIZATION_ID
,      ORGANIZATION_NAME
,      ORG_STRUCTURE_ID
,      OFFICE_SYMBOL
,      AGENCY_CODE_SUBELEMENT
,      AGENCY_CODE_SUBELEMENT_DESC
,      OBLIGATED_EXPIRATION_DATE
,      COMP_AREA
,      COMP_LEVEL
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
FROM HR.GHR_RIF_REGISTERS#;

Dependencies

[top of page]

HR.GHR_RIF_REGISTERS# references the following:

HR: GHR_RIF_REGISTERS

HR.GHR_RIF_REGISTERS# is referenced by following:

APPS: GHR_RIF_REGISTERS; GHR_RIF_REGISTERS_WHO