...
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_deps_18over | studentDeps18Over | SG 4.10 | CC_PROMISE_GRANT_STG | student_deps_Under18 | studentDepsUnder18 | SG 4.10 | CC_PROMISE_GRANT_STG | |
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 |