7,612
edits
Changes
Jump to navigation
Jump to search
→Creating portcoexitmaster
==Creating portcoexitmaster==
Portcoexitmaster contains the portcokey with an exitflag, ipoflag and maflag and an exit value. It is built off the companybaseipomasmaster table so be sure you've built this first. Note that the amounts are actually in b m (not k) in the input. We need to times by 1000 to get to m.
ALTER TABLE portcoexitbuild RENAME TO portcoexitbuildbak;
CASE WHEN masannounceddate IS NOT NULL THEN 1::int ELSE 0::int END AS maflag,
CASE WHEN ipoissuedate IS NOT NULL OR masannounceddate IS NOT NULL THEN 1::int ELSE 0::int END AS exitflag,
CASE WHEN ipoissuedate IS NOT NULL THEN ipoamt::numeric::float8*1000 ELSE maamt::numeric::float8*1000 END AS
exitvaluem
FROM portcoexitbuild;
