DBA Data[Home] [Help]

VIEW: HR.HR_PERSON_DEPLOYMENTS#

Source

View Text - Preformatted

select PERSON_DEPLOYMENT_ID PERSON_DEPLOYMENT_ID, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER, FROM_BUSINESS_GROUP_ID FROM_BUSINESS_GROUP_ID, TO_BUSINESS_GROUP_ID TO_BUSINESS_GROUP_ID, FROM_PERSON_ID FROM_PERSON_ID, TO_PERSON_ID TO_PERSON_ID, PERSON_TYPE_ID PERSON_TYPE_ID, START_DATE START_DATE, END_DATE END_DATE, DEPLOYMENT_REASON DEPLOYMENT_REASON, EMPLOYEE_NUMBER EMPLOYEE_NUMBER, LEAVING_REASON LEAVING_REASON, LEAVING_PERSON_TYPE_ID LEAVING_PERSON_TYPE_ID, PERMANENT PERMANENT, STATUS STATUS, STATUS_CHANGE_REASON STATUS_CHANGE_REASON, STATUS_CHANGE_DATE STATUS_CHANGE_DATE, DEPLYMT_POLICY_ID DEPLYMT_POLICY_ID, ORGANIZATION_ID ORGANIZATION_ID, LOCATION_ID LOCATION_ID, JOB_ID JOB_ID, POSITION_ID POSITION_ID, GRADE_ID GRADE_ID, SUPERVISOR_ID SUPERVISOR_ID, SUPERVISOR_ASSIGNMENT_ID SUPERVISOR_ASSIGNMENT_ID, RETAIN_DIRECT_REPORTS RETAIN_DIRECT_REPORTS, PAYROLL_ID PAYROLL_ID, PAY_BASIS_ID PAY_BASIS_ID, PROPOSED_SALARY PROPOSED_SALARY, PEOPLE_GROUP_ID PEOPLE_GROUP_ID, SOFT_CODING_KEYFLEX_ID SOFT_CODING_KEYFLEX_ID, ASSIGNMENT_STATUS_TYPE_ID ASSIGNMENT_STATUS_TYPE_ID, ASS_STATUS_CHANGE_REASON ASS_STATUS_CHANGE_REASON, ASSIGNMENT_CATEGORY ASSIGNMENT_CATEGORY, PER_INFORMATION_CATEGORY PER_INFORMATION_CATEGORY, PER_INFORMATION1 PER_INFORMATION1, PER_INFORMATION2 PER_INFORMATION2, PER_INFORMATION3 PER_INFORMATION3, PER_INFORMATION4 PER_INFORMATION4, PER_INFORMATION5 PER_INFORMATION5, PER_INFORMATION6 PER_INFORMATION6, PER_INFORMATION7 PER_INFORMATION7, PER_INFORMATION8 PER_INFORMATION8, PER_INFORMATION9 PER_INFORMATION9, PER_INFORMATION10 PER_INFORMATION10, PER_INFORMATION11 PER_INFORMATION11, PER_INFORMATION12 PER_INFORMATION12, PER_INFORMATION13 PER_INFORMATION13, PER_INFORMATION14 PER_INFORMATION14, PER_INFORMATION15 PER_INFORMATION15, PER_INFORMATION16 PER_INFORMATION16, PER_INFORMATION17 PER_INFORMATION17, PER_INFORMATION18 PER_INFORMATION18, PER_INFORMATION19 PER_INFORMATION19, PER_INFORMATION20 PER_INFORMATION20, PER_INFORMATION21 PER_INFORMATION21, PER_INFORMATION22 PER_INFORMATION22, PER_INFORMATION23 PER_INFORMATION23, PER_INFORMATION24 PER_INFORMATION24, PER_INFORMATION25 PER_INFORMATION25, PER_INFORMATION26 PER_INFORMATION26, PER_INFORMATION27 PER_INFORMATION27, PER_INFORMATION28 PER_INFORMATION28, PER_INFORMATION29 PER_INFORMATION29, PER_INFORMATION30 PER_INFORMATION30, CREATED_BY CREATED_BY, CREATION_DATE CREATION_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN from "HR"."HR_PERSON_DEPLOYMENTS"
View Text - HTML Formatted

SELECT PERSON_DEPLOYMENT_ID PERSON_DEPLOYMENT_ID
, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, FROM_BUSINESS_GROUP_ID FROM_BUSINESS_GROUP_ID
, TO_BUSINESS_GROUP_ID TO_BUSINESS_GROUP_ID
, FROM_PERSON_ID FROM_PERSON_ID
, TO_PERSON_ID TO_PERSON_ID
, PERSON_TYPE_ID PERSON_TYPE_ID
, START_DATE START_DATE
, END_DATE END_DATE
, DEPLOYMENT_REASON DEPLOYMENT_REASON
, EMPLOYEE_NUMBER EMPLOYEE_NUMBER
, LEAVING_REASON LEAVING_REASON
, LEAVING_PERSON_TYPE_ID LEAVING_PERSON_TYPE_ID
, PERMANENT PERMANENT
, STATUS STATUS
, STATUS_CHANGE_REASON STATUS_CHANGE_REASON
, STATUS_CHANGE_DATE STATUS_CHANGE_DATE
, DEPLYMT_POLICY_ID DEPLYMT_POLICY_ID
, ORGANIZATION_ID ORGANIZATION_ID
, LOCATION_ID LOCATION_ID
, JOB_ID JOB_ID
, POSITION_ID POSITION_ID
, GRADE_ID GRADE_ID
, SUPERVISOR_ID SUPERVISOR_ID
, SUPERVISOR_ASSIGNMENT_ID SUPERVISOR_ASSIGNMENT_ID
, RETAIN_DIRECT_REPORTS RETAIN_DIRECT_REPORTS
, PAYROLL_ID PAYROLL_ID
, PAY_BASIS_ID PAY_BASIS_ID
, PROPOSED_SALARY PROPOSED_SALARY
, PEOPLE_GROUP_ID PEOPLE_GROUP_ID
, SOFT_CODING_KEYFLEX_ID SOFT_CODING_KEYFLEX_ID
, ASSIGNMENT_STATUS_TYPE_ID ASSIGNMENT_STATUS_TYPE_ID
, ASS_STATUS_CHANGE_REASON ASS_STATUS_CHANGE_REASON
, ASSIGNMENT_CATEGORY ASSIGNMENT_CATEGORY
, PER_INFORMATION_CATEGORY PER_INFORMATION_CATEGORY
, PER_INFORMATION1 PER_INFORMATION1
, PER_INFORMATION2 PER_INFORMATION2
, PER_INFORMATION3 PER_INFORMATION3
, PER_INFORMATION4 PER_INFORMATION4
, PER_INFORMATION5 PER_INFORMATION5
, PER_INFORMATION6 PER_INFORMATION6
, PER_INFORMATION7 PER_INFORMATION7
, PER_INFORMATION8 PER_INFORMATION8
, PER_INFORMATION9 PER_INFORMATION9
, PER_INFORMATION10 PER_INFORMATION10
, PER_INFORMATION11 PER_INFORMATION11
, PER_INFORMATION12 PER_INFORMATION12
, PER_INFORMATION13 PER_INFORMATION13
, PER_INFORMATION14 PER_INFORMATION14
, PER_INFORMATION15 PER_INFORMATION15
, PER_INFORMATION16 PER_INFORMATION16
, PER_INFORMATION17 PER_INFORMATION17
, PER_INFORMATION18 PER_INFORMATION18
, PER_INFORMATION19 PER_INFORMATION19
, PER_INFORMATION20 PER_INFORMATION20
, PER_INFORMATION21 PER_INFORMATION21
, PER_INFORMATION22 PER_INFORMATION22
, PER_INFORMATION23 PER_INFORMATION23
, PER_INFORMATION24 PER_INFORMATION24
, PER_INFORMATION25 PER_INFORMATION25
, PER_INFORMATION26 PER_INFORMATION26
, PER_INFORMATION27 PER_INFORMATION27
, PER_INFORMATION28 PER_INFORMATION28
, PER_INFORMATION29 PER_INFORMATION29
, PER_INFORMATION30 PER_INFORMATION30
, CREATED_BY CREATED_BY
, CREATION_DATE CREATION_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
FROM "HR"."HR_PERSON_DEPLOYMENTS"