wonum in ( 
        select 
            workorderspec.wonum  
        from  
            maximo.workorderspec
        where 
            classstructureid is not null  
            and workorderspec.refobjectid = workorder.workorderid
            and workorderspec.assetattrid= '3_CB_REPAIR' 
            and upper(workorderspec.alnvalue) = 'MAJOR REPAIRS' 
         )
        and hasfollowupwork = 0
        and wonum not in (
                        select 
                            relatedreckey 
                        from 
                            maximo.relatedrecord 
                        where
                            relatedrecclass='WORKORDER' 
                            and relatetype='FOLLOWUP'
                         )

Question:

A worker inspects up to 100 catch basins in a day. We want to avoid forcing the worker to manually create follow-up WOs for each of the 100 catch basins he inspects (tedious and error-prone). Instead, we want to automatically create follow-up WOs based on the inspection WOs' specification attributes.

To do that, I think I could query for the 'MAJOR REPAIRS' as demonstrated above. And then come up with a mechanism in Maximo that would automatically create follow-up WOs for each WO in the query.

What mechanism could I use to automatically create follow-up WOs from the WOs in the query? (run daily)

Thank you.