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 |
|