PER_ALL_ASSIGNMENTS_M in Oracle Fusion HCM

The “PER_ALL_ASSIGNMENTS_M” table in Oracle Fusion HCM is a key table that stores information about assignments in the system. It is part of the Oracle Fusion Human Capital Management (HCM) application and plays a crucial role in managing employee assignments and their associated details.

Functionally, the “PER_ALL_ASSIGNMENTS_M” table stores data related to the employment assignments of individuals within an organization. It contains information such as the assignment ID, assignment start date, assignment end date, assignment type, position ID, job ID, location ID, business unit ID, and other relevant assignment-related attributes.

This table is designed to capture a comprehensive history of assignments for an employee. It maintains a record of all past and current assignments, allowing organizations to track an individual’s employment history and understand their current and previous roles within the company. The table includes effective-dated records, ensuring accurate historical tracking of assignment changes over time.

Related tables to “PER_ALL_ASSIGNMENTS_M”

  1. PER_ASSIGNMENTS_V”: This View holds additional details about assignments and is based on “PER_ALL_ASSIGNMENTS_M” through the assignment ID. It stores data such as assignment status, working hours, payroll information, and other assignment-specific attributes.
  2. PER_JOBS“: This table contains information about the jobs defined in the system. It includes details such as job ID, job name, job family, job level, and other job-related attributes. The “PER_ALL_ASSIGNMENTS_M” table references this table to associate an assignment with a specific job.
  3. PER_ALL_POSITIONS_F“: This table stores information about positions within the organization. It includes data such as position ID, position name, position type, position hierarchy, and other position-related attributes. The “PER_ALL_ASSIGNMENTS_M” table references this table to link an assignment with a specific position.
  4. HR_ORGANIZATION_UNITS“: This table holds details about business units within the organization. It includes data such as BUSINESS_GROUP_ID, business unit name, business unit type, and other business unit-related attributes. The “PER_ALL_ASSIGNMENTS_M” table references this table to associate an assignment with a specific business unit.

These related tables help provide a comprehensive view of an employee’s assignment history, linking assignments to jobs, positions, and business units for better organizational management and reporting in Oracle Fusion HCM.

Details

  • Schema: FUSION
  • Object owner: PER
  • Object type: TABLE
  • Tablespace: FUSION_TS_TX_DATA

Primary Key

NameColumns
PER_ALL_ASSIGNMENTS_M_PKASSIGNMENT_ID, EFFECTIVE_START_DATE, EFFECTIVE_END_DATE, EFFECTIVE_LATEST_CHANGE, EFFECTIVE_SEQUENCE
image 14 PER_ALL_ASSIGNMENTS_M 1

Columns

NameDatatypeLengthPrecisionNot-nullCommentsFlexfield-mapping
ASSIGNMENT_IDNUMBER18YesThis is a system generated primary key. Surrogate key.
EFFECTIVE_START_DATEDATEYesDate Effective Entity: indicates the date at the beginning of the date range within which the row is effective.
EFFECTIVE_END_DATEDATEYesDate Effective Entity: indicates the date at the end of the date range within which the row is effective.
BUSINESS_GROUP_IDNUMBER18YesIdentifier of Enterprise, used for multi-tenancy partitioning. Foreign key to HR_ORGANIZATION_UNITS.
PERSON_IDNUMBER18YesIdentifies person holding an assignment or a set of Employment/Placement Terms. Foreign key to PER_PERSONS.
PERIOD_OF_SERVICE_IDNUMBER18Identifies the Employment Level. Foreign key to PER_PERIODS_OF_SERVICE.
ASSIGNMENT_TYPEVARCHAR230YesIdentifies the type of record: either assignment (employee, CWK, applicant, non-workers) or a set of Terms.
ASSIGNMENT_NUMBERVARCHAR250Uniquely identifies the assignment or terms. Valid for Workers and non-workers. Assignment Level:By default [Person Number ] – [sequence] Work Term Level:[sequence]
ASSIGNMENT_SEQUENCENUMBER18YesUsed when defaulting assignment number.
ASSIGNMENT_STATUS_TYPE_IDNUMBER18YesDenormalized status of the assignment. This is derived using the Assignment Status Type ID.
PRIMARY_FLAGVARCHAR230YesPrimary flag. Accepts value of ?Y? or ?N? based on ?YES_NO? lookup type. If set to ?Yes?, record represents the primary assignment associated to the primary Work Relationship and primary set of Employment/Placement Terms.
ORGANIZATION_IDNUMBER18Department Identifier, it is optional.
JOB_IDNUMBER18Foreign key to PER_JOBS_F.
LOCATION_IDNUMBER18Foreign key to HR_LOCATIONS_ALL_F.
POSITION_IDNUMBER18Foreign key to PER_ALL_POSITIONS_F.
GRADE_IDNUMBER18Foreign key to PER_GRADES_F.
GRADE_LADDER_PGM_IDNUMBER18Link assignment to grade ladder for Benefits.
PEOPLE_GROUP_IDNUMBER18Foreign key to PER_PEOPLE_GROUPS.
COLLECTIVE_AGREEMENT_IDNUMBER18Foreign key to PER_COLLECTIVE_AGREEMENTS.
BARGAINING_UNIT_CODEVARCHAR230Bargaining unit code.
LABOUR_UNION_MEMBER_FLAGVARCHAR230Labour union member flag. Accepts values of ?Y? or ?N?.
CAGR_GRADE_DEF_IDNUMBER18Foreign key to PER_CAGR_GRADES_DEF.
CAGR_ID_FLEX_NUMNUMBER18Key flex Structure Identifier for Collectively Agreed Grade.
CONTRACT_IDNUMBER18Foreign key to PER_CONTRACTS_F.
MANAGER_FLAGVARCHAR230Indicates whether the employee in this assignment is designated a manager. Based on ?YES_NO? lookup type.
DATE_PROBATION_ENDDATEEnd date of probation period.
PROBATION_PERIODNUMBER22Duration of probation period.
PROBATION_UNITVARCHAR230Units of probation period duration. Based on QUALIFYING_UNITS lookup type.
NORMAL_HOURSNUMBER22Normal working hours.
FREQUENCYVARCHAR230Frequency of normal working hours, – week, month, year. Sourced from ?Frequency? lookup type.
WORK_AT_HOMEVARCHAR230Work at home flag.
TIME_NORMAL_FINISHVARCHAR25Work day normal end time.
TIME_NORMAL_STARTVARCHAR25Work day normal start time.
NOTICE_PERIODNUMBER10Notice period for the assignment.
NOTICE_PERIOD_UOMVARCHAR230Notice period unit of measure.
DEFAULT_CODE_COMB_IDNUMBER18Foreign key to GL_CODE_COMBINATIONS.
EMPLOYEE_CATEGORYVARCHAR230Based on Lookup Type = ?EMPLOYEE_CATG?: Blue collar, Civil Servant, etc.
EMPLOYMENT_CATEGORYVARCHAR230User defined category. For example Full-Time Permanent or Part-Time Permanent. Lookup Type = ?EMP_CAT?.
ESTABLISHMENT_IDNUMBER18Foreign key to HR_ORGANIZATION_UNITS_F.
HOURLY_SALARIED_CODEVARCHAR230Identifies if the assignment is paid by the hour or by a salary. Either maintained at the assignment level or ?Employment/Placement Terms? but not both.
SAL_REVIEW_PERIODNUMBER18Length of time between salary reviews. Either maintained at the assignment level or ?Employment/Placement Terms? but not both.
SAL_REVIEW_PERIOD_FREQUENCYVARCHAR230Used with SAL REVIEW PERIOD to define time between salary reviews. Based on ?QUALIFYING_UNITS? lookup type.
JOB_POST_SOURCE_NAMEVARCHAR2240Job post source name.
PROJECT_TITLEVARCHAR280Obsolete
PERSON_REFERRED_BY_IDNUMBER18Identifies person who referred applicant. Foreign key to PER_PERSONS.
PO_HEADER_IDNUMBER18Foreign key reference to po_headers_all.
PO_LINE_IDNUMBER18Foreign key reference to po_lines_all.
RECRUITER_IDNUMBER18Identifies recruiter. Foreign Key to PER_PERSONS.
RECRUITMENT_ACTIVITY_IDNUMBER18Identifies activity associated with the recruitment process. Foreign key to PER_RECRUITMENT_ACTIVITIES.
VACANCY_IDNUMBER18Foreign key to PER_ALL_VACANCIES.
APPLICANT_RANKNUMBERRank assigned to an applicant based on suitability and other criteria
POSTING_CONTENT_IDNUMBER18The posting to which the applicant has applied.
SOURCE_ORGANIZATION_IDNUMBER18Valid for ‘Offer’ and ‘Applicant’ Assignments only. Captured as part of the ?Application Source? details. For instance, Agency or Marketing.
SOURCE_TYPEVARCHAR230Recruitment activity source for applicant assignment, for example, Advertisement.
PROJECTED_ASSIGNMENT_ENDDATEThe date the assignment is expected to end.
SET_OF_BOOKS_IDNUMBER18This is called Ledger in Fusion. Defaulted from Business Unit.
SOFT_CODING_KEYFLEX_IDNUMBER18Obsolete
SPECIAL_CEILING_STEP_IDNUMBER18Foreign key to PER_GRADE_STEPS_F.
VENDOR_ASSIGNMENT_NUMBERVARCHAR230Assignment number of non-payrolled worker assignment with vending organization.
VENDOR_EMPLOYEE_NUMBERVARCHAR230Employee number of worker with vending organization.
VENDOR_IDNUMBER18Foreign key reference to po_vendors.
VENDOR_SITE_IDNUMBER18Foreign key reference to po_vendor_sites_all.
ASS_ATTRIBUTE_CATEGORYVARCHAR230Descriptive Flexfield: structure definition of the user descriptive flexfield.Assignment Attributes (PER_ASG_DF)
ASS_ATTRIBUTE1VARCHAR2150Descriptive Flexfield: segment of the user descriptive flexfield.Assignment Attributes (PER_ASG_DF)
ASS_ATTRIBUTE2VARCHAR2150Descriptive Flexfield: segment of the user descriptive flexfield.Assignment Attributes (PER_ASG_DF)
ASS_ATTRIBUTE3VARCHAR2150Descriptive Flexfield: segment of the user descriptive flexfield.Assignment Attributes (PER_ASG_DF)
ASS_ATTRIBUTE4VARCHAR2150Descriptive Flexfield: segment of the user descriptive flexfield.Assignment Attributes (PER_ASG_DF)
ASS_ATTRIBUTE5VARCHAR2150Descriptive Flexfield: segment of the user descriptive flexfield.Assignment Attributes (PER_ASG_DF)
ASS_ATTRIBUTE6VARCHAR2150Descriptive Flexfield: segment of the user descriptive flexfield.Assignment Attributes (PER_ASG_DF)
ASS_ATTRIBUTE7VARCHAR2150Descriptive Flexfield: segment of the user descriptive flexfield.Assignment Attributes (PER_ASG_DF)
ASS_ATTRIBUTE8VARCHAR2150Descriptive Flexfield: segment of the user descriptive flexfield.Assignment Attributes (PER_ASG_DF)
ASS_ATTRIBUTE9VARCHAR2150Descriptive Flexfield: segment of the user descriptive flexfield.Assignment Attributes (PER_ASG_DF)
ASS_ATTRIBUTE10VARCHAR2150Descriptive Flexfield: segment of the user descriptive flexfield.Assignment Attributes (PER_ASG_DF)
ASS_ATTRIBUTE11VARCHAR2150Descriptive Flexfield: segment of the user descriptive flexfield.Assignment Attributes (PER_ASG_DF)
ASS_ATTRIBUTE12VARCHAR2150Descriptive Flexfield: segment of the user descriptive flexfield.Assignment Attributes (PER_ASG_DF)
ASS_ATTRIBUTE13VARCHAR2150Descriptive Flexfield: segment of the user descriptive flexfield.Assignment Attributes (PER_ASG_DF)
ASS_ATTRIBUTE14VARCHAR2150Descriptive Flexfield: segment of the user descriptive flexfield.Assignment Attributes (PER_ASG_DF)
ASS_ATTRIBUTE15VARCHAR2150Descriptive Flexfield: segment of the user descriptive flexfield.Assignment Attributes (PER_ASG_DF)
ASS_ATTRIBUTE16VARCHAR2150Descriptive Flexfield: segment of the user descriptive flexfield.Assignment Attributes (PER_ASG_DF)
ASS_ATTRIBUTE17VARCHAR2150Descriptive Flexfield: segment of the user descriptive flexfield.Assignment Attributes (PER_ASG_DF)
ASS_ATTRIBUTE18VARCHAR2150Descriptive Flexfield: segment of the user descriptive flexfield.Assignment Attributes (PER_ASG_DF)
ASS_ATTRIBUTE19VARCHAR2150Descriptive Flexfield: segment of the user descriptive flexfield.Assignment Attributes (PER_ASG_DF)
ASS_ATTRIBUTE20VARCHAR2150Descriptive Flexfield: segment of the user descriptive flexfield.Assignment Attributes (PER_ASG_DF)
ASS_ATTRIBUTE21VARCHAR2150Descriptive Flexfield: segment of the user descriptive flexfield.Assignment Attributes (PER_ASG_DF)
ASS_ATTRIBUTE22VARCHAR2150Descriptive Flexfield: segment of the user descriptive flexfield.Assignment Attributes (PER_ASG_DF)
ASS_ATTRIBUTE23VARCHAR2150Descriptive Flexfield: segment of the user descriptive flexfield.Assignment Attributes (PER_ASG_DF)
ASS_ATTRIBUTE24VARCHAR2150Descriptive Flexfield: segment of the user descriptive flexfield.Assignment Attributes (PER_ASG_DF)
ASS_ATTRIBUTE25VARCHAR2150Descriptive Flexfield: segment of the user descriptive flexfield.Assignment Attributes (PER_ASG_DF)
ASS_ATTRIBUTE26VARCHAR2150Descriptive Flexfield: segment of the user descriptive flexfield.Assignment Attributes (PER_ASG_DF)
ASS_ATTRIBUTE27VARCHAR2150Descriptive Flexfield: segment of the user descriptive flexfield.Assignment Attributes (PER_ASG_DF)
ASS_ATTRIBUTE28VARCHAR2150Descriptive Flexfield: segment of the user descriptive flexfield.Assignment Attributes (PER_ASG_DF)
ASS_ATTRIBUTE29VARCHAR2150Descriptive Flexfield: segment of the user descriptive flexfield.Assignment Attributes (PER_ASG_DF)
ASS_ATTRIBUTE30VARCHAR2150Descriptive Flexfield: segment of the user descriptive flexfield.Assignment Attributes (PER_ASG_DF)
OBJECT_VERSION_NUMBERNUMBER9YesUsed to implement optimistic locking. This number is incremented every time that the row is updated. The number is compared at the start and end of a transaction to detect whether another session has updated the row since it was queried.
CREATED_BYVARCHAR264YesWho column: indicates the user who created the row.
CREATION_DATETIMESTAMPYesWho column: indicates the date and time of the creation of the row.
LAST_UPDATE_DATETIMESTAMPYesWho column: indicates the date and time of the last update of the row.
LAST_UPDATE_LOGINVARCHAR232Who column: indicates the session login associated to the user who last updated the row.
LAST_UPDATED_BYVARCHAR264YesWho column: indicates the user who last updated the row.
WORK_TERMS_ASSIGNMENT_IDNUMBER18Foreign key to PER_ALL_ASSIGNMENTS_M for a work term.
ACTION_CODEVARCHAR230Specifies the action performed on the particular record. For example: HIRE, ADD PENDING WORKER, MANAGER CHANGE, etc.
ASSIGNMENT_NAMEVARCHAR280Describes the type of assignment or set of Terms. Users can configure how to derive this (at setup time). This is optional, by default (out-of-the-box) this is derived as follows: [job name] – [department name].
ASSIGNMENT_STATUS_TYPEVARCHAR230YesDenormalized status of the assignment. This is derived using the Assignment Status Type ID.
AUTO_END_FLAGVARCHAR230YesUsed for temporary assignments. Determines whether to end the temporary job automatically.
DUTIES_TYPEVARCHAR230Duties type. Apply for temporary assignments. Derived from a lookup code. Enterprise stores types in a specific table rather than a lookup.
EFFECTIVE_SEQUENCENUMBER4YesDate Effective Entity: indicates the order of different changes made during a day. The lowest value represents the earliest change in the day.
EXPENSE_CHECK_ADDRESSVARCHAR230Determines whether check is sent to the Home or Office address. Based on ?HOME_OFFICE? lookup.
INTERNAL_BUILDINGVARCHAR245Building information associated with Work location.
INTERNAL_FLOORVARCHAR245Floor information.
INTERNAL_LOCATIONVARCHAR280Additional location details.
INTERNAL_MAILSTOPVARCHAR245Internal mail location.
INTERNAL_OFFICE_NUMBERVARCHAR245Office Number.
LEGAL_ENTITY_IDNUMBER18Represents Legal Entity. Might be null for Applicants.
LEGISLATION_CODEVARCHAR2150Legislation code derived from the Legal Entity. Might be null for Applicants.
LINKAGE_TYPEVARCHAR230Determines the type of processing and rules associated with the linking of two assignments.
PARENT_ASSIGNMENT_IDNUMBER18Allows two assignments to be linked. Used when creating temporary assignments. Also, potentially required when converting the Applicant onto a Worker (i.e. this stores the applicant assignment ID for the worker?s assignment).
PERSON_TYPE_IDNUMBER18Defines the worker class. Examples: Assignee, Consultant, Expatriate, Agency/Temp, Intern, Apprentice, Contractor, Trainee. This defaults from the person/org relationship. It is defined at either level (Assignment or Employment/Placement Terms).
PRIMARY_WORK_TERMS_FLAGVARCHAR230YesAccepts value of ?Y? or ?N? based on ?YES_NO? lookup type. If set to ?Yes?, then the current row represents a Assignment attached to the primary set of Employment/Placement.
PRIMARY_ASSIGNMENT_FLAGVARCHAR230YesAccepts value of ?Y? or ?N? based on ?YES_NO? lookup type. If set to ?Yes?, then the current row represents the primary deployment.
PRIMARY_WORK_RELATION_FLAGVARCHAR230YesAccepts value of ?Y? or ?N? based on ?YES_NO? lookup type. If set to ?Yes?, then the current row represents an Assignment or Employment/Placement attached to the primary Work Relationship.
PROJECTED_START_DATEDATETentative start date (applicants).
REASON_CODEVARCHAR230Specifies the reason for the action performed on the record.
SYSTEM_PERSON_TYPEVARCHAR230Derived from the person type id. It is included in this table to aid in performance.
BUSINESS_UNIT_IDNUMBER18Determinant for ?Set Enabled? tables and those using BU as a partitioning key.
BILLING_TITLEVARCHAR230Billing Title for assignment.
STEP_ENTRY_DATEDATEobsolete
TAX_ADDRESS_IDNUMBER18Foreign key to PER_ADDRESSES. This represents the address that is used for taxation purposes. This can be different from a ?mailing address?.
ASS_ATTRIBUTE31VARCHAR2150Descriptive Flexfield: segment of the user descriptive flexfield.Assignment Attributes (PER_ASG_DF)
ASS_ATTRIBUTE32VARCHAR2150Descriptive Flexfield: segment of the user descriptive flexfield.Assignment Attributes (PER_ASG_DF)
ASS_ATTRIBUTE33VARCHAR2150Descriptive Flexfield: segment of the user descriptive flexfield.Assignment Attributes (PER_ASG_DF)
ASS_ATTRIBUTE34VARCHAR2150Descriptive Flexfield: segment of the user descriptive flexfield.Assignment Attributes (PER_ASG_DF)
ASS_ATTRIBUTE35VARCHAR2150Descriptive Flexfield: segment of the user descriptive flexfield.Assignment Attributes (PER_ASG_DF)
ASS_ATTRIBUTE36VARCHAR2150Descriptive Flexfield: segment of the user descriptive flexfield.Assignment Attributes (PER_ASG_DF)
ASS_ATTRIBUTE37VARCHAR2150Descriptive Flexfield: segment of the user descriptive flexfield.Assignment Attributes (PER_ASG_DF)
ASS_ATTRIBUTE38VARCHAR2150Descriptive Flexfield: segment of the user descriptive flexfield.Assignment Attributes (PER_ASG_DF)
ASS_ATTRIBUTE39VARCHAR2150Descriptive Flexfield: segment of the user descriptive flexfield.Assignment Attributes (PER_ASG_DF)
ASS_ATTRIBUTE40VARCHAR2150Descriptive Flexfield: segment of the user descriptive flexfield.Assignment Attributes (PER_ASG_DF)
ASS_ATTRIBUTE41VARCHAR2150Descriptive Flexfield: segment of the user descriptive flexfield.Assignment Attributes (PER_ASG_DF)
ASS_ATTRIBUTE42VARCHAR2150Descriptive Flexfield: segment of the user descriptive flexfield.Assignment Attributes (PER_ASG_DF)
ASS_ATTRIBUTE43VARCHAR2150Descriptive Flexfield: segment of the user descriptive flexfield.Assignment Attributes (PER_ASG_DF)
ASS_ATTRIBUTE44VARCHAR2150Descriptive Flexfield: segment of the user descriptive flexfield.Assignment Attributes (PER_ASG_DF)
ASS_ATTRIBUTE45VARCHAR2150Descriptive Flexfield: segment of the user descriptive flexfield.Assignment Attributes (PER_ASG_DF)
ASS_ATTRIBUTE46VARCHAR2150Descriptive Flexfield: segment of the user descriptive flexfield.Assignment Attributes (PER_ASG_DF)
ASS_ATTRIBUTE47VARCHAR2150Descriptive Flexfield: segment of the user descriptive flexfield.Assignment Attributes (PER_ASG_DF)
ASS_ATTRIBUTE48VARCHAR2150Descriptive Flexfield: segment of the user descriptive flexfield.Assignment Attributes (PER_ASG_DF)
ASS_ATTRIBUTE49VARCHAR2150Descriptive Flexfield: segment of the user descriptive flexfield.Assignment Attributes (PER_ASG_DF)
ASS_ATTRIBUTE50VARCHAR2150Descriptive Flexfield: segment of the user descriptive flexfield.Assignment Attributes (PER_ASG_DF)
RECORD_CREATORVARCHAR230Record created By Module
ACTION_OCCURRENCE_IDNUMBER18Foreign Key to PER_ACTION_OCCURRENCES.
PROPOSED_WORKER_TYPEVARCHAR230Determines whether applicant will be hired/placed as an Employee or Contingent Worker. This represents a SYSTEM PERSON TYPE: EMP or CWK. This is also applicable for Pending Hires (workers).
RETIREMENT_AGENUMBER18Represents the age, worker is retiring at.
RETIREMENT_DATEDATERepresents the planned retirement date.
POSITION_OVERRIDE_FLAGVARCHAR230YesOverride Position related data. Accepts values of ?Y? and ?N?.
EFFECTIVE_LATEST_CHANGEVARCHAR230YesDate Effective Entity: ‘Y’ indicates that this row represents the latest change in the day.
ALLOW_ASG_OVERRIDE_FLAGVARCHAR230YesOverride Work Term related data. Accepts values of ?Y? and ?N?. This is set for the Work Term. Default is set to ?N? for rows representing Assignments and it does not change. If row represents a Work Term, then this is user-enterable.
ASS_ATTRIBUTE_NUMBER1NUMBERDescriptive flex field numeric columnAssignment Attributes (PER_ASG_DF)
ASS_ATTRIBUTE_NUMBER2NUMBERDescriptive flex field numeric columnAssignment Attributes (PER_ASG_DF)
ASS_ATTRIBUTE_NUMBER3NUMBERDescriptive flex field numeric columnAssignment Attributes (PER_ASG_DF)
ASS_ATTRIBUTE_NUMBER4NUMBERDescriptive flex field numeric columnAssignment Attributes (PER_ASG_DF)
ASS_ATTRIBUTE_NUMBER5NUMBERDescriptive flex field numeric columnAssignment Attributes (PER_ASG_DF)
ASS_ATTRIBUTE_NUMBER6NUMBERDescriptive flex field numeric columnAssignment Attributes (PER_ASG_DF)
ASS_ATTRIBUTE_NUMBER7NUMBERDescriptive flex field numeric columnAssignment Attributes (PER_ASG_DF)
ASS_ATTRIBUTE_NUMBER8NUMBERDescriptive flex field numeric columnAssignment Attributes (PER_ASG_DF)
ASS_ATTRIBUTE_NUMBER9NUMBERDescriptive flex field numeric columnAssignment Attributes (PER_ASG_DF)
ASS_ATTRIBUTE_NUMBER10NUMBERDescriptive flex field numeric columnAssignment Attributes (PER_ASG_DF)
ASS_ATTRIBUTE_NUMBER11NUMBERDescriptive flex field numeric columnAssignment Attributes (PER_ASG_DF)
ASS_ATTRIBUTE_NUMBER12NUMBERDescriptive flex field numeric columnAssignment Attributes (PER_ASG_DF)
ASS_ATTRIBUTE_NUMBER13NUMBERDescriptive flex field numeric columnAssignment Attributes (PER_ASG_DF)
ASS_ATTRIBUTE_NUMBER14NUMBERDescriptive flex field numeric columnAssignment Attributes (PER_ASG_DF)
ASS_ATTRIBUTE_NUMBER15NUMBERDescriptive flex field numeric columnAssignment Attributes (PER_ASG_DF)
ASS_ATTRIBUTE_NUMBER16NUMBERDescriptive flex field numeric columnAssignment Attributes (PER_ASG_DF)
ASS_ATTRIBUTE_NUMBER17NUMBERDescriptive flex field numeric columnAssignment Attributes (PER_ASG_DF)
ASS_ATTRIBUTE_NUMBER18NUMBERDescriptive flex field numeric columnAssignment Attributes (PER_ASG_DF)
ASS_ATTRIBUTE_NUMBER19NUMBERDescriptive flex field numeric columnAssignment Attributes (PER_ASG_DF)
ASS_ATTRIBUTE_NUMBER20NUMBERDescriptive flex field numeric columnAssignment Attributes (PER_ASG_DF)
ASS_ATTRIBUTE_DATE1DATEDescriptive flex field date columnAssignment Attributes (PER_ASG_DF)
ASS_ATTRIBUTE_DATE2DATEDescriptive flex field date columnAssignment Attributes (PER_ASG_DF)
ASS_ATTRIBUTE_DATE3DATEDescriptive flex field date columnAssignment Attributes (PER_ASG_DF)
ASS_ATTRIBUTE_DATE4DATEDescriptive flex field date columnAssignment Attributes (PER_ASG_DF)
ASS_ATTRIBUTE_DATE5DATEDescriptive flex field date columnAssignment Attributes (PER_ASG_DF)
ASS_ATTRIBUTE_DATE6DATEDescriptive flex field date columnAssignment Attributes (PER_ASG_DF)
ASS_ATTRIBUTE_DATE7DATEDescriptive flex field date columnAssignment Attributes (PER_ASG_DF)
ASS_ATTRIBUTE_DATE8DATEDescriptive flex field date columnAssignment Attributes (PER_ASG_DF)
ASS_ATTRIBUTE_DATE9DATEDescriptive flex field date columnAssignment Attributes (PER_ASG_DF)
ASS_ATTRIBUTE_DATE10DATEDescriptive flex field date columnAssignment Attributes (PER_ASG_DF)
ASS_ATTRIBUTE_DATE11DATEDescriptive flex field date columnAssignment Attributes (PER_ASG_DF)
ASS_ATTRIBUTE_DATE12DATEDescriptive flex field date columnAssignment Attributes (PER_ASG_DF)
ASS_ATTRIBUTE_DATE13DATEDescriptive flex field date columnAssignment Attributes (PER_ASG_DF)
ASS_ATTRIBUTE_DATE14DATEDescriptive flex field date columnAssignment Attributes (PER_ASG_DF)
ASS_ATTRIBUTE_DATE15DATEDescriptive flex field date columnAssignment Attributes (PER_ASG_DF)
ASG_INFORMATION_CATEGORYVARCHAR230Developer Descriptive flexfield structure defining columnLegislative Assignment Attributes (PER_ASG_LEG_DDF)
ASG_INFORMATION1VARCHAR2150Descriptive flex field column. Store Legislation specific informationLegislative Assignment Attributes (PER_ASG_LEG_DDF)
ASG_INFORMATION2VARCHAR2150Descriptive flex field column. Store Legislation specific informationLegislative Assignment Attributes (PER_ASG_LEG_DDF)
ASG_INFORMATION3VARCHAR2150Descriptive flex field column. Store Legislation specific informationLegislative Assignment Attributes (PER_ASG_LEG_DDF)
ASG_INFORMATION4VARCHAR2150Descriptive flex field column. Store Legislation specific informationLegislative Assignment Attributes (PER_ASG_LEG_DDF)
ASG_INFORMATION5VARCHAR2150Descriptive flex field column. Store Legislation specific informationLegislative Assignment Attributes (PER_ASG_LEG_DDF)
ASG_INFORMATION6VARCHAR2150Descriptive flex field column. Store Legislation specific informationLegislative Assignment Attributes (PER_ASG_LEG_DDF)
ASG_INFORMATION7VARCHAR2150Descriptive flex field column. Store Legislation specific informationLegislative Assignment Attributes (PER_ASG_LEG_DDF)
ASG_INFORMATION8VARCHAR2150Descriptive flex field column. Store Legislation specific informationLegislative Assignment Attributes (PER_ASG_LEG_DDF)
ASG_INFORMATION9VARCHAR2150Descriptive flex field column. Store Legislation specific informationLegislative Assignment Attributes (PER_ASG_LEG_DDF)
ASG_INFORMATION10VARCHAR2150Descriptive flex field column. Store Legislation specific informationLegislative Assignment Attributes (PER_ASG_LEG_DDF)
ASG_INFORMATION11VARCHAR2150Descriptive flex field column. Store Legislation specific informationLegislative Assignment Attributes (PER_ASG_LEG_DDF)
ASG_INFORMATION12VARCHAR2150Descriptive flex field column. Store Legislation specific informationLegislative Assignment Attributes (PER_ASG_LEG_DDF)
ASG_INFORMATION13VARCHAR2150Descriptive flex field column. Store Legislation specific informationLegislative Assignment Attributes (PER_ASG_LEG_DDF)
ASG_INFORMATION14VARCHAR2150Descriptive flex field column. Store Legislation specific informationLegislative Assignment Attributes (PER_ASG_LEG_DDF)
ASG_INFORMATION15VARCHAR2150Descriptive flex field column. Store Legislation specific informationLegislative Assignment Attributes (PER_ASG_LEG_DDF)
ASG_INFORMATION16VARCHAR2150Descriptive flex field column. Store Legislation specific informationLegislative Assignment Attributes (PER_ASG_LEG_DDF)
ASG_INFORMATION17VARCHAR2150Descriptive flex field column. Store Legislation specific informationLegislative Assignment Attributes (PER_ASG_LEG_DDF)
ASG_INFORMATION18VARCHAR2150Descriptive flex field column. Store Legislation specific informationLegislative Assignment Attributes (PER_ASG_LEG_DDF)
ASG_INFORMATION19VARCHAR2150Descriptive flex field column. Store Legislation specific informationLegislative Assignment Attributes (PER_ASG_LEG_DDF)
ASG_INFORMATION20VARCHAR2150Descriptive flex field column. Store Legislation specific informationLegislative Assignment Attributes (PER_ASG_LEG_DDF)
ASG_INFORMATION21VARCHAR2150Descriptive flex field column. Store Legislation specific informationLegislative Assignment Attributes (PER_ASG_LEG_DDF)
ASG_INFORMATION22VARCHAR2150Descriptive flex field column. Store Legislation specific informationLegislative Assignment Attributes (PER_ASG_LEG_DDF)
ASG_INFORMATION23VARCHAR2150Descriptive flex field column. Store Legislation specific informationLegislative Assignment Attributes (PER_ASG_LEG_DDF)
ASG_INFORMATION24VARCHAR2150Descriptive flex field column. Store Legislation specific informationLegislative Assignment Attributes (PER_ASG_LEG_DDF)
ASG_INFORMATION25VARCHAR2150Descriptive flex field column. Store Legislation specific informationLegislative Assignment Attributes (PER_ASG_LEG_DDF)
ASG_INFORMATION26VARCHAR2150Descriptive flex field column. Store Legislation specific informationLegislative Assignment Attributes (PER_ASG_LEG_DDF)
ASG_INFORMATION27VARCHAR2150Descriptive flex field column. Store Legislation specific informationLegislative Assignment Attributes (PER_ASG_LEG_DDF)
ASG_INFORMATION28VARCHAR2150Descriptive flex field column. Store Legislation specific informationLegislative Assignment Attributes (PER_ASG_LEG_DDF)
ASG_INFORMATION29VARCHAR2150Descriptive flex field column. Store Legislation specific informationLegislative Assignment Attributes (PER_ASG_LEG_DDF)
ASG_INFORMATION30VARCHAR2150Descriptive flex field column. Store Legislation specific informationLegislative Assignment Attributes (PER_ASG_LEG_DDF)
ASG_INFORMATION31VARCHAR2150Descriptive flex field column. Store Legislation specific informationLegislative Assignment Attributes (PER_ASG_LEG_DDF)
ASG_INFORMATION32VARCHAR2150Descriptive flex field column. Store Legislation specific informationLegislative Assignment Attributes (PER_ASG_LEG_DDF)
ASG_INFORMATION33VARCHAR2150Descriptive flex field column. Store Legislation specific informationLegislative Assignment Attributes (PER_ASG_LEG_DDF)
ASG_INFORMATION34VARCHAR2150Descriptive flex field column. Store Legislation specific informationLegislative Assignment Attributes (PER_ASG_LEG_DDF)
ASG_INFORMATION35VARCHAR2150Descriptive flex field column. Store Legislation specific informationLegislative Assignment Attributes (PER_ASG_LEG_DDF)
ASG_INFORMATION36VARCHAR2150Descriptive flex field column. Store Legislation specific informationLegislative Assignment Attributes (PER_ASG_LEG_DDF)
ASG_INFORMATION37VARCHAR2150Descriptive flex field column. Store Legislation specific informationLegislative Assignment Attributes (PER_ASG_LEG_DDF)
ASG_INFORMATION38VARCHAR2150Descriptive flex field column. Store Legislation specific informationLegislative Assignment Attributes (PER_ASG_LEG_DDF)
ASG_INFORMATION39VARCHAR2150Descriptive flex field column. Store Legislation specific informationLegislative Assignment Attributes (PER_ASG_LEG_DDF)
ASG_INFORMATION40VARCHAR2150Descriptive flex field column. Store Legislation specific informationLegislative Assignment Attributes (PER_ASG_LEG_DDF)
ASG_INFORMATION41VARCHAR2150Descriptive flex field column. Store Legislation specific informationLegislative Assignment Attributes (PER_ASG_LEG_DDF)
ASG_INFORMATION42VARCHAR2150Descriptive flex field column. Store Legislation specific informationLegislative Assignment Attributes (PER_ASG_LEG_DDF)
ASG_INFORMATION43VARCHAR2150Descriptive flex field column. Store Legislation specific informationLegislative Assignment Attributes (PER_ASG_LEG_DDF)
ASG_INFORMATION44VARCHAR2150Descriptive flex field column. Store Legislation specific informationLegislative Assignment Attributes (PER_ASG_LEG_DDF)
ASG_INFORMATION45VARCHAR2150Descriptive flex field column. Store Legislation specific informationLegislative Assignment Attributes (PER_ASG_LEG_DDF)
ASG_INFORMATION46VARCHAR2150Descriptive flex field column. Store Legislation specific informationLegislative Assignment Attributes (PER_ASG_LEG_DDF)
ASG_INFORMATION47VARCHAR2150Descriptive flex field column. Store Legislation specific informationLegislative Assignment Attributes (PER_ASG_LEG_DDF)
ASG_INFORMATION48VARCHAR2150Descriptive flex field column. Store Legislation specific informationLegislative Assignment Attributes (PER_ASG_LEG_DDF)
ASG_INFORMATION49VARCHAR2150Descriptive flex field column. Store Legislation specific informationLegislative Assignment Attributes (PER_ASG_LEG_DDF)
ASG_INFORMATION50VARCHAR2150Descriptive flex field column. Store Legislation specific informationLegislative Assignment Attributes (PER_ASG_LEG_DDF)
ASG_INFORMATION_NUMBER1NUMBERDescriptive flex field numeric column.Legislative Assignment Attributes (PER_ASG_LEG_DDF)
ASG_INFORMATION_NUMBER2NUMBERDescriptive flex field numeric column.Legislative Assignment Attributes (PER_ASG_LEG_DDF)
ASG_INFORMATION_NUMBER3NUMBERDescriptive flex field numeric column.Legislative Assignment Attributes (PER_ASG_LEG_DDF)
ASG_INFORMATION_NUMBER4NUMBERDescriptive flex field numeric column.Legislative Assignment Attributes (PER_ASG_LEG_DDF)
ASG_INFORMATION_NUMBER5NUMBERDescriptive flex field numeric column.Legislative Assignment Attributes (PER_ASG_LEG_DDF)
ASG_INFORMATION_NUMBER6NUMBERDescriptive flex field numeric column.Legislative Assignment Attributes (PER_ASG_LEG_DDF)
ASG_INFORMATION_NUMBER7NUMBERDescriptive flex field numeric column.Legislative Assignment Attributes (PER_ASG_LEG_DDF)
ASG_INFORMATION_NUMBER8NUMBERDescriptive flex field numeric column.Legislative Assignment Attributes (PER_ASG_LEG_DDF)
ASG_INFORMATION_NUMBER9NUMBERDescriptive flex field numeric column.Legislative Assignment Attributes (PER_ASG_LEG_DDF)
ASG_INFORMATION_NUMBER10NUMBERDescriptive flex field numeric column.Legislative Assignment Attributes (PER_ASG_LEG_DDF)
ASG_INFORMATION_NUMBER11NUMBERDescriptive flex field numeric column.Legislative Assignment Attributes (PER_ASG_LEG_DDF)
ASG_INFORMATION_NUMBER12NUMBERDescriptive flex field numeric column.Legislative Assignment Attributes (PER_ASG_LEG_DDF)
ASG_INFORMATION_NUMBER13NUMBERDescriptive flex field numeric column.Legislative Assignment Attributes (PER_ASG_LEG_DDF)
ASG_INFORMATION_NUMBER14NUMBERDescriptive flex field numeric column.Legislative Assignment Attributes (PER_ASG_LEG_DDF)
ASG_INFORMATION_NUMBER15NUMBERDescriptive flex field numeric column.Legislative Assignment Attributes (PER_ASG_LEG_DDF)
ASG_INFORMATION_NUMBER16NUMBERDescriptive flex field numeric column.Legislative Assignment Attributes (PER_ASG_LEG_DDF)
ASG_INFORMATION_NUMBER17NUMBERDescriptive flex field numeric column.Legislative Assignment Attributes (PER_ASG_LEG_DDF)
ASG_INFORMATION_NUMBER18NUMBERDescriptive flex field numeric column.Legislative Assignment Attributes (PER_ASG_LEG_DDF)
ASG_INFORMATION_NUMBER19NUMBERDescriptive flex field numeric column.Legislative Assignment Attributes (PER_ASG_LEG_DDF)
ASG_INFORMATION_NUMBER20NUMBERDescriptive flex field numeric column.Legislative Assignment Attributes (PER_ASG_LEG_DDF)
ASG_INFORMATION_DATE1DATEDescriptive flex field date column.Legislative Assignment Attributes (PER_ASG_LEG_DDF)
ASG_INFORMATION_DATE2DATEDescriptive flex field date column.Legislative Assignment Attributes (PER_ASG_LEG_DDF)
ASG_INFORMATION_DATE3DATEDescriptive flex field date column.Legislative Assignment Attributes (PER_ASG_LEG_DDF)
ASG_INFORMATION_DATE4DATEDescriptive flex field date column.Legislative Assignment Attributes (PER_ASG_LEG_DDF)
ASG_INFORMATION_DATE5DATEDescriptive flex field date column.Legislative Assignment Attributes (PER_ASG_LEG_DDF)
ASG_INFORMATION_DATE6DATEDescriptive flex field date column.Legislative Assignment Attributes (PER_ASG_LEG_DDF)
ASG_INFORMATION_DATE7DATEDescriptive flex field date column.Legislative Assignment Attributes (PER_ASG_LEG_DDF)
ASG_INFORMATION_DATE8DATEDescriptive flex field date column.Legislative Assignment Attributes (PER_ASG_LEG_DDF)
ASG_INFORMATION_DATE9DATEDescriptive flex field date column.Legislative Assignment Attributes (PER_ASG_LEG_DDF)
ASG_INFORMATION_DATE10DATEDescriptive flex field date column.Legislative Assignment Attributes (PER_ASG_LEG_DDF)
ASG_INFORMATION_DATE11DATEDescriptive flex field date column.Legislative Assignment Attributes (PER_ASG_LEG_DDF)
ASG_INFORMATION_DATE12DATEDescriptive flex field date column.Legislative Assignment Attributes (PER_ASG_LEG_DDF)
ASG_INFORMATION_DATE13DATEDescriptive flex field date column.Legislative Assignment Attributes (PER_ASG_LEG_DDF)
ASG_INFORMATION_DATE14DATEDescriptive flex field date column.Legislative Assignment Attributes (PER_ASG_LEG_DDF)
ASG_INFORMATION_DATE15DATEDescriptive flex field date column.Legislative Assignment Attributes (PER_ASG_LEG_DDF)
FREEZE_START_DATEDATEYesRepresents the Deferred data freeze start date (defaulted to End of time).
FREEZE_UNTIL_DATEDATEYesRepresents the Deferred data freeze until date (defaulted to Start of Time).
ID_FLEX_NUMNUMBER18Represents ID Flex num for PeopleGroup KFF implementation.
CATEGORY_CODEVARCHAR280YesExtensible Flexfield Category Code
FULL_PART_TIMEVARCHAR230FULL_PART_TIME
PERMANENT_TEMPORARY_FLAGVARCHAR230PERMANENT_TEMPORARY_FLAG
GSP_ELIGIBILITY_FLAGVARCHAR230Identifies if person is included in grade step progression.
UNION_IDNUMBER18Union to which a person belongs
SENIORITY_BASISVARCHAR230Seniority
OVERTIME_PERIODNUMBER18Overtime Period
SOURCE_ASSIGNMENT_IDNUMBER18Identifier (ID) of the source assignment that was used to create the assignment.
LAST_WORKING_DATEDATELast Date Worked (for terminated workers).
REVIEW_USER_ACCESSVARCHAR230This stores user’s option of review user access on Termination. Values accepted are ‘I’ for Immediately or ‘A’ for After termination
REHIRE_RECOMMENDATIONVARCHAR230Accepts Yes or No values. If Yes, person is recommended for re-hiring.
REHIRE_REASONVARCHAR230If rehire recommendation is ‘yes’, then reason from recommending person is tracked via this field.
REHIRE_AUTHORIZER_PERSON_IDNUMBER18Foreign Key to PER_PERSONS. Represents the person who recommends the worker for rehire.
TERMINATION_DATEDATEActual termination date of an assignment.
NOTIFICATION_DATEDATEDate when the termination of employment was notified.

Indexes

IndexUniquenessTablespaceColumnsStatus
PER_ALL_ASSIGNMENTS_M_FK1Non UniqueDefaultBUSINESS_GROUP_ID
PER_ALL_ASSIGNMENTS_M_FK13Non UniqueDefaultRECRUITMENT_ACTIVITY_IDObsolete
PER_ALL_ASSIGNMENTS_M_FK14Non UniqueDefaultSOURCE_ORGANIZATION_IDObsolete
PER_ALL_ASSIGNMENTS_M_FK15Non UniqueDefaultORGANIZATION_ID, EFFECTIVE_END_DATE
PER_ALL_ASSIGNMENTS_M_FK16Non UniqueDefaultPEOPLE_GROUP_ID
PER_ALL_ASSIGNMENTS_M_FK17Non UniqueDefaultSOFT_CODING_KEYFLEX_IDObsolete
PER_ALL_ASSIGNMENTS_M_FK18Non UniqueDefaultVACANCY_ID
PER_ALL_ASSIGNMENTS_M_FK20Non UniqueDefaultESTABLISHMENT_ID
PER_ALL_ASSIGNMENTS_M_FK21Non UniqueDefaultCOLLECTIVE_AGREEMENT_ID
PER_ALL_ASSIGNMENTS_M_FK22Non UniqueDefaultCONTRACT_ID
PER_ALL_ASSIGNMENTS_M_FK23Non UniqueDefaultCAGR_GRADE_DEF_IDObsolete
PER_ALL_ASSIGNMENTS_M_FK3Non UniqueDefaultGRADE_ID
PER_ALL_ASSIGNMENTS_M_FK31Non UniqueDefaultPOSTING_CONTENT_IDObsolete
PER_ALL_ASSIGNMENTS_M_FK4Non UniqueDefaultPOSITION_ID, EFFECTIVE_START_DATE, EFFECTIVE_END_DATE
PER_ALL_ASSIGNMENTS_M_FK5Non UniqueDefaultJOB_ID, EFFECTIVE_START_DATE, EFFECTIVE_END_DATE
PER_ALL_ASSIGNMENTS_M_FK52Non UniqueDefaultVENDOR_IDObsolete
PER_ALL_ASSIGNMENTS_M_FK53Non UniqueDefaultUNION_ID
PER_ALL_ASSIGNMENTS_M_FK6Non UniqueDefaultASSIGNMENT_STATUS_TYPE_ID
PER_ALL_ASSIGNMENTS_M_FK8Non UniqueDefaultLOCATION_ID, EFFECTIVE_END_DATE
PER_ALL_ASSIGNMENTS_M_FK9Non UniqueDefaultACTION_OCCURRENCE_ID
PER_ALL_ASSIGNMENTS_M_N03Non UniqueDefaultGRADE_LADDER_PGM_ID
PER_ALL_ASSIGNMENTS_M_N11Non UniqueDefaultSPECIAL_CEILING_STEP_ID
PER_ALL_ASSIGNMENTS_M_N12Non UniqueDefaultPERSON_ID, ASSIGNMENT_TYPE, PRIMARY_FLAG, EFFECTIVE_LATEST_CHANGE, EFFECTIVE_START_DATE, EFFECTIVE_END_DATE, ASSIGNMENT_STATUS_TYPE_ID
PER_ALL_ASSIGNMENTS_M_N13Non UniqueDefaultEFFECTIVE_START_DATE, EFFECTIVE_END_DATE, EFFECTIVE_LATEST_CHANGE, EFFECTIVE_SEQUENCE
PER_ALL_ASSIGNMENTS_M_N2Non UniqueDefaultRECRUITER_IDObsolete
PER_ALL_ASSIGNMENTS_M_N4Non UniqueDefaultPERIOD_OF_SERVICE_ID
PER_ALL_ASSIGNMENTS_M_N5Non UniqueDefaultWORK_TERMS_ASSIGNMENT_ID, EFFECTIVE_START_DATE, EFFECTIVE_END_DATE, EFFECTIVE_SEQUENCE
PER_ALL_ASSIGNMENTS_M_N50Non UniqueDefaultASSIGNMENT_NUMBER, EFFECTIVE_END_DATE
PER_ALL_ASSIGNMENTS_M_N51Non UniqueDefaultLAST_UPDATE_DATE
PER_ALL_ASSIGNMENTS_M_N52Non UniqueDefaultASSIGNMENT_TYPEObsolete
PER_ALL_ASSIGNMENTS_M_N53Non UniqueDefaultASSIGNMENT_ID, ASSIGNMENT_STATUS_TYPE, EFFECTIVE_LATEST_CHANGE, EFFECTIVE_START_DATE, EFFECTIVE_END_DATE, FREEZE_UNTIL_DATE, FREEZE_START_DATE
PER_ALL_ASSIGNMENTS_M_N54Non UniqueDefaultUPPER(“ASSIGNMENT_NUMBER”), EFFECTIVE_START_DATE, EFFECTIVE_END_DATE
PER_ALL_ASSIGNMENTS_M_N55Non UniqueDefaultSOURCE_ASSIGNMENT_ID
PER_ALL_ASSIGNMENTS_M_N6Non UniqueDefaultUPPER(“ASSIGNMENT_NAME”)
PER_ALL_ASSIGNMENTS_M_N7Non UniqueDefaultLEGAL_ENTITY_ID, ASSIGNMENT_TYPE, EFFECTIVE_END_DATE, ASSIGNMENT_STATUS_TYPE_ID
PER_ALL_ASSIGNMENTS_M_N9Non UniqueDefaultPERSON_REFERRED_BY_IDObsolete
PER_ALL_ASSIGNMENTS_M_PKUniqueDefaultASSIGNMENT_ID, EFFECTIVE_START_DATE, EFFECTIVE_END_DATE, EFFECTIVE_LATEST_CHANGE, EFFECTIVE_SEQUENCE

See also 2 Key Difference between PER_ALL_ASSIGNMENTS_M and PER_ALL_ASSIGNMENTS_F in HCM Cloud

wpsbutton
We will be happy to hear your thoughts

Leave a reply

Ads Blocker Image Powered by Code Help Pro

Ads Blocker Detected!!!

We have detected that you are using extensions to block ads. Please support us by disabling these ads blocker.

Cloud Technologies Blog
Logo
Compare items
  • Total (0)
Compare
0
Shopping cart