Custom Export Layout Files

If the answer is No or Null (no value), then the field will be blank.

You have the option to transform this field to Y and N, instead of Yes and blank. All No and Null values will transform to N.

You have the option to transform this field to:

• Dates without Separators (format MMddyyyy) (e.g., 04282018)
• Dates without Days and Separators (format MMyyyy) (e.g., 042018)
• Dates as Just Years (format yyyy) (e.g., 2018)

Note that due to MS Excel formatting preferences, .csv and .xls file types may automatically change the format to M/dd/yyyy (e.g., 4/28/2018). Additionally, .csv and .xls file types may automatically drop the leading zero (e.g., 42018).

You have the option to transform this field to:

• Dates without Separators (format MMddyyyy) (e.g., 10032020)
• Dates without Days and Separators (format MMyyyy) (e.g., 102020)
• Dates as Just Years (format yyyy) (e.g., 2020)

Note that due to MS Excel formatting preferences, .csv and .xls file types may automatically drop the leading zero.

These are typically CAS-calculated GPAs or official test score numbers. The values come from an official source:

• CAS-calculated GPAs are automatically calculated once an applicant's coursework is verified by Liaison's Verification team.
• Official test scores are sent to Liaison directly from the testing agency (e.g., ETS sends official GRE scores to Liaison).

Any stored lookup value in the application. You can find all lookup values in the:

• CEL documents below
• Master College Code List
• Master Degree Code List
• Master High School Code List.