The tables below reflect the latest version of the CC Promise Grant Online Application.
CC Promise Grant Data Fields Table Mapping - MSQL
For more details, see the latest CC Promise Grant Application data dictionary.
CCPG: Data Element | CCPG: College Adaptor Element | System Notes | Type | Length | ||
accepted_terms | acceptedTerms | 4.7 | ||||
accepted_terms_timestamp | acceptedTermsTimestamp | 4.7 | ||||
ack_fin_aid | ackFinAid | |||||
address_verified_override | addressValidationOverride | 4.6 | ||||
address_verified_override_timestamp | addressValidationOverrideTimestamp | 4.6 | ||||
app_id | appId | |||||
app_lang | appLang | |||||
birthdate | birthdate | |||||
born_before_23_year | bornBefore23Year | |||||
campaign1 | campaign1 | |||||
campaign2 | campaign2 | |||||
campaign3 | campaign3 | |||||
ccc_id | ccId | |||||
cert_national_guard | certNationalGuard | |||||
cert_veteran_affairs | certVeteranAffairs | |||||
city | city | |||||
college_id | collegeId | |||||
college_name | collegeName | |||||
confirmation_applicant | confirmationApplicant | |||||
confirmation_number | confirmationNumber | |||||
confirmation_parent_guardian | confirmationParentGuardian | |||||
country | country | |||||
dep_gross_income | depGrossIncome | |||||
dep_number_household | depNumberHousehold | |||||
dep_other_income | depOtherIncome | |||||
dep_total_income | depTotalIncome | |||||
dependency_status | dependencyStatus | |||||
dependent_on_parent_taxes | dependentOnParentTaxes | |||||
dependents | dependents | |||||
determined_ab540_eligible | determinedAB540Eligible | |||||
determined_homeless | determinedHomeless | |||||
determined_non_res_exempt | determinedNonResExempt | |||||
determined_residentca | determinedResidentca | |||||
elig_bogfw | eligBogfw | |||||
elig_covid_death | eligCovidDeath | |||||
elig_exonerated_crime | eligExoneratedCrime | |||||
elig_medal_honor | eligMedalHonor | |||||
elig_method_a | eligMethodA | |||||
elig_method_b | eligMethodB | |||||
elig_method_d | eligMethodD | |||||
elig_police_fire | eligPoliceFire | |||||
elig_sept_11 | eligSept11 | |||||
email_verified | emailVerified | |||||
email_verified_timestamp | emailVerifiedTimestamp | |||||
emancipated_minor | emancipatedMinor | |||||
firstname | firstname | |||||
general_assistance | generalAssistance | |||||
homeless_youth_hud | homelessYouthHud | |||||
homeless_youth_other | homelessYouthOther | |||||
homeless_youth_school | homelessYouthSchool | |||||
ind_gross_income | indGrossIncome | |||||
ind_number_household | indNumberHousehold | |||||
ind_other_income | indOtherIncome | |||||
ind_total_income | indTotalIncome | |||||
ip_address | ipAddress | |||||
ip_address_at_account_creation | ipAddressAtAccountCreation | 4.7 | ||||
ip_address_at_app_creation | ipAddressAtAppCreation | 4.7 | ||||
last_page | lastPage | |||||
lastname | lastname | |||||
legal_guardianship | legalGuardianship | |||||
living_with_parents | livingWithParents | |||||
mailing_address_validation_override | mailingAddressValidationOverride | 4.7 | date | |||
mainphone | mainphone | |||||
mainphone_auth_text | mainphoneAuthText | |||||
mainphone_ext | mainphoneExt | |||||
mainphoneintl | mainphoneintl | |||||
marital_status | maritalStatus | |||||
married_or_rdp | marriedOrRdp | |||||
middlename | middlename | |||||
no_mailing_address_homeless | noMailingAddressHomeless | |||||
no_perm_address_homeless | noPermAddressHomeless | |||||
non_us_address | nonUsAddress | |||||
otherfirstname | otherfirstname | |||||
otherlastname | otherlastname | |||||
othermiddlename | othermiddlename | |||||
parent_guardian_name | parentGuardianName | |||||
parents_assistance | parentsAssistance | |||||
parents_deceased | parentsDeceased | |||||
phone_type | phoneType | 4.7 | ||||
phone_verified | phoneVerified | |||||
phone_verified_timestamp | phoneVerifiedTimestamp | |||||
postalcode | postalcode | |||||
preferred_contact_method | preferredMethodOfContact | |||||
preferred_firstname | preferredFirstname | |||||
preferred_lastname | preferredLastname | |||||
preferred_middlename | preferredMiddlename | |||||
preferred_name | preferredName | |||||
province | province | |||||
reg_dom_partner | regDomPartner | |||||
sis_receipt | ||||||
ssi_ssp | ssiSsp | |||||
ssn | ssn | |||||
ssn_exception | ssnException | |||||
ssn_last4 | ssnLast4 | |||||
ssn_no | ssnNo | |||||
ssn_type | ssnType | |||||
state | state | |||||
status | status | |||||
streetaddress1 | streetaddress1 | |||||
streetaddress2 | streetaddress2 | |||||
student_college_id | studentCollegeId | |||||
student_parent | studentParent | 4.7 | ||||
tanf_calworks | tanfCalworks | |||||
term_code | termCode | NOT USED IN CCPG | ||||
tstmp_create | tstmpCreate | |||||
tstmp_download | tstmpDownload | |||||
tstmp_submit | tstmpSubmit | |||||
tstmp_update | tstmpUpdate | |||||
us_veteran | usVeteran | |||||
year_code | yearCode | |||||
year_description | yearDescription |