Participation (Transaction Data)

Technical name: 0HR_LSO_1

Technical Data

Type of DataSource

 Transaction data

Application component

SAP Learning Solution (PE-LSO)

Available as of Add-On Release

LSO200

RemoteCube-compatible

No

Use

This DataSource contains course bookings and course types participated in.

Delta Update

Delta update is not supported.

Fields of Origin in the Extraction Structure

Field in Extraction Structure

Description of Field in the Extraction Structure

Table of Origin

Field in the Table of Origin

CALDAY

Calendar day

HRP1001

BEGDA

GRPID

Course group

HRP1000

OBJID

TRAINTYPID

Course type

HRP1000

OBJID

TRAINTYPOTYP

Object type of course type

HRP1000

OTYPE

TRAINID

Course

HRP1000

OBJID

TRAINOTYPE

Object type of course               

HRP1000

OTYPE

PATYP

Participant type

HRP1001

SCLAS

PARID

Participant

HRP1001

SOBID

TPARTDOCNO

Course participation document

HRPAD614

TPARTDOCNO

TNUMEBOS

Number of achieved learning objectives

LSOLEARNING_C

TNUMEBOS

TNUMELUS

Number of completed learning objects

LSOLEARNING_C

TNUMELUS

TTIMECRS

Course completion time (in seconds)

LSOLEARNING_C

TTIMECRS

SCORE

Achieved score

LSOTACLRNASSRES

SCORE

PASSED

Flag for course passed

HRPAD614 or HRPAD25

PASSED

PRIOX

Participation booking priority

HRP1001

PRIOX

MANZL

Number of participants

HRPAD25 or HRPAD34 or HRP614

MANZL

KOKRS

Controlling area of participant

HRPAD25 or HRPAD34 or HRP614

KOKRS

KOSTL

Cost center of participant

HRPAD25 or HRPAD34 or HRP614

KOSTL

KKOST

Participation fee

HRPAD25 or HRPAD34 or HRP614

KKOST

KWAER

Currency of participation fee

HRPAD25 or HRPAD34 or HRP614

KWAER

INTEX

Fee indicator

HRPAD25 or HRPAD34 or HRP614

INTEX

STATUS

Document status

HRPAD25 or HRPAD34 or HRP614

STATUS

CONFIRMED

Participation confirmed

HRPAD614 or HRPAD25

CONFIRMED

FAILED

Reason failed

HRPAD614 or HRPAD25

FAILED

FOLLOW_UP

Follow-up completed

HRPAD614 or HRPAD25

FOLLOW_UP

Features of Extractor

The selection is set for the fields CALDAY, GRPID, TRAINTYPID and TRAINTYPOTYP.

If there is a booking relationship (A025 participates in or A614 is participated in by) between the participant and the course, the fields are filled with data from table HRPAD25 or HRP614.

If there is a relationship (B034 participated in) between the participant and the course type, the fields are filled with data from table HRPAD34.