EDI Cross-Reference Rules (SOAXREF) page

This page is used to define valid values for incoming EDI or electronic (XML) data and the equivalent Banner® values.

It also serves as the source of the values for the pulldown lists which appear on the Web application. Rules entered here are used in electronic and Web data loads to validate incoming data and to translate EDI values into the appropriate Banner values.

EDI equivalents on Banner validation forms (for example, on STVSTAT) are used only when extracting data from Banner for transmission by EDI. In some instances, a single Banner value may be associated with a number of EDI values, or an EDI qualifier may further define the associated data value.

An example is college codes. In EDI transmissions, colleges are identified by both a qualifier and a code value. A college can be identified by FICE code or ETS code (and also a number of other coding sets), and both the qualifier (FICE or ETS) and the appropriate college code within the set are transmitted. In this example, two entire sets of Banner college codes would be defined, one for FICE and one for ETS, and each line of cross-reference rules would contain the appropriate qualifier.

In other instances, there is a one-to-one correspondence between EDI and Banner codes. For example, there is a single EDI code for each nation. In these instances, there would be a single cross-reference rule for each EDI nation code, and these rules would not contain a qualifier.

Use the List function for the Banner Value field to search the Banner validation table and exit with a value.

Use the Web search tool for High Schools and Colleges that pulls data from SOASBGI. The school search consists of three parts. The first step is to select the state/province or country in which the school exists; the second is to select the city; and the third is to select the school itself.

If no values exist on SOAXREF for a particular validation table (for example the legacy code from STVLGCY), the source of the pull down on the Web application will be the Banner validation table itself (in this case, STVLGCY). This also applies to the Web page pull down population logic and to the verification of the electronic application and push processes.

This page is not required if the you are not running the TS 189 Upload to Banner (SAR189U), and you want all values on all applicable validation tables to display on the Web.

Fields Descriptions
XML Check box used to indicate whether the EDI verification label code in the Label field is a PESC/XML standard code.