[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | HR_PAY_INTERFACE_EMPLOYEES_V |
|---|---|
| Object Type: | VIEW |
| Owner: | APPS |
| Subobject Name: | |
| Status: | VALID |
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| EMPLOYEE_NUMBER | VARCHAR2 | (30) | ||
| BUSINESS_GROUP_NAME | VARCHAR2 | (240) | Yes | |
| LAST_NAME | VARCHAR2 | (150) | Yes | |
| FIRST_NAME | VARCHAR2 | (150) | ||
| MIDDLE_NAMES | VARCHAR2 | (60) | ||
| FULL_NAME | VARCHAR2 | (240) | ||
| SUFFIX | VARCHAR2 | (30) | ||
| TITLE | VARCHAR2 | (30) | ||
| PREFIX | VARCHAR2 | (30) | ||
| DATE_OF_BIRTH | DATE | |||
| MARITAL_STATUS | VARCHAR2 | (30) | ||
| SYSTEM_PERSON_TYPE | VARCHAR2 | (30) | Yes | |
| USER_PERSON_TYPE | VARCHAR2 | (80) | Yes | |
| GENDER | VARCHAR2 | (30) | ||
| NATIONALITY | VARCHAR2 | (30) | ||
| NATIONAL_IDENTIFIER | VARCHAR2 | (30) | ||
| CORRESPONDENCE_LANGUAGE | VARCHAR2 | (30) | ||
| LEAVING_REASON | VARCHAR2 | (30) | ||
| REGISTERED_DISABLED_FLAG | VARCHAR2 | (30) | ||
| DATE_OF_DEATH | DATE | |||
| EMAIL_ADDRESS | VARCHAR2 | (240) | ||
| MAILING_ADDRESS | VARCHAR2 | (30) | ||
| HOME_PHONE_NUMBER | VARCHAR2 | (60) | ||
| WORK_PHONE_NUMBER | VARCHAR2 | (60) | ||
| MOBILE_PHONE_NUMBER | VARCHAR2 | (60) | ||
| ADDRESS_LINE1 | VARCHAR2 | (240) | ||
| ADDRESS_LINE2 | VARCHAR2 | (240) | ||
| ADDRESS_LINE3 | VARCHAR2 | (240) | ||
| TOWN_OR_CITY | VARCHAR2 | (30) | ||
| COUNTRY | VARCHAR2 | (60) | ||
| REGION_1 | VARCHAR2 | (120) | ||
| REGION_2 | VARCHAR2 | (120) | ||
| REGION_3 | VARCHAR2 | (120) | ||
| POSTAL_CODE | VARCHAR2 | (30) | ||
| REHIRE_FLAG | VARCHAR2 | (1) | ||
| ORIGINAL_HIRE_DATE | DATE | Yes | ||
| HIRE_DATE | DATE | Yes | ||
| ACTUAL_TERMINATION_DATE | DATE | |||
| FINAL_PROCESS_DATE | DATE | |||
| PERSON_ID | NUMBER | (10) | Yes | |
| BUSINESS_GROUP_ID | NUMBER | (15) | Yes | |
| 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) | ||
| PER_ATTRIBUTE1 | VARCHAR2 | (150) | ||
| PER_ATTRIBUTE2 | VARCHAR2 | (150) | ||
| PER_ATTRIBUTE3 | VARCHAR2 | (150) | ||
| PER_ATTRIBUTE4 | VARCHAR2 | (150) | ||
| PER_ATTRIBUTE5 | VARCHAR2 | (150) | ||
| PER_ATTRIBUTE6 | VARCHAR2 | (150) | ||
| PER_ATTRIBUTE7 | VARCHAR2 | (150) | ||
| PER_ATTRIBUTE8 | VARCHAR2 | (150) | ||
| PER_ATTRIBUTE9 | VARCHAR2 | (150) | ||
| PER_ATTRIBUTE10 | VARCHAR2 | (150) | ||
| PER_ATTRIBUTE11 | VARCHAR2 | (150) | ||
| PER_ATTRIBUTE12 | VARCHAR2 | (150) | ||
| PER_ATTRIBUTE13 | VARCHAR2 | (150) | ||
| PER_ATTRIBUTE14 | VARCHAR2 | (150) | ||
| PER_ATTRIBUTE15 | VARCHAR2 | (150) | ||
| PER_ATTRIBUTE16 | VARCHAR2 | (150) | ||
| PER_ATTRIBUTE17 | VARCHAR2 | (150) | ||
| PER_ATTRIBUTE18 | VARCHAR2 | (150) | ||
| PER_ATTRIBUTE19 | VARCHAR2 | (150) | ||
| PER_ATTRIBUTE20 | VARCHAR2 | (150) | ||
| ADD_ATTRIBUTE1 | VARCHAR2 | (150) | ||
| ADD_ATTRIBUTE2 | VARCHAR2 | (150) | ||
| ADD_ATTRIBUTE3 | VARCHAR2 | (150) | ||
| ADD_ATTRIBUTE4 | VARCHAR2 | (150) | ||
| ADD_ATTRIBUTE5 | VARCHAR2 | (150) | ||
| ADD_ATTRIBUTE6 | VARCHAR2 | (150) | ||
| ADD_ATTRIBUTE7 | VARCHAR2 | (150) | ||
| ADD_ATTRIBUTE8 | VARCHAR2 | (150) | ||
| ADD_ATTRIBUTE9 | VARCHAR2 | (150) | ||
| ADD_ATTRIBUTE10 | VARCHAR2 | (150) | ||
| ADD_ATTRIBUTE11 | VARCHAR2 | (150) | ||
| ADD_ATTRIBUTE12 | VARCHAR2 | (150) | ||
| ADD_ATTRIBUTE13 | VARCHAR2 | (150) | ||
| ADD_ATTRIBUTE14 | VARCHAR2 | (150) | ||
| ADD_ATTRIBUTE15 | VARCHAR2 | (150) | ||
| ADD_ATTRIBUTE16 | VARCHAR2 | (150) | ||
| ADD_ATTRIBUTE17 | VARCHAR2 | (150) | ||
| ADD_ATTRIBUTE18 | VARCHAR2 | (150) | ||
| ADD_ATTRIBUTE19 | VARCHAR2 | (150) | ||
| ADD_ATTRIBUTE20 | VARCHAR2 | (150) | ||
| POS_ATTRIBUTE1 | VARCHAR2 | (150) | ||
| POS_ATTRIBUTE2 | VARCHAR2 | (150) | ||
| POS_ATTRIBUTE3 | VARCHAR2 | (150) | ||
| POS_ATTRIBUTE4 | VARCHAR2 | (150) | ||
| POS_ATTRIBUTE5 | VARCHAR2 | (150) | ||
| POS_ATTRIBUTE6 | VARCHAR2 | (150) | ||
| POS_ATTRIBUTE7 | VARCHAR2 | (150) | ||
| POS_ATTRIBUTE8 | VARCHAR2 | (150) | ||
| POS_ATTRIBUTE9 | VARCHAR2 | (150) | ||
| POS_ATTRIBUTE10 | VARCHAR2 | (150) | ||
| POS_ATTRIBUTE11 | VARCHAR2 | (150) | ||
| POS_ATTRIBUTE12 | VARCHAR2 | (150) | ||
| POS_ATTRIBUTE13 | VARCHAR2 | (150) | ||
| POS_ATTRIBUTE14 | VARCHAR2 | (150) | ||
| POS_ATTRIBUTE15 | VARCHAR2 | (150) | ||
| POS_ATTRIBUTE16 | VARCHAR2 | (150) | ||
| POS_ATTRIBUTE17 | VARCHAR2 | (150) | ||
| POS_ATTRIBUTE18 | VARCHAR2 | (150) | ||
| POS_ATTRIBUTE19 | VARCHAR2 | (150) | ||
| POS_ATTRIBUTE20 | VARCHAR2 | (150) | ||
| PHO_ATTRIBUTE1 | VARCHAR2 | (150) | ||
| PHO_ATTRIBUTE2 | VARCHAR2 | (150) | ||
| PHO_ATTRIBUTE3 | VARCHAR2 | (150) | ||
| PHO_ATTRIBUTE4 | VARCHAR2 | (150) | ||
| PHO_ATTRIBUTE5 | VARCHAR2 | (150) | ||
| PHO_ATTRIBUTE6 | VARCHAR2 | (150) | ||
| PHO_ATTRIBUTE7 | VARCHAR2 | (150) | ||
| PHO_ATTRIBUTE8 | VARCHAR2 | (150) | ||
| PHO_ATTRIBUTE9 | VARCHAR2 | (150) | ||
| PHO_ATTRIBUTE10 | VARCHAR2 | (150) | ||
| PHO_ATTRIBUTE11 | VARCHAR2 | (150) | ||
| PHO_ATTRIBUTE12 | VARCHAR2 | (150) | ||
| PHO_ATTRIBUTE13 | VARCHAR2 | (150) | ||
| PHO_ATTRIBUTE14 | VARCHAR2 | (150) | ||
| PHO_ATTRIBUTE15 | VARCHAR2 | (150) | ||
| PHO_ATTRIBUTE16 | VARCHAR2 | (150) | ||
| PHO_ATTRIBUTE17 | VARCHAR2 | (150) | ||
| PHO_ATTRIBUTE18 | VARCHAR2 | (150) | ||
| PHO_ATTRIBUTE19 | VARCHAR2 | (150) | ||
| PHO_ATTRIBUTE20 | VARCHAR2 | (150) | ||
| PHO_ATTRIBUTE21 | VARCHAR2 | (150) | ||
| PHO_ATTRIBUTE22 | VARCHAR2 | (150) | ||
| PHO_ATTRIBUTE23 | VARCHAR2 | (150) | ||
| PHO_ATTRIBUTE24 | VARCHAR2 | (150) | ||
| PHO_ATTRIBUTE25 | VARCHAR2 | (150) | ||
| PHO_ATTRIBUTE26 | VARCHAR2 | (150) | ||
| PHO_ATTRIBUTE27 | VARCHAR2 | (150) | ||
| PHO_ATTRIBUTE28 | VARCHAR2 | (150) | ||
| PHO_ATTRIBUTE29 | VARCHAR2 | (150) | ||
| PHO_ATTRIBUTE30 | VARCHAR2 | (150) | ||
| GREATEST_LAST_UPDATE_DATE | DATE | |||
| PER_LAST_UPDATE_DATE | DATE | |||
| ADD_LAST_UPDATE_DATE | DATE | |||
| POS_LAST_UPDATE_DATE | DATE | |||
| PHO_LAST_UPDATE_DATE | DATE | |||
| PHO2_LAST_UPDATE_DATE | DATE | |||
| PPT_LAST_UPDATE_DATE | DATE |
Cut, paste (and edit) the following text to query this object:
SELECT EMPLOYEE_NUMBER
, BUSINESS_GROUP_NAME
, LAST_NAME
, FIRST_NAME
, MIDDLE_NAMES
, FULL_NAME
, SUFFIX
, TITLE
, PREFIX
, DATE_OF_BIRTH
, MARITAL_STATUS
, SYSTEM_PERSON_TYPE
, USER_PERSON_TYPE
, GENDER
, NATIONALITY
, NATIONAL_IDENTIFIER
, CORRESPONDENCE_LANGUAGE
, LEAVING_REASON
, REGISTERED_DISABLED_FLAG
, DATE_OF_DEATH
, EMAIL_ADDRESS
, MAILING_ADDRESS
, HOME_PHONE_NUMBER
, WORK_PHONE_NUMBER
, MOBILE_PHONE_NUMBER
, ADDRESS_LINE1
, ADDRESS_LINE2
, ADDRESS_LINE3
, TOWN_OR_CITY
, COUNTRY
, REGION_1
, REGION_2
, REGION_3
, POSTAL_CODE
, REHIRE_FLAG
, ORIGINAL_HIRE_DATE
, HIRE_DATE
, ACTUAL_TERMINATION_DATE
, FINAL_PROCESS_DATE
, PERSON_ID
, BUSINESS_GROUP_ID
, 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
, PER_ATTRIBUTE1
, PER_ATTRIBUTE2
, PER_ATTRIBUTE3
, PER_ATTRIBUTE4
, PER_ATTRIBUTE5
, PER_ATTRIBUTE6
, PER_ATTRIBUTE7
, PER_ATTRIBUTE8
, PER_ATTRIBUTE9
, PER_ATTRIBUTE10
, PER_ATTRIBUTE11
, PER_ATTRIBUTE12
, PER_ATTRIBUTE13
, PER_ATTRIBUTE14
, PER_ATTRIBUTE15
, PER_ATTRIBUTE16
, PER_ATTRIBUTE17
, PER_ATTRIBUTE18
, PER_ATTRIBUTE19
, PER_ATTRIBUTE20
, ADD_ATTRIBUTE1
, ADD_ATTRIBUTE2
, ADD_ATTRIBUTE3
, ADD_ATTRIBUTE4
, ADD_ATTRIBUTE5
, ADD_ATTRIBUTE6
, ADD_ATTRIBUTE7
, ADD_ATTRIBUTE8
, ADD_ATTRIBUTE9
, ADD_ATTRIBUTE10
, ADD_ATTRIBUTE11
, ADD_ATTRIBUTE12
, ADD_ATTRIBUTE13
, ADD_ATTRIBUTE14
, ADD_ATTRIBUTE15
, ADD_ATTRIBUTE16
, ADD_ATTRIBUTE17
, ADD_ATTRIBUTE18
, ADD_ATTRIBUTE19
, ADD_ATTRIBUTE20
, POS_ATTRIBUTE1
, POS_ATTRIBUTE2
, POS_ATTRIBUTE3
, POS_ATTRIBUTE4
, POS_ATTRIBUTE5
, POS_ATTRIBUTE6
, POS_ATTRIBUTE7
, POS_ATTRIBUTE8
, POS_ATTRIBUTE9
, POS_ATTRIBUTE10
, POS_ATTRIBUTE11
, POS_ATTRIBUTE12
, POS_ATTRIBUTE13
, POS_ATTRIBUTE14
, POS_ATTRIBUTE15
, POS_ATTRIBUTE16
, POS_ATTRIBUTE17
, POS_ATTRIBUTE18
, POS_ATTRIBUTE19
, POS_ATTRIBUTE20
, PHO_ATTRIBUTE1
, PHO_ATTRIBUTE2
, PHO_ATTRIBUTE3
, PHO_ATTRIBUTE4
, PHO_ATTRIBUTE5
, PHO_ATTRIBUTE6
, PHO_ATTRIBUTE7
, PHO_ATTRIBUTE8
, PHO_ATTRIBUTE9
, PHO_ATTRIBUTE10
, PHO_ATTRIBUTE11
, PHO_ATTRIBUTE12
, PHO_ATTRIBUTE13
, PHO_ATTRIBUTE14
, PHO_ATTRIBUTE15
, PHO_ATTRIBUTE16
, PHO_ATTRIBUTE17
, PHO_ATTRIBUTE18
, PHO_ATTRIBUTE19
, PHO_ATTRIBUTE20
, PHO_ATTRIBUTE21
, PHO_ATTRIBUTE22
, PHO_ATTRIBUTE23
, PHO_ATTRIBUTE24
, PHO_ATTRIBUTE25
, PHO_ATTRIBUTE26
, PHO_ATTRIBUTE27
, PHO_ATTRIBUTE28
, PHO_ATTRIBUTE29
, PHO_ATTRIBUTE30
, GREATEST_LAST_UPDATE_DATE
, PER_LAST_UPDATE_DATE
, ADD_LAST_UPDATE_DATE
, POS_LAST_UPDATE_DATE
, PHO_LAST_UPDATE_DATE
, PHO2_LAST_UPDATE_DATE
, PPT_LAST_UPDATE_DATE
FROM APPS.HR_PAY_INTERFACE_EMPLOYEES_V;
APPS
HR_ALL_ORGANIZATION_UNITS
HR_PAY_INTERFACE_PKG
- show dependent code
PER_ADDRESSES
PER_ALL_PEOPLE_F
PER_PERIODS_OF_SERVICE
PER_PERSON_TYPES
PER_PHONES
APPS.HR_PAY_INTERFACE_EMPLOYEES_V is not referenced by any database object
|
|
|
|