[Home] [Help] [Dependency Information]
Object Name: | HR_PERSON_DEPLOYMENTS# |
---|---|
Object Type: | VIEW |
Owner: | HR |
Subobject Name: | |
Status: | VALID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
PERSON_DEPLOYMENT_ID | NUMBER | (15) | Yes | |
OBJECT_VERSION_NUMBER | NUMBER | (15) | Yes | |
FROM_BUSINESS_GROUP_ID | NUMBER | (15) | Yes | |
TO_BUSINESS_GROUP_ID | NUMBER | (15) | Yes | |
FROM_PERSON_ID | NUMBER | (15) | Yes | |
TO_PERSON_ID | NUMBER | (15) | ||
PERSON_TYPE_ID | NUMBER | (15) | ||
START_DATE | DATE | Yes | ||
END_DATE | DATE | |||
DEPLOYMENT_REASON | VARCHAR2 | (30) | ||
EMPLOYEE_NUMBER | VARCHAR2 | (30) | ||
LEAVING_REASON | VARCHAR2 | (30) | ||
LEAVING_PERSON_TYPE_ID | NUMBER | (15) | ||
PERMANENT | VARCHAR2 | (1) | ||
STATUS | VARCHAR2 | (30) | Yes | |
STATUS_CHANGE_REASON | VARCHAR2 | (30) | ||
STATUS_CHANGE_DATE | DATE | Yes | ||
DEPLYMT_POLICY_ID | NUMBER | (15) | ||
ORGANIZATION_ID | NUMBER | (15) | ||
LOCATION_ID | NUMBER | (15) | ||
JOB_ID | NUMBER | (15) | ||
POSITION_ID | NUMBER | (15) | ||
GRADE_ID | NUMBER | (15) | ||
SUPERVISOR_ID | NUMBER | (15) | ||
SUPERVISOR_ASSIGNMENT_ID | NUMBER | (15) | ||
RETAIN_DIRECT_REPORTS | VARCHAR2 | (1) | ||
PAYROLL_ID | NUMBER | (15) | ||
PAY_BASIS_ID | NUMBER | (15) | ||
PROPOSED_SALARY | VARCHAR2 | (60) | ||
PEOPLE_GROUP_ID | NUMBER | (15) | ||
SOFT_CODING_KEYFLEX_ID | NUMBER | (15) | ||
ASSIGNMENT_STATUS_TYPE_ID | NUMBER | (15) | ||
ASS_STATUS_CHANGE_REASON | VARCHAR2 | (30) | ||
ASSIGNMENT_CATEGORY | VARCHAR2 | (30) | ||
PER_INFORMATION_CATEGORY | VARCHAR2 | (30) | ||
PER_INFORMATION1 | VARCHAR2 | (150) | ||
PER_INFORMATION2 | VARCHAR2 | (150) | ||
PER_INFORMATION3 | VARCHAR2 | (150) | ||
PER_INFORMATION4 | VARCHAR2 | (150) | ||
PER_INFORMATION5 | VARCHAR2 | (150) | ||
PER_INFORMATION6 | VARCHAR2 | (150) | ||
PER_INFORMATION7 | VARCHAR2 | (150) | ||
PER_INFORMATION8 | VARCHAR2 | (150) | ||
PER_INFORMATION9 | VARCHAR2 | (150) | ||
PER_INFORMATION10 | VARCHAR2 | (150) | ||
PER_INFORMATION11 | VARCHAR2 | (150) | ||
PER_INFORMATION12 | VARCHAR2 | (150) | ||
PER_INFORMATION13 | VARCHAR2 | (150) | ||
PER_INFORMATION14 | VARCHAR2 | (150) | ||
PER_INFORMATION15 | VARCHAR2 | (150) | ||
PER_INFORMATION16 | VARCHAR2 | (150) | ||
PER_INFORMATION17 | VARCHAR2 | (150) | ||
PER_INFORMATION18 | VARCHAR2 | (150) | ||
PER_INFORMATION19 | VARCHAR2 | (150) | ||
PER_INFORMATION20 | VARCHAR2 | (150) | ||
PER_INFORMATION21 | VARCHAR2 | (150) | ||
PER_INFORMATION22 | VARCHAR2 | (150) | ||
PER_INFORMATION23 | VARCHAR2 | (150) | ||
PER_INFORMATION24 | VARCHAR2 | (150) | ||
PER_INFORMATION25 | VARCHAR2 | (150) | ||
PER_INFORMATION26 | VARCHAR2 | (150) | ||
PER_INFORMATION27 | VARCHAR2 | (150) | ||
PER_INFORMATION28 | VARCHAR2 | (150) | ||
PER_INFORMATION29 | VARCHAR2 | (150) | ||
PER_INFORMATION30 | VARCHAR2 | (150) | ||
CREATED_BY | NUMBER | (15) | Yes | |
CREATION_DATE | DATE | Yes | ||
LAST_UPDATED_BY | NUMBER | (15) | Yes | |
LAST_UPDATE_DATE | DATE | Yes | ||
LAST_UPDATE_LOGIN | NUMBER | (15) |
Cut, paste (and edit) the following text to query this object:
SELECT PERSON_DEPLOYMENT_ID
, OBJECT_VERSION_NUMBER
, FROM_BUSINESS_GROUP_ID
, TO_BUSINESS_GROUP_ID
, FROM_PERSON_ID
, TO_PERSON_ID
, PERSON_TYPE_ID
, START_DATE
, END_DATE
, DEPLOYMENT_REASON
, EMPLOYEE_NUMBER
, LEAVING_REASON
, LEAVING_PERSON_TYPE_ID
, PERMANENT
, STATUS
, STATUS_CHANGE_REASON
, STATUS_CHANGE_DATE
, DEPLYMT_POLICY_ID
, ORGANIZATION_ID
, LOCATION_ID
, JOB_ID
, POSITION_ID
, GRADE_ID
, SUPERVISOR_ID
, SUPERVISOR_ASSIGNMENT_ID
, RETAIN_DIRECT_REPORTS
, PAYROLL_ID
, PAY_BASIS_ID
, PROPOSED_SALARY
, PEOPLE_GROUP_ID
, SOFT_CODING_KEYFLEX_ID
, ASSIGNMENT_STATUS_TYPE_ID
, ASS_STATUS_CHANGE_REASON
, ASSIGNMENT_CATEGORY
, PER_INFORMATION_CATEGORY
, PER_INFORMATION1
, PER_INFORMATION2
, PER_INFORMATION3
, PER_INFORMATION4
, PER_INFORMATION5
, PER_INFORMATION6
, PER_INFORMATION7
, PER_INFORMATION8
, PER_INFORMATION9
, PER_INFORMATION10
, PER_INFORMATION11
, PER_INFORMATION12
, PER_INFORMATION13
, PER_INFORMATION14
, PER_INFORMATION15
, PER_INFORMATION16
, PER_INFORMATION17
, PER_INFORMATION18
, PER_INFORMATION19
, PER_INFORMATION20
, PER_INFORMATION21
, PER_INFORMATION22
, PER_INFORMATION23
, PER_INFORMATION24
, PER_INFORMATION25
, PER_INFORMATION26
, PER_INFORMATION27
, PER_INFORMATION28
, PER_INFORMATION29
, PER_INFORMATION30
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
FROM HR.HR_PERSON_DEPLOYMENTS#;
|
|
|