• Red bullet denotes Forest-Service Only
 

Coastal ECAS44 - Grade %

Description:

This screen captures information regarding species, species volumes, log grade percentages and grade source level for an appraisal data worksheet.

Screen Layout:

Business Rules:

  • Cannot add new species on this screen. This must be done on the Reference Info screen.
  • The Save button associated with the Species grid/table is disabled until a row is selected for update.
  • Information on this screen is only entered by the Region.
  • See ECAS Appraisal Validations for appraisal submission business rules.

Field Descriptions:

Species:
Data Source: ADS_SPECIES_VOLUME.HDBS_TREE SPECIES
Optionality: Derived
Default: <blank>
Validation Rules:
Notes: This field is derived from the reference screen
 
Grade %:
(B, C, D, E, F, G, H, I, J, K, L, M, U, X, Y)
Total Length 3
Data Type Numeric
Data Source ADS_SPECIES_VOLUME.GRADE_PCT
Format NNN
Optionality Optional
Default Alder, Birch, Cottonwood and Maple species default Grade % U to 100 (done on Ref Info when adding species)
Validation Rules
  • Sum of all grade percents for a row must equal 100
  • Valid values for individual Grade %: 0 - 100
  • Validate grades by inpsecting the GAS grade table:
SELECT *  
  FROM SPP_GRD_PRC_TBL sgpt
WHERE sgpt.committed_ind = 'Y'
AND sgpt.hdbs_spp_prd_grade LIKE '%'||P_SPECIES||'%'
AND SUBSTR(hdbs_spp_prd_grade, 5,1) = 'D'
AND RATE_CALC_MTHD_CD = 'MPS'
AND effective_date = (SELECT MAX(a.effective_date)
  FROM SPP_GRD_PRC_TBL A
WHERE A.rate_calc_mthd_cd = P_RATECALC
AND A.committed_ind = 'Y'
AND A.effective_date <= P_ADS_effective_date);
 
Total Net Cruise Volume By Species
Total Length 7
Data Type Numeric
Data Source APPRAISAL_DATA_ SUBMISSION.NET_ CRUISE_ VOLUME
Default Derived
Validation Rules Display only (entered on Reference Info Page - ECAS30)
 
Grade Source Level:
Data Source ADS_SPECIES_VOLUME.GRADE_SOURCE
Optionality Mandatory
Default <blank>
Validation Rules These should be the valid ones from the updated codelist
 
Total Net Volume
Total Length 7
Data Type Numeric
Data Source ADS_SPECIES_VOLUME.VOLUME
Default <blank>
Validation Rules Derived from reference page
 
Selling Price Zone:
Total Length 2
Data Source APPRAISAL_DATA_ SUBMISSION .SELL_PRICE_ZONE_CODE
Format NNN
Optionality Mandatory
Default 52 - if 2nd growth conifer volume is 'Y' (on reference page)
else 51
Validation Rules N/A
 
Second Growth:
Data Source Derived: Same value as APPRAISAL_DATA_SUBMISSION.SECOND_GROWTH_IND
Optionality Derived
Default Derived
Validation Rules
  • N/A, Derived
  • Derived from 2nd growth in reference screen
 
Single Tree Selection:
Data Source Derived. If data is present in APPRAISAL_DATA_SUBMISSION.SINGLE_ TREE_SELECTION_ VOLUME then checked, otherwise not checked
Optionality Derived
Default Derived
Validation Rules
  • N/A, Derived
  • Derived from reference screen
 
TSA
Total Length
Data Type Alpha Numeric
Data Source APPRAISAL_DATA_SUBMISSION.TSA_NUMBER
Optionality Derived
Default Derived
Validation Rules Description must be obtained from the TSA code list.
 
TSB
Total Length
Data Type Alpha Numeric
Data Source APPRAISAL_DATA_SUBMISSION.TSB_NUMBER
Optionality Derived
Default Derived
Validation Rules Description must be obtained from the TSA code list.
 
Applicable Volume (m3)
Total Length 7
Data Type Numeric
Data Source ADS_AREA_LOGGED.APPLICABLE VOLUME
Format NNNNNNN
Optionality Mandatory
Default
  • If the applicable volume has no value, the default for each appraisal year is determined as follows:
    1. Total Net Cruise Volume (Reference Page) / Total Merchantable Area (Reference Page)
    2. Resultant from 1 above * Area Unlogged (this page)
  • else <blank>
Validation Rules
 
Appraisal Year
Total Length 4
Data Type Numeric
Data Source ADS_AREA_LOGGED.APPRAISAL_YEAR
Format YYYY
Optionality Mandatory
Default <blank>
Validation Rules
  • Appraisal Year must be unique in list - only one Appraisal Year per ECAS ID
  • Must not be greater that the current appraisal year.
 
Area Unlogged (ha)
Total Length 4
Data Type Numeric
Data Source Derived. The area unlogged is determined by appraisal year as follows:
Total Merchantable Area (Reference Page) - Area Logged (Reference Page)
Format NNN.N
Optionality Derived
Validation Rules N/A, Derived

Get Processing

  • 'Get'
    • Species: Select from ADS_ SPECIES_ VOLUME where ECAS_ID = ECAS_ID
    • Area Unlogged: Select from ADS_LOGGED_AREA where ECAS_ID = ECAS_ID
  • See Costal Tombstone for retrieval on other parts of tombstone

Processing

  • On Go:
    1. Clear screen data
    2. Perform tombstone validation
    3. Perform get using filter criteria
  • On Delete/Clear:
    • Species: Call REMOVE_ADS_SPECIES_VOLUME
    • Area Unlogged: Call REMOVE_ ADS_LOGGED_AREA
  • On Update:
    • Species: Species is protected, all others are enterable.
    • Area Unlogged: Appraisal Year is protected, Applicable Volume is enterable.

Database Transactions

  1. 'Get'
    • Species: Select from ADS_SPECIES_VOLUME where ECAS_ID = ECAS_ID
    • Area Unlogged: Select from ADS_LOGGED_AREA where ECAS_ID = ECAS_ID
  2. 'Save'
    • Species: Can only update, no inserts allowed in this grid
    • Area Unlogged: Can only update applicable volume, no inserts allowed in this grid
  3. 'Update'
    • Species: Update ADS_SPECIES_VOLUME where HDBS_ TREE SPECIES = HDBS_TREE SPECIES set REVISION_COUNT = REVISION_COUNT + 1
    • Area Unlogged: Update ADS_LOGGED_AREA.APPLICABLE_VOLUME where APPRAISAL_YEAR = APPRAISAL_YEAR and ECAS_ID = ECAS_ID set REVISION_COUNT = REVISION_COUNT + 1
  4. 'Delete/Clear'
    • Species: (Clear) Updates all of the allowable grades to '0'.
    • Area Unlogged: Delete from ADS_LOGGED_AREA where APPRAISAL_YEAR = APPRAISAL_YEAR and REVISION_COUNT = REVISION_COUNT

Controls

Combo Boxes

Species Drop Down List - Values = HDBS_TREE_SPECIES, <blank>
Default: <blank>
Grade Source Level Drop Down List - Values = GRADE_SOURCE_LEVEL_CODE, <blank>
Default: <blank>
Selling Price Zone Drop Down List - Values = SELL_ PRICE_ ZONE_CODE, <blank>
Default: <blank>

Check Boxes

Competitive Ind. Yes if check box checked, otherwise No
Second Growth Derived
Single Tree Selection Cruise Volume Derived

Buttons

See Screen Button Security for button display rules.

Species
Save Save the data as per edits - disable until row is selected
Update Select the row to be updated.
Clear Sets the grade percentages of the selected row to zero.
 
Area Unlogged (ha)
Save Save the data as per edits.
Update Select the row to be updated.
Delete Deletes the selected row.
 
Entire screen
Save Save all other fields not in designated sections.

Change History

17:00 September 24, 2002 — KM
Selling Price Zone Changed from mandatory to optional
 
17:00 October 30 2002 — Mark Antenbring (changes as per client meeting Oct 24 2002)
 
  1. Species remove existing validation  note that the species are derived from the Reference screen and cannot be changed in this screen.
  2. Grade % BCDEFGHIJKLMUXY- Add validation rule that subgrade_cost_tbl referenced to enforce subgrade business rules
  3. Total Net Cruise Volume By Species change length to 7 no decimals. Derived
  4. Grade Source Level: Change to mandatory
  5. Competitive Ind: Change to mandatory. Default Y
  6. Total Net Volume: Length 7; Remove current validation and change to "derive from Reference Page"
  7. Selling Price Zone
    Length 2
    Drop down box
    Mandatory
    Default if on reference, if 2nd growth coniferous volume is Y the 52, else 51.
    This can be changed manually to another value in the drop down list
  8. Second Growth
    Note in validation that derived from 2nd growth in reference screen
    (note the rule above can be derived from this field)
  9. Single TreeSelection
    Note in validation that derived from reference screen
  10. ApplicableVolume
    Length = 7
    No decimals (format NNNNNNN)
  11. Area Logged
    Length = 4
    One decimal (format NNN.N)
 
11:00 Nov 1, 2002 — Steve Taylor (as per Sabina's email of Nov 1, 2002 08:23)
Competive Indicator Removed from prototype and spec.
 
12:00 Nov 20, 2002 — Steve Taylor (as per Coast Tech Spec Review by Sabina Nov 8, 2002)
Grade Source Level Updated Datasource
Added rule: 'These should be the valid ones from the updated codelist'
 
16:00 Dec 5, 2002 — Paul Parratt
Field Descriptions Updated table and field names.
 
16:00 Dec 10, 2002 — Mark Antenbring
Applicable volume Moved text in validation section to default section
Database Transactions: (Save) Area Unlogged: Can only update applicable volume, no inserts allowed in this grid
 
10:08 March 12, 2003 — Jordan Miller
Grade %: (B, C, D, E, F, G, H, I, J, K, L, M, U, X, Y) Added Birch and Maple to default to 100%
 
12:30 January 29, 2004 — Parma Gill
PT #21918
Grade %:		 Added. Validate grades by inpsecting the GAS grade table.
 
2004-07-14 — Bruce Macpherson
PT #23640
Second Growth:		 Changed Data source to: APPRAISAL_DATA_SUBMISSION.SECOND_GROWTH_OVER_80_IND
 
August 25, 2004 — Tim Thom (23777) ECAS Release 2.0 Phase 1
CR 30 Reorder Coast navigation buttons and pull down menus
 
2005-03-18 — Bruce Macpherson
CR44
Second Growth:		 Changed Data source to: APPRAISAL_DATA_SUBMISSION.SECOND_GROWTH_IND