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')
...