List of APIs by Iia7Y8E

VIEWS: 16 PAGES: 136

									API Overview
Beginning with the 7.0 release, Banner includes Application Programming Interfaces (APIs). An API is a central program that creates, updates,
and deletes data. Previously, this business logic was encoded in Banner forms and processes.

APIs provide several advantages:

       They support integration by exposing Banner business entities to external applications.
       They ensure consistent edit and validation business logic.
       They simplify code by encapsulating business logic in database packages.
       They eliminate duplicate code that would otherwise be maintained in multiple applications.
       They leverage messaging support so that Banner becomes “messaging enabled.”

Banner has two kinds of APIs: business entity APIs and business process APIs.

Business Entity APIs
A business entity is the smallest, most granular group of information associated with a Banner table. Examples include course, address, e-mail,
and telephone number. A business entity API is a database package that encapsulates the business logic surrounding a Banner business entity.
Generally there is a one-to-one relationship between a business entity, an API, and a Banner table.

The foundation of all business entity APIs is the ability to create, retrieve, update, and delete (CRUD) data on the database. The same validation
and processing occur regardless of whether the API is called from a Banner form, self-service page, batch process, or external application.

For example, the “course” business entity, Course API, and Course table are related. Calling the Course API allows you to:

       Create course information (insert rows into the Course table).
       Retrieve data from the Course table.
       Update course information (modify rows in the Course table).
       Delete course information (physically remove data from the Course table).

Identical logic is executed any time the Course API is invoked by an internal Banner form, self-service page, or batch process, or by an external
application.

Business Process APIs
A business process API executes a business process that calls multiple entity APIs in a single transaction. A business process API may expose
one or more interfaces for different purposes. Examples include:

       An XML interface to support integrations such as Web Services.
       An OOT (Oracle Object Type) interface to support simple handling of complex types.
       A simple type interface to support legacy applications that cannot immediately take advantage of OOTs or XML.

Spreadsheet Overview
This document includes two spreadsheets:

       APIs by Product lists the Banner APIs and their underlying tables, by product. This spreadsheet identifies the APIs that support
        Integration Solutions and the APIs that support various enhancements.
       Impacted Programs lists the programs that use APIs to insert, update, delete, or query Banner data. This includes forms, packages,
        triggers, permanent (not release-specific) SQL scripts, and C/COBOL programs.
                                                                         Banner APIs by Product

                                                                                                                                                                                                  In




                                                                                                                                                                                 Luminis Portal
              Release



                                                                                         Entity/                                                     Representative   Tables
Product                 API Name                  Main Source Name            Type       Process Name      Logic Performed                           Source Forms     Affected
Advancement   7.0       ab_adv_individual         aokb_individual0.sql        Business   Advancement       Maintains information about Advancement APACONS            APBCONS
                                                                              Entity     Individual        individuals
Advancement   7.0       ab_adv_organization       aokb_organiztn0.sql         Business   Advancement       Maintains information about organizations AOAORGN          AOBORGN
                                                                              Entity     Organization      such as corporations and foundations

Advancement   7.4       ab_custom_search_detail   aokb_search_detail0.sql     Business   Custom Search Creates and maintains details for custom NA                    AORDOSR
                                                                              Entity     Detail        searches
Advancement   7.4       ab_custom_search_header   aokb_search_header0.sql     Business   Custom Search Creates and maintains header information NA                    AOBDOSR
                                                                              Entity     Header        for custom searches

Advancement   7.0       ab_donor_category         aokb_donor_category0.sql    Business   Donor Category Maintains donor categories                        APACONS     APRCATG
                                                                              Entity                                                                      AOAORGN
Advancement   8.1       ab_gift_auxl_hold         aokb_gift_auxl_hold0.sql    Business   Gift Auxiliary    Temporarily holds auxiliary values and         NA          AGRAUXH
                                                                              Entity     Hold              benefit or premium codes for gifts in a gift
                                                                                                           mass entry session
Advancement   8.1       ab_project_history        aokb_prop_hist0.sql         Business   Project History Stores project history information               NA          AMRPRPH
                                                                              Entity
Advancement   8.1       ab_project_results        aokb_proj_rslt0.sql         Business   Project Results Stores information about gifts or pledges        NA          AMRPRRS
                                                                              Entity                     that are received as a result of a project

Advancement   8.1       ab_proposal_history       aokb_proj_hist0.sql         Business   Proposal          Stores proposal history information            NA          AMBPRPH
                                                                              Entity     History
AR            7.0       tb_cashier_session        tgkb_cshrsess0.sql          Business   Cashier           Contains supporting programs                   NA          TBBCSHR
                                                                              Entity     Session
AR            7.0       tb_customer_profile       tgkb_custprof0.sql          Business   Customer          Maintains customer information such as         TGACPRF     TBBCPRF
                                                                              Entity     Profile           credit limit and entity type
AR            7.0       tb_depo_control           tgkb_depoctrl0.sql          Business   Deposit Control   Contains supporting programs                   NA          TBBDEPC
                                                                              Entity
AR            7.0       tb_deposit                tgkb_deposit0.sql           Business   Deposit           Records deposits on a customer account         TSADETL     TBRDEPO
                                                                              Entity                                                                      TFADETL
AR            7.0       tb_detail_code            tgkb_detlcode0.sql          Business   Detail Code       Contains supporting programs                   NA          TBBDETC
                                                                              Entity
AR            7.2       tb_memo                   tgkb_acctmemo0.sql          Business   Memo              Maintains memo information                     TSADETL     TBRMEMO
                                                                              Entity




                                                                                    Page 2
                                                                    Banner APIs by Product

                                                                                                                                                                                                In




                                                                                                                                                                               Luminis Portal
           Release



                                                                                    Entity/                                                        Representative   Tables
Product              API Name                Main Source Name            Type       Process Name     Logic Performed                               Source Forms     Affected
AR        7.0        tb_misc_detail          tgkb_miscdetl0.sql          Business   Miscellaneous    Records miscellaneous transactions to be      TSAMISC          TBRMISD
                                                                         Entity     Receipt Detail   posted                                        TFAMISC
AR        7.0        tb_misc_header          tgkb_mischead0.sql          Business   Miscellaneous    Records miscellaneous transactions to be      TSAMISC          TBBMISC
                                                                         Entity     Receipt Header   posted                                        TFAMISC

AR        7.0        tb_receivable           tgkb_acctrecv0.sql          Business   Receivable       Records charges and payments on a             TSASPAY          TBRACCD
                                                                         Entity                      customer account                              TSAAREV
AR        7.3        tb_statement            tgkb_acctstmt0.sql          Business   Statement        Creates history of statements sent to         TSADETL
                                                                                                                                                   NA               TBBSTMT
                                                                         Entity                      student, with option to store a copy of the
                                                                                                     statement as a large object or file
                                                                                                     reference
AR        7.1        tb_term_control_ar      tgkb_termctrl0.sql          Business   Term Control     Maintains Accounts Receivable term            TSATERM          TBBTERM
                                                                         Entity     AR               control data
AR        7.1.1 tp_student_deposit           tskp_deposit0.sql           Business   Student          Creates deposit records or releases           TSADTEL          TBRDEPO
                                                                         Process    Deposit          previously recorded deposits                                   TBRACCD
AR        7.1.1 tp_student_receivable        tskp_receivable0.sql        Business   Student          Creates accounts receivable transactions      ftmorgn          TBRACCD
                                                                         Process    Receivable
Finance   7.0        fb_accounting_element   fokb_ifoapal0.sql           Business   Accounting       Provides business interface for IFOAPAL       FTMACCT          FTVACCT
                                                                         Entity     Element          information                                   FTMACTV          FTVACTV
                                                                                                                                                   FTMFUND          FTVFUND
                                                                                                                                                   FTMLOCN          FTVLOCN
                                                                                                                                                   FTMORGN          FTVORGN
                                                                                                                                                   FTMPROG          FTVPROG
Finance   7.0        fb_chart_of_accounts    fokb_coas0.sql              Business   Chart of         Provides standard functions for Chart of      FTMCOAS          FTVCOAS
                                                                         Entity     Accounts         Accounts
Finance   7.0        fb_commodity            fokb_comm0.sql              Business   Commodity        Provides standard functions for               FTMCOMM          FTVCOMM
                                                                         Entity                      Commoidty API
Finance   8.0        fb_encumbrance_detail   fgkb_encdetail0.sql         Business   Encumbrance      Maintains detail information for the          FGAENCB          FGBENCD
                                                                         Entity     Detail           Finance general encumbrance document

Finance   8.0        fb_encumbrance_header   fgkb_enchead0.sql           Business   Encumbrance      Maintains header information for the          FGAENCB          FGBENCH
                                                                         Entity     Header           Finance general encumbrance document          FOAAINP
                                                                                                                                                   FOADOCU
                                                                                                                                                   FOAUAPP




                                                                               Page 3
                                                                  Banner APIs by Product

                                                                                                                                                                                          In




                                                                                                                                                                         Luminis Portal
          Release



                                                                                  Entity/                                                    Representative   Tables
Product             API Name            Main Source Name               Type       Process Name Logic Performed                               Source Forms     Affected
Finance   8.1       fb_grant_effcert    ftkb_grant_effcert0.sql        Business   Grant Effort  Supports effort certification in Banner      FRAGRNT          FTVFUND
                                                                       Entity     Certification Human Resouces                                                FRBGRNT
                                                                                                                                                              FRRGREC
Finance   7.2       fb_invoice_acctg    fakb_invacctg0.sql             Business   Invoice        Maintains invoice accounting information    FAAINVE          FARINVA
                                                                       Entity     Accounting
Finance   7.2       fb_invoice_header   fakb_invhead0.sql              Business   Invoice Header Maintains invoice header information        FAAINVE          FABINVH
                                                                       Entity
Finance   7.2       fb_invoice_item     fakb_invitem0.sql              Business   Invoice Item    Maintains invoice commodity information    FAAINVE          FARINVC
                                                                       Entity
Finance   7.2       fb_invoice_tax      fakb_invtax0.sql               Business   Invoice Tax     Calculates and maintains information for   FAAINVE          FARINTX
                                                                       Entity                     invoice tax
Finance   7.3       fb_jv_detail        fgkb_jvdetail0.sql             Business   JV Detail       Maintains JV details                       FGAJVCD          FGBJVCD
                                                                       Entity
Finance   7.3       fb_jv_header        fgkb_jvhead0.sql               Business   JV Header       Maintains JV header information            FGAJVCD          FGBJVCH
                                                                       Entity
Finance   7.1       fb_po_tax           fokb_potax0.sql                Business   Purchase Order Calculates and maintains information for    FPAPURR          FPRPOTX
                                                                       Entity     Tax            purchase order tax
Finance   7.0       fb_purchase_order   fpkb_order0.sql                Business   Purchase Order Maintains purchase order information        FPAPURR          FPBPOHD
                                                                       Entity                                                                                 FPRPODT
                                                                                                                                                              FPRPODA
Finance   7.1       fb_req_tax          fokb_rqtax0.sql                Business   Requisition Tax Calculates and maintains information for   FPAREQN          FPRRQTX
                                                                       Entity                     requisition tax
Finance   7.0       fb_requisition      fpkb_reqn0.sql                 Business   Requisition     Maintains requisition information          FPAREQN          FPBREQH
                                                                       Entity                                                                                 FPRREQD
                                                                                                                                                              FPRREQA
Finance   7.0       fb_ship             fokb_ship0.sql                 Business   Ship            Maintains shipping information             FTMSHIP          FTVSHIP
                                                                       Entity

Finance   7.0       fb_vendor           fokb_vendor0.sql               Business   Vendor          Creates and maintains vendor               FTMVEND          FTVVVEND
                                                                       Entity
Finance   7.0       fb_vendor_type      fokb_vendtype0.sql             Business   Vendor Type     Creates and maintains vendor type          FTMVEND          FTVVENT
                                                                       Entity
Finance   8.0       fp_encumbrance      fgkp_encumb0.sql               Business   Encumbrance     Creates and maintains encumbrance          FGAENCB          FGBENCB
                                                                       Process                                                                                FGBENCH




                                                                             Page 4
                                                                           Banner APIs by Product

                                                                                                                                                                                                     In




                                                                                                                                                                                    Luminis Portal
                 Release



                                                                                           Entity/                                                     Representative    Tables
Product                    API Name                Main Source Name             Type       Process Name Logic Performed                                Source Forms      Affected
Finance         7.3        fp_invoice              fakp_invoice0.sql            Business   Invoice      Creates and maintains invoices                 FAAINVE           FABINVH
                                                                                Process                                                                                  FARINVA
                                                                                                                                                                         FARINVC
                                                                                                                                                                         FARINTX
Finance         7.3        fp_journal_voucher      fgkp_journal0.sql            Business   Journal          Creates and maintains journal vouchers     FGAJVCD           FGBJVCH
                                                                                Process    Voucher                                                                       FGBJVCD



Financial Aid   7.9        rb_applicant_comment    rhkb_app_comment0.sql        Business   Applicant        Maintains applicant comments information RHACOMM             RHRCOMM
                                                                                Entity     Comment
Financial Aid   8.1        rb_application_status   rokb_appl_status0.sql        Business   Application      Supports RORSTAT processing                RBAABUD           RORSTAT
                                                                                Entity     Status                                                      REACORR
Financial Aid   7.8        rb_award                rpkb_award0.sql              Business   Award            Maintains applicant award information      RPAAWRD           RPRAWRD
                                                                                Entity
Financial Aid   7.0        rb_award_disbursement   rpkb_awd_disb0.sql           Business   Award        Processes disbursement records                 RPAAWRD           RPRADSB
                                                                                Entity     Disbursement
Financial Aid   7.8        rb_award_schedule       rpkb_award_sched0.sql        Business   Award        Maintains award schedule information           RPAAWRD           RPRATRM
                                                                                Entity     Schedule
Financial Aid   7.0        rb_cod_document         rekb_cod_doc0.sql            Business   COD Document Maintains COD document information             REICODD           RERCODD
                                                                                Entity
Financial Aid   7.0        rb_cod_identifier       rekb_cod_identifier0.sql     Business   COD Identifier   Maintains all identification information   REASTID           RERSTID
                                                                                Entity                      related to the COD data
Financial Aid   7.0        rb_dl_refund            rekb_dl_refund0.sql          Business   DL Refund        Maintains Direct Loan refund information   RPALORG           RPRRFND
                                                                                Entity
Financial Aid   7.9        rb_ny_user_def_data     rokb_ny_user_def0.sql        Business   Applicant Non    Maintains user-defined data values         ROANYUD           ROBNYUD
                                                                                Entity     Year User-
                                                                                           Defined Data
Financial Aid   7.0        rb_pell_originations    rekb_pell_orig0.sql          Business   Pell             Calculates and creates Pell Origination    REAORxx           REBPAYV
                                                                                Entity     Originations     records
Financial Aid   7.3.1 rb_requirement               rrkb_requirement0.sql        Business   Applicant        Maintains applicant requirements           RRAAREQ           RRRAREQ
                                                                                Entity     Requirements
Financial Aid   8.1        rb_sim_appl_status      rokb_sim_appl_status0.sql    Business   Packaging        Supports ROTSTTS processing                None (called by   ROTSTTS
                                                                                Entity     Simulation                                                  other database
                                                                                           Applicant                                                   packages)
                                                                                           Status



                                                                                      Page 5
                                                                        Banner APIs by Product

                                                                                                                                                                                             In




                                                                                                                                                                            Luminis Portal
                Release



                                                                                        Entity/                                                 Representative   Tables
Product                   API Name              Main Source Name             Type       Process Name Logic Performed                            Source Forms     Affected
Financial Aid   8.1       rb_temp_appl_status   rokb_temp_appl_status0.sql   Business   Temporary    Supports ROTSTAT processing                RCRSUSP          ROTSTAT
                                                                             Entity     Application
                                                                                        Status
Financial Aid   7.8       rb_temp_award         rpkb_temp_award0.sql         Business   Temporary         Accesses the DML layer for RPTAWRD    NA               RPTAWRD
                                                                             Entity     Award
Financial Aid   7.9       rb_user_def_data      rokb_user_def0.sql           Business   Applicant User-   Maintains user-defined data           ROAUSDF          ROBUSDF
                                                                             Entity     Defined Data
Financial Aid   8.1       rp_applicant_status   rokp_appl_status0.sql        Business   Application       Creates records associated with applicant RBAABUD      RORSTAT
                                                                             Process    Status            status processing                         RNANA09      RORSAPR
                                                                                                                                                    RNAOV09      GURMAIL
                                                                                                                                                    RNAPR09      ROBNYUD
                                                                                                                                                    RNASU09      ROBUSDF
                                                                                                                                                    ROAMESG      RRRAREQ
                                                                                                                                                    ROAPELL
                                                                                                                                                    ROASTAT
                                                                                                                                                    ROAUSDF
                                                                                                                                                    RPAAPMT
                                                                                                                                                    RPAAWRD
                                                                                                                                                    RRAAREQ

Financial Aid   7.8       rp_award              rpkp_award0.sql              Business   Create an         Processes Financial Aid awards        NA               RORSTAT
                                                                             Process    Award                                                                    ROPSAPR
                                                                                                                                                                 GURMAIL
                                                                                                                                                                 RPRAWRD
                                                                                                                                                                 RPRATRM
                                                                                                                                                                 RPRADSB
                                                                                                                                                                 RFRPROM
                                                                                                                                                                 RRRAREQ
                                                                                                                                                                 RFRASPC
                                                                                                                                                                 RPRLAPP
                                                                                                                                                                 RPRLADB
                                                                                                                                                                 RPRLATR




                                                                                   Page 6
                                                                            Banner APIs by Product

                                                                                                                                                                                                      In




                                                                                                                                                                                     Luminis Portal
                 Release



                                                                                            Entity/                                                      Representative   Tables
Product                    API Name                Main Source Name              Type       Process Name Logic Performed                                 Source Forms     Affected
Financial Aid   7.8        rp_award_schedule       rpkp_award_sched0.sql         Business   Create an    Processes Financial Aid awards                  NA               RORSTAT
                                                                                 Process    Award                                                                         ROPSAPR
                                                                                            Schedule                                                                      GURMAIL
                                                                                                                                                                          RPRAWRD
                                                                                                                                                                          RPRATRM
                                                                                                                                                                          RPRADSB
                                                                                                                                                                          RFRPROM
                                                                                                                                                                          RRRAREQ
                                                                                                                                                                          RFRASPC

Financial Aid   7.3.1 rp_requirement               rrkp_requirement0.sql         Business   Applicant       Maintains applicant requirements and         NA               RORSTAT
                                                                                 Process    Requirement     processes summary requirements                                ROPSAPR
                                                                                                                                                                          GURMAIL
                                                                                                                                                                          RRRAREQ
General         8.0        gb_additional_ident     gokb_additional_ident0.sql    Business   Additional      Stores and retrieves additional ID           SPAIDEN,         GORADID
                                                                                 Entity     Identificaton   information                                  GOQCLIB
General         7.0        gb_address              gokb_address0.sql             Business   Address         Maintains address information                SPAIDEN          SPRADDR      X
                                                                                 Entity
General         7.0        gb_bio                  gokb_bio0.sql                 Business   Biographical    Maintains individual bio/demo information    SPAPERS          SPBPERS      X
                                                                                 Entity
General         7.0        gb_bldgdefinition       gokb_bldg_defn0.sql           Business   Building        Maintains information on buildings           SLABLDG          SLBBLDG
                                                                                 Entity
General         7.0        gb_bus_prof_rule        gokb_fg_bprofrule0.sql        Business   Business        Assigns the categories of users and their    GOAFGAC          GORFGBP
                                                                                 Entity     Profile Rule    privileges to each domain and predicate
                                                                                                            for a FGAC VBS grouip rule
General         7.0        gb_businessprofile      gokb_busprofile0.sql          Business   Business        Groups users with similar responsibilities   GORFBPR          GORFBPR
                                                                                 Entity     Profile         for FGAC VBS processing

General         7.0        gb_busprofpii           gokb_busprofpii0.sql          Business   Business        Groups user with similar responsibilities for GOAFBPI         GORFBPI
                                                                                 Entity     Profile PII     FGAC PII processing
                                                                                            Assignments
General         7.0        gb_classtimes           gokb_classroom0.sql           Business   Class Times     Maintains meeting times for specific         SSASECT          SSRMEET
                                                                                 Entity                     sections
General         7.0        gb_cm_data_dictionary   gokb_cm_data_dict0.sql        Business   Common          Maintains data dctionary (attributes used    GORCMDD          GORCMDD
                                                                                 Entity     Matching Data   for matching)
                                                                                            Dictionary



                                                                                       Page 7
                                                                 Banner APIs by Product

                                                                                                                                                                                        In




                                                                                                                                                                       Luminis Portal
          Release



                                                                                  Entity/                                                  Representative   Tables
Product             API Name                Main Source Name           Type       Process Name Logic Performed                             Source Forms     Affected
General   7.3       gb_cm_disp_hier         gokb_cm_disp_hier0.sql     Business   Common       Maintains Common Matching hierarchy         GORCMSC          GORCMDH
                                                                       Entity     Matching     information                                 GOAMTCH
                                                                                  Display
                                                                                  Hierarchy
General   7.0       gb_cm_display_options   gokb_cm_disp_option0.sql   Business   Common          Defines and maintains objects used as       GORCMSC       GORCMDO
                                                                       Entity     Matching        options to be displayed and accessed for
                                                                                  Display Options additional information for records returned
                                                                                                  as potential matches for Common
                                                                                                  Matching source
General   7.0       gb_cm_rules             gokb_cm_rules0.sq          Business   Common         Maintains rules for Common Matching       GORCMRL          GORCMSR
                                                                       Entity     Matching Rules

General   7.0       gb_cm_source_priority   gokb_cm_srce_prior0.sql    Business   Common          Sets Common Matching rule priority for   GORCMRL          GORCMSP
                                                                       Entity     Matching        source code
                                                                                  Source Priority
General   7.0       gb_cm_source_rules      gokb_cm_source_rule0.sql   Business   Common          Defines and maintains default address    GORCMSC          GORCMSC
                                                                       Entity     Matching        type, phone type, email type for Common
                                                                                  Source Rules    Matching source to use when creating new
                                                                                                  records; determines whether Common
                                                                                                  Matching source processes person and/or
                                                                                                  non-person records when matching


General   7.0       gb_cm_user_procedure    gokb_cm_user_proc0.sql     Business   Common          Maintains non-Banner General procedures GORCMRL           GORCMUP
                                                                       Entity     Matching User   that Common Matching can invoke
                                                                                  Procedures
General   7.0       gb_cm_user_setup        gokb_cm_user_setup0.sql    Business   Common          Maintains Common Matching user options GORCMUS            GOBCMUS
                                                                       Entity     Matching User
                                                                                  Setup
General   7.0       gb_currency             gokb_currcode0.sql                    Currency Code Provides query functions for currency code Used by Finance None
                                                                                  stub package                                             and AR forms and
                                                                                                                                           APIs. No CUD
                                                                                                                                           capability at this
                                                                                                                                           time.




                                                                             Page 8
                                                                      Banner APIs by Product

                                                                                                                                                                                                 In




                                                                                                                                                                                Luminis Portal
           Release



                                                                                      Entity/                                                     Representative     Tables
Product              API Name                 Main Source Name             Type       Process Name Logic Performed                                Source Forms       Affected
General   7.0        gb_currency_rate         gokb_currrate0.sql                      Currency Rate Provides query functions and calculation      Used by Finance None
                                                                                      stub package procedures for currency conversion             and AR forms and
                                                                                                                                                  APIs. No CUD
                                                                                                                                                  capability at this
                                                                                                                                                  time.
General   7.0        gb_displaycolumns        gokb_display_cols0.sql       Business   Display          Maintains data items (columns) for         GORDMCL           GORDMCL
                                                                           Entity     Columns          protection of sensitive information
General   7.0        gb_displaymask           gokb_display_mask0.sql       Business   Display Mask     Maintains rules for users and data items   GORDMSK           GORDMSK
                                                                           Entity                      (columns) for protection of sensitive
                                                                                                       information
General   7.0        gb_domains               gokb_fg_domains0.sql         Business   Domains          Maintains domains for FGAC processing      GORFDMN           GOBFDMN
                                                                           Entity
General   7.0        gb_domaintype            gokb_fg_domaintype0.sql      Business   Domain Type      Maintains domain type information for      GORFDTP           GOBFDTP
                                                                           Entity                      FGAC processing
General   7.0        gb_email                 gokb_email0.sql              Business   Email            Maintains email addresses                  GOAEMAL           GOREMAL       X
                                                                           Entity
General   7.0        gb_emergency_contact     gokb_emerg_cont0.sql         Business   Emergency        Maintains emergency contact information    SPAEMRG           SPREMRG       X
                                                                           Entity     Contact          about individuals
General   7.0        gb_fgac_user_rule        gokb_fg_userrule0.sql        Business   FGAC User        Lists individual users restricted by VBS   GOAFGAC           GORFGUS
                                                                           Entity     Rule             predicate defined for a group
General   7.0        gb_fgacexcludedobjects   gokb_fg_exclobj0.sql         Business   FGAC             Maintains objects that are exempt from     GORFEOB           GOBFEOB
                                                                           Entity     Excluded         FGAC processing
                                                                                      Objects
General   7.0        gb_group_rules           gokb_group_rule0.sql         Business   Group Rules      Maintains FGAC group rules for VBS         GOAFGAC           GOBFGAC
                                                                           Entity                      restrictions
General   7.0        gb_hold                  gokb_hold0.sql               Business   Hold             Places or removes holds on an account      SOAHOLD           SPRHOLD
                                                                           Entity
General   7.0        gb_identification        gokb_ident0.sql              Business   Identification   Maintains person and non-person      SPAIDEN                 SPRIDEN       X
                                                                           Entity                      bio/demo data
General   7.4        gb_immunization          gokb_immunization0.sql       Business   Immunization Maintains immunization information about GOAIMMU                 GORIMMU
                                                                           Entity                      individuals
General   7.3.1 gb_institution_role           gokb_inst_role0.sql          Business   Institution Role Maintains institution roles                                  GORIROL       X
                                                                           Entity




                                                                                  Page 9
                                                                   Banner APIs by Product

                                                                                                                                                                                               In




                                                                                                                                                                              Luminis Portal
          Release



                                                                                   Entity/                                                       Representative    Tables
Product             API Name                Main Source Name            Type       Process Name Logic Performed                                  Source Forms      Affected
General   7.4       gb_integ_config         gokb_integ_config0.sql      Business   Integration   Maintains settings that control integration     GORICCR           GORICCR      X
                                                                        Entity     Configuration between Banner and third-party systems

General   7.3       gb_large_object         gokb_large_object0.sql      Business   Large Object    Stores and retrieves large objects            No form maintains GORBLOB
                                                                        Entity                                                                   this data.
General   7.3       gb_medical              gokb_medical0.sql           Business   Medical         Maintains personal medical information        TSRCBIL output
                                                                                                                                                 GOAMEDI           SPRMEDI
                                                                        Entity
General   7.0       gb_name_translate       gokb_name_translate0.sql    Business   Name            Maintains person name translation rules       GORNAME           GORNAME
                                                                        Entity     Translate
General   7.0       gb_np_name_trans        gokb_np_name_trans0.sql     Business   Non-person      Maintains non-person name translation         GORNPNM           GORNPNM
                                                                        Entity     Name            rules
                                                                                   Translate
General   7.2       gb_partner_rule         gokb_partner_rule0.sql      Business   Partner Rule    Maintains rules for e-Learning integration    GORINTG           GORINTG
                                                                        Entity                     partners
General   7.3       gb_pcol_concentration   gokb_pcol_conc0.sql         Business   Prior College   Maintains information about                   SOAPCOL           SORCONC
                                                                        Entity     Concentration   concentrations at prior colleges
General   7.3       gb_pcol_degree          gokb_pcol_degree0.sql       Business   Prior College   Maintains information about degrees           SOAPCOL           SORDEGR
                                                                        Entity     Degree          received at prior colleges
General   7.3       gb_pcol_major           gokb_pcol_major0.sql        Business   Prior College   Maintains information about majors at prior   SOAPCOL           SORMAJR
                                                                        Entity     Major           colleges
General   7.3       gb_pcol_minor           gokb_pcol_minor0.sql        Business   Prior College   Maintains information about minors at prior   SOAPCOL           SORMINR
                                                                        Entity     Minor           colleges
General   7.2       gb_person_race          gokb_person_race0.sql       Business   Person Race     Maintains a person's race data                IDEN forms that   GORPRAC
                                                                        Process                                                                  reference
                                                                                                                                                 GORPRAC from
                                                                                                                                                 GOQCLIB
General   7.0       gb_pii_tables           gokb_pii_tables0.sql        Business   PII Table       Maintains teble rules for PII processing      GORFDPI           GORFDPI
                                                                        Entity
General   8.0       gb_pin_answer           gokb_pin_answer0.sql        Business   PIN Answer      Stores answers to security questions and      GOATPAD           GOBANSR
                                                                        Entity                     compares the answers provided by users
                                                                                                   during the PIN reset process
General   8.0       gb_pin_question         gokb_pin_question0.sql      Business   PIN Question    Stores and retrieves security questions       GOAQSTN           GOBQSTN
                                                                        Entity                     used in PIN reset process
General   7.3       gb_prior_college        gokb_prior_college0.sql     Business   Prior College   Maintains prior college background            SOAPCOL           SORPCOL
                                                                        Entity                     information



                                                                              Page 10
                                                                    Banner APIs by Product

                                                                                                                                                                                             In




                                                                                                                                                                            Luminis Portal
           Release



                                                                                    Entity/                                                     Representative   Tables
Product              API Name                Main Source Name            Type       Process Name Logic Performed                                Source Forms     Affected
General   7.2        gb_race_ethnicity       gokb_race_ethn0.sql         Business   Race Ethnicity Maintains race and new ethnicity rules       GORRACE          GORRACE
                                                                         Entity
General   7.0        gb_roomassignment       gokb_room_assign0.sql       Business   Room            Assigns learners to dorm rooms              SLARASG          SLRRASG
                                                                         Entity     Assignment
General   7.0        gb_roomdefinition       gokb_room_defn0.sql         Business   Room            Maintains information about rooms in the    SLARDEF          SLBRDEF
                                                                         Entity     Definition      institution's buildings
General   8.0        gb_sde_discrim_value    gokb_sde_disc_val0.sql      Business   SDE             Stores and retrieves discriminator values   GOADISC          GORSDDV
                                                                         Entity     Discriminator   for SDE processing
                                                                                    Value
General   8.0        gb_sde_discriminator    gokb_sde_disc0.sql          Business   SDE           Stores and retrieves discriminator            GOADISC          GOBSDDC
                                                                         Entity     Discriminator information for SDE processing
General   8.0        gb_sde_metadata         gokb_sde_metadata0.sql      Business   SDE Metadata Stores and retrieves metadata for SDE          GOASDMD          GORSDAM
                                                                         Entity                   attributes

General   8.0        gb_sde_table            gokb_sde_table0.sql         Business   SDE Table       Stores and retrieves information on         GTVSDTB          GOBSDTB
                                                                         Entity                     Banner tables that have been extended
                                                                                                    with supplemental data through SDE
General   7.0        gb_telephone            gokb_telephone0.sql         Business   Telephone       Maintains telephone information             SPATELE          SPRTELE      X
                                                                         Entity
General   7.0        gb_third_party_access   gokb_third_party_a0.sql     Business   Third Party     Maintains cross-references between third- GOATPAC            GOBTPAC      X
                                                                         Entity     Access          party system user IDs and Oracle user IDs

General   7.0        gb_userdefault          gokb_pii_usrdefault0.sql    Business   User Default    Maintains FGAC user defaults (exempt        GOAFPUD          GOBFPUD
                                                                         Entity                     from PII processing and VBS rules,
                                                                                                    access to multiple domains, etc.)
General   7.0        gb_userpiidomains       gokb_pii_usrdomain0.sql     Business   User PII      Maintains domains for each user for FGAC      GOAFPII          GORFPII
                                                                         Entity     Domain        PII processing
General   7.0        gb_vbs_predicate        gokb_vbs_predicate0.sql     Business   VBS Predicate Maintains predicate information for FGAC      GORFDTP          GORFPRD
                                                                         Entity                   VBS processing
General   7.0        gb_vbs_tables           gokb_vbs_tables0.sql        Business   VBS Tables    Maintains tables associated with each         GORFDPL          GORFDPL
                                                                         Entity                   domain for FGAC VBS processing
General   7.3        gb_visa                 gokb_visa0.sql              Business   Visa Code     Maintains visa information                    GOAINTL          GORVISA
                                                                         Entity
General   7.1.1 gp_cardholder                gokp_cardholder0.sql        Business   Cardholder      Retrieves information about campus card
                                                                         Process                    cardholders



                                                                               Page 11
                                                                         Banner APIs by Product

                                                                                                                                                                                                      In




                                                                                                                                                                                     Luminis Portal
           Release



                                                                                         Entity/                                                        Representative    Tables
Product              API Name                   Main Source Name              Type       Process Name Logic Performed                                   Source Forms      Affected
General   7.0        gp_common_matching         gokp_common_matching0.sql     Business   Common       Checks for the existance of a record in           None (called by   GOTCMRT
                                                                              Process    Matching     Banner based on criteria (rules) defined for      other database    GOTCMME
                                                                                                      the source of the data                            packages)
General   7.1.1 gp_entity_address               gokp_entity_address0.sql      Business   Entity Address   Maintains address information about a
                                                                              Process                     person
General   7.3        gp_international_student   gokp_internatl_stud0.sql      Business   International    Retrieves international student information                     GTVSDAX
                                                                              Process    Student                                                                          SPRADDR
General   7.1.1 gp_person_identity              gokp_person_identity0.sql     Business   Person Identity Allows external systems to retrieve a                            SPRTELE
                                                                              Process                    Banner ID
HR        7.2        nb_ea_comments             nokb_ea_comments0.sql         Business   Electronic      Maintains multiple comments for ePAF           NOAAPSM           NORCMNT
                                                                              Entity     Approvals       transactions                                   NOAEPAF
                                                                                         Comment
HR        7.1        nb_ea_group_category       ntkb_ea_group_cat0.sql        Business   Electronic       Establishes a group of approval categories NTRAGRP              NTRAGRP
                                                                              Entity     Approvals        to control the usage of ePAF approval
                                                                                         Group            categories when originating a transaction
                                                                                         Category
HR        7.1        nb_ea_group_user           ntkb_ea_group_user0.sql       Business   Electronic       Establishes valid originators for an          NTRAGRP           NTRAGID
                                                                              Entity     Approvals        approval group                                NOAOGRP
                                                                                         Group User
HR        8.1        nb_effcert_addl_queue      ntkb_effcert_aque0.sql        Business   Effort           Provides the common business interface NTRELAQ                  NTRECAQ
                                                                              Entity     Certification    for the Effort Certification Additional Queue
                                                                                         Additional       Members
                                                                                         Queue
                                                                                         Members
HR        8.1        nb_effcert_category        ntkb_effcert_cat0.sql         Business   Effort           Provides the common business interface        NTRECCG           NTRECCG
                                                                              Entity     Certification    for the Effort Certification Category Rule
                                                                                         Category
HR        8.1        nb_effcert_dflt_queue      ntkb_effcert_dque0.sql        Business   Effort           Provides the common business interface        NTRELRQ           NTRECDQ
                                                                              Entity     Certification    for the Effort Certification Default Queue
                                                                                         Default Queue    Rule
HR        8.1        nb_effcert_ftyp            ntkb_effcert_ftyp0.sql        Business   Effort           Provides the common business interface        NTRELAQ           NTRECFT
                                                                              Entity     Certification    for the Effort Certification Member Fund
                                                                                         Member Fund      Type
                                                                                         Type




                                                                                    Page 12
                                                                     Banner APIs by Product

                                                                                                                                                                                               In




                                                                                                                                                                              Luminis Portal
          Release



                                                                                     Entity/                                                      Representative   Tables
Product             API Name                Main Source Name              Type       Process Name Logic Performed                                 Source Forms     Affected
HR        7.3       nb_job_base             nbkb_job_base0.sql            Business   Job Base     Maintains employee job base information         NBAJOBS          NBRBJOB
                                                                          Entity
HR        7.3       nb_job_detail           nbkb_job_detail0.sql          Business   Job Detail       Maintains employee job detail information   NBAJOBS          NBRJOBS
                                                                          Entity
HR        7.3       nb_job_earnings         nbkb_job_earnings0.sql        Business   Job Earnings     Maintains employee job default earnings     NBAJOBS          NBREARN
                                                                          Entity                      information
HR        8.0       nb_job_enc_history      nbkb_job_enc_hist0.sql        Business   Job Labor        Maintains job labor encumbrance history     NBILJLHS         NBRJLHS
                                                                          Entity     Encumbrance
                                                                                     History
HR        7.3       nb_job_labor            nbkb_job_labor0.sql           Business   Job Labor     Maintains employee job labor distribution      NBAJOBS          NBRJLBD
                                                                          Entity                   information
HR        8.1       nb_proxy                ntkb_proxy0.sql               Business   Proxy         Provides the common business interface         NTRPROX          NTRPRXY
                                                                          Entity                   for the Proxy
HR        8.1       nb_proxy_module         ntkb_proxy_module0.sql        Business   Proxy Module Provides the common business interface          NTRPROX          NTRPRXM
                                                                          Entity                   for the Proxy Module
HR        8.1       nb_queue_group          ntkb_queue_group0.sql         Business   Routing Queue Provides the common business interface         NTRQPRT          NTRQGRP
                                                                          Entity     Group         for the Routing Queue Group
HR        8.1       nb_queue_participant    ntkb_queue_partic0.sql        Business   Routing Queue Provides the common business interface         NTRQPRT          NTRQPRT
                                                                          Entity     Participant   for the Effort Certification Routing Queue
                                                                                                   Participant Rule
HR        8.1       nb_redistr_addl_queue   ntkb_redistr_aque0.sql        Business   Labor            Provides the common business interface      NTRELAQ          NTRLRAQ
                                                                          Entity     Redistribution   for the Labor Redistribution Additional
                                                                                     Additional       Queue Members
                                                                                     Queue
                                                                                     Members
HR        8.1       nb_redistr_dflt_queue   ntkb_redistr_dque0.sql        Business   Labor            Provides the common business interface NTRELRQ               NTRLRDQ
                                                                          Entity     Redistribution   for the Labor Redistribution Default Queue
                                                                                     Default Queue
HR        8.1       nb_redistr_ftyp         ntkb_redistr_ftyp0.sql        Business   Labor            Provides the common business interface NTRELAQ               NTRLRFT
                                                                          Entity     Redistribution   for the Labor Redistribution Member Fund
                                                                                     Member Fund      Type
                                                                                     Type
HR        7.3       np_job_assignment       nbkp_job_assignment0.sql      Business   Job              Maintains job base and job detail data      NBAJOBS          NBRJOBS
                                                                          Process    Assignment                                                                    NBRBJOB




                                                                                Page 13
                                                                   Banner APIs by Product

                                                                                                                                                                                             In




                                                                                                                                                                            Luminis Portal
          Release



                                                                                   Entity/                                                      Representative   Tables
Product             API Name             Main Source Name               Type       Process Name Logic Performed                                 Source Forms     Affected
HR        7.3       np_job_earnings      nbkp_job_earnings0.sql         Business   Job Earnings  Maintains default earnings records for a       NBAJOBS          NBREARN
                                                                        Process                  job
HR        7.3       np_job_labor         nbkp_job_labor0.sql            Business   Job Labor     Establishes information about the labor        NBAJOBS          NBRJLBD
                                                                        Process                  distribution assigned to a job
HR        7.2       pb_assoc_term        phkb_assoc_term0.sql           Business   Associated    Establishes information about the terms        PTRATRM          PTRATRM
                                                                        Entity     Term          assigned to an associated term
HR        7.2       pb_certification     ppkb_certification0.sql        Business   Certification Maintains employee certifications              PPACERT          PPRCERT
                                                                        Entity
HR        8.0       pb_dedn_comb_lmt     ptkb_dedn_comb_lmt0.sql        Business   Benefit/         Maintains benefit/deduction combined        PTRBDCL          PTRBDCL
                                                                        Entity     Deduction        limits
                                                                                   Combined
                                                                                   Limits
HR        8.0       pb_dedn_lmt_grp      ptkb_dedn_lmt_grp0.sql         Business   Combined Limit Maintains combined limit deductions group PTRBDCA              PTRBDLG
                                                                        Entity     Deductions
                                                                                   Group
HR        7.2       pb_driver_license    ppkb_driver_lic0.sql           Business   Driver License   Maintains employee driver license           PPAGENL          PPRDLIC
                                                                        Entity                      information
HR        8.1       pb_effcert_earn      ptkb_effcert_earn0.sql         Business   Effort           Provides the common business interface      PTRECPD          PTRECER
                                                                        Entity     Certification    for the Effort Certification Earnings
                                                                                   Earnings
HR        8.1       pb_effcert_ecls      ptkb_effcert_ecls0.sql         Business   Effort           Provides the common business interface      PTRECPD          PTRECEC
                                                                        Entity     Certification    for the Effort Certification Employee
                                                                                   Employee         Classification
                                                                                   Class
HR        8.1       pb_effcert_payroll   ptkb_effcert_payr0.sql         Business   Effort           Provides the common business interface      PTRECPD          PTRECPR
                                                                        Entity     Certification    for the Effort Certification Payroll Rule
                                                                                   Payroll
HR        8.1       pb_effcert_pcls      ptkb_effcert_pcls0.sql         Business   Effort           Provides the common business interface      PTRECPD          PTRECPC
                                                                        Entity     Certification    for the Effort Certification Position
                                                                                   Position Class   Classification
HR        8.1       pb_effcert_period    ptkb_effcert_period0.sql       Business   Effort           Provides the common business interface      PTRECPD          PTRECPD
                                                                        Entity     Certification    for the Effort Certification Period Rule
                                                                                   Period




                                                                              Page 14
                                                                  Banner APIs by Product

                                                                                                                                                                                               In




                                                                                                                                                                              Luminis Portal
          Release



                                                                                  Entity/                                                        Representative   Tables
Product             API Name             Main Source Name              Type       Process Name     Logic Performed                               Source Forms     Affected
HR        8.1       pb_effcert_rpt_ctl   ptkb_effcert_rptc0.sql        Business   Effort           Provides the common business interface        PTRECRT          PTRECRC
                                                                       Entity     Certification    for the Effort Certification Report Control
                                                                                  Report Control   Rule
HR        7.0       pb_employee          pokb_employee0.sql            Business   Employee         Maintains employee information                PEAEMPL          PEBEMPL       X
                                                                       Entity
HR        7.2       pb_endorsement       ppkb_endorsement0.sql         Business   Endorsement      Maintains employee endorsements               PPACERT          PPRENDS
                                                                       Entity
HR        7.2       pb_experience        ppkb_experience0.sql          Business   Experience       Maintains employee work history               PPAEXPR          PPREXPE
                                                                       Entity
HR        8.0       pb_fac_cntract       ptkb_fac_cntract0.sql         Business   Faculty Load     Maintains contract type rules for faculty     PTRFLCT          PTRFLCT
                                                                       Entity     Contract Type    compensation
                                                                                  Rules
HR        8.0       pb_fac_comments      pekb_fac_comments0.sql        Business   Faculty          Maintains compensation comments               Faculty Load       PERFLCM
                                                                       Entity     Compensation                                                   Compensation Self-
                                                                                  Comments                                                       Service
HR        8.0       pb_fac_crsassign     pekb_fac_crsassign0.sql       Business   Faculty          Maintains course assignments for              Faculty Load       PERFASG
                                                                       Entity     Compensation     compensation                                  Compensation Self-
                                                                                  Course                                                         Service
                                                                                  Assignment
HR        8.0       pb_fac_crsecomp      pekb_fac_crsecomp0.sql        Business   Faculty Course Maintains course compensation                   Faculty Load       PERFCSC
                                                                       Entity     Compensation                                                   Compensation Self-
                                                                                                                                                 Service
HR        8.0       pb_fac_errors        pekb_fac_errors0.sql          Business   Faculty          Maintains compensation errors                 Faculty Load       PERFLER
                                                                       Entity     Compensation                                                   Compensation Self-
                                                                                  Errors                                                         Service
HR        8.0       pb_fac_fcnt          pekb_fac_fcnt0.sql            Business   Faculty        Maintains faculty contract types for            Faculty Load       PERFCNT
                                                                       Entity     Compensation compensation                                      Compensation Self-
                                                                                  Contract Types                                                 Service

HR        8.0       pb_fac_incrate       ptkb_fac_incrate0.sql         Business   Faculty Load     Maintains incremental compensation rules PTRFLIC               PTRFLIC
                                                                       Entity     Incremental
                                                                                  Compensation
                                                                                  Rules




                                                                             Page 15
                                                                Banner APIs by Product

                                                                                                                                                                                              In




                                                                                                                                                                             Luminis Portal
          Release



                                                                                Entity/                                                        Representative     Tables
Product             API Name           Main Source Name              Type       Process Name Logic Performed                                   Source Forms       Affected
HR        8.0       pb_fac_incrcomp    pekb_fac_incrcomp0.sql        Business   Faculty      Maintains course incremental                      Faculty Load       PERFCIN
                                                                     Entity     Incremental  compensation                                      Compensation Self-
                                                                                Compensation                                                   Service
HR        8.0       pb_fac_isolcomp    pekb_fac_isolcomp0.sql        Business   Faculty         Maintains instructional overload               Faculty Load       PERFISO
                                                                     Entity     Instructional   compensation                                   Compensation Self-
                                                                                Overload                                                       Service
                                                                                Compensation
HR        8.0       pb_fac_jobdetail   pekb_fac_jobdetail0.sql       Business   Faculty Job     Maintains job assignment for faculty           Faculty Load       PERFJOB
                                                                     Entity     Detail          compensation                                   Compensation Self-
                                                                                                                                               Service
HR        8.0       pb_fac_jobdistr    pekb_fac_jobdistr0.sql        Business   Faculty Job     Maintains job labor distribution for faculty   Faculty Load       PERFJLD
                                                                     Entity     Labor           compensation                                   Compensation Self-
                                                                                Distributuion                                                  Service
HR        8.0       pb_fac_jobearns    pekb_fac_jobearns0.sql        Business   Faculty Job     Maintains job earnings for faculty             Faculty Load       PERFJER
                                                                     Entity     Earnings        compensation                                   Compensation Self-
                                                                                                                                               Service
HR        8.0       pb_fac_nilrate     ptkb_fac_nilrate0.sql         Business   Faculty Level   Maintains non-instructional compensation       PTRNIST           PTRNIST
                                                                     Entity     Non-            rules by faculty level
                                                                                Instructional
                                                                                Compenation
                                                                                Rules
HR        8.0       pb_fac_niolcomp    pekb_fac_niolcomp0.sql        Business   Faculty Non-    Maintains non-instructional overload           Faculty Load       PERFNIO
                                                                     Entity     Instructional   compensation                                   Compensation Self-
                                                                                Overload                                                       Service
                                                                                Compensation
HR        8.0       pb_fac_nisrate     ptkb_fac_nisrate0.sql         Business   Faculty Non-    Maintains non-instructional compensation       PTRNIST           PTRNILV
                                                                     Entity     Instructional   rules
                                                                                Compensation
                                                                                Rules
HR        8.0       pb_fac_nistcomp    pekb_fac_nistcomp0.sql        Business   Faculty Non-    Maintains non-instructional compensation       Faculty Load       PERFNIS
                                                                     Entity     Instructional                                                  Compensation Self-
                                                                                Compensation                                                   Service




                                                                           Page 16
                                                                  Banner APIs by Product

                                                                                                                                                                                        In




                                                                                                                                                                       Luminis Portal
           Release



                                                                                  Entity/                                                  Representative   Tables
Product              API Name             Main Source Name             Type       Process Name Logic Performed                             Source Forms     Affected
HR        8.0        pb_fac_schrate       ptkb_fac_schrate0.sql        Business   Faculty       Maintains schedule types compensation      PTRFLAC          PTRSCHD
                                                                       Entity     Schedule Type rules
                                                                                  Compensation
                                                                                  Rules

HR        8.0        pb_fac_sclrate       ptkb_fac_sclrate0.sql        Business   Faculty Level Maintains schedule type compensation       PTRFLAC          PTRSCLV
                                                                       Entity     Schedule Type rules by faculty level
                                                                                  Compensation
                                                                                  Rules

HR        7.2        pb_honor_award       ppkb_honor_award0.sql        Business   Honor Award    Maintains employee honors and awards      PPAGENL          PPRHNAW
                                                                       Entity
HR        8.1        pb_payhist_comment   phkb_payhist_comment0.sql    Business   Pay History    Provides the common business interface    PHAADJT          PHRCMNT
                                                                       Entity     Comment        for the Pay Adjustment Comments           PHAREDS

HR        7.2        pb_publication       ppkb_publication0.sql        Business   Publication    Maintains employee publication             PPAGENL         PPRPUBL
                                                                       Entity                    information
HR        8.10 pb_redistr_queue           phkb_redistr_queue0.sql      Business   Labor          Provides the common business interface     PHAADJT         PHRLRRQ
                                                                       Entity     Redistribution for the Labor Redistribution Routing Queue
HR        7.2        pb_skill             ppkb_skill0.sql              Business   Routing Queue Maintains employee skills
                                                                                  Skill                                                     PPASKIL         PPRSKIL
                                                                       Entity
HR        7.2        pb_stu_deduction     phkb_stu_deduction0.sql      Business   Student        Establishes information about the         PTRSTDE          PTRSTDE
                                                                       Entity     Deducation     deduction status for a student employee
                                                                                                 based on full-time or part-time status

HR        7.2        pb_stu_emp_cred      phkb_stu_emp_cred0.sql       Business   Student        Establishes information about the         PTRSCRD          PTRSCRD
                                                                       Entity     Employee       minimum hours required for a student
                                                                                  Credit         employee to be considered full-time
HR        7.1.5 pb_w2_coded_info          pxkb_w2_coded_info0.sql      Business   W-2 Coded      Maintains historical W-2 box amounts      PXAW2CC          PXRW2CD
                                                                       Entity     Information
HR        7.1.5 pb_w2_federal             pxkb_w2_federal0.sql         Business   W-2 Federal    Creates and maintains federal W-2         PXAW2CC          PXRW2FD
                                                                       Entity                    information
HR        7.1.5 pb_w2_local               pxkb_w2_local0.sql           Business   W-2 Local      Creates and maintains local W-2           PXAW2CC          PXRW2LC
                                                                       Entity                    information




                                                                             Page 17
                                                                Banner APIs by Product

                                                                                                                                                                                          In




                                                                                                                                                                         Luminis Portal
           Release



                                                                                Entity/                                                     Representative   Tables
Product         API Name                  Main Source Name           Type       Process Name Logic Performed                                Source Forms     Affected
HR        7.1.5 pb_w2_state               pxkb_w2_state0.sql         Business   W-2 State    Creates and maintains state W-2                PXAW2CC          PXRW2ST
                                                                     Entity                  information
HR        8.0        pp_fac_jobdistr      pbkp_fac_job_labor0.sql    Business   Faculty      Processes job labor distribution for faculty   Faculty Load       PERFJLD
                                                                     Process    Compensation compensation                                   Compensation Self-
                                                                                Job Labor                                                   Service
                                                                                Distribution
HR        7.1.5 pp_w2                     pxkp_w20.sql               Business   W-2             Processes W-2s                              PXAW2CC          PXRW2CD
                                                                     Process    Processing                                                                   PXRW2FD
                                                                                                                                                             PXRW2LC
                                                                                                                                                             PXRW2ST
HR        8.1.1 pp_w2_2008                pxkp_w2_20080.sql,         Business   W-2             Processes W-2s                              PXAW2CC          PXRW2CD
           and                            pxkp_w2_20081.sql          Process    Processing                                                                   PXRW2FD
          7.2.7                                                                                                                                              PXRW2LC
                                                                                                                                                             PXRW2ST
HR        7.2.2 pp_w2_common              pxkp_w2_common0.sql        Business   W-2 Common                                                  PXAW2CC          PXRW2FD
                                                                     Process                                                                PXRW207
                                                                                                                                            PXPW207
HR        7.2.1 pt_roe_contact_rules      ptkb_roe_cont_rule0.sql    Business   ROE Contact     Processes contact rules for Canadian        PTRROEC          PTRROEC
                                                                     Entity     Rules           Record of Employment (ROE) data



HR        7.2.1 px_mass_roe               pxkb_mass_roe0.sql         Business   Mass ROE        Processes mass Canadian Record of           PXAMROE          PXRMROE
                                                                     Entity                     Employment (ROE) data



HR        7.2.1 px_record_of_employment   pxkb_rec_of_empl0.sql      Business   Record of       Processes individual Canadian Record of     PXAROEC          PXRROEC
                                                                     Entity     Employment      Employment (ROE) data



Student   7.0        gb_address           gokb_address0.sql          Business   Address         Maintains address information               SPAIDEN          SPRADDR       X
                                                                     Entity
Student   7.0        gb_bio               gokb_bio0.sql              Business   Biographical    Maintains individual bio/demo information   SPAPERS          SPBPERS       X
                                                                     Entity
Student   7.0        gb_bldgdefinition    gokb_bldg_defn0.sql        Business   Building        Maintains information on buildings          SLABLDG          SLBBLDG
                                                                     Entity



                                                                           Page 18
                                                                      Banner APIs by Product

                                                                                                                                                                                               In




                                                                                                                                                                              Luminis Portal
          Release



                                                                                      Entity/                                                     Representative   Tables
Product             API Name                   Main Source Name            Type       Process Name Logic Performed                                Source Forms     Affected
Student   7.0       gb_classtimes              gokb_classroom0.sql         Business   Class Times  Maintains meeting times for specific           SSASECT          SSRMEET
                                                                           Entity                  sections
Student   7.0       gb_emergency_contact       gokb_emerg_cont0.sql        Business   Emergency    Maintains emergency contact information        SPAEMRG          SPREMRG      X
                                                                           Entity     Contact      about individuals
Student   7.0       gb_hold                    gokb_hold0.sql              Business   Hold         Places or removes holds on an account          SOAHOLD          SPRHOLD
                                                                           Entity
Student   7.0       gb_identification          gokb_ident0.sql             Business   Identification   Maintains person and non-person            SPAIDEN          SPRIDEN      X
                                                                           Entity                      bio/demo data
Student   7.0       gb_roomassignment          gokb_room_assign0.sql       Business   Room             Assigns learners to dorm rooms             SLARASG          SLRRASG
                                                                           Entity     Assignment
Student   7.0       gb_roomdefinition          gokb_room_defn0.sql         Business   Room             Maintains information about rooms in the   SLARDEF          SLBRDEF
                                                                           Entity     Definition       institution's buildings

Student   7.0       gb_telephone               gokb_telephone0.sql         Business   Telephone        Maintains telephone information            SPATELE          SPRTELE      X
                                                                           Entity
Student   7.0       sb_admissionsapplication   sokb_admissions0.sql        Business   Admissions       Maintains admissions applications          SAAADMS          SARADAP      X
                                                                           Entity     Application
Student   7.3       sb_application_decision    sokb_app_decision0.sql      Business   Application      Maintains separate decision codes on       SAADCRV          SARAPPD
                                                                           Entity     Decision         multiple admissions applications for the   SAADCBT
                                                                                                       same applicant within the same term
Student   8.1       sb_athletic_acad_prog      sgkb_athl_acad_prg0.sql     Business   Athletic         Processes academic progress information SGAAPRG             SGBAPRG
                                                                           Entity     Academic         for an athlete for athletic compliance
                                                                                      Progress
Student   8.1       sb_athletic_admissions     sgkb_athl_admissns0.sql     Business   Athletic         Processes admissions information for an    SGASPRT          SGRATAD
                                                                           Entity     Admissions       athlete for athletic compliance
                                                                                      Application
Student   8.1       sb_athletic_attributes     sgkb_athl_attrs0.sql        Business   Athletic         Processes attribute information for an     SGASPRT          SGRATHA
                                                                           Entity     Compliance       athlete for athletic compliance
                                                                                      Attributes
Student   8.1       sb_athletic_comments       sgkb_athl_comments0.sql     Business   Athletic         Processes comment information for an       SGASPRT          SGRATCT
                                                                           Entity     Comments         athlete for athletic compliance

Student   8.1       sb_athletic_competition    sgkb_athl_comptn0.sql       Business   Athletic         Processes competition information for an   SGASPRT          SGRATHC
                                                                           Entity     Compliance       athlete for athletic compliance
                                                                                      Competition



                                                                                 Page 19
                                                                          Banner APIs by Product

                                                                                                                                                                                               In




                                                                                                                                                                              Luminis Portal
           Release



                                                                                          Entity/                                                 Representative   Tables
Product              API Name                   Main Source Name               Type       Process Name Logic Performed                            Source Forms     Affected
Student   8.1        sb_athletic_compliance     sgkb_athl_complnce0.sql        Business   Athletic     Processes sport information for an athlete SGASPRT          SGRSPRT
                                                                               Entity     Compliance   for athletic compliance

Student   8.1        sb_athletic_degc_comp      sgkb_athl_degc_cmp0.sql        Business   Athletic Degree Processes degree completion information     SGAAPRG      SGBDCPR
                                                                               Entity     Completion      for an athlete for athletic compliance

Student   8.1        sb_athletic_eligibility    sgkb_athl_eligibl0.sql         Business   Athletic         Processes eligibility information for an   SGASPRT      SGRATHE
                                                                               Entity     Compliance       athlete for athletic compliance
                                                                                          Eligibility
Student   8.1        sb_athletic_transfer       sgkb_athl_trans0.sql           Business   Athletic         Processes transfer information for an      SGASPRT      SGRATHT
                                                                               Entity     Complliance      athlete for athletic compliance
                                                                                          Transfer
Student   7.2        sb_catlg_int_partner       sokb_catlg_intpart0.sql        Business   Catalog          Identifies course integration partners     SCADETL      SCRINTG
                                                                               Entity     Integration
                                                                                          Partner
Student   7.0        sb_course                  sokb_course0.sql               Business   Course           Creates and maintains basic course         SCACRSE      SCBCRSE      X
                                                                               Entity                      catalog information
Student   8.0        sb_course_labor            sckb_course_labor0.sql         Business   Course Labor     Maintains course labor distributions       SCACLBD      SCRCLBD      X
                                                                               Entity     Distribution
Student   8.0        sb_crse_atts_restriction   sckb_crsattsrstrct0.sql        Business   Course Student Maintains student attribute restrictions     SCARRES      SCRRATT      X
                                                                               Entity     Attribute      defined at the catalog level
                                                                                          Restriction

Student   8.0        sb_crse_chrt_restriction   sckb_crschrtrstrct0.sql        Business   Course Cohort    Maintains cohort restrictions defined at the SCARRES    SCRRCHR      X
                                                                               Entity     Restriction      catalog level
Student   8.0        sb_crse_dept_restriction   sckb_crsdeptrstrct0.sql        Business   Course           Maintains department restrictions defined SCARRES       SCRRDEP      X
                                                                               Entity     Department       at the catalog level
                                                                                          Restriction
Student   8.0        sb_crse_select_pri         sokb_crse_slct_pri0.sql        Business   Waitlist Course Maintains priority rules to be applied to   SOAWLTC      SOBCSPR      X
                                                                               Entity     Selection       waitlist course selection criteria by
                                                                                          Priority        sequence number

Student   7.3.1 sb_curric_status_event          sokb_curricstatus0.sql         Business   Curriculum       Maintains curriculum status for events     SORCSTS      SORCSTS
                                                                               Entity     Status Event




                                                                                     Page 20
                                                                        Banner APIs by Product

                                                                                                                                                                                                 In




                                                                                                                                                                                Luminis Portal
           Release



                                                                                        Entity/                                                     Representative   Tables
Product              API Name                 Main Source Name               Type       Process Name Logic Performed                                Source Forms     Affected
Student   7.0        sb_curriculum            sokb_crse_slct_pri0.sql        Business   Curriculum   Maintains learner curriculum information       SOQOLIB          SORLCUR      X
                                                                             Entity
Student   7.3.1 sb_curriculum_default         sokb_curricdefault0.sql        Business   Curriculum       Maintains default user curriculum          SORCLDF          SORCLDF
                                                                             Entity     Default          preferences for data entry
Student   7.3.1 sb_curriculum_history         sokb_curricarchive0.sql        Business   Curriculum       Maintains curriculum history               SOIHCUR          SORHCUR      X
                                                                             Entity     Archive
Student   7.1        sb_datafile_delimiter    sokb_filedelimiter1.sql        Business   File Delimiter   Maintains file delimiters                  SORDLIM          SORDLIM
                                                                             Entity
Student   7.1        sb_datafile_test_score   sokb_filetestscore1.sql        Business   Datafile Test    Maintains test scores                      SRATPTS          SRRTPTS
                                                                             Entity     Score
Student   7.3        sb_edi_acad_sess_sum     shkb_edi_ssum0.sql             Business   EDI Academic     Loads imported XML transcript academic     NA               SHRSUMS
                                                                             Entity     Session          session summary data
                                                                                        Summary
Student   7.3        sb_edi_acad_session      shkb_edi_sess0.sql             Business   EDI Academic Loads imported XML transcript academic         NA               SHRASES
                                                                             Entity     Session      session data
Student   7.3        sb_edi_acad_summ         shkb_edi_summ0.sql             Business   EDI Academic Loads imported XML transcript academic         NA               SHRSUMA
                                                                             Entity     Summary      summary data
Student   7.3        sb_edi_acrec_ude         shkb_edi_arc_ude0.sql          Business   EDI Academic Accesses imported XML transcript records       SHAEDIS          SHRAUDE
                                                                             Entity     Record UDE   for academic record UDE data
Student   7.3        sb_edi_course            shkb_edi_course0.sql           Business   EDI Course   Accesses imported XML transcript records       SHAEDIS          SHRCRSR
                                                                             Entity                  for course UDE data
Student   7.3        sb_edi_doc_header        shkb_edi_dochead0.sql          Business   EDI Document Accesses imported XML transcript records       NA               SHRHDR4
                                                                             Entity     Header       for document identification header

Student   7.3        sb_edi_header            shkb_edi_header0.sql           Business   EDI Header       Accesses imported XML transcript records NA                 SHBHEAD
                                                                             Entity                      for document master header record

Student   7.3        sb_edi_identification    shkb_edi_ident0.sql            Business   EDI              Accesses imported XML transcript records   NA               SHRIDEN
                                                                             Entity     Identification   for person identification data
Student   7.3.2 sb_edi_immunization           shkb_edi_immu0.sql             Business   EDI              Accesses imported XML transcript records   SHAEDIS          SHRIMMU
                                                                             Entity     Immunization     for immunization data
Student   7.3        sb_edi_medical           shkb_edi_medical0.sql          Business   EDI Medical      Accesses imported XML transcript records   NA               SHRMEDI
                                                                             Entity                      for medical data
Student   7.3        sb_edi_status            shkb_edi_status0.sql           Business   EDI Status       Accesses imported XML transcript records   NA               SHREDIS
                                                                             Entity                      for EDI status data



                                                                                   Page 21
                                                                        Banner APIs by Product

                                                                                                                                                                                                     In




                                                                                                                                                                                    Luminis Portal
           Release



                                                                                        Entity/                                                         Representative   Tables
Product              API Name                  Main Source Name              Type       Process Name       Logic Performed                              Source Forms     Affected
Student   7.3        sb_edi_stud_ude           shkb_edi_stu_ude0.sql         Business   EDI Student        Accesses imported XML transcript records     SHAEDIS          SHRSUDE
                                                                             Entity     UDE                for student UDE data
Student   7.3        sb_edi_subtest            shkb_edi_subt0.sql            Business   EDI Subtest        Accesses imported XML transcript records     NA               SHRSTST
                                                                             Entity                        for subtest data
Student   7.3        sb_edi_subtest_score      shkb_edi_subt_sc0.sql         Business   EDI Subtest        Accesses imported XML transcript records     NA               SHRSTSC
                                                                             Entity     Score              for subtest score data
Student   7.3        sb_edi_test               shkb_edi_test0.sql            Business   EDI Test           Accesses imported XML transcript records     NA               SHRTEST
                                                                             Entity                        for test data
Student   7.3        sb_edi_trans_ude          shkb_edi_tr_ude0.sql          Business   EDI Transcript Accesses imported XML transcript records         SHAEDIS          SHRTUDE
                                                                             Entity     UDE                for transript UDE data
Student   7.2        sb_enroll_ver_payment     sokb_enr_ver_pay0.sql         Business   Enrollment         Provides rules for enrollment verification   SFAEPRT          SFRENPO
                                                                             Entity     Verification Self- self-service payment options
                                                                                        Service
                                                                                        Payment
                                                                                        Options
Student   7.2        sb_enroll_ver_service     sokb_enr_ver_serve0.sql       Business   Enrollment         Provides rules for enrollment verification   SFAEPRT          SFRENSS
                                                                             Entity     Verification Self- self-service delivery options
                                                                                        Service Options

Student   7.0        sb_facassignment          sokb_fac_assign0.sql          Business   Faculty           Maintains course assignments for a faculty SIAASGN             SIRASGN      X
                                                                             Entity     Assignment        member or advisor
Student   7.0        sb_faculty                sokb_faculty0.sql             Business   Faculty           Maintains information about faculty         SIAINST            SIBINST      X
                                                                             Entity                       members and advisors
Student   7.0        sb_fieldofstudy           sokb_fieldstudy0.sql          Business   Field of Study    Maintains learner curriculum field of study SOQOLIB            SORLFOS
                                                                             Entity
Student   7.2        sb_fieldofstudy_allowed   sokb_lfst_allowed0.sql        Business   Field of Study    Provides rules for number of fields of study SOACTRL           SORLMFS
                                                                             Entity     Allowed           allowed
Student   7.3.1 sb_fieldofstudy_archive        sokb_lfosarchive0.sql         Business   Field of Study    Maintains field of study history             SOIHCUR           SORHFOS
                                                                             Entity     Archive
Student   8.0        sb_gradapp                shkb_gradapp0.sql             Business   Graduation        Maintains student graduation applications     SHAGAPP          SHBGAPP      X
                                                                             Entity     Application




                                                                                   Page 22
                                                                      Banner APIs by Product

                                                                                                                                                                                                    In




                                                                                                                                                                                   Luminis Portal
           Release



                                                                                      Entity/                                                          Representative   Tables
Product              API Name                 Main Source Name             Type       Process Name Logic Performed                                     Source Forms     Affected
Student   8.0        sb_gradapp_displayrule   shkb_gradapp_dsprl0.sql      Business   Graduation   Maintains graduation application display            SHAGADR          SHBGADR      X
                                                                           Entity     Application  rules for self-service
                                                                                      Display Rule
Student   8.0        sb_gradapp_eligible      shkb_gradapp_eligb0.sql      Business   Graduation        Maintains graduation application eligibility   SHAGELR          SHBGELR      X
                                                                           Entity     Application       rules for self-service
                                                                                      Elibibility Rules
                                                                                      Selection
Student   8.0        sb_gradapp_graddate      shkb_gradapp_graddt0.sql     Business   Graduation       Maintains rules for graduation dates            SHAGADR          SHRGADA      X
                                                                           Entity     Application
                                                                                      Dates
Student   8.0        sb_gradapp_paymentopts   shkb_gradapp_paymt0.sql      Business   Graduation       Maintains rules for graduation application      SHAGADR          SHRGAPO      X
                                                                           Entity     Application      payment options
                                                                                      Payment
                                                                                      Options
Student   8.0        sb_gradapp_selrule       shkb_gradapp_selrl0.sql      Business   Graduation       Maintains rules to select curriculum for self- SHAGADS           SHBGADS      X
                                                                           Entity     Application      service graduation application
                                                                                      Display Rule
                                                                                      Selection
Student   7.3.1 sb_highschool                 sokb_highschool0.sql         Business   High School      Maintains high school records                   SOAHSCH          SORHSCH
                                                                           Entity     Information
Student   8.0        sb_incmp_grading         shkb_incmp_grading0.sql      Business   Incomplete       Maintains incomplete grade rules                SHAINCG          SHRINCG      X
                                                                           Entity     Grade Rule
Student   7.0        sb_learner               sokb_learner0.sql            Business   Learner          Creates and admits a learner                    SOAQUIK          SGBSTDN      X
                                                                           Entity
Student   7.0        sb_learnercurricstatus   sokb_curric_stat0.sql        Business   Learner          Maintains learner curriculum activity and       SORCACT          SOBCACT
                                                                           Entity     Curriculum       status rules
                                                                                      Status
Student   7.0        sb_learnermodule         sokb_learner_mod0.sql        Business   Learner Module Maintains Learner Module information              SOACTRL          SOBLMOD
                                                                           Entity
Student   7.0        sb_learneroutcome        sokb_learneroutcome0.sql     Business   Learner          Maintains degree and award information          SHADEGR          SHRDGMR
                                                                           Entity     Outcome
Student   8.0        sb_mass_entry            sokb_massentry0.sql          Business   Mass Entry       Maintains mass entry selection information SOAMAUD               SORMAUD      X
                                                                           Entity     Results
Student   8.0        sb_mass_entry_column     sokb_massentrycol0.sql       Business   Mass Entry       Maintains mass entry columns and values SOAMAUD                  SORMECL      X
                                                                           Entity     Columns          for search and update processing



                                                                                 Page 23
                                                                         Banner APIs by Product

                                                                                                                                                                                                  In




                                                                                                                                                                                 Luminis Portal
          Release



                                                                                         Entity/                                                     Representative   Tables
Product             API Name                   Main Source Name               Type       Process Name     Logic Performed                            Source Forms     Affected
Student   8.0       sb_mass_entry_form         sokb_massentryform0.sql        Business   Mass Entry       Maintains mass entry session header        SOAMAUD          SOBMAUD      X
                                                                              Entity     Forms            information
Student   7.0       sb_mealassignment          sokb_meal_assign0.sql          Business   Meal             Maintains applicant information on meal    SLAMASG          SLRMASG
                                                                              Entity     Assignment       assignments
Student   7.3       sb_pesc_status_export      shkb_xml_stat_ex0.sql          Business   PESC Status      Accesses imported XML transcript records   NA               SHREPTD
                                                                              Entity     Export           for transcript export status
Student   7.3       sb_pesc_status_imp         shkb_xml_stat_im0.sql          Business   PESC Status      Accesses imported XML transcript records   NA               SHRIPTD
                                                                              Entity     Import           for transcript import status
Student   7.3       sb_pescxml_trandata_exp    shkb_xml_trdata_ex0.sql        Business   PESC/XML         Extracts transmission data from the        STVSBGI          GUBINST      X
                                                                              Entity     Transcript       database                                                    STVSBGI
                                                                                         Export
Student   7.3       sb_pescxml_trandata_imp    shkb_xml_trdata_im0.sql        Business   PESC/XML         Imports transmission data into the         SHAEDIS          SHBHEAD      X
                                                                              Entity     Transcript       database
                                                                                         Import
Student   7.0       sb_phoneassignment         sokb_phone_assign0.sql         Business   Phone            Maintains applicant information on         SLAPASG          SLRPASG
                                                                              Entity     Assignment       telephone assignments
Student   7.0       sb_recruit                 sokb_recruit0.sql              Business   Recruit          Maintains information on prospective       SRARECR          SRBRECR      X
                                                                              Entity                      applicants
Student   8.0       sb_registration_msg        sfkb_registrn_msg0.sql         Business   Registration     Returns error messages for registration    SFARMSG          SFRRMSG      X
                                                                              Entity     Message          process by message code and sequence
                                                                                                          number
Student   7.0       sb_roommate                sokb_roommate0.sql             Business   Roommate         Maintains roommate applications            SLARMAT          SLRRMAT
                                                                              Entity
Student   7.0       sb_roompreference          sokb_room_pref0.sql            Business   Room             Maintains applications for dorm rooms and SLARMAP           SLBRMAP
                                                                              Entity     Preference       meal plans
Student   8.0       sb_sect_atts_restriction   sskb_secattsrstrct0.sql        Business   Section          Maintains student attribute restrictions  SSARRES           SSRRATT      X
                                                                              Entity     Student          defined at the schedule level
                                                                                         Attribute
                                                                                         Restriction
Student   8.0       sb_sect_chrt_restriction   sskb_secchrtrstrct0.sql        Business   Section Cohort   Maintains cohort restrictions defined at the SSARRES        SSRRCHR      X
                                                                              Entity     Restriction      schedule level
Student   8.0       sb_sect_dept_restriction   sskb_secdeptrstrct0.sql        Business   Section          Maintains department restrictions defined SSARRES           SSRRDEP      X
                                                                              Entity     Department       at the schedule level
                                                                                         Restriction




                                                                                    Page 24
                                                                        Banner APIs by Product

                                                                                                                                                                                                  In




                                                                                                                                                                                 Luminis Portal
           Release



                                                                                        Entity/                                                      Representative   Tables
Product              API Name                    Main Source Name            Type       Process Name Logic Performed                                 Source Forms     Affected
Student   7.0        sb_section                  sokb_section0.sql           Business   Section      Maintains section records for a course          SSASECT          SSBSECT
                                                                             Entity
Student   8.0        sb_section_labor            sskb_section_labor0.sql     Business   Class Labor      Maintains course labor distribution         SSACLBD          SSRCLBD      X
                                                                             Entity     Distribution     information

Student   7.0        sb_smrprle                  svkb_smrprle0.sql           Business   Program Rules Maintains Program Rules records for a          SMAPRLE          SMRPRLE
                                                                             Entity                   course of study
Student   7.0        sb_sobctrl                  sokb_sobctrl0.sql           Business   Curriculum    Creates and maintains curriculum rules         SOACTRL          SOBCTRL
                                                                             Entity     Rules Control control record
Student   7.0        sb_term                     sokb_term0.sql              Business   Term          Maintains controls for a specific term         SOATERM          SOBTERM      X
                                                                             Entity
Student   7.2        sb_test_percentile          sokb_testpercentile0.sql    Business   Test Percentile Identifies test score percentiles            SOATEST          SORTSPC
                                                                             Entity
Student   7.3.1 sb_testscore                     sokb_testscore0.sql         Business   Test Score       Maintains test score records for a person   SOATEST          SORTEST
                                                                             Entity     Information
Student   7.2        sb_transcript_name          sokb_trans_name0.sql        Business   Transcript       Identifies name hierarchy for transcript    SHATPRT          SHRTRNM
                                                                             Entity     Name             type
Student   7.2        sb_transcript_name_source   sokb_trans_namesrce0.sql    Business   Transcript       Identifies names available to print on      SHRTRNS          SHRTRNS
                                                                             Entity     Names Source     transcript
Student   7.2        sb_transcript_req_name      sokb_transreq_name0.sql     Business   Transcript       Identifies name hierarchy for transcript    SHARQTC          SHTTRNM
                                                                             Entity     Request Name     request
Student   8.0        sb_transfer_crse            shkb_xfer_crse0.sql         Business   Transfer         Processes transfer courses                  SHATATC          SHBTATC      X
                                                                             Entity     Institution                                                  SHATATR
                                                                                        Catalog Entry
Student   8.0        sb_transfer_crse_attr       shkb_xfer_crse_atr0.sql     Business   Transfer         Processes transfer course attributes        SHATATC          SHRTCAT      X
                                                                             Entity     Course                                                       SHATATR
                                                                                        Attribute
Student   8.0        sb_transfer_crse_cmt        shkb_xfer_crse_cmt0.sql     Business   Transfer         Processes transfer course comments          SHATATC          SHRTCMT      X
                                                                             Entity     Course                                                       SHATATR
                                                                                        Comment
Student   8.0        sb_transfer_equiv           shkb_xfer_eqv0.sql          Business   Equivalent       Processes equivalent courses                SHATATR          SHRTATC      X
                                                                             Entity     Course
Student   8.0        sb_transfer_equiv_attr      shkb_xfer_eqv_atr0.sql      Business   Equivalent       Processes equivalent course attributes      SHATATR          SHRTRAT      X
                                                                             Entity     Course
                                                                                        Attribute



                                                                                   Page 25
                                                                      Banner APIs by Product

                                                                                                                                                                                                In




                                                                                                                                                                               Luminis Portal
           Release



                                                                                      Entity/                                                      Representative   Tables
Product              API Name                Main Source Name              Type       Process Name Logic Performed                                 Source Forms     Affected
Student   8.0        sb_transfer_equiv_cmt   shkb_xfer_eqv_cmt0.sql        Business   Equivalent   Processes equivalent course comments            SHATATR          SHRICMT      X
                                                                           Entity     Course
                                                                                      Comment
Student   8.0        sb_wl_collector         sfkb_wl_collector0.sql        Business   Waitlist         Maintains sections by term and CRN with NA                   SFRCOLW      X
                                                                           Entity     Collector        new available seats for which a waitlisted
                                                                                                       student can register and be counted in
                                                                                                       enrollment

Student   8.0        sb_wl_exclusion         sokb_wl_exclusion0.sql        Business   Waitlist         Maintains waitlist exclusion rules by        SOAWLTC         SOBEXCR      X
                                                                           Entity     Exclusion        sequence number that prevent students
                                                                                      Rules            from being added to a course waitist if they
                                                                                                       fall into any of the specified exclusions

Student   8.0        sb_wl_notification      sfkb_wl_notif0.sql            Business   Waitlist         Maintains students notified of available    SFIWLNT          SFRWLNT      X
                                                                           Entity     Notification     seats in a section by term, CRN, and
                                                                                                       PIDM
Student   8.0        sb_wl_reordering        sokb_wl_reordering0.sql       Business   Waitlist         Maintains waitlist reordering rules by      SOAWLTC          SOBROPR      X
                                                                           Entity     Reorder Priority sequence number to be applied to
                                                                                      Rules            students registered in the waitlist queue
Student   8.0        sb_wl_section_ctrl      sskb_wl_sec_ctrl0.sql         Business   Waitlist Section Maintains the waitlist configuration for    SSAWLSC          SSBWLSC      X
                                                                           Entity     Control          each section by term and CRN

Student   8.0        sb_wl_term_control      sokb_wl_term_ctrl0.sql        Business   Waitlist Term    Configures waitlist by term                 SOAWLTC          SOBWLTC      X
                                                                           Entity     Control
Student   7.1.1 sp_academic_period           sokp_academic_period0.sql     Business   Academic         Returns academic periods                    NA               STVTERM
                                                                           Process    Period                                                                        SOBTERM
                                                                                                                                                                    STVACYR
Student   8.0        sp_catalog_export       sckp_catalog_export0.sql      Business   Course Catalog Extracts course, level, schedule type,      NA                 SCBCRSE
                                                                           Process    Extract        attribute, and description data from course                    SCBDESC
                                                                                                     catalog tables                                                 SCRATTR
                                                                                                                                                                    SCRLEVL
                                                                                                                                                                    SCRSCMD




                                                                                 Page 26
                                                               Banner APIs by Product

                                                                                                                                                                                          In




                                                                                                                                                                         Luminis Portal
           Release



                                                                                Entity/                                                      Representative   Tables
Product         API Name                 Main Source Name            Type       Process Name Logic Performed                                 Source Forms     Affected
Student   7.1.1 sp_housing_eligibility   sgkp_housing_elgblty0.sql   Business   Housing      Verifies eligibility of an applicant to apply   NA               GORRSQL
                                                                     Process    Applicant    for housing                                                      GTVSDAX
                                                                                Eligibility
Student   7.1.1 sp_housing_profile       sgkp_housing_profile0.sql   Business   Housing          Returns housing profile information         NA               GTVSDAX
                                                                     Process    Applicant                                                                     SPRMEDI
                                                                                Profile                                                                       STVDISA
                                                                                                                                                              STVSPSR
                                                                                                                                                              STVACTC
                                                                                                                                                              STVTERM
                                                                                                                                                              STVELIG
                                                                                                                                                              SGRSACT
                                                                                                                                                              STVCACT




                                                                           Page 27
                                                  Banner APIs by Product

                                                                                                                                             In




                                                                                                                            Luminis Portal
          Release



                                                                 Entity/                        Representative   Tables
Product             API Name   Main Source Name        Type      Process Name Logic Performed   Source Forms     Affected




                                                              Page 28
                                                  Banner APIs by Product

                                                                                                                                             In




                                                                                                                            Luminis Portal
          Release



                                                                 Entity/                        Representative   Tables
Product             API Name   Main Source Name        Type      Process Name Logic Performed   Source Forms     Affected




                                                              Page 29
                                                  Banner APIs by Product

                                                                                                                                             In




                                                                                                                            Luminis Portal
          Release



                                                                 Entity/                        Representative   Tables
Product             API Name   Main Source Name        Type      Process Name Logic Performed   Source Forms     Affected




                                                              Page 30
                                                  Banner APIs by Product

                                                                                                                                             In




                                                                                                                            Luminis Portal
          Release



                                                                 Entity/                        Representative   Tables
Product             API Name   Main Source Name        Type      Process Name Logic Performed   Source Forms     Affected




                                                              Page 31
                                                  Banner APIs by Product

                                                                                                                                             In




                                                                                                                            Luminis Portal
          Release



                                                                 Entity/                        Representative   Tables
Product             API Name   Main Source Name        Type      Process Name Logic Performed   Source Forms     Affected




                                                              Page 32
                                                                                       Banner APIs by Product

                                                              Integrations                                                                                                                                                                  Enhancements




                                                                                                                                                                                                                          AR Term Control




                                                                                                                                                                                                                                                                  Officer Search
                                                                                       eProcurement




                                                                                                                                                                                                                                                                  Advancement
                                                               Campus Card




                                                                                                      Technologies




                                                                                                                                                                                  Basic Person
                                                                                                                                          Concurrent
                                                                                                      Integration




                                                                                                                                                                                                             PESC/XML
                                                                                                                                                                                                             Transcript




                                                                                                                                                                                                                                                                                   Approvals
                                                                                                                                                                                                                                                                                   Electronic
                                                                                                                                                       SRTLOAD
                                                  eLearning




                                                                                                                                                                 Bio Demo




                                                                                                                                                                                                 Applicant
                                                                                                                                          Curricula
                                                                                                                     Matching

                                                                                                                                New VBS
                                                                                                                     Common




                                                                                                                                                                                                                                                      Ethnicity
                                                                             Housing




                                                                                                                                                       AMCAS/
              Release




                                                                                                                                                                                                                                                      Race
                                                                                                                                                                            COD




                                                                                                                                                                                                                                              eBill




                                                                                                                                                                                                                                                                                                SDE
Product                 API Name
Advancement   7.0       ab_adv_individual                        X

Advancement   7.0       ab_adv_organization                      X



Advancement   7.4       ab_custom_search_detail                                                                                                                                                                                                                        X

Advancement   7.4       ab_custom_search_header                                                                                                                                                                                                                        X



Advancement   7.0       ab_donor_category                        X

Advancement   8.1       ab_gift_auxl_hold



Advancement   8.1       ab_project_history

Advancement   8.1       ab_project_results



Advancement   8.1       ab_proposal_history

AR            7.0       tb_cashier_session

AR            7.0       tb_customer_profile                      X

AR            7.0       tb_depo_control

AR            7.0       tb_deposit                               X            X

AR            7.0       tb_detail_code

AR            7.2       tb_memo




                                                                                                                        Page 33
                                                                                  Banner APIs by Product

                                                         Integrations                                                                                                                                                                  Enhancements




                                                                                                                                                                                                                     AR Term Control




                                                                                                                                                                                                                                                             Officer Search
                                                                                  eProcurement




                                                                                                                                                                                                                                                             Advancement
                                                          Campus Card




                                                                                                 Technologies




                                                                                                                                                                             Basic Person
                                                                                                                                     Concurrent
                                                                                                 Integration




                                                                                                                                                                                                        PESC/XML
                                                                                                                                                                                                        Transcript




                                                                                                                                                                                                                                                                              Approvals
                                                                                                                                                                                                                                                                              Electronic
                                                                                                                                                  SRTLOAD
                                             eLearning




                                                                                                                                                            Bio Demo




                                                                                                                                                                                            Applicant
                                                                                                                                     Curricula
                                                                                                                Matching

                                                                                                                           New VBS
                                                                                                                Common




                                                                                                                                                                                                                                                 Ethnicity
                                                                        Housing




                                                                                                                                                  AMCAS/
           Release




                                                                                                                                                                                                                                                 Race
                                                                                                                                                                       COD




                                                                                                                                                                                                                                         eBill




                                                                                                                                                                                                                                                                                           SDE
Product              API Name
AR        7.0        tb_misc_detail                         X            X

AR        7.0        tb_misc_header                         X            X



AR        7.0        tb_receivable                          X            X

AR        7.3        tb_statement                                                                                                                                                                                                        X




AR        7.1        tb_term_control_ar                                                                                                                                                                                X

AR        7.1.1 tp_student_deposit                                       X

AR        7.1.1 tp_student_receivable                                    X

Finance   7.0        fb_accounting_element




Finance   7.0        fb_chart_of_accounts

Finance   7.0        fb_commodity

Finance   8.0        fb_encumbrance_detail



Finance   8.0        fb_encumbrance_header




                                                                                                                   Page 34
                                                                             Banner APIs by Product

                                                    Integrations                                                                                                                                                                  Enhancements




                                                                                                                                                                                                                AR Term Control




                                                                                                                                                                                                                                                        Officer Search
                                                                             eProcurement




                                                                                                                                                                                                                                                        Advancement
                                                     Campus Card




                                                                                            Technologies




                                                                                                                                                                        Basic Person
                                                                                                                                Concurrent
                                                                                            Integration




                                                                                                                                                                                                   PESC/XML
                                                                                                                                                                                                   Transcript




                                                                                                                                                                                                                                                                         Approvals
                                                                                                                                                                                                                                                                         Electronic
                                                                                                                                             SRTLOAD
                                        eLearning




                                                                                                                                                       Bio Demo




                                                                                                                                                                                       Applicant
                                                                                                                                Curricula
                                                                                                           Matching

                                                                                                                      New VBS
                                                                                                           Common




                                                                                                                                                                                                                                            Ethnicity
                                                                   Housing




                                                                                                                                             AMCAS/
          Release




                                                                                                                                                                                                                                            Race
                                                                                                                                                                  COD




                                                                                                                                                                                                                                    eBill




                                                                                                                                                                                                                                                                                      SDE
Product             API Name
Finance   8.1       fb_grant_effcert



Finance   7.2       fb_invoice_acctg

Finance   7.2       fb_invoice_header

Finance   7.2       fb_invoice_item

Finance   7.2       fb_invoice_tax

Finance   7.3       fb_jv_detail

Finance   7.3       fb_jv_header

Finance   7.1       fb_po_tax                                                  X

Finance   7.0       fb_purchase_order



Finance   7.1       fb_req_tax                                                 X

Finance   7.0       fb_requisition



Finance   7.0       fb_ship



Finance   7.0       fb_vendor

Finance   7.0       fb_vendor_type

Finance   8.0       fp_encumbrance




                                                                                                              Page 35
                                                                                        Banner APIs by Product

                                                               Integrations                                                                                                                                                                  Enhancements




                                                                                                                                                                                                                           AR Term Control




                                                                                                                                                                                                                                                                   Officer Search
                                                                                        eProcurement




                                                                                                                                                                                                                                                                   Advancement
                                                                Campus Card




                                                                                                       Technologies




                                                                                                                                                                                   Basic Person
                                                                                                                                           Concurrent
                                                                                                       Integration




                                                                                                                                                                                                              PESC/XML
                                                                                                                                                                                                              Transcript




                                                                                                                                                                                                                                                                                    Approvals
                                                                                                                                                                                                                                                                                    Electronic
                                                                                                                                                        SRTLOAD
                                                   eLearning




                                                                                                                                                                  Bio Demo




                                                                                                                                                                                                  Applicant
                                                                                                                                           Curricula
                                                                                                                      Matching

                                                                                                                                 New VBS
                                                                                                                      Common




                                                                                                                                                                                                                                                       Ethnicity
                                                                              Housing




                                                                                                                                                        AMCAS/
                 Release




                                                                                                                                                                                                                                                       Race
                                                                                                                                                                             COD




                                                                                                                                                                                                                                               eBill




                                                                                                                                                                                                                                                                                                 SDE
Product                    API Name
Finance         7.3        fp_invoice




Finance         7.3        fp_journal_voucher




Financial Aid   7.9        rb_applicant_comment

Financial Aid   8.1        rb_application_status

Financial Aid   7.8        rb_award

Financial Aid   7.0        rb_award_disbursement                                                                                                                             X

Financial Aid   7.8        rb_award_schedule

Financial Aid   7.0        rb_cod_document                                                                                                                                   X

Financial Aid   7.0        rb_cod_identifier                                                                                                                                 X

Financial Aid   7.0        rb_dl_refund                                                                                                                                      X

Financial Aid   7.9        rb_ny_user_def_data



Financial Aid   7.0        rb_pell_originations                                                                                                                              X

Financial Aid   7.3.1 rb_requirement

Financial Aid   8.1        rb_sim_appl_status




                                                                                                                         Page 36
                                                                                   Product




          Financial Aid
                          Financial Aid
                                                Financial Aid
                                                                   Financial Aid
                                                                                   Financial Aid
                                                                                              Release




          7.8
                          8.1
                                                7.9
                                                                   7.8
                                                                                   8.1




          rp_award
                                                                                   API Name




                                                                   rb_temp_award

                                                rb_user_def_data

                          rp_applicant_status
                                                                                   rb_temp_appl_status




                                                                                             eLearning


                                                                                             Campus Card


                                                                                             Housing
                                                                                                               Integrations




                                                                                             eProcurement

                                                                                             Integration
                                                                                             Technologies
                                                                                             Common
                                                                                             Matching

                                                                                             New VBS




Page 37
                                                                                             Concurrent
                                                                                             Curricula
                                                                                             AMCAS/
                                                                                             SRTLOAD
                                                                                                                              Banner APIs by Product




                                                                                             Bio Demo


                                                                                             COD


                                                                                             Basic Person


                                                                                             Applicant

                                                                                             PESC/XML
                                                                                             Transcript

                                                                                             AR Term Control


                                                                                             eBill

                                                                                             Race
                                                                                             Ethnicity
                                                                                                               Enhancements




                                                                                             Advancement
                                                                                             Officer Search
                                                                                             Electronic
                                                                                             Approvals

                                                                                             SDE
                                                                                        Banner APIs by Product

                                                               Integrations                                                                                                                                                                  Enhancements




                                                                                                                                                                                                                           AR Term Control




                                                                                                                                                                                                                                                                   Officer Search
                                                                                        eProcurement




                                                                                                                                                                                                                                                                   Advancement
                                                                Campus Card




                                                                                                       Technologies




                                                                                                                                                                                   Basic Person
                                                                                                                                           Concurrent
                                                                                                       Integration




                                                                                                                                                                                                              PESC/XML
                                                                                                                                                                                                              Transcript




                                                                                                                                                                                                                                                                                    Approvals
                                                                                                                                                                                                                                                                                    Electronic
                                                                                                                                                        SRTLOAD
                                                   eLearning




                                                                                                                                                                  Bio Demo




                                                                                                                                                                                                  Applicant
                                                                                                                                           Curricula
                                                                                                                      Matching

                                                                                                                                 New VBS
                                                                                                                      Common




                                                                                                                                                                                                                                                       Ethnicity
                                                                              Housing




                                                                                                                                                        AMCAS/
                 Release




                                                                                                                                                                                                                                                       Race
                                                                                                                                                                             COD




                                                                                                                                                                                                                                               eBill




                                                                                                                                                                                                                                                                                                 SDE
Product                    API Name
Financial Aid   7.8        rp_award_schedule




Financial Aid   7.3.1 rp_requirement




General         8.0        gb_additional_ident

General         7.0        gb_address               X            X             X                                                                                                     X

General         7.0        gb_bio                   X            X             X                                                                                                     X

General         7.0        gb_bldgdefinition                                   X

General         7.0        gb_bus_prof_rule                                                                                       X



General         7.0        gb_businessprofile                                                                                     X



General         7.0        gb_busprofpii                                                                                          X



General         7.0        gb_classtimes            X

General         7.0        gb_cm_data_dictionary                                                                        X




                                                                                                                         Page 38
                                                                                 Banner APIs by Product

                                                        Integrations                                                                                                                                                                  Enhancements




                                                                                                                                                                                                                    AR Term Control




                                                                                                                                                                                                                                                            Officer Search
                                                                                 eProcurement




                                                                                                                                                                                                                                                            Advancement
                                                         Campus Card




                                                                                                Technologies




                                                                                                                                                                            Basic Person
                                                                                                                                    Concurrent
                                                                                                Integration




                                                                                                                                                                                                       PESC/XML
                                                                                                                                                                                                       Transcript




                                                                                                                                                                                                                                                                             Approvals
                                                                                                                                                                                                                                                                             Electronic
                                                                                                                                                 SRTLOAD
                                            eLearning




                                                                                                                                                           Bio Demo




                                                                                                                                                                                           Applicant
                                                                                                                                    Curricula
                                                                                                               Matching

                                                                                                                          New VBS
                                                                                                               Common




                                                                                                                                                                                                                                                Ethnicity
                                                                       Housing




                                                                                                                                                 AMCAS/
          Release




                                                                                                                                                                                                                                                Race
                                                                                                                                                                      COD




                                                                                                                                                                                                                                        eBill




                                                                                                                                                                                                                                                                                          SDE
Product             API Name
General   7.3       gb_cm_disp_hier                                                                              X




General   7.0       gb_cm_display_options                                                                        X




General   7.0       gb_cm_rules                                                                                  X



General   7.0       gb_cm_source_priority                                                                        X



General   7.0       gb_cm_source_rules                                                                           X




General   7.0       gb_cm_user_procedure                                                                         X



General   7.0       gb_cm_user_setup                                                                             X



General   7.0       gb_currency




                                                                                                                  Page 39
                                                                                   Banner APIs by Product

                                                          Integrations                                                                                                                                                                  Enhancements




                                                                                                                                                                                                                      AR Term Control




                                                                                                                                                                                                                                                              Officer Search
                                                                                   eProcurement




                                                                                                                                                                                                                                                              Advancement
                                                           Campus Card




                                                                                                  Technologies




                                                                                                                                                                              Basic Person
                                                                                                                                      Concurrent
                                                                                                  Integration




                                                                                                                                                                                                         PESC/XML
                                                                                                                                                                                                         Transcript




                                                                                                                                                                                                                                                                               Approvals
                                                                                                                                                                                                                                                                               Electronic
                                                                                                                                                   SRTLOAD
                                              eLearning




                                                                                                                                                             Bio Demo




                                                                                                                                                                                             Applicant
                                                                                                                                      Curricula
                                                                                                                 Matching

                                                                                                                            New VBS
                                                                                                                 Common




                                                                                                                                                                                                                                                  Ethnicity
                                                                         Housing




                                                                                                                                                   AMCAS/
           Release




                                                                                                                                                                                                                                                  Race
                                                                                                                                                                        COD




                                                                                                                                                                                                                                          eBill




                                                                                                                                                                                                                                                                                            SDE
Product              API Name
General   7.0        gb_currency_rate




General   7.0        gb_displaycolumns                                                                                       X

General   7.0        gb_displaymask                                                                                          X



General   7.0        gb_domains                                                                                              X

General   7.0        gb_domaintype                                                                                           X

General   7.0        gb_email                  X            X             X                                                                                                     X

General   7.0        gb_emergency_contact                                 X                           X                                                                         X

General   7.0        gb_fgac_user_rule                                                                                       X

General   7.0        gb_fgacexcludedobjects                                                                                  X



General   7.0        gb_group_rules                                                                                          X

General   7.0        gb_hold

General   7.0        gb_identification         X            X             X                           X                                                                         X

General   7.4        gb_immunization

General   7.3.1 gb_institution_role            X




                                                                                                                    Page 40
                                                                                 Banner APIs by Product

                                                        Integrations                                                                                                                                                                  Enhancements




                                                                                                                                                                                                                    AR Term Control




                                                                                                                                                                                                                                                            Officer Search
                                                                                 eProcurement




                                                                                                                                                                                                                                                            Advancement
                                                         Campus Card




                                                                                                Technologies




                                                                                                                                                                            Basic Person
                                                                                                                                    Concurrent
                                                                                                Integration




                                                                                                                                                                                                       PESC/XML
                                                                                                                                                                                                       Transcript




                                                                                                                                                                                                                                                                             Approvals
                                                                                                                                                                                                                                                                             Electronic
                                                                                                                                                 SRTLOAD
                                            eLearning




                                                                                                                                                           Bio Demo




                                                                                                                                                                                           Applicant
                                                                                                                                    Curricula
                                                                                                               Matching

                                                                                                                          New VBS
                                                                                                               Common




                                                                                                                                                                                                                                                Ethnicity
                                                                       Housing




                                                                                                                                                 AMCAS/
          Release




                                                                                                                                                                                                                                                Race
                                                                                                                                                                      COD




                                                                                                                                                                                                                                        eBill




                                                                                                                                                                                                                                                                                          SDE
Product             API Name
General   7.4       gb_integ_config          X



General   7.3       gb_large_object

General   7.3       gb_medical                                                                                                                              X                                             X

General   7.0       gb_name_translate                                                                            X

General   7.0       gb_np_name_trans                                                                             X



General   7.2       gb_partner_rule          X

General   7.3       gb_pcol_concentration                                                           X                                                       X

General   7.3       gb_pcol_degree                                                                  X                                                       X

General   7.3       gb_pcol_major                                                                   X                                                       X

General   7.3       gb_pcol_minor                                                                   X                                                       X

General   7.2       gb_person_race                                                                                                                                                                                                                 X




General   7.0       gb_pii_tables                                                                                          X

General   8.0       gb_pin_answer



General   8.0       gb_pin_question

General   7.3       gb_prior_college                                                                X                                                       X




                                                                                                                  Page 41
                                                                                  Banner APIs by Product

                                                         Integrations                                                                                                                                                                  Enhancements




                                                                                                                                                                                                                     AR Term Control




                                                                                                                                                                                                                                                             Officer Search
                                                                                  eProcurement




                                                                                                                                                                                                                                                             Advancement
                                                          Campus Card




                                                                                                 Technologies




                                                                                                                                                                             Basic Person
                                                                                                                                     Concurrent
                                                                                                 Integration




                                                                                                                                                                                                        PESC/XML
                                                                                                                                                                                                        Transcript




                                                                                                                                                                                                                                                                              Approvals
                                                                                                                                                                                                                                                                              Electronic
                                                                                                                                                  SRTLOAD
                                             eLearning




                                                                                                                                                            Bio Demo




                                                                                                                                                                                            Applicant
                                                                                                                                     Curricula
                                                                                                                Matching

                                                                                                                           New VBS
                                                                                                                Common




                                                                                                                                                                                                                                                 Ethnicity
                                                                        Housing




                                                                                                                                                  AMCAS/
           Release




                                                                                                                                                                                                                                                 Race
                                                                                                                                                                       COD




                                                                                                                                                                                                                                         eBill




                                                                                                                                                                                                                                                                                           SDE
Product              API Name
General   7.2        gb_race_ethnicity                                                                                                                                                                                                              X

General   7.0        gb_roomassignment                     X             X

General   7.0        gb_roomdefinition                                   X

General   8.0        gb_sde_discrim_value                                                                                                                                                                                                                                                  X



General   8.0        gb_sde_discriminator                                                                                                                                                                                                                                                  X

General   8.0        gb_sde_metadata                                                                                                                                                                                                                                                       X



General   8.0        gb_sde_table                                                                                                                                                                                                                                                          X



General   7.0        gb_telephone             X            X             X                                                                                                     X

General   7.0        gb_third_party_access



General   7.0        gb_userdefault                                                                                         X



General   7.0        gb_userpiidomains                                                                                      X

General   7.0        gb_vbs_predicate                                                                                       X

General   7.0        gb_vbs_tables                                                                                          X

General   7.3        gb_visa                                                                         X                                                       X

General   7.1.1 gp_cardholder                               X            X




                                                                                                                   Page 42
                                                                                     Banner APIs by Product

                                                            Integrations                                                                                                                                                                  Enhancements




                                                                                                                                                                                                                        AR Term Control




                                                                                                                                                                                                                                                                Officer Search
                                                                                     eProcurement




                                                                                                                                                                                                                                                                Advancement
                                                             Campus Card




                                                                                                    Technologies




                                                                                                                                                                                Basic Person
                                                                                                                                        Concurrent
                                                                                                    Integration




                                                                                                                                                                                                           PESC/XML
                                                                                                                                                                                                           Transcript




                                                                                                                                                                                                                                                                                 Approvals
                                                                                                                                                                                                                                                                                 Electronic
                                                                                                                                                     SRTLOAD
                                                eLearning




                                                                                                                                                               Bio Demo




                                                                                                                                                                                               Applicant
                                                                                                                                        Curricula
                                                                                                                   Matching

                                                                                                                              New VBS
                                                                                                                   Common




                                                                                                                                                                                                                                                    Ethnicity
                                                                           Housing




                                                                                                                                                     AMCAS/
           Release




                                                                                                                                                                                                                                                    Race
                                                                                                                                                                          COD




                                                                                                                                                                                                                                            eBill




                                                                                                                                                                                                                                                                                              SDE
Product              API Name
General   7.0        gp_common_matching                                                                              X



General   7.1.1 gp_entity_address                              X            X

General   7.3        gp_international_student

General   7.1.1 gp_person_identity                             X            X

HR        7.2        nb_ea_comments                                                                                                                                                                                                                                                 X



HR        7.1        nb_ea_group_category                                                                                                                                                                                                                                           X




HR        7.1        nb_ea_group_user                                                                                                                                                                                                                                               X



HR        8.1        nb_effcert_addl_queue




HR        8.1        nb_effcert_category                                                                                                                                         X



HR        8.1        nb_effcert_dflt_queue                                                                                                                                       X



HR        8.1        nb_effcert_ftyp




                                                                                                                      Page 43
                                                                                 Banner APIs by Product

                                                        Integrations                                                                                                                                                                  Enhancements




                                                                                                                                                                                                                    AR Term Control




                                                                                                                                                                                                                                                            Officer Search
                                                                                 eProcurement




                                                                                                                                                                                                                                                            Advancement
                                                         Campus Card




                                                                                                Technologies




                                                                                                                                                                            Basic Person
                                                                                                                                    Concurrent
                                                                                                Integration




                                                                                                                                                                                                       PESC/XML
                                                                                                                                                                                                       Transcript




                                                                                                                                                                                                                                                                             Approvals
                                                                                                                                                                                                                                                                             Electronic
                                                                                                                                                 SRTLOAD
                                            eLearning




                                                                                                                                                           Bio Demo




                                                                                                                                                                                           Applicant
                                                                                                                                    Curricula
                                                                                                               Matching

                                                                                                                          New VBS
                                                                                                               Common




                                                                                                                                                                                                                                                Ethnicity
                                                                       Housing




                                                                                                                                                 AMCAS/
          Release




                                                                                                                                                                                                                                                Race
                                                                                                                                                                      COD




                                                                                                                                                                                                                                        eBill




                                                                                                                                                                                                                                                                                          SDE
Product             API Name
HR        7.3       nb_job_base                                                                                                                                                             X

HR        7.3       nb_job_detail                                                                                                                                                           X

HR        7.3       nb_job_earnings

HR        8.0       nb_job_enc_history                                                                                                                                                      X



HR        7.3       nb_job_labor

HR        8.1       nb_proxy

HR        8.1       nb_proxy_module

HR        8.1       nb_queue_group                                                                                                                                            X

HR        8.1       nb_queue_participant



HR        8.1       nb_redistr_addl_queue




HR        8.1       nb_redistr_dflt_queue



HR        8.1       nb_redistr_ftyp




HR        7.3       np_job_assignment




                                                                                                                  Page 44
                                                                              Banner APIs by Product

                                                     Integrations                                                                                                                                                                  Enhancements




                                                                                                                                                                                                                 AR Term Control




                                                                                                                                                                                                                                                         Officer Search
                                                                              eProcurement




                                                                                                                                                                                                                                                         Advancement
                                                      Campus Card




                                                                                             Technologies




                                                                                                                                                                         Basic Person
                                                                                                                                 Concurrent
                                                                                             Integration




                                                                                                                                                                                                    PESC/XML
                                                                                                                                                                                                    Transcript




                                                                                                                                                                                                                                                                          Approvals
                                                                                                                                                                                                                                                                          Electronic
                                                                                                                                              SRTLOAD
                                         eLearning




                                                                                                                                                        Bio Demo




                                                                                                                                                                                        Applicant
                                                                                                                                 Curricula
                                                                                                            Matching

                                                                                                                       New VBS
                                                                                                            Common




                                                                                                                                                                                                                                             Ethnicity
                                                                    Housing




                                                                                                                                              AMCAS/
          Release




                                                                                                                                                                                                                                             Race
                                                                                                                                                                   COD




                                                                                                                                                                                                                                     eBill




                                                                                                                                                                                                                                                                                       SDE
Product             API Name
HR        7.3       np_job_earnings                                                                                                                                                      X

HR        7.3       np_job_labor                                                                                                                                                         X                                                                                   X

HR        7.2       pb_assoc_term

HR        7.2       pb_certification                                                                                                                     X                               X

HR        8.0       pb_dedn_comb_lmt                                                                                                                     X                               X




HR        8.0       pb_dedn_lmt_grp                                                                                                                      X                               X



HR        7.2       pb_driver_license                                                                                                                    X                               X

HR        8.1       pb_effcert_earn



HR        8.1       pb_effcert_ecls




HR        8.1       pb_effcert_payroll



HR        8.1       pb_effcert_pcls



HR        8.1       pb_effcert_period




                                                                                                               Page 45
                                                                              Banner APIs by Product

                                                     Integrations                                                                                                                                                                  Enhancements




                                                                                                                                                                                                                 AR Term Control




                                                                                                                                                                                                                                                         Officer Search
                                                                              eProcurement




                                                                                                                                                                                                                                                         Advancement
                                                      Campus Card




                                                                                             Technologies




                                                                                                                                                                         Basic Person
                                                                                                                                 Concurrent
                                                                                             Integration




                                                                                                                                                                                                    PESC/XML
                                                                                                                                                                                                    Transcript




                                                                                                                                                                                                                                                                          Approvals
                                                                                                                                                                                                                                                                          Electronic
                                                                                                                                              SRTLOAD
                                         eLearning




                                                                                                                                                        Bio Demo




                                                                                                                                                                                        Applicant
                                                                                                                                 Curricula
                                                                                                            Matching

                                                                                                                       New VBS
                                                                                                            Common




                                                                                                                                                                                                                                             Ethnicity
                                                                    Housing




                                                                                                                                              AMCAS/
          Release




                                                                                                                                                                                                                                             Race
                                                                                                                                                                   COD




                                                                                                                                                                                                                                     eBill




                                                                                                                                                                                                                                                                                       SDE
Product             API Name
HR        8.1       pb_effcert_rpt_ctl



HR        7.0       pb_employee           X            X

HR        7.2       pb_endorsement                                                                                                                       X                               X

HR        7.2       pb_experience                                                                                                                        X                               X

HR        8.0       pb_fac_cntract



HR        8.0       pb_fac_comments



HR        8.0       pb_fac_crsassign




HR        8.0       pb_fac_crsecomp



HR        8.0       pb_fac_errors



HR        8.0       pb_fac_fcnt




HR        8.0       pb_fac_incrate




                                                                                                               Page 46
          HR
                            HR
                                             HR
                                                               HR
                                                                                HR
                                                                                                  HR
                                                                                                                    HR
                                                                                                                                       HR
                                                                                                                                                         HR
                                                                                                                                                         Product
                                                                                                                                                                  Release




          8.0
                            8.0
                                             8.0
                                                               8.0
                                                                                8.0
                                                                                                  8.0
                                                                                                                    8.0
                                                                                                                                       8.0
                                                                                                                                                         8.0
                                                                                                                                                         API Name




                                                               pb_fac_nilrate




                            pb_fac_nisrate
                                                                                                  pb_fac_jobdistr
                                                                                                                    pb_fac_jobdetail




                                                                                pb_fac_jobearns
                                                                                                                                       pb_fac_isolcomp




                                             pb_fac_niolcomp




          pb_fac_nistcomp
                                                                                                                                                         pb_fac_incrcomp




                                                                                                                                                                 eLearning


                                                                                                                                                                 Campus Card


                                                                                                                                                                 Housing
                                                                                                                                                                                   Integrations




                                                                                                                                                                 eProcurement

                                                                                                                                                                 Integration
                                                                                                                                                                 Technologies
                                                                                                                                                                 Common
                                                                                                                                                                 Matching

                                                                                                                                                                 New VBS




Page 47
                                                                                                                                                                 Concurrent
                                                                                                                                                                 Curricula
                                                                                                                                                                 AMCAS/
                                                                                                                                                                 SRTLOAD
                                                                                                                                                                                                  Banner APIs by Product




                                                                                                                                                                 Bio Demo


                                                                                                                                                                 COD


                                                                                                                                                                 Basic Person


                                                                                                                                                                 Applicant

                                                                                                                                                                 PESC/XML
                                                                                                                                                                 Transcript

                                                                                                                                                                 AR Term Control


                                                                                                                                                                 eBill

                                                                                                                                                                 Race
                                                                                                                                                                 Ethnicity
                                                                                                                                                                                   Enhancements




                                                                                                                                                                 Advancement
                                                                                                                                                                 Officer Search
                                                                                                                                                                 Electronic
                                                                                                                                                                 Approvals

                                                                                                                                                                 SDE
                                                                               Banner APIs by Product

                                                      Integrations                                                                                                                                                                  Enhancements




                                                                                                                                                                                                                  AR Term Control




                                                                                                                                                                                                                                                          Officer Search
                                                                               eProcurement




                                                                                                                                                                                                                                                          Advancement
                                                       Campus Card




                                                                                              Technologies




                                                                                                                                                                          Basic Person
                                                                                                                                  Concurrent
                                                                                              Integration




                                                                                                                                                                                                     PESC/XML
                                                                                                                                                                                                     Transcript




                                                                                                                                                                                                                                                                           Approvals
                                                                                                                                                                                                                                                                           Electronic
                                                                                                                                               SRTLOAD
                                          eLearning




                                                                                                                                                         Bio Demo




                                                                                                                                                                                         Applicant
                                                                                                                                  Curricula
                                                                                                             Matching

                                                                                                                        New VBS
                                                                                                             Common




                                                                                                                                                                                                                                              Ethnicity
                                                                     Housing




                                                                                                                                               AMCAS/
           Release




                                                                                                                                                                                                                                              Race
                                                                                                                                                                    COD




                                                                                                                                                                                                                                      eBill




                                                                                                                                                                                                                                                                                        SDE
Product              API Name
HR        8.0        pb_fac_schrate




HR        8.0        pb_fac_sclrate




HR        7.2        pb_honor_award                                                                                                                       X                               X

HR        8.1        pb_payhist_comment



HR        7.2        pb_publication                                                                                                                       X                               X

HR        8.10 pb_redistr_queue

HR        7.2        pb_skill                                                                                                                             X                               X

HR        7.2        pb_stu_deduction                                                                                                                                                     X




HR        7.2        pb_stu_emp_cred                                                                                                                                                      X



HR        7.1.5 pb_w2_coded_info

HR        7.1.5 pb_w2_federal

HR        7.1.5 pb_w2_local




                                                                                                                Page 48
                                                                               Banner APIs by Product

                                                      Integrations                                                                                                                                                                      Enhancements




                                                                                                                                                                                                                      AR Term Control




                                                                                                                                                                                                                                                              Officer Search
                                                                               eProcurement




                                                                                                                                                                                                                                                              Advancement
                                                       Campus Card




                                                                                              Technologies




                                                                                                                                                                              Basic Person
                                                                                                                                  Concurrent
                                                                                              Integration




                                                                                                                                                                                                         PESC/XML
                                                                                                                                                                                                         Transcript




                                                                                                                                                                                                                                                                               Approvals
                                                                                                                                                                                                                                                                               Electronic
                                                                                                                                               SRTLOAD
                                          eLearning




                                                                                                                                                         Bio Demo




                                                                                                                                                                                             Applicant
                                                                                                                                  Curricula
                                                                                                             Matching

                                                                                                                        New VBS
                                                                                                             Common




                                                                                                                                                                                                                                                  Ethnicity
                                                                     Housing




                                                                                                                                               AMCAS/
           Release




                                                                                                                                                                                                                                                  Race
                                                                                                                                                                    COD




                                                                                                                                                                                                                                          eBill




                                                                                                                                                                                                                                                                                            SDE
Product         API Name
HR        7.1.5 pb_w2_state

HR        8.0        pp_fac_jobdistr




HR        7.1.5 pp_w2




HR        8.1.1 pp_w2_2008
           and
          7.2.7

HR        7.2.2 pp_w2_common



HR        7.2.1 pt_roe_contact_rules




HR        7.2.1 px_mass_roe




HR        7.2.1 px_record_of_employment




Student   7.0        gb_address            X            X             X                                                                                                         X

Student   7.0        gb_bio                X            X             X                                                                                                   X

Student   7.0        gb_bldgdefinition                                X




                                                                                                                Page 49
                                                                                    Banner APIs by Product

                                                           Integrations                                                                                                                                                                  Enhancements




                                                                                                                                                                                                                       AR Term Control




                                                                                                                                                                                                                                                               Officer Search
                                                                                    eProcurement




                                                                                                                                                                                                                                                               Advancement
                                                            Campus Card




                                                                                                   Technologies




                                                                                                                                                                               Basic Person
                                                                                                                                       Concurrent
                                                                                                   Integration




                                                                                                                                                                                                          PESC/XML
                                                                                                                                                                                                          Transcript




                                                                                                                                                                                                                                                                                Approvals
                                                                                                                                                                                                                                                                                Electronic
                                                                                                                                                    SRTLOAD
                                               eLearning




                                                                                                                                                              Bio Demo




                                                                                                                                                                                              Applicant
                                                                                                                                       Curricula
                                                                                                                  Matching

                                                                                                                             New VBS
                                                                                                                  Common




                                                                                                                                                                                                                                                   Ethnicity
                                                                          Housing




                                                                                                                                                    AMCAS/
          Release




                                                                                                                                                                                                                                                   Race
                                                                                                                                                                         COD




                                                                                                                                                                                                                                           eBill




                                                                                                                                                                                                                                                                                             SDE
Product             API Name
Student   7.0       gb_classtimes               X

Student   7.0       gb_emergency_contact                                   X                                                                                                     X

Student   7.0       gb_hold

Student   7.0       gb_identification           X            X             X                                                                                                     X

Student   7.0       gb_roomassignment                        X             X

Student   7.0       gb_roomdefinition                                      X



Student   7.0       gb_telephone                X            X             X                                                                                                     X

Student   7.0       sb_admissionsapplication                               X                                                              X

Student   7.3       sb_application_decision                                                                                               X



Student   8.1       sb_athletic_acad_prog



Student   8.1       sb_athletic_admissions



Student   8.1       sb_athletic_attributes



Student   8.1       sb_athletic_comments



Student   8.1       sb_athletic_competition




                                                                                                                     Page 50
                                                                                     Banner APIs by Product

                                                            Integrations                                                                                                                                                                  Enhancements




                                                                                                                                                                                                                        AR Term Control




                                                                                                                                                                                                                                                                Officer Search
                                                                                     eProcurement




                                                                                                                                                                                                                                                                Advancement
                                                             Campus Card




                                                                                                    Technologies




                                                                                                                                                                                Basic Person
                                                                                                                                        Concurrent
                                                                                                    Integration




                                                                                                                                                                                                           PESC/XML
                                                                                                                                                                                                           Transcript




                                                                                                                                                                                                                                                                                 Approvals
                                                                                                                                                                                                                                                                                 Electronic
                                                                                                                                                     SRTLOAD
                                                eLearning




                                                                                                                                                               Bio Demo




                                                                                                                                                                                               Applicant
                                                                                                                                        Curricula
                                                                                                                   Matching

                                                                                                                              New VBS
                                                                                                                   Common




                                                                                                                                                                                                                                                    Ethnicity
                                                                           Housing




                                                                                                                                                     AMCAS/
           Release




                                                                                                                                                                                                                                                    Race
                                                                                                                                                                          COD




                                                                                                                                                                                                                                            eBill




                                                                                                                                                                                                                                                                                              SDE
Product              API Name
Student   8.1        sb_athletic_compliance



Student   8.1        sb_athletic_degc_comp



Student   8.1        sb_athletic_eligibility



Student   8.1        sb_athletic_transfer



Student   7.2        sb_catlg_int_partner        X



Student   7.0        sb_course                   X

Student   8.0        sb_course_labor

Student   8.0        sb_crse_atts_restriction




Student   8.0        sb_crse_chrt_restriction

Student   8.0        sb_crse_dept_restriction



Student   8.0        sb_crse_select_pri




Student   7.3.1 sb_curric_status_event                                                                                                     X




                                                                                                                      Page 51
                                                                                   Banner APIs by Product

                                                          Integrations                                                                                                                                                                      Enhancements




                                                                                                                                                                                                                          AR Term Control




                                                                                                                                                                                                                                                                  Officer Search
                                                                                   eProcurement




                                                                                                                                                                                                                                                                  Advancement
                                                           Campus Card




                                                                                                  Technologies




                                                                                                                                                                              Basic Person
                                                                                                                                      Concurrent
                                                                                                  Integration




                                                                                                                                                                                                             PESC/XML
                                                                                                                                                                                                             Transcript




                                                                                                                                                                                                                                                                                   Approvals
                                                                                                                                                                                                                                                                                   Electronic
                                                                                                                                                   SRTLOAD
                                              eLearning




                                                                                                                                                             Bio Demo




                                                                                                                                                                                                 Applicant
                                                                                                                                      Curricula
                                                                                                                 Matching

                                                                                                                            New VBS
                                                                                                                 Common




                                                                                                                                                                                                                                                      Ethnicity
                                                                         Housing




                                                                                                                                                   AMCAS/
           Release




                                                                                                                                                                                                                                                      Race
                                                                                                                                                                        COD




                                                                                                                                                                                                                                              eBill




                                                                                                                                                                                                                                                                                                SDE
Product              API Name
Student   7.0        sb_curriculum             X            X             X                                                              X

Student   7.3.1 sb_curriculum_default                                                                                                    X

Student   7.3.1 sb_curriculum_history                                                                                                    X

Student   7.1        sb_datafile_delimiter                                                                                                                                                   X

Student   7.1        sb_datafile_test_score                                                                                                                                                  X

Student   7.3        sb_edi_acad_sess_sum                                                                                                                                                                       X



Student   7.3        sb_edi_acad_session                                                                                                                                                                        X

Student   7.3        sb_edi_acad_summ                                                                                                                                                                           X

Student   7.3        sb_edi_acrec_ude                                                                                                                                                                           X

Student   7.3        sb_edi_course                                                                                                                                                                              X

Student   7.3        sb_edi_doc_header                                                                                                                                                                          X



Student   7.3        sb_edi_header                                                                                                                                                                              X



Student   7.3        sb_edi_identification                                                                                                                                                                      X

Student   7.3.2 sb_edi_immunization                                                                                                                                                                             X

Student   7.3        sb_edi_medical                                                                                                                                                                             X

Student   7.3        sb_edi_status                                                                                                                                                                              X




                                                                                                                    Page 52
                                                                                    Banner APIs by Product

                                                           Integrations                                                                                                                                                                  Enhancements




                                                                                                                                                                                                                       AR Term Control




                                                                                                                                                                                                                                                               Officer Search
                                                                                    eProcurement




                                                                                                                                                                                                                                                               Advancement
                                                            Campus Card




                                                                                                   Technologies




                                                                                                                                                                               Basic Person
                                                                                                                                       Concurrent
                                                                                                   Integration




                                                                                                                                                                                                          PESC/XML
                                                                                                                                                                                                          Transcript




                                                                                                                                                                                                                                                                                Approvals
                                                                                                                                                                                                                                                                                Electronic
                                                                                                                                                    SRTLOAD
                                               eLearning




                                                                                                                                                              Bio Demo




                                                                                                                                                                                              Applicant
                                                                                                                                       Curricula
                                                                                                                  Matching

                                                                                                                             New VBS
                                                                                                                  Common




                                                                                                                                                                                                                                                   Ethnicity
                                                                          Housing




                                                                                                                                                    AMCAS/
           Release




                                                                                                                                                                                                                                                   Race
                                                                                                                                                                         COD




                                                                                                                                                                                                                                           eBill




                                                                                                                                                                                                                                                                                             SDE
Product              API Name
Student   7.3        sb_edi_stud_ude                                                                                                                                                                         X

Student   7.3        sb_edi_subtest                                                                                                                                                                          X

Student   7.3        sb_edi_subtest_score                                                                                                                                                                    X

Student   7.3        sb_edi_test                                                                                                                                                                             X

Student   7.3        sb_edi_trans_ude                                                                                                                                                                        X

Student   7.2        sb_enroll_ver_payment                                                                                                X




Student   7.2        sb_enroll_ver_service                                                                                                X




Student   7.0        sb_facassignment           X

Student   7.0        sb_faculty                 X

Student   7.0        sb_fieldofstudy                                                                                                      X

Student   7.2        sb_fieldofstudy_allowed                                                                                              X

Student   7.3.1 sb_fieldofstudy_archive                                                                                                   X

Student   8.0        sb_gradapp




                                                                                                                     Page 53
                                                                                   Banner APIs by Product

                                                          Integrations                                                                                                                                                                  Enhancements




                                                                                                                                                                                                                      AR Term Control




                                                                                                                                                                                                                                                              Officer Search
                                                                                   eProcurement




                                                                                                                                                                                                                                                              Advancement
                                                           Campus Card




                                                                                                  Technologies




                                                                                                                                                                              Basic Person
                                                                                                                                      Concurrent
                                                                                                  Integration




                                                                                                                                                                                                         PESC/XML
                                                                                                                                                                                                         Transcript




                                                                                                                                                                                                                                                                               Approvals
                                                                                                                                                                                                                                                                               Electronic
                                                                                                                                                   SRTLOAD
                                              eLearning




                                                                                                                                                             Bio Demo




                                                                                                                                                                                             Applicant
                                                                                                                                      Curricula
                                                                                                                 Matching

                                                                                                                            New VBS
                                                                                                                 Common




                                                                                                                                                                                                                                                  Ethnicity
                                                                         Housing




                                                                                                                                                   AMCAS/
           Release




                                                                                                                                                                                                                                                  Race
                                                                                                                                                                        COD




                                                                                                                                                                                                                                          eBill




                                                                                                                                                                                                                                                                                            SDE
Product              API Name
Student   8.0        sb_gradapp_displayrule



Student   8.0        sb_gradapp_eligible




Student   8.0        sb_gradapp_graddate



Student   8.0        sb_gradapp_paymentopts




Student   8.0        sb_gradapp_selrule




Student   7.3.1 sb_highschool

Student   8.0        sb_incmp_grading

Student   7.0        sb_learner                X            X             X                                                              X

Student   7.0        sb_learnercurricstatus                                                                                              X



Student   7.0        sb_learnermodule                                                                                                    X

Student   7.0        sb_learneroutcome                                                                                                   X

Student   8.0        sb_mass_entry

Student   8.0        sb_mass_entry_column




                                                                                                                    Page 54
                                                                                    Banner APIs by Product

                                                           Integrations                                                                                                                                                                  Enhancements




                                                                                                                                                                                                                       AR Term Control




                                                                                                                                                                                                                                                               Officer Search
                                                                                    eProcurement




                                                                                                                                                                                                                                                               Advancement
                                                            Campus Card




                                                                                                   Technologies




                                                                                                                                                                               Basic Person
                                                                                                                                       Concurrent
                                                                                                   Integration




                                                                                                                                                                                                          PESC/XML
                                                                                                                                                                                                          Transcript




                                                                                                                                                                                                                                                                                Approvals
                                                                                                                                                                                                                                                                                Electronic
                                                                                                                                                    SRTLOAD
                                               eLearning




                                                                                                                                                              Bio Demo




                                                                                                                                                                                              Applicant
                                                                                                                                       Curricula
                                                                                                                  Matching

                                                                                                                             New VBS
                                                                                                                  Common




                                                                                                                                                                                                                                                   Ethnicity
                                                                          Housing




                                                                                                                                                    AMCAS/
          Release




                                                                                                                                                                                                                                                   Race
                                                                                                                                                                         COD




                                                                                                                                                                                                                                           eBill




                                                                                                                                                                                                                                                                                             SDE
Product             API Name
Student   8.0       sb_mass_entry_form

Student   7.0       sb_mealassignment                        X             X

Student   7.3       sb_pesc_status_export                                                                                                                                                                    X

Student   7.3       sb_pesc_status_imp                                                                                                                                                                       X

Student   7.3       sb_pescxml_trandata_exp



Student   7.3       sb_pescxml_trandata_imp



Student   7.0       sb_phoneassignment                                     X

Student   7.0       sb_recruit                                                                                                            X

Student   8.0       sb_registration_msg



Student   7.0       sb_roommate                                            X

Student   7.0       sb_roompreference                                     Y

Student   8.0       sb_sect_atts_restriction




Student   8.0       sb_sect_chrt_restriction

Student   8.0       sb_sect_dept_restriction




                                                                                                                     Page 55
                                                                                      Banner APIs by Product

                                                             Integrations                                                                                                                                                                  Enhancements




                                                                                                                                                                                                                         AR Term Control




                                                                                                                                                                                                                                                                 Officer Search
                                                                                      eProcurement




                                                                                                                                                                                                                                                                 Advancement
                                                              Campus Card




                                                                                                     Technologies




                                                                                                                                                                                 Basic Person
                                                                                                                                         Concurrent
                                                                                                     Integration




                                                                                                                                                                                                            PESC/XML
                                                                                                                                                                                                            Transcript




                                                                                                                                                                                                                                                                                  Approvals
                                                                                                                                                                                                                                                                                  Electronic
                                                                                                                                                      SRTLOAD
                                                 eLearning




                                                                                                                                                                Bio Demo




                                                                                                                                                                                                Applicant
                                                                                                                                         Curricula
                                                                                                                    Matching

                                                                                                                               New VBS
                                                                                                                    Common




                                                                                                                                                                                                                                                     Ethnicity
                                                                            Housing




                                                                                                                                                      AMCAS/
           Release




                                                                                                                                                                                                                                                     Race
                                                                                                                                                                           COD




                                                                                                                                                                                                                                             eBill




                                                                                                                                                                                                                                                                                               SDE
Product              API Name
Student   7.0        sb_section                   X

Student   8.0        sb_section_labor



Student   7.0        sb_smrprle

Student   7.0        sb_sobctrl

Student   7.0        sb_term                      X                                                                                                     X

Student   7.2        sb_test_percentile                                                                                                                 X

Student   7.3.1 sb_testscore

Student   7.2        sb_transcript_name                                                                                                     X

Student   7.2        sb_transcript_name_source                                                                                              X

Student   7.2        sb_transcript_req_name                                                                                                 X

Student   8.0        sb_transfer_crse



Student   8.0        sb_transfer_crse_attr



Student   8.0        sb_transfer_crse_cmt



Student   8.0        sb_transfer_equiv

Student   8.0        sb_transfer_equiv_attr




                                                                                                                       Page 56
                                                                                  Banner APIs by Product

                                                         Integrations                                                                                                                                                                  Enhancements




                                                                                                                                                                                                                     AR Term Control




                                                                                                                                                                                                                                                             Officer Search
                                                                                  eProcurement




                                                                                                                                                                                                                                                             Advancement
                                                          Campus Card




                                                                                                 Technologies




                                                                                                                                                                             Basic Person
                                                                                                                                     Concurrent
                                                                                                 Integration




                                                                                                                                                                                                        PESC/XML
                                                                                                                                                                                                        Transcript




                                                                                                                                                                                                                                                                              Approvals
                                                                                                                                                                                                                                                                              Electronic
                                                                                                                                                  SRTLOAD
                                             eLearning




                                                                                                                                                            Bio Demo




                                                                                                                                                                                            Applicant
                                                                                                                                     Curricula
                                                                                                                Matching

                                                                                                                           New VBS
                                                                                                                Common




                                                                                                                                                                                                                                                 Ethnicity
                                                                        Housing




                                                                                                                                                  AMCAS/
           Release




                                                                                                                                                                                                                                                 Race
                                                                                                                                                                       COD




                                                                                                                                                                                                                                         eBill




                                                                                                                                                                                                                                                                                           SDE
Product              API Name
Student   8.0        sb_transfer_equiv_cmt



Student   8.0        sb_wl_collector




Student   8.0        sb_wl_exclusion




Student   8.0        sb_wl_notification



Student   8.0        sb_wl_reordering



Student   8.0        sb_wl_section_ctrl



Student   8.0        sb_wl_term_control

Student   7.1.1 sp_academic_period                          X            X



Student   8.0        sp_catalog_export




                                                                                                                   Page 57
          Student
                                     Student
                                     Product
                                                      Release




                                           API Name




          7.1.1 sp_housing_profile
                                     7.1.1 sp_housing_eligibility




                                                     eLearning
          X
                                     X




                                                     Campus Card
          X
                                     X




                                                     Housing
                                                                       Integrations




                                                     eProcurement

                                                     Integration
                                                     Technologies
                                                     Common
                                                     Matching

                                                     New VBS




Page 58
                                                     Concurrent
                                                     Curricula
                                                     AMCAS/
                                                     SRTLOAD
                                                                                      Banner APIs by Product




                                                     Bio Demo


                                                     COD


                                                     Basic Person


                                                     Applicant

                                                     PESC/XML
                                                     Transcript

                                                     AR Term Control


                                                     eBill

                                                     Race
                                                     Ethnicity
                                                                       Enhancements




                                                     Advancement
                                                     Officer Search
                                                     Electronic
                                                     Approvals

                                                     SDE
          Product
          Release




          API Name




          eLearning


          Campus Card


          Housing
                            Integrations




          eProcurement

          Integration
          Technologies
          Common
          Matching

          New VBS




Page 59
          Concurrent
          Curricula
          AMCAS/
          SRTLOAD
                                           Banner APIs by Product




          Bio Demo


          COD


          Basic Person


          Applicant

          PESC/XML
          Transcript

          AR Term Control


          eBill

          Race
          Ethnicity
                            Enhancements




          Advancement
          Officer Search
          Electronic
          Approvals

          SDE
          Product
          Release




          API Name




          eLearning


          Campus Card


          Housing
                            Integrations




          eProcurement

          Integration
          Technologies
          Common
          Matching

          New VBS




Page 60
          Concurrent
          Curricula
          AMCAS/
          SRTLOAD
                                           Banner APIs by Product




          Bio Demo


          COD


          Basic Person


          Applicant

          PESC/XML
          Transcript

          AR Term Control


          eBill

          Race
          Ethnicity
                            Enhancements




          Advancement
          Officer Search
          Electronic
          Approvals

          SDE
          Product
          Release




          API Name




          eLearning


          Campus Card


          Housing
                            Integrations




          eProcurement

          Integration
          Technologies
          Common
          Matching

          New VBS




Page 61
          Concurrent
          Curricula
          AMCAS/
          SRTLOAD
                                           Banner APIs by Product




          Bio Demo


          COD


          Basic Person


          Applicant

          PESC/XML
          Transcript

          AR Term Control


          eBill

          Race
          Ethnicity
                            Enhancements




          Advancement
          Officer Search
          Electronic
          Approvals

          SDE
          Product
          Release




          API Name




          eLearning


          Campus Card


          Housing
                            Integrations




          eProcurement

          Integration
          Technologies
          Common
          Matching

          New VBS




Page 62
          Concurrent
          Curricula
          AMCAS/
          SRTLOAD
                                           Banner APIs by Product




          Bio Demo


          COD


          Basic Person


          Applicant

          PESC/XML
          Transcript

          AR Term Control


          eBill

          Race
          Ethnicity
                            Enhancements




          Advancement
          Officer Search
          Electronic
          Approvals

          SDE
          Product
          Release




          API Name




          eLearning


          Campus Card


          Housing
                            Integrations




          eProcurement

          Integration
          Technologies
          Common
          Matching

          New VBS




Page 63
          Concurrent
          Curricula
          AMCAS/
          SRTLOAD
                                           Banner APIs by Product




          Bio Demo


          COD


          Basic Person


          Applicant

          PESC/XML
          Transcript

          AR Term Control


          eBill

          Race
          Ethnicity
                            Enhancements




          Advancement
          Officer Search
          Electronic
          Approvals

          SDE
                                                                                             Banner APIs by Product

              Enhancements




                                                                                                             Course, Sec, Reg
                                                                                             SS Graduation
                                                  Faculty Load



                                                                 Extract/Load




                                                                                                             Restrictions


                                                                                                                                Compliance
                                                                                                                                             Algorithmic
                                                                                Automation


                                                                                             Application




                                                                                                                                             Packaging
              Release




                                                                                                                                Athletic
                                                                 Catalog


                                                                                Waitlist
Product                 API Name
Advancement   7.0       ab_adv_individual

Advancement   7.0       ab_adv_organization



Advancement   7.4       ab_custom_search_detail

Advancement   7.4       ab_custom_search_header



Advancement   7.0       ab_donor_category

Advancement   8.1       ab_gift_auxl_hold



Advancement   8.1       ab_project_history

Advancement   8.1       ab_project_results



Advancement   8.1       ab_proposal_history

AR            7.0       tb_cashier_session

AR            7.0       tb_customer_profile

AR            7.0       tb_depo_control

AR            7.0       tb_deposit

AR            7.0       tb_detail_code

AR            7.2       tb_memo




                                                                                                                                     Page 64
                                                                                        Banner APIs by Product

          Enhancements




                                                                                                        Course, Sec, Reg
                                                                                        SS Graduation
                                             Faculty Load



                                                            Extract/Load




                                                                                                        Restrictions


                                                                                                                           Compliance
                                                                                                                                        Algorithmic
                                                                           Automation


                                                                                        Application




                                                                                                                                        Packaging
           Release




                                                                                                                           Athletic
                                                            Catalog


                                                                           Waitlist
Product              API Name
AR        7.0        tb_misc_detail

AR        7.0        tb_misc_header



AR        7.0        tb_receivable

AR        7.3        tb_statement




AR        7.1        tb_term_control_ar

AR        7.1.1 tp_student_deposit

AR        7.1.1 tp_student_receivable

Finance   7.0        fb_accounting_element




Finance   7.0        fb_chart_of_accounts

Finance   7.0        fb_commodity

Finance   8.0        fb_encumbrance_detail



Finance   8.0        fb_encumbrance_header




                                                                                                                                Page 65
                                                                                   Banner APIs by Product

          Enhancements




                                                                                                   Course, Sec, Reg
                                                                                   SS Graduation
                                        Faculty Load



                                                       Extract/Load




                                                                                                   Restrictions


                                                                                                                      Compliance
                                                                                                                                   Algorithmic
                                                                      Automation


                                                                                   Application




                                                                                                                                   Packaging
          Release




                                                                                                                      Athletic
                                                       Catalog


                                                                      Waitlist
Product             API Name
Finance   8.1       fb_grant_effcert



Finance   7.2       fb_invoice_acctg

Finance   7.2       fb_invoice_header

Finance   7.2       fb_invoice_item

Finance   7.2       fb_invoice_tax

Finance   7.3       fb_jv_detail

Finance   7.3       fb_jv_header

Finance   7.1       fb_po_tax

Finance   7.0       fb_purchase_order



Finance   7.1       fb_req_tax

Finance   7.0       fb_requisition



Finance   7.0       fb_ship



Finance   7.0       fb_vendor

Finance   7.0       fb_vendor_type

Finance   8.0       fp_encumbrance




                                                                                                                           Page 66
                                                                                              Banner APIs by Product

                Enhancements




                                                                                                              Course, Sec, Reg
                                                                                              SS Graduation
                                                   Faculty Load



                                                                  Extract/Load




                                                                                                              Restrictions


                                                                                                                                 Compliance
                                                                                                                                              Algorithmic
                                                                                 Automation


                                                                                              Application




                                                                                                                                              Packaging
                 Release




                                                                                                                                 Athletic
                                                                  Catalog


                                                                                 Waitlist
Product                    API Name
Finance         7.3        fp_invoice




Finance         7.3        fp_journal_voucher




Financial Aid   7.9        rb_applicant_comment

Financial Aid   8.1        rb_application_status

Financial Aid   7.8        rb_award

Financial Aid   7.0        rb_award_disbursement

Financial Aid   7.8        rb_award_schedule

Financial Aid   7.0        rb_cod_document

Financial Aid   7.0        rb_cod_identifier

Financial Aid   7.0        rb_dl_refund

Financial Aid   7.9        rb_ny_user_def_data



Financial Aid   7.0        rb_pell_originations

Financial Aid   7.3.1 rb_requirement

Financial Aid   8.1        rb_sim_appl_status




                                                                                                                                      Page 67
                                                                                           Banner APIs by Product

                Enhancements




                                                                                                           Course, Sec, Reg
                                                                                           SS Graduation
                                                Faculty Load



                                                               Extract/Load




                                                                                                           Restrictions


                                                                                                                              Compliance
                                                                                                                                           Algorithmic
                                                                              Automation


                                                                                           Application




                                                                                                                                           Packaging
                Release




                                                                                                                              Athletic
                                                               Catalog


                                                                              Waitlist
Product                   API Name
Financial Aid   8.1       rb_temp_appl_status



Financial Aid   7.8       rb_temp_award

Financial Aid   7.9       rb_user_def_data

Financial Aid   8.1       rp_applicant_status




Financial Aid   7.8       rp_award




                                                                                                                                   Page 68
                                                                                              Banner APIs by Product

                Enhancements




                                                                                                              Course, Sec, Reg
                                                                                              SS Graduation
                                                   Faculty Load



                                                                  Extract/Load




                                                                                                              Restrictions


                                                                                                                                 Compliance
                                                                                                                                              Algorithmic
                                                                                 Automation


                                                                                              Application




                                                                                                                                              Packaging
                 Release




                                                                                                                                 Athletic
                                                                  Catalog


                                                                                 Waitlist
Product                    API Name
Financial Aid   7.8        rp_award_schedule




Financial Aid   7.3.1 rp_requirement




General         8.0        gb_additional_ident

General         7.0        gb_address

General         7.0        gb_bio

General         7.0        gb_bldgdefinition

General         7.0        gb_bus_prof_rule



General         7.0        gb_businessprofile



General         7.0        gb_busprofpii



General         7.0        gb_classtimes

General         7.0        gb_cm_data_dictionary




                                                                                                                                      Page 69
                                                                                       Banner APIs by Product

          Enhancements




                                                                                                       Course, Sec, Reg
                                                                                       SS Graduation
                                            Faculty Load



                                                           Extract/Load




                                                                                                       Restrictions


                                                                                                                          Compliance
                                                                                                                                       Algorithmic
                                                                          Automation


                                                                                       Application




                                                                                                                                       Packaging
          Release




                                                                                                                          Athletic
                                                           Catalog


                                                                          Waitlist
Product             API Name
General   7.3       gb_cm_disp_hier




General   7.0       gb_cm_display_options




General   7.0       gb_cm_rules



General   7.0       gb_cm_source_priority



General   7.0       gb_cm_source_rules




General   7.0       gb_cm_user_procedure



General   7.0       gb_cm_user_setup



General   7.0       gb_currency




                                                                                                                               Page 70
                                                                                         Banner APIs by Product

          Enhancements




                                                                                                         Course, Sec, Reg
                                                                                         SS Graduation
                                              Faculty Load



                                                             Extract/Load




                                                                                                         Restrictions


                                                                                                                            Compliance
                                                                                                                                         Algorithmic
                                                                            Automation


                                                                                         Application




                                                                                                                                         Packaging
           Release




                                                                                                                            Athletic
                                                             Catalog


                                                                            Waitlist
Product              API Name
General   7.0        gb_currency_rate




General   7.0        gb_displaycolumns

General   7.0        gb_displaymask



General   7.0        gb_domains

General   7.0        gb_domaintype

General   7.0        gb_email

General   7.0        gb_emergency_contact

General   7.0        gb_fgac_user_rule

General   7.0        gb_fgacexcludedobjects



General   7.0        gb_group_rules

General   7.0        gb_hold

General   7.0        gb_identification

General   7.4        gb_immunization

General   7.3.1 gb_institution_role




                                                                                                                                 Page 71
                                                                                       Banner APIs by Product

          Enhancements




                                                                                                       Course, Sec, Reg
                                                                                       SS Graduation
                                            Faculty Load



                                                           Extract/Load




                                                                                                       Restrictions


                                                                                                                          Compliance
                                                                                                                                       Algorithmic
                                                                          Automation


                                                                                       Application




                                                                                                                                       Packaging
          Release




                                                                                                                          Athletic
                                                           Catalog


                                                                          Waitlist
Product             API Name
General   7.4       gb_integ_config



General   7.3       gb_large_object

General   7.3       gb_medical

General   7.0       gb_name_translate

General   7.0       gb_np_name_trans



General   7.2       gb_partner_rule

General   7.3       gb_pcol_concentration

General   7.3       gb_pcol_degree

General   7.3       gb_pcol_major

General   7.3       gb_pcol_minor

General   7.2       gb_person_race




General   7.0       gb_pii_tables

General   8.0       gb_pin_answer



General   8.0       gb_pin_question

General   7.3       gb_prior_college




                                                                                                                               Page 72
                                                                                        Banner APIs by Product

          Enhancements




                                                                                                        Course, Sec, Reg
                                                                                        SS Graduation
                                             Faculty Load



                                                            Extract/Load




                                                                                                        Restrictions


                                                                                                                           Compliance
                                                                                                                                        Algorithmic
                                                                           Automation


                                                                                        Application




                                                                                                                                        Packaging
           Release




                                                                                                                           Athletic
                                                            Catalog


                                                                           Waitlist
Product              API Name
General   7.2        gb_race_ethnicity

General   7.0        gb_roomassignment

General   7.0        gb_roomdefinition

General   8.0        gb_sde_discrim_value



General   8.0        gb_sde_discriminator

General   8.0        gb_sde_metadata



General   8.0        gb_sde_table



General   7.0        gb_telephone

General   7.0        gb_third_party_access



General   7.0        gb_userdefault



General   7.0        gb_userpiidomains

General   7.0        gb_vbs_predicate

General   7.0        gb_vbs_tables

General   7.3        gb_visa

General   7.1.1 gp_cardholder




                                                                                                                                Page 73
                                                                                           Banner APIs by Product

          Enhancements




                                                                                                           Course, Sec, Reg
                                                                                           SS Graduation
                                                Faculty Load



                                                               Extract/Load




                                                                                                           Restrictions


                                                                                                                              Compliance
                                                                                                                                           Algorithmic
                                                                              Automation


                                                                                           Application




                                                                                                                                           Packaging
           Release




                                                                                                                              Athletic
                                                               Catalog


                                                                              Waitlist
Product              API Name
General   7.0        gp_common_matching



General   7.1.1 gp_entity_address

General   7.3        gp_international_student

General   7.1.1 gp_person_identity

HR        7.2        nb_ea_comments



HR        7.1        nb_ea_group_category




HR        7.1        nb_ea_group_user



HR        8.1        nb_effcert_addl_queue




HR        8.1        nb_effcert_category



HR        8.1        nb_effcert_dflt_queue



HR        8.1        nb_effcert_ftyp




                                                                                                                                   Page 74
                                                                                       Banner APIs by Product

          Enhancements




                                                                                                       Course, Sec, Reg
                                                                                       SS Graduation
                                            Faculty Load



                                                           Extract/Load




                                                                                                       Restrictions


                                                                                                                          Compliance
                                                                                                                                       Algorithmic
                                                                          Automation


                                                                                       Application




                                                                                                                                       Packaging
          Release




                                                                                                                          Athletic
                                                           Catalog


                                                                          Waitlist
Product             API Name
HR        7.3       nb_job_base

HR        7.3       nb_job_detail

HR        7.3       nb_job_earnings

HR        8.0       nb_job_enc_history



HR        7.3       nb_job_labor

HR        8.1       nb_proxy

HR        8.1       nb_proxy_module

HR        8.1       nb_queue_group

HR        8.1       nb_queue_participant



HR        8.1       nb_redistr_addl_queue




HR        8.1       nb_redistr_dflt_queue                                                                                    X



HR        8.1       nb_redistr_ftyp                                                                                          X




HR        7.3       np_job_assignment




                                                                                                                               Page 75
                                                                                    Banner APIs by Product

          Enhancements




                                                                                                    Course, Sec, Reg
                                                                                    SS Graduation
                                         Faculty Load



                                                        Extract/Load




                                                                                                    Restrictions


                                                                                                                       Compliance
                                                                                                                                    Algorithmic
                                                                       Automation


                                                                                    Application




                                                                                                                                    Packaging
          Release




                                                                                                                       Athletic
                                                        Catalog


                                                                       Waitlist
Product             API Name
HR        7.3       np_job_earnings

HR        7.3       np_job_labor

HR        7.2       pb_assoc_term

HR        7.2       pb_certification

HR        8.0       pb_dedn_comb_lmt




HR        8.0       pb_dedn_lmt_grp



HR        7.2       pb_driver_license

HR        8.1       pb_effcert_earn                                                                                       X



HR        8.1       pb_effcert_ecls                                                                                       X




HR        8.1       pb_effcert_payroll                                                                                    X



HR        8.1       pb_effcert_pcls                                                                                       X



HR        8.1       pb_effcert_period                                                                                     X




                                                                                                                            Page 76
                                                                                    Banner APIs by Product

          Enhancements




                                                                                                    Course, Sec, Reg
                                                                                    SS Graduation
                                         Faculty Load



                                                        Extract/Load




                                                                                                    Restrictions


                                                                                                                       Compliance
                                                                                                                                    Algorithmic
                                                                       Automation


                                                                                    Application




                                                                                                                                    Packaging
          Release




                                                                                                                       Athletic
                                                        Catalog


                                                                       Waitlist
Product             API Name
HR        8.1       pb_effcert_rpt_ctl                                                                                    X



HR        7.0       pb_employee

HR        7.2       pb_endorsement

HR        7.2       pb_experience

HR        8.0       pb_fac_cntract         X



HR        8.0       pb_fac_comments        X



HR        8.0       pb_fac_crsassign       X




HR        8.0       pb_fac_crsecomp        X



HR        8.0       pb_fac_errors          X



HR        8.0       pb_fac_fcnt            X




HR        8.0       pb_fac_incrate         X




                                                                                                                            Page 77
                                                                                  Banner APIs by Product

          Enhancements




                                                                                                  Course, Sec, Reg
                                                                                  SS Graduation
                                       Faculty Load



                                                      Extract/Load




                                                                                                  Restrictions


                                                                                                                     Compliance
                                                                                                                                  Algorithmic
                                                                     Automation


                                                                                  Application




                                                                                                                                  Packaging
          Release




                                                                                                                     Athletic
                                                      Catalog


                                                                     Waitlist
Product             API Name
HR        8.0       pb_fac_incrcomp      X



HR        8.0       pb_fac_isolcomp      X




HR        8.0       pb_fac_jobdetail     X



HR        8.0       pb_fac_jobdistr      X



HR        8.0       pb_fac_jobearns      X



HR        8.0       pb_fac_nilrate       X




HR        8.0       pb_fac_niolcomp      X




HR        8.0       pb_fac_nisrate       X




HR        8.0       pb_fac_nistcomp      X




                                                                                                                          Page 78
                                                                                     Banner APIs by Product

          Enhancements




                                                                                                     Course, Sec, Reg
                                                                                     SS Graduation
                                          Faculty Load



                                                         Extract/Load




                                                                                                     Restrictions


                                                                                                                        Compliance
                                                                                                                                     Algorithmic
                                                                        Automation


                                                                                     Application




                                                                                                                                     Packaging
           Release




                                                                                                                        Athletic
                                                         Catalog


                                                                        Waitlist
Product              API Name
HR        8.0        pb_fac_schrate         X




HR        8.0        pb_fac_sclrate         X




HR        7.2        pb_honor_award

HR        8.1        pb_payhist_comment                                                                                    X



HR        7.2        pb_publication

HR        8.10 pb_redistr_queue

HR        7.2        pb_skill

HR        7.2        pb_stu_deduction




HR        7.2        pb_stu_emp_cred



HR        7.1.5 pb_w2_coded_info

HR        7.1.5 pb_w2_federal

HR        7.1.5 pb_w2_local




                                                                                                                             Page 79
                                                                                     Banner APIs by Product

          Enhancements




                                                                                                     Course, Sec, Reg
                                                                                     SS Graduation
                                          Faculty Load



                                                         Extract/Load




                                                                                                     Restrictions


                                                                                                                        Compliance
                                                                                                                                     Algorithmic
                                                                        Automation


                                                                                     Application




                                                                                                                                     Packaging
           Release




                                                                                                                        Athletic
                                                         Catalog


                                                                        Waitlist
Product         API Name
HR        7.1.5 pb_w2_state

HR        8.0        pp_fac_jobdistr        X




HR        7.1.5 pp_w2




HR        8.1.1 pp_w2_2008
           and
          7.2.7

HR        7.2.2 pp_w2_common



HR        7.2.1 pt_roe_contact_rules




HR        7.2.1 px_mass_roe




HR        7.2.1 px_record_of_employment




Student   7.0        gb_address

Student   7.0        gb_bio

Student   7.0        gb_bldgdefinition




                                                                                                                             Page 80
                                                                                          Banner APIs by Product

          Enhancements




                                                                                                          Course, Sec, Reg
                                                                                          SS Graduation
                                               Faculty Load



                                                              Extract/Load




                                                                                                          Restrictions


                                                                                                                             Compliance
                                                                                                                                          Algorithmic
                                                                             Automation


                                                                                          Application




                                                                                                                                          Packaging
          Release




                                                                                                                             Athletic
                                                              Catalog


                                                                             Waitlist
Product             API Name
Student   7.0       gb_classtimes

Student   7.0       gb_emergency_contact

Student   7.0       gb_hold

Student   7.0       gb_identification

Student   7.0       gb_roomassignment

Student   7.0       gb_roomdefinition



Student   7.0       gb_telephone

Student   7.0       sb_admissionsapplication

Student   7.3       sb_application_decision



Student   8.1       sb_athletic_acad_prog                                                                                       X



Student   8.1       sb_athletic_admissions                                                                                      X



Student   8.1       sb_athletic_attributes                                                                                      X



Student   8.1       sb_athletic_comments                                                                                        X



Student   8.1       sb_athletic_competition                                                                                     X




                                                                                                                                  Page 81
                                                                                           Banner APIs by Product

          Enhancements




                                                                                                           Course, Sec, Reg
                                                                                           SS Graduation
                                                Faculty Load



                                                               Extract/Load




                                                                                                           Restrictions


                                                                                                                              Compliance
                                                                                                                                           Algorithmic
                                                                              Automation


                                                                                           Application




                                                                                                                                           Packaging
           Release




                                                                                                                              Athletic
                                                               Catalog


                                                                              Waitlist
Product              API Name
Student   8.1        sb_athletic_compliance                                                                                      X



Student   8.1        sb_athletic_degc_comp                                                                                       X



Student   8.1        sb_athletic_eligibility                                                                                     X



Student   8.1        sb_athletic_transfer                                                                                        X



Student   7.2        sb_catlg_int_partner



Student   7.0        sb_course

Student   8.0        sb_course_labor

Student   8.0        sb_crse_atts_restriction                                                                   X




Student   8.0        sb_crse_chrt_restriction                                                                   X

Student   8.0        sb_crse_dept_restriction                                                                   X



Student   8.0        sb_crse_select_pri                                          X




Student   7.3.1 sb_curric_status_event




                                                                                                                                   Page 82
                                                                                         Banner APIs by Product

          Enhancements




                                                                                                         Course, Sec, Reg
                                                                                         SS Graduation
                                              Faculty Load



                                                             Extract/Load




                                                                                                         Restrictions


                                                                                                                            Compliance
                                                                                                                                         Algorithmic
                                                                            Automation


                                                                                         Application




                                                                                                                                         Packaging
           Release




                                                                                                                            Athletic
                                                             Catalog


                                                                            Waitlist
Product              API Name
Student   7.0        sb_curriculum

Student   7.3.1 sb_curriculum_default

Student   7.3.1 sb_curriculum_history

Student   7.1        sb_datafile_delimiter

Student   7.1        sb_datafile_test_score

Student   7.3        sb_edi_acad_sess_sum



Student   7.3        sb_edi_acad_session

Student   7.3        sb_edi_acad_summ

Student   7.3        sb_edi_acrec_ude

Student   7.3        sb_edi_course

Student   7.3        sb_edi_doc_header



Student   7.3        sb_edi_header



Student   7.3        sb_edi_identification

Student   7.3.2 sb_edi_immunization

Student   7.3        sb_edi_medical

Student   7.3        sb_edi_status




                                                                                                                                 Page 83
                                                                                          Banner APIs by Product

          Enhancements




                                                                                                          Course, Sec, Reg
                                                                                          SS Graduation
                                               Faculty Load



                                                              Extract/Load




                                                                                                          Restrictions


                                                                                                                             Compliance
                                                                                                                                          Algorithmic
                                                                             Automation


                                                                                          Application




                                                                                                                                          Packaging
           Release




                                                                                                                             Athletic
                                                              Catalog


                                                                             Waitlist
Product              API Name
Student   7.3        sb_edi_stud_ude

Student   7.3        sb_edi_subtest

Student   7.3        sb_edi_subtest_score

Student   7.3        sb_edi_test

Student   7.3        sb_edi_trans_ude

Student   7.2        sb_enroll_ver_payment




Student   7.2        sb_enroll_ver_service




Student   7.0        sb_facassignment

Student   7.0        sb_faculty

Student   7.0        sb_fieldofstudy

Student   7.2        sb_fieldofstudy_allowed

Student   7.3.1 sb_fieldofstudy_archive

Student   8.0        sb_gradapp                                                               X




                                                                                                                                  Page 84
                                                                                         Banner APIs by Product

          Enhancements




                                                                                                         Course, Sec, Reg
                                                                                         SS Graduation
                                              Faculty Load



                                                             Extract/Load




                                                                                                         Restrictions


                                                                                                                            Compliance
                                                                                                                                         Algorithmic
                                                                            Automation


                                                                                         Application




                                                                                                                                         Packaging
           Release




                                                                                                                            Athletic
                                                             Catalog


                                                                            Waitlist
Product              API Name
Student   8.0        sb_gradapp_displayrule                                                  X



Student   8.0        sb_gradapp_eligible                                                     X




Student   8.0        sb_gradapp_graddate                                                 X



Student   8.0        sb_gradapp_paymentopts                                                  X




Student   8.0        sb_gradapp_selrule                                                      X




Student   7.3.1 sb_highschool

Student   8.0        sb_incmp_grading

Student   7.0        sb_learner

Student   7.0        sb_learnercurricstatus



Student   7.0        sb_learnermodule

Student   7.0        sb_learneroutcome

Student   8.0        sb_mass_entry

Student   8.0        sb_mass_entry_column




                                                                                                                                 Page 85
                                                                                          Banner APIs by Product

          Enhancements




                                                                                                          Course, Sec, Reg
                                                                                          SS Graduation
                                               Faculty Load



                                                              Extract/Load




                                                                                                          Restrictions


                                                                                                                             Compliance
                                                                                                                                          Algorithmic
                                                                             Automation


                                                                                          Application




                                                                                                                                          Packaging
          Release




                                                                                                                             Athletic
                                                              Catalog


                                                                             Waitlist
Product             API Name
Student   8.0       sb_mass_entry_form

Student   7.0       sb_mealassignment

Student   7.3       sb_pesc_status_export

Student   7.3       sb_pesc_status_imp

Student   7.3       sb_pescxml_trandata_exp



Student   7.3       sb_pescxml_trandata_imp



Student   7.0       sb_phoneassignment

Student   7.0       sb_recruit

Student   8.0       sb_registration_msg



Student   7.0       sb_roommate

Student   7.0       sb_roompreference

Student   8.0       sb_sect_atts_restriction                                                                   X




Student   8.0       sb_sect_chrt_restriction                                                                   X

Student   8.0       sb_sect_dept_restriction                                                                   X




                                                                                                                                  Page 86
                                                                                            Banner APIs by Product

          Enhancements




                                                                                                            Course, Sec, Reg
                                                                                            SS Graduation
                                                 Faculty Load



                                                                Extract/Load




                                                                                                            Restrictions


                                                                                                                               Compliance
                                                                                                                                            Algorithmic
                                                                               Automation


                                                                                            Application




                                                                                                                                            Packaging
           Release




                                                                                                                               Athletic
                                                                Catalog


                                                                               Waitlist
Product              API Name
Student   7.0        sb_section

Student   8.0        sb_section_labor



Student   7.0        sb_smrprle

Student   7.0        sb_sobctrl

Student   7.0        sb_term

Student   7.2        sb_test_percentile

Student   7.3.1 sb_testscore

Student   7.2        sb_transcript_name

Student   7.2        sb_transcript_name_source

Student   7.2        sb_transcript_req_name

Student   8.0        sb_transfer_crse                              X



Student   8.0        sb_transfer_crse_attr                         X



Student   8.0        sb_transfer_crse_cmt                          X



Student   8.0        sb_transfer_equiv                             X

Student   8.0        sb_transfer_equiv_attr                        X




                                                                                                                                    Page 87
                                                                                        Banner APIs by Product

          Enhancements




                                                                                                        Course, Sec, Reg
                                                                                        SS Graduation
                                             Faculty Load



                                                            Extract/Load




                                                                                                        Restrictions


                                                                                                                           Compliance
                                                                                                                                        Algorithmic
                                                                           Automation


                                                                                        Application




                                                                                                                                        Packaging
           Release




                                                                                                                           Athletic
                                                            Catalog


                                                                           Waitlist
Product              API Name
Student   8.0        sb_transfer_equiv_cmt                     X



Student   8.0        sb_wl_collector                                          X




Student   8.0        sb_wl_exclusion                                          X




Student   8.0        sb_wl_notification                                       X



Student   8.0        sb_wl_reordering                                         X



Student   8.0        sb_wl_section_ctrl                                       X



Student   8.0        sb_wl_term_control                                       X

Student   7.1.1 sp_academic_period



Student   8.0        sp_catalog_export                         X




                                                                                                                                Page 88
          Student
                                     Student
                                     Product
                                                      Release
                                                                        Enhancements




                                           API Name




          7.1.1 sp_housing_profile
                                     7.1.1 sp_housing_eligibility




                                                     Faculty Load

                                                     Catalog
                                                     Extract/Load
                                                     Waitlist
                                                     Automation
                                                     SS Graduation
                                                     Application
                                                     Course, Sec, Reg
                                                     Restrictions
                                                     Athletic
                                                     Compliance
                                                     Algorithmic
                                                     Packaging




Page 89
                                                                                       Banner APIs by Product
          Product
          Release
                             Enhancements




          API Name




          Faculty Load

          Catalog
          Extract/Load
          Waitlist
          Automation
          SS Graduation
          Application
          Course, Sec, Reg
          Restrictions
          Athletic
          Compliance
          Algorithmic
          Packaging




Page 90
                                            Banner APIs by Product
          Product
          Release
                             Enhancements




          API Name




          Faculty Load

          Catalog
          Extract/Load
          Waitlist
          Automation
          SS Graduation
          Application
          Course, Sec, Reg
          Restrictions
          Athletic
          Compliance
          Algorithmic
          Packaging




Page 91
                                            Banner APIs by Product
          Product
          Release
                             Enhancements




          API Name




          Faculty Load

          Catalog
          Extract/Load
          Waitlist
          Automation
          SS Graduation
          Application
          Course, Sec, Reg
          Restrictions
          Athletic
          Compliance
          Algorithmic
          Packaging




Page 92
                                            Banner APIs by Product
          Product
          Release
                             Enhancements




          API Name




          Faculty Load

          Catalog
          Extract/Load
          Waitlist
          Automation
          SS Graduation
          Application
          Course, Sec, Reg
          Restrictions
          Athletic
          Compliance
          Algorithmic
          Packaging




Page 93
                                            Banner APIs by Product
          Product
          Release
                             Enhancements




          API Name




          Faculty Load

          Catalog
          Extract/Load
          Waitlist
          Automation
          SS Graduation
          Application
          Course, Sec, Reg
          Restrictions
          Athletic
          Compliance
          Algorithmic
          Packaging




Page 94
                                            Banner APIs by Product
                                       Programs Impacted by Banner APIs

                                                                      Tables
                                                                      Impacting the
Product       Release   Program Name                Program Type      Program         Associated APIs
Advancement     8.1     AGAGMAS                     Form              AGRAUXH         ab_gift_auxl_hold
Advancement     7.0     AGPMATC                     C/Cobol Program   SPRIDEN         gb_identification
Advancement     8.1     AMAPROP                     Form              AMRPRPH         ab_project_history
                                                                      AMRPRRS         ab_project_results
                                                                      AMBPRPH         ab_proposal_history
Advancement     7.0     AOAORGN                     Form              APRCATG         ab_donor_category
Advancement     7.0     APACONS                     Form              APRCATG         ab_donor_category
Advancement     7.0     APAIDEN                     Form              SPRIDEN         gb_identification
Advancement     7.0     APANAME                     Form              SPRIDEN         gb_identification
Advancement     7.0     APAWPRS                     Form              SPRIDEN         gb_identification
                                                                      APRCATG         ab_donor_category
Advancement     7.0     APKLDRD.P_LOAD_SPOUSE       Package           APBCONS         ab_adv_individual
Advancement     7.0     APPCUPD                     C/Cobol Program   SPRIDEN         gb_identification
Advancement     7.0     APPSTDI                     C/Cobol Program   APRCATG         ab_donor_category
Advancement     7.0     BWAKADVS.P_INSERT_ADVISOR   Package           APBCONS         ab_adv_individual
Advancement     7.0     BWAKALOG                    Package           GOBTPAC         gb_third_party_access
Advancement     7.0     BWAKPREF.P_UPD_PREF_ADDR    Package           APBCONS         ab_adv_individual
Advancement     7.4     BWDKLIBS                    Package           AOBDOSR         ab_custom_search_header
                                                                      AORDOSR         ab_custom_search_detailr
Advancement     7.4     BWDKSRCH                    Package           AOBDOSR         ab_custom_search_header
                                                                      AORDOSR         ab_custom_search_detailr
AR              7.0     TFAADSP                     Form              TBRACCD         tb_receivable
AR              7.0     TFADETF                     Form              TBRACCD         tb_receivable
AR              7.0     TFADETL                     Form              TBRACCD         tb_receivable
                                                                      TBRDEPO         tb_deposit
AR              7.2     TFADETL                     Form              TBRMEMO         tb_memo
AR              7.0     TFAISTL                     Form              TBRACCD         tb_receivable
AR              7.0     TFAMASS                     Form              TBRACCD         tb_receivable
AR              7.2     TFAMASS                     Form              TBRMEMO         tb_memo
AR              7.0     TFAMDET                     Form              TBRACCD         tb_receivable
AR              7.0     TFAMISC                     Form              TBBMISC         tb_misc_header
                                                                      TBRMISD         tb_misc_detail
                                                                                      tgkfoap (foapal validation)
AR              7.0     TFAUNAP                     Form              TBRACCD         tb_receivable



                                                           Page 95
                                   Programs Impacted by Banner APIs

                                                              Tables
                                                              Impacting the
Product   Release   Program Name            Program Type      Program         Associated APIs
AR          7.0     TFRBILL                 C/Cobol Program   TBRACCD         tb_receivable
AR          7.0     TFRLATE                 C/Cobol Program   TBRACCD         tb_receivable
AR          7.0     TFRRFND                 C/Cobol Program   TBRACCD         tb_receivable
AR          7.0     TGACPRF                 Form              TBBCPRF         tb_customer_profile
AR          7.0     TGACREV                 Form              TBRACCD         tb_receivable
                                                              TBRDEPO         tb_deposit
                                                              TRRACCD         direct DML
                                                              TBRMISD         tb_misc_detail
                                                                              (all via tb_cashier_session)
AR          7.2     TGKB_DEPOSIT            Package           TBRMEMO         tb_memo
AR          7.0     TGPBILL                 C/Cobol Program   TBRACCD         tb_receivable
                                                              TBRDEPO         tb_deposit
AR          7.2     TGPBILL                 C/Cobol Program   TBRMEMO         tb_memo
AR          7.3     TGPSTMT                 C/Cobol Program   TBBSTMT         tb_statement
AR          7.0     TGRAPPL                 C/Cobol Program   TBRACCD         tb_receivable
AR          7.0     TGRCLOS                 C/Cobol Program   TBRACCD         tb_receivable
                                                              TBRDEPO         tb_deposit
                                                              TRRACCD         direct DML
                                                              TBRMISD         tb_misc_detail
                                                                              (all via tb_cashier_session)
AR          7.0     TGRFEED                 C/Cobol Program   TBRMISD         tb_misc_detail
                                                              TBRACCD         tb_receivable
                                                              TBRDEPO         tb_deposit
AR          7.0     TGRUNAP                 C/Cobol Program   TBRACCD         tb_receivable
AR          7.0     TSAADSP                 Form              TBRACCD         tb_receivable
AR          7.0     TSAAREV                 Form              TBRACCD         tb_receivable
AR          7.2     TSACONP                 Form              TBRMEMO         tb_memo
AR          7.2     TSACONT                 Form              TBRMEMO         tb_memo
AR          7.0     TSADETF                 Form              TBRACCD         tb_receivable
AR          7.0     TSADETL                 Form              TBRACCD         tb_receivable
AR          7.2     TSADETL                 Form              TBRMEMO         tb_memo
AR          7.0     TSAISTL                 Form              TBRACCD         tb_receivable
AR          7.0     TSAMASS                 Form              TBRACCD         tb_receivable
AR          7.2     TSAMASS                 Form              TBRMEMO         tb_memo



                                                 Page 96
                                   Programs Impacted by Banner APIs

                                                              Tables
                                                              Impacting the
Product   Release   Program Name            Program Type      Program         Associated APIs
AR          7.0     TSAMISC                 Form              TBBMISC         tb_misc_header
AR          7.0     TSASPAY                 Form              TBRACCD         tb_receivable
                                                              SFBETRM         sb_enrollment
                                                              SLRMASG         gb_mealassignment
                                                              SLRPASG         sb_phoneassignment
                                                              SLRRASG         sb_roomassignment
AR          7.2     TSASPAY                 Form              TBRMEMO         tb_memo
AR          7.1     TSATERM                 Form              TBBTERM         tb_term_control_ar
AR          7.0     TSAUNAP                 Form              TBRACCD         tb_receivable
AR          7.0     TSKFUNC                 Package           TBRACCD         tb_receivable
AR          7.2     TSKFUNC                 Form              TBRMEMO         tb_memo
AR          7.0     TSKMODS                 Package           TBRACCD         tb_receivable
AR          7.2     TSKMODS                 Form              TBRMEMO         tb_memo
AR          7.0     TSP1098                 C/Cobol Program   TBRACCD         tb_receivable
AR          7.0     TSPISTT                 C/Cobol Program   TBRACCD         tb_receivable
AR          7.0     TSRCBIL                 C/Cobol Program   TBRACCD         tb_receivable
                                                              SFBETRM         sb_enrollment
                                                              SLRMASG         gb_mealassignment
                                                              SLRPASG         sb_phoneassignment
                                                              SLRRASG         sb_roomassignment
AR          7.2     TSRCBIL                 C/Cobol Program   TBRMEMO         tb_memo
AR          7.3     TSRCBIL                 C/Cobol Program   TBBSTMT         tb_statement
AR          7.0     TSRLATE                 C/Cobol Program   TBRACCD         tb_receivable
AR          7.0     TSRLBOX                 C/Cobol Program   TBRACCD         tb_receivable
AR          7.0     TSRRFND                 C/Cobol Program   TBRACCD         tb_receivable
AR          7.0     TSRTBIL                 C/Cobol Program   TBRACCD         tb_receivable
AR          7.2     TSRTBIL                 C/Cobol Program   TBRMEMO         tb_memo
AR          7.0     TTKMODS                 Package           TBRACCD         tb_receivable
Finance     7.3     BWFKTRA                 Package           FGBJVCH         fb_jv_header
                                                              FGBJVCD         fb_jv_detail
                                                                              fp_journal_voucher




                                                 Page 97
                                   Programs Impacted by Banner APIs

                                                              Tables
                                                              Impacting the
Product   Release   Program Name            Program Type      Program         Associated APIs
Finance     7.3     BWFKUAD1                Package           FGBJVCH         fb_jv_header
                                                              FGBJVCD         fb_jv_detail
                                                              FABINVH         fp_journal_voucher
                                                              FARINVA         fb_invoice_header
                                                                              fb_invoice_acctg
Finance     7.3     FAACHKS                 Form              FABINVH         fb_invoice_header
                                                              FARINVC         fb_invoice_item
                                                              FARINVA         fb_invoice_acctg
Finance     7.3     FAAINVD                 Form              FABINVH         fp_invoice
Finance     7.3     FAAPAYC                 Form              FABINVH         fb_invoice_header
                                                              FARINVC         fb_invoice_item
Finance     7.3     FAARUIV                 Form              FABINVH         fb_invoice_header
Finance     7.3     FABCHKA                 C/Cobol Program   FABINVH         fb_invoice_header
                                                              FARINVC         fb_invoice_item
                                                              FARINVA         fb_invoice_acctg
Finance     7.3     FABMATC                 C/Cobol Program   FABINVH         fb_invoice_header
                                                              FARINVC         fb_invoice_item
Finance     7.3     FAPINVT                 C/Cobol Program   FABINVH         fb_common
                                                              FARINVC         fp_invoice
                                                              FARINVA
Finance     8.0     FFKRULP                 Package           FGBENCB         fp_encumbrance
                                                              FGBENCH
Finance     7.3     FGAAUTO                 Form              FGBJVCH         fb_jv_header
                                                                              fp_journal_voucher
Finance     8.0     FGAENCB                 Form              FGBENCH         fb_encumbrance_header
                                                              FGBENCD         fb_encumbrance_detail
                                                              FGBENCB         fp_encumbrance
Finance     7.3     FGAJVCD                 Form              FGBJVCH         fb_jv_header
                                                              FGBJVCD         fb_jv_detail
                                                                              fp_journal_voucher
Finance     7.3     FGAJVCM                 Form              FGBJVCH         fb_jv_header
                                                              FGBJVCD         fb_jv_detail
                                                                              fp_journal_voucher




                                                   Page 98
                                   Programs Impacted by Banner APIs

                                                              Tables
                                                              Impacting the
Product   Release   Program Name            Program Type      Program       Associated APIs
Finance     7.3     FGAJVCQ                 Form              FGBJVCH       fb_jv_header
                                                              FGBJVCD       fb_jv_detail
                                                                            fp_journal_voucher
Finance     8.0     FGIENCD                 Form              FGBENCB       fp_encumbrance
                                                              FGBENCH
Finance     7.3     FGPBODY                 C/Cobol Program   FABINVH       fb_invoice_header
                                                              FARINVC       fb_invoice_item
                                                              FARINVA       fb_invoice_acctg
Finance     8.0     FGPEOCD                 C/Cobol Program   FGBENCD       fb_encumbrance_detail
                                                              FGBENCB       fp_encumbrance
                                                              FGBENCH
Finance     8.0     FGPEXXX                 C/Cobol Program   FGBENCD       fb_encumbrance_detail
                                                              FGBENCB       fp_encumbrance
                                                              FGBENCH
Finance     7.0     FGRACTG                 C/Cobol Program   FPBPOHD       fb_purchase_order
                                                              FPRPODT       fb_requisition
                                                              FPRPODA
                                                              FPBREQH
                                                              FPRREQD
                                                              FPRREQA
Finance     7.3     FGRACTG                 C/Cobol Program   FPRPODT       fb_jv_header
                                                                            fb_jv_detail
                                                                            fp_journal_voucher
                                                                            fb_invoice_header
                                                                            fb_invoice_item
                                                                            fb_invoice_acctg
                                                                            fb_invoice_tax
                                                                            fp_invoice
Finance     8.0     FGRACTG                 C/Cobol Program   FGBENCD       fb_encumbrance_detail
                                                              FGBENCB       fp_encumbrance
                                                              FGBENCH
Finance     7.0     FGRTRNI                 C/Cobol Program   FTVCOMM       fb_commodity




                                                   Page 99
                                   Programs Impacted by Banner APIs

                                                              Tables
                                                              Impacting the
Product   Release   Program Name            Program Type      Program         Associated APIs
Finance     7.3     FGRTRNI                 C/Cobol Program   FGBJVCH         fb_jv_header
                                                              FGBJVCD         fb_jv_detail
                                                              FABINVH         fp_journal_voucher
                                                              FARINVA         fb_invoice_header
                                                                              fb_invoice_acctg
Finance     8.0     FGRTRNI                 C/Cobol Program   FGBENCB         fp_encumbrance
                                                              FGBENCH
Finance     7.0     FOAAINP                 Form              FPBPOHD         fb_purchase_order
                                                              FPRPODT         fb_requisition
                                                              FPRPODA
                                                              FGBENCH
                                                              FPBREQH
                                                              FPRREQD
                                                              FPRREQA
Finance     7.3     FOAAINP                 Form              FGBJVCH         fb_jv_header
                                                              FGBJVCD         fb_jv_detail
                                                              FABINVH         fp_journal_voucher
                                                              FARINVA         fb_invoice_header
                                                                              fb_invoice_acctg
Finance     8.0     FOAAINP                 Form              FGBENCH         fb_encumbrance_header
                                                              FGBENCD         fb_encumbrance_detail
                                                              FGBENCB         fp_encumbrance
Finance     7.0     FOADOCU                 Form              FPBPOHD         fb_purchase_order
                                                              FPRPODT         fb_requisition
                                                              FPRPODA
                                                              FPBREQH
                                                              FPRREQD
                                                              FPRREQA
Finance     7.3     FOADOCU                 Form              FGBJVCD         fb_jv_detail
                                                              FABINVH         fp_journal_voucher
                                                                              fb_invoice_header
Finance     8.0     FOADOCU                 Form              FGBENCH         fb_encumbrance_header
                                                              FGBENCB         fp_encumbrance




                                                   Page 100
                                   Programs Impacted by Banner APIs

                                                              Tables
                                                              Impacting the
Product   Release   Program Name            Program Type      Program         Associated APIs
Finance     7.0     FOAIDEN                 Form              SPRIDEN         gb_identification
                                                              SPRADDR         gb_address
                                                              SPBPERS         gb_bio
                                                              SPRTELE         gb_telephone
                                                              GOREMAL         gb_email
                                                              SPREMRG         gb_emergency_contact
                                                                              gp_common_matching
Finance     7.0     FOAUAPP                 Form              FPBPOHD         fb_purchase_order
                                                              FPRPODT         fb_requisition
                                                              FPRPODA
                                                              FPBREQH
                                                              FPRREQD
                                                              FPRREQA
Finance     7.3     FOAUAPP                 Form              FGBJVCH         fb_jv_header
                                                              FGBJVCD         fb_jv_detail
                                                              FABINVH         fp_journal_voucher
                                                              FARINVA         fb_invoice_header
                                                                              fb_invoice_acctg
Finance     8.0     FOAUAPP                 Form              FGBENCH         fb_encumbrance_header
                                                              FGBENCD         fb_encumbrance_detail
                                                              FGBENCB         fp_encumbrance
Finance     7.3     FOKUTIL                 Package           FGBJVCH         fb_jv_header
                                                              FGBJVCD         fb_jv_detail
Finance     8.0     FOKUTIL                 Package           FGBENCD         fb_encumbrance_detail
Finance     7.3     FOQINVA                 Form              FARINVA         fb_invoice_acctg
Finance     7.3     FOQJVCD                 Form              FGBJVCD         fb_jv_detail
                                                                              fp_journal_voucher
Finance     7.0     FORAPPL                 C/Cobol Program   FPBPOHD         fb_purchase_order
                                                              FPRPODT         fb_requisition
                                                              FPRPODA
                                                              FPBREQH
                                                              FPRREQD
                                                              FPRREQA



                                                   Page 101
                                   Programs Impacted by Banner APIs

                                                              Tables
                                                              Impacting the
Product   Release   Program Name            Program Type      Program         Associated APIs
Finance     8.0     FORAPPL                 C/Cobol Program   FGBENCD         fb_encumbrance_detail
                                                              FGBENCH         fp_encumbrance
                                                              FGBENCB
Finance     7.0     FPABLAR                 Form              FTVCOMM         fb_commodity
Finance     7.0     FPAPORD                 C/Cobol Program   FPBPOHD         fb_purchase_order
                                                              FPRPODT
                                                              FPRPODA
Finance     7.0     FPAPURR                 Form              FPBPOHD         fb_purchase_order
                                                              FPRPODT         fb_commodity
                                                              FPRPODA
                                                              FTVCOMM
Finance     7.0     FPAREQN                 Form              FTVCOMM         fb_commodity
                                                              FPBREQH         fb_requisition
                                                              FPRREQD
                                                              FPRREQA
Finance     7.3     FPARRIM                 Form              FABINVH         fb_invoice_header
Finance     8.0     FRAGRNT                 Form              FRBGRNT         fb_grant_effcert
                                                              FRRAGPT
                                                              FRRGUSN
                                                              FRRGLOC
                                                              FRBGBIL
                                                              FRRGRPI
                                                              FRRGREC
Finance     7.0     FTMACCI                 Form              FTVACCI         fb_accounting_element
Finance     7.0     FTMACCT                 Form              FTVACCT         fb_accounting_element
Finance     7.0     FTMACTV                 Form              FTVACTV         fb_accounting_element
Finance     7.0     FTMAGCY                 Form              SPRIDEN         gb_identification
                                                              SPRADDR         gb_address
                                                              SPRTELE         gb_telephone
                                                                              gp_common_matching
Finance     7.0     FTMCOAS                 Form              FTVCOAS         fb_chart_of_accounts
Finance     7.0     FTMCOMM                 Form              FTVCOMM         fb_commodity
Finance     7.0     FTMCUST                 Form              SPRADDR         gb_address
                                                              SPRTELE         gb_telephone



                                                   Page 102
                                         Programs Impacted by Banner APIs

                                                                    Tables
                                                                    Impacting the
Product         Release   Program Name            Program Type      Program         Associated APIs
Finance           7.0     FTMFMGR                 Form              SPRIDEN         gb_identification
                                                                    SPRADDR         gb_address
                                                                    SPRTELE         gb_telephone
Finance           7.0     FTMFUND                 Form              FTVFUND         fb_accounting_element
Finance           7.0     FTMLOCN                 Form              FTVLOCN         fb_accounting_element
Finance           7.0     FTMORGN                 Form              FTVORGN         fb_accounting_element
Finance           7.0     FTMPROG                 Form              FTVPROG         fb_accounting_element
Finance           7.0     FTMSHIP                 Form              FTVSHIP         fb_ship
Finance           7.0     FTMVEND                 Form              SPRIDEN         gb_identification
                                                                    SPRADDR         gb_address
                                                                    SPRTELE         gb_telephone
                                                                                    gp_common_matching
Finance           7.3     FURAPAY                 C/Cobol Program   FABINVH         fb_common
                                                                    FARINVC         fp_invoice
                                                                    FARINVA
Finance           8.0     FXIENCD                 Form              FGBENCH         fp_encumbrance
                                                                    FGBENCB
Financial Aid    7.3.1    BWRKACPT                Package           RRRAREQ         rb_requirement
Financial Aid     7.8     BWRKACPT                Package           RPRAWRD         rp_award
Financial Aid     7.8     PCKGCAA                 C/Cobol Program   RPRAWRD         rp_award
Financial Aid     8.1     RBAABUD                 Form              RORSTAT         rb_applicant_status
                                                                                    rp_applicant_status
Financial Aid     8.1     RCPDTMP                 C/Cobol Program   ROTSTAT         rb_temp_appl_status
Financial Aid     7.0     RCPMTCH                 C/Cobol Program                   gp_common_matching
Financial Aid     8.1     RCRSUSP                 Form              ROTSTAT         rb_temp_appl_status
Financial Aid     7.0     RCRTPxx                 C/Cobol Program   SPRIDEN         gb_identification
                                                                    GOREMAL         gb_email
                                                                    SPBPERS         gb_bio
                                                                    SPRADDR         gb_address
                                                                    SPRTELE         gb_telephone
                                                                    ROTSTAT         rb_temp_appl_status
                                                                                    gp_common_matching
Financial Aid    7.3.1    RCRTPxx                 C/Cobol Program   RRRAREQ         rb_requirement
Financial Aid     7.9     RCRTPxx                 C/Cobol Program   ROBUSDF         rb_user_def_data


                                                         Page 103
                                         Programs Impacted by Banner APIs

                                                                    Tables
                                                                    Impacting the
Product         Release   Program Name            Program Type      Program       Associated APIs
Financial Aid     8.1     RCRTPxx                 C/Cobol Program   RORSTAT       rb_applicant_status
                                                                                  rp_applicant_status
Financial Aid     8.1     REACORR                 Form              RORSTAT       rb_applicant_status
Financial Aid     7.0     READIxx                 Form              RPRADSB       rb_award_disbursement
Financial Aid     7.8     READIxx                 Form              RPRAWRD       rb_award
Financial Aid     7.0     REAORxx                 Form              REBPAYV       rb_pell_originations
Financial Aid     8.1     REAORxx                 Form              RORSTAT       rb_applicant_status
Financial Aid     7.0     REASTID                 Form              RERSTID       rb_cod_identifier
Financial Aid     8.1     REKB_TEACH_ORIG         Package           REBPAYV       rb_pell_originations
Financial Aid     7.0     REKCExx                 Package           REBPAYV       rb_pell_originations
                                                                    RERCODD       rb_cod_document
                                                                    RERSTID       rb_cod_identifier
                                                                    RPRADSB       rb_award_disbursement
Financial Aid     7.8     REKCExx                 Package           RPRAWRD       rb_award
Financial Aid     7.0     REKCIxx                 Package           REBPAYV       rb_pell_originations
                                                                    RERCODD       rb_cod_document
                                                                    RERSTID       rb_cod_identifier
                                                                    RPRADSB       rb_award_disbursement
                                                                    RPRRFND       rb_dl_refund
Financial Aid     7.8     REKCIxx                 Package           RPRAWRD       rb_award
Financial Aid     8.1     REKCIxx                 Package           RORSTAT       rb_applicant_status
Financial Aid     8.0     REKORIG                 Package           RPRAWRD       rb_award
Financial Aid     8.1     RERFIxx                 Package           RORSTAT       rb_applicant_status
Financial Aid     7.0     RERORxx                 C/Cobol Program   REBPAYV       rb_pell_originations
Financial Aid     8.1     RERORxx                 C/Cobol Program   RORSTAT       rb_applicant_status
Financial Aid     7.0     RERPLxx                 C/Cobol Program   REBPAYV       rb_pell_originations
Financial Aid     7.9     RESDBPR                 Package           RHRCOMM       rb_applicant_comment
Financial Aid    7.3.1    RFIXAREQ                Package           RRRAREQ       rb_requirement
Financial Aid     7.9     RHACOMM                 Form              RHRCOMM       rb_applicant_comment
Financial Aid     7.8     RHAPBAW                 Form              RPRAWRD       rb_award
Financial Aid     7.9     RHRPCOM                 C/Cobol Program   RHRCOMM       rb_applicant_comment
Financial Aid     7.8     RJASEME                 Form              RPRAWRD       rb_award
                                                                    RPRATRM       rb_award_schedule
Financial Aid     7.3     RJASERF                 Form              SPRMEDI       gb_medical



                                                         Page 104
                                         Programs Impacted by Banner APIs

                                                                    Tables
                                                                    Impacting the
Product         Release   Program Name            Program Type      Program         Associated APIs
Financial Aid     7.8     RJRLOAD                 C/Cobol Program   RPRAWRD         rb_award
                                                                    RPRATRM         rb_award_schedule
Financial Aid    7.3.1    RLRLETR                 C/Cobol Program   RRRAREQ         rb_requirement
Financial Aid     8.1     RLRLETR                 C/Cobol Program   RORSTAT         rb_applicant_status
Financial Aid     8.1     RNANAxx                 Form              RORSTAT         rb_applicant_status
                                                                                    rp_applicant_status
Financial Aid     8.1     RNAOVxx                 Form              RORSTAT         rb_applicant_status
                                                                                    rp_applicant_status
Financial Aid     8.1     RNAPRxx                 Form              RORSTAT         rb_applicant_status
                                                                                    rp_applicant_status
Financial Aid     8.1     RNARSxx                 Form              RORSTAT         rb_applicant_status
Financial Aid     8.1     RNASUxx                 Form              RORSTAT         rb_applicant_status
                                                                                    rp_applicant_status
Financial Aid     8.1     RNAVRxx                 Form              RORSTAT         rb_applicant_status
Financial Aid     8.1     RNRVRFY                 C/Cobol Program   RORSTAT         rb_applicant_status
Financial Aid     7.9     ROAHOLD                 Form              RHRCOMM         rb_applicant_comment
Financial Aid     8.1     ROAMESG                 Form              RORSTAT         rp_applicant_status
Financial Aid     7.9     ROANYUD                 Form              ROBNYUD         rb_ny_user_def_data
Financial Aid    7.3.1    ROAPELL                 Form              RRRAREQ         rb_requirement
Financial Aid     8.1     ROAPELL                 Form              RORSTAT         rp_applicant_status
Financial Aid     7.3     ROARMAN                 Form              RPRADSB         rb_award_disbursement
Financial Aid    7.3.1    ROARMAN                 Form              RRRAREQ         rb_requirement
Financial Aid    7.3.1    ROASMRY                 Form              RRRAREQ         rb_requirement
Financial Aid     8.1     ROASTAT                 Form              RORSTAT         rb_applicant_status
                                                                                    rp_applicant_status
Financial Aid     7.9     ROAUSDF                 Form              ROBUSDF         rb_user_def_data
Financial Aid     8.1     ROAUSDF                 Form              RORSTAT         rp_applicant_status
Financial Aid    7.3.1    ROBBGRP                 C/Cobol Program   RRRAREQ         rb_requirement
Financial Aid     8.1     ROKB_SIM__APPL_STATUS   Package           RORSTAT         rb_applicant_status
Financial Aid     8.1     ROKB_TEMP_APPL_STATUS   Package           RORSTAT         rb_applicant_status
Financial Aid     8.1     ROKB_USER_DEF_DATA      Package           RORSTAT         rb_applicant_status
Financial Aid     8.1     ROKB_USER_DEF_DATA_R    Package           RORSTAT         rb_applicant_status
Financial Aid     7.0     ROKMISC                 Package           RPRADSB         rb_award_disbursement
Financial Aid     7.8     ROKMISC                 Package           RPRAWRD         rb_award



                                                         Page 105
                                           Programs Impacted by Banner APIs

                                                                      Tables
                                                                      Impacting the
Product         Release   Program Name              Program Type      Program         Associated APIs
Financial Aid     7.9     ROKP_APPL_STATUS          Package           ROBNYUD         rb_ny_user_def_data
                                                                      ROBUSDF         rb_user_def_data
Financial Aid     8.0     ROKP_APPL_STATUS          Package           RRRAREQ         rb_requirement
Financial Aid     8.1     ROKP_APPL_STATUS          Package           RORSTAT         rb_applicant_status
Financial Aid    7.3.1    ROOAUTO                   C/Cobol Program   RRRAREQ         rb_requirement
Financial Aid     8.1     ROPSAPR                   Package           RORSTAT         rb_applicant_status
Financial Aid     7.9     ROPUSER                   c/Cobol Program   ROBNYUD         rb_ny_user_def_data
                                                                      ROBUSDF         rb_user_def_data
Financial Aid     8.1     ROQRPLS                   Form              RORSTAT         rb_applicant_status
                                                                                      rp_applicant_status
Financial Aid     7.0     RORBPST                   C/Cobol Program   RPRADSB         rb_award_disbursement
Financial Aid    7.3.1    RORBPST                   C/Cobol Program   RRRAREQ         rb_requirement
                                                                                      rp_requirement
Financial Aid     7.8     RORBPST                   C/Cobol Program   RPRAWRD         rp_award
                                                                      RPRATRM         rb_award_schedule
Financial Aid     7.9     RORBPST                   C/Cobol Program   ROBNYUD         rb_ny_user_def_data
                                                                      ROBUSDF         rb_user_def_data
Financial Aid     8.1     RORBPST                   C/Cobol Program   RORSTAT         rb_applicant_status
                                                                                      rp_applicant_status
Financial Aid     8.1     RORCALC                   C/Cobol Program   RORSTAT         rb_applicant_status
Financial Aid     8.1     RORGRPS                   C/Cobol Program   RORSTAT         rb_applicant_status
                                                                                      rp_applicant_status
Financial Aid    7.3.1    RP_REQUIREMENT            Package                           rp_requirement
Financial Aid     7.0     RPAAPMT                   Form              RPRADSB         rb_award_disbursement
Financial Aid    7.3.1    RPAAPMT                   Form              RRRAREQ         rb_requirement
Financial Aid     7.8     RPAAPMT                   Form              RPRAWRD         rp_award
                                                                      RPRATRM         rp_award_schedule
Financial Aid     8.1     RPAAPMT                   Form              RORSTAT         rb_applicant_status
                                                                                      rp_applicant_status
Financial Aid     8.1     RPAARSC                   Form              RORSTAT         rb_applicant_status
Financial Aid     7.0     RPAAWRD                   Form              RPRADSB         rb_award_disbursement
Financial Aid    7.3.1    RPAAWRD                   Form              RRRAREQ         rb_requirement
Financial Aid     7.8     RPAAWRD                   Form              RPRAWRD         rp_award
                                                                      RPRATRM         rp_award_schedule



                                                           Page 106
                                         Programs Impacted by Banner APIs

                                                                    Tables
                                                                    Impacting the
Product         Release   Program Name            Program Type      Program       Associated APIs
Financial Aid     8.1     RPAAWRD                 Form              RORSTAT       rb_applicant_status
                                                                                  rp_applicant_status
Financial Aid    7.3.1    RPAELAP                 Form              RRRAREQ       rb_requirement
Financial Aid    7.3.1    RPALAPP                 Form              RRRAREQ       rb_requirement
Financial Aid     7.8     RPALAPP                 Form              RPRAWRD       rb_award
                                                                    RPRATRM       rb_award_schedule
Financial Aid     7.0     RPALORG                 Form              RPRRFND       rb_dl_refund
Financial Aid    7.3.1    RPALORG                 Form              RRRAREQ       rb_requirement
Financial Aid     7.8     RPAMACC                 Form              RPRAWRD       rp_award
Financial Aid     7.8     RPAMOFF                 Form              RPRAWRD       rp_award
Financial Aid    7.3.1    RPATATS                 Form              RRRAREQ       rb_requirement
                                                                    RPRAWRD       rp_requirement
Financial Aid     7.0     RPBLMID                 C/Cobol Program   RPRADSB       rb_award_disbursement
Financial Aid     7.8     RPBLMID                 C/Cobol Program   RPRAWRD       rb_award
Financial Aid     7.0     RPEDISBS                C/Cobol Program   TBRACCD       tb_receivable
                                                                    RPRADSB       rb_award_disbusement
Financial Aid    7.3.1    RPEDISBS                C/Cobol Program   RRRAREQ       rb_requirement
                                                                    TBRMEMO       tb_memo
Financial Aid     7.8     RPEDISBS                C/Cobol Program   RPRAWRD       rb_award
                                                                    RPRATRM       rb_award_schedule
Financial Aid     7.0     RPEPCKG                 C/Cobol Program   RPRADSB       rb_award_disbursement
Financial Aid    7.3.1    RPEPCKG                 C/Cobol Program   RRRAREQ       rb_requirement
Financial Aid     7.8     RPEPCKG                 C/Cobol Program   RPRAWRD       rb_award
                                                                    RPTAWRD       rb_temp_award
                                                                                  rp_award
Financial Aid    7.3.1    RPEPELL                 C/Cobol Program   RRRAREQ       rb_requirement
Financial Aid     7.0     RPEPELLS                C/Cobol Program   RPRADSB       rb_award_disbursement
Financial Aid     7.8     RPEPELLS                C/Cobol Program   RPRAWRD       rb_award
                                                                    RPRATRM       rb_award_schedule
Financial Aid     7.0     RPEPINT                 C/Cobol Program   RPRADSB       rb_award_disbursement
Financial Aid    7.3.1    RPEPINT                 C/Cobol Program   RRRAREQ       rb_requirement
Financial Aid     7.8     RPEPINT                 C/Cobol Program   RPRAWRD       rb_award
                                                                    RPTAWRD       rb_temp_award
                                                                                  rp_award


                                                         Page 107
                                       Programs Impacted by Banner APIs

                                                               Tables
                                                               Impacting the
Product         Release   Program Name          Program Type   Program         Associated APIs
Financial Aid     7.8     RPK_AWARD_VAL         Package        RPRAWRD         rb_award
Financial Aid     7.8     RPK_COMMON_VAL        Package        RPRAWRD         rb_award
Financial Aid     7.8     RPKB_AWARD_SCHED      Package        RPRAWRD         rb_award
Financial Aid     7.8     RPKB_AWD_DISB         Package        RPRAWRD         rb_award
Financial Aid     7.8     RPKB_TEMP_AWARD       Package        RPRAWRD         rb_award
Financial Aid     7.8     RPKAFRM               Package        RPRAWRD         rb_award
                                                               RPRATRM         rp_award
                                                                               rp_award_schedule
Financial Aid     7.0     RPKATRM               Package        RPRADSB         rb_award_disbursement
Financial Aid     7.8     RPKATRM               Package        RPRAWRD         rb_award
                                                               RPRATRM         rb_award_schedule
Financial Aid     7.3     RPKAWDL               Package        RPRADSB         rb_award_disbursement
Financial Aid    7.3.1    RPKAWRD               Package        RRRAREQ         rb_requirement
Financial Aid     7.3     RPKAWIU               Package        RPRADSB         rb_award_disbursement
Financial Aid    7.3.1    RPKAWIU               Package        RRRAREQ         rb_requirement
Financial Aid     7.8     RPKAWRD               Package        RPRATRM         rb_award_schedule
                                                               RPRAWRD         rb_award
                                                                               rp_award
Financial Aid     7.8     RPKB_AWARD            Package        RPRATRM         rb_award_schedule
Financial Aid     8.1     RPKB_AWARD            Package        RORSTAT         rb_applicant_status
Financial Aid    7.3.1    RPKLOAN               Package        RRRAREQ         rb_requirement
Financial Aid     7.8     RPKLOAN               Package        RPRAWRD         rb_award
                                                               RPRATRM         rb_award_schedule
Financial Aid     8.1     RPKLOAN               Package        RORSTAT         rb_applicant_status
                                                                               rp_applicant_status
Financial Aid     7.8     RPKP_AWARD            Package        RPBATRM         rb_award_schedule
                                                               RPRAWRD         rb_award
                                                                               rp_award
Financial Aid     8.1     RPKP_AWARD            Package        RORSTAT         rb_applicant_status
                                                                               rp_applicant_status
Financial Aid     7.8     RPKP_AWARD_SCHED      Package        RPRATRM         rb_award_schedule
                                                               RPRAWRD         rb_award
                                                                               rp_award




                                                    Page 108
                                        Programs Impacted by Banner APIs

                                                                   Tables
                                                                   Impacting the
Product         Release   Program Name           Program Type      Program       Associated APIs
Financial Aid     8.1     RPKP_AWARD_SCHED       Package           RORSTAT       rb_applicant_status
                                                                                 rp_applicant_status
Financial Aid     7.8     RPKSAWD                Package           RPTAWRD       rb_temp_award
                                                                   RPRAWRD       rb_award
                                                                   RPRATRM       rb_award_schedule
Financial Aid     7.3     RPKTERM                Package           RPRADSB       rb_award_disbursement
Financial Aid     7.8     RPRAROL                C/Cobol Program   RPRAWRD       rb_award
                                                                                 rp_award
Financial Aid    7.3.1    RPRCNCL                C/Cobol Program   RRRAREQ       rb_requirement
Financial Aid     7.8     RPRCNCL                C/Cobol Program   RPRAWRD       rp_award
Financial Aid     7.0     RPRDLPM                Package           RERCODD       rb_cod_document
Financial Aid    7.3.1    RPRDUxx                C/Cobol Program   RRRAREQ       rb_requirement
Financial Aid    7.3.1    RRAAREQ                Form              RRRAREQ       rb_requirement
Financial Aid     8.1     RRAAREQ                Form              RORSTAT       rp_applicant_status
Financial Aid    7.3.1    RRAMASS                Form              RRRAREQ       rb_requirement
Financial Aid    7.3.1    RRKAREQ                Package           RRRAREQ       rb_requirement
Financial Aid    7.3.1    RRRAREQ                Package           RRRAREQ       rb_requirement
Financial Aid     8.1     RRKAREQ                Package           RORSTAT       rb_applicant_status
Financial Aid    7.3.1    RRKP_REQUIREMENT       Package           RRRAREQ       rb_requirement
Financial Aid     8.1     RRKP_REQUIREMENT       Package           RORSTAT       rb_applicant_status
                                                                                 rp_applicant_status
Financial Aid    7.3.1    RRRAREQ                C/Cobol Program   RRRAREQ       rb_requirement
Financial Aid    7.3.1    RRREXIT                C/Cobol Program   RRRAREQ       rb_requirement
Financial Aid    7.3.1    RSRPCOL                C/Cobol Program   RRRAREQ       rb_requirement
Financial Aid     7.3     UAARTN                 C/Cobol Program   RPRADSB       rb_award_disbursement
Financial Aid    7.3.1    UAARTN                 C/Cobol Program   RRRAREQ       rb_requirement
General           7.0     BWGKOADR               Package           GOREMAL       gb_email
                                                                   SPRADDR       gb_address
                                                                   SPRTELE       gb_telephone
General           7.0     BWGKOEMR               Package           SPREMRG       gb_emergency_contact
General           7.0     BWGKOMAR               Package           SPBPERS       gb_bio
General           7.0     GB_CURRENCY            Package
General           7.0     GB_CURRENCY_RATE       Package
General           7.0     GEAFUNC                Form              SSRMEET       gb_classtimes



                                                     Page 109
                                   Programs Impacted by Banner APIs

                                                              Tables
                                                              Impacting the
Product   Release   Program Name            Program Type      Program         Associated APIs
General     7.0     GOAADDR                 Form              SPRADDR         gb_address
                                                              SPRTELE         gb_telephone
General     7.0     GOACMDD                 Form              GORCMUP         gb_cm_user_procedure
General     7.0     GOAEMAL                 Form              GOREMAL         gb_email
General     8.0     GOADISC                 Form              GOBSDDC         gb_sde_discriminator
                                                              GORSDDV         gb_sde_discrim_value
General     7.0     GOAFBPI                 Form              GORFBPI         gb_busprofpii
General     7.0     GOAFGAC                 Form              GOBFGAC         gb_group_rules
                                                              GORFPRD         gb_vbs_predicate
                                                              GORFGUS         gb_fgac_user_rule
                                                              GORFGBP         gb_bus_prof_rule
General     7.0     GOAFPUD                 Form              GOBFPUD         gb_userdefault
                                                              GORFPII         gb_userpiidomains
General     7.3     GOAINTL                 Form              GOBINTL         gp_international_student
                                                              GORVISA         gb_visa
General     7.3     GOAMEDI                 Form              SPRMEDI         gb_medical
General     7.3     GOAMTCH                 Form              GORCMDH         gb_cm_disp_hier
General     8.0     GOAQSTN                 Form              GOBQSTN         gb_pin_question
General     8.0     GOASDMD                 Form              GORSDAM         gb_sde_metadata
General     7.3     GOASGEO                 Form              SOBSBGI
General     7.0     GOATPAC                 Form              GOBTPAC         gb_third_party_access
General     7.0     GOATPAD                 Form              GOBTPAC         gb_third_party_access
General     8.0     GOATPAD                 Form              GOBANSR         gb_pin_answer
General     7.3     GOICMSS                 Form              GORCMDD         gb_cm_data_dictionary
General     7.0     GOKMODS                 Package           GOBTPAC         gb_third_party_access
General     7.0     GOKTPTY                 Package           GOBTPAC         gb_third_party_access
General     7.0     GOQCLIB                 Form              SPRIDEN         gb_identification
                                                              GOREMAL         gb_email
                                                              SPBPERS         gb_bio
                                                              SPRADDR         gb_address
                                                              SPRTELE         gb_telephone
                                                              SPREMRG         gb_emergency_contact




                                                   Page 110
                                   Programs Impacted by Banner APIs

                                                              Tables
                                                              Impacting the
Product   Release   Program Name            Program Type      Program         Associated APIs
General     8.0     GOQCLIB                 Form              SPRIDEN         gb_identification
                                                              SPBPERS         gb_bio
                                                              SPRADDR         gb_address
                                                              SPRTELE         gb_telephone
                                                              GOREMAL         gb_email
                                                              SPREMRG         gb_emergency_contact
                                                              GORADID         gb_additional_ident
General     7.2     GOQCLIB.GORPRAC block   Form              GORPRAC         gb_person_race
General     7.0     GORCMDD                 Form              GORCMDD         gb_cm_data_dictionary
General     7.3     GORCMRL                 Form              GORCMSP         gb_cm_source_priority
                                                              GORCMSR         gb_cm_rules
                                                              GORCMUP         gb_cm_user_procedure
                                                              GORCMDD         gb_cm_data_dictionary
General     7.3     GORCMSC                 Form              GORCMDO         gb_cm_display_options
                                                              GORCMSC         gb_cm_source_rules
                                                              GORCMDH         gb_cm_disp_hier
General     7.0     GORCMUS                 Form              GOBCMUS         gb_cm_user_setup
General     7.3     GORDMCL                 Form              GORDMCL         gb_displaycolumns
                                                                              gb_displaymask
General     7.0     GORDMSK                 Form              GORDMSK         gb_displaymask
General     7.0     GORFBPR                 Form              GORFBPR         gb_businessprofile
General     7.0     GORFDMN                 Form              GOBFDMN         gb_domains
General     7.0     GORFDPL                 Form              GORFDPL         gb_pii_tables
General     7.0     GORFDTP                 Form              GOBFDTP         gb_domaintype
General     7.0     GORFEOB                 Form              GOBFEOB         gb_fgacexcludedobjects
General     7.4     GORICCR                 Form              GORICCR         gb_integ_config
General     7.2     GORINTG                 Form              GORINTG         gb_partner_rule
General     7.0     GORNAME                 Form              GORNAME         gb_name_translate
General     7.0     GORNPNM                 Form              GORNPNM         gb_np_name_trans
General     7.2     GORRACE                 Form              GORRACE         gb_race_ethnicity
General     7.0     GPPADDR                 C/Cobol Program   SPRADDR         gb_address
                                                              SPRTELE         gb_telephone
General     7.3     GTVCMSC                 Form              GTVCMSC         DML package only (no API)
General     8.0     GTVSDTB                 Form              GOBSDTB         gb_sde_table



                                                   Page 111
                                  Programs Impacted by Banner APIs

                                                             Tables
                                                             Impacting the
Product   Release   Program Name           Program Type      Program         Associated APIs
General     7.4     GT_GOREMAL_AR_LDI      Trigger           GORICCR         gb_integ_config
General    7.3.1    GURIROL                C/Cobol Program   GORIROL         gb_institution_role
General     7.0     GXRBANK                Form              SPRIDEN         gp_common_matching
General     7.0     TWBKINTE               Package           GOBTPAC         gb_third_party_access
General     7.0     TWBKWBIS               Package           GOBTPAC         gb_third_party_access
HR          8.0     BWPKEPD1               Package           NORCMNT         nb_ea_comments
                                                             NBRJLBD         np_job_labor
HR          8.0     BWPKFCF1               Package           NBRBJOB         np_job_assignment
                                                             NBRJOBS         pb_fac_comments
                                                             PERFLCM         pb_fac_crsassign
                                                             PERFASG         pb_fac_isolcomp
                                                             PERFISO         pb_fac_jobdetail
                                                             PERFJOB         pb_fac_jobearns
                                                             PERFJER         pb_fac_niolcomp
                                                             PERFNIO         pb_fac_nistcomp
                                                             PERFNIS         pp_fac_jobdistr
                                                             PERFJLD
HR          8.0     BWPKFCP1               Package           PERFASG         pb_fac_crsassign
                                                             PERFCSC         pb_fac_crsecomp
                                                             PERFCIN         pb_fac_incrcomp
                                                             PERFJOB         pb_fac_jobdetail
                                                             PTRSCHD         pb_fac_schrate
HR          8.0     BWPKFCR1               Package           PERFLCM         pb_fac_comments
                                                             PERFJOB         pb_fac_jobdetail
                                                             PERFNIS         pb_fac_nistcomp
                                                             PTRNILV         pb_fac_nisrate




                                               Page 112
                                       Programs Impacted by Banner APIs

                                                                        Tables
                                                                        Impacting the
Product   Release   Program Name                      Program Type      Program         Associated APIs
HR          8.0     BWPKFJD1                          Package           NBRBJOB         np_job_assignment
                                                                        NBRJOBS         pb_fac_crsassign
                                                                        PERFASG         pb_fac_isolcomp
                                                                        PERFISO         pb_fac_jobdetail
                                                                        PERFJOB         pb_fac_jobdistr
                                                                        PERFJLD         pb_fac_jobearns
                                                                        PERFJER         pb_fac_niolcomp
                                                                        PERFNIO         pb_fac_nistcomp
                                                                        PERFNIS         pp_fac_jobdistr
                                                                        PERFJLD
HR          8.0     BWPKFJL1                          Package           PERFJOB         pb_fac_jobdetail
                                                                        PERFJLD         pb_fac_jobdistr
HR          8.0     BWPKFLD1                          Package           PERFLCM         pb_fac_comments
                                                                        PERFJOB         pb_fac_jobdetail
HR          8.0     BWPKFMS1                          Package           PERFLCM         pb_fac_comments
HR          8.0     BWPKFSL1                          Package           PERFJOB         pb_fac_jobdetail
HR          8.0     BWPKSDS1                          Package           NBRJLBD         np_job_labor
HR          8.0     BWPKX061                          Package           PXRW2FD         pb_w2_federal
HR          8.0     BWPKX071                          Package           PXRW2FD         pb_w2_federal
HR          8.0     BWPKXW21                          Package           PEBEMPL         pb_employee
                                                                        PXRW2FD         pb_w2_federal
HR          8.1     LaborRedistributionRoutingQueue   Java              NTVQPRT         nb_ntvqprt
HR          8.1     LaborRedistributionRouting        Java              PHRLRRQ         pb_redistr_queue
                    QueueDAO
HR          8.0     NBAJOBS                           Form              NBRJLEH         nb_job_base
                                                                        NBRJLHS         nb_job_detail
                                                                        NBRBJOB         nb_job_earnings
                                                                        NBRJOBS         nb_job_labor
                                                                        NBREARN         np_job_earnings
                                                                        NBRJLBD         nb_job_enc_history
                                                                        NBRJLEH         np_job_assignment
                                                                                        np_job_earnings
                                                                                        np_job_labor
            8.0     NBIJLHS                           Form              NBRJLHS         nb_job_enc_history



                                                             Page 113
                                     Programs Impacted by Banner APIs

                                                             Tables
                                                             Impacting the
Product   Release   Program Name              Program Type   Program         Associated APIs
HR          8.0     NBKB_JOB_BASE1            Package        NBRJOBS         nb_job_detail
                                                             NBREARN         nb_job_earnings
HR          8.0     NBKB_JOB_EARNINGS_R1      Package        NBRBJOB         np_job_assignment
                                                             NBRJOBS
HR          8.0     NBKB_JOB_EARNINGS1        Package        NBRBJOB         np_job_assignment
                                                             NBRJOBS
HR          8.0     NBKBJOB1                  Package        NBRBJOB         nb_job_base
                                                             NBRJOBS         nb_job_detail
HR          8.0     NBKCOMP1                  Package        NBRJOBS         nb_job_detail
HR          8.0     NBKEARN1                  Package        NBREARN         nb_job_earnings
HR          8.0     NBKENCM                   Package        NBRJLBD         np_job_labor
HR          8.0     NBKENCM1                  Package        NBRBJOB         nb_job_base
                                                             NBRJOBS         nb_job_detail
                                                             NBRJLBD         nb_job_labor
                                                             NBRJLHS         nb_job_enc_history
HR          8.0     NBKJENC1                  Package        NBRBJOB         nb_job_base
                                                             NBRJOBS         nb_job_detail
HR          8.0     NBKJLBD                   Package        NBRJLBD         np_job_labor
HR          8.0     NBKJLBD1                  Package        NBRJOBS         nb_job_detail
                                                             NBRJOBS         nb_job_labor
                                                             NBRJLBD         np_job_assignment
                                                             NBRJLHS         np_job_labor
                                                             PERFASG         nb_job_enc_history
HR          8.0     NBKJOB1                   Package        NBRBJOB         nb_job_base
                                                             NBRJOBS         nb_job_detail
HR          8.0     NBKP_JOB_ASSIGNMENT0      Package        NBREARN         np_job_earnings
                                                             NBRJLBD         np_job_labor
HR          8.0     NBKP_JOB_ASSIGNMENT1      Package        NBRBJOB         nb_job_base
                                                             NBRJOBS         nb_job_detail
                                                             NBREARN         np_job_earnings
                                                             NBRJLBD         np_job_labor
HR          8.0     NBKP_JOB_EARNINGS0.SQL    Package        NBREARN         nb_job_earnings
HR          8.0     NBKP_JOB_EARNINGS1.SQL    Package        NBREARN         nb_job_earnings




                                                  Page 114
                                  Programs Impacted by Banner APIs

                                                             Tables
                                                             Impacting the
Product   Release   Program Name           Program Type      Program         Associated APIs
HR          8.0     NBKP_JOB_LABOR0        Package           NBRJLBD         nb_job_labor
                                                             NBRJLHS         nb_job_enc_history
HR          8.0     NBKP_JOB_LABOR1        Package           NBRJLBD         nb_job_labor
                                                             NBRJLHS         nb_job_enc_history
HR          8.0     NBPENCM                C/Cobol Program   NBRJLBD         nb_job_labor
HR          8.0     NHPFIN1                C/Cobol Program   NBRJLBD         nb_job_labor
HR          8.0     NOAAPSM                Form              NORCMNT         nb_ea_comments
HR          8.0     NOAEPAF                Form              NORCMNT         nb_ea_comments
                                                                             np_job_labor
HR          8.0     NOKEDIT1               Package           NBRBJOB         np_job_assignment
                                                             NBRJOBS         np_job_labor
                                                             NBRJLBD
HR          8.0     NOKEPA1                Package           NORCMNT         nb_ea_comments
HR          8.0     NOKMUP1                Package           NBRJLBD         np_job_labor
                                                             PEBEMPL         pb_employee
            8.0     NOAEPAF                Form              NORCMNT         nb_ea_comments
HR          8.0     NOQLIBR                Form              NORCMNT         nb_ea_comments
HR          8.1     PayrollCommentsDAO     Java              PHRCMNT         pb_payhist_comment
HR          8.0     PBKP_FAC_JOB_LABOR0    Package           PERFJLD         pb_fac_jobdistr
HR          8.0     PBKP_FAC_JOB_LABOR1    Package           PERFJLD         pb_fac_jobdistr
HR          8.0     PCONVIPEDSPRIMFUNC     Package           PEBEMPL         pb_employee
HR          8.0     PDABDSU                Form              PTRBDCL         pb_dedn_comb_lmt
                                                             PTRBDLG         pb_dedn_lmt_grp
HR          8.0     PDADEDN                Form              PTRBDCL         pb_dedn_comb_lmt
                                                             PTRBDLG         pb_dedn_lmt_grp
HR          7.0     PEA1PAY                Form              SPRIDEN         gb_identification
HR          7.3     PEA1PAY                Form              NBRBJOB         nb_job_base
                                                             NBRJOBS         nb_job_detail
HR          8.0     PEA1PAY                Form              NBREARN         np_job_assignment
                                                             NBRJLBD         np_job_earnings
                                                             PEBEMPL         np_job_labor
                                                                             pb_employee
HR          7.0     PEAEMPL                Form              PEBEMPL         pb_employee
HR          7.0     PEAESCH                Form              PEBEMPL         pb_employee



                                                  Page 115
                                   Programs Impacted by Banner APIs

                                                              Tables
                                                              Impacting the
Product   Release   Program Name            Program Type      Program         Associated APIs
HR          7.3     PEAESCH                 Form              NBRBJOB         nb_job_base
                                                              NBRJOBS         nb_job_detail
HR          8.0     PEAESCH                 Form              NBRBJOB         np_job_assignment
                                                              NBRJOBS
                                                              PEBEMPL
HR          7.0     PEAHIRE                 Form              SPRIDEN         gb_identification
                                                              SPBPERS         gb_bio
                                                              SPRADDR         gb_address
                                                              SPRTELE         gb_telephone
                                                              PEBEMPL         pb_employee
                                                                              gp_common_matching
HR          7.3     PEAHIRE                 Form              NBRBJOB         nb_job_base
                                                              NBRJOBS         nb_job_detail
HR          8.0     PEAHIRE                 Form              NBRBJOB         nb_job_base
                                                              NBRJOBS         np_job_assignment
                                                              PEBEMPL         pb_employee
HR          8.0     PEAPADV                 Form              PEBEMPL         pb_employee
HR          7.0     PEATMVF                 Form              PEBEMPL         pb_employee
HR          8.0     PEKB_FAC_CRSECOMP_R1    Package           PERFASG         pb_fac_crsassign
HR          8.0     PEKB_FAC_INCRCOMP_R1    Package           PERFASG         pb_fac_crsassign
HR          8.0     PEKB_FAC_JOBEARNS_R1    Package           PERFJOB         pb_fac_jobdetail
HR          8.0     PEKEMPL1                Package           PEBEMPL         pb_employee




                                                   Page 116
                                   Programs Impacted by Banner APIs

                                                            Tables
                                                            Impacting the
Product   Release   Program Name            Program Type    Program         Associated APIs
HR          8.0     PEKFASG1                Package         NBRBJOB         nb_job_base
                                                            NBRJOBS         np_job_assignment
                                                            NBRJLBD         np_job_labor
                                                            PERFASG         pb_fac_crsassign
                                                            PERFCSC         pb_fac_crsecomp
                                                            PERFLER         pb_fac_errors
                                                            PERFCNT         pb_fac_fcnt
                                                            PERFCIN         pb_fac_incrcomp
                                                            PERFISO         pb_fac_isolcomp
                                                            PERFJOB         pb_fac_jobdetail
                                                            PERFJLD         pb_fac_jobdistr
                                                            PERFJER         pb_fac_jobearns
                                                            PERFNIO         pb_fac_niolcomp
                                                            PERFNIS         pb_fac_nistcomp
                                                            PERFJLD         pp_fac_jobdistr
HR          8.0     PEKFLAC1                Package         PERFASG         pb_fac_crsassign
                                                            PERFJOB         pb_fac_jobdetail
HR          8.0     PEPFCAP                 C/COBOL Program NBRBJOB         np_job_assignment
                                                            NBRJOBS         np_job_earnings
                                                            NBREARN         np_job_labor
                                                            NBRJLBD         pb_fac_errors
                                                            PERFLER         pb_fac_jobdetail
                                                            PERFJOB         pb_fac_jobdistr
                                                            PERFJLD         pb_fac_jobearns
                                                            PERFJER




                                                Page 117
                                   Programs Impacted by Banner APIs

                                                            Tables
                                                            Impacting the
Product   Release   Program Name            Program Type    Program         Associated APIs
HR          8.0     PEPFLAC                 C/COBOL Program PERFASG         pb_fac_crsassign
                                                            PERFCNT         pb_fac_fcnt
                                                            PERFLER         pb_fac_errors
                                                            PTRFLIC         pb_fac_incrate
                                                            PERFISO         pb_fac_isolcomp
                                                            PERFJOB         pb_fac_jobdetail
                                                            PERFJLD         pb_fac_jobdistr
                                                            PERFJER         pb_fac_jobearns
                                                            PERFNIO         pb_fac_niolcomp
                                                            PERFNIS         pb_fac_nistcomp
                                                            PTRSCHD         pb_fac_schrate
                                                            PTRSCLV         pb_fac_sclrate
HR          8.0     PHPPROF                 C/Cobol Program PEBEMPL         pb_employee
HR          8.0     PHPUPDT                 C/Cobol Program PEBEMPL         pb_employee
HR          8.0     POQRPLS                 Form            PEBEMPL         pb_employee
HR          7.2     PPACERT                 Form            PPRCERT         pb_certification
                                                            PPRENDS         pb_endorsement
HR          7.2     PPAEXPR                 Form            PPREXPE         pb_experience
HR          7.2     PPAGENL                 Form            PPRDLIC         pb_driver_license
                                                            PPRHNAW         pb_honor_award
                                                            PPRPUBL         pb_publication
                                                            PPRSKIL         pb_skill
                                                            SORMINR         gb_pcol_minor
                                                            SORDEGR         gb_pcol_degree
                                                            SORPCOL         gb_prior_college
                                                            SORCONC         gb_pcol_concentration
                                                            SORMAJR         gb_pcol_major
            8.0     PPAGENL                 Form            PPRDLIC         pb_driver_license
                                                            PPRHNAW         pb_honor_award
                                                            PPRPUBL         pb_publication




                                                Page 118
                                   Programs Impacted by Banner APIs

                                                              Tables
                                                              Impacting the
Product   Release   Program Name            Program Type      Program         Associated APIs
HR          7.0     PPAIDEN                 Form              SPRIDEN         gb_identification
                                                              SPBPERS         gb_bio
                                                              SPRADDR         gb_address
                                                              SPRTELE         gb_telephone
                                                              SPREMRG         gb_emergency_contact
                                                              GOREMAL         gb_email
                                                                              gp_common_matching
HR          7.2     PPASKIL                 Form              PPRSKIL         pb_skill
HR          8.0     PPKB_CERTIFICATION1     Package           PPRENDS         pb_endorsement
HR          8.0     PPKB_ENDORSEMENT_R1     Package           PPRCERT         pb_certification
HR         8.1.1    PP_W2_2008              Package           PXRW2ST         pb_w2_state
           7.2.7                                              PXRW2LC         pb_w2_local
                                                              PXRW2FD         pb_w2_federal
HR          7.2     PTRATRM                 Form              PTRATRM         pb_assoc_term
            8.0     PPACERT                 Form              PPRCERT         pb_certification
            8.0     PPAGENL                 Form              PPRDLIC         pb_driver_license
            8.0     PTRATRM                 Form              PTRATRM         pb_assoc_term
HR          8.0     PTRBDCA                 Form              PTRBDCL         pb_dedn_comb_lmt
                                                              PTRBDLG         pb_dedn_lmt_grp
            8.0     PTRBDCL                 Form              PTRBDCL         pb_dedn_comb_lmt
HR          8.0     PTRBDCL                 Form              PTRBDCL         pb_dedn_comb_lmt
HR          8.0     PTRFLAC                 Form              PTRSCHD         pb_fac_schrate
                                                              PTRSCLV         pb_fac_sclrate
HR          8.0     PTRFLCT                 Form              PTRFLCT         pb_fac_cntract
HR          8.0     PTRFLIC                 Form              PTRFLIC         pb_fac_incrate
HR          8.0     PTRNIST                 Form              PTRNILV         pb_fac_nilrate
                                                              PTRNIST         pb_fac_nisrate
HR         7.2.1    PTRROEC                 Form              PTRROEC         pt_roe_contact rules
HR          7.2     PTRSCRD                 Form              PTRSCRD         pb_stu_emp_cred
HR          7.2     PTRSTDE                 Form              PTRSTDE         pb_stu_deduction
HR         7.2.1    PXAMORE                 Form              PXRMROE         px_mass_roe
HR         7.2.1    PXAROEC                 Form              PXRROEC         px_record_of_employment




                                                   Page 119
                                    Programs Impacted by Banner APIs

                                                               Tables
                                                               Impacting the
Product   Release   Program Name             Program Type      Program         Associated APIs
HR         7.1.5    PXAW2CC                  Form              PXRW2CD         pb_w2_coded_info
                                                               PXRW2FD         pb_w2_federal
                                                               PXRW2ST         pb_w2_state
                                                               PXRW2LC         pb_w2_local
                                                                               pp_w2
HR          8.0     PXKB_W2_FEDERAL1         Package           PXRW2CD         pb_w2_coded_info
                                                               PXRW2LC         pb_w2_local
                                                               PXRW2ST         pb_w2_state
HR          8.0     PXKP_W2_20061            Package           PXRW2CD         pb_w2_coded_info
                                                               PXRW2LC         pb_w2_local
                                                               PXRW2ST         pb_w2_state
HR          8.0     PXKP_W2_20071            Package           PXRW2CD         pb_w2_coded_info
                                                               PXRW2LC         pb_w2_local
                                                               PXRW2ST         pb_w2_state
HR          8.0     PXKP_W21                 Package           PXRW2CD         pb_w2_coded_info
                                                               PXRW2LC         pb_w2_local
                                                               PXRW2ST         pb_w2_state
HR          8.0     PXKW2FD1                 Package           PXRW2CD         pb_w2_coded_info
HR         7.1.5    PXRW2US                  C/Cobol Program   PXRW2CD         pb_w2_coded_info
                                                               PXRW2FD         pb_w2_federal
                                                               PXRW2ST         pb_w2_state
                                                               PXRW2LC         pb_w2_local
                                                                               pp_w2
Intcomp     7.3     ICCHECK                  Script            GORICCR         gb_integ_config
Intcomp     7.3     ICGOKCOM                 Package           GORICCR         gb_integ_config
Intcomp     7.3     ICGORLDI                 C/Cobol Program   GORICCR         gb_integ_config
Intcomp     7.3     ICSCKCOM                 Package           GORICCR         gb_integ_config
Intcomp     7.3     ICSFKCOM                 Package           GORICCR         gb_integ_config
Intcomp     7.3     ICSFKGEX                 Package           GORICCR         gb_integ_config
Intcomp     7.3     ICSOKCOM                 Package           GORICCR         gb_integ_config
Intcomp     7.3     ICSPKCOM                 Package           GORICCR         gb_integ_config
Intcomp     7.2     ICSPKLDI                 Package           GORIROL         gb_institution_role
Intcomp     7.3     ICSSKCOM                 Package           GORICCR         gb_integ_config
Kiosk       7.0     ISRKBIL                  C/Cobol Program   TBRACCD         tb_receivable



                                                 Page 120
                                   Programs Impacted by Banner APIs

                                                              Tables
                                                              Impacting the
Product   Release   Program Name            Program Type      Program         Associated APIs
Kiosk       7.0     ISRKTRN                 C/Cobol Program   TBRACCD         tb_receivable
Student     8.0     BWCKCOMS                Package           SFRRMSG         sb_registration_msg
Student     7.0     BWSKALOG                Package           GOBTPAC         gb_third_party_access
Student     7.0     BWSKAPMT                Package           TBBMISC         tb_misc_header
                                                              TBRMISD         tb_misc_detail
Student     7.0     BWSKWCCP                Package           TBBMISC         tb_misc_header
                                                              TBRMISD         tb_misc_detail
Student     7.0     BWSKXMIS                Package           SGBSTDN         sb_learner
                                                              SORLCUR         sb_curriculum
                                                              SORLFOS         sb_fieldofstudy
Student     7.0     SAAADMS                 Form              TBRACCD         tb_receivable
                                                              SARADAP         sb_admissionsapplication
Student     7.0     SAADCBT                 Form              SARADAP         sb_admissionsapplication
                                                              SGBSTDN         sb_learner
Student     7.0     SAADCRV                 Form              SARADAP         sb_admissionsapplication
                                                              SGBSTDN         sb_learner
Student     7.3     SAADCRV                 Form              SORPCOL         gb_prior_college
Student     7.0     SAAEAPS                 Form              SPRIDEN         gb_identification
                                                                              gp_common_matching
Student     7.0     SAAQUIK                 Form              SPRIDEN         gb_identification
                                                              SARADAP         sb_admissionsapplication
                                                              SGBSTDN         sb_learner
                                                              SORLCUR         sb_curriculum
                                                              SORLFOS         sb_fieldofstudy
                                                              SRBRECR         sb_recruit
                                                              SPBPERS         gb_bio
                                                              SPRADDR         gb_address
                                                              SPRTELE         gb_telephone
                                                                              gp_common_matching
Student     7.0     SAARRAT                 Form              SARADAP         sb_admissionsapplication
Student     7.0     SAKCHKB                 Package           SARADAP         sb_admissionsapplication
Student     7.0     SAKL010                 Package           SARADAP         sb_admissionsapplication
                                                              SORLCUR         sb_curriculum
                                                              SORLFOS         sb_fieldofstudy



                                                   Page 121
                                   Programs Impacted by Banner APIs

                                                              Tables
                                                              Impacting the
Product   Release   Program Name            Program Type      Program         Associated APIs
Student     7.0     SAKL020                 Package           SPRIDEN         gb_identification
                                                              SPBPERS         gb_bio
Student     7.0     SAKL040                 Package           SPRADDR         gb_address
Student     7.0     SAKL045                 Package           GOREMAL         gb_email
Student     7.0     SAKL050                 Package           SPRTELE         gb_telephone
Student     7.3     SAKL080                 Package           SPRMEDI         gb_medical
Student     7.3     SAKL090                 Package           SORCONC         gb_pcol_concentration
                                                              SORDEGR         gb_pcol_degree
                                                              SORMAJR         gb_pcol_major
                                                              SORMINR         gb_pcol_minor
                                                              SORPCOL         gb_pcol
Student     7.0     SAKMODS                 Package           SPRIDEN         gb_identification
                                                              SGBSTDN         sb_learner
                                                              SARADAP         sb_admissionsapplication
                                                              SRBRECR         sb_recruit
                                                              SORLCUR         sb_curriculum
                                                              SORLFOS         sb_fieldofstudy
Student     7.0     SAKQADM                 Package           SARADAP         sb_admissionsapplication
                                                                              gp_common_matching
Student     7.0     SAPADMS                 C/Cobol Program   SARADAP         sb_admissionsapplication
Student     7.3     SAPADMS                 C/Cobol Program   SORCONC         gb_pcol_concentration
                                                              SORDEGR         gb_pcol_degree
                                                              SORMAJR         gb_pcol_major
                                                              SORMINR         gb_pcol_minor
                                                              SORPCOL         gb_pcol
Student     7.0     SAPAMAL                 C/Cobol Program   SPRIDEN         gb_identification
                                                              GOREMAL         gb_email
                                                              SPBPERS         gb_bio
                                                              SPRADDR         gb_address
                                                              SPRTELE         gb_telephone
                                                                              gp_common_matching
Student     7.3     SAPAMAL                 C/Cobol Program   SORDEGR         gb_pcol_degree
                                                              SORMAJR         gb_pcol_major
                                                              SORPCOL         gb_pcol



                                                Page 122
                                   Programs Impacted by Banner APIs

                                                              Tables
                                                              Impacting the
Product   Release   Program Name            Program Type      Program       Associated APIs
Student     7.0     SARETMT                 C/Cobol Program   SPRIDEN       gb_identification
                                                                            gp_common_matching
Student    7.3.1    SB_PESCXML_TESTS_IMP    Package           SORTEST       sb_testscore
Student     7.0     SCABASE                 Form              SCBCRSE       sb_course
Student     7.2     SCABASE                 Form              SCRINTG       sb_catlg_int_partner
Student     8.0     SCABASE                 Form              SCRRATT       sb_crse_atts_restriction
                                                              SCRRCHR       sb_crse_chrt_restriction
                                                              SCRRDEP       sb_crse_dept_restriction
Student     8.0     SCACLBD                 Form              SCRCLBD       sb_course_labor
Student     7.0     SCACRSE                 Form              SCBCRSE       sb_course
Student     7.2     SCADETL                 Form              SCRINTG       sb_catlg_int_partner
Student     7.0     SCAPREQ                 Form              SCBCRSE       sb_course
Student     8.0     SCARRES                 Form              SCRRATT       sb_crse_atts_restriction
                                                              SCRRCHR       sb_crse_chrt_restriction
                                                              SCRRDEP       sb_crse_dept_restriction
Student     7.2     SFAEPRT                 Form              SFRENPO       sb_enroll_ver_payment
                                                              SFRENSS       sb_enroll_ver_service
Student     8.1     SFAMREG                 Form              SGRSPRT       sb_athletic_compliance
Student     7.0     SFAREGS                 Form              SGBSTDN       sb_learner
Student     8.0     SFARMSG                 Form              SFRRMSG       sb_registration_msg
Student     7.0     SFAWDRL                 Form              TBRACCD       tb_receivable
Student     8.0     SFIWLNT                 Form              SFRWLNT       sb_wl_notification
Student     8.0     SFKCURS                 Package           SFRRMSG       sb_registration_msg
Student     8.0     SFKEDIT                 Package           SFRRMSG       sb_registration_msg
Student     7.0     SFKFEES                 Package           TBRACCD       tb_receivable
Student     7.0     SFKMODS                 Package           TBRACCD       tb_receivable
Student     8.0     SFKMODS                 Package           SFRRMSG       sb_registration_msg
Student     8.0     SFKPREQ                 Package           SFRRMSG       sb_registration_msg




                                                   Page 123
                                   Programs Impacted by Banner APIs

                                                              Tables
                                                              Impacting the
Product   Release   Program Name            Program Type      Program         Associated APIs
Student     8.0     SFKWLAT                 Package           SOBWLTC         sb_wl_term_control
                                                              SOBCSPR         sb_crse_select_pri
                                                              SOBEXCR         sb_wl_exclusion
                                                              SOBROPR         sb_wl_reordering
                                                              SSBWLSC         sb_wl_section_ctrl
                                                              SFRCOLW         sb_wl_collector
                                                              SFRWLNT         sb_wl_notification
Student     7.0     SFPFREQ                 C/Cobol Program   SSBSECT         sb_section
Student     7.0     SFPWAIT                 C/Cobol Program   SSBSECT         sb_section
Student     8.0     SFPWAIT                 C/Cobol Program   SFRCOLW         sb_wl_collector
                                                              SFRWLNT         sb_wl_notification
Student     7.0     SFRRNOP                 C/Cobol Program   TBRACCD         sb_receivable
                                                              SSBSECT         sb_section
Student     8.1     SGAAPRG                 Form              SGBAPRG         sb_athletic_acad_prog
                                                              SGBDCPR         sb_athletic_degc_comp
Student     8.1     SGAMSPT                 Form              SGRSPRT         sb_athletic_compliance
Student     8.1     SGASPRT                 Form              SGRATAD         sb_athletic_admissions
                                                              SGRATCT         sb_athletic_comments
                                                              SGRATHA         sb_athletic_attributes
                                                              SGRATHC         sb_athletic_competition
                                                              SGRATHE         sb_athletic_eligibility
                                                              SGRATHT         sb_athletic_transfer
                                                              SGRSPRT         sb_athletic_compliance
Student     7.0     SGASTDN                 Form              SGBSTDN
Student     8.1     SGISPRT                 Form              SGRATHC         sb_athletic_competition
Student     7.0     SGPBLCK                 C/Cobol Program   SGBSTDN         sb_learner
Student     7.0     SGPHOLD                 C/Cobol Program   SPRHOLD         gb_hold
Student     7.0     SGPSTDN                 C/Cobol Program   SGBSTDN         sb_learner
                                                              SORLCUR         sb_curriculum
                                                              SPRHOLD         gb_hold




                                                   Page 124
                                   Programs Impacted by Banner APIs

                                                              Tables
                                                              Impacting the
Product   Release   Program Name            Program Type      Program         Associated APIs
Student     7.3     SGPSTDN                 C/Cobol Program   SORCONC         gb_pcol_concentration
                                                              SORDEGR         gb_pcol_degree
                                                              SORMAJR         gb_pcol_major
                                                              SORMINR         gb_pcol_minor
                                                              SORPCOL         gb_pcol
Student    7.3.1    SGPSTDN                 C/Cobol Program   SORTEST         sb_testscore
                                                              SORHSCH         sb_highschool
Student     7.0     SHACATT                 Form              TBRACCD         tb_receivable
Student     7.0     SHADEGR                 Form              SHRDGMR         sb_learneroutcome
                                                              TBRACCD         tb_receivable
Student     7.0     SHADGMR                 Form              SHRDGMR         sb_learneroutcome
                                                              SORLCUR         sb_curriculum
                                                              SORLFOS         sb_fieldofstudy
Student     7.0     SHADIPL                 Form              TBRACCD         tb_receivable
Student     7.0     SHAEDIS                 Form              SPRIDEN         gp_common_matching
Student     7.3     SHAEDIS                 Form              SORPCOL         gb_pc
                                                              SHBHEAD         sb_pescxml_trandata_imp
Student     8.0     SHAGADR                 Form              SHBGADR         sb_gradapp_displayrule
                                                              SHRGADA         sb_gradapp_graddate
                                                              SHRGAPO         sb_gradapp_paymentopts
Student     8.0     SHAGADS                 Form              SHBGADS         sb_gradapp_selrule
Student     8.0     SHAGAPP                 Form              SHBGAPP         sb_gradapp
Student     8.0     SHAGELR                 Form              SHBGELR         sb_gradapp_eligible
Student     8.0     SHAINCG                 Form              SHRINCG         sb_incmp_grading
Student     7.0     SHAMCAT                 Form              SHRDGMR         sb_learneroutcome
                                                              TBRACCD         tb_receivable
Student     7.0     SHAMDEG                 Form              SHRDGMR         sb_learneroutcome
                                                              TBRACCD         tb_receivable
Student     7.0     SHAMDIP                 Form              SHRDGMR         sb_learneroutcome
                                                              TBRACCD         tb_receivable
Student     7.2     SHARQTC                 Form              SHTTRNM         sb_transcript_req_name
Student     8.0     SHATATC                 Form              SHBTATC         sb_transfer_crse
                                                              SHRTCAT         sb_transfer_crse_attr
                                                              SHRTCMT         sb_transfer_crse_cmt



                                                   Page 125
                                   Programs Impacted by Banner APIs

                                                              Tables
                                                              Impacting the
Product   Release   Program Name            Program Type      Program         Associated APIs
Student     8.0     SHATATR                 Form              SHBTATC         sb_transfer_crse
                                                              SHRTCAT         sb_transfer_crse_attr
                                                              SHRTCMT         sb_transfer_crse_cmt
                                                              SHRTATC         sb_transfer_equiv
                                                              SHRTRAT         sb_transfer_equiv_attr
                                                              SHRICMT         sb_transfer_equiv_cmt
Student     7.2     SHATPRT                 Form              SHRTRNM         sb_transcript_name
Student     8.0     SHKINCG                 Package           SHRINCG         sb_incmp_grading
Student     7.0     SHKMODS                 Package           SHRDGMR         sb_learneroutcome
                                                              SORLCUR         sb_curriculum
                                                              SORLFOS         sb_fieldofstudy
Student     7.0     SHKWEV1                 Package           SPRHOLD         gb_hold
Student     7.0     SHRDEGS                 C/Cobol Program   SGBSTDN         sb_learner
                                                              SHRDGMR         sb_learneroutcome
                                                              SORLCUR         sb_curriculum
                                                              SORLFOS         sb_fieldofstudy
Student     7.0     SHREDIY                 C/Cobol Program   TBRACCD         tb_receivable
Student     7.3     SHRPESE                 Java              SHREPTD         sb_pesc_status_export
Student     7.3     SHRPESI                 Java              SHRSUMS         sb_edi_acad_sess_sum
                                                              SHRASES         sb_edi_acad_session
                                                              SHRSUMA         sb_edi_acad_summ
                                                              SHRAUDE         sb_edi_acrec_ude
                                                              SHRCRSR         sb_edi_course
                                                              SHRHDR4         sb_edi_doc_header
                                                              SHBHEAD         sb_edi_header
                                                              SHRIDEN         sb_edi_identification
                                                              SHRMEDI         sb_edi_medical
                                                              SHREDIS         sb_edi_status
                                                              SHRSUDE         sb_edi_stud_ude
                                                              SHRSTST         sb_edi_subtest
                                                              SHRSTSC         sb_edi_subtest_score
                                                              SHRTEST         sb_edi_test
                                                              SHRTUDE         sb_edi_trans_ude
                                                              SHRIPTD         sb_pesc_status_imp



                                                Page 126
                                   Programs Impacted by Banner APIs

                                                              Tables
                                                              Impacting the
Product   Release   Program Name            Program Type      Program       Associated APIs
Student    7.3.2    SHRPESI                 Java              SHRIMMU       sb_edi_immunization
Student     8.0     SHRTCIM                 Java              SHBTATC       sb_transfer_crse
                                                                            sb_transfer_crse_attr
Student     7.2     SHRTRNS                 Form              SHRTRNS       sb_transcript_name_source
Student     7.0     SHRTRTC                 C/Cobol Program   TBRACCD       tb_receivable
Student     7.0     SHRTYPE                 C/Cobol Program   SGBSTDN       sb_learner
                                                              SHRDGMR       sb_learneroutcome
                                                              SORLCUR       sb_curriculum
                                                              SORLFOS       sb_fieldofstudy
Student     7.0     SIAASGN                 Form              SIRASGN       sb_facassignment
                                                              SIBINST       sb_faculty
Student     7.3     SIAFDEG                 Form              SORCONC       gb_pcol_concentration
                                                              SORDEGR       gb_pcol_degree
                                                              SORMAJR       gb_pcol_major
                                                              SORMINR       gb_pcol_minor
                                                              SORPCOL       gb_pcol
Student     7.0     SIAINST                 Form              SIBINST       sb_faculty
Student     7.0     SIPASGN                 C/Cobol Program   SIRASGN       sb_facassignment
Student     7.0     SLABLDG                 Form              SLBBLDG       gb_bldgdefinition
Student     7.0     SLAEVNT                 Form              SSRMEET       gb_classtimes
Student     7.0     SLAMASG                 Form              TBRACCD       tb_receivable
                                                              SLRMASG       sb_mealassignment
Student     7.0     SLAPASG                 Form              TBRACCD       tb_receivable
                                                              SLRPASG       sb_phoneassignment
Student     7.0     SLARASG                 Form              TBRACCD       tb_receivable
                                                              SLRRASG       gb_roomassignment
Student     7.0     SLARDEF                 Form              SLBRDEF       gb_roomdefinition
Student     7.0     SLARMAP                 Form              SPBPERS       gb_bio
                                                              SLBRMAP       sb_roompreference
Student     7.0     SLARMAT                 Form              SLRRMAT       sb_roommate
Student     7.0     SLKMOD1                 Package           SLRRASG       gb_roomassignment
                                                              SLRPASG       sb_phoneassignment
                                                              SLRMASG       sb_mealassignment




                                                   Page 127
                                   Programs Impacted by Banner APIs

                                                              Tables
                                                              Impacting the
Product   Release   Program Name            Program Type      Program         Associated APIs
Student     7.0     SLPHOUS                 C/Cobol Program   SLRRMAT         sb_roommate
                                                              SLBRMAP         sb_roompreference
                                                              SLRRASG         gb_roomassignment
                                                              SLRPASG         sb_phoneassignment
                                                              SLRMASG         sb_mealassignment
Student     7.0     SLRDADD                 C/Cobol Program   SPRADDR         gb_address
                                                              SPRTELE         gb_telephone
Student     7.0     SLRFASM                 C/Cobol Program   TBRACCD         tb_receivable
                                                              SLRRASG         gb_roomassignment
                                                              SLRPASG         sb_phoneassignment
                                                              SLRMASG         sb_mealassignment
Student     7.0     SLRROLL                 C/Cobol Program   SLRRASG         gb_roomassignment
                                                              SLRPASG         sb_phoneassignment
                                                              SLRMASG         sb_mealassignment
Student     7.0     SLRSCHD                 C/Cobol Program   SLRRASG         gb_roomassignment
Student     7.0     SMACACT                 Form              TBRACCD         tb_receivable
Student     7.0     SMARQCM                 Form              TBRACCD         tb_receivable
                                                              SMRRQCM         sb_curriculum
                                                              SORLCUR         gb_common
                                                              SORLMJR
Student     7.0     SOACTRL                 Form              SOBLMOD         sb_learnermodule
Student     7.2     SOACTRL                 Form              SORLMFS         sb_fieldofstudy_allowed
Student     7.0     SOAHOLD                 Form              SPRHOLD         gb_hold
Student     7.0     SOAHSCH                 Form              SARADAP         sb_admissionsapplication
Student    7.3.1    SOAHSCH                 Form              SORHSCH         sb_highschool
Student     8.0     SOAMAUD                 Form              SOBMAUD         sb_mass_entry_form
                                                              SORMECL         sb_mass_entry_column
                                                              SORMAUD         sb_mass_entry
Student     7.0     SOAPCOL                 Form              SARADAP         sb_admissionsapplication
Student     7.3     SOAPCOL                 Form              SORCONC         gb_pcol_concentration
                                                              SORDEGR         gb_pcol_degree
                                                              SORMAJR         gb_pcol_major
                                                              SORMINR         gb_pcol_minor
                                                              SORPCOL         gb_pcol



                                                   Page 128
                                   Programs Impacted by Banner APIs

                                                              Tables
                                                              Impacting the
Product   Release   Program Name            Program Type      Program         Associated APIs
Student     7.3     SOASBGI                 Form              SOBSBGI         NA
Student     7.0     SOATERM                 Form              SOBTERM         sb_term
Student     7.0     SOATEST                 Form              SARADAP         sb_admissionsapplication
Student     7.2     SOATEST                 Form              SORTSPC         sb_test_percentile
Student    7.3.1    SOATEST                 Form              SORTEST         sb_testscore
Student     8.0     SOAWLTC                 Form              SOBWLTC         sb_wl_term_control
                                                              SOBCSPR         sb_crse_select_pri
                                                              SOBROPR         sb_wl_reordering
                                                              SOBEXCR         sb_wl_exclusion
Student    7.3.1    SOIHCUR                 Form              SORHCUR         sb_curriculum_history
                                                              SORHFOS         sb_fieldofstudy_archive
Student     7.0     SOKLCUR                 Package           SORLCUR         sb_curriculum
                                                              SORLFOS         sb_fieldofstudy
Student     8.0     SOKMAUD                 Package           SGRATHA         sb_athletic_attributes
                                                              SGRATHC         sb_athletic_competition
                                                              SGRSPRT         sb_athletic_complaince
                                                              SORMAUD         sb_mass_entry
                                                              SORMECL         sb_mass_entry_column
                                                              SOBMAUD         sb_mass_entry_form
Student    7.3.1    SOPLCPG                 C/Cobol Program   SORHCUR         sb_curriculum_history
                                                              SORHFOS         sb_fieldofstudy_archive
Student     8.0     SOPMAUD                 C/Cobol Program   SORMAUD         sb_mass_entry
Student     8.0     SOQMLIB                 Form Library      SGRSPRT         sb_athletic_compliance
                                                              SOBMAUD         sb_mass_entry_form
                                                              SORMECL         sb_mass_entry_column
                                                              SORMAUD         sb_mass_entry
Student     7.0     SOQOLIB                 Form              SORLCUR         sb_curriculum
                                                              SORLFOS         sb_fieldofstudy
Student    7.3.1    SORCLDF                 Form              SORCLDF         sb_curriculum_default
Student    7.3.1    SORCSTS                 Form              SORCSTS         sb_curriculum_status_event
            7.1     SORDLIM                 Form              SORDLIM         sb_datafile_delimiter
Student     7.0     SPAEMRG                 Form              SPREMRG         gb_emergency_contact




                                                   Page 129
                                   Programs Impacted by Banner APIs

                                                              Tables
                                                              Impacting the
Product   Release   Program Name            Program Type      Program         Associated APIs
Student     7.0     SPAIDEN                 Form              SPRIDEN         gb_identification
                                                              SPBPERS         gb_bio
                                                              SPRADDR         gb_address
                                                              SPRTELE         gb_telephone
                                                              GOREMAL         gb_email
                                                              SPREMRG         gb_emergency_contact
                                                                              gp_common_matching
Student     7.0     SPAPERS                 Form              SPBPERS         gb_bio
Student     7.0     SPATELE                 Form              SPRTELE         gb_telephone
Student     7.0     SRAQUIK                 Form              SPRIDEN         gb_identification
                                                              SPBPERS         gb_bio
                                                              SPRADDR         gb_address
                                                              SPRTELE         gb_telephone
                                                                              gp_common_matching
Student     7.3     SRAQUIK                 Form              SORCONC         gb_pcol_concentration
                                                              SORDEGR         gb_pcol_degree
                                                              SORMAJR         gb_pcol_major
                                                              SORMINR         gb_pcol_minor
                                                              SORPCOL         gb_pcol
Student    7.3.1    SRAQUIK                 Form              SORHSCH         sb_highschool
Student     7.0     SRARECR                 Form              SRBRECR         sb_recruit
                                                              SORLCUR         sb_curriculum
                                                              SORLMJR         sb_fieldofstudy
                                                                              sb_learnercurricstatus
Student     7.1     SRATPTS                 Form              SRRTPTS         sb_datafile_test_score
Student     7.0     SRKPREL                 Package           SPRIDEN         gb_identification
                                                              GOREMAL         gb_email
                                                              SPBPERS         gb_bio
                                                              SPRADDR         gb_address
                                                              SPRTELE         gb_telephone
                                                              SRBRECR         sb_recruit
Student     7.3     SRKPREL                 Package           SORDEGR         gb_pcol_degree
                                                              SORPCOL         gb_pcol
Student    7.3.1    SRKTEST                 Package           SORTEST         sb_testscore



                                                   Page 130
                                   Programs Impacted by Banner APIs

                                                              Tables
                                                              Impacting the
Product   Release   Program Name            Program Type      Program         Associated APIs
Student     7.0     SRRINQR                 C/Cobol Program   SRBRECR         sb_recruit
                                                              SORLMJR         sb_curriculum
                                                              SORLCUR         gb_pcol_major
                                                                              gb_pcol_minor
                                                                              gb_pcol_degree
                                                                              gb_pcol_college
                                                                              gb_pcol_concentration
Student     7.3     SRRINQR                 C/Cobol Program   SORCONC         gb_pcol_concentration
                                                              SORDEGR         gb_pcol_degree
                                                              SORMAJR         gb_pcol_major
                                                              SORMINR         gb_pcol_minor
                                                              SORPCOL         gb_pcol
Student    7.3.1    SRRINQR                 C/Cobol Program   SORTEST         sb_testscore
                                                              SORHSCH         sb_highschool
Student     7.0     SRRSRIN                 C/Cobol Program   SPRIDEN         gp_common_matching
Student     7.0     SSAACCL                 Form              SSBSECT         sb_section
Student     8.0     SSACLBD                 Form              SSRCLBD         sb_section_labor
Student     7.3     SSADCRV                 Form              SORDEGR         gb_pcol_degree
Student     8.0     SSARRES                 Form              SSRRATT         sb_sect_atts_restriction
                                                              SSRRCHR         sb_sect_chrt_restriction
                                                              SSRRDEP         sb_sect_dept_restriction
Student     7.0     SSASECT                 Form              SSBSECT         sb_section
                                                              SIRASGN         sb_facassignment
                                                              SOBTERM         sb_term
                                                              SSRMEET         gb_classtimes
Student     8.0     SSASECT                 Form              SCRRATT         sb_crse_atts_restriction
                                                              SCRRCHR         sb_crse_chrt_restriction
                                                              SCRRDEP         sb_crse_dept_restriction
                                                              SSRRATT         sb_sect_atts_restriction
                                                              SSRRCHR         sb_sect_chrt_restriction
                                                              SSRRDEP         sb_sect_dept_restriction
Student     8.0     SSAWLSC                 Form              SSBWLSC         sb_wl_section_ctrl
Student     7.0     SSKMODS                 Package           SSBSECT         sb_section




                                                   Page 131
                                   Programs Impacted by Banner APIs

                                                              Tables
                                                              Impacting the
Product   Release   Program Name            Program Type      Program         Associated APIs
Student     7.0     SSPSCHD                 C/Cobol Program   SSBSECT         sb_section
                                                              SIRASGN         sb_facassignment
                                                              SSRMEET         gb_classtimes
Student     8.0     SSPSCHD                 C/Cobol Program   SSRCLBD         sb_section_labor
                                                              SSRRATT         sb_sect_atts_restriction
                                                              SSRRCHR         sb_sect_chrt_restriction
                                                              SSRRDEP         sb_sect_dept_restriction
Student     7.0     SSRROLL                 C/Cobol Program   SSBSECT         sb_section
                                                              SIRASGN         sb_facassignment
                                                              SOBTERM         sb_term
                                                              SSRMEET         gb_classtimes
Student     8.0     SSRROLL                 C/Cobol Program   SSRCLBD         sb_section_labor
                                                              SSRRATT         sb_crse_atts_restriction
                                                              SSRRCHR         sb_crse_chrt_restriction
                                                              SSRRDEP         sb_crse_dept_restriction
                                                              SSRRATT         sb_sect_atts_restriction
                                                              SSRRCHR         sb_sect_chrt_restriction
                                                              SSRRDEP         sb_sect_dept_restriction
Student     7.0     SSRSCMT                 C/Cobol Program   SSRMEET         gb_classtimes
Student     7.3     STVSGBI                 Form              GUBINST         sb_pescxml_trandata_exp
                                                              STVSGBI




                                                Page 132
                                   Programs Impacted by Banner APIs

                                                           Tables
                                                           Impacting the
Product   Release   Program Name            Program Type   Program       Associated APIs




                                                Page 133
    Revision History: APIs by Product                                       Revision History: Impacted Programs

    February 12, 2004: Version 1.0 (Initial Version)                        February 12, 2004: Version 1.0 (Initial Version)

    March 19, 2004: Version 1.1                                             March 19, 2004: Version 1.1
1   Removed the following entries:                                      1   Removed the following APIs and associated programs:
    pdrbded, pdrdedn (HR)                                                   pdrbded, pdrdedn (HR)
    sfrstcr, sfrareg, sfrstca (Student)                                     sfrstcr, sfrareg, sfrstca (Student)
2   Associated the table TBRDEPO for Business Entity Deposits           2   Both tsrcbil and tsrtbil should mention both TBRACCD and TBRDEPO
3   Removed the item 'comments' for the Customer Profile API ( tbbcprf) 3   TSASPAY should also mention TBRDEPO
                                                                        4   Removed TFAMUNA, TFIAREV, TSAMUNA, TSIQACT, FRAAREV,
                                                                            RSIAREV for programs impacted by tbraccd

    July 1, 2004: Version 2.0                                               July 1, 2004: Version 2.0
1   Added APIs created for Common Matching and New VBS Using           1    Added impacted programs for APIs created for Common Matching and
    FGAC ( Fine-Grained Access Control)                                     new VBS Using FGAC ( Fine-Grained Access Control)
2   Renamed worksheet                                                  2    Multiple revisions based on refining impact analysis and correcting initial
                                                                            spreadsheet information
3   Corrected Business entity name for the slbrmap api

    February 18, 2005: Version 3.0                                          February 18, 2005: Version 3.0
1   Added API names, main source names, and release information        1    Added release numbers

    June 24, 2005: Version 4.0                                              June 24, 2005: Version 4.0
1   Added Banner HR 7.3 APIs                                           1    Added impacted programs for Banner HR 7.3 APIs
2   Added Banner General 7.2 and 7.3 APIs                              2    Added impacted programs for Banner General 7.2 and 7.3 APIs
3   Added Banner AR 7.1 and 7.2 APIs                                   3    Added impacted programs for Banner AR 7.1and 7.2 APIs
4   Added Banner Finance 7.1 APIs                                      4    Added impacted programs for Banner Finance 7.1 APIs
5   Added Banner Student 7.1, 7.2, and 7.3 APIs                        5    Added impacted programs for Banner Student 7.1, 7.2, and 7.3 APIs
6   Added Banner Financial Aid 7.0 and 7.3.1 APIs                      6    Added impacted programs for Banner Financial Aid 7.0 and 7.3.1 APIs

    July 29, 2005: Version 5.0                                              July 29, 2005: Version 5.0
1   Added Banner Student 7.2 API                                       1    Added impacted programs Banner Student 7.2 API
2   Added Banner General 7.2 API                                       2    Added impacted programs for Banner General 7.2 API
3   Corrected "rb_cod_identification" to "rb_cod_identifier"

    September 9, 2005: Version 6.0                                          September 9, 2005: Version 6.0
1   Added Banner General 7.2 APIs                                      1    Added impacted programs for Banner General 7.2 APIs
    Revision History: APIs by Product                            Revision History: Impacted Programs

    August 11, 2006: Version 7.0                                 August 11, 2006: Version 7.0
1   Consolidated format of spreadsheet.                      1   Added impacted programs Banner Student 7.1.1, 7.3, and 7.3.1 APIs
2   Added Banner Student 7.1.1, 7.3, and 7.3.1 APIs          2   Added impacted programs for Banner General 7.1.1, 7.3, and 7.3.1 APIs
3   Added Banner General APIs 7.1.1, 7.3, and 7.3.1 APIs     3   Added impacted programs for Banner HR 7.1.5 APIs
4   Added Banner HR 7.1.5 APIs                               4   Added impacted programs for Banner Finance 7.2 APIs
5   Added Banner Finance 7.2 APIs                            5   Added impacted programs for Banner AR 7.1.1 and 7.3 APIs
6   Added Banner AR 7.1.1 and 7.3 APIs                       6   Removed programs delayed to a future release
7   Added missing APIs                                       7   Added missing programs
8   Updated information throughout                           8   Updated information throughout

    September 11, 2006: Version 8.0                              September 11, 2006: Version 8.0
1   Added Banner HR 7.2.1 APIs                               1   Added impacted programs for Banner HR 7.2.1 APIs

    October 30, 2006: Version 9.0                                October 30, 2006: Version 9.0
1   Changed information about sb_fieldofstudy_archive        1   Changed name of sb_fieldofstudy_archive
2   Added Banner Student 7.3.1 APIs                          2   Added impacted programs for Banner Student 7.3.1 APIs

    December 6, 2006: Version 10.0                               December 6, 2006: Version 10.0
1   Added Banner General 7.4 APIs                            1   Added impacted programs for Banner General 7.4 APIs
2   Added integration dependencies for gb_institution_role   2   Changed product for isrkbil and isrktrn from Banner IntComp to Kiosk

    March 7, 2007: Version 11.0                                  March 7, 2007: Version 11.0
1   Added Banner Advancement 7.4 APIs                        1   Added impacted programs for Banner Advancement 7.4 APIs
2   Added Banner Finance 7.3 APIs                            2   Added impacted programs for Banner Finance 7.3 APIs
3   Added Banner Student 7.3.2 API                           3   Added impacted programs for Banner Student 7.3.2 API

    April 25, 2007: Version 12.0                                 April 25, 2007: Version 12.0
1   Added Banner Financial Aid 7.8 APIs                      1   Added impacted programs for Banner Financial Aid 7.8 APIs
2   Added affected tables for rp_requirement                 2   Updated impacted programs for Banner Financial Aid 7.3.1 APIs

    October 27, 2008: Version 13.0                               October 27, 2008: Version 13.0
1   Added Banner 8.0 APIs                                    1   Added impacted programs for Banner 8.0 APIs
2   Added missing APIs delivered in earlier releases         2   Added impacted programs for missing APIs delivered in earlier releases

    January 16, 2009: Version 14.0                               January 16, 2009: Version 14.0
1   Added Advancement 8.1 APIs                               1   Added impacted programs for Banner Advancement 8.1 APIs
2   Added Finance 8.2 APIs                                   2   Added impacted programs for Banner Finance 8.2 APIs
3   Added HR 8.1 APIs                                        3   Added impacted programs for Banner HR 8.1 APIs
    Revision History: APIs by Product       Revision History: Impacted Programs
4   Added Student 8.1 APIs              4   Added impacted programs for Banner Student 8.1 APIs

								
To top