WLF_ASSIGNMENT_RECORDS

Details

Schema: FUSION
Object owner: WLF
Object type: VIEW

Columns

Name
ASSIGNMENT_RECORD_ID ASSIGNMENT_RECORD_NUMBER ACCESS_PERMISSION_ID PRE_ASSIGNMENT_RECORD_ID SUCC_ASSIGNMENT_RECORD_ID REASON_CODE EFFECTIVE_START_DATE EFFECTIVE_END_DATE EVENT_ASSIGNMENT_ID EVENT_CREATED_BY_ID VALIDITY_DATE EXPIRATION_DATE ASSIGNMENT_RULE_ID LEARNER_ID ATTACHMENT_ID DATE_STATUS_CHANGED TOTAL_LEARNING_TIME STATUS NOTIFICATION_STATUS CALCULATED_DUE_DATE COMPLETION_DATE IS_HISTORY_FLAG SOURCE_INFO SOURCE_TYPE SOURCE_ID LEARNING_ITEM_ID EVENT_TYPE EVENT_SUB_TYPE ATTRIBUTION_ID ATTRIBUTION_TYPE ATTRIBUTION_LOOKUP_CODE ASSIGNED_ON_DATE STATUS_CHANGE_COMMENT STATUS_CHANGE_TYPE CREATED_BY CREATION_DATE LAST_UPDATED_BY LAST_UPDATE_DATE LAST_UPDATE_LOGIN ENTERPRISE_ID OBJECT_VERSION_NUMBER LI_EFFECTIVE_DATE SH_ATTRIBUTE_CATEGORY SH_ATTRIBUTE1 SH_ATTRIBUTE2 SH_ATTRIBUTE3 SH_ATTRIBUTE4 SH_ATTRIBUTE5 SH_ATTRIBUTE6 SH_ATTRIBUTE7 SH_ATTRIBUTE8 SH_ATTRIBUTE9 SH_ATTRIBUTE10 SH_ATTRIBUTE11 SH_ATTRIBUTE12 SH_ATTRIBUTE13 SH_ATTRIBUTE14 SH_ATTRIBUTE15 SH_ATTRIBUTE16 SH_ATTRIBUTE17 SH_ATTRIBUTE18 SH_ATTRIBUTE19 SH_ATTRIBUTE20 SH_ATTRIBUTE21 SH_ATTRIBUTE22 SH_ATTRIBUTE23 SH_ATTRIBUTE24 SH_ATTRIBUTE25 SH_ATTRIBUTE26 SH_ATTRIBUTE27 SH_ATTRIBUTE28 SH_ATTRIBUTE29 SH_ATTRIBUTE30 SH_ATTRIBUTE_NUMBER1 SH_ATTRIBUTE_NUMBER2 SH_ATTRIBUTE_NUMBER3 SH_ATTRIBUTE_NUMBER4 SH_ATTRIBUTE_NUMBER5 SH_ATTRIBUTE_NUMBER6 SH_ATTRIBUTE_NUMBER7 SH_ATTRIBUTE_NUMBER8 SH_ATTRIBUTE_NUMBER9 SH_ATTRIBUTE_NUMBER10 SH_ATTRIBUTE_NUMBER11 SH_ATTRIBUTE_NUMBER12 SH_ATTRIBUTE_NUMBER13 SH_ATTRIBUTE_NUMBER14 SH_ATTRIBUTE_NUMBER15 SH_ATTRIBUTE_NUMBER16 SH_ATTRIBUTE_NUMBER17 SH_ATTRIBUTE_NUMBER18 SH_ATTRIBUTE_NUMBER19 SH_ATTRIBUTE_NUMBER20 SH_ATTRIBUTE_DATE1 SH_ATTRIBUTE_DATE2 SH_ATTRIBUTE_DATE3 SH_ATTRIBUTE_DATE4 SH_ATTRIBUTE_DATE5 SH_ATTRIBUTE_DATE6 SH_ATTRIBUTE_DATE7 SH_ATTRIBUTE_DATE8 SH_ATTRIBUTE_DATE9 SH_ATTRIBUTE_DATE10 SH_ATTRIBUTE_DATE11 SH_ATTRIBUTE_DATE12 SH_ATTRIBUTE_DATE13 SH_ATTRIBUTE_DATE14 SH_ATTRIBUTE_DATE15 REQUEST_DETAIL_ID TOTAL_ACTUAL_EFFORT SUB_STATUS EFFORT_UOM PRICING_RULE_ID PRICE_LOCK_DATE TRANSACTION_DETAILS_RULE_ID PEND_PREREQ_CUTOFF_DATE PH_DESTINATION_ID REQUESTED_DATE REQUEST_APPROVED_DATE REQUEST_REJECTED_DATE WAITLISTED_DATE DELETED_DATE WITHDRAWN_DATE WAITLIST_POSITION ADMIN_ACCESS_PERMISSION_ID PENDING_PREREQ_ENTERED_DATE PENDING_PREREQ_EXITED_DATE WAITLIST_EXITED_DATE ASSIGNMENT_STARTED_ON_DATE CONTENT_COMPLETION_DATE EVALUATION_SUBMITTED_DATE PENDING_PAY_ENTERED_DATE STATUS_EXPIRATION_DATE IS_COURSE_SUBORDINATE PAYMENT_RULE_ID BPM_TASK_ID WITHDRAW_REQUESTED_DATE CPE_TYPE CPE_POINTS CATEGORY_ID CATEGORY ACTUAL_SCORE USE_COMPLETED_ATTEMPTS_FLAG LI_DEF_USED_DATE LAST_RECONCILE_DATE LEARNING_ITEM_TYPE LEARNING_ITEM_SUB_TYPE

Name

ASSIGNMENT_RECORD_ID

ASSIGNMENT_RECORD_NUMBER

ACCESS_PERMISSION_ID

PRE_ASSIGNMENT_RECORD_ID

SUCC_ASSIGNMENT_RECORD_ID

REASON_CODE

EFFECTIVE_START_DATE

EFFECTIVE_END_DATE

EVENT_ASSIGNMENT_ID

EVENT_CREATED_BY_ID

VALIDITY_DATE

EXPIRATION_DATE

ASSIGNMENT_RULE_ID

LEARNER_ID

ATTACHMENT_ID

DATE_STATUS_CHANGED

TOTAL_LEARNING_TIME

STATUS

NOTIFICATION_STATUS

CALCULATED_DUE_DATE

COMPLETION_DATE

IS_HISTORY_FLAG

SOURCE_INFO

SOURCE_TYPE

SOURCE_ID

LEARNING_ITEM_ID

EVENT_TYPE

EVENT_SUB_TYPE

ATTRIBUTION_ID

ATTRIBUTION_TYPE

ATTRIBUTION_LOOKUP_CODE

ASSIGNED_ON_DATE

STATUS_CHANGE_COMMENT

STATUS_CHANGE_TYPE

CREATED_BY

CREATION_DATE

LAST_UPDATED_BY

LAST_UPDATE_DATE

LAST_UPDATE_LOGIN

ENTERPRISE_ID

OBJECT_VERSION_NUMBER

LI_EFFECTIVE_DATE

SH_ATTRIBUTE_CATEGORY

SH_ATTRIBUTE1

SH_ATTRIBUTE2

SH_ATTRIBUTE3

SH_ATTRIBUTE4

SH_ATTRIBUTE5

SH_ATTRIBUTE6

SH_ATTRIBUTE7

SH_ATTRIBUTE8

SH_ATTRIBUTE9

SH_ATTRIBUTE10

SH_ATTRIBUTE11

SH_ATTRIBUTE12

SH_ATTRIBUTE13

SH_ATTRIBUTE14

SH_ATTRIBUTE15

SH_ATTRIBUTE16

SH_ATTRIBUTE17

SH_ATTRIBUTE18

SH_ATTRIBUTE19

SH_ATTRIBUTE20

SH_ATTRIBUTE21

SH_ATTRIBUTE22

SH_ATTRIBUTE23

SH_ATTRIBUTE24

SH_ATTRIBUTE25

SH_ATTRIBUTE26

SH_ATTRIBUTE27

SH_ATTRIBUTE28

SH_ATTRIBUTE29

SH_ATTRIBUTE30

SH_ATTRIBUTE_NUMBER1

SH_ATTRIBUTE_NUMBER2

SH_ATTRIBUTE_NUMBER3

SH_ATTRIBUTE_NUMBER4

SH_ATTRIBUTE_NUMBER5

SH_ATTRIBUTE_NUMBER6

SH_ATTRIBUTE_NUMBER7

SH_ATTRIBUTE_NUMBER8

SH_ATTRIBUTE_NUMBER9

SH_ATTRIBUTE_NUMBER10

SH_ATTRIBUTE_NUMBER11

SH_ATTRIBUTE_NUMBER12

SH_ATTRIBUTE_NUMBER13

SH_ATTRIBUTE_NUMBER14

SH_ATTRIBUTE_NUMBER15

SH_ATTRIBUTE_NUMBER16

SH_ATTRIBUTE_NUMBER17

SH_ATTRIBUTE_NUMBER18

SH_ATTRIBUTE_NUMBER19

SH_ATTRIBUTE_NUMBER20

SH_ATTRIBUTE_DATE1

SH_ATTRIBUTE_DATE2

SH_ATTRIBUTE_DATE3

SH_ATTRIBUTE_DATE4

SH_ATTRIBUTE_DATE5

SH_ATTRIBUTE_DATE6

SH_ATTRIBUTE_DATE7

SH_ATTRIBUTE_DATE8

SH_ATTRIBUTE_DATE9

SH_ATTRIBUTE_DATE10

SH_ATTRIBUTE_DATE11

SH_ATTRIBUTE_DATE12

SH_ATTRIBUTE_DATE13

SH_ATTRIBUTE_DATE14

SH_ATTRIBUTE_DATE15

REQUEST_DETAIL_ID

TOTAL_ACTUAL_EFFORT

SUB_STATUS

EFFORT_UOM

PRICING_RULE_ID

PRICE_LOCK_DATE

TRANSACTION_DETAILS_RULE_ID

PEND_PREREQ_CUTOFF_DATE

PH_DESTINATION_ID

REQUESTED_DATE

REQUEST_APPROVED_DATE

REQUEST_REJECTED_DATE

WAITLISTED_DATE

DELETED_DATE

WITHDRAWN_DATE

WAITLIST_POSITION

ADMIN_ACCESS_PERMISSION_ID

PENDING_PREREQ_ENTERED_DATE

PENDING_PREREQ_EXITED_DATE

WAITLIST_EXITED_DATE

ASSIGNMENT_STARTED_ON_DATE

CONTENT_COMPLETION_DATE

EVALUATION_SUBMITTED_DATE

PENDING_PAY_ENTERED_DATE

STATUS_EXPIRATION_DATE

IS_COURSE_SUBORDINATE

PAYMENT_RULE_ID

BPM_TASK_ID

WITHDRAW_REQUESTED_DATE

CPE_TYPE

CPE_POINTS

CATEGORY_ID

Query

SQL_Statement
SELECT wlf_assignment_records_f.ASSIGNMENT_RECORD_ID ASSIGNMENT_RECORD_ID, wlf_assignment_records_f.ASSIGNMENT_RECORD_NUMBER ASSIGNMENT_RECORD_NUMBER, wlf_assignment_records_f.ACCESS_PERMISSION_ID ACCESS_PERMISSION_ID, wlf_assignment_records_f.PRE_ASSIGNMENT_RECORD_ID PRE_ASSIGNMENT_RECORD_ID, wlf_assignment_records_f.SUCC_ASSIGNMENT_RECORD_ID SUCC_ASSIGNMENT_RECORD_ID, wlf_assignment_records_f.REASON_CODE REASON_CODE, wlf_assignment_records_f.EFFECTIVE_START_DATE EFFECTIVE_START_DATE, wlf_assignment_records_f.EFFECTIVE_END_DATE EFFECTIVE_END_DATE, wlf_assignment_records_f.EVENT_ASSIGNMENT_ID EVENT_ASSIGNMENT_ID, wlf_assignment_records_f.EVENT_CREATED_BY_ID EVENT_CREATED_BY_ID, wlf_assignment_records_f.VALIDITY_DATE VALIDITY_DATE, wlf_assignment_records_f.EXPIRATION_DATE EXPIRATION_DATE, wlf_assignment_records_f.ASSIGNMENT_RULE_ID ASSIGNMENT_RULE_ID, wlf_assignment_records_f.LEARNER_ID LEARNER_ID, wlf_assignment_records_f.ATTACHMENT_ID ATTACHMENT_ID, wlf_assignment_records_f.DATE_STATUS_CHANGED DATE_STATUS_CHANGED, wlf_assignment_records_f.TOTAL_LEARNING_TIME TOTAL_LEARNING_TIME, wlf_assignment_records_f.STATUS STATUS, wlf_assignment_records_f.NOTIFICATION_STATUS NOTIFICATION_STATUS, wlf_assignment_records_f.CALCULATED_DUE_DATE CALCULATED_DUE_DATE, wlf_assignment_records_f.COMPLETION_DATE COMPLETION_DATE, wlf_assignment_records_f.IS_HISTORY_FLAG IS_HISTORY_FLAG, wlf_assignment_records_f.SOURCE_INFO SOURCE_INFO, wlf_assignment_records_f.SOURCE_TYPE SOURCE_TYPE, wlf_assignment_records_f.SOURCE_ID SOURCE_ID, wlf_assignment_records_f.LEARNING_ITEM_ID LEARNING_ITEM_ID, wlf_assignment_records_f.EVENT_TYPE EVENT_TYPE, wlf_assignment_records_f.EVENT_SUB_TYPE EVENT_SUB_TYPE, wlf_assignment_records_f.ATTRIBUTION_ID ATTRIBUTION_ID, wlf_assignment_records_f.ATTRIBUTION_TYPE ATTRIBUTION_TYPE, wlf_assignment_records_f.ATTRIBUTION_LOOKUP_CODE ATTRIBUTION_LOOKUP_CODE, wlf_assignment_records_f.ASSIGNED_ON_DATE ASSIGNED_ON_DATE, wlf_assignment_records_f.STATUS_CHANGE_COMMENT STATUS_CHANGE_COMMENT, wlf_assignment_records_f.STATUS_CHANGE_TYPE STATUS_CHANGE_TYPE, wlf_assignment_records_f.CREATED_BY CREATED_BY, wlf_assignment_records_f.CREATION_DATE CREATION_DATE, wlf_assignment_records_f.LAST_UPDATED_BY LAST_UPDATED_BY, wlf_assignment_records_f.LAST_UPDATE_DATE LAST_UPDATE_DATE, wlf_assignment_records_f.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, wlf_assignment_records_f.ENTERPRISE_ID ENTERPRISE_ID, wlf_assignment_records_f.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER, wlf_assignment_records_f.LI_EFFECTIVE_DATE LI_EFFECTIVE_DATE, wlf_assignment_records_f.SH_ATTRIBUTE_CATEGORY SH_ATTRIBUTE_CATEGORY, wlf_assignment_records_f.SH_ATTRIBUTE1 SH_ATTRIBUTE1, wlf_assignment_records_f.SH_ATTRIBUTE2 SH_ATTRIBUTE2, wlf_assignment_records_f.SH_ATTRIBUTE3 SH_ATTRIBUTE3, wlf_assignment_records_f.SH_ATTRIBUTE4 SH_ATTRIBUTE4, wlf_assignment_records_f.SH_ATTRIBUTE5 SH_ATTRIBUTE5, wlf_assignment_records_f.SH_ATTRIBUTE6 SH_ATTRIBUTE6, wlf_assignment_records_f.SH_ATTRIBUTE7 SH_ATTRIBUTE7, wlf_assignment_records_f.SH_ATTRIBUTE8 SH_ATTRIBUTE8, wlf_assignment_records_f.SH_ATTRIBUTE9 SH_ATTRIBUTE9, wlf_assignment_records_f.SH_ATTRIBUTE10 SH_ATTRIBUTE10, wlf_assignment_records_f.SH_ATTRIBUTE11 SH_ATTRIBUTE11, wlf_assignment_records_f.SH_ATTRIBUTE12 SH_ATTRIBUTE12, wlf_assignment_records_f.SH_ATTRIBUTE13 SH_ATTRIBUTE13, wlf_assignment_records_f.SH_ATTRIBUTE14 SH_ATTRIBUTE14, wlf_assignment_records_f.SH_ATTRIBUTE15 SH_ATTRIBUTE15, wlf_assignment_records_f.SH_ATTRIBUTE16 SH_ATTRIBUTE16, wlf_assignment_records_f.SH_ATTRIBUTE17 SH_ATTRIBUTE17, wlf_assignment_records_f.SH_ATTRIBUTE18 SH_ATTRIBUTE18, wlf_assignment_records_f.SH_ATTRIBUTE19 SH_ATTRIBUTE19, wlf_assignment_records_f.SH_ATTRIBUTE20 SH_ATTRIBUTE20, wlf_assignment_records_f.SH_ATTRIBUTE21 SH_ATTRIBUTE21, wlf_assignment_records_f.SH_ATTRIBUTE22 SH_ATTRIBUTE22, wlf_assignment_records_f.SH_ATTRIBUTE23 SH_ATTRIBUTE23, wlf_assignment_records_f.SH_ATTRIBUTE24 SH_ATTRIBUTE24, wlf_assignment_records_f.SH_ATTRIBUTE25 SH_ATTRIBUTE25, wlf_assignment_records_f.SH_ATTRIBUTE26 SH_ATTRIBUTE26, wlf_assignment_records_f.SH_ATTRIBUTE27 SH_ATTRIBUTE27, wlf_assignment_records_f.SH_ATTRIBUTE28 SH_ATTRIBUTE28, wlf_assignment_records_f.SH_ATTRIBUTE29 SH_ATTRIBUTE29, wlf_assignment_records_f.SH_ATTRIBUTE30 SH_ATTRIBUTE30, wlf_assignment_records_f.SH_ATTRIBUTE_NUMBER1 SH_ATTRIBUTE_NUMBER1, wlf_assignment_records_f.SH_ATTRIBUTE_NUMBER2 SH_ATTRIBUTE_NUMBER2, wlf_assignment_records_f.SH_ATTRIBUTE_NUMBER3 SH_ATTRIBUTE_NUMBER3, wlf_assignment_records_f.SH_ATTRIBUTE_NUMBER4 SH_ATTRIBUTE_NUMBER4, wlf_assignment_records_f.SH_ATTRIBUTE_NUMBER5 SH_ATTRIBUTE_NUMBER5, wlf_assignment_records_f.SH_ATTRIBUTE_NUMBER6 SH_ATTRIBUTE_NUMBER6, wlf_assignment_records_f.SH_ATTRIBUTE_NUMBER7 SH_ATTRIBUTE_NUMBER7, wlf_assignment_records_f.SH_ATTRIBUTE_NUMBER8 SH_ATTRIBUTE_NUMBER8, wlf_assignment_records_f.SH_ATTRIBUTE_NUMBER9 SH_ATTRIBUTE_NUMBER9, wlf_assignment_records_f.SH_ATTRIBUTE_NUMBER10 SH_ATTRIBUTE_NUMBER10, wlf_assignment_records_f.SH_ATTRIBUTE_NUMBER11 SH_ATTRIBUTE_NUMBER11, wlf_assignment_records_f.SH_ATTRIBUTE_NUMBER12 SH_ATTRIBUTE_NUMBER12, wlf_assignment_records_f.SH_ATTRIBUTE_NUMBER13 SH_ATTRIBUTE_NUMBER13, wlf_assignment_records_f.SH_ATTRIBUTE_NUMBER14 SH_ATTRIBUTE_NUMBER14, wlf_assignment_records_f.SH_ATTRIBUTE_NUMBER15 SH_ATTRIBUTE_NUMBER15, wlf_assignment_records_f.SH_ATTRIBUTE_NUMBER16 SH_ATTRIBUTE_NUMBER16, wlf_assignment_records_f.SH_ATTRIBUTE_NUMBER17 SH_ATTRIBUTE_NUMBER17, wlf_assignment_records_f.SH_ATTRIBUTE_NUMBER18 SH_ATTRIBUTE_NUMBER18, wlf_assignment_records_f.SH_ATTRIBUTE_NUMBER19 SH_ATTRIBUTE_NUMBER19, wlf_assignment_records_f.SH_ATTRIBUTE_NUMBER20 SH_ATTRIBUTE_NUMBER20, wlf_assignment_records_f.SH_ATTRIBUTE_DATE1 SH_ATTRIBUTE_DATE1, wlf_assignment_records_f.SH_ATTRIBUTE_DATE2 SH_ATTRIBUTE_DATE2, wlf_assignment_records_f.SH_ATTRIBUTE_DATE3 SH_ATTRIBUTE_DATE3, wlf_assignment_records_f.SH_ATTRIBUTE_DATE4 SH_ATTRIBUTE_DATE4, wlf_assignment_records_f.SH_ATTRIBUTE_DATE5 SH_ATTRIBUTE_DATE5, wlf_assignment_records_f.SH_ATTRIBUTE_DATE6 SH_ATTRIBUTE_DATE6, wlf_assignment_records_f.SH_ATTRIBUTE_DATE7 SH_ATTRIBUTE_DATE7, wlf_assignment_records_f.SH_ATTRIBUTE_DATE8 SH_ATTRIBUTE_DATE8, wlf_assignment_records_f.SH_ATTRIBUTE_DATE9 SH_ATTRIBUTE_DATE9, wlf_assignment_records_f.SH_ATTRIBUTE_DATE10 SH_ATTRIBUTE_DATE10, wlf_assignment_records_f.SH_ATTRIBUTE_DATE11 SH_ATTRIBUTE_DATE11, wlf_assignment_records_f.SH_ATTRIBUTE_DATE12 SH_ATTRIBUTE_DATE12, wlf_assignment_records_f.SH_ATTRIBUTE_DATE13 SH_ATTRIBUTE_DATE13, wlf_assignment_records_f.SH_ATTRIBUTE_DATE14 SH_ATTRIBUTE_DATE14, wlf_assignment_records_f.SH_ATTRIBUTE_DATE15 SH_ATTRIBUTE_DATE15, wlf_assignment_records_f.REQUEST_DETAIL_ID REQUEST_DETAIL_ID, wlf_assignment_records_f.TOTAL_ACTUAL_EFFORT TOTAL_ACTUAL_EFFORT, wlf_assignment_records_f.SUB_STATUS SUB_STATUS, wlf_assignment_records_f.EFFORT_UOM EFFORT_UOM, wlf_assignment_records_f.PRICING_RULE_ID PRICING_RULE_ID, wlf_assignment_records_f.PRICE_LOCK_DATE PRICE_LOCK_DATE, wlf_assignment_records_f.TRANSACTION_DETAILS_RULE_ID TRANSACTION_DETAILS_RULE_ID, wlf_assignment_records_f.PEND_PREREQ_CUTOFF_DATE PEND_PREREQ_CUTOFF_DATE, wlf_assignment_records_f.PH_DESTINATION_ID PH_DESTINATION_ID, wlf_assignment_records_f.REQUESTED_DATE REQUESTED_DATE, wlf_assignment_records_f.REQUEST_APPROVED_DATE REQUEST_APPROVED_DATE, wlf_assignment_records_f.REQUEST_REJECTED_DATE REQUEST_REJECTED_DATE, wlf_assignment_records_f.WAITLISTED_DATE WAITLISTED_DATE, wlf_assignment_records_f.DELETED_DATE DELETED_DATE, wlf_assignment_records_f.WITHDRAWN_DATE WITHDRAWN_DATE, wlf_assignment_records_f.WAITLIST_POSITION WAITLIST_POSITION, wlf_assignment_records_f.ADMIN_ACCESS_PERMISSION_ID ADMIN_ACCESS_PERMISSION_ID, wlf_assignment_records_f.PENDING_PREREQ_ENTERED_DATE PENDING_PREREQ_ENTERED_DATE, wlf_assignment_records_f.PENDING_PREREQ_EXITED_DATE PENDING_PREREQ_EXITED_DATE, wlf_assignment_records_f.WAITLIST_EXITED_DATE WAITLIST_EXITED_DATE, wlf_assignment_records_f.ASSIGNMENT_STARTED_ON_DATE ASSIGNMENT_STARTED_ON_DATE, wlf_assignment_records_f.CONTENT_COMPLETION_DATE CONTENT_COMPLETION_DATE, wlf_assignment_records_f.EVALUATION_SUBMITTED_DATE EVALUATION_SUBMITTED_DATE, wlf_assignment_records_f.PENDING_PAY_ENTERED_DATE PENDING_PAY_ENTERED_DATE, wlf_assignment_records_f.STATUS_EXPIRATION_DATE STATUS_EXPIRATION_DATE, wlf_assignment_records_f.IS_COURSE_SUBORDINATE IS_COURSE_SUBORDINATE, wlf_assignment_records_f.PAYMENT_RULE_ID PAYMENT_RULE_ID, wlf_assignment_records_f.BPM_TASK_ID BPM_TASK_ID, wlf_assignment_records_f.WITHDRAW_REQUESTED_DATE WITHDRAW_REQUESTED_DATE, wlf_assignment_records_f.CPE_TYPE CPE_TYPE, wlf_assignment_records_f.CPE_POINTS CPE_POINTS, wlf_assignment_records_f.CATEGORY_ID CATEGORY_ID, wlf_assignment_records_f.CATEGORY CATEGORY, wlf_assignment_records_f.ACTUAL_SCORE ACTUAL_SCORE, wlf_assignment_records_f.USE_COMPLETED_ATTEMPTS_FLAG USE_COMPLETED_ATTEMPTS_FLAG, wlf_assignment_records_f.LI_DEF_USED_DATE LI_DEF_USED_DATE, wlf_assignment_records_f.LAST_RECONCILE_DATE LAST_RECONCILE_DATE, wlf_assignment_records_f.LEARNING_ITEM_TYPE LEARNING_ITEM_TYPE, wlf_assignment_records_f.LEARNING_ITEM_SUB_TYPE LEARNING_ITEM_SUB_TYPE FROM wlf_assignment_records_f

SQL_Statement

SELECT

wlf_assignment_records_f.ASSIGNMENT_RECORD_ID ASSIGNMENT_RECORD_ID,

wlf_assignment_records_f.ASSIGNMENT_RECORD_NUMBER ASSIGNMENT_RECORD_NUMBER,

wlf_assignment_records_f.ACCESS_PERMISSION_ID ACCESS_PERMISSION_ID,

wlf_assignment_records_f.PRE_ASSIGNMENT_RECORD_ID PRE_ASSIGNMENT_RECORD_ID,

wlf_assignment_records_f.SUCC_ASSIGNMENT_RECORD_ID SUCC_ASSIGNMENT_RECORD_ID,

wlf_assignment_records_f.REASON_CODE REASON_CODE,

wlf_assignment_records_f.EFFECTIVE_START_DATE EFFECTIVE_START_DATE,

wlf_assignment_records_f.EFFECTIVE_END_DATE EFFECTIVE_END_DATE,

wlf_assignment_records_f.EVENT_ASSIGNMENT_ID EVENT_ASSIGNMENT_ID,

wlf_assignment_records_f.EVENT_CREATED_BY_ID EVENT_CREATED_BY_ID,

wlf_assignment_records_f.VALIDITY_DATE VALIDITY_DATE,

wlf_assignment_records_f.EXPIRATION_DATE EXPIRATION_DATE,

wlf_assignment_records_f.ASSIGNMENT_RULE_ID ASSIGNMENT_RULE_ID,

wlf_assignment_records_f.LEARNER_ID LEARNER_ID,

wlf_assignment_records_f.ATTACHMENT_ID ATTACHMENT_ID,

wlf_assignment_records_f.DATE_STATUS_CHANGED DATE_STATUS_CHANGED,

wlf_assignment_records_f.TOTAL_LEARNING_TIME TOTAL_LEARNING_TIME,

wlf_assignment_records_f.STATUS STATUS,

wlf_assignment_records_f.NOTIFICATION_STATUS NOTIFICATION_STATUS,

wlf_assignment_records_f.CALCULATED_DUE_DATE CALCULATED_DUE_DATE,

wlf_assignment_records_f.COMPLETION_DATE COMPLETION_DATE,

wlf_assignment_records_f.IS_HISTORY_FLAG IS_HISTORY_FLAG,

wlf_assignment_records_f.SOURCE_INFO SOURCE_INFO,

wlf_assignment_records_f.SOURCE_TYPE SOURCE_TYPE,

wlf_assignment_records_f.SOURCE_ID SOURCE_ID,

wlf_assignment_records_f.LEARNING_ITEM_ID LEARNING_ITEM_ID,

wlf_assignment_records_f.EVENT_TYPE EVENT_TYPE,

wlf_assignment_records_f.EVENT_SUB_TYPE EVENT_SUB_TYPE,

wlf_assignment_records_f.ATTRIBUTION_ID ATTRIBUTION_ID,

wlf_assignment_records_f.ATTRIBUTION_TYPE ATTRIBUTION_TYPE,

wlf_assignment_records_f.ATTRIBUTION_LOOKUP_CODE ATTRIBUTION_LOOKUP_CODE,

wlf_assignment_records_f.ASSIGNED_ON_DATE ASSIGNED_ON_DATE,

wlf_assignment_records_f.STATUS_CHANGE_COMMENT STATUS_CHANGE_COMMENT,

wlf_assignment_records_f.STATUS_CHANGE_TYPE STATUS_CHANGE_TYPE,

wlf_assignment_records_f.CREATED_BY CREATED_BY,

wlf_assignment_records_f.CREATION_DATE CREATION_DATE,

wlf_assignment_records_f.LAST_UPDATED_BY LAST_UPDATED_BY,

wlf_assignment_records_f.LAST_UPDATE_DATE LAST_UPDATE_DATE,

wlf_assignment_records_f.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN,

wlf_assignment_records_f.ENTERPRISE_ID ENTERPRISE_ID,

wlf_assignment_records_f.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER,

wlf_assignment_records_f.LI_EFFECTIVE_DATE LI_EFFECTIVE_DATE,

wlf_assignment_records_f.SH_ATTRIBUTE_CATEGORY SH_ATTRIBUTE_CATEGORY,

wlf_assignment_records_f.SH_ATTRIBUTE1 SH_ATTRIBUTE1,

wlf_assignment_records_f.SH_ATTRIBUTE2 SH_ATTRIBUTE2,

wlf_assignment_records_f.SH_ATTRIBUTE3 SH_ATTRIBUTE3,

wlf_assignment_records_f.SH_ATTRIBUTE4 SH_ATTRIBUTE4,

wlf_assignment_records_f.SH_ATTRIBUTE5 SH_ATTRIBUTE5,

wlf_assignment_records_f.SH_ATTRIBUTE6 SH_ATTRIBUTE6,

wlf_assignment_records_f.SH_ATTRIBUTE7 SH_ATTRIBUTE7,

wlf_assignment_records_f.SH_ATTRIBUTE8 SH_ATTRIBUTE8,

wlf_assignment_records_f.SH_ATTRIBUTE9 SH_ATTRIBUTE9,

wlf_assignment_records_f.SH_ATTRIBUTE10 SH_ATTRIBUTE10,

wlf_assignment_records_f.SH_ATTRIBUTE11 SH_ATTRIBUTE11,

wlf_assignment_records_f.SH_ATTRIBUTE12 SH_ATTRIBUTE12,

wlf_assignment_records_f.SH_ATTRIBUTE13 SH_ATTRIBUTE13,

wlf_assignment_records_f.SH_ATTRIBUTE14 SH_ATTRIBUTE14,

wlf_assignment_records_f.SH_ATTRIBUTE15 SH_ATTRIBUTE15,

wlf_assignment_records_f.SH_ATTRIBUTE16 SH_ATTRIBUTE16,

wlf_assignment_records_f.SH_ATTRIBUTE17 SH_ATTRIBUTE17,

wlf_assignment_records_f.SH_ATTRIBUTE18 SH_ATTRIBUTE18,

wlf_assignment_records_f.SH_ATTRIBUTE19 SH_ATTRIBUTE19,

wlf_assignment_records_f.SH_ATTRIBUTE20 SH_ATTRIBUTE20,

wlf_assignment_records_f.SH_ATTRIBUTE21 SH_ATTRIBUTE21,

wlf_assignment_records_f.SH_ATTRIBUTE22 SH_ATTRIBUTE22,

wlf_assignment_records_f.SH_ATTRIBUTE23 SH_ATTRIBUTE23,

wlf_assignment_records_f.SH_ATTRIBUTE24 SH_ATTRIBUTE24,

wlf_assignment_records_f.SH_ATTRIBUTE25 SH_ATTRIBUTE25,

wlf_assignment_records_f.SH_ATTRIBUTE26 SH_ATTRIBUTE26,

wlf_assignment_records_f.SH_ATTRIBUTE27 SH_ATTRIBUTE27,

wlf_assignment_records_f.SH_ATTRIBUTE28 SH_ATTRIBUTE28,

wlf_assignment_records_f.SH_ATTRIBUTE29 SH_ATTRIBUTE29,

wlf_assignment_records_f.SH_ATTRIBUTE30 SH_ATTRIBUTE30,

wlf_assignment_records_f.SH_ATTRIBUTE_NUMBER1 SH_ATTRIBUTE_NUMBER1,

wlf_assignment_records_f.SH_ATTRIBUTE_NUMBER2 SH_ATTRIBUTE_NUMBER2,

wlf_assignment_records_f.SH_ATTRIBUTE_NUMBER3 SH_ATTRIBUTE_NUMBER3,

wlf_assignment_records_f.SH_ATTRIBUTE_NUMBER4 SH_ATTRIBUTE_NUMBER4,

wlf_assignment_records_f.SH_ATTRIBUTE_NUMBER5 SH_ATTRIBUTE_NUMBER5,

wlf_assignment_records_f.SH_ATTRIBUTE_NUMBER6 SH_ATTRIBUTE_NUMBER6,

wlf_assignment_records_f.SH_ATTRIBUTE_NUMBER7 SH_ATTRIBUTE_NUMBER7,

wlf_assignment_records_f.SH_ATTRIBUTE_NUMBER8 SH_ATTRIBUTE_NUMBER8,

wlf_assignment_records_f.SH_ATTRIBUTE_NUMBER9 SH_ATTRIBUTE_NUMBER9,

wlf_assignment_records_f.SH_ATTRIBUTE_NUMBER10 SH_ATTRIBUTE_NUMBER10,

wlf_assignment_records_f.SH_ATTRIBUTE_NUMBER11 SH_ATTRIBUTE_NUMBER11,

wlf_assignment_records_f.SH_ATTRIBUTE_NUMBER12 SH_ATTRIBUTE_NUMBER12,

wlf_assignment_records_f.SH_ATTRIBUTE_NUMBER13 SH_ATTRIBUTE_NUMBER13,

wlf_assignment_records_f.SH_ATTRIBUTE_NUMBER14 SH_ATTRIBUTE_NUMBER14,

wlf_assignment_records_f.SH_ATTRIBUTE_NUMBER15 SH_ATTRIBUTE_NUMBER15,

wlf_assignment_records_f.SH_ATTRIBUTE_NUMBER16 SH_ATTRIBUTE_NUMBER16,

wlf_assignment_records_f.SH_ATTRIBUTE_NUMBER17 SH_ATTRIBUTE_NUMBER17,

wlf_assignment_records_f.SH_ATTRIBUTE_NUMBER18 SH_ATTRIBUTE_NUMBER18,

wlf_assignment_records_f.SH_ATTRIBUTE_NUMBER19 SH_ATTRIBUTE_NUMBER19,

wlf_assignment_records_f.SH_ATTRIBUTE_NUMBER20 SH_ATTRIBUTE_NUMBER20,

wlf_assignment_records_f.SH_ATTRIBUTE_DATE1 SH_ATTRIBUTE_DATE1,

wlf_assignment_records_f.SH_ATTRIBUTE_DATE2 SH_ATTRIBUTE_DATE2,

wlf_assignment_records_f.SH_ATTRIBUTE_DATE3 SH_ATTRIBUTE_DATE3,

wlf_assignment_records_f.SH_ATTRIBUTE_DATE4 SH_ATTRIBUTE_DATE4,

wlf_assignment_records_f.SH_ATTRIBUTE_DATE5 SH_ATTRIBUTE_DATE5,

wlf_assignment_records_f.SH_ATTRIBUTE_DATE6 SH_ATTRIBUTE_DATE6,

wlf_assignment_records_f.SH_ATTRIBUTE_DATE7 SH_ATTRIBUTE_DATE7,

wlf_assignment_records_f.SH_ATTRIBUTE_DATE8 SH_ATTRIBUTE_DATE8,

wlf_assignment_records_f.SH_ATTRIBUTE_DATE9 SH_ATTRIBUTE_DATE9,

wlf_assignment_records_f.SH_ATTRIBUTE_DATE10 SH_ATTRIBUTE_DATE10,

wlf_assignment_records_f.SH_ATTRIBUTE_DATE11 SH_ATTRIBUTE_DATE11,

wlf_assignment_records_f.SH_ATTRIBUTE_DATE12 SH_ATTRIBUTE_DATE12,

wlf_assignment_records_f.SH_ATTRIBUTE_DATE13 SH_ATTRIBUTE_DATE13,

wlf_assignment_records_f.SH_ATTRIBUTE_DATE14 SH_ATTRIBUTE_DATE14,

wlf_assignment_records_f.SH_ATTRIBUTE_DATE15 SH_ATTRIBUTE_DATE15,

wlf_assignment_records_f.REQUEST_DETAIL_ID REQUEST_DETAIL_ID,

wlf_assignment_records_f.TOTAL_ACTUAL_EFFORT TOTAL_ACTUAL_EFFORT,

wlf_assignment_records_f.SUB_STATUS SUB_STATUS,

wlf_assignment_records_f.EFFORT_UOM EFFORT_UOM,

wlf_assignment_records_f.PRICING_RULE_ID PRICING_RULE_ID,

wlf_assignment_records_f.PRICE_LOCK_DATE PRICE_LOCK_DATE,

wlf_assignment_records_f.TRANSACTION_DETAILS_RULE_ID TRANSACTION_DETAILS_RULE_ID,

wlf_assignment_records_f.PEND_PREREQ_CUTOFF_DATE PEND_PREREQ_CUTOFF_DATE,

wlf_assignment_records_f.PH_DESTINATION_ID PH_DESTINATION_ID,

wlf_assignment_records_f.REQUESTED_DATE REQUESTED_DATE,

wlf_assignment_records_f.REQUEST_APPROVED_DATE REQUEST_APPROVED_DATE,

wlf_assignment_records_f.REQUEST_REJECTED_DATE REQUEST_REJECTED_DATE,

wlf_assignment_records_f.WAITLISTED_DATE WAITLISTED_DATE,

wlf_assignment_records_f.DELETED_DATE DELETED_DATE,

wlf_assignment_records_f.WITHDRAWN_DATE WITHDRAWN_DATE,

wlf_assignment_records_f.WAITLIST_POSITION WAITLIST_POSITION,

wlf_assignment_records_f.ADMIN_ACCESS_PERMISSION_ID ADMIN_ACCESS_PERMISSION_ID,

wlf_assignment_records_f.PENDING_PREREQ_ENTERED_DATE PENDING_PREREQ_ENTERED_DATE,

wlf_assignment_records_f.PENDING_PREREQ_EXITED_DATE PENDING_PREREQ_EXITED_DATE,

wlf_assignment_records_f.WAITLIST_EXITED_DATE WAITLIST_EXITED_DATE,

wlf_assignment_records_f.ASSIGNMENT_STARTED_ON_DATE ASSIGNMENT_STARTED_ON_DATE,

wlf_assignment_records_f.CONTENT_COMPLETION_DATE CONTENT_COMPLETION_DATE,

wlf_assignment_records_f.EVALUATION_SUBMITTED_DATE EVALUATION_SUBMITTED_DATE,

wlf_assignment_records_f.PENDING_PAY_ENTERED_DATE PENDING_PAY_ENTERED_DATE,

wlf_assignment_records_f.STATUS_EXPIRATION_DATE STATUS_EXPIRATION_DATE,

wlf_assignment_records_f.IS_COURSE_SUBORDINATE IS_COURSE_SUBORDINATE,

wlf_assignment_records_f.PAYMENT_RULE_ID PAYMENT_RULE_ID,

wlf_assignment_records_f.BPM_TASK_ID BPM_TASK_ID,

wlf_assignment_records_f.WITHDRAW_REQUESTED_DATE WITHDRAW_REQUESTED_DATE,

wlf_assignment_records_f.CPE_TYPE CPE_TYPE,

wlf_assignment_records_f.CPE_POINTS CPE_POINTS,

wlf_assignment_records_f.CATEGORY_ID CATEGORY_ID,

wlf_assignment_records_f.CATEGORY CATEGORY,

wlf_assignment_records_f.ACTUAL_SCORE ACTUAL_SCORE,

wlf_assignment_records_f.USE_COMPLETED_ATTEMPTS_FLAG USE_COMPLETED_ATTEMPTS_FLAG,

wlf_assignment_records_f.LI_DEF_USED_DATE LI_DEF_USED_DATE,

wlf_assignment_records_f.LAST_RECONCILE_DATE LAST_RECONCILE_DATE,

wlf_assignment_records_f.LEARNING_ITEM_TYPE LEARNING_ITEM_TYPE,

wlf_assignment_records_f.LEARNING_ITEM_SUB_TYPE LEARNING_ITEM_SUB_TYPE

FROM

wlf_assignment_records_f