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


TABLE: HR.PER_ALL_ASSIGNMENTS_F

Object Details
Object Name: PER_ALL_ASSIGNMENTS_F
Object Type: TABLE
Owner: HR
FND Design Data: TablePER.PER_ALL_ASSIGNMENTS_F
Subobject Name:
Status: VALID


PER_ALL_ASSIGNMENTS_F is the DateTracked table that holds information
about employee assignments. It also holds details of assignments for
which an applicant has applied. The ASSIGNMENT_TYPE is E for an
employee assignment, and A for an applicant assignment. Employees
must have at least one employee assignment at all times in a period of
service, and each assignment must have a unique number. Employees can
have multiple assignments at any time, but there must always be a
designated primary assignment. Applicants must have at least one
applicant assignment throughout their application. Each assignment
has an assignment status that can change over time.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Primary Key: PER_ASSIGNMENTS_F_PK
  1. ColumnASSIGNMENT_ID
  2. ColumnEFFECTIVE_START_DATE
  3. ColumnEFFECTIVE_END_DATE
Indexes
Index Type Uniqueness Tablespace Column
PER_ASSIGNMENTS_F_PK NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnASSIGNMENT_ID
ColumnEFFECTIVE_START_DATE
ColumnEFFECTIVE_END_DATE
PER_ASSIGNMENTS_F_FK1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnBUSINESS_GROUP_ID
PER_ASSIGNMENTS_F_FK13 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnRECRUITMENT_ACTIVITY_ID
PER_ASSIGNMENTS_F_FK14 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnSOURCE_ORGANIZATION_ID
PER_ASSIGNMENTS_F_FK15 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnORGANIZATION_ID
PER_ASSIGNMENTS_F_FK16 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnPEOPLE_GROUP_ID
PER_ASSIGNMENTS_F_FK17 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnSOFT_CODING_KEYFLEX_ID
PER_ASSIGNMENTS_F_FK18 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnVACANCY_ID
PER_ASSIGNMENTS_F_FK19 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnPAY_BASIS_ID
PER_ASSIGNMENTS_F_FK20 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnESTABLISHMENT_ID
PER_ASSIGNMENTS_F_FK21 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnCOLLECTIVE_AGREEMENT_ID
PER_ASSIGNMENTS_F_FK22 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnCONTRACT_ID
PER_ASSIGNMENTS_F_FK23 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnCAGR_GRADE_DEF_ID
PER_ASSIGNMENTS_F_FK3 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnGRADE_ID
PER_ASSIGNMENTS_F_FK31 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnPOSTING_CONTENT_ID
PER_ASSIGNMENTS_F_FK4 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnPOSITION_ID
PER_ASSIGNMENTS_F_FK5 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnJOB_ID
PER_ASSIGNMENTS_F_FK52 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnVENDOR_ID
PER_ASSIGNMENTS_F_FK6 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnASSIGNMENT_STATUS_TYPE_ID
PER_ASSIGNMENTS_F_FK8 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnLOCATION_ID
PER_ASSIGNMENTS_F_N03 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnGRADE_LADDER_PGM_ID
PER_ASSIGNMENTS_F_N10 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnSUPERVISOR_ID
ColumnEFFECTIVE_START_DATE
ColumnEFFECTIVE_END_DATE
PER_ASSIGNMENTS_F_N11 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnSPECIAL_CEILING_STEP_ID
PER_ASSIGNMENTS_F_N12 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnPERSON_ID
ColumnEFFECTIVE_START_DATE
ColumnEFFECTIVE_END_DATE
PER_ASSIGNMENTS_F_N2 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnRECRUITER_ID
PER_ASSIGNMENTS_F_N50 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnASSIGNMENT_NUMBER
PER_ASSIGNMENTS_F_N55 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnSUPERVISOR_ASSIGNMENT_ID
ColumnEFFECTIVE_START_DATE
ColumnEFFECTIVE_END_DATE
PER_ASSIGNMENTS_F_N7 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnPAYROLL_ID
PER_ASSIGNMENTS_F_N9 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnPERSON_REFERRED_BY_ID
PER_ASSIGNMENTS_N4 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnPERIOD_OF_SERVICE_ID
PER_ASSIGNMENTS_N5 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnAPPLICATION_ID
Foreign Keys
Table
Foreign Table Foreign Key Column
PER_ALL_ASSIGNMENTS_F PER_ASSIGNMENTS_F_FK1 TableHR_ALL_ORGANIZATION_UNITS PER_ALL_ASSIGNMENTS_F BUSINESS_GROUP_ID
PER_ALL_ASSIGNMENTS_F PER_ASSIGNMENTS_F_FK14 TableHR_ALL_ORGANIZATION_UNITS PER_ALL_ASSIGNMENTS_F SOURCE_ORGANIZATION_ID
PER_ALL_ASSIGNMENTS_F PER_ASSIGNMENTS_F_FK15 TableHR_ALL_ORGANIZATION_UNITS PER_ALL_ASSIGNMENTS_F ORGANIZATION_ID
PER_ALL_ASSIGNMENTS_F PER_ASSIGNMENTS_F_FK20 TableHR_ALL_ORGANIZATION_UNITS PER_ALL_ASSIGNMENTS_F ESTABLISHMENT_ID
PER_ALL_ASSIGNMENTS_F PER_ASSIGNMENTS_F_FK8 TableHR_LOCATIONS_ALL PER_ALL_ASSIGNMENTS_F LOCATION_ID
PER_ALL_ASSIGNMENTS_F PER_ASSIGNMENTS_F_FK17 TableHR_SOFT_CODING_KEYFLEX PER_ALL_ASSIGNMENTS_F SOFT_CODING_KEYFLEX_ID
PER_ALL_ASSIGNMENTS_F PER_ASSIGNMENTS_F_FK16 TablePAY_PEOPLE_GROUPS PER_ALL_ASSIGNMENTS_F PEOPLE_GROUP_ID
PER_ALL_ASSIGNMENTS_F PER_ASSIGNMENTS_F_FK18 TablePER_ALL_VACANCIES PER_ALL_ASSIGNMENTS_F VACANCY_ID
PER_ALL_ASSIGNMENTS_F PER_ASSIGNMENTS_F_FK50 TablePER_APPLICATIONS PER_ALL_ASSIGNMENTS_F APPLICATION_ID
PER_ALL_ASSIGNMENTS_F PER_ASSIGNMENTS_F_FK6 TablePER_ASSIGNMENT_STATUS_TYPES PER_ALL_ASSIGNMENTS_F ASSIGNMENT_STATUS_TYPE_ID
PER_ALL_ASSIGNMENTS_F PER_ASSIGNMENTS_F_FK23 TablePER_CAGR_GRADES_DEF PER_ALL_ASSIGNMENTS_F CAGR_GRADE_DEF_ID
PER_ALL_ASSIGNMENTS_F PER_ASSIGNMENTS_F_FK21 TablePER_COLLECTIVE_AGREEMENTS PER_ALL_ASSIGNMENTS_F COLLECTIVE_AGREEMENT_ID
PER_ALL_ASSIGNMENTS_F PER_ASSIGNMENTS_F_FK3 TablePER_GRADES PER_ALL_ASSIGNMENTS_F GRADE_ID
PER_ALL_ASSIGNMENTS_F PER_ASSIGNMENTS_F_FK5 TablePER_JOBS PER_ALL_ASSIGNMENTS_F JOB_ID
PER_ALL_ASSIGNMENTS_F PER_ASSIGNMENTS_F_FK19 TablePER_PAY_BASES PER_ALL_ASSIGNMENTS_F PAY_BASIS_ID
PER_ALL_ASSIGNMENTS_F PER_ASSIGNMENTS_F_FK51 TablePER_PERIODS_OF_SERVICE PER_ALL_ASSIGNMENTS_F PERIOD_OF_SERVICE_ID
PER_ALL_ASSIGNMENTS_F PER_ASSIGNMENTS_F_FK13 TablePER_RECRUITMENT_ACTIVITIES PER_ALL_ASSIGNMENTS_F RECRUITMENT_ACTIVITY_ID
Columns
Name Datatype Length Mandatory Comments
ASSIGNMENT_ID NUMBER (10) Yes System-generated primary key column.
EFFECTIVE_START_DATE DATE
Yes Effective start date.
EFFECTIVE_END_DATE DATE
Yes Effective end date.
BUSINESS_GROUP_ID NUMBER (15) Yes Foreign key to HR_ORGANIZATION_UNITS.
RECRUITER_ID NUMBER (10)
Foreign key to PER_PEOPLE.
GRADE_ID NUMBER (15)
Foreign key to PER_GRADES.
POSITION_ID NUMBER (15)
Foreign key to PER_ALL_POSITIONS.
JOB_ID NUMBER (15)
Foreign key to PER_JOBS.
ASSIGNMENT_STATUS_TYPE_ID NUMBER (9) Yes Foreign key to PER_ASSIGNMENT_STATUS_TYPES.
PAYROLL_ID NUMBER (9)
Foreign key to PAY_PAYROLLS.
LOCATION_ID NUMBER (15)
Foreign key to HR_LOCATIONS.
PERSON_REFERRED_BY_ID NUMBER (10)
Foreign key to PER_PEOPLE.
SUPERVISOR_ID NUMBER (10)
Foreign key to PER_PEOPLE.
SPECIAL_CEILING_STEP_ID NUMBER (15)
Foreign key to PER_SPINAL_POINT_STEPS.
PERSON_ID NUMBER (10) Yes Foreign key to PER_PEOPLE.
RECRUITMENT_ACTIVITY_ID NUMBER (15)
Foreign key to PER_RECRUITMENT_ACTIVITIES.
SOURCE_ORGANIZATION_ID NUMBER (15)
Foreign key to HR_ORGANIZATION_UNITS.
ORGANIZATION_ID NUMBER (15) Yes Foreign key to HR_ORGANIZATION_UNITS.
PEOPLE_GROUP_ID NUMBER (15)
Foreign key to PAY_PEOPLE_GROUPS.
SOFT_CODING_KEYFLEX_ID NUMBER (15)
Foreign key to HR_SOFT_CODING_KEYFLEX.
VACANCY_ID NUMBER (15)
Foreign key to PER_ALL_VACANCIES.
PAY_BASIS_ID NUMBER (9)
Foreign key to PER_PAY_BASES.
ASSIGNMENT_SEQUENCE NUMBER (15) Yes Used when defaulting assignment number.
ASSIGNMENT_TYPE VARCHAR2 (1) Yes Assignment type; (E)mployee or (A)pplicant.
PRIMARY_FLAG VARCHAR2 (30) Yes Indicates primary employee assignment. Y/N.
APPLICATION_ID NUMBER (15)
Foreign key to PER_APPLICATIONS.
ASSIGNMENT_NUMBER VARCHAR2 (30)
Employee assignment number.
CHANGE_REASON VARCHAR2 (30)
Reason the assignment last changed.
COMMENT_ID NUMBER (15)
Foreign key reference to HR_COMMENTS.
DATE_PROBATION_END DATE

End date of probation period.
DEFAULT_CODE_COMB_ID NUMBER (15)
Foreign key to GL_CODE_COMBINATIONS.
EMPLOYMENT_CATEGORY VARCHAR2 (30)
User defined category. For example Full-Time Permanent or Part-Time Permanent. Known as Assignment Category.
FREQUENCY VARCHAR2 (30)
Frequency of normal working hours, - week, month, year.
INTERNAL_ADDRESS_LINE VARCHAR2 (80)
Internal address details such as floor or office number.
MANAGER_FLAG VARCHAR2 (30)
Indicates whether the employee in this assignment is designated a manager.
NORMAL_HOURS NUMBER (22)
Normal working hours.
PERF_REVIEW_PERIOD NUMBER (15)
Number of units of time between performance reviews.
PERF_REVIEW_PERIOD_FREQUENCY VARCHAR2 (30)
Frequency units. Used with PERF_REVIEW_PERIOD to define time between reviews.
PERIOD_OF_SERVICE_ID NUMBER (15)
Foreign key to PER_PERIODS_OF_SERVICE.
PROBATION_PERIOD NUMBER (22)
Duration of probation period.
PROBATION_UNIT VARCHAR2 (30)
Units of probation period duration.
SAL_REVIEW_PERIOD NUMBER (15)
Length of time between salary reviews.
SAL_REVIEW_PERIOD_FREQUENCY VARCHAR2 (30)
Used with SAL REVIEW PERIOD to define time between salary reviews.
SET_OF_BOOKS_ID NUMBER (15)
Foreign key to GL_SETS_OF_BOOKS.
SOURCE_TYPE VARCHAR2 (30)
Recruitment activity source for applicant assignment, for example, Advertisement).
TIME_NORMAL_FINISH VARCHAR2 (5)
Work day normal end time.
TIME_NORMAL_START VARCHAR2 (5)
Work day normal start time.
BARGAINING_UNIT_CODE VARCHAR2 (30)
Bargaining unit code
LABOUR_UNION_MEMBER_FLAG VARCHAR2 (30)
Labour union member flag
HOURLY_SALARIED_CODE VARCHAR2 (30)
Identifies if the assignment is paid by the hour or by a salary.
CONTRACT_ID NUMBER (9)
Foreign key to PER_CONTRACTS_F
COLLECTIVE_AGREEMENT_ID NUMBER (9)
Foreign key to PER_COLLECTIVE_AGREEMENTS
CAGR_ID_FLEX_NUM NUMBER (15)
Keyflex Structure Identifier for Collectively Agreed Grade
CAGR_GRADE_DEF_ID NUMBER (15)
Foreign key to PER_CAGR_GRADES_DEF
ESTABLISHMENT_ID NUMBER (15)
Foreign key to HR_ORGANIZATION_UNITS
REQUEST_ID NUMBER (15)
Standard Who column.
PROGRAM_APPLICATION_ID NUMBER (15)
Standard Who column.
PROGRAM_ID NUMBER (15)
Standard Who column.
PROGRAM_UPDATE_DATE DATE

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

Standard Who column.
LAST_UPDATED_BY NUMBER (15)
Standard Who column.
LAST_UPDATE_LOGIN NUMBER (15)
Standard Who column.
CREATED_BY NUMBER (15)
Standard Who column.
CREATION_DATE DATE

Standard Who column.
TITLE VARCHAR2 (30)
Title for assignment.
OBJECT_VERSION_NUMBER NUMBER (9)
System-generated version of row. Increments by one with each update.
NOTICE_PERIOD NUMBER (10)
notice period
NOTICE_PERIOD_UOM VARCHAR2 (30)
notice period unit of measure
EMPLOYEE_CATEGORY VARCHAR2 (30)
employee category
WORK_AT_HOME VARCHAR2 (30)
work at home flag
JOB_POST_SOURCE_NAME VARCHAR2 (240)
job post source name
POSTING_CONTENT_ID NUMBER (15)
The posting to which the applicant has applied.
PERIOD_OF_PLACEMENT_DATE_START DATE

Part of foreign key to per_periods_of_placement
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
ASSIGNMENT_CATEGORY VARCHAR2 (30)
Assignment Category. This column is not currently used but reserved for future use.
PROJECT_TITLE VARCHAR2 (30)
Title of project of which this assignment forms part
APPLICANT_RANK NUMBER

applicant rank
VENDOR_SITE_ID NUMBER (15)
Foreign key reference to po_vendor_sites_all
PO_HEADER_ID NUMBER (15)
Foreign key reference to po_headers_all
PO_LINE_ID NUMBER (15)
Foreign key reference to po_lines_all
PROJECTED_ASSIGNMENT_END DATE

The date the assignment is expected to end
GRADE_LADDER_PGM_ID NUMBER (15)
Link assignment to grade_ladder for Benefits
SUPERVISOR_ASSIGNMENT_ID NUMBER (15)
Not to be used at the present time
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
,      CONTRACT_ID
,      COLLECTIVE_AGREEMENT_ID
,      CAGR_ID_FLEX_NUM
,      CAGR_GRADE_DEF_ID
,      ESTABLISHMENT_ID
,      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
,      OBJECT_VERSION_NUMBER
,      NOTICE_PERIOD
,      NOTICE_PERIOD_UOM
,      EMPLOYEE_CATEGORY
,      WORK_AT_HOME
,      JOB_POST_SOURCE_NAME
,      POSTING_CONTENT_ID
,      PERIOD_OF_PLACEMENT_DATE_START
,      VENDOR_ID
,      VENDOR_EMPLOYEE_NUMBER
,      VENDOR_ASSIGNMENT_NUMBER
,      ASSIGNMENT_CATEGORY
,      PROJECT_TITLE
,      APPLICANT_RANK
,      VENDOR_SITE_ID
,      PO_HEADER_ID
,      PO_LINE_ID
,      PROJECTED_ASSIGNMENT_END
,      GRADE_LADDER_PGM_ID
,      SUPERVISOR_ASSIGNMENT_ID
FROM HR.PER_ALL_ASSIGNMENTS_F;

Dependencies

[top of page]

HR.PER_ALL_ASSIGNMENTS_F does not reference any database object

HR.PER_ALL_ASSIGNMENTS_F is referenced by following:

SchemaAPPS
TriggerBEN_EXT_ASG_EVT
TriggerGHR_PER_ASSIGNMENTS_F_AFIUD
Materialized ViewHRI_MDP_SUP_WRKFC_JX_MV
Materialized ViewHR_MBS_WRKFC_JCX_MV
Materialized ViewHR_MBS_WRKFC_JCX_SUPH_MV
TriggerHR_PA_MAINTN_ASSIN_HIST_BRD
TriggerHR_PA_MAINTN_ASSIN_HIST_BRI
TriggerHR_PA_MAINTN_ASSIN_HIST_BRU
TriggerPERALLASSIGNMENTSF_110U_DYT
TriggerPERALLASSIGNMENTSF_111D_DYT
SynonymPER_ALL_ASSIGNMENTS_F
TriggerPER_ALL_ASSIGNMENTS_F_OVN
TriggerPER_ALL_ASSIGNMENTS_F_WHO