Attributes for Worker Assignment
This table lists the main attributes of the Worker Assignment object and exceptions for any attribute, if any.
Attribute |
Field Name |
Description |
Supported by LOV |
---|---|---|---|
ACTION_CODE | Action Code | Specifies the action performed on the particular record. For example: HIRE, ADD PENDING WORKER, MANAGER CHANGE, and so on. | LOV_ActionCode |
ACTION_OCCURRENCE_ID | When and Why ID | Foreign Key to PER_ACTION_OCCURRENCES. | N/A |
ALLOW_ASG_OVERRIDE_FLAG | Allow Assignment Override | 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 doesn't change. If row represents a Work Term, then users can enter a value. | N/A |
ASS_ATTRIBUTE_CATEGORY | Attribute Context | Descriptive Flexfield: structure definition of the user descriptive flexfield. | N/A |
ASSIGNMENT_ID | Assignment ID | This is a system generated primary key. Surrogate key. | N/A |
ASSIGNMENT_NAME | Assignment Name | 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]. | N/A |
ASSIGNMENT_NUMBER | Assignment Number | Uniquely identifies the assignment or terms. Valid for Workers and nonworkers. Assignment Level:By default [Person Number ] - [sequence] Work Term Level:[sequence] | N/A |
ASSIGNMENT_SEQUENCE | Assignment Sequence | Used when defaulting assignment number. | N/A |
ASSIGNMENT_STATUS_TYPE | Assignment Status Type | Denormalized status of the assignment. This is derived using the Assignment Status Type ID. | N/A |
ASSIGNMENT_STATUS_TYPE_ID | Assignment Status Type ID | Denormalized status of the assignment. This is derived using the Assignment Status Type ID. | LOV_AssignmentStatusTypeId |
ASSIGNMENT_TYPE | Assignment Type | Identifies the type of record: either assignment (employee, CWK, applicant, nonworkers) or a set of Terms. | LOV_AssignmentType |
BARGAINING_UNIT_CODE | Bargaining Unit | Bargaining unit code. | LOV_BargainingUnitCode |
BUSINESS_GROUP_ID | Business Group ID | Identifier of Enterprise, used for multi-tenancy partitioning. Foreign key to HR_ORGANIZATION_UNITS. | LOV_BusinessUnitId |
BUSINESS_UNIT_ID | Business Unit ID | Determinant for 'Set Enabled' tables and those using BU as a partitioning key. | N/A |
CATEGORY_CODE | EFF Context | Extensible Flexfield Category Code | N/A |
COLLECTIVE_AGREEMENT_ID | Collective Agreement ID | Foreign key to PER_COLLECTIVE_AGREEMENTS. | LOV_CollectiveAgreementId |
CONTRACT_ID | Contract ID | Foreign key to PER_CONTRACTS_F. | N/A |
CREATED_BY | Created By | Who column: indicates the user who created the row. | N/A |
CREATION_DATE | Creation Date | Who column: indicates the date and time of the creation of the row. | N/A |
DATE_PROBATION_END | Probation End Date | End date of probation period. | N/A |
DEFAULT_CODE_COMB_ID | Foreign key to GL_CODE_COMBINATIONS. | N/A | |
EFFECTIVE_END_DATE | End Date | Date Effective Entity: indicates the date at the end of the date range within which the row is effective. | N/A |
EFFECTIVE_LATEST_CHANGE | Effective Latest Changes | Date Effective Entity: 'Y' indicates that this row represents the latest change in the day. | N/A |
EFFECTIVE_SEQUENCE | Date Effective Sequence of Changes | Date Effective Entity: indicates the order of different changes made during a day. The lowest value represents the earliest change in the day. | N/A |
EFFECTIVE_START_DATE | Start Date | Date Effective Entity: indicates the date at the beginning of the date range within which the row is effective. | N/A |
EMPLOYEE_CATEGORY | Employee Category | Based on Lookup Type = ?EMPLOYEE_CATG?: Blue collar, Civil Servant, and so on. | LOV_EmployeeCategory |
EMPLOYMENT_CATEGORY | Employment Category | User defined category. For example Full-Time Permanent or Part-Time Permanent. Lookup Type = 'EMP_CAT'. | LOV_EmploymentCategory |
ESTABLISHMENT_ID | Establishment ID | Foreign key to HR_ORGANIZATION_UNITS_F. | LOV_EstablishmentId |
EXPENSE_CHECK_ADDRESS | Expense Check Address | Determines whether check is sent to the Home or Office address. Based on 'HOME_OFFICE' lookup. | LOV_ExpenseCheckSendToAddress |
FREQUENCY | Working Hours Frequency | Frequency of normal working hours, - week, month, year. Sourced from 'Frequency' lookup type. | LOV_Frequency |
FULL_PART_TIME | Full Time or Part Time | FULL_PART_TIME | LOV_FullPartTime |
GRADE_ID | Grade ID | Foreign key to PER_GRADES_F. | LOV_Grade |
GRADE_LADDER_PGM_ID | Grade Ladder ID | FULL_PART_TIME | LOV_GradeLadderPgmId |
GSP_ELIGIBILITY_FLAG | Grade Step Progression Eligibility | Identifies if person is included in grade step progression. | N/A |
HOURLY_SALARIED_CODE | Hourly Salaried Code | Identifies if the assignment is paid by the hour or by a salary. Either maintained at the assignment level or Employment or Placement Terms but not both. | LOV_HourlySalariedCode |
INTERNAL_BUILDING | Internal Building | Building information associated with Work location. | N/A |
INTERNAL_FLOOR | Internal Floor | Floor information. | N/A |
INTERNAL_LOCATION | Internal Location | Additional location details. | N/A |
INTERNAL_MAILSTOP | Internal Mail Location | Internal mail location. | N/A |
INTERNAL_OFFICE_NUMBER | Internal Office Number | Office Number. | N/A |
LABOUR_UNION_MEMBER_FLAG | Labor Union Member | Labor union member option. Accepts values of 'Y' or 'N'. | LOV_LabourUnionMemberFlag |
LAST DAY WORKED | Last Day Worked | Last working day of the terminated worker. | N/A |
LAST_UPDATE_DATE | Last Update Date | Who column: indicates the date and time of the last update of the row. | N/A |
LAST_UPDATE_LOGIN | Last Update Login | Who column: indicates the session login associated to the user who last updated the row. | N/A |
LAST_UPDATED_BY | Last Updated By | Who column: indicates the user who last updated the row. | N/A |
LEGAL_ENTITY_ID | Legal Entity ID | Represents Legal Entity. Might be null for Applicants. | LOV_LegalEntityId |
LEGISLATION_CODE | Legislation Code | Legislation code derived from the Legal Entity. Might be null for Applicants. | N/A |
LOCATION_ID | Location ID | Foreign key to HR_LOCATIONS_ALL_F. | LOV_Location |
MANAGER_FLAG | Working As Manager | Indicates whether the employee in this assignment is designated a manager. Based on 'YES_NO' lookup type. | LOV_ManagerFlag |
NORMAL_HOURS | Working Hours | Normal working hours. | N/A |
NOTICE_PERIOD | Notice Period | Notice period for the assignment. | N/A |
NOTICE_PERIOD_UOM | Notice Period UOM | Notice period unit of measure. | LOV_NoticePeriodUom |
NOTIFICATION DATE | Notification Date | Date when the termination notification is sent. | N/A |
OBJECT_VERSION_NUMBER | Object Version Number | 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. | N/A |
ORGANIZATION_ID | Organization ID | Department Identifier. This is an optional field. | LOV_Department |
OVERTIME_PERIOD | Overtime Period | Overtime Period | LOV_OvertimePeriod |
PARENT_ASSIGNMENT_ID | Parent Assignment ID | Allows two assignments to be linked. Used when creating temporary assignments. Also, potentially required when converting the Applicant onto a Worker (this stores the applicant assignment ID for the worker?s assignment). | N/A |
PERIOD_OF_SERVICE_ID | Period of Service ID | Identifies the Employment Level. Foreign key to PER_PERIODS_OF_SERVICE. | N/A |
PERMANENT_TEMPORARY_FLAG | Regular or Temporary | PERMANENT_TEMPORARY_FLAG | LOV_PermanentTemporaryFlag |
PERSON_ID | Person ID | Identifies person holding an assignment or a set of Employment/Placement Terms. Foreign key to PER_PERSONS. | N/A |
PERSON_TYPE_ID | Person Type ID | 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). | LOV_PersonTypeId |
POSITION_ID | Position ID | Foreign key to PER_ALL_POSITIONS_F. | LOV_PositionId |
POSITION_OVERRIDE_FLAG | Position Override | Override Position related data. Accepts values of 'Y' and 'N'. | LOV_PositionOverrideFlag |
PRIMARY_ASSIGNMENT_FLAG | Primary Assignment |
Accepts value of ?Y? or 'N' based on 'YES_NO' lookup type. If set to 'Yes', then the current row represents the primary deployment. Note: You can use this attribute in validation rules, but not for object defaulting. |
LOV_PrimaryAssignmentFlag |
PRIMARY_FLAG | Primary | Primary option. 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 or Placement Terms. | LOV_PrimaryFlag |
PRIMARY_WORK_RELATION_FLAG | Primary Work Relationship | 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. | LOV_PrimaryWorkRelationFlag |
PRIMARY_WORK_TERMS_FLAG | Primary Work Terms | 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. | LOV_PrimaryTermsFlag |
PROBATION_PERIOD | Probation Period | Duration of probation period. | N/A |
PROBATION_UNIT | Probation Unit | Units of probation period duration. Based on QUALIFYING_UNITS lookup type. | LOV_ProbationUnit |
PROJECTED_ASSIGNMENT_END | Projected Assignment End Date | The date the assignment is expected to end. | N/A |
PROJECTED_START_DATE | Projected Start Date | Tentative start date (applicants). | N/A |
PROPOSED_WORKER_TYPE | Proposed Worker Type | 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). | LOV_ProposedWorkerType |
REASON_CODE | Action Reason Code | Specifies the reason for the action performed on the record. | LOV_ReasonCodeFseniority |
RECOMMENDATION REASON | Recommendation Reason | Reason for rehire recommendation. | LOV_RehireReason |
RECOMMENDED FOR REHIRE | Recommended for Rehire | Accepts Yes or No values. If Yes, person is recommended for re-hiring. | LOV_RehireRecommendation |
RECORD_CREATOR | Record Creator | Record created By Module | N/A |
REHIRE AUTHORIZER PERSON ID | Rehire Authorizer Person Id | Foreign Key to PER_PERSONS. Represents the person who recommends the worker for rehire. | N/A |
RETIREMENT_AGE | Retirement Age | Represents the age, worker is retiring at. | N/A |
RETIREMENT_DATE | Retirement Date | Represents the planned retirement date. | N/A |
REVIEW USER ACCESS | Review User Access |
This stores the user's option of revoking user access for Termination. Values accepted are I for Immediately or A for After termination. Note: This attribute is applicable for V3 Terminations. |
LOV_ReviewUserAccess |
SENIORITY_BASIS | Seniority Basis | Seniority | LOV_SeniorityBasis |
SOURCE_ASSIGNMENT_ID | Source Assignment ID | Identifier (ID) of the source assignment that was used to create the assignment. | N/A |
SPECIAL_CEILING_STEP_ID | Special Ceiling Step ID | Foreign key to PER_GRADE_STEPS_F. | LOV_SpecialCeilingStepId |
SYSTEM_PERSON_TYPE | System Person Type | Derived from the person type ID. It's included in this table to aid in performance. | N/A |
TAX_ADDRESS_ID | Tax Address ID | Foreign key to PER_ADDRESSES. This represents the address that's used for taxation purposes. This can be different from a mailing address. | LOV_TaxAddressId |
TERMINATION DATE | Termination Date | Date when the worker is terminated. | N/A |
TIME_NORMAL_FINISH | Work Day End Time | Work day normal end time. | N/A |
TIME_NORMAL_START | Work Day Start Time | Work day normal start time. | N/A |
UNION_ID | Union ID | Union to which a person belongs | LOV_UnionId |
VACANCY_ID | Vacancy ID | Foreign key to PER_ALL_VACANCIES. | N/A |
WORK_AT_HOME | Work at Home | Work at home option. | LOV_WorkAtHome |
WORK_TERMS_ASSIGNMENT_ID | Work Terms Assignment ID | Foreign key to PER_ALL_ASSIGNMENTS_M for a work term. | N/A |