In the GTREP database there should be a relation between the job_information and the gtrep_publish_action table. At this moment I use the 'data' field in the job_information table to derive the gtrep_publish_action.pa_ld_id like so: SUBSTRING(data, CHARINDEX('generatorid', data)+13,CHARINDEX('jobtype',data) - CHARINDEX('generatorid', data) + Len('jobtype')-22)
I don't think this is how TDM Portal ties these two together. Does anyone know how this is done?