-- -------------------------------------------------------------------------------------
-- Name.....: DBA_Migration_Notes.txt
-- Purpose..: DBA Migration Notes, FTARPT version 02_01_12
-- -------------------------------------------------------------------------------------
-- <Mar 2 2005> <DRV> For migration into <test> (<DBQ01>)

These are required Pulldown and validation procedures and functions need to allow the 
reports to run in CRSRM


-- -------------------------------------------------------------------------------------
-- Migration Notes:


 - As per instructions: 
1) Create new Views (Needs Public Synonyms)
V_FTARPT_I01_INSPECTION
V_FTARPT_I02_PLAN_NO_INSP_HOUR
V_FTARPT_I03_INSPECT_BY_INSPTR
V_FTARPT_I04_CLIENT_INSPECTION
V_FTARPT_I06_RANGE_INSPECTION
V_FTARPT_P06_CUT_PERMIT_HIST

2) update existing Views
V_FTARPT_B01_CUT_BLOCK_STATUS
V_FTARPT_B02_CUT_BLOCK_AREAS
V_FTARPT_B03_CUT_BLOCK_DATES
V_FTARPT_F01_LICENCE_DATES
V_FTARPT_F02_LIC_STATUS_REGSTR
V_FTARPT_F03_ALLOWABLE_ANN_CUT
V_FTARPT_F04_MAILING_LIST_LIC
V_FTARPT_F05_LICENCE_CL_REGSTR
V_FTARPT_F06_ASSOCIATED_FILES
V_FTARPT_F07_LICENCE_OPENINGB
V_FTARPT_F08_LICENCE_OPENING2B
V_FTARPT_F09_LICENCE_SALES
V_FTARPT_P01_CUT_PERMIT_LISTNG
V_FTARPT_P02_CUT_PERMIT_DATES
V_FTARPT_P03_PRIV_MARK_REGISTR
V_FTARPT_P04_SMALL_BUS_MARKS
V_FTARPT_P05_CASH_SALES_REPORT
V_FTARPT_R01_ROAD_PERMIT_SECTN
V_FTARPT_R02_ROAD_PERMIT_AMEND
V_FTARPT_R03_CURKM_UNDR_RDPRMT
V_FTARPT_RAN01_GRAZING_TENURE
V_FTARPT_RAN02_HAYCUTNG_TENURE

3) Create New Procedures (Needs Public Synonyms)
FTARPT_I01_INSPECTION
FTARPT_I02_PLAN_NO_INSP_HOUR
FTARPT_I03_INSPECT_BY_INSPTR
FTARPT_I04_CLIENT_INSPECTION
FTARPT_I06_RANGE_INSPECTION
FTARPT_P06_CUT_PERMIT_HIST
FTARPT_ROAD_PRMT_WITH_SPATIAL

4) Update existing Procedures
FTARPT_B01_CUT_BLOCK_STATUS
FTARPT_B02_CUT_BLOCK_AREAS
FTARPT_B03_CUT_BLOCK_DATES
FTARPT_B04_CUT_BLOCK_OPENING
FTARPT_F01_LICENCE_DATES
FTARPT_F02_LIC_STATUS_REGSTR
FTARPT_F03_ALLOWABLE_ANN_CUT
FTARPT_F04_MAILING_LIST_LIC
FTARPT_F05_LICENCE_CL_REGSTR
FTARPT_F06_ASSOCIATED_FILES
FTARPT_F07_LICENCE_OPENINGB
FTARPT_F08_LICENCE_OPENING2B
FTARPT_F09_LICENCE_SALES
FTARPT_I07_RECREATION_INSPCT
FTARPT_P01_CUT_PERMIT_LISTNG
FTARPT_P02_CUT_PERMIT_DATES
FTARPT_P03_PRIV_MARK_REGISTR
FTARPT_P04_SMALL_BUS_MARKS
FTARPT_P05_CASH_SALES_REPORT
FTARPT_R01_ROAD_PERMIT_SECTN
FTARPT_R02_ROAD_PERMIT_AMEND
FTARPT_R03_CURKM_UNDR_RDPRMT
FTARPT_RAN01_GRAZING_TENURE
FTARPT_RAN02_HAYCUTNG_TENURE
FTARPT_REC01_RECREATION_PROJ
FTARPT_ESF0011
FTARPT_ESF_MESSAGE
FTARPT_CUT_BLOCKS_WITH_SPATIAL
FTARPT_IDW01


6) Grant Roles
See FTARPT Security Matrix.xls

-- -------------------------------------------------------------------------------------

-  generate public synonym list
-  review for invalids

-- -------------------------------------------------------------------------------------

