CC Promise Grant Application SuperGlue Data Mappings - PeopleSoft

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

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_CD

See the BOGFW Data Dictionary here: here

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_NM

See the BOGFW Data Dictionary here: here

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_MAINSMS

See the BOGFW Data Dictionary here: here

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_TS

See the BOGFW Data Dictionary here: here

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_LINE1

See the BOGFW Data Dictionary here: here

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_COUNTRY

See the BOGFW Data Dictionary here: here

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

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_VETERAN

See the BOGFW Data Dictionary here: here

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

PS_CCTC_PMGT_STG

CCTC_PMGT_DPNDPGTX

See the BOGFW Data Dictionary here: here

livingWithParents

living_with_parents

PS_CCTC_PMGT_STG

CCTC_PMGT_LVNG_PGS

See the BOGFW Data Dictionary here: here

dependencyStatus

dependency_status

PS_CCTC_PMGT_STG

CCTC_PMGT_DPNDCY

See the BOGFW Data Dictionary here: here

certVeteranAffairs

cert_veteran_affairs

PS_CCTC_PMGT_STG

CCTC_PMGT_CERT_VA

See the BOGFW Data Dictionary here: here

certNationalGuard

cert_national_guard

PS_CCTC_PMGT_STG

CCTC_PMGT_CERT_NG

See the BOGFW Data Dictionary here: here

eligMedalHonor

elig_medal_honor

PS_CCTC_PMGT_STG

CCTC_PMGT_ELIG_MOH

See the BOGFW Data Dictionary here: here

eligSept11

elig_sept_11

PS_CCTC_PMGT_STG

CCTC_PMGT_ELIG_911

See the BOGFW Data Dictionary here: here

eligPoliceFire

elig_police_fire

PS_CCTC_PMGT_STG

CCTC_PMGT_ELIG_KIA

See the BOGFW Data Dictionary here: here

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_SSP

See the BOGFW Data Dictionary here: here

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_GI

See the BOGFW Data Dictionary here: here

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_TTLI

See the BOGFW Data Dictionary here: here

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_NM

See the BOGFW Data Dictionary here: here

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_TS

See the BOGFW Data Dictionary here: here

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_ADDRESS

See the BOGFW Data Dictionary here: here

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_NM

See the BOGFW Data Dictionary here: here

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_NONE

See the BOGFW Data Dictionary here: here

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