trans-data.sql

INSERT INTO application_type (type, name, description)
VALUES
('DFL', 'Dispositionary first lease', 'An application for the registration of a new lease granted by the proprietor of registered land'),
('DLG', 'Dealing', 'An application in respect of registered land. This includes transfers of title, charges and notices'),
('FR', 'First registration', 'An application for a first registration of land both freehold and leasehold. For leasehold this applies when the landlord’s title is not registered'),
('TP', 'Transfer of part', 'An application to register the transfer of part of a registered title'),
('OS(W)', 'Search of whole', 'An application to protect a transaction for value, such as purchase, lease or charge for the whole of a title'),
('OS(P)', 'Search of part', 'An application to protect a transaction for value, such as purchase, lease or charge for part of a title'),
('OS(NPW)', 'Non-priority search of whole', 'An application to search the whole of the register without getting priority'),
('OS(NPP)', 'Non-priority search of part', 'An application to search a part of the register without getting priority'),
('OSNPW', 'Non-priority search of whole', 'An application to search the whole of the register without getting priority'),
('OC1', 'Official copy', 'An application to obtain an official copy of a register or title plan represents a true record of entries in the register and extent of the registered title at a specific date and time. The data includes historical editions of the register and title plan where they are kept by the registrar in electronic form'),
('OC2', 'Official copy of a deed or document', 'An application to obtain a copy of a document referred to in the register or relates to an application. This includes correspondence, surveys, application forms and emails relating to applications that are pending, cancelled or completed'),
('SIM', 'Search of the index map', 'An application to find out whether or not land is registered and, if so, to obtain the title number')