Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

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
XCTC.CP.IDME.CONFIRMED.TIME

SG v.4.9

idmeOptinTimestamp

idme_optin_timestamp

XCTC.CCPG.APPL

XCTC.CP.IDME.OPTIN.DATE
XCTC.CP.IDME.OPTIN.TIME

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
XCTC.CP.ACCEPTED.TRMS.TIME

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

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

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

...