INSERT INTO ref_cat (
    site_cd,
    ref_cat_module,
    ref_cat_cat_cd,
    ref_cat_desc,
    ref_cat_disable_flag,
    audit_user,
    audit_date,
    column1,
    column2,
    column3,
    column4,
    column5
)
SELECT
    s.site_cd,
    m.ref_cat_module,                 -- module from predefined list
    'Information' AS ref_cat_cat_cd,  -- your new value
    'Information' AS ref_cat_desc,
    '0' AS ref_cat_disable_flag,
    'admin' AS audit_user,
    GETDATE() AS audit_date,
    NULL, NULL, NULL, NULL, NULL
FROM cf_site s
CROSS JOIN (
    VALUES
        ('Work Order'),
        ('Work Request'),
        ('Asset'),
        ('Inventory'),
        ('Purchase Request'),
        ('Purchase Order'),
        ('Supplier'),
        ('Training'),
        ('Preventive Maintenance'),
        ('Check List'),
        ('Contract'),
        ('Employee'),
        ('Customer'),
        ('Document Library'),
        ('Demand Task')
) AS m(ref_cat_module)
WHERE NOT EXISTS (
    SELECT 1
    FROM ref_cat r
    WHERE r.site_cd = s.site_cd
      AND r.ref_cat_module = m.ref_cat_module
      AND r.ref_cat_cat_cd = 'Information'
);
