Product: | GHR - US Federal Human Resources |
---|---|
Description: | Mapping of GHR_PA_HISTORY columns to HR_ALL_POSITIONS_F. |
Implementation/DBA Data: | APPS.GHR_POSITIONS_H_V |
SELECT PA_HISTORY_ID
, PROCESS_DATE
, EFFECTIVE_DATE
, DML_OPERATION
, PRE_VALUES_FLAG
, ALTERED_PA_REQUEST_ID
, PA_REQUEST_ID
, NATURE_OF_ACTION_ID
, GHR_GENERAL.RETURN_NUMBER(INFORMATION1) POSITION_ID
, FND_DATE.CANONICAL_TO_DATE(INFORMATION2) EFFECTIVE_START_DATE
, FND_DATE.CANONICAL_TO_DATE(INFORMATION3) EFFECTIVE_END_DATE
, FND_DATE.CANONICAL_TO_DATE(INFORMATION4) DATE_EFFECTIVE
, FND_DATE.CANONICAL_TO_DATE(INFORMATION5) DATE_END
, SUBSTR(INFORMATION6
, 1
, 240) NAME
, GHR_GENERAL.RETURN_NUMBER(INFORMATION7) RELIEF_POSITION_ID
, GHR_GENERAL.RETURN_NUMBER(INFORMATION8) LOCATION_ID
, GHR_GENERAL.RETURN_NUMBER(INFORMATION9) POSITION_DEFINITION_ID
, GHR_GENERAL.RETURN_NUMBER(INFORMATION10) JOB_ID
, GHR_GENERAL.RETURN_NUMBER(INFORMATION12) ORGANIZATION_ID
, SUBSTR(INFORMATION13
, 1
, 30) FREQUENCY
, GHR_GENERAL.RETURN_NUMBER(INFORMATION14) SUCCESSOR_POSITION_ID
, GHR_GENERAL.RETURN_NUMBER(INFORMATION15) PROBATION_PERIOD
, SUBSTR(INFORMATION16
, 1
, 30) PROBATION_PERIOD_UNIT_CD
, SUBSTR(INFORMATION17
, 1
, 30) REPLACEMENT_REQUIRED_FLAG
, SUBSTR(INFORMATION18
, 1
, 5) TIME_NORMAL_FINISH
, SUBSTR(INFORMATION19
, 1
, 5) TIME_NORMAL_START
, GHR_GENERAL.RETURN_NUMBER(INFORMATION20) WORKING_HOURS
, FND_DATE.CANONICAL_TO_DATE(INFORMATION21) AMENDMENT_DATE
, SUBSTR(INFORMATION22
, 1
, 255) AMENDMENT_RECOMMENDATION
, SUBSTR(INFORMATION23
, 1
, 30) AMENDMENT_REF_NUMBER
, GHR_GENERAL.RETURN_NUMBER(INFORMATION24) AVAILABILITY_STATUS_ID
, FND_DATE.CANONICAL_TO_DATE(INFORMATION25)AVAIL_STATUS_PROP_END_DATE
, SUBSTR(INFORMATION26
, 1
, 30)BARGAINING_UNIT_CD
, SUBSTR(INFORMATION27
, 1
, 30)COPIED_TO_OLD_TABLE_FLAG
, FND_DATE.CANONICAL_TO_DATE(INFORMATION28) EARLIEST_HIRE_DATE
, GHR_GENERAL.RETURN_NUMBER(INFORMATION29) ENTRY_GRADE_ID
, GHR_GENERAL.RETURN_NUMBER(INFORMATION30) ENTRY_GRADE_RULE_ID
, GHR_GENERAL.RETURN_NUMBER(INFORMATION31) ENTRY_STEP_ID
, FND_DATE.CANONICAL_TO_DATE(INFORMATION32) FILL_BY_DATE
, GHR_GENERAL.RETURN_NUMBER(INFORMATION33) FTE
, GHR_GENERAL.RETURN_NUMBER(INFORMATION34) MAX_PERSONS
, GHR_GENERAL.RETURN_NUMBER(INFORMATION35) OVERLAP_PERIOD
, SUBSTR(INFORMATION36
, 1
, 30) OVERLAP_UNIT_CD
, GHR_GENERAL.RETURN_NUMBER(INFORMATION37) PAY_BASIS_ID
, GHR_GENERAL.RETURN_NUMBER(INFORMATION38) PAY_FREQ_PAYROLL_ID
, SUBSTR(INFORMATION39
, 1
, 30) PAY_TERM_END_DAY_CD
, SUBSTR(INFORMATION40
, 1
, 30) PAY_TERM_END_MONTH_CD
, SUBSTR(INFORMATION41
, 1
, 30) PERMANENT_TEMPORARY_FLAG
, SUBSTR(INFORMATION42
, 1
, 30) PERMIT_RECRUITMENT_FLAG
, GHR_GENERAL.RETURN_NUMBER(INFORMATION43) POSITION_TRANSACTION_ID
, SUBSTR(INFORMATION44
, 1
, 30) POSITION_TYPE
, SUBSTR(INFORMATION45
, 1
, 255) POSTING_DESCRIPTION
, GHR_GENERAL.RETURN_NUMBER(INFORMATION46) PRIOR_POSITION_ID
, SUBSTR(INFORMATION47
, 1
, 30) REVIEW_FLAG
, SUBSTR(INFORMATION48
, 1
, 30) SEASONAL_FLAG
, SUBSTR(INFORMATION49
, 1
, 255) SECURITY_REQUIREMENTS
, GHR_GENERAL.RETURN_NUMBER(INFORMATION50) SUPERVISOR_ID
, GHR_GENERAL.RETURN_NUMBER(INFORMATION51) SUPERVISOR_POSITION_ID
, SUBSTR(INFORMATION52
, 1
, 30) TERM_START_DAY_CD
, SUBSTR(INFORMATION53
, 1
, 30) TERM_START_MONTH_CD
, SUBSTR(INFORMATION54
, 1
, 30) UPDATE_SOURCE_CD
, SUBSTR(INFORMATION55
, 1
, 30) WORKS_COUNCIL_APPROVAL_FLAG
, SUBSTR(INFORMATION56
, 1
, 30) WORK_PERIOD_TYPE_CD
, SUBSTR(INFORMATION57
, 1
, 30) WORK_TERM_END_DAY_CD
, SUBSTR(INFORMATION58
, 1
, 30) WORK_TERM_END_MONTH_CD
, FND_DATE.CANONICAL_TO_DATE(INFORMATION59) CURRENT_JOB_PROP_END_DATE
, FND_DATE.CANONICAL_TO_DATE(INFORMATION60) CURRENT_ORG_PROP_END_DATE
, FND_DATE.CANONICAL_TO_DATE(INFORMATION61) PROPOSED_DATE_FOR_LAYOFF
, GHR_GENERAL.RETURN_NUMBER(INFORMATION62) PROPOSED_FTE_FOR_LAYOFF
, SUBSTR(INFORMATION63
, 1
, 255) POSITION_DESCRIPTION
, SUBSTR(INFORMATION121
, 1
, 30) STATUS
, GHR_GENERAL.RETURN_NUMBER(INFORMATION122) BUSINESS_GROUP_ID
, GHR_GENERAL.RETURN_NUMBER(INFORMATION123) REQUEST_ID
, GHR_GENERAL.RETURN_NUMBER(INFORMATION124) PROGRAM_APPLICATION_ID
, TO_NUMBER(INFORMATION125) PROGRAM_ID
, FND_DATE.CANONICAL_TO_DATE(INFORMATION126)PROGRAM_UPDATE_DATE
, SUBSTR(INFORMATION127
, 1
, 30) ATTRIBUTE_CATEGORY
, SUBSTR(INFORMATION128
, 1
, 150) ATTRIBUTE1
, SUBSTR(INFORMATION129
, 1
, 150) ATTRIBUTE2
, SUBSTR(INFORMATION130
, 1
, 150) ATTRIBUTE3
, SUBSTR(INFORMATION131
, 1
, 150) ATTRIBUTE4
, SUBSTR(INFORMATION132
, 1
, 150) ATTRIBUTE5
, SUBSTR(INFORMATION133
, 1
, 150) ATTRIBUTE6
, SUBSTR(INFORMATION134
, 1
, 150) ATTRIBUTE7
, SUBSTR(INFORMATION135
, 1
, 150) ATTRIBUTE8
, SUBSTR(INFORMATION136
, 1
, 150) ATTRIBUTE9
, SUBSTR(INFORMATION137
, 1
, 150) ATTRIBUTE10
, SUBSTR(INFORMATION138
, 1
, 150) ATTRIBUTE11
, SUBSTR(INFORMATION139
, 1
, 150) ATTRIBUTE12
, SUBSTR(INFORMATION140
, 1
, 150) ATTRIBUTE13
, SUBSTR(INFORMATION141
, 1
, 150) ATTRIBUTE14
, SUBSTR(INFORMATION142
, 1
, 150) ATTRIBUTE15
, SUBSTR(INFORMATION143
, 1
, 150) ATTRIBUTE16
, SUBSTR(INFORMATION144
, 1
, 150) ATTRIBUTE17
, SUBSTR(INFORMATION145
, 1
, 150) ATTRIBUTE18
, SUBSTR(INFORMATION146
, 1
, 150) ATTRIBUTE19
, SUBSTR(INFORMATION147
, 1
, 150) ATTRIBUTE20
, SUBSTR(INFORMATION148
, 1
, 150) ATTRIBUTE21
, SUBSTR(INFORMATION149
, 1
, 150) ATTRIBUTE22
, SUBSTR(INFORMATION150
, 1
, 150) ATTRIBUTE23
, SUBSTR(INFORMATION151
, 1
, 150) ATTRIBUTE24
, SUBSTR(INFORMATION152
, 1
, 150) ATTRIBUTE25
, SUBSTR(INFORMATION153
, 1
, 150) ATTRIBUTE26
, SUBSTR(INFORMATION154
, 1
, 150) ATTRIBUTE27
, SUBSTR(INFORMATION155
, 1
, 150) ATTRIBUTE28
, SUBSTR(INFORMATION156
, 1
, 150) ATTRIBUTE29
, SUBSTR(INFORMATION157
, 1
, 150) ATTRIBUTE30
, SUBSTR(INFORMATION158
, 1
, 150) INFORMATION_CATEGORY
, SUBSTR(INFORMATION159
, 1
, 150) INFORMATION1
, SUBSTR(INFORMATION160
, 1
, 150) INFORMATION2
, SUBSTR(INFORMATION161
, 1
, 150) INFORMATION3
, SUBSTR(INFORMATION162
, 1
, 150) INFORMATION4
, SUBSTR(INFORMATION163
, 1
, 150) INFORMATION5
, SUBSTR(INFORMATION164
, 1
, 150) INFORMATION6
, SUBSTR(INFORMATION165
, 1
, 150) INFORMATION7
, SUBSTR(INFORMATION166
, 1
, 150) INFORMATION8
, SUBSTR(INFORMATION167
, 1
, 150) INFORMATION9
, SUBSTR(INFORMATION168
, 1
, 150) INFORMATION10
, SUBSTR(INFORMATION169
, 1
, 150) INFORMATION11
, SUBSTR(INFORMATION170
, 1
, 150) INFORMATION12
, SUBSTR(INFORMATION171
, 1
, 150) INFORMATION13
, SUBSTR(INFORMATION172
, 1
, 150) INFORMATION14
, SUBSTR(INFORMATION173
, 1
, 150) INFORMATION15
, SUBSTR(INFORMATION174
, 1
, 150) INFORMATION16
, SUBSTR(INFORMATION175
, 1
, 150) INFORMATION17
, SUBSTR(INFORMATION176
, 1
, 150) INFORMATION18
, SUBSTR(INFORMATION177
, 1
, 150) INFORMATION19
, SUBSTR(INFORMATION178
, 1
, 150) INFORMATION20
, SUBSTR(INFORMATION179
, 1
, 150) INFORMATION21
, SUBSTR(INFORMATION180
, 1
, 150) INFORMATION22
, SUBSTR(INFORMATION181
, 1
, 150) INFORMATION23
, SUBSTR(INFORMATION182
, 1
, 150) INFORMATION24
, SUBSTR(INFORMATION183
, 1
, 150) INFORMATION25
, SUBSTR(INFORMATION184
, 1
, 150) INFORMATION26
, SUBSTR(INFORMATION185
, 1
, 150) INFORMATION27
, SUBSTR(INFORMATION186
, 1
, 150) INFORMATION28
, SUBSTR(INFORMATION187
, 1
, 150) INFORMATION29
, SUBSTR(INFORMATION188
, 1
, 150) INFORMATION30
FROM GHR_PA_HISTORY
WHERE TABLE_NAME = 'HR_ALL_POSITIONS_F'