1 INSERT IGNORE INTO authorised_value_categories( category_name, is_system )
10 ('SUGGEST_FORMAT', 0),
14 ('REPORT_SUBGROUP', 0),
20 ('HOLD_CANCELLATION', 0),
22 ('AR_CANCELLATION', 0),
25 INSERT IGNORE INTO authorised_value_categories( category_name, is_system )
31 INSERT IGNORE INTO authorised_value_categories( category_name, is_system )
40 ('SIP_MEDIA_TYPE', 0),
41 ('ORDER_CANCELLATION_REASON', 0),
51 ('CONTROL_NUM_SEQUENCE' ,0);
54 INSERT IGNORE INTO authorised_value_categories( category_name ) VALUES
62 INSERT IGNORE INTO authorised_value_categories( category_name ) VALUES
65 -- For Interlibrary loans
66 INSERT IGNORE INTO authorised_value_categories( category_name ) VALUES
69 -- For Claims returned
70 INSERT IGNORE INTO authorised_value_categories( category_name ) VALUES
71 ('RETURN_CLAIM_RESOLUTION');
74 INSERT IGNORE INTO authorised_value_categories( category_name, is_system ) VALUES
78 INSERT IGNORE INTO authorised_value_categories (category_name, is_system)
80 ('ERM_AGREEMENT_STATUS', 1),
81 ('ERM_AGREEMENT_CLOSURE_REASON', 1),
82 ('ERM_AGREEMENT_RENEWAL_PRIORITY', 1),
83 ('ERM_USER_ROLES', 1),
84 ('ERM_LICENSE_TYPE', 1),
85 ('ERM_LICENSE_STATUS', 1),
86 ('ERM_AGREEMENT_LICENSE_STATUS', 1),
87 ('ERM_AGREEMENT_LICENSE_LOCATION', 1),
88 ('ERM_PACKAGE_TYPE', 1),
89 ('ERM_PACKAGE_CONTENT_TYPE', 1),
90 ('ERM_TITLE_PUBLICATION_TYPE', 1);