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


VIEW: APPS.PER_ASSIGNMENTS_V

Object Details
Object Name: PER_ASSIGNMENTS_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewPER.PER_ASSIGNMENTS_V
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
ROW_ID ROWID (10)

EFFECTIVE_START_DATE DATE
Yes
D_EFFECTIVE_END_DATE DATE


EFFECTIVE_END_DATE DATE
Yes
BUSINESS_GROUP_ID NUMBER


GRADE_ID NUMBER (15)

GRADE_NAME VARCHAR2 (240)

POSITION_ID NUMBER (15)

POSITION_NAME VARCHAR2 (4000)

JOB_ID NUMBER (15)

JOB_NAME VARCHAR2 (700)

ASSIGNMENT_STATUS_TYPE_ID NUMBER (9) Yes
USER_STATUS VARCHAR2 (80)

PER_SYSTEM_STATUS VARCHAR2 (30)

PAYROLL_ID NUMBER (9)

PAYROLL_NAME VARCHAR2 (80)

LOCATION_ID NUMBER (15)

LOCATION_CODE VARCHAR2 (60)

SUPERVISOR_ID NUMBER (10)

SUPERVISOR_NAME VARCHAR2 (240)

SUPERVISOR_EMPLOYEE_NUMBER VARCHAR2 (30)

SPECIAL_CEILING_STEP_ID NUMBER (15)

SPINAL_POINT VARCHAR2 (30)

SPINAL_POINT_STEP_SEQUENCE NUMBER (15)

PERSON_ID NUMBER (10) Yes
ORGANIZATION_ID NUMBER (15) Yes
ORGANIZATION_NAME VARCHAR2 (240) Yes
PEOPLE_GROUP_ID NUMBER (15)

ASSIGNMENT_SEQUENCE NUMBER (15) Yes
PRIMARY_FLAG VARCHAR2 (30) Yes
ASSIGNMENT_NUMBER VARCHAR2 (30)

CHANGE_REASON VARCHAR2 (30)

CHANGE_REASON_MEANING VARCHAR2 (4000)

COMMENT_ID NUMBER (15)

COMMENT_TEXT CLOB (4000)

DATE_PROBATION_END DATE


D_DATE_PROBATION_END DATE


FREQUENCY VARCHAR2 (30)

FREQUENCY_MEANING VARCHAR2 (4000)

INTERNAL_ADDRESS_LINE VARCHAR2 (80)

MANAGER_FLAG VARCHAR2 (30)

NORMAL_HOURS NUMBER (22)

PROBATION_PERIOD NUMBER (22)

PROBATION_UNIT VARCHAR2 (30)

PROBATION_UNIT_MEANING VARCHAR2 (4000)

TIME_NORMAL_FINISH VARCHAR2 (5)

TIME_NORMAL_START VARCHAR2 (5)

BARGAINING_UNIT_CODE VARCHAR2 (30)
BARGAINING_UNIT_CODE_MEANING VARCHAR2 (4000)
LABOUR_UNION_MEMBER_FLAG VARCHAR2 (30)
HOURLY_SALARIED_CODE VARCHAR2 (30)
HOURLY_SALARIED_CODE_MEANING VARCHAR2 (4000)
LAST_UPDATE_DATE DATE


LAST_UPDATED_BY NUMBER (15)

LAST_UPDATE_LOGIN NUMBER (15)

CREATED_BY NUMBER (15)

CREATION_DATE DATE


SAL_REVIEW_PERIOD NUMBER (15)

SAL_REV_PERIOD_FREQ_MEANING VARCHAR2 (4000)

SAL_REVIEW_PERIOD_FREQUENCY VARCHAR2 (30)

PERF_REVIEW_PERIOD NUMBER (15)

PERF_REV_PERIOD_FREQ_MEANING VARCHAR2 (4000)

PERF_REVIEW_PERIOD_FREQUENCY VARCHAR2 (30)

PAY_BASIS_ID NUMBER (9)

SALARY_BASIS VARCHAR2 (30)

PAY_BASIS VARCHAR2 (30)

RECRUITER_ID NUMBER (10)

PERSON_REFERRED_BY_ID NUMBER (10)

RECRUITMENT_ACTIVITY_ID NUMBER (15)

SOURCE_ORGANIZATION_ID NUMBER (15)

SOFT_CODING_KEYFLEX_ID NUMBER (15)

VACANCY_ID NUMBER (15)

ASSIGNMENT_TYPE VARCHAR2 (1) Yes
APPLICATION_ID NUMBER (15)

DEFAULT_CODE_COMB_ID NUMBER (15)

PERIOD_OF_SERVICE_ID NUMBER (15)

SET_OF_BOOKS_ID NUMBER (15)

D_SET_OF_BOOKS VARCHAR2 (30)

GL_KEYFLEX_STRUCTURE NUMBER (15)

SOURCE_TYPE 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)

EMPLOYMENT_CATEGORY VARCHAR2 (30)

EMPLOYMENT_CATEGORY_MEANING VARCHAR2 (4000)

ESTABLISHMENT_ID NUMBER (15)
COLLECTIVE_AGREEMENT_ID NUMBER (9)
CONTRACT_ID NUMBER (9)
CAGR_GRADE_DEF_ID NUMBER (15)
CAGR_ID_FLEX_NUM NUMBER (15)
AGREEMENT_NAME VARCHAR2 (80)
ESTABLISHMENT_NAME VARCHAR2 (240)
REFERENCE VARCHAR2 (80)
NOTICE_PERIOD NUMBER (10)
NOTICE_PERIOD_UOM VARCHAR2 (30)
NOTICE_PERIOD_UOM_MEANING VARCHAR2 (4000)
EMPLOYEE_CATEGORY VARCHAR2 (30)
EMPLOYEE_CATEGORY_MEANING VARCHAR2 (4000)
WORK_AT_HOME VARCHAR2 (30)
JOB_POST_SOURCE_NAME VARCHAR2 (240)
TITLE VARCHAR2 (30)
PROJECT_TITLE VARCHAR2 (30)
PERIOD_OF_PLACEMENT_DATE_START DATE

VENDOR_ID NUMBER (15)
Supplying organization for contingent workers
VENDOR_NAME VARCHAR2 (240)
Name of the supplying organization for contingent workers
VENDOR_SITE_ID NUMBER (15)
Site of the supplying organization
VENDOR_SITE_CODE VARCHAR2 (15)
Site name of the supplying organization
PO_HEADER_ID NUMBER (15)
Purchase order header for contingent worker services procurement
PO_NUMBER VARCHAR2 (20)
Purchase order number for contingent worker services procurement
PO_LINE_ID NUMBER (15)
Purchase order line for contingent worker services procurement
PO_LINE_NUMBER NUMBER

Purchase order line number for contingent worker services procurement
PROJECTED_ASSIGNMENT_END DATE

Date the assignment is expected to end
VENDOR_EMPLOYEE_NUMBER VARCHAR2 (30)
VENDOR_ASSIGNMENT_NUMBER VARCHAR2 (30)
ASSIGNMENT_CATEGORY VARCHAR2 (30)
GRADE_LADDER_PGM_ID NUMBER (15)
SUPERVISOR_ASSIGNMENT_ID NUMBER (15)
GRADE_LADDER_NAME VARCHAR2 (240)
SUPERVISOR_ASSIGNMENT_NUMBER VARCHAR2 (30)
Query Text

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


SELECT ASSIGNMENT_ID
,      ROW_ID
,      EFFECTIVE_START_DATE
,      D_EFFECTIVE_END_DATE
,      EFFECTIVE_END_DATE
,      BUSINESS_GROUP_ID
,      GRADE_ID
,      GRADE_NAME
,      POSITION_ID
,      POSITION_NAME
,      JOB_ID
,      JOB_NAME
,      ASSIGNMENT_STATUS_TYPE_ID
,      USER_STATUS
,      PER_SYSTEM_STATUS
,      PAYROLL_ID
,      PAYROLL_NAME
,      LOCATION_ID
,      LOCATION_CODE
,      SUPERVISOR_ID
,      SUPERVISOR_NAME
,      SUPERVISOR_EMPLOYEE_NUMBER
,      SPECIAL_CEILING_STEP_ID
,      SPINAL_POINT
,      SPINAL_POINT_STEP_SEQUENCE
,      PERSON_ID
,      ORGANIZATION_ID
,      ORGANIZATION_NAME
,      PEOPLE_GROUP_ID
,      ASSIGNMENT_SEQUENCE
,      PRIMARY_FLAG
,      ASSIGNMENT_NUMBER
,      CHANGE_REASON
,      CHANGE_REASON_MEANING
,      COMMENT_ID
,      COMMENT_TEXT
,      DATE_PROBATION_END
,      D_DATE_PROBATION_END
,      FREQUENCY
,      FREQUENCY_MEANING
,      INTERNAL_ADDRESS_LINE
,      MANAGER_FLAG
,      NORMAL_HOURS
,      PROBATION_PERIOD
,      PROBATION_UNIT
,      PROBATION_UNIT_MEANING
,      TIME_NORMAL_FINISH
,      TIME_NORMAL_START
,      BARGAINING_UNIT_CODE
,      BARGAINING_UNIT_CODE_MEANING
,      LABOUR_UNION_MEMBER_FLAG
,      HOURLY_SALARIED_CODE
,      HOURLY_SALARIED_CODE_MEANING
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      CREATED_BY
,      CREATION_DATE
,      SAL_REVIEW_PERIOD
,      SAL_REV_PERIOD_FREQ_MEANING
,      SAL_REVIEW_PERIOD_FREQUENCY
,      PERF_REVIEW_PERIOD
,      PERF_REV_PERIOD_FREQ_MEANING
,      PERF_REVIEW_PERIOD_FREQUENCY
,      PAY_BASIS_ID
,      SALARY_BASIS
,      PAY_BASIS
,      RECRUITER_ID
,      PERSON_REFERRED_BY_ID
,      RECRUITMENT_ACTIVITY_ID
,      SOURCE_ORGANIZATION_ID
,      SOFT_CODING_KEYFLEX_ID
,      VACANCY_ID
,      ASSIGNMENT_TYPE
,      APPLICATION_ID
,      DEFAULT_CODE_COMB_ID
,      PERIOD_OF_SERVICE_ID
,      SET_OF_BOOKS_ID
,      D_SET_OF_BOOKS
,      GL_KEYFLEX_STRUCTURE
,      SOURCE_TYPE
,      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
,      EMPLOYMENT_CATEGORY
,      EMPLOYMENT_CATEGORY_MEANING
,      ESTABLISHMENT_ID
,      COLLECTIVE_AGREEMENT_ID
,      CONTRACT_ID
,      CAGR_GRADE_DEF_ID
,      CAGR_ID_FLEX_NUM
,      AGREEMENT_NAME
,      ESTABLISHMENT_NAME
,      REFERENCE
,      NOTICE_PERIOD
,      NOTICE_PERIOD_UOM
,      NOTICE_PERIOD_UOM_MEANING
,      EMPLOYEE_CATEGORY
,      EMPLOYEE_CATEGORY_MEANING
,      WORK_AT_HOME
,      JOB_POST_SOURCE_NAME
,      TITLE
,      PROJECT_TITLE
,      PERIOD_OF_PLACEMENT_DATE_START
,      VENDOR_ID
,      VENDOR_NAME
,      VENDOR_SITE_ID
,      VENDOR_SITE_CODE
,      PO_HEADER_ID
,      PO_NUMBER
,      PO_LINE_ID
,      PO_LINE_NUMBER
,      PROJECTED_ASSIGNMENT_END
,      VENDOR_EMPLOYEE_NUMBER
,      VENDOR_ASSIGNMENT_NUMBER
,      ASSIGNMENT_CATEGORY
,      GRADE_LADDER_PGM_ID
,      SUPERVISOR_ASSIGNMENT_ID
,      GRADE_LADDER_NAME
,      SUPERVISOR_ASSIGNMENT_NUMBER
FROM APPS.PER_ASSIGNMENTS_V;

Dependencies

[top of page]

APPS.PER_ASSIGNMENTS_V references the following:

SchemaAPPS
SynonymBEN_PGM_F
PL/SQL PackageFND_GLOBAL - show dependent code
SynonymFND_SESSIONS
ViewGL_SETS_OF_BOOKS
SynonymHR_ALL_ORGANIZATION_UNITS
SynonymHR_ALL_ORGANIZATION_UNITS_TL
SynonymHR_COMMENTS
PL/SQL PackageHR_GENERAL - show dependent code
SynonymHR_LOCATIONS_ALL_TL
ViewHR_LOCATIONS_NO_JOIN
SynonymPAY_ALL_PAYROLLS_F
SynonymPER_ALL_ASSIGNMENTS_F
SynonymPER_ALL_PEOPLE_F
SynonymPER_ASSIGNMENT_STATUS_TYPES
SynonymPER_ASSIGNMENT_STATUS_TYPES_TL
SynonymPER_ASS_STATUS_TYPE_AMENDS
SynonymPER_ASS_STATUS_TYPE_AMENDS_TL
SynonymPER_COLLECTIVE_AGREEMENTS
SynonymPER_CONTRACTS_F
SynonymPER_GRADES
SynonymPER_GRADES_TL
SynonymPER_JOBS
SynonymPER_JOBS_TL
SynonymPER_PAY_BASES
SynonymPER_SPINAL_POINTS
SynonymPER_SPINAL_POINT_STEPS_F
SynonymPO_HEADERS_ALL
SynonymPO_LINES_ALL
ViewPO_VENDORS
ViewPO_VENDOR_SITES_ALL
APPS.PER_ASSIGNMENTS_V is referenced by following:

SchemaAPPS
Package BodyPER_QH_FIND_QUERY - show dependent code
PL/SQL PackagePER_QH_FIND_QUERY - show dependent code
PL/SQL PackagePER_QH_MAINTAIN_QUERY - show dependent code
Package BodyPER_QH_POPULATE - show dependent code