Symptom
Within an Item, admins can populate the Item Image and Image URL details. Where are these details located within the LMS database?
Image/data in this KBA is from SAP internal systems, sample data, or demo systems. Any resemblance to real data is purely coincidental.
Environment
SAP SuccessFactors Learning
Resolution
The Image details are stored in the PA_ATTACHMENT table, and the relationship between the attachment and the item is kept in the PA_ATTACHMENT_CPNT_THUMBNAIL table.
The Image URL details are found in the THUMBNAIL_URI column within the PA_CPNT table.
See Also
Keywords
sf, sfsf, lms, learning, administration, admin, image, item, thumbnail, thumbnail image, url, image url, PA_CPNT, PA_ATTACHMENT, PA_ATTACHMENT_CPNT_THUMBNAIL, THUMBNAIL_URI , KBA , LOD-SF-LMS-CRI , Custom Report Issues , LOD-SF-LMS-ITE , Items , LOD-SF-LMS-REP , Reporting Data , How To