VIEW: HR.GHR_RIF_REGISTERS#

Source

View Text - Preformatted

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

View Text - HTML Formatted

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