ECAS Appraisal Validations

• Change History

Coast

activated on ECAS31 Acknowledgement when Submit button is pressed all sections except ECAS32 and ECAS44

activated on ECAS32 Control when Send to Region or Sent with Issue buttons are pressed all sections except ECAS32 and ECAS44

activated on ECAS32 Control when Transfer to GAS button is pressed all sections

ECAS30 - Reference Information

1. At least one timber mark must exist
2. For each timber mark, there must be Timber Mark Cruise Volume
3. If TSB is filled in, TSA must be filled in
4. Appraisal Type must be filled in
5. 1. Submit: If appraisal is BCTS or Appraisal Type = ReAppraisal, Appraisal Effective Date must be filled in.
   2. Sent to Region, Send with Issue, Transfer to GAS: Appraisal Effective Date must be filled in.
6. Rate Calculation Method must be filled in
7. At least one species must exist
8. For each species, there must be Volume > 0 unless it is Primary Timber Mark
9. Total Merchantable Area must be filled in
10. At Least one "Area Logged" must be entered.
11. The Effective Date/Expiry Date combination must not overlap any other appraisal with the same timber_mark found in the app_worksheet table. app_worksheet is all the appraisals found within GAS.
12. Major Centre and Distance must be filled in if the appraisal effective date >= 2004-02-29 and < 2006-06-01
13. Major Centre and Distance must be blank if the appraisal effective date < 2004-02-29
14. Second Growth Conifer Volume must be <= Total Conifer Volume
15. Sum of Mark volumes must equal the Net Cruise Volume
16. Rate Calculation method must be MPS if the appraisal effective date >= 2004-02-29
17. If FTA information for the Mark exists:
    • If FTA Mgmt Unit Type is U (TSA) or V (TSB) then
      • TSB field must be entered (can't be blank)
      • TSA number in FTA must = TSA number entered
18. Distance to Major Centre must be filled if the appraisal effective date >= 2006-06-01
19. Coniferous Stand Rate Eligibility Code must be S or N if the appraisal effective date is on or after the SRE code effective date
20. Deciduous Stand Rate Eligibility Code must be N if the appraisal effective date is on or after the SRE code effective date

ECAS33 - Tree to Truck

1. At least one logging system must exist (Cable Yarding, Ground Systems, Skyline >600m, Land Drop, Water Drop or Single Stem for appraisals effective >= 2004-02-29; Cable Yarding, Ground Systems, Land Drop, Water Drop or Single Stem for appraisals effective < 2004-02-29)
2. The sum of all logging systems must = Total Net Cruise Volume.
3. Average Haul Distance must be filled in
4. Point of Appraisal and Point of Origin must be filled in
5. If 2nd Point of Origin is filled in, Point of Origin must exist
6. Routine Road Maintenance must be filled in
7. Basic Silviculture required must be filled in
8. Is the Cutting Permit Accessible must be filled in
9. The volume for each logging system must equal the total volume for that logging system on the Cutting Authority Details screen (ECAS41).
10. If appraisal effective date is on or after 2007-06-01 then CP Vol / Log must be filled in.

ECAS34 - Specified Operations

1. If Description is filled in for Specified Operations, Rate must be filled in
2. Each description may only be entered once for Specified Operations

ECAS35- Bridges

1. If Bridges exist, Bridge type, Crib Height, Span Length and Crown Portion percent must be filled in
2. Bridge Road Name and Start Station / End Station must be unique

ECAS36 - Culverts

1. If Metal Culvert exist, Diameter, Total Length for Diameter, Crown Portion percent must be filled in
2. Each Diameter can only be used once
3. If Wooden Culvert exist, Number and Crown Portion percent and Unit cost must be filled in
4. Each Number /Appraisal Year combination must be unique

ECAS37 - Tabular Roads

1. If Tabular Roads exist, and appraisal effective date < 2006-12-01, Road Name, Section Length, Construction Category, Crown % must be filled in
2. If Tabular Roads exist, and appraisal effective date >= 2006-12-01, Road Name, Section Length, Bank Height Category, Crown % must be filled in
3. Each Road Name /Start Station/End Station combination must be unique.

ECAS40 -Detailed Engineering

1. If New Construction exists, Cost Estimate Identifier, Total Length of Road, Crown Portion % and Total Cost must be filled in
2. Each Cost Estimate Identifier must be unique for New Construction (ignore RR and EH records)
3. If Reconstruction and Replacement exists, Cost Estimate Applicable Attachment #, Total Length of Road, Crown Portion % and Total Cost must be filled in
4. Each Cost estimate Applicable Attachment # must be unique for Reconstruction and Replacement

ECAS41 -Cutting Authority Details

1. Major Center and Distance must be filled in if the appraisal effective date >= 2006-06-01
2. Appraisal Log Dump must be filled in if the appraisal effective date >= 2006-06-01
3. Other Log Dump description must be filled in if the appraisal effective date >= 2006-06-01 and Appraisal Log Dump = 'OTHR'

ECAS43 - Attachment

1. Ensure that there are attachments for the Cruise Compilation
2. Ensure that there are attachments for the Appraisal Map
3. If any of the following Specified Operations exist on ECAS34 ensure there is a corresponding attachment:
   • A-frame Logging
   • Blowdown Timber
   • Single Tree Harvesting
   • Skyline Logging
   • Tree Crown Modification
   • Lake Transportation
   • Skidder Swing
   • Towing to Tie-up Grounds
   • Camp Move
   • Destumping for Root Disease Control
4. If Culvert Worksheet attachment provided ensure a record exists in Culvert Cost table
5. If Bridge Repair, Construction Estimate Form #1-6, of Estimate Info to Support Detailed Engineering attachment provided ensure a record exists in Detailed Engineering Cost table
6. If BC Timber Sales (FS 574) attachment provided ensure a record exists in BC Timber Sales table

ECAS BCTS 2nd Pass Submit Validations

1. BCTS Sale Date is mandatory
2. BCTS and Tenure Information attachments are mandatory

Coast

For District Send to Region or Send with Issue button - all coast rules above apply, PLUS ECAS43

For Region Transfer to GAS button - same rules apply, PLUS ECAS32 and ECAS44

ECAS32 - Control

1. MVI Eligible must be filled in
2. TOA Eligible must be filled in
3. Rate Adjustment Type must be filled in
4. Override Calculated Silviculture Levy must be filled on
5. check for mandatory Grade% fields completion before approval at the regional level.
6. TOA must be set to "Y" if MPS = Y and SB indicator = N. Else Must be set to N

ECAS44 - Grade %

1. At least one Species must exist
2. Selling Price Zone must be filled in
3. If Second Growth Indicator is true (from ECAS30), then Selling Price Zone must not be 51
4. Sum of grades for each species must equal 100%
5. Each species must have a Grade Source Level

ECAS43 - Attachments

1. Ensure there is a Cruise Analysis Form.
2. For Non-BCTS funded appraisals, ensure Tenure Information is provided.

Interior

activated on ECAS61 Acknowledgement when Submit button is pressed all sections except ECAS62

activated on ECAS62 Control when Send to Region or Send with Issue button is pressed all sections

activated on ECAS32 Control when Transfer to GAS button is pressed all sections

Change History

ECAS60 - Reference Information

1. If TSB is filled in, TSA must be filled in
2. Appraisal Type must be filled in
   1. Submit: If appraisal is BCTS or Appraisal Type = ReAppraisal, Appraisal Effective Date must be filled in.
   2. Send to Region, Send with Issue, Transfer to GAS: Appraisal Effective Date must be filled in.
3. Rate Calculation Method must be filled in
4. Point of Appraisal must be filled in
5. Comparative Cruise must be filled in
6. Salvage must be filled in.
7. The Effective Date/Expiry Date combination must not overlap any other appraisal with the same timber_mark found in the app_worksheet table. App_worksheet is all the appraisals found within GAS.
8. If FTA information for the Mark exists:
   • If FTA Mgmt Unit Type is U (TSA) or V (TSB) then
     • TSB field must be entered (can't be blank)
     • TSA number in FTA must = TSA number entered
   • If FTA Mgmt Unit Type is NOT U or V then
     • IF File Type Code = A04 (woodlot)
       • TSB must be entered
9. Coniferous Stand Rate Eligibility Code must be A or S if the appraisal effective date is on or after the SRE code effective date
10. Deciduous Stand Rate Eligibility Code is required if the appraisal effective date is on or after the SRE code effective date

ECAS67 - Tabular Roads

1. Applicable Volume must be filled in (> 0), if tabular roads are entered (exist)
2. Applicable Volume must be <= Net Cruise Volume + Obligatory Deciduous Volume
3. If Tabular Roads exist, Road Identifier, Road Group, BEC Zone, Section Length, must be filled in
4. Each Road/Identifier/Road Section Number/ BEC Zone combination must be unique
5. If Road Type is W (winter), then Stabilize Material (Length, Mat. Type and Haul Distance) must be blank
6. If appraisal effective date is before 2007-07-01, the appraisal road type codes must be one of 'O','B', or 'W'
7. If appraisal effective date is on or after 2007-07-01, the appraisal road type codes must be one of 'L','S','T', or 'W'

ECAS66 - Culverts

1. Applicable Volume must be filled in (>0), if culverts are entered (exist)
2. Applicable Volume must be <= Net Cruise Volume + Obligatory Deciduous Volume
3. Diameter, Length and Number must be filled in, if culverts are entered (exist)
4. Each Diameter/Length combination can only be used once, if culverts are entered (exist)

ECAS68 - Other Development

1. If Allocated Development exist, Identifier, Description, Trended Cost and Applicable Volume must be filled in
2. Applicable Volume must be <= Net Cruise Volume + Obligatory Deciduous Volume
3. Each Allocated Development identifier must be unique
4. If Engineered Development exist, Identifier, Description, Trended Cost and Applicable Volume must be filled in
5. Applicable Volume must be > 0.
6. Each Engineered Development identifier must be unique

ECAS63 - Cruise Information / TTT

1. Total Net Cruise Volume must exist
2. Sampling Error must be filled in
3. CP Average Vol/tree must be filled in
4. CP Average Slope must be filled in
5. CP Vol/ha must be filled in.
6. BEC Zone and Subzone zone must be filled in.
7. The combination of BEC zone, Sub Zone and Variant must exist in APP_BSILV_M3TBL
8. Sum of Species Volume must be equal to the Total Net Cruise Volume
9. At least one species must exist and it must be a coniferous species
10. For each species, there must be Volume > 0
11. For each species filled in, there must be LRF
12. Support Centre must be filled in
13. Distance to Support Centre must be > 0
14. At least one Harvest Method must be filled in
15. If any Partial Harvest Method is filled in, partial cut % must be > 0 and < 90
16. If partial cut is filled in, other information in that column must exist
17. Appraisals effective prior to 2004-11-01: The sum of all vol. To be harvested must be equal to the Total Net Cruise Volume
    Appraisals effective on or after 2004-11-01: The sum of all vol. To be harvested must be equal to the sum of Total Net Cruise Volume and Deciduous Volume
18. For each Harvest Method filled in, Vol to be harvested, Biogeoclimatic Zone, Net Volume/Tree, Volume/hectare, average slope must be filled in
19. If Skyline volume exists, skyline yarding distance must be filled in
20. If helicopter volume exists, helicopter yarding distance
21. Sum of harvest method volumes must equal sum of species volume
22. Total Net Cruise Area is Mandatory.
23. Lodgepole Pine volume for harvest method must be less than Total Lodgepole Pine species volume
24. Lodgepole Pine volume for harvest method must be less than harvest method volume
25. Spruce volume for harvest method must be less than Total Spruce species volume
26. Spruce volume for harvest method must be less than harvest method volume
27. If Lodgepole Pine Volume is specified, then at least one Lodgepole Pine Category must be provided.

ECAS64 - Log Transportation

1. Primary Haul Method must be filled in
2. Primary Cycle Time must be filled in
3. If Secondary Cycle time is filled in, Primary Cycle time must be filled in
4. Dewater/Reload must be filled in
5. Truck to Rail Transfer must be filled in
6. If Tow Distance > 0, then Water Transportation must be filled in
7. Road Management must be filled in
8. Isolated Cutting Authority must be filled in
9. Basic Silviculture must be filled in
10. If Woodlot with Road Management = Y, Woodlot Road Management Cost must be present
11. If CP average volume/tree < 0.20, Primary Haul Method must = H

ECAS 65 - Specified Operations

1. If more than one Dispersed Salvage is filled in, the sum of Blended % cannot be > 100
2. If a Dispersed Salvage radio button is selected, Blended % cannot be 0

ECAS 69 - BCTS

1. If BCTS Allocated Development identifier exists, then other fields must be filled in
2. Applicable Volume must be <= Net Cruise Volume + Obligatory Deciduous Volume
3. Applicable Volume must be > 0.

ECAS 70 - Attachments

1. Appraisal Map radio button must be filled in
2. Cycle Time Calculation radio button must be filled in
3. One of either cruise compilation or comparative cruise information must be filled in

ECAS BCTS 2nd Pass Submit Validations

1. BCTS Sale Date is mandatory
2. BCTS attachment is mandatory

Interior

activated on ECAS31 Acknowledgement when Submit button is pressed
For District Send to Region or Sent with Issue button - same rules apply as listed above

activated on ECAS31 Acknowledgement when Submit button is pressed
For Region Transfer to GAS button - same rules apply PLUS ECAS62

ECAS61 - Acknowledgement

1. RPF section must be filled in
2. If BCTS/Licensee Rep name is filled in, other information (phone and email) must be filled in

ECAS62 - Control

1. Adjust Quarterly must be filled in
2. MVI Eligible must be filled in
3. MVI set to "Y" if CVP = Y and SB indicator = N (BCTS page is blank) and File type code of A01, A02, A03 ( must have AAC > 10,000), A06, A30.
4. TOA Eligible must be filled in

Change History