LearningContentItems
LearningContentItems
Columns
| Name | Type | Description |
| ContentId [KEY] | Long | Unique identifier for the content object. |
| Title | String | Tiitle of the content item. |
| FileName | String | File name of the content item to be uploaded. Depending on the tracking type, the extension should be zip, pdf, or mov. |
| ItemNumber | String | Unique user key for the content item. |
| TrackingType | String | Tracking type for the content item. Valid values are ORA_SCORM_12, ORA_SCORM_2004, ORA_HACP, ORA_PDF, ORA_AUTO, and ORA_VIDEO. |
| Description | String | Description of the content item. |
| StartDate | Date | Start date of the content item. |
| EndDate | Date | End date of the content item. |
| UUID | String | Internal value, no input required. |
| Status | String | Status of the content item. For PDF and WEBLINK content, valid values are ORA_CONT_INACTIVE, ORA_CONT_ACTIVE. |
| URL | String | Starting URL of the content item. |
| UploadAuthToken | String | Upload authentication token generated for the learning content item. |
| UploadLocation | String | Upload location of the learning content item. |
| IngestionStatus | String | Ingestion status of the content item. For Video and SCORM/AICC/HACP content, valid value is ORA_MED_TRANSCODING. |
| MarkCompleteOnOpen | String | Indicates whether the learning content item can be marked complete when opened. This attribute doesn't have a default value. Valid values are Y and N. |
| AssessmentCode | String | Unique identifier for the assessment. |
| AssessmentMasteryScore | Double | Indicates the minimum score needed to pass the assessment. |
| AssessmentScoreVisibleToAdministrator | String | Indicates whether the assessment is visible to the administrator or not. This attribute doesn't have a default value. Valid values are Y and N. |
| AssessmentScoreVisibleToLearner | String | Indicates whether the assessment is visible to the learner or not. This attribute doesn't have a default value. Valid values are Y and N. |
| CompletedAssessmentVisibleToLearner | String | Indicates whether the completed assessment is visible to the learner or not. This attribute doesn't have a default value. Valid values are Y and N. |
| AssessmentTimeLimit | Double | Indicates the time limit for the assessment. |
| AssessmentTimeLimitUOM | String | Indicates the unit of measure for the assessment time limit. |
| AssessmentAttempts | Long | Indicates the number of attempts allowed for the assessment. |
| ReplaceStatus | String | Replacement status of the content item. For video, PDF, and SCORM/AICC/HACP content, valid values are ORA_MED_REPLACE_BEGIN and ORA_MED_REPLACE_END. Use ORA_MED_REPLACE_BEGIN to request the auth token for uploading a replacement to Akamai. Use ORA_MED_REPLACE_END to perform the replacement after the new media has been uploaded to Akamai. |
Pseudo-Columns
SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。
| Name | Type | Description |
| Finder | String | finder |