cancel
Showing results for 
Search instead for 
Did you mean: 

Custom report in LMS

manishvyas
Discoverer
0 Kudos
775

Dear All Expertise,

Hope your doing well.

I'm customizing a LMS PRD report in order to create brand new custom report.

Could you please provide the source information (table) for the below fields which we need in custom report.

Division

Cost Center

Primary Supervisor email

Job Title

Facility Description

Start date

Registration Status Description

Completion Status Description

Assignment Type Description

Item Description

Course revalidation date

We just need to know the source information for the above fields in LMS.

Regards,

Manish Vyas

View Entire Topic
0 Kudos

Hi Manish

You can search for these fields in PA_SCHED table under data dictionary.

Item Type and Title you can get from PA_CPNT table.

Regards

Ridhi

sfsfaficionado
Active Participant
0 Kudos
how do we fetch the name fname and lname for super_id ..do we need get the superid and pass it in pa_studnet table or is there a table that holds name of supervisor