LM_TRAKLONG_HST

(SQL Table)
Index Back

Tracking table long

AICC Track long table

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 PSARCH_ID Character(8) VARCHAR2(8) NOT NULL Archive ID (see PSARCHTEMPLATE).
2 PSARCH_BATCHNUM Number(30,0) DECIMAL(30) NOT NULL Archive Batch Number
3 LM_ENRLMT_ID Number(10,0) DECIMAL(10) NOT NULL Enrollment ID
4 LM_LC_ID Number(10,0) DECIMAL(10) NOT NULL Learning Component ID - Blended Learning
5 LM_SCO_ID Character(200) VARCHAR2(200) NOT NULL A system id for the launchable SCOs or AUs, determined by the content provider
6 LM_LONG_ID Number(10,0) DECIMAL(10) NOT NULL Long ID
7 LM_ACT_ID Number(10,0) DECIMAL(10) NOT NULL Activity ID
8 LM_LONG_DATA Long Character(10000) CLOB Long Data