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 | 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.