VIEW: APPS.HR_POSITIONS_V1

Source

View Text - Preformatted

SELECT PSF.POSITION_ID, PSF.EFFECTIVE_START_DATE, PSF.EFFECTIVE_END_DATE, PSF.AVAILABILITY_STATUS_ID, HR_GENERAL.DECODE_AVAILABILITY_STATUS(PSF.AVAILABILITY_STATUS_ID) AVAILABILITY_STATUS_DESC, HR_GENERAL.DECODE_AVAIL_STATUS_START_DATE( PSF.POSITION_ID,PSF.AVAILABILITY_STATUS_ID,PSF.EFFECTIVE_START_DATE) AVAILABILITY_STATUS_START_DATE, PSF.BUSINESS_GROUP_ID, PSF.ENTRY_STEP_ID, HR_GENERAL.DECODE_STEP(PSF.ENTRY_STEP_ID,DATE_EFFECTIVE) ENTRY_STEP_DESC, PSF.ENTRY_GRADE_RULE_ID, HR_GENERAL.DECODE_GRADE_RULE(PSF.ENTRY_GRADE_RULE_ID) GRADE_RATE_VALUE, PGR.VALUE POINT_VALUE, PGR.MINIMUM GRADE_RATE_MIN, PGR.MID_VALUE GRADE_RATE_MID, PGR.MAXIMUM GRADE_RATE_MAX, PSF.JOB_ID, HR_GENERAL.DECODE_JOB(PSF.JOB_ID) JOB_DESC, PSF.LOCATION_ID, HR_GENERAL.DECODE_LOCATION(PSF.LOCATION_ID) LOCATION_DESC, PSF.ORGANIZATION_ID, HR_GENERAL.DECODE_ORGANIZATION(PSF.ORGANIZATION_ID) ORGANIZATION_DESC, PSF.PAY_FREQ_PAYROLL_ID, HR_GENERAL.DECODE_PAYROLL(PSF.PAY_FREQ_PAYROLL_ID) PAY_FREQ_PAYROLL_DESC, PSF.POSITION_DEFINITION_ID, PSF.POSITION_TRANSACTION_ID, PSF.PRIOR_POSITION_ID, HR_GENERAL.DECODE_POSITION(PSF.PRIOR_POSITION_ID) PRIOR_POSITION_DESC, PSF.RELIEF_POSITION_ID, HR_GENERAL.DECODE_POSITION(PSF.RELIEF_POSITION_ID) RELIEF_POSITION_DESC, PSF.ENTRY_GRADE_ID, HR_GENERAL.DECODE_GRADE(PSF.ENTRY_GRADE_ID) SALARY_ENTRY_GRADE_DESC, PSF.SUCCESSOR_POSITION_ID, HR_GENERAL.DECODE_POSITION(PSF.SUCCESSOR_POSITION_ID) SUCCESSOR_POSITION_DESC, PSF.SUPERVISOR_POSITION_ID, HR_GENERAL.DECODE_POSITION(PSF.SUPERVISOR_POSITION_ID) SUPERVISOR_POSITION_DESC, PSF.AMENDMENT_DATE, PSF.AMENDMENT_RECOMMENDATION, PSF.AMENDMENT_REF_NUMBER, PSF.BARGAINING_UNIT_CD, HR_GENERAL.DECODE_LOOKUP( 'BARGAINING_UNIT_CODE' ,PSF.BARGAINING_UNIT_CD) BARGAINING_UNIT_DESC, PSF.COMMENTS, PSF.CURRENT_JOB_PROP_END_DATE, PSF.CURRENT_ORG_PROP_END_DATE, PSF.AVAIL_STATUS_PROP_END_DATE, PSF.DATE_EFFECTIVE, PSF.DATE_END, PSF.EARLIEST_HIRE_DATE, PSF.FILL_BY_DATE, PSF.FREQUENCY, HR_GENERAL.DECODE_LOOKUP('FREQUENCY' , PSF.FREQUENCY) FREQUENCY_DESC, PSF.FTE, PSF.MAX_PERSONS, PSF.NAME, HR_GENERAL.DECODE_POSITION_LATEST_NAME(PSF.POSITION_ID) POSITION_LATEST_NAME, HR_GENERAL.DECODE_LATEST_POSITION_DEF_ID(PSF.POSITION_ID) latest_position_definition_id, PSF.OVERLAP_PERIOD, PSF.OVERLAP_UNIT_CD, HR_GENERAL.DECODE_LOOKUP( 'FREQUENCY' , PSF.OVERLAP_UNIT_CD) OVERLAP_UNIT_DESC, PSF.PAY_TERM_END_DAY_CD, HR_GENERAL.DECODE_LOOKUP('DAY_CODE' , PSF.PAY_TERM_END_DAY_CD) PAY_TERM_END_DAY_DESC, PSF.PAY_TERM_END_MONTH_CD, HR_GENERAL.DECODE_LOOKUP('MONTH_CODE' , PSF.PAY_TERM_END_MONTH_CD) PAY_TERM_END_MONTH_DESC, PSF.PERMANENT_TEMPORARY_FLAG, PSF.PERMIT_RECRUITMENT_FLAG, PSF.POSITION_TYPE, HR_GENERAL.DECODE_LOOKUP('POSITION_TYPE' , PSF.POSITION_TYPE) POSITION_TYPE_DESC, PSF.POSTING_DESCRIPTION, PSF.PROBATION_PERIOD, PSF.PROBATION_PERIOD_UNIT_CD, HR_GENERAL.DECODE_LOOKUP('FREQUENCY' ,PSF.PROBATION_PERIOD_UNIT_CD) PROBATION_UNIT_DESC, PSF.REPLACEMENT_REQUIRED_FLAG, HR_GENERAL.decode_lookup('YES_NO' ,PSF.REPLACEMENT_REQUIRED_FLAG) REPLACEMENT_REQUIRED_DESC, PSF.REVIEW_FLAG, PSF.SEASONAL_FLAG, PSF.SECURITY_REQUIREMENTS, PSF.STATUS, HR_GENERAL.DECODE_LOOKUP('POSITION_STATUS' ,PSF.STATUS) STATUS_DESC, PSF.TERM_START_DAY_CD, HR_GENERAL.DECODE_LOOKUP('DAY_CODE' , PSF.TERM_START_DAY_CD) TERM_START_DAY_DESC, PSF.TERM_START_MONTH_CD, HR_GENERAL.DECODE_LOOKUP('MONTH_CODE' , PSF.TERM_START_MONTH_CD) TERM_START_MONTH, PSF.TIME_NORMAL_FINISH, PSF.TIME_NORMAL_START, PSF.UPDATE_SOURCE_CD, PSF.WORKING_HOURS, PSF.WORKS_COUNCIL_APPROVAL_FLAG, PSF.WORK_PERIOD_TYPE_CD, HR_GENERAL.DECODE_LOOKUP('YES_NO' ,PSF.WORK_PERIOD_TYPE_CD) WORK_PERIOD_TYPE_DESC, PSF.WORK_TERM_END_DAY_CD, HR_GENERAL.DECODE_LOOKUP('DAY_CODE' , PSF.WORK_TERM_END_DAY_CD) WORK_TERM_END_DAY_DESC, PSF.WORK_TERM_END_MONTH_CD, HR_GENERAL.DECODE_LOOKUP('MONTH_CODE' , PSF.WORK_TERM_END_DAY_CD) WORK_TERM_END_MONTH_DESC, PSF.PROPOSED_FTE_FOR_LAYOFF, PSF.PROPOSED_DATE_FOR_LAYOFF, HR_GENERAL.DECODE_PAY_BASIS(PSF.PAY_BASIS_ID) PAY_BASIS_DESC, PSF.PAY_BASIS_ID, HR_GENERAL.DECODE_PERSON_NAME(PSF.SUPERVISOR_ID) SUPERVISOR_NAME, PSF.SUPERVISOR_ID, PSF.INFORMATION1,PSF.INFORMATION2,PSF.INFORMATION3,PSF.INFORMATION4, PSF.INFORMATION5,PSF.INFORMATION6,PSF.INFORMATION7, PSF.INFORMATION8, PSF.INFORMATION9,PSF.INFORMATION10,PSF.INFORMATION11, PSF.INFORMATION12, PSF.INFORMATION13,PSF.INFORMATION14, PSF.INFORMATION15,PSF.INFORMATION16, PSF.INFORMATION17,PSF.INFORMATION18,PSF.INFORMATION19, PSF.INFORMATION20, PSF.INFORMATION21, PSF.INFORMATION22,PSF.INFORMATION23,PSF.INFORMATION24, PSF.INFORMATION25,PSF.INFORMATION26,PSF.INFORMATION27, PSF.INFORMATION28, PSF.INFORMATION29,PSF.INFORMATION30,PSF.INFORMATION_CATEGORY, PSF.ATTRIBUTE1, PSF.ATTRIBUTE2,PSF.ATTRIBUTE3,PSF.ATTRIBUTE4,PSF.ATTRIBUTE5, PSF.ATTRIBUTE6, PSF.ATTRIBUTE7, PSF.ATTRIBUTE8,PSF.ATTRIBUTE9,PSF.ATTRIBUTE10,PSF.ATTRIBUTE11, PSF.ATTRIBUTE12,PSF.ATTRIBUTE13,PSF.ATTRIBUTE14, PSF.ATTRIBUTE15,PSF.ATTRIBUTE16, PSF.ATTRIBUTE17,PSF.ATTRIBUTE18,PSF.ATTRIBUTE19,PSF.ATTRIBUTE20, PSF.ATTRIBUTE21, PSF.ATTRIBUTE22,PSF.ATTRIBUTE23,PSF.ATTRIBUTE24,PSF.ATTRIBUTE25, PSF.ATTRIBUTE26, PSF.ATTRIBUTE27,PSF.ATTRIBUTE28, PSF.ATTRIBUTE29,PSF.ATTRIBUTE30, PSF.ATTRIBUTE_CATEGORY, PSF.REQUEST_ID,PSF.PROGRAM_APPLICATION_ID, PSF.PROGRAM_ID,PSF.PROGRAM_UPDATE_DATE,PSF.CREATED_BY, PSF.CREATION_DATE, PSF.LAST_UPDATED_BY,PSF.LAST_UPDATE_DATE,PSF.LAST_UPDATE_LOGIN, PSF.OBJECT_VERSION_NUMBER from HR_POSITIONS_F PSF, PAY_GRADE_RULES PGR WHERE PSF.ENTRY_GRADE_RULE_ID = PGR.GRADE_RULE_ID(+) and PSF.EFFECTIVE_END_DATE = to_date('12/31/4712','mm/dd/yyyy')

View Text - HTML Formatted

SELECT PSF.POSITION_ID
, PSF.EFFECTIVE_START_DATE
, PSF.EFFECTIVE_END_DATE
, PSF.AVAILABILITY_STATUS_ID
, HR_GENERAL.DECODE_AVAILABILITY_STATUS(PSF.AVAILABILITY_STATUS_ID) AVAILABILITY_STATUS_DESC
, HR_GENERAL.DECODE_AVAIL_STATUS_START_DATE( PSF.POSITION_ID
, PSF.AVAILABILITY_STATUS_ID
, PSF.EFFECTIVE_START_DATE) AVAILABILITY_STATUS_START_DATE
, PSF.BUSINESS_GROUP_ID
, PSF.ENTRY_STEP_ID
, HR_GENERAL.DECODE_STEP(PSF.ENTRY_STEP_ID
, DATE_EFFECTIVE) ENTRY_STEP_DESC
, PSF.ENTRY_GRADE_RULE_ID
, HR_GENERAL.DECODE_GRADE_RULE(PSF.ENTRY_GRADE_RULE_ID) GRADE_RATE_VALUE
, PGR.VALUE POINT_VALUE
, PGR.MINIMUM GRADE_RATE_MIN
, PGR.MID_VALUE GRADE_RATE_MID
, PGR.MAXIMUM GRADE_RATE_MAX
, PSF.JOB_ID
, HR_GENERAL.DECODE_JOB(PSF.JOB_ID) JOB_DESC
, PSF.LOCATION_ID
, HR_GENERAL.DECODE_LOCATION(PSF.LOCATION_ID) LOCATION_DESC
, PSF.ORGANIZATION_ID
, HR_GENERAL.DECODE_ORGANIZATION(PSF.ORGANIZATION_ID) ORGANIZATION_DESC
, PSF.PAY_FREQ_PAYROLL_ID
, HR_GENERAL.DECODE_PAYROLL(PSF.PAY_FREQ_PAYROLL_ID) PAY_FREQ_PAYROLL_DESC
, PSF.POSITION_DEFINITION_ID
, PSF.POSITION_TRANSACTION_ID
, PSF.PRIOR_POSITION_ID
, HR_GENERAL.DECODE_POSITION(PSF.PRIOR_POSITION_ID) PRIOR_POSITION_DESC
, PSF.RELIEF_POSITION_ID
, HR_GENERAL.DECODE_POSITION(PSF.RELIEF_POSITION_ID) RELIEF_POSITION_DESC
, PSF.ENTRY_GRADE_ID
, HR_GENERAL.DECODE_GRADE(PSF.ENTRY_GRADE_ID) SALARY_ENTRY_GRADE_DESC
, PSF.SUCCESSOR_POSITION_ID
, HR_GENERAL.DECODE_POSITION(PSF.SUCCESSOR_POSITION_ID) SUCCESSOR_POSITION_DESC
, PSF.SUPERVISOR_POSITION_ID
, HR_GENERAL.DECODE_POSITION(PSF.SUPERVISOR_POSITION_ID) SUPERVISOR_POSITION_DESC
, PSF.AMENDMENT_DATE
, PSF.AMENDMENT_RECOMMENDATION
, PSF.AMENDMENT_REF_NUMBER
, PSF.BARGAINING_UNIT_CD
, HR_GENERAL.DECODE_LOOKUP( 'BARGAINING_UNIT_CODE'
, PSF.BARGAINING_UNIT_CD) BARGAINING_UNIT_DESC
, PSF.COMMENTS
, PSF.CURRENT_JOB_PROP_END_DATE
, PSF.CURRENT_ORG_PROP_END_DATE
, PSF.AVAIL_STATUS_PROP_END_DATE
, PSF.DATE_EFFECTIVE
, PSF.DATE_END
, PSF.EARLIEST_HIRE_DATE
, PSF.FILL_BY_DATE
, PSF.FREQUENCY
, HR_GENERAL.DECODE_LOOKUP('FREQUENCY'
, PSF.FREQUENCY) FREQUENCY_DESC
, PSF.FTE
, PSF.MAX_PERSONS
, PSF.NAME
, HR_GENERAL.DECODE_POSITION_LATEST_NAME(PSF.POSITION_ID) POSITION_LATEST_NAME
, HR_GENERAL.DECODE_LATEST_POSITION_DEF_ID(PSF.POSITION_ID) LATEST_POSITION_DEFINITION_ID
, PSF.OVERLAP_PERIOD
, PSF.OVERLAP_UNIT_CD
, HR_GENERAL.DECODE_LOOKUP( 'FREQUENCY'
, PSF.OVERLAP_UNIT_CD) OVERLAP_UNIT_DESC
, PSF.PAY_TERM_END_DAY_CD
, HR_GENERAL.DECODE_LOOKUP('DAY_CODE'
, PSF.PAY_TERM_END_DAY_CD) PAY_TERM_END_DAY_DESC
, PSF.PAY_TERM_END_MONTH_CD
, HR_GENERAL.DECODE_LOOKUP('MONTH_CODE'
, PSF.PAY_TERM_END_MONTH_CD) PAY_TERM_END_MONTH_DESC
, PSF.PERMANENT_TEMPORARY_FLAG
, PSF.PERMIT_RECRUITMENT_FLAG
, PSF.POSITION_TYPE
, HR_GENERAL.DECODE_LOOKUP('POSITION_TYPE'
, PSF.POSITION_TYPE) POSITION_TYPE_DESC
, PSF.POSTING_DESCRIPTION
, PSF.PROBATION_PERIOD
, PSF.PROBATION_PERIOD_UNIT_CD
, HR_GENERAL.DECODE_LOOKUP('FREQUENCY'
, PSF.PROBATION_PERIOD_UNIT_CD) PROBATION_UNIT_DESC
, PSF.REPLACEMENT_REQUIRED_FLAG
, HR_GENERAL.DECODE_LOOKUP('YES_NO'
, PSF.REPLACEMENT_REQUIRED_FLAG) REPLACEMENT_REQUIRED_DESC
, PSF.REVIEW_FLAG
, PSF.SEASONAL_FLAG
, PSF.SECURITY_REQUIREMENTS
, PSF.STATUS
, HR_GENERAL.DECODE_LOOKUP('POSITION_STATUS'
, PSF.STATUS) STATUS_DESC
, PSF.TERM_START_DAY_CD
, HR_GENERAL.DECODE_LOOKUP('DAY_CODE'
, PSF.TERM_START_DAY_CD) TERM_START_DAY_DESC
, PSF.TERM_START_MONTH_CD
, HR_GENERAL.DECODE_LOOKUP('MONTH_CODE'
, PSF.TERM_START_MONTH_CD) TERM_START_MONTH
, PSF.TIME_NORMAL_FINISH
, PSF.TIME_NORMAL_START
, PSF.UPDATE_SOURCE_CD
, PSF.WORKING_HOURS
, PSF.WORKS_COUNCIL_APPROVAL_FLAG
, PSF.WORK_PERIOD_TYPE_CD
, HR_GENERAL.DECODE_LOOKUP('YES_NO'
, PSF.WORK_PERIOD_TYPE_CD) WORK_PERIOD_TYPE_DESC
, PSF.WORK_TERM_END_DAY_CD
, HR_GENERAL.DECODE_LOOKUP('DAY_CODE'
, PSF.WORK_TERM_END_DAY_CD) WORK_TERM_END_DAY_DESC
, PSF.WORK_TERM_END_MONTH_CD
, HR_GENERAL.DECODE_LOOKUP('MONTH_CODE'
, PSF.WORK_TERM_END_DAY_CD) WORK_TERM_END_MONTH_DESC
, PSF.PROPOSED_FTE_FOR_LAYOFF
, PSF.PROPOSED_DATE_FOR_LAYOFF
, HR_GENERAL.DECODE_PAY_BASIS(PSF.PAY_BASIS_ID) PAY_BASIS_DESC
, PSF.PAY_BASIS_ID
, HR_GENERAL.DECODE_PERSON_NAME(PSF.SUPERVISOR_ID) SUPERVISOR_NAME
, PSF.SUPERVISOR_ID
, PSF.INFORMATION1
, PSF.INFORMATION2
, PSF.INFORMATION3
, PSF.INFORMATION4
, PSF.INFORMATION5
, PSF.INFORMATION6
, PSF.INFORMATION7
, PSF.INFORMATION8
, PSF.INFORMATION9
, PSF.INFORMATION10
, PSF.INFORMATION11
, PSF.INFORMATION12
, PSF.INFORMATION13
, PSF.INFORMATION14
, PSF.INFORMATION15
, PSF.INFORMATION16
, PSF.INFORMATION17
, PSF.INFORMATION18
, PSF.INFORMATION19
, PSF.INFORMATION20
, PSF.INFORMATION21
, PSF.INFORMATION22
, PSF.INFORMATION23
, PSF.INFORMATION24
, PSF.INFORMATION25
, PSF.INFORMATION26
, PSF.INFORMATION27
, PSF.INFORMATION28
, PSF.INFORMATION29
, PSF.INFORMATION30
, PSF.INFORMATION_CATEGORY
, PSF.ATTRIBUTE1
, PSF.ATTRIBUTE2
, PSF.ATTRIBUTE3
, PSF.ATTRIBUTE4
, PSF.ATTRIBUTE5
, PSF.ATTRIBUTE6
, PSF.ATTRIBUTE7
, PSF.ATTRIBUTE8
, PSF.ATTRIBUTE9
, PSF.ATTRIBUTE10
, PSF.ATTRIBUTE11
, PSF.ATTRIBUTE12
, PSF.ATTRIBUTE13
, PSF.ATTRIBUTE14
, PSF.ATTRIBUTE15
, PSF.ATTRIBUTE16
, PSF.ATTRIBUTE17
, PSF.ATTRIBUTE18
, PSF.ATTRIBUTE19
, PSF.ATTRIBUTE20
, PSF.ATTRIBUTE21
, PSF.ATTRIBUTE22
, PSF.ATTRIBUTE23
, PSF.ATTRIBUTE24
, PSF.ATTRIBUTE25
, PSF.ATTRIBUTE26
, PSF.ATTRIBUTE27
, PSF.ATTRIBUTE28
, PSF.ATTRIBUTE29
, PSF.ATTRIBUTE30
, PSF.ATTRIBUTE_CATEGORY
, PSF.REQUEST_ID
, PSF.PROGRAM_APPLICATION_ID
, PSF.PROGRAM_ID
, PSF.PROGRAM_UPDATE_DATE
, PSF.CREATED_BY
, PSF.CREATION_DATE
, PSF.LAST_UPDATED_BY
, PSF.LAST_UPDATE_DATE
, PSF.LAST_UPDATE_LOGIN
, PSF.OBJECT_VERSION_NUMBER
FROM HR_POSITIONS_F PSF
, PAY_GRADE_RULES PGR
WHERE PSF.ENTRY_GRADE_RULE_ID = PGR.GRADE_RULE_ID(+)
AND PSF.EFFECTIVE_END_DATE = TO_DATE('12/31/4712'
, 'MM/DD/YYYY')