View: GHR_ASSIGNMENT_EXTRA_INFO_H_V

Product:	GHR - US Federal Human Resources
Description:	Mapping of GHR_PA_HISTORY columns to PER_ASSIGNMENTS_EXTRA_INFO.
Implementation/DBA Data:	APPS.GHR_ASSIGNMENT_EXTRA_INFO_H_V

View Text

SELECT PA_HISTORY_ID
, PROCESS_DATE
, EFFECTIVE_DATE
, DML_OPERATION
, PRE_VALUES_FLAG
, ALTERED_PA_REQUEST_ID
, PA_REQUEST_ID
, NATURE_OF_ACTION_ID
, PERSON_ID
, GHR_GENERAL.RETURN_NUMBER(INFORMATION1) ASSIGNMENT_EXTRA_INFO_ID
, GHR_GENERAL.RETURN_NUMBER(INFORMATION4) ASSIGNMENT_ID
, SUBSTR(INFORMATION5
, 1
, 40) INFORMATION_TYPE
, SUBSTR(INFORMATION6
, 1
, 30) AEI_INFORMATION_CATEGORY
, SUBSTR(INFORMATION7
, 1
, 150) AEI_INFORMATION1
, SUBSTR(INFORMATION8
, 1
, 150) AEI_INFORMATION2
, SUBSTR(INFORMATION9
, 1
, 150) AEI_INFORMATION3
, SUBSTR(INFORMATION10
, 1
, 150) AEI_INFORMATION4
, SUBSTR(INFORMATION11
, 1
, 150) AEI_INFORMATION5
, SUBSTR(INFORMATION12
, 1
, 150) AEI_INFORMATION6
, SUBSTR(INFORMATION13
, 1
, 150) AEI_INFORMATION7
, SUBSTR(INFORMATION14
, 1
, 150) AEI_INFORMATION8
, SUBSTR(INFORMATION15
, 1
, 150) AEI_INFORMATION9
, SUBSTR(INFORMATION16
, 1
, 150) AEI_INFORMATION10
, SUBSTR(INFORMATION17
, 1
, 150) AEI_INFORMATION11
, SUBSTR(INFORMATION18
, 1
, 150) AEI_INFORMATION12
, SUBSTR(INFORMATION19
, 1
, 150) AEI_INFORMATION13
, SUBSTR(INFORMATION20
, 1
, 150) AEI_INFORMATION14
, SUBSTR(INFORMATION21
, 1
, 150) AEI_INFORMATION15
, SUBSTR(INFORMATION22
, 1
, 150) AEI_INFORMATION16
, SUBSTR(INFORMATION23
, 1
, 150) AEI_INFORMATION17
, SUBSTR(INFORMATION24
, 1
, 150) AEI_INFORMATION18
, SUBSTR(INFORMATION25
, 1
, 150) AEI_INFORMATION19
, SUBSTR(INFORMATION26
, 1
, 150) AEI_INFORMATION20
, SUBSTR(INFORMATION27
, 1
, 150) AEI_INFORMATION21
, SUBSTR(INFORMATION28
, 1
, 150) AEI_INFORMATION22
, SUBSTR(INFORMATION29
, 1
, 150) AEI_INFORMATION23
, SUBSTR(INFORMATION30
, 1
, 150) AEI_INFORMATION24
, SUBSTR(INFORMATION31
, 1
, 150) AEI_INFORMATION25
, SUBSTR(INFORMATION32
, 1
, 150) AEI_INFORMATION26
, SUBSTR(INFORMATION33
, 1
, 150) AEI_INFORMATION27
, SUBSTR(INFORMATION34
, 1
, 150) AEI_INFORMATION28
, SUBSTR(INFORMATION35
, 1
, 150) AEI_INFORMATION29
, SUBSTR(INFORMATION36
, 1
, 150) AEI_INFORMATION30
, GHR_GENERAL.RETURN_NUMBER(INFORMATION121) REQUEST_ID
, GHR_GENERAL.RETURN_NUMBER(INFORMATION122) PROGRAM_APPLICATION_ID
, GHR_GENERAL.RETURN_NUMBER(INFORMATION123) PROGRAM_ID
, FND_DATE.CANONICAL_TO_DATE(INFORMATION124) PROGRAM_UPDATE_DATE
, SUBSTR(INFORMATION125
, 1
, 30) AEI_ATTRIBUTE_CATEGORY
, SUBSTR(INFORMATION126
, 1
, 150) AEI_ATTRIBUTE1
, SUBSTR(INFORMATION127
, 1
, 150) AEI_ATTRIBUTE2
, SUBSTR(INFORMATION128
, 1
, 150) AEI_ATTRIBUTE3
, SUBSTR(INFORMATION129
, 1
, 150) AEI_ATTRIBUTE4
, SUBSTR(INFORMATION130
, 1
, 150) AEI_ATTRIBUTE5
, SUBSTR(INFORMATION131
, 1
, 150) AEI_ATTRIBUTE6
, SUBSTR(INFORMATION132
, 1
, 150) AEI_ATTRIBUTE7
, SUBSTR(INFORMATION133
, 1
, 150) AEI_ATTRIBUTE8
, SUBSTR(INFORMATION134
, 1
, 150) AEI_ATTRIBUTE9
, SUBSTR(INFORMATION135
, 1
, 150) AEI_ATTRIBUTE10
, SUBSTR(INFORMATION136
, 1
, 150) AEI_ATTRIBUTE11
, SUBSTR(INFORMATION137
, 1
, 150) AEI_ATTRIBUTE12
, SUBSTR(INFORMATION138
, 1
, 150) AEI_ATTRIBUTE13
, SUBSTR(INFORMATION139
, 1
, 150) AEI_ATTRIBUTE14
, SUBSTR(INFORMATION140
, 1
, 150) AEI_ATTRIBUTE15
, SUBSTR(INFORMATION141
, 1
, 150) AEI_ATTRIBUTE16
, SUBSTR(INFORMATION142
, 1
, 150) AEI_ATTRIBUTE17
, SUBSTR(INFORMATION143
, 1
, 150) AEI_ATTRIBUTE18
, SUBSTR(INFORMATION144
, 1
, 150) AEI_ATTRIBUTE19
, SUBSTR(INFORMATION145
, 1
, 150) AEI_ATTRIBUTE20
FROM GHR_PA_HISTORY
WHERE TABLE_NAME = 'PER_ASSIGNMENT_EXTRA_INFO'

Columns