CC Promise Grant Application SuperGlue Data Mappings - Banner

The tables below pertain to the California Colleges Promise Grant online application.


CC Promise Grant Data Fields Table Mapping - Banner

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

College Adaptor Payload Field

Data Dictionary Name

Banner Table Name

Banner Field Name

Explanation

College Adaptor Payload Field

Data Dictionary Name

Banner Table Name

Banner Field Name

Explanation

appId

app_id

CC_PROMISE_GRANT_STG

APP_ID

See the CCPG Data Specification here.

ccId

ccc_id

CC_PROMISE_GRANT_STG

CCC_ID

See the CCPG Data Specification here.

confirmationNumber

confirmation_number

CC_PROMISE_GRANT_STG

CONFIRMATION_NUMBER

See the CCPG Data Specification here.

status

status

CC_PROMISE_GRANT_STG

STATUS

See the CCPG Data Specification here.

appLang

app_lang

CC_PROMISE_GRANT_STG

APP_LANG

See the CCPG Data Specification here.

collegeId

college_id

CC_PROMISE_GRANT_STG

COLLEGE_ID

See the CCPG Data Specification here.

yearCode

year_code

CC_PROMISE_GRANT_STG

YEAR_CODE

See the CCPG Data Specification here.

yearDescription

year_description

CC_PROMISE_GRANT_STG

YEAR_DESCRIPTION

See the CCPG Data Specification here.

determinedResidentca

determined_residentca

CC_PROMISE_GRANT_STG

DETERMINED_RESIDENTCA

See the CCPG Data Specification here.

determinedAB540Eligible

determined_ab540_eligible

CC_PROMISE_GRANT_STG

DETERMINED_AB540_ELIGIBLE

See the CCPG Data Specification here.

determinedNonResExempt

determined_non_res_exempt

CC_PROMISE_GRANT_STG

DETERMINED_NON_RES_EXEMPT

See the CCPG Data Specification here.

lastname

lastname

CC_PROMISE_GRANT_STG

LASTNAME

See the CCPG Data Specification here.

firstname

firstname

CC_PROMISE_GRANT_STG

FIRSTNAME

See the CCPG Data Specification here.

middlename

middlename

CC_PROMISE_GRANT_STG

MIDDLENAME

See the CCPG Data Specification here.

mainphone

mainphone

CC_PROMISE_GRANT_STG

MAINPHONE

See the CCPG Data Specification here.

mainphoneExt

mainphone_ext

CC_PROMISE_GRANT_STG

MAINPHONE_EXT

See the CCPG Data Specification here.

mainphoneAuthText

mainphone_auth_text

CC_PROMISE_GRANT_STG

MAINPHONE_AUTH_TEXT

See the CCPG Data Specification here.

email

email

CC_PROMISE_GRANT_STG

EMAIL

See the CCPG Data Specification here.

nonUsAddress

non_us_address

CC_PROMISE_GRANT_STG

NON_US_ADDRESS

See the CCPG Data Specification here.

streetaddress1

streetaddress1

CC_PROMISE_GRANT_STG

STREETADDRESS1

See the CCPG Data Specification here.

streetaddress2

streetaddress2

CC_PROMISE_GRANT_STG

STREETADDRESS2

See the CCPG Data Specification here.

city

city

CC_PROMISE_GRANT_STG

CITY

See the CCPG Data Specification here.

state

state

CC_PROMISE_GRANT_STG

STATE

See the CCPG Data Specification here.

province

province

CC_PROMISE_GRANT_STG

PROVINCE

See the CCPG Data Specification here.

country

country

CC_PROMISE_GRANT_STG

COUNTRY

See the CCPG Data Specification here.

postalcode

postalcode

CC_PROMISE_GRANT_STG

POSTALCODE

See the CCPG Data Specification here.

ssn

ssn

CC_PROMISE_GRANT_STG

SSN_TEXT

See the CCPG Data Specification here.

ssnType

ssn_type

CC_PROMISE_GRANT_STG

SSN_TYPE

See the CCPG Data Specification here.

studentCollegeId

student_college_id

CC_PROMISE_GRANT_STG

STUDENT_COLLEGE_ID

See the CCPG Data Specification here.

birthdate

birthdate

CC_PROMISE_GRANT_STG

BIRTHDATE

See the CCPG Data Specification here.

maritalStatus

marital_status

CC_PROMISE_GRANT_STG

MARITAL_STATUS

See the CCPG Data Specification here.

regDomPartner

reg_dom_partner

CC_PROMISE_GRANT_STG

REG_DOM_PARTNER

See the CCPG Data Specification here.

bornBefore23Year

born_before_23_year

CC_PROMISE_GRANT_STG

BORN_BEFORE_23_YEAR

See the CCPG Data Specification here.

marriedOrRdp

married_or_rdp

CC_PROMISE_GRANT_STG

MARRIED_OR_RDP

See the CCPG Data Specification here.

usVeteran

us_veteran

CC_PROMISE_GRANT_STG

US_VETERAN

See the CCPG Data Specification here.

dependents

dependents

CC_PROMISE_GRANT_STG

DEPENDENTS

See the CCPG Data Specification here.

parentsDeceased

parents_deceased

CC_PROMISE_GRANT_STG

PARENTS_DECEASED

See the CCPG Data Specification here.

emancipatedMinor

emancipated_minor

CC_PROMISE_GRANT_STG

EMANCIPATED_MINOR

See the CCPG Data Specification here.

legalGuardianship

legal_guardianship

CC_PROMISE_GRANT_STG

LEGAL_GUARDIANSHIP

See the CCPG Data Specification here.

homelessYouthSchool

homeless_youth_school

CC_PROMISE_GRANT_STG

HOMELESS_YOUTH_SCHOOL

See the CCPG Data Specification here.

homelessYouthHud

homeless_youth_hud

CC_PROMISE_GRANT_STG

HOMELESS_YOUTH_HUD

See the CCPG Data Specification here.

homelessYouthOther

homeless_youth_other

CC_PROMISE_GRANT_STG

HOMELESS_YOUTH_OTHER

See the CCPG Data Specification here.

dependentOnParentTaxes

dependent_on_parent_taxes

CC_PROMISE_GRANT_STG

DEPENDENT_ON_PARENT_TAXES

See the CCPG Data Specification here.

livingWithParents

living_with_parents

CC_PROMISE_GRANT_STG

LIVING_WITH_PARENTS

See the CCPG Data Specification here.

dependencyStatus

dependency_status

CC_PROMISE_GRANT_STG

DEPENDENCY_STATUS

See the CCPG Data Specification here.

certVeteranAffairs

cert_veteran_affairs

CC_PROMISE_GRANT_STG

CERT_VETERAN_AFFAIRS

See the CCPG Data Specification here.

certNationalGuard

cert_national_guard

CC_PROMISE_GRANT_STG

CERT_NATIONAL_GUARD

See the CCPG Data Specification here.

eligCovidDeath

elig_covid_death

CC_PROMISE_GRANT_STG

 

 

eligExoneratedCrime

elig_exonerated_crime

CC_PROMISE_GRANT_STG

 

 

eligMedalHonor

elig_medal_honor

CC_PROMISE_GRANT_STG

ELIG_MEDAL_HONOR

See the CCPG Data Specification here.

eligSept11

elig_sept_11

CC_PROMISE_GRANT_STG

ELIG_SEPT_11

See the CCPG Data Specification here.

eligPoliceFire

elig_police_fire

CC_PROMISE_GRANT_STG

ELIG_POLICE_FIRE

See the CCPG Data Specification here.

eligCovidDeath

elig_covid_death

CC_PROMISE_GRANT_STG

ELIG_COVID_DEATH

Added 2022-2023

eligExoneratedCrime

elig_exonerated_crime

CC_PROMISE_GRANT_STG

ELIG_EXONERATED_CRIME

Added 2022-2023

tanfCalworks

tanf_calworks

CC_PROMISE_GRANT_STG

TANF_CALWORKS

See the CCPG Data Specification here.

ssiSsp

ssi_ssp

CC_PROMISE_GRANT_STG

SSI_SSP

See the CCPG Data Specification here.

generalAssistance

general_assistance

CC_PROMISE_GRANT_STG

GENERAL_ASSISTANCE

See the CCPG Data Specification here.

parentsAssistance

parents_assistance

CC_PROMISE_GRANT_STG

PARENTS_ASSISTANCE

See the CCPG Data Specification here.

depNumberHousehold

dep_number_household

CC_PROMISE_GRANT_STG

DEP_NUMBER_HOUSEHOLD

See the CCPG Data Specification here.

indNumberHousehold

ind_number_household

CC_PROMISE_GRANT_STG

IND_NUMBER_HOUSEHOLD

See the CCPG Data Specification here.

depGrossIncome

dep_gross_income

CC_PROMISE_GRANT_STG

DEP_GROSS_INCOME

See the CCPG Data Specification here.

indGrossIncome

ind_gross_income

CC_PROMISE_GRANT_STG

IND_GROSS_INCOME

See the CCPG Data Specification here.

depOtherIncome

dep_other_income

CC_PROMISE_GRANT_STG

DEP_OTHER_INCOME

See the CCPG Data Specification here.

indOtherIncome

ind_other_income

CC_PROMISE_GRANT_STG

IND_OTHER_INCOME

See the CCPG Data Specification here.

depTotalIncome

dep_total_income

CC_PROMISE_GRANT_STG

DEP_TOTAL_INCOME

See the CCPG Data Specification here.

indTotalIncome

ind_total_income

CC_PROMISE_GRANT_STG

IND_TOTAL_INCOME

See the CCPG Data Specification here.

eligMethodA

elig_method_a

CC_PROMISE_GRANT_STG

ELIG_METHOD_A

See the CCPG Data Specification here.

eligMethodB

elig_method_b

CC_PROMISE_GRANT_STG

ELIG_METHOD_B

See the CCPG Data Specification here.

eligBogfw

elig_bogfw

CC_PROMISE_GRANT_STG

ELIG_BOGFW

See the CCPG Data Specification here.

confirmationParentGuardian

confirmation_parent_guardian

CC_PROMISE_GRANT_STG

CONFIRMATION_PARENT_GUARDIAN

See the CCPG Data Specification here.

parentGuardianName

parent_guardian_name

CC_PROMISE_GRANT_STG

PARENT_GUARDIAN_NAME

See the CCPG Data Specification here.

ackFinAid

ack_fin_aid

CC_PROMISE_GRANT_STG

ACK_FIN_AID

See the CCPG Data Specification here.

confirmationApplicant

confirmation_applicant

CC_PROMISE_GRANT_STG

CONFIRMATION_APPLICANT

See the CCPG Data Specification here.

lastPage

last_page

CC_PROMISE_GRANT_STG

LAST_PAGE

See the CCPG Data Specification here.

ssnLast4

ssn_last4

CC_PROMISE_GRANT_STG

SSN_LAST4

See the CCPG Data Specification here.

tstmpSubmit

tstmp_submit

CC_PROMISE_GRANT_STG

TSTMP_SUBMIT

See the CCPG Data Specification here.

tstmpCreate

tstmp_create

CC_PROMISE_GRANT_STG

TSTMP_CREATE

See the CCPG Data Specification here.

tstmpUpdate

tstmp_update

CC_PROMISE_GRANT_STG

TSTMP_UPDATE

See the CCPG Data Specification here.

tstmpDownload

tstmp_download

CC_PROMISE_GRANT_STG

TSTMP_DOWNLOAD

See the CCPG Data Specification here.

termCode

term_code

CC_PROMISE_GRANT_STG

TERM_CODE

See the CCPG Data Specification here.

ipAddress

ip_address

CC_PROMISE_GRANT_STG

IP_ADDRESS

See the CCPG Data Specification here.

campaign1

campaign1

CC_PROMISE_GRANT_STG

CAMPAIGN1

See the CCPG Data Specification here.

campaign2

campaign2

CC_PROMISE_GRANT_STG

CAMPAIGN2

See the CCPG Data Specification here.

campaign3

campaign3

CC_PROMISE_GRANT_STG

CAMPAIGN3

See the CCPG Data Specification here.

ssnException

ssn_exception

CC_PROMISE_GRANT_STG

SSN_EXCEPTION

See the CCPG Data Specification here.

collegeName

college_name

CC_PROMISE_GRANT_STG

COLLEGE_NAME

See the CCPG Data Specification here.

preferredFirstname

preferred_firstname

CC_PROMISE_GRANT_STG

PREFERRED_FIRSTNAME

See the CCPG Data Specification here.

preferredMiddlename

preferred_middlename

CC_PROMISE_GRANT_STG

PREFERRED_MIDDLENAME

See the CCPG Data Specification here.

preferredLastname

preferred_lastname

CC_PROMISE_GRANT_STG

PREFERRED_LASTNAME

See the CCPG Data Specification here.

preferredName

preferred_name

CC_PROMISE_GRANT_STG

PREFERRED_NAME

See the CCPG Data Specification here.

ssnNo

ssn_no

CC_PROMISE_GRANT_STG

SSN_NO

See the CCPG Data Specification here.

noPermAddressHomeless

no_perm_address_homeless

CC_PROMISE_GRANT_STG

NO_PERM_ADDRESS_HOMELESS

See the CCPG Data Specification here.

noMailingAddressHomeless

no_mailing_address_homeless

CC_PROMISE_GRANT_STG

NO_MAILING_ADDRESS_HOMELESS

See the CCPG Data Specification here.

determinedHomeless

determined_homeless

CC_PROMISE_GRANT_STG

DETERMINED_HOMELESS

See the CCPG Data Specification here.

eligMethodD

elig_method_d

CC_PROMISE_GRANT_STG

ELIG_METHOD_D

See the CCPG Data Specification here.

mainphoneintl

mainphoneintl

CC_PROMISE_GRANT_STG

MAINPHONEINTL

See the CCPG Data Specification here.