CC Promise Grant Application SuperGlue Data Mappings - Banner

The tables below reflect the latest version of the CC Promise Grant Online Application.


CC Promise Grant Data Fields Table Mapping - Banner

For more details, see the latest CC Promise Grant Application data dictionary.

College Adaptor Payload Field

Data Dictionary Name

Banner Table Name

Banner Field Name

Notes

College Adaptor Payload Field

Data Dictionary Name

Banner Table Name

Banner Field Name

Notes

studentDeps18Over

student_deps_18Over

SZRPGRT

STU_DEPS_18_OVER

SG v.4.10

studentDepsUnder18

student_deps_Under18

SZRPGRT

STU_DEPS_UNDER_18

SG v.4.10

idmeConfirmationTimestamp

idme_confirmation_timestamp

SZRPGRT

IDME_CONFIRMATION_TSTMP

SG v.4.9

idmeOptinTimestamp

idme_optin_timestamp

SZRPGRT

IDME_OPTIN_TSTMP

SG v.4.9

idmeWorkflowStatus

idme_workflow_status

SZRPGRT

IDME_WORKFLOW_STATUS

SG v.4.9

studentParent

student_parent

SZRPGRT

STUDENT_PARENT

Question added v.6.13 / SG v.4.7

acceptedTerms

accepted_terms

SZRPGRT

ACCEPTED_TERMS_TSTMP

SG v.4.7

acceptedTermsTimestamp

accepted_terms_timestamp

SZRPGRT

ACCEPTED_TERMS_TSTMP

SG v.4.7

addressValidationOverride

address_validation_override

SZRPGRT

ADDRESS_VAL_OVERRIDE

SG v.4.6

addressValidationOverrideTimestamp

address_validation_override_timestamp

SZRPGRT

ADDRESS_VAL_OVER_TSTMP

SG v.4.6

emailVerified

email_verified

SZRPGRT

EMAIL_VERIFIED

SG v.4.6

emailVerifiedTimestamp

email_verified_timestamp

SZRPGRT

EMAIL_VERIFIED_TSTMP

SG v.4.6

ipAddressAtAccountCreation

ip_address_at_account_creation

SZRPGRT

IP_ADDR_ACCT_CREATE

SG v.4.7

ipAddressAtAppCreation

ip_address_at_app_creation

SZRPGRT

IP_ADDR_APP_CREATE

SG v.4.7

mailingAddressValidationOverride

mailing_address_validation_override

SZRPGRT

MAIL_ADDR_VALIDATION_OVR

SG v.4.7

mainphoneVerified

phone_verified

SZRPGRT

PHONE_VERIFIED

SG v.4.6

mainphoneVerifiedTimestamp

phone_verified_timestamp

SZRPGRT

PHONE_VERIFIED_TSTMP

SG v.4.6

phoneType

phone_type

SZRPGRT

PHONE_TYPE

SG v.4.7

preferredMethodOfContact

preferred_contact_method

SZRPGRT

PREF_CONTACT_METHOD

SG v.4.6

sisReceipt

sis_receipt

 

 

Coming

appId

app_id

SZRPGRT

APP_ID

 

ccId

ccc_id

SZRPGRT

CCC_ID

 

confirmationNumber

confirmation_number

SZRPGRT

CONFIRMATION_NUMBER

 

status

status

SZRPGRT

STATUS

 

appLang

app_lang

SZRPGRT

APP_LANG

 

collegeId

college_id

SZRPGRT

COLLEGE_ID

 

yearCode

year_code

SZRPGRT

YEAR_CODE

 

yearDescription

year_description

SZRPGRT

YEAR_DESCRIPTION

 

determinedResidentca

determined_residentca

SZRPGRT

DETERMINED_RESIDENTCA

 

determinedAB540Eligible

determined_ab540_eligible

SZRPGRT

DETERMINED_AB540_ELIGIBLE

 

determinedNonResExempt

determined_non_res_exempt

SZRPGRT

DETERMINED_NON_RES_EXEMPT

 

lastname

lastname

SZRPGRT

LASTNAME

 

firstname

firstname

SZRPGRT

FIRSTNAME

 

middlename

middlename

SZRPGRT

MIDDLENAME

 

mainphone

mainphone

SZRPGRT

MAINPHONE

 

mainphoneExt

mainphone_ext

SZRPGRT

MAINPHONE_EXT

NO LONGER USED

mainphoneAuthText

mainphone_auth_text

SZRPGRT

MAINPHONE_AUTH_TEXT

NO LONGER USED

email

email

SZRPGRT

EMAIL

 

nonUsAddress

non_us_address

SZRPGRT

NON_US_ADDRESS

 

streetaddress1

streetaddress1

SZRPGRT

STREETADDRESS1

 

streetaddress2

streetaddress2

SZRPGRT

STREETADDRESS2

 

city

city

SZRPGRT

CITY

 

state

state

SZRPGRT

STATE

 

province

province

SZRPGRT

PROVINCE

 

country

country

SZRPGRT

COUNTRY

 

postalcode

postalcode

SZRPGRT

POSTALCODE

 

ssn

ssn

SZRPGRT

SSN_TEXT

 

ssnType

ssn_type

SZRPGRT

SSN_TYPE

 

studentCollegeId

student_college_id

SZRPGRT

STUDENT_COLLEGE_ID

 

birthdate

birthdate

SZRPGRT

BIRTHDATE

 

maritalStatus

marital_status

SZRPGRT

MARITAL_STATUS

 

regDomPartner

reg_dom_partner

SZRPGRT

REG_DOM_PARTNER

 

bornBefore23Year

born_before_23_year

SZRPGRT

BORN_BEFORE_23_YEAR

 

marriedOrRdp

married_or_rdp

SZRPGRT

MARRIED_OR_RDP

 

usVeteran

us_veteran

SZRPGRT

US_VETERAN

 

dependents

dependents

SZRPGRT

DEPENDENTS

 

parentsDeceased

parents_deceased

SZRPGRT

PARENTS_DECEASED

 

emancipatedMinor

emancipated_minor

SZRPGRT

EMANCIPATED_MINOR

 

legalGuardianship

legal_guardianship

SZRPGRT

LEGAL_GUARDIANSHIP

 

homelessYouthSchool

homeless_youth_school

SZRPGRT

HOMELESS_YOUTH_SCHOOL

 

homelessYouthHud

homeless_youth_hud

SZRPGRT

HOMELESS_YOUTH_HUD

 

homelessYouthOther

homeless_youth_other

SZRPGRT

HOMELESS_YOUTH_OTHER

 

dependentOnParentTaxes

dependent_on_parent_taxes

SZRPGRT

DEPENDENT_ON_PARENT_TAXES

 

livingWithParents

living_with_parents

SZRPGRT

LIVING_WITH_PARENTS

 

dependencyStatus

dependency_status

SZRPGRT

DEPENDENCY_STATUS

 

certVeteranAffairs

cert_veteran_affairs

SZRPGRT

CERT_VETERAN_AFFAIRS

 

certNationalGuard

cert_national_guard

SZRPGRT

CERT_NATIONAL_GUARD

 

eligMedalHonor

elig_medal_honor

SZRPGRT

ELIG_MEDAL_HONOR

 

eligSept11

elig_sept_11

SZRPGRT

ELIG_SEPT_11

 

eligPoliceFire

elig_police_fire

SZRPGRT

ELIG_POLICE_FIRE

 

eligCovidDeath

elig_covid_death

SZRPGRT

ELIG_COVID_DEATH

Question added 2022-2023 / SG v.4.4

eligExoneratedCrime

elig_exonerated_crime

SZRPGRT

ELIG_EXONERATED_CRIME

Question added 2022-2023 / SG v.4.4

tanfCalworks

tanf_calworks

SZRPGRT

TANF_CALWORKS

 

ssiSsp

ssi_ssp

SZRPGRT

SSI_SSP

 

generalAssistance

general_assistance

SZRPGRT

GENERAL_ASSISTANCE

 

parentsAssistance

parents_assistance

SZRPGRT

PARENTS_ASSISTANCE

 

depNumberHousehold

dep_number_household

SZRPGRT

DEP_NUMBER_HOUSEHOLD

 

indNumberHousehold

ind_number_household

SZRPGRT

IND_NUMBER_HOUSEHOLD

 

depGrossIncome

dep_gross_income

SZRPGRT

DEP_GROSS_INCOME

 

indGrossIncome

ind_gross_income

SZRPGRT

IND_GROSS_INCOME

 

depOtherIncome

dep_other_income

SZRPGRT

DEP_OTHER_INCOME

 

indOtherIncome

ind_other_income

SZRPGRT

IND_OTHER_INCOME

 

depTotalIncome

dep_total_income

SZRPGRT

DEP_TOTAL_INCOME

 

indTotalIncome

ind_total_income

SZRPGRT

IND_TOTAL_INCOME

 

eligMethodA

elig_method_a

SZRPGRT

ELIG_METHOD_A

 

eligMethodB

elig_method_b

SZRPGRT

ELIG_METHOD_B

 

eligBogfw

elig_bogfw

SZRPGRT

ELIG_BOGFW

 

confirmationParentGuardian

confirmation_parent_guardian

SZRPGRT

CONFIRMATION_PARENT_GUARDIAN

 

parentGuardianName

parent_guardian_name

SZRPGRT

PARENT_GUARDIAN_NAME

 

ackFinAid

ack_fin_aid

SZRPGRT

ACK_FIN_AID

 

confirmationApplicant

confirmation_applicant

SZRPGRT

CONFIRMATION_APPLICANT

 

lastPage

last_page

SZRPGRT

LAST_PAGE

 

ssnLast4

ssn_last4

SZRPGRT

SSN_LAST4

 

tstmpSubmit

tstmp_submit

SZRPGRT

TSTMP_SUBMIT

 

tstmpCreate

tstmp_create

SZRPGRT

TSTMP_CREATE

 

tstmpUpdate

tstmp_update

SZRPGRT

TSTMP_UPDATE

 

tstmpDownload

tstmp_download

SZRPGRT

TSTMP_DOWNLOAD

 

termCode

term_code

SZRPGRT

TERM_CODE

NOT USED IN CCPG

ipAddress

ip_address

SZRPGRT

IP_ADDRESS

 

campaign1

campaign1

SZRPGRT

CAMPAIGN1

 

campaign2

campaign2

SZRPGRT

CAMPAIGN2

 

campaign3

campaign3

SZRPGRT

CAMPAIGN3

 

ssnException

ssn_exception

SZRPGRT

SSN_EXCEPTION

 

collegeName

college_name

SZRPGRT

COLLEGE_NAME

 

preferredFirstname

preferred_firstname

SZRPGRT

PREFERRED_FIRSTNAME

 

preferredMiddlename

preferred_middlename

SZRPGRT

PREFERRED_MIDDLENAME

NO LONGER USED

preferredLastname

preferred_lastname

SZRPGRT

PREFERRED_LASTNAME

NO LONGER USED

preferredName

preferred_name

SZRPGRT

PREFERRED_NAME

NO LONGER USED

ssnNo

ssn_no

SZRPGRT

SSN_NO

 

noPermAddressHomeless

no_perm_address_homeless

SZRPGRT

NO_PERM_ADDRESS_HOMELESS

 

noMailingAddressHomeless

no_mailing_address_homeless

SZRPGRT

NO_MAILING_ADDRESS_HOMELESS

 

determinedHomeless

determined_homeless

SZRPGRT

DETERMINED_HOMELESS

 

eligMethodD

elig_method_d

SZRPGRT

ELIG_METHOD_D

 

mainphoneintl

mainphoneintl

SZRPGRT

MAINPHONEINTL