VIEW: APPS.GHR_MT_ASSIGNMENTS_F_V

Source

View Text - Preformatted

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 ASSIGNMENT_ID , INFORMATION8 EFFECTIVE_START_DATE , INFORMATION9 EFFECTIVE_END_DATE , INFORMATION10 BUSINESS_GROUP_ID , INFORMATION11 RECRUITER_ID , INFORMATION12 GRADE_ID , INFORMATION13 POSITION_ID , INFORMATION14 JOB_ID , INFORMATION15 ASSIGNMENT_STATUS_TYPE_ID , INFORMATION16 PAYROLL_ID , INFORMATION17 LOCATION_ID , INFORMATION18 PERSON_REFERRED_BY_ID , INFORMATION19 SUPERVISOR_ID , INFORMATION20 SPECIAL_CEILING_STEP_ID , INFORMATION21 PERSON_ID , INFORMATION22 RECRUITMENT_ACTIVITY_ID , INFORMATION23 SOURCE_ORGANIZATION_ID , INFORMATION24 ORGANIZATION_ID , INFORMATION25 PEOPLE_GROUP_ID , INFORMATION26 SOFT_CODING_KEYFLEX_ID , INFORMATION27 VACANCY_ID , INFORMATION28 PAY_BASIS_ID, INFORMATION29 ASSIGNMENT_SEQUENCE , INFORMATION30 ASSIGNMENT_TYPE , INFORMATION31 PRIMARY_FLAG , INFORMATION32 APPLICATION_ID , INFORMATION33 ASSIGNMENT_NUMBER , INFORMATION34 CHANGE_REASON , INFORMATION35 COMMENT_ID , INFORMATION36 DATE_PROBATION_END , INFORMATION37 DEFAULT_CODE_COMB_ID , INFORMATION38 EMPLOYMENT_CATEGORY , INFORMATION39 FREQUENCY , INFORMATION40 INTERNAL_ADDRESS_LINE , INFORMATION41 MANAGER_FLAG , INFORMATION42 NORMAL_HOURS , INFORMATION43 PERF_REVIEW_PERIOD , INFORMATION44 PERF_REVIEW_PERIOD_FREQUENCY , INFORMATION45 PERIOD_OF_SERVICE_ID , INFORMATION46 PROBATION_PERIOD , INFORMATION47 PROBATION_UNIT , INFORMATION48 SAL_REVIEW_PERIOD , INFORMATION49 SAL_REVIEW_PERIOD_FREQUENCY , INFORMATION50 SET_OF_BOOKS_ID , INFORMATION51 SOURCE_TYPE , INFORMATION52 TIME_NORMAL_FINISH , INFORMATION53 TIME_NORMAL_START , INFORMATION54 REQUEST_ID , INFORMATION55 PROGRAM_APPLICATION_ID , INFORMATION56 PROGRAM_ID , INFORMATION57 PROGRAM_UPDATE_DATE , INFORMATION58 ASS_ATTRIBUTE_CATEGORY, INFORMATION59 ASS_ATTRIBUTE1 , INFORMATION60 ASS_ATTRIBUTE2 , INFORMATION61 ASS_ATTRIBUTE3 , INFORMATION62 ASS_ATTRIBUTE4 , INFORMATION63 ASS_ATTRIBUTE5 , INFORMATION64 ASS_ATTRIBUTE6 , INFORMATION65 ASS_ATTRIBUTE7 , INFORMATION66 ASS_ATTRIBUTE8 , INFORMATION67 ASS_ATTRIBUTE9 , INFORMATION68 ASS_ATTRIBUTE10 , INFORMATION69 ASS_ATTRIBUTE11 , INFORMATION70 ASS_ATTRIBUTE12 , INFORMATION71 ASS_ATTRIBUTE13 , INFORMATION72 ASS_ATTRIBUTE14 , INFORMATION73 ASS_ATTRIBUTE15 , INFORMATION74 ASS_ATTRIBUTE16 , INFORMATION75 ASS_ATTRIBUTE17 , INFORMATION76 ASS_ATTRIBUTE18 , INFORMATION77 ASS_ATTRIBUTE19 , INFORMATION78 ASS_ATTRIBUTE20 , INFORMATION79 ASS_ATTRIBUTE21 , INFORMATION80 ASS_ATTRIBUTE22 , INFORMATION81 ASS_ATTRIBUTE23 , INFORMATION82 ASS_ATTRIBUTE24 , INFORMATION83 ASS_ATTRIBUTE25 , INFORMATION84 ASS_ATTRIBUTE26 , INFORMATION85 ASS_ATTRIBUTE27 , INFORMATION86 ASS_ATTRIBUTE28 , INFORMATION87 ASS_ATTRIBUTE29 , INFORMATION88 ASS_ATTRIBUTE30 , INFORMATION89 LAST_UPDATE_DATE , INFORMATION90 LAST_UPDATED_BY, INFORMATION91 LAST_UPDATE_LOGIN , INFORMATION92 CREATED_BY , INFORMATION93 CREATION_DATE , INFORMATION94 TITLE , INFORMATION95 OBJECT_VERSION_NUMBER FROM GHR_INTERFACE WHERE INFORMATION4 = 'PER_ASSIGNMENTS_F'

View Text - HTML Formatted

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 ASSIGNMENT_ID
, INFORMATION8 EFFECTIVE_START_DATE
, INFORMATION9 EFFECTIVE_END_DATE
, INFORMATION10 BUSINESS_GROUP_ID
, INFORMATION11 RECRUITER_ID
, INFORMATION12 GRADE_ID
, INFORMATION13 POSITION_ID
, INFORMATION14 JOB_ID
, INFORMATION15 ASSIGNMENT_STATUS_TYPE_ID
, INFORMATION16 PAYROLL_ID
, INFORMATION17 LOCATION_ID
, INFORMATION18 PERSON_REFERRED_BY_ID
, INFORMATION19 SUPERVISOR_ID
, INFORMATION20 SPECIAL_CEILING_STEP_ID
, INFORMATION21 PERSON_ID
, INFORMATION22 RECRUITMENT_ACTIVITY_ID
, INFORMATION23 SOURCE_ORGANIZATION_ID
, INFORMATION24 ORGANIZATION_ID
, INFORMATION25 PEOPLE_GROUP_ID
, INFORMATION26 SOFT_CODING_KEYFLEX_ID
, INFORMATION27 VACANCY_ID
, INFORMATION28 PAY_BASIS_ID
, INFORMATION29 ASSIGNMENT_SEQUENCE
, INFORMATION30 ASSIGNMENT_TYPE
, INFORMATION31 PRIMARY_FLAG
, INFORMATION32 APPLICATION_ID
, INFORMATION33 ASSIGNMENT_NUMBER
, INFORMATION34 CHANGE_REASON
, INFORMATION35 COMMENT_ID
, INFORMATION36 DATE_PROBATION_END
, INFORMATION37 DEFAULT_CODE_COMB_ID
, INFORMATION38 EMPLOYMENT_CATEGORY
, INFORMATION39 FREQUENCY
, INFORMATION40 INTERNAL_ADDRESS_LINE
, INFORMATION41 MANAGER_FLAG
, INFORMATION42 NORMAL_HOURS
, INFORMATION43 PERF_REVIEW_PERIOD
, INFORMATION44 PERF_REVIEW_PERIOD_FREQUENCY
, INFORMATION45 PERIOD_OF_SERVICE_ID
, INFORMATION46 PROBATION_PERIOD
, INFORMATION47 PROBATION_UNIT
, INFORMATION48 SAL_REVIEW_PERIOD
, INFORMATION49 SAL_REVIEW_PERIOD_FREQUENCY
, INFORMATION50 SET_OF_BOOKS_ID
, INFORMATION51 SOURCE_TYPE
, INFORMATION52 TIME_NORMAL_FINISH
, INFORMATION53 TIME_NORMAL_START
, INFORMATION54 REQUEST_ID
, INFORMATION55 PROGRAM_APPLICATION_ID
, INFORMATION56 PROGRAM_ID
, INFORMATION57 PROGRAM_UPDATE_DATE
, INFORMATION58 ASS_ATTRIBUTE_CATEGORY
, INFORMATION59 ASS_ATTRIBUTE1
, INFORMATION60 ASS_ATTRIBUTE2
, INFORMATION61 ASS_ATTRIBUTE3
, INFORMATION62 ASS_ATTRIBUTE4
, INFORMATION63 ASS_ATTRIBUTE5
, INFORMATION64 ASS_ATTRIBUTE6
, INFORMATION65 ASS_ATTRIBUTE7
, INFORMATION66 ASS_ATTRIBUTE8
, INFORMATION67 ASS_ATTRIBUTE9
, INFORMATION68 ASS_ATTRIBUTE10
, INFORMATION69 ASS_ATTRIBUTE11
, INFORMATION70 ASS_ATTRIBUTE12
, INFORMATION71 ASS_ATTRIBUTE13
, INFORMATION72 ASS_ATTRIBUTE14
, INFORMATION73 ASS_ATTRIBUTE15
, INFORMATION74 ASS_ATTRIBUTE16
, INFORMATION75 ASS_ATTRIBUTE17
, INFORMATION76 ASS_ATTRIBUTE18
, INFORMATION77 ASS_ATTRIBUTE19
, INFORMATION78 ASS_ATTRIBUTE20
, INFORMATION79 ASS_ATTRIBUTE21
, INFORMATION80 ASS_ATTRIBUTE22
, INFORMATION81 ASS_ATTRIBUTE23
, INFORMATION82 ASS_ATTRIBUTE24
, INFORMATION83 ASS_ATTRIBUTE25
, INFORMATION84 ASS_ATTRIBUTE26
, INFORMATION85 ASS_ATTRIBUTE27
, INFORMATION86 ASS_ATTRIBUTE28
, INFORMATION87 ASS_ATTRIBUTE29
, INFORMATION88 ASS_ATTRIBUTE30
, INFORMATION89 LAST_UPDATE_DATE
, INFORMATION90 LAST_UPDATED_BY
, INFORMATION91 LAST_UPDATE_LOGIN
, INFORMATION92 CREATED_BY
, INFORMATION93 CREATION_DATE
, INFORMATION94 TITLE
, INFORMATION95 OBJECT_VERSION_NUMBER
FROM GHR_INTERFACE
WHERE INFORMATION4 = 'PER_ASSIGNMENTS_F'