Panel | ||||||
---|---|---|---|---|---|---|
| ||||||
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 | CCPG: MS SQL College Adaptor Element | System Notes | Type | LengthMS 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.7date | |||
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 |