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

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

 

email

email

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

 

 

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