...
Navigate to Admin > Mail Merge Data
The Existing Merge Field drop down contains a list of all mergeable fields reproduced below
Table | Field Name | Web Word Merge Field Name | Web Export Spreadsheet Field Name |
STBIOS | SALUTATION | Salutation | Salutation |
STBIOS | LAST_NAME | Last_Name | Last Name |
STBIOS | FIRST_NAME | First_Name | First Name |
STBIOS | MIDDLE_NAME | Middle_Name | Middle Name |
STBIOS | ID_NUMBER | Id_Number | Id Number |
STBIOS | SUFFIX | Suffix | Suffix |
STBIOS | SOCIAL_SEC_NUMBER | SSN | SSN |
STBIOS | BIRTH_DATE | Birth_Date | Birth Date |
STBIOS | NICK_NAME | Nick_Name | Nick Name |
STBIOS | SEX | Gender | Gender |
STBIOS | CONTINUING_ED_CODE | Continuing_Ed_Code | Continuing Ed Code |
Based on address type drop down selection | Address_Line_1 | NONE | |
Based on address type drop down selection | Address_Line_2 | NONE | |
Based on address type drop down selection | Address_Line_3 | NONE | |
Based on address type drop down selection | Address_Line_4 | NONE | |
Based on address type drop down selection | Address_Line_5 | NONE | |
STBIOS | HOME_ADDRESS_ONE | Home_Street1 | Home Street1 |
STBIOS | HOME_ADDRESS_TWO | Home_Street2 | Home Street2 |
STBIOS | HOME_ADDRESS_THREE | Home_Street3 | Home Street3 |
STBIOS | HOME_CITY | Home_City | Home City |
STBIOS | HOME_STATE | Home_State | Home State |
STBIOS | HOME_ZIP | Home_Zip | Home Zip |
STBIOS | HOME_ZIP_EXTENSION | Home_Zip_Ext | Home Zip Ext |
STBIOS | HOME_PROVINCE | Home_Province | Home Province |
STBIOS | HOME_COUNTRY | Home_Country | Home Country |
GENERIC! | Home Phone Number | Home_Phone | Home Phone |
STBIOS | HOME_PHONE_AREA | Home_Phone_Area | Home Phone Area |
STBIOS | HOME_PHONE_EXCHANGE | Home_Phone_Exchange | Home Phone Exchange |
STBIOS | HOME_PHONE_NUMBER | Home_Phone_Num | Home Phone Num |
STBIOS | BILLING_ADDRESS_ONE | Bill_Street1 | Bill Street1 |
STBIOS | BILLING_ADDRESS_TWO | Bill_Street2 | Bill Street2 |
STBIOS | BILLING_ADDRESS_THREE | Bill_Street3 | Bill Street3 |
STBIOS | BILLING_CITY | Bill_City | Bill City |
STBIOS | BILLING_STATE | Bill_State | Bill State |
STBIOS | BILLING_ZIP | Bill_Zip | Bill Zip |
STBIOS | BILLING_ZIP_EXTENSION | Bill_Zip_Ext | Bill Zip Ext |
STBIOS | BILLING_PROVINCE | Bill_Province | Bill Province |
STBIOS | BILLING_COUNTRY | Bill_Country | Bill Country |
GENERIC! | Billing Phone Number | Bill_Phone | Bill Phone |
STBIOS | BILLING_PHONE_AREA | Bill_Phone_Area | Bill Phone Area |
STBIOS | BILLING_PHN_EXCHANGE | Bill_Phone_Exchange | Bill Phone Exchange |
STBIOS | BILLING_PHN_NUMBER | Bill_Phone_Num | Bill Phone Num |
STBIOS | MAIL_ADDRESS_ONE | Mail_Street1 | Mail Street1 |
STBIOS | MAIL_ADDRESS_TWO | Mail_Street2 | Mail Street2 |
STBIOS | MAIL_ADDRESS_THREE | Mail_Street3 | Mail Street3 |
STBIOS | MAIL_CITY | Mail_City | Mail City |
STBIOS | MAIL_STATE | Mail_State | Mail State |
STBIOS | MAIL_ZIP | Mail_Zip | Mail Zip |
STBIOS | MAIL_ZIP_CODE_EXT | Mail_Zip_Ext | Mail Zip Ext |
STBIOS | MAIL_PROVINCE | Mail_Province | Mail Province |
STBIOS | MAIL_COUNTRY | Mail_Country | Mail Country |
GENERIC! | Mail Phone Number | Mail_Phone | Mail Phone |
STBIOS | MAIL_PHONE_AREA | Mail_Phone_Area | Mail Phone Area |
STBIOS | MAIL_PHN_EXCHANGE | Mail_Phone_Exchange | Mail Phone Exchange |
STBIOS | MAIL_PHONE_NUMBER | Mail_Phone_Num | Mail Phone Num |
STBIOS | RETURN_MAIL_CODE | Mail_Code | NONE |
STBIOS | RETURN_MAIL_CODE decoded | Mail_Code_Decoded | NONE STPARM SBRMCD |
GENERIC! | ALL MAJORS | Inq_Majors | Inq Majors |
STBIOS | ADMISSIONS_INQ_MAJOR | Adm_Inq_Major | Adm Inq Major |
STBIOS | ADMISSIONS_INQ_MAJOR decoded | Adm_Inq_Major_Decoded | Adm Inq Major Decoded |
STBIOS | ADMISSIONS_INQ_MAJ_02 | Adm_Inq_Major2 | Adm Inq Major 2 |
STBIOS | ADMISSIONS_INQ_MAJ_02 decoded | Adm_Inq_Major2_Decoded | Adm Inq Major 2 Decoded |
STBIOS | ADMISSIONS_INQ_MAJ_03 | Adm_Inq_Major3 | Adm Inq Major 3 |
STBIOS | ADMISSIONS_INQ_MAJ_03 decoded | Adm_Inq_Major3_Decoded | Adm Inq Major 3 Decoded |
STBIOS | ADMISSIONS_INQ_MINOR | Adm_Inq_Minor | Adm Inq Minor |
STBIOS | ADMISSIONS_INQ_MINOR decoded | Adm_Inq_Minor_Decoded | Adm Inq Minor Decoded |
STBIOS | ADMISSIONS_ENT_SEM | Adm_Ent_Sem | Adm Ent Sem |
STBIOS | ADMISSIONS_ENT_SEM | Adm_Ent_Sem_Decoded | Adm Ent Sem Decoded |
STBIOS | ADM_PROGRESS_CODE | Prog_Code | Prog Code |
STBIOS | ADMISSIONS_SITE | Admissions_Site | Admissions Site |
STBIOS | ADMISSIONS_SITE decoded | Admissions_Site_Decoded | Not in Export STPARM SBPRCC |
STBIOS | ADMISSIONS_RES_CODE | Resident_Code | Resident Code |
STBIOS | TRANSFER_CODE | Transfer_Code | Transfer Code |
STBIOS | HIGH_SCHOOL_CODE | High_School | High School |
STBIOS | HIGH_SCHOOL_CODE decoded | High_School_Decoded | High School Decoded |
STBIOS | PREV_ATTED_COLLEGE | Last_College | Last College |
STBIOS | PREV_ATTED_COLLEGE decoded | Last_College_Decoded | Last College Decoded |
STBIOS | ETHNIC_CODE | Ethnic_Code | Ethnic Code |
STBIOS | ETHNIC_CODE decoded | Ethnic_Code_Decoded | Ethnic Code Decoded |
STBIOS | FIN_AID_CODE | Financial_Aid_Code | Financial Aid Code |
STBIOS | FIN_AID_CODE decoded | Financial_Aid_Code_Decoded | Financial Aid Code Decoded |
STBIOS | ADMISSIONS_PT_CODE decoded | Part_Time_Code_Decoded | Part Time Code Decoded |
STBIOS | VETERAN_CODE | Veteran_Code | Veteran Code |
STBIOS | VETERAN_CODE decoded | Veteran_Code_Decoded | Veteran Code Decoded |
STBIOS | PRIVACY_CODE | Privacy_Code | Privacy Code |
STBIOS | PRIVACY_CODE decoded | Privacy_Code_Decoded | Privacy Code Decoded |
STBIOS | SITE_NUMBER | Site_Code | Site Code |
STBIOS | SITE_NUMBER decoded | Site_Code_Decoded | Site Code Decoded |
STBIOS | PREFERRED_ADDRESS_CD | Preferred_Address_Code | Preferred Address Code |
STBIOS | PREFERRED_ADDRESS_CD decoded | Preferred_Address_Code_Decoded | Preferred Address Code Decoded |
STBIOS | INTL_STUDENT_CODE | International_Student_Code | International Student Code |
STBIOS | INTL_STUDENT_CODE decoded | International_Student_Code_Decoded | International Student Code Decoded |
STBIOS | US_CITIZENSHIP | US_Citizenship | US Citizenship |
STBIOS | US_CITIZENSHIP decoded | US_Citizenship_Decoded | US Citizenship Decoded |
STBIOS | HIGH_SCHOOL_GRAD_YR | HS_Grad_Year | HS Grad Year |
STBIOS |
| Advisor_1 |
|
STBIOS |
| Advisor_1_Name |
|
STBIOS |
| Advisor_2 |
|
STBIOS |
| Advisor_2_Name |
|
STBIOS | EMPLOYER_NAME | Employer_Name |
|
STBIOS | CONTACT_FIRST_NAME +CONTACT_LAST_NAME | Contact_Name | Contact Name |
STBIOS | EMPLOYER_ADDRESS_ONE | Employer_Address1 | Employer Address1 |
STBIOS | EMPLOYER_ADDRESS_TWO | Employer_Address2 | Employer Address2 |
STBIOS | EMPLOYER_CITY | Employer_City | Employer City |
STBIOS | EMPLOYER_STATE | Employer_State | Employer State |
STBIOS | EMPLOYER_ZIP | Employer_Zip | Employer Zip |
STBIOS | EMPLOYER_COUNTRY | Employer_Country | Employer Country |
STBIOS | EMPLOYER_SORT_FIELD | Employer_Sort_Field | Employer Sort Field |
STPARM | SBCLOR (STPARM CODE) | Counselor_Name | Counselor Name |
STPARM | SBCLOX (STPARM CODE) | Counselor_Title | Counselor Title |
STPARM | SBCLOY (STPARM CODE) | Counselor_Email | Counselor Email |
STPARM | SBCLOZ (STPARM CODE) | Counselor_Phone_Number | Counselor Phone Number |
STPARM | SBCLOG (STPARM CODE) | Counselor_Gender | Counselor Gender |
ADMAST | APPLIC_DATE | App_Date | App Date |
NONE | App date decoded (does not exist?) | None | None |
ADMAST | APPLIED_FOR_MAJOR | Applied_For_Major | Applied For Major |
ADMAST | APPLIED_FOR_MAJOR decoded | Applied_For_Major_Decoded | Applied For Major Decoded |
ADMAST | ACCEPT_MAJOR | Accept_Major | Accept Major |
ADMAST | ACCEPT_MAJOR decoded | Accept_Major_Decoded | Accept Major Decoded |
ADMAST | DECISION_DATE | Decision_Date | Decision Date |
ADMAST | DECISION_DATE decoded | Decision_Date_Decoded | Decision Date Decoded |
ADMAST | SCHOOL_DECISION | School_Decision | None |
ADMAST | SCHOOL_DECISION decoded | School_Decision_Decoded | None (STPARM ACDECD) |
ADMAST | COMMITMENT_DATE | Commitment_Date | Commitment Date |
ADMAST | COMMITMENT_DATE decoded | Commitment_Date_Decoded | Commitment Date Decoded |
ADMAST | DEPOSIT_DATE | Deposit_Date | Decision Date |
ADMAST | DEPOSIT_DATE decoded | Deposit_Date_Decoded | Deposit Date Decoded |
ADMAST | DATE_ACCEPTED | Date_Accepted | Date Accepted |
ADMAST | DATE_ACCEPTED decoded | Date_Accepted_Decoded | Date Accepted Decoded |
ADMAST | DATE_REPLIED | Date_Replied | Date Replied |
ADMAST | DATE_REPLIED decoded | Date_Replied_Decoded | Date Replied Decoded |
ADMAST | APP_AMOUNT | App_Amount | App Amount |
ADMAST | TUITION_DEP_AMT | Tuition_Dep_Amount | Tuition Dep Amount |
ADMAST | HOUSING_DEP_AMT | Housing_Dep_Amount | Housing Dep Amount |
ADMAST | APP_COMPLETED | App_Completed | App Completed |
ADMAST | SCHOOL_DIV_APP | School_Div_APP | School Div APP |
ADMAST | SCHOOL_DIV_ACC | School_Div_ACC | School Div ACC |
ADMAST | ACTION_TYPE | Action_Type | Action Type |
ADMAST | ACTION_TYPE decoded | Action_Type_Decoded | Action Type Decoded |
ADMAST | COND_ACC | Cond_ACC | Cond ACC |
ADMAST | COND_ACC decoded | Cond_ACC_Decoded | Cond ACC Decoded |
SYUSER | USERNAME | Username | Username |
SYUSER | PASSWORD | Password | Password |
SYUSER | LOGIN_COUNT | Login_Count | Login Count |
SYUSER | LAST_LOGIN_DATE | Last_Login_Date | Last Login Date |
SYUSER | LAST_LOGIN_DATE decoded | Last_Login_Date_Decoded | Last Login Date Decoded |
SYUSER | MAINTENANCE_PWD | Maintenance_Password | None |
ADDTRK | PLEDGED_AMOUNT | Amount_Original | Amount_Original |
ADDTRK | AMOUNT_DUE | Amount_Due | Amount_Due |
ADDTRK | PAID_AMOUNT | Amount_Paid | Amount_Paid |
ADDTRK | FIRST_COMMENT | Comment_1 | Comment_1 |
ADDTRK | SECOND_COMMENT | Comment_2 | Comment_2 |
ADDTRK | THIRD_COMMENT | Comment_3 | Comment_3 |
ADDTRK | FOURTH_COMMENT | Comment_4 | Comment_4 |
ADDTRK | FIFTH_COMMENT | Comment_5 | Comment_5 |
ADDTRK | SIXTH_COMMENT | Comment_6 | Comment_6 |
ADDTRK | SEVENTH_COMMENT | Comment_7 | Comment_7 |
ADDTRK | EIGHT_COMMENT | Comment_8 | Comment_8 |
ADDTRK | FIRST_REQ_DATE | Request_Date |
|
STSALU | FORMAL_CODE | Formal_Code | Formal_Code |
STSALU | FORMAL_SAL | Formal_Sal | Formal_Sal |
STSALU | FORMAL_DEAR | Formal_Dear | Formal_Dear |
STSALU | INFORMAL_CODE | Informal_Code | Informal_Code |
STSALU | INFORMAL_SAL | Informal_Sal | Informal_Sal |
STSALU | INFORMAL_DEAR | Informal_Dear | Informal_Dear |
STSALU | ALUMNI_CODE | Alumni_Code | Alumni_Code |
STSALU | ALUMNI_SAL_1 | Alumni_Sal_1 | Alumni_Sal_1 |
STSALU | ALUMNI_SAL_2 | Alumni_Sal_2 | Alumni_Sal_2 |
STSALU | ALUMNI_DEAR | Alumni_Dear | Alumni_Dear |
STSALU | VERY_INFORMAL_CODE | Very_Informal_Code | Very_Informal_Code |
STSALU | VERY_INFORMAL_SAL | Very_Informal_Sal | Very_Informal_Sal |
STSALU | VERY_INFORMAL_DEAR | Very_Informal_Dear | Very_Informal_Dear |
STSALU | CUSTOM_CODE | Custom_Code | Custom_Code |
STSALU | CUSTOM_SAL | Custom_Sal | Custom_Sal |
STSALU | CUSTOM_DEAR | Custom_Dear | Custom_Dear |
STSALU | CUSTOM_CODE_2 | Custom_Code_2 |
|
STSALU | CUSTOM_SAL_2 | Custom_Sal_2 |
|
STSALU | CUSTOM_DEAR_2 | Custom_Dear_2 |
|
STSALU | RECOGNITION_SAL | Recognition_Sal |
|
STSALU | Based on Salutation Selection | Formatted_Sal | NONE |
STSALU | Based on Salutation Selection | Formatted_Dear | NONE |
ALFUND | FUND_DESCRIPTION_1 | Fund_Description | NONE |
ALDONA | NON_DEDUCT_AMT | Non_Deductible_Amount | NONE |
ALDONA | COMMENT | Gift_Comment_1 | NONE |
ALDONA | COMMENT_TWO | Gift_Comment_2 | NONE |
ALDONA | AMOUNT_PAID | Paid_To_Date | NONE |
ALDONA | APPEAL | Appeal_Code |
|
|
| Appeal_Code_Decoded |
|
ALDONA | CAMPAIGN | Campaign_Code |
|
|
| Campaign_Code_Decoded |
|
ALDONA | IN_MEMORIAM_CONS_NUM | In_Memoriam_Cons_Num |
|
|
| In_Memoriam_Name |
|
ALDONA | GIFT_PURPOSE | Gift_Purpose |
|
ALDONA | MATCH_GIFT_CONS_NUM | MG_Constituent_Number |
|
|
| MG_Constituent_Name |
|
ALDONA | PRIMARY_CONS | Primary_Cons_Code |
|
|
| Primary_Cons_Code_Decoded |
|
ALDONA | REQUEST_DATE | Request_Date |
|
TRK | COURSE_NUMBER / COURSE_SECTION | Course_And_Section |
|
TRK | CURRENT_SEMESTER | Course_Semester |
|
TRK | REG_SYLLABUS_OID | Syllabus_Decoded |
|
RGCRSE | PROF_ID_NUMBER (Name) | Instructor |
|
RGCRSE | BEGIN_DATE | Course_Start_Date |
|
RGCRSE | END_DATE | Course_End_Date |
|
RGCRSE | COURSE_TITLE | Course_Title |
|
RGENRL | ENROLLMENT_DATE | Enrollment_Start | NONE |
RGENRL | ENROLLMENT_END_DATE | Enrollment_End | NONE |
RGENRL | LAST_ATTEND_DATE | Last_Attend_Date | NONE |
NONE | Will output a ‘$’ without quotes | Dollar_Sign | NONE |
TRK | DUE_DATE | Due_Date | NONE |
TRK | SUBMITTED_DATE | Submitted_Date | NONE |
TRK | COMPLETED_DATE | Completed_Date | NONE |
TRK | DUE_TIME | Due_Time | NONE |
TRK | SUBMITTED_TIME | Submitted_Time | NONE |
RGDEGR | DEGREE_MAJOR | Degree_Major | NONE |
RGDEGR | DEGREE_MAJOR Decoded | Degree_Major_Decoded | NONE |
When using the school finder sub-module – use the address_line_x solution when a formatted address is needed | |||
ADSCHL | SCHOOL_NAME | Name | No Export on School Finder |
ADSCHL | ALPHA_SORT_FIELD | Sort_Name | No Export on School Finder |
ADSCHL | SCHOOL_CODE | CEEB | No Export on School Finder |
ADSCHL | SCHOOL_SUFFIX | Suffix | No Export on School Finder |
ADSCHL | ADDRESS_ONE | Street1 (use Address_Line_X) | No Export on School Finder |
ADSCHL | ADDRESS_TWO | Street2 (use Address_Line_X) | No Export on School Finder |
ADSCHL | ADDRESS_THREE | Street3 (use Address_Line_X) | No Export on School Finder |
ADSCHL | CITY | City (use Address_Line_X) | No Export on School Finder |
ADSCHL | STATE | State (use Address_Line_X) | No Export on School Finder |
ADSCHL | ZIP | Zip (use Address_Line_X) | No Export on School Finder |
ADSCHL | ZIP_EXTENSION | Zip_Ext (use Address_Line_X) | No Export on School Finder |
ADSCHL | COUNTRY | Country (use Address_Line_X) | No Export on School Finder |
ADSCHL | PROVINCE | Province (use Address_Line_X) | No Export on School Finder |
ADSCHL | AREA_CODE+EXCHANGE+PHONE | Phone | No Export on School Finder |
ADSCHL | CONTACT_FIRST_NAME | First_Name* | No Export on School Finder |
ADSCHL | CONTACT_MID_NAME | Middle_Name* | No Export on School Finder |
ADSCHL | CONTACT_LAST_NAME | Last_Name* | No Export on School Finder |
ADSCHL | CONTACT_TITLE | Title* | No Export on School Finder |
ADSCHL | EMAIL_ADDRESS | Email* | No Export on School Finder |
View AR_BALANCE_WITH_AID | AMOUNT_DUE | Amount_Due_AR_Bal | None |
View AR_BALANCE_WITH_AID | TOTAL_BALANCE | Actual_Cash_Balance | None |
*This data is associated with the contact information of the school. For example, a school counselor or administrator |
...