CC Promise Grant SuperGlue Data Mappings for Colleague
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 |
verificationOptinTimestamp | verification_optin_timestamp | XCTC.CCPG.APPL | XCTC.SD.VERIF.OPTIN.TIME | SG 5.3.0 |
verificationConfirmationTimestamp | verification_confirmation_timestamp | XCTC.CCPG.APPL | XCTC.SD.VERIF.CONFRM.TIME | SG 5.3.0 |
verificationWorkflowStatus | verification_workflow_status | XCTC.CCPG.APPL | XCTC.SD.VERIF.WF.STATUS | SG 5.3.0 |
verificationSourceIdentity | verification_source_identity | XCTC.CCPG.APPL | XCTC.SD.VERIF.SRC.IDENT | SG 5.3.0 |
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 |