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

VIEW: APPS.PER_ASSIGNMENTS_X

Object Details
Object Name: PER_ASSIGNMENTS_X
Object Type: VIEW
Owner: APPS
FND Design Data: ViewPER.PER_ASSIGNMENTS_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
ASSIGNMENT_ID NUMBER (10) Yes
EFFECTIVE_START_DATE DATE
Yes
EFFECTIVE_END_DATE DATE
Yes
BUSINESS_GROUP_ID NUMBER (15) Yes
RECRUITER_ID NUMBER (10)
GRADE_ID NUMBER (15)
POSITION_ID NUMBER (15)
JOB_ID NUMBER (15)
ASSIGNMENT_STATUS_TYPE_ID NUMBER (9) Yes
PAYROLL_ID NUMBER (9)
LOCATION_ID NUMBER (15)
PERSON_REFERRED_BY_ID NUMBER (10)
SUPERVISOR_ID NUMBER (10)
SPECIAL_CEILING_STEP_ID NUMBER (15)
PERSON_ID NUMBER (10) Yes
RECRUITMENT_ACTIVITY_ID NUMBER (15)
SOURCE_ORGANIZATION_ID NUMBER (15)
ORGANIZATION_ID NUMBER (15) Yes
PEOPLE_GROUP_ID NUMBER (15)
SOFT_CODING_KEYFLEX_ID NUMBER (15)
VACANCY_ID NUMBER (15)
PAY_BASIS_ID NUMBER (9)
ASSIGNMENT_SEQUENCE NUMBER (15) Yes
ASSIGNMENT_TYPE VARCHAR2 (1) Yes
PRIMARY_FLAG VARCHAR2 (30) Yes
APPLICATION_ID NUMBER (15)
ASSIGNMENT_NUMBER VARCHAR2 (30)
CHANGE_REASON VARCHAR2 (30)
COMMENT_ID NUMBER (15)
DATE_PROBATION_END DATE

DEFAULT_CODE_COMB_ID NUMBER (15)
EMPLOYMENT_CATEGORY VARCHAR2 (30)
FREQUENCY VARCHAR2 (30)
INTERNAL_ADDRESS_LINE VARCHAR2 (80)
MANAGER_FLAG VARCHAR2 (30)
NORMAL_HOURS NUMBER (22)
PERF_REVIEW_PERIOD NUMBER (15)
PERF_REVIEW_PERIOD_FREQUENCY VARCHAR2 (30)
PERIOD_OF_SERVICE_ID NUMBER (15)
PROBATION_PERIOD NUMBER (22)
PROBATION_UNIT VARCHAR2 (30)
SAL_REVIEW_PERIOD NUMBER (15)
SAL_REVIEW_PERIOD_FREQUENCY VARCHAR2 (30)
SET_OF_BOOKS_ID NUMBER (15)
SOURCE_TYPE VARCHAR2 (30)
TIME_NORMAL_FINISH VARCHAR2 (5)
TIME_NORMAL_START VARCHAR2 (5)
BARGAINING_UNIT_CODE VARCHAR2 (30)
LABOUR_UNION_MEMBER_FLAG VARCHAR2 (30)
HOURLY_SALARIED_CODE VARCHAR2 (30)
REQUEST_ID NUMBER (15)
PROGRAM_APPLICATION_ID NUMBER (15)
PROGRAM_ID NUMBER (15)
PROGRAM_UPDATE_DATE DATE

ASS_ATTRIBUTE_CATEGORY VARCHAR2 (30)
ASS_ATTRIBUTE1 VARCHAR2 (150)
ASS_ATTRIBUTE2 VARCHAR2 (150)
ASS_ATTRIBUTE3 VARCHAR2 (150)
ASS_ATTRIBUTE4 VARCHAR2 (150)
ASS_ATTRIBUTE5 VARCHAR2 (150)
ASS_ATTRIBUTE6 VARCHAR2 (150)
ASS_ATTRIBUTE7 VARCHAR2 (150)
ASS_ATTRIBUTE8 VARCHAR2 (150)
ASS_ATTRIBUTE9 VARCHAR2 (150)
ASS_ATTRIBUTE10 VARCHAR2 (150)
ASS_ATTRIBUTE11 VARCHAR2 (150)
ASS_ATTRIBUTE12 VARCHAR2 (150)
ASS_ATTRIBUTE13 VARCHAR2 (150)
ASS_ATTRIBUTE14 VARCHAR2 (150)
ASS_ATTRIBUTE15 VARCHAR2 (150)
ASS_ATTRIBUTE16 VARCHAR2 (150)
ASS_ATTRIBUTE17 VARCHAR2 (150)
ASS_ATTRIBUTE18 VARCHAR2 (150)
ASS_ATTRIBUTE19 VARCHAR2 (150)
ASS_ATTRIBUTE20 VARCHAR2 (150)
ASS_ATTRIBUTE21 VARCHAR2 (150)
ASS_ATTRIBUTE22 VARCHAR2 (150)
ASS_ATTRIBUTE23 VARCHAR2 (150)
ASS_ATTRIBUTE24 VARCHAR2 (150)
ASS_ATTRIBUTE25 VARCHAR2 (150)
ASS_ATTRIBUTE26 VARCHAR2 (150)
ASS_ATTRIBUTE27 VARCHAR2 (150)
ASS_ATTRIBUTE28 VARCHAR2 (150)
ASS_ATTRIBUTE29 VARCHAR2 (150)
ASS_ATTRIBUTE30 VARCHAR2 (150)
LAST_UPDATE_DATE DATE

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

TITLE VARCHAR2 (30)
NOTICE_PERIOD NUMBER (10)
NOTICE_PERIOD_UOM VARCHAR2 (30)
EMPLOYEE_CATEGORY VARCHAR2 (30)
WORK_AT_HOME VARCHAR2 (30)
JOB_POST_SOURCE_NAME VARCHAR2 (240)
OBJECT_VERSION_NUMBER NUMBER (9)
PERIOD_OF_PLACEMENT_DATE_START DATE

Date contingent worker placement started.
VENDOR_ID NUMBER (15)
Supplying organization for contingent workers
VENDOR_SITE_ID NUMBER (15)
Site of the supplying organization
PO_HEADER_ID NUMBER (15)
Purchase order header for contingent worker services procurement
PO_LINE_ID NUMBER (15)
Purchase order line for contingent worker services procurement
PROJECTED_ASSIGNMENT_END DATE

Date the assignment is expected to end
VENDOR_EMPLOYEE_NUMBER VARCHAR2 (30)
Employee number of worker with supplying organization
VENDOR_ASSIGNMENT_NUMBER VARCHAR2 (30)
Assignment number of this assignment with supplying organization
SUPERVISOR_ASSIGNMENT_ID NUMBER (15)
Assignment which acts as supervisory assignment
Query Text

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


SELECT ASSIGNMENT_ID
,      EFFECTIVE_START_DATE
,      EFFECTIVE_END_DATE
,      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
,      PERSON_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
,      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
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      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
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      CREATED_BY
,      CREATION_DATE
,      TITLE
,      NOTICE_PERIOD
,      NOTICE_PERIOD_UOM
,      EMPLOYEE_CATEGORY
,      WORK_AT_HOME
,      JOB_POST_SOURCE_NAME
,      OBJECT_VERSION_NUMBER
,      PERIOD_OF_PLACEMENT_DATE_START
,      VENDOR_ID
,      VENDOR_SITE_ID
,      PO_HEADER_ID
,      PO_LINE_ID
,      PROJECTED_ASSIGNMENT_END
,      VENDOR_EMPLOYEE_NUMBER
,      VENDOR_ASSIGNMENT_NUMBER
,      SUPERVISOR_ASSIGNMENT_ID
FROM APPS.PER_ASSIGNMENTS_X;

Dependencies

[top of page]

APPS.PER_ASSIGNMENTS_X references the following:

SchemaAPPS
PL/SQL PackageHR_GENERAL - show dependent code
PL/SQL PackageHR_SECURITY - show dependent code
ViewPER_ASSIGNMENTS_F
APPS.PER_ASSIGNMENTS_X is referenced by following:

SchemaAPPS
Package BodyAS_LEAD_ABANDON_WF - show dependent code
Package BodyCS_CORE_UTIL - show dependent code
ViewCS_SR_UWQ_EMPLOYEE_V
ViewCS_SR_UWQ_TEAM_V
Package BodyENG_VAL_TO_ID - show dependent code
ViewGL_HR_EMPLOYEES_CURRENT_V
Package BodyHRBISOFO - show dependent code
ViewHRFV_ACCRUAL_PLAN_ENROLLMENTS
ViewHRFV_ACCRUAL_VALUES
ViewHRFV_ASSIGNMENT_COSTS
ViewHRFV_BENEFIT_ENROLLMENTS
ViewHRFV_CURRENT_SALARIES
ViewHRFV_GB_DIRECT_DEPOSITS
ViewHRFV_GRADE_STEP_PLACEMENTS
ViewHRFV_GRD_PLACEMNT_PROG_PT_VALS
ViewHRFV_PAY_METH_NOT_DIR_DEPOSITS
ViewHRFV_SUPERVISORS
ViewHRFV_US_DIRECT_DEPOSITS
ViewHRI_CL_PER_SUP_HX_V
Package BodyHR_OFFER_WF - show dependent code
ViewICX_INTERNAL_CONTACT_LOV
ViewICX_INTERNAL_SAV_DEFAULTS_V
ViewIGW_ADMIN_OFFICIAL_V
ViewIGW_PI_V
ViewIGW_PROPOSAL_PERSONS_V
Package BodyIGW_REPORT_PROCESSING - show dependent code
ViewIGW_SIGNING_OFFICIAL_V
ViewMTL_EMPLOYEES_CURRENT_VIEW
Package BodyPA_PLANNING_RESOURCE_UTILS - show dependent code
Package BodyPER_VIEWS_PKG - show dependent code
SchemaPUBLIC
SynonymPER_ASSIGNMENTS_X