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

VIEW: APPS.PER_WORKFORCE_X

Object Details
Object Name: PER_WORKFORCE_X
Object Type: VIEW
Owner: APPS
FND Design Data: ViewPER.PER_WORKFORCE_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
EMPLOYEE_NUMBER VARCHAR2 (30)
Employee number
CURRENT_EMPLOYEE_FLAG VARCHAR2 (30)
Determines if person is current employee.
BUSINESS_GROUP_ID NUMBER (15) Yes Business Group Id.
ORGANIZATION_ID NUMBER (15) Yes Organization Id.
PERSON_ID NUMBER (10) Yes System generated person primary key from PER_PEOPLE_S.
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.
NPW_NUMBER VARCHAR2 (30)
Number for contingent worker
CURRENT_NPW_FLAG VARCHAR2 (30)
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
VENDOR_SITE_ID NUMBER (15)
PO_HEADER_ID NUMBER (15)
PO_LINE_ID NUMBER (15)
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)
Working Location Id.
SUPERVISOR_ID NUMBER (10)
Supervisor Id.
SUPERVISOR_ASSIGNMENT_ID NUMBER (15)
Supervisor Assignment Id.
SET_OF_BOOKS_ID NUMBER (15)
Set of Books Id.
DEFAULT_CODE_COMBINATION_ID NUMBER (15)
Identifies GL key flexfield structure.
TERMINATION_DATE DATE

Actual date of termination of period of placement
PROJECT_TITLE VARCHAR2 (30)
Title of project of which this assignment forms part
BILLING_TITLE VARCHAR2 (30)
Title for assignment.
EMAIL_ADDRESS VARCHAR2 (240)
Email Address.
EXPENSE_CHECK_ADDRESS_FLAG VARCHAR2 (30)
ASSIGNMENT_TYPE VARCHAR2 (1) Yes
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)
LOCAL_NAME VARCHAR2 (240)
LIST_NAME VARCHAR2 (4000)
Query Text

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


SELECT EMPLOYEE_NUMBER
,      CURRENT_EMPLOYEE_FLAG
,      BUSINESS_GROUP_ID
,      ORGANIZATION_ID
,      PERSON_ID
,      ASSIGNMENT_ID
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      CREATION_DATE
,      CREATED_BY
,      NPW_NUMBER
,      CURRENT_NPW_FLAG
,      VENDOR_ID
,      VENDOR_EMPLOYEE_NUMBER
,      VENDOR_ASSIGNMENT_NUMBER
,      VENDOR_SITE_ID
,      PO_HEADER_ID
,      PO_LINE_ID
,      FULL_NAME
,      FIRST_NAME
,      MIDDLE_NAME
,      LAST_NAME
,      PREFIX
,      LOCATION_ID
,      SUPERVISOR_ID
,      SUPERVISOR_ASSIGNMENT_ID
,      SET_OF_BOOKS_ID
,      DEFAULT_CODE_COMBINATION_ID
,      TERMINATION_DATE
,      PROJECT_TITLE
,      BILLING_TITLE
,      EMAIL_ADDRESS
,      EXPENSE_CHECK_ADDRESS_FLAG
,      ASSIGNMENT_TYPE
,      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_WORKFORCE_X;

Dependencies

[top of page]

APPS.PER_WORKFORCE_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_PLACEMENT
SynonymPER_PERIODS_OF_SERVICE
APPS.PER_WORKFORCE_X is referenced by following:

SchemaAPPS
Package BodyAP_WEB_DB_HR_INT_PKG - show dependent code
Package BodyAP_WEB_EXPENSE_WF - show dependent code
Package BodyAP_WEB_MANAGEMENT_REPORTS_PKG - show dependent code
Package BodyAP_WEB_OA_DISC_PKG - show dependent code
Package BodyCSZ_SERVICEREQUEST_UTIL_PVT - show dependent code
Package BodyCS_CORE_UTIL - show dependent code
Package BodyCS_SERVICEREQUEST_UTIL - show dependent code
Package BodyCS_WF_AUTO_NTFY_UPDATE_PKG - show dependent code
SchemaPUBLIC
SynonymPER_WORKFORCE_X