CC Promise Grant SuperGlue Data Mappings for Colleague
- Patricia Donohue
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 |
|---|---|---|---|---|
studentDeps18Over | student_deps_18Over | XCTC.CCPG.APPL | XCTC.CP.STUDENT.DEPS.18OVER | SG v.4.10 |
studentDepsUnder18 | student_deps_Under18 | XCTC.CCPG.APPL | XCTC.CP.STUDENT.DEPS.UNDER18 | SG v.4.10 |
idmeConfirmationTimestamp | idme_confirmation_timestamp | XCTC.CCPG.APPL | XCTC.CP.IDME.CONFIRMED.DATE | SG v.4.9 |
idmeOptinTimestamp | idme_optin_timestamp | XCTC.CCPG.APPL | XCTC.CP.IDME.OPTIN.DATE | SG v.4.9 |
idmeWorkflowStatus | idme_workflow_status | XCTC.CCPG.APPL | XCTC.CP.IDME.WORKFLOW.STATUS | SG v.4.9 |
studentParent | student_parent | XCTC.CCPG.APPL | XCTC.CA.STUDENT.PARENT | Question added Apply 6.13 / SG v.4.7 |
acceptedTerms | accepted_terms | XCTC.CCPG.APPL | XCTC.CP.ACCEPTED.TRMS | SG v.4.7 |
acceptedTermsTimestamp | accepted_terms_timestamp | XCTC.CCPG.APPL | XCTC.CP.ACCEPTED.TRMS.DATE | SG v.4.7 |
ipAddressAtAccountCreation | ip_address_at_account_creation | XCTC.CCPG.APPL | XCTC.CA.IP.ADDRESS.ACCT.CRTD | SG v.4.7 |
ipAddressAtAppCreation | ip_address_at_app_creation | XCTC.CCPG.APPL | XCTC.CA.IP.ADDRESS.APPL.CRTD | SG v.4.7 |
mailingAddressValidationOverride | mailing_address_validation_override | XCTC.CCPG.APPL | XCTC.CA.MA.ADDRESS.VALID.O | SG v.4.7 |
phoneType | phone_type | XCTC.CCPG.APPL | XCTC.CA.MAINPHONE.TYPE | SG v.4.7 |
appId | app_id | XCTC.CCPG.APPL | XCTC.CCPG.APPL.ID |
|
cccId | ccc_id | XCTC.CCPG.APPL | XCTC.CP.CCC.ID |
|
confirmationNumber | confirmation_number | XCTC.CCPG.APPL | XCTC.CP.CONFIRMATION.NUMBER |
|
status | status | XCTC.CCPG.APPL | XCTC.CP.STATUS |
|
appLang | app_lang | XCTC.CCPG.APPL | XCTC.CP.APP.LANG |
|
collegeId | 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 |
|
eligCovidDeath | elig_covid_death | XCTC.CCPG.APPL | XCTC.CP.ELIG.COVID.DEATH | Added 2022-2023 |
eligExoneratedCrime | elig_exonerated_crime | XCTC.CCPG.APPL | XCTC.CP.ELIG.EXONERATED.CRIME | Added 2022-2023 |
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 | NOT USED IN CCPG |
ipAddress | 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 |
|
ssnException | 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 | phone_verified | XCTC.CCPG.APPL | XCTC.CP.MAINPHONE.VERIFIED |
|
mainphoneVerifiedTimestamp | phone_verified_timestamp | XCTC.CCPG.APPL | XCTC.CP.MAINPHONE.VRFD.DATE |
|
|
| XCTC.CCPG.APPL | XCTC.CP.MAINPHONE.VRFD.TIME |
|
preferredMethodOfContact | preferred_contact_method | 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 |