List of New Data for Colleague SIS
Data Elements Table Definitions
| Column | Definition |
|---|---|
| Adaptor Field | Field in the college adaptor |
| Adaptor Enum Values | If the field in the college adaptor has a specific list of values that it can have (known as an "enum" in Java), they are listed in this column |
| Online App Field | Field in the Online BOG Fee Waiver application that the adaptor field corresponds to |
| Staging/Audit Field | Field in the staging/audit table in Colleague that the adaptor field is mapped to. A staging table is used so that a) there an audit trail of what data came in via the college adaptor and b) records that were not written because a record already existed |
| Colleague Field | Field in Colleague that adaptor field is mapped to. A BOGG record is only written if one was not previously present, however, in either case data will still be present in the staging/audit table. |
| Mnemonic | Mnemonic in Colleague where you can find this Colleague Field |
Data Elements
| Adaptor Field | Adaptor Enum Values | Online App Field | Staging/Audit Field | Colleague Field | Mnemonic |
|---|---|---|---|---|---|
| XCTC.BG.STUDENT.ID (PK) | BG.STUDENT.ID | ||||
sisTermId^ | term_code | XCTC.BG.FA.YEAR (PK) | BOGG.ACYR File Suite Year | ||
| XCTC.BG.MIS.CODE | |||||
| ccc_id | XCTC.BG.CCC.ID | PERSON.ALT.IDS | DADD | ||
| maritalStatus | SINGLE, MARRIED, DIVORCED, SEPARATED, WIDOWED, REG_DOM_PARTNER | marital_status | XCTC.BG.MARITAL.STATUS | Not supported | |
| regDomPartner | reg_dom_partner | XCTC.BG.REG.DOM.PARTNER | Not supported | ||
| bornBefore23Year | born_before_23_year | XCTC.BG.BORN.B4.DT | BG.BORN.B4.DT | BOGW | |
| marriedOrRDP | married_or_rdp | XCTC.BG.MARRIED | BG.MARRIED& | BOGW | |
| usVeteran | us_veteran | XCTC.BG.VETERAN | BG.VETERAN | BOGW | |
| dependents | dependents | XCTC.BG.OTHER.DEPEND | BG.OTHER.DEPEND | BOGW | |
| parentsDeceased | parents_deceased | XCTC.BG.ORPHAN.WARD | BG.ORPHAN.WARD | BOGW | |
| emancipatedMinor | emancipated_minor | XCTC.BG.EMANCIPATED.MINOR | BG.EMANCIPATED.MINOR | BOGW | |
| legalGuardianship | legal_guardianship | XCTC.BG.LEGAL.GUARDIAN | BG.LEGAL.GUARDIAN | BOGW | |
| homelessYouthSchool | homeless_youth_school | XCTC.BG.LIAISON.HOMELESS | BG.LIAISON.HOMELESS | BOGW | |
| homelessYouthHUD | homeless_youth_hud | XCTC.BG.EMRG.HOMELESS | BG.EMRG.HOMELESS | BOGW | |
| homelessYouthOther | homeless_youth_other | XCTC.BG.YOUTH.HOMELESS | BG.YOUTH.HOMELESS | BOGW | |
| dependentOnParentTaxes$ | NO, YES, PARENTS_NOT_FILE | dependent_on_parent_taxes | XCTC.BG.EX.PAR.TX | BG.EX.PAR.TX | BOGW |
| livingWithParents | living_with_parents | XCTC.BG.HOUSING.CODE | BG.HOUSING.CODE | BOGW | |
| dependencyStatus* | DEPENDENT, INDEPENDENT | dependency_status | XCTC.BG.DEPENDENCY.STATUS | Derived (output only) | BOGW |
| certVeteranAffairs | cert_veteran_affairs | XCTC.BG.VA.DEP | BG.VA.DEP | BOGW | |
| certNationalGuard | cert_national_guard | XCTC.BG.DEP.CANG | BG.DEP.CANG | BOGW | |
| eligMedalHonor | elig_medal_honor | XCTC.BG.CMOH.RECIP | BG.CMOH.RECIP | BOGW | |
| eligSept11 | elig_sept_11 | XCTC.BG.SEPT11.DEP | BG.SEPT11.DEP | BOGW | |
| eligPoliceFire | elig_police_fire | XCTC.BG.LODD.DEP | BG.LODD.DEP | BOGW | |
| tanfCalworks | tanf_calworks | XCTC.BG.S.TANF | BG.S.TANF | BOGW | |
| ssiSSP | ssi_ssp | XCTC.BG.SSI | BG.SSI | BOGW | |
| generalAssistance | general_assistance | XCTC.BG.GEN.ASST | BG.GEN.ASST | BOGW | |
| parentsAssistance | parents_assistance | XCTC.BG.P.TANF | BG.P.TANF | BOGW | |
| depNumberHousehold | dep_number_household | XCTC.BG.P.NBR.FAMILY | BG.P.NBR.FAMILY | BOGW | |
| indNumberHousehold | ind_number_household | XCTC.BG.S.NBR.FAMILY | BG.S.NBR.FAMILY | BOGW | |
| depGrossIncome | dep_gross_income | XCTC.BG.P.AGI | BG.P.AGI | BOGW | |
| indGrossIncome | ind_gross_income | XCTC.BG.S.AGI | BG.S.AGI | BOGW | |
| depOtherIncome | dep_other_income | XCTC.BG.P.OTH.INC | BG.P.OTH.INC | BOGW | |
| indOtherIncome | ind_other_income | XCTC.BG.S.OTH.INC | BG.S.OTH.INC | BOGW | |
| depTotalIncome | dep_total_income | XCTC.BG.P.TOTAL.INC | BG.P.AGI + BG.P.OTH.INC | BOGW | |
| indTotalIncome | ind_total_income | XCTC.BG.S.TOTAL.INC | BG.S.AGI + BG.S.OTH.INC | BOGW | |
| eligibility | METHOD_A, METHOD_B, METHOD_D, METHOD_A_AND_B, NOT_ELIGIBLE | elig_bogfw | XCTC.BG.ELIGIBILITY | Not supported | BOGW |
| determinedResidentCA | determined_residentca | XCTC.BG.RESIDENT.CA | Not supported | BOGW | |
| determinedAB540Eligible | determined_ab540_eligible | XCTC.BG.CAL.DREAM | BG.CAL.DREAM | BOGW | |
| determinedNonResExempt | determined_non_res_exempt | XCTC.BG.NON.RES.EXEMPT | Not supported | BOGW | |
| determinedHomeless | determined_homeless | XCTC.BG.HOMELESS | Not supported | BOGW | |
| XCTC.BG.STATUS% |
^ In Colleague, BOGW is a year based form, not term based. Therefore:
- When a GET is performed, a term is supplied and will be returned with the result.
- When a POST is performed, the term supplied will dictate with FA Year to write the data to.
- On a GET or POST, if a term matches more than one FA Year, the configuration value FaExchangeBOGYearMatching will determine whether to use the first or last year (default is LAST).
* In Colleague, dependency status is derived based on the following formula (this is displayed in the header of BOGW). When BOGW data is retrieved from a Colleague school, this formula is used to populate this field:
IF (BG.BORN.B4.DT = 'Y' OR BG.VETERAN = 'Y' OR BG.MARRIED = 'Y' OR BG.ORPHAN.WARD = 'Y' OR BG.OTHER.DEPEND EQ='Y')
"Independent"
ELSE IF (BG.EX.PAR.TX = 'Y' OR BG.HOUSING.CODE EQ 'Y') THEN
"Dependent"
ELSE
"Independent"
$ dependentOnParentTaxes values of YES and NO map to "Y" and "N" in Colleague respectively. PARENTS_NOT_FILE is not mapped.
% XCTC.BG.STATUS indicates a status of whether the import was successful.
- 1 = success
- 2 = BOGW record already exists
& When updating BOGW in Colleague, the field BG.MARRIED will check multiple sources as needed:
- if marriedOrRDP = true, BG.MARRIED is set to "Y"
- else if marriedOrRDP = false, BG.MARRIED is set to "N"
- else if regDomPartner = true, BG.MARRIED is set to "Y"
- else if maritalStatus = MARRIED, SEPARATED or REG_DOM_PARTNER, BG.MARRIED it set to "Y"
- else if maritalStatus is anything other than MARRIED, SEPARATED or REG_DOM_PARTNER, BG.MARRIED it set to "N"