search

bcgov / nr-fom

Forestry Operations Map
Apache License 2.0
0 stars 1 forks source link

FOM are saved in relation to Forest Stewardship Plan. Validation for FSP ID is required #278

Closed DerekRoberts closed 1 year ago

DerekRoberts commented 2 years ago

We will need to retrieve the FSP_ID for FOM A forest stewardship plan (FSP) can have one or more FOM (Forest Operations Map) Currently, FOM are created, FSP ID's are related to those FOM but there is no Referential Integrity to the FOREST_STEWARDSHIP_PLAN.FSP_ID. Validation will eventually be required to ensure that the FSP_ID entered actually exists. Additionally, Forest stewardship Plans are related to Client Numbers in the FSP_AGREEMENT_HOLDER table FSP_ID to CLIENT_NUMBER. Once both CLIENT data and FSP data are available, the data in FOM will be validated and reliable.

amee99073 commented 2 years ago

We will need to retrieve the FSP_ID for FOM A forest stewardship plan (FSP) can have one or more FOM (Forest Operations Map) Currently, FOM are created, FSP ID's are related to those FOM but there is no Referential Integrity to the FOREST_STEWARDSHIP_PLAN.FSP_ID. This validation of FSPs is expected to be done manually by ministry users after FOM are finalized. Validation within the application on creation of the FOM will eventually be required to ensure that the FSP_ID entered actually exists. Additionally, Forest stewardship Plans are related to Client Numbers in the FSP_AGREEMENT_HOLDER table FSP_ID to CLIENT_NUMBER. Further validation can be done to ensure the licensee submitting a FOM for the given FSP is, in fact the client of the entered FSP. Once both CLIENT data and FSP data are available, the data in FOM will be validated and reliable.

gormless87 commented 2 years ago

Is this a Fingerprint issue, or does it belong as a FOM issue?

gormless87 commented 1 year ago

Duplicated by #235