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

VIEW: APPS.PER_PEOPLE_X

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

View Type

A supplementary view used to simplify forms coding.

Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major
releases.

[View Source]

Columns
Name Datatype Length Mandatory Comments
PERSON_ID NUMBER (10) Yes
EFFECTIVE_START_DATE DATE
Yes
EFFECTIVE_END_DATE DATE
Yes
BUSINESS_GROUP_ID NUMBER (15) Yes
PERSON_TYPE_ID NUMBER (15) Yes
LAST_NAME VARCHAR2 (150) Yes
START_DATE DATE
Yes
APPLICANT_NUMBER VARCHAR2 (30)
COMMENT_ID NUMBER (15)
CURRENT_APPLICANT_FLAG VARCHAR2 (30)
CURRENT_EMP_OR_APL_FLAG VARCHAR2 (30)
CURRENT_EMPLOYEE_FLAG VARCHAR2 (30)
DATE_EMPLOYEE_DATA_VERIFIED DATE

DATE_OF_BIRTH DATE

EMAIL_ADDRESS VARCHAR2 (240)
EMPLOYEE_NUMBER VARCHAR2 (30)
EXPENSE_CHECK_SEND_TO_ADDRESS VARCHAR2 (30)
FIRST_NAME VARCHAR2 (150)
FULL_NAME VARCHAR2 (240)
KNOWN_AS VARCHAR2 (80)
MARITAL_STATUS VARCHAR2 (30)
MIDDLE_NAMES VARCHAR2 (60)
NATIONALITY VARCHAR2 (30)
NATIONAL_IDENTIFIER VARCHAR2 (30)
PREVIOUS_LAST_NAME VARCHAR2 (150)
REGISTERED_DISABLED_FLAG VARCHAR2 (30)
SEX VARCHAR2 (30)
TITLE VARCHAR2 (30)
VENDOR_ID NUMBER (15)
WORK_TELEPHONE VARCHAR2 (4000)
REQUEST_ID NUMBER (15)
PROGRAM_APPLICATION_ID NUMBER (15)
PROGRAM_ID NUMBER (15)
PROGRAM_UPDATE_DATE DATE

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)
ATTRIBUTE21 VARCHAR2 (150)
ATTRIBUTE22 VARCHAR2 (150)
ATTRIBUTE23 VARCHAR2 (150)
ATTRIBUTE24 VARCHAR2 (150)
ATTRIBUTE25 VARCHAR2 (150)
ATTRIBUTE26 VARCHAR2 (150)
ATTRIBUTE27 VARCHAR2 (150)
ATTRIBUTE28 VARCHAR2 (150)
ATTRIBUTE29 VARCHAR2 (150)
ATTRIBUTE30 VARCHAR2 (150)
LAST_UPDATE_DATE DATE

LAST_UPDATED_BY NUMBER (15)
LAST_UPDATE_LOGIN NUMBER (15)
CREATED_BY NUMBER (15)
CREATION_DATE DATE

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)
SUFFIX VARCHAR2 (30)
OBJECT_VERSION_NUMBER NUMBER (9)
WORK_SCHEDULE VARCHAR2 (30)
CORRESPONDENCE_LANGUAGE VARCHAR2 (30)
STUDENT_STATUS VARCHAR2 (30)
FTE_CAPACITY NUMBER (5)
ON_MILITARY_SERVICE VARCHAR2 (30)
SECOND_PASSPORT_EXISTS VARCHAR2 (30)
BACKGROUND_CHECK_STATUS VARCHAR2 (30)
BACKGROUND_DATE_CHECK DATE

BLOOD_TYPE VARCHAR2 (30)
LAST_MEDICAL_TEST_DATE DATE

LAST_MEDICAL_TEST_BY VARCHAR2 (60)
REHIRE_RECOMMENDATION VARCHAR2 (30)
REHIRE_AUTHORIZOR VARCHAR2 (30)
REHIRE_REASON VARCHAR2 (60)
RESUME_EXISTS VARCHAR2 (30)
RESUME_LAST_UPDATED DATE

OFFICE_NUMBER VARCHAR2 (45)
INTERNAL_LOCATION VARCHAR2 (45)
MAILSTOP VARCHAR2 (45)
PROJECTED_START_DATE DATE

HONORS VARCHAR2 (45)
PRE_NAME_ADJUNCT VARCHAR2 (30)
HOLD_APPLICANT_DATE_UNTIL DATE

COORD_BEN_MED_PLN_NO VARCHAR2 (30)
COORD_BEN_NO_CVG_FLAG VARCHAR2 (30)
DPDNT_ADOPTION_DATE DATE

DPDNT_VLNTRY_SVCE_FLAG VARCHAR2 (30)
RECEIPT_OF_DEATH_CERT_DATE DATE

USES_TOBACCO_FLAG VARCHAR2 (30)
BENEFIT_GROUP_ID NUMBER (15)
ORIGINAL_DATE_OF_HIRE DATE

TOWN_OF_BIRTH VARCHAR2 (90)
REGION_OF_BIRTH VARCHAR2 (90)
COUNTRY_OF_BIRTH VARCHAR2 (90)
GLOBAL_PERSON_ID VARCHAR2 (30)
COORD_BEN_MED_EXT_ER VARCHAR2 (80)
COORD_BEN_MED_PL_NAME VARCHAR2 (80)
COORD_BEN_MED_INSR_CRR_NAME VARCHAR2 (80)
COORD_BEN_MED_INSR_CRR_IDENT VARCHAR2 (80)
COORD_BEN_MED_CVG_STRT_DT DATE

COORD_BEN_MED_CVG_END_DT DATE

NPW_NUMBER VARCHAR2 (30)
CURRENT_NPW_FLAG VARCHAR2 (30)
GLOBAL_NAME VARCHAR2 (240)
LOCAL_NAME VARCHAR2 (240)
LIST_NAME VARCHAR2 (4000)
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
,      COMMENT_ID
,      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
,      FIRST_NAME
,      FULL_NAME
,      KNOWN_AS
,      MARITAL_STATUS
,      MIDDLE_NAMES
,      NATIONALITY
,      NATIONAL_IDENTIFIER
,      PREVIOUS_LAST_NAME
,      REGISTERED_DISABLED_FLAG
,      SEX
,      TITLE
,      VENDOR_ID
,      WORK_TELEPHONE
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      ATTRIBUTE16
,      ATTRIBUTE17
,      ATTRIBUTE18
,      ATTRIBUTE19
,      ATTRIBUTE20
,      ATTRIBUTE21
,      ATTRIBUTE22
,      ATTRIBUTE23
,      ATTRIBUTE24
,      ATTRIBUTE25
,      ATTRIBUTE26
,      ATTRIBUTE27
,      ATTRIBUTE28
,      ATTRIBUTE29
,      ATTRIBUTE30
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      CREATED_BY
,      CREATION_DATE
,      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
,      SUFFIX
,      OBJECT_VERSION_NUMBER
,      WORK_SCHEDULE
,      CORRESPONDENCE_LANGUAGE
,      STUDENT_STATUS
,      FTE_CAPACITY
,      ON_MILITARY_SERVICE
,      SECOND_PASSPORT_EXISTS
,      BACKGROUND_CHECK_STATUS
,      BACKGROUND_DATE_CHECK
,      BLOOD_TYPE
,      LAST_MEDICAL_TEST_DATE
,      LAST_MEDICAL_TEST_BY
,      REHIRE_RECOMMENDATION
,      REHIRE_AUTHORIZOR
,      REHIRE_REASON
,      RESUME_EXISTS
,      RESUME_LAST_UPDATED
,      OFFICE_NUMBER
,      INTERNAL_LOCATION
,      MAILSTOP
,      PROJECTED_START_DATE
,      HONORS
,      PRE_NAME_ADJUNCT
,      HOLD_APPLICANT_DATE_UNTIL
,      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
,      ORIGINAL_DATE_OF_HIRE
,      TOWN_OF_BIRTH
,      REGION_OF_BIRTH
,      COUNTRY_OF_BIRTH
,      GLOBAL_PERSON_ID
,      COORD_BEN_MED_EXT_ER
,      COORD_BEN_MED_PL_NAME
,      COORD_BEN_MED_INSR_CRR_NAME
,      COORD_BEN_MED_INSR_CRR_IDENT
,      COORD_BEN_MED_CVG_STRT_DT
,      COORD_BEN_MED_CVG_END_DT
,      NPW_NUMBER
,      CURRENT_NPW_FLAG
,      GLOBAL_NAME
,      LOCAL_NAME
,      LIST_NAME
FROM APPS.PER_PEOPLE_X;

Dependencies

[top of page]

APPS.PER_PEOPLE_X references the following:

SchemaAPPS
PL/SQL PackageHR_GENERAL - show dependent code
PL/SQL PackageHR_PERSON_NAME - show dependent code
PL/SQL PackageHR_SECURITY - show dependent code
ViewPER_PEOPLE_F
APPS.PER_PEOPLE_X is referenced by following:

SchemaAPPS
Package BodyAHL_UMP_NONROUTINES_PVT - show dependent code
ViewAMS_DS_ACCESSES_ALL_V
ViewAMS_DS_GROUP_ACCESSES_ALL_V
ViewAP_CARDS_V
ViewAP_EXPENSE_REPORT_HISTORY_V
Package BodyAP_NOTES_PVT - show dependent code
Package BodyAP_WEB_DB_CCARD_PKG - show dependent code
Package BodyAP_WEB_DB_EXPRPT_PKG - show dependent code
Package BodyAP_WEB_DB_HR_INT_PKG - show dependent code
Package BodyAP_WEB_EXPENSE_CUST_WF - show dependent code
Package BodyAP_WEB_EXPENSE_WF - show dependent code
Package BodyAP_WEB_POLICY_UTILS - show dependent code
ViewAST_SALES_GROUP_ADMINS_V
ViewAS_ACCESSES_ACTIVE_V
Package BodyCS_CORE_UTIL - show dependent code
ViewCS_INCIDENT_ACTION_AUDIT_V
Package BodyCS_SERVICEREQUEST_UTIL - show dependent code
Package BodyCS_WORKFLOW_PUB - show dependent code
Package BodyCUG_GENERIC_WF_PKG - show dependent code
ViewENG_ECN_APPROVERS_V
Package BodyFARX_C_MT - show dependent code
ViewFA_DISTRIBUTION_HISTORY_V
ViewFA_DISTRIBUTION_HIST_WEB_V
ViewFA_EMPLOYEES
ViewFA_MASS_EXTERNAL_TRANSFERS_V
ViewGHR_PD_COVERSHEET_V
ViewGL_HR_EMPLOYEES_CURRENT_V
ViewGMS_NOTIFICATIONS_V
ViewGMS_PERSONNEL_V
ViewGMS_REPORTS_V
Package BodyHRBISOFO - show dependent code
ViewHRFV_ACCRUAL_PLAN_ENROLLMENTS
ViewHRFV_ACCRUAL_VALUES
ViewHRFV_ADA_DISABILITIES
ViewHRFV_ADA_DIS_ACCOMMODATIONS
ViewHRFV_ADDRESSES
ViewHRFV_APPLICANT_DETAILS
ViewHRFV_APPRAISAL_DETAILS
ViewHRFV_ASSIGNMENT_COSTS
ViewHRFV_BENEFIT_ENROLLMENTS
ViewHRFV_COMPETENCE_PROFILES
ViewHRFV_CONTACTS
ViewHRFV_CURRENT_SALARIES
ViewHRFV_DEPLOYMENT_FACTORS
ViewHRFV_DETAILED_SPECIAL_INFO
ViewHRFV_GB_ADDRESSES
ViewHRFV_GB_DIRECT_DEPOSITS
ViewHRFV_GB_LOCATIONS
ViewHRFV_GB_PERSONAL_DETAILS
ViewHRFV_GRADE_HISTORY
ViewHRFV_GRADE_STEP_PLACEMENTS
ViewHRFV_GRD_PLACEMNT_PROG_PT_VALS
ViewHRFV_GRD_STEP_PLACEMNT_HISTORY
ViewHRFV_JOB_APPLICATIONS
ViewHRFV_JOB_HISTORY
ViewHRFV_LOCATIONS
ViewHRFV_LOCATION_HISTORY
ViewHRFV_ORGANIZATION_HISTORY
ViewHRFV_OSHA_REPORTABLE_INCIDENTS
ViewHRFV_PAY_METH_NOT_DIR_DEPOSITS
ViewHRFV_PERSONAL_BACKGROUND_INFO
ViewHRFV_PERSONAL_MEDICAL_INFO
ViewHRFV_PERSONAL_REHIRE_INFO
ViewHRFV_PERSON_AGE_ANALYSIS
ViewHRFV_PERSON_SPECIAL_INFO
ViewHRFV_PHONES
ViewHRFV_POSITION_HISTORY
ViewHRFV_PROBATIONS
ViewHRFV_QUALIFICATIONS
ViewHRFV_REVIEWERS
ViewHRFV_REVIEWS
ViewHRFV_SALARY_COMPONENTS
ViewHRFV_SCHOOL_COLL_ATTENDANCES
ViewHRFV_SUBJECTS
ViewHRFV_SUPERVISORS
ViewHRFV_TIME_IN_SERVICE_ANALYSIS
ViewHRFV_US_ADDRESSES
ViewHRFV_US_DIRECT_DEPOSITS
ViewHRFV_US_LOCATIONS
ViewHRFV_US_PERSONAL_DETAILS
ViewHRIBV_SUPV_HRCHY_ROLLUP_X
ViewHRIBV_SUPV_HRCHY_X
Package BodyHRI_BPL_DATA_SETUP_DGNSTC - show dependent code
ViewHRI_CL_PER_APL_BX_V
ViewHRI_CL_PER_EMP_HX_V
ViewHRI_CL_PER_HXN_V
ViewHRI_CL_PER_HX_V
ViewHRI_CL_PER_SUP_HX_V
ViewHRI_CL_PER_USER_HX_V
Package BodyHRI_OPL_SUPH_HST - show dependent code
ViewHR_CERIDIAN_500_DEDUCTION_V
ViewHR_CERIDIAN_DEDUCTION_V
ViewHXC_APPROVAL_COMPS_V
Package BodyHXC_GET_NAME - show dependent code
ViewHXC_RESOURCE_RULES_PERSON_V
ViewHXC_RESOURCE_RULES_V
Package BodyIBY_PAYGROUP_PUB - show dependent code
ViewICX_INTERNAL_CONTACT_LOV
ViewICX_PER_PEOPLE_X_V
ViewIGW_ADMIN_OFFICIAL_V
Package BodyIGW_AWARD_PARTICULARS_PKG - show dependent code
ViewIGW_ORG_MAP_DETAILS_V
ViewIGW_PI_V
Package BodyIGW_PROP - show dependent code
ViewIGW_PROPOSAL_PERSONS_V
ViewIGW_PROP_COMMENTS_V
ViewIGW_PROP_PERSONS_V
ViewIGW_PROP_V
ViewIGW_PRPO_OTHER_SUPPORT_V
ViewIGW_PRPO_PROP_PERSONS_V
Package BodyIGW_REPORT_PROCESSING - show dependent code
ViewIGW_SIGNING_OFFICIAL_V
Package BodyIGW_VIEW_PARAMETERS - show dependent code
ViewINVFV_ITEMS
ViewINVFV_ORGANIZATION_ITEMS
ViewMTL_EMPLOYEES_CURRENT_VIEW
ViewMTL_EMPLOYEES_VIEW
ViewOIE_MGR_RPT_V
Package BodyPA_BUDGET_PUB - show dependent code
ViewPA_CANDIDATE_REVIEWS_V
Package BodyPA_CANDIDATE_UTILS - show dependent code
Package BodyPA_COMP_PROFILE_PUB - show dependent code
Package BodyPA_COMP_PROFILE_PVT - show dependent code
Package BodyPA_FIN_PLAN_UTILS - show dependent code
Package BodyPA_FP_CI_IMPLEMENT_PKG - show dependent code
ViewPA_MANAGERS_V
Package BodyPA_PLANNING_RESOURCE_PVT - show dependent code
Package BodyPA_PLANNING_RESOURCE_UTILS - show dependent code
Package BodyPA_PROJECT_ASSETS_PUB - show dependent code
ViewPA_PROJ_MANAGER_V
Package BodyPA_RBS_ELEMENTS_PVT - show dependent code
ViewPA_REP_PROJ_REQHRS_GLD_V
ViewPA_REP_PROJ_REQHRS_GL_V
ViewPA_REP_PROJ_REQHRS_PAD_V
ViewPA_REP_PROJ_REQHRS_PA_V
ViewPA_REP_PROJ_REQHRS_WKD_V
ViewPA_REP_PROJ_REQHRS_WK_V
ViewPA_REP_RES_SCHHRS_GLD_V
ViewPA_REP_RES_SCHHRS_PAD_V
ViewPA_REP_RES_SCHHRS_WKD_V
ViewPA_RESOURCE_AUTHORITY_V
ViewPOS_AP_EXPENSE_REPORTS_V
ViewPOS_PER_PEOPLE_X_V
ViewPQH_ROLE_PEOPLE_V
Package BodyPSP_PSPDAREG_XMLP_PKG - show dependent code
SchemaPUBLIC
SynonymPER_PEOPLE_X