Transcript PPDM Lite 1.0

PPDM Association
PPDM Lite
Relational Model
Version 1.1
2007
Note: Use this document for making printed copies of the
diagrams, as it will provide better resolution than the pdf file.
PPDM Lite 1.0 Data Diagrams Legend
Index
Table in
PPDM 3.6
or earlier
New
Table
New
Reference
Table
Note that not all elements are present on all diagrams
PPDM Lite 1.0
Copyright, 2004, PPDM Association. All Rights Reserved
24
Data Diagram Index
Index
Applications and Areas
Business Associates
Contracts
Entitlements
Facilities
Fields and Pools
Financial
Interest Sets
Land
Licenses
Meta Model
Production
Projects
Project components
Records Management
Reserves
Seismic Sets
Spatial Components
Spatial Descriptions
Support Facilities
Wells
PPDM Lite 1.0
Copyright, 2004, PPDM Association. All Rights Reserved
25
Index
Applications and Areas
L_APPLICATION
APPLICATION_ID
APPLICATION_TYPE
DATA_SOURCE
DECISION
PPDM_GUID
RECEIVED_DATE
L_AREA_ALIAS
REMARK
RESUBMISSION_IND
SUBMITTED_DATE
AREA_ID
AREA_TYPE
AREA_ALIAS_ID
ALIAS_OWNER_BA_ID
ALIAS_TYPE
L_AREA
AREA_FULL_NAME
LAA_LA_F K
AREA_ID
AREA_TYPE
DATA_SOURCE
DATA_SOURCE
PPDM_GUID
PREFERRED_IND
REMARK
PPDM_GUID
PREFERRED_NAME
REMARK
PPDM Lite 1.0
Copyright, 2004, PPDM Association. All Rights Reserved
26
Index
Business Associates
L_BUSINESS_ASSOCIATE
BUSINESS_ASSOCIATE
BA_CATEGORY
BA_CODE
BA_NAME
BA_TYPE
L_BA_ADDRESS
CURRENT_STATUS
DATA_SOURCE
EFFECTIVE_DATE
BUSINESS_ASSOCIATE
FIRST_NAME
SOURCE
LAST_NAME
MIDDLE_INITIAL
ADDRESS_OBS_NO
LBAA_LBA_FK
PPDM_GUID
REMARK
ADDRESS_TYPE
CITY_ID
COUNTRY
LBAAL_LBA_FK
DATA_SOURCE
EMAIL_ADDRESS
FAX_NUM
FIRST_ADDRESS_LINE
PHONE_NUM
L_BA_ALIAS
POSTAL_ZIP_CODE
PPDM_GUID
BUSINESS_ASSOCIATE
PROVINCE_STATE
SOURCE
REMARK
BA_ALIAS_ID
SECOND_ADDRESS_LINE
ALIAS_NAME
THIRD_ADDRESS_LINE
ALIAS_TYPE
WEB_URL
DATA_SOURCE
PPDM_GUID
PREFERRED_IND
REMARK
PPDM Lite 1.0
Copyright, 2004, PPDM Association. All Rights Reserved
27
Index
Contracts
L_CONTRACT_COMPONENT
L_CONTRACT
CONTRACT_ID
COMPONENT_ID
LCCOM_LC_FK
APPLICATION_ID
CONTRACT_ID
AREA_ID
CONFIDENTIAL_IND
AREA_TYPE
CONTRACT_NAME
BUSINESS_ASSOCIATE
L_CONT_EXTENSION
CONTRACT_NUM
DATA_SOURCE
CONTRACT_TYPE
FACILITY_ID
CURRENT_OPERATOR
CURRENT_STATUS
CURRENT_STATUS_DATE
FACILITY_TYPE
EXTENSION_ID
FIELD_ID
INFORMATION_ITEM_ID
DATA_SOURCE
DATA_SOURCE
DEV_PENALTY_PERCENT
CONTRACT_ID
LCEX_LC_FK
EQUIP_PENALTY_PERCENT
EXTENSION_TYPE
INFO_ITEM_TYPE
ISSUED_BY
JURISDICTION
LAND_RIGHT_ID
ISSUED_DATE
EXPIRY_DATE
LAND_RIGHT_TYPE
LAND_RIGHT_ID
EXPL_PENALTY_PERCENT
LAND_SALE_NUMBER
LAND_RIGHT_TYPE
MKTG_FEE_ELECT_PERCENT
OPERATING_PROCEDURE_TYPE
PPDM_GUID
PPDM_GUID
LAND_SALE_OFFERING_ID
REMARK
PDEN_ID
PDEN_SOURCE
PDEN_TYPE
ROFR_IND
PPDM_GUID
TERMINATION_DATE
REASON_TYPE
LCEX_LBA_FK
REMARK
REMARK
SEIS_SET_ID
SEIS_SET_TYPE
L_BUSINESS_ASSOCIATE
SUPPORT_FACILITY_ID
LCAL_LC_FK
LCCOM_LBA_FK
BUSINESS_ASSOCIATE
SUPPORT_FACILITY_TYPE
UWI
BA_CATEGORY
BA_CODE
L_CONT_ALIAS
BA_NAME
BA_TYPE
CURRENT_STATUS
CONTRACT_ID
ALIAS_ID
PPDM Lite 1.0
LCAL_LBA_FK
DATA_SOURCE
ALIAS_NAME
EFFECTIVE_DATE
ALIAS_OWNER
FIRST_NAME
ALIAS_TYPE
LAST_NAME
DATA_SOURCE
MIDDLE_INITIAL
PPDM_GUID
PPDM_GUID
REMARK
REMARK
Copyright, 2004, PPDM Association. All Rights Reserved
28
Index
Entitlements
L_ENT_COMPONENT
L_ENTITLEMENT
ENTITLEMENT_ID
COMPONENT_ID
ENTITLEMENT_ID
AREA_ID
DATA_SOURCE
AREA_TYPE
ENTITLEMENT_TYPE
LENT C_LENT_FK
BUSINESS_ASSOCIATE
EXPIRY_ACTION
CONTRACT_ID
EXPIRY_DATE
DATA_SOURCE
PPDM_GUID
DESCRIPTION
PRIMARY_TERM
ENT_COMP_TYPE
PRIMARY_TERM_OUOM
ENT_RULE
REMARK
FACILITY_ID
FACILITY_TYPE
LENTG_LENT_FK
FIELD_ID
L_ENT_GROUP
INFORMATION_ITEM_ID
INFO_ITEM_TYPE
INTEREST_SET_ID
LAND_RIGHT_ID
LAND_RIGHT_TYPE
PDEN_ID
ENTITLEMENT_ID
SECURITY_GROUP_ID
ACCESS_TYPE
DATA_SOURCE
EFFECTIVE_DATE
PPDM_GUID
RESTRICTION_DESC
PPDM Lite 1.0
PDEN_SOURCE
PDEN_TYPE
PPDM_GUID
RESENT_ID
SEIS_SET_ID
SEIS_SET_TYPE
UWI
Copyright, 2004, PPDM Association. All Rights Reserved
29
Index
Facilities
L_FACILITY_SUBSTANCE
L_BUSINESS_ASSOCIATE
BUSINESS_ASSOCIATE
FACILITY_ID
BA_CATEGORY
FACILITY_TYPE
BA_CODE
SUBSTANCE_ID
BA_NAME
AVERAGE_CAPACITY
CAPACITY_UOM
BA_TYPE
L_FACILITY
CURRENT_STATUS
DATA_SOURCE
MAX_CAPACITY
DATA_SOURCE
LFSU_LF_FK
EFFECTIVE_DATE
FACILITY_ID
FIRST_NAME
REMARK
FACILITY_TYPE
LAST_NAME
LF_LBA_F K
MIDDLE_INITIAL
PPDM_GUID
CURRENT_OPERATOR
DATA_SOURCE
PPDM_GUID
FACILITY_FUNCTION
REMARK
FACILITY_NAME
LFA_LBA_F K
FACILITY_STATUS
FACILITY_STATUS_TYPE
L_FACILITY_XREF
H2S_IND
L_FACILITY_ALIAS
LAST_PRODUCTION_DATE
FACILITY_ID
LFA_LF_F K
FACILITY_TYPE
ON_PRODUCTION_DATE
FACILITY_ID
PPDM_GUID
FACILITY_TYPE
REMARK
FACILITY_ID_2
LFX_LF_FK
FACILITY_ALIAS_ID
LFX_LF_FK2
SOURCE
ALIAS_OWNER_BA_ID
ALIAS_TYPE
FACILITY_TYPE_2
XREF_OBS_NO
DATA_SOURCE
FACILITY_XREF_TYPE
PPDM_GUID
DATA_SOURCE
REMARK
FACILITY_ALIAS
PPDM_GUID
PREFERRED_IND
REMARK
PPDM Lite 1.0
Copyright, 2004, PPDM Association. All Rights Reserved
30
Index
Fields and Pools
LFL
D_LFL
D_FK
L_FIELD
L_FIELD_ALIAS
FIELD_ID
COUNTRY
FIELD_ID
LFL
DA_LF
LD_F
K
FIELD_ALIAS_ID
DATA_SOURCE
SOURCE
DISCOVERY_DATE
ALIAS_OWNER_BA_ID
FIELD_NAME
ALIAS_TYPE
FIELD_TYPE
DATA_SOURCE
GROUP_FIELD_ID
FIELD_ALIAS
PPDM_GUID
PPDM_GUID
PROVINCE_STATE
PREFERRED_IND
REMARK
REMARK
L_POOL_ALIAS
LPOL_LF
LD_F
K
L_POOL
POOL_ID
POOL_ID
BUSINESS_ASSOCIATE
SOURCE
COUNTRY
POOL_ALIAS_ID
DATA_SOURCE
LPOLA_L
PO L
_FK
ALIAS_OWNER_BA_ID
FIELD_ID
ALIAS_TYPE
POOL_NAME
DATA_SOURCE
POOL_STATUS
POOL_ALIAS
POOL_TYPE
PPDM_GUID
PPDM_GUID
PREFERRED_IND
PROVINCE_STATE
REMARK
REMARK
STRAT_NAME_SET_ID
STRAT_UNIT_ID
PPDM Lite 1.0
Copyright, 2004, PPDM Association. All Rights Reserved
31
Index
Financial
L_FIN_COMPONENT
L_FINANCE
FINANCE_ID
FINANCE_ID
FINANCE_COMPONENT_ID
ACTUAL_COST
APPLICATION_ID
AUTHORIZED_BY_BA_ID
BUDGET_COST
LFINC_LFIN_FK
AREA_ID
AREA_TYPE
DATA_SOURCE
BUSINESS_ASSOCIATE
FINANCE_TYPE
DATA_SOURCE
FIN_STATUS
FACILITY_ID
ISSUE_DATE
FACILITY_TYPE
LIMIT_AMOUNT
FIELD_ID
COST_AMOUNT
PPDM_GUID
INFORMATION_ITEM_ID
COST_TYPE
REFERENCE_NUMBER
INFO_ITEM_TYPE
DATA_SOURCE
REMARK
INTEREST_SET_ID
FINANCE_COMPONENT_ID
TAX_CREDIT_CODE
LAND_RIGHT_ID
L_FIN_COST_SUMMARY
COST_ID
LFINCS_LFIN_FK
LAND_SALE_JURISDICTION
PARENT_COST_ID
LAND_SALE_NUMBER
PPDM_GUID
LAND_SALE_OFFERING_ID
REMARK
SUBMIT_DATE
L_FIN_XREF
LFINX_LFIN_FK
LAND_RIGHT_TYPE
PAID_DATE
LFINX_LFIN_FK2
FINANCE_ID
LICENSE_ID
LICENSE_TABLE
POOL_ID
PPDM_GUID
REMARK
FINANCE_ID1
L FINC S_ LFINCS _FK
FINANCE_ID2
DATA_SOURCE
DISTRIBUTION_PERCENT
FIN_XREF_TYPE
PPDM_GUID
REMARK
PPDM Lite 1.0
Copyright, 2004, PPDM Association. All Rights Reserved
RESENT_ID
RESERVE_CLASS_ID
SEIS_SET_ID
SEIS_SET_TYPE
SUPPORT_FACILITY_ID
SUPPORT_FACILITY_TYPE
UWI
32
Interest Sets (Partnerships)
Index
L_INTEREST_SET
L_INT_SET_COMPONENT
INTEREST_SET_ID
DATA_SOURCE
INTEREST_SET_ID
EFFECTIVE_DATE
BUSINESS_ASSOCIATE
INTEREST_SET_TYPE
COMPONENT_TYPE
PPDM_GUID
LISC_LIS_FK
CONTRACT_ID
DATA_SOURCE
REMARK
FACILITY_ID
FACILITY_TYPE
LISP_LIS_FK
INFORMATION_ITEM_ID
INFO_ITEM_TYPE
JURISDICTION
L_INT_SET_PARTNER
LAND_OFFERING_BID
LAND_RIGHT_ID
LAND_RIGHT_TYPE
INTEREST_SET_ID
LAND_SALE_NUMBER
PARTNER_BA_ID
PDEN_ID
DATA_SOURCE
PDEN_SOURCE
GROSS_FRACT_INTEREST
PDEN_TYPE
GROSS_PERCENT_INTEREST
PPDM_GUID
INTEREST_SET_ROLE
REMARK
NET_FRACT_INTEREST
RESENT_ID
NET_PERCENT_INTEREST
RESERVE_CLASS_ID
PPDM_GUID
SEIS_SET_ID
REMARK
SEIS_SET_TYPE
LISP_LBA_FK
SF_TYPE
SUPPORT_FACILITY_ID
LISC_LBA_FK
UWI
L_BUSINESS_ASSOCIATE
BUSINESS_ASSOCIATE
PPDM Lite 1.0
Copyright, 2004, PPDM Association. All Rights Reserved
33
Index
Land
L_LAND_ALIAS
L_LAND_RIGHT
LAND_RIGHT_ID
LAND_RIGHT_ID
LAND_RIGHT_TYPE
LAND_RIGHT_TYPE
LR_ALIAS_ID
COST_CENTER_NUM
ALIAS_NAME
COUNTRY
ALIAS_OWNER_BA_ID
DATA_SOURCE
ALIAS_TYPE
DATA_SOURCE
EXPIRY_DATE
LLRA_LLR_FK
GRANTED_RIGHT_TYPE
LAND_REF_NUM_TYPE
JURISDICTION
PPDM_GUID
LAND_ACQTN_METHOD
REASON_TYPE
LAND_PROPERTY_TYPE
REMARK
LAND_RIGHT_CATEGORY
LAND_SALE_NUMBER
LAND_SALE_OFFERING_ID
LESSOR_NUM
L_LAND_SALE
LESSOR_TYPE
OCCUPANT_NAME
PPDM_GUID
JURISDICTION
PRIMARY_TERM
LAND_SALE_NUMBER
PRIMARY_TERM_OUOM
CLOSE_DATE
PROVINCE_STATE
DATA_SOURCE
REMARK
LAND_SALE_NAME
ROFR_IND
OPEN_DATE
PPDM_GUID
REMARK
JURISDICTION
LAND_SALE_NUMBER
LAND_SALE_OFFERING_ID
LLR_LLSO_FK
LLRX_LLR_FK
L_LAND_SALE_OFFERING
LLRX_LLR_FK2
LLSO_LLS_FK
SALE_DATE
L_LAND_XREF
AREA_ID
AREA_TYPE
LR_XREF_SEQ_NO
CANCEL_REASON
CHILD_LAND_RIGHT_TYPE
DATA_SOURCE
CHILD_LAND_RIGHT_ID
LAND_OFFERING_STATUS
PARENT_LAND_RIGHT_TYPE
LAND_OFFERING_TYPE
PARENT_LAND_RIGHT_ID
PPDM_GUID
DATA_SOURCE
REMARK
LAND_XREF_TYPE
STATUS_DATE
PERCENT_ALLOCATION
PPDM_GUID
REMARK
PPDM Lite 1.0
Copyright, 2004, PPDM Association. All Rights Reserved
34
Index
Licenses
L_LICENSE
L_FIN_COMPONENT
LFINC_LL_FK
LICENSE_ID
LICENSE_TABLE
FINANCE_ID
DATA_SOURCE
FINANCE_COMPONENT_ID
EFFECTIVE_DATE
EXPIRY_DATE
FACILITY_ID
FACILITY_TYPE
GRANTED_BY_BA_ID
GRANTED_DATE
GRANTED_TO_BA_ID
L_PROJECT_COMPONENT
LICENSE_BA_ID
LPROJCOM_LL_FK
LICENSE_NUM
LICENSE_STATUS
PROJECT_ID
LICENSE_TERM
LICENSE_TYPE
PPDM_GUID
REMARK
SECONDARY_TERM
L_SP_COMPONENT
SEIS_SET_ID
SEIS_SET_TYPE
LSC_LL_FK
SPATIAL_DESCRIPTION_ID
UWI
WELL_LICENSE_SOURCE
SPATIAL_OBS_NO
L_RM_INFO_ITEM_CONTENT
LRMIIC_LL_FK
INFORMATION_ITEM_ID
INFO_ITEM_TYPE
CONTENT_OBS_NO
PPDM Lite 1.0
Copyright, 2004, PPDM Association. All Rights Reserved
35
Index
Meta Model (Data Management)
L_PPDM_ORIGIN
L_PPDM_DATA_SOURCE
L_PPDM_EXCEPTION
SOURCE_TABLE_NAME
SOURCE_PPDM_GUID
DATA_SOURCE
TARGET_TABLE_NAME
TARGET_PPDM_GUID
DATABASE_NAME LPE_LPDS_FK
LPO_LPDS_FK
EFFECTIVE_DATE
DATA_SOURCE
PPDM_GUID
BUSINESS_RULE
ERROR_MESSAGE
EXCEPTION_COLUMN_NAME
USER_NAME
REMARK
DATA_SOURCE
ERROR_NO
REMARK
PPDM_GUID
EXCEPTION_ID
EXCEPTION_DATE
SOURCE_COLUMN_NAME
EXCEPTION_TABLE_NAME
TARGET_COLUMN_NAME
EXCEPTION_TYPE
PPDM_GUID
REMARK
TABLE_NAME
DATA_SOURCE
PPDM_GUID
PRIMARY_KEY_NAME
REMARK
LPC_LPDS_FK
LPO_LPT_FK
LPO_LPT_FK2
LPT_LPDS_FK
L_PPDM_TABLE
PLSQL_NAME
LPC_LPT_FK
TABLE_COMMENT
L_PPDM_COLUMN
LPO_LPC_FK
LPO_LPC_FK2
TABLE_NAME
COLUMN_NAME
COLUMN_COMMENT
COLUMN_SEQUENCE
DATA_SOURCE
DATA_TYPE
PPDM_GUID
PRIMARY_KEY_SEQUENCE
REMARK
PPDM Lite 1.0
Copyright, 2004, PPDM Association. All Rights Reserved
36
Index
Production
L_PDEN_VOL_SUMMARY
L_PDEN
L_BUSINESS_ASSOCIATE
LPD
EN_LB
A_FK
PDEN_ID
PDEN_ID
PDEN_TYPE
PDEN_TYPE
SOURCE
PDEN_SOURCE
AREA_ID
VOLUME_METHOD
AREA_TYPE
ACTIVITY_TYPE
COUNTRY
VOLUME_DATE
CURRENT_OPERATOR
BOE_CUM_VOLUME
CURRENT_STATUS_DATE
BOE_VOLUME_OUOM
STRAT_NAME_SET_ID
DATA_SOURCE
CO2_CUM_VOLUME
STRAT_UNIT_ID
FACILITY_ID
CO2_VOLUME_OUOM
AVERAGE_AGE
FACILITY_TYPE
DATA_SOURCE
BUSINESS_ASSOCIATE
FIELD_ID
GAS_CUM_VOLUME
DATA_SOURCE
GEOLOGIC_PROVINCE
GAS_VOLUME_OUOM
EFFECTIVE_DATE
LAST_INJECTION_DATE
INJECTION_CUM_VOLUME
FAULT_TYPE
LAST_PRODUCTION_DATE
INJECTION_VOLUME_OUOM
FORM_CODE
LAST_REPORTED_DATE
NGL_CUM_VOLUME
LONG_NAME
ON_INJECTION_DATE
NGL_VOLUME_OUOM
MAX_AGE
ON_PRODUCTION_DATE
BUSINESS_ASSOCIATE
LSU
_LBA_
FK
L_STRAT_UNIT
NITROGEN_CUM_VOLUME
LPD
ENVS_
LPDE
N_FK
MIN_AGE
OTHER_NAME
NITROGEN_VOLUME_OUOM
ORDINAL_AGE_CODE
PDEN_NAME
OIL_CUM_VOLUME
PPDM_GUID
POOL_ID
OIL_VOLUME_OUOM
REMARK
PPDM_GUID
PERIOD_ON_INJECTION
PR_STR_FORM_OBS_NO
PERIOD_ON_INJECTION_OUOM
PRIMARY_PRODUCT
PERIOD_ON_PRODUCTION
PRODUCTION_METHOD
PERIOD_ON_PRODUCTION_OUOM
PROVINCE_STATE
PPDM_GUID
REMARK
PRIMARY_PRODUCT
RESENT_ID
PROJECT_ID
RESERVE_CLASS_ID
REMARK
PDEN_TYPE
STRING_ID
SULPHUR_CUM_VOLUME
PDEN_SOURCE
STRING_SOURCE
SULPHUR_VOLUME_OUOM
STRAT_NAME_SET_ID
UWI
WATER_CUM_VOLUME
LPS
U_LSU
_FK
L_PDEN_STRAT_UNIT
PDEN_ID
LPS
U_LPD
EN_F
K
WATER_VOLUME_OUOM
STRAT_UNIT_ID
PDEN_SU_OBS_NO
DATA_SOURCE
PPDM_GUID
REMARK
LPD
ENX_L
PDEN
_FK
LPD
ENX_L
PDEN
_FK2
L_PDEN_XREF
FROM_PDEN_ID
FROM_PDEN_TYPE
TO_PDEN_ID
TO_PDEN_TYPE
PDEN_SOURCE
XREF_OBS_NO
DATA_SOURCE
PDEN_XREF_TYPE
PPDM_GUID
PPDM Lite 1.0
Copyright, 2004, PPDM Association. All Rights Reserved
37
Index
Projects
L_PROJECT_COMPONENT
L_PROJECT_ALIAS
PROJECT_ID
PROJECT_ID
ALIAS_ID
AREA_ID
ALIAS_NAME
AREA_TYPE
ALIAS_TYPE
BA_ID
DATA_SOURCE
COMPONENT_TYPE
OWNER_BA_ID
CONTRACT_ID
PPDM_GUID
DATA_SOURCE
PREFERRED_IND
FACILITY_ID
REMARK
FACILITY_TYPE
FIELD_ID
LPROJA_LPROJ_FK
JURISDICTION
LAND_RIGHT_ID
LAND_RIGHT_TYPE
LAND_SALE_NUMBER
L_PROJECT
L_RESENT_COMPONENT
LICENSE_ID
LICENSE_TABLE
LRS
CO M_LPR
O J_F
K
PDEN_ID
PROJECT_ID
PDEN_SOURCE
COMPLETE_DATE
RESENT_ID
DATA_SOURCE
LPROJCOM_LPROJ_FK
PPDM_GUID
PROJECT_NAME
PROJECT_TYPE
L_PDEN_VOL_SUMMARY
REMARK
START_DATE
PDEN_ID
LPD
ENVS_
LPROJ_FK
STATUS
PDEN_TYPE
POOL_ID
PPDM_GUID
RESENT_ID
RESERVE_CLASS_ID
SEIS_SET_ID
SEIS_SET_TYPE
STRAT_NAME_SET_ID
PDEN_TYPE
SUPPORT_FACILITY_ID
PDEN_SOURCE
SUPPORT_FACILITY_TYPE
VOLUME_METHOD
UWI
ACTIVITY_TYPE
L_SF_COMPONENT
LSF
CO M_LPR
O J_F
K
SUPPORT_FACILITY_ID
SF_TYPE
PPDM Lite 1.0
Copyright, 2004, PPDM Association. All Rights Reserved
38
Index
Project Components
L_AREA
L_PROJECT_COMPONENT
AREA_ID
LPROJCOM_LA_FK
AREA_TYPE
L_CONTRACT
PROJECT_ID
CONTRACT_ID
AREA_ID
AREA_TYPE
BA_ID
L_STRAT_NAME_SET
LPROJCOM_LC_FK
L_LAND_RIGHT
COMPONENT_TYPE
LPROJCOM_LSNS_FK
STRAT_NAME_SET_ID
CONTRACT_ID
DATA_SOURCE
LAND_RIGHT_ID
LPROJCOM_LLR_FK
LAND_RIGHT_TYPE
FACILITY_ID
FACILITY_TYPE
FIELD_ID
L_LICENSE
L_LAND_SALE
JURISDICTION
LAND_RIGHT_ID
LICENSE_ID
LAND_RIGHT_TYPE
LICENSE_TABLE
LAND_SALE_NUMBER
LPROJCOM_LLS_FK
JURISDICTION
LICENSE_ID
LICENSE_TABLE
L_FACILITY
PDEN_ID
L_POOL
LPROJCOM_LPOL_FK
PDEN_SOURCE
PDEN_TYPE
LPROJCOM_LF _FK
FACILITY_ID
POOL_ID
POOL_ID
FACILITY_TYPE
PPDM_GUID
RESENT_ID
L_RESENT_CLASS
SEIS_SET_ID
LPOL_LFLD_FK
L_SF_SUPPORT_FACILITY
RESERVE_CLASS_ID
LPROJCOM_LRSCL_FK
RESENT_ID
LPROJCOM_LSF_FK
SEIS_SET_TYPE
SUPPORT_FACILITY_ID
STRAT_NAME_SET_ID
SF_TYPE
SUPPORT_FACILITY_ID
SUPPORT_FACILITY_TYPE
UWI
L_FIELD
LPROJCOM_LW_FK
LPROJCOM_LF LD_FK
FIELD_ID
PPDM Lite 1.0
L_WELL
UWI
Copyright, 2004, PPDM Association. All Rights Reserved
39
Records Management
L_RM_INFORMATION_ITEM
L_RM_INFO_ITEM_CONTENT
INFORMATION_ITEM_ID
INFORMATION_ITEM_ID
INFO_ITEM_TYPE
INFO_ITEM_TYPE
CATALOGUE_DATE
CONTENT_OBS_NO
CATALOGUE_NAME
APPLICATION_ID
DATA_SOURCE
BUSINESS_ASSOCIATE
INFORMATION_QUALITY
CONTRACT_ID
ITEM_CATEGORY
DATA_SOURCE
ITEM_SUB_CATEGORY
FACILITY_ID
MEDIA_TYPE
FACILITY_TYPE
ORIGIN_DATE
PHYSICAL_ITEM_ID
PHYSICAL_ITEM_STATUS
PPDM_GUID
REFERENCE_NUM
REMARK
RETENTION_PERIOD
STORE_ID
TITLE
Index
FIELD_ID
LRMIIC_LRMII_FK
JURISDICTION
LAND_RIGHT_ID
LAND_RIGHT_TYPE
LAND_SALE_NUMBER
LAND_SALE_OFFERING_ID
LICENSE_ID
LICENSE_TABLE
PDEN_ID
PDEN_SOURCE
PDEN_TYPE
POOL_ID
PPDM_GUID
LRMIID_LRMII_FK
REMARK
L_RM_INFO_ITEM_DESC
RESENT_ID
RESERVE_CLASS_ID
SEIS_SET_ID
SEIS_SET_TYPE
STRAT_NAME_SET_ID
STRAT_UNIT_ID
SUPPORT_FACILITY_ID
INFORMATION_ITEM_ID
INFO_ITEM_TYPE
SUPPORT_FACILITY_TYPE
UWI
DESCRIPTION_ID
DATA_SOURCE
DESCRIPTION
DESCRIPTION_DATE
DESCRIPTION_TYPE
DESC_VALUE
DESC_VALUE_UOM
PPDM_GUID
REMARK
PPDM Lite 1.0
Copyright, 2004, PPDM Association. All Rights Reserved
40
Index
Reserves
L_RESERVE_ENTITY
L_RESENT_COMPONENT
LRSCOM_LRE_FK
RESENT_ID
CREATED_BY_BA_ID
RESENT_ID
COMPONENT_ID
DATA_SOURCE
AREA_ID
LRSCL_LRE_FK
GROUP_TYPE
AREA_TYPE
PPDM_GUID
BUSINESS_ASSOCIATE
PRIMARY_PRODUCT_TYPE
CONTRACT_ID
REMARK
DATA_SOURCE
UPDATE_SCHEDULE
FACILITY_ID
FACILITY_TYPE
FIELD_ID
LAND_RIGHT_ID
L_RESENT_CLASS
LAND_RIGHT_TYPE
PDEN_ID
LRX_LRE_FK2
LRX_LRE_FK
PDEN_SOURCE
RESENT_ID
RESERVE_CLASS_ID
CONFIDENCE_FACTOR
PERCENT_CONTRIBUTION
POOL_ID
DATA_SOURCE
PPDM_GUID
EFFECTIVE_DATE
PRODUCT_TYPE
PPDM_GUID
L_RESENT_XREF
PDEN_TYPE
REMARK
PROJECT_ID
REMARK
STRAT_NAME_SET_ID
STRAT_UNIT_ID
RESENT_ID
UWI
RESENT_ID2
XREF_OBS_NO
DATA_SOURCE
PPDM_GUID
REMARK
XREF_TYPE
PPDM Lite 1.0
Copyright, 2004, PPDM Association. All Rights Reserved
41
Index
Seismic Sets
L_SEIS_SET
L_SEIS_ALIAS
L_SEIS_POINT
SEIS_SET_ID
SEIS_SET_ID
SEIS_SET_TYPE
SEIS_SET_TYPE
ACQTN_SURVEY_NAME
COMPLETED_DATE
SEIS_SET_ID
SEIS_ALIAS_ID
LSSAL_LSS_FK
SEIS_SET_TYPE
ALIAS_OWNER
COORD_ACQUISITION_ID
DATA_SOURCE
COUNTRY
PPDM_GUID
CURRENT_SEIS_STATUS
PREFERRED_IND
STATUS_TYPE
REMARK
DATA_SOURCE
SEIS_SET_ALIAS
SEIS_POINT_ID
DATA_SOURCE
DATUM_ELEV
DATUM_ELEV_OUOM
ELEV
FINANCE_ID
ELEV_OUOM
FIRST_SEIS_POINT_ID
END_BEND_IND
FIRST_SEIS_SET_ID
MEASURED_DEPTH
FIRST_SEIS_SET_TYPE
MEASURED_DEPTH_OUOM
PPDM_GUID
JURISDICTION
LAST_SEIS_POINT_ID
REFERENCE_DATUM
LSSPT_LSS_FK
LAST_SEIS_SET_ID
REMARK
LAST_SEIS_SET_TYPE
SEIS_POINT_LABEL
SEIS_POINT_LAT
LINE_LENGTH
LINE_LENGTH_OUOM
L_SEIS_RECORD
LSSR_LSSPT_FK
SEIS_POINT_LONG
SEIS_POINT_NO
LINE_NAME
PPDM_GUID
SEIS_SET_ID
PROVINCE_STATE
SEIS_SET_TYPE
REFRACTION_REFLECTION
RECORD_ID
RESHOOT_OF_SET_ID
DATA_SOURCE
RESHOOT_OF_SEIS_SET_TYPELSSR_LSS_FK
FIELD_FILE_NUMBER
SEIS_3D_TYPE
INFORMATION_ITEM_ID
SEIS_DIMENSION
INFO_ITEM_TYPE
SEIS_SPECTRUM_TYPE
PATCH_USED_IND
SEIS_STATION_TYPE
PPDM_GUID
SHOT_FOR
RECORDING_REMARKS
START_DATE
RECORD_NUMBER
TEST_EXPERIMENTAL
RECORD_QUALITY
SEIS_STATION_TYPE
SPATIAL_SEQ_NO
RECORD_TYPE
REMARK
SEIS_SHOT_POINT_ID
PPDM Lite 1.0
Copyright, 2004, PPDM Association. All Rights Reserved
42
Index
Spatial Components
L_SP_COMPONENT
L_WELL
L_APPLICATION
LSC_LW_FK
LSC_LAPP_FK
APPLICATION_ID
SPATIAL_DESCRIPTION_ID
UWI
SPATIAL_OBS_NO
COMPONENT_ID
APPLICATION_ID
AREA_TYPE
LSC_LPOL_FK
DATA_SOURCE
AREA_ID
LSC_LA_FK
POOL_ID
FACILITY_ID
FACILITY_TYPE
FIELD_ID
L_FACILITY
L_FIELD
INTEREST_SET_ID
JURISDICTION
LAND_RIGHT_ID
FACILITY_ID
LSC_LF_FK
LW_LFLD_FK
L_POOL
AREA_ID
LPOL_LFLD_FK
L_AREA
LSC_LFLD_FK
FIELD_ID
LAND_RIGHT_TYPE
LAND_SALE_NUMBER
LAND_SALE_OFFERING_ID
LICENSE_ID
L_INTEREST_SET
L_SEIS_SET
LICENSE_TABLE
LSC_LIS_FK
INTEREST_SET_ID
PDEN_ID
LSC_LSS_FK
PDEN_SOURCE
SEIS_SET_ID
PDEN_TYPE
SEIS_SET_TYPE
POOL_ID
PPDM_GUID
L_LICENSE
L_LAND_SALE_OFFERING
REMARK
RESENT_ID
SEIS_SET_ID
LICENSE_ID
LSC_LLSO_FK
JURISDICTION
SEIS_SET_TYPE
LICENSE_TABLE
LAND_SALE_NUMBER
SUPPORT_FACILITY_ID
DATA_SOURCE
LAND_SALE_OFFERING_ID
LLR_LLSO_F K
SUPPORT_FACILITY_TYPE
UWI
LSC_LSF_FK
L_SF_SUPPORT_FACILITY
L_LAND_RIGHT
LSC_LLR_FK
SUPPORT_FACILITY_ID
PPDM Lite 1.0
Copyright, 2004, PPDM Association. All Rights Reserved
LAND_RIGHT_ID
43
Index
Spatial Descriptions
L_SP_POINT
POINT_ID
L_CS_COORDINATE_SYSTEM
DATA_SOURCE
L_SPATIAL_DESCRIPTION
LATITUDE
LONGITUDE
COORD_SYSTEM_ID
COORDINATE_SYSTEM_TYPE
COORD_SYSTEM_NAME
SPATIAL_OBS_NO
COORD_SYSTEM_FROM_UOM
COORD_SYSTEM_ID
COORD_SYSTEM_TO_UOM
DATA_SOURCE
DATA_SOURCE
LINE_IND
REMARK
SPATIAL_DESCRIPTION_ID
LSP2_LSD_FK
L_SP_LINE_POINT
SPATIAL_OBS_NO
LINE_ID
MAX_LATITUDE
ELLIPSOID_ID
POINT_SEQ_NO
MAX_LONGITUDE
ELLIPSOID_INVERSE_FLATTENING
BEND_IND
MIN_LATITUDE
ELLIPSOID_NAME
DATA_SOURCE
MIN_LONGITUDE
ELLIPSOID_SEMI_MAJOR_AXIS
L_SP_LINE
DEPTH
POINT_IND
FACTOR_DENOMINATOR
ELEVATION
POLYGON_IND
FACTOR_NUMERATOR
GEODETIC_DATUM
GEODETIC_DATUM_NAME
GREENWICH_LONGITUDE
PPDM_GUID
SPATIAL_DESCRIPTION_ID
LSD_LCS_FK
FIRST_POINT_IND
PPDM_GUID
LINE_ID
REMARK
DATA_SOURCE
SPATIAL_DESC_TEXT_IND
PPDM_GUID
SPATIAL_DESC_TYPE
LAST_POINT_IND
LATITUDE
LSLP_LSL_FK
LONGITUDE
REMARK
PPDM_GUID
PRIME_MERIDIAN_ID
SPATIAL_DESCRIPTION_ID
REMARK
PRIME_MERIDIAN_NAME
SPATIAL_OBS_NO
REMARK
LSP_LSP_FK
PPDM_GUID
LSL_LSD_FK
L_SP_POLYGON
L_SP_BOUNDARY
L_SP_COMPONENT
LSP_LSD_FK
SPATIAL_OBS_NO
POLYGON_ID
POLYGON_ID
BOUNDARY_DIRECTION
SPATIAL_DESCRIPTION_ID
POINT_SEQ_NO
CONTAINED_BY_POLYGON_ID
LSC_LSD_FK
COMPONENT_ID
DATA_SOURCE
APPLICATION_ID
EXCLUSION_IND
AREA_ID
POLYGON_SET_ID
DATA_SOURCE
LATITUDE
LONGITUDE
LSB_LSP_FK
PPDM_GUID
AREA_TYPE
DATA_SOURCE
PPDM_GUID
REMARK
REMARK
SPATIAL_DESCRIPTION_ID
FACILITY_ID
SPATIAL_OBS_NO
FACILITY_TYPE
FIELD_ID
INTEREST_SET_ID
JURISDICTION
LAND_RIGHT_ID
LAND_RIGHT_TYPE
L_SP_ZONE_SUBSTANCE
LSMZ_LSD_FK
LAND_SALE_NUMBER
L_SP_MINERAL_ZONE
LICENSE_ID
LSG_LSD_FK
LAND_SALE_OFFERING_ID
SPATIAL_DESCRIPTION_ID
LSZS_LSMZ_FK
SPATIAL_DESCRIPTION_ID
SPATIAL_OBS_NO
SPATIAL_OBS_NO
MINERAL_ZONE_ID
MINERAL_ZONE_ID
SUBSTANCE
PDEN_TYPE
DATA_SOURCE
BASE_MD
POOL_ID
DEEP_RIGHT_REVERSION_IND
BASE_STRAT_UNIT_ID
LICENSE_TABLE
PDEN_ID
PDEN_SOURCE
L_SP_GEOMETRY
PPDM_GUID
SPATIAL_OBS_NO
PPDM_GUID
DATA_SOURCE
REMARK
SPATIAL_DESCRIPTION_ID
REMARK
EXCLUDED_IND
RESENT_ID
GEOMETRY_FORMAT
ZONE_DEFINITION_ID
INCLUDED_IND
SEIS_SET_ID
GEOMETRY_ID
PPDM_GUID
SEIS_SET_TYPE
GEOMETRY_OBS_NO
REMARK
SUPPORT_FACILITY_ID
DATA_SOURCE
STRAT_NAME_SET_ID
SUPPORT_FACILITY_TYPE
GEOMETRY_DATE
TOP_MD
UWI
GEOMETRY_SOURCE
TOP_STRAT_UNIT_ID
GEOMETRY_TYPE
OBJECT_SOURCE
PPDM_GUID
REMARK
PPDM Lite 1.0
Copyright, 2004, PPDM Association. All Rights Reserved
44
Index
Support Facilities
L_SF_SUPPORT_FACILITY
L_SF_DESCRIPTION
LSFDE_LSF_F K
L_SF_COMPONENT
SUPPORT_FACILITY_ID
SUPPORT_FACILITY_ID
SF_TYPE
SF_TYPE
SF_TYPE
DESCRIPTION_OBS_NO
DATA_SOURCE
USE_ID
DATA_SOURCE
FACILITY_STATUS
AREA_ID
DESCRIPTION
PPDM_GUID
AREA_TYPE
DESC_TYPE
REMARK
BUSINESS_ASSOCIATE
DESC_VALUE
STATUS_TYPE
CONTRACT_ID
SUPPORT_FACILITY_ID
DESC_VALUE_CODE
DATA_SOURCE
DESC_VALUE_UOM
FACILITY_ID
PPDM_GUID
LSFCOM_LSF_FK
FACILITY_TYPE
FIELD_ID
FINANCE_ID
INFORMATION_ITEM_ID
INFO_ITEM_TYPE
L_SF_ALIAS
INTEREST_SET_ID
LSFAL_LSF_FK
LAND_RIGHT_ID
LAND_RIGHT_TYPE
LAND_SALE_NUMBER
ALIAS_ID
ALIAS
ALIAS_TYPE
DATA_SOURCE
OWNER_BA_ID
LSFX_LSF_FK
LAND_SALE_JURISDICTION
SF_TYPE
LSFX_LSF_FK2
SUPPORT_FACILITY_ID
L_SF_XREF
PDEN_ID
PDEN_SOURCE
PDEN_TYPE
POOL_ID
PPDM_GUID
PPDM_GUID
PREFERRED_IND
SUPPORT_FACILITY_ID
REMARK
SF_TYPE
SUPPORT_FACILITY_ID2
SF_TYPE2
DATA_SOURCE
PROJECT_ID
REMARK
SEIS_SET_ID
SEIS_SET_TYPE
UWI
PPDM_GUID
REMARK
XREF_TYPE
PPDM Lite 1.0
Copyright, 2004, PPDM Association. All Rights Reserved
45
Index
Wells
L_BUSINESS_ASSOCIATE
BUSINESS_ASSOCIAT E
BA_ CATEGORY
BA_ CODE
BA_ NAME
BA_ TYPE
L_WELL
CURRENT_ ST ATUS
DAT A_ SOURCE
EFFECTIVE_ DATE
UWI
FIRST _NAME
AOF_COUNT
LAST_ NAME
ASSIGNED_ FIEL D
MIDDLE_INIT IAL
L_STRAT_NAME_SET
T D_ ST RAT _UNIT _ID
LW_LBA_F K2
PPDM_GUID
COM P_ COUNT
REMARK
LSNS_LBA_FK
CONFIDENT IAL_ DAT E
LW_LBA_F K
CORE_COUNT
COUNTRY
STRAT _NAME_ SET _ID
CURRENT_ CL ASS
L_WELL_ALIAS
BUSINESS_ASSOCIAT E
CURRENT_ ST ATUS_ DAT E
DAT A_ SOURCE
DAT A_ SOURCE
EFFECTIVE_ DATE
UWI
PREFERRED_ IND
SOURCE
LS WS _LBA _FK
PPDM_GUID
REMARK
DIR_SRVY_COUNT
DRILL _RIG_ NUM
DST _COUNT
WELL_ AL IAS_ID
FINAL _DRILL _DAT E
ALIAS_T YPE
DAT A_ SOURCE
L_STRAT_WELL_SECTION
LWA_LW_F K
IPT S_COUNT
PREFERRED_ IND
KB_ EL EV
REMARK
UWI
LAST_ INJECT ION_DATE
WELL_ AL IAS
STRAT _NAME_ SET _ID
LAST_ PRODUCTION_ DAT E
STRAT _UNIT _ID
LICENSEE
LSU_LBA_FK
INT ERP_ID
LOG_COUNT
DAT A_ SOURCE
LS WS _LW_FK
MAX_ TVD
INT ERPRET ER
OLDEST _STRAT_ AGE
ORDINAL_ SEQ_NO
OLDEST _STRAT_ UNIT _ID
OVERTURNED_ IND
LSU_LSNS_FK
PICK_DAT E
ON_ INJECTION_ DAT E
L_WELL_SERVICE
ON_ PRODUCTION_DAT E
PICK_T VD
OPERAT OR
PPDM_GUID
PARENT _REL AT IONSHIP_T YPE
REMARK
UWI
STRAT _UNIT _AGE
SOURCE
PARENT _UWI
PLOT_ SYMBOL
SERVICE_ TABLE
PPDM_GUID
SERVICE_ TYPE
PROFIL E_ TYPE
SERVICE_ NUMBER
PROSPECT_ NAME
BASE_ MD
BASE_ ST RAT _UNIT _AGE
LSWS_LSU_FK
L_STRAT_UNIT
BASE_ ST RAT _UNIT _ID
AVERAGE_AGE
BUSINESS_ASSOCIAT E
LWS_LSU_FK
STATUS_T YPE
SURVEY_GRID
SU_ COUNT
VEL _SRVY_ COUNT
T OP_ST RAT _UNIT_ ID
EFFECTIVE_ DATE
SURFACE_UWI
STRAT _NAME_ SET _ID
T OP_ST RAT _UNIT_ AGE
DAT A_ SOURCE
T D_ ST RAT _NAME_SET_ ID
SERVICE_ DAT E
T OP_M D
LWS _LS U_FK 2
RIG_ RELEASE_DAT E
SPUD_ DAT E
REMARK
STRAT _UNIT _ID
REMARK
PPDM_GUID
PRIMARY_STRAT_ UNIT_ AGE
LWS_LSU_FK3
PROVINCE_ ST AT E
LWS _LW_FK
DAT A_ SOURCE
PRIMARY_STRAT_ UNIT_ ID
STRAT _NAME_ SET _ID
FINAL _T D
GROUND_ EL EV
PPDM_GUID
WATER_DEPTH
WATER_DEPTH_DATUM
WELL_ NAME
WELL_ NUMERIC_ID
FAULT _T YPE
ROW_CHANGED_ DAT E
FORM_CODE
LONG_NAME
MAX_ AGE
LW_LSU_FK
MIN_ AGE
ORDINAL_ AGE_CODE
LW_LS U_FK2
PPDM_GUID
REMARK
PPDM Lite 1.0
Copyright, 2004, PPDM Association. All Rights Reserved
46