Data model — Virtual data fields

Working as a Guidewire for a while , I usually work more and think less , when I tried to use a data field, I just found it out in data dictionary and used it . Recently , I had job interview because my contract is going to end soon , during the interview , the interview asked what is a virtual field , I found that I couldn’t give the definition clearly . This is too bad and I may lose a good chance because this. Here , I want to explain what it is in case others or myself want to review it later.

• Data fields can be physical fields or virtual fields in data model
• physical fields can be stored in a given db table’s columns
• Virtual fields are defined in code and won’t be stored in db table, for example : a virtual field — Fullname = FirstName+MiddleName+LastName , the field FullName will be generated by code which will add FirstName,MiddleName and LastName.
• in the data model portal page , for a virtual field, there will be a “virtual property” in the property description .