Home

Solomon Land/Training Manual

1. Created Modify Approval 10 24 2005 SYSADMIN 10 24 2005 SYSADMIN fot SYSADMIN 02 16 2006 lt F9 gt Opens the Note field next for the line in Focus CTRL S to save then Shift Tab puts focus on the OK button then Space Bar closes the note Tab off the Note column for lt F9 gt to work NOTE Provisions are also included as Remarks 411 LEASE CROSS REFERENCES All leases and tracts may be cross referenced to a Lease Tract Prospect Segment Contracts or Producing Property The following screen may be used to review associated cross references to a lease tract Refer to Sections 2 1 13 through 2 1 13E in the LANDMAN System User Manual for detailed information S Lease Tract Cross References LM 107 00 olx Lease No i Menu Lease Name SE View All C Lease Tract Prospect C Location C Contract C General Xref Te ey a T tm Noni m e E Ea E 6 E a a 10 Er m 4 gt Q Details Enter a Lease Number 17 Characters max or press lt F3 gt to view existing Created Modify Approval i ft i DEVELOP SYSADMIN 7 19 01 NOTE Within a lease contract cross references may be added or deleted This is independent of the function being performed on the lease tract i e you may delete a cross reference to a contract but not delete the contract and vice versa NOTE You may not update contract information here
2. To Selection Criteria Cross Ref Type L Tract Lease Level Beginning Lease No Ending Lease No Po Refresh Grid Select All De Select All Generate Cross References To Lease No Mee Lease Name Sel No m o A o Ex o a o 5 o 6 Oo Ex o m o g m 10 o is K gt DEVELOP SYSADMIN 01 23 2002 In the From Section select the type of Cross Reference you want to make from the drop down box CGI INC Page 28 Land Management System Training Manual Section 5 Multiple Cross References LM 108 00 From Cross Ref Type Lease Tract Prospect Location Contract General Xref To Selection Criteria Cross Ref Type Lease Tract v Beginning Lease No I Lease Level Ending Lease No Refresh Grid SelectAll De Select All Generate Cross References To Tract No Lease No oh eet Sty tere ty a A E es fret se a E Lease Name oo v mimimaal z _ DEVELOP SYSADMIN 01 23 2002 Selecting Lease Tract will change the From Section to the following CGI INC Page 29 Land Management System Training Manual Section 5 From Cross Ret Type Lease Tract v Lease Tract No 00002 001 0o00 Enter a valid Lease Number or use the lt F3 gt table lookup feature Enter a valid Tract Number
3. Filter the data by company and Lease Query Wizard Filter Data xi Filter the data to specify which rows to include in your query If you don t want to filter the data click Next Column to filter Only include rows where CpnylD equals 001 v LeaseTypeCode And Or LessorlD Rental amp 4mount z Z InstrumentT ypeCode A fed tay ExpirationD ate Lease E ffectiveD ate z z And C Gr or Query Wizard Filter Data xi Filter the data to specify which rows to include in your query If you don t want to filter the data click Next Column to filter Only include rows where m LeaseNo begins with fi LeaseName LeaseTypeCode And Or LessorlD Rentaldmount z zi InstrumentT ypeCode Cad Or ExpirationD ate LeaseE ffectiveD ate v fs 4nd Ss Sr onea Sort by Query Wizard Sort Order xi Specify how you want your data sorted If you don t want to sort the data click Next Sort by ws P _ Ascending E tionD at abies Descending Then by leseno Sf Ascending C Descending Then by InstrumentT ypeCode g Ascending EA sara C Descending el o lt Back Cancel Click next and return data to Excel Query Wizard Finish What would you like to do next Save Query View data or edit query in Microsoft Query Create an OLAP Cube from this query o
4. 01 17 2002 Click on the Select Tab Select for the following screen CGI INC Page 12 Land Management System Training Manual Section 5 Gease Summary Report LM 605 00 E a x Template Report Sort Options Cover Page Company Selection Field l Operator Val 2 Print Print Preview Printer Options HOUSTON1 HP LaserJet 4 on HPWest DEVELOP SYSADMIN 01 17 2002 e Using the lt F3 gt table lookup feature under Field select xvr_lm605p lleaseno as shown below e Using the lt F3 gt table lookup feature under Operator select Equal as shown below if you electing to print only one lease You may use the Greater than and Less than or equal to to select a range Refer to the LANDMAN Report Assistant Manual for assistance in setting values e Type in the lease number you wish to print You may not use the lt F3 gt table lookup feature in the Value field CGI INC Page 13 Land Management System Training Manual Section 5 ease Summary Report LM 605 00 Template Report Sort Select Options Cover Page Company Selection Field Operator Value Boolean hvr_Im605p lleaseno Equal VT42010001 00 And Print Print Preview Printer Options HOUSTON1 HP LaserJet 4 on HPWest DEVELOP SYSADMIN 01 17 2002 Next select the Options tab tions On the Options ta
5. CGI INC Page 31 Land Management System Training Manual Section 5 Multiple Cross References LM 108 00 From Cross Ref Type z To Selection Criteria Cross Ref Type J Lease Level Lease Tract v ease Tract Beginning Lease No Prospect Location Ending Lease No Refresh Grid Select All De Select All Generate Cross References To Lease No Mee Lease Name Sel No m o A o Ex o a o 5 o 6 Oo EX o ee o g m 10 o p a z Once you make your selection from the drop down box If selecting Lease Tract and not checking mi A DEVELOP SYSADMIN 01 23 2002 the lease grid will CGI INC Page 32 Land Management System Training Manual Section 5 display all tracts for all leases E Multiple Cross References LM 108 00 From See below Cross Ref Type Prospect Prospect Seg No 901 ooo L Cross Ref Type To Selection Criteria Beginning Lease No Lease Tract v I Lease Level Ending Lease No Select All De Select All Generate Cross References Lease No 4 00002 001 2 00002 001 3 01404 001 4 01404 001 5 01404 001 g 12345 7 12345 a 1234566666666 g 1234A p DEVELOP SYSADMIN 01 23 2002 Tract No 000 001 000 001 002 000 001 000 000 Lease Name st oO st g
6. xvt_Im608p leasename xvr _Im608p leaseno Property Inquiry LM 608 00 CGI INC Page 14 Land Management System Training Manual Section 3 Transaction Import EJ Microsoft Excel Lease xls ioixi Eile Edit View Insert Format Tools Data Window Help Type a question for help X OEE EE AO ERA Dee AR GRAY ABe SJ nae E sl wm B G 2 92a 4 DG GB BH BH A YeReoly with che Pesta t KHe nee ye E K cLeaseNo cLeaseName cCriticalLease cLeaseAltSe cLessorLeaseh cLessorlD cLessorName cLesseell cLesseeName cBrokerlD cBrokerNar c AR 777SWL 0009 on D Jr et al ooooot Too T00001 AR 777SWL 0010 mes ooooot T0001 AR 777SWL 0011 avid ooooot TooO01 AR 77SWL 0012 im ooooot T00001 AR 777SWL 0013 onnie ooooot T00001 AR 777SWL 0014 nel Foo0001 T00001 Arial 10 BZU B A 168 53 M 4 gt r Lease Draft Z Costlvl RelParty Z Contacts Leasecsv Ready CGI INC Page 15 Land Management System Training Manual Section 3 3 5 CODE DESCRIPTION MAINTENANCE After adding a Name and Address we return to the File Maintenance Menu and select Code Description Maintenance oI x File Maintenance Find Master Listings Reports Payment Processing Invoice Processing Utilities Leases DEVELOP VTOWNSEND 04 26 2002 Prospects Producing Properties Contracts General Cross Ref Name and Address Code Descriptions Nation State
7. 21x IBM My Data Sources My Pictures NameIDs Favorites File name db 1 mdb Save as type microsoft Access Databases mdb EQ Microsoft Access 16 x Eile Edit View Insert Tools Window Help Type a question for help see alSay mae o ta ols e e Q amp amp db1 Database Access 2000 file format Qoen BE Design iNew X lt 20 lt EEE Create table by using wizard Create table by entering data alex File Edit View Insert Tools Window Help Type a question for help SO new Gran o HE ga ty o al a 3 Ctri O using wizard entering data Database Properties 1db1 mdb 2 000Transfer AccessDBs Pcs mdb 3 Legal Agreements mdb 4LPR_19991111_2000 mdb Exit Ready NUM start e a A K inbox mic G 3 Floppy Boantelopen somon B microsofe Hooe LAIN 1 58PM Microsoft Access i _ e x File Edit View Insert Tools Window Help Type a question for help Dee aeh Belo B H leal tabase Access 2000 file format Gonen BE pesin New 2o EE EE Objects a Create table in Design view Tables Create table by using wizard Lookin a My Documents z e X Ei E Toos 2 x Microsoft Access mdb mda mde Exchange HTML Documents html htm Outlook Paradox db Text Files txt csv tab asc ODBC Databases Ready
8. FARMOUT AGREEMENTS Contracts to assign oil and gas lease rights upon completion of a specified drilling obligation and the performance of the other obligations and conditions contained in the agreement FEDERAL ACRES Acres owned by the government There are restrictions on number of acres that may be leased by one company FEE SIMPLE OR ABSOLUTE LEASE If the owner of the land owns an interest which has no limit on its durations FIXED TERM LEASE No provision to extend lease No longer used HABENDUM CLAUSE Clause of special limitation consisting of 2 parts a Primary Term of Lease b Secondary Term of Lease Sets forth the duration of a lease LEASEHOLD INTEREST Percentage of ownership held by the lessee under an oil gas or minerals lease MAP REFERENCES An abbreviated description that gives the primary information necessary to locate the general area of the lease s location on a map CGI INC Page 67 Land Management System Training Manual Section 5 MINERAL INTEREST The property interest created in oil and gas after a SEVERANCE by MINERAL DEED or oil and gas LEASE MINIMUM ROYALTY Lease clause stating that the royalty paid must equal a stipulated amount for each year of the lease If the actual royalty payment does not equal this amount a make up payment of the difference is paid at the end of the year Also if a federal lease is classified as Productive but there is no actual production an annual p
9. Is it possible to transfer or copy one lease to another ANSWER Yes A Lease Copy is a stand alone function under Utilities This function allows copying all or parts of one lease to another or to a group of leases The Copy button on the lease entry screen also provides this capability Copying a default lease can be very time efficient B Transferring a lease is a stand alone function under Utilities This function allows transferring a lease from one lease ID to another lease ID C Tract data may be copied from lease to lease or within a lease with the lease copy function under Utilities Edit Template Submit Navigation Favorites E aA 1K RMA a Be So mel Ed Copy From Copy To Lease No Tract No Beginning Lease No Ending Lease No Copy Only Copy and Replace Refresh Grid Select All De Select All with Notes without Notes Lease No Tract No Copy IE eal C Select All De Select All 2 oO include __ 3 O 4 O Lease Tract L l Text j e Tr I Legal Te OC I Drafts Remarks Ler oO ia El Related Parties Chain of Title 8 oO ea oO T Contacts I Special Obligations 10 iy 11 I Additional Cnty Cross Ref ALL 12 Oo Cont t IM Payment Oblig E R 13 oO n Fro ucing 14 oO roperty m I Map References 15 O v 4 001 SYSADMIN 09 03 2004 CGI INC Page 2 Land Manag
10. for conversions or exporting use with extreme caution always an extra backup before using the SQL query for any updates Note The display is in grid mode and may be copied and pasted into Excel as well ed SQL Query Analyzer iol x File Edit Query Tools Window Help a S aat SOBA Mm v gt m U Feno 7 E S Q sie ti Query LYOUNGBLOOD PioneerApp sa Untitled1 select from xlmmleas where acquiredcode 1 and acquiredFromID umc001 Change the Acquired from ID from UMCOO1 to 000001 update xlmmleas set acquiredfromID O00001 where acquiredcode and acquiredFromID bd 4 gt AcquiredCode AcquiredDate AcquiredFromID AcquiredFromTextID BonusAmount BonusCoShare Bo 1 00 00 00 1996 07 01 uMNcOoo1 0 0 0 0 0 1996 07 01 00 00 00 UMCO01 1996 07 01 00 00 00 UVMCO01 1996 07 01 00 00 00 UMCOO1 1900 01 01 00 00 00 UMNCOO1 1996 07 01 00 00 00 UMcOO1 1996 07 01 00 00 00 UNCOOL 1 a Joan bl UlNj e 0 F Query batch completed LYOUNGBLOOD 8 0 fsa 68 PioneerApp 0 00 00 27S5rows Ln2 Coli 4 Connections 1 NUM Ui 4 22 Import Export Purge Requires System Administrator Database access Rights Do not enter ie blank as the drop code 4 23 PROSPECTS Prospect Maintenance involves several screens displayed by making the following selections SJandrton menu mooo E File Maintenance Find Master Listings Reports Payment Processing Invoice Processing Utilitie
11. City JuvincsTON OO State Province a ZIP Postal code 77351 9506 Country Region I 7 IV Show this again when address is incomplete or unclear CGI INC Page 46 Land Management System Training Manual Section 5 GENERAL TAB o FULL NAME a Base Record For Name Type Individual use First Name and Last Name For Name Types having only one name field use Last Name b For Contacts use Contact Name o JOB TITLE a Base Record blank b If record is created from Contact Tab use xcmmphon title o COMPANY All records For Name Type Individual use First Name Last Name For Name Types having only one name field use Last Name o FILE AS All records Alt Sequence from Xcmmname o ADDRESS a Base Record From Xcmmaddr first address ID b For Contacts use Address from xcmmaddr for xcmmphon AtAddrID o BUSINESS phone a Base Record Main Phone from xcmmaddr b Work Phone No if record is for a Contact If Contact Work Phone No is blank use Main Phone from Xcmmaddr if present o HOME phone a Base Record Blank b Home Phone No if record is for a Contact o BUSINESS FAX a Base Record Fax No from xcmmaddr b Fax No from Contact if record is for a Contact If Contact Fax No is blank use Fax Number from Xcmmaddr if present o MOBILE a Base Record Blank b Cellular Phone No if record is for a Contact o Web Page Address All records Xcmmaddr Website o E Mail a Base Record
12. M Legal Tex Ease F 0 O a Copy 001 SYSADMIN 10 04 2002 Should work just fine this way NEW PROCEDURES TO COPY REMARKS This lease has no remarks and only one tract 000 CGI INC Page 51 Land Management System Training Manual Section 5 Kot ease Tract Remarks LM 105 00 VT CA 01 065 01 FANNELL KATE C This lease has six 6 tracts CGI INC Page 52 Land Management System Training Manual Section 5 There are remarks on the lease level and Tract 006 CGI INC Page 53 Land Management System Training Manual Section 5 Ky Lease Tract Remarks LM 105 00 Lease No DOROTHY a Meu Lease Name DOROTHY JOHNSON Remark Tract r yA BES Applies Type Description Note 1 BACK px Yes BACK IN 2 EXTN 006 Yes EXTENSION 3 4 i E gt a Created Modify Approval 12 13 2001 SYSADMIN 12713 2001 SYSADMIN bof E DEVELOP SYSADMIN 12714 2001 This lease has no remarks ease Tract Remarks LM 105 00 lel Fs Lease No VT CA 01 065 01 Lease Name FANNELL KATE C Remark Tract Applies Type Description Note Created Modify Approval Fran EE Ey nnn ees O DEVELOP SYSADMIN 12 14 2001 Page 54 Land Management System Training Manual Section 5 We want to copy t
13. Manual Checks Tot Pymnt Amt Created Modify Approval i Bi i DEVELOP SYSADMIN 10 30 2001 Above there is one complete screen for depository information 1 The check section for entering information for the check 2 The check remittance for entering payees to be listed on the check remittance or check stub voucher NOTE This portion of the screen ONLY needs to be entered if there is more than one payee on a single check or if you want to enter some of the additional information Refer to Sections 2 1 8 through 2 1 8B in the LANDMAN System User Manual for additional information Fe 4 Payment Obligation L PAYEES selection from command line S YY 11 Check Section m m m 001 002 003 Payment Payment Payment Number Number Number a L a Remittances Section m m m Payee Payee Payee Payee Payee Payee oo1 002 oo1 002 oo1 002 E EE i oe ay eee 4 8 2 LOCATION ALLOCATION The screen below shows the location allocation as setup is defined to interface with JIB O Location Allocation OF x 7 JIB Allocation Location ID Location Name DOI Number Decimal 4 sus AFE oe Description 7 00159311 MAIN PASS 299 4 1 p31 470100
14. A To save data that might be lost due to 1 System Hardware Failure 2 A power outage or surge 3 An operator error or accidental erasure B To free up disk space for current uses by backing up and then deleting old or infrequently used information G To archive data for permanent storage and future use D To save data prior to certain processing steps which might be needed if the processing step needs to be rerun The hard disk on your PC can store huge volumes of information which can be lost in a FRACTION FOR A SECOND and which might take many hours weeks or even months for you to recover CGI INC Page 4 Land Management System Training Manual Section 2 WHAT TO BACKUP SOFTWARE There are two types of software or programs The first is System software which includes the operating system PC DOS MS DOS etc and utilities like print spoolers The second type of software is referred to as Applications software These are programs like LAND which are designed to handle special applications like accounting engineering etc DATA Data is your information Your accounting information is an example of data This would include everything from individual invoices input into the system to general ledger balances and budgets WHEN TO BACKUP SYSTEM SOFTWARE You should make a permanent backup of any program you buy as soon as you get it This includes when PetroComp sends an update of even just one or
15. Acquired From ee uM Sienu Additional Counties General Info Acquired Code Rental Owner Instr Type Shutln Lease Type Alt Lease No LSE UDC 01 I Release Required LSE UDC 02 Print Lease Drop Date Code i Data Sheet Created Modified Approved i ER ik DEVELOP SYSADMIN 12 03 2001 Now proceed to the General Information tab by moving the cursor to this tab Click on the Cost tab to reveal the cost information This also applies to the Summary Burdens Drafts Contacts and Related Parties sections Note Any data field can be made required as you desire using the flexible and easy to use Customization Manager Below only the lease No and Lease Name are delivered out of the box as required fields You decide what data fields are required for your operation TITLE BAR TABS BUTTONS Lease Maintenance LM 100 00 Bel x Actions Pe axKW Feo F HlO amp SB Alt Sequence a Date ee Grantor Lease No sE i Lessor Ol Lease Term 0 Years Lessee Exp Date i Broker Acquired i Region General Info Related Parties Acquired From o oo Acre 0 00 Acquired Code Rental poop Acre 0 00 Owner Instr Type Shut In Acre 0 00 0 00 Lease Type Alt Lease No Lease 5C 1 I Release Required Lease SC 2 Drop Date Code fee E Copy Lease Bu owe Created Modified Approved Es
16. Send an e mail to her at the same time showing which checks are coming through the courier 18 ___ Make additional set of copies for our check control file next to checks and check log Copy onto green our control copy pink payee s copy and white accounting s copy Copies go to accounting as follows One copy of everything to who enters the positive pay entries for every check with purple cover sheet reflecting which checks those below each have a cover sheet If chargeable to a well including shut ins send to yellow coversheet Recoupable rentals payable to MMS go to green coversheet Recoupable rentals payable to individuals go to blue coversheet Undeveloped rentals go to gold coversheet 19 ___ Certify according to departmental guidelines Rentals If large payment undeveloped or terminable leases to the MMS see guidelines Shut ins Above 25 or outside of Oklahoma others 21 Print Check Register for file Backup Payment files whe1 all checks are finalized and tendered IT will do this step at this time 22 Check Update writes information into the lease file Payment History table and screen 23 Print Payment History Report to ensure they all posted correctly and or spot check a couple of leases on the lease payment history screen 24 Print the Invoice Report Notes x Procedures PayProcessChecklist Land Management System Training Manual Section 1 1 0 LANDMAN TRAINING SYS
17. Training Manual Section I 45 Can I tell who changed which data field in a lease and when Can I tell the value the data field originally contained ANSWER Yes This is the purpose of the Audit manager Audit Log iewer CM 006 00 lel Ed Actions Je ax es e 2 3 zll Ot SB Result Sort By Table 7 Date Time User ID Computer Application Name Lease XLMMLEAS 11 05 2005 11 19 27 570 SYSADMIN LYOUNGELOOD Solomon I LM10000 3 Field Name 001 001 TXWISE1001 TxWISE1001 UDCLease1 IDn SES eee UMCSIG UserMaintKey 27429 UserMaintKey 27434 001 SYSADMIN 11 05 2005 46 Can we Scan Images pictures contracts and attach them to the lease and contract records ANSWER Yes this is an optional module Currently 5500 for Land Contracts and Common files only For accounting and production the cost increases Additional costs for each additional user 47 How do I find a lease when I only know the social security number of the Lessor ANSWER Use F3 in Name Address to find the person s name Then use the Find leases binoculars Icon CGI INC Page 20 Land Management System Training Manual Section 1 48 How do I find a lease when I only know the last name of the Lessor ANSWER Find Leases LM 920 00 49 Can I print a Master Division Order i e a division order showing all owners in a location Can I print individual
18. You need to do that in contract maintenance You may click on the contract cross reference and then the details button provides access to the contract for maintenance or detail review lt F9 gt Opens the Note field next for the line in Focus CTRL S to save then Shift Tab Shift Tab puts focus on the OK button then Space Bar closes the note 4 12 ADDITIONAL COUNTY CROSS REFERENCE If required this screen will define secondary counties that a lease tract may cover For each county the acres and a description may be maintained The information entered here is only listed on the Lease Data Sheets SB Additional Counties LM 112 00 lolx Lease No A O __ Tract Nation State County County Name Recording Date l 1 e 3 4 5 gen e pa aL Pa F DEVELOP SYSADMIN 7 19 01 In general we recommend setting up a separate tract under a lease when the lease crosses counties Refer to Sections 2 1 14 in the LANDMAN System User Manual for detailed information lt F9 gt Opens the Note field next for the line in Focus CTRL S to save then Shift Tab Shift Tab puts focus on the OK button then Space Bar closes the note 413 MAP REFERENCE Map References for each tract in a lease may be entered using this screen The Township Range Section or County Abstract State for each Map Reference must be entered This will allow the Lease Tracts to be reported by Map Reference An un
19. enter the gross lease acres net lease acres and company net acres for the second tract and uncheck the count acres flag This will result in the acreage not being added to any totals Discuss Sort order of tract numbers 001 01 101 vs O1A 201 01B 4 7 LEASE OWNERSHIP PARTNER OWNERS For each tract within a lease it is possible to associate the partners or owners who have an interest in the tract Menu Click on the Ownership button below the Manu button eae to access the following screen An large number of partners may be defined for each tract Refer to Section 2 1 7 in the LANDMAN System User Manual for additional information Land Division of Interest Maintenance LM 130 00 Actions Jed Xk e z MlO amp SS p Display Options DOI Number ZNEW a Sub No ooo Description znew Current ort By x Status Active 7 Status Date 91 01 2000 C All Owner ID Owner Interest Decimal Decimal Decimal p a Setup ID Owner Name Class Eff Date End Date eee Billable Paid By Operator Notify Short Remark Date 1 000001 Allan Business wW 01201 2005 12 31 2078 o 50000000 O JEJ E E 12 08 2005 2 3D0101 3DO0IL amp GAS wW 01201 2005 12 31 2078 O 50000000 fx El oO E 12 08 2005 3 Oo Oo ea a E 4 o o EE 5 o m me E E m 6 oco koo a m m m zi 4 gt Q Copy From DOI Copy To DOI Balance Date 43 44 2005 Enter a Valid Owner ID from the Name Address Ta
20. 00 Draft Due RentPerAcre Oil ORRI Other Charges 0 00 Total Consideration 0 00 TotalRent Gas ORRI LOCATION gt TractNo Map Type Quartering SvyLegalDescription Lots Block Survey Abstract Section Twn NS Rng EW a 001 zl StatelD County ID Min Owner Int COI Int Type Company Int Gross Tract Overlap Owner Net AC Co Net AC 0 0 00000000 zl 00000000 000000 000000 000000 000000 Record I4 lt CRITICAL LEASE REMARKS gt Type Record I4 LEASE PAYMEHT OBLIGATIONS PaymentAmount 0 00 Date1stPayment Record M1 lt 1 gt bu fp of 1 Fc E nd Jima CGI INC Page 41 Land Management System Training Manual Section 5 EJ Solomon I Menu my ici x Land Management Impor ExporPurge Leases Import Export Purge DOls Inport Access File Lease Maintenance Lease Legal Description Tract Maintenance Ownership Leasehold Ownership Transfer Map References F LandMan Menu LM 000 00 Import Access File CGI INC Page 42 Land Management System Training Manual Section 5 Access File Import Choose a destination To where do you want to copy data CGI INC Page 43 Land Management System Training Manual Section 5 5 6 Outlook Interface Wf Name amp Address Maintenance CM 110 00 olx zes g active l 871 2000 findividua Mo SHIRELY A SYLESTINE RESER SHIRELY A E T 3 BOX 414 B CGI INC
21. 0141141961 0 00 001 1 CA001 009 00 EST OF JOHN VICTORINO MACHADO FE LS 03 24 1964 0 00 09 24 1963 0 00 001 1 CA001 004 00 JOHN C RATH ET UX FE os 08 06 1965 0 00 08 06 1962 0 00 001 1 CA001 003 00 GEORGE REID ET UX FE Os 01 22 1967 0 00 01 22 1962 0 00 001 1 CA001 008 00 ORVAL A DAGEN ET AL FE LS 03 13 1971 0 00 03 13 1961 0 00 001 1 WY001 002 00 ALBERT A HUNTER ET UX EE OLS 08 19 1972 0 00 08 19 1967 0 00 001 1 WY001 008 00 ST OF WY 66 15021 B ST LS 10 02 1976 0 00 10 02 1966 0 00 001 1 WY001 003 00 GEORGE R EMIGH ET UX FE OLS 08 16 1977 0 00 08 16 1967 0 00 001 1 WY001 009 00 ST OF WY 68 23993 A ST ojLS 07 02 1978 0 00 07 02 1968 0 00 001 1 WY001 006 00 BLM W 51429 FD OLs 08 01 1980 0 00 08 01 1975 0 00 001 1 WY001 004 00 BLM W 55723 FD LS 08 01 1981 0 00 08 01 1976 0 00 001 1 TX003 004 000 ROBERT R PETTY JR FE PETTO1 LS 07 16 1996 0 00 03 16 1996 0 00 001 1 TX003 003 000 ROBERT R PETTY JR ET UX NADENE D FE PETTO4 os 02 03 1998 0 00 02 03 1997 0 00 001 1 TX006 001 000 BENNY PRESTON BARKER FE BARKOS os 04 20 2002 0 00 04 20 2001 0 00 001 1 T 003 002 000 BILLIE HANKS SR ET UX ET AL FE HANKO2 OLS 04 01 2003 0 00 04 01 2002 0 00 M 4 gt pi Sheeti Sheet2 f Sheet3 Is tT Ready NUM B ACCESS Can be used as a more sophisticated report writer This procedure is very similar to the Excel procedure for those who are familiar with Access Capabilities File New Database Save in Y My Documents H Qx Ci E Tools Adobe
22. 2 3 TE X d 3 aa ol Created Modify Approval i Ez ve SYSADMIN 09 03 2004 28 How can a chain of title record be maintained ANSWER A Chain of Title screen is available to maintain pertinent data This section is located on the Land Menu then select Leases and then Chain of Title A CT remark may also be defined CGI INC Page 14 Land Management System Training Manual Section I 29 30 31 What detail items should be checked if the Payment Recommendation Report will not print ANSWER A A Payment Obligation record must be present and must contain valid dates for the reporting period and a valid Payment Type code B Payment Type must be defined in the Code Description File and must allow reporting and or payment Also check as payment due C A valid Payment Responsibility must be entered and settings in the Code Description File must allow reporting and or payment D Drop code and drop date must be blank What if we have prospects we want to keep as a Rental however we are not the operator and will not be paying rentals but still would like to keep track of them ANSWER Put into Prospect Screen Set up payment responsibility code of Pay Due Y but Company Pays N Can then run a Payment Recommendation to list Paid By Others However this will not cut a check because Payment Responsibility says company does not pay Within Producing Property Mainten
23. Acquired Code 4 PURCHASED Expire Date 03 27 1958 Drop Date Drop Code Lease Costs CGI INC Page 3 Land Management System Training Manual Section 2 2 3 BACKING UP amp RESTORING NOTES The data and information stored in LAND is very important You have a large investment in software and time spent using it Your company s efficient operation can be highly dependent upon the computer To ensure that you will always have ready access to this important information and to ensure that it is not lost you must backup BACKUPS have become the responsibility of IT departments It is your data your responsibility to confirm it is done and can be restored to a back up computer Learn how to make a backup to your own hard drive or to a CD to take to an off site location I illustrate with the following example IT department gets a new backup tape device and merrily backs up diligently and daily for over a month only to have IT realize when trying to restore from a tape that the nightly process was not working and nothing could be restored for the entire time the new tape was in operation Fortunately my Oklahoma client had been shown how to make her own backup to her own local C drive What does it mean to backup It means make a copy of the information stored on the computer so that it can be easily retrieved if the data on the computer is somehow lost or if old deleted data is needed for current use REASONS FOR BACKING UP
24. CAPABILITIES A EXCEL Can be used as a simple columnar report writer Your IT Department needs to provide you with Read only access rights to the SQL Database Click and drop down the Data menu select Import External data and New data base query ES Microsoft Excel Book1 Bel ix file Edit View Insert Format Tools Data window Help Type a question forhelp 8 X A 7 a aR Ola EER Osbaalearyistaae B ig ta ta a T G B BH A rereply with chances Cine i Form Ey gt Arial yi mE Fa 2 A n Subtotals Validation l J K E M N 0 Zz Table Text to Columns Consolidate Group and Outline gt ia PivotTable and PivotChart Report Import External Data 5 Import Data E New Web Query lg New Database Query E Sa X M 4 gt M Sheeti Shest2 Sheet3 IK i ols Ready NUM start dasa Bse Gla Bric Ble Bie f La B Grr E Emi B O8FROR B s sem Select the data base you have your Land data in usually the name will be XX XApp where XXX is you company ID First Find the Lease data in XLMMLEAG Query Wizard Choose Columns LMMLDSC xlmmidsc_vType1 xlmmidsc_vType2 gt LMMLEAS then select the columns you want in your query and click next Query Wizard Choose Columns CriticalleaseS w DropCode DropDate Freq FreqPeriod k S
25. CODE LISTING TYPE CODE DESCRIPTION L6 ADPY ADDITIONAL PAYMENT REQUIRED L6 CD CONTINUOUS DEVELOPMENT L6 CF CONFIDENTIALITY L6 CR COMPENSATORY ROYALTY L6 DR DRILLING REQUIREMENT L6 ER ESCALATING ROYALTY L6 GGOP GEOLOGICAL OPERATIONS L6 K KEEP SAKE ROYALTY L6 MR MINIMUM ROYALTY L6 OPER PLAN OF OPERATIONS L6 OPT OPTION TO RENEW OR EXTEND 16 REAS REASSIGNMENT OBLIGATION L6 RR RELEASE REQUIRED L6 SFRS SURFACE RESTORATION L6 SL SHUT IN L6 wo WORKOVER FIELD CODES TYPE CODE DESCRIPTION 18 10 CHAR 40 CHARACTERS Alpha amp Numeric SHORT DESC ADTL PYMT CONT DEV CONFIDENTIAL COMP ROY DRLG REQ ESC ROY GEOL OPS KEEP SAKE RY MIN ROY PLAN OF OPER OPTN TO REN REASSIGNMENT R S S LS REQU URF REST HUT IN WORKOVER SHORT DESC 12 CHARACTERS This code will be not be populated The design of this code is a company preference and should be set up by the User CROSS REFERENCE TYPE LISTING TYPE CODE DESCRIPTION SHORT DESC 21L ASMT ASSIGNMENT ASSIGNMENT ai POOL POOLING POOLING 21 SALE LEASE SALES PACKAGE LEASE SALE 21 UNIT UNITIZATION UNITIZATION CGI INC Page 3 Land Management System Training Manual Section 3 SURVEY CODES TYPE CODE DESCRIPTION SHORT DESC 22 14 CHAR 40 CHARACTERS 12 CHARACTERS Alpha amp Numeric This code will be not be populated This will vary by company and should be set up by the User PROSPECT CODES TYPE CODE DESCRIPTION SHORT DESC 23 17 CHAR 40 CHA
26. Ee ee Ee got SYSADMIN 12714 2005 lt F9 gt Opens the Note field next to the Lease number Shift Tab Shift Tab puts focus on the OK button then Space Bar closes the note You must use the mouse to click the note next to lessor lt F9 gt 4 1 COST INFORMATION The Cost Descriptions and codes must first be defined in Land Setup This screen is populated as payments are processed through the LANDMAN System Lease Maintenance LM 100 00 JdG 12 08 2005 SYSADMIN 12 08 2005 SYSADMIN Ea Ds tt SYSADMIN 11271472005 How do you want to capture costs NOTE The costs that will be tracked in the system must be setup in the Land Setup screen costs such as RN BN and SI for Rental Bonus or Shut In payments respectively for example The costs are kept calculated at the tract level and rolled up summed to the lease level 4 2 SUMMARY INFORMATION This screen is populated by data entered on the tract level oe r The Total Tracts is a counted number from each tract that is entered This field is display only The acreages are summarized from the tracts and are display only may not be changed on this screen 4 3 BURDENS INFORMATION This screen is populated by data input on the Tract level This information cannot be changed on this lease summary screen Bi Lease Maintenance LM 100 00 Lease No O A Images Lease Name I Critical Lease Alt Seque
27. General Ledger Accounts Payable Accounts Receivable Revenue Accounting Revenue Accrual MMS 2014 Joint Interest Billing AFE Tax Reporting Cash Manager Inventory Purchasing Payroll Advanced Payroll Production Accounting Government Reporting Economics Graphics Gas Plant Gas Balancing Contracts Management Partnership Management Chase REMM Maintenance Chase REMM Operations Only Chase REMM Interfaces Fees Fixed Assets Management E Land Management Maintenance Lease Maintenance Lease Legal Description Tract Maintenance Land Division of Interest Maintenance Tract Map Reference Lease Tract Payment Obligations Lease Tract Special Obligations Lease Tract Remarks Lease Chain of Title Additional Counties Lease Tract Cross References Billing History Maintenance Prospect Segment Maintenance Land Division of Interest Maintenance Prospect Map Reference Prospect Segment Special Obligations Prospect Segment Remarks Additional Counties Prospect Seg Cross References General Cross Reference Maintenance General Cross Reference Obligations General Cross Reference Remarks General Cross References COMPANY 001 Contract Contracts Master Maintenance Parties Map Reference Payment Obligations Special Obligations Remarks Cross References Amendments Contract Gas Plant Detail Marketing Dedication Contract Nominations Processes Import Export Purge Leases Import Export Purge DOIs Impor
28. Lease No iiss Lease Name Sel 4 Ea Oo a o 3 o ESA H 5 o E o a o a m a aa e 6 Solomo A Docum Sip untitled H 6 O1 8 G 6 Landva C Lease mjo Multipl CGI INC Page 39 Land Management System Training Manual Section 5 Once you have carefully chosen all of your From and To Criteria A Generate Cross References Selections select the Generate Cross References button The following screen will appear Confirm E x 2 Are you sure to create multiple cross references Select Yes to continue the following screen will appear to notify you that the appropriate cross references have been made xl i Successfully created CGI INC Page 40 Land Management System Training Manual Section 5 5 5 Field Data Capture LEASE PURCHASE REPORT ENTRY FOR FIELD DATA CAPTURE F Lease Purchase Report Bel x Eile Edit View Insert Format Records Tools Window Help M B SRY BBS gt B 4 21 Y By Vv ah IDENTIFICATION Lessor LeaseNo 1 Lease Type Lessee Lessor Lease No Instrument Type Lease BrokerName Old Lease No Status Region Code ProspectNo How Acq d District Acquisition LeaseDate Term 0 Book Book 2 ExpireDate Morr zl Page Page 2 EffectiveDate Release Req d g Entry Entry 2 AcquiredDate Lease Code Preliminary zl Record Date Record Date 2 LEASE COSTS BonusPerAc Oil Royalty Paid Up Rentals 0 00 Draft No BONUS Gas Royalty Bank Fees 0
29. Payment Review Update step on that lease 10 Get number of checks as reflected a the bottom of Check List be sure to initial check log and show number of checks taken must include voided checks on the log for tracking purposes If checks are printed directly from the printer be sure to reverse collate them prior to placing in the printer may not have to do this 11 Print Checks Again specify payment type or All then the month and the Report date you want to appear on the checks this should correspond with the day the checks are to be mailed Enter then the beginning check number double check the beginning check 12 __ Print Preview 13 SEND E MAIL TO GET I EOPLE OFF THE PRINTER IF PRINTING DIRECTLY ONTO THE CHECKS This is only necessary if printing actual checks from the printer Usually we will print onto white paper and copy onto tile check stock 14 Press PRINT When it says it is not set up with 10 5 etc settings enter through this by pressing Y 15 ___ JF PRINTING DIRECTLY ONTO CHECKSTOCK ONLY Go directly to printer to see that the first check number is correct Then follow the numbers on the back to see that they are running in succession If anything happens press the OFF LINE button IMMEDIATELY to conserve checks When it stops check the bin to ensure there are no remaining checks If printing onto plain paper this is unnecessary 16 Print Labels PLEASE NOTE May also exp lt X1 into Word or Wor
30. RN 62 SE 62 SI 62 SLD 62 TA 62 TR 62 UN TOWNSITE CODES ACTIVE ACTIVE PROSPECT ACTIVE SALTWATER DISPOSAL WELL ACTIVE WWATER INJECTION WELL COMMINGLED DRY HOLE DRILLING HELD BY OPERATIONS HELD BY PRODUCTION HELD BY UNIT INACTIVE INACTIVE PROSPECT INACTIVE WATER INJECTION WELL PLUGGED amp ABANDONED PLUGGED BACK PRODUCING RECOMPLETED RECOMPLETED TO ANOTHER ZONE RECOVERING FRAC OIL RENTAL SEALED SHUT IN SOLD TEMPORARILY ABANDONED TRANSFERRED UNITIZED DESCRIPTION ACTIVE ACTIVE PROSP ACTIVE SWDW ACTIVE WATER COMMINGLED DRY HOLE DRILLING HELD BY OPER HELD BY PROD HELD BY UNIT INACTIVE INACT PROSP INACT WATER P amp A PLUG BACK PRODUCING RECOMPLETED RECOMPL ZONE RECOV FRAC RENTAL SEALED SHUT IN SOLD TEMPORARY AB TRANSFERRED UNITIZED SHORT DESC TYPE CODE 63 10 CHAR Alpha amp Numeric 40 CHARACTERS 12 CHARACTERS This code will be not be populated This will vary by company and should be set up by the User CGI INC Page 12 Land Management System Training Manual Section 3 TOWNSHIP CODES TYPE CODE DESCRIPTION SHORT DESC 64 10 CHAR 40 CHARACTERS 12 CHARACTERS Alpha amp Numeric This code will be not be populated This will vary by company and should be set up by the User SUBDIVISION CODES TYPE CODE DESCRIPTION SHORT DESC 65 10 CHAR 40 CHARACTERS 12 CHARACTERS Alpha amp Numeric This code will be not be populated This will
31. Section 1 1 in the Oil amp Gas Files User Manual DIVISION OF INTEREST DOD NUMBER gt By Entity Lease Tract Prospect Segment Property gt Size 20 and a 3 character sub ENTITY METHOD OF DOI Each DOI has different partners for each lease tract SI LEASE tract 1 DOI 1 Po Po rT LEASE tract 2 lt gt DOI 2 Po Po i rT LEASE tract 3 1 1 DOI 3 Po Po POINTS TO CONSIDER 1 Control of data The correspondence of tract to DOI is unique 2 Mass Changes of DOI information may be more tedious Most current clients employ this method CGI INC Page 10 Land Management System Training Manual Section 2 USER DEFINED METHOD OF DOI All DOIs have the same partners and each partner has the same interest in each Lease tract Not recommended or preferred _ _ _ 1 a LEASE tract Partner 01 1 Partner 02 L Partner 03 Partner 04 J Partner 05 LEASE tract Partner 06 2 lt Partner 07 Partner 08 L Partner 09 Partner 10 a Partner 11 LEASE tract Partner 12 3 lt DOI 123 POINTS TO CONSIDER 1 Control of data The correspondence of tract to DOI is no longer unique Therefore extreme care should be observed in changing DOI information For example Suppose partner
32. Yes H Bonus Paid Yes I Brokerage Paid Yes J ITD Rentals Yes K Bank Charges Not usually These are usually stored by bank in the Name and Address file However if a particular tract has a bank service charge that is different from that normally charged by this bank on other leases the service charge may be overridden on the particular tracts payments under PAYEE maintenance L Chain of title Yes 15 Does LANDMAN produce 1099 s to be provided at year end ANSWER Yes CGI INC Page 11 Land Management System Training Manual Section 1 16 17 18 19 20 Does the 1099 amount include bank charges ANSWER No Does LANDMAN provide for not printing 1099 s where not required by the IRS ANSWER Yes A minimum dollar amount may be entered There is also a check box in Name and Address maintenance to activate or de activate Does LANDMAN output 1099 s on magnetic media ANSWER Yes Are billings for delay rentals done entirely within the LANDMAN system or does LANDMAN simply pass billable expense information to the Joint Interest Billing system in PetroComp s PAYOUT system ANSWER Invoicing may be directly from LANDMAN on the Windows version but you may also bill from PAYOUT accounting system Please consider carefully before using PAYOUT to bill for rentals a 600 rental may get lost in a 200 000 drilling invoice This requires checking boxes in the Land Setup Screen for computer ge
33. a Contr Tx GASPURCHASE Gas Purchase GSC ACT hd Lease NMO0010001 000 001 NM NM 88888 NP E Loc ELLYN1 ELLYN 1 as 4 3 gt P Details Created Modify Approval ee i i 001 SYSADMIN 09703 2004 13 How does the system provide for cross referencing the following ANSWER See the Cross reference screen and click to the appropriate radio button A One lease to other leases Use the Lease Cross Reference You may also use the General Cross Reference B Wells or Units to leases tracts Use the Producing Property Cross Reference See also F below C Partners to a lease or well These are listed in the Ownership Section DOI List for both leases and Producing Properties D Contracts or other agreements to leases or wells Use the Contract Cross Reference CGI INC Page 10 Land Management System Training Manual Section 1 E Other Operators These are indicated by flags in the Ownership Section DOI List for both leases and Producing Properties F Lease Level and Tract Level User defined Soft Codes provide linking leases or tracts to each other 14 Under a unique lease number sub divided into multiple tracts is each of the following data maintained by tract ANSWER A Owners and their fractional interests Yes B Legal Descriptions Yes G Remarks Yes D Well data Yes E Obligations Yes F Cross Reference to Contracts Yes G Gross Net Acreage
34. alphabetic or numeric normally left justified Descriptive schemes may be imbedded in the number itself EXAMPLE 4TX1000001 may represent Region 4 State of Texas Prospect 100 Lease 0001 gt Tracking 3 numeric digits can be numeric or alphabetic PROSPECT NUMBER gt Size xxxxxxxx 20 Alphanumeric gt Integrates to PCS Accounting Common files PRODUCING PROPERTY NUMBER gt Size xxxxxxxx 20 Alphanumeric CONTRACT NUMBERS gt Size xxxxxxxxx 20 Alphanumeric CGI INC Page 8 Land Management System Training Manual Section 2 GENERAL CROSS REFERENCE gt Size xxx 3 XXXXXXXXXXXXXXXX 16 Alphanumeric Set up first 3 in Code Description This is most commonly used for referencing assignments or referencing Marketing or Sales packages In general general cross referencing is used to cross reference things that are not producing properties prospects leases or contracts CODE DESCRIPTIONS gt Size Varies See section 1 2 in the LANDMAN User Manual NATION STATE COUNTY gt See Section 1 3 in the LANDMAN User Manual gt Nation Characters xxx Numeric gt State 2 Characters xx Numeric gt County Characters xxx Numeric We can provide the numeric codes for states and counties if you desire to use the API standard numeric codes CGI INC Page 9 Land Management System Training Manual Section 2 NAME ADDRESS gt Size xxxxxx 15 2 Note Standard is 10 2 See
35. are backups of specific files that have been changed since the last time you backed up and which only need to be kept until the next time the files change For example let s say you backup your accounts payable data files after each time you enter new invoices You enter invoices on Monday and make a backup You then enter more invoices on Wednesday and make another backup Now since you have all of your data as of Wednesday you don t need your backups from Monday or do you Hopefully you don t but you might What do you do if something happens and you loose your accounts payable data on Thursday Of course you restore your backups from Wednesday right Right But when it rains it pours and those diskettes had coffee spilled on them and they are unreadable Don t say this won t happen to you Murphy s Law strikes everyone So now what do you do Aha You still have Monday s backup and can restore from it and only loose the data you entered on Wednesday There was still some loss but it was minimized because you backed up and were using the grandfather father son technique CGI INC Page 6 Land Management System Training Manual Section 2 The grandfather father son technique is the rule that says Do not use the diskettes or tape I used to backup last time to backup this time In fact you want to have 3 sets of backups Grandfather Father and Son In terms of the example above it would work like this gt On Monda
36. below By Multiple Cross References LM 108 00 From Cross Ref Type Prospect Prospect Seg No 301 ooo LEESVILLE To Selection Criteria Cross Ref Type Prospect IV Prospect Level Beginning Prospect No Ending Prospect No SelectAll De Select All Generate Cross References m To Prospect No Segment No Prospect Name Sel 4 1 00002 pci PROSPECT 00002 oO 111 HOMER o 112 oan RANKIN o C IE pas SEMINOLE o p 21 PROSPECT 21 o g 400 eae HUGOTON CONSOLIDATED ACQUISITION EI 2 88888 ja o 8 z m g 99999 aa Prospect 99999 Test oO qo ALLEY oan ALLEYTON o 41 ALP100 a ALPINE n z E gt SE RETRO NOAM RAINE st 299 79NND 1a Sl aR CGI INC Page 35 Land Management System Training Manual Section 5 If selecting Prospect and not checking F display all segments for all prospects I Prospect Level the lease grid will See below by Multiple Cross References LM 108 00 From Cross Ref Type Prospect Seqg No Prospect 301 000 LEESVILLE T Cross Ref Type To Selection Criteria Beginning Prospect No Prospect I Prospect Level Ending Prospect No EEE SelectAll De Select All Generate Cross References p m To e Prospect No Segment No Prospect Name Sel 4 1 00002 001 PROSPECT 00002 m E 00002 002 PROSPECT 00002 o 112 000 RANKIN o Eg 21 000 PROSPECT 21 o 5 901 000 LEESVILLE o Te ALLEY 02 ALLEYTON o 7 ALP100 000 ALP
37. lt Back Cancel Click Finish to position your Excel data normally default to the top left cell Import Data ra xi Where do you want to put the data Existing worksheet Cancel New worksheet jia Create a PivotTable report Click OK to see your Excel Query This can be saved edited to add or delete columns form lease information or tract information EQ Microsoft Excel Book1 BEEF Eile Edit view Insert Format Tools Data Window Help Type a question for help f X Be Se EEA Ol EEA DSESRESRY 4BB Slo a xz 4 10m 7 Gt a a T 7 BH P rere etal RO fe hes 4 Arial 10 B z u lR aA E1 bd fe LessorlD D F Lease im Type Instrument Expiration CpnylD LeaseNo LeaseName Code LessorID IRentalAmount Type Code Date LeaseEffectiveDate 001 1 CA001 007 00 CECIL DAGEN ET UX EE LS 01 01 1900 0 00 03 13 1961 0 00 001 1 TX003 001 000 T N BEAUCHAMP ET UX MAMIE BEAUCHAMP FE HANKO2 Os 01 14 1953 0 00 01 14 1948 0 00 001 1 TX003 005 000 R H JORDAN LEASE FE LS 05 31 1956 0 00 05 31 1961 0 00 001 1 CA001 002 00 California State Lease FE OLs 03 27 1958 0 00 03 27 1948 0 00 001 1 WY001 007 00 BLM W 040037 FD LS 04 01 1961 0 00 04 01 1956 0 00 001 1 W Y001 005 00 BLM W 36520 FD OLS 11 01 1961 0 00 11 01 1956 0 00 001 1 CA001 005 00 DICK B BELOAT ET UX FE os 01 10 1964 0 00 01 10 1961 0 00 001 1 CA001 006 00 MAISIE COLBERT FE OLS 01 11 1964 0 00
38. not covered in the lease RIPARIAN LANDS The rights of the owners of land on the banks of watercourses relating to the water its use ownership of soil under the stream accretions etc CGI INC Page 69 Land Management System Training Manual Section 5 ROYALTY INTEREST The property interest created in oil amp gas after a severance Royalty Deed It is fee simple in fee simple determinable for life or for a fixed term of years Also Landowners royalty reserved in an oil amp gas lease is a share of production free of expenses of production CGI INC Page 70 Land Management System Training Manual Section 5 ROYALTY CLAUSE Share of the product or a portion of the proceeds from the sale of the product reserved by the owner of land in the lease SEGMENT A subdivision of a prospect Usually the Prospect is segmented because of differing leasehold interests SEVERED HORIZON A conveyance of all or some portion of the minerals above or below or between specified depths or in a given stratum or horizon e g a conveyance of the minerals in the Yegua formation or a conveyance of all minerals at a depth greater or less than 3000 feet beneath the surface SHUT IN GAS ROYALTY CLAUSE Permits the lessee where gas is discovered but a market is not available to maintain the lease in force and effect beyond the primary term by payment of stated amounts STATE WATERS Each state owns the land under navig
39. note 415 LEASE FIND The ability to find leases has been greatly enhanced in this release Click Find on the LANDMAN Menu to display the submenu for Leases Contracts and Locations SJ Landman Menu LM 000 00 E lo x File Maintenance Find Master Listings Reports Payment Processing Invoice Processing Utilities m Leases DEVELOP SYSADMIN 12 04 2001 Contracts Locations Click Leases to display the following search screen You may enter a specific lease number or any of the group identifiers such as nation sate county prospect or Map reference as shown below Then click the FIND button to begin the search Find Leases LM 920 00 IEG Actions Jd aAxw F 2 2 SlOu s Search Criteria Search Results Lease No TractNo L49010334 000 Lease Name Lessee ID Name By Lease Tract Lessor ID Name C By Owner Lease Date 2 Thu Eff Date a Thu Exp Date 2 Thu 7 Acquired Date Thu 7 Clear Find Drop Date E Thu 77 Drop Code J Exclude Dropped Lease Owner Instr Type Lease Type Grid View Book Page Entry Related Party ID Payable ID Credit To ID Prospect t Name Nation State County x Owner ID Name AsofDate s Survey Desc Meridian Desc SSS a Map Reference Field Township I and x TownshipDir vend x RangeNo z and 7 RangeDir v ana x Section gt Jeffersonian be O A E Pe i SYSA
40. or Recommendation Report Display this report s Use VCR buttons to go forward back when going through fields on each screen 3 Payment Review This screen organizes this report for further review and selection It also allows you to note your recommendations for payment for your inquiry letter partners 4 Payment Recommendation Report Do any amount of updating you deem necessary to the individual leases dropping leases updating status etc until you feel they are ready for processing this can be run many times if necessary Run one last time to see that all those you want to pay are included may just want to Display to compare May schedule a lease group prospect etc at a time does not have to be done for an entire month but will usually be done by all payments due within a given month for rental or shut ins 5 Payment Review Update Process enter several times to pull up everything in the payment control This will show you if anything remains from last month Do not change flag or drop those without discussing w supervisor or Analyst who was responsible for those payments please help keep this cleaned out it should only have very recent payments on hold Select delete to delete a payment from the Payment Control File Check Click PAY it will place them in Pay status 6 Run Inquiry Letters May be done at any time during the process sometimes done earlier These are done for payments made by out
41. or use the lt F3 gt table lookup feature Entry of the Tract Number is mandatory Selecting Prospect will change the From Section to the following From Cross Ref Type Prospect Seg No 901 ooo Enter a valid Prospect Number or use the lt F3 gt table lookup feature Enter a Segment Number or use the lt F3 gt table lookup feature Entry of Segment Number is not mandatory Selecting Location will change the From Section to the following From Cross Ref Type Location v Location ID 0000021 Tiger test size of name 1234567890123450 Enter a valid Location ID or use the lt F3 gt table lookup feature Selecting Contract will change the From Section to the following CGI INC Page 30 Land Management System Training Manual Section 5 From Cross Ref Type Contract Vv Contract No ALP 200 002 Alpi e JOA Enter a valid Contract Number or use the lt F3 gt table lookup feature Selecting General X Reference will change the From Section to the following From Cross Ref Type General xref x Xref Type No SALE 5001 Enter a valid Reference Type or use the lt F3 gt table lookup feature Enter a valid Reference Number or use the lt F3 gt table lookup feature Entry of the X Reference Number is mandatory In the To Selection Criteria Section select the type of Cross Reference you want to make to from the drop down box
42. the lease as the first line of the address Which Files may be shared with PAYOUT and PACTMAN accounting and Production ANSWER Property Master Name and Address Master Contract Master Code Description Nation State County file Well DOI What are the uses of the Crystal Report Writer ANSWER We have written all reports in Crystal In general to write your own reports or modify our standard reports for your specific needs Crystal may also be used to export data to Excel NOTE Excel Query and Access offer a way to produce quick columnar reports Can I get a report of a selected expiration date range ANSWER Yes The date type is also selectable That is you may get reports by drop date lease date effective date etc CGI INC Page 17 Land Management System Training Manual Section 1 39 40 41 42 43 Can I change the operator on Lease XXX001 through XXX900 ANSWER Yes There are various ways to do this depending on the circumstances and number needed to change Copy Ownership may be used to do this Or this is done with a SQL Script Can I add postage and Handling or an administration charge to rental or other payments ANSWER Yes See General Cross Reference discussion Not at this time Can I define escalating payments Do I have to change the amount each year for each payee ANSWER Yes if payees are defined with the percent option their individual amounts will not have
43. to be changed each year Can I have different billing percents for rentals and minimum royalty or other payment obligations ANSWER Yes You may define in the Land DOI a WI and a BI If a BI is defined it will be used even if a WI is present Assuming each lease record contains three tracts with each tract having 12 interest owners how much disk space is required for ANSWER Leases Megabytes of disk storage 100 2 3 Meg 500 10 12 Meg 1000 20 Meg These estimates may very dramatically as a function of your usage of the optional and large freeform areas of entry CGI INC Page 18 Land Management System Training Manual Section I 44 Will using the mouse slow down data entry Can this be done faster ANSWER Yes But there are numerous tricks to keeping this to an absolute minimum Under Application Options on the tool bar menu select Enter key equal tab key and use the enter keys just as you would in any DOS environment When you get a information box enter the first letter Y or N and do not pick up the mouse to click the correct answer System Message 6001 2 Do you want to save your outstanding changes Enter Y or if you notice the Focus dots around the Yes answer you may just tap the space bar Use CTRL S to Save do it often rather than picking up the mouse to click the Save Icon CGI INC Page 19 Land Management System
44. vary by company and should be set up by the User OCS AREA CODES TYPE CODE DESCRIPTION SHORT DESC 66 10 CHAR 40 CHARACTERS 12 CHARACTERS Alpha amp Numeric This code will be not be populated This will vary by company and should be set up by the User CGI INC Page 13 Land Management System Training Manual Section 3 OCS REGION CODES TYPE CODE DESCRIPTION SHORT DESC 67 10 CHAR 40 CHARACTERS 12 CHARACTERS Alpha amp Numeric This code will be not be populated This will vary by company and should be set up by the User RELATED PARTIES CODES TYPE CODE DESCRIPTION SHORT DESC 68 01 BENEFICIARY BENEFICIAR 68 02 REMAINDERMAN REMAINDERM 68 03 CO FIDUCIARY CO FIDUCIA 68 04 ATTORNEY ATTORNEY 69 05 ACCOUNTANT ACCOUNTANT GOVERNMENT LEASE CODES TYPE CODE DESCRIPTION SHORT DESC 69 10 CHAR 40 CHARACTERS 12 CHARACTERS Alpha amp Numeric This code will be not be populated This will vary by company and should be set up by the User CGI INC Page 14 Land Management System Training Manual Section 3 MERIDIAN CODES TYPE CODE DESCRIPTION SHORT DESC 80 El EAST OF 1 MANITOBA EAST OF 1 80 E2 EAST OF 2 SASKA EAST OF 2 80 E5 EAST OF 5 ALB SASKA EAST OF 5 80 W1 WEST OF 1 MANITOBA WEST OF 1 80 W2 WEST OF 2 SASKA WEST OF 2 80 w3 WEST OF 5 ALBERTA WEST OF 5 ROLE TYPES CODES TYPE CODE DESCRIPTION SHORT DESC 86 001 ACCOUNT EMPLOYEE ACCOUNT EMPL 86 002 BUYER BUYER 86 003 COLLECTION TAX
45. xL BER x x 888 LM 101 00 Scree ease Legal Description xL x gag LM 103 00 Screen Lease Tract Special Obligations XL x x x x x 990 LM 105 00 Screen Lease Tract Remarks xL x x x x x ol x E x 991 LM 107 00 Screen Lease Tract Cross References xL a 001 SYSADMIN 03 05 2002 CGI INC Page 63 Land Management System Training Manual Section 5 eer Maintenance LM 100 00 OF x Lease No Loon gh Images Menu Lease Name HOBERT POTTER ET AL I Critical Lease AtSequence Tia Lease Date 97 15 1947 Lessor Lease No a ae el Ett Date 0771571947 essor ROBERT Porten ETAL Lease Term 3fMonhs 7 Lessee 0002 ALERT OIL amp GAS COMPANY INC Exp Date 10 15 1947 es ae cs Acquired owt 5 1947 Region Related Parties Acquired From Bonus o oo 6 Acre 0 00 Acquired Code PURC Purchased Rental o oo Acre 0 00 Dwner Instr Type LS LEASEHOLD Shut In o oo Acre l 0 00 Lease Type FE FEE LEASE Alt Lease No Jnt Venture I Release Required Jnt Venture Drop Date Code KG Copy Lease Bui cee Created Modified Approved 03 08 2001 STEVE 03 08 2001 STEVE 2t 001 SYSADMIN 03 05 2002 User must click on the approved date and the system will drop the current date in there like an automatic lt F7 gt Must allow for changing back to blank CGI INC Page 64 Land Management System Training
46. 0 00 dof x Search Criteria Search Results Leases 1 MATCH ES FOUND LA901 0334 000 T 000 Lease Number La9010334 000 Tract Number ooo Lease Name HIGGINBOTHAM SARAH ELLEN K Lessor ID 018375 Lessor Name HIGGINBOTHAM Lessee Name FIRST AMERICAN BANK Lease Date 10 11 1997 Effective Date 1071171997 Terms Expiration Date Acquired Date Drop Date Instrument Type Lease Type Lessor Mineral Interest Lessor Royalty Oil Lessor Royalty Gas Total Bonus Amount Rental Amount Rental Per Acre Tract Status Tract Status Date Tract Prospect Prospect Name Higginbotham Sarah Ellen 1071172003 1071171997 A i LEASEHOLD FEE LEASE 1 000000000 0 187500000 0 187500000 0 00 0 00 901 LEESVILLE SYSADMIN DEVELOP 1172172001 Right Click to see the drop down menu to get to Lease and tract level information as shown on the next page Find Leases LM 920 00 MEI ES Search Criteria Search Results Leases 1 MATCH ES FOUND Field Name Field Value il A9010334 000 T 000 Higginbotham Sarah E pase Number La9010334 000 00000003 000001 000001 000014 WI C Development Inc First American Bank First American Bank Test Miller Oil Corporation Lease Maintenance Tract Maintenance Tract Legal Description Tract Map Reference Tract Remarks Prospect Maintenance Payment Obligations Payment History ooo HIGGINBOTHAM SARAH ELLEN KEEL 018375 HIGGINBOTHAM ssor Name s
47. 000 jooo 1 00000000 2 3 X 4 gt Close This screen allows you to tie costs to a specific cost center and subsequently book to the General Ledger and send this information to Joint Interest Billing You may have more than one cost center Location to book bill this payment to Each Payment may be associated with an AFE Refer to Sections 2 1 8C in the LANDMAN System User Manual for additional information 48 3 PAYMENT OBLIGATION TRACT ALLOCATION S Tract Allocation olx F Tract No Decimal Interest Amount E 1 This screen allows you to allocate Lease Level costs to individual tracts by a decimal interest computed by the Net acres in this tract to Net acres in the entire lease You may also override the Decimal Interest by un checking the Allocate by tract Net Acres and entering the desired decimal interests for each tract in the lease NOTE For a Payment with NO ACRES associated such as a ROW or an EASEMENT un check the net acres box and enter the tract 000 and decimal 1 00 unless there are multiple tracts Refer to Sections 2 1 8D in the LANDMAN System User Manual for additional information 4 9 LEGAL DESCRIPTION Legal descriptions for the entire lease are entered using this screen Up to 8 pages of description may be entered for each legal description The legal description is free form information for those who want it to appear exactly like lease You may paste from Word into this screen
48. 00000 Developed o oooooo o ooooo0 0 000000 0 000000 Undeveloped 0 000000 0 000000 0 000000 0 000000 Refresh Dur Share Calc Net Co Net Drop Dt Cd i Created Modified Approved a ie Pi Customization Design Mode 001 SYSADMIN 01 05 2006 Note also the check marks you may check off the tab stop if you want the cursor flow to skip a field CGI INC Page 9 Land Management System Training Manual Section 5 CGI INC Page 10 Land Management System Training Manual Section 5 5 2 Chain of Title Report CHAIN OF TITLE REPORT On the LANDMAN Menu select the Report Module then Lease Summary o LandMan Menu LM 000 00 E a o x File Maintenance Find Master Listings Reports Payment Processing Invoice Processing Utilities Lease Data Sheet SYSADMIN 01 17 2002 Acreage Inventory Lease Listing Lease Summary Lease Exhibit A Lease Inventory Lease Cost Report Map Reference Report Producing Property List Property Inquiry Producing Acre Lease Expiration Report Prospect Exhibit A Special Obligation Lease Special Obligation Prospect Special Obligation Contract Special Obligation Location Special Obligation Payment Projection Relinquished Leases Remarks Draft Status CGI INC Page 11 Land Management System Training Manual Section 5 The following screen will appear E Lease summary Report LM 605 00
49. 04 sells his interest in lease 2 to partner 02 OR Partner 04 sells his interest in lease 2 to a partner outside the current DOI 2 Reduces amount of data entry greatly Modification to combine these two methods planned for ease of entry and processing CGI INC Page 11 Land Management System Training Manual Section 2 2 5 FILE RELATIONSHIPS IN LAND Lease i 4 LEASE Tract TRACT A 1 _ 4 tT PROSPECT cRoss PRODUCING SEGMENT ____ REFERENCE _ __ PROPERTY M a e m m CONTRACTS GENERAL H cross REFERENCE C L LEASE TRACT 2 1 PROSPECT SEGMENT 2 2 Lease Information Screens Tract Information Payee Information Lease Partner Owner Legal Description Remarks Description Prospect Information Segment Information Prospect Partner Owner Map Reference Remarks Description Cross References Additional Counties Special Obligations Map Reference Cross References Special Obligations PRODUCING PROPERTY 2 3 CONTRACTS 2 4 Property Information Partner Information Remarks Description Contract Information Cross References Remarks Description Map Reference Special Obligations Cross References Locator Information Special Obligations GENERAL CROSS REFERENCE 2 5 General X Ref Information General X Ref Cross Reference Remarks Description Special Obligations CGI INC Page 12
50. 100000 SH CHECKING 1530260000 PROMAROTIONAL COST x 4 01 1010100000 SH CHECKING 1530040000 DELAY RENTAL x 5 1010120000 CASH REVENUE 3010700000 FEDERAL BACKUP WH ix DISTRIBUTION P LE gt TE 1010100000 CASH CHECKING 1530020000 LEASE BONUS x 7 06 EJ 8 1010100000 CASH CHECKING 3010200000 ACCOUNTS PAYABLE x 4 aninionnann PACU DCiICkILIC aninieanann r c m n 1 int c DAS ADI C real n Dd DEVELOP SYSADMIN 12 07 2001 gt Is apayment rental shut in etc due A report may be generated for the accounting department even if not using PetroComp s accounting software by entering the General Ledger account numbers and running the Journal Report discussed in Section 7 Refer to Section 1 2 of the Oil amp Gas Master Files User Manual and Section 1 4 1G of the LANDMAN User Manual for additional information concerning Code Maintenance CGI INC Page 20 Land Management System Training Manual Section 3 The following pages offer suggestions for the various Land system codes that may be used STATUS LISTING TYPE CODE DESCRIPTION SHORT DESC PYMT DUE 03 A ACTIVE ACTIVE ba 03 AI ACTIVE WATER INJECTION WELL ACTIVE WIW x 03 CO COMMINGLED COMMINGLED Y 03 DH DRY HOLE DRY HOLE Y 03 DR DRILLING DRILLING 03 FE FULLY EXECUTED FULLY EXECUT x 03 G GAS INJECTION WELL GAS INJECTOR Y 03 GS SHUT IN GAS INJECTION WELL SI GI x 03 GT TEMP ABANDONED GAS INJECTOR TA D GI 03 I INACTIVE INACTI
51. 116 00 x Lease Import Export Utility The Lease Import Export Utility allows you to import and export lease data This utility quides you through the steps to import and export data between databases lt Back Click next CGI INC Page 18 Land Management System Training Manual Section 5 Import Export Purge Leases LM 116 00 i X Choose a Data Source From where do you want to copy data You can copy data from one of the following sources Data Source Microsoft SQL Server bi EPEE EET aN Text Fil To connect to Mi D g name and password Server ORO Use SQL Server Authentication Username sa Password Database Development E Refresh cmo He Fill out the above and click next CGI INC Page 19 Land Management System Training Manual Section 5 Import Export Purge Leases LM 116 00 Choose a destination To where do you want to copy data You can copy data to one of the following destinations e LYoungblood les select Text file and enter path name Click Next CGI INC Page 20 Land Management System Training Manual Section 5 Import Export Purge Leases LM 116 00 Select Source Tables You can choose one or more tables but you always have to choose Lease Tract 4 TX001 001 01 4 TX001 004 00 Vv Vv Vv Vv Vv Vv Enter source company range of le
52. BS Burdens Print T BS Burdens Print T BS Burdens Print T uy 7 o Oo oo oO 0000000 000 Li CGI INC Page 33 Land Management System Training Manual Section 5 If selecting Lease Tract checking leases at a lease level showing in the Tract field V Lease Level the lease grid will display the See below By Multiple Cross References LM 108 00 From Cross Ref Type LEESVILL Prospect Prospect Seq No 301 ooo To Selection Criteria Cross Ref Type Beginning Lease No a Lease Tract v SelectAll De Select All Generate Cross References V Lease Level Ending Lease No _ To Lease No 4 00002 001 2 01404 001 3 12345 4 1234566666666 T5 1234A 6 4Tx001 001 01 7 4 7x001 002 00 g 4 Tx001 003 01 g 4 TXx001 003 02 HH 4 TX001 003 03 4 oo oO Lease Name Jones 12345 LEO T ATKINS ET UX CL GAGE NGTON ET U WILSON K MAXWELL ET Ux JJCOYVI GAYLEN FRAN 700 0000000 Fa a MI AR Mowe aM r ONZO ATA AIRE Ina 99 70nNe CGI INC Page 34 Land Management System Training Manual Section 5 If selecting Prospect and checking i V Prospect Level the lease grid will display the prospects at a prospect level showing in the Segment field See
53. Blank b From Contacts 3 Add data field to screen for Address Description from PCS N amp A Place near address 4 If N amp A in PCS is deleted what happens to the Contact CGI INC Page 47 Land Management System Training Manual Section 5 Milton Fry Contact silanes s enensm viene aens Sl frveretrocome conl o CGI INC Page 48 Land Management System Training Manual Section 5 5 7 Multiple Xref 5 8 Copying a lease to create an new least or copy a portion of a lease to multiple previously existinig leases Mass Lease Copy LM 113 00 iof x r Copy From Copy To Lease No Tract No Beginning Lease No Ending Lease No NM NM 98888 USA Copy Only Copy and Replace Refresh Grid Select All De Select All With Notes Without Notes Lease No Tract No Copy 5 Include Eua Oo 2 o J Lease Tract I Remarks 3 o ey cs 4 o Additional Cnty f Chain 4f Title 5 o M Payment Oblig f pecial Obligations Map References ross Ref ALL 8 O I Contracts g o Legal Text Producing ll E Property 10 m 1 ma gt 001 SYSADMIN 10 04 2002 Use this Area to Copy To an Existing lease partial info from another lease CGI INC Page 49 Land Management System Training Manual Section 5 TO Copy to a NEW lease num
54. CGI INC Page 1 Land Management System Training Manual Section 3 REMARKS TYPE LEASE TRACT DESCRIPTION SHORT DESC ABAT BI CALL CONT COT CROY DAMG DEPT ESCR EXTN FEDS HUBB MINE MROY MS NKND NOTE OFFS OPER OTHR POUT POOL PRTL PUGH RCVD REAS REST RLRQ RNTR RNWL RWRK SI SURF SUR WAR anwnwnnonunnoenonnneunnoaononunannnoeunanaseu4nenanwnoanuow D N DRILL ABATE BACK IN CALL ON PRODUCTION CONTIGUOUS ACREAGE CHAIN OF TITLE COMPENSATORY ROYALTY UNUSUAL DAMAGES DEPTH LIMIT ESCALATING RENTALS EXTENSION FEDERAL STIPULATION HUBBARD MINERAL EXCLUSION MINIMUM ROYALTY MISCELLANEOUS PRODUCTION IN KIND LESSOR CONSENT OFFSET PROVISION CONTINUOUS OPERATIONS OTHER PAYOUT ELECTION POOLING PARTIAL ASSIGNMENT PUGH YEARS ASSIGNMENT RECEIVED REASSIGNMENT DUE RESTORATION OF SURFACE RELEASE REQUIRED RENTAL REDUCTION RENEWAL REWORK SHUT IN CLAUSE SURFACE USE SURRENDER WARRANTY DRILL ABATE BACK IN CALL ON PROD CNTG ACRE CHAIN OF TIT COMP ROY UNUSUAL DAM DEPTH LIMIT ESC RENTS EXTENSION FED STIP HUBBARD MIN EXCLUSI MIN ROY MISC PROD IN KIND LSR CONSENT OFFSET PROV CONT OPER OTHER PAYOUT ELECT POOLING PART ASSGN PUGH YRS ASSGN RECV REASSIGN DUE RESTORE REL REQUIR RNT REDUCE RENEWAL REWORK SHUT IN CL SURFACE USE SURRENDER WARRANTY CGI INC Page 2 Land Management System Training Manual Section 3 OBLIGATION
55. CGI INC Page 4 Land Management System Training Manual Section 1 J If a lessor owns different mineral interests in two or more parcels covered by the same lease must each parcel be defined with a unique lease number ANSWER No Each parcel tract can be defined as separate tracts under the same lease number Parcel B Owner 2 owns 50 Owner 1 owns 50 One lease for Owner I two tracts One lease for owner 2 1 tract 6 How many tracts per lease number may be defined ANSWER 1000 tracts per lease number starting with Tract 000 and ending with Tract 999 Actually with the Windows product the sub can be alphabetic so there is no practical limit CGI INC Page 5 Land Management System Training Manual Section I 7 Are working interest and other types of ownership maintained by tract ANSWER Yes Land Ownership records DOIs are maintained by tract Options are available for determining the DOI number used on a particular tract 1 The system can automatically do this for you recommended 2 you can define determine and input the DOI number to be used on each tract These options are discussed further in the setting parameters section of this manual 8 How many different sets of divisions of interest are allowed per lease tract ANSWER One DOI number per tract 1000 DOI numbers per lease Windows allows more with alpha Most often only one is required as the owners are date eff
56. County Land Setup Click on Code Description to display the following lt F3 gt in the Code Type Field click the heading description to sort by that column type PA and down arrow to find Payment types and responsibility Code Description Maintenance CM 020 00 olx C Accounting Cecla iE C Land C Production All CODE Description Role Type Short Description oF a 2 2 4 5 6 A Esa 9 lt FT is DEVELOP SYSADMIN 7 19 01 This function allows use of familiar codes rather than having them pre defined by the system Now try entering the Acquired Code defined in the Dates amp Codes Section of the Lease Data Sheet CGI INC Page 16 Land Management System Training Manual Section 3 TYPE Enter the 2 position number from the screen to indicate code type They lt F3 gt table lookup feature is available in this field Place cursor on Type Description and double click to sort by type CODE Enter the value of the code to be maintained The field size is from 1 to 4 positions which are indicated in brackets after each code name DESCRIPTION Enter or modify the description of the item A maximum of 30 characters is allowed and it must be non blank SHORT DESCRIPTION A maximum of 12 positions is allowed Defaults to the first 12 positions of the description CGI INC Page 17 Land Management System Training Manual Section 3 Some of the codes requir
57. DMIN 05 02 2006 and the following screen will be displayed gt Find Leases LM 920 00 Search Results Leases 1 MATCH ES FOUND Field Name LA39010334 000 T 000 Higginbotham Sarah Ellen Keel DEVELOP SYSADMIN 10 30 2001 Click on the plus sign to show the ownership in the Lease Click on one of the owners and Right Click to see the Name and address selection Find Leases LM 920 00 PEI Es Search Criteria f Search Results Leases 1 MATCH ES FOUND LA9010334 000 T 0000 Higginbotham Sarah Ellen Keel Field Value DOI Owner ID 000014 BR 00000003 WI C Development Inc Owner Name Miller Oil Corporation 000001 wi P First American Bank Interest Type Working 000001A wi C_First American Bank Test DO Number La9010334 000 000014 WI P_ Miller Oil Corporation DO Sub 000 i Name amp Address Maintenance lus A Lease Tract Ownership v PoF petty imal Eff Date 03 01 2000 Cease imal End Date 0372072001 Decimal Interest 0 000000000 Short Remark Tract Prospect Number 901 Tract Prospect Name LEESVILLE Tract Segment Number DEVELOP SYSADMIN 11721 2001 I Astart sn Gasapocu 9 Solomo LandMa S Landma Oo Find Le e a Peis OM BROSMO sim You may go Name and Address Lease Tract Ownership or Lease summary Click on the Lease ID and basic descriptive information will be displayed fFind Leases LM 92
58. DUE Bg N N CGI INC Page 5 Land Management System Training Manual Section 3 ACQUIRED CODE LISTING TYPE CODE DESCRIPTION SHORT DESC 28 A001 ACQUISITION FROM BROKER ACQ BROKER 28 A002 ACQUISITION FROM COMPANY ACQ COMPANY 28 ACEX ACREAGE EXCHANGE AC EXCHANGE 28 DRCT ACQUIRED DIRECT FROM LESSOR ACQ DIRECT 28 E001 PRODUCED TO EARN PROD TO EARN 28 E002 DRILLED TO EARN DRLD TO EARN 28 E003 COMPLETED TO EARN COMP TO EARN 28 FI FARM IN FARM IN 28 JV JOINT VENTURE JOINT VENT 28 MERG MERGER MERGER 28 PURC PURCHASED PURCHASED INSTRUMENT TYPE CODES TYPE CODE DESCRIPTION SHORT DESC 29 A001 ASSIGNMENT ASSIGNMENT 29 A002 ASSIGNMENT amp BILL OF SALE ASMT BOS 29 A003 ASSIGNMENT OF WORKING INTEREST ASMT WI 29 A004 ASSIGNMENT OF OVERRIDING ROY INT ASMT ORRI 29 A005 PARTIAL ASSIGNMENT PART ASMT 29 BOS BILL OF SALE BILL OF SALE 29 DOOL ROYALTY DEED ROY DEED 29 D002 QUITCLAIM DEED QUITCLAIM DE 29 ESMT EASEMENT EASEMENT 29 L001 LEASEHOLD LEASEHOLD 29 1002 GEOTHERMAL LEASE GEOTHERM LS 29 1003 PROTECTION LEASE PROT LSE 29 OPTN OPTION AGREEMENT OPTION AGMT 29 R001 RELEASE RELEASE 29 R002 PARTIAL RELEASE PARTIAL RLS 29 ROW RIGHT OF WAY RIGHT OF WAY 29 sool SURFACE USE AGREEMENT SURFACE USE 29 S002 SALT WATER DISPOSAL AGREEMENT SW DISPOSAL 29 wool WARRANTY DEED WARR DEED 29 w002 SPECIAL WARRANTY DEED SPEC WD 29 w003 GENERAL WARRANTY DEED GENERAL WD CGI INC Page 6 Land Management System Training Manual Section 3 PAYMENT TYPES CODE
59. GI INC Page 60 Land Management System Training Manual Section 5 5 10 5 11 Contract Setup CT 950 00 O x moomoo CASH 1010100000 CASH CHECKING Cost Setup 1040100000 ACCOUNTS RECEIVABLE TRADE uk Companies a aa E Ezr E n 11 09 1999 SYSADMIN 10 13 2000 SYSADMIN a You have to setup the companies in which you want to share the contract master Those companies should be in one database CGI INC Page 61 Land Management System Training Manual Section 5 Company Setup CM 001 00 DEVELOP Development Energy Corporation 00000003 Invoice Date oogo0d aooo Houston fice 10 31 1998 H SYSADMIN 03 08 2001 H SYSADMIN Co oO OO EP O OSSA 09 08 2001 You have to set Share Contract Master flag on in order to share the contract master CGI INC Page 62 Land Management System Training Manual Section 5 Check the Initialization Mode Option with the assumption this user has the rights to do this access Rights Maintenance 95 270 00 Iof x Type User Group User ID BECKY Name BECKY ANUSZKIEWICZ J All Companies Company ID ALL Preload Detail F4 for grid form view Ep Type Name Module View Update Insert Delete sis rae le 885 JB 950 00 Screen JIB Setup xJ x x x x x 886 LM 000 00 Screen LandMan Menu
60. ILL TRUSTEES Date Filed 09 18 1945 Date Recorded Conveyed 0 500000 Reserved 0 000000 Book 163 Page 610 Entry Notification Date CGI INC Page 16 Land Management System Training Manual Section 5 5 3 Import Export Purge x Land Management LandMan Menu Find Leases ImporExport Purqe L Lease Maintenance Lease Legal Description Tract Maintenance Ownership Leasehold Ownership Transfer Map References Payment Obligations Special Obligations 10 xi File Maintenance Find Master Listings Reports Payment Processing Invoice Processing l Utilities i DEVELOP SYSADMIN Lease Copy Lease Transfer Leasehold Ownership Transfer Recalculate Net Company Net Acres Contract Copy Import Export Purge Leases Assumptions 1 The lease tables should exist in the database you are importing exporting into from 2 OS should be Windows NT or Windows 2000 Not Windows 95 There are three choices to import export Case 1 Microsoft SQL Server gt Text File Case 2 Text File gt Microsoft SQL Server Case 3 Microsoft SQL Server gt Microsoft SQL Server This feature is not working yet I am planning to continue to work on it Let s talk about Case 1 First of all you setup the directory to store all text files which this Utility will create And then follow the steps to finish CGI INC Page 17 Land Management System Training Manual Section 5 Import Export Purge Leases LM
61. INE o a ALP100 001 ALPINE o g CAO 001 SAN JOAQUIN o yo CC110 000 Cedar Creek Prospect oO 11 DOROTHY 000 DOROTHY S PROSPECT n Me MCEI aM ONZO ATMA AIRE nia 9979nNS en Pl aR CGI INC Page 36 Land Management System Training Manual Section 5 If you want to cross reference to all of the properties listed in the grid use the Select All button field the Select Select All This will put an X in all the boxes in E Multiple Cross References LM 108 00 am From Cross Ref Type Prospect Prospect Seg No 901 ooo LEESVILLE To Selection Criteria Cross Ref Type Beginning Lease No Refresh Grid Lease Tract v I Lease Level Ending Lease No De Select All Generate Cross References 4 0 Lease No 4 00002 001 00002 001 3 01404 001 4 01404 001 5 01404 001 g 12345 7 12345 a 1234566666666 g 1234A E Tract No Lease Name Sel 4 000 test EJ 001 test JEJ 000 BS Burdens Print Test Lease x 001 BS Burdens Print Test Lease Ea 002 BS Burdens Print Test Lease x 000 Lease Data Sheet Test Lease Name x 001 Lease Data Sheet Test Lease Name x 000 Jones ix 000 12345 x oe DEVELOP SYSADMIN 01 23 2002 CGI INC Page 37 Land Management System Training Manual Section 5 Use the De Select All button Dees if you want to clear your singl
62. JURISDICTION COLL TAX 86 004 CONTACT FOR ACCESS TO PROPERTY CONTACT 86 005 CO OWNER CO OWNER 86 006 CORRESPONDENCE BANK CORRESPONDEN 86 008 GENERAL PARTNER GENERAL PART 86 009 GRANTEE GRANTEE 86 010 GRANTOR GRANTOR 86 O11 INSPECTION FIRM INSP FIRM 86 012 INSPECTOR INSPECTOR 86 013 LESSEE LESSEE 86 014 LESSEE ON PREMISES CONTACT LESSEE CONT 86 015 LESSOR LESSOR 86 016 NEW RESPONSIBLE PARTY NEW PARTY 86 017 OIL GAS DIVISION MANAGER DIV MANAGER 86 018 OPERATOR OPERATOR 86 019 OPERATOR CONTACT OPER CONTACT 86 020 PARTY BILLED PARTY BILLED 86 021 PAYEE PAYEE 86 022 PAYOR PAYOR 86 023 PROSPECTIVE TENANT PROSP TENANT 86 024 PUMPER CONTACT PUMPER CONT 86 025 PURCHASER PURCHASER 86 026 PURCHASER CONTACT PURCH CONTAC 86 027 REAL ESTATE DIVISION MANAGER REAL ESTATE 86 028 SELLER SELLER CGI INC Page 15 Land Management System Training Manual Section 3 RESERVOIR CODES TYPE CODE DESCRIPTION SHORT DESC 90 10 CHAR 40 CHARACTERS 12 CHARACTERS Alpha amp Numeric This code will be not be populated This will vary by company and should be set up by the User GOVERNMENT RESERVOIR CODES TYPE CODE DESCRIPTION SHORT DESC 91 10 CHAR 40 CHARACTERS 12 CHARACTERS Alpha amp Numeric This code will be not be populated This will vary by company and should be set up by the User GOVERNMENT LEASE CODES TYPE CODE DESCRIPTION SHORT DESC 95 10 CHAR 40 CHARACTERS 12 CHARACTERS Alpha amp Numeric This code will be not be populated Thi
63. LAND MANAGEMENT SYSTEM TRAINING MANUAL Copyright 2006 CGI AMS INC This document is intended for the internal use of the LANDMAN Management System licensee only and any disclosure or reproduction of its contents without the expressed written consent of PetroComp Systems Group is strictly forbidden 5 2006 PAYMENT PROCESSING CHECKLIST Month Due Checks for Rentals Shut Ins Other Analyst Date Go through this checklist as you are processing payments each time General steps Run the report schedule payments run letters optional and cam be done at any time flag for payment hold delete payment summary and preliminary check reports print checks then check register backup and update history each month at a time You may schedule several groups months of payments to pay simultaneously but do not try to run steps 5 9 on the Payment Processing Menu for multiple months at a time iE Print Payment Projection Report for the month you are getting ready to pay Enter the from through Date on the Options Tab There are 3 formats Review each decide which one and change this procedure Give copy to Temp to pull these lease files Give copy to SI Analyst to review any shut in obligations which are coming up Review and correct all errors and update as necessary Errors will be found in the Event log 2 Run Payment Selection for the month you wish to pay Enter dates Enter Selection Options and Enter who pays option Run Summary
64. Land Management System Training Manual Section 3 3 0 The following section has been designed as a guide through all that you will need to know about basic lease and tract data entry Microsoft Business Solutions Solomon Bile Edit Module Application Options Utility Customize Help GA 5 cGciams Ja Favorites Modules Government Reporting a Economics Graphics Gas Plant Gas Balancing Land Payment and Invoice Proces Contracts Management Partnership Management Minerals Management Fees Fixed Assets Management Fixed Inventory Shared Information Multi Company Currency Manager Application Server Project Controller Allocator Time and Expense for Projects Employee Utilization Analyzer Communicator Flexible Billings Project Budgeting Contract Management Service Dispatch E Service Contracts Equipment Maintenance Flat Rate Pricing x Land Maintenance Lease Maintenance Lease Maintenance Lease Legal Description Tract Maintenance Land Division of Interest Maintenance Land Leasehold Ownership Transfer Tract Map Reference Lease Tract Payment Obligations Lease Tract Special Obligations Lease Tract Remarks Lease Chain of Title Additional Counties Lease Tract Cross References Billing History Maintenance Prospect Maintenance Prospect Segment Maintenance Land Division of Interest Maintenance Prospect Map Reference Prospect Segment Special Obligations Prospect Segment Re
65. Manual Section 5 GLOSSARY ALLOTTED LANDS Indian Lands Land allotted to Indians on reservations and land from the public domain allotted to Indians not on reservations The allotter received a Trust Patent issued in his name but under which the United States holds the allotted land in trust for a specified time Title to unallotted land is held by the tribe AVULSION A sudden cutting off of land by flood currents or change in the course of a body of water especially one separating land from one person s property and joining it to another s BONUS An amount paid to a person owning land up front for an oil amp gas lease BOTTOM HOLE AGREEMENT Creates an obligation on the part of the supporting party to pay a sum of money or in some instances to assign certain acreage upon the satisfaction of certain drilling obligations by the other party CARRIED INTEREST Usually a geologist or broker involved in a well whose expenses are carried until a pre determined time to casing point or through the tanks for example CASING POINT Point of deciding whether to go into production i e set production casing and attempt a completion CO TENANCY Multiple ownership of land or minerals If all owners cannot be located and drilling starts those owners are still entitled to their percentage after payout to operator If they still can t be located monies must be held in suspense for a certain number of years then released to the s
66. NUM Psvr ea iinbox mic 3 Floppy oAntelopen 9 Solomon IV 2lmicrosote Documenti G2 HS gam 1 59pm Select Data Source ay 2 x File Data Source Machine Data Source Look in Data Sources 7 cs DSN Name New Select the file data source that describes the driver that you wish to connect to You can use any file data source that refers to an ODBC driver which is installed on your machine Select Data Source E 2 x File Data Source Machine Data Source ABRIAPP User Solomon IV ABRIAPP ABRISYS User Solomon IY ABRISYS ANTAPP User Solomon I ANTAPP ANTSYS User Solomon IV ANTSYS AREAS15004PP User Solomon IV AREA515004PP AREAS 5008S User Solomon IV AREAS1 5005S CBA_EH_DB System CB4_TL_DB System CUACCTCCTADD r Calamani CUACCTCCTADO of Machine Data Source is specific to this machine and cannot be shared User data sources are specific to a user on this machine System data sources can be used by all users on this machine or by a system wide service Cancel Help Link Tables Ei x fd I Save password F Microsoft Access _ 8 x File Edit View Insert Tools Window Help Type a question for help Oe ea Say s BB o B sa to ols ag a s amp db1 Database Access 2000 file format open DE Design anew X 2o EE HF Objects Create table in Design view Tables Create table by using wizard Queries Create
67. Page 44 Land Management System Training Manual Section 5 i Name amp Address Maintenance CM 110 00 zes active I SHIRELY A SYLESTINE E SHIRELY E Main Address Milton Fry No 8 14 2000 SYSADMIN 8 14 2000 SYSADMIN ol Update of Contact to be once a day How difficult to make real time Create Contact record for Base Name amp Address record use first address ID Create Additional record for each Contact and it s address ID CGI INC Page 45 Land Management System Training Manual Section 5 GE SHIRELY A SYLESTINE Contact olx Eile Edit Yiew Insert Format Tools Actions Help E Save and cose Fy amp 0 Y pHo ae General Details Activities Certificates All Fields e Full Name Ms SHIRELY A SYLESTINE pues x izos 563 254 O 1563 2549 Job title E Home x ha Company SHIRELY A SYLESTINE Bisiness Fax x E File as SYLESTINE SHIRELYA Mobile yy Address cy Email v am a a Business x RT 3 BOX 414 B LIVINGSTON TX 77351 9506 Ya page address IV This is the mailing address a Contacts Categories Private _ AES Name details Title Ms X Cancel First SHIRELY Middle 55 Check ddress 21 x Lat SYLESTINE Address details Suffix 7 Street RT 3 BOX 414 B M Show this again when name is incomplete or unclear Check Full Name Cancel di
68. RACTERS 12 CHARACTERS Alpha amp Numeric This code will be not be populated The design of this code is a company preference and should be set up by the User DISTRICT CODES TYPE CODE DESCRIPTION SHORT DESC 24 17 CHAR 40 CHARACTERS 12 CHARACTERS Alpha amp Numeric This code will be not be populated This will vary by company and should be set up by the User CGI INC Page 4 Land Management System Training Manual Section 3 LEASE TYPE CODES SHORT DESC ALLOTTED LDS FED ACQUIRED PUBLIC LEASE LSE FED FEE FED OCS ROW ST OFFSHORE SURFACE LSE ST ONSHORE SWD TRIBAL LANDS VET LAND BRD SHORT DESC TYPE CODE DESCRIPTION 25 AL ALLOTTED LANDS 25 FA FEDERAL ACQUIRED 25 FD FEDERAL PUBLIC DOMAIN 25 FE FEE LEASE 25 FL FEDERAL LEASE 25 oc OUTER CONTINENTAL SHELF 25 RW RIGHT OF WAY 25 SF STATE OFFSHORE 25 SL SURFACE LEASE 25 ST STATE ONSHORE 25 SW SALT WATER DISPOSAL 25 TR TRIBAL LANDS 25 VL VETERANS LAND BOARD UNIT CODES TYPE CODE DESCRIPTION 26 10 CHAR 40 CHARACTERS Alpha amp Numeric 12 CHARACTERS This code will be not be populated This will vary by company and should be set up by the User PAYMENT RESPONSIBILITY CODES TYPE CODE DESCRIPTION SHORT DESC PYMT DUE PAYS BILLS 27 01 WE PAY ALL WE PAY ALL Y 27 02 WE PAY AND BILL OTHERS WE PAY BILL a4 b x 27 03 OTHERS PAY ALL THEY PAY ALL X N N 27 04 OTHERS PAY AND BILL US THEY PAY BIL x N N 27 05 NO PAYMENT DUE NO PYMT
69. RED TO ANOTHER NUMBER TRANSF NO 3 T002 TRANSFERRED TO ANOTHER COMPANY TRANSF CO 3 u001 DROPPED FROM UNIT OUT OF UNIT 3 u002 UNIT DISSOLVED UNIT DISSOLV 3 WP amp A WELL PLUGGED AND ABANDONED WELL P amp A D CGI INC Page 7 Land Management System Training Manual Section 3 CONTRACT TYPE CODES TYPE CODE DESCRIPTION SHORT DESC 33 AMI AREA OF MUTUAL INTEREST AMI 33 BCA BOTTOMHOLE CONTRIB AGREEMENT BOTTOMHOLE 33 BID BIDDING AGREEMENT BIDDING AGMT 33 BOS BILL OF SALE BILL OF SALE 33 D O DIVISION ORDER DIV ORDER 33 EXPL EXPLORATION AGREEMENT EXPL AGMT 33 F O FARMOUT AGREEMENT FARMOUT AGMT 33 G001 GAS PURCHASE AGREEMENT GAS PURCH AG 33 G002 GAS PROCESSING AGREEMENT GAS PROC AGT 33 G003 GAS SALES CONTRACT GAS SALES 33 JOA JOINT OPERATING AGREEMENT JT OPER AGMT 33 MISC MISCELLANEOUS MISCELLANEOU 33 PPA PRODUCTION PAYMENT AGREEMENT PROD PMT AGT 33 STRG STORAGE AGREEMENT STORAGE AGMT 33 TRAN TRANSPORTATION AGREEMENT TRANSP AGMT 33 UNIT UNTI AGREEMENT UNTI AGMT MINERAL INTENT LISTING TYPE CODE DESCRIPTION SHORT DESC 35 CG CASINGHEAD GAS CASINGHD GAS 35 CO CRUDE OIL OIL 35 GS GAS GAS 35 OG OIL AND GAS OIL AND GAS 35 SW SALT WATER DISPOSAL SWD PROVINCE PROSPECT CODES TYPE CODE DESCRIPTION SHORT DESC 36 10 CHAR 40 CHARACTERS 12 CHARACTERS Alpha amp Numeric This code will be not be populated This will vary by company and should be set up by the User CGI INC Page 8 Land Management System Training Manual
70. Registration Record Field Report Control Maintenance Generate Schema Control Macro Generator Transaction Import DB Update Possible Yalues Import Project Series Message Log Viewer Image Link Site Setup Image Link Doc Type Maint The event log viewer will capture errors or other important messages during payment and invoicing processes CGI INC Page 1 Land Management System Training Manual Section 2 2 1 COMPANY MAINTENANCE Go to Utility on the Soloman IV tool bar Select Company Maintenance to setup the company or companies in the database ix File Edit Module Option Utility Customize Help Password Event Log Options Write Event Log Diagnostics Object Model Samples User Group Access Rights Access Rights Report Access Rights List Event Log Viewer Database Administration Company Maintenance Database Physical Integrity Registration Record Field Report Control Maintenance Generate Schema Control Macro Generator Transaction Import DB Update Possible Values Import Project Series Message Log Viewer Image Link Site Setup Image Link Doc Type Maint This should be already completed by CGI Consultant when the data base is created See Company Setup and Land Setup in Section 3 of this manual CGI INC Page 2 La
71. S TYPE CODE DESCRIPTION SHORT DESC PYMT DUE DR ACCOUNT CR ACCOUNT 30 Al RENTAL Al RENTAL Al Y 0000000000 0000000000 30 AG ATTORNEY GROSS ATTORNEY GRO Y 0000000000 0000000000 30 AR RENTAL AR RENTAL AR N 0000000000 0000000000 30 BK BROKER PAYMENT BROKER PYMT Y 0000000000 0000000000 30 BN BONUS BONUS X 0000000000 0000000000 30 FBW FEDERAL BACKUP WITHHLD FEDERAL BU 0000000000 0000000000 30 GP GOLDEN PARACHUTE GOLDEN PAR Y 0000000000 0000000000 30 HC HEALTH CARE HEALTH CARE x 0000000000 0000000000 30 MMS MMS SPECIAL PAY MMS SPECIAL Y 0000000000 0000000000 30 MR MINIMUM ROYALTY MIN ROYALTY 0000000000 0000000000 30 OI OTHER INCOME OTHER INCOME Y 0000000000 0000000000 30 OP OPTION TO RENEW OPTION TO RE Y 0000000000 0000000000 30 PD PAID UP PAID UP Y 0000000000 0000000000 30 PP PRODUCTION PAYMENT PROD PYMT x 0000000000 0000000000 30 RI ROYALTIES ROYALTIES Y 0000000000 0000000000 30 RN DELAY RENTAL DELAY RENTAL x 0000000000 0000000000 30 SF SURFACE LEASE SURFACE LEASE Y 0000000000 0000000000 30 SL SHUT IN ROYALTY SHUT IN ROY Y 0000000000 0000000000 30 SP SPECIAL PAY SPECIAL PAY Y 0000000000 0000000000 30 TX TAXES PAYABLE TAXES PAYABLE Y 0000000000 0000000000 30 TXC TAXES PAYABLE COLORADO TAXES PAY CO Y 0000000000 0000000000 DROP REASON CODES TYPE CODE DESCRIPTION SHORT DESC 3 EXP EXPIRED EXPIRED 3 INLS INVALID LEASE INVALID LSE 3 NPR NON PAYMENT OF RENTAL RENT NOT PD 3 PRCD PRODUCTION CEASE DPROD CEASED 3 SLD SOLD SOLD 3 T001 TRANSFER
72. SADMIN 12 14 2005 Click on the related party on line 1 in the grid of the screen and then click Related Parties details to navigate to the Name and Address record for this related party lt F9 gt Opens the Note field next for the line in Focus CTRL S to save then Shift Tab puts focus on the OK button then Space Bar closes the note CONTACTS This does not require an individual to be setup in the Name and Address Lease Maintenance LM 100 00 Actions Haxh e v z MlOE LeaseNo ZTEST1 PI Images Lease Name I Citical Lease Alt Sequence ftestmotact O Grantor Lease No a Lessor o as Lessee i TT Broker OoOo a Region sy Menu Lease Date Eff Date Lease Term Exp Date Acquired ff vot 0fYears i lolx Contacts J J Contact First Name Contact Last Name Department Title Email Address Work Phone No Cellular Phone No 1 erate Fanaa WE Modified Approved SYSADMIN 03 03 2006 SYSADMIN PE Lease Maintenance LM 100 00 SYSADMIN 05 02 2006 Actions Hida xG F e o j Nlo w torso Cl Images Menu Alt Sequence Trest no tract e Kag Lr Grantor Lease No Sepsis dos bess Qh trom tree Lessee Exp Date AZ Broker Acquired ood Region oix Contacts First Name Work Phone No Last Name Cellular Phone No De
73. Section 3 GEOLOGICAL PLAY SEGMENT CODES TYPE CODE DESCRIPTION SHORT DESC 37 10 CHAR 40 CHARACTERS 12 CHARACTERS Alpha amp Numeric This code will be not be populated This will vary by company and should be set up by the User DISTRICT PROSPECT CODES TYPE CODE DESCRIPTION SHORT DESC 38 ES EASTERN STATES EASTERN ST 38 FM FARMINGTON FARMINGTON 38 GC GULF COAST GULF COAST 38 MD MIDLAND MIDLAND 38 OFF OFFSHORE OFFSHORE 38 RM ROCKY MOUNTAINS ROCKY MTN 38 SW STATE WATERS STATE WATERS 38 WC WEST COAST WEST COAST REMARK TYPES LOCATION CODES TYPE CODE DESCRIPTION SHORT DESC 44 10 CHAR 40 CHARACTERS 12 CHARACTERS Alpha amp Numeric This code will be not be populated This will vary by company and should be set up by the User CGI INC Page 9 Land Management System Training Manual Section 3 REMARK TYPES NAME CODES DESCRIPTION SHORT DESC TYPE CODE 45 10 CHAR Alpha amp Numeric 40 CHARACTERS 12 CHARACTERS This code will be not be populated This will vary by company and should be set up by the User GEOGRAPHIC REGION CODES DESCRIPTION SHORT DESC 001 002 003 004 005 006 007 008 009 010 011 012 013 014 015 a a A a a rr a a OT a eT a OH GOVERNMENTAL FIELD CODES Offshore Federal Offshore Louisiana Offshore Texas Eastern Region Central Region So Central Region Mountain Region Foreign Region Gulf Coast South Texas Mid Continent Rocky Mountain
74. Serif FontSize 8 FontStrikethru False Enant Indarline Falco The Default field between DBNav and Enabled above which is blank set customized value equal to 001 Right click on state and set customized value to 35 If all in one county set customized value county equal to xxx like 135 Note also Blankerr is set to False change this to True if you wish this field to be required ie If blank then this is an error Properties x Customized Value Standard Value 0 amp H80000005 False 35 True bxlmmtrac stateapi 0 0 0 0 MS Sans Serif False False MS Sans Serif 8 FontStrikethru False Fant Indarlina F alza CGI INC Page 8 Land Management System Training Manual Section 5 Tract Maintenance LM 200 00 iojxi Actions d X o 2 O amp Ss Menu f e 001 Tract No Ownership H Lease Name mileage i sespe A Prospect Sea t Nat St County ee eS Property Window Date A ERASE RD S Code Window D ale ASE ye Remove Changes for Object General Ir Align to Grid aaa DOI Sub 000001 w visible Our Share 9 000001 Lsr Min Int o oo v Enabled 0 00 Rental Amt od Depth Limit v TabStop Operator Map Desc Insert Object Wizard Remark Acres Contains Objects erlap Company Net Tez OnTop 0 000000 0 000000 0 000000 HBP 0000000 0 000000 0 000000 0 0
75. Sj Lease Legal Description LM 101 00 olx Lease No Menu Lease Name Enter a Lease Number 1 Characters max or press lt F3 gt to view existing DEVELOP SYSADMIN 7 19 01 Enter the description of the property from the lease NOTE This does not have all the functions of a word processor You may copy and paste insert delete and word wrap NOTE This lease legal description will be copied to the Map Description tract level the first time you enter the Map Description tract level screen You must save this information at the tract level to make it permanent and then add detail to the tract description 4 10 REMARKS DESCRIPTION Remarks for each tract in a lease are entered using this screen The remarks may be segmented by assigning a remark type to different categories of remarks Each remark type within a lease may have up to 8 pages lines of description The lt F3 gt table lookup feature is available in the Remarks Type field Refer to Section 2 1 10 in the LANDMAN System User Manual for detailed information Lease Tract Remarks LM 105 00 Actions Jo aA XG F e r jO E Lease No 1 caoo1 00200 g Meu Lease Name California State Lease Tract No Note Remark Type 03 ae No SURFACE USE 05 a Yes MINERAL INTEREST OF ae Special DEPTH LIMITATION 10 000 RENTAL PUGH CLAUSE cS va Special CESSATION a 2 ea ale 5 6 LSSR Yes v mpi TS B Applies Type Description 4
76. TEM GETTING STARTED The purpose of this outline is to guide you through each of the important functions and features available in the LANDMAN system This structural approach assures us of covering all the salient features in the system in a logical sequence Please understand that all of the system will be covered and most all questions you will have will be covered WHAT YOU HAVE RECEIVED gt Land Getting Started Manual gt LANDMAN Manual gt LANDMAN Installation CD gt LANDMAN Report Assistant HARDWARE REQUIREMENTS In order to run LANDMAN your computing system should be an Intel based Microsoft compatible and must have the following gt gt Pentium 800 or faster CPU Recommended Local Hard Disk 20 GBytes or more recommended 1 Floppy diskette drive 1 CD drive 512 Mg RAM memory An SVG or better monitor Windows 2000 XP Professional is required 132 column printer or greater Laser HP compatible recommended Please consult PetroComp Systems Group about using any compatibles before purchasing the computer or the LANDMAN program CGI INC Page 1 Land Management System Training Manual Section 1 1 1 LAND QUESTIONS AND ANSWERS The following questions and answers will provide insights into the workings of the system and encourage additional questions you may have regarding how the system can be adapted to your company s specific needs 1 Mass Lease Copy LM 113 00
77. VE x 03 I INACTIVE WATER INJECTION WELL INACTIVE INJ Y 03 IS SHUT IN WATER INJECTION WELL SI WATER INJ x 03 IT TEMP ABANDONED WATER INJECTOR TA WIR INJ 03 NP NON PRODUCING NON PRODUCIN y 03 PA PLUGGED amp ABANDONED PLUGGED amp AB Y 03 PB PLUG BACK PLUG BACK x 03 PR PRODUCING PRODUCING ki 03 PT PLANT PLANT x 03 RC RECOMPLETED TO ANOTHER ZONE RECOM ZONE Y 03 RE RECOMPLETED RECOMPLETED Y 03 SD SOLD SOLD 03 SE SEALED SEALED x 03 SI SHUT IN SHUT IN Y 03 SS SHUT IN SALTWATER DISPOSAL WELL SI SWD y 03 ST TEMP ABANDONED SALTWATER DISPOSAL TA D SWD 03 SW ACTIVE SALTWATER DISPOSAL WELL ACTIVE SWD x 03 TA TEMPORARY ABANDONED TEMPORARY AB Y 03 TR TRANSFERRED TRANSFERRED x 03 UN UNITIZED UNITIZED 03 WI SHUT IN WATER SOURCE WELL SHUTIN WSW x 03 WS WATER SOURCE WELL WATER SOURCE Y 03 WT TEMP ABANDONED WATER SOURCE WELL TAD WSW Y For complete list of sample codes see the appendix following this section CGI INC Page 21 Land Management System Training Manual Section 3 3 6 NATION STATE COUNTY MAINTENANCE Now we will add a Nation State amp County On the File Maintenance menu select Nation State County S Landman Menu LM 000 00 E 5 x File Maintenance Find Master Listings Reports Payment Processing Invoice Processing Utilities Leases DEVELOP SYSADMIN 12 03 2001 Prospects Producing Properties Contracts General Cross Ref Name and Address Code Descriptions Nation State County ee ee a
78. able waters from the low tide line out to the 3 mile limit opposite it s seacoast except Texas which owns out to the 3 league line approximately 10 miles The Federal Government owns all lands beyond the 3 mile limit on the OCS Outer Continental Shelf SUB LEASE In landlord and tenant law a transfer of an interest in an estate for years of lesser size than the underlying estate TERM INTEREST MINERAL Mineral interest lasting for a certain term Generally last through production during the term The term will be extended as long as production continues CGI INC Page 71 Land Management System Training Manual Section 5 TRACT A subdivision of a lease If mineral ownership or leasehold interest are not uniform for the entire lease the lease is divided into tracts each of which reflect uniform ownership Tracts may be horizontal or vertical subdivisions Also tract Each area of uniform working interest ownership that has been unitized within a field wide Unit Each tract has a identifying number on a participating factor for the unit area UNITIZATION Bring together to create a large unit for joint operations of a complete reservoir Usually already multiple producing properties CGI INC Page 72 Land Management System Training Manual Section 5 This Page Intentionally Left Blank CGI INC Page 73
79. alid Expense Account Expense Account 1230010000 Payment Type RN Lease Tract AR 7 7S WL 0009 ERRORS Payment History not updated Correct and rerun System Message 6125 Process ended Wed Apr 26 09 32 A M If interface to JIB Y or AFE Y these accounts must be setup in JIB Parameters 4 19 INVOICE PROCESSING The Invoice Processing section outlines the steps required to process invoices J Landman Menu LM 000 00 File Maintenance Find Master Listings Reports Payment Processing Invoice Processing Utilities DEVELOP Schedule Biling Preliminary Invoice Rpt Invoice Selection Review Print Invoices Mailing Labels Invoice Summary Rpt Biling Update Payment Biling Rpt Biling Hist Maintenance Reprint Invoices Refer to Sections 6 0 through 6 9 in the LANDMAN System User Manual for additional information 4 20 UTILITIES The Utilities section is a group of six functions which copy data or make mass changes easier Refer to Sections 7 0 through 7 7 2 in the LANDMAN System User Manual for Specific details Ej Landman Menu LM 000 00 File Maintenance Find Master Listings Reports Payment Processing Invoice Processing Utilities DEVELOP VTOWNSEND Lease Copy Lease Transfer Leasehold Ownership Transfer Recalculate Net Company Net Acres Multiple Cross References Contract Copy Import Export Purge Leases Import Export Purge DOIs 4 21 EXCEL SQL ACCESS DATA ACCESS
80. ance is there a screen to cross reference the well or unit to a lease ANSWER Yes A Producing Property can be cross referenced to a lease within Lease Maintenance once the Producing Property has been set up in the Producing Property File CGI INC Page 15 Land Management System Training Manual Section I Location Maintenance CM 010 00 mel x Edit Template Submit Navigation Favorites Jd IX eer DB eo Soe LocationID fiyryo37932 4 HUNTER RANCH TRACT 47 Location Type wel x IV Active 01 01 1990 hes Location oie Map Reference Alternate seq HUNTER RAN Short Description HUNTER RANCH eane te Detail Screen 5 AFE Prospect P Petrocomp Generatec Main DOI Sub yrvo37900 09 District Rev DOI Sub Cross Referen Field MUDDY MUDDY JIB DOISub Remarks Lease WY037900 HUNTER RANCH MUDDY Land DOI Sub SpE Olehe piian Reservoir Status Unit Status Date 22 Facility Susp Code Operator 000001 Allan Business Resou Misc Nat State 001 49 WYOMING APiwei County 005 CAMPBELL Federal ID Well Type Taxing Auth State ID Dil X I Book Cost J Book Revenue Net Receivables Section 29 J Adj Tax Rate J Marginal IV Afe Prompt oo Copy Well Delete well DOI Detail Setup Date User 04 20 1998 SYSTEM Update Date User 09 03 2004 SYSADMIN 001 SYSADMIN 09 03 2004 32 Can I print just one single Lease Data Sheet ANSWER Yes Click
81. ases destination company and select the lease screens to export Daejin need to have an all check box and click NEXT CGI INC Page 21 Land Management System Training Manual Section 5 Import Export Purge Leases LM 116 00 Completing the Lease Import Export Wizard You have successfully specified the information required to import and export the lease data Review the selections below and click on FINISH to execute Summary Source Microsoft SOL Server Location x250 Database Development Source Flat File Location LYoungblood Range Company ID DEVELOP When you click Finish the leases will be exported To bring the leases back into to another database the flow works the same way Case 2 Choose the directory where you saved the text files and then follow the steps If you want to purge the source database check the checkbox like below CGI INC Page 22 Land Management System Training Manual Section 5 Import Export Purge Leases LM 116 00 Select Source Tables You can choose one or more tables but you always have to choose Lease Tract Vv M Vv Vv M M M M M M CGI INC Page 23 Land Management System Training Manual Section 5 Notes Confirm that the MSHFLXGD OCX is available and registered CGI INC Page 24 Land Management System Training Manual Section 5 5 4 Multiple Cross References Ky Ge
82. ata Sheet Laid Modified Approved in 7 eS ee eee SYSADMIN 03 27 2006 CGI INC Page 9 Land Management System Training Manual Section 3 Tract Maintenance LM 200 00 Jel Eq Actions Hax evs zl B Ot 8 leseNo iii Leea Pacl o keg Lease Name Status Date Ly Depths Prospect Seg t ee l Upper 0 Nat St County wml Lower 0 Bk Pg Entry 1 Date Copy Rec Info Bk Po Enty 2 Date Fed Ac g 000000 Ownership General Information Cost and UDC DOI Sub 000001 ooo Int Type fwi OurShare p po000000 J CountAc Addl Cty Lsr Min Int 9 o0000000 Bonus Amt 0 00 RentalAmt 0 00 AFE Depth Limit zea Operator Sea Sia Map Desc on cd Remark as Actes Gross _ Overlap Company Net Tract o ooo000 o ooo000 0 000000 0 000000 HBP o ooo000 0 000000 0 000000 0 000000 Developed o oo0000 o ooo000 0 000000 0 000000 Undeveloped 0 000000 0 000000 ooooooo 0 000000 Refresh Our Share Cale Net Co Net Drop DiCd 7 Created Modified Approved T rE i Fo SYSADMIN 03727 2006 CGI INC Page 10 Land Management System Training Manual Section 3 3 4 NAME AND ADDRESS MAINTENANCE Discuss Access Rights Who will set up name and address or will they be linked to another accounting system To display the Name and Address screen cl
83. ayment equal to the amount of the rental is due and is paid in arrears MOTHER HUBBARD CLAUSE Coverall clause to define boundaries of lands covered in the lease but not described NON PARTICIPATING OWNER An expense free interest in oil or gas as if and when produced The prefix non participating indicates the interest does not share in bonus or rental or in the right to execute leases or to explore and develop OIL AND GAS LEASE The mineral owner by execution of the lease transfers his right to explore drill develop produce save etc oil amp gas for a term of years to the lessee The lessor reserves a royalty interest and the lessor owns the leasehold or W I Upon expiration of the lease the rights transferred revert to the mineral owner OIL PAYMENTS OR PRODUCTION PAYMENT A stipulated amount of money paid out of a fractional share of the working interest owner s share of income from the sale of production Usually created as part of a financing agreement ORRI Royalty interest in oil company s leasehold interest This is generally a percentage of 8 8ths or of total production Can just be a portion of the company leasehold interest CGI INC Page 68 Land Management System Training Manual Section 5 OVERLAP Used to accurately state gross acres in a lease The surface acres described in the lease are lease gross acres Any subsequent partial interest lease that has a description either fully or partially cov
84. b on the bottom List line type in U to select the title information for your lease CGI INC Page 14 Land Management System Training Manual Section 5 Gease Summary Report LM 605 00 Select Print Preview __PrintPreview The Chain of Title report will appear in the following format CGI INC Page 15 Land Management System Training Manual Section 5 lolx xida 1 of 1 vif Sj le hess eh Totar2 100 2of2 Jat DATE 01 17 2002 Development Energy Corporation PAGE 1 TIME 10 42 414M Land Managem ent System REPORT LM60500 rpt USER ID SYSADMIN Lease Summary Report co ID DEVELOP Lease HAMILL amp HAMILL A PARTNERSHIP ET AL Lease No T42010001 00 Chain Of Title 03 05 1936 Inst Type TD TRUSTEE S DEED From 000320 CANEY CATTLE COMPANY To 000321 C G HAMILL Date Filed 03 16 1936 Date Recorded Notification Date Conveyed 1 000000 Reserved 0 000000 Book 110 Page 183 Notes Assigns all right title and interest in and to 11 639 40 acres 02 11 1937 Inst Type TRUSTEE S DEED From 000321 C G HAMILL To 000322 DOROTHY STONER HAMILL Date Filed 02 17 1937 Date Recorded Notification Date Conveyed 0 500000 Reserved 0 500000 Book 116 Page 040 Entry Notes Assigns all right title and interest in and to 11 639 40 acres 06 30 1945 Inst Type TD TRUSTEE S DEED From 000321 C G HAMILL To 000328 CLAUDE B HAMILL amp P R HAM
85. ber use the grid area and check the box Gy Mass Lease Copy LM 113 00 Copy From Copy To Lease No Tract No Beginning Leate No Ending Lease No ee Select All De Select All Lese No Tract No Co NM NM 88888 USA Refresh Grid f Copy Only Copy and Replace With Notes C Without Notes g mia m Include 1 NMNEW fa o 2 Oo V Lease Tract Vv Remarks Ew o 4 oO IV Additional Cnty f Chain of Title 5 z IV Payment Oblig J Special Obligations V Map References Cross Ref fv ALL 8 o ji Contracts g o V Legal Text po Eeducina 149 O Property a Ki na Copy 001 SYSADMIN 10 04 2002 CGI INC Page 50 Land Management System Training Manual Section 5 When you get this message box after clicking copy button click yes Message 2 Do you want to create a new lease Mass Lease Copy LM 113 00 Iof x Copy From Copy To Lease No Tract No Beginning Lease No Ending Lease No NM NM 88888 USA Copy Only Copy and Replace Refresh Grid Select All De Select All With Notes C Without Notes Lease No Tract No Copy 4 Include ean NMNEW E 2 Oo V Lease Tract IV Remarks 3 oO 4 o IV Additional Cnty f Chain of Title 5 m M Payment Oblig 7 Special Obligations V Map References Cross Ref 7 ALL 8 O _ Contracts g m Legal Text Producing
86. ber may be changed at anytime before Code Type 30 Payment Types Description be 2 0 x printing of 1099 s if the codes have been entered for each payment Description a CODE Description Short Description Alternate Sequence 1099 Box cash secon Account Description Expe 1 4G ATTORNEY GROSS ATTORNEY GRO ATTORNEY G 14 1010100000 G 11530 2 BN BONUS BONUS BONUS 1010100000 G 11530 3 BK BROKER BROKER BROKER 1010100000 G 1530 4 RAN DELAY RENTAL DELAY RENTAL DELAY RENT 01 1010100000 G 1530 5 FEW FEDERAL BACKUP FEDERAL BACK FEDERAL BA 1010120000 UE 3010 WITHHOLDING 6 GP GOLDEN PARACHUTE GOLDEN PARAC GOLDEN PAR 13 1010100000 NG 1530 7 HC HEALTH CARE HEALTH CARE HEALTH CAR 06 8 MR MINIMUM ROYALTY MINIMUM ROYA MINIMUM RO 1010100000 H CHECKING 3010 AAC bhaAhkAC COCCIAI DAY bhAKAC COCTCIAI hAKAC COCCIA aninisnAnAnn ACU DC VCRILIC a 4 b DEVELOP SYSADMIN 12 07 2001 PAYMENT TYPE The account from Company CGI INC Page 19 Land Management System Training Manual Section 3 Ky Code Description Maintenance CM 020 00 C Accounting Code Type 30 Payment Types i Land Production Sort By All 1099 Box Cash Account Account Description Expense Acct Account Description Payment Due Sere 4 1 14 1010100000 CASH CHECKING 1530080000 LEGAL FEES x 2 1010100000 CASH CHECKING 1530020000 LEASE BONUS x 3 1010
87. ber v Joint Interest Billing x Save Leases as Locations Checked Yes Last Invoice Number JV Cash Manager i Company Burdens IV Checked Yes Enter Cash Account Number Created Modified Approved 09 19 2001 SYSADMIN 09 23 2005 SYSADMIN i 001 SYSADMIN 10 26 2005 Refer to Section 1 3 2 of the LANDMAN System User Manual for additional information There are decisions to make on various of these data fields such as Are we interfacing to the PetroComp accounting system Account numbers for expenses should be obtained from the GL accountant JB AFE and Cash Manager may be considered User defined codes should be considered UDC for units assignments other The Cost Setup Screen is required before posting printing any checks to your leases Land setup expense account and the code description expense accounts setup Note this account needs to be defined as_8 Sths JIB account This account may be changed for each Payment Obligation CGI INC Page 4 Land Management System Training Manual Section 3 3 2 LAND MANAGEMENT MASTER MENU The Land Management Master Menu defines the major functions that can be performed by the system On the Solomon IV Master Menu slide the mouse down to Land Management lol x Fie Edit Module Option Utility Customize Help PetroComp Menus fal EI Oil and Gas Master Files General Ledger Accounts Payable Accounts Receivab
88. ble OR Press lt F3 gt to see a list of EESESS zi Possible Values for this Field PERSA View Owner Info Created Modified Approved 12708 2005 SYSADMIN 12 08 2005 SYSADMIN iz 00 SYSADMIN 12 14 2005 Note the COPY DOI button ene may be used if the tract ownership is the same or similar on multiple tracts for this or other leases Note the Balance button Balanca to help confirm at data entry time that all interests add to 100 and ensure completed entry Note the View Owner button This will take you to the name and address information on the owner ID in focus The Yellow Sticky notes Icons provide up to 8 pages of notes about the DOI and the note at the bottom of the grid provides up to 8 pages of notes about the owner line item in focus 4 8 PAYMENT OBLIGATION This screen is used to schedule payments which are due for a lease or tract within a lease Each payment obligation within a lease must have a unique payment type and starting obligation date Within this restriction multiple payment obligations may concurrently exist on the same lease This also allows for the scheduling of escalating payments when required g Lease Tract Payment Obligations LM 109 00 ream oe aa sem aa a aw A i Fa a Fa a z A A EA NOTE The Location Allocation button __Lecation Allocation _ and Tract Allocation button in the top righ
89. can select this option as follows J Landman Menu LM 000 00 yy _ ol x File Maintenance Find Master Listings Reports PaymentProcessing Invoice Processing Utilities Leases DEVELOP SYSADMIN 10 30 2001 Prospects Producing Properties Contracts General Cross Ref General X Ref Maintenance Name and Address Special Obligations Code Descriptions Remarks Nation State County Cross References Land Setup Please refer to Sections 2 5 through 2 5 3 of the LANDMAN System User Manual for detailed instructions PAYMENT PROCESSING CHECKLIST Month Due Checks for Rentals Shut Ins Other Analyst Date Go through this checklist as you are processing payments each time General steps Run the report schedule payments run letters optional and cam be done at any time flag for payment hold delete payment summary and preliminary check reports print checks then check register backup and update history each month at a time You may schedule several groups months of payments to pay simultaneously but do not try to run steps 5 9 on the Payment Processing Menu for multiple months at a time 1 Print Payment Projection Report for the month you are getting ready to pay Enter the from through Date on the Options Tab There are 3 formats Review each decide which one and change this procedure Give copy to Temp to pull these lease files Give copy to SI Analyst to review any shut in obligations which are coming up Review and co
90. dPerfect to print on laser labels Each person s computer seems to work differently so consult manager 17 Obtain signature s and send copies to in Accounting immediately this is essential for positive pay procedure DO NOT SEND OUT CHECKS WITHOUT DOING THIS Send an e mail to her at the same time showing which checks are coming through the courier 18 ___ Make additional set of copies for our check control file next to checks and check log Copy onto green our control copy pink payee s copy and white accounting s copy Copies go to accounting as follows One copy of everything to who enters the positive pay entries for every check with purple cover sheet reflecting which checks those below each have a cover sheet If chargeable to a well including shut ins send to yellow coversheet Recoupable rentals payable to MMS go to green coversheet CGI INC Page 1 Land Management System Training Manual Section 4 Recoupable rentals payable to individuals go to blue coversheet Undeveloped rentals go to gold coversheet 19 Certify according to departmental guidelines Rentals If large payment undeveloped or terminable leases to the MMS see guidelines Shut ins Above 25 or outside of Oklahoma others 21s Print Check Register for file Backup Payment files whe1 all checks are finalized and tendered IT will do this step at this time 22 Check Update writes information into the lease fil
91. division orders ANSWER Yes We use the NDOA format For individuals the format is very simple to mail out and get signed CGI INC Page 21 Land Management System Training Manual Section I PLEASE HELP US TO MAKE THIS TRAINING MANUAL MORE EFFECTIVE BY PROVIDING ONE OR MORE QUESTIONS YOU NOW HAVE OR COME UP WITH AFTER EARLY USAGE OF THE SYSTEM CGI INC Page 22 Land Management System Training Manual Section I This Page Intentionally Left Blank CGI INC Page 23 Land Management System Training Manual Section 2 2 0 SECURITY To set up User ID s and passwords for the first time after programs have been loaded onto the system go to the Solomon Tool Bar under Utilities to enter Security Maintenance Under Utility do the following Go to User to setup a new user and password Change password regularly Version 6 requires 1 Capital letter 1 non capital letter and 1 number or special character Larry1 for example Go to Group to tie a user to a group Go to Access Rights to give a user access to various functions See menu below You will most likely use only the Password and Event Log Viewer selection on this menu SIsoimony aT File Edit Module Option Utility Customize Help Write Event Log Diagnostics Object Model Samples gt User Group Access Rights Access Rights Report Access Rights List PWEF Database Physical Integrity
92. e Land Setup To see how the codes should look do an Inquire on the Nation which is set up as 001 then tap lt Enter gt through State By the NAME United States will now appear on the screen as shown below Click on the navigation buttons several times and observe how Louisiana Arcadia and others have been set up F Nation State and County Codes CM 040 00 olx Nation APINo fi State APINo foo County API No 000 State Abbr i Name a Revenue Minimum 0 00 DEVELOP SYSADMIN 7 19 01 This function supports the definition of codes to be used to identify Countries States Provinces and Counties NOTE When setting up states you must enter the Nation code first On counties both the nation and state codes must be entered CGI INC Page 22 Land Management System Training Manual Section 3 Let s try to set up the state of Maine with a State Code of 18 and the county of Oxford Maine with a county code of 017 TO ENTER A STATE CODE TO ENTER A COUNTY CODE 001 lt ENTER gt 001 lt ENTER gt 18 lt ENTER gt 18 lt ENTER gt ME lt ENTER gt 17 lt ENTER gt MAINE lt ENTER gt OX lt ENTER gt OXFORD lt ENTER gt Press lt CTRL S gt to save this information and close the screen to return to the Maintenance Menu Refer to Section 1 3 of the Oil amp Gas Master Files User Manual and Section 1 4 1H of the LANDMAN User Manual for additional information concerning Nation State County Main
93. e Begin Date s EndDate Contract Date Fi Cross References Eff Date Lease Tract Contract i fe Prospect Seg Hl General ee Exp Date Py Location Drop Date a3 Drop Code Survey Desc Meridian Desc Locator Township z and x TownshipDir y Jand x RangeNo pal and z RangeDir vI and 7 Section 7 Jeffersonian E I SYSADMIN 05 02 2006 a Find Contracts CT 920 00 Search Criteria Search Results tt Contracts MATCH ES FOUND Field Name H CONTRACT B Contract No B DEVELOP SYSADMIN 10 30 2001 4 17 LOCATION FIND The LOCATION Find works very similarly to the Lease Find Enter the desired search criteria and click GO Please refer to the Lease Find for additional detail E Find Locations CM 920 00 etesen z E Find Locations CM 920 00 etecorisn Z Select New Mexico Wells and click FIND to Display the following screen Find Locations CM 920 00 Bikel x Locations MATCH ES FOUND Field Value 00165401 Laplata G 32 003932 Texaco 14 Federal 20701 Barrett F 1 DEVELOP SYSADMIN 11 23 2001 Click on the first well listed to display the following screen and right click to show the selection menu gt Gee CM 920 00 Le 1x Search Results Locations 3 MATCH ES FOUND Field Name FieldValue o o 00165401 Lap L
94. e Payment Control File Check Click PAY it will place them in Pay status 6 Run Inquiry Letters May be done at any time during the process sometimes done earlier These are done for payments made by outside parties or partners who may have a say in a delay rental payment Do not need to run if all payments are paid by us See Land DOI owner check boxes 7 Print Payment Summary to ensure the payments you want to make are included This will show a simple list easy to review in overview and the Cost Centers the payments will be booked Land Management System Training Manual Section 4 8 Rerun Payment Summary if you changed anything in Payment R U 9 _____ Preliminary Check Report Click Print Preview to review all unless you are specifically printing only a particular type payment when processing shut ins for example and the month you want Scan for problems it will flash you when there are errors but if only one or two you may want to note from the Display rather than going through the full print process Otherwise print and utilize the printed report for your file so you may take notes when you go through to correct the problems for future reference Check all payment associated fields for errors Upon obtaining a clean report print a final copy for the notebook If there are errors correct then re schedule payment and go through Steps 1 through 8 as required If a payment needs to be deleted click delete in the
95. e Payment History table and screen 23 Print Payment History Report to ensure they all posted correctly and or spot check a couple of leases on the lease payment history screen 24 Print the Invoice Report Notes x Procedures PayProcessChecklist CGI INC Page 2 Land Management System Training Manual Section 5 5 0 E REPORTS gt Lease Data Sheet gt Division Of Interest Inquiry gt Prospect Data Sheet Inquiry gt Name amp Address Inquiry gt Producing Property Inquiry gt Code Description List gt Contract Summary Inquiry gt Location List Inquiry gt General X Ref Inquiry gt Lease Cross Reference Please see the Land Management Report Assistant Manual G5 Exhibit A LM 601 00 F Print Notes 02 27 2002 9999 Any screen that has the word Selection next to the date has a screen more similar to Petrocomp standard rather than Microsoft standard Solomon See next page CGI INC Page 1 Land Management System Training Manual Section 5 exhibit A LM 901 10 x Lease Prospect Region Nation State Lease Type Instrument Type Interest Type Status LSE UDC 01 LSE UDC 02 TRA UDC 01 TRA UDC 02 Partner ID Partner Interest OK Clear Selection DEVELOP SYSADMIN 02 27 2002 Through General Ref Type ry General XRef No i ee Clear Selection DEVELOP SYSADMIN 02 27 2002 CGI INC Page 2 Land Management Sy
96. e additional questions For example Payment Responsibility D Code Description Maintenance CM 020 00 E 0 x C Accounting Code Type EJ Payment Responsibility C Land Production Sort By All CODE Description Short Description Alternate Sequence Payment Due Company Pays Company oie fee Ot WE PAY ALL WE PAY ALL WE PAY ALL x JEJ O Pz 02 WE PAY AND BILL OTHERS WE PAY BILL WE PY amp BL x x x 3 03 OTHERS PAY ALL THEY PAY THEY PAY x oO oO 4 04 OTHERS PAY AND BILL US THEY PAY BIL THEY PY amp BL x oO oO 15 05 NO PAYMENT DUE NO PYMT DUE NO PYMTDUE oO oO oO ical o m o Ez O O m a o m o BA o m o 10 E o o R ajej DEVELOP SYSADMIN 12 07 2001 Note for 01 05 above you could use WPAY WPBO OPAY OPBL NOPY PAYMENT RESPONSIBILITY gt Is apayment rental shut in etc due gt Does your company pay rentals gt Does your company bill joint charges CGI INC Page 18 Land Management System Training Manual Section 3 And Payment Types D Code Description Maintenance CM 020 00 Accounting Land Production All gt General Ledger Account If interfacing with the PetroComp General Ledger enter the account number that this payment type is to debit Parameters will be credited gt 1099 Box Enter the number of the box in which this payment is to be shown on the 1099 Defaults to the rental box The box num
97. e cursor on Alt Sequence or Last Name and double click to sort by both category and owner name To enter another ID you click on the NEW page icon just under File on the Solomon tool bar Review the Lease Data Sheet at the beginning of this chapter and add Walter Martin to the name and address codes The data items are displayed for reference Refer to Section 1 1 of the Oil amp Gas Master Files User Manual and Section 1 4 1F of the LANDMAN User Manual for additional information concerning Name and Address Maintenance Function Keys F1 Help F2 To change a data field while in grid mode insert is NOT enabled F3 Lookup F4 Grid to form to grid form to grid toggle switch F5 Delete current data field NOTE the delete key on a grid line any where in the line deletes the entire line as Accept current date into a date field F9 Access to note without clicking the mouse lt F9 gt Opens the Note field next for the line in Focus CTRL S to save then Shift Tab Shift Tab puts focus on the OK button then Space Bar closes the note F12 Jump to next grid We do print Multi Names on Land Check For Credit of When you change the name please update the multi name as well If the original name was an individual You have to clear the first name before you change the name type All our report default to print FIRST NAME LAST NAME WITHOUT checking the name type P
98. e in Customize mode CGI INC Page 6 Land Management System Training Manual Section 5 Tract Maintenance LM 200 00 iojxi Actions P zi 3 x il e 3 v g Lease No 001 Tract No Ownership nee ree Lease Name Lease Status Date E Prospect Seg t Nat St County a Bk Pao Entry 1 ae cami Date r eas A Code Window Date Bk PgrEnty 2 t Remove Changes for Object General lr Align to Grid DOI Sub 000001 w visible Our Share 9 000001 Lsr Min Int o oo v Enabled 0 00 Rental Amt od Depth Limit v TabStop Operator Map Desc Insert Object Wizard Remark Acres Gonteins Objects erlap Company Net Tract Cilio 0 000000 0 000000 0 000000 HBP 0 000000 0 000000 0 000000 o ooo000 Developed 0 000000 0 000000 0 000000 o 000000 Undeveloped 0 000000 0 000000 0 000000 o 000000 Refresh Our Share Calc Net Co Net DiopDWCd fy o Created Modified Approved as i i Customization Design Mode SYSADMIN 01 05 2006 Right Click on the Nation input field and click on the Property Window CGI INC Page 7 Land Management System Training Manual Section 5 Properties x cNation4Pl SAFt Customized Value Standard Value 0 amp H80000005 False Enabled True FieldName bxlmmtrac nationapi 0 0 Fieldclass 0 Font MS Sans Serif FontBold False Fontltalic False FontName MS Sans
99. e or multiple selections E Multiple Cross References LM 108 00 From Cross Ref Type Prospect Prospect Seg No 901 ooo LEESVILLE To Selection Criteria Cross Ref Type Lease Tract v J Lease Level Beginning Lease No Ending Lease No ns ee Refresh Grid Select All Generate Cross References To a Lease No eg Lease Name Sel 4 1 00002 001 000 test o 00002 001 001 test o 3 0 404 001 000 BS Burdens Print Test Lease o Pg o 404 001 001 BS Burdens Print Test Lease E 50 404 001 002 BS Burdens Print Test Lease E e 12345 000 Lease Data Sheet Test Lease Name oO 7 12345 001 Lease Data Sheet Test Lease Name o a 1234566666666 000 Jones o g 1234A 000 12345 Oo Fa DEVELOP SYSADMIN 01 23 2002 El CGI INC Page 38 Land Management System Training Manual Section 5 If you want to choose a range for your To Selection Criteria use the Beginning and Ending fields as shown below E Multiple Cross References LM 108 00 lolx From Cross Ref Type Prospect Prospect Seg No o foo LEESVILLE To Selection Criteria Cross Ref Type Lease Tract v I Lease Level Beginning Lease No Ending Lease No 7T42010002 00 vTa201 0002 00 HAMILL HAMILL A PARTNERSHIP ET AL HAMILL HAMILL A PARTNERSHIP ET AL Select All De Select All Generate Cross References To a
100. e place This is to help isolate them in case of fire or theft of the computer They should be stored away from sources of heat magnetic fields and high humidity Do not store them in direct sunlight next to electric devices or on or near CRT s or other computer equipment Permanent Backups should be stored in a very safe place away from the computer At least once a month a full system backup should be made for storage off site in a bank safety deposit box or at someone s home HOW TO BACKUP See your network administrator for backup procedures CGI INC Page 7 Land Management System Training Manual Section 2 2 4 CODING SCHEMES Contract Number General Cross References Division of Interest DOI Number gt Lease Number gt Code Description Maintenance gt Prospect Number gt Nation State County gt Producing Property Number gt Name amp Address gt gt gt Below you will find notes for the different codes you will need to set up It is advisable to decide on your numbering schemes before beginning You may already have an existing scheme that will work The above information should be assembled and assigned before entering your first lease Consistency is imperative for sorting and reporting features All codes used by the system may be alphanumeric except the tract number LEASE NUMBER gt Size xxxxxxxx 20 Alphanumeric Suffix is generally used for companion leases covering all or part of common May be
101. ective CGI INC Page 6 Land Management System Training Manual Section 1 Land Division of Interest Maintenance LM 130 00 fwrroot0043 000 oos _ Active CRAIG BAUGUESS SR 08 13 2002 m a poon ES 100724 WELLSTAR CORPORAT iON 01 01 2078 016666667 100980 PHEASANT BRUCE D 01 01 2078 1 00000000 101004 BAUGUESS SR CRAIG 01 01 2078 1 00000000 O o O m O o o ci ce im Ea ma ia cro KiE a Balance 08 20 2002 SYSADMIN 08 20 2002 SYSADMIN E eT SYSADMIN 0970372004 CGI INC Page 7 Land Management System Training Manual Section I 9 Is the Lease Ownership Land System DOD table precisely the same one used for Joint Interest Billing Can it be maintained from both systems ANSWER A No The lease ownership records may have WI RI OR NPRI as well as LRI and LMI codes B Even if using the PAYOUT accounting system or if LANDMAN is being used stand alone LANDMAN has it s own DOI which is entirely separate from any other file The owners in a well are not necessarily the owners of a lease or mineral interest 10 At what levels may checks for delay rentals or other lease payments be written ANSWER At the lease level one check per lease is produced for each depository or payee i e separate checks At the tract level one check per tract is produced for each depository or payee Lease Tract Payment Obl
102. em Company Setup CM 001 00 iol xi Actions Jdaxwl Fe2zl Mlou a E ID lt a ashes 001 TEST COMPANY 001 Units of Measure Applications in Use Company Name ID 000001 Allan Business Resources Inc Product Codes SubAccount Location Name amp Address Audit Enable bd Interest Classes Audit Manager Share Contract Master Boeie Partnership Map Reference Setup Service Date Default Required z Calculate Backup Withholding Iv Location Types Backup Withholding 0 00 m Location User Codes Validate DOI For Employees Waming i Code Type Name Length Use Sequential Name amp Address IN r S o fuoco joz Next Name amp Address Number 0 pm 06 UDC 02 03 Last Process Number Used 1 07 UDC 03 10 Product Conversion Method 2 m k 08 UDC 04 Product Conversion Factor le To E E uoce m Balancing InterestCode BAL BALANCING INTEREST T i A Balancing Owner ID OUTSO1 OUTSIDE INTERESTS Ji TI Rounding Owner ID m A 12 UDC 08 InterLocation Clearing Acct 2810000000 INTERLOCATION CLEARING lo Default Office Location 000001 HOUSTON OFFICE a f 14 UDC 10 Group Allocation Location Setup Date User 96 29 2001 SYSADMIN Update Date User 19 26 2005 SYSADMIN Enter the number of Characters that will contain the Table data entered into the Defined SoftCode I ame PM ARIK nae sana S T ee ee a ee wreaks SAG Ar Refer to Section 1 8 of the Oil amp Gas Master Fi
103. ement System Training Manual Section I 2 What is an Exhibit A ANSWER Assignments and other documents often require attachment of a list of leases in a specific format suitable for recording There is a Work Sheet format that is very popular or Excel Query can be used to write your own worksheet format The Exhibit A by Well Location will list all leases associated with the Well Exhibit A LM 601 00 lel EF Actions ld AX Fe gt z Ot Template Report Sort Select Options Cover Page Company Selection Report Format Exhibit z Exhibit 4 Work Sheet County List Prospect Work Sheet Selection 1105 2005 Beg End Page Nbr 1 9999 Copies 1 Print Print Preview Printer Options SYSADMIN 11 05 2005 3 What is the maximum allowable lease number length ANSWER The lease number can have a 20 position alphanumeric base The base is used to identify a lease covering a specific parcel of land and the suffix is used most commonly to indicate other partial interest leases associated with the base lease For example a suffix of 000 might indicate a full interest lease recommended procedure and a suffix of 001 or greater might indicate that the lease covers less than a full mineral interest The suffix is usually distinguished by putting in a dash Additionally there is a 3 digit tract ID CGI INC Page 3 Land Management System Training Manual Secti
104. eneral Cross Ref Name and Address Code Descriptions Nation State County Land Setup GENERAL OVERVIEW Within each maintenance function after the key data is entered the system verifies if the record already exists Key data is a unique set of characters and numbers that completely identify a record of information If it does not exist the system will assume the record is to be added If the record does exist the appropriate information is displayed and it may be changed scanned or deleted based on the activity you select Lease Data Sheets may be produced each day showing additions changes and deletions We recommend that these reports be run on a daily basis Please refer to Sections 1 4 1A through 2 5 3 in the LANDMAN User Manual for additional detail concerning each of these selections CGI INC Page 8 Land Management System Training Manual Section 3 Lease Maintenance LM 100 00 a x Actions Haxe s al HOt 8 Alt Sequence a Lease Date aaa Grantor Lease No SA Eff Date re Lessor O E Lease Term OfYeas z Lessee oOo ESS Exp Date DOE Broker O OO Acquired PF Region oOo a General Info Related Parties Acquired From a es Bonus oog Acre 0 00 Acquired Code Ss Rental o0 Acre 0 00 Owner Instr Type fz o ar Shut In oog Acre 0 00 Lease Type iar a Alt Lease No fo Lease SC 1 a Release Required Lease SC 2 Print Lease Drop Date Code i Copy Lease D
105. eration of the Land Management System l Power on the computer system Enter the system date and time when requested 2 When the computer is ready click the icon of the Land Management Solomon or PetroComp System 3 The system Login Screen will be displayed Login 98 000 00 Solutions Company m User ID SYSADMIN Password Cancel System Database Company Double right click is used to look up possible companies USER ID Enter a various character ID to identify each user The system will then prompt for a password associated with the User ID If a valid User ID and password are not entered the system will request another User ID PASSWORD Keep safe and change regularly once every 3 6 months SYSTEM DATABASE If you have multiple data bases know you data base names Is there a test data base Look here for a test database We will usually set one up as a copy of your original converted data This is used then to try things From time to time it will be useful to copy the live data base to the Test data base NOTE The Last Company amp User ID and SYSTEM data base will be remembered and default into the proper fields You must always key the password The Password will be in 1 4 1 format CGI INC Page 2 Land Management System Training Manual Section 3 3 1 1 COMPANY SETUP This screen is used to set up various codes and default fields for use within the syst
106. ering surface acres previously described in the initial lease are said to be overlapping acres These overlap acres are not added to the gross acres total PAID UP LEASE Lease with no rental clause The lease states that no rentals are due during the term hereof therefore the term paid up lease PORCION SHARE Found only in deep south Texas along Rio Grande Porciones were originally granted by the Crown of Spain to the original settlers of the region Each was usually but not always 1000 veras wide and of varying length They gave each owner access to water for their livestock As time went on the heirs of the original grantees partitioned the porciones so that each heir had a share However there are cases in Starr County and possibly others where litigation has not allowed the partition of certain porciones In this case there are hundreds perhaps thousands of individual owners having undivided interests in the porcion POOLING Bringing together small units in order to get minimum needed to drill PROSPECT Any group of leases assembled to cover an entire geological structure or a prospective area Initial Exploration is usually done for the entire prospect before selecting a drill site PUGH CLAUSE States that only lands producing are not liable for rentals but any acreage outside the producing unit must be kept up on rentals RIDERS Additions or amendments to the oil and gas lease and provides for forms and subjects
107. ese letters be viewed on screen first ANSWER Yes through the Payment Processing Menu This letter is a function of Payment Processing called inquiry letter All reports in the Land System may be previewed on screen before printing 24 What is the format of the Lease Data Sheet ANSWER The lease data sheet is designed to print on a non preprinted form letter or legal 25 What information is provided in an on line environment ANSWER Everything can be displayed on line CGI INC Page 13 Land Management System Training Manual Section I 26 Does the first Tract have to be 000 or can it start with 001 ANSWER One can start with 001 or 000 We recommend 000 for a full interest lease when there is only one tract With the Windows version the tract numbers may be alpha Some find this useful for defining tracts by depth 27 Are obligations date sensitive and able to be reported sorted by date ANSWER Yes and by Obligation Type Drilling Obligation Minimum royalty etc Lease Tract Special Obligations LM 103 00 Edit Template Submit Navigation Favorites Jd AX MCD Dr Be oo LeaseNo fwyv0010042 005 Menu Lease Name WILLIAM J KARSTAIR ET UX a hese Status Status Description ae First Date Tee Code Interpretation Frequency Frequency Type End Date Short Description Note a _ 01 01 2004 MAI MINIMUM ROYALTY DUE Months 12 31 2078
108. he printer be sure to reverse collate them prior to placing in the printer may not have to do this 11 Print Checks Again specify payment type or All then the month and the Report date you want to appear on the checks this should correspond with the day the checks are to be mailed Enter then the beginning check number double check the beginning check 12 __ Print Preview 13 SEND E MAIL TO GET I EOPLE OFF THE PRINTER IF PRINTING DIRECTLY ONTO THE CHECKS This is only necessary if printing actual checks from the printer Usually we will print onto white paper and copy onto tile check stock 14 Press PRINT When it says it is not set up with 10 5 etc settings enter through this by pressing Y 15 ___ IF PRINTING DIRECTLY ONTO CHECKSTOCK ONLY Go directly to printer to see that the first check number is correct Then follow the numbers on the back to see that they are running in succession If anything happens press the OFF LINE button IMMEDIATELY to conserve checks When it stops check the bin to ensure there are no remaining checks If printing onto plain paper this is unnecessary 16 Print Labels PLEASE NOTE May also exp lt X1 into Word or WordPerfect to print on laser labels Each person s computer seems to work differently so consult manager 17 Obtain signature s and send copies to in Accounting immediately this is essential for positive pay procedure DO NOT SEND OUT CHECKS WITHOUT DOING THIS
109. he remarks from the Dorothy lease lease level only to this lease To copy lease level only you must enter in the Tract No K ieee Lease Copy LM 113 00 DOROTHY o 1 L NOOOOOOOk Results CGI INC Page 55 Land Management System Training Manual Section 5 Kot ease Tract Remarks LM 105 00 VT CA01 065 01 FANNELL KATE C BACK IN 12 13 2001 SYSADMIN 12 13 2001 SYSADMIN ZA p DEVELOP n 12 14 2001 To copy everything leave the lease level blank CGI INC Page 56 Land Management System Training Manual Section 5 O fees Lease Copy LM 113 00 DOROTHY ooo oo m Results CGI INC Page 57 Land Management System Training Manual Section 5 Kot ease Tract Remarks LM 105 00 VT CA01 065 01 FANNELL KATE C BACK IN EXTENSION 12 13 2001 SYSADMIN 12 13 2001 SYSADMIN ZA p DEVELOP n 12 14 2001 But you will also get the tract information copied CGI INC Page 58 Land Management System Training Manual Section 5 K Tracts List 10 x Interest Drop TractNo Status Tae Code 002 HBO 003 HBU 004 HBU 005 HBP 006 a Se e ee eee CGI INC Page 59 Land Management System Training Manual Section 5 5 9 Sharing Contracts C
110. ick on File Maintenance then Name amp Address S Landvan Menu LM 000 00 Leases DEVELOP SYSADMIN 12 03 2001 Prospects r Producing Properties gt Contracts k General Cross Ref r Name and Address Code Descriptions Nation State County Land Setup The Name and Address screen will appear as follows Double Right Click Right click in the Srayarea to open Excel Word and other options Name amp Address Maintenance CM i12 90 olx Name ID Name Type First Name Last Name Address TaxID Status Active gt Status Date 7 19 01 Alt Sequence F Send 1099 Multiple Names Related Parties ID E Descr Address Email For Mult ID 1 2 3 SO City E Zip Nation Prov B Attention Main Phone Fax No fas Internet Addr Role aor Role m Code Description Type Maintenance for Selected Role Type View all Roles for this Name ID Enter the unique number to identify the person or company A maximum of ten 10 characters and or numbers is allowed Name Created Modified Approved DEVELOP SYSADMIN 7 19 01 CGI INC Page 11 Land Management System Training Manual Section 3 Enter the ID Number 000002 this will retrieve the data for this ID or enter the data if the ID does not exist The lt F3 gt table lookup feature is available in the Name ID field Plac
111. igations LM 109 00 Edit Template Submit Navigation Favorites Jal XRD wD BD eo Oe Location Allocation Lasse new il Tract Allocation Obligation Summary m History Information Last Check Date FE Check Amount 0 00 Next Payment Date m Obligation Trac Payment Payment Type First Pymt Freq Freq Last Pymt Payment Type Desc Date Period Date Amount RN RENTAL 0170172004 12 Months 0170172009 500 00 01 sf Enter a valid lease number or hit lt F3 gt for selection list Created Modify Approval Fro fees ee ee ee 001 SYSADMIN 09 03 2004 CGI INC Page 8 Land Management System Training Manual Section I 11 What information is provided on the voucher portion of checks at each level ANSWER Information identifying the lease and payment period list of payees the amount tendered for each the address and Social Security or Tax I D number of each Lease description and recording information is also included depending upon the check format selected Several formats are provided a custom format can be designed if desired Four part forms were generally preferred The original and one copy are sent to the depository or payee one of which is signed dated and returned as the receipt copy One copy is usually sent to the Accounting Department and one is retained by the Land Department to be filed in numerical order Laser forms are pr
112. ion 2 NOTE If you have proper backups no steps in LAND are really points of no return But if you do not have backups data recovery can be very difficult LAND will normally stop and tell you to backup certain files before processing such steps DO IT 2 How long will it take me to recover the data I have entered if there were some sort of failure which caused me to loose all of my data This includes simple data such as names and addresses too If the answer is more than a couple of hours you should back up 3 Am I absolutely positive I don t need a backup now If the answer is no if you have any doubts then DO a backup HOW LONG TO KEEP THE BACKUPS PERMANENT BACKUPS Some backups should be permanent backups i e kept for many months or even years gt Backups you make of your programs and program updates are classified as permanent backups and should be kept until a month or so after you have received and begun using an entire new version not just an update of the software gt Data backups made at the end of a processing period or backups of the data used to generate finished financial reports should be kept permanently This will ensure that you have the backup data to answer any further questions that might arise from the printed reports gt From within PAYOUT any data that you WRITE or COPY to history should be kept permanently INCREMENTAL BACKUPS amp GRANDFATHER FATHER SON Incremental backups
113. le Revenue Accounting MMS 2014 Joint Interest Billing AFE Tax Reporting Cash Manager Inventory Purchasing Payroll Production Accounting Government Reporting Economics Graphics Gas Plant Land Management Contracts Management Chase REMM Maintenance Chase REMM Operations Only Chase REMM Interfaces Shared Information Multi Company Currency Manager Application Server FRx Desktop a Es CGI INC Page 5 Land Management System Training Manual Section 3 The LANDMAN Delta Menu will appear as follows oix Land Management Screen Reports LandMan Menu Find Leases Import Export Purge Leases Import Export Purge DOls Audit Manager Audit Log Viewer Lease Maintenance Lease Legal Description Tract Maintenance Ownership Leasehold Ownership Transfer Title Bar Push Pin Audit Manager Click on the highlighted LandMan Menu bar as shown above and the LANDMAN Master Menu will appear as follows 5 LandMan Menu LM 000 00 lolx File Maintenance Find Master Listings Reports Payment Processing Invoice Processing Utilities DEVELOP SYSADMIN 7 19 01 CGI INC Page 6 Land Management System Training Manual New 6 0 Menu Screen Microsoft Business Solutions Solomon File Edit Module Application Options Utility Customize Help 5 CGI ams Ja Favorites Modules PetroComp Menus Oil and Gas Master Files
114. lease check the Multi Name as well The rule is when there is no multi name we will default back to the FIRST NAME LAST NAME WITHOUT checking the name type CGI INC Page 12 Land Management System Training Manual Section 3 Copy and Paste Show examples Lease Maintenance LM 100 00 OEx Actions JjHAaAxK us Fe gt FIMO S LeaseNo f1 c4001 002 00 oa images Meu Soa I Citical Lease Alt Sequence Boria Sterea oo TN pee Grantor Lease No 7 1948 Lessor BI Biore State Lease Lease Term ni B Lessee H Mh Lanas ti tstst SO Exp Date 7 1958 Broker 7 A e 37 73Ct lt i S Acquired Region H aa a a A General Ifo Relted Paris Acquired From Bonus qooo o0 Acre 10 00 Acquired Code PURCHASED sits Rental 0 00 Acre 0 00 Owner Instr Type LEASEHOLD ts Shutln ooo Ace mE Lease Type FEE tt t Alt Lease No Lease SCI 0 JV Release Required Lease SC 2 Drop Date Code i C Copy Lease Ein cana Created Modified Approved 10 03 2001 SYSADMIN 2 08 2005 SYSADMIN 12 08 2005 SYSADMIN 001 SYSADMIN 03 27 2006 CGI INC Page 13 Land Management System Training Manual Section 3 Templates Screens and Reports Field List xvt_Im608p lcpnybonusamount xvt_Im608p lcpnyotheramount xvt_Im608p lcpnyrentalamount xvt_Im608p lcpnyshutinamount xvt_Im608p leasecompanyop xvi_Im608p leasedate xvr_Im6O8p leaseeffectivedate
115. lection Schedule Billing Exhibit A Economics Graphics Payment Selection Report Preliminary Invoice Report Lease Payment Projection Gas Plant Payment Inquiry Letter Adjust Billing Lease Summary Report Gas Balancing Payment Selertinn Rewiew ndate Print Tnvnices Draft Status Land Maintenance i l Invoice Processing Contracts Management ja x b e s W Partnership Management Minerals Management ord Fees pen Fixed Assets Management i nA Fixed Inventory igati ford al amily re Shared Information Multi Company Currency Manager Application Server Project Controller Allocator s y H Time and Expense for Projects i ics Employee Utilization Analyzer Su Communicator Flexible Billings Obligation Schedule Project Budgeting Billing Verification Report Contract Management Service Dispatch Service Contracts Equipment Maintenance This message may occur when printing checks It is telling you that there is overflow of notes or map description and the Print Remittance Advice step must be printed Process Status LM 404 00 Event Log iewer 95 290 01 LM40400 SYSADMIN 04 26 2006 System Message 6124 Process started Wed Apr 26 09 32 A M ERROR Invalid Expense Account Expense Account 1230020000 Payment Type SL Lease Tract 1 C4001 003 40 ERROR Invalid Expense Account Expense Account 1230010000 Payment Type RN Lease Tract 1 C4001 004 00 ERROR Inv
116. les User Manual and Section 1 3 of the LANDMAN System User Manual for additional information Note The Company Name ID above must be in the Land Tract Ownership table as this company is the company for which Company Net Acres will be computed Interest Classes must be defined These may already be established for accounting Share the basics WI RI OR You may need to add others Location User Codes These are used for selecting certain reports by well group Sequential Name and Address common with accounting CGI INC Page 3 Land Management System Training Manual Section 3 3 1 2 LANDMAN PARAMETER SETUP From the module menu select the LANDMAN Management option and select Land Setup to display the LANDMAN parameters Many of these will need to be reviewed with the accounting department Land Setup LM 950 00 iojx Actions led da Xl e o 2l Nl O F Cash Account 010001000 OPERATING A C BANK OF TEXAS upc Default Expense 1530040000 DELAY RENTAL Cost Setup Bank SC Account 1530880000 MISCELLANEOUS Billing orking Interest Working Ony Billing Int Class Working Int Class Check Format Last Check Number Invoice Format m Printing Options Interface To J Print Check Number v JIB Print Company J Print All Check Detail on Overflow Defaut Tract Somt 00 J Print Duplex on Detail Payment Process Cycle Flag eat ola Sees AA Save Prospects as Locations Checked Yes Lease Num
117. limited number may be entered for each tract Tract Map Reference LM 202 00 iol x Tract Legal Lease No Menu Map Ref Type JF Note Tract No Longitude OCS Region OCS Area OCS Area Name Primary Quadrangle 4 Fa DEVELOP SYSADMIN 7 19 01 SER Click on the drop down box to the right of Map Ref Type to review the options for the Map Reference types provide in the system Refer to Sections 2 1 11 through 2 1 11L in the LANDMAN System User Manual for detailed information lt F9 gt Opens the Note field next for the line in Focus CTRL S to save then Shift Tab Shift Tab puts focus on the OK button then Space Bar closes the note 4 14 SPECIAL OBLIGATIONS Any date dependent obligations of a Lease Tract may be maintained with this function An unlimited number of obligations per Lease Tract may be defined The lt F3 gt table lookup feature is available in Type field These obligations are entered when no specific payment to a lease owner is directly associated such as a Drilling Obligation install a cattle guard etc S Lease Tract Special Obligations LM 103 00 Eo _ um Ee mee RE mete oa Refer to Section 2 1 12 in the LANDMAN System User Manual for additional information lt F9 gt Opens the Note field next for the line in Focus CTRL S to save then Shift Tab places focus on the OK button then space bar closes the
118. marks Additional Counties Prospect Seg Cross References General Xref Maintenance General Cross Reference Maintenance Setup Land Setup Land Setup Report Listings Lease Data Sheet Prospect Data Sheet Location Data Sheet Chain OF Title Division of Interest Payment Obligation Report Exhibit A By Prospect Exhibit A By Location General Cross Reference Report Utilities Mass Lease Copy Mass Lease Transfer Land Leasehold Ownership Transfer Mass Chain of Title Copy Recalculate Net Acres Multiple Cross References Mass Contract Copy Import Export Purge Leases Import Export Purge DOIs Import Access File Inquiry Find Leases Payment History Inquiry Billing History Inquiry Reports Exhibit A Lease Payment Projection Lease Summary Report Draft Status Property Inquiry Producing Acre Lease Listing Map Reference Report Remarks Acreage Inventory Report Obligation Schedule Combined Special Obligation Prospect Special Obligation Lease Special Obligation Contract Special Obligation Location Special Obligation Lease Expiration Report Relinquished Lease Report Lease Cross Reference Partner Cross Reference B Lease Data Sheet Lm 602 00 Active Applications i Lease Maintenance LM 100 00 BD Tract Maintenance LM 200 00 CGI INC Page 1 Land Management System Training Manual Section 3 3 1 GETTING INTO LANDMAN The following steps should be performed to initiate op
119. nce ai Lease Date Lessor Lease NO Eff Date i Lessor o D SES Lease Term Ofvears x Lessee o D SES Exp Date oc a Broker B Acquired DE i Region i ipa Sea Lessor Royalty ORRI Lease NRI Company Burden Company ORRI Company NRI Refresh Created Modified Approved i i i DEVELOP SYSADMIN 12 03 2001 The Refresh button is clicked to reflect any changes made to the tract level information during the current session with this lease 4 4 DRAFT INFORMATION The Draft Data must be entered and then a report Draft Status may be printed to track the payment status of drafts in the system Lease Maintenance LM 100 00 Allan Business Resources Inc Allan Business Resources Inc os a 0 000000 12 08 2005 12 08 2005 ez E SYSADMIN a Refer to Section 2 1 5 of the LANDMAN System User Manual for additional information Currently the payment of a draft does not automatically update the Payment History for the lease This is planned for Year 2006 4 5 RELATED PARTIES INFORMATION Data must be entered Here to relate other parties to a lease for communication purposes CPA Attorney Banker etc Related parties must be defined in the Name and Address file Lease Maintenance LM 100 00 BE Allan Business Resources Inc Allan Business Resources Inc 12 08 2005 SYSADMIN 12 08 2005 SYSADMIN in i m SY
120. nd Management System Training Manual Section 2 2 2 PRE PRINTED FORMS CHECKS 8 1 2 x 11 used for payments AP or Land check format LEASE DATA SHEETS We currently print to letter or legal blank paper and not to a preprinted form E Lease Data Sheet IEG x4 ide gt a Bw elf bh Tota 100 1of1 RUN DATE 12 14 2005 TEST COMPANY 001 PAG E 4 TIME 7 16 31PM Land Management System REPORT LM60200 rpt USERID SYSADMIN Lease Data Sheet co ID 001 Lease California State Lease Lease No Created 12 14 2005 SYSADMIN Approved Modified 12 14 2005 SYSADMIN Approved By Identification Name California State Lease Alt Sequence California State Lea Region Lessor Lease No Lessor California State Lease Alt Lease No Lessee Allan Lands Critical Lease Broker 000001 Allan Business Resources Inc Release Required Owner Instru Ls LEASEHOLD Lease Type FE FEE Lease SC 1 Lease SC 2 Total Tracts 4 90 000000 0 000000 22 500000 5 850000 Multi County No 90 000000 0 000000 22 500000 5 850000 Muli Prospect No 90 000000 0 000000 22 500000 5 850000 Federal Acres 0 000000 0 000000 0 000000 0 000000 0 000000 Lessor Royalty Lease NRI Co Burden Co ORRI Co NRI 0 12500000 0 00000000 0 87500000 0 00000000 0 00000000 0 87500000 0 12500000 0 00000000 0 87500000 0 00000000 0 00000000 0 87500000 Dates amp Codes Lease Date 03 27 1948 Tem Acquired From Effective Date 03 27 1948 Acquire Date
121. neral Cross Reference Maintenance LM 500 00 SALE Producing Property Sale CGI INC Page 25 Land Management System Training Manual Section 5 sJ Multiple Cross References LM 108 00 General Xref 7 1003SALE1 TX960324 SALE Lease Tract x M tw 2904 001 tw 2904 003 Ce I awo MAYAT WATE ay Tx x GLADYS FOYT ROESLER CGI INC Page 26 Land Management System Training Manual Section 5 lolx General Select Gen X Reference Select Heading Report Options Through Landman Partner ID Partner Interest GenxRefType SALE Producing Property Sale GenXRefNo 1003SALE1 TX960324 SALE m Map Reference Field Jeffersonian gt Township y Jand Townshipdi and gt RangeNo fand gt Rangedir Jand Section OK Clear Selection 001 SYSADMIN 10 28 2003 MULTIPLE CROSS REFERENCES This module allows you to quickly cross reference a lease a specific tract of a lease a prospect a contract a location or make a general cross reference to a lease a specific tract of a lease a prospect a contract a location or make a general cross reference From the LANDMAN Main Menu select module then select Multiple Cross Reference This screen will appear CGI INC Page 27 Land Management System Training Manual Section 5 Multiple Cross References LM 108 00 From Cross Ref Type v
122. nerated checks from the land system Also similar check boxes are clicked when entering manual checks What are the timing considerations for billing joint interest owners and the payment of a rental check ANSWER Invoices cannot be generated until Land checks have been printed and Payment History is updated Although checks are normally written once a month they can be written more than once during a month Checks can also be printed for more than one month at a time CGI INC Page 12 Land Management System Training Manual Section I 21 Does LANDMAN create entries into General Ledger or does Joint Interest Billing ANSWER LANDMAN generates entries for Land checks into the JIB system and Joint Interest Billing generates entries when it does the billing The entries are automatic Setup of the Payment Obligation and location allocation screens is very important A cash manager transaction is also created where interfaced with accounting This may be useful if you are responsible for a Rentals bank cash account 22 Are receivables for billings of delay rentals kept in LANDMAN or PAYOUT s ACCOUNTS RECEIVABLE system ANSWER Located in Payout s Accounts Receivable Rental bonus or other land related checks written from the accounts payable system do not currently update the lease check payment history A manual check record must be entered in Land 23 Does LANDMAN print rental recommendation letters Can th
123. ocation ID 00165401 003932 Tex D Aon aonane Location Name LAPLATA G 32 20701 Bar Map Reference Location Type Well Cross References Location Status 02 Remarks Status Date 0471971994 Alternate seq LAPLATA G SERENE RESTS Short Description LAPLATA G 32 DOI Field ID DEVELOP SYSADMIN 11 23 2001 PAstart 4 l imo Jsi Land Solo S Land O Find EE EALES ESI AN 11 05 AM On the Search Criteria Tab click GRID VIEW to see the search results in Grid format 4 18 PAYMENT PROCESSING The Payment Processing section supports the payment of Delay Rentals Shut in Royalties and other payments IE Landman Menu LM 000 00 Payment Selection Payment Report Payment Inquiry Letter Payment Review Print Checks Remittance Advice Check Register Mailing Labels Check Update Manual Checks Void Checks Clear Checks Payment History Report molki File Maintenance Find Master Listings Reports Payment Processing Invoice Processing Utilities SADMIN 10 30 2001 Refer to Sections 5 0 through 5 13 in the LANDMAN System User Manual for detailed information Note See Procedure at the end of this section Preliminary check report lo x lo x TEST COMPANY 001 Z switchcomoaries BJ wooo aan Land Payment and Invoice Processing Ja Favorites Modules Production Accounting Payment Processing Reports Government Reporting Land Payment Se
124. on 1 4 Is there structure in the lease number ANSWER No This is not required but may be desired and is recommended We will try to accommodate a client s existing lease numbering scheme Some companies numbers include a state code as well as perhaps a prospect code For example Lease Number TX0100022 000 might indicate a lease in the Texas prospect 01 Hyphens can also be used Lease Maintenance LM 100 00 fel xi Actions Jo aAxW Fes 2z BlO amp 8 Lease No 1 C4001 002 00 ah SPARRAS Meu Lease Name California State Lease J Critical Lease Alt Sequence California State Lea eee 03 27 1948 Eff Date 03 27 1948 Grantor Lease No aan Leitor OI California State Lease Loasa Term 10 Years z Lessee anans oos Broker 000001 Allan Business Resources Inc Acquired a Region aeaa ais General Info Related Parties Acquired From Sn Pa Bonus 10000 00 Acre 10 00 Acquired Code ia PURCHASED tits Rental 0 00 Acre 0 00 Owner Instr Type ls LEASEHOLD ts Shut ln ooo Acre o oo Lease Type FE FEE i tt AltLeaseNo LeaseSC1 ff JV Release Required Lease SC 2 Drop Date Code rw Copy Lease i are Created Modified Approved 10 03 2001 SYSADMIN 12 08 2005 SYSADMIN 12 08 2005 SYSADMIN 001 SYSADMIN 12 14 2005 The 00 in the above screen is used to identify companion leases MI not 1 00 You may have a 0L 02 etc
125. ovided Lease Tract Payment Obligations LM 109 00 Edit Template Submit Navigation Favorites Jd I Xe A D rw BD we Se Location Allocation Lease No 4 c4901 003 00 new ai Tract Allocation Obligation Summary i Tract Pymt Type RN First Pymt 0 01 2004 Last Pymt 01 01 2009 PaymentAmt 500 00 Frequency 12 Months z Total Check Amt 0 00 Addr a Ck Seq Payable ID Addr ID Payable Name Decimalint Check Amount Override sc Total 0 00000000 Rem 1 00000000 mi 2 Adar Yr Seq Credit To ID Addr ID Credit To Name Decimal Int Pymnt Amt Bank Acct LA Voucher Total 0 00000000 Rem 7 00000000 Fo Manual Checks Tot Pymnt Amt 0 00 Created Modify Approval tard oe 001 SYSADMIN 09703 2004 CGI INC Page 9 Land Management System Training Manual Section I 12 If a payment is to be made for only part of a lease is a separate lease record required ANSWER No You will define a separate tract and code a tract level payment obligation Lease Tract Cross References LM 107 00 Eifel xi Edit Template Submit Navigation Favorites jad Xe D D E gla Lease No 1 ca001 003 00 O Lease Name Menu Prospect Location C Contract C General Xref a St Lease Tract 1st Key rid Element ike Contract Element ltem Name Element Type
126. p Gaunty Currency Manager DOI List or Outlook Contacts Coversion Log Application Server Division Of Interest Listing Project Controller Misc DOI Exception Allocator Audit Manager Ownership Detail Time and Expense For Projects Audit Log Viewer ORG Division Order Employee Utilization Amended O amp G Division Order Analyzer Allocation Group Listing Communicator Suspense Code Flexible Billings Property Code Project Budgeting Asset List Contract Management Name amp Address Audit Service Dispatch Active Applications Service Contracts Equipment Maintenance Flat Rate Pricing PeR ae sn noo san Mo SEOSTRODOB sem n Level 91 26 Standard C Supplemental Product Cc AllUsers C One Group C One User Self T Exclude Event Code 001 SYSADMIN 01 05 2006 CGI INC Page 4 Land Management System Training Manual Section 5 Click the level you want to customize then open the screen you wish to customize Nation state and county on the tract screen Tract Maintenance LM 200 00 ida o oo000000 fv Ej 0 000000 0 000000 0 000 0 000000 0 000000 0 000000 0 000000 0 000000 Click customize on the top menu CGI INC Page 5 Land Management System Training Manual Section 5 Tract Maintenance LM 200 00 0 00000000 0 000000 0 000 0 000000 0 000000 0 000000 0 000000 0 000000 This is what the tract screen will look like when you ar
127. pt Fax No Title Home Phone No Email Pager No Modem No Modified Approved SYSADMIN f ee SYSADMIN 05 02 2006 4 6 TRACT INFORMATION This screen is used to define the status interests and acreage data for each tract within a lease A maximum of 1000 tracts per lease may be defined if you use numeric tracts Tract number will default to 000 if you press return but you may enter any number you wish It is then possible to define multiple tracts as required to represent different ownership farmin farmouts partially producing situations depths etc A discussion of multiple lease tracts can be found at the end of this section Ownership is kept at the tract level Therefore at least one tract for each lease must be defined for processing Note the Ownership Button below the Menu button in the top right hand corner of the Menu screen below o Moved Tract Maintenance LM 200 00 _ joyx Actions Pho axi Fesrz SlOu Menu Lease No ZNEW ol Tract No Ownership Lease Name znew Status Date rw Depths Prospect Seg t a ae Upper 0 Lower 0 Nat St County foo 42 101 COTTLE TX Bk Pa Entry 1 Date Copy Rec Info Bk Pg Enty2 Date 7 Fed Ac 0 000000 Cost and UDC DOI Sub ooo Int Type w Our Share o 50000000 IV CountAc Addi Cty Lsr Min Int 1 00000000 Bonus Amt Rental Amt 0 00 AFE De
128. pth Limit Operator 000001 Allan Business Resources Map Desc Remark Actes Gross Overlap Net Company Net Tract 100 000000 ooooooo 100 000000 50 000000 HBP 4oo00000 o ooo000 4o ooo000 20 000000 Developed sooooooo oooooo0 60 000000 30 000000 Undeveloped 4o oo0000 ooooooo f 40 000000 20 000000 Befresh Dur Share Calc Net Co Net DropDWCd incon Created Modified Approved 12 08 2005 SYSADMIN 12 08 2005 SYSADMIN ae 001 SYSADMIN 12 14 2005 Status Date Segment DOI Sub Int Type Lsr Min INt 46 1 TRACT INFORMATION BURDENS There is additional information at the tract level on the Burdens tab Please refer to Section 2 1 6A of the LANDMAN System User Manual for additional information K Tract Maintenance LM 200 00 X Menu Lease No ol TractNo 000 ae Lease Name Status Date rv Depths 0 0 Upper ieee E mE Lower al un Bk Pg Entry Date Fed Ac 0 000000 General Information Cost and UDC Lessor Royalty ORRI Lease NRI Company Burden Company ORRI Company NRI Qil 0 00000000 0 00000000 1 00000000 0 00000000 0 00000000 1 00000000 Gas 0 00000000 0 00000000 1 00000000 0 00000000 0 00000000 1 00000000 Refresh Burdens Created Modified Approved i i i DEVELOP SYSADMIN _ 12 03 2001 4 6 2 TRACT INFORMATION COSTS There is additional information at the tract level on the Cost tab Plea
129. rrect all errors and update as necessary Errors will be found in the Event log 2 Run Payment Selection for the month you wish to pay Enter dates Enter Selection Options and Enter who pays option Run Summary or Recommendation Report Display this report s Use VCR buttons to go forward back when going through fields on each screen 3 Payment Review This screen organizes this report for further review and selection It also allows you to note your recommendations for payment for your inquiry letter partners 4 Payment Recommendation Report Do any amount of updating you deem necessary to the individual leases dropping leases updating status etc until you feel they are ready for processing this can be run many times if necessary Run one last time to see that all those you want to pay are included may just want to Display to compare May schedule a lease group prospect etc at a time does not have to be done for an entire month but will usually be done by all payments due within a given month for rental or shut ins S5 Payment Review Update Process enter several times to pull up everything in the payment control This will show you if anything remains from last month Do not change flag or drop those without discussing w supervisor or Analyst who was responsible for those payments please help keep this cleaned out it should only have very recent payments on hold Select delete to delete a payment from th
130. s DEVELOP SYSADMIN 12 07 2001 Leases Prospects d Prospect Maintenance Producing Properties gt Ownership Contracts gt Map Reference General Cross Ref gt Special Obligations Name and Address Remarks Code Descriptions Additional Counties Nation State County Cross References Land Setup Please refer to Sections 2 2 through 2 2 7 of the LANDMAN System User Manual for detailed instructions 4 23 CONTRACTS The Contracts section maintains all contract information and allows you to cross reference agreements to leases prospects producing properties or other contracts This section can be accessed by making the following selections S Landman Menu LM 000 00 E l0 x File Maintenance Find Master Listings Reports Payment Processing Invoice Processing Utilities DEVELOP l SYSADMIN 12 07 2001 Leases Prospects Producing Properties Contracts General Cross Ref Name and Address Code Descriptions Nation State County Land Setup vR Y Y Contract Maintenance Parties Locator Information Payment Obligations Special Obligations Remarks Cross References Amendments Contract Setup Please refer to Sections 2 4 through 2 4 8 of the LANDMAN System User Manual for detailed instructions 4 24 GENERAL CROSS REFERENCE The General Cross Reference allows you the option to establish cross references for data items not covered by other portions of the system You
131. s East Texas West Texas Panhandle of Texas DESCRIPTION OS Federal OS LA OS TX Eastern Central So Central Mountain Reg Foreign Reg Gulf Coast South Texas Mid Continen Rocky Mtns East Texas West Texas TX Panhandle SHORT DESC TYPE CODE 49 10 CHAR Alpha amp Numeric 40 CHARACTERS 12 CHARACTERS This code will be not be populated This will vary by company and should be set up by the User CGI INC Page 10 Land Management System Training Manual Section 3 CONTRACT CLAUSE PROVISION CODES TYPE CODE DESCRIPTION SHORT DESC 51 10 CHAR 40 CHARACTERS 12 CHARACTERS Alpha amp Numeric This code will be not be populated This will vary by company and should be set up by the User ADDITIONAL SURVEY CODES TYPE CODE DESCRIPTION SHORT DESC 54 10 CHAR 40 CHARACTERS 12 CHARACTERS Alpha amp Numeric This code will be not be populated This will vary by company and should be set up by the User RECORD STATUS CODES LAND CODES TYPE CODE DESCRIPTION SHORT DESC 61 01 ACTIVE ACTIVE 61 A ACTIVE ACTIVE 61 gg INACTIVE INACTIVE 61 I INACTIVE INACTIVE 61 50 PENDING PENDING 61 P PENDING PENDING CGI INC Page 11 Land Management System Training Manual Section 3 STATUS TRACT ACREAGE CODES DESCRIPTION SHORT DESC TYPE CODE 62 A001 62 A002 62 A003 62 A004 62 CO 62 DH 62 DR 62 HBO 62 HBP 62 HBU 62 1001 62 1002 62 1003 62 PA 62 PB 62 PR 62 R001 62 R002 62 RF 62
132. s will vary by company and should be set up by the User CGI INC Page 16 Land Management System Training Manual Section 3 CGI INC Page 17 4 0 LEASE DATA MAINTENANCE Lease Data Maintenance is used to enter or modify the data stored in the system for each lease Lease Data consists of several screens controlled by the Lease Data Maintenance Menu Each section of the lease to be modified may be selected on the lease maintenance screen lolx g Landman Menu E Invoice Processing Utilities File Maintenance Find L z Master Listings Reports Payment Processing access Wai te ELOP SYSADMIN 12 03 2001 Prospects Lease Legal Description Producing Properties gt Tract Maintenance Contracts gt Leasehold Ownership General Cross Ref gt Leasehold Ownership Transfer Name and Address Map Reference Code Descriptions Payment Obligations Nation State County Special Obligations Land Setup Gemak Chain of Tite Additional Counties Cross Reference Payment History Biling History or selected by using the MENU option on the lease S Lease Maintenance LM 100 00 lolx Lease No ol a Images Menu Lease Name I Critical Lease Alt Sequence ee ss Payment Obligations Lessor Lease No Ownership Information Lessor Ss ee Legal Text eee Remarks Sar a R Chain of Title Map Reference Region Special Obligations Cross Reference Payment History Bill History
133. se refer to Section 2 1 6B of the LANDMAN System User Manual for additional information K Tract Maintenance LM 200 00 4 6 3 MULTIPLE TRACTS ON A LEASE The following conditions or a combination of them may demand separate tracts for a particular lease Every lease must have at least one tract usually Tract 000 for a full interest lease If multiple tracts are required the first of those tracts would be numbered 001 the second 002 the third 003 etc There may be a Mineral ownership Acreage status Horizontal severance Leasehold ownership Prospect County tract 004 without a tract 003 if a partial interest lease only has an interest under tract 004 Example Lease B 320 Acres Min Int 0 75 Lease C 160 Acres Min Int 0 25 Lease A 320 acres Min Int 1 00 Lease C 160 Acres Min Int 0 25 Lease A Lease B Lease C Lease D Lease ID TX001 001 00 TX001 002 00 TX001 002 01 TX001 002 02 Tract 000 000 000 000 For example As shown in the chart below the base lease TX0001 01 covers an interest in all four tracts and would have all four tracts set up on the lease Lease TX0001 02 would be set up with a Tract 002 and 004 Lease TX0001 03 would be set up with only Tract 003 Lease TX0001 04 would be set up with a Tract 002 and 003 and Lease TX0001 05 would be set up with only Tract 004 Multiple tracts are not required when the mineral interest is uniform
134. see Name ase Date fective Date rms piration Date quired Date Drop Date Instrument Type Lease Type Lessor Mineral Interest Lessor Royalty Oil Lessor Royalty Gas Total Bonus Amount Rental Amount Rental Per Acre Tract Status Date Tract Prospect Prospect Name Depths Upper Limit Depths Lower Limit 0 Tract Gross Acres Tract Net Acres Book Page Entry Recording Date FIRST AMERICAN BANK 1071171997 1071171997 1071172003 1071171997 TAE i LEASEHOLD FEE LEASE 1 000000000 0 187500000 0 187500000 0 00 0 00 Tract Status NP fo 901 LEESVILLE 0 57 000000 57 000000 Mstart A SS BJ S Docu Solomo S Lanama S7 Landma O Find Le DEVELOP SYSADMIN 11 21 2001 BE OS 5 DE ALOSDD 3 17 PM Click the Lease Maintenance selection to go the normal lease maintenance screens and processes 4 16 CONTRACT FIND The contract Find works very similarly to the Lease Find Enter the desired search criteria and click GO Please refer to the Lease Find for additional detail Find Contracts CT 920 00 ioix Actions sO k aA Xxl Fe te Z FlO amp BS Search Criteria Contract No Name CONTRACT g By Contract Party1 ID C By Owner Party2 ID Contract Type Contract Status Clear Find Prospect No Grid View Book Page Entry Nation State County Owner ID Name Interest Type Special Obligation Typ
135. side parties or partners who may have a say in a delay rental payment Do not need to run if all payments are paid by us See Land DOI owner check boxes 7 Print Payment Summary to ensure the payments you want to make are included This will show a simple list easy to review in overview and the Cost Centers the payments will be booked 8 Rerun Payment Summary if you changed anything in Payment R U 9 ____ Preliminary Check Report Click Print Preview to review all unless you are specifically printing only a particular type payment when processing shut ins for example and the month you want Scan for problems it will flash you when there are errors but if only one or two you may want to note from the Display rather than going through the full print process Otherwise print and utilize the printed report for your file so you may take notes when you go through to correct the problems for future reference Check all payment associated fields for errors Upon obtaining a clean report print a final copy for the notebook If there are errors correct then re schedule payment and go through Steps 1 through 8 as required If a payment needs to be deleted click delete in the Payment Review Update step on that lease 10 Get number of checks as reflected a the bottom of Check List be sure to initial check log and show number of checks taken must include voided checks on the log for tracking purposes If checks are printed directly from t
136. stem Training Manual Section 5 Exhibit A LM 901 10 a E a m m m a Net and Grass Tract Leve Daai Lease Name Z m m CGI INC Page 3 Land Management System Training Manual Section 5 5 1 Defaults with Customization Often it is very convenient to set user or company defaults Customize on top menu Click customize mode Note Select Level is Self Fak Documentt Microsoft Word lal x Microsoft Business Solutions Solomon _ oyx z file Edit Module Application Options Utility Customize G Customize Mode cai ams Ja A Oi a Select Level Self Level User ID SYSADMIN Modules Government Reporting Maintena Ke KITRIE Setup Economics Graphics Oil amp Gas M Export Customizations il Company Setup Gas Plant Find Locati Import Customizations i it Customization Setup Gas Balancing Name amp Ad Petrocomp Registration Land Maintenance Code Desc Land Payment and Invoice Proces Nation Stat e amp Address Mailing Labels Contracts Management Location M Mailing Labels Partnership Management Division of tion Master Minerals Management Allocation ion Data Sheet Fees Backup Wit ion Summary Report Sai se hahaa Proces ation Special Obligation ede Description Listing Location Remarks DOI Ownership Transfer GTM Division of Interest Export Shared Information Multi Company Microsoft Outlook Contacts Conversion Nation State am
137. t Access File Land Leasehold Ownership Transfer Lease Transfer Mass Lease Transfer Land Leasehold Ownership Transfer Recalculate Net Acres Multiple Cross References Mass Chain of Title Copy Land Payment Selection Payment Selection Pevieuil Indake Section 3 Switch Companies Inquiries Find Leases Payment History Inquiry Report General Cross Reference Report Acreage Inventory Report Lease Listing Lease Data Sheet Lease Summary Report Exhibit A Exhibit A By Location Lease Inventory Lease Cost Report Map Reference Report Division of Interest Remarks Chain OF Title Draft Status Producing Property Summary Property Inquiry Producing Acre Lease Expiration Report Relinquished Lease Report Lease Cross Reference Partner Cross Reference lolx Active Applications CGI INC Page 7 Land Management System Training Manual Section 3 3 3 FILE MAINTEANCE The File Maintenance Menu supports the processing of all maintenance functions These functions are required to add change and delete data used by the system It also allows the reporting or inquiry of the master files used in the system as well as miscellaneous special functions PEuandmian Menu M 000 00 o x File Maintenance Find Master Listings Reports Payment Processing Invoice Processing Utilities DEVELOP YTOWNSEND 04 26 2002 Leases b Prospects Producing Properties gt Contracts b G
138. t hand corner This information must be filled out to interface with accounting for Land Payments Refer to Sections 2 1 8 through 2 1 8A 4 in the LANDMAN System User Manual for additional information 48 1 PAYMENT OBLIGATION PAYEE INFORMATION This screen is used to maintain any payees which may be due delay rentals shut in royalties or other payments under a lease Each payment which results in a unique check is defined by indicating the payment type due date the depository service charge total amount payees and payees amounts An unlimited number of checks may be defined per lease with an unlimited number of payees per check o ease Tract Payment Obligations LM 109 00 oj x Location Allocation Lease No HAYNIE2 PETE AND REPETE oj Tract Allocation Menu Obligation Summary D l Tract Pymt Type OP Payment Amt Frequency 24 Total Check Amt Addr a Ck Seq PeyableID AddriD Payable Name Decimal Int Check Amount Check 1 1 10234 00 CHEVRON US A INC 0 06818182 19627 2 Total 210241 00 FRANK KELL CAHOON 0 20454546 58881 82 En 3 10244 00 JAMES A CRUTCHMER JR 0 06818182 19627 2 EA 410245 o0 MARGARET ANNE EATON 0 06818182 19627 26 gt Voucher Info for Check Seq 1 Payable to CHEVRON US AINC vrSeq CreditToID AddriD Credit To Name Decimal int Pymnt Amt Voucher 110234 00 CHEVRON U 5 A INC 1 00000000 19627 Total wa
139. table by entering data Forms Reports Y Pages I Macros amp Modules Groups Favorites Ready NUM El Microsoft Access la x Type a question for help File Edit View Insert Tools Window Help ise alSay smealo f s amp db1 Database Access 2000 file format Gjopen BZ pesin New X So EE Create query in Design view Create query by using wizard NUM Ready Simple Query Wizard Which Fields do you want in your query You can choose From more than one table or query Tables Queries Table dbo_XCMMNAME X Available Fields Selected Fields AltSequence Ea BT eana E aai E A e asl Cancel Back Next gt Finish ewe ce Fa E Microsoft Access x Eile Edit View Insert Format Records Tools Window Help Type a question for help amp M BaA S6RAY Smeal Ol Sl NH Y Wy dil w Bo a QO Create query in Design view Create query by using wizard ag dbo_XCMMNAME Query Select Query NameiD LastName FirstName _ SuspenseCode VERN JONES AND ASSOCIATES AVEN GAS amp OIL INC BINGHAM PETROLEUM ENGINEERIN BLACK DIAMOND GENERAL OIL COMPANY INC BRYAN WOODBINE GATHERING INC CENTURY OIL COMPANY WHEELER ENERGY COMPANY WHITE AND ELLIS DRILLING INC CD RESOURCES CO DREILING OIL INC BRUNDARDT HOWER WARD ALEXANDER GRANT AND COMPANY Record M AI 1 gt rrpal C SQL Back door fixer very powerful
140. tate CGI INC Page 65 Land Management System Training Manual Section 5 COASTAL WATERS amp COASTLINE Any waters from the coastline to three miles out COMMUNITY LEASE Covers at least two tracts owned by different owners covered by one lease COMPENSATORY ROYALTY Payment in lieu of production royalty in lieu of drilling a well CONVEYANCE Transfer of rights to drill Most common method to transfer private title of presently operative instrument intended by the grantor to pass ownership of some interest in land to the transferee COVENANT Stipulations restrictions on the lease DAMAGES A rider pinpointing anything the lessor wishes to be compensated for if damaged ex cotton corn crops DELAY RENTALS Permits the lease to remain in effect absent any drilling operation for a certain amount of time usually the primary term of the lease DIVISION OF INTEREST Part of lease which describes interest percentages of each working interest owner DIVISION ORDER A contract of sale to the purchaser of oil or gas The order directs the purchaser to make payment for the value of the products taken in the proportions set out in the division order CGI INC Page 66 Land Management System Training Manual Section 5 DRY HOLE CLAUSE A lease clause specifying the means by which a lessee may keep a lease alive after the drilling of a dry hole 8 8THS Total production from a well or simply all production expenses etc
141. tenance CGI INC Page 23 Land Management System Training Manual Section 3 3 0 The following pages offer suggestions for the various Land system codes that may be used STATUS LISTING TYPE CODE DESCRIPTION SHORT DESC PYMT DUE 03 A ACTIVE ACTIVE Y 03 AI ACTIVE WATER INJECTION WELL ACTIVE WIW Me 03 CO COMMINGLED COMMINGLED Y 03 DH DRY HOLE DRY HOLE Y 03 DR DRILLING DRILLING kd 03 FE FULLY EXECUTED FULLY EXECUT h 03 G GAS INJECTION WELL GAS INJECTOR x 03 GS SHUT IN GAS INJECTION WELL SI GI Y 03 GT TEMP ABANDONED GAS INJECTOR TA D GI x 03 I INACTIVE INACTIVE Ye 03 I INACTIVE WATER INJECTION WELL INACTIVE INJ X 03 Is SHUT IN WATER INJECTION WELL SI WATER INJ Y 03 IL TEMP ABANDONED WATER INJECTOR TA WTR INJ x 03 NP NON PRODUCING NON PRODUCIN M5 03 PA PLUGGED amp ABANDONED PLUGGED amp AB x 03 PB PLUG BACK PLUG BACK Y 03 PR PRODUCING PRODUCING Y 03 PT PLANT PLANT Me 03 RC RECOMPLETED TO ANOTHER ZONE RECOM ZONE b 03 RE RECOMPLETED RECOMPLETED Y 03 SD SOLD SOLD 03 SE SEALED SEALED Ys 03 SI SHUT IN SHUT IN k 03 SS SHUT IN SALTWATER DISPOSAL WELL SI SWD Y 03 ST TEMP ABANDONED SALTWATER DISPOSAL TA D SWD 03 SW ACTIVE SALTWATER DISPOSAL WELL ACTIVE SWD Ye 03 TA TEMPORARY ABANDONED TEMPORARY AB X 03 TR TRANSFERRED TRANSFERRED Y 03 UN UNITIZED UNITIZED x 03 WI SHUT IN WATER SOURCE WELL SHUTIN WSW BG 03 WS WATER SOURCE WELL WATER SOURCE x 03 WT TEMP ABANDONED WATER SOURCE WELL TAD WSW Y
142. the print button from the lease entry screen Lease Data Sheets can also be printed for a range of lease numbers or for all leases in a prospect or by other selection criteria using the Powerful Report Option Interpreter ROI from Report Menu 33 Even though checks for this year s rentals have not been generated by LANDMAN can I enter check history and invoice history for this year in order to do 1099 s ANSWER Yes Use Manual Check entry and Billing History Maintenance Other years data may be entered for a more complete Payment Billing History Report We can help with converting this data 34 How can I keep track of minimum royalty payments and the potential for having to pay a makeup check at the end of the year CGI INC Page 16 Land Management System Training Manual Section 1 35 36 37 38 ANSWER With PAYOUT in Revenue run a Payment History Report by Well by owner and compare to LANDMAN s Payment Obligation selecting Minimum Royalty type obligation How many Payees can be printed on a check How do we set up a Name and Address record for et ux ANSWER LANDMAN allows for chaining name and address ID s such that the number of payees is virtually unlimited Additional payees are printed to the overflow Space on the actual check only allows for about 6 lines For Et Ux In the Name and Address record enter the first name on the lease as Individual and the second name of
143. throughout a lease unless it is a artial interest under a base lease that has various tracts In that event it is best to set it up in tracts to co ordinate with the base lease TRACT 001 TRACT 002 ANNT ner ACS sv eo mamen a 1am anmo osoon mano osm om osmon se Ma sa EES OO aw 0 250000 ro 0000 SS S o o e a 1 000000 40 0000 1 000000 100 0000 004 100 ac 4 6 4 ACREAGE ON MULTIPLE TRACTS If the gross acres for a tract have already been entered for a previous lease or tract i e acreage has been accounted for on a companion lease enter in the field titled Overlap Acres the previously entered gross acres or portions which overlaps for succeeding leases or tracts For example tector mow maw maw GROSS OVERLAP NET GROSS OVERLAP NET GROSS OVERLAP NET GROSS OVERLAP NET ACRES ACRES ACRES ACRES ARES ACRES AOB AES AS ACRES ABS ACRES 40 0000 NI 160 0000 san 40 0000 100 0000 33 334 pC wow wo ooo 10000000 1000 3 383 O l a NN EE tes ee TOTALS 40 0000 0 0000 a 160 0000 0 0000 oa 40 0000 0 0000 a n 0 0000 100 0000 Entering the acreage as shown above prevents the gross lease acres pertaining to identical legal descriptions from being added more than once on reports such as the acreage inventory report If tract acreage is exactly the same as for a preceding tract as it could be in the case of severed horizons for example
144. two programs IMMEDIATELY MAKE A BACKUP OF ALL NEW PROGRAMS DATA Backing up data is a little different than backing up system software which you usually only backup once you first get it Your data is always changing and with a large system like LANDMAN the decision of what and when to backup is more complicated than with system software There are times you MUST backup and times you SHOULD backup TIMES YOU MUST BACKUP 1 Before loading any new program updates backup your data Also be sure to make a backup of the new program updates 2 At the end of a processing period i e when you close a month 3 When you get your financials or reports to look like you want them too 4 When prompted by LAND to backup before particular processing steps OTHER TIMES TO BACKUP These are times when you have done work on the computer entered or processed data you do not wish to loose and which do not fall into the categories listed above You can help yourself decide when these other times are by asking yourself a couple of questions 1 Can I recover my data if it is lost If you do not have the original data so that you could re input it you should immediately do a backup Or maybe some processing step is a point of no return that irreversibly changes your data in some way If so backup before processing the step in case something goes wrong during processing CGI INC Page 5 Land Management System Training Manual Sect
145. y you enter leases and make a backup This backup is called Son because it is the most recent gt On Wednesday you enter more leases contracts and make another backup This backup is now Son and Monday s backup is called Father gt On Friday you enter more leases properties and make another backup This new backup is now called Son Wednesday s is called Father and Monday s is called Grandfather gt It s a busy week so you work Saturday and enter more leases This time when you make your backup you can use the diskettes from Monday the grandfather diskettes This technique will help minimize any data loss that may occur due to system or media failure FULL SYSTEM BACKUPS Besides the permanent and incremental backups described above you should also do a full system backup at least once a week You might need to do it more often It depends on the level of activity on the system A full system is simply a backup of all your data even if it has not all changed You should employ the grandfather father son technique with your full system backups just as with your incrementals Do not mix the diskettes or tapes used to make full system backups with the diskettes used to make incremental backups MAKE SURE ALL BACKUPS ARE CLEARLY LABELED AS TO THEIR CONTENTS AND DATE MADE WHERE TO STORE YOUR BACKUPS All backups should be stored away from your computer They should be at least in another room or on another floor in a saf

Solomon Land/Training Manual

Contents

Download Pdf Manuals

Related Search

Related Contents