Compliance Monitoring Database (IRIS)
File ID: |
7A497527-ECFE-4E1C-92DA-6E788302D658 |
Hierarchy Level: |
dataset |
Abstract: |
All Compliance Monitoring Sites (Regimes) in the Waikato Region. This layer comprises only IRIS data. |
Statement: |
The compliance monitoring layer contains all compliance monitoring regimes (also referred to as sites) in the Waikato Region. The layer is constructed using IRIS data. All regimes are presented in the layer, including those that have been closed (Status = complete). In addition to high level regime attributes the layer provides regime contact details (both the owner and emergency contact details), a summary statement of compliance, and information on monitoring activities planned by the Resource Use directorate for the current financial year.
|
Keywords: |
Authorisation,Compliance,IRIS,Monitoring |
Topic Category: |
location:positional information and services |
Resource Reference Date: |
24/07/2015 |
Metadata URL: |
https://data.waikatoregion.govt.nz:8443/ords/f?p=140:12:0::NO::P12_METADATA_ID:4049 |
Responsible Parties
Role: |
owner |
Position: |
|
Organisation: |
Waikato Regional Council |
Delivery Point: |
160 Ward Street |
City: |
Hamilton Central |
Postal Code: |
3204 |
Country: |
New Zealand |
Phone: |
|
Fax: |
|
Email: |
|
|
Metadata
Language: |
English |
Character Set: |
utf8 |
Standard: |
ANZLIC |
Standard Version: |
1.1 |
Metadata Constraints
Access Constraints: |
copyright |
Use Constraints: |
copyright |
Download Links
Supporting Information Links
General Notes:
COMPLIANCE.sdeadmin.COMPLIANCE_MONITORING_BLOCK_HR
|
File Identifier: |
64F7EAFD-D1D3-2630-E055-000000000001 |
Parent Identifier: |
7A497527-ECFE-4E1C-92DA-6E788302D658 |
Hierarchy Level: |
feature |
Hierarchy Level Name: | Feature of Compliance Monitoring Database (IRIS) |
Abstract: |
Geographical areas used to group compliance monitoring sites (regimes) into blocks that align to the 74 Healthy Rivers Wai Ora sub-catchments within the catchment area. |
Statement: |
The compliance monitoring blocks have been digitised to align to the Healthy Rivers Wai Ora catchment. Strategic areas have been aligned to the 4 river FMUs while the operational areas have been aligned to the 74 Healthy Rivers Wai Ora sub-catchments. Outside of the Healthy Rivers Wai Ora catchment the blocks have been divided into strategic areas using REC catchments and further split into operational areas using geographic features identified using Topo50 images.
Base data used to create compliance monitoring blocks is 1:50,000 scale data; therefore this layer inherits that level of implied geographic accuracy.
The compliance monitoring layer contains all compliance monitoring regimes (also referred to as sites) in the Waikato Region. The layer is constructed using IRIS data contained in GIS_ALL.COMPLIANCE_MONITORING_IRIS. All regimes are presented in the layer, including those that have been closed (Status = complete). In addition to high level regime attributes the layer provides regime contact details (both the owner and emergency contact details), a summary statement of compliance, and information on monitoring activities planned by the Resource Use directorate for the current financial year.
|
Other Information: |
The business rules that apply to the layer are contained in DM#3344828
|
Keywords: |
Farm,Healthy Rivers,Monitoring |
Topic Category: |
boundaries:legal land descriptions |
Resource Reference Date: |
26/03/2018 |
Metadata Constraints
Access Constraints: |
copyright |
Use Constraints: |
copyright |
Maintenance Information
Maintenance frequency: |
asNeeded |
Last Load Date: |
26/03/2018 |
Spatial Representation Information
Recommended Scale: |
1:50,000 |
Reference System: |
EPSG2193 |
Spatial Representation Type: |
vector |
Vector | Grid | Geographic Bounding Box |
GeometricObjectType : |
surface |
geometricObjectCount : |
92 |
topologyLevel : |
geometryOnly |
|
Number of Dimensions : |
2 |
Cell Geometry : |
|
Transformation Param Available : |
N |
|
westBoundLongitude : |
1906113.6494 |
eastBoundLongitude : |
1740273.901 |
southBoundLatitude : |
5646087.3429 |
northBoundLatitude : |
5961470.1796 |
|
Responsible Parties
Role: |
owner |
Position: |
|
Organisation: |
Waikato Regional Council |
Delivery Point: |
160 Ward Street |
City: |
Hamilton Central |
Postal Code: |
3204 |
Country: |
New Zealand |
Phone: |
|
Fax: |
|
Email: |
|
|
Data Constraints
Data Access Constraints : |
copyright |
Data Use Constraints: |
copyright |
Data Distribution: |
Third party, internal permission |
Licence Type : |
To be determined |
Licence: |
|
Licence Expiry: |
|
Licence Conditions: |
|
Copyright : |
© Waikato Regional Council Compliance Monitoring Database (IRIS)2018 Data. |
Data Disclaimers : |
The standard Waikato Regional Council Disclaimer applies to this data “While Waikato Regional Council has exercised all reasonable skill and care in controlling the contents of this information, Waikato Regional Council accepts no liability in contract, tort or otherwise howsoever, for any loss, damage, injury or expense (whether direct, indirect or consequential) arising out of the provision of this information or its use by you.” |
Data Use Limits : |
. |
Download Links
Supporting Information Links
General Notes:
Attribute Information
Name | Description | Notes | Restricted | Primary Key |
FARM_BLOCK_STRATEGIC |
Farm block name at the strategic level. |
|
N |
N |
FARM_BLOCK_OPERATIONAL |
Farm block name at the operational level. |
|
N |
N |
HR_PRIORITY_RANK |
Healthy Rivers Wai Ora sub-catchment priority rank. |
|
N |
N |
HR_CATCHMENT_ID |
Healthy Rivers Wai Ora unique sub-catchment ID |
|
N |
N |
HR_CATCHMENT_NAME |
Healthy Rivers Wai Ora sub-catchment name. |
|
N |
N |
ID |
Unique primary key ID. |
|
N |
Y |
GEOMETRY |
Geometry type. |
|
N |
Y |
|
COMPLIANCE.sdeadmin.COMPLIANCE_MONITORING_IRIS
|
File Identifier: |
9CE4A7E9-1C8C-49F1-8D69-FD3A6AF25064 |
Parent Identifier: |
7A497527-ECFE-4E1C-92DA-6E788302D658 |
Hierarchy Level: |
feature |
Hierarchy Level Name: | Feature of Compliance Monitoring Database (IRIS) |
Abstract: |
All Compliance Monitoring Sites (Regimes) in the Waikato Region. This layer comprises only IRIS data. |
Statement: |
The compliance monitoring layer contains all compliance monitoring regimes (also referred to as sites) in the Waikato Region. The layer is constructed using IRIS data. All regimes are presented in the layer, including those that have been closed (Status = complete). In addition to high level regime attributes the layer provides regime contact details (both the owner and emergency contact details), a summary statement of compliance, and information on monitoring activities planned by the Resource Use directorate for the current financial year.
|
Other Information: |
The business rules that apply to the layer are contained in DM#3344828
GIS_ALL.COMPLIANCE_MONITORING_IRIS is a view of materialised view GIS_DATASTORE.COMPLIANCE_MONITORING_IRIS_MV2 which is updated daily at approx 4:30am
see also doc: 15999929
This was provided by Herbert M 07/03/2024 and details info on addition of new attributes in 2023 and 2024.
|
Keywords: |
Authorisation,Compliance,IRIS,Monitoring |
Topic Category: |
location:positional information and services |
Resource Reference Date: |
24/07/2015 |
Metadata Constraints
Access Constraints: |
copyright |
Use Constraints: |
copyright |
Maintenance Information
Maintenance frequency: |
daily |
Last Load Date: |
26/11/2024 |
Spatial Representation Information
Recommended Scale: |
|
Reference System: |
EPSG2193 |
Spatial Representation Type: |
vector |
Vector | Grid | Geographic Bounding Box |
GeometricObjectType : |
point |
geometricObjectCount : |
9933 |
topologyLevel : |
geometryOnly |
|
Number of Dimensions : |
2 |
Cell Geometry : |
|
Transformation Param Available : |
N |
|
westBoundLongitude : |
17977370 |
eastBoundLongitude : |
1463057 |
southBoundLatitude : |
5648841 |
northBoundLatitude : |
5962282 |
|
Responsible Parties
Role: |
|
Position: |
|
Organisation: |
Waikato Regional Council |
Delivery Point: |
160 Ward Street |
City: |
Hamilton Central |
Postal Code: |
3204 |
Country: |
New Zealand |
Phone: |
|
Fax: |
|
Email: |
|
|
Data Constraints
Data Access Constraints : |
copyright |
Data Use Constraints: |
copyright |
Data Distribution: |
Third party, internal permission |
Licence Type : |
To be determined |
Licence: |
|
Licence Expiry: |
|
Licence Conditions: |
|
Copyright : |
© Waikato Regional Council Compliance Monitoring Database (IRIS)2015 - 2018 Data. |
Data Disclaimers : |
The standard Waikato Regional Council Disclaimer applies to this data “While Waikato Regional Council has exercised all reasonable skill and care in controlling the contents of this information, Waikato Regional Council accepts no liability in contract, tort or otherwise howsoever, for any loss, damage, injury or expense (whether direct, indirect or consequential) arising out of the provision of this information or its use by you.” |
Data Use Limits : |
. |
Download Links
Supporting Information Links
General Notes:
Attribute Information
Name | Description | Notes | Restricted | Primary Key |
ID |
|
|
N |
Y |
IRISID |
|
|
N |
N |
IRISOBJECTID |
|
|
N |
N |
FILENO |
|
|
N |
N |
REGIME_NAME |
|
|
N |
N |
REGIME_OFFICER |
|
|
N |
N |
REGIME_OWNER |
|
|
N |
N |
REGIME_EMERGENCY_CONTACT |
|
|
N |
N |
REGIME_CLASSIFICATION |
|
|
N |
N |
REGIME_STATUS |
|
|
N |
N |
COMPLIANCEMONITORINGSUMMARY |
|
|
N |
N |
COMPLIANCE_DOCUMENTS |
|
|
N |
N |
CURRENT_RA_IRISID |
|
|
N |
N |
CURRENT_RA_SUBTYPE |
|
|
N |
N |
CURRENT_RA_OFFICER |
|
|
N |
N |
CURRENT_RA_PRIORITY |
|
|
N |
N |
CURRENT_RA_TEAM |
|
|
N |
N |
CURRENT_RA_STATUS |
|
|
N |
N |
CURRENT_RA_COMPLIANCE |
|
|
N |
N |
CURRENT_RA_TYPE |
|
|
N |
N |
CURRENT_RA_FOCUS_AREA |
|
|
N |
N |
CURRENT_RA_FOCUS_AREA_REASON |
|
|
N |
N |
PRIOR_RA_FINANCIAL_YEAR |
|
|
N |
N |
PRIOR_RA_COMPLIANCE_STATUS |
|
|
N |
N |
LATEST_OBSERVATION_DATE |
|
|
N |
N |
LATEST_OBSERVATION_TYPE |
|
|
N |
N |
LATEST_OBSERVATION_WORST_COMP |
|
|
N |
N |
INDUSTRY |
|
|
N |
N |
INDUSTRIES |
|
|
N |
N |
DAIRY_HIGH_RISK_INITIAL |
|
|
N |
N |
DAIRY_HIGH_RISK_CURRENT |
|
|
N |
N |
DAIRY_WINTER_MILKING |
|
|
N |
N |
DAIRY_LAST_EFFLUENT_ASSESSMENT |
|
|
N |
N |
LATEST_OBSERVATION_WORST_COMPLIANCE |
|
|
N |
N |
LOCATION_IRISID |
|
|
N |
N |
LOCATION_ACCURACY |
|
|
N |
N |
NZTM_EASTING |
|
|
N |
N |
NZTM_NORTHING |
|
|
N |
N |
JMA_AREA |
|
|
N |
N |
GEOMETRY |
|
|
N |
N |
GDB_GEOMATTR_DATA |
|
|
N |
N |
|
COMPLIANCE.sdeadmin.COMPLIANCE_MONITORING_IRISLINK
|
File Identifier: |
6923610B-0675-42A8-E055-000000000001 |
Parent Identifier: |
7A497527-ECFE-4E1C-92DA-6E788302D658 |
Hierarchy Level: |
feature |
Hierarchy Level Name: | Feature of Compliance Monitoring Database (IRIS) |
Abstract: |
Contains all the relationships between compliance monitoring sites and authorisations. Achieved through a join between COMPLIANCE_MONITORING_IRIS and AUTHORISATION_IRIS via IRIS_REGIME_ACTIVITYOBJ_LINK. |
Statement: |
The compliance monitoring layer contains all compliance monitoring regimes (also referred to as sites) in the Waikato Region. The layer is constructed using IRIS data. All regimes are presented in the layer, including those that have been closed (Status = complete). In addition to high level regime attributes the layer provides regime contact details (both the owner and emergency contact details), a summary statement of compliance, and information on monitoring activities planned by the Resource Use directorate for the current financial year.
The join structure between compliance monitoring, the link table and authorisations is as follows: One-to-many join between compliance monitoring (left) and the link table (right). One-to-many join between the link table (left) and authorisations (right). This results in an output where all rows in the compliance monitoring table are retained and only those rows in authorisations are retained that have a successful join to compliance monitoring. This layer contains duplicates of regimes where more than one authorisation has a relationship with the compliance monitoring site. |
Other Information: |
The business rules that apply to the layer are contained in DM#3344828
GIS_ALL.COMPLIANCE_MONITORING_IRISLINK is a composite view made up of materialised view GIS_DATASTORE.COMPLIANCE_MONITORING_IRIS_MV2 which is updated daily at approx 4:30am and materialized view AUTHORISATION_IRIS which is updated every 2 hours. These two materialized views are joined together via IRIS_REGIME_ACTIVITYOBJ_LINK. |
Keywords: |
Authorisation,Monitoring |
Topic Category: |
|
Resource Reference Date: |
06/04/2018 |
Metadata Constraints
Access Constraints: |
copyright |
Use Constraints: |
copyright |
Maintenance Information
Maintenance frequency: |
daily |
Last Load Date: |
26/11/2024 |
Spatial Representation Information
Recommended Scale: |
|
Reference System: |
EPSG2193 |
Spatial Representation Type: |
vector |
Vector | Grid | Geographic Bounding Box |
GeometricObjectType : |
point |
geometricObjectCount : |
75557 |
topologyLevel : |
geometryOnly |
|
Number of Dimensions : |
2 |
Cell Geometry : |
|
Transformation Param Available : |
N |
|
westBoundLongitude : |
1904207.3108 |
eastBoundLongitude : |
1463056.9707 |
southBoundLatitude : |
5648840.887 |
northBoundLatitude : |
5962282.1192 |
|
Responsible Parties
Role: |
|
Position: |
|
Organisation: |
Waikato Regional Council |
Delivery Point: |
160 Ward Street |
City: |
Hamilton Central |
Postal Code: |
3204 |
Country: |
New Zealand |
Phone: |
|
Fax: |
|
Email: |
|
|
Data Constraints
Data Access Constraints : |
copyright |
Data Use Constraints: |
copyright |
Data Distribution: |
Third party, internal permission |
Licence Type : |
To be determined |
Licence: |
|
Licence Expiry: |
|
Licence Conditions: |
|
Copyright : |
© Waikato Regional Council Compliance Monitoring Database (IRIS)2015 Data. |
Data Disclaimers : |
The standard Waikato Regional Council Disclaimer applies to this data “While Waikato Regional Council has exercised all reasonable skill and care in controlling the contents of this information, Waikato Regional Council accepts no liability in contract, tort or otherwise howsoever, for any loss, damage, injury or expense (whether direct, indirect or consequential) arising out of the provision of this information or its use by you.” |
Data Use Limits : |
|
Download Links
Supporting Information Links
General Notes:
Attribute Information
Name | Description | Notes | Restricted | Primary Key |
CM_IRISOBJECTID |
Derived from COMPLIANCE_MONITORING_IRIS |
|
N |
N |
CM_IRISID |
Derived from COMPLIANCE_MONITORING_IRIS |
|
N |
N |
FILENO |
Derived from COMPLIANCE_MONITORING_IRIS |
|
N |
N |
REGIME_NAME |
Derived from COMPLIANCE_MONITORING_IRIS |
|
N |
N |
REGIME_OFFICER |
Derived from COMPLIANCE_MONITORING_IRIS |
|
N |
N |
REGIME_OWNER |
Derived from COMPLIANCE_MONITORING_IRIS |
|
N |
N |
REGIME_EMERGENCY_CONTACT |
Derived from COMPLIANCE_MONITORING_IRIS |
|
N |
N |
REGIME_CLASSIFICATION |
Derived from COMPLIANCE_MONITORING_IRIS |
|
N |
N |
REGIME_STATUS |
Derived from COMPLIANCE_MONITORING_IRIS |
|
N |
N |
COMPLIANCEMONITORINGSUMMARY |
Derived from COMPLIANCE_MONITORING_IRIS |
|
N |
N |
COMPLIANCE_DOCUMENTS |
Derived from COMPLIANCE_MONITORING_IRIS |
|
N |
N |
CURRENT_RA_IRISID |
Derived from COMPLIANCE_MONITORING_IRIS |
|
N |
N |
CURRENT_RA_SUBTYPE |
Derived from COMPLIANCE_MONITORING_IRIS |
|
N |
N |
CURRENT_RA_OFFICER |
Derived from COMPLIANCE_MONITORING_IRIS |
|
N |
N |
CURRENT_RA_PRIORITY |
Derived from COMPLIANCE_MONITORING_IRIS |
|
N |
N |
CURRENT_RA_TEAM |
Derived from COMPLIANCE_MONITORING_IRIS |
|
N |
N |
CURRENT_RA_STATUS |
Derived from COMPLIANCE_MONITORING_IRIS |
|
N |
N |
CURRENT_RA_COMPLIANCE |
Derived from COMPLIANCE_MONITORING_IRIS |
|
N |
N |
CURRENT_RA_TYPE |
Derived from COMPLIANCE_MONITORING_IRIS |
|
N |
N |
CURRENT_RA_FOCUS_AREA |
|
|
N |
N |
CURRENT_RA_FOCUS_AREA_REASON |
|
|
N |
N |
PRIOR_RA_FINANCIAL_YEAR |
|
|
N |
N |
PRIOR_RA_COMPLIANCE_STATUS |
|
|
N |
N |
LATEST_OBSERVATION_DATE |
|
|
N |
N |
LATEST_OBSERVATION_TYPE |
|
|
N |
N |
LATEST_OBSERVATION_WORST_COMPLIANCE |
|
|
N |
N |
INDUSTRY |
|
|
N |
N |
INDUSTRIES |
|
|
N |
N |
J_CM_IRISOBJECTID |
Derived from IRIS_REGIME_ACTIVITYOBJ_IRIS |
|
N |
N |
J_AUTH_IRISOBJECTID |
Derived from IRIS_REGIME_ACTIVITYOBJ_IRIS |
|
N |
N |
CURRENTFROM |
Derived from IRIS_REGIME_ACTIVITYOBJ_IRIS |
|
N |
N |
CURRENTTO |
Derived from IRIS_REGIME_ACTIVITYOBJ_IRIS |
|
N |
N |
AUTH_IRISOBJECTID |
Derived from AUTHORISATION_IRIS |
|
N |
N |
AUTH_IRISID |
Derived from AUTHORISATION_IRIS |
|
N |
N |
AUTHORISATIONTYPE |
Derived from AUTHORISATION_IRIS |
|
N |
N |
ACTIVITYTYPE |
Derived from AUTHORISATION_IRIS |
|
N |
N |
ACTIVITYSUBTYPE |
Derived from AUTHORISATION_IRIS |
|
N |
N |
ACTIVITYCLASS |
Derived from AUTHORISATION_IRIS |
|
N |
N |
AUTHORISATIONNAME |
Derived from AUTHORISATION_IRIS |
|
N |
N |
AUTHORISATIONDESCRIPTION |
Derived from AUTHORISATION_IRIS |
|
N |
N |
MONITORINGNOTES |
Derived from AUTHORISATION_IRIS |
|
N |
N |
COMMENCEMENTDATE |
Derived from AUTHORISATION_IRIS |
|
N |
N |
GRANTEDDURATION |
Derived from AUTHORISATION_IRIS |
|
N |
N |
EXPIRYDATE |
Derived from AUTHORISATION_IRIS |
|
N |
N |
LAPSEDATE |
Derived from AUTHORISATION_IRIS |
|
N |
N |
EFFECTIVEENDDATE |
Derived from AUTHORISATION_IRIS |
|
N |
N |
PRIMARYINDUSTRYPURPOSE |
Derived from AUTHORISATION_IRIS |
|
N |
N |
SECONDARYINDUSTRYPURPOSE |
Derived from AUTHORISATION_IRIS |
|
N |
N |
HOLDER |
Derived from AUTHORISATION_IRIS |
|
N |
N |
CURRENTSTATUS |
Derived from AUTHORISATION_IRIS |
|
N |
N |
CURRENTSTATUSFROMDATE |
Derived from AUTHORISATION_IRIS |
|
N |
N |
AUTHORISATIONEXERCISED |
Derived from AUTHORISATION_IRIS |
|
N |
N |
S124STATUS |
Derived from AUTHORISATION_IRIS |
|
N |
N |
AUTHORISATIONURL |
Derived from AUTHORISATION_IRIS |
|
N |
N |
AUTHCOMPLIANCE |
|
|
N |
N |
OBSERVATIONDATE |
|
|
N |
N |
OBSERVINGOFFICERS |
|
|
N |
N |
GEOMETRY |
|
|
N |
N |
ID |
Unique ID |
|
N |
N |
|
GIS_ALL.IRIS_REGIME_ACTIVITYOBJ_LINK
|
File Identifier: |
672CBADC-BC3E-0B0C-E055-000000000001 |
Parent Identifier: |
7A497527-ECFE-4E1C-92DA-6E788302D658 |
Hierarchy Level: |
feature |
Hierarchy Level Name: | Feature of Compliance Monitoring Database (IRIS) |
Abstract: |
A non-spatial table to be used as a link for AUTHORISATION_IRIS and COMPLIANCE_MONITORING_IRIS |
Statement: |
A many-to-many join relationship exists between AUTHORISATION_IRIS and COMPLIANCE_MONITORING_IRIS. A single authorisations can link at one or more of the regime level / regime activity level / observation level of compliance monitoring. A compliance monitoring (regime / regime activity / observation) will link back to at least one authorisation. |
Other Information: |
|
Keywords: |
IRIS |
Topic Category: |
farming:rearing of animals and/or cultivation of plants |
Resource Reference Date: |
12/03/2018 |
Metadata Constraints
Access Constraints: |
copyright |
Use Constraints: |
copyright |
Maintenance Information
Maintenance frequency: |
daily |
Last Load Date: |
26/11/2024 |
Spatial Representation Information
Recommended Scale: |
|
Reference System: |
|
Spatial Representation Type: |
textTable |
Vector | Grid | Geographic Bounding Box |
GeometricObjectType : |
|
geometricObjectCount : |
73112 |
topologyLevel : |
|
|
Number of Dimensions : |
|
Cell Geometry : |
|
Transformation Param Available : |
N |
|
westBoundLongitude : |
0 |
eastBoundLongitude : |
0 |
southBoundLatitude : |
0 |
northBoundLatitude : |
0 |
|
Responsible Parties
Role: |
owner |
Position: |
GIS and Data Management Team Leader |
Organisation: |
Waikato Regional Council - Science, Policy and Information |
Delivery Point: |
160 Ward Street |
City: |
Hamilton Central |
Postal Code: |
3204 |
Country: |
New Zealand |
Phone: |
0800 800 401 |
Fax: |
07 859 0998 |
Email: |
inforeq@waikatoregion.govt.nz |
|
Data Constraints
Data Access Constraints : |
copyright |
Data Use Constraints: |
copyright |
Data Distribution: |
Third party, internal permission |
Licence Type : |
To be determined |
Licence: |
|
Licence Expiry: |
|
Licence Conditions: |
|
Copyright : |
© Waikato Regional Council Compliance Monitoring Database (IRIS)2018 Data. |
Data Disclaimers : |
The standard Waikato Regional Council Disclaimer applies to this data “While Waikato Regional Council has exercised all reasonable skill and care in controlling the contents of this information, Waikato Regional Council accepts no liability in contract, tort or otherwise howsoever, for any loss, damage, injury or expense (whether direct, indirect or consequential) arising out of the provision of this information or its use by you.” |
Data Use Limits : |
|
Download Links
Supporting Information Links
General Notes:
Attribute Information
Name | Description | Notes | Restricted | Primary Key |
IRISOBJECTID |
|
|
N |
N |
LINKEDIRISOBJECTID |
|
|
N |
N |
LINKEDASRELATIONSHIPTYPE |
|
|
N |
N |
DESCRIPTION |
|
|
N |
N |
CURRENTFROM |
|
|
N |
N |
CURRENTTO |
|
|
N |
N |
ACTIVITYOBJECTRELATIONSHIPID |
|
|
N |
N |
REFRESH_DATE |
Date data has been updated from IRIS |
|
N |
N |
ID |
|
|
N |
Y |
|
|
|