Find information about defining system settings relating to reporting in Wise.
Reports system tables can be accessed in the Wise configuration manager at systemWise > Reports > System tables.
(TABDGT) Day-to-day counting description
(TABDGT) Day-to-day counting description is used to define the description of daily count codes.
Transactions and actions are counted throughout the Wise system. Based on the type of count (DGT code), a count is recorded per location, date, and DGT code. A daily counts report provides an overview by location/period of the number of actions per code.
Some DGT codes are fixed in the system and some are composed of the parts of the action being counted. Wise counts the actions listed below and shows them in the daily counts overview. The list in the table is not exhaustive, additional codes can be added.
Daily count codes
| Code |
Description |
| ADA |
Read advice |
| ADA_AP |
Read advice app |
| ADP |
Personal read advice |
| B_ATTM |
New arrivals |
| B_CAE |
Expiring memberships |
| B_CAJ |
Ratify |
| B_CATF |
Ending membership Temp |
| B_CNFF |
Membership fee by letter |
| B_CNFM |
Membership fee by mail |
| B_CNHF |
Membership remember fee |
| B_CNIB |
Membership fee automatic payment |
| B_HR1F |
Overdue first reminder - mail |
| B_HR1I |
Overdue first reminder - inbox |
| B_HR1M |
Overdue first reminder - email |
| B_HR2F |
Overdue second reminder - mail |
| B_HR2I |
Overdue second reminder - inbox |
| B_HR2M |
Overdue second reminder - email |
| B_IV1I |
Courtesy notice - inbox |
| B_IV1M |
Courtesy notice - email |
| B_NBBF |
Replacement cost bill - desk |
| B_NBEF |
Add manual to billing procedure |
| B_NBFF |
Invoice replacement fee |
| B_NRFF |
Outstanding fines - mail |
| B_PAAM |
Forgot Password Request |
| B_PADM |
Change password - email |
| B_PAIM |
Unread inbox message(s) |
| B_PAWM |
Change or end membership |
| B_PPVM |
Lost Card Reported |
| B_PVCM |
Confirmation of email address |
| B_PVEM |
Change email address |
| B_PVLI |
Confirmation of Renewed Items - inbox |
| B_PVLM |
Confirmation of Renewed Items - email |
| B_PVWM |
Welcome email |
| B_RSOF |
Hold pick up message letter |
| B_RSOI |
Hold pick up message inbox |
| B_RSOM |
Hold pick up message email |
| BTL |
Visitors counter |
| BTL_ |
Visitors counter |
| CIR1_B |
Checkout at Desk |
| CIR1_D |
Checkout with double loan period |
| CIR1_N |
Checkout in Offline mode |
| CIR1_S |
Checkout via Self-Check |
| CIR1_X |
Checkout admin (no charges) |
| CIR2_B |
Check-in at Desk |
| CIR2_E |
Check-in via Bookdrop |
| CIR2_H |
In-house use |
| CIR2_S |
Check in self service |
| CIR2_X |
Check admin (no charges) |
| CIR3_B |
Renewal at the Desk |
| CIR3_D |
Renewal with double loan period |
| CIR3_I |
Renewal internet |
| CIR3_J |
Renewal via App |
| CIR3_N |
Renewal in Offline mode |
| CIR3_P |
Renewal via My Account (in branch) |
| CIR3_S |
Renewal via Self-Check |
| CIR3_T |
Renewal via Telephone |
| CIR3_Z |
Renewal Wise self service |
| CIR5_B |
Double check in desk |
| CIR5_E |
Double check in bookdrop |
| CIR6_B |
Cancel checkout at Desk |
| CIR6_S |
Cancel check out Wise self service |
| CIR7_B |
Cancel check-in at Desk |
| CIR7_S |
Cancel check in Wise self service |
| CIR8_B |
Cancel renewal desk |
| CIR8_I |
Cancel renewal internet |
| CIR8_J |
Cancel renewal APP |
| CIR8_P |
Cancel renewal my account onsite |
| CIR8_S |
Cancel renewal Wise self service |
| CIR9_B |
Check out Spec Customers |
| CIR9_X |
CIR actie 9 |
| CIRADM |
Check out Workroom |
| FC0 |
Open monthly customer run |
| FC1 |
Subscripiton invoices |
| HFL |
Relocating floating |
| IBA |
ILL APP |
| IBB |
ILL desk |
| IBE |
ILL delivered |
| IBI |
ILL internet |
| IBK |
ILL copy |
| IBL |
ILL requests |
| IBP |
ILL catalog onsite |
| IBT |
ILL check in to late |
| IBZ |
ILL overview (search) |
| INZ |
Inhouse use |
| KSI |
Cash draw income |
| KSU |
Cash draw expenses |
| KSW |
Shop sales |
| Kxxx |
Afsluiten van kasnummer xxx |
| MIA |
My Account login |
| MID |
My Account online payment (envisonware) |
| MID_AP |
My Account online payment APP (envisionware) |
| MIP |
My Account login (in branch) |
| MIW |
My Account login - Web |
| MMA |
My Account change address |
| MMB |
My Account change notifications |
| MMB_AP |
My Account change notifications APP |
| MME |
My Account change email address |
| MME_AP |
My Account change email address APP |
| MMG |
My Account change username |
| MMG_AP |
My Account changes username APP |
| MMP |
My Account changes mail preferences |
| MMS |
Change phone number in My Account |
| MPA |
Dagtelling MPQ |
| MPA_AP |
My Account change address APP |
| MPV |
My Account report lost card |
| MPV_AP |
My Account report lost card APP |
| NWH |
Re-register |
| NWI |
Online Registration |
| NWL |
New Registration (desk) |
| NWN |
Registration newsletter |
| RES |
Place a hold |
| RSA |
Place a hold APP |
| RSB |
Place a hold at Desk |
| RSG |
Group holds |
| RSI |
Place hold via internet |
| RSJ |
Place a hold APP |
| RSK |
Place a hold copy |
| RSM |
Place a hold storage |
| RSP |
Place a hold catatlog |
| UBD |
Direct end membership |
| UBV |
End membership per end of period |
| ZA0 |
Paymachine buy deposit |
| ZA1 |
Paymachine pay membership fee |
| ZA2 |
Paymachine pay fines |
| ZB0 |
Paymachine pay cash |
| ZB1 |
Paymachine pay bank |
| ZB2 |
Paymachine pay bank |
| ZB3 |
Paymachine pay chip |
| ZB9 |
Paymachine pay by deposit |
| ZBA |
Paymachine pay anonymous |
(TABSDS) Selection earmarks
In the Selections menu of the Wise configuration manager, saved selection criteria and saved sets can be assigned an earmark. Earmarks are tags that allow for easier filtering of saved selections and sets within the Statistics and Selections area of the Wise client. For more information, see Earmark.
Earmarks are defined in the (TABSDS) Selection earmarks table. Wise uses specific earmark codes for Wise functions, those codes are managed by OCLC. In addition to system codes, a library can create their own. All codes can be used at the system level and it is not possible to exclude branches or locations. Each code can be used for both sets and selections.
System earmarks
The following earmarks have a fixed meaning and usage:
| Code |
Definition |
| NBP |
Newsletter profile |
| NBO |
Newsletter recipients |
| SEL |
Selections (standard)
|
| MLT |
Marketing (selections built in the marketing workbench are assigned this earmark automatically) |
Create a new earmark
To create your own institution-level earmarks:
- Go to systemWise > Reports > System tables > (TABSDS) Selection earmarks.
- Click New. A Selection tags window opens.
- Enter a numerical code (limit 7 characters).
- Enter a description for the earmark.
- Click OK. The earmark is saved.
