• Red bullet denotes Forest-Service Only
 

Coastal Tombstone

Description:

Displays common fields for all Coast screens. Allows users to retrieve an existing appraisal data submission based on entered criteria from any Coast screen.

Screen Layout:

Business Rules:

  • The "Tombstone" information is displayed at the top of each page. It is limited to one line containing the following information below.
  • One or more of the criteria must be entered.
  • Possible combinations include:
    • Timber Mark and Effective Date (Effective Date may be blank)
    • ECAS ID
  • Other combinations are not allowed

Field Descriptions:

Licence:
Total Length: Display Only
Data Source: ADS_SUBMITTED_TIMBER_MARK.FOREST_FILE_ID
 
Cutting Permit:
Total Length: Display Only
Data Source:

ADS_SUBMITTED_TIMBER_MARK.CUTTING_PERMIT_ID
Validation Rules:
  • Cutting Permit may not be entered without License
  • Tenure Processing Rules must be applied, see Tenure Processing Rule.
 
Timber Mark(s):
Total Length: 6
Data Type: Alpha Numeric
Data Source: ADS_SUBMITTED_TIMBER_MARK.TIMBER_MARK
Optionality: Mandatory
Default: <blank>
Validation Rules:
  • Note: Timber Mark is not validated due to the timing of when appraisals come into ECAS. Timber Mark may exist in ECAS but not entered into FTAS.
  • Tenure Processing Rules must be applied, see Tenure Processing Rules.
  • Note special character such as "/" and quotes must be supported.
 
Effective Date:
Total Length: 10
Data Type: Date
Data Source: APPRAISAL_DATA_SUBMISSION.EFFECTIVE_DATE
Format: YYYY-MM-DD
Optionality: Optional
Default: <blank>
Validation Rules:
  • If entered, timber mark must also be entered.
 
ECAS ID:
Total Length: 12
Data Type: Numeric
Data Source: APPRAISAL_DATA_ SUBMISSION.ECAS_ID
Optionality: Mandatory
Default: <blank>
Validation Rules:
  • Must exist in ADS, if not will display that it is not a valid ECAS ID
  • If entered, entries for Timber Mark, and Effective date are disregarded in Search Criteria. (I.e Mark and Effective date are interpreted to be null)

Get Processing:

  • If ECAS ID entered, use it and disregard TIMBER_MARK, and EFFECTIVE_DATE criteria.
  • If Timber Mark / Effective Date combination is entered, look in the APPRAISAL_DATA_SUBMISSION / ADS_SUBMITTED_TIMBER_MARK to get the corresponding ECAS_ID. The key that is pushed down through child tables is only ECAS_ID.

Processing:

  • On Update of ADS Data:
    1. Ensure that the key information has not changed since the last successful Get.

Change History:

17:00 Sept 30, 2002 — Jordan Miller
  Made Licence and Cutting Permit Read only.
  Added OR in between Effective date and ECAS Id
 
17:00 Oct 7, 2002 — Steve Taylor
  Added "AND" in between Timber Mark and Effective Date fields
 
13:00 Nov 16, 2002 — Steve Taylor (as per Sabina's email of 10:05 Nov 16, 2002)
  Added description
 
10:21 Aug 1, 2003 — Ross Nanton (CR17 Modifications)
 
  • Get Processing: Specified "If ECAS ID entered, use it and disregard TIMBER_MARK, and EFFECTIVE_DATE criteria.".
  • Calendar widget added to effective date.