WatIAM

The “WatIAM” application maintains a copy of all the information found in the WatIAM ”Extract” file.

Profile

Schemas

• _watiam — Main schema containing tables derived from WatIAM “Extract” file.
• _watiam_load — Tables used when updating the _watiam tables from the _watiam_raw tables.
• _watiam_raw — Raw tables used to load WatIAM “Extract” file, and check views which find questionable entries.
• _watiam_view — Views which compute _watiam table contents from _watiam_raw tables.

Roles

• _watiam_core — Standard role which owns functions.
• _watiam_load — Role used to load data. Full access to tables in _watiam, _watiam_load, and _watiam_raw.
• _watiam_raw_select — Grantable role to give SELECT access to tables in _watiam_load and _watiam_raw.
• _watiam_references — Standard role to give REFERENCES access to all tables in _watiam.
• _watiam_root — Standard role which owns all tables.
• _watiam_select — Standard role with SELECT access to all tables in _watiam.

Dependencies

• Data

Dependents

• Instruct
• Identity

Details