eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

View: GHR_PERSON_ANALYSES_H_V

Product:	GHR - US Federal Human Resources
Description:	Mapping of GHR_PA_HISTORY columns to PER_PERSON_ANALYSES.
Implementation/DBA Data:	APPS.GHR_PERSON_ANALYSES_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
, GHR_GENERAL.RETURN_NUMBER(INFORMATION1) PERSON_ANALYSIS_ID
, GHR_GENERAL.RETURN_NUMBER(INFORMATION5) BUSINESS_GROUP_ID
, GHR_GENERAL.RETURN_NUMBER(INFORMATION6) ANALYSIS_CRITERIA_ID
, GHR_GENERAL.RETURN_NUMBER(INFORMATION7) PERSON_ID
, INFORMATION8 COMMENTS
, FND_DATE.CANONICAL_TO_DATE(INFORMATION9) DATE_FROM
, FND_DATE.CANONICAL_TO_DATE(INFORMATION10) DATE_TO
, GHR_GENERAL.RETURN_NUMBER(INFORMATION11) ID_FLEX_NUM
, 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) ATTRIBUTE_CATEGORY
, SUBSTR(INFORMATION126
, 1
, 15) ATTRIBUTE1
, SUBSTR(INFORMATION127
, 1
, 150) ATTRIBUTE2
, SUBSTR(INFORMATION128
, 1
, 150) ATTRIBUTE3
, SUBSTR(INFORMATION129
, 1
, 150) ATTRIBUTE4
, SUBSTR(INFORMATION130
, 1
, 150) ATTRIBUTE5
, SUBSTR(INFORMATION131
, 1
, 150) ATTRIBUTE6
, SUBSTR(INFORMATION132
, 1
, 150) ATTRIBUTE7
, SUBSTR(INFORMATION133
, 1
, 150) ATTRIBUTE8
, SUBSTR(INFORMATION134
, 1
, 150) ATTRIBUTE9
, SUBSTR(INFORMATION135
, 1
, 150) ATTRIBUTE10
, SUBSTR(INFORMATION136
, 1
, 150) ATTRIBUTE11
, SUBSTR(INFORMATION137
, 1
, 150) ATTRIBUTE12
, SUBSTR(INFORMATION138
, 1
, 150) ATTRIBUTE13
, SUBSTR(INFORMATION139
, 1
, 150) ATTRIBUTE14
, SUBSTR(INFORMATION140
, 1
, 150) ATTRIBUTE15
, SUBSTR(INFORMATION141
, 1
, 150) ATTRIBUTE16
, SUBSTR(INFORMATION142
, 1
, 150) ATTRIBUTE17
, SUBSTR(INFORMATION143
, 1
, 150) ATTRIBUTE18
, SUBSTR(INFORMATION144
, 1
, 150) ATTRIBUTE19
, SUBSTR(INFORMATION145
, 1
, 150) ATTRIBUTE20
FROM GHR_PA_HISTORY
WHERE TABLE_NAME='PER_PERSON_ANALYSES'

Columns

Name
PA_HISTORY_ID
PROCESS_DATE
EFFECTIVE_DATE
DML_OPERATION
PRE_VALUES_FLAG
ALTERED_PA_REQUEST_ID
PA_REQUEST_ID
NATURE_OF_ACTION_ID
PERSON_ANALYSIS_ID
BUSINESS_GROUP_ID
ANALYSIS_CRITERIA_ID
PERSON_ID
COMMENTS
DATE_FROM
DATE_TO
ID_FLEX_NUM
REQUEST_ID
PROGRAM_APPLICATION_ID
PROGRAM_ID
PROGRAM_UPDATE_DATE
ATTRIBUTE_CATEGORY
ATTRIBUTE1
ATTRIBUTE2
ATTRIBUTE3
ATTRIBUTE4
ATTRIBUTE5
ATTRIBUTE6
ATTRIBUTE7
ATTRIBUTE8
ATTRIBUTE9
ATTRIBUTE10
ATTRIBUTE11
ATTRIBUTE12
ATTRIBUTE13
ATTRIBUTE14
ATTRIBUTE15
ATTRIBUTE16
ATTRIBUTE17
ATTRIBUTE18
ATTRIBUTE19
ATTRIBUTE20