Help with exact code for adding a text field to a customised tile in Portfolios

Hi All

Recently taken over Planview for my area and having a little bit of an odd issue.

So we are trying to add some new columns to one of the Work Portfolio tiles and one is giving me some grief.

Been able to add an alternate structure and a long text column without issue but trying to add a text field we have that has a 200 character limit is displayed a column with the right name but not pulling through any data into it.

Notes I had been left behind say using the same code as long text would work but is clearly not doing it and wondering what the code needs to be.

The attribute is as follows 

Code my instructions advise me to use is below which generates the column with the attribute name but showing any of the data in the attribute on the screens it has been entered on.

(SELECT lt.line_text
 FROM [DBPATH]long_text lt
 WHERE lt.key1 = 'msd_approved_by'
 AND lt.key2 = cri.cri_code) AS Approved_By_Other