CURRENT_STATUS and MODIFIED attributes in table: PROJECTS

[MikeZBi]

Do we still plan to have these two attributes in the table PROJECTS?

MODIFIED AS (EID + ' ' + CHANGE_DATE)
CURRENT_STATUS AS (STATUS_TYPE + ' : ' + COMMENT)

Seems similar to the problem of LOCATION in the DEPARTMENTS table?

[if2159]

We may consider moving the updates to a different table that just stores the date it was changed, what project was changed, and who changed it.

[MikeZBi]

Just need to write a function to go along with it to give the STATUS_DESCRIPTION instead of just the int which is STATUS_TYPE

[if2159]

These attributes have been removed from the PROJECTS table. Still need to consider creating a new table for them.