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_MT_ADDRESSES_V

Product:	GHR - US Federal Human Resources
Description:	This views is used by mass transfer in and out processes for datatransfer.
Implementation/DBA Data:	APPS.GHR_MT_ADDRESSES_V

View Text

SELECT INTERFACE_ID GHR_INTERFACE_ID
, PROCESS_DATE MT_PROCESS_DATE
, SOURCE_NAME MT_SOURCE
, DATE_FROM MT_EFFECTIVE_DATE
, INFORMATION1 MT_NAME
, INFORMATION2 MT_STATUS
, INFORMATION3 MT_PERSON_ID
, INFORMATION4 MT_TABLE_NAME
, INFORMATION5 MT_INFORMATION_TYPE
, INFORMATION6 MT_INTER_BG_TRANSFER
, INFORMATION7 MT_CONTACT_NAME
, INFORMATION8 MT_CONTACT_TYPE
, INFORMATION9 ADDRESS_ID
, INFORMATION10 BUSINESS_GROUP_ID
, INFORMATION11 PERSON_ID
, INFORMATION12 DATE_FROM
, INFORMATION13 PRIMARY_FLAG
, INFORMATION14 STYLE
, INFORMATION15 ADDRESS_LINE1
, INFORMATION16 ADDRESS_LINE2
, INFORMATION17 ADDRESS_LINE3
, INFORMATION18 ADDRESS_TYPE
, INFORMATION19 COMMENTS
, INFORMATION20 COUNTRY
, INFORMATION21 DATE_TO
, INFORMATION22 POSTAL_CODE
, INFORMATION23 REGION_1
, INFORMATION24 REGION_2
, INFORMATION25 REGION_3
, INFORMATION26 TELEPHONE_NUMBER_1
, INFORMATION27 TELEPHONE_NUMBER_2
, INFORMATION28 TELEPHONE_NUMBER_3
, INFORMATION29 TOWN_OR_CITY
, INFORMATION30 REQUEST_ID
, INFORMATION31 PROGRAM_APPLICATION_ID
, INFORMATION32 PROGRAM_ID
, INFORMATION33 PROGRAM_UPDATE_DATE
, INFORMATION34 ADDR_ATTRIBUTE_CATEGORY
, INFORMATION35 ADDR_ATTRIBUTE1
, INFORMATION36 ADDR_ATTRIBUTE2
, INFORMATION37 ADDR_ATTRIBUTE3
, INFORMATION38 ADDR_ATTRIBUTE4
, INFORMATION39 ADDR_ATTRIBUTE5
, INFORMATION40 ADDR_ATTRIBUTE6
, INFORMATION41 ADDR_ATTRIBUTE7
, INFORMATION42 ADDR_ATTRIBUTE8
, INFORMATION43 ADDR_ATTRIBUTE9
, INFORMATION44 ADDR_ATTRIBUTE10
, INFORMATION45 ADDR_ATTRIBUTE11
, INFORMATION46 ADDR_ATTRIBUTE12
, INFORMATION47 ADDR_ATTRIBUTE13
, INFORMATION48 ADDR_ATTRIBUTE14
, INFORMATION49 ADDR_ATTRIBUTE15
, INFORMATION50 ADDR_ATTRIBUTE16
, INFORMATION51 ADDR_ATTRIBUTE17
, INFORMATION52 ADDR_ATTRIBUTE18
, INFORMATION53 ADDR_ATTRIBUTE19
, INFORMATION54 ADDR_ATTRIBUTE20
, INFORMATION55 LAST_UPDATE_DATE
, INFORMATION56 LAST_UPDATED_BY
, INFORMATION57 LAST_UPDATE_LOGIN
, INFORMATION58 CREATED_BY
, INFORMATION59 CREATION_DATE
, INFORMATION60 OBJECT_VERSION_NUMBER
FROM GHR_INTERFACE
WHERE INFORMATION4 = 'PER_ADDRESSES'

Columns

Name
GHR_INTERFACE_ID
MT_PROCESS_DATE
MT_SOURCE
MT_EFFECTIVE_DATE
MT_NAME
MT_STATUS
MT_PERSON_ID
MT_TABLE_NAME
MT_INFORMATION_TYPE
MT_INTER_BG_TRANSFER
MT_CONTACT_NAME
MT_CONTACT_TYPE
ADDRESS_ID
BUSINESS_GROUP_ID
PERSON_ID
DATE_FROM
PRIMARY_FLAG
STYLE
ADDRESS_LINE1
ADDRESS_LINE2
ADDRESS_LINE3
ADDRESS_TYPE
COMMENTS
COUNTRY
DATE_TO
POSTAL_CODE
REGION_1
REGION_2
REGION_3
TELEPHONE_NUMBER_1
TELEPHONE_NUMBER_2
TELEPHONE_NUMBER_3
TOWN_OR_CITY
REQUEST_ID
PROGRAM_APPLICATION_ID
PROGRAM_ID
PROGRAM_UPDATE_DATE
ADDR_ATTRIBUTE_CATEGORY
ADDR_ATTRIBUTE1
ADDR_ATTRIBUTE2
ADDR_ATTRIBUTE3
ADDR_ATTRIBUTE4
ADDR_ATTRIBUTE5
ADDR_ATTRIBUTE6
ADDR_ATTRIBUTE7
ADDR_ATTRIBUTE8
ADDR_ATTRIBUTE9
ADDR_ATTRIBUTE10
ADDR_ATTRIBUTE11
ADDR_ATTRIBUTE12
ADDR_ATTRIBUTE13
ADDR_ATTRIBUTE14
ADDR_ATTRIBUTE15
ADDR_ATTRIBUTE16
ADDR_ATTRIBUTE17
ADDR_ATTRIBUTE18
ADDR_ATTRIBUTE19
ADDR_ATTRIBUTE20
LAST_UPDATE_DATE
LAST_UPDATED_BY
LAST_UPDATE_LOGIN
CREATED_BY
CREATION_DATE
OBJECT_VERSION_NUMBER