Versions Compared

Old Version 1

changes.mady.by.user Patricia Donohue

Saved on

compared with

New Version Current

changes.mady.by.user Patricia Donohue

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Panel
panelIconIdatlassian-info
panelIcon:info:
bgColor#F4F5F7

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

Contents

Table of Contents
minLevel1
maxLevel2

latest version of the CC Promise Grant Online Application. See CCCApply Release Notespage for related updates.

...

CC Promise Grant Data Fields Table Mapping - PeopleSoft

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

College Adaptor Payload Field Name

Data Dictionary Name

PS Table Name

PS Name

Explanation

Notes

appId

studentDeps18Over

app_id

student_deps_18Over

PS_CCTC_PMGT_STG

CCTC_APPL_DEPS_18O

SG v.4.10

studentDepsUnder18

student_deps_Under18

PS_CCTC_PMGT_STG

CCTC_APPL_DEPS_U18

SG v.4.10

idmeConfirmationTimestamp

idme_confirmation_timestamp

PS_CCTC_PMGT_STG

CCTC_IDME_CNFRM_TS

SG v.4.9

idmeOptinTimestamp

idme_optin_timestamp

PS_CCTC_PMGT_STG

CCTC_IDME_OPTIN_TS

SG v.4.9

idmeWorkflowStatus

idme_workflow_status

PS_CCTC_PMGT_STG

CCTC_IDME_WKFL_STS

SG v.4.9

studentParent

student_parent

PS_CCTC_PMGT_STG

CCTC_APPL_STD_PAR

Question added Apply v.6.13 / SG v.4.7

acceptedTerms

accepted_terms

PS_CCTC_PMGT_STG

CCTC_APPL_ACC_TRMS

SG v.4.7

acceptedTermsTimestamp

accepted_terms_timestamp

PS_CCTC_PMGT_STG

CCTC_APPL_ATRMS_TS

SG v.4.7

addressValidationOverride

address_validation_override

PS_CCTC_PMGT_STG

CCTC_MADDR_VOVR

SG v.4.6

addressValidationOverrideTimestamp

address_validation_override_timestamp

PS_CCTC_PMGT_STG

CCTC_MADDR_VOVR_TS

SG v.4.6

emailVerified

email_verified

PS_CCTC_PMGT_STG

CCTC_EMAIL_VER

SG v.4.6

emailVerifiedTimestamp

email_verified_timestamp

PS_CCTC_PMGT_STG

CCTC_EMAIL_VER_TS

SG v.4.6

ipAddressAtAccountCreation

ip_address_at_account_creation

PS_CCTC_PMGT_STG

CCTC_APPL_IP_ACCT

SG v.4.7

ipAddressAtAppCreation

ip_address_at_app_creation

PS_CCTC_PMGT_STG

CCTC_APPL_IP_APP

SG v.4.7

mailingAddressValidationOverride

mailing_address_validation_override

PS_CCTC_PMGT_STG

CCTC_MADDR_VOVR2

SG v.4.7

mainphoneVerified

phone_verified

PS_CCTC_PMGT_STG

CCTC_PHONE_MN_VER

SG v.4.6

mainphoneVerifiedTimestamp

phone_verified_timestamp

PS_CCTC_PMGT_STG

CCTC_PHONE_MN_VRTS

SG v.4.6

phoneType

phone_type

PS_CCTC_PMGT_STG

CCTC_PHONE_MN_TYPE

SG v.4.7

preferredMethodOfContact

preferred_contact_method

PS_CCTC_PMGT_STG

CCTC_PRF_CNCT_MTHD

SG v.4.6

sisReceipt

sis_receipt

PS_CCTC_PMGT_STG

Coming

appId

app_id

PS_CCTC_PMGT_STG

CCTC_PMGT_ID

See the BOGFW Data Dictionary here: here

ccId

ccc_id

PS_CCTC_PMGT_STG

CCTC_CCCID

See the BOGFW Data Dictionary here: here

CCTC_CCCID

confirmationNumber

confirmation_number

PS_CCTC_PMGT_STG

CCTC_APPL_CFRM_NBR

See the BOGFW Data Dictionary here: here

status

status

PS_CCTC_PMGT_STG

CCTC_APPL_STATUS

See the BOGFW Data Dictionary here: here

appLang

app_lang

PS_CCTC_PMGT_STG

CCTC_APPL_LANG_CD

See the BOGFW Data Dictionary here: here

collegeId

college_id

PS_CCTC_PMGT_STG

CCTC_MIS_CD

See the BOGFW Data Dictionary here: here

yearCode

year_code

PS_CCTC_PMGT_STG

CCTC_PMGT_

YEAR_CDSee the BOGFW Data Dictionary here: here

YEAR_CD

yearDescription

year_description

PS_CCTC_PMGT_STG

CCTC_PMGT_YEAR_DS

See the BOGFW Data Dictionary here: here

determinedResidentca

determined_residentca

PS_CCTC_PMGT_STG

CCTC_PMGT_CA_RESI

See the BOGFW Data Dictionary here: here

determinedAB540Eligible

determined_ab540_eligible

PS_CCTC_PMGT_STG

CCTC_APPL_ELGAB540

See the BOGFW Data Dictionary here: here

determinedNonResExempt

determined_non_res_exempt

PS_CCTC_PMGT_STG

CCTC_PMGT_CARESI_E

See the BOGFW Data Dictionary here: here

lastname

lastname

PS_CCTC_PMGT_STG

CCTC_LGL_

LAST_NMSee the BOGFW Data Dictionary here: here

LAST_NM

firstname

firstname

PS_CCTC_PMGT_STG

CCTC_LGL_FIRST_NM

See the BOGFW Data Dictionary here: here

middlename

middlename

PS_CCTC_PMGT_STG

CCTC_LGL_MIDDLE_NM

See the BOGFW Data Dictionary here: here

mainphone

mainphone

PS_CCTC_PMGT_STG

CCTC_PHONE_MAIN

See the BOGFW Data Dictionary here: here

mainphoneExt

mainphone_ext

PS_CCTC_PMGT_STG

CCTC_PHONE_MAIN_EX

See the BOGFW Data Dictionary here: here

mainphoneAuthText

mainphone_auth_text

PS_CCTC_PMGT_STG

CCTC_

PHONE_MAINSMSSee the BOGFW Data Dictionary here: here

PHONE_MAINSMS

mainphoneVerified

mainphone_verified

PS_CCTC_PMGT_STG

CCTC_PHONE_MN_VER

See the BOGFW Data Dictionary here: here

mainphoneVerifiedTimestamp

mainphone_verified_timestmp

PS_CCTC_PMGT_STG

CCTC_PHONE_MN_VRTS

See the BOGFW Data Dictionary here: here

email

email

PS_CCTC_PMGT_STG

CCTC_EMAIL

See the BOGFW Data Dictionary here: here

emailVerified

email_verified

PS_CCTC_PMGT_STG

CCTC_EMAIL_VER

See the BOGFW Data Dictionary here: here

emailVerifiedTimestamp

email_verified_timestamp

PS_CCTC_PMGT_STG

CCTC_EMAIL_

VER_TSSee the BOGFW Data Dictionary here: here

VER_TS

preferredMethodOfContact

preferred_method_of_contact

PS_CCTC_PMGT_STG

CCTC_PRF_CNCT_MTHD

See the BOGFW Data Dictionary here: here

nonUsAddress

non_us_address

PS_CCTC_PMGT_STG

CCTC_MADDR_USA

See the BOGFW Data Dictionary here: here

addressValidationOverride

address_validation_override

PS_CCTC_PMGT_STG

CCTC_MADDR_VOVR

See the BOGFW Data Dictionary here: here

addressValidationOverrideTimestamp

address_validation_override_timestamp

PS_CCTC_PMGT_STG

CCTC_MADDR_VOVR_TS

See the BOGFW Data Dictionary here: here

streetaddress1

streetaddress1

PS_CCTC_PMGT_STG

CCTC_

MADDR_LINE1See the BOGFW Data Dictionary here: here

MADDR_LINE1

streetaddress2

streetaddress2

PS_CCTC_PMGT_STG

CCTC_MADDR_LINE2

See the BOGFW Data Dictionary here: here

city

city

PS_CCTC_PMGT_STG

CCTC_MADDR_CITY

See the BOGFW Data Dictionary here: here

state

state

PS_CCTC_PMGT_STG

CCTC_MADDR_STATE

See the BOGFW Data Dictionary here: here

province

province

PS_CCTC_PMGT_STG

CCTC_MADDR_PRVINCE

See the BOGFW Data Dictionary here: here

country

country

PS_CCTC_PMGT_STG

CCTC_

MADDR_COUNTRYSee the BOGFW Data Dictionary here: here

MADDR_COUNTRY

postalcode

postalcode

PS_CCTC_PMGT_STG

CCTC_MADDR_POSTCD

See the BOGFW Data Dictionary here: here

ssn

ssn

PS_CCTC_PMGT_STG

CCTC_SSN

See the BOGFW Data Dictionary here: here

ssnType

ssn_type

PS_CCTC_PMGT_STG

CCTC_APPL_SSN_TYPE

See the BOGFW Data Dictionary here: here

studentCollegeId

student_college_id

PS_CCTC_PMGT_STG

CCTC_PMGT_EMPLID

See the BOGFW Data Dictionary here: here

birthdate

birthdate

PS_CCTC_PMGT_STG

CCTC_BIRTHDATE

See the BOGFW Data Dictionary here: here

CCTC_BIRTHDATE

maritalStatus

marital_status

PS_CCTC_PMGT_STG

CCTC_MARITAL_STAT

See the BOGFW Data Dictionary here: here

regDomPartner

reg_dom_partner

PS_CCTC_PMGT_STG

CCTC_PMGT_APG_RDP

See the BOGFW Data Dictionary here: here

bornBefore23Year

born_before_23_year

PS_CCTC_PMGT_STG

CCTC_PMGT_OVER23

See the BOGFW Data Dictionary here: here

marriedOrRdp

married_or_rdp

PS_CCTC_PMGT_STG

CCTC_PMGT_MRD_RDP

See the BOGFW Data Dictionary here: here

usVeteran

us_veteran

PS_CCTC_PMGT_STG

CCTC_

USA_VETERANSee the BOGFW Data Dictionary here: here

USA_VETERAN

dependents

dependents

PS_CCTC_PMGT_STG

CCTC_PMGT_DPNDTS

See the BOGFW Data Dictionary here: here

parentsDeceased

parents_deceased

PS_CCTC_PMGT_STG

CCTC_PMGT_PG_DECD

See the BOGFW Data Dictionary here: here

emancipatedMinor

emancipated_minor

PS_CCTC_PMGT_STG

CCTC_PMGT_EMANCPTD

See the BOGFW Data Dictionary here: here

legalGuardianship

legal_guardianship

PS_CCTC_PMGT_STG

CCTC_PMGT_LGL_GRDN

See the BOGFW Data Dictionary here: here

homelessYouthSchool

homeless_youth_school

PS_CCTC_PMGT_STG

CCTC_PMGT_HL_EDU

See the BOGFW Data Dictionary here: here

homelessYouthHud

homeless_youth_hud

PS_CCTC_PMGT_STG

CCTC_PMGT_HL_HUD

See the BOGFW Data Dictionary here: here

homelessYouthOther

homeless_youth_other

PS_CCTC_PMGT_STG

CCTC_PMGT_HL_MISC

See the BOGFW Data Dictionary here: here

dependentOnParentTaxes

dependent_on_parent_taxes

dependentOnParentTaxes

dependent_on_parent_taxes

PS_CCTC_PMGT_STG

CCTC_PMGT_DPNDPGTX

livingWithParents

living_with_parents

PS_CCTC_PMGT_STG

CCTC_PMGT_LVNG_PGS

dependencyStatus

dependency_status

PS_CCTC_PMGT_STG

CCTC_PMGT_

DPNDPGTX

See the BOGFW Data Dictionary here: here

livingWithParents

living_with_parents

DPNDCY

certVeteranAffairs

cert_veteran_affairs

PS_CCTC_PMGT_STG

CCTC_PMGT_

LVNG

CERT_

PGS

See the BOGFW Data Dictionary here: here

dependencyStatus

dependency_status

VA

certNationalGuard

cert_national_guard

PS_CCTC_PMGT_STG

CCTC_PMGT_CERT_

DPNDCY

See the BOGFW Data Dictionary here: here

certVeteranAffairs

cert_veteran_affairs

NG

eligMedalHonor

elig_medal_honor

PS_CCTC_PMGT_STG

CCTC_PMGT_

CERT

ELIG_

VA

See the BOGFW Data Dictionary here: here

certNationalGuard

cert_national_guard

MOH

eligSept11

elig_sept_11

PS_CCTC_PMGT_STG

CCTC_PMGT

_CERT_NG

See the BOGFW Data Dictionary here: here

eligMedalHonor

_ELIG_911

eligPoliceFire

elig_

medal

police_

honor

fire

PS_CCTC_PMGT_STG

CCTC_PMGT_ELIG_

MOH

See the BOGFW Data Dictionary here: here

eligSept11

KIA

eligCovidDeath

elig_

sept

covid_

11

death

PS_CCTC_PMGT_STG

CCTC_

PMGT

COVID_

ELIG_911

See the BOGFW Data Dictionary here: here

eligPoliceFire

DEATH

Question added 2022-2023 / SG v.4.4

eligExoneratedCrime

elig_

police

exonerated_

fire

crime

PS_CCTC_PMGT_STG

CCTC_

PMGT

ELIG_

ELIG

EX_

KIASee the BOGFW Data Dictionary here: here

CRIME

Question added 2022-2023 / SG v.4.4

tanfCalworks

tanf_calworks

PS_CCTC_PMGT_STG

CCTC_PMGT_TANF_CW

See the BOGFW Data Dictionary here: here

ssiSsp

ssi_ssp

PS_CCTC_PMGT_STG

CCTC_PMGT_

SSI_SSPSee the BOGFW Data Dictionary here: here

SSI_SSP

generalAssistance

general_assistance

PS_CCTC_PMGT_STG

CCTC_PMGT_GEN_HELP

See the BOGFW Data Dictionary here: here

parentsAssistance

parents_assistance

PS_CCTC_PMGT_STG

CCTC_PMGT_PG_HELP

See the BOGFW Data Dictionary here: here

depNumberHousehold

dep_number_household

PS_CCTC_PMGT_STG

CCTC_PMGT_DP_NBRHH

See the BOGFW Data Dictionary here: here

indNumberHousehold

ind_number_household

PS_CCTC_PMGT_STG

CCTC_PMGT_ID_NBRHH

See the BOGFW Data Dictionary here: here

depGrossIncome

dep_gross_income

PS_CCTC_PMGT_STG

CCTC_PMGT_

DP_GISee the BOGFW Data Dictionary here: here

DP_GI

indGrossIncome

ind_gross_income

PS_CCTC_PMGT_STG

CCTC_PMGT_IND_GI

See the BOGFW Data Dictionary here: here

depOtherIncome

dep_other_income

PS_CCTC_PMGT_STG

CCTC_PMGT_DP_MSCI

See the BOGFW Data Dictionary here: here

indOtherIncome

ind_other_income

PS_CCTC_PMGT_STG

CCTC_PMGT_IND_MSCI

See the BOGFW Data Dictionary here: here

depTotalIncome

dep_total_income

PS_CCTC_PMGT_STG

CCTC_PMGT_DP_TTLI

See the BOGFW Data Dictionary here: here

indTotalIncome

ind_total_income

PS_CCTC_PMGT_STG

CCTC_PMGT_

IND_TTLISee the BOGFW Data Dictionary here: here

IND_TTLI

eligMethodA

elig_method_a

PS_CCTC_PMGT_STG

CCTC_PMGT_ELIG_A

See the BOGFW Data Dictionary here: here

eligMethodB

elig_method_b

PS_CCTC_PMGT_STG

CCTC_PMGT_ELIG_B

See the BOGFW Data Dictionary here: here

eligBogfw

elig_bogfw

PS_CCTC_PMGT_STG

CCTC_PMGT_ELIGIBLE

See the BOGFW Data Dictionary here: here

confirmationParentGuardian

confirmation_parent_guardian

PS_CCTC_PMGT_STG

CCTC_PMGT_PG_CNFRM

See the BOGFW Data Dictionary here: here

parentGuardianName

parent_guardian_name

PS_CCTC_PMGT_STG

CCTC_PG1_

FULL_NMSee the BOGFW Data Dictionary here: here

FULL_NM

ackFinAid

ack_fin_aid

PS_CCTC_PMGT_STG

CCTC_APPL_ACK_FA

See the BOGFW Data Dictionary here: here

confirmationApplicant

confirmation_applicant

PS_CCTC_PMGT_STG

CCTC_PMGT_AP_CNFRM

See the BOGFW Data Dictionary here: here

lastPage

last_page

PS_CCTC_PMGT_STG

CCTC_APPL_LAST_PG

See the BOGFW Data Dictionary here: here

ssnLast4

ssn_last4

PS_CCTC_PMGT_STG

CCTC_SSN_LST4

See the BOGFW Data Dictionary here: here

tstmpSubmit

tstmp_submit

PS_CCTC_PMGT_STG

CCTC_APPL_

SBMT_TSSee the BOGFW Data Dictionary here: here

SBMT_TS

tstmpCreate

tstmp_create

PS_CCTC_PMGT_STG

CCTC_APPL_CRTE_TS

See the BOGFW Data Dictionary here: here

tstmpUpdate

tstmp_update

PS_CCTC_PMGT_STG

CCTC_APPL_UPDT_TS

See the BOGFW Data Dictionary here: here

tstmpDownload

tstmp_download

PS_CCTC_PMGT_STG

CCTC_APPL_DWNLD_TS

See the BOGFW Data Dictionary here: here

termCode

term_code

PS_CCTC_PMGT_STG

CCTC_APPL_TERM_CD

See the BOGFW Data Dictionary here: here

ipAddress

ip_address

PS_CCTC_PMGT_STG

CCTC_

IP_ADDRESSSee the BOGFW Data Dictionary here: here

IP_ADDRESS

campaign1

campaign1

PS_CCTC_PMGT_STG

CCTC_APPL_CAMPGN1

See the BOGFW Data Dictionary here: here

campaign2

campaign2

PS_CCTC_PMGT_STG

CCTC_APPL_CAMPGN2

See the BOGFW Data Dictionary here: here

campaign3

campaign3

PS_CCTC_PMGT_STG

CCTC_APPL_CAMPGN3

See the BOGFW Data Dictionary here: here

ssnException

ssn_exception

PS_CCTC_PMGT_STG

CCTC_APPL_SSN_EXCP

See the BOGFW Data Dictionary here: here

collegeName

college_name

PS_CCTC_PMGT_STG

CCTC_APPL_

COL_NMSee the BOGFW Data Dictionary here: here

COL_NM

preferredFirstname

preferred_firstname

PS_CCTC_PMGT_STG

CCTC_PRF_FIRST_NM

See the BOGFW Data Dictionary here: here

preferredMiddlename

preferred_middlename

PS_CCTC_PMGT_STG

CCTC_PRF_MIDDLE_NM

See the BOGFW Data Dictionary here: here

preferredLastname

preferred_lastname

PS_CCTC_PMGT_STG

CCTC_PRF_LAST_NM

See the BOGFW Data Dictionary here: here

preferredName

preferred_name

PS_CCTC_PMGT_STG

CCTC_PRF_NM_SET

See the BOGFW Data Dictionary here: here

ssnNo

ssn_no

PS_CCTC_PMGT_STG

CCTC_APPL_

SSN_NONESee the BOGFW Data Dictionary here: here

SSN_NONE

noPermAddressHomeless

no_perm_address_homeless

PS_CCTC_PMGT_STG

CCTC_PADDR_HOMELSS

See the BOGFW Data Dictionary here: here

noMailingAddressHomeless

no_mailing_address_homeless

PS_CCTC_PMGT_STG

CCTC_MADDR_HOMELSS

See the BOGFW Data Dictionary here: here

determinedHomeless

determined_homeless

PS_CCTC_PMGT_STG

CCTC_PMGT_HL_FAO

See the BOGFW Data Dictionary here: here

eligMethodD

elig_method_d

PS_CCTC_PMGT_STG

CCTC_PMGT_ELIG_D

See the BOGFW Data Dictionary here: here

mainphoneintl

mainphoneintl

PS_CCTC_PMGT_STG

CCTC_PHONE_MAININT

See the BOGFW Data Dictionary here: here

sisProcessedFlag


PS_CCTC_PMGT_STG

STATUS_FLAG

A single character blank value whenever a new row is created. May be optionally used by the college to track processing

tstmpSISProcessed


PS_CCTC_PMGT_STG

STATUS_DTTM

Used for tracking/processing; defaults to the current date/time when a row is created, should be updated if/when the STATUS_FLAG field is changed

sisProcessedNotes


PS_CCTC_PMGT_STG

DESCRLONG_NOTES

A blank value whenever a new row is created. May be optionally used by the college to track processing



PS_CCTC_PMGT_STG

LASTUPDOPRID

The default value is “CCTC” when a row is created, but this value should be updated to whichever operatorID the college’s IT department changes it to, if desired



PS_CCTC_PMGT_STG

LASTUPDDTTM

Last updated date/time