DBA Data[Home] [Help] [Dependency Information]

VIEW: APPS.HR_EMPLOYEE_API_V

Object Details
Object Name: HR_EMPLOYEE_API_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewPER.HR_EMPLOYEE_API_V
Subobject Name:
Status: VALID

***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.

View Type

Internal

[View Source]

Columns
Name Datatype Length Mandatory Comments
PERSON_ID NUMBER (10) Yes System generated person primary key from PER_PEOPLE_S.
EFFECTIVE_START_DATE DATE
Yes Effective start date.
EFFECTIVE_END_DATE DATE
Yes Effective end date.
BUSINESS_GROUP_ID NUMBER (15) Yes Foreign key to HR_ORGANIZATION_UNITS.
PERSON_TYPE_ID NUMBER (15) Yes Foreign key to PER_PERSON_TYPES.
LAST_NAME VARCHAR2 (150) Yes Last name of the person, (surname, family name).
START_DATE DATE
Yes Start date for the person (not the DateTrack attribute).
APPLICANT_NUMBER VARCHAR2 (30)
Number assigned to person if ever classed as an applicant.
BACKGROUND_CHECK_STATUS VARCHAR2 (30)
Background check status.
BACKGROUND_DATE_CHECK DATE

Background date check.
BLOOD_TYPE VARCHAR2 (30)
Blood group.
COMMENT_ID NUMBER (15)
Foreign key reference to remark.
CORRESPONDENCE_LANGUAGE VARCHAR2 (30)
Correspondence Language validated against FND_LANGUAGES.
CURRENT_APPLICANT_FLAG VARCHAR2 (30)
Yes or null.
CURRENT_EMP_OR_APL_FLAG VARCHAR2 (30)
Yes or null.
CURRENT_EMPLOYEE_FLAG VARCHAR2 (30)
Yes or null.
DATE_EMPLOYEE_DATA_VERIFIED DATE

Date when the employee last verified the data.
DATE_OF_BIRTH DATE

Date of birth.
EMAIL_ADDRESS VARCHAR2 (240)
Holds actual email identifier.
EMPLOYEE_NUMBER VARCHAR2 (30)
Number assigned to a person if they have been an employee.
EXPENSE_CHECK_SEND_TO_ADDRESS VARCHAR2 (30)
Mailing address.
FAST_PATH_EMPLOYEE VARCHAR2 (30)
Currently unsupported.
FIRST_NAME VARCHAR2 (150)
First name of person.
FTE_CAPACITY NUMBER (5)
Full-time employment capacity.
FULL_NAME VARCHAR2 (240)
Concatenation of last name, title, first name, middle names and the name the person is known by.
HOLD_APPLICANT_DATE_UNTIL DATE

Hold applicant until.
HONORS VARCHAR2 (45)
Honors.
INTERNAL_LOCATION VARCHAR2 (45)
Internal location.
KNOWN_AS VARCHAR2 (80)
Preferred name, if different from first name.
LAST_MEDICAL_TEST_BY VARCHAR2 (60)
Last medical test by.
LAST_MEDICAL_TEST_DATE DATE

Last medical test date.
MAILSTOP VARCHAR2 (45)
Internal mail location.
MARITAL_STATUS VARCHAR2 (30)
Marital status.
MIDDLE_NAMES VARCHAR2 (60)
Middle names.
NATIONALITY VARCHAR2 (30)
Nationality.
NATIONAL_IDENTIFIER VARCHAR2 (30)
Number by which a person is identified in a given legislation.
OFFICE_NUMBER VARCHAR2 (45)
Office number.
ON_MILITARY_SERVICE VARCHAR2 (30)
On military service.
ORDER_NAME VARCHAR2 (240)
Concatenated name used for ordering on select.
PRE_NAME_ADJUNCT VARCHAR2 (30)
Name prefix.
PREVIOUS_LAST_NAME VARCHAR2 (150)
Previous last name of person (if applicable).
PROJECTED_START_DATE DATE

Currently unsupported.
REHIRE_AUTHORIZOR VARCHAR2 (30)
Currently unsupported.
REHIRE_REASON VARCHAR2 (60)
Reason for re-hiring.
REHIRE_RECOMMENDATION VARCHAR2 (30)
Re-hire recommendation.
RESUME_EXISTS VARCHAR2 (30)
Resume exists.
RESUME_LAST_UPDATED DATE

Date resume last updated.
REGISTERED_DISABLED_FLAG VARCHAR2 (30)
Flag indicating whether person is classified as disabled.
SECOND_PASSPORT_EXISTS VARCHAR2 (30)
Second passport available flag.
SEX VARCHAR2 (30)
Legal gender.
STUDENT_STATUS VARCHAR2 (30)
Student status.
SUFFIX VARCHAR2 (30)
Suffix after the surname e.g. Sr., Jr., III
TITLE VARCHAR2 (30)
Title e.g. Mr, Mrs, Dr.
VENDOR_ID NUMBER (15)
Not used.
WORK_SCHEDULE VARCHAR2 (30)
Work schedule.
WORK_TELEPHONE VARCHAR2 (60)
Unsupported.
COORD_BEN_MED_PLN_NO VARCHAR2 (30)
Coordination of benefits medical group plan number.
COORD_BEN_NO_CVG_FLAG VARCHAR2 (30)
Coordination of benefits no other coverage flag
DPDNT_ADOPTION_DATE DATE

Dependent adoption date
DPDNT_VLNTRY_SVCE_FLAG VARCHAR2 (30)
Dependent voluntary service flag
RECEIPT_OF_DEATH_CERT_DATE DATE

Receipt of death certificate date
USES_TOBACCO_FLAG VARCHAR2 (30)
Uses tabacco flag
BENEFIT_GROUP_ID NUMBER (15)
Foreign key to benefits group table.
REQUEST_ID NUMBER (15)
Standard Who Column.
ATTRIBUTE_CATEGORY VARCHAR2 (30)
Descriptive flexfield structure defining column.
PER_ATTRIBUTE1 VARCHAR2 (150)
Descriptive flexfield column.
PER_ATTRIBUTE2 VARCHAR2 (150)
Descriptive flexfield column.
PER_ATTRIBUTE3 VARCHAR2 (150)
Descriptive flexfield column.
PER_ATTRIBUTE4 VARCHAR2 (150)
Descriptive flexfield column.
PER_ATTRIBUTE5 VARCHAR2 (150)
Descriptive flexfield column.
PER_ATTRIBUTE6 VARCHAR2 (150)
Descriptive flexfield column.
PER_ATTRIBUTE7 VARCHAR2 (150)
Descriptive flexfield column.
PER_ATTRIBUTE8 VARCHAR2 (150)
Descriptive flexfield column.
PER_ATTRIBUTE9 VARCHAR2 (150)
Descriptive flexfield column.
PER_ATTRIBUTE10 VARCHAR2 (150)
Descriptive flexfield column.
PER_ATTRIBUTE11 VARCHAR2 (150)
Descriptive flexfield column.
PER_ATTRIBUTE12 VARCHAR2 (150)
Descriptive flexfield column.
PER_ATTRIBUTE13 VARCHAR2 (150)
Descriptive flexfield column.
PER_ATTRIBUTE14 VARCHAR2 (150)
Descriptive flexfield column.
PER_ATTRIBUTE15 VARCHAR2 (150)
Descriptive flexfield column.
PER_ATTRIBUTE16 VARCHAR2 (150)
Descriptive flexfield column.
PER_ATTRIBUTE17 VARCHAR2 (150)
Descriptive flexfield column.
PER_ATTRIBUTE18 VARCHAR2 (150)
Descriptive flexfield column.
PER_ATTRIBUTE19 VARCHAR2 (150)
Descriptive flexfield column.
PER_ATTRIBUTE20 VARCHAR2 (150)
Descriptive flexfield column.
PER_ATTRIBUTE21 VARCHAR2 (150)
Descriptive flexfield column.
PER_ATTRIBUTE22 VARCHAR2 (150)
Descriptive flexfield column.
PER_ATTRIBUTE23 VARCHAR2 (150)
Descriptive flexfield column.
PER_ATTRIBUTE24 VARCHAR2 (150)
Descriptive flexfield column.
PER_ATTRIBUTE25 VARCHAR2 (150)
Descriptive flexfield column.
PER_ATTRIBUTE26 VARCHAR2 (150)
Descriptive flexfield column.
PER_ATTRIBUTE27 VARCHAR2 (150)
Descriptive flexfield column.
PER_ATTRIBUTE28 VARCHAR2 (150)
Descriptive flexfield column.
PER_ATTRIBUTE29 VARCHAR2 (150)
Descriptive flexfield column.
PER_ATTRIBUTE30 VARCHAR2 (150)
Descriptive flexfield column.
PER_INFORMATION_CATEGORY VARCHAR2 (30)
Developer descriptive flexfield column.
PER_INFORMATION1 VARCHAR2 (150)
Developer descriptive flexfield column.
PER_INFORMATION2 VARCHAR2 (150)
Developer descriptive flexfield column.
PER_INFORMATION3 VARCHAR2 (150)
Developer descriptive flexfield column.
PER_INFORMATION4 VARCHAR2 (150)
Developer descriptive flexfield column.
PER_INFORMATION5 VARCHAR2 (150)
Developer descriptive flexfield column.
PER_INFORMATION6 VARCHAR2 (150)
Developer descriptive flexfield column.
PER_INFORMATION7 VARCHAR2 (150)
Developer descriptive flexfield column.
PER_INFORMATION8 VARCHAR2 (150)
Developer descriptive flexfield column.
PER_INFORMATION9 VARCHAR2 (150)
Developer descriptive flexfield column.
PER_INFORMATION10 VARCHAR2 (150)
Developer descriptive flexfield column.
PER_INFORMATION11 VARCHAR2 (150)
Developer descriptive flexfield column.
PER_INFORMATION12 VARCHAR2 (150)
Developer descriptive flexfield column.
PER_INFORMATION13 VARCHAR2 (150)
Developer descriptive flexfield column.
PER_INFORMATION14 VARCHAR2 (150)
Developer descriptive flexfield column.
PER_INFORMATION15 VARCHAR2 (150)
Developer descriptive flexfield column.
PER_INFORMATION16 VARCHAR2 (150)
Developer descriptive flexfield column.
PER_INFORMATION17 VARCHAR2 (150)
Developer descriptive flexfield column.
PER_INFORMATION18 VARCHAR2 (150)
Developer descriptive flexfield column.
PER_INFORMATION19 VARCHAR2 (150)
Developer descriptive flexfield column.
PER_INFORMATION20 VARCHAR2 (150)
Developer descriptive flexfield column.
PER_INFORMATION21 VARCHAR2 (150)
Developer descriptive flexfield.
PER_INFORMATION22 VARCHAR2 (150)
Developer descriptive flexfield.
PER_INFORMATION23 VARCHAR2 (150)
Developer descriptive flexfield.
PER_INFORMATION24 VARCHAR2 (150)
Developer descriptive flexfield.
PER_INFORMATION25 VARCHAR2 (150)
Developer descriptive flexfield.
PER_INFORMATION26 VARCHAR2 (150)
Developer descriptive flexfield.
PER_INFORMATION27 VARCHAR2 (150)
Developer descriptive flexfield.
PER_INFORMATION28 VARCHAR2 (150)
Developer descriptive flexfield.
PER_INFORMATION29 VARCHAR2 (150)
Developer descriptive flexfield.
PER_INFORMATION30 VARCHAR2 (150)
Developer descriptive flexfield.
PER_OBJECT_VERSION_NUMBER NUMBER (9)
System-generated version of row. Increments by one with each update.
DATE_OF_DEATH DATE

Date of death.
ORIGINAL_DATE_OF_HIRE DATE

Original date of hire.
TOWN_OF_BIRTH VARCHAR2 (90)
Town that the person was born in
REGION_OF_BIRTH VARCHAR2 (90)
Region that the person was born in
COUNTRY_OF_BIRTH VARCHAR2 (90)
Country that the person was born in
GLOBAL_PERSON_ID VARCHAR2 (30)
Global person identifier.
COORD_BEN_MED_PL_NAME VARCHAR2 (80)
Benefits: Medical plan name.
COORD_BEN_MED_INSR_CRR_NAME VARCHAR2 (80)
Benefits: Insurance carrier name.
COORD_BEN_MED_INSR_CRR_IDENT VARCHAR2 (80)
Benefits: Insurance carrier identification number.
COORD_BEN_MED_EXT_ER VARCHAR2 (80)
Used for benefits.
COORD_BEN_MED_CVG_STRT_DT DATE

Benefits: start date of coverage plan.
COORD_BEN_MED_CVG_END_DT DATE

Benefits: end date of coverage plan.
PARTY_ID NUMBER (15)
Party identifier.
NPW_NUMBER VARCHAR2 (30)
Number for non-payrolled worker
CURRENT_NPW_FLAG VARCHAR2 (30)
Indicator of non-payrolled worker status
ASSIGNMENT_ID NUMBER (10) Yes System-generated primary key column.
ASG_EFFECTIVE_START_DATE DATE
Yes Effective start date.
ASG_EFFECTIVE_END_DATE DATE
Yes Effective end date.
ASG_BUSINESS_GROUP_ID NUMBER (15) Yes Foreign key to HR_ORGANIZATION_UNITS.
RECRUITER_ID NUMBER (10)
Foreign key to PER_PEOPLE.
GRADE_ID NUMBER (15)
Foreign key to PER_GRADES.
POSITION_ID NUMBER (15)
Foreign key to PER_ALL_POSITIONS.
JOB_ID NUMBER (15)
Foreign key to PER_JOBS.
ASSIGNMENT_STATUS_TYPE_ID NUMBER (9) Yes Foreign key to PER_ASSIGNMENT_STATUS_TYPES.
PAYROLL_ID NUMBER (9)
Foreign key to PAY_PAYROLLS.
LOCATION_ID NUMBER (15)
Foreign key to HR_LOCATIONS.
PERSON_REFERRED_BY_ID NUMBER (10)
Foreign key to PER_PEOPLE.
SUPERVISOR_ID NUMBER (10)
Foreign key to PER_PEOPLE.
SPECIAL_CEILING_STEP_ID NUMBER (15)
Foreign key to PER_SPINAL_POINT_STEPS.
RECRUITMENT_ACTIVITY_ID NUMBER (15)
Foreign key to PER_RECRUITMENT_ACTIVITIES.
SOURCE_ORGANIZATION_ID NUMBER (15)
Foreign key to HR_ORGANIZATION_UNITS.
ORGANIZATION_ID NUMBER (15) Yes Foreign key to HR_ORGANIZATION_UNITS.
PEOPLE_GROUP_ID NUMBER (15)
Foreign key to PAY_PEOPLE_GROUPS.
SOFT_CODING_KEYFLEX_ID NUMBER (15)
Foreign key to HR_SOFT_CODING_KEYFLEX.
VACANCY_ID NUMBER (15)
Foreign key to PER_ALL_VACANCIES.
PAY_BASIS_ID NUMBER (9)
Foreign key to PER_PAY_BASES.
ASSIGNMENT_SEQUENCE NUMBER (15) Yes Used when defaulting assignment number.
ASSIGNMENT_TYPE VARCHAR2 (1) Yes Assignment type; (E)mployee or (A)pplicant.
PRIMARY_FLAG VARCHAR2 (30) Yes Indicates primary employee assignment. Y/N.
APPLICATION_ID NUMBER (15)
Foreign key to PER_APPLICATIONS.
ASSIGNMENT_NUMBER VARCHAR2 (30)
Employee assignment number.
CHANGE_REASON VARCHAR2 (30)
Reason the assignment last changed.
ASG_COMMENT_ID NUMBER (15)
Foreign key reference to HR_COMMENTS.
DATE_PROBATION_END DATE

End date of probation period.
DEFAULT_CODE_COMB_ID NUMBER (15)
Foreign key to GL_CODE_COMBINATIONS.
EMPLOYMENT_CATEGORY VARCHAR2 (30)
User defined category. For example Full-Time Permanent or Part-Time Permanent.
FREQUENCY VARCHAR2 (30)
Frequency of normal working hours, - week, month, year.
INTERNAL_ADDRESS_LINE VARCHAR2 (80)
Internal address details such as floor or office number.
MANAGER_FLAG VARCHAR2 (30)
Indicates whether the employee in this assignment is designated a manager.
NORMAL_HOURS NUMBER (22)
Normal working hours.
PERF_REVIEW_PERIOD NUMBER (15)
Number of units of time between performance reviews.
PERF_REVIEW_PERIOD_FREQUENCY VARCHAR2 (30)
Frequency units. Used with PERF_REVIEW_PERIOD to define time between reviews.
PERIOD_OF_SERVICE_ID NUMBER (15)
Foreign key to PER_PERIODS_OF_SERVICE.
PROBATION_PERIOD NUMBER (22)
Duration of probation period.
PROBATION_UNIT VARCHAR2 (30)
Units of probation period duration.
SAL_REVIEW_PERIOD NUMBER (15)
Length of time between salary reviews.
SAL_REVIEW_PERIOD_FREQUENCY VARCHAR2 (30)
Used with SAL REVIEW PERIOD to define time between salary reviews.
SET_OF_BOOKS_ID NUMBER (15)
Foreign key to GL_SETS_OF_BOOKS.
SOURCE_TYPE VARCHAR2 (30)
Recruitment activity source for applicant assignment, for example, Advertisement).
TIME_NORMAL_FINISH VARCHAR2 (5)
Work day normal end time.
TIME_NORMAL_START VARCHAR2 (5)
Work day normal start time.
BARGAINING_UNIT_CODE VARCHAR2 (30)
Bargaining unit code
LABOUR_UNION_MEMBER_FLAG VARCHAR2 (30)
Labour union member flag
HOURLY_SALARIED_CODE VARCHAR2 (30)
Identifies if the assignment is paid by the hour or by a salary.
CONTRACT_ID NUMBER (9)
Foreign key to PER_CONTRACTS_F
COLLECTIVE_AGREEMENT_ID NUMBER (9)
Foreign key to PER_COLLECTIVE_AGREEMENTS
CAGR_ID_FLEX_NUM NUMBER (15)
Keyflex Structure Identifier for Collectively Agreed Grade
CAGR_GRADE_DEF_ID NUMBER (15)
Foreign key to PER_CAGR_GRADES_DEF
ESTABLISHMENT_ID NUMBER (15)
Foreign key to HR_ORGANIZATION_UNITS
ASG_REQUEST_ID NUMBER (15)
Standard Who column.
ASS_ATTRIBUTE_CATEGORY VARCHAR2 (30)
Descriptive flexfield column.
ASS_ATTRIBUTE1 VARCHAR2 (150)
Descriptive flexfield column.
ASS_ATTRIBUTE2 VARCHAR2 (150)
Descriptive flexfield column.
ASS_ATTRIBUTE3 VARCHAR2 (150)
Descriptive flexfield column.
ASS_ATTRIBUTE4 VARCHAR2 (150)
Descriptive flexfield column.
ASS_ATTRIBUTE5 VARCHAR2 (150)
Descriptive flexfield column.
ASS_ATTRIBUTE6 VARCHAR2 (150)
Descriptive flexfield column.
ASS_ATTRIBUTE7 VARCHAR2 (150)
Descriptive flexfield column.
ASS_ATTRIBUTE8 VARCHAR2 (150)
Descriptive flexfield column.
ASS_ATTRIBUTE9 VARCHAR2 (150)
Descriptive flexfield column.
ASS_ATTRIBUTE10 VARCHAR2 (150)
Descriptive flexfield column.
ASS_ATTRIBUTE11 VARCHAR2 (150)
Descriptive flexfield column.
ASS_ATTRIBUTE12 VARCHAR2 (150)
Descriptive flexfield column.
ASS_ATTRIBUTE13 VARCHAR2 (150)
Descriptive flexfield column.
ASS_ATTRIBUTE14 VARCHAR2 (150)
Descriptive flexfield column.
ASS_ATTRIBUTE15 VARCHAR2 (150)
Descriptive flexfield column.
ASS_ATTRIBUTE16 VARCHAR2 (150)
Descriptive flexfield column.
ASS_ATTRIBUTE17 VARCHAR2 (150)
Descriptive flexfield column.
ASS_ATTRIBUTE18 VARCHAR2 (150)
Descriptive flexfield column.
ASS_ATTRIBUTE19 VARCHAR2 (150)
Descriptive flexfield column.
ASS_ATTRIBUTE20 VARCHAR2 (150)
Descriptive flexfield column.
ASS_ATTRIBUTE21 VARCHAR2 (150)
Descriptive flexfield column.
ASS_ATTRIBUTE22 VARCHAR2 (150)
Descriptive flexfield column.
ASS_ATTRIBUTE23 VARCHAR2 (150)
Descriptive flexfield column.
ASS_ATTRIBUTE24 VARCHAR2 (150)
Descriptive flexfield column.
ASS_ATTRIBUTE25 VARCHAR2 (150)
Descriptive flexfield column.
ASS_ATTRIBUTE26 VARCHAR2 (150)
Descriptive flexfield column.
ASS_ATTRIBUTE27 VARCHAR2 (150)
Descriptive flexfield column.
ASS_ATTRIBUTE28 VARCHAR2 (150)
Descriptive flexfield column.
ASS_ATTRIBUTE29 VARCHAR2 (150)
Descriptive flexfield column.
ASS_ATTRIBUTE30 VARCHAR2 (150)
Descriptive flexfield column.
ASG_TITLE VARCHAR2 (30)
Title for assignment.
OBJECT_VERSION_NUMBER NUMBER (9)
System-generated version of row. Increments by one with each update.
NOTICE_PERIOD NUMBER (10)
NOTICE_PERIOD_UOM VARCHAR2 (30)
EMPLOYEE_CATEGORY VARCHAR2 (30)
WORK_AT_HOME VARCHAR2 (30)
JOB_POST_SOURCE_NAME VARCHAR2 (240)
POSTING_CONTENT_ID NUMBER (15)
The posting to which the applicant has applied.
PERIOD_OF_PLACEMENT_DATE_START DATE

Part of foreign key to per_periods_of_placement
ASG_VENDOR_ID NUMBER (15)
Foreign key reference to po_vendors
VENDOR_EMPLOYEE_NUMBER VARCHAR2 (30)
Employee number of worker with vending organization
VENDOR_ASSIGNMENT_NUMBER VARCHAR2 (30)
Assignment number of non-payrolled worker assignment with vending organization
ASSIGNMENT_CATEGORY VARCHAR2 (30)
Category of assignment
PROJECT_TITLE VARCHAR2 (30)
Title of project of which this assignment forms part
POS_PERIOD_OF_SERVICE_ID NUMBER (9) Yes System generated period of service primary key from PER_PERIODS_OF_SERVICE_S.
POS_BUSINESS_GROUP_ID NUMBER (15) Yes Foreign key to HR_ORGANIZATION_UNITS.
TERMINATION_ACCEPTED_PERSON_ID NUMBER (10)
Foreign key to PER_PEOPLE. Person who accepted or authorized employee termination.
POS_PERSON_ID NUMBER (10) Yes Foreign key to PER_PEOPLE.
DATE_START DATE
Yes Start date of the period of employment.
ACCEPTED_TERMINATION_DATE DATE

Date when termination of employment was accepted.
ACTUAL_TERMINATION_DATE DATE

Actual date of termination of employment.
COMMENTS CLOB (4000)
General remark.
FINAL_PROCESS_DATE DATE

Final date for all payroll processing of this person.
LAST_STANDARD_PROCESS_DATE DATE

Last date for including the person in any standard payroll processing.
LEAVING_REASON VARCHAR2 (30)
Reason for termination of employment.
NOTIFIED_TERMINATION_DATE DATE

Date when the termination of employment was noted.
PROJECTED_TERMINATION_DATE DATE

Projected employment termination date, used for information only.
ADJUSTED_SVC_DATE DATE

Previous date of hire.
POS_REQUEST_ID NUMBER (15)
Standard Who Column.
POS_ATTRIBUTE_CATEGORY VARCHAR2 (30)
Descriptive flexfield structure defining column.
POS_ATTRIBUTE1 VARCHAR2 (150)
Descriptive flexfield column.
POS_ATTRIBUTE2 VARCHAR2 (150)
Descriptive flexfield column.
POS_ATTRIBUTE3 VARCHAR2 (150)
Descriptive flexfield column.
POS_ATTRIBUTE4 VARCHAR2 (150)
Descriptive flexfield column.
POS_ATTRIBUTE5 VARCHAR2 (150)
Descriptive flexfield column.
POS_ATTRIBUTE6 VARCHAR2 (150)
Descriptive flexfield column.
POS_ATTRIBUTE7 VARCHAR2 (150)
Descriptive flexfield column.
POS_ATTRIBUTE8 VARCHAR2 (150)
Descriptive flexfield column.
POS_ATTRIBUTE9 VARCHAR2 (150)
Descriptive flexfield column.
POS_ATTRIBUTE10 VARCHAR2 (150)
Descriptive flexfield column.
POS_ATTRIBUTE11 VARCHAR2 (150)
Descriptive flexfield column.
POS_ATTRIBUTE12 VARCHAR2 (150)
Descriptive flexfield column.
POS_ATTRIBUTE13 VARCHAR2 (150)
Descriptive flexfield column.
POS_ATTRIBUTE14 VARCHAR2 (150)
Descriptive flexfield column.
POS_ATTRIBUTE15 VARCHAR2 (150)
Descriptive flexfield column.
POS_ATTRIBUTE16 VARCHAR2 (150)
Descriptive flexfield column.
POS_ATTRIBUTE17 VARCHAR2 (150)
Descriptive flexfield column.
POS_ATTRIBUTE18 VARCHAR2 (150)
Descriptive flexfield column.
POS_ATTRIBUTE19 VARCHAR2 (150)
Descriptive flexfield column.
POS_ATTRIBUTE20 VARCHAR2 (150)
Descriptive flexfield column.
POS_OBJECT_VERSION_NUMBER NUMBER (9)
System-generated version of row. Increments by one with each update.
PRIOR_EMPLOYMENT_SSP_PAID_TO DATE

Date SSP paid to in prior employment. (UK specific).
PRIOR_EMPLOYMENT_SSP_WEEKS NUMBER

Number of weeks SSP paid for in prior employment. (UK specific).
PDS_INFORMATION_CATEGORY VARCHAR2 (30)
Developer descriptive flexfield structure defining column.
PDS_INFORMATION1 VARCHAR2 (150)
Developer descriptive flexfield column.
PDS_INFORMATION2 VARCHAR2 (150)
Developer descriptive flexfield column.
PDS_INFORMATION3 VARCHAR2 (150)
Developer descriptive flexfield column.
PDS_INFORMATION4 VARCHAR2 (150)
Developer descriptive flexfield column.
PDS_INFORMATION5 VARCHAR2 (150)
Developer descriptive flexfield column.
PDS_INFORMATION6 VARCHAR2 (150)
Developer descriptive flexfield column.
PDS_INFORMATION7 VARCHAR2 (150)
Developer descriptive flexfield column.
PDS_INFORMATION8 VARCHAR2 (150)
Developer descriptive flexfield column.
PDS_INFORMATION9 VARCHAR2 (150)
Developer descriptive flexfield column.
PDS_INFORMATION10 VARCHAR2 (150)
Developer descriptive flexfield column.
PDS_INFORMATION11 VARCHAR2 (150)
Developer descriptive flexfield column.
PDS_INFORMATION12 VARCHAR2 (150)
Developer descriptive flexfield column.
PDS_INFORMATION13 VARCHAR2 (150)
Developer descriptive flexfield column.
PDS_INFORMATION14 VARCHAR2 (150)
Developer descriptive flexfield column.
PDS_INFORMATION15 VARCHAR2 (150)
Developer descriptive flexfield column.
PDS_INFORMATION16 VARCHAR2 (150)
Developer descriptive flexfield column.
PDS_INFORMATION17 VARCHAR2 (150)
Developer descriptive flexfield column.
PDS_INFORMATION18 VARCHAR2 (150)
Developer descriptive flexfield column.
PDS_INFORMATION19 VARCHAR2 (150)
Developer descriptive flexfield column.
PDS_INFORMATION20 VARCHAR2 (150)
Developer descriptive flexfield column.
PDS_INFORMATION21 VARCHAR2 (150)
Developer descriptive flexfield column.
PDS_INFORMATION22 VARCHAR2 (150)
Developer descriptive flexfield column.
PDS_INFORMATION23 VARCHAR2 (150)
Developer descriptive flexfield column.
PDS_INFORMATION24 VARCHAR2 (150)
Developer descriptive flexfield column.
PDS_INFORMATION25 VARCHAR2 (150)
Developer descriptive flexfield column.
PDS_INFORMATION26 VARCHAR2 (150)
Developer descriptive flexfield column.
PDS_INFORMATION27 VARCHAR2 (150)
Developer descriptive flexfield column.
PDS_INFORMATION28 VARCHAR2 (150)
Developer descriptive flexfield column.
PDS_INFORMATION29 VARCHAR2 (150)
Developer descriptive flexfield column.
PDS_INFORMATION30 VARCHAR2 (150)
Developer descriptive flexfield column.
ADDR_ADDRESS_ID NUMBER (15)
System-generated primary key column.
ADDR_BUSINESS_GROUP_ID NUMBER (15)
Foreign key to HR_ORGANIZATION_UNITS.
ADDR_PERSON_ID NUMBER (10)
Foreign key to PER_PEOPLE.
ADDR_DATE_FROM DATE

Start date at the address.
ADDR_PRIMARY_FLAG VARCHAR2 (30)
Indicates whether this is the primary address for the person.
ADDR_STYLE VARCHAR2 (30)
Address style - foreign key to FND_TERRITORIES.
ADDR_ADDRESS_LINE1 VARCHAR2 (240)
The first line of the address.
ADDR_ADDRESS_LINE2 VARCHAR2 (240)
The second line of the address.
ADDR_ADDRESS_LINE3 VARCHAR2 (240)
The third line of the address.
ADDR_ADDRESS_TYPE VARCHAR2 (30)
Address type, for example, home, business, weekend.
ADDR_COMMENTS CLOB (4000)
General remark.
ADDR_COUNTRY VARCHAR2 (60)
Country.
ADDR_DATE_TO DATE

End date at this address.
ADDR_POSTAL_CODE VARCHAR2 (30)
National code to identify addresses in a specific country.
ADDR_REGION_1 VARCHAR2 (120)
Primary region in which the address is located.
ADDR_REGION_2 VARCHAR2 (120)
Sub region of region 1 in which the address is located.
ADDR_REGION_3 VARCHAR2 (120)
Sub region of region 2 in which the address is located.
ADDR_TELEPHONE_NUMBER_1 VARCHAR2 (60)
Telephone number for the address.
ADDR_TELEPHONE_NUMBER_2 VARCHAR2 (60)
Second telephone number for the address.
ADDR_TELEPHONE_NUMBER_3 VARCHAR2 (60)
Third telephone number for the address.
ADDR_TOWN_OR_CITY VARCHAR2 (30)
Town or city name.
ADDR_REQUEST_ID NUMBER (15)
Standard Who column.
ADDR_PROGRAM_APPLICATION_ID NUMBER (15)
Standard Who column.
ADDR_PROGRAM_ID NUMBER (15)
Standard Who column.
ADDR_PROGRAM_UPDATE_DATE DATE

Standard Who column.
ADDR_ATTRIBUTE_CATEGORY VARCHAR2 (30)
Developers Descriptive flexfield column.
ADDR_ATTRIBUTE1 VARCHAR2 (150)
Descriptive flexfield column.
ADDR_ATTRIBUTE2 VARCHAR2 (150)
Descriptive flexfield column.
ADDR_ATTRIBUTE3 VARCHAR2 (150)
Descriptive flexfield column.
ADDR_ATTRIBUTE4 VARCHAR2 (150)
Descriptive flexfield column.
ADDR_ATTRIBUTE5 VARCHAR2 (150)
Descriptive flexfield column.
ADDR_ATTRIBUTE6 VARCHAR2 (150)
Descriptive flexfield column.
ADDR_ATTRIBUTE7 VARCHAR2 (150)
Descriptive flexfield column.
ADDR_ATTRIBUTE8 VARCHAR2 (150)
Descriptive flexfield column.
ADDR_ATTRIBUTE9 VARCHAR2 (150)
Descriptive flexfield column.
ADDR_ATTRIBUTE10 VARCHAR2 (150)
Descriptive flexfield column.
ADDR_ATTRIBUTE11 VARCHAR2 (150)
Descriptive flexfield column.
ADDR_ATTRIBUTE12 VARCHAR2 (150)
Descriptive flexfield column.
ADDR_ATTRIBUTE13 VARCHAR2 (150)
Descriptive flexfield column.
ADDR_ATTRIBUTE14 VARCHAR2 (150)
Descriptive flexfield column.
ADDR_ATTRIBUTE15 VARCHAR2 (150)
Descriptive flexfield column.
ADDR_ATTRIBUTE16 VARCHAR2 (150)
Descriptive flexfield column.
ADDR_ATTRIBUTE17 VARCHAR2 (150)
Descriptive flexfield column.
ADDR_ATTRIBUTE18 VARCHAR2 (150)
Descriptive flexfield column.
ADDR_ATTRIBUTE19 VARCHAR2 (150)
Descriptive flexfield column.
ADDR_ATTRIBUTE20 VARCHAR2 (150)
Descriptive flexfield column.
ADDR_LAST_UPDATE_DATE DATE

Standard Who column.
ADDR_LAST_UPDATED_BY NUMBER (15)
Standard Who column.
ADDR_LAST_UPDATE_LOGIN NUMBER (15)
Standard Who column.
ADDR_CREATED_BY NUMBER (15)
Standard Who column.
ADDR_CREATION_DATE DATE

Standard Who column.
ADDR_OBJECT_VERSION_NUMBER NUMBER (9)
System-generated version of row. Increments by one with each update.
ADDR_ADD_INFORMATION13 VARCHAR2 (150)
Developers Descriptive flexfield column.
ADDR_ADD_INFORMATION14 VARCHAR2 (150)
Developers Descriptive flexfield column.
ADDR_ADD_INFORMATION15 VARCHAR2 (150)
Developers Descriptive flexfield column.
ADDR_ADD_INFORMATION16 VARCHAR2 (150)
Developers Descriptive flexfield column.
ADDR_ADD_INFORMATION17 VARCHAR2 (150)
Developers Descriptive flexfield column.
ADDR_ADD_INFORMATION18 VARCHAR2 (150)
Developers Descriptive flexfield column.
ADDR_ADD_INFORMATION19 VARCHAR2 (150)
Developers Descriptive flexfield column.
ADDR_ADD_INFORMATION20 VARCHAR2 (150)
Developers Descriptive flexfield column.
ADDR_PARTY_ID NUMBER (15)
Party Id
ADDR_DERIVED_LOCALE VARCHAR2 (240)
derived locale
Query Text

Cut, paste (and edit) the following text to query this object:


SELECT PERSON_ID
,      EFFECTIVE_START_DATE
,      EFFECTIVE_END_DATE
,      BUSINESS_GROUP_ID
,      PERSON_TYPE_ID
,      LAST_NAME
,      START_DATE
,      APPLICANT_NUMBER
,      BACKGROUND_CHECK_STATUS
,      BACKGROUND_DATE_CHECK
,      BLOOD_TYPE
,      COMMENT_ID
,      CORRESPONDENCE_LANGUAGE
,      CURRENT_APPLICANT_FLAG
,      CURRENT_EMP_OR_APL_FLAG
,      CURRENT_EMPLOYEE_FLAG
,      DATE_EMPLOYEE_DATA_VERIFIED
,      DATE_OF_BIRTH
,      EMAIL_ADDRESS
,      EMPLOYEE_NUMBER
,      EXPENSE_CHECK_SEND_TO_ADDRESS
,      FAST_PATH_EMPLOYEE
,      FIRST_NAME
,      FTE_CAPACITY
,      FULL_NAME
,      HOLD_APPLICANT_DATE_UNTIL
,      HONORS
,      INTERNAL_LOCATION
,      KNOWN_AS
,      LAST_MEDICAL_TEST_BY
,      LAST_MEDICAL_TEST_DATE
,      MAILSTOP
,      MARITAL_STATUS
,      MIDDLE_NAMES
,      NATIONALITY
,      NATIONAL_IDENTIFIER
,      OFFICE_NUMBER
,      ON_MILITARY_SERVICE
,      ORDER_NAME
,      PRE_NAME_ADJUNCT
,      PREVIOUS_LAST_NAME
,      PROJECTED_START_DATE
,      REHIRE_AUTHORIZOR
,      REHIRE_REASON
,      REHIRE_RECOMMENDATION
,      RESUME_EXISTS
,      RESUME_LAST_UPDATED
,      REGISTERED_DISABLED_FLAG
,      SECOND_PASSPORT_EXISTS
,      SEX
,      STUDENT_STATUS
,      SUFFIX
,      TITLE
,      VENDOR_ID
,      WORK_SCHEDULE
,      WORK_TELEPHONE
,      COORD_BEN_MED_PLN_NO
,      COORD_BEN_NO_CVG_FLAG
,      DPDNT_ADOPTION_DATE
,      DPDNT_VLNTRY_SVCE_FLAG
,      RECEIPT_OF_DEATH_CERT_DATE
,      USES_TOBACCO_FLAG
,      BENEFIT_GROUP_ID
,      REQUEST_ID
,      ATTRIBUTE_CATEGORY
,      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
,      PER_ATTRIBUTE21
,      PER_ATTRIBUTE22
,      PER_ATTRIBUTE23
,      PER_ATTRIBUTE24
,      PER_ATTRIBUTE25
,      PER_ATTRIBUTE26
,      PER_ATTRIBUTE27
,      PER_ATTRIBUTE28
,      PER_ATTRIBUTE29
,      PER_ATTRIBUTE30
,      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
,      PER_OBJECT_VERSION_NUMBER
,      DATE_OF_DEATH
,      ORIGINAL_DATE_OF_HIRE
,      TOWN_OF_BIRTH
,      REGION_OF_BIRTH
,      COUNTRY_OF_BIRTH
,      GLOBAL_PERSON_ID
,      COORD_BEN_MED_PL_NAME
,      COORD_BEN_MED_INSR_CRR_NAME
,      COORD_BEN_MED_INSR_CRR_IDENT
,      COORD_BEN_MED_EXT_ER
,      COORD_BEN_MED_CVG_STRT_DT
,      COORD_BEN_MED_CVG_END_DT
,      PARTY_ID
,      NPW_NUMBER
,      CURRENT_NPW_FLAG
,      ASSIGNMENT_ID
,      ASG_EFFECTIVE_START_DATE
,      ASG_EFFECTIVE_END_DATE
,      ASG_BUSINESS_GROUP_ID
,      RECRUITER_ID
,      GRADE_ID
,      POSITION_ID
,      JOB_ID
,      ASSIGNMENT_STATUS_TYPE_ID
,      PAYROLL_ID
,      LOCATION_ID
,      PERSON_REFERRED_BY_ID
,      SUPERVISOR_ID
,      SPECIAL_CEILING_STEP_ID
,      RECRUITMENT_ACTIVITY_ID
,      SOURCE_ORGANIZATION_ID
,      ORGANIZATION_ID
,      PEOPLE_GROUP_ID
,      SOFT_CODING_KEYFLEX_ID
,      VACANCY_ID
,      PAY_BASIS_ID
,      ASSIGNMENT_SEQUENCE
,      ASSIGNMENT_TYPE
,      PRIMARY_FLAG
,      APPLICATION_ID
,      ASSIGNMENT_NUMBER
,      CHANGE_REASON
,      ASG_COMMENT_ID
,      DATE_PROBATION_END
,      DEFAULT_CODE_COMB_ID
,      EMPLOYMENT_CATEGORY
,      FREQUENCY
,      INTERNAL_ADDRESS_LINE
,      MANAGER_FLAG
,      NORMAL_HOURS
,      PERF_REVIEW_PERIOD
,      PERF_REVIEW_PERIOD_FREQUENCY
,      PERIOD_OF_SERVICE_ID
,      PROBATION_PERIOD
,      PROBATION_UNIT
,      SAL_REVIEW_PERIOD
,      SAL_REVIEW_PERIOD_FREQUENCY
,      SET_OF_BOOKS_ID
,      SOURCE_TYPE
,      TIME_NORMAL_FINISH
,      TIME_NORMAL_START
,      BARGAINING_UNIT_CODE
,      LABOUR_UNION_MEMBER_FLAG
,      HOURLY_SALARIED_CODE
,      CONTRACT_ID
,      COLLECTIVE_AGREEMENT_ID
,      CAGR_ID_FLEX_NUM
,      CAGR_GRADE_DEF_ID
,      ESTABLISHMENT_ID
,      ASG_REQUEST_ID
,      ASS_ATTRIBUTE_CATEGORY
,      ASS_ATTRIBUTE1
,      ASS_ATTRIBUTE2
,      ASS_ATTRIBUTE3
,      ASS_ATTRIBUTE4
,      ASS_ATTRIBUTE5
,      ASS_ATTRIBUTE6
,      ASS_ATTRIBUTE7
,      ASS_ATTRIBUTE8
,      ASS_ATTRIBUTE9
,      ASS_ATTRIBUTE10
,      ASS_ATTRIBUTE11
,      ASS_ATTRIBUTE12
,      ASS_ATTRIBUTE13
,      ASS_ATTRIBUTE14
,      ASS_ATTRIBUTE15
,      ASS_ATTRIBUTE16
,      ASS_ATTRIBUTE17
,      ASS_ATTRIBUTE18
,      ASS_ATTRIBUTE19
,      ASS_ATTRIBUTE20
,      ASS_ATTRIBUTE21
,      ASS_ATTRIBUTE22
,      ASS_ATTRIBUTE23
,      ASS_ATTRIBUTE24
,      ASS_ATTRIBUTE25
,      ASS_ATTRIBUTE26
,      ASS_ATTRIBUTE27
,      ASS_ATTRIBUTE28
,      ASS_ATTRIBUTE29
,      ASS_ATTRIBUTE30
,      ASG_TITLE
,      OBJECT_VERSION_NUMBER
,      NOTICE_PERIOD
,      NOTICE_PERIOD_UOM
,      EMPLOYEE_CATEGORY
,      WORK_AT_HOME
,      JOB_POST_SOURCE_NAME
,      POSTING_CONTENT_ID
,      PERIOD_OF_PLACEMENT_DATE_START
,      ASG_VENDOR_ID
,      VENDOR_EMPLOYEE_NUMBER
,      VENDOR_ASSIGNMENT_NUMBER
,      ASSIGNMENT_CATEGORY
,      PROJECT_TITLE
,      POS_PERIOD_OF_SERVICE_ID
,      POS_BUSINESS_GROUP_ID
,      TERMINATION_ACCEPTED_PERSON_ID
,      POS_PERSON_ID
,      DATE_START
,      ACCEPTED_TERMINATION_DATE
,      ACTUAL_TERMINATION_DATE
,      COMMENTS
,      FINAL_PROCESS_DATE
,      LAST_STANDARD_PROCESS_DATE
,      LEAVING_REASON
,      NOTIFIED_TERMINATION_DATE
,      PROJECTED_TERMINATION_DATE
,      ADJUSTED_SVC_DATE
,      POS_REQUEST_ID
,      POS_ATTRIBUTE_CATEGORY
,      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
,      POS_OBJECT_VERSION_NUMBER
,      PRIOR_EMPLOYMENT_SSP_PAID_TO
,      PRIOR_EMPLOYMENT_SSP_WEEKS
,      PDS_INFORMATION_CATEGORY
,      PDS_INFORMATION1
,      PDS_INFORMATION2
,      PDS_INFORMATION3
,      PDS_INFORMATION4
,      PDS_INFORMATION5
,      PDS_INFORMATION6
,      PDS_INFORMATION7
,      PDS_INFORMATION8
,      PDS_INFORMATION9
,      PDS_INFORMATION10
,      PDS_INFORMATION11
,      PDS_INFORMATION12
,      PDS_INFORMATION13
,      PDS_INFORMATION14
,      PDS_INFORMATION15
,      PDS_INFORMATION16
,      PDS_INFORMATION17
,      PDS_INFORMATION18
,      PDS_INFORMATION19
,      PDS_INFORMATION20
,      PDS_INFORMATION21
,      PDS_INFORMATION22
,      PDS_INFORMATION23
,      PDS_INFORMATION24
,      PDS_INFORMATION25
,      PDS_INFORMATION26
,      PDS_INFORMATION27
,      PDS_INFORMATION28
,      PDS_INFORMATION29
,      PDS_INFORMATION30
,      ADDR_ADDRESS_ID
,      ADDR_BUSINESS_GROUP_ID
,      ADDR_PERSON_ID
,      ADDR_DATE_FROM
,      ADDR_PRIMARY_FLAG
,      ADDR_STYLE
,      ADDR_ADDRESS_LINE1
,      ADDR_ADDRESS_LINE2
,      ADDR_ADDRESS_LINE3
,      ADDR_ADDRESS_TYPE
,      ADDR_COMMENTS
,      ADDR_COUNTRY
,      ADDR_DATE_TO
,      ADDR_POSTAL_CODE
,      ADDR_REGION_1
,      ADDR_REGION_2
,      ADDR_REGION_3
,      ADDR_TELEPHONE_NUMBER_1
,      ADDR_TELEPHONE_NUMBER_2
,      ADDR_TELEPHONE_NUMBER_3
,      ADDR_TOWN_OR_CITY
,      ADDR_REQUEST_ID
,      ADDR_PROGRAM_APPLICATION_ID
,      ADDR_PROGRAM_ID
,      ADDR_PROGRAM_UPDATE_DATE
,      ADDR_ATTRIBUTE_CATEGORY
,      ADDR_ATTRIBUTE1
,      ADDR_ATTRIBUTE2
,      ADDR_ATTRIBUTE3
,      ADDR_ATTRIBUTE4
,      ADDR_ATTRIBUTE5
,      ADDR_ATTRIBUTE6
,      ADDR_ATTRIBUTE7
,      ADDR_ATTRIBUTE8
,      ADDR_ATTRIBUTE9
,      ADDR_ATTRIBUTE10
,      ADDR_ATTRIBUTE11
,      ADDR_ATTRIBUTE12
,      ADDR_ATTRIBUTE13
,      ADDR_ATTRIBUTE14
,      ADDR_ATTRIBUTE15
,      ADDR_ATTRIBUTE16
,      ADDR_ATTRIBUTE17
,      ADDR_ATTRIBUTE18
,      ADDR_ATTRIBUTE19
,      ADDR_ATTRIBUTE20
,      ADDR_LAST_UPDATE_DATE
,      ADDR_LAST_UPDATED_BY
,      ADDR_LAST_UPDATE_LOGIN
,      ADDR_CREATED_BY
,      ADDR_CREATION_DATE
,      ADDR_OBJECT_VERSION_NUMBER
,      ADDR_ADD_INFORMATION13
,      ADDR_ADD_INFORMATION14
,      ADDR_ADD_INFORMATION15
,      ADDR_ADD_INFORMATION16
,      ADDR_ADD_INFORMATION17
,      ADDR_ADD_INFORMATION18
,      ADDR_ADD_INFORMATION19
,      ADDR_ADD_INFORMATION20
,      ADDR_PARTY_ID
,      ADDR_DERIVED_LOCALE
FROM APPS.HR_EMPLOYEE_API_V;

Dependencies

[top of page]

APPS.HR_EMPLOYEE_API_V references the following:

SchemaAPPS
SynonymPER_ADDRESSES
SynonymPER_ALL_ASSIGNMENTS_F
SynonymPER_ALL_PEOPLE_F
SynonymPER_PERIODS_OF_SERVICE
SynonymPER_PERSON_TYPES

APPS.HR_EMPLOYEE_API_V is not referenced by any database object