# DW_TA_ASG_D

Assignment offer dimension stores the offer assignment detail along with effective dates

## Details

Module: Recruiting

## Key Columns

ASSIGNMENT_ID, EFFECTIVE_SEQUENCE, EFFECTIVE_LATEST_CHANGE, EFFECTIVE_END_DATE, EFFECTIVE_START_DATE

## Columns

Columns
Name | Datatype | Length | Precision | Not Null | Comments | Referred Table | Referred Column
--- | --- | --- | --- | --- | --- | --- | ---
ASSIGNMENT_ID | NUMBER | 38 | 0 | True | Assignment identifier |  |
EFFECTIVE_START_DATE | DATE |  |  | True | Start date of event |  |
EFFECTIVE_END_DATE | DATE |  |  | True | End date of event |  |
EFFECTIVE_SEQUENCE | NUMBER | 38 | 0 | True | Sequence to track multiple changes on same effective start date |  |
EFFECTIVE_LATEST_CHANGE | VARCHAR2 | 32 |  | True | Flag to indicate last transaction of a day |  |
SOURCE_RECORD_ID | VARCHAR2 | 256 |  |  | This column is for Oracle Internal use only. Functional key of records.Combination of Assignment Id , Effective Start Date and effective Sequence |  |
DEPARTMENT_ID | NUMBER | 38 | 0 |  | Department Identifier#5 | DW_DEPARTMENT_D | DEPARTMENT_ID
REPORTING_ESTABLISHMENT_ID | NUMBER | 38 | 0 |  | Reporting Establishment Identifier#6 | DW_REPORTING_EST_D | REPORTING_EST_ID
JOB_ID | NUMBER | 38 | 0 |  | Job Identifier #1 | DW_JOB_D | JOB_ID
LOCATION_ID | NUMBER | 38 | 0 |  | Location Identifier | DW_WORKER_LOCATION_D | LOCATION_ID
POSITION_ID | NUMBER | 38 | 0 |  | Position Identifier#2 | DW_POSITION_D | POSITION_ID
GRADE_ID | NUMBER | 38 | 0 |  | Grade Identifier#3 | DW_PAY_GRADE_D | GRADE_ID
LEGAL_EMPLOYER_ID | NUMBER | 38 | 0 |  | Legal Employer#7 | DW_LEGAL_EMPLOYER_D | LEGAL_EMPLOYER_ID
BUSINESS_UNIT_ID | NUMBER | 38 | 0 |  | Business Unit Identifier#8 | DW_BUSINESS_UNIT_D | BUSINESS_UNIT_ID
PERSON_ID | NUMBER | 38 | 0 |  | Person Identifier#4 | DW_PERSON_D | PERSON_ID
ACTION_OCCURRENCE_ID | NUMBER | 38 | 0 |  | Event Action Occurance Identifier |  |
ACTION_ID | NUMBER | 38 | 0 |  | Event Action Identifier | DW_ACTION_D | ACTION_ID
ACTION_REASON_ID | NUMBER | 38 | 0 |  | Event Action reason Identifier | DW_ACTION_REASON_D | ACTION_REASON_ID
PERSON_TYPE_ID | NUMBER | 38 | 0 |  | Person Type | DW_PERSON_TYPE_D_TL | PERSON_TYPE_ID
ASSIGNMENT_STATUS_TYPE_ID | NUMBER | 38 | 0 |  | Assignment status type identifier | DW_ASSIGNMENT_STATUS_D_TL | ASSIGNMENT_STATUS_TYPE_ID
BUSINESS_GROUP_ID | NUMBER | 38 | 0 |  | Business Group identifier |  |
SYSTEM_PERSON_TYPE | VARCHAR2 | 32 |  |  | Person Type in System |  |
PRIMARY_FLAG | VARCHAR2 | 32 |  |  | Represents overall Primary assignment |  |
PRIMARY_ASSIGNMENT_FLAG | VARCHAR2 | 32 |  |  | Primary assignment Flag |  |
MANAGER_FLAG | VARCHAR2 | 32 |  |  | Manager Flag, indicates if employee in this assignment is designated a manager. |  |
ASSIGNMENT_NUMBER | VARCHAR2 | 32 |  |  | Assignment Number |  |
ASSIGNMENT_NAME | VARCHAR2 | 128 |  |  | Assignment Name |  |
LABOUR_UNION_MEMBER_FLAG | VARCHAR2 | 32 |  |  | Labour Union flag |  |
WORKER_TYPE | VARCHAR2 | 32 |  |  | Identifies the type of record: either assignment (employee, CWK, applicant, non-workers) or a set of Terms | DW_WORKER_TYPE_D_TL | WORKER_TYPE
WORKER_CATEGORY | VARCHAR2 | 32 |  |  | Employee category example: Blue collar, Civil Servant, etc | DW_WORKER_CATEGORY_D_TL | WORKER_CATEGORY
ASSIGNMENT_CATEGORY | VARCHAR2 | 32 |  |  | User defined category. For example Full-Time Permanent or Part-Time Permanent | DW_ASSIGNMENT_CATEGORY_D_TL | ASSIGNMENT_CATEGORY
LEGISLATION_CODE | VARCHAR2 | 256 |  |  | Legislation of Assignment | DW_LEGISLATION_D_TL | LEGISLATION_CODE
HOURLY_SALARIED_CODE | VARCHAR2 | 32 |  |  | Identifies if the assignment is paid by the hour or by a salary |  |
PAY_SYSTEM_STATUS | VARCHAR2 | 32 |  |  | Payroll status indicating whether the assignment is processed in payroll runs. |  |
PER_SYSTEM_STATUS | VARCHAR2 | 32 |  |  | HR status used to determine how the assignment is processed |  |
FREQUENCY | VARCHAR2 | 32 |  |  | Frequency of normal working hours:week,month,year |  |
NORMAL_HOURS | NUMBER |  |  |  | Normal working hours |  |
DW_DATE_FROM | DATE |  |  |  | Warehouse Effective From Date for the Assignment Event. If Initial extract date is greater than EFFECTIVE_FROM_DATE then Initial extract date is used. |  |
DW_DATE_TO | DATE |  |  |  | Warehouse Effective To Date for the Assignment Event. This is equal to EFFECTIVE_END_DATE |  |
DW_INITIAL_RECORD_IND | NUMBER | 38 | 0 |  | This indicates whether the record is the first event for the assignment to be brought into the warehouse based on initial extract date set by user. |  |
FULL_PART_TIME_FLAG | VARCHAR2 | 32 |  |  | Full Part Time Flag |  |
PERMANENT_TEMPORARY_FLAG | VARCHAR2 | 32 |  |  | Permanent Temporary Flag |  |
BARGAINING_UNIT_CODE | VARCHAR2 | 32 |  |  | Bargaining Unit Code |  |
PROBATION_PERIOD | NUMBER |  |  |  | Duration of probation period |  |
PROBATION_UNIT | VARCHAR2 | 32 |  |  | Units of probation period duration |  |
WORK_TERMS_ASSIGNMENT_ID | NUMBER | 38 | 0 |  | Work Terms Assignment Identifier |  |
SOURCE_ASSIGNMENT_ID | NUMBER | 38 | 0 |  | Source Assignment Identifier |  |
PROJECTED_START_DATE | DATE |  |  |  | Projected start date |  |

## Notes

#1 DW_JOB_D may contain multiple records for a job. Join should also consider fact calendar date to get the dimension values.

#2 DW_POSITION_D may contain multiple records for a position. Join should also consider fact calendar date to get the dimension values.

#3 DW_PAY_GRADE_D may contain multiple records for a grade. Join should also consider fact calendar date to get the dimension values.

#4 DW_PERSON_LEGISLATION_D may contain multiple records for a person. The person information is also legislation specific. Join should also consider fact calendar date and legislation to get the dimension values.

#5 For getting Organization hierarchy, DEPARTMENT_ID represents DW_ORGANIZATION_CF_DH.ORGANIZATION_ID

#6 For getting Organization hierarchy, REPORTING_ESTABLISHMENT_ID represents DW_ORGANIZATION_CF_DH.ORGANIZATION_ID

#7 For getting Organization hierarchy, LEGAL_EMPLOYER_ID represents DW_ORGANIZATION_CF_DH.ORGANIZATION_ID

#8 For getting Organization hierarchy, BUSINESS_UNIT_ID represents DW_ORGANIZATION_CF_DH.ORGANIZATION_ID

Copyright © 2019, 2026, Oracle and/or its affiliates.