220
edits
Changes
Jump to navigation
Jump to search
→Name Based Matching companybase keys to mas keys
maskeys.targetstatecode = maskeysmindates.targetstatecode);
--114825
The dateflag is 1 when the current key's announceddate is 1 week older than the minimum announced date for that targetname, targetstatecode pair. If the announceddate is less than 1 week greater than the minimum announceddate for te targetname, targetstatecode pair, then it is 0.
CREATE TABLE maskeysdatefiltered AS
