VIEW: HR.GHR_MASS_ACTIONS_PREVIEW#

Source

View Text - Preformatted

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

View Text - HTML Formatted

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