set schema YourLibrary;

drop table jetyp;

create table jetyp (typ char(2) not null with default, dsc char(100) not null with default);

insert into jetyp values('AD','A change was made to the auditing attribute');
insert into jetyp values('AF','All authority failures');
insert into jetyp values('AP','A change was made to program adopt');
insert into jetyp values('AU','Attribute change');
insert into jetyp values('CA','Changes to object authority (authorization list or object)');
insert into jetyp values('CD','A change was made to a command string');
insert into jetyp values('CO','Create object');
insert into jetyp values('CP','Create, change, restore user profiles');
insert into jetyp values('CQ','A change was made to a change request descriptor');
insert into jetyp values('CU','Cluster operation');
insert into jetyp values('CV','Connection verification');
insert into jetyp values('CY','Cryptographic configuration');
insert into jetyp values('DI','Directory services');
insert into jetyp values('DO','All delete operations on the system');
insert into jetyp values('DS','DST security officer password reset');
insert into jetyp values('EV','Environment variable');
insert into jetyp values('GR','General purpose audit record');
insert into jetyp values('GS','A descriptor was given');
insert into jetyp values('IP','Inter-process communication event');
insert into jetyp values('IR','IP rules actions');
insert into jetyp values('IS','Internet security management');
insert into jetyp values('JD','Changes to the USER parameter of a job description');
insert into jetyp values('JS','A change was made to job data');
insert into jetyp values('KF','Key ring file name');
insert into jetyp values('LD','A link, unlink, or lookup operation to a directory');
insert into jetyp values('ML','A change was made to office services mail');
insert into jetyp values('NA','Changes to network attributes');
insert into jetyp values('ND','Directory search violations');
insert into jetyp values('NE','End point violations');
insert into jetyp values('OM','Object management change');
insert into jetyp values('OR','Object restored');
insert into jetyp values('OW','Changes to object ownership');
insert into jetyp values('O1','Single optical object access');
insert into jetyp values('O2','Dual optical object access');
insert into jetyp values('O3','Optical volume access');
insert into jetyp values('PA','Changes to programs (CHGPGM) that will now adopt the owner''s authority');
insert into jetyp values('PG','Changes to an object''s primary group');
insert into jetyp values('PO','A change was made to printed output');
insert into jetyp values('PS','Profile swap');
insert into jetyp values('PW','Passwords used that are not valid');
insert into jetyp values('RA','Restore of objects when authority changes');
insert into jetyp values('RJ','Restore of job descriptions that contain user profile names');
insert into jetyp values('RO','Restore of objects when ownership information changes');
insert into jetyp values('RP','Restore of programs that adopt their owner''s authority');
insert into jetyp values('RQ','A change request descriptor was restored');
insert into jetyp values('RU','Restore of authority for user profiles');
insert into jetyp values('RZ','The primary group for an object was changed during a restore operation');
insert into jetyp values('SD','A change was made to the system directory');
insert into jetyp values('SE','Changes to subsystem routing');
insert into jetyp values('SF','A change was made to a spooled output file');
insert into jetyp values('SG','Asynchronous signals');
insert into jetyp values('SK','Secure sockets connection');
insert into jetyp values('SM','A change was made by system management');
insert into jetyp values('SO','A change was made by server security');
insert into jetyp values('SA','change was made by system tools');
insert into jetyp values('SV','Changes to system values');
insert into jetyp values('VA','Changes to access control list');
insert into jetyp values('VC','Connection started or ended');
insert into jetyp values('VF','Server files were closed');
insert into jetyp values('VL','An account limit was exceeded');
insert into jetyp values('VN','A logon or logoff operation on the network');
insert into jetyp values('VO','Actions on validation lists');
insert into jetyp values('VP','A network password error');
insert into jetyp values('VR','A network resources was accessed');
insert into jetyp values('VS','A server session started or ended');
insert into jetyp values('VU','A network profile was changed');
insert into jetyp values('VV','Service status was changed');
insert into jetyp values('X0','Network authentication');
insert into jetyp values('X1','Reserved for future audit entry');
insert into jetyp values('X2','Reserved for future audit entry');
insert into jetyp values('X3','Reserved for future audit entry');
insert into jetyp values('X4','Reserved for future audit entry');
insert into jetyp values('X5','Reserved for future audit entry');
insert into jetyp values('X6','Reserved for future audit entry');
insert into jetyp values('X7','Reserved for future audit entry');
insert into jetyp values('X8','Reserved for future audit entry');
insert into jetyp values('X9','Reserved for future audit entry');
insert into jetyp values('YC','A change was made to DLO change access');
insert into jetyp values('YR','A change was made to DLO read access');
insert into jetyp values('ZC','A change was made to object change access');
insert into jetyp values('ZM','An object was accessed using a method');
insert into jetyp values('ZR','A change was made to Object read access');