MTA - Mineral Titles Person Organization MVW

577 views (5 recent)

Published by the Ministry of Energy, Mines and Petroleum Resources - Mineral Titles
Licensed under Access Only

Holds information about Mineral Titles clients (including client number, name, and contact information).

Data and Resources

Dataset Extent

Latitude: 48.0° to 60.0°
Longitude: -139.5° to -113.5°

Additional Information

More Information

Contact Information

NameKaren Samuelson (pointOfContact)
EmailMineral.Titles@gov.bc.ca
OrganizationMinistry of Energy, Mines and Petroleum Resources
Sub-OrganizationMineral Titles
NameDataBC Operations (pointOfContact)
Emaildata@gov.bc.ca
OrganizationMinistry of Jobs, Trade and Technology
Sub-OrganizationDataBC

Access & Security

Who can view this dataset? Public
Who can download this dataset?Public

Metadata Information

Record Published 2012-01-16
Record Last Modified 2019-08-01
Resource Status completed

Object Description

Object Name: WHSE_MINERAL_TENURE.MTA_PERSON_ORGANIZATION_MVW

Short Name: MTA_PR_ORG

Column Name Short Name Data Type Data Precision Comments
PERSON_ORGANIZATION_ID PRS_ORG_ID NUMBER 10 This is a system Generated Primary Key for a Person Organization
ORGANIZATION_ID ORG_ID NUMBER 16 System generated unique key for organization
PERSON_ID PERSON_ID NUMBER 10 System generated unique key for person.
CLIENT_NUMBER_ID CLN_NUM_ID NUMBER 6 Unique client identifier
MTA_FMC_CLIENT_TYPE_CODE MTA_CLI_TY VARCHAR2 1 The Free Miner Certificate (FMC) client type code. Examples of possible types are : C=Company, D=Deceased, E=Estate, G=Government, I=Individual.
PUBLIC_EMAIL_ADDRESS PBL_EMAIL VARCHAR2 50 Email address of the person, organization or person of the organization
PUBLIC_FAX_NUMBER PBL_FAX VARCHAR2 20 Public fax number of the organization. Includes area code.
PUBLIC_PHONE_NUMBER PBL_PHNE VARCHAR2 20 Public phone number of the organization. Includes area code.
MTA_OFFICER_CODE MTA_OFF_CD VARCHAR2 4000 The code of this officer. Examples of possible codes are : LSAM_P=Lynn Sam, KSTONE_P=Kim Stone, CSEWARD_P=Carol A. Seward, PHAGEN_P=Paul Hagen, SCARRIGG_P=Shaun Margaret Carrigg.
PERSON_ORGANIZATION_TYPE PRS_ORG_TY VARCHAR2 4000 Shows organization Type. Can be : ORGANIZATION, CLIENT or OFFICER
NAME NAME VARCHAR2 150 Organization Name or Person Name
BUSINESS_REGISTRATION_NUMBER BSNSSRGSTR VARCHAR2 20
EXPIRY_DATE EXP_DATE DATE 7
ACTIVE_STATUS ACT_STATUS VARCHAR2 1 MTA_FMC_CLIENT_TYPE_CODE Status : A = Active, I = Inactive