I have created a number of SQL queries in ssms to list table details, and the app/espace they are related to.
See Code sample below....

I'm wondering if someone can advise table(s) related to Data Type in Outsystems...
When I run the query below, in the "Field Type" Column I'm getting a lot of fields with text Similar to: bt29049529-f47d-4a6b-bda0-63d3dff02e3b*24ace1e0-e2.. I'd like to be able to link these to human readable text, like:  "Rhubarb Record Identifier", or similar.. 

(Is there a better way to do this??  I find the extracts great, because they list APP, ESPACE, data Kind, table name, phyical table name, and also details of the table..)

(I have a similar query - attached which gets column information from the INFORMATION_SCHEMA.COLUMNS which lists actual data types, but would like the outsystems details..)

eg:
SELECT
       APP.NAME "App Name",
       /* app.DESCRIPTION, */
      /* modu.ESPACE_ID, */
      ESP.NAME "ESpace Name",
      /* ENT.ID "Entity ID", */
      ENT.Data_Kind,
      ENT.NAME "Table Name",
      ENT.PHYSICAL_TABLE_NAME,
      ea.NAME "Field Name",
      ea.DESCRIPTION,
      isnull(bt.Name, ea.type) "Field Type",
      ea.length "Field Length",
      ea.decimals,
      ea.DEFAULT_LABEL,
      ea.DEFAULT_VALUE
  FROM CATALOG.dbo.OSSYS_APPLICATION APP,
       CATALOG.dbo.OSSYS_APP_DEFINITION_MODULE APP_MOD,
       CATALOG.dbo.OSSYS_MODULE MODU,
       CATALOG.dbo.OSSYS_ESPACE ESP,
       CATALOG.dbo.OSSYS_Entity ENT,
       CATALOG.dbo.OSSYS_Entity_attr EA
  LEFT JOIN CATALOG.dbo.OSSYS_BASIC_TYPE bt
    on ea.type = bt.id
  where APP_MOD.APPLICATION_ID = APP.ID
    and charindex('RHUBARB', upper(APP.name)) > 0  /* Comment this line out for all APP */
    and APP.IS_ACTIVE = 1
    and MODU.ID = APP_MOD.MODULE_ID
    and ESP.ID  = modu.ESPACE_ID
    and ESP.IS_ACTIVE = 1
    and ENT.ESPACE_ID = modu.ESPACE_ID
    and ENT.IS_ACTIVE = 1
    and ENT.IS_SYSTEM = 0
    and ea.ENTITY_ID = Ent.id
  ORDER BY APP.NAME, ESP.NAME,
   ENT.Data_Kind DESC,
   ENT.NAME, ENT.PHYSICAL_TABLE_NAME, ea.ORDER_NUM