Skip to main content

Completed/Inactive Working Groups and Task Forces

​FISCAL YEAR SET UP


ORDER LOGS (Z71) WILL NOT MIGRATE

​During migration, some fields are "not in scope" and will not migrate over, including the Z71 (Order Log*) information. This information can be downloaded for off-line saving as a static file.  (*any Library Notes will migrate)

If you are at a hosted school, contact SUNY OLIS using Footprints or assistance in downloading the logs. 

select
  z71_rec_key Z71_REC_KEY,
  substr(Z71_REC_KEY,2,9) ADM_NUMBER,
  z13_rec_key BIB_NUMBER,
  z13_title TITLE,
  z71_type ORDER_LOG_TYPE,
  z71_text ORDER_LOG_TYPE_DESCRIPTION,
  z71_open_date ORDER_LOG_ENTRY_DATE,
  z71_action_date ORDER_LOG_ACTION_DATE,
  z71_data DATA
from XXX01.z13, XXX50.z103, XXX50.Z71
where z13_rec_key = substr(z103_rec_key_1,6,9)
and z103_lkr_library = 'XXX50'
and substr(Z71_REC_KEY,2,9) = substr(z103_rec_key,6,9)
and z71_type in ('00','13','93','94','95','96','97','98','99')
 

BUDGET INFORMATION

Alma's Fund and Ledger View sorts budgets by Name (the Name field in Aleph).

Under the Name, it displays the  Code (Budget Code in Aleph) and then the External ID (External Name in Aleph).

In most Analytic Functions, the funds will be reported by Name.    As you can see from above, there are three funds that share the same Name*.   It is necessary to edit the names so reporting is clearer. 

*accounting for misspellings.