Custom Export Layout Files
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:
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:
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:
|
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:
|
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 |
|||||||
AACPMAS |
|||||||
ADEA AADSAS |
|||||||
ADEA CAAPID |
|||||||
ADEA DHCAS |
|||||||
ADEA PASS |
|||||||
AHCAS |
|||||||
APPA CAS |
|||||||
ArchCAS |
|
||||||
ATCAS |
ATCAS |
||||||
BioMedCAS |
BioMedCAS |
|
|||||
BusinessCAS |
|
||||||
BU-CDS |
BU-CDS | BU-CDS | |||||
BU-CFA |
|||||||
BU-COM |
|||||||
BU-ENG |
|||||||
BU-GMS |
|||||||
BU-GRS |
|||||||
BU-MET |
BU-MET |
||||||
BU-PAR |
|||||||
BU-QST |
|||||||
BU-SAR |
|||||||
BU-SED |
|||||||
BU-SHA |
|
||||||
BU-SSW |
|||||||
BU-STH |
|||||||
Cal State Apply |
|
|
|||||
CASAA |
|||||||
CASPA |
|||||||
The Common Application for transfer |
|
||||||
CSDCAS |
CSDCAS |
||||||
EngineeringCAS |
|
||||||
GradCAS |
|
|
|||||
HAMPCAS |
|||||||
Indiana University Graduate CAS |
|
|
|
||||
Montana University System |
|
|
|
|
|||
NAFCAS |
|||||||
NDCAS |
|||||||
NursingCAS |
|||||||
OPCAS |
OPCAS |
||||||
OPRESCAS |
|
||||||
OptomCAS |
OptomCAS |
||||||
Oregon Health & Science University |
|||||||
OTACAS |
|||||||
OTCAS |
OTCAS |
||||||
PharmCAS |
PharmCAS |
||||||
PharmDirect |
|||||||
PharmGrad |
PharmGrad |
||||||
PhORCAS |
|||||||
PostbacCAS |
|
||||||
PSYCAS |
|||||||
PTACAS |
|
|
|
|
|||
PTCAS |
PTCAS |
||||||
RF-PTCAS |
|||||||
RFUCAS |
RFUCAS |
||||||
SHP CAS/CCBC |
|||||||
SocialWorkCAS |
|||||||
SOPHAS |
|||||||
SOPHAS Express |
|||||||
Stillman College |
Stillman College |
|
|||||
Texas A&M University |
|
|
|
|
|||
TMDSAS |
TMDSAS |
|
|
||||
UMHS |
|
(skipped cycle) |
|
|
|||
University of San Diego |
University of San Diego |
||||||
University of South Alabama |
|
||||||
University of Southern California |
University of Southern California |
||||||
UNMC |
UNMC |
||||||
UNMC IPAP |
|||||||
UofM Graduate School |
|
|
|||||
UTHSC |
|||||||
UTSA Graduate School |
UTSA Graduate School |
||||||
VCU Grad |
VCU Grad |
|
|
||||
VMCAS |
|||||||
Weill Cornell Graduate School |
Report Manager Data Dictionaries
These data dictionaries are specific to select reports available in the Report Manager.
- A-G Subject Report data dictionary
- Coursework data dictionary
- Evaluations Report data dictionary
- High School Coursework data dictionary
- Prerequisite Courses data dictionary
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.