Table stores allocated checklist details
Module:
ALLOCATED_CHECKLIST_ID
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, 2023, Oracle and/or its affiliates.