Table m_extract_master

Description:
Master file for extracts. Contains names for the extract id

PRIMARY KEY
m_extract_id_i integer default: 0 NOT NULL	Identifier for the extract

UNIQUE KEY
m_extract_name_c varchar (50) NOT NULL	Short name for the extract to be used in filenames

m_extract_desc_c varchar (160)	This is a long description for the extract
m_last_ref_d date
m_deletable_l boolean default: '1' NOT NULL
m_frozen_l boolean default: '0' NOT NULL	The user can set the frozen field when the extract should not be updated.
m_key_count_i integer default: 0
m_public_l boolean default: '1' NOT NULL
m_manual_mod_l boolean default: '0' NOT NULL	Indicates that the extract has been edited by a user
m_manual_mod_d date	Date the extract was manually modified
m_manual_mod_by_c varchar (20)	Who made the last manual modification ?	s_user
m_extract_type_code_c varchar (50)	Indicate the extract type. Which function was the extract created through?	m_extract_type
m_template_l boolean default: '0'	Is this extract just a template that has not yet been run?
m_restricted_l boolean default: '0'	Indicates whether or not the extract has restricted access. If it does then the access will be controlled by s_group_extract
s_date_created_d date default: CURRENT_DATE	The date the record was created.
s_created_by_c varchar (20)	User ID of who created this record.	s_user
s_date_modified_d date	The date the record was modified.
s_modified_by_c varchar (20)	User ID of who last modified this record.	s_user
s_modification_id_t timestamp default: CURRENT_TIMESTAMP	This identifies the current version of the record.
FOREIGN KEY m_extract_master_fk3: m_manual_mod_by_c => s_user m_extract_master_fk4: m_extract_type_code_c => m_extract_type m_extract_master_fkcr: s_created_by_c => s_user m_extract_master_fkmd: s_modified_by_c => s_user
REFERENCED BY m_extract_parameter, m_extract, s_group_extract