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.
Table of Contents
Related tables to “PER_ALL_ASSIGNMENTS_M”
- “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.
- “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.
- “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.
- “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
| Name | Columns |
|---|---|
| PER_ALL_ASSIGNMENTS_M_PK | ASSIGNMENT_ID, EFFECTIVE_START_DATE, EFFECTIVE_END_DATE, EFFECTIVE_LATEST_CHANGE, EFFECTIVE_SEQUENCE |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments | Flexfield-mapping |
|---|---|---|---|---|---|---|
| ASSIGNMENT_ID | NUMBER | 18 | Yes | This is a system generated primary key. Surrogate key. | ||
| EFFECTIVE_START_DATE | DATE | Yes | Date Effective Entity: indicates the date at the beginning of the date range within which the row is effective. | |||
| EFFECTIVE_END_DATE | DATE | Yes | Date Effective Entity: indicates the date at the end of the date range within which the row is effective. | |||
| BUSINESS_GROUP_ID | NUMBER | 18 | Yes | Identifier of Enterprise, used for multi-tenancy partitioning. Foreign key to HR_ORGANIZATION_UNITS. | ||
| PERSON_ID | NUMBER | 18 | Yes | Identifies person holding an assignment or a set of Employment/Placement Terms. Foreign key to PER_PERSONS. | ||
| PERIOD_OF_SERVICE_ID | NUMBER | 18 | Identifies the Employment Level. Foreign key to PER_PERIODS_OF_SERVICE. | |||
| ASSIGNMENT_TYPE | VARCHAR2 | 30 | Yes | Identifies the type of record: either assignment (employee, CWK, applicant, non-workers) or a set of Terms. | ||
| ASSIGNMENT_NUMBER | VARCHAR2 | 50 | Uniquely identifies the assignment or terms. Valid for Workers and non-workers. Assignment Level:By default [Person Number ] – [sequence] Work Term Level:[sequence] | |||
| ASSIGNMENT_SEQUENCE | NUMBER | 18 | Yes | Used when defaulting assignment number. | ||
| ASSIGNMENT_STATUS_TYPE_ID | NUMBER | 18 | Yes | Denormalized status of the assignment. This is derived using the Assignment Status Type ID. | ||
| PRIMARY_FLAG | VARCHAR2 | 30 | Yes | Primary 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_ID | NUMBER | 18 | Department Identifier, it is optional. | |||
| JOB_ID | NUMBER | 18 | Foreign key to PER_JOBS_F. | |||
| LOCATION_ID | NUMBER | 18 | Foreign key to HR_LOCATIONS_ALL_F. | |||
| POSITION_ID | NUMBER | 18 | Foreign key to PER_ALL_POSITIONS_F. | |||
| GRADE_ID | NUMBER | 18 | Foreign key to PER_GRADES_F. | |||
| GRADE_LADDER_PGM_ID | NUMBER | 18 | Link assignment to grade ladder for Benefits. | |||
| PEOPLE_GROUP_ID | NUMBER | 18 | Foreign key to PER_PEOPLE_GROUPS. | |||
| COLLECTIVE_AGREEMENT_ID | NUMBER | 18 | Foreign key to PER_COLLECTIVE_AGREEMENTS. | |||
| BARGAINING_UNIT_CODE | VARCHAR2 | 30 | Bargaining unit code. | |||
| LABOUR_UNION_MEMBER_FLAG | VARCHAR2 | 30 | Labour union member flag. Accepts values of ?Y? or ?N?. | |||
| CAGR_GRADE_DEF_ID | NUMBER | 18 | Foreign key to PER_CAGR_GRADES_DEF. | |||
| CAGR_ID_FLEX_NUM | NUMBER | 18 | Key flex Structure Identifier for Collectively Agreed Grade. | |||
| CONTRACT_ID | NUMBER | 18 | Foreign key to PER_CONTRACTS_F. | |||
| MANAGER_FLAG | VARCHAR2 | 30 | Indicates whether the employee in this assignment is designated a manager. Based on ?YES_NO? lookup type. | |||
| DATE_PROBATION_END | DATE | End date of probation period. | ||||
| PROBATION_PERIOD | NUMBER | 22 | Duration of probation period. | |||
| PROBATION_UNIT | VARCHAR2 | 30 | Units of probation period duration. Based on QUALIFYING_UNITS lookup type. | |||
| NORMAL_HOURS | NUMBER | 22 | Normal working hours. | |||
| FREQUENCY | VARCHAR2 | 30 | Frequency of normal working hours, – week, month, year. Sourced from ?Frequency? lookup type. | |||
| WORK_AT_HOME | VARCHAR2 | 30 | Work at home flag. | |||
| TIME_NORMAL_FINISH | VARCHAR2 | 5 | Work day normal end time. | |||
| TIME_NORMAL_START | VARCHAR2 | 5 | Work day normal start time. | |||
| NOTICE_PERIOD | NUMBER | 10 | Notice period for the assignment. | |||
| NOTICE_PERIOD_UOM | VARCHAR2 | 30 | Notice period unit of measure. | |||
| DEFAULT_CODE_COMB_ID | NUMBER | 18 | Foreign key to GL_CODE_COMBINATIONS. | |||
| EMPLOYEE_CATEGORY | VARCHAR2 | 30 | Based on Lookup Type = ?EMPLOYEE_CATG?: Blue collar, Civil Servant, etc. | |||
| EMPLOYMENT_CATEGORY | VARCHAR2 | 30 | User defined category. For example Full-Time Permanent or Part-Time Permanent. Lookup Type = ?EMP_CAT?. | |||
| ESTABLISHMENT_ID | NUMBER | 18 | Foreign key to HR_ORGANIZATION_UNITS_F. | |||
| HOURLY_SALARIED_CODE | VARCHAR2 | 30 | Identifies 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_PERIOD | NUMBER | 18 | Length of time between salary reviews. Either maintained at the assignment level or ?Employment/Placement Terms? but not both. | |||
| SAL_REVIEW_PERIOD_FREQUENCY | VARCHAR2 | 30 | Used with SAL REVIEW PERIOD to define time between salary reviews. Based on ?QUALIFYING_UNITS? lookup type. | |||
| JOB_POST_SOURCE_NAME | VARCHAR2 | 240 | Job post source name. | |||
| PROJECT_TITLE | VARCHAR2 | 80 | Obsolete | |||
| PERSON_REFERRED_BY_ID | NUMBER | 18 | Identifies person who referred applicant. Foreign key to PER_PERSONS. | |||
| PO_HEADER_ID | NUMBER | 18 | Foreign key reference to po_headers_all. | |||
| PO_LINE_ID | NUMBER | 18 | Foreign key reference to po_lines_all. | |||
| RECRUITER_ID | NUMBER | 18 | Identifies recruiter. Foreign Key to PER_PERSONS. | |||
| RECRUITMENT_ACTIVITY_ID | NUMBER | 18 | Identifies activity associated with the recruitment process. Foreign key to PER_RECRUITMENT_ACTIVITIES. | |||
| VACANCY_ID | NUMBER | 18 | Foreign key to PER_ALL_VACANCIES. | |||
| APPLICANT_RANK | NUMBER | Rank assigned to an applicant based on suitability and other criteria | ||||
| POSTING_CONTENT_ID | NUMBER | 18 | The posting to which the applicant has applied. | |||
| SOURCE_ORGANIZATION_ID | NUMBER | 18 | Valid for ‘Offer’ and ‘Applicant’ Assignments only. Captured as part of the ?Application Source? details. For instance, Agency or Marketing. | |||
| SOURCE_TYPE | VARCHAR2 | 30 | Recruitment activity source for applicant assignment, for example, Advertisement. | |||
| PROJECTED_ASSIGNMENT_END | DATE | The date the assignment is expected to end. | ||||
| SET_OF_BOOKS_ID | NUMBER | 18 | This is called Ledger in Fusion. Defaulted from Business Unit. | |||
| SOFT_CODING_KEYFLEX_ID | NUMBER | 18 | Obsolete | |||
| SPECIAL_CEILING_STEP_ID | NUMBER | 18 | Foreign key to PER_GRADE_STEPS_F. | |||
| VENDOR_ASSIGNMENT_NUMBER | VARCHAR2 | 30 | Assignment number of non-payrolled worker assignment with vending organization. | |||
| VENDOR_EMPLOYEE_NUMBER | VARCHAR2 | 30 | Employee number of worker with vending organization. | |||
| VENDOR_ID | NUMBER | 18 | Foreign key reference to po_vendors. | |||
| VENDOR_SITE_ID | NUMBER | 18 | Foreign key reference to po_vendor_sites_all. | |||
| ASS_ATTRIBUTE_CATEGORY | VARCHAR2 | 30 | Descriptive Flexfield: structure definition of the user descriptive flexfield. | Assignment Attributes (PER_ASG_DF) | ||
| ASS_ATTRIBUTE1 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Assignment Attributes (PER_ASG_DF) | ||
| ASS_ATTRIBUTE2 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Assignment Attributes (PER_ASG_DF) | ||
| ASS_ATTRIBUTE3 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Assignment Attributes (PER_ASG_DF) | ||
| ASS_ATTRIBUTE4 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Assignment Attributes (PER_ASG_DF) | ||
| ASS_ATTRIBUTE5 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Assignment Attributes (PER_ASG_DF) | ||
| ASS_ATTRIBUTE6 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Assignment Attributes (PER_ASG_DF) | ||
| ASS_ATTRIBUTE7 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Assignment Attributes (PER_ASG_DF) | ||
| ASS_ATTRIBUTE8 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Assignment Attributes (PER_ASG_DF) | ||
| ASS_ATTRIBUTE9 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Assignment Attributes (PER_ASG_DF) | ||
| ASS_ATTRIBUTE10 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Assignment Attributes (PER_ASG_DF) | ||
| ASS_ATTRIBUTE11 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Assignment Attributes (PER_ASG_DF) | ||
| ASS_ATTRIBUTE12 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Assignment Attributes (PER_ASG_DF) | ||
| ASS_ATTRIBUTE13 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Assignment Attributes (PER_ASG_DF) | ||
| ASS_ATTRIBUTE14 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Assignment Attributes (PER_ASG_DF) | ||
| ASS_ATTRIBUTE15 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Assignment Attributes (PER_ASG_DF) | ||
| ASS_ATTRIBUTE16 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Assignment Attributes (PER_ASG_DF) | ||
| ASS_ATTRIBUTE17 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Assignment Attributes (PER_ASG_DF) | ||
| ASS_ATTRIBUTE18 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Assignment Attributes (PER_ASG_DF) | ||
| ASS_ATTRIBUTE19 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Assignment Attributes (PER_ASG_DF) | ||
| ASS_ATTRIBUTE20 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Assignment Attributes (PER_ASG_DF) | ||
| ASS_ATTRIBUTE21 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Assignment Attributes (PER_ASG_DF) | ||
| ASS_ATTRIBUTE22 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Assignment Attributes (PER_ASG_DF) | ||
| ASS_ATTRIBUTE23 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Assignment Attributes (PER_ASG_DF) | ||
| ASS_ATTRIBUTE24 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Assignment Attributes (PER_ASG_DF) | ||
| ASS_ATTRIBUTE25 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Assignment Attributes (PER_ASG_DF) | ||
| ASS_ATTRIBUTE26 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Assignment Attributes (PER_ASG_DF) | ||
| ASS_ATTRIBUTE27 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Assignment Attributes (PER_ASG_DF) | ||
| ASS_ATTRIBUTE28 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Assignment Attributes (PER_ASG_DF) | ||
| ASS_ATTRIBUTE29 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Assignment Attributes (PER_ASG_DF) | ||
| ASS_ATTRIBUTE30 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Assignment Attributes (PER_ASG_DF) | ||
| OBJECT_VERSION_NUMBER | NUMBER | 9 | Yes | Used 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_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who created the row. | ||
| CREATION_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the creation of the row. | |||
| LAST_UPDATE_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the last update of the row. | |||
| LAST_UPDATE_LOGIN | VARCHAR2 | 32 | Who column: indicates the session login associated to the user who last updated the row. | |||
| LAST_UPDATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who last updated the row. | ||
| WORK_TERMS_ASSIGNMENT_ID | NUMBER | 18 | Foreign key to PER_ALL_ASSIGNMENTS_M for a work term. | |||
| ACTION_CODE | VARCHAR2 | 30 | Specifies the action performed on the particular record. For example: HIRE, ADD PENDING WORKER, MANAGER CHANGE, etc. | |||
| ASSIGNMENT_NAME | VARCHAR2 | 80 | Describes 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_TYPE | VARCHAR2 | 30 | Yes | Denormalized status of the assignment. This is derived using the Assignment Status Type ID. | ||
| AUTO_END_FLAG | VARCHAR2 | 30 | Yes | Used for temporary assignments. Determines whether to end the temporary job automatically. | ||
| DUTIES_TYPE | VARCHAR2 | 30 | Duties type. Apply for temporary assignments. Derived from a lookup code. Enterprise stores types in a specific table rather than a lookup. | |||
| EFFECTIVE_SEQUENCE | NUMBER | 4 | Yes | Date Effective Entity: indicates the order of different changes made during a day. The lowest value represents the earliest change in the day. | ||
| EXPENSE_CHECK_ADDRESS | VARCHAR2 | 30 | Determines whether check is sent to the Home or Office address. Based on ?HOME_OFFICE? lookup. | |||
| INTERNAL_BUILDING | VARCHAR2 | 45 | Building information associated with Work location. | |||
| INTERNAL_FLOOR | VARCHAR2 | 45 | Floor information. | |||
| INTERNAL_LOCATION | VARCHAR2 | 80 | Additional location details. | |||
| INTERNAL_MAILSTOP | VARCHAR2 | 45 | Internal mail location. | |||
| INTERNAL_OFFICE_NUMBER | VARCHAR2 | 45 | Office Number. | |||
| LEGAL_ENTITY_ID | NUMBER | 18 | Represents Legal Entity. Might be null for Applicants. | |||
| LEGISLATION_CODE | VARCHAR2 | 150 | Legislation code derived from the Legal Entity. Might be null for Applicants. | |||
| LINKAGE_TYPE | VARCHAR2 | 30 | Determines the type of processing and rules associated with the linking of two assignments. | |||
| PARENT_ASSIGNMENT_ID | NUMBER | 18 | Allows 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_ID | NUMBER | 18 | Defines 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_FLAG | VARCHAR2 | 30 | Yes | Accepts 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_FLAG | VARCHAR2 | 30 | Yes | Accepts 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_FLAG | VARCHAR2 | 30 | Yes | Accepts 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_DATE | DATE | Tentative start date (applicants). | ||||
| REASON_CODE | VARCHAR2 | 30 | Specifies the reason for the action performed on the record. | |||
| SYSTEM_PERSON_TYPE | VARCHAR2 | 30 | Derived from the person type id. It is included in this table to aid in performance. | |||
| BUSINESS_UNIT_ID | NUMBER | 18 | Determinant for ?Set Enabled? tables and those using BU as a partitioning key. | |||
| BILLING_TITLE | VARCHAR2 | 30 | Billing Title for assignment. | |||
| STEP_ENTRY_DATE | DATE | obsolete | ||||
| TAX_ADDRESS_ID | NUMBER | 18 | Foreign key to PER_ADDRESSES. This represents the address that is used for taxation purposes. This can be different from a ?mailing address?. | |||
| ASS_ATTRIBUTE31 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Assignment Attributes (PER_ASG_DF) | ||
| ASS_ATTRIBUTE32 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Assignment Attributes (PER_ASG_DF) | ||
| ASS_ATTRIBUTE33 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Assignment Attributes (PER_ASG_DF) | ||
| ASS_ATTRIBUTE34 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Assignment Attributes (PER_ASG_DF) | ||
| ASS_ATTRIBUTE35 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Assignment Attributes (PER_ASG_DF) | ||
| ASS_ATTRIBUTE36 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Assignment Attributes (PER_ASG_DF) | ||
| ASS_ATTRIBUTE37 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Assignment Attributes (PER_ASG_DF) | ||
| ASS_ATTRIBUTE38 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Assignment Attributes (PER_ASG_DF) | ||
| ASS_ATTRIBUTE39 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Assignment Attributes (PER_ASG_DF) | ||
| ASS_ATTRIBUTE40 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Assignment Attributes (PER_ASG_DF) | ||
| ASS_ATTRIBUTE41 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Assignment Attributes (PER_ASG_DF) | ||
| ASS_ATTRIBUTE42 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Assignment Attributes (PER_ASG_DF) | ||
| ASS_ATTRIBUTE43 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Assignment Attributes (PER_ASG_DF) | ||
| ASS_ATTRIBUTE44 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Assignment Attributes (PER_ASG_DF) | ||
| ASS_ATTRIBUTE45 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Assignment Attributes (PER_ASG_DF) | ||
| ASS_ATTRIBUTE46 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Assignment Attributes (PER_ASG_DF) | ||
| ASS_ATTRIBUTE47 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Assignment Attributes (PER_ASG_DF) | ||
| ASS_ATTRIBUTE48 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Assignment Attributes (PER_ASG_DF) | ||
| ASS_ATTRIBUTE49 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Assignment Attributes (PER_ASG_DF) | ||
| ASS_ATTRIBUTE50 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Assignment Attributes (PER_ASG_DF) | ||
| RECORD_CREATOR | VARCHAR2 | 30 | Record created By Module | |||
| ACTION_OCCURRENCE_ID | NUMBER | 18 | Foreign Key to PER_ACTION_OCCURRENCES. | |||
| PROPOSED_WORKER_TYPE | VARCHAR2 | 30 | Determines 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_AGE | NUMBER | 18 | Represents the age, worker is retiring at. | |||
| RETIREMENT_DATE | DATE | Represents the planned retirement date. | ||||
| POSITION_OVERRIDE_FLAG | VARCHAR2 | 30 | Yes | Override Position related data. Accepts values of ?Y? and ?N?. | ||
| EFFECTIVE_LATEST_CHANGE | VARCHAR2 | 30 | Yes | Date Effective Entity: ‘Y’ indicates that this row represents the latest change in the day. | ||
| ALLOW_ASG_OVERRIDE_FLAG | VARCHAR2 | 30 | Yes | Override 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_NUMBER1 | NUMBER | Descriptive flex field numeric column | Assignment Attributes (PER_ASG_DF) | |||
| ASS_ATTRIBUTE_NUMBER2 | NUMBER | Descriptive flex field numeric column | Assignment Attributes (PER_ASG_DF) | |||
| ASS_ATTRIBUTE_NUMBER3 | NUMBER | Descriptive flex field numeric column | Assignment Attributes (PER_ASG_DF) | |||
| ASS_ATTRIBUTE_NUMBER4 | NUMBER | Descriptive flex field numeric column | Assignment Attributes (PER_ASG_DF) | |||
| ASS_ATTRIBUTE_NUMBER5 | NUMBER | Descriptive flex field numeric column | Assignment Attributes (PER_ASG_DF) | |||
| ASS_ATTRIBUTE_NUMBER6 | NUMBER | Descriptive flex field numeric column | Assignment Attributes (PER_ASG_DF) | |||
| ASS_ATTRIBUTE_NUMBER7 | NUMBER | Descriptive flex field numeric column | Assignment Attributes (PER_ASG_DF) | |||
| ASS_ATTRIBUTE_NUMBER8 | NUMBER | Descriptive flex field numeric column | Assignment Attributes (PER_ASG_DF) | |||
| ASS_ATTRIBUTE_NUMBER9 | NUMBER | Descriptive flex field numeric column | Assignment Attributes (PER_ASG_DF) | |||
| ASS_ATTRIBUTE_NUMBER10 | NUMBER | Descriptive flex field numeric column | Assignment Attributes (PER_ASG_DF) | |||
| ASS_ATTRIBUTE_NUMBER11 | NUMBER | Descriptive flex field numeric column | Assignment Attributes (PER_ASG_DF) | |||
| ASS_ATTRIBUTE_NUMBER12 | NUMBER | Descriptive flex field numeric column | Assignment Attributes (PER_ASG_DF) | |||
| ASS_ATTRIBUTE_NUMBER13 | NUMBER | Descriptive flex field numeric column | Assignment Attributes (PER_ASG_DF) | |||
| ASS_ATTRIBUTE_NUMBER14 | NUMBER | Descriptive flex field numeric column | Assignment Attributes (PER_ASG_DF) | |||
| ASS_ATTRIBUTE_NUMBER15 | NUMBER | Descriptive flex field numeric column | Assignment Attributes (PER_ASG_DF) | |||
| ASS_ATTRIBUTE_NUMBER16 | NUMBER | Descriptive flex field numeric column | Assignment Attributes (PER_ASG_DF) | |||
| ASS_ATTRIBUTE_NUMBER17 | NUMBER | Descriptive flex field numeric column | Assignment Attributes (PER_ASG_DF) | |||
| ASS_ATTRIBUTE_NUMBER18 | NUMBER | Descriptive flex field numeric column | Assignment Attributes (PER_ASG_DF) | |||
| ASS_ATTRIBUTE_NUMBER19 | NUMBER | Descriptive flex field numeric column | Assignment Attributes (PER_ASG_DF) | |||
| ASS_ATTRIBUTE_NUMBER20 | NUMBER | Descriptive flex field numeric column | Assignment Attributes (PER_ASG_DF) | |||
| ASS_ATTRIBUTE_DATE1 | DATE | Descriptive flex field date column | Assignment Attributes (PER_ASG_DF) | |||
| ASS_ATTRIBUTE_DATE2 | DATE | Descriptive flex field date column | Assignment Attributes (PER_ASG_DF) | |||
| ASS_ATTRIBUTE_DATE3 | DATE | Descriptive flex field date column | Assignment Attributes (PER_ASG_DF) | |||
| ASS_ATTRIBUTE_DATE4 | DATE | Descriptive flex field date column | Assignment Attributes (PER_ASG_DF) | |||
| ASS_ATTRIBUTE_DATE5 | DATE | Descriptive flex field date column | Assignment Attributes (PER_ASG_DF) | |||
| ASS_ATTRIBUTE_DATE6 | DATE | Descriptive flex field date column | Assignment Attributes (PER_ASG_DF) | |||
| ASS_ATTRIBUTE_DATE7 | DATE | Descriptive flex field date column | Assignment Attributes (PER_ASG_DF) | |||
| ASS_ATTRIBUTE_DATE8 | DATE | Descriptive flex field date column | Assignment Attributes (PER_ASG_DF) | |||
| ASS_ATTRIBUTE_DATE9 | DATE | Descriptive flex field date column | Assignment Attributes (PER_ASG_DF) | |||
| ASS_ATTRIBUTE_DATE10 | DATE | Descriptive flex field date column | Assignment Attributes (PER_ASG_DF) | |||
| ASS_ATTRIBUTE_DATE11 | DATE | Descriptive flex field date column | Assignment Attributes (PER_ASG_DF) | |||
| ASS_ATTRIBUTE_DATE12 | DATE | Descriptive flex field date column | Assignment Attributes (PER_ASG_DF) | |||
| ASS_ATTRIBUTE_DATE13 | DATE | Descriptive flex field date column | Assignment Attributes (PER_ASG_DF) | |||
| ASS_ATTRIBUTE_DATE14 | DATE | Descriptive flex field date column | Assignment Attributes (PER_ASG_DF) | |||
| ASS_ATTRIBUTE_DATE15 | DATE | Descriptive flex field date column | Assignment Attributes (PER_ASG_DF) | |||
| ASG_INFORMATION_CATEGORY | VARCHAR2 | 30 | Developer Descriptive flexfield structure defining column | Legislative Assignment Attributes (PER_ASG_LEG_DDF) | ||
| ASG_INFORMATION1 | VARCHAR2 | 150 | Descriptive flex field column. Store Legislation specific information | Legislative Assignment Attributes (PER_ASG_LEG_DDF) | ||
| ASG_INFORMATION2 | VARCHAR2 | 150 | Descriptive flex field column. Store Legislation specific information | Legislative Assignment Attributes (PER_ASG_LEG_DDF) | ||
| ASG_INFORMATION3 | VARCHAR2 | 150 | Descriptive flex field column. Store Legislation specific information | Legislative Assignment Attributes (PER_ASG_LEG_DDF) | ||
| ASG_INFORMATION4 | VARCHAR2 | 150 | Descriptive flex field column. Store Legislation specific information | Legislative Assignment Attributes (PER_ASG_LEG_DDF) | ||
| ASG_INFORMATION5 | VARCHAR2 | 150 | Descriptive flex field column. Store Legislation specific information | Legislative Assignment Attributes (PER_ASG_LEG_DDF) | ||
| ASG_INFORMATION6 | VARCHAR2 | 150 | Descriptive flex field column. Store Legislation specific information | Legislative Assignment Attributes (PER_ASG_LEG_DDF) | ||
| ASG_INFORMATION7 | VARCHAR2 | 150 | Descriptive flex field column. Store Legislation specific information | Legislative Assignment Attributes (PER_ASG_LEG_DDF) | ||
| ASG_INFORMATION8 | VARCHAR2 | 150 | Descriptive flex field column. Store Legislation specific information | Legislative Assignment Attributes (PER_ASG_LEG_DDF) | ||
| ASG_INFORMATION9 | VARCHAR2 | 150 | Descriptive flex field column. Store Legislation specific information | Legislative Assignment Attributes (PER_ASG_LEG_DDF) | ||
| ASG_INFORMATION10 | VARCHAR2 | 150 | Descriptive flex field column. Store Legislation specific information | Legislative Assignment Attributes (PER_ASG_LEG_DDF) | ||
| ASG_INFORMATION11 | VARCHAR2 | 150 | Descriptive flex field column. Store Legislation specific information | Legislative Assignment Attributes (PER_ASG_LEG_DDF) | ||
| ASG_INFORMATION12 | VARCHAR2 | 150 | Descriptive flex field column. Store Legislation specific information | Legislative Assignment Attributes (PER_ASG_LEG_DDF) | ||
| ASG_INFORMATION13 | VARCHAR2 | 150 | Descriptive flex field column. Store Legislation specific information | Legislative Assignment Attributes (PER_ASG_LEG_DDF) | ||
| ASG_INFORMATION14 | VARCHAR2 | 150 | Descriptive flex field column. Store Legislation specific information | Legislative Assignment Attributes (PER_ASG_LEG_DDF) | ||
| ASG_INFORMATION15 | VARCHAR2 | 150 | Descriptive flex field column. Store Legislation specific information | Legislative Assignment Attributes (PER_ASG_LEG_DDF) | ||
| ASG_INFORMATION16 | VARCHAR2 | 150 | Descriptive flex field column. Store Legislation specific information | Legislative Assignment Attributes (PER_ASG_LEG_DDF) | ||
| ASG_INFORMATION17 | VARCHAR2 | 150 | Descriptive flex field column. Store Legislation specific information | Legislative Assignment Attributes (PER_ASG_LEG_DDF) | ||
| ASG_INFORMATION18 | VARCHAR2 | 150 | Descriptive flex field column. Store Legislation specific information | Legislative Assignment Attributes (PER_ASG_LEG_DDF) | ||
| ASG_INFORMATION19 | VARCHAR2 | 150 | Descriptive flex field column. Store Legislation specific information | Legislative Assignment Attributes (PER_ASG_LEG_DDF) | ||
| ASG_INFORMATION20 | VARCHAR2 | 150 | Descriptive flex field column. Store Legislation specific information | Legislative Assignment Attributes (PER_ASG_LEG_DDF) | ||
| ASG_INFORMATION21 | VARCHAR2 | 150 | Descriptive flex field column. Store Legislation specific information | Legislative Assignment Attributes (PER_ASG_LEG_DDF) | ||
| ASG_INFORMATION22 | VARCHAR2 | 150 | Descriptive flex field column. Store Legislation specific information | Legislative Assignment Attributes (PER_ASG_LEG_DDF) | ||
| ASG_INFORMATION23 | VARCHAR2 | 150 | Descriptive flex field column. Store Legislation specific information | Legislative Assignment Attributes (PER_ASG_LEG_DDF) | ||
| ASG_INFORMATION24 | VARCHAR2 | 150 | Descriptive flex field column. Store Legislation specific information | Legislative Assignment Attributes (PER_ASG_LEG_DDF) | ||
| ASG_INFORMATION25 | VARCHAR2 | 150 | Descriptive flex field column. Store Legislation specific information | Legislative Assignment Attributes (PER_ASG_LEG_DDF) | ||
| ASG_INFORMATION26 | VARCHAR2 | 150 | Descriptive flex field column. Store Legislation specific information | Legislative Assignment Attributes (PER_ASG_LEG_DDF) | ||
| ASG_INFORMATION27 | VARCHAR2 | 150 | Descriptive flex field column. Store Legislation specific information | Legislative Assignment Attributes (PER_ASG_LEG_DDF) | ||
| ASG_INFORMATION28 | VARCHAR2 | 150 | Descriptive flex field column. Store Legislation specific information | Legislative Assignment Attributes (PER_ASG_LEG_DDF) | ||
| ASG_INFORMATION29 | VARCHAR2 | 150 | Descriptive flex field column. Store Legislation specific information | Legislative Assignment Attributes (PER_ASG_LEG_DDF) | ||
| ASG_INFORMATION30 | VARCHAR2 | 150 | Descriptive flex field column. Store Legislation specific information | Legislative Assignment Attributes (PER_ASG_LEG_DDF) | ||
| ASG_INFORMATION31 | VARCHAR2 | 150 | Descriptive flex field column. Store Legislation specific information | Legislative Assignment Attributes (PER_ASG_LEG_DDF) | ||
| ASG_INFORMATION32 | VARCHAR2 | 150 | Descriptive flex field column. Store Legislation specific information | Legislative Assignment Attributes (PER_ASG_LEG_DDF) | ||
| ASG_INFORMATION33 | VARCHAR2 | 150 | Descriptive flex field column. Store Legislation specific information | Legislative Assignment Attributes (PER_ASG_LEG_DDF) | ||
| ASG_INFORMATION34 | VARCHAR2 | 150 | Descriptive flex field column. Store Legislation specific information | Legislative Assignment Attributes (PER_ASG_LEG_DDF) | ||
| ASG_INFORMATION35 | VARCHAR2 | 150 | Descriptive flex field column. Store Legislation specific information | Legislative Assignment Attributes (PER_ASG_LEG_DDF) | ||
| ASG_INFORMATION36 | VARCHAR2 | 150 | Descriptive flex field column. Store Legislation specific information | Legislative Assignment Attributes (PER_ASG_LEG_DDF) | ||
| ASG_INFORMATION37 | VARCHAR2 | 150 | Descriptive flex field column. Store Legislation specific information | Legislative Assignment Attributes (PER_ASG_LEG_DDF) | ||
| ASG_INFORMATION38 | VARCHAR2 | 150 | Descriptive flex field column. Store Legislation specific information | Legislative Assignment Attributes (PER_ASG_LEG_DDF) | ||
| ASG_INFORMATION39 | VARCHAR2 | 150 | Descriptive flex field column. Store Legislation specific information | Legislative Assignment Attributes (PER_ASG_LEG_DDF) | ||
| ASG_INFORMATION40 | VARCHAR2 | 150 | Descriptive flex field column. Store Legislation specific information | Legislative Assignment Attributes (PER_ASG_LEG_DDF) | ||
| ASG_INFORMATION41 | VARCHAR2 | 150 | Descriptive flex field column. Store Legislation specific information | Legislative Assignment Attributes (PER_ASG_LEG_DDF) | ||
| ASG_INFORMATION42 | VARCHAR2 | 150 | Descriptive flex field column. Store Legislation specific information | Legislative Assignment Attributes (PER_ASG_LEG_DDF) | ||
| ASG_INFORMATION43 | VARCHAR2 | 150 | Descriptive flex field column. Store Legislation specific information | Legislative Assignment Attributes (PER_ASG_LEG_DDF) | ||
| ASG_INFORMATION44 | VARCHAR2 | 150 | Descriptive flex field column. Store Legislation specific information | Legislative Assignment Attributes (PER_ASG_LEG_DDF) | ||
| ASG_INFORMATION45 | VARCHAR2 | 150 | Descriptive flex field column. Store Legislation specific information | Legislative Assignment Attributes (PER_ASG_LEG_DDF) | ||
| ASG_INFORMATION46 | VARCHAR2 | 150 | Descriptive flex field column. Store Legislation specific information | Legislative Assignment Attributes (PER_ASG_LEG_DDF) | ||
| ASG_INFORMATION47 | VARCHAR2 | 150 | Descriptive flex field column. Store Legislation specific information | Legislative Assignment Attributes (PER_ASG_LEG_DDF) | ||
| ASG_INFORMATION48 | VARCHAR2 | 150 | Descriptive flex field column. Store Legislation specific information | Legislative Assignment Attributes (PER_ASG_LEG_DDF) | ||
| ASG_INFORMATION49 | VARCHAR2 | 150 | Descriptive flex field column. Store Legislation specific information | Legislative Assignment Attributes (PER_ASG_LEG_DDF) | ||
| ASG_INFORMATION50 | VARCHAR2 | 150 | Descriptive flex field column. Store Legislation specific information | Legislative Assignment Attributes (PER_ASG_LEG_DDF) | ||
| ASG_INFORMATION_NUMBER1 | NUMBER | Descriptive flex field numeric column. | Legislative Assignment Attributes (PER_ASG_LEG_DDF) | |||
| ASG_INFORMATION_NUMBER2 | NUMBER | Descriptive flex field numeric column. | Legislative Assignment Attributes (PER_ASG_LEG_DDF) | |||
| ASG_INFORMATION_NUMBER3 | NUMBER | Descriptive flex field numeric column. | Legislative Assignment Attributes (PER_ASG_LEG_DDF) | |||
| ASG_INFORMATION_NUMBER4 | NUMBER | Descriptive flex field numeric column. | Legislative Assignment Attributes (PER_ASG_LEG_DDF) | |||
| ASG_INFORMATION_NUMBER5 | NUMBER | Descriptive flex field numeric column. | Legislative Assignment Attributes (PER_ASG_LEG_DDF) | |||
| ASG_INFORMATION_NUMBER6 | NUMBER | Descriptive flex field numeric column. | Legislative Assignment Attributes (PER_ASG_LEG_DDF) | |||
| ASG_INFORMATION_NUMBER7 | NUMBER | Descriptive flex field numeric column. | Legislative Assignment Attributes (PER_ASG_LEG_DDF) | |||
| ASG_INFORMATION_NUMBER8 | NUMBER | Descriptive flex field numeric column. | Legislative Assignment Attributes (PER_ASG_LEG_DDF) | |||
| ASG_INFORMATION_NUMBER9 | NUMBER | Descriptive flex field numeric column. | Legislative Assignment Attributes (PER_ASG_LEG_DDF) | |||
| ASG_INFORMATION_NUMBER10 | NUMBER | Descriptive flex field numeric column. | Legislative Assignment Attributes (PER_ASG_LEG_DDF) | |||
| ASG_INFORMATION_NUMBER11 | NUMBER | Descriptive flex field numeric column. | Legislative Assignment Attributes (PER_ASG_LEG_DDF) | |||
| ASG_INFORMATION_NUMBER12 | NUMBER | Descriptive flex field numeric column. | Legislative Assignment Attributes (PER_ASG_LEG_DDF) | |||
| ASG_INFORMATION_NUMBER13 | NUMBER | Descriptive flex field numeric column. | Legislative Assignment Attributes (PER_ASG_LEG_DDF) | |||
| ASG_INFORMATION_NUMBER14 | NUMBER | Descriptive flex field numeric column. | Legislative Assignment Attributes (PER_ASG_LEG_DDF) | |||
| ASG_INFORMATION_NUMBER15 | NUMBER | Descriptive flex field numeric column. | Legislative Assignment Attributes (PER_ASG_LEG_DDF) | |||
| ASG_INFORMATION_NUMBER16 | NUMBER | Descriptive flex field numeric column. | Legislative Assignment Attributes (PER_ASG_LEG_DDF) | |||
| ASG_INFORMATION_NUMBER17 | NUMBER | Descriptive flex field numeric column. | Legislative Assignment Attributes (PER_ASG_LEG_DDF) | |||
| ASG_INFORMATION_NUMBER18 | NUMBER | Descriptive flex field numeric column. | Legislative Assignment Attributes (PER_ASG_LEG_DDF) | |||
| ASG_INFORMATION_NUMBER19 | NUMBER | Descriptive flex field numeric column. | Legislative Assignment Attributes (PER_ASG_LEG_DDF) | |||
| ASG_INFORMATION_NUMBER20 | NUMBER | Descriptive flex field numeric column. | Legislative Assignment Attributes (PER_ASG_LEG_DDF) | |||
| ASG_INFORMATION_DATE1 | DATE | Descriptive flex field date column. | Legislative Assignment Attributes (PER_ASG_LEG_DDF) | |||
| ASG_INFORMATION_DATE2 | DATE | Descriptive flex field date column. | Legislative Assignment Attributes (PER_ASG_LEG_DDF) | |||
| ASG_INFORMATION_DATE3 | DATE | Descriptive flex field date column. | Legislative Assignment Attributes (PER_ASG_LEG_DDF) | |||
| ASG_INFORMATION_DATE4 | DATE | Descriptive flex field date column. | Legislative Assignment Attributes (PER_ASG_LEG_DDF) | |||
| ASG_INFORMATION_DATE5 | DATE | Descriptive flex field date column. | Legislative Assignment Attributes (PER_ASG_LEG_DDF) | |||
| ASG_INFORMATION_DATE6 | DATE | Descriptive flex field date column. | Legislative Assignment Attributes (PER_ASG_LEG_DDF) | |||
| ASG_INFORMATION_DATE7 | DATE | Descriptive flex field date column. | Legislative Assignment Attributes (PER_ASG_LEG_DDF) | |||
| ASG_INFORMATION_DATE8 | DATE | Descriptive flex field date column. | Legislative Assignment Attributes (PER_ASG_LEG_DDF) | |||
| ASG_INFORMATION_DATE9 | DATE | Descriptive flex field date column. | Legislative Assignment Attributes (PER_ASG_LEG_DDF) | |||
| ASG_INFORMATION_DATE10 | DATE | Descriptive flex field date column. | Legislative Assignment Attributes (PER_ASG_LEG_DDF) | |||
| ASG_INFORMATION_DATE11 | DATE | Descriptive flex field date column. | Legislative Assignment Attributes (PER_ASG_LEG_DDF) | |||
| ASG_INFORMATION_DATE12 | DATE | Descriptive flex field date column. | Legislative Assignment Attributes (PER_ASG_LEG_DDF) | |||
| ASG_INFORMATION_DATE13 | DATE | Descriptive flex field date column. | Legislative Assignment Attributes (PER_ASG_LEG_DDF) | |||
| ASG_INFORMATION_DATE14 | DATE | Descriptive flex field date column. | Legislative Assignment Attributes (PER_ASG_LEG_DDF) | |||
| ASG_INFORMATION_DATE15 | DATE | Descriptive flex field date column. | Legislative Assignment Attributes (PER_ASG_LEG_DDF) | |||
| FREEZE_START_DATE | DATE | Yes | Represents the Deferred data freeze start date (defaulted to End of time). | |||
| FREEZE_UNTIL_DATE | DATE | Yes | Represents the Deferred data freeze until date (defaulted to Start of Time). | |||
| ID_FLEX_NUM | NUMBER | 18 | Represents ID Flex num for PeopleGroup KFF implementation. | |||
| CATEGORY_CODE | VARCHAR2 | 80 | Yes | Extensible Flexfield Category Code | ||
| FULL_PART_TIME | VARCHAR2 | 30 | FULL_PART_TIME | |||
| PERMANENT_TEMPORARY_FLAG | VARCHAR2 | 30 | PERMANENT_TEMPORARY_FLAG | |||
| GSP_ELIGIBILITY_FLAG | VARCHAR2 | 30 | Identifies if person is included in grade step progression. | |||
| UNION_ID | NUMBER | 18 | Union to which a person belongs | |||
| SENIORITY_BASIS | VARCHAR2 | 30 | Seniority | |||
| OVERTIME_PERIOD | NUMBER | 18 | Overtime Period | |||
| SOURCE_ASSIGNMENT_ID | NUMBER | 18 | Identifier (ID) of the source assignment that was used to create the assignment. | |||
| LAST_WORKING_DATE | DATE | Last Date Worked (for terminated workers). | ||||
| REVIEW_USER_ACCESS | VARCHAR2 | 30 | This stores user’s option of review user access on Termination. Values accepted are ‘I’ for Immediately or ‘A’ for After termination | |||
| REHIRE_RECOMMENDATION | VARCHAR2 | 30 | Accepts Yes or No values. If Yes, person is recommended for re-hiring. | |||
| REHIRE_REASON | VARCHAR2 | 30 | If rehire recommendation is ‘yes’, then reason from recommending person is tracked via this field. | |||
| REHIRE_AUTHORIZER_PERSON_ID | NUMBER | 18 | Foreign Key to PER_PERSONS. Represents the person who recommends the worker for rehire. | |||
| TERMINATION_DATE | DATE | Actual termination date of an assignment. | ||||
| NOTIFICATION_DATE | DATE | Date when the termination of employment was notified. |
Indexes
| Index | Uniqueness | Tablespace | Columns | Status |
|---|---|---|---|---|
| PER_ALL_ASSIGNMENTS_M_FK1 | Non Unique | Default | BUSINESS_GROUP_ID | |
| PER_ALL_ASSIGNMENTS_M_FK13 | Non Unique | Default | RECRUITMENT_ACTIVITY_ID | Obsolete |
| PER_ALL_ASSIGNMENTS_M_FK14 | Non Unique | Default | SOURCE_ORGANIZATION_ID | Obsolete |
| PER_ALL_ASSIGNMENTS_M_FK15 | Non Unique | Default | ORGANIZATION_ID, EFFECTIVE_END_DATE | |
| PER_ALL_ASSIGNMENTS_M_FK16 | Non Unique | Default | PEOPLE_GROUP_ID | |
| PER_ALL_ASSIGNMENTS_M_FK17 | Non Unique | Default | SOFT_CODING_KEYFLEX_ID | Obsolete |
| PER_ALL_ASSIGNMENTS_M_FK18 | Non Unique | Default | VACANCY_ID | |
| PER_ALL_ASSIGNMENTS_M_FK20 | Non Unique | Default | ESTABLISHMENT_ID | |
| PER_ALL_ASSIGNMENTS_M_FK21 | Non Unique | Default | COLLECTIVE_AGREEMENT_ID | |
| PER_ALL_ASSIGNMENTS_M_FK22 | Non Unique | Default | CONTRACT_ID | |
| PER_ALL_ASSIGNMENTS_M_FK23 | Non Unique | Default | CAGR_GRADE_DEF_ID | Obsolete |
| PER_ALL_ASSIGNMENTS_M_FK3 | Non Unique | Default | GRADE_ID | |
| PER_ALL_ASSIGNMENTS_M_FK31 | Non Unique | Default | POSTING_CONTENT_ID | Obsolete |
| PER_ALL_ASSIGNMENTS_M_FK4 | Non Unique | Default | POSITION_ID, EFFECTIVE_START_DATE, EFFECTIVE_END_DATE | |
| PER_ALL_ASSIGNMENTS_M_FK5 | Non Unique | Default | JOB_ID, EFFECTIVE_START_DATE, EFFECTIVE_END_DATE | |
| PER_ALL_ASSIGNMENTS_M_FK52 | Non Unique | Default | VENDOR_ID | Obsolete |
| PER_ALL_ASSIGNMENTS_M_FK53 | Non Unique | Default | UNION_ID | |
| PER_ALL_ASSIGNMENTS_M_FK6 | Non Unique | Default | ASSIGNMENT_STATUS_TYPE_ID | |
| PER_ALL_ASSIGNMENTS_M_FK8 | Non Unique | Default | LOCATION_ID, EFFECTIVE_END_DATE | |
| PER_ALL_ASSIGNMENTS_M_FK9 | Non Unique | Default | ACTION_OCCURRENCE_ID | |
| PER_ALL_ASSIGNMENTS_M_N03 | Non Unique | Default | GRADE_LADDER_PGM_ID | |
| PER_ALL_ASSIGNMENTS_M_N11 | Non Unique | Default | SPECIAL_CEILING_STEP_ID | |
| PER_ALL_ASSIGNMENTS_M_N12 | Non Unique | Default | PERSON_ID, ASSIGNMENT_TYPE, PRIMARY_FLAG, EFFECTIVE_LATEST_CHANGE, EFFECTIVE_START_DATE, EFFECTIVE_END_DATE, ASSIGNMENT_STATUS_TYPE_ID | |
| PER_ALL_ASSIGNMENTS_M_N13 | Non Unique | Default | EFFECTIVE_START_DATE, EFFECTIVE_END_DATE, EFFECTIVE_LATEST_CHANGE, EFFECTIVE_SEQUENCE | |
| PER_ALL_ASSIGNMENTS_M_N2 | Non Unique | Default | RECRUITER_ID | Obsolete |
| PER_ALL_ASSIGNMENTS_M_N4 | Non Unique | Default | PERIOD_OF_SERVICE_ID | |
| PER_ALL_ASSIGNMENTS_M_N5 | Non Unique | Default | WORK_TERMS_ASSIGNMENT_ID, EFFECTIVE_START_DATE, EFFECTIVE_END_DATE, EFFECTIVE_SEQUENCE | |
| PER_ALL_ASSIGNMENTS_M_N50 | Non Unique | Default | ASSIGNMENT_NUMBER, EFFECTIVE_END_DATE | |
| PER_ALL_ASSIGNMENTS_M_N51 | Non Unique | Default | LAST_UPDATE_DATE | |
| PER_ALL_ASSIGNMENTS_M_N52 | Non Unique | Default | ASSIGNMENT_TYPE | Obsolete |
| PER_ALL_ASSIGNMENTS_M_N53 | Non Unique | Default | ASSIGNMENT_ID, ASSIGNMENT_STATUS_TYPE, EFFECTIVE_LATEST_CHANGE, EFFECTIVE_START_DATE, EFFECTIVE_END_DATE, FREEZE_UNTIL_DATE, FREEZE_START_DATE | |
| PER_ALL_ASSIGNMENTS_M_N54 | Non Unique | Default | UPPER(“ASSIGNMENT_NUMBER”), EFFECTIVE_START_DATE, EFFECTIVE_END_DATE | |
| PER_ALL_ASSIGNMENTS_M_N55 | Non Unique | Default | SOURCE_ASSIGNMENT_ID | |
| PER_ALL_ASSIGNMENTS_M_N6 | Non Unique | Default | UPPER(“ASSIGNMENT_NAME”) | |
| PER_ALL_ASSIGNMENTS_M_N7 | Non Unique | Default | LEGAL_ENTITY_ID, ASSIGNMENT_TYPE, EFFECTIVE_END_DATE, ASSIGNMENT_STATUS_TYPE_ID | |
| PER_ALL_ASSIGNMENTS_M_N9 | Non Unique | Default | PERSON_REFERRED_BY_ID | Obsolete |
| PER_ALL_ASSIGNMENTS_M_PK | Unique | Default | ASSIGNMENT_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
