# DW_JRNY_ALLOCATED_CHECKLIST_D

Table stores allocated checklist details

## Details

Module:

## Key Columns

ALLOCATED_CHECKLIST_ID

## Columns

Columns
Name | Datatype | Length | Precision | Not Null | Comments | Referred Table | Referred Column
--- | --- | --- | --- | --- | --- | --- | ---
ALLOCATED_CHECKLIST_ID | NUMBER | 38 | 0 | True | Allocated Checklist Identifier |  |
SOURCE_RECORD_ID | VARCHAR2 | 128 |  |  | This column is for Oracle Internal use only. Unique record identifier |  |
ENTERPRISE_ID | NUMBER | 38 | 0 |  | Identifier of Enterprise |  |
PERSON_ID | NUMBER | 38 | 0 |  | Person Identifier for whom this checklist has been allocated |  |
ASSIGNMENT_ID | NUMBER | 38 | 0 |  | Assignment Identifier for whom this checklist has been allocated |  |
CHECKLIST_CATEGORY | VARCHAR2 | 64 |  |  | Category of the Allocated Checklist |  |
CHECKLIST_STATUS | VARCHAR2 | 64 |  |  | The status of the checklist |  |
ALLOCATION_DATE | DATE |  |  |  | Date on which this checklist is allocated |  |
EVENT_DATE | DATE |  |  |  | Date when this event was raised |  |
ACTION_DATE | DATE |  |  |  | Date as of which the action on the employee record is active |  |
COMPLETION_CRITERIA | VARCHAR | 32 |  |  | Criteria for checklist completion |  |
COMPLETION_OFFSET_DAYS | NUMBER | 38 | 0 |  | COMPLETION_OFFSET_DAYS |  |
COMPLETION_DATE | DATE |  |  |  | Expected/Actual Completion Date |  |

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