[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | PER_DEPLOYMENT_FACTORS# |
|---|---|
| Object Type: | VIEW |
| Owner: | HR |
| Subobject Name: | |
| Status: | VALID |
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| DEPLOYMENT_FACTOR_ID | NUMBER | (9) | Yes | |
| POSITION_ID | NUMBER | (15) | ||
| PERSON_ID | NUMBER | (10) | ||
| JOB_ID | NUMBER | (9) | ||
| BUSINESS_GROUP_ID | NUMBER | (15) | Yes | |
| WORK_ANY_COUNTRY | VARCHAR2 | (30) | Yes | |
| WORK_ANY_LOCATION | VARCHAR2 | (30) | Yes | |
| RELOCATE_DOMESTICALLY | VARCHAR2 | (30) | Yes | |
| RELOCATE_INTERNATIONALLY | VARCHAR2 | (30) | Yes | |
| TRAVEL_REQUIRED | VARCHAR2 | (30) | Yes | |
| COUNTRY1 | VARCHAR2 | (30) | ||
| COUNTRY2 | VARCHAR2 | (30) | ||
| COUNTRY3 | VARCHAR2 | (30) | ||
| WORK_DURATION | VARCHAR2 | (30) | ||
| WORK_SCHEDULE | VARCHAR2 | (30) | ||
| WORK_HOURS | VARCHAR2 | (30) | ||
| FTE_CAPACITY | VARCHAR2 | (30) | ||
| VISIT_INTERNATIONALLY | VARCHAR2 | (30) | ||
| ONLY_CURRENT_LOCATION | VARCHAR2 | (30) | ||
| NO_COUNTRY1 | VARCHAR2 | (30) | ||
| NO_COUNTRY2 | VARCHAR2 | (30) | ||
| NO_COUNTRY3 | VARCHAR2 | (30) | ||
| COMMENTS | VARCHAR2 | (2000) | ||
| EARLIEST_AVAILABLE_DATE | DATE | |||
| AVAILABLE_FOR_TRANSFER | VARCHAR2 | (30) | ||
| RELOCATION_PREFERENCE | VARCHAR2 | (30) | ||
| RELOCATION_REQUIRED | VARCHAR2 | (30) | ||
| PASSPORT_REQUIRED | VARCHAR2 | (30) | ||
| LOCATION1 | VARCHAR2 | (30) | ||
| LOCATION2 | VARCHAR2 | (30) | ||
| LOCATION3 | VARCHAR2 | (30) | ||
| OTHER_REQUIREMENTS | VARCHAR2 | (2000) | ||
| SERVICE_MINIMUM | VARCHAR2 | (30) | ||
| OBJECT_VERSION_NUMBER | NUMBER | (9) | Yes | |
| ATTRIBUTE_CATEGORY | VARCHAR2 | (30) | ||
| ATTRIBUTE1 | VARCHAR2 | (150) | ||
| ATTRIBUTE2 | VARCHAR2 | (150) | ||
| ATTRIBUTE3 | VARCHAR2 | (150) | ||
| ATTRIBUTE4 | VARCHAR2 | (150) | ||
| ATTRIBUTE5 | VARCHAR2 | (150) | ||
| ATTRIBUTE6 | VARCHAR2 | (150) | ||
| ATTRIBUTE7 | VARCHAR2 | (150) | ||
| ATTRIBUTE8 | VARCHAR2 | (150) | ||
| ATTRIBUTE9 | VARCHAR2 | (150) | ||
| ATTRIBUTE10 | VARCHAR2 | (150) | ||
| ATTRIBUTE11 | VARCHAR2 | (150) | ||
| ATTRIBUTE12 | VARCHAR2 | (150) | ||
| ATTRIBUTE13 | VARCHAR2 | (150) | ||
| ATTRIBUTE14 | VARCHAR2 | (150) | ||
| ATTRIBUTE15 | VARCHAR2 | (150) | ||
| ATTRIBUTE16 | VARCHAR2 | (150) | ||
| ATTRIBUTE17 | VARCHAR2 | (150) | ||
| ATTRIBUTE18 | VARCHAR2 | (150) | ||
| ATTRIBUTE19 | VARCHAR2 | (150) | ||
| ATTRIBUTE20 | VARCHAR2 | (150) | ||
| LAST_UPDATE_DATE | DATE | |||
| LAST_UPDATED_BY | NUMBER | (15) | ||
| LAST_UPDATE_LOGIN | NUMBER | (15) | ||
| CREATED_BY | NUMBER | (15) | ||
| CREATION_DATE | DATE |
Cut, paste (and edit) the following text to query this object:
SELECT DEPLOYMENT_FACTOR_ID
, POSITION_ID
, PERSON_ID
, JOB_ID
, BUSINESS_GROUP_ID
, WORK_ANY_COUNTRY
, WORK_ANY_LOCATION
, RELOCATE_DOMESTICALLY
, RELOCATE_INTERNATIONALLY
, TRAVEL_REQUIRED
, COUNTRY1
, COUNTRY2
, COUNTRY3
, WORK_DURATION
, WORK_SCHEDULE
, WORK_HOURS
, FTE_CAPACITY
, VISIT_INTERNATIONALLY
, ONLY_CURRENT_LOCATION
, NO_COUNTRY1
, NO_COUNTRY2
, NO_COUNTRY3
, COMMENTS
, EARLIEST_AVAILABLE_DATE
, AVAILABLE_FOR_TRANSFER
, RELOCATION_PREFERENCE
, RELOCATION_REQUIRED
, PASSPORT_REQUIRED
, LOCATION1
, LOCATION2
, LOCATION3
, OTHER_REQUIREMENTS
, SERVICE_MINIMUM
, OBJECT_VERSION_NUMBER
, ATTRIBUTE_CATEGORY
, ATTRIBUTE1
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE10
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
, ATTRIBUTE16
, ATTRIBUTE17
, ATTRIBUTE18
, ATTRIBUTE19
, ATTRIBUTE20
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
, CREATED_BY
, CREATION_DATE
FROM HR.PER_DEPLOYMENT_FACTORS#;
HR
PER_DEPLOYMENT_FACTORS
APPS
PER_DEPLOYMENT_FACTORS
PER_DEPLOYMENT_FACTORS_WHO
|
|
|
|