This section contains parameter detail and output samples for three new Banner Student processes.
Note
System locale variables must be set to UTF-8 for Unicode compatibility (e.g.,
LANG=en_US.UTF-8), because the .csv files that are generated by the provisioning
processes (SRRRVAL and SRRRPRO) contain a Byte Order Mark at the beginning of the file.
If you FTP these .csv files, it must be done in binary mode, as ASCII mode will corrupt the Byte Order Mark. Please refer to FAQ 1-3YSCJ8 for more information about Banner UTF-8
configuration.
Recruiter Prospect Provisioning Process (SRRRPRO)
Description The Recruiter Prospect Provisioning Process (SRRRPRO) is used to “provision” Recruiter with Banner prospects, for further processing in Recruiter.
Prospects are selected for provisioning if they have Banner recruit records (SRBRECR) for the specified term range, and they do not have any application records (SARADAP). If they have multiple recruit records for the term range, the record with the highest term is selected. The pool of prospects can be limited using a population selection, as long as the prospects have existing recruit records for the specified term range and do not have application records.
This process can be run during system implementation to capture the initial set of prospects and then periodically thereafter to capture new prospects that have been added in Banner (such as through financial aid date loads).
Multiple .csv files are created for a prospect. Besides the main prospect file, files containing prospect high schools, prior colleges, and interests are also generated.
This process extracts the Banner data into .csv files which can then be imported into the Recruiter system. The .csv files may be edited before the data is imported the data into Recruiter.
Note
You should be careful editing the .cvs files in spreadsheet format, as leading zeroes are
sometimes removed.
The process allows for the provisioning of distinct prefix and suffix values that exist for Banner prospects within the specified term range. Prefixes and suffixes are extracted into their own .csv files and should be imported into Recruiter before prospect data is imported, so that prefix and suffix validation errors do not occur in Recruiter when prospects are imported.
The .lis file generated by this process contains the Control Report as well as informational messages about prospects who are being provisioned. See the report sample that follows for examples of these messages.
Listed below are the .csv files created by this process, showing the Recruiter fields into which the data will be imported and the Banner fields from which the data was extracted.
.cvs file Recruiter Display Name Banner Data Field
ProvisionPrefix.csv Prefix Name SPBPERS_NAME_PREFIX
ProvisionSuffix.csv Suffix Name SPBPERS_NAME_SUFFIX
ProvisionProspect.csv SSN
Is this an International Address?
Address 1: Street 1 addresses only, otherwise Null SPRADDR_CITY
.cvs file Recruiter Display Name Banner Data Field
ProvisionProspect.csv (cont.) Address 1: Home Phone Value is Prospective Student SRBRECR_STYP_CODE SPBPERS_NAME_PREFIX SPBPERS_PREF_FIRST_NAME Value is Male, Female, or Null, based on SPBPERS_SEX
Value is Hispanic/Latino or Non-Hispanic/
Latino, based on SPBPERS_ETHN_CDE
.cvs file Recruiter Display Name Banner Data Field
Use the following parameters to run SRRRPRO.
Value is name of month, derived from SORDEGR_ATTEND_FROM
Value is four-digit year, derived from SORDEGR_ATTEND_FROM
Value is name of month, derived from SORDEGR_ATTEND_TO
Value is four-digit year, derived from SORDEGR_ATTEND_TO Value is name of month, derived from SORHSCH_GRADUATION_DATE Value is four-digit year, derived from SORHSCH_GRADUATION_DATE
.cvs file Recruiter Display Name Banner Data Field
Parameters Name Required? Description Values Start Term Yes Enter the start term to be used for provisioning the
prefix, suffix, and prospect information. The default is 999999.
If 999999 is entered, no data will be provisioned.
Term Code Validation Form (STVTERM)
End Term Yes Enter the end term to be used for provisioning the prefix, suffix, and prospect information. The default is 999999.
Term Code Validation Form (STVTERM)
Provision Prefix No Enter Y to create the ProvisionPrefix.csv file or leave Null to not create the file. The default is Null.
Y Create Prefix file Null Do not create file Provision Suffix No Enter Y to create the ProvisionSuffix.csv file
or leave Null to not create the file. The default is Null.
Y Create Suffix file Null Do not create file Provision Prospect No Enter Y to create the ProvisionProspect.csv
file or leave Null to not create the file. The default is Null.
Y Create Prospect file Null Do not create file Domestic Address
Nation Code
Yes Enter the nation code for the domestic address.
Multiple values can be entered.
Nation Code Validation Form (STVNATN)
Address Hierarchy Yes Enter the address priority and address type code associated with the prospect information, such as 1MA. Multiple values can be entered.
Address Type Code Validation Form (STVATYP)
Home Phone Hierarchy Yes Enter the home phone priority and phone type code associated with the prospect information, such as 1HO. Multiple values can be entered.
Telephone Type Validation Form (STVTELE)
Cell Phone Hierarchy Yes Enter the cell phone priority and phone type code associated with the prospect information, such as 1CELL. Multiple values can be entered.
Telephone Type Validation Form (STVTELE)
Email Hierarchy Yes Enter the email address priority and address type code associated with the prospect information, such as 1HOME. Multiple values can be entered.
E-mail Address Type Validation Form (GTVEMAL)
Include Confidential No Enter Y to include prospects whose information is flagged as confidential or leave Null to not include those records.
Y Include confidential prospects Null Do not include confidential
prospects Default Source Code Yes Enter the source/background institution code
associated with the prospect information.
Note: The code entered must have the Source Indicator checked on STVSBGI.
Source/Background Institution Code Validation Form (STVSBGI)
Interface Code Yes Enter the interface code that is associated with the STVPREL code being used for Recruiter.
Interface Validation Form (STVINFC)
Include if no academic program
No Enter Y to include prospects whose curriculum records have not been converted to academic program names on the Recruiter Integration Curriculum Crosswalk Form (SRARICC).
Note: When set to Y, any prospect for whom an academic program name cannot be found on SRARICC will be listed on the report, along with his/her curriculum data.
The institution may want to create a record on SRARICC for this curriculum and run SRRRPRO again, so the prospect's academic program is included in the data that will be imported into Recruiter.
Y Include prospects with no academic programs
Null Do not include prospects who have no academic programs
Parameters Name Required? Description Values
Application Code No Enter the code that identifies the general area for which the selection identifier was defined. All or none of the population selection parameters must be entered, with the exception of the User ID parameter.
The Population Selection Extract Inquiry Form (GLIEXTR) may be used to review the people who will be processed in the load from the selection identifier and application code entered.
Application Inquiry Form (GLIAPPL)
Selection ID No Enter the code that identifies the population with which you wish to work. The selection identifier must be defined on the Population Selection Inquiry Form (GLISLCT). All or none of the population selection parameters must be entered, with the exception of the User ID parameter.
Population Selection Inquiry Form (GLISLCT)
Creator ID No Enter the user ID of the person creating the sub-population rules. The creator ID must have been specified when defining the selection identifier. All or none of the population selection parameters must be entered, with the exception of the User ID parameter.
User ID No Enter the user ID for the population selection.
If this parameter is Null, and the above three parameters were entered, the process will use the Banner logon user ID.
Parameters Name Required? Description Values
Report Sample—Recruiter Prospect Provisioning Process (SRRRPRO)
06-MAR-2013 11:08:03 Banner University Page 1 SRRRPRO Recruiter Prospect Provision
ID Name Message --- --- --- A00156834 Smalley, Deborah No academic program exists for curriculum Levl:UG Coll:AS Degr:BA Majr:ARTH Prog:BA-ARTS High school GPA of 15.22 is not within 0.00-5.00 range.
A00156835 Harrison, Richard Non-numeric high school GPA: B+
College GPA of 14 is not within 0.00-5.00 range.
6-MAR-2013 11:08:03 Banner University Page 2 SRRRPRO Recruiter Prospect Provision
*** REPORT CONTROL INFORMATION - SRRRPRO - Release 8.5.7 ***
Start Term: 201310 End Term : 201340 Provision PREFIX: Y Provision SUFFIX: Y Provision PROSPECTS: Y
Domestic Address Nation Code: US Address Hierarchy: 1PR
Home Phone Hierarchy: 1PR Cell Phone Hierarchy: 1CELL Email Code Hierarchy: 1HOME Include Confidential: Y Default Source Code: 000004 Interface Code: R2B
Include if no Academic Program: Y Application Code: RECRUITING Selection ID : R2B_INTG Creator ID : SAISUSR User ID : SAISUSR
ProvisionPrefix.csv record count: 25 ProvisionSuffix.csv record count: 26 ProvisionProspect.csv record count: 3 ProvisionProspectInts.csv record count: 2 ProvisionProspectHS.csv record count: 7 ProvisionProspectColl.csv record count: 7
Recruiter Validation Provisioning Process (SRRRVAL)
Description The Recruiter Validation Provisioning Process (SRRRVAL) is used to “provision” Recruiter with validation codes from Banner. This ensures that the same validation codes are used in the Recruiter system as in Banner when possible.
This process can be run by a Banner institution that has newly installed the Recruiter system. (It can also be run if new validation values are added to Banner.) The process extracts Banner validation data into .csv files, which can then be imported into the Recruiter system using the standard CRM2011 import process. The .csv files may be edited before the data is imported the data.
Here are the .csv files created by this process, showing the Recruiter fields into which the data will be imported, the Banner fields from which the data was extracted, and the name of the related Recruiter entity.
Listed below are the .csv files created by this process, showing the Recruiter fields into which the data will be imported and the Banner fields from which the data was extracted.
.cvs file Recruiter Display Name Banner Data Field
ProvisionTerm.csv Abbreviation Name
STVTERM_CODE STVTERM_DESC ProvisionMrtlStatus.csv Abbreviation
Name
STVMRTL_CODE STVMRTL_DESC ProvisionVisaType.csv Abbreviation
Name
STVVTYP_CODE STVVTYP_DESC ProvisionLevel.csv Abbreviation
Name
STVLEVL_CODE STVLEVL_DESC ProvisionStudentType.csv Abbreviation
Name
STVSTYP_CODE STVSTYP_DESC ProvisionCitizenType.csv Abbreviation
Name
STVSTYP_CODE STVSTYP_DESC
ProvisionLanguage.csv Abbreviation Value is set as follows:
• Rejected if STVAPDC_REJECT_IND is Y
• Moved to Student if
STVAPDC_STDN_ACC_IND is Y
• Accepted if
STVAPDC_INST_ACC_IND is Y
• Applied if none of the above indicators has been set
Note: Special handling is needed for application status types of “withdrawn”. Recruiter has an application status category of “withdrawn”, and Banner does not. After these codes have been provisioned, you should manually change the category in Recruiter on any application statuses that designate “withdrawn”.
ProvisionPersonSource.csv Contains only records where STVSBGI_SRCE_IND is Y
Abbreviation Name
STVSBGI_CODE STVSBGI_DESC
.cvs file Recruiter Display Name Banner Data Field
ProvisionChklstCont.csv Abbreviation
Name
STVADMR_CODE and STVCTYP_CODE
• Codes from STVADMR are prefixed with ADMR
• Codes from STVCTYP are prefixed with CTYP
STVADMR_DESC and STVCTYP_DESC ProvisionFullPartTIme.csv Abbreviation
Name
Value is F or P
Value is Full Time or Part Time ProvisionEducatnGoal.csv Abbreviation
Name
STVEGOL_CODE STVEGOL_DESC
.cvs file Recruiter Display Name Banner Data Field
Use the following parameters to run SRRRVAL.
Contains only records where STVSBGI_TYPE_IND is H or C
Account Name
SOBCNVT_CONV_CODE for table SBGH, or STVSBGI_CODE, or Null, based on setting of the Are CEEB codes used on STVSBGI parameter (parameter 23) Value is No
Value is Yes if SOBSBGI_STAT_CODE is Not Null, otherwise No
Value is High School or College Value is Null addresses only, otherwise Null SOBSBGI_CITY
SOBCNVT_CONV_CODE for table STAT, or SOBSBGI_STAT_CODE
SOBSBGI_ZIP
SOBCNVT_CONV_CODE for table NATN, or SOBSBGI_NATN_CODE
Value is Yes or Null, based on SOBSBGI_NATN_CODE STVSBGI_CODE
.cvs file Recruiter Display Name Banner Data Field
Parameters Name Required? Description Values Provision from
STVTERM
Yes Enter the start term to be used to create the
ProvisionTerm.csv file. The default is 999999. Term Code Validation Form (STVTERM)
Provision from STVMRTL
No Enter Y to create the ProvisionMrtlStatus.csv file or leave Null to not create the file. The default is Null.
Y Create Marital Status file Null Do not create file Provision from
STVVTYP
No Enter Y to create the ProvisionVisaType.csv file or leave Null to not create the file. The default is Null.
Y Create Visa Type file Null Do not create file Provision from
STVLEVL
No Enter Y to create the ProvisionLevel.csv file or
leave Null to not create the file. The default is Null. Y Create Level file Null Do not create file Provision from
STVSTYP
No Enter Y to create the
ProvisionStudentType.csv file or leave Null to not create the file. The default is Null.
Y Create Student Type file Null Do not create file Provision from
STVCITZ
No Enter Y to create the
ProvisionCitizenType.csv file or leave Null to not create the file. The default is Null.
Y Create Citizen Type file Null Do not create file Provision from
STVBLDG
No Enter Y to create the ProvisionBuilding.csv file or leave Null to not create the file. The default is Null.
Y Create Building file Null Do not create file Provision from
STVLANG
No Enter Y to create the ProvisionLanguage.csv file or leave Null to not create the file. The default is Null.
Y Create Language file Null Do not create file Provision from
STVCAMP
No Enter Y to create the ProvisionCampus.csv file or leave Null to not create the file. The default is Null.
Y Create Campus file Null Do not create file
Provision from STVDISA
No Enter Y to create the ProvisionDisability.csv file or leave Null to not create the file. The default is Null.
Y Create Disability Type file Null Do not create file
Provision from STVRELG
No Enter Y to create the ProvisionReligion.csv file or leave Null to not create the file. The default is Null.
Y Create Religion file Null Do not create file Provision from
STVINTS
No Enter Y to create the ProvisionInterest.csv file or leave Null to not create the file. The default is Null.
Y Create Outside Interest file Null Do not create file
Provision from STVADMT
No Enter Y to create the
ProvisionAdmissnType.csv file or leave Null to not create the file. The default is Null.
Y Create Admission Type file Null Do not create file
Provision from STVAPDC
No Enter Y to create the
ProvisionAdmissnDcsn.csv file or leave Null to not create the file. The default is Null.
Y Create Admission Application Decision file
Null Do not create file Provision from
STVSBGI Source
No Enter Y to create the
ProvisionPersonSource.csv file or leave Null to not create the file. The default is Null.
Y Create Person Source/
Background Institution file Null Do not create file
Provision from
STVADMR/STVCTYP
No Enter Y to create the
ProvisionChklistCont.csv file or leave Null to not create the file. The default is Null.
Y Create Admissions Request Checklist and Contact Type file Null Do not create file
Provision FULLTIME/
PARTTIME
No Enter Y to create the
ProvisionFullPartTime.csv file or leave Null to not create the file. The default is Null.
Y Create Full-time/Part-time file Null Do not create file
Provision from STVEGOL
No Enter Y to create the
ProvisionEducatnGoal.csv file or leave Null to not create the file. The default is Null.
Y Create Education Goal file Null Do not create file
Parameters Name Required? Description Values
Provision from SRARRIC
No Enter Y to create the
ProvisionAcadProgram.csv file or leave Null to not create the file. The default is Null.
Y Create Academic Program file Null Do not create file
SRARRIC Start Date No Enter the start date for selection of the academic program.
Provision STVSBGI HS
& College
No Enter Y to create the
ProvisionInstitution.csv file or leave Null to not create the file. The default is Null.
Y Create Institution file Null Do not create file Max number of records
per file
No Enter the maximum number of records to be written to each high school/college file or leave Null to write all records to one file.
If a value is entered, each high school/college file will contain only that number of records, and subsequent file names will be generated with the next one-up number.
For example, the initial file will be named
ProvisionInstitutions.csv. The second file will be named ProvisionInstitutions2.csv, and so on.
Are CEEB codes used on STVSBGI
No Enter Y if the STVSBGI codes are valid CEEB codes
or N if they are not valid CEEB codes. Y Valid CEEB codes N Not valid CEEB codes Domestic Address
Nation Code
No Enter the nation code for domestic high school and college addresses. Multiple values can be entered.
Nation Code Validation Form (STVNATN)
Interface Code Yes Enter the interface code associated with the STVPREL code that is used with Recruiter.
Interface Validation Form (STVINFC)
Parameters Name Required? Description Values
Report Sample—Recruiter Validation Provisioning Process (SRRREVAL)
07-MAR-2013 13:53:05 Banner University PAGE 1 SRRRVAL Recruiter Validation Provision
*** REPORT CONTROL INFORMATION - SRRRVAL - Release 8.5.7 ***
Start Term: 201310
Provision from STVTERM term: 201310 Count: 8 Provision from STVMRTL: Y Count: 8 Provision from STVVTYP: Y Count: 18 Provision from STVLEVL: Y Count: 36 Provision from STVSTYP: Y Count: 15 Provision from STVCITZ: Y Count: 23 Provision from STVBLDG: Y Count: 100 Provision from STVLANG: Y Count: 13 Provision from STVCAMP: Y Count: 18 Provision from STVDISA: Y Count: 9 Provision from STVRELG: Y Count: 15 Provision from STVINTS: Y Count: 29 Provision from STVADMT: Y Count: 20 Provision from STVAPDC: Y Count: 24 Provision from STVSBGI Source: Y Count: 1,001 Provision from STVADMR/STVCTYP: Y Count: 56
07-MAR-2013 13:53:05 Banner University PAGE 2 SRRRVAL Recruiter Validation Provision
Provision FULLTIME/PARTTIME: Y Count: 2 Provision from STVEGOL: Y Count: 15
Provision from SRARICC: Y Start Date: 01-SEP-2012 Count: 152
Provision STVSGBI HS & College: Y Count: 15,124 Max number of records per file: 1000 CEEB codes used on STVSBGI: Y
Domestic Address Nation Code: US Interface Code: R2B
Recruiter Integration Curriculum Crosswalk Process (SRRRICC)
Description The Recruiter Integration Curriculum Crosswalk Process (SRRRICC) generates academic programs names from existing curriculum data using a rule defined on the Business Rules Form (GORRSQL).
A sample SQL statement is delivered as seed data for use on GORRSQL for the Process value (nnn) and the Rule value nnn_CURR_CROSSWALK, where nnn is the value you entered during installation. The SQL statement can be modified to fit your requirements.
The delivered statement uses existing curriculum data to derive academic program names and populate the Recruiter Integration Curriculum Crosswalk Table (SRBRICC). Each academic program name must be unique. If multiple curriculum records result in the same academic program name, only one is written to SRBRICC, and the
The delivered statement uses existing curriculum data to derive academic program names and populate the Recruiter Integration Curriculum Crosswalk Table (SRBRICC). Each academic program name must be unique. If multiple curriculum records result in the same academic program name, only one is written to SRBRICC, and the