1. Tables and Views for HCM
  2. PER_ALLOCATED_CHECKLISTS_

PER_ALLOCATED_CHECKLISTS_

This table records the checklists allocated to a person. These may be copied from templates in PER_CHECKLISTS, but it is possible to override with values specific to the particular allocation.

Details

  • Schema: FUSION

  • Object owner: PER

  • Object type: TABLE

  • Tablespace: TRANSACTION_TABLES

Primary Key

Name Columns

PER_ALLOCATED_CHECKLISTS_PK_

LAST_UPDATE_DATE, LAST_UPDATED_BY, ALLOCATED_CHECKLIST_ID

Columns

Name Datatype Length Precision Not-null Comments Status
ALLOCATED_CHECKLIST_ID NUMBER 18 Yes Allocated Checklist Identifier Active
CHECKLIST_ALLOCATION_ID NUMBER 18 CHECKLIST_ALLOCATION_ID
SECURITY_ENABLED VARCHAR2 4 SECURITY_ENABLED
CHECKLIST_LEVEL_CODE VARCHAR2 30 CHECKLIST_LEVEL_CODE
ACCESS_GROUP_ID NUMBER ACCESS_GROUP_ID
INITIATOR_PERSON_ID NUMBER 18 Initiator person.
INITIATOR_USER VARCHAR2 64 Initiator user.
SELF_ASSIGNED_FLAG VARCHAR2 4 If checklist is self assigned.
OBJECT_ID NUMBER 18 OBJECT_ID
ALLOCATION_NOTIFIED_FLAG VARCHAR2 4 Indicates if a checklist assigned notification is sent.
PROCESSING_MODE VARCHAR2 30 Identifies if the checklist need to be processed with SOA/ESS.
DEF_COMPLETION_DATE DATE Date on which the checklist completion is deferred.
ASSIGNED_TEMPLATE_ID NUMBER 18 Alert template for welcome notification.
FCL_TEMPLATE_ID NUMBER 18 FCL_TEMPLATE_ID
COMBINED_TASK_TEMPLATE_ID NUMBER 18 Alert template for combined notification.
BACKGROUND_THUMBNAIL_URL VARCHAR2 4000 BACKGROUND_THUMBNAIL_URL
BACKGROUND_IMAGE_URL VARCHAR2 4000 Background Image URL
LEGISLATION_CODE VARCHAR2 30 Legislation code derived from legal entity.
CHECKLIST_INSTANCE VARCHAR2 20 CHECKLIST_INSTANCE
CHECKLIST_ID NUMBER 18 Template Checklist Identifier Active
PERSON_ID NUMBER 18 Person Identifier for whom this checklist has been allocated Active
ENTERPRISE_ID NUMBER 18 Identifier of Enterprise, used for multi-tenancy partitioning. Foreign key to HR_ORGANIZATION_UNITS.
ASSIGNMENT_ID NUMBER 18 Assignment Identifier for whom this checklist has been allocated Active
CHECKLIST_NAME VARCHAR2 240 Name of the Allocated Checklist Active
DESCRIPTION VARCHAR2 360 Description of the Allocated Checklist Active
CHECKLIST_CATEGORY VARCHAR2 60 Category of the Allocated Checklist Active
CHECKLIST_STATUS VARCHAR2 60 The status of the checklist. System Lookup: PER_CHECKLIST_TASK_STATUS Values - COM - Completed INI - Initiated DEF - Deferred
OBJECT_VERSION_NUMBER NUMBER 9 Used to implement optimistic locking. This number is incremented every time that the row is updated. The number is compared at the start and end of a transaction to detect whether another session has updated the row since it was queried. Active
LAST_UPDATE_DATE TIMESTAMP Yes Who column: indicates the date and time of the last update of the row. Active
LAST_UPDATED_BY VARCHAR2 64 Yes Who column: indicates the user who last updated the row. Active
LAST_UPDATE_LOGIN VARCHAR2 32 Who column: indicates the session login associated to the user who last updated the row. Active
CREATED_BY VARCHAR2 64 Who column: indicates the user who created the row. Active
CREATION_DATE TIMESTAMP Who column: indicates the date and time of the creation of the row. Active
SYNCH_HISTORY VARCHAR2 4000 SYNCH_HISTORY
CONTEXTUAL_ACTION VARCHAR2 240 CONTEXTUAL_ACTION
CONTEXT VARCHAR2 240 CONTEXT
ALL_ROLES_VIEW_ASSIGNED VARCHAR2 4 ALL_ROLES_VIEW_ASSIGNED
ATTRIBUTE_CATEGORY VARCHAR2 30 Descriptive Flexfield: structure definition of the user descriptive flexfield. Active
ATTRIBUTE1 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE2 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE3 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE4 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE5 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE6 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE7 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE8 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE9 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE10 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE11 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE12 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE13 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE14 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE15 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE16 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE17 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE18 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE19 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE20 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE21 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE22 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE23 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE24 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE25 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE26 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE27 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE28 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE29 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE30 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE_NUMBER1 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_NUMBER2 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_NUMBER3 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_NUMBER4 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_NUMBER5 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_NUMBER6 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_NUMBER7 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_NUMBER8 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_NUMBER9 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_NUMBER10 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_NUMBER11 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_NUMBER12 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_NUMBER13 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_NUMBER14 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_NUMBER15 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_NUMBER16 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_NUMBER17 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_NUMBER18 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_NUMBER19 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_NUMBER20 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_DATE1 DATE Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_DATE2 DATE Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_DATE3 DATE Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_DATE4 DATE Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_DATE5 DATE Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_DATE6 DATE Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_DATE7 DATE Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_DATE8 DATE Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_DATE9 DATE Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_DATE10 DATE Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_DATE11 DATE Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_DATE12 DATE Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_DATE13 DATE Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_DATE14 DATE Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_DATE15 DATE Descriptive Flexfield: segment of the user descriptive flexfield.
INFORMATION_CATEGORY VARCHAR2 30 Developer Descriptive Flexfield structure defining column Active
INFORMATION1 VARCHAR2 150 Developer-Descriptive Flexfield Segment Active
INFORMATION2 VARCHAR2 150 Developer-Descriptive Flexfield Segment Active
INFORMATION3 VARCHAR2 150 Developer-Descriptive Flexfield Segment Active
INFORMATION4 VARCHAR2 150 Developer-Descriptive Flexfield Segment Active
INFORMATION5 VARCHAR2 150 Developer-Descriptive Flexfield Segment Active
INFORMATION6 VARCHAR2 150 Developer-Descriptive Flexfield Segment Active
INFORMATION7 VARCHAR2 150 Developer-Descriptive Flexfield Segment Active
INFORMATION8 VARCHAR2 150 Developer-Descriptive Flexfield Segment Active
INFORMATION9 VARCHAR2 150 Developer-Descriptive Flexfield Segment Active
INFORMATION10 VARCHAR2 150 Developer-Descriptive Flexfield Segment Active
INFORMATION11 VARCHAR2 150 Developer-Descriptive Flexfield Segment Active
INFORMATION12 VARCHAR2 150 Developer-Descriptive Flexfield Segment Active
INFORMATION13 VARCHAR2 150 Developer-Descriptive Flexfield Segment Active
INFORMATION14 VARCHAR2 150 Developer-Descriptive Flexfield Segment Active
INFORMATION15 VARCHAR2 150 Developer-Descriptive Flexfield Segment Active
INFORMATION16 VARCHAR2 150 Developer-Descriptive Flexfield Segment Active
INFORMATION17 VARCHAR2 150 Developer-Descriptive Flexfield Segment Active
INFORMATION18 VARCHAR2 150 Developer-Descriptive Flexfield Segment Active
INFORMATION19 VARCHAR2 150 Developer-Descriptive Flexfield Segment Active
INFORMATION20 VARCHAR2 150 Developer-Descriptive Flexfield Segment Active
INFORMATION21 VARCHAR2 150 Developer Descriptive Flexfield: segment of the developer descriptive flexfield.
INFORMATION22 VARCHAR2 150 Developer Descriptive Flexfield: segment of the developer descriptive flexfield.
INFORMATION23 VARCHAR2 150 Developer Descriptive Flexfield: segment of the developer descriptive flexfield.
INFORMATION24 VARCHAR2 150 Developer Descriptive Flexfield: segment of the developer descriptive flexfield.
INFORMATION25 VARCHAR2 150 Developer Descriptive Flexfield: segment of the developer descriptive flexfield.
INFORMATION26 VARCHAR2 150 Developer Descriptive Flexfield: segment of the developer descriptive flexfield.
INFORMATION27 VARCHAR2 150 Developer Descriptive Flexfield: segment of the developer descriptive flexfield.
INFORMATION28 VARCHAR2 150 Developer Descriptive Flexfield: segment of the developer descriptive flexfield.
INFORMATION29 VARCHAR2 150 Developer Descriptive Flexfield: segment of the developer descriptive flexfield.
INFORMATION30 VARCHAR2 150 Developer Descriptive Flexfield: segment of the developer descriptive flexfield.
EVENT_DATE DATE Date when this event was raised
ALLOCATION_DATE DATE Date on which this checklist is allocated
ACTION_DATE DATE Date as of which the action on the employee record is active.
COMPLETED_ON VARCHAR2 30 System Lookup: ORA_CHK_CHECKLIST_CMP_ON Values: ORA_MAND_COMPLETE- All mandatory tasks are complete. ORA_MAND_WITH_OFFSET - All mandatory tasks complete with a grace period. ORA_ALL_COMPLETE - All tasks are complete.
COMPLETION_OFFSET_DAYS NUMBER 5 COMPLETION_OFFSET_DAYS
COMPLETION_DATE DATE Expected/Actual Completion Date
ACTION_OCCURRENCE_ID NUMBER 18 The instance of the action associated with this checklist.
PERIOD_OF_SERVICE_ID NUMBER 18 The worker employment
ALLOCATION_DETAILS VARCHAR2 4000 The checklist allocation details
CHECKLIST_ACTION_ID NUMBER 18 Foreign Key to PER_CHECKLIST_ACTIONS.CHECKLIST_ACTION_ID
CHECKLIST_ACTION_OCCURRENCE_ID NUMBER 18 Foreign Key to PER_CHECKLIST_ACT_OCCURRENCES.CHECKLIST_ACTION_OCCURRENCE_ID
CHECKLIST_SUB_CATEGORY VARCHAR2 60 CHECKLIST_SUB_CATEGORY
BACKGROUND_IMAGE BLOB BACKGROUND_IMAGE
CROPPED_BACKGROUND_IMAGE BLOB CROPPED_BACKGROUND_IMAGE
CHECKLIST_FEATURE1 VARCHAR2 4000 Stores the Checklist feature
CHECKLIST_FEATURE2 VARCHAR2 4000 Stores the Checklist feature
CHECKLIST_FEATURE3 VARCHAR2 4000 Stores the Checklist feature
CHECKLIST_FEATURE4 VARCHAR2 4000 Stores the Checklist feature
CHECKLIST_FEATURE5 VARCHAR2 4000 Stores the Checklist feature
CHECKLIST_FEATURE6 VARCHAR2 4000 Stores the Checklist feature
CHECKLIST_FEATURE7 VARCHAR2 4000 Stores the Checklist feature
CHECKLIST_FEATURE8 VARCHAR2 4000 Stores the Checklist feature
CHECKLIST_FEATURE9 VARCHAR2 4000 Stores the Checklist feature
CHECKLIST_FEATURE10 VARCHAR2 4000 Stores the Checklist feature
CHECKLIST_FEATURE_DETAILS CLOB Stores the Checklist feature details
ARCHIVE_OFFSET NUMBER 5 ARCHIVE_OFFSET
PURGE_OFFSET NUMBER 5 PURGE_OFFSET
RECURRENT_FLAG VARCHAR2 4 Yes RECURRENT_FLAG
AUDIT_ACTION_TYPE_ VARCHAR2 10 Action Type - have values like INSERT, UPDATE and DELETE.
AUDIT_CHANGE_BIT_MAP_ VARCHAR2 1000 Used to store a bit map of 1s and 0s for each column in the table.
AUDIT_IMPERSONATOR_ VARCHAR2 64 Original Impersonator User.
GENERATE_ATOM_FEED VARCHAR2 30 Identifies if ATOM feed needs to be generated
ATOM_FEED_CONFIGURATION VARCHAR2 4000 ATOM_FEED_CONFIGURATION
ALLOCATION_METHOD VARCHAR2 80 ALLOCATION_METHOD
ALLOCATION_SOURCE VARCHAR2 30 ALLOCATION_SOURCE

Indexes

Index Uniqueness Tablespace Columns
PACN1_ Non Unique Default ALLOCATED_CHECKLIST_ID, LAST_UPDATE_DATE
PER_ALLOCATED_CHECKLISTS_PK_ Unique FUSION_TS_TX_IDX LAST_UPDATE_DATE, LAST_UPDATED_BY, ALLOCATED_CHECKLIST_ID
PER_ALLOCATED_CHECKLISTS_U1_ Unique Default LAST_UPDATE_DATE, LAST_UPDATED_BY, PERSON_ID, CHECKLIST_CATEGORY, CHECKLIST_NAME, CHECKLIST_INSTANCE, ALLOCATED_CHECKLIST_ID