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     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, 2022, Oracle and/or its affiliates.