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

VIEW: APPS.PER_EMPLOYEES_X

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

View Type

A public view which may be useful for custom reporting or other data
requirements.


All employees (current and ex-employees) visible within the current
security profile as of the current system date.


[View Source]

Columns
Name Datatype Length Mandatory Comments
BUSINESS_GROUP_ID NUMBER (15) Yes Business Group Id.
ORGANIZATION_ID NUMBER (15) Yes Organization Id.
EMPLOYEE_ID NUMBER (10) Yes Employee Id.
ASSIGNMENT_ID NUMBER (10) Yes Assignment Id.
LAST_UPDATE_DATE DATE

Standard who column.
LAST_UPDATED_BY NUMBER (15)
Standard who column.
LAST_UPDATE_LOGIN NUMBER (15)
Standard who column.
CREATION_DATE DATE

Standard who column.
CREATED_BY NUMBER (15)
Standard who column.
EMPLOYEE_NUM VARCHAR2 (30)
Employee Number/
FULL_NAME VARCHAR2 (240)
Full Name.
FIRST_NAME VARCHAR2 (150)
First Name.
MIDDLE_NAME VARCHAR2 (60)
Middle Name.
LAST_NAME VARCHAR2 (150) Yes Last Name.
PREFIX VARCHAR2 (30)
Prefix.
LOCATION_ID NUMBER (15)
Location Id.
SUPERVISOR_ID NUMBER (10)
Supervisor Id.
SET_OF_BOOKS_ID NUMBER (15)
Set of Books Id.
DEFAULT_CODE_COMBINATION_ID NUMBER (15)
Identifies GL key flexfield structure.
EXPENSE_CHECK_ADDRESS_FLAG VARCHAR2 (30)
Mailing address.
INACTIVE_DATE DATE

Inactive Date.
EMAIL_ADDRESS VARCHAR2 (240)
Email Address.
ATTRIBUTE1 VARCHAR2 (150)
Descriptive flexfield column.
ATTRIBUTE2 VARCHAR2 (150)
Descriptive flexfield column.
ATTRIBUTE3 VARCHAR2 (150)
Descriptive flexfield column.
ATTRIBUTE4 VARCHAR2 (150)
Descriptive flexfield column.
ATTRIBUTE5 VARCHAR2 (150)
Descriptive flexfield column.
ATTRIBUTE6 VARCHAR2 (150)
Descriptive flexfield column.
ATTRIBUTE7 VARCHAR2 (150)
Descriptive flexfield column.
ATTRIBUTE8 VARCHAR2 (150)
Descriptive flexfield column.
ATTRIBUTE9 VARCHAR2 (150)
Descriptive flexfield column.
ATTRIBUTE10 VARCHAR2 (150)
Descriptive flexfield column.
ATTRIBUTE11 VARCHAR2 (150)
Descriptive flexfield column.
ATTRIBUTE12 VARCHAR2 (150)
Descriptive flexfield column.
ATTRIBUTE13 VARCHAR2 (150)
Descriptive flexfield column.
ATTRIBUTE14 VARCHAR2 (150)
Descriptive flexfield column.
ATTRIBUTE15 VARCHAR2 (150)
Descriptive flexfield column.
ATTRIBUTE16 VARCHAR2 (150)
Descriptive flexfield column.
ATTRIBUTE17 VARCHAR2 (150)
Descriptive flexfield column.
ATTRIBUTE18 VARCHAR2 (150)
Descriptive flexfield column.
ATTRIBUTE19 VARCHAR2 (150)
Descriptive flexfield column.
ATTRIBUTE20 VARCHAR2 (150)
Descriptive flexfield column.
ATTRIBUTE21 VARCHAR2 (150)
Descriptive flexfield column.
ATTRIBUTE22 VARCHAR2 (150)
Descriptive flexfield column.
ATTRIBUTE23 VARCHAR2 (150)
Descriptive flexfield column.
ATTRIBUTE24 VARCHAR2 (150)
Descriptive flexfield column.
ATTRIBUTE25 VARCHAR2 (150)
Descriptive flexfield column.
ATTRIBUTE26 VARCHAR2 (150)
Descriptive flexfield column.
ATTRIBUTE27 VARCHAR2 (150)
Descriptive flexfield column.
ATTRIBUTE28 VARCHAR2 (150)
Descriptive flexfield column.
ATTRIBUTE29 VARCHAR2 (150)
Descriptive flexfield column.
ATTRIBUTE30 VARCHAR2 (150)
Descriptive flexfield column.
ATTRIBUTE_CATEGORY VARCHAR2 (30)
Descriptive flexfield column.
PARTY_ID NUMBER (15)
foreign key to HZ_PARTIES
GLOBAL_NAME VARCHAR2 (240)
Stores personal name according to the defined Global List Name format
LOCAL_NAME VARCHAR2 (240)
Stores personal name according to the defined Local List Name format
LIST_NAME VARCHAR2 (4000)
Either a global or local name depending on the profile option HR_LOCAL_OR_GLOBAL_NAME_FORMAT
Query Text

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


SELECT BUSINESS_GROUP_ID
,      ORGANIZATION_ID
,      EMPLOYEE_ID
,      ASSIGNMENT_ID
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      CREATION_DATE
,      CREATED_BY
,      EMPLOYEE_NUM
,      FULL_NAME
,      FIRST_NAME
,      MIDDLE_NAME
,      LAST_NAME
,      PREFIX
,      LOCATION_ID
,      SUPERVISOR_ID
,      SET_OF_BOOKS_ID
,      DEFAULT_CODE_COMBINATION_ID
,      EXPENSE_CHECK_ADDRESS_FLAG
,      INACTIVE_DATE
,      EMAIL_ADDRESS
,      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
,      ATTRIBUTE_CATEGORY
,      PARTY_ID
,      GLOBAL_NAME
,      LOCAL_NAME
,      LIST_NAME
FROM APPS.PER_EMPLOYEES_X;

Dependencies

[top of page]

APPS.PER_EMPLOYEES_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
SynonymPER_ALL_ASSIGNMENTS_F
ViewPER_PEOPLE_F
SynonymPER_PERIODS_OF_SERVICE
APPS.PER_EMPLOYEES_X is referenced by following:

SchemaAPPS
Package BodyAP_APXCCOUT_XMLP_PKG - show dependent code
Package BodyAP_CARD_UTILITY_PKG - show dependent code
Package BodyAP_CREDIT_CARD_INVOICE_PKG - show dependent code
ViewAP_EXPENSE_REPORT_HEADERS_V
Package BodyAP_WEB_AMOUNT_UTIL - show dependent code
Package BodyAP_WEB_AUDIT_UTILS - show dependent code
Package BodyAP_WEB_CC_VALIDATIONS_PKG - show dependent code
Package BodyAP_WEB_CREDIT_CARD_WF - show dependent code
Package BodyAP_WEB_DB_AP_INT_PKG - 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_DB_SCHLINE_PKG - show dependent code
Package BodyAP_WEB_EXPORT_ER - show dependent code
Package BodyAP_WEB_PCARD_WORKFLOW_PKG - show dependent code
Package BodyAP_WEB_POLICY_UTILS - show dependent code
PL/SQL PackageAP_WEB_POLICY_UTILS - show dependent code
Package BodyAP_WEB_RECEIPTS_WF - show dependent code
Package BodyCE_BANK_AND_ACCOUNT_VALIDATION - show dependent code
ViewJTF_RS_EMPLOYEES_VL
ViewOIE_SRS_CARD_NUMBER_V