# Change_log

Guidance:
This is a Documentation tool developed for QBE Banca Team data usage. 
This tool can be used to Add/ Delete/ Modify/ Lookup Documentations of currently 3 usages: 

1. Key Measurements SQL: Definition of frequent used business measures and their recommented SQL queries.  
Users can find records by searching their wantted measure name. 
For example, get the definition of "Inforced policy" by searching "Inforce".

2. Database Documentation: The documentation for Banca Team's frequent used databases. 
Users can find the description and other details of the fields for each of the table. 
The records can be looked up by searching their "Schema", "Table" and/or "Field".

3. Marco Polo Dashboards: The documentation for the most used and useful Marco Polo Dashboards.
Users can get the description and the links to frequent used dashboards on Marco Polo.
Records can be find by eitehr search for the "Dashboard name" or just by the "key words" of your desired dimension of data.

There are two different portal entries:

One is the developer-end which I call it "Maintainance portal", members in data team can use this portal to add/ delete/ modify/ lookup the contents of the documentations.

The other one is the user-end which will be distributed to users for them to look up the contents of documentations.


# Table_description

Description:
This is the most fondamental table in transaction level which includes basic information about the transaction of each policy


Description:
This is a suplimentary table to theTAL_CHDRPF which is also in transaction level.
Banca Team often use this table to get the catlog code for policies


Description:
This is a client level table which is often used to retrieve client information based on their client number


