Results Reports version 01_00_03 March 19, 2004.


--this table already exists through CRSRA 2.0.0 as does the index and constraints.
--1) Create New Table
--PRIVATE_LAND_VOL_HA_RATIO_CONV
--Populate Table
--ins_PRIVATE_LAND_VOL_HA_RATIO_CONV

2) Create New Function

CRS_GET_OPENING_CLIENT.FNC

3) Create New View

V_OPENING_TENURE.VW

4) Update Existing Functions

RSLTRPT_FTASCLT_CLIENT_LOCN.FNC
RSLTRPT_FTASCLT_CLIENT_NUMBER.FNC
RSLTRPT_GET_FOR_COVR_SPEC_DATA.FNC
RSLTRPT_GET_SL_ACC_TREE.FNC
RSLTRPT_GET_SL_PREF_TREE.FNC

5) Create New Functions 

CRS_GET_OPENING_CLIENT.FNC
RSLTRPT_ADD_YEARS.FNC
RSLTRPT_GET_BLOCK_STATUS.FNC
RSLTRPT_GET_CLIENT_NAME.FNC
RSLTRPT_GET_COMMENCEMENT_DATE.FNC
RSLTRPT_GET_MARK_STATUS.FNC
RSLTRPT_GET_SILV_METHOD_DESCR.FNC
RSLTRPT_GET_SSU_MILESTONE_DT2.FNC
RSLTRPT_LAND_STATUS_FFGROUP.FNC
RSLTRPT_LAND_STATUS_PLANTED.FNC
RSLTRPT_LAND_STATUS_PLANTFAIL.FNC
RSLTRPT_OSHDR_CLIENT_LOCN_CODE.FNC
RSLTRPT_OSHDR_CLIENT_NUMBER.FNC

6) Create New Functions that call other functions

RSLTRPT_LAND_STATUS_NATURAL.FNC
RSLTRPT_LAND_STATUS_REGENFAIL.FNC
RSLTRPT_LAND_STATUS_NEWDENUDE.FNC
RSLTRPT_LAND_STATUS_NPRECLASS.FNC


7) Update Existing Procedures

RSLTRPT_DECLARATION.PRC
RSLTRPT_FG_15MONTH_IND.PRC
RSLTRPT_OPENING_SUMMARY.PRC
RSLTRPT_OPENING_SUMMARY_STOCK.PRC

8) Create New Procedures

RSLTRPT_AREA_HV_BY_SILV.PRC
RSLTRPT_AREA_PL_BY_RSPONSBILTY.PRC
RSLTRPT_FERTILIZATION_ON_CROWN.PRC
RSLTRPT_NSR_CROWN_LAND.PRC
RSLTRPT_OPENING_SUMM_CMT_ATU.PRC
RSLTRPT_OPENING_SUMM_CMT_OPEN.PRC
RSLTRPT_OPENING_SUMM_CMT_SMS.PRC
RSLTRPT_OPENING_SUMM_CMT_SSU.PRC
RSLTRPT_PRUNING_ON_CROWN.PRC
RSLTRPT_RDD001.PRC
RSLTRPT_RDD002.PRC
RSLTRPT_RDD003.PRC
RSLTRPT_RDD004.PRC
RSLTRPT_RDD005.PRC
RSLTRPT_RDD006.PRC
RSLTRPT_RDD007.PRC
RSLTRPT_RDD008.PRC
RSLTRPT_RDD009.PRC
RSLTRPT_RDD010.PRC
RSLTRPT_RDD011.PRC
RSLTRPT_REGEN_FG_DUE_YEAR.PRC


9) Apply Grants
