CC Promise Grant Application SuperGlue Data Mappings - MS SQL
- Patricia Donohue
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 |
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 |