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_POSITIONS_V |
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 POSITION_ID
, INFORMATION8 BUSINESS_GROUP_ID
, INFORMATION9 JOB_ID
, INFORMATION10 ORGANIZATION_ID
, INFORMATION11 SUCCESSOR_POSITION_ID
, INFORMATION12 RELIEF_POSITION_ID
, INFORMATION13 LOCATION_ID
, INFORMATION14 POSITION_DEFINITION_ID
, INFORMATION15 DATE_EFFECTIVE
, INFORMATION16 COMMENTS
, INFORMATION17 DATE_END
, INFORMATION18 FREQUENCY
, INFORMATION19 NAME
, INFORMATION20 PROBATION_PERIOD
, INFORMATION21 PROBATION_PERIOD_UNITS
, INFORMATION22 REPLACEMENT_REQUIRED_FLAG
, INFORMATION23 TIME_NORMAL_FINISH
, INFORMATION24 TIME_NORMAL_START
, INFORMATION25 WORKING_HOURS
, INFORMATION26 REQUEST_ID
, INFORMATION27 PROGRAM_APPLICATION_ID
, INFORMATION28 PROGRAM_ID
, INFORMATION29 PROGRAM_UPDATE_DATE
, INFORMATION30 ATTRIBUTE_CATEGORY
, INFORMATION31 ATTRIBUTE1
, INFORMATION32 ATTRIBUTE2
, INFORMATION33 ATTRIBUTE3
, INFORMATION34 ATTRIBUTE4
, INFORMATION35 ATTRIBUTE5
, INFORMATION36 ATTRIBUTE6
, INFORMATION37 ATTRIBUTE7
, INFORMATION38 ATTRIBUTE8
, INFORMATION39 ATTRIBUTE9
, INFORMATION40 ATTRIBUTE10
, INFORMATION41 ATTRIBUTE11
, INFORMATION42 ATTRIBUTE12
, INFORMATION43 ATTRIBUTE13
, INFORMATION44 ATTRIBUTE14
, INFORMATION45 ATTRIBUTE15
, INFORMATION46 ATTRIBUTE16
, INFORMATION47 ATTRIBUTE17
, INFORMATION48 ATTRIBUTE18
, INFORMATION49 ATTRIBUTE19
, INFORMATION50 ATTRIBUTE20
, INFORMATION51 OBJECT_VERSION_NUMBER
, INFORMATION52 LAST_UPDATE_DATE
, INFORMATION53 LAST_UPDATED_BY
, INFORMATION54 LAST_UPDATE_LOGIN
, INFORMATION55 CREATED_BY
, INFORMATION56 CREATION_DATE
, INFORMATION57 STATUS
FROM GHR_INTERFACE
WHERE INFORMATION4 = 'PER_POSITIONS'