Copy Service Database: User Manual (BMR Record 1989/7)
Contents
1. 1939 4 Copy 4 g BMR PUBLICATIONS COMPACTUS en De a LENDING SECTION Lo am Bureau of Mineral Resources Geology amp Geophysics RECORD 1989 7 COPY SERVICE DATABASE USER MANUAL Tony Boston Geoscience Computing and Database Branch bn contained in this report has been obtained by the Bureau of Mineral Resources Geology and Geophysics as part of the policy an Government to assist in the exploration and development of mineral resources It may not be published in any form or used in bspectus or statement without the permission in writing of the Director RECORD 1989 7 COPY SERVICE DATABASE USER MANUAL Tony Boston Geoscience Computing and Database Branch CONTENTS INTRODUCTION DATA ENTRY 2 1 Querying the Database 2 2 Updating the Database 25 43 Inserting Records into the Database 2 4 Deleting Records from the Database 2 5 Exiting the Form Un E wa APPENDIXES Logical Record Structure of the Database Schema of Copy Service Database Data Entry Form Designer Documentation Data Entry Screen Layout Data Entry Screen User Documentation W Q2 W Bh MO 1 Introduction The Copy Service database has been set up using the ORACLE DBMS on the DG MV 20000 Its purpose is to store information on and associated costs of material available for reproduction by the copy service Data is stored on BMR bulletins reports and records petroleum and geophysical reports and logs as w2. GOBLK CSGEODX1 GOBLK REPORT GOBLK AMIRP GOBLK SURVEY GOBLK WELL GOBLK GEOMAP GOBLK COST EXIT OTHERS THEN NULL If step not successful stop with error No Message 13 SQL FORMS Application CSDBASE owned by COPY SERVICE as at 12 DEC 88 l record Block csgeodxl BMR BULLETINS REPORTS RECORDS Starts on Page 1 Table CSGEODX1 Block level Triggers KEY COMMIT STEP 1 EXEMACRO NULL Actions If step not successful stop with error No Message KEY DELREC STEP 1 HEXEMACRO NULL Actions If step not successful stop with error No Message KEY ENTQRY STEP 1 HEXEMACRO ENTQRY EXETRG Q NEXTBLOCK Actions If step not successful stop with error No Message KEY EXEQRY STEP 1 HEXEMACRO EXETRG DO NOTHING Actions If step not successful stop with error No Message KEY NXTREC STEP 1 ZEXEMACRO NXTREC EXETRG Q NEXTBLOCK Actions If step not successful stop with error No Message KEY PRVREC STEP 1 EXEMACRO PRVREC EXETRG Q NEXTBLOCK Actions If step not successful stop with error No Message Field 1 PUBNUM Number Length 3 Page 1 Line 4 Column 23 Non enterable Queryable No Help Message Field 2 VOLPARTNUM Character Length 20 Page 1 Line 4 Column 59 Non enterable Queryable No Help Message 14 SQL FORMS Application CSDBASE owned by COPY SERVICE as at 12 DEC 88 Block csgeodx1 BMR BULLETINS REPORTS RECORDS continued POST CHANGE STEP 1 Field 3 TITL
3. To exit the form at any time press the cancel exit key Fll If prompted with the message Do you want to commit the changes you have made then generally type n for no unless you are sure that you want to make changes to the database It is better to have to re enter data than to accidentally corrupt the database Notes on keyboard NL New line key Use to move forward between fields in a block HOME Home key Use to move backwards between fields in a block C1 Use to travel backwards between blocks C2 Use to travel forward between blocks which usually correspond to ORACLE tables C4 Use to scroll through a screen full of records SHIFT F2 Displays block menu F3 Commits changes to the database F4 Clears block ready for entry of next record SHIFT F4 Displays last record on the screen F11 Use to exit from Form or cancel current operation ARROW KEYS Use to scroll through records after a query and move about fields in a block APPENDIX 1 BMR BULLETINS REPORTS RECORDS Pub Number Volume Part Num Number of Pages Number of Plates Length of Plates Price AMTAR PREPRINTS Title Year Number of pages Num Copied SHOT POINT DATA Product Code Part Part Start Part Stop GEOPHYSICAL MAPS Sheet Name Scale Grid Reference Num BMR Reference Num Release Date Data Type Contoured REPORTS BMR File Number Govt Printer Num Title Numbe
4. When this screen is entered the publication number and volume part number are copied from the previous screen Data can be inserted in the number of pages number of plates plate length and price fields as appropriate The copy cost is calculated automatically based on the number of pages and length of plates After a record has been entered the cursor skips to the publication number field and the user is asked to press F3 to commit the record to the database It is envisaged that data will be entered into this screen each time a request for a BMR publication has been processed In this way the database will be gradually built up 3 REPORTS The report screen is designed for input of data on Well Completion PSSA Seismic Survey and Geophysical Survey Reports 50 Enter data in the upper block from left to right top to bottom Data must be entered into the BMR file number Govt printer number and Title fields for each record Be consistent in the use of upper and lower case for all character fields and also in the style used for entry of BMR file number Records with inconsistent data will not be retrieved during a query For example the BMR file number should be entered consistently as 88 1234 not 88 1234 or any other variation The total cost is calculated automatically based on the number of pages and length of plates The C2 key can be used to enter the lower block on the screen The BMR file number is automatically copied a
5. 4 Line I Column 5 Mandatory Value range from 1900 to 2200 Help Message Enter value for YEAR Field 2 TITLE Character Length 48 Page 4 Line I Column 11 Mandatory Help Message Enter value for TITLE Field 3 TOTAL COST Money R Length 7 Page 4 Line I Column 70 Non table Non enterable Field 4 NUM PAGES Number R Length 3 Page 4 Line 1 Column 63 Help Message Enter value for NUM PAGES POST CHANGE STEP 1 SELECT NVL AMIRP NUM PAGES 0 COST INTO AMIRP TOTAL COST FROM COST WHERE COST TYPE COST PER PAGE Actions If step not successful stop with error No Message 25 SQL FORMS Application CSDBASE owned by COPY SERVICE as at 12 DEC 88 1 record Block SURVEY MARINE SEISMIC DATA Starts on Page 5 Field Field Table SURVEYDATA Default Order by ORDER BY SURVEY NUM Block level Triggers KEY NXTBLK STEP 1 HEXEMACRO NXTBLK CLRBLK Actions If step not successful stop with error No Message PRE DELETE STEP 1 DELETE FROM SEISMICDATA WHERE SEISMICDATA SURVEY NUM SURVEY SURVEY NUM Actions If step not successful stop with error No Message 1 SURVEY NUM Number Length 3 Page 5 Line 5 Column 6 Mandatory Help Message Enter value for SURVEY IND 2 SURVEY NAME Character Length 50 Page 5 Line 5 Column 25 Mandatory Help Message Enter value for SURVEY NAME 26 SQL FORMS Application CSDBASE owned by COPY SERVICE as at 12 DEC 88 5 record Block SEI
6. as at 12 DEC 88 Block AEROMAP AEROMAP continued Field DATA TYPE Character Length 20 Page 7 Line 16 Column 57 Help Message Enter value for DATA TYPE Field 8 FILM COST Money R Length 7 Page 7 Line 18 Column 57 Non table Non enterable Field 9 DYELINE COST Money R Length 7 Page 7 Line 18 Column 37 Non table Non enterable Field 10 CON DYE COST Money R Length 7 Page 7 Line 19 Column 37 Non table Non enterable Field 11 CON FILM COST Money R Length 7 Page 7 Line 19 Column 57 able Non enterable 38 SQL FORMS Application CSDBASE owned by COPY SERVICE as at 12 DEC 88 15 record Block COST COST TABLE Starts on Page 8 Field Field Table COST 1 COST TYPE Character Length 20 Page 8 Line 1 Column 19 Help Message WARNING COST TYPES SHOULD NORMALLY NOT BE ALTERED 2 COST Money R Length 7 Page 8 Line 1 Column 47 Help Message Enter value for COST 39 APPENDIX 4 DATA ENTRY SCREEN LAYOUT COPY SERVICE DATABASE MATN MENU BMR BULLETINS REPORTS RECORDS REPORTS AMIAR CHAPTER PREPRINTS MARINE SEISMIC DATA WELL LOGS MAPS COST TABLE EXIT CO NN DU WHE ENTER CHOICE _ Char Mode Replace Page 10 Count 0 40 BMR BULLETINS REPORTS RECORDS PUBLICATION NUMBER VOL PART NUMBER BULLETIN 183 REPORT 185 RECORD 191 TITLE STATUS PUBLICATION DATE COST AUTHOR ORDER SEQUENCE Char Mode Replace Page 1 Count 0 41 GEODX BULLETINS R
7. and a greater cost will be calculated for dyeline and film reproductions To create a new record with the same sheet name query the database for that name press F4 to create a new record then shift F4 to duplicate the last record 52 10 COPY SERVICE CHARGES This screen accesses the copy service charges which are used to calculate the costs which appear on all other screens The cost types should not be altered without consulting the Computing or Database branch The costs however can be changed at will and the copy costs appearing on other screens are then be altered automatically
8. step not successful stop with error No Message KEY NXTREC STEP 1 HEXEMACRO NXTREC EXETRG Q NEXTBLOCK Actions If step not successful stop with error No Message KEY PRVREC STEP 1 HEXEMACRO PRVREC EXETRG Q NEXTBLOCK Actions If step not successful stop with error No Message UNO Character Length 8 Page 6 Line 6 Column 2 Help Message Enter value for UNO 2 WELL NAME Character Length 30 Page 6 Line 6 Column l Help Message Enter value for WELL NAME 3 BMR FILE NUM Character Length 8 Page 6 Line 6 Column 46 Help Message Enter value for BMR FILE NUM Field Field 30 SQL FORMS Application CSDBASE owned by COPY SERVICE as at 12 DEC 88 Block WELL PEDIN WELL LOGS continued 4 LOCATION Character Length 3 Page 6 Line 6 Column 56 Help Message Enter value for LOCATION 5 STATE Character Length 4 Page 6 Line 6 Column 66 Help Message Enter value for STATE 31 SQL FORMS Application CSDBASE owned by COPY SERVICE as at 12 DEC 88 12 record Block LOG LOG Starts on Page 6 Field Field Field Field Table LOG Block level Triggers key commit STEP 1 EXEMACRO NULL Actions If step not successful stop with error No Message 1 UNO Character Length 8 Non displayed Copied from WELL UNO 2 LOG TYPE Character Length 16 Page 6 Line I Column 14 Help Message Enter value for LOG TYPE 3 TOP Number R Length 10 Page 6 Line I Column 37 He
9. with error No Message STEP 2 SELECT NVL LOG DETAILS LENGTH OF LOG 0 COST INTO LOG DETAILS FILM COST FROM COST WHERE COST TYPE FILM PER METRE Actions If step not successful stop with error No Message Field 8 DYELINE COST Money R Length 7 Page 9 Line 1 Column 65 Non table Non enterable 34 SQL FORMS Application CSDBASE owned by COPY SERVICE as at 12 DEC 88 4 record Block GEOMAP MAPS Starts on Page 7 Table GEOMAP Field 1 SHEET NAME Character Length 22 Page 7 Line 1 Column 3 Mandatory Help Message Enter value for SHEET NAME Field 2 SCALE Character Length 7 Page 7 Line 1 Column 31 Help Message Enter value for SCALE Field 3 COVERAGE Character Length 1 Page 7 Line 1 Column 43 Help Message Enter value for COVERAGE Field 4 PRICE Money R Length 7 Page 7 Line I Column 57 No Help Message 35 SQL FORMS Application CSDBASE owned by COPY SERVICE as at 12 DEC 88 1 record Block AEROMAP AEROMAP Starts on Page Table AEROMAP Block level Triggers POST QUERY STEP 1 HEXEMACRO EXETRG GETCOST Actions If step not successful stop with error No Message GETCOST STEP 1 SELECT COST INTO AEROMAP DYELINE COST FROM COST WHERE COST TYPE DYELINE STANDARD MAP Actions If step not successful stop with error No Message STEP 2 SELECT COST INTO AEROMAP FILM COST FROM COST WHERE COST TYPE FILM STANDARD MAP Actions If step not success
10. DETAILS COST INTO GDXDETAILS COST FROM COST WHERE COST TYPE DYELINE PER METRE Actions If step not successful stop with error and display TRIGGER STEP FAILED CHECK COST TABLE WHERE COST DYELINE PER METRE STEP 3 HEXEMACRO NXTFLD Actions If step not successful stop with error No Message STEP 4 SELECT X FROM DUAL Actions If step not successful stop with error and display PRESS F3 TO COMMIT RECORD TO THE DATABASE 19 SQL FORMS Application CSDBASE owned by COPY SERVICE as at 12 DEC 88 Block GDXDETAILS BMR BULLETINS REPORTS RECORDS DATA continued Field COST Money R Length 7 Page 2 Line 1 Column 71 Non table Non enterable 20 SQL FORMS Application CSDBASE owned by COPY SERVICE as at 12 DEC 88 1 record Block REPORT REPORTS Starts on Page 3 Table REPORT Default Order by ORDER BY BMR FILE NUM Block level Triggers KEY ENTQRY STEP 1 HEXEMACRO CLRBLK ENTQRY EXETRG Q NEXTBLOCK Actions If step not successful stop with error No Message KEY EXEQRY STEP 1 HEXEMACRO EXEQRY EXETRG Q NEXTBLOCK Actions If step not successful stop with error No Message KEY NXTBLK STEP 1 HEXEMAGRO GOBLK AUTHOR CLRBLK Actions If step not successful stop with error No Message KEY NXTREC STEP 1 EXEMACRO NXTREC EXETRG Q NEXTBLOCK Actions If step not successful stop with error No Message KEY PRVREC STEP 1 HEXEMACRO PRVREC EXETRG Q NEXTBLOCK Act
11. E Page 1 SELECT SUBSTR CSGEODX1 TITLE 79 78 INTO DISPLAYTITLE FROM DUAL Actions If step not successful stop with error No Message STEP 2 SELECT PRICE INTO CSGEODX1 TEMP FROM PUB DETAILS WHERE CSGEODX1 VOLPARTNUM PUB DETAILS VOLPARTNUM AND CSGEODX1 PUBNUM PUB DETAILS PUBNUM AND PRICE IS NOT NULL Actions If step IS successful stop trigger No Message STEP 3 SELECT NVL NUM PAGES 0 COST INTO CSGEODX1 TEMP FROM PUB DETAILS COST WHERE CSGEODX1 PUBNUM PUB DETAILS PUBNUM AND CSGEODX1 VOLPARTNUM PUB DETAILS VOLPARTNUM AND COST TYPE COST PER PAGE Actions If step not successful stop with error No Message STEP 4 SELECT NVL LENGTH OF PLATES 0 COST CSGEODX1 TEMP INTO GSGEODXI TEMP FROM PUB DETAILS COST WHERE CSGEODX1 PUBNUM PUB DETAILS PUBNUM AND CSGEODX1 VOLPARTNUM PUB DETAILS VOLPARTNUM AND COST TYPE DYELINE PER METRE Actions If step not successful stop with error No Message Character Length 240 Line 8 Column 2 Displayed 78 Non updatable No Help Message Field Field Field Field Field 15 SQL FORMS Application CSDBASE owned by COPY SERVICE as at 12 DEC 88 Block csgeodx1 BMR BULLETINS REPORTS RECORDS continued 4 STATUS Page 1 Line 10 Column Non enterable Queryable No Help Message 5 PUBDATE Page 1 Line 10 Column Non enterable Queryable No Help Message 6 GDXNUM Non displayed 7 TEMP Page 1 Line 10 Column Non ta
12. EC 88 Block REPORT REPORTS continued 6 LENGTH OF PLATES Number R Length 3 Page 3 Line 10 Column 20 Help Message Enter value for LENGTH OF PLATES KEY NXTFID STEP 1 SELECT NVL REPORT NUM PAGES 0 COST INTO REPORT TEMP FROM COST WHERE COST TYPE COST PER PAGE Actions If step not successful stop with error and display TRIGGERL FAILED IRI STEP 2 SELECT NVL REPORT LENGTH OF PLATES 0 COST REPORT TEMP INTO REPORT TOTALCOST FROM COST WHERE COST TYPE DYELINE PER METRE Actions If step not successful stop with error and display TRIGGER FAILED STEP 3 HEXEMACRO NXTFLD Actions If step not successful stop with error No Message 7 TOTALCOST Money R Length 6 Page 3 Line 10 Column 60 Non table Non enterable 8 TEMP Money R Length 7 Non table Non displayed 23 SQL FORMS Application CSDBASE owned by COPY SERVICE as at 12 DEC 88 9 record Block AUTHOR AUTHOR Starts on Page 3 Field Field Table AUTHOR Default Order by ORDER BY AUTHOR 1 BMR FILE NUM Character Length 8 Page 3 Line I Column 20 Copied from REPORT BMR FILE NUM Help Message Enter value for BMR FILE NUM 2 AUTHOR Character Length 30 Page 3 Line 1 Column 50 Help Message Enter value for AUTHOR 24 SQL FORMS Application CSDBASE owned by COPY SERVICE as at 12 DEC 88 15 record Block AMIRP AMIAR CHAPTER PREPRINTS Starts on Page 4 Table AMIRP Field 1 YEAR Number Length 4 Page
13. EPORTS RECORDS DETAILS PUB VOLUME AND PART NUMBER NUMBER PLATE PRICE COPY NUMBER NUMBER PAGES PLATES LENGTH COST H lt a ee a a O Char Mode Replace Page 2 Count 0 42 REPORTS BMR FILE NUMBER GOVT PRINTER NUMBER TITLE NUMBER OF PAGES mE NUMBER OF PLATES LENGTH OF PLATES TOTAL COST BMR FILE NUMBER AUTHOR Char Mode Replace Page 3 Count 0 43 AMIR PREPRINT CHAPTERS Hd E TITLE NUM TOTAL PAGES COST mari _ _ 11111111111 HH Char Mode Replace Page 4 Count x0 44 MARINE SEISMIC DATA SURVEY NUMBER SURVEY NAME SURVEY LINE NUMBER PRODUCT LENCTH OF PRICE NUMBER CODE SECTION PRODUCT CODE PART PART START PART FINISH Char Mode Replace Page 5 DYELINE COST Count 0 FILM Q 2 3 45 WELL LOGS IN THE PEDIN DATABASE PEDIN WELL WELL NAME BMR FILE LOCATION STATE NUMBER NUMBER LOG TYPE TOP METRES BOTTOM METRES Char Mode Replace Page 6 Count 0 46 WELL LOGS WELL NAME LOG TYPE BMR FILE IN GOVT LENGTH DYELINE FILM NUMBER CS PR NO OF LOG COST COST HER HIIHIHIIIIH Char Mode Replace Page 9 Count 0 47 GEOLOGICAL COMPILATION SHEETS AND GEOCHEMICAL MAPS SHEET NAME SCALE COVERAGE PRICE GRAVITY RADIOMETRIC AND TOTAL MAGNETIC
14. INTENSITY MAPS SHEET NAME SCALE GRID REF NUM BMR REF NUM RELEASE DATE DATA TYPE CONTOURED _ DYELINE COST FILM COST Char Mode Replace Page 7 Count 0 48 COPY SERVICE CHARGES COST TYPE COST Char Mode Replace Page 8 Count x0 49 APPENDIX 5 DATA ENTRY SCREEN USER DOCUMENTATION 1 BMR BULLETINS REPORTS RECORDS This screen accesses data in the GEODX database and can be used for query only Records cannot be updated inserted or deleted Records can be queried by any field except author Generally queries will be by title or vol part number eg 88 1234 To initiate a query press F2 then enter the appropriate publication number 183 for a Bulletin 185 for a Report or 191 for a Record followed by the title or vol part number of the required publication Titles may be abbreviated using the symbol for example entering 191 in the publication field followed by Gold in the title field would retrieve all Records with titles beginning with the word Gold To execute the query press Fl and all records which satisfy the query will be retrieved The authors appear in the author block automatically and the order sequence indicates the lst 2nd 3rd etc authors Records can be searched through using the up and down arrow keys If a record has already been entered in the Copy Service Database the its cost will appear in the cost field To move to the next screen press C2 twice 2 BMR BULLETINS REPORTS RECORDS DETAILS
15. SMICDATA SEISMICDATA Starts on Page 5 Field Field Field Field Table SEISMICDATA Block level Triggers KEY NXTBLK STEP 1 HEXEMACRO NXTBLK CLRBIK Actions If step not successful stop with error No Message PRE DELETE STEP 1 DELETE FROM SHOTPOINTDATA WHERE SHOTPOINTDATA PRODUCT CODE SEISMICDATA PRODUCT CODE Actions If step not successful stop with error No Message 1 SURVEY NUM Number Length 3 Page 5 Line 1 Column 6 Copied from SURVEY SURVEY NUM Mandatory Help Message Enter value for SURVEY NUM 2 LINE NUM Character Length 15 Page 5 Line 1 Column 14 Mandatory Help Message Enter value for LINE NUM 3 PRODUCT CODE Character Length 11 Page 5 Line I Column 30 Mandatory Help Message Enter value for PRODUCT CODE 4 LENGTH OF SECTION Number R Length 3 Page 5 Line 1 Column 45 Help Message Enter value for LENGTH OF SECTION POST CHANGE STEP 1 SELECT COST NVL SEISMICDATA LENGTH OF SECTION 0 INTO SEISMICDATA DYELINE COST FROM COST WHERE COST TYPE DYELINE PER METRE Actions If step not successful stop with error No Message Field Field Field 27 SQL FORMS Application CSDBASE owned by COPY SERVICE as at 12 DEC 88 Block SEISMICDATA SEISMICDATA continued STEP 2 SELECT COST NVL SEISMICDATA LENGTH OF SECTION 0 INTO SEISMICDATA FIIM COST FROM COST WHERE COST TYPE FILM PER METRE Actions If step not successful stop w
16. ate as select cd article tx title id publication no volpart nvl ed status dt publication from geodx source geodx article geodx bmrpub where id publication 183 or id publication 185 or id publication 191 and geodx article id source geodx source id source and geodx source id source geodx bmrpub id source and geodx article id source geodx bmrpub id source create view csgeodx2 gdxnum author order sequence as select cd article name author order sequence from geodx article author geodx author where geodx article author id author geodx author id author rem rem Create two views of data in the PEDIN database for use by rem the Copy Service These were created by the PEDIN DBA manager rem Two synonyms were then created for these views rem create view copy service well logs uno well name bmr file num location state as select wells uno name file no on off state from wells wdatal where wells uno wdatal uno and wdatal code WL create view copy service logs uno log type top bottom as select uno testtype top bottom from wdatal where code WL create synonym well for bruce copy service well logs create synonym log for copy service logs rem rem Create a table to hold some of the Publication details of rem BMR Bulletins Reports and Records in the Copy Service rem create table pub details pubnum number 5 not null Volpartnum char 20 not null Num pages number 3 Num plates number 3 L
17. ble Non enterable 8 DISPLAYTITLE Page 1 Line 9 Column 2 Non table Non enterable 15 40 67 Character Number Character Money R Character Length 2 Length 234 Displayed 10 Length 8 Length 7 Length 78 16 SQL FORMS Application CSDBASE owned by COPY SERVICE as at 12 DEC 88 7 record Block csgeodx2 csgeodx2 Starts on Page 1 Field Field Field Table CSGEODX2 Block level Triggers KEY COMMIT STEP 1 HEXEMACRO NULL Actions If step not successful stop with error No Message KEY DELREC STEP 1 HEXEMAGRO NULL Actions If step not successful stop with error No Message KEY NXTBLK STEP 1 HEXEMACRO NXTBLK GLRBLK Actions If step not successful stop with error No Message 1 GDXNUM Character Length 8 Non displayed Copied from CSGEODXI GDXNUM 2 AUTHOR Character Length 60 Page I Line 1 Column 2 Non updatable Help Message Enter value for AUTHOR 3 ORDER SEQUENCE Number Length 234 Page 1 Line 1 Column 69 Displayed 2 Non enterable Queryable No Help Message 17 SQL FORMS Application CSDBASE owned by COPY SERVICE as at 12 DEC 88 14 record Block GDXDETAILS BMR BULLETINS REPORTS RECORDS DATA Starts on Page 2 Field Field Field Field Table PUB DETAILS Block level Triggers POST QUERY STEP 1 SELECT NVL GDXDETAILS NUM PAGES 0 COST INTO GDXDETAILS COST FROM COST WHERE COST TYPE COST PER PAGE Actio
18. ell as geological and geophysical maps and sections The logical record structure of the database is given in appendix 1 and consists of 11 tables The schema used to create the database is given in appendix 2 This is a brief guide to the use of the data entry form for the Copy Service Database This form allows the user to query update insert and delete records from the database Appendix 3 provides complete documentation of the data entry form created using SQL FORMS including all imbedded triggers When a keyboard symbol appears in the following instructions it means that you press that key eg NL means press the carriage return key Shift F9 means that you must press the shift key before pressing the F9 key To run the data entry form enter COPYS NL After an introductory message a screen appears which prompts for the ORACLE username and password Enter your username Copy service hit NL then enter the password followed by NL to log into ORACLE A main menu then appears as follows MAIN MENU BMR BULLETINS REPORTS RECORDS REPORTS AMIAR CHAPTER PREPRINTS MARINE SEISMIC DATA WELL LOGS MAPS COST TABLE EXIT CO Ov Un Wh IP Choose the number corresponding to your desired option then hit NL For example if you enter 2 the block for data entry into the AMIAR table appears The C1 and C2 keys can be used to travel backwards and forwards between blocks To view a list of all the
19. ength of plates number 3 Price number 6 2 space CSDB 2 create unique index Pubnum in on Pub Details Pubnum Volpartnum rem rem Create the Report Table to hold data on Well Completion rem Reports Seismic Survey Reports Marine Survey Reports and rem Geophysical Survey Reports rem create table Report BMR File Num char 8 not null Govt Print Num number 5 not null Title char 240 not null Num Pages number 3 Num Plates number 3 Length of Plates number 3 space CSDB 1 create unique index File num in 1 on Report BMR File Num create unique index Govt Print Num in 1 on Report Govt Print Num create unique index Title in on Report Title rem rem Create a table for all authors of reports rem create table Author BMR File Num char 8 not null Author char 30 not null space CSDB 2 create index File Num in 2 on Author BMR File Num create index Author in on Author Author rem rem Create the AMIRP Table to hold data on AMIR pre print chapters rem create table Amirp Title char 50 not null Year number 4 not null Num Pages number 3 space CSDB 2 create unique index Title Year on AMIRP Title Year rem rem Create a Survey Table to hold the Seismic Survey Names rem and Numbers rem create table SurveyData Survey Num number 3 not null Survey Name char 50 not null space CSDB 2 create unique index Survey in 2 on SurveyData Survey Num create unique inde
20. ful stop with error No Message STEP 3 SELECT COST INTO AEROMAP CON DYE COST FROM COST WHERE COST TYPE DYELINE CONTOUR MAP Actions If step not successful stop with error No Message STEP 4 SELECT COST INTO AEROMAP CON FILM COST FROM COST WHERE COST TYPE FILM CONTOUR MAP Actions If step not successful stop with error No Message Field Field Field Field Field Field 36 SQL FORMS Application CSDBASE owned by COPY SERVICE as at 12 DEC 88 Block AEROMAP AEROMAP continued 1 SHEET NAME Character Length 22 Page 7 Line 12 Column 16 Mandatory Help Message Enter value for SHEET NAME KEY NXTFLD STEP 1 EXEMACRO EXETRG GETCOST NXTFLD Actions If step not successful stop with error No Message 2 SCALE Character Length 7 Page 7 Line 12 Column 57 Help Message Enter value for SCALE 3 GRID REF NUM Character Length 6 Page 7 Line 14 Column 16 Help Message Enter value for GRID REF NUM 4 BMR REF NUM Character Length 15 Page 7 Line 14 Column 57 Help Message Enter value for BMR REF NUM 5 RELEASE DATE Date Length 9 Page 7 Line 16 Column 16 Automatic Help Help Message DATE MUST BE IN THE FORMAT DD MMM YY EG 01 JAN 88 6 CONTOURED Character Length 1 Page Line l6 Column 37 Mandatory Automatic Help Help Message Enter Y for contoured maps N for uncontoured maps 37 SQL FORMS Application CSDBASE owned by COPY SERVICE
21. ions If step not successful stop with error No Message PRE DELETE STEP 1 DELETE FROM AUTHOR WHERE BMR FILE NUM REPORT BMR FILE NUM Actions If step not successful stop with error No Message Field 1 BMR FILE NUM Character Length 8 Page 3 Line 4 Column 20 Mandatory Help Message Enter value for BMR FILE NUM Field Field Field Field 21 SQL FORMS Application CSDBASE owned by COPY SERVICE as at 12 DEC 88 Block REPORT REPORTS continued POST CHANGE STEP 1 SELECT NVL REPORT NUM PAGES 0 COST INTO REPORT TEMP FROM COST WHERE COST TYPE COST PER PAGE Actions If step not successful stop with error No Message STEP 2 SELECT NVL REPORT LENGTH OF PLATES 0 GOST REPORT TEMP INTO REPORT TOTALCOST FROM COST WHERE COST TYPE DYELINE PER METRE Actions If step not successful stop with error No Message 2 GOVT PRINT NUM Number Length 5 Page 3 Line 4 Column 60 Mandatory Help Message Enter value for GOVT PRINT NUM 3 TITLE Page 3 Mandatory Character Length 100 Line 6 Column 20 Displayed 60 Help Message Enter value for TITLE 4 NUM PAGES Number R Length 3 Page 3 Line 8 Column 20 Help Message Enter value for NUM PAGES 5 NUM PLATES Number R Length 3 Page 3 Line 8 Column 60 Help Message Enter value for NUM PLATES Field Field Field 22 SQL FORMS Application CSDBASE owned by COPY SERVICE as at 12 D
22. ith error No Message 5 PRICE Money R Length 7 Page 5 Line 1 Colum 53 Help Message Enter value for PRICE 6 DYELINE COST Money R Length 7 Page 5 Line I Column 61 Non table Non enterable 7 FILM COST Money R Length 7 Page 5 Line 1 Column 69 Non table Non enterable 28 SQL FORMS Application CSDBASE owned by COPY SERVICE as at 12 DEC 88 4 record Block SHOTPOINTDATA SHOTPOINTDATA Starts on Page 5 Table SHOTPOINTDATA Field 1 PRODUCT CODE Character Page 5 Line 1 Column 5 Copied from SEISMICDATA PRODUCT CODE Mandatory Help Message Enter value for PRODUCT CODE Field 2 PART Character Page 5 Line 1 Column 20 Help Message Enter value for PART Field 3 PART START Character Page 5 Line I Column 28 Help Message Enter value for PART START Field 4 PART STOP Character Page 5 Line 1 Column 41 Help Message Enter value for PART STOP Length 11 Length 5 Length 10 Length 10 29 SQL FORMS Application CSDBASE owned by COPY SERVICE as at 12 DEC 88 l record Block WELL PEDIN WELL LOGS Starts on Page 6 Field Field Field Table WELL Block level Triggers KEY COMMIT STEP 1 HEXEMACRO NULL Actions If step not successful stop with error No Message KEY ENTQRY STEP 1 EXEMACRO ENTQRY EXETRG Q NEXTBLOCK Actions If step not successful stop with error No Message KEY EXEQRY STEP 1 HEXEMACRO EXEQRY EXETRG Q NEXTBLOCK Actions If
23. lp Message Enter value for TOP 4 BOTTOM Number R Length 10 Page 6 Line 1 Column 50 Help Message Enter value for BOTTOM 32 SQL FORMS Application CSDBASE owned by COPY SERVICE as at 12 DEC 88 15 record Block LOG DETAILS COPY SERVICE WELL LOGS Starts on Page 9 Table LOG DETAILS Field 1 WELL NAME Character Length 30 Page 9 Line I Column 2 Displayed 20 Mandatory Help Message Enter value for WELL NAME Field 2 LOG TYPE Character Length 20 Page 9 Line 1 Column 23 Mandatory Help Message Enter value for LOG TYPE Field 3 BMR FILE NUM Character Length 8 Page 9 Line I Column 43 Help Message Enter value for BMR FILE NUM Field 4 FILM COST Money R Length 7 Page 9 Line 1 Column 73 Non table Non enterable Field 5 IN COPYS Character Length 1 Page 9 Line I Column 51 Automatic Help Help Message Enter Y if log is in Copy Service Field 6 GOVT PRINT NUM Number R Length 5 Page 9 Line 1 Column 53 Help Message Enter value for GOVT PRINT NUM Field 7 LENGTH OF LOG Number R Length 3 Page 9 Line 1 Column 59 Help Message Enter value for LENGTH OF LOG 33 SQL FORMS Application CSDBASE owned by COPY SERVICE as at 12 DEC 88 Block LOG DETAILS COPY SERVICE WELL LOGS continued POST CHANGE STEP 1 SELECT NVL LOG DETAILS LENGTH OF LOG 0 COST INTO LOG DETAILS DYELINE COST FROM COST WHERE COST TYPE DYELINE PER METRE Actions If step not successful stop
24. me or the BMR file number The query will retrieve all logs recorded for that well and the interval over which they were run If more than 12 logs were run for a particular well press C2 to go to the next block and C4 to bring up the rest of the logs for that well This screen can be used to obtain more information on logs especially on those that are not held by the copy service 7 WELL LOGS This screen accesses a table which contains all well logs held at the BMR Only a proportion of these are held by the copy service The well name log type and BMR file number of these logs are already in the table If the log is held in the copy service then enter Y for yes in the IN CS field The government printer number and length of log should also be entered for these logs and the costs of a dyeline and film reproduction are calculated automatically 8 GEOLOGIGAL COMPILATION SHEETS AND GEOCHEMICAL MAPS The names of 1 100 000 sheets in Australia have already been entered into the sheet name field The other fields should be updated as these maps are requested Coverage is indicated by a P or C in the coverage field for partial and complete coverage of the map area 9 GRAVITY RADIOMETRIC AND TOTAL MAGNETIC INTENSITY MAPS The names of 1 250 000 sheets in Australia have already been entered in the sheet name field The other fields should be updated as these maps are requested If a map is contoured enter Y in the Contoured field
25. n GeoMap Sheet name create table AeroMap Sheet name char 22 not null Scale char 7 Grid Ref Num char 6 BMR Ref Num char 15 Release date date Data type char 20 Contoured char 1 space CSDB 1 create index sheet name in 2 on AeroMap Sheet name create unique index Grid Ref num in on AeroMap Grid ref num rem rem Create the Cost Table to hold data on Copy Charges rem create table Cost Cost Type char 20 not null Cost number 6 2 space CSDB 3 11 APPENDIX 3 DATA ENTRY FORM DESIGNER DOCUMENTATION SQL FORMS Application CSDBASE owned by COPY SERVICE as at 12 DEC 88 Application level Triggers DO NOTHING STEP 1 HEXEMACRO NULL Actions If step not successful stop with error No Message Q NEXTBLOCK STEP 1 ZEXEMACRO NXTBLK CLRBLK EXEQRY PRVBLK Actions If step not successful stop with error No Message 12 SQL FORMS Application CSDBASE owned by COPY SERVICE Control Block menu MAIN MENU Starts on Page 10 Field 1 CHOICE Page 10 Line 18 as at 12 DEC 88 Number Length 1 Column 39 Non table Non queryable Value range from 1 to 8 Automatic Help Help Message NOTE ORACLE IS CASE SENSITIVE PLEASE BE CONSISTENT WHEN ENTERING AbCde DATA KEY NXTFLD STEP 1 HEXEMAGRO CASE CHOICE IS WHEN WHEN WHEN WHEN WHEN WHEN WHEN WHEN WHEN END CASE Actions 1 12 3 t FE 6 SE l 19 THEN THEN THEN THEN THEN THEN THEN THEN
26. nd authors can be entered one at a time Authors should be entered in a consistent manner eg surname followed by initials as in Bowen K C Always commit data to the database after it has been entered by pressing F3 You should then get a message at the bottom of the screen Transaction completed N records processed 4 AMIAR CHAPTER PREPRINTS The cost of these publications is automatically calculated based on the number of pages copied Enter records from left to right and press the NL key after each field has been entered Press the down arrow key to start entering a new record Press F3 to commit the records to the database 5 MARINE SEISMIC DATA To query this screen first query the upper block for survey number or survey name Move to the next block using the C2 key The survey number is automatically copied to the next block Press Fl to query this block and data should then appear in the other fields on the screen To obtain shot point data on a particular line place the cursor on the desired line press C2 and its product code is copied into the next block Then press Fl to query this block Please note that if a record is deleted from the upper block on the screen then all records from the next block with the same survey number are also deleted 51 6 WELL LOGS IN THE PEDIN DATABASE The PEDIN database can be accessed for query only Press F2 then enter a query which will usually be for the well na
27. ns If step not successful stop trigger No Message STEP 2 SELECT NVL GDXDETAILS LENGTH OF PLATES 0 COST GDXDETAILS COST INTO GDXDETAILS COST FROM COST WHERE COST TYPE DYELINE PER METRE Actions If step not successful stop trigger No Message 1 PUBNUM Number Length 3 Page 2 Line 1 Column 3 Copied from CSGEODX1 PUBNUM Help Message Enter value for PUBLICATION NUMBER 2 VOLPARTNUM Character Length 20 Page 2 Line 1 Column 11 Copied from CSGEODX1 VOLPARTNUM Help Message Enter value for VOLPARTNUM 3 NUM PAGES Number R Length 3 Page 2 Line 1 Column 36 Help Message Enter value for NUM PAGES 4 NUM PLATES Number R Length 3 Page 2 Line 1 Column 43 Help Message Enter value for NUM PLATES Field Field 18 SQL FORMS Application CSDBASE owned by COPY SERVICE as at 12 DEC 88 Block GDXDETAILS BMR BULLETINS REPORTS RECORDS DATA continued 5 LENGTH OF PLATES Number R Length 3 Page 2 Line I Column 51 Help Message Enter value for LENGTH OF PLATES 6 PRICE Money R Length 7 Page 2 Line 1 Column 59 Help Message Enter value for NUM COPIED KEY NXTFLD STEP 1 SELECT NVL GDXDETAILS NUM PAGES 0 COST INTO GDXDETAILS COST FROM COST WHERE COST TYPE COST PER PAGE Actions If step not successful stop with error and display TRIGGER STEP FAILED CHECK COST TABLE WHERE COST TYPE COST PER PAGE STEP 2 SELECT NVL GDXDETAILS LENGTH OF PLATES 0 COST GDX
28. pressing the function key F3 or leave the current screen In the latter case you are asked if you want to commit the changes you have made Answer y for yes only if you are sure the changes you have made are correct If the record is sucessfully committed the message Transaction complete 1 record processed appears at the bottom of the screen 2 3 Inserting Records into the Database To enter new data into the database the screen must be blank The screen is ready for data input when it is first viewed or when the create record function key F4 is pressed In general it is best to press the create record key F4 before a new record is entered As for updated records new records must be committed to the database using function key F3 or when prompted on exiting the screen When entering multiple records which differ from each other in only a minor way after the first record has been entered and committed press create record F4 to clear the screen then the duplicate record key shift F4 to copy the last record onto the screen Then you may alter the fields as necessary and commit the next record to the database 2 4 Deleting Records from the Database To delete a record from the database first summon the record onto the screen by querying the database Next press the delete record key shift F9 which will clear the record from the screen Then press F3 to commit the change to the database 2 5 Exiting the Form
29. r of Pages Number of Plates Length of Plates SEISMIC DATA Survey Number Line Number Product Code Price Length of Section LOG DETAILS Well Name Log Type BMR File Number Govt Print Num In Copy Service Length of Log COSTS Cost Type Cost LOGICAL RECORD STRUCTURE OF COPY SERVICE DATABASE REPORT AUTHORS BMR File Number Author SURVEY Survey Number Survey Name GEOLOGICAL MAPS Sheet Name Scale Coverage Price rem rem rem rem rem rem APPENDIX 2 SCHEMA FOR THE COPY SERVICE DATABASE rem rem Date May 1988 rem rem Author Tony Boston rem rem rem rem rem rem Create Space Definitions rem create space CSDB 1 Datapages Initial 200 Increment 50 Maxextents 9999 Pctfree 10 Indexpages Initial 50 Increment 25 Maxextents 9999 Partition A create space CSDB 2 Datapages Initial 50 Increment 25 Maxextents 9999 Pctfree 10 Indexpages Initial 20 Increment 10 Maxextents 9999 Partition A create space CSDB 3 Datapages Initial 10 Increment 5 Maxextents 9999 Petfree 10 Indexpages Initial 10 Increment 5 Maxextents 9999 Partition A rem rem Create the views csgeodxl and csgeodx2 based on information rem in GEODX database relevant to the copy service That is BMR rem Bulletins Reports and Records which have Publication IDs of rem 183 185 and 191 respectively rem create view csgeodxl gdxnum title pubnum volpartnum status pubd
30. screens in the form use shift F2 A complete list of all keys used in the forms package and their function is given at the end of this guide An example of each screen in the form and detailed information on their use is given in appendices 4 and 5 respectively 2 Data Entry 2 1 Querying the Database Move to the block which corresponds with the table you wish to query To initiate a query of the database press function key F2 enter query Move to the field s to be queried using the NL and HOME keys and enter query data For example if you wish to query the well logs table for logs from the well Crunter 1 press F2 and enter this name in the well name field Alternatively the symbol may be used for general searches For example Grunter entered in the well name field would search for all records with well names starting with Grunter To execute the query press function key Fl After a small delay during which the word Working appears at the bottom of the screen the retrieved data appears on the screen If many records are retrieved by a query they may be searched through by using the arrow keys 2 2 Updating the Database To update data retrieved to a form as the result of a query modify the data as it appears on the screen If many records have been retrieved you may step through them with the arrow keys and make any necessary changes The changes do not affect the database itself until you commit by
31. x Survey name in on SurveyData Survey Name rem rem Create the Seismic Table to hold data on Seismic Survey rem Sections rem create table SeismicData Survey Num number 3 not null Line num char 15 not null Product code char 11 not null Price number 6 2 Length of Section number 3 space CSDB 2 create index Survey in 1 on SeismicData Survey Num create unique index Prod in 1 on SeismicData Product Code rem rem Create the Shot Point Data table to contain data on the number rem of parts in the line and the shot points of those parts rem create table ShotPointData Product Code char 11 not null Part char 5 Part Start char 10 Part Stop char 10 space CSDB 2 create index Prod in 2 on ShotPointData Product Code rem rem Create the Log Table to hold data on Schlumberger Logs rem create table Log details Well name char 30 not null Log Type char 20 not null BMR file num char 8 Govt Print num number 5 In cs char 1 Length of Log number 3 space CSDB 2 10 create index File num in 3 on Log details BMR File Num create index Govt Print num in 2 on Log details Govt Print Num create unique index Well name Log type in on Log details Well Name Log Type rem rem Create the Map Tables to hold data on B M R Maps rem create table GeoMap Sheet name char 22 not null Scale char 7 Coverage char 1 Price number 6 2 space CSDB 1 create index Sheet name in 1 o
Download Pdf Manuals
Related Search