View: policy.auto_verification_policy_scrud_view
| Schema | policy |
| Materialized View Name | auto_verification_policy_scrud_view |
| Owner | postgres |
| Tablespace | DEFAULT |
| Description | |
CREATE OR REPLACE VIEW policy.auto_verification_policy_scrud_view
AS
SELECT auto_verification_policy.user_id,
users.user_name,
auto_verification_policy.verify_sales_transactions,
auto_verification_policy.sales_verification_limit,
auto_verification_policy.verify_purchase_transactions,
auto_verification_policy.purchase_verification_limit,
auto_verification_policy.verify_gl_transactions,
auto_verification_policy.gl_verification_limit,
auto_verification_policy.effective_from,
auto_verification_policy.ends_on,
auto_verification_policy.is_active
FROM policy.auto_verification_policy
JOIN office.users ON auto_verification_policy.user_id = users.user_id;