...
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 |
student_deps_18over | studentDeps18Over | SG 4.10 | CC_PROMISE_GRANT_STG | studentDeps18Over |
student_deps_Under18 | studentDepsUnder18 | SG 4.10 | CC_PROMISE_GRANT_STG | studentDepsUnder18 |
idme_confirmation_timestamp | idmeConfirmationTimestamp | SG 4.9 | CC_PROMISE_GRANT_STG | idmeConfirmationTimestamp |
idme_optin_timestamp | idmeOptinTimestamp | SG 4.9 | CC_PROMISE_GRANT_STG | idmeOptinTimestamp |
idme_workflow_status | idmeWorkflowStatus | SG 4.9 | CC_PROMISE_GRANT_STG | idmeWorkflowStatus |
accepted_terms | acceptedTerms | 4.7 | CC_PROMISE_GRANT_STG | acceptedTerms |
accepted_terms_timestamp | acceptedTermsTimestamp | 4.7 | CC_PROMISE_GRANT_STG | acceptedTermsTimestamp |
ack_fin_aid | ackFinAid | CC_PROMISE_GRANT_STG | ackFinAid | |
address_verified_override | addressValidationOverride | 4.6 | CC_PROMISE_GRANT_STG | addressValidationOverride |
address_verified_override_timestamp | addressValidationOverrideTimestamp | 4.6 | CC_PROMISE_GRANT_STG | addressValidationOverrideTimestamp |
app_id | appId | CC_PROMISE_GRANT_STG | appId | |
app_lang | appLang | CC_PROMISE_GRANT_STG | appLang | |
birthdate | birthdate | CC_PROMISE_GRANT_STG | birthdate | |
born_before_23_year | bornBefore23Year | CC_PROMISE_GRANT_STG | bornBefore23Year | |
campaign1 | campaign1 | CC_PROMISE_GRANT_STG | campaign1 | |
campaign2 | campaign2 | CC_PROMISE_GRANT_STG | campaign2 | |
campaign3 | campaign3 | CC_PROMISE_GRANT_STG | campaign3 | |
ccc_id | ccId | CC_PROMISE_GRANT_STG | cccId | |
cert_national_guard | certNationalGuard | CC_PROMISE_GRANT_STG | certNationalGuard | |
cert_veteran_affairs | certVeteranAffairs | CC_PROMISE_GRANT_STG | certVeteranAffairs | |
city | city | CC_PROMISE_GRANT_STG | city | |
college_id | collegeId | CC_PROMISE_GRANT_STG | collegeId | |
college_name | collegeName | CC_PROMISE_GRANT_STG | collegeName | |
confirmation_applicant | confirmationApplicant | CC_PROMISE_GRANT_STG | confirmationApplicant | |
confirmation_number | confirmationNumber | CC_PROMISE_GRANT_STG | confirmationNumber | |
confirmation_parent_guardian | confirmationParentGuardian | CC_PROMISE_GRANT_STG | confirmationParentGuardian | |
country | country | CC_PROMISE_GRANT_STG | country | |
dep_gross_income | depGrossIncome | CC_PROMISE_GRANT_STG | depGrossIncome | |
dep_number_household | depNumberHousehold | CC_PROMISE_GRANT_STG | depNumberHousehold | |
dep_other_income | depOtherIncome | CC_PROMISE_GRANT_STG | depOtherIncome | |
dep_total_income | depTotalIncome | CC_PROMISE_GRANT_STG | depTotalIncome | |
dependency_status | dependencyStatus | CC_PROMISE_GRANT_STG | dependencyStatus | |
dependent_on_parent_taxes | dependentOnParentTaxes | CC_PROMISE_GRANT_STG | dependentOnParentTaxes | |
dependents | dependents | CC_PROMISE_GRANT_STG | dependents | |
determined_ab540_eligible | determinedAB540Eligible | CC_PROMISE_GRANT_STG | determinedAB540Eligible | |
determined_homeless | determinedHomeless | CC_PROMISE_GRANT_STG | determinedHomeless | |
determined_non_res_exempt | determinedNonResExempt | CC_PROMISE_GRANT_STG | determinedNonResExempt | |
determined_residentca | determinedResidentca | CC_PROMISE_GRANT_STG | determinedResidentca | |
elig_bogfw | eligBogfw | CC_PROMISE_GRANT_STG | eligBogfw | |
elig_covid_death | eligCovidDeath | CC_PROMISE_GRANT_STG | eligCovidDeath | |
elig_exonerated_crime | eligExoneratedCrime | CC_PROMISE_GRANT_STG | eligExoneratedCrime | |
elig_medal_honor | eligMedalHonor | CC_PROMISE_GRANT_STG | eligMedalHonor | |
elig_method_a | eligMethodA | CC_PROMISE_GRANT_STG | eligMethodA | |
elig_method_b | eligMethodB | CC_PROMISE_GRANT_STG | eligMethodB | |
elig_method_d | eligMethodD | CC_PROMISE_GRANT_STG | eligMethodD | |
elig_police_fire | eligPoliceFire | CC_PROMISE_GRANT_STG | eligPoliceFire | |
elig_sept_11 | eligSept11 | CC_PROMISE_GRANT_STG | eligSept11 | |
CC_PROMISE_GRANT_STG | ||||
email_verified | emailVerified | CC_PROMISE_GRANT_STG | emailVerified | |
email_verified_timestamp | emailVerifiedTimestamp | CC_PROMISE_GRANT_STG | emailVerifiedTimestamp | |
emancipated_minor | emancipatedMinor | CC_PROMISE_GRANT_STG | emancipatedMinor | |
firstname | firstname | CC_PROMISE_GRANT_STG | firstname | |
general_assistance | generalAssistance | CC_PROMISE_GRANT_STG | generalAssistance | |
homeless_youth_hud | homelessYouthHud | CC_PROMISE_GRANT_STG | homelessYouthHud | |
homeless_youth_other | homelessYouthOther | CC_PROMISE_GRANT_STG | homelessYouthOther | |
homeless_youth_school | homelessYouthSchool | CC_PROMISE_GRANT_STG | homelessYouthSchool | |
ind_gross_income | indGrossIncome | CC_PROMISE_GRANT_STG | indGrossIncome | |
ind_number_household | indNumberHousehold | CC_PROMISE_GRANT_STG | indNumberHousehold | |
ind_other_income | indOtherIncome | CC_PROMISE_GRANT_STG | indOtherIncome | |
ind_total_income | indTotalIncome | CC_PROMISE_GRANT_STG | indTotalIncome | |
ip_address | ipAddress | CC_PROMISE_GRANT_STG | ipAddress | |
ip_address_at_account_creation | ipAddressAtAccountCreation | 4.7 | CC_PROMISE_GRANT_STG | ipAddressAtAccountCreation |
ip_address_at_app_creation | ipAddressAtAppCreation | 4.7 | CC_PROMISE_GRANT_STG | ipAddressAtAppCreation |
last_page | lastPage | CC_PROMISE_GRANT_STG | lastPage | |
lastname | lastname | CC_PROMISE_GRANT_STG | lastname | |
legal_guardianship | legalGuardianship | CC_PROMISE_GRANT_STG | legalGuardianship | |
living_with_parents | livingWithParents | CC_PROMISE_GRANT_STG | livingWithParents | |
mailing_address_validation_override | mailingAddressValidationOverride | 4.7 | CC_PROMISE_GRANT_STG | mailingAddressValidationOverride |
mainphone | mainphone | CC_PROMISE_GRANT_STG | mainphone | |
mainphone_auth_text | mainphoneAuthText | CC_PROMISE_GRANT_STG | mainphoneAuthText | |
mainphone_ext | mainphoneExt | CC_PROMISE_GRANT_STG | mainphoneExt | |
mainphoneintl | mainphoneintl | CC_PROMISE_GRANT_STG | mainphoneintl | |
marital_status | maritalStatus | CC_PROMISE_GRANT_STG | maritalStatus | |
married_or_rdp | marriedOrRdp | CC_PROMISE_GRANT_STG | marriedOrRdp | |
middlename | middlename | CC_PROMISE_GRANT_STG | middlename | |
no_mailing_address_homeless | noMailingAddressHomeless | CC_PROMISE_GRANT_STG | noMailingAddressHomeless | |
no_perm_address_homeless | noPermAddressHomeless | CC_PROMISE_GRANT_STG | noPermAddressHomeless | |
non_us_address | nonUsAddress | CC_PROMISE_GRANT_STG | nonUsAddress | |
otherfirstname | otherfirstname | CC_PROMISE_GRANT_STG | otherfirstname | |
otherlastname | otherlastname | CC_PROMISE_GRANT_STG | otherlastname | |
othermiddlename | othermiddlename | CC_PROMISE_GRANT_STG | othermiddlename | |
parent_guardian_name | parentGuardianName | CC_PROMISE_GRANT_STG | parentGuardianName | |
parents_assistance | parentsAssistance | CC_PROMISE_GRANT_STG | parentsAssistance | |
parents_deceased | parentsDeceased | CC_PROMISE_GRANT_STG | parentsDeceased | |
phone_type | phoneType | 4.7 | CC_PROMISE_GRANT_STG | phoneType |
phone_verified | phoneVerified | CC_PROMISE_GRANT_STG | phoneVerified | |
phone_verified_timestamp | phoneVerifiedTimestamp | CC_PROMISE_GRANT_STG | phoneVerifiedTimestamp | |
postalcode | postalcode | CC_PROMISE_GRANT_STG | postalcode | |
preferred_contact_method | preferredMethodOfContact | CC_PROMISE_GRANT_STG | preferredMethodOfContact | |
preferred_firstname | preferredFirstname | CC_PROMISE_GRANT_STG | preferredFirstname | |
preferred_lastname | preferredLastname | CC_PROMISE_GRANT_STG | preferredLastname | |
preferred_middlename | preferredMiddlename | CC_PROMISE_GRANT_STG | preferredMiddlename | |
preferred_name | preferredName | CC_PROMISE_GRANT_STG | preferredName | |
province | province | CC_PROMISE_GRANT_STG | province | |
reg_dom_partner | regDomPartner | CC_PROMISE_GRANT_STG | regDomPartner | |
sis_receipt | sisReceipt | Coming soon | CC_PROMISE_GRANT_STG | sisReceipt |
ssi_ssp | ssiSsp | CC_PROMISE_GRANT_STG | ssiSsp | |
ssn | ssn | CC_PROMISE_GRANT_STG | ssn | |
ssn_exception | ssnException | CC_PROMISE_GRANT_STG | ssnException | |
ssn_last4 | ssnLast4 | CC_PROMISE_GRANT_STG | ssnLast4 | |
ssn_no | ssnNo | CC_PROMISE_GRANT_STG | ssnNo | |
ssn_type | ssnType | CC_PROMISE_GRANT_STG | ssnType | |
state | state | CC_PROMISE_GRANT_STG | state | |
status | status | CC_PROMISE_GRANT_STG | status | |
streetaddress1 | streetaddress1 | CC_PROMISE_GRANT_STG | streetaddress1 | |
streetaddress2 | streetaddress2 | CC_PROMISE_GRANT_STG | streetaddress2 | |
student_college_id | studentCollegeId | CC_PROMISE_GRANT_STG | studentCollegeId | |
student_parent | studentParent | 4.7 | CC_PROMISE_GRANT_STG | studentParent |
tanf_calworks | tanfCalworks | CC_PROMISE_GRANT_STG | tanfCalworks | |
term_code | termCode | NOT USED IN CCPG | CC_PROMISE_GRANT_STG | termCode |
tstmp_create | tstmpCreate | CC_PROMISE_GRANT_STG | tstmpCreate | |
tstmp_download | tstmpDownload | CC_PROMISE_GRANT_STG | tstmpDownload | |
tstmp_submit | tstmpSubmit | CC_PROMISE_GRANT_STG | tstmpSubmit | |
tstmp_update | tstmpUpdate | CC_PROMISE_GRANT_STG | tstmpUpdate | |
us_veteran | usVeteran | CC_PROMISE_GRANT_STG | usVeteran | |
year_code | yearCode | CC_PROMISE_GRANT_STG | yearCode | |
year_description | yearDescription | CC_PROMISE_GRANT_STG | yearDescription |