My Oracle Support Banner

ELM 9.x LM_TRACK_STUDNT Converting Table Data for Total Time and Session Time (Doc ID 1334197.1)

Last updated on NOVEMBER 05, 2017

Applies to:

PeopleSoft Enterprise ELM Enterprise Learning Management - Version 8.81 to 9.2 [Release 8.8 to 9]
Information in this document applies to any platform.
Tracking Total Time and Session Time from the LM_TRACK_STUDNT table


Purpose

This note references SQL settings to reference Total Time and Session Time from an Oracle Database in the case where field values may be reflected in Date or Date/Time format.

Scope

In some instances the Total Time and Session time may be reflected to include date (i.e 1/1/1900) depending upon your database formats and how the content posts data to the LM_TRACK_STUDNT table.

Details

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Purpose
Scope
Details

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.