-- -------------------------------------------------------------------------------------
-- Name.....: DBA_Migration_Notes.txt
-- Purpose..: DBA Migration Notes, FTARPT version 01_00_01
-- -------------------------------------------------------------------------------------
-- <2003/11/13> <DBA> 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) Run the scripts as listed in:
    ..\ddl\changes

2) Create the Synonyms for the Objects

CRS_V_CHECK_DATE_STRING3
CRS_V_CHECK_DATE_STRING4
CRS_V_CHECK_YEAR_MONTH_STRING
FTARPT_PD_DISTRICT_ALL_NO
FTARPT_PD_DISTRICT_NO
FTARPT_PD_DIS_REG_ALL_CODE
FTARPT_PD_DIS_REG_ALL_NUMBER
FTARPT_PD_REGION_ALL_NO
FTARPT_PD_REGION_NO
FTARPT_V_CHECK_GRAZING_TENURE
FTARPT_V_CHECK_RANGE_UNIT
FTARPT_V_CHECK_SB_PROJECT_NUMBER
FTARPT_V_CHECK_TIMBER_MARK
FTARPT_V_FRNR117
FTARPT_V_FRNR145
FTARPT_V_FRNR147
FTARPT_V_FRNR300
FTARPT_V_FRNR400
FTARPT_V_FRSR15A
FTARPT_V_FRSR16A
FTARPT_V_FRSR18A
FTARPT_V_FRSR19A
FTARPT_V_FTAR076


3) Grant priveledges
   The grants are listed on the output tab on the file:
   FTARPT Database Access.xls


-- -------------------------------------------------------------------------------------
-- DBA Changes to Original DDL:

-  generate public synonym list
-  review for invalids

-- -------------------------------------------------------------------------------------
-- Role/Security Notes: 

-  adjust WEBADE entries
-  check naming convensions and create the following proxy ids and roles



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

