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


VIEW: APPS.PER_ASSIGNMENTS_V5

Object Details
Object Name: PER_ASSIGNMENTS_V5
Object Type: VIEW
Owner: APPS
FND Design Data: ViewPER.PER_ASSIGNMENTS_V5
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 VARCHAR2 (9)

EFFECTIVE_END_DATE DATE
Yes
BUSINESS_GROUP_ID NUMBER


RECRUITMENT_ACTIVITY_ID NUMBER (15)

D_RECRUITMENT_ACTIVITY_ID VARCHAR2 (30)

C_REC_ACT_TYPE VARCHAR2 (30)

RECRUITMENT_ACTIVITY_TYPE VARCHAR2 (4000)

GRADE_ID NUMBER (15)

D_GRADE_ID VARCHAR2 (240)

POSITION_ID NUMBER (15)

D_POSITION_ID VARCHAR2 (4000)

JOB_ID NUMBER (15)

D_JOB_ID VARCHAR2 (700)

ASSIGNMENT_STATUS_TYPE_ID NUMBER (9) Yes
STATUS VARCHAR2 (80)

PER_SYSTEM_STATUS VARCHAR2 (30)

LOCATION_ID NUMBER (15)

D_LOCATION_ID VARCHAR2 (60)

SUPERVISOR_ID NUMBER (10)

SUPERVISOR_NAME VARCHAR2 (240)

SUPERVISOR_EMPLOYEE_NUMBER VARCHAR2 (30)

PERSON_ID NUMBER (10) Yes
ORGANIZATION_ID NUMBER (15) Yes
D_ORGANIZATION_ID 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 VARCHAR2 (11)

FREQUENCY VARCHAR2 (30)

FREQUENCY_MEANING VARCHAR2 (4000)

MANAGER_FLAG VARCHAR2 (30)

NORMAL_HOURS NUMBER (22)

PROBATION_PERIOD NUMBER (22)

PROBATION_UNIT VARCHAR2 (30)

PROBATION_UNIT_MEANING VARCHAR2 (4000)

TIME_NORMAL_FINISH DATE


TIME_NORMAL_START DATE


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)

RECRUITER_ID NUMBER (10)

D_RECRUITER_ID VARCHAR2 (240)

RECRUITER_NUMBER VARCHAR2 (30)

PERSON_REFERRED_BY_ID NUMBER (10)

D_PERSON_REFERRED_BY_ID VARCHAR2 (240)

D_PERSON_REFERRED_NUMBER VARCHAR2 (30)

SOURCE_ORGANIZATION_ID NUMBER (15)

D_SOURCE_ORGANIZATION_ID VARCHAR2 (240)

VACANCY_ID NUMBER (15)

D_VACANCY_ID VARCHAR2 (30)

V_ORGANIZATION_ID NUMBER (15)

V_PEOPLE_GROUP_ID NUMBER (15)

V_JOB_ID NUMBER (15)

V_POSITION_ID NUMBER (15)

V_GRADE_ID NUMBER (15)

V_LOCATION_ID NUMBER (15)

V_RECRUITER_ID NUMBER (10)

ASSIGNMENT_TYPE VARCHAR2 (1) Yes
APPLICATION_ID 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)

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)
WORK_AT_HOME VARCHAR2 (30)
JOB_POST_SOURCE_NAME VARCHAR2 (240)
GRADE_LADDER_PGM_ID NUMBER (15)
SUPERVISOR_ASSIGNMENT_ID NUMBER (15)
GRADE_LADDER_NAME VARCHAR2 (240)
SUPERVISOR_ASSIGNMENT_NUMBER VARCHAR2 (30)
PAYROLL_ID NUMBER (9)
PAY_BASIS_ID NUMBER (9)
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
,      RECRUITMENT_ACTIVITY_ID
,      D_RECRUITMENT_ACTIVITY_ID
,      C_REC_ACT_TYPE
,      RECRUITMENT_ACTIVITY_TYPE
,      GRADE_ID
,      D_GRADE_ID
,      POSITION_ID
,      D_POSITION_ID
,      JOB_ID
,      D_JOB_ID
,      ASSIGNMENT_STATUS_TYPE_ID
,      STATUS
,      PER_SYSTEM_STATUS
,      LOCATION_ID
,      D_LOCATION_ID
,      SUPERVISOR_ID
,      SUPERVISOR_NAME
,      SUPERVISOR_EMPLOYEE_NUMBER
,      PERSON_ID
,      ORGANIZATION_ID
,      D_ORGANIZATION_ID
,      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
,      MANAGER_FLAG
,      NORMAL_HOURS
,      PROBATION_PERIOD
,      PROBATION_UNIT
,      PROBATION_UNIT_MEANING
,      TIME_NORMAL_FINISH
,      TIME_NORMAL_START
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      CREATED_BY
,      CREATION_DATE
,      SAL_REVIEW_PERIOD
,      RECRUITER_ID
,      D_RECRUITER_ID
,      RECRUITER_NUMBER
,      PERSON_REFERRED_BY_ID
,      D_PERSON_REFERRED_BY_ID
,      D_PERSON_REFERRED_NUMBER
,      SOURCE_ORGANIZATION_ID
,      D_SOURCE_ORGANIZATION_ID
,      VACANCY_ID
,      D_VACANCY_ID
,      V_ORGANIZATION_ID
,      V_PEOPLE_GROUP_ID
,      V_JOB_ID
,      V_POSITION_ID
,      V_GRADE_ID
,      V_LOCATION_ID
,      V_RECRUITER_ID
,      ASSIGNMENT_TYPE
,      APPLICATION_ID
,      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
,      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
,      WORK_AT_HOME
,      JOB_POST_SOURCE_NAME
,      GRADE_LADDER_PGM_ID
,      SUPERVISOR_ASSIGNMENT_ID
,      GRADE_LADDER_NAME
,      SUPERVISOR_ASSIGNMENT_NUMBER
,      PAYROLL_ID
,      PAY_BASIS_ID
FROM APPS.PER_ASSIGNMENTS_V5;

Dependencies

[top of page]

APPS.PER_ASSIGNMENTS_V5 references the following:

SchemaAPPS
SynonymBEN_PGM_F
SynonymFND_SESSIONS
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
PL/SQL PackageHR_SECURITY - show dependent code
SynonymPER_ALL_ASSIGNMENTS_F
SynonymPER_ALL_PEOPLE_F
SynonymPER_ALL_VACANCIES
ViewPER_ASSIGNMENTS_F2
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_RECRUITMENT_ACTIVITIES

APPS.PER_ASSIGNMENTS_V5 is not referenced by any database object