Banner to Sunapsis data feed

Data feed from Banner to Sunapsis is handled with the job submission process GWPXIPO. This runs regularly from the gen-cron functional account and XML files that are generated are loaded by the Sunapsis system.

File generated has sections as indicated by the tables below. Field contents on the tables:

prsn_univ_id
XML Field Required? Banner Field Description Banner Field Notes
prsn_univ_id required Vnumber spriden_id  
associatedIdNumbers
XML Field Required? Banner Field Description Banner Field Notes
associatedIDNumbers optional Student ID spriden_id Old-format ID. Students starting Fall 2018 or later should not have this
associatedIDNumbers required PIDM - Banner internal ID spriden_pidm  
biographical
XML Field Required? Banner Field Description Banner Field Notes
prsn_prm_sfx_nm optional Name suffix spbpers_name_suffix  
prsn_prm_last_nm required Last Name spriden_last_name  
prsn_prm_1st_nm required First Name spriden_first_name  
prsn_prm_mid_nm optional Middle Name spriden_mi  
prsn_gndr_cd required Legal Sex spbpers_sex  
prsn_martl_stat_cd optional Marital Status spbpers_mrtl_code  
prsn_ofcl_res_cd optional NR hard-coded value  
prsn_birth_dt required Date of Birth spbpers_birth_date  
prsn_birth_plc_nm optional City of Birth spbpers_city_birth  
prsn_birth_cntry_cd optional Nation of birth gobintl_natn_code_birth  
prsn_other_email_id optional Personal Email (email type PERS) goremal_email_address  
prsn_gds_cmp_email_addr optional Official Email (email type OF) goremal_email_address  
prsn_ntwrk_id optional NetID - student if they have one, employee otherwise ATS_OPEN.username  
prsn_lcl_ln1_addr optional Dorm or Mailing address - line 1 spraddr_street_line1  
prsn_lcl_ln2_addr optional Dorm or Mailing address - line 2 spraddr_street_line2  
prsn_lcl_cty_nm optional Dorm or Mailing address - City spraddr_city  
prsn_lcl_st_cd optional Dorm or Mailing address - State spraddr_stat_code  
prsn_lcl_zip_cd optional Dorm or Mailing address - Zip spraddr_zip  
prsn_lcl_phn_nbr optional Phone number - Mailing Address sprtele_phone_area sprtele_phone_number  
prsn_lcl_subtype optional Address type - CH =  dorm MA = mailing spraddr_atyp_code  
prsn_frgn_cntry_cd optional Foreign address - country code spraddr_natn_code  
prsn_frgn_ln1_addr optional Foreign address - line 1 spraddr_street_line1  
prsn_frgn_ln2_addr optional Foreign address - line 2 spraddr_street_line2  
prsn_frgn_cty_nm optional Foreign address - city spraddr_city  
prsn_frgn_st_cd optional Foreign address - state spraddr_stat_code  
prsn_frgn_zip_cd optional Foreign address - zip spraddr_zip  
prsn_frgn_phn_nbr optional phone number - Foreign sprtele_phone_area sprtele_phone_number  
prsn_frgn_subtype optional Address type - PR spraddr_atyp_code  
prsn_hm_ln1_addr optional home address - line 1 spraddr_street_line1  
prsn_hm_ln2_addr optional home address - line 2 spraddr_street_line2  
prsn_hm_cty_nm optional home address - city spraddr_city  
prsn_hm_st_cd optional home address - state spraddr_stat_code  
prsn_hm_zip_cd optional home address - zip spraddr_zip  
prsn_hm_cntry_cd optional home address - country code spraddr_natn_code  
prsn_hm_phn_nbr optional phone number - home sprtele_phone_area sprtele_phone_number  
visaCitezenship
XML Field Required? Banner Field Description Banner Field Notes
prsn_ctzn_cntry_cd required Nation code - legal gobintl_natn_code_legal  
admission
XML Field Required? Banner Field Description Banner Field Notes
inst_cd, required   saradap_camp_code  
stu_admt_term_cd, required   saradap_term_code_entry  
acad_career_cd, required Student Level (UGRAD, GRAD, ND, LC, LA) saradap_levl_code Not a direct select - hard-coded translation (example: Banner UG to UGRAD)
appl_acad_lvl_cd,  required   saradap_levl_code saradap_program_1 saradap_program_2 Not a direct select - hard-coded translation
appl_pgm_stat_cd, optional application program status saradap_wrsn_code sarappd_apdc_code Not a direct select - hard-coded translation
acad_plan_cd, optional applicant major code saradap_majr_code_1  
acad_plan_desc, optional major code description stvmajr_desc  
cip_code, optional   stvmajr_cipc_code  
acad_pgm_cd, optional   saradap_program_1  
acad_grp_cd, optional   saradap_coll_code_1  
acad_deg_cd, optional   saradap_degc_code_1  
acad_dept_cd, optional   saradap_dept_code  
stu_admt_typ_cd, optional   saradap_styp_code  
appl_pgm_actn_cd, optional application decision sarappd_apdc_code Not a direct select - hard-coded translation
stu_admt_term_beg_dt, required Admit term start date stvterm_start_date  
stu_admt_term_end_dt, optional Admit term end date stvterm_end_date  
appl_pgm_actn_dt, optional application action date saradap_activity_date  
appl_plan_seq_nbr, optional 0 hard-coded value as per Lucy Jones email
appl_nbr, optional application number saradap_appl_no  
stu_hs_grad_dt, optional high school graduation date sorhsch_graduation_date  
stu_hs_sum_gpa_nbr optional high school GPA sorhsch_gpa  
programs
XML Field Required? Banner Field Description Banner Field Notes
        documentation not yet written
terms
XML Field Required? Banner Field Description Banner Field Notes
        documentation not yet written
courses
XML Field Required? Banner Field Description Banner Field Notes
        documentation not yet written
saa
XML Field Required? Banner Field Description Banner Field Notes
job_pct_tm optional Jobs FTE nbrjobs_fte this may not print - changes to HR system might make this blank in all cases
studentGroups
XML Field Required? Banner Field Description Banner Field Notes
        documentation not yet written
studentHolds
XML Field Required? Banner Field Description Banner Field Notes
sprhold_hldd_code optional Hold code - describes type of hold sprhold_hldd_code  
sprhold_user optional user that put the hold on the account sprhold_user  
sprhold_from_date optional start date of the hold sprhold_from_date  
sprhold_to_date optional end date of the hold sprhold_to_date  
sprhold_reason optional reason hold was applied sprhold_reason  
sprhold_amount_owed optional amount owed sprhold_amount_owed Not used in Banner
sprhold_activity_date optional date record was last updated sprhold_activity_date  
toefls
XML Field Required? Banner Field Description Banner Field Notes
stu_tst_cmpnt_cd required   sortest_tesc_code  
stu_tst_dt required   sortest_test_date  
stu_tst_scr_nbr required   sortest_test_score  
stu_tst_desc required   stvtesc_desc  
employees
XML Field Required? Banner Field Description Banner Field Notes
pos_nbr required Jobs position number nbrjobs_posn  
pos_desc required Jobs description nbrjobs_desc  
emp_stat_cd required Jobs status nbrjobs_status  
job_pos_entry_dt optional date job change takes effect nbrjobs_effective_date Most if not all positions have annual re-appointments
job_emp_typ_desc optional employee class code nbrjobs_ecls_code  
job_slry_plan_cd optional   nbrjobs_sal_table  
job_slry_grd_cd optional   nbrjobs_sal_grade  
job_comp_rt optional Jobs hourly rate nbrjobs_reg_rate  
job_comp_annl_rt required Jobs annual salary nbrjobs_assgn_salary  
job_reg_temp_ind required board-appointed (permanent) employee or not n/a Based on common code to determine if an employee class code is considererd board-appointed
job_full_pt_tm_ind required full time or part time nbrjobs_fte FT if fte > .875 else PT
emp_tot_fte_rt required Jobs FTE nbrjobs_fte May not be accurate for non-board-appointed employees
pyck_lst_chk_dt optional last check date ptrcaln_end_date  
job_dept_setid_cd required   n/a Tries to determine campus based on Campus Mail (CM) address
job_dept_id required Timesheet approval organization code nbrjobs_orgn_code_ts  
job_dept_desc optional description for job_dept_id ftvorgn_title  
job_loc_desc optional   nbrjobs_jbln_code unreliable for anything except state. Blank is assumed to be Idaho
prsn_cmp_ln1_addr optional HR address - line 1 spraddr_street_line1  
prsn_cmp_ln2_addr optional HR address - line 2 spraddr_street_line2  
prsn_cmp_phn_nbr optional phone number - HR address sprtele_phone_area sprtele_phone_number  
paychecks
XML Field Required? Banner Field Description Banner Field Notes
pyck_earn_setid_cd required   n/a Tries to determine campus based on Campus Mail (CM) address
pyck_earn_dept_id required Timesheet approval organization code phrearn_orgn_code_ts  
pos_nbr required Jobs position number phrearn_posn  
pyck_earn_amt required check amount for the earn code phrearn_amt  
pyck_earn_cd optional earn code phrearn_earn_code  
pyck_earn_beg_dt optional pay period begin ptrcaln_start_date  
pyck_earn_end_dt optional pay period end ptrcaln_end_date  

Details

Article ID: 1916
Created
Fri 5/28/21 11:12 AM
Modified
Thu 6/3/21 1:26 PM