Schema "policy"

Tables

#	Table Name	Owner	Tablespace	Description
1	auto_verification_policy	postgres	DEFAULT
2	lock_outs	postgres	DEFAULT
3	menu_access	postgres	DEFAULT
4	menu_policy	postgres	DEFAULT
5	store_policies	postgres	DEFAULT	STORE POLICY DEFINES THE RIGHT OF USERS TO ACCESS A STORE. AN ADMINISTRATOR CAN ACCESS ALL THE stores, BY DEFAULT.
6	store_policy_details	postgres	DEFAULT
7	voucher_verification_policy	postgres	DEFAULT

Sequences

#	Sequence Name	Owner	Data Type	Start Value	Increment	Description
1	lock_outs_lock_out_id_seq	postgres	bigint	1	1
2	menu_access_access_id_seq	postgres	bigint	1	1
3	menu_policy_policy_id_seq	postgres	bigint	1	1
4	store_policies_store_policy_id_seq	postgres	bigint	1	1
5	store_policy_details_store_policy_detail_id_seq	postgres	bigint	1	1
6	voucher_verification_policy_policy_id_seq	postgres	bigint	1	1

Views

#	View Name	Owner	Tablespace	Description
1	auto_verification_policy_scrud_view	postgres	DEFAULT
2	voucher_verification_policy_scrud_view	postgres	DEFAULT

Materialized Views

#	Matview Name	Owner	Tablespace	Description

Functions

#	Function	Owner	Description
1	can_post_transaction(_login_id bigint, _user_id integer, _office_id integer, transaction_book text, _value_date date) RETURNS boolean	postgres
2	change_password(_user_name text, _current_password text, _new_password text) RETURNS boolean	postgres
3	change_password(_admin_user_id integer, _user_name text, _new_password text) RETURNS void	postgres
4	get_menu(user_id_ integer, office_id_ integer, culture_ text) RETURNS TABLE(menu_id integer, menu_text character varying, url character varying, menu_code character varying, level smallint, parent_menu_id integer)	postgres
5	get_menu_policy(_user_id integer, _office_id integer, _culture text) RETURNS TABLE(row_number bigint, access boolean, menu_id integer, menu_code text, menu_text text, url text)	postgres
6	is_elevated_user(_user_id integer) RETURNS boolean	postgres
7	is_locked_out_till(user_id integer_strict) RETURNS timestamp without time zone	postgres
8	is_restricted_mode() RETURNS boolean	postgres
9	is_transaction_restricted(_office_id integer) RETURNS boolean	postgres
10	save_menu_policy(_user_id integer, _office_id integer, _menu_ids integer[]) RETURNS void	postgres

Triggers

#	Trigger	Owner	Description
1	check_menu_policy_trigger() RETURNS TRIGGER	postgres
2	perform_lock_out() RETURNS TRIGGER	postgres

Types

#	Type	Base Type	Owner	Collation	Default	Type	StoreType	NotNull	Description