Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

Version 1 Next »


Superglue ReleaseMinimum College Adaptor VersionFileNotesColleague
Resources
SGv4.1.0CAv4.1.0B93_XCTC.CCPG.V1_004.zip

Per PLATFORM-858, PLATFORM-859, PLATFORM-860, PLATFORM-856, added the OpenCCC 2.0 data fields:

addressValidationOverride: ADDRESS.VALIDATION.O

addressValidationOverrideTimestamp: ADDRESS.VALID.O.DATE, ADDRESS.VALID.O.TIME

emailVerified: EMAIL.VERIFIED

emailVerifiedTimestamp: EMAIL.VERIFIED.DATE, EMAIL.VERIFIED.TIME

mainphoneVerified: MAINPHONE.VERIFIED

mainphoneVerifiedTimestamp: MAINPHONE.VRFD.DATE, MAINPHONE.VRFD.TIME

preferredMethodOfContact: PREFERRED.METHOD.CON

Entities

  • XCTC.CCPG.APPL
SGv3.0.0CAv3.0.0B93_XCTC.CCPG.V1_003.zip

Per CADAPTER-196, added Processed Date and Time stamps and User field to table

AKA: Colleague_Patch_CCPG_v3.0.0.zip

Entities

  • XCTC.CCPG.APPL
SGv2.8.0CAv2.7.0002 file not foundPer CADAPTER-150, added Processed Flag to table

Entities

  • XCTC.CCPG.APPL
SGv2.6.0CAv2.5.0
B93_XCTC.CCPG.V1_001.zip

Per CADAPTER-83, initial support for ccpromise applications.

AKA: release 1.0

Entities

  • XCTC.CCPG.APPL

CC Promise Grant Application / Colleague Table Mappings

More details can be found in the BOGFW section on the Data Dictionaries page

College Adaptor Payload FieldData Dictionary NameColleague Table NameColleague Field NameExplanation
appIdapp_id
XCTC.CCPG.APPL
XCTC.CCPG.APPL.ID

ccIdccc_id
XCTC.CCPG.APPL
XCTC.CP.CCC.ID
confirmationNumberconfirmation_numberXCTC.CCPG.APPLXCTC.CP.CONFIRMATION.NUMBER

statusXCTC.CCPG.APPLXCTC.CP.STATUS
appLangapp_langXCTC.CCPG.APPL
XCTC.CP.APP.LANG


college_idXCTC.CCPG.APPLXCTC.CP.COLLEGE.ID
yearCodeyear_codeXCTC.CCPG.APPLXCTC.CP.YEAR.CODE
yearDescriptionyear_descriptionXCTC.CCPG.APPLXCTC.CP.YEAR.DESCRIPTION
determinedResidentcadetermined_residentcaXCTC.CCPG.APPLXCTC.CP.DETERMINED.RESIDENTC
determinedAB540Eligibledetermined_ab540_eligibleXCTC.CCPG.APPLXCTC.CP.DETERMINED.AB540.ELI
determinedNonResExemptdetermined_non_res_exemptXCTC.CCPG.APPLXCTC.CP.DETERMINED.NON.RES.E
lastnamelastnameXCTC.CCPG.APPLXCTC.CP.LASTNAME
firstnamefirstnameXCTC.CCPG.APPLXCTC.CP.FIRSTNAME
middlenamemiddlenameXCTC.CCPG.APPLXCTC.CP.MIDDLENAME
mainphonemainphoneXCTC.CCPG.APPLXCTC.CP.MAINPHONE
mainphoneExtmainphone_extXCTC.CCPG.APPLXCTC.CP.MAINPHONE.AUTH.EXT
mainphoneAuthTextmainphone_auth_textXCTC.CCPG.APPLXCTC.CP.MAINPHONE.AUTH.TEXT
emailemailXCTC.CCPG.APPLXCTC.CP.EMAIL
nonUsAddressnon_us_addressXCTC.CCPG.APPLXCTC.CP.NON.US.ADDRESS
streetaddress1streetaddress1XCTC.CCPG.APPLXCTC.CP.STREETADDRESS1
streetaddress2streetaddress2XCTC.CCPG.APPLXCTC.CP.STREETADDRESS2
citycityXCTC.CCPG.APPLXCTC.CP.CITY
statestateXCTC.CCPG.APPLXCTC.CP.STATE
provinceprovinceXCTC.CCPG.APPLXCTC.CP.PROVINCE
countrycountryXCTC.CCPG.APPLXCTC.CP.COUNTRY
postalcodepostalcodeXCTC.CCPG.APPLXCTC.CP.POSTALCODE
ssnssnXCTC.CCPG.APPLXCTC.CP.SSN
ssnTypessn_typeXCTC.CCPG.APPLXCTC.CP.SSN.TYPE
studentCollegeIdstudent_college_idXCTC.CCPG.APPLXCTC.CP.STUDENT.COLLEGE.ID
birthdatebirthdateXCTC.CCPG.APPL
XCTC.CP.BIRTHDATE

maritalStatusmarital_statusXCTC.CCPG.APPLXCTC.CP.MARITAL.STATUS
regDomPartnerreg_dom_partnerXCTC.CCPG.APPLXCTC.CP.REG.DOM.PARTNER
bornBefore23Yearborn_before_23_yearXCTC.CCPG.APPL
XCTC.CP.BORN.BEFORE.23.YEAR

marriedOrRdpmarried_or_rdpXCTC.CCPG.APPLXCTC.CP.MARRIED.OR.RDP
usVeteranus_veteranXCTC.CCPG.APPLXCTC.CP.US.VETERAN
dependentsdependentsXCTC.CCPG.APPLXCTC.CP.DEPENDENTS
parentsDeceasedparents_deceasedXCTC.CCPG.APPLXCTC.CP.PARENTS.DECEASED
emancipatedMinoremancipated_minorXCTC.CCPG.APPLXCTC.CP.EMANCIPATED.MINOR
legalGuardianshiplegal_guardianshipXCTC.CCPG.APPLXCTC.CP.LEGAL.GUARDIANSHIP
homelessYouthSchoolhomeless_youth_schoolXCTC.CCPG.APPLXCTC.CP.HOMELESS.YOUTH.SCHOO
homelessYouthHudhomeless_youth_hudXCTC.CCPG.APPLXCTC.CP.HOMELESS.YOUTH.HUD
homelessYouthOtherhomeless_youth_otherXCTC.CCPG.APPLXCTC.CP.HOMLESS.YOUTH.OTHER
dependentOnParentTaxesdependent_on_parent_taxesXCTC.CCPG.APPLXCTC.CP.DEPENDENT.PARENT.TAX
livingWithParentsliving_with_parentsXCTC.CCPG.APPLXCTC.CP.LIVING.WITH.PARENTS
dependencyStatusdependency_statusXCTC.CCPG.APPLXCTC.CP.DEPENDENCY.STATUS
certVeteranAffairscert_veteran_affairsXCTC.CCPG.APPLXCTC.CP.CERT.VETERAN.AFFAIRS
certNationalGuardcert_national_guardXCTC.CCPG.APPLXCTC.CP.CERT.NATIONAL.GUARD
eligMedalHonorelig_medal_honorXCTC.CCPG.APPLXCTC.CP.ELIG.MEDAL.HONOR
eligSept11elig_sept_11XCTC.CCPG.APPLXCTC.CP.ELIG.SEPT.11
eligPoliceFireelig_police_fireXCTC.CCPG.APPLXCTC.CP.ELIG.POLICE.FIRE
tanfCalworkstanf_calworksXCTC.CCPG.APPLXCTC.CP.TANF.CALWORKS
ssiSspssi_sspXCTC.CCPG.APPLXCTC.CP.SSI.SSP
generalAssistancegeneral_assistanceXCTC.CCPG.APPLXCTC.CP.GENERAL.ASSISTANCE
parentsAssistanceparents_assistanceXCTC.CCPG.APPLXCTC.CP.PARENTS.ASSISTANCE
depNumberHouseholddep_number_householdXCTC.CCPG.APPLXCTC.CP.DEP.NUMBER.HOUSEHOLD
indNumberHouseholdind_number_householdXCTC.CCPG.APPLXCTC.CP.IND.NUMBER.HOUSEHOLD
depGrossIncomedep_gross_incomeXCTC.CCPG.APPLXCTC.CP.DEP.GROSS.INCOME
indGrossIncomeind_gross_incomeXCTC.CCPG.APPLXCTC.CP.IND.GROSS.INCOME
depOtherIncomedep_other_incomeXCTC.CCPG.APPLXCTC.CP.DEP.OTHER.INCOME
indOtherIncomeind_other_incomeXCTC.CCPG.APPLXCTC.CP.IND.OTHER.INCOME
depTotalIncomedep_total_incomeXCTC.CCPG.APPLXCTC.CP.DEP.TOTAL.INCOME
indTotalIncomeind_total_incomeXCTC.CCPG.APPLXCTC.CP.IND.TOTAL.INCOME
eligMethodAelig_method_aXCTC.CCPG.APPLXCTC.CP.ELIG.METHOD.A
eligMethodBelig_method_bXCTC.CCPG.APPLXCTC.CP.ELIG.METHOD.B
eligBogfwelig_bogfwXCTC.CCPG.APPLCTC.CP.ELIG.BOGFW
confirmationParentGuardianconfirmation_parent_guardianXCTC.CCPG.APPLXCTC.CP.CONFIRMATION.PARENTG
parentGuardianNameparent_guardian_nameXCTC.CCPG.APPLXCTC.CP.PARENT.GUARDIAN.NAME
ackFinAidack_fin_aidXCTC.CCPG.APPL
XCTC.CP.ACK.FIN.AID

confirmationApplicantconfirmation_applicantXCTC.CCPG.APPLXCTC.CP.CONFIRMATION.APPLICA
lastPagelast_pageXCTC.CCPG.APPLXCTC.CP.LAST.PAGE
ssnLast4ssn_last4XCTC.CCPG.APPLXCTC.CP.SSN.LAST4
tstmpSubmittstmp_submitXCTC.CCPG.APPLXCTC.CP.TSTMP.SUBMIT.DATE + XCTC.CP.TSTMP.SUBMIT.TIME
tstmpCreatetstmp_createXCTC.CCPG.APPLXCTC.CP.TSTMP.CREATE.DATE + XCTC.CP.TSTMP.CREATE.TIME
tstmpUpdatetstmp_update--

Not supported in Colleague

tstmpDownloadtstmp_downloadXCTC.CCPG.APPLXCTC.CP.TSTMP.DOWNLOAD.DATE + XCTC.CP.TSTMP.DOWNLOAD.TIME

tstmpSISProcessed

-XCTC.CCPG.APPLXCTC.CP.PROCESSED.DATE + XCTC.CP.PROCESSED.TIME-
--XCTC.CCPG.APPLXCTC.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.

termCodeterm_codeXCTC.CCPG.APPLXCTC.CP.TERM.CODE

ip_addressXCTC.CCPG.APPLXCTC.CP.IP.ADDRESS
campaign1campaign1XCTC.CCPG.APPL

XCTC.CP.CAMPAIGN1


campaign2campaign2XCTC.CCPG.APPL

XCTC.CP.CAMPAIGN2


campaign3campaign3XCTC.CCPG.APPL

XCTC.CP.CAMPAIGN3



ssn_exceptionXCTC.CCPG.APPLXCTC.CP.SSN.EXCEPTION
collegeNamecollege_nameXCTC.CCPG.APPLXCTC.CP.COLLEGE.NAME
preferredFirstnamepreferred_firstnameXCTC.CCPG.APPLXCTC.CP.PREFERRED.FIRSTNAME
preferredMiddlenamepreferred_middlenameXCTC.CCPG.APPLXCTC.CP.PREFERRED.MIDDLENAME
preferredLastnamepreferred_lastnameXCTC.CCPG.APPLXCTC.CP.PREFERRED.LASTNAME
preferredNamepreferred_nameXCTC.CCPG.APPLXCTC.CP.PREFERRED.NAME
ssnNossn_noXCTC.CCPG.APPLXCTC.CP.SSN.NO
noPermAddressHomelessno_perm_address_homelessXCTC.CCPG.APPLXCTC.CP.NO.PERM.ADDRESS.HOME
noMailingAddressHomelessno_mailing_address_homelessXCTC.CCPG.APPLXCTC.CP.NO.MAILING.ADDRESS
determinedHomelessdetermined_homelessXCTC.CCPG.APPLXCTC.CP.DETERMINED.HOMELESS
eligMethodDelig_method_dXCTC.CCPG.APPLXCTC.CP.ELIG.METHOD.D
mainphoneintlmainphoneintlXCTC.CCPG.APPLXCTC.CP.MAINPHONEINTL
addressValidationOverrideaddress_validation_overrideXCTC.CCPG.APPLXCTC.CP.ADDRESS.VALIDATION.O
addressValidationOverrideTimestampaddress_validation_override_timestampXCTC.CCPG.APPLXCTC.CP.ADDRESS.VALID.O.DATE


XCTC.CCPG.APPLXCTC.CP.ADDRESS.VALID.O.TIME
emailVerifiedemail_verifiedXCTC.CCPG.APPLXCTC.CP.EMAIL.VERIFIED
emailVerifiedTimestampemail_verified_timestampXCTC.CCPG.APPLXCTC.CP.EMAIL.VERIFIED.DATE


XCTC.CCPG.APPLXCTC.CP.EMAIL.VERIFIED.TIME
mainphoneVerifiedmain_phone_verifiedXCTC.CCPG.APPLXCTC.CP.MAINPHONE.VERIFIED
mainphoneVerifiedTimestampmain_phone_verified_timestampXCTC.CCPG.APPLXCTC.CP.MAINPHONE.VRFD.DATE


XCTC.CCPG.APPLXCTC.CP.MAINPHONE.VRFD.TIME
preferredMethodOfContactpreferred_method_of_contactXCTC.CCPG.APPLXCTC.CP.PREFERRED.METHOD.CON
sisProcessedNotes

XCTC.CCPG.APPLXCTC.CP.USER1


XCTC.CCPG.APPLXCTC.CP.USER2


XCTC.CCPG.APPLXCTC.CP.USER3
sisProcessFlag--

-

Y/N value based on if XCTC.CP.PROCESSED.DATE has a value or not
  • No labels