[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | HR_PERSON_DEPLOYMENTS |
|---|---|
| Object Type: | TABLE |
| Owner: | HR |
| FND Design Data: |  PER.HR_PERSON_DEPLOYMENTS
|
| Subobject Name: | |
| Status: | VALID |
Stores record to relate a single employees periods of work in two different business groups
| Tablespace: |  APPS_TS_TX_DATA |
|---|---|
| PCT Free: | 10 |
| PCT Used: |
| Index | Type | Uniqueness | Tablespace | Column |
|---|---|---|---|---|
| HR_PERSON_DEPLOYMENTS_PK | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
 PERSON_DEPLOYMENT_ID
|
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| PERSON_DEPLOYMENT_ID | NUMBER | (15) | Yes | Unique identifier for the employee's deployment record |
| OBJECT_VERSION_NUMBER | NUMBER | (15) | Yes | Version number of row |
| FROM_BUSINESS_GROUP_ID | NUMBER | (15) | Yes | Employee's business group prior to deployment |
| TO_BUSINESS_GROUP_ID | NUMBER | (15) | Yes | Employee's business group during deployment |
| FROM_PERSON_ID | NUMBER | (15) | Yes | Identifier of person record of home business group |
| TO_PERSON_ID | NUMBER | (15) | Identifier of person record of host business group | |
| PERSON_TYPE_ID | NUMBER | (15) | Person Type | |
| START_DATE | DATE | Yes | Start Date | |
| END_DATE | DATE | End Date | ||
| DEPLOYMENT_REASON | VARCHAR2 | (30) | Reason that employee is being transferred | |
| EMPLOYEE_NUMBER | VARCHAR2 | (30) | Employee number | |
| LEAVING_REASON | VARCHAR2 | (30) | Leaving Reason | |
| LEAVING_PERSON_TYPE_ID | NUMBER | (15) | Termination person type | |
| PERMANENT | VARCHAR2 | (1) | Permanent flag | |
| STATUS | VARCHAR2 | (30) | Yes | Status of deployment |
| STATUS_CHANGE_REASON | VARCHAR2 | (30) | Reason status changed | |
| STATUS_CHANGE_DATE | DATE | Yes | Date of status change | |
| DEPLYMT_POLICY_ID | NUMBER | (15) | Reserved for Oracle future use | |
| ORGANIZATION_ID | NUMBER | (15) | Unique identifier of the Organization | |
| LOCATION_ID | NUMBER | (15) | Unique identifier of the Location for the assignment | |
| JOB_ID | NUMBER | (15) | Unique identifier of the job for the assignment | |
| POSITION_ID | NUMBER | (15) | Unique identifier of the position for the assignment | |
| GRADE_ID | NUMBER | (15) | Unique identifier of the grade for the assignment | |
| SUPERVISOR_ID | NUMBER | (15) | Unique identifier of the manager for the assignment | |
| SUPERVISOR_ASSIGNMENT_ID | NUMBER | (15) | Unique identifier of the assignment which manager performs as supervisor for the assignment | |
| RETAIN_DIRECT_REPORTS | VARCHAR2 | (1) | Identify if employee's direct reports are to be supervised by the new assignment or not | |
| PAYROLL_ID | NUMBER | (15) | Unique identifier of the payroll for the assignment | |
| PAY_BASIS_ID | NUMBER | (15) | Unique identifier of the salary basis for the assignment | |
| PROPOSED_SALARY | VARCHAR2 | (60) | Proposed salary for the deployment | |
| PEOPLE_GROUP_ID | NUMBER | (15) | Unique identifier of the People Group key flexfield combination for the assignment | |
| SOFT_CODING_KEYFLEX_ID | NUMBER | (15) | Unique identifier of the Soft Coded Key Flexfield combination for the assignment | |
| ASSIGNMENT_STATUS_TYPE_ID | NUMBER | (15) | Value to be stored in the employee's assignment when the deployment commences | |
| ASS_STATUS_CHANGE_REASON | VARCHAR2 | (30) | Unique identifier of the assignment status for the assignment | |
| ASSIGNMENT_CATEGORY | VARCHAR2 | (30) | Unique identifier of the assignment category for the assignment | |
| PER_INFORMATION_CATEGORY | VARCHAR2 | (30) | Person Developer Descriptive Flexfield structure defining column | |
| PER_INFORMATION1 | VARCHAR2 | (150) | Person Developer Descriptive Flexfield column | |
| PER_INFORMATION2 | VARCHAR2 | (150) | Person Developer Descriptive Flexfield column | |
| PER_INFORMATION3 | VARCHAR2 | (150) | Person Developer Descriptive Flexfield column | |
| PER_INFORMATION4 | VARCHAR2 | (150) | Person Developer Descriptive Flexfield column | |
| PER_INFORMATION5 | VARCHAR2 | (150) | Person Developer Descriptive Flexfield column | |
| PER_INFORMATION6 | VARCHAR2 | (150) | Person Developer Descriptive Flexfield column | |
| PER_INFORMATION7 | VARCHAR2 | (150) | Person Developer Descriptive Flexfield column | |
| PER_INFORMATION8 | VARCHAR2 | (150) | Person Developer Descriptive Flexfield column | |
| PER_INFORMATION9 | VARCHAR2 | (150) | Person Developer Descriptive Flexfield column | |
| PER_INFORMATION10 | VARCHAR2 | (150) | Person Developer Descriptive Flexfield column | |
| PER_INFORMATION11 | VARCHAR2 | (150) | Person Developer Descriptive Flexfield column | |
| PER_INFORMATION12 | VARCHAR2 | (150) | Person Developer Descriptive Flexfield column | |
| PER_INFORMATION13 | VARCHAR2 | (150) | Person Developer Descriptive Flexfield column | |
| PER_INFORMATION14 | VARCHAR2 | (150) | Person Developer Descriptive Flexfield column | |
| PER_INFORMATION15 | VARCHAR2 | (150) | Person Developer Descriptive Flexfield column | |
| PER_INFORMATION16 | VARCHAR2 | (150) | Person Developer Descriptive Flexfield column | |
| PER_INFORMATION17 | VARCHAR2 | (150) | Person Developer Descriptive Flexfield column | |
| PER_INFORMATION18 | VARCHAR2 | (150) | Person Developer Descriptive Flexfield column | |
| PER_INFORMATION19 | VARCHAR2 | (150) | Person Developer Descriptive Flexfield column | |
| PER_INFORMATION20 | VARCHAR2 | (150) | Person Developer Descriptive Flexfield column | |
| PER_INFORMATION21 | VARCHAR2 | (150) | Person Developer Descriptive Flexfield column | |
| PER_INFORMATION22 | VARCHAR2 | (150) | Person Developer Descriptive Flexfield column | |
| PER_INFORMATION23 | VARCHAR2 | (150) | Person Developer Descriptive Flexfield column | |
| PER_INFORMATION24 | VARCHAR2 | (150) | Person Developer Descriptive Flexfield column | |
| PER_INFORMATION25 | VARCHAR2 | (150) | Person Developer Descriptive Flexfield column | |
| PER_INFORMATION26 | VARCHAR2 | (150) | Person Developer Descriptive Flexfield column | |
| PER_INFORMATION27 | VARCHAR2 | (150) | Person Developer Descriptive Flexfield column | |
| PER_INFORMATION28 | VARCHAR2 | (150) | Person Developer Descriptive Flexfield column | |
| PER_INFORMATION29 | VARCHAR2 | (150) | Person Developer Descriptive Flexfield column | |
| PER_INFORMATION30 | VARCHAR2 | (150) | Person Developer Descriptive Flexfield column | |
| CREATED_BY | NUMBER | (15) | Yes | AOL WHO column |
| CREATION_DATE | DATE | Yes | AOL WHO column | |
| LAST_UPDATED_BY | NUMBER | (15) | Yes | AOL WHO column |
| LAST_UPDATE_DATE | DATE | Yes | AOL WHO column | |
| LAST_UPDATE_LOGIN | NUMBER | (15) | AOL WHO column |
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;
HR.HR_PERSON_DEPLOYMENTS does not reference any database object
HR.HR_PERSON_DEPLOYMENTS is referenced by following:
APPS
HR_PERSON_DEPLOYMENTS
HR_PERSON_DEPLOYMENTS_WHO
PUBLIC
HR_PERSON_DEPLOYMENTS
|
|
|
|