PER_CHECKLIST_TASKS

Details

Schema: FUSION
Object owner: PER
Object type: VIEW

Columns

Name
CHECKLIST_TASK_ID CHECKLIST_TASK_CODE TASK_CATEGORY ELIGIBILITY_PROFILE_ID MANDATORY_FLAG TARGET_DURATION TARGET_DURATION_UOM RESPONSIBILITY_TYPE ACTIVE_INACTIVE_FLAG TASK_DELAY_DURATION_UOM TASK_DELAY_DURATION ACTION_TYPE ADHOC_USER_GUID TASK_ACTION_ID FLEX_CONTEXT_CODE DOCUMENT_TYPE_ID TASK_CONFIGURATION ACTIVATION_ELIGY_PRFL_ID REMINDER_RECURRENCE REMINDER_DURATION REMINDER_RELATIVE_TO GENERATE_ATOM_FEED ATOM_FEED_CONFIGURATION OWNER_RESP_TYPE OWNER_USER_GUID MEETING_OFFSET MEETING_TIME ENABLE_TASK_EXPIRY EXPIRY_AFTER_DAYS CHECKLIST_TASK_NAME DESCRIPTION ACTION_URL TASK_DETAILS USER_DISPLAY_NAME MEETING_LOCATION BUSINESS_GROUP_ID OBJECT_VERSION_NUMBER LAST_UPDATE_DATE LAST_UPDATED_BY LAST_UPDATE_LOGIN CREATED_BY CREATION_DATE MODULE_ID SGUID SEED_DATA_SOURCE LEGISLATION_CODE LEGAL_EMPLOYER_ID BUSINESS_UNIT_ID TASK_ACTION_CODE SIGN_TEMPLATE ESIGN_TYPE REPORT_PATH QUESTIONNAIRE_ID NOTE_TITLE ATTACHMENT_DOCUMENT_TYPE_ID LEARNING_ITEM_ID LEARN_CONTENT_TYPE REPORT_PARAMETERS ANALYTICS_PATH EXPIRY_RELATIVE_TO TASK_FEATURE1 TASK_FEATURE2 TASK_FEATURE3 TASK_FEATURE4 TASK_FEATURE5 TASK_FEATURE_DETAILS REMINDER_TEMPLATE_ID TASK_LEVEL_CODE TASK_LEVEL_VALUE COMPLETE_ACTION_LABEL REJECT_ACTION_LABEL SAVE_ACTION_LABEL CALENDAR_ACTION_LABEL ACTIVITY_ACTION1_LABEL ACTIVITY_ACTION2_LABEL ACTIVITY_ACTION3_LABEL ACTIVITY_ACTION4_LABEL ACTIVITY_ACTION5_LABEL VIDEO_TYPE DISPLAY_OPTIONS VIDEO_URL LEARN_ENROLLMENT_ID LEARN_COMMUNITY_ID LEARN_ENROLLMENT_TYPE EMBED_TASK_ACTION_CODE CONTENT_PROVIDER_CODE EMBED_APP_TASK_TYPE_ID CHECKLIST_CATEGORY CHECKLIST_SUB_CATEGORY ANALYTICS_SUB_TYPE

Name

CHECKLIST_TASK_ID

CHECKLIST_TASK_CODE

TASK_CATEGORY

ELIGIBILITY_PROFILE_ID

MANDATORY_FLAG

TARGET_DURATION

TARGET_DURATION_UOM

RESPONSIBILITY_TYPE

ACTIVE_INACTIVE_FLAG

TASK_DELAY_DURATION_UOM

TASK_DELAY_DURATION

ACTION_TYPE

ADHOC_USER_GUID

TASK_ACTION_ID

FLEX_CONTEXT_CODE

DOCUMENT_TYPE_ID

TASK_CONFIGURATION

ACTIVATION_ELIGY_PRFL_ID

REMINDER_RECURRENCE

REMINDER_DURATION

REMINDER_RELATIVE_TO

GENERATE_ATOM_FEED

ATOM_FEED_CONFIGURATION

OWNER_RESP_TYPE

OWNER_USER_GUID

MEETING_OFFSET

MEETING_TIME

ENABLE_TASK_EXPIRY

EXPIRY_AFTER_DAYS

CHECKLIST_TASK_NAME

DESCRIPTION

ACTION_URL

TASK_DETAILS

USER_DISPLAY_NAME

MEETING_LOCATION

BUSINESS_GROUP_ID

OBJECT_VERSION_NUMBER

LAST_UPDATE_DATE

LAST_UPDATED_BY

LAST_UPDATE_LOGIN

CREATED_BY

CREATION_DATE

MODULE_ID

SGUID

SEED_DATA_SOURCE

LEGISLATION_CODE

LEGAL_EMPLOYER_ID

BUSINESS_UNIT_ID

TASK_ACTION_CODE

SIGN_TEMPLATE

ESIGN_TYPE

REPORT_PATH

QUESTIONNAIRE_ID

NOTE_TITLE

ATTACHMENT_DOCUMENT_TYPE_ID

LEARNING_ITEM_ID

LEARN_CONTENT_TYPE

REPORT_PARAMETERS

ANALYTICS_PATH

EXPIRY_RELATIVE_TO

TASK_FEATURE1

TASK_FEATURE2

TASK_FEATURE3

TASK_FEATURE4

TASK_FEATURE5

TASK_FEATURE_DETAILS

REMINDER_TEMPLATE_ID

TASK_LEVEL_CODE

TASK_LEVEL_VALUE

COMPLETE_ACTION_LABEL

REJECT_ACTION_LABEL

SAVE_ACTION_LABEL

CALENDAR_ACTION_LABEL

ACTIVITY_ACTION1_LABEL

ACTIVITY_ACTION2_LABEL

ACTIVITY_ACTION3_LABEL

ACTIVITY_ACTION4_LABEL

ACTIVITY_ACTION5_LABEL

VIDEO_TYPE

DISPLAY_OPTIONS

VIDEO_URL

LEARN_ENROLLMENT_ID

LEARN_COMMUNITY_ID

LEARN_ENROLLMENT_TYPE

EMBED_TASK_ACTION_CODE

CONTENT_PROVIDER_CODE

EMBED_APP_TASK_TYPE_ID

CHECKLIST_CATEGORY

CHECKLIST_SUB_CATEGORY

ANALYTICS_SUB_TYPE

Query

SQL_Statement
SELECT B.CHECKLIST_TASK_ID, B.CHECKLIST_TASK_CODE, B.TASK_CATEGORY, B.ELIGIBILITY_PROFILE_ID, B.MANDATORY_FLAG, B.TARGET_DURATION, B.TARGET_DURATION_UOM, B.RESPONSIBILITY_TYPE, B.ACTIVE_INACTIVE_FLAG, B.TASK_DELAY_DURATION_UOM, B.TASK_DELAY_DURATION, B.ACTION_TYPE, B.ADHOC_USER_GUID, B.TASK_ACTION_ID, B.FLEX_CONTEXT_CODE, B.DOCUMENT_TYPE_ID, B.TASK_CONFIGURATION, B.ACTIVATION_ELIGY_PRFL_ID, B.REMINDER_RECURRENCE, B.REMINDER_DURATION, B.REMINDER_RELATIVE_TO, B.GENERATE_ATOM_FEED, B.ATOM_FEED_CONFIGURATION, B.OWNER_RESP_TYPE, B.OWNER_USER_GUID, B.MEETING_OFFSET, B.MEETING_TIME, B.ENABLE_TASK_EXPIRY, B.EXPIRY_AFTER_DAYS, T.CHECKLIST_TASK_NAME, T.DESCRIPTION, T.ACTION_URL, T.TASK_DETAILS, T.USER_DISPLAY_NAME, T.MEETING_LOCATION, B.BUSINESS_GROUP_ID, B.OBJECT_VERSION_NUMBER, B.LAST_UPDATE_DATE, B.LAST_UPDATED_BY, B.LAST_UPDATE_LOGIN, B.CREATED_BY, B.CREATION_DATE, B.MODULE_ID, B.SGUID, B.SEED_DATA_SOURCE, B.LEGISLATION_CODE, B.LEGAL_EMPLOYER_ID, B.BUSINESS_UNIT_ID, B.TASK_ACTION_CODE, B.SIGN_TEMPLATE, B.ESIGN_TYPE, B.REPORT_PATH, B.QUESTIONNAIRE_ID, T.NOTE_TITLE, B.ATTACHMENT_DOCUMENT_TYPE_ID, B.LEARNING_ITEM_ID, B.LEARN_CONTENT_TYPE, B.REPORT_PARAMETERS, B.ANALYTICS_PATH, B.EXPIRY_RELATIVE_TO, B.TASK_FEATURE1, B.TASK_FEATURE2, B.TASK_FEATURE3, B.TASK_FEATURE4, B.TASK_FEATURE5, B.TASK_FEATURE_DETAILS, B.REMINDER_TEMPLATE_ID, B.TASK_LEVEL_CODE, B.TASK_LEVEL_VALUE, T.COMPLETE_ACTION_LABEL, T.REJECT_ACTION_LABEL, T.SAVE_ACTION_LABEL, T.CALENDAR_ACTION_LABEL, T.ACTIVITY_ACTION1_LABEL, T.ACTIVITY_ACTION2_LABEL, T.ACTIVITY_ACTION3_LABEL, T.ACTIVITY_ACTION4_LABEL, T.ACTIVITY_ACTION5_LABEL, B.VIDEO_TYPE, B.DISPLAY_OPTIONS, B.VIDEO_URL, B.LEARN_ENROLLMENT_ID, B.LEARN_COMMUNITY_ID, B.LEARN_ENROLLMENT_TYPE, B.EMBED_TASK_ACTION_CODE, B.CONTENT_PROVIDER_CODE, B.EMBED_APP_TASK_TYPE_ID, B.CHECKLIST_CATEGORY, B.CHECKLIST_SUB_CATEGORY, B.ANALYTICS_SUB_TYPE FROM PER_CHECKLIST_TASKS_B B, PER_CHECKLIST_TASKS_TL T WHERE B.CHECKLIST_TASK_ID = T.CHECKLIST_TASK_ID AND T.LANGUAGE = USERENV('LANG')

SQL_Statement

SELECT

B.CHECKLIST_TASK_ID,

B.CHECKLIST_TASK_CODE,

B.TASK_CATEGORY,

B.ELIGIBILITY_PROFILE_ID,

B.MANDATORY_FLAG,

B.TARGET_DURATION,

B.TARGET_DURATION_UOM,

B.RESPONSIBILITY_TYPE,

B.ACTIVE_INACTIVE_FLAG,

B.TASK_DELAY_DURATION_UOM,

B.TASK_DELAY_DURATION,

B.ACTION_TYPE,

B.ADHOC_USER_GUID,

B.TASK_ACTION_ID,

B.FLEX_CONTEXT_CODE,

B.DOCUMENT_TYPE_ID,

B.TASK_CONFIGURATION,

B.ACTIVATION_ELIGY_PRFL_ID,

B.REMINDER_RECURRENCE,

B.REMINDER_DURATION,

B.REMINDER_RELATIVE_TO,

B.GENERATE_ATOM_FEED,

B.ATOM_FEED_CONFIGURATION,

B.OWNER_RESP_TYPE,

B.OWNER_USER_GUID,

B.MEETING_OFFSET,

B.MEETING_TIME,

B.ENABLE_TASK_EXPIRY,

B.EXPIRY_AFTER_DAYS,

T.CHECKLIST_TASK_NAME,

T.DESCRIPTION,

T.ACTION_URL,

T.TASK_DETAILS,

T.USER_DISPLAY_NAME,

T.MEETING_LOCATION,

B.BUSINESS_GROUP_ID,

B.OBJECT_VERSION_NUMBER,

B.LAST_UPDATE_DATE,

B.LAST_UPDATED_BY,

B.LAST_UPDATE_LOGIN,

B.CREATED_BY,

B.CREATION_DATE,

B.MODULE_ID,

B.SGUID,

B.SEED_DATA_SOURCE,

B.LEGISLATION_CODE,

B.LEGAL_EMPLOYER_ID,

B.BUSINESS_UNIT_ID,

B.TASK_ACTION_CODE,

B.SIGN_TEMPLATE,

B.ESIGN_TYPE,

B.REPORT_PATH,

B.QUESTIONNAIRE_ID,

T.NOTE_TITLE,

B.ATTACHMENT_DOCUMENT_TYPE_ID,

B.LEARNING_ITEM_ID,

B.LEARN_CONTENT_TYPE,

B.REPORT_PARAMETERS,

B.ANALYTICS_PATH,

B.EXPIRY_RELATIVE_TO,

B.TASK_FEATURE1,

B.TASK_FEATURE2,

B.TASK_FEATURE3,

B.TASK_FEATURE4,

B.TASK_FEATURE5,

B.TASK_FEATURE_DETAILS,

B.REMINDER_TEMPLATE_ID,

B.TASK_LEVEL_CODE,

B.TASK_LEVEL_VALUE,

T.COMPLETE_ACTION_LABEL,

T.REJECT_ACTION_LABEL,

T.SAVE_ACTION_LABEL,

T.CALENDAR_ACTION_LABEL,

T.ACTIVITY_ACTION1_LABEL,

T.ACTIVITY_ACTION2_LABEL,

T.ACTIVITY_ACTION3_LABEL,

T.ACTIVITY_ACTION4_LABEL,

T.ACTIVITY_ACTION5_LABEL,

B.VIDEO_TYPE,

B.DISPLAY_OPTIONS,

B.VIDEO_URL,

B.LEARN_ENROLLMENT_ID,

B.LEARN_COMMUNITY_ID,

B.LEARN_ENROLLMENT_TYPE,

B.EMBED_TASK_ACTION_CODE,

B.CONTENT_PROVIDER_CODE,

B.EMBED_APP_TASK_TYPE_ID,

B.CHECKLIST_CATEGORY,

B.CHECKLIST_SUB_CATEGORY,

B.ANALYTICS_SUB_TYPE

FROM

PER_CHECKLIST_TASKS_B B,

PER_CHECKLIST_TASKS_TL T

WHERE

B.CHECKLIST_TASK_ID = T.CHECKLIST_TASK_ID AND T.LANGUAGE = USERENV('LANG')