Database Tables Used for Document Migration

The following table lists the database tables which are used for document migration and their usage

Table 20-79 Database Tables

Table Name	Usage	How the Table is Populated
AAI_DOC_MIGN_UTIL_REG	Applications which needs the Documents Migrated from OnPrem to Cloud should Register	Manualor via REST API
AAI_DOC_MIGN_PROPERTIES	Applications needto seed some of the key value pairs for a given Application	Manualor via REST API
AAI_DOC_MIGN_PROCESSOR	Internallyused by the utility to track the Document Migration Process for a given application.	Processing Table

The following table provides key and value pairs which can be added or updated by Applications in the AAI_DOC_MIGN_PROPERTIES table.

Note:

Dates provided in the query should be changed as per your requirements.

Table 20-80 Key and Value Pairs

V_APP_ID	V_PROP_KEY	V_PROP_VALUE
OFS_ECM	QUERY	select t.n_document_id FROM cm_entity_document_map t where NOT EXISTS (SELECT‘x’ FROM aai_doc_mign_processor mign WHERE mign.v_app_id = 'OFS_ECM AND mign.v_src_doc_id = t.N_DOC_ID ) and ((t.v_src_type='report' and t.n_src_id in (select r.n_repid from fct_cases r where r.n_status_key in (5, 6) and to_date(r.D_REP_LASTUPDATEDON,'DD-MM-YY') = '28-jul-2023')) or ((t.v_src_type='efile' or t.v_src_type='ack') and t.n_src_id in (select r.n_efileid from fct_case where r.n_status_key in (5, 6) and to_date(r.D_REP_LASTUPDATEDON,'DD-MM-YY') ='28-jul-2023')))
OFS_ECM	OBJECTTYPE	CRRCS
OFS_ECM	ofs_remote_user	appuser
OFS_ECM	serviceId	OFS_ECMCS