Advertisement
Guest User

Untitled

a guest
Apr 22nd, 2014
99
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.87 KB | None | 0 0
  1. select
  2. ccmm.id serial,
  3. ccmm.active,
  4. ccmm.org_unit,
  5. ccmm.grp,
  6. pgt.name,
  7. ccmm.circ_modifier,
  8. ccmm.marc_type,
  9. ccmm.marc_form,
  10. ccmm.marc_vr_format,
  11. ccmm.copy_circ_lib,
  12. ccmm.copy_owning_lib,
  13. ccmm.ref_flag,
  14. ccmm.juvenile_flag,
  15. ccmm.is_renewal,
  16. ccmm.usr_age_lower_bound,
  17. ccmm.usr_age_upper_bound,
  18. ccmm.circulate,
  19. ccmm.duration_rule,
  20. ccmm.recurring_fine_rule,
  21. ccmm.max_fine_rule,
  22. ccmm.hard_due_date,
  23. ccmm.script_test,
  24. ccmm.total_copy_hold_ratio,
  25. ccmm.available_copy_hold_ratio,
  26. ccmm.renewals,
  27. ccmm.user_home_ou,
  28. ccmm.grace_period,
  29. ccmm.marc_bib_level,
  30. ccmm.item_age,
  31. ccmm.copy_location
  32. from
  33. config.circ_matrix_matchpoint ccmm,
  34. permission.grp_tree pgt
  35. where
  36. ccmm.grp=pgt.id and
  37. ccmm.org_unit in(174,
  38. 175,
  39. 157,
  40. 158,
  41. 159,
  42. 160,
  43. 161,
  44. 162,
  45. 163,
  46. 164)
  47.  
  48.  
  49. 214;t;174;1;"Users";"";"";"";"";;;f;;;"";"";t;15;102;101;;"";;;;;"";"";"";
  50. 218;t;174;1;"Users";"Magazines";"";"";"";;;f;;;"";"";t;16;102;101;;"";;;;;"";"";"";
  51. 230;t;174;1;"Users";"Equipment";"";"";"";;;f;;;"";"";t;10;102;101;;"";;;;;"";"";"";
  52. 239;t;174;1;"Users";"Movie";"";"";"";;;f;;;"";"";t;5;102;101;;"";;;;;"";"";"";884
  53. 215;t;174;1;"Users";"AudioBooks";"";"";"";;;f;;;"";"";t;15;102;101;;"";;;;;"";"";"";
  54. 219;t;174;1;"Users";"Special";"";"";"";;;t;;;"";"";t;27;102;101;;"";;;;;"";"";"";
  55. 217;t;174;1;"Users";"Movie";"";"";"";;;f;;;"";"";t;5;102;101;;"";;;;;"";"";"";
  56. 240;t;174;1;"Users";"Movie";"";"";"";;;f;;;"";"";t;5;102;101;;"";;;;;"";"";"";1192
  57. 216;t;174;1;"Users";"Music";"";"";"";;;f;;;"";"";t;15;102;101;;"";;;;;"";"";"";
  58. 231;t;174;1;"Users";"";"";"";"";;;f;;;"";"";f;;;;;"";;;;;"";"";"";1387
  59. 232;t;174;15;"Staff Member";"";"";"";"";;;f;;;"";"";t;15;102;101;;"";;;;;"";"";"";1387
  60. 238;t;174;1;"Users";"DVD";"";"";"";;;f;;;"";"";t;5;102;101;;"";;;;;"";"";"";
  61. 241;t;174;29;"Outreach";"";"";"";"";;;f;;;"";"";t;32;102;101;;"";;;;;"";"";"";
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement