# DW_TA_CANDIDATE_WORKER_ASG_F

Assignment details of the candidates after conversion to employee/contingent worker

## Details

Module: Recruiting

## Key Columns

ASSIGNMENT_ID

## Columns

Columns
Name | Datatype | Length | Precision | Not Null | Comments | Referred Table | Referred Column
--- | --- | --- | --- | --- | --- | --- | ---
ASSIGNMENT_ID | NUMBER | 38 | 0 | True | primary key of the table |  |
SOURCE_RECORD_ID | VARCHAR2 | 128 |  |  | This column is for Oracle Internal use only. Unique Source Record Identifier |  |
ASSIGNMENT_NUMBER | VARCHAR2 | 32 |  |  | assignment number |  |
PERSON_ID | NUMBER | 38 | 0 |  | Person identifier |  |
OFFER_ASG_ID | NUMBER | 38 | 0 |  | Offer assignment identifier |  |
ANCHOR_DATE | DATE |  |  |  | Greated of assignment start date and IED |  |
ASSIGNMENT_TYPE | VARCHAR2 | 32 |  |  | assignment type (employee/contingent) |  |
ASSIGNMENT_STATUS_TYPE_ID | NUMBER | 38 | 0 |  | Assignment status type identifier |  |
BUSINESS_UNIT_ID | NUMBER | 38 | 0 |  | Business Unit Identifier |  |
MANAGER_ID | NUMBER | 38 | 0 |  | Manager identifier |  |
JOB_ID | NUMBER | 38 | 0 |  | Job identifier |  |
GRADE_ID | NUMBER | 38 | 0 |  | Grade identifier |  |
LEGAL_EMPLOYER_ID | NUMBER | 38 | 0 |  | Legal employer identifier |  |
PERIOD_OF_SERVICE_ID | NUMBER | 38 | 0 |  | Period of service identifier |  |
LOCATION_ID | NUMBER | 38 | 0 |  | Location identifier |  |
POSITION_ID | NUMBER | 38 | 0 |  | Position identifier |  |
CAL_MONTH_ID | NUMBER | 38 | 0 |  | Month identifier in YYYYQMM format. For example, 1979412. |  |
CAL_QUARTER_ID | NUMBER | 38 | 0 |  | Quarter identifier in YYYYQ format. For example, 19794. |  |
CAL_YEAR_ID | NUMBER | 38 | 0 |  | Year identifier in YYYY format. For example, 1979. |  |

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