Lines 1-146
Link Here
|
1 |
-- Coded values conforming to the Z39.77-2006 Holdings Statements for Bibliographic Items'); |
|
|
2 |
-- ISSN: 1041-5653 |
3 |
-- Refer to https://www.niso.org/publications/standards |
4 |
|
5 |
-- General Holdings: Type of Unit Designator |
6 |
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_UT','0','Information not available; Not applicable'); |
7 |
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_UT','a','Basic bibliographic unit'); |
8 |
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_UT','c','Secondary bibliographic unit: supplements, special issues, accompanying material, other secondary bibliographic units'); |
9 |
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_UT','d','Indexes'); |
10 |
|
11 |
-- Physical Form Designators |
12 |
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_PF','au','Cartographic material'); |
13 |
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_PF','ad','Cartographic material, atlas'); |
14 |
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_PF','ag' ,'Cartographic material, diagram'); |
15 |
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_PF','aj' ,'Cartographic material, map'); |
16 |
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_PF','ak' ,'Cartographic material, profile'); |
17 |
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_PF','aq' ,'Cartographic material, model'); |
18 |
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_PF','ar' ,'Cartographic material, remote sensing image'); |
19 |
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_PF','as' ,'Cartographic material, section'); |
20 |
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_PF','ay' ,'Cartographic material, view'); |
21 |
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_PF','az' ,'Cartographic material, other'); |
22 |
|
23 |
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_PF','cu' ,'Computer file'); |
24 |
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_PF','ca' ,'Computer file, tape cartridge'); |
25 |
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_PF','cb' ,'Computer file, chip cartridge'); |
26 |
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_PF','cc' ,'Computer file, computer optical disk cartridge'); |
27 |
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_PF','cf' ,'Computer file, tape cassette'); |
28 |
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_PF','ch' ,'Computer file, tape reel'); |
29 |
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_PF','cj' ,'Computer file, magnetic disk'); |
30 |
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_PF','cm' ,'Computer file, magneto-optical disk'); |
31 |
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_PF','co' ,'Computer file, optical disk'); |
32 |
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_PF','cr' ,'Computer file, remote'); |
33 |
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_PF','cz' ,'Computer file, other'); |
34 |
|
35 |
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_PF','du' ,'Globe'); |
36 |
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_PF','da' ,'Globe, celestial'); |
37 |
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_PF','db' ,'Globe, planetary or lunar'); |
38 |
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_PF','dc' ,'Globe, terrestrial'); |
39 |
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_PF','de' ,'Globe, earth moon'); |
40 |
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_PF','dz' ,'Globe, other'); |
41 |
|
42 |
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_PF','ou' ,'Kit'); |
43 |
|
44 |
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_PF','hu' ,'Microform'); |
45 |
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_PF','ha' ,'Microform, aperture card'); |
46 |
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_PF','hb',' Microform, microfilm cartridge'); |
47 |
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_PF','hc',' Microform, microfilm cassette'); |
48 |
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_PF','hd',' Microform, microfilm reel'); |
49 |
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_PF','he' ,'Microform, microfiche'); |
50 |
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_PF','hf' ,'Microform, microfiche cassette'); |
51 |
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_PF','hg' ,'Microform, micro-opaque'); |
52 |
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_PF','hz' ,'Microform, other'); |
53 |
|
54 |
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_PF','mu' ,'Motion picture'); |
55 |
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_PF','mc' ,'Motion picture, film cartridge'); |
56 |
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_PF','mf' ,'Motion picture, film cassette'); |
57 |
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_PF','mr' ,'Motion picture, film reel'); |
58 |
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_PF','mz' ,'Motion picture, other'); |
59 |
|
60 |
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_PF','ku' ,'Nonprojected graphic'); |
61 |
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_PF','kc' ,'Nonprojected graphic, collage'); |
62 |
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_PF','kd' ,'Nonprojected graphic, drawing'); |
63 |
|
64 |
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_PF','ke' ,'Nonprojected graphic, painting'); |
65 |
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_PF','kf' ,'Nonprojected graphic, photomechanical print'); |
66 |
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_PF','kg' ,'Nonprojected graphic, photonegative'); |
67 |
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_PF','kh' ,'Nonprojected graphic, photoprint'); |
68 |
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_PF','ki' ,'Nonprojected graphic, picture'); |
69 |
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_PF','kj' ,'Nonprojected graphic, print'); |
70 |
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_PF','kl' ,'Nonprojected graphic, technical drawing'); |
71 |
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_PF','kn' ,'Nonprojected graphic, chart'); |
72 |
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_PF','ko' ,'Nonprojected graphic, flash card'); |
73 |
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_PF','kz' ,'Nonprojected graphic, other'); |
74 |
|
75 |
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_PF','qu' ,'Notated music'); |
76 |
|
77 |
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_PF','gu' ,'Projected graphic'); |
78 |
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_PF','gc' ,'Projected graphic, filmstrip cartridge'); |
79 |
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_PF','gd' ,'Projected graphic, filmstrip'); |
80 |
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_PF','gf' ,'Projected graphic, other type of filmstrip'); |
81 |
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_PF','go' ,'Projected graphic, filmstrip roll'); |
82 |
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_PF','gs' ,'Projected graphic, slide'); |
83 |
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_PF','gt' ,'Projected graphic, transparency'); |
84 |
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_PF','gz' ,'Projected graphic, other'); |
85 |
|
86 |
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_PF','ru' ,'Remote-sensing image'); |
87 |
|
88 |
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_PF','su' ,'Sound recording'); |
89 |
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_PF','sd' ,'Sound recording, sound disk'); |
90 |
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_PF','se' ,'Sound recording, cylinder'); |
91 |
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_PF','sg' ,'Sound recording, sound cartridge'); |
92 |
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_PF','si' ,'Sound recording, sound-track film'); |
93 |
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_PF','sq' ,'Sound recording, roll'); |
94 |
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_PF','ss' ,'Sound recording, sound cassette'); |
95 |
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_PF','st' ,'Sound recording, sound-tape reel'); |
96 |
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_PF','sw' ,'Sound recording, wire recording'); |
97 |
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_PF','sz' ,'Sound recording, other'); |
98 |
|
99 |
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_PF','tu' ,'Text'); |
100 |
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_PF','ta' ,'Text, regular print'); |
101 |
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_PF','tb' ,'Text, large print'); |
102 |
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_PF','tc' ,'Text, Braille'); |
103 |
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_PF','td' ,'Text, loose-leaf'); |
104 |
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_PF','tz' ,'Text, other'); |
105 |
|
106 |
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_PF','vu' ,'Videorecording'); |
107 |
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_PF','vc' ,'Videorecording, videocartridge'); |
108 |
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_PF','vd' ,'Videorecording, videodisc'); |
109 |
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_PF','vf' ,'Videorecording, videocassette'); |
110 |
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_PF','vr' ,'Videorecording, videoreel'); |
111 |
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_PF','vz' ,'Videorecording, other'); |
112 |
|
113 |
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_PF','zu' ,'Physical form is unspecified'); |
114 |
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_PF','zm' ,'Multiple physical forms'); |
115 |
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_PF','zz' ,'Other physical media'); |
116 |
|
117 |
-- General Holdings: Completeness Designator |
118 |
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_C','0','Information not available, or Retention is limited'); |
119 |
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_C','1','Complete (95%-100% held)'); |
120 |
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_C','2','Incomplete (50%-94% held)'); |
121 |
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_C','3','Very incomplete or scattered (less than 50% held)'); |
122 |
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_C','4','Not applicable'); |
123 |
|
124 |
-- General Holdings: Acquisition Status Designator |
125 |
-- This data element specifies acquisition status for the unit at the time of the holdings report. |
126 |
|
127 |
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_AS','0','Information not available, or Retention is limited'); |
128 |
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_AS','1','Other'); |
129 |
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_AS','2','Received and complete or Ceased'); |
130 |
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_AS','3','On order'); |
131 |
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_AS','4','Currently received'); |
132 |
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_AS','5','Not currently received'); |
133 |
|
134 |
-- General Holdings: Retention Designator |
135 |
-- This data element specifies the retention policy for the unit at the time of the holdings report. |
136 |
|
137 |
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_RD','0','Information not available'); |
138 |
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_RD','1','Other'); |
139 |
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_RD','2','Retained except as replaced by updates'); |
140 |
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_RD','3','Sample issue retained'); |
141 |
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_RD','4','Retained until replaced by microform, or other preservation format'); |
142 |
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_RD','5','Retained until replaced by cumulation, replacement volume, or revision'); |
143 |
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_RD','6','Limited retention (only some parts kept)'); |
144 |
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_RD','7','No retention (no parts kept)'); |
145 |
INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('HINGS_RD','8','Permanent retention (all parts kept permanently)'); |
146 |
|