List of New Data for Banner SIS
Banner - BOGFW College Adaptor API Call
| 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 |
| Banner Field | Field in Banner that adaptor field is mapped to. A BOG record is only written if one was not previously present, however, in either case data will still be present in the staging/audit table. The staging table is RZRSAAP |
| Mnemonic | Mnemonic in Banner where you can find this field |
Data Elements
| Adaptor Field | Adaptor Enum Values | online App field | Staging /Audit Field | Banner Field | Mnemonic |
|---|---|---|---|---|---|
sisTermId^ | term_code | rzrsaap_term_code | |||
| cccid | ccc_id | rzrsaap_cccid | goradid_additional_id | SPAIDEN | |
| maritalStatus | SINGLE, MARRIED, DIVORCED, SEPARATED, WIDOWED, REG_DOM_PARTNER | marital_status | rzrsaap_marital_status | RVRSAAP_BMTL_CODE | RVASFND |
| regDomPartner | reg_dom_partner | rzrsaap_reg_dom_partner | RVRSAAP_REG_DOM_PARTNER_IND | RVASFND | |
| bornBefore23Year | born_before_23_year | rzrsaap_born_b4_dt | RVRSAAP_BORN_BEF_JAN1_IND | RVASFND | |
| marriedOrRDP | married_or_rdp | rzrsaap_reg_dom_partner_ind | RVRSAAP_MAR_DOM_TODAY_IND | RVASFND | |
| usVeteran | us_veteran | rzrsaap_us_veteran | RVRSAAP_VETERAN_IND | RVASFND | |
| dependents | dependents | rzrsaap_dependents_ind | RVRSAAP_DEPENDENTS_IND | RVASFND | |
| parentsDeceased | parents_deceased | rzrsaap_parents_deceased | RVRSAAP_ORPHAN_WARD_IND | RVASFND | |
| emancipatedMinor | emancipated_minor | rzrsaap_eman_minor_ind | RVRSAAP_EMAN_MINOR_IND | RVASFND | |
| legalGuardianship | legal_guardianship | rzrsaap_legal_guardian_ind | RVRSAAP_LEGAL_GUARD_IND | RVASFND | |
| homelessYouthSchool | homeless_youth_school | rzrsaap_homls_schl_ind | RVRSAAP_HOMLS_SCHL_IND | RVASFND | |
| homelessYouthHUD | homeless_youth_hud | rzrsaap_homls_shltr_ind | RVRSAAP_HOMLS_SHLTR_IND | RVASFND | |
| homelessYouthOther | homeless_youth_other | rzrsaap_homls_cntr_prg_ind | RVRSAAP_HOMLS_CNTR_PRG_IND | RVASFND | |
| dependentOnParentTaxes$ | NO, YES, PARENTS_NOT_FILE | dependent_on_parent_taxes | rzrsaap_parents_tax | RVRSAAP_PARENTS_TAX | RVASFND |
| livingWithParents | living_with_parents | rzrsaap_live_parents_ind | RVRSAAP_LIVE_PARENTS_IND | RVASFND | |
| dependencyStatus* | DEPENDENT, INDEPENDENT | dependency_status | rzrsaap_dependency_stat | RVRSAAP_DEPENDENCY_STAT | RVASFND |
| certVeteranAffairs | cert_veteran_affairs | rzrsaap_cert_vet_affairs | RVRSAAP_CERT_VET_AFFAIRS_IND | RVASFND | |
| certNationalGuard | cert_national_guard | rzrsaap_cert_natl_guard | RVRSAAP_CERT_NAT_GUARD_IND | RVASFND | |
| eligMedalHonor | elig_medal_honor | rzrsaap_elig_medal_honor | RVRSAAP_DOC_F4_STAT_IND | RVASFND | |
| eligSept11 | elig_sept_11 | rzrsaap_elig_sept11 | RVRSAAP_DOC_F5_STAT_IND | RVASFND | |
| eligPoliceFire | elig_police_fire | rzrsaap_elig_police_fire | RVRSAAP_DOC_F1_STAT_IND | RVASFND | |
| tanfCalworks | tanf_calworks | rzrsaap_tanf_calworks | RVRSAAP_DOC_A1_STAT_IND | RVASFND | |
| ssiSSP | ssi_ssp | rzrsaap_ssi_ssp | RVRSAAP_DOC_A2_STAT_IND | RVASFND | |
| generalAssistance | general_assistance | rzrsaap_general_assistance | RVRSAAP_DOC_A3_STAT_IND | RVASFND | |
| parentsAssistance | parents_assistance | rzrsaap_parents_assistance | RVRSAAP_DOC_A_STAT_IND | RVASFND | |
| depNumberHousehold | dep_number_household | rzrsaap_dep_no_house | RVRSAAP_DEP_NO_HOUS | RVASFND | |
| indNumberHousehold | ind_number_household | rzrsaap_ind_no_house | RVRSAAP_IND_NO_HOUSE | RVASFND | |
| depGrossIncome | dep_gross_income | rzrsaap_dep_agi | RVRSAAP_DEP_AGI | RVASFND | |
| indGrossIncome | ind_gross_income | rzrsaap_ind_agi | RVRSAAP_IND_AGI | RVASFND | |
| depOtherIncome | dep_other_income | rzrsaap_dep_other_inc | RVRSAAP_DEP_OTHER_INC | RVASFND | |
| indOtherIncome | ind_other_income | rzrsaap_ind_other_inc | RVRSAAP_IND_OTHER_INC | RVASFND | |
| depTotalIncome | dep_total_income | rzrsaap_dep_total_inc | RVRSAAP_DEP_TOTAL_INC | RVASFND | |
| indTotalIncome | ind_total_income | rzrsaap_ind_total_inc | RVRSAAP_IND_TOTAL_INC | RVASFND |
In Banner BOGW is based on aid year. (eg; '1718')
- When a GET is performed a term is supplied and results returned
- When a POST is performed, the term is converted in to the Financial Aid Year and loaded in to the staging table
dependentOnParentTaxes values of YES and NO map to "Y" and "N" in Colleague respectively. PARENTS_NOT_FILE is "1"
In Banner dependency status is set as "Y" or "N" .
Marital Status has multiple values and stored as follows, S - Single, M- Married, D- Divorced, X- Separated, W- Widow