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