CC Promise Grant Application Data Fields Table Mappings
More details can be found in the CC Promise Grant Application section on the Data Dictionaries page.
College Adaptor Payload Field | Data Dictionary Name | Colleague Table Name | Colleague Field Name | Notes |
|---|---|---|---|---|
appId | app_id | XCTC.CCPG.APPL | XCTC.CCPG.APPL.ID | |
ccId | ccc_id | XCTC.CCPG.APPL | XCTC.CP.CCC.ID | |
confirmationNumber | confirmation_number | XCTC.CCPG.APPL | XCTC.CP.CONFIRMATION.NUMBER | |
status | XCTC.CCPG.APPL | XCTC.CP.STATUS | ||
appLang | app_lang | XCTC.CCPG.APPL | XCTC.CP.APP.LANG | |
college_id | XCTC.CCPG.APPL | XCTC.CP.COLLEGE.ID | ||
yearCode | year_code | XCTC.CCPG.APPL | XCTC.CP.YEAR.CODE | |
yearDescription | year_description | XCTC.CCPG.APPL | XCTC.CP.YEAR.DESCRIPTION | |
determinedResidentca | determined_residentca | XCTC.CCPG.APPL | XCTC.CP.DETERMINED.RESIDENTC | |
determinedAB540Eligible | determined_ab540_eligible | XCTC.CCPG.APPL | XCTC.CP.DETERMINED.AB540.ELI | |
determinedNonResExempt | determined_non_res_exempt | XCTC.CCPG.APPL | XCTC.CP.DETERMINED.NON.RES.E | |
lastname | lastname | XCTC.CCPG.APPL | XCTC.CP.LASTNAME | |
firstname | firstname | XCTC.CCPG.APPL | XCTC.CP.FIRSTNAME | |
middlename | middlename | XCTC.CCPG.APPL | XCTC.CP.MIDDLENAME | |
mainphone | mainphone | XCTC.CCPG.APPL | XCTC.CP.MAINPHONE | |
mainphoneExt | mainphone_ext | XCTC.CCPG.APPL | XCTC.CP.MAINPHONE.AUTH.EXT | |
mainphoneAuthText | mainphone_auth_text | XCTC.CCPG.APPL | XCTC.CP.MAINPHONE.AUTH.TEXT | |
XCTC.CCPG.APPL | XCTC.CP.EMAIL | |||
nonUsAddress | non_us_address | XCTC.CCPG.APPL | XCTC.CP.NON.US.ADDRESS | |
streetaddress1 | streetaddress1 | XCTC.CCPG.APPL | XCTC.CP.STREETADDRESS1 | |
streetaddress2 | streetaddress2 | XCTC.CCPG.APPL | XCTC.CP.STREETADDRESS2 | |
city | city | XCTC.CCPG.APPL | XCTC.CP.CITY | |
state | state | XCTC.CCPG.APPL | XCTC.CP.STATE | |
province | province | XCTC.CCPG.APPL | XCTC.CP.PROVINCE | |
country | country | XCTC.CCPG.APPL | XCTC.CP.COUNTRY | |
postalcode | postalcode | XCTC.CCPG.APPL | XCTC.CP.POSTALCODE | |
ssn | ssn | XCTC.CCPG.APPL | XCTC.CP.SSN | |
ssnType | ssn_type | XCTC.CCPG.APPL | XCTC.CP.SSN.TYPE | |
studentCollegeId | student_college_id | XCTC.CCPG.APPL | XCTC.CP.STUDENT.COLLEGE.ID | |
birthdate | birthdate | XCTC.CCPG.APPL | XCTC.CP.BIRTHDATE | |
maritalStatus | marital_status | XCTC.CCPG.APPL | XCTC.CP.MARITAL.STATUS | |
regDomPartner | reg_dom_partner | XCTC.CCPG.APPL | XCTC.CP.REG.DOM.PARTNER | |
bornBefore23Year | born_before_23_year | XCTC.CCPG.APPL | XCTC.CP.BORN.BEFORE.23.YEAR | |
marriedOrRdp | married_or_rdp | XCTC.CCPG.APPL | XCTC.CP.MARRIED.OR.RDP | |
usVeteran | us_veteran | XCTC.CCPG.APPL | XCTC.CP.US.VETERAN | |
dependents | dependents | XCTC.CCPG.APPL | XCTC.CP.DEPENDENTS | |
parentsDeceased | parents_deceased | XCTC.CCPG.APPL | XCTC.CP.PARENTS.DECEASED | |
emancipatedMinor | emancipated_minor | XCTC.CCPG.APPL | XCTC.CP.EMANCIPATED.MINOR | |
legalGuardianship | legal_guardianship | XCTC.CCPG.APPL | XCTC.CP.LEGAL.GUARDIANSHIP | |
homelessYouthSchool | homeless_youth_school | XCTC.CCPG.APPL | XCTC.CP.HOMELESS.YOUTH.SCHOO | |
homelessYouthHud | homeless_youth_hud | XCTC.CCPG.APPL | XCTC.CP.HOMELESS.YOUTH.HUD | |
homelessYouthOther | homeless_youth_other | XCTC.CCPG.APPL | XCTC.CP.HOMLESS.YOUTH.OTHER | |
dependentOnParentTaxes | dependent_on_parent_taxes | XCTC.CCPG.APPL | XCTC.CP.DEPENDENT.PARENT.TAX | |
livingWithParents | living_with_parents | XCTC.CCPG.APPL | XCTC.CP.LIVING.WITH.PARENTS | |
dependencyStatus | dependency_status | XCTC.CCPG.APPL | XCTC.CP.DEPENDENCY.STATUS | |
certVeteranAffairs | cert_veteran_affairs | XCTC.CCPG.APPL | XCTC.CP.CERT.VETERAN.AFFAIRS | |
certNationalGuard | cert_national_guard | XCTC.CCPG.APPL | XCTC.CP.CERT.NATIONAL.GUARD | |
eligMedalHonor | elig_medal_honor | XCTC.CCPG.APPL | XCTC.CP.ELIG.MEDAL.HONOR | |
eligSept11 | elig_sept_11 | XCTC.CCPG.APPL | XCTC.CP.ELIG.SEPT.11 | |
eligPoliceFire | elig_police_fire | XCTC.CCPG.APPL | XCTC.CP.ELIG.POLICE.FIRE | |
tanfCalworks | tanf_calworks | XCTC.CCPG.APPL | XCTC.CP.TANF.CALWORKS | |
ssiSsp | ssi_ssp | XCTC.CCPG.APPL | XCTC.CP.SSI.SSP | |
generalAssistance | general_assistance | XCTC.CCPG.APPL | XCTC.CP.GENERAL.ASSISTANCE | |
parentsAssistance | parents_assistance | XCTC.CCPG.APPL | XCTC.CP.PARENTS.ASSISTANCE | |
depNumberHousehold | dep_number_household | XCTC.CCPG.APPL | XCTC.CP.DEP.NUMBER.HOUSEHOLD | |
indNumberHousehold | ind_number_household | XCTC.CCPG.APPL | XCTC.CP.IND.NUMBER.HOUSEHOLD | |
depGrossIncome | dep_gross_income | XCTC.CCPG.APPL | XCTC.CP.DEP.GROSS.INCOME | |
indGrossIncome | ind_gross_income | XCTC.CCPG.APPL | XCTC.CP.IND.GROSS.INCOME | |
depOtherIncome | dep_other_income | XCTC.CCPG.APPL | XCTC.CP.DEP.OTHER.INCOME | |
indOtherIncome | ind_other_income | XCTC.CCPG.APPL | XCTC.CP.IND.OTHER.INCOME | |
depTotalIncome | dep_total_income | XCTC.CCPG.APPL | XCTC.CP.DEP.TOTAL.INCOME | |
indTotalIncome | ind_total_income | XCTC.CCPG.APPL | XCTC.CP.IND.TOTAL.INCOME | |
eligMethodA | elig_method_a | XCTC.CCPG.APPL | XCTC.CP.ELIG.METHOD.A | |
eligMethodB | elig_method_b | XCTC.CCPG.APPL | XCTC.CP.ELIG.METHOD.B | |
eligBogfw | elig_bogfw | XCTC.CCPG.APPL | CTC.CP.ELIG.BOGFW | |
confirmationParentGuardian | confirmation_parent_guardian | XCTC.CCPG.APPL | XCTC.CP.CONFIRMATION.PARENTG | |
parentGuardianName | parent_guardian_name | XCTC.CCPG.APPL | XCTC.CP.PARENT.GUARDIAN.NAME | |
ackFinAid | ack_fin_aid | XCTC.CCPG.APPL | XCTC.CP.ACK.FIN.AID | |
confirmationApplicant | confirmation_applicant | XCTC.CCPG.APPL | XCTC.CP.CONFIRMATION.APPLICA | |
lastPage | last_page | XCTC.CCPG.APPL | XCTC.CP.LAST.PAGE | |
ssnLast4 | ssn_last4 | XCTC.CCPG.APPL | XCTC.CP.SSN.LAST4 | |
tstmpSubmit | tstmp_submit | XCTC.CCPG.APPL | XCTC.CP.TSTMP.SUBMIT.DATE + XCTC.CP.TSTMP.SUBMIT.TIME | |
tstmpCreate | tstmp_create | XCTC.CCPG.APPL | XCTC.CP.TSTMP.CREATE.DATE + XCTC.CP.TSTMP.CREATE.TIME | |
tstmpUpdate | tstmp_update | - | - | Not supported in Colleague |
tstmpDownload | tstmp_download | XCTC.CCPG.APPL | XCTC.CP.TSTMP.DOWNLOAD.DATE + XCTC.CP.TSTMP.DOWNLOAD.TIME | |
tstmpSISProcessed | - | XCTC.CCPG.APPL | XCTC.CP.PROCESSED.DATE + XCTC.CP.PROCESSED.TIME | - |
- | - | XCTC.CCPG.APPL | XCTC.CP.PROCESSED.ID | This is the Internal Colleague ID for the student/applicant. This field may be used by colleges as part of their staging record processing process. |
termCode | term_code | XCTC.CCPG.APPL | XCTC.CP.TERM.CODE | |
ip_address | XCTC.CCPG.APPL | XCTC.CP.IP.ADDRESS | ||
campaign1 | campaign1 | XCTC.CCPG.APPL | XCTC.CP.CAMPAIGN1 | |
campaign2 | campaign2 | XCTC.CCPG.APPL | XCTC.CP.CAMPAIGN2 | |
campaign3 | campaign3 | XCTC.CCPG.APPL | XCTC.CP.CAMPAIGN3 | |
ssn_exception | XCTC.CCPG.APPL | XCTC.CP.SSN.EXCEPTION | ||
collegeName | college_name | XCTC.CCPG.APPL | XCTC.CP.COLLEGE.NAME | |
preferredFirstname | preferred_firstname | XCTC.CCPG.APPL | XCTC.CP.PREFERRED.FIRSTNAME | |
preferredMiddlename | preferred_middlename | XCTC.CCPG.APPL | XCTC.CP.PREFERRED.MIDDLENAME | |
preferredLastname | preferred_lastname | XCTC.CCPG.APPL | XCTC.CP.PREFERRED.LASTNAME | |
preferredName | preferred_name | XCTC.CCPG.APPL | XCTC.CP.PREFERRED.NAME | |
ssnNo | ssn_no | XCTC.CCPG.APPL | XCTC.CP.SSN.NO | |
noPermAddressHomeless | no_perm_address_homeless | XCTC.CCPG.APPL | XCTC.CP.NO.PERM.ADDRESS.HOME | |
noMailingAddressHomeless | no_mailing_address_homeless | XCTC.CCPG.APPL | XCTC.CP.NO.MAILING.ADDRESS | |
determinedHomeless | determined_homeless | XCTC.CCPG.APPL | XCTC.CP.DETERMINED.HOMELESS | |
eligMethodD | elig_method_d | XCTC.CCPG.APPL | XCTC.CP.ELIG.METHOD.D | |
mainphoneintl | mainphoneintl | XCTC.CCPG.APPL | XCTC.CP.MAINPHONEINTL | |
addressValidationOverride | address_validation_override | XCTC.CCPG.APPL | XCTC.CP.ADDRESS.VALIDATION.O | |
addressValidationOverrideTimestamp | address_validation_override_timestamp | XCTC.CCPG.APPL | XCTC.CP.ADDRESS.VALID.O.DATE | |
XCTC.CCPG.APPL | XCTC.CP.ADDRESS.VALID.O.TIME | |||
emailVerified | email_verified | XCTC.CCPG.APPL | XCTC.CP.EMAIL.VERIFIED | |
emailVerifiedTimestamp | email_verified_timestamp | XCTC.CCPG.APPL | XCTC.CP.EMAIL.VERIFIED.DATE | |
XCTC.CCPG.APPL | XCTC.CP.EMAIL.VERIFIED.TIME | |||
mainphoneVerified | main_phone_verified | XCTC.CCPG.APPL | XCTC.CP.MAINPHONE.VERIFIED | |
mainphoneVerifiedTimestamp | main_phone_verified_timestamp | XCTC.CCPG.APPL | XCTC.CP.MAINPHONE.VRFD.DATE | |
XCTC.CCPG.APPL | XCTC.CP.MAINPHONE.VRFD.TIME | |||
preferredMethodOfContact | preferred_method_of_contact | XCTC.CCPG.APPL | XCTC.CP.PREFERRED.METHOD.CON | |
sisProcessedNotes | XCTC.CCPG.APPL | XCTC.CP.USER1 | ||
XCTC.CCPG.APPL | XCTC.CP.USER2 | |||
XCTC.CCPG.APPL | XCTC.CP.USER3 | |||
sisProcessFlag | - | - | - | Y/N value based on if XCTC.CP.PROCESSED.DATE has a value or not |