The tables below reflect the latest version of the CC Promise Grant Online Application.
CC Promise Grant Data Fields Table Mapping - MS SQL
For more details, see the latest CC Promise Grant Application data dictionary.
CCPG Db Data Element | MS SQL College Adaptor Element | System Notes | MS SQL Table | MS SQL Field |
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 | ||
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 |