APPS.GHR_MT_ASSIGNMENTS_F_V
[Home] [Help]
| 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_ASSIGNMENTS_F_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 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'