Custom Export Layout Files

Last updated
Save as PDF

Custom Export Field Layout (CEL) documents are Excel files that list all the available fields in the Export Manager and Report Manager. They include each field name, field type (numeric, Boolean, etc.), and associated lookup tables. These files can help IT teams anticipate what will be exported, which is useful information when importing WebAdMIT data into a separate Student Information System (SIS).

Additionally, you can access the master code lists for select data. These master code lists include all the possible values for select data, but due to the number of possible values, they are stored separately from the standard CEL.

Field Type Descriptions

Each field follows a specific format. You can find a description of each format below.

Field Type	Example Format	Additional Notes
Boolean	Yes	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.
Date	2018-04-28 (format yyyy-MM-dd)	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).
Datetime	Oct 3, 2020 at 3:51 PM (format MMM d, yyyy at h:mm tt)	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.
Float	Overall Total GPA is 3.66	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).
Integer	3	Only whole numbers.
Lookup	TE-Approved for Professional Transcript Entry (PTE) statuses	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.
Numeric	15	Any numeric value, including decimals.
String	Abigail	Any alphanumeric text fields.
Time	9:40 AM (format h:mm tt)	Available only for Interview times.
User Defined	N/A	This field type is used for any program questions you create in the Configuration Portal. Depending on how you configure your questions, the answer values will follow the field type options above (e.g., an Essay type question will be a string field type).

CEL Document Downloads

To download a CEL, locate your desired CAS and cycle and click the corresponding link. CELs published prior to the application’s launch date are drafts and will be updated once the application opens. You can view your CAS’s application cycle dates in the CAS Program User Guides.

CAS Name	2022-23 Cycle	2021-22 Cycle	2020-21 Cycle	2019-20 Cycle	2018-19 Cycle	2017-18 Cycle	2016-17 Cycle
AACOMAS	AACOMAS	AACOMAS	AACOMAS	AACOMAS	AACOMAS	AACOMAS	AACOMAS
AACPMAS		AACPMAS	AACPMAS	AACPMAS	AACPMAS	AACPMAS	AACPMAS
ADEA AADSAS	ADEA AADSAS	ADEA AADSAS	ADEA AADSAS	ADEA AADSAS	ADEA AADSAS	ADEA AADSAS	ADEA AADSAS
ADEA CAAPID	ADEA CAAPID	ADEA CAAPID	ADEA CAAPID	ADEA CAAPID	ADEA CAAPID	ADEA CAAPID	ADEA CAAPID
ADEA DHCAS		ADEA DHCAS	ADEA DHCAS	ADEA DHCAS	ADEA DHCAS	ADEA DHCAS	ADEA DHCAS
ADEA PASS	ADEA PASS	ADEA PASS	ADEA PASS	ADEA PASS	ADEA PASS	ADEA PASS	ADEA PASS
AHCAS		AHCAS	AHCAS	AHCAS	AHCAS	AHCAS	AHCAS
APPA CAS		APPA CAS	APPA CAS	APPA CAS	APPA CAS	APPA CAS	APPA CAS
ArchCAS		ArchCAS	ArchCAS	ArchCAS	ArchCAS	ArchCAS
ATCAS	ATCAS	ATCAS	ATCAS	ATCAS	ATCAS	ATCAS	ATCAS
BioMedCAS	BioMedCAS	BioMedCAS	BioMedCAS	BioMedCAS	BioMedCAS	BioMedCAS
BusinessCAS		BusinessCAS	BusinessCAS	BusinessCAS	BusinessCAS	BusinessCAS
BU-CDS		BU-CDS	BU-CDS
BU-CFA		BU-CFA	BU-CFA	BU-CFA	BU-CFA	BU-CFA	BU-CFA
BU-COM		BU-COM	BU-COM	BU-COM	BU-COM	BU-COM	BU-COM
BU-ENG		BU-ENG	BU-ENG	BU-ENG	BU-ENG	BU-ENG	BU-ENG
BU-GMS		BU-GMS	BU-GMS	BU-GMS	BU-GMS	BU-GMS	BU-GMS
BU-GRS		BU-GRS	BU-GRS	BU-GRS	BU-GRS	BU-GRS	BU-GRS
BU-MET	BU-MET	BU-MET	BU-MET	BU-MET	BU-MET	BU-MET	BU-MET
BU-PAR		BU-PAR	BU-PAR	BU-PAR	BU-PAR	BU-PAR	BU-PAR
BU-QST		BU-QST	BU-QST	BU-QST	BU-QST	BU-QST	BU-QST
BU-SAR		BU-SAR	BU-SAR	BU-SAR	BU-SAR	BU-SAR	BU-SAR
BU-SED		BU-SED	BU-SED	BU-SED	BU-SED	BU-SED	BU-SED
BU-SHA		BU-SHA	BU-SHA	BU-SHA	BU-SHA	BU-SHA
BU-SSW		BU-SSW	BU-SSW	BU-SSW	BU-SSW	BU-SSW	BU-SSW
BU-STH		BU-STH	BU-STH	BU-STH	BU-STH	BU-STH	BU-STH
Cal State Apply	Cal State Apply	Cal State Apply	Cal State Apply	Cal State Apply	Cal State Apply
CASAA	CASAA	CASAA	CASAA	CASAA	CASAA	CASAA	CASAA
CASPA	CASPA	CASPA	CASPA	CASPA	CASPA	CASPA	CASPA
The Common Application for transfer	The Common Application for transfer	The Common Application for transfer	The Common Application for transfer	The Common Application for transfer	The Common Application for transfer	The Common Application for transfer
CSDCAS	CSDCAS	CSDCAS	CSDCAS	CSDCAS	CSDCAS	CSDCAS	CSDCAS
EngineeringCAS		EngineeringCAS	EngineeringCAS	EngineeringCAS	EngineeringCAS	EngineeringCAS
GradCAS		GradCAS	GradCAS	GradCAS	GradCAS
HAMPCAS		HAMPCAS	HAMPCAS	HAMPCAS	HAMPCAS	HAMPCAS	HAMPCAS
Indiana University Graduate CAS	Indiana University	Indiana University	Indiana University	Indiana University
Montana University System	Montana University System	Montana University System	Montana University System
NAFCAS		NAFCAS	NAFCAS	NAFCAS	NAFCAS	NAFCAS	NAFCAS
NDCAS		NDCAS	NDCAS	NDCAS	NDCAS	NDCAS	NDCAS
NursingCAS		NursingCAS	NursingCAS	NursingCAS	NursingCAS	NursingCAS	NursingCAS
OPCAS	OPCAS	OPCAS	OPCAS	OPCAS	OPCAS	OPCAS	OPCAS
OPRESCAS		OPRESCAS	OPRESCAS	OPRESCAS	OPRESCAS	OPRESCAS
OptomCAS	OptomCAS	OptomCAS	OptomCAS	OptomCAS	OptomCAS	OptomCAS	OptomCAS
Oregon Health & Science University		Oregon Health & Science University	Oregon Health & Science University	Oregon Health & Science University	Oregon Health & Science University	Oregon Health & Science University	Oregon Health & Science University
OTACAS		OTACAS	OTACAS	OTACAS	OTACAS	OTACAS	OTACAS
OTCAS	OTCAS	OTCAS	OTCAS	OTCAS	OTCAS	OTCAS	OTCAS
PharmCAS	PharmCAS	PharmCAS	PharmCAS	PharmCAS	PharmCAS	PharmCAS	PharmCAS
PharmDirect		PharmDirect	PharmDirect	PharmDirect	PharmDirect	PharmDirect	PharmDirect
PharmGrad	PharmGrad	PharmGrad	PharmGrad	PharmGrad	PharmGrad	PharmGrad	PharmGrad
PhORCAS		PhORCAS	PhORCAS	PhORCAS	PhORCAS	PhORCAS	PhORCAS
PostbacCAS		PostbacCAS	PostbacCAS	PostbacCAS	PostbacCAS	PostbacCAS
PSYCAS		PSYCAS	PSYCAS	PSYCAS	PSYCAS	PSYCAS	PSYCAS
PTACAS		PTACAS	PTACAS
PTCAS	PTCAS	PTCAS	PTCAS	PTCAS	PTCAS	PTCAS	PTCAS
RF-PTCAS		RF-PTCAS	RF-PTCAS	RF-PTCAS	RF-PTCAS	RF-PTCAS	RF-PTCAS
RFUCAS	RFUCAS	RFUCAS	RFUCAS	RFUCAS	RFUCAS	RFUCAS	RFUCAS
SHP CAS/CCBC		SHP CAS	SHP CAS/CCBC	CCBC	CCBC	CCBC	CCBC
SocialWorkCAS		SocialWorkCAS	SocialWorkCAS	SocialWorkCAS	SocialWorkCAS	SocialWorkCAS	SocialWorkCAS
SOPHAS		SOPHAS	SOPHAS	SOPHAS	SOPHAS	SOPHAS	SOPHAS
SOPHAS Express		SOPHAS Express	SOPHAS Express	SOPHAS Express	SOPHAS Express	SOPHAS Express	SOPHAS Express
Stillman College	Stillman College	Stillman College	Stillman College	Stillman College	Stillman College	Stillman College
Texas A&M University		Texas A&M	Texas A&M
TMDSAS	TMDSAS		TMDSAS	TMDSAS	TMDSAS	TMDSAS
UMHS			UMHS	(skipped cycle)	UMHS
University of San Diego	University of San Diego	University of San Diego	University of San Diego	University of San Diego	University of San Diego	University of San Diego	University of San Diego
University of South Alabama		University of South Alabama	University of South Alabama	University of South Alabama	University of South Alabama	University of South Alabama
University of Southern California	University of Southern California	University of Southern California	University of Southern California	University of Southern California	University of Southern California	University of Southern California	University of Southern California
UNMC	UNMC	UNMC	UNMC	UNMC	UNMC	UNMC	UNMC
UNMC IPAP		UNMC IPAP	UNMC IPAP	UNMC IPAP	UNMC IPAP	UNMC IPAP	UNMC IPAP
UofM Graduate School		UofM Graduate School	UofM Graduate School	UofM Graduate School	UofM Graduate School
UTHSC		UTHSC	UTHSC	UTHSC	UTHSC	UTHSC	UTHSC
UTSA Graduate School	UTSA Graduate School	UTSA Graduate School
VCU Grad	VCU Grad	VCU Grad	VCU Grad	VCU Grad	VCU Grad
VMCAS	VMCAS	VMCAS	VMCAS	VMCAS	VMCAS	VMCAS	VMCAS
Weill Cornell Graduate School		Weill Cornell Graduate School	Weill Cornell Graduate School	Weill Cornell Graduate School	Weill Cornell Graduate School	Weill Cornell Graduate School	Weill Cornell Graduate School

Report Manager Data Dictionaries

These data dictionaries are specific to select reports available in the Report Manager.

Additionally, if your CAS provides partial (i.e., limited) viewing rights for an application status, you can download a prefabricated report of applicant data; review this Partial View data dictionary.

Master Code Lists

Master College Code List

Download the Master College Code List for a holistic list of all college names and their respective codes. Every college contained in the Master College Code List has an MDB code. If available, its CEEB, FICE, and/or IPED code is also listed.

MDB: Liaison’s unique college code.
CEEB: College Entrance Examination Board code.
FICE: Federal Interagency Committee on Education code.
IPED: Integrated Postsecondary Education Data System code.

If a college is accredited, the accreditation agency is also listed. This document is useful when extracting college data through the Export Manager and Report Manager.

The Master College Code List is very comprehensive since Liaison has:

Added colleges and universities to this list over the past 20+ years,
Created a unique MDB code for each institution, and
Retained information for institutions that may have since closed.

Be sure to check out our other code lists:

Custom Export Field Layout files for all available fields.
Master Degree Code List for college degree data.
Master High School Code List for high school data.

College Code Updates

May 9, 2022 Updates

BRANDMAN UNIVERSITY (CALIFORNIA) was updated to UNIVERSITY OF MASSACHUSETTS GLOBAL
The CEEB code for PHILADELPHIA COLLEGE OF OSTEOPATHIC MEDICINE - PHILADELPHIA, PA and PHILADELPHIA COLLEGE OF OSTEOPATHIC MEDICINE - SUWANEE, GA was updated to 2662

April 8, 2022 Updates

The accrediting agency for WEST VIRGINIA UNIVERSITY - MORGANTOWN was updated to Higher Learning Commission

March 6, 2022 Updates

Numerous changes due to the Shared Lookup Table Updates for Spring 2022

The Master College Code List was last updated on May 9, 2022.

Master Degree Code List

Master High School Code List

Download the Master High School Code List for a holistic list of all high school names and their respective CEEB codes. This document is useful when extracting high school data through the Export Manager and Report Manager.

Be sure to check out our other code lists:

Custom Export Field Layout files for all available fields
Master College Code List for college data
Master Degree Code List for college degree data

High School Code Updates

May 13, 2021 Updates

Numerous high schools hidden on the Applicant Portal. Applicants can no longer select these high schools.

April 5, 2021 Updates

Numerous changes due to the Shared Lookup Table Updates for Spring 2021

The Master High School Code List was last updated on May 14, 2021.