Top Ten Definitions

Top Ten Definitions

Maintenance program for Top Ten:

Header:

_________________________________________________________________________________________________________________________________

Create Year: ______         Copy from year: _____     Create copy Y/N___          

 Maintain year: _____      Create Month Minimums for Jan/Dec    Y/N__    Maintain:  Monthly minimums Y/N__

________________________________________________________________________________________________________________________________

• Help reminder on header
• copy/replace
  • look for Copy "from year - 1" to "New Year -1"  do this first
  • look for Copy "from year" with the "new year"
• if year exists not allowed to copy
  • they must remove the records
• 
  
• remove records
  • single records deletion
  • only if they are after the last released year/month   SCC_TT_RELEASE_BY_DATES  
    • SCC_PAYEE_TYPE="MGT"
• insert in between any of these
  • Group #
    • 1-15
  • Criteria
    •  "A"  "B" "C"  
  • these need to follow no gaps
• Maintain
  • cannot change the keys  (delete and insert again)
    • year
    • group
    • criteria
    • number of criteria
      • show it - no changes
    • SCC_MINIMUM_VALUE  
      • old Top Ten program needs this - current month min criteria
• Rules for each field
  • Group heading: text
  • Criteria heading:  text
  • TT_CALC_RANK_FLAG
    • Rules - Y/N  this needs to be forced to Y and tab back to change to N
      • Y is the normal and adds to the total ranks
      • N is only a qualifier  Change programming in New Top Ten
        • must define this as a qualifier 
          • Final Top Ten qualifier
          • or Group qualifier
  • SCC_REPORT_TYPE  (NEW table for LOV) 
    • 1   Simple criteria (no extra fields to display)  no prior year comparison
    • 2   Percentage ( imply PY  CY Increase )
    • 3   Goal Criteria (imply Goal and Dollars over Goal)
  • TT_CRTERIA_CALC_TYPE (existing table -simple program)
    • lov   SCC_TT_CRITERIA_CALC_TYPES
  • TT_USE_PRODUCT_LIST
    • Criteria A,B,C,D
    • was TL now Blanks!!! test this web programs
  • TT_REQUIRED_QUALIFY_FLAG   ("Final qualifier for Top10"  Y/N)
    • Y/N    Whole TOP 10 year qualifier
    • ****APPLY the qualifier for this line to the Whole Top Ten
  • SCC_TT_QUALIFIER_CODE  ("Group qualifier code")
    • LOV  SCC_TT_CRITERIA_CALC_TYPES (needs simple Maint)
      • if blank there is no qualifier for this group
  • If either are filled in these must be filled in
    • TT_REQUIRED_QUALIFY_FLAG 
    • or
    • SCC_TT_QUALIFIER_CODE  not blank 
    • if both are N and blank all the qualifier fields NEED to be blank
    • Define qualifier
      • TT_GROUP_CODE_SOURCE
        • must be defined (could be on this line)
      • TT_CRITERIA_CODE_SOURCE
        • must be defined (could be on this line)
      • SCC_TT_DETAILS_FIELD_NAME
        • LOV table (create it)
      • SCC_YEAR_END_MINIMUM_VALUE
        • 1-99999999
        • if this changes
          • then the monthly min for each month needs to be recalculated.
            • this/12 rounded to 5 dollar
            • fill in Jan - Nov 
              • Dec is always the Year end value
              • must always run New Top Ten
              • before the Old Top Ten
      • SCC_TT_BELOW_MIN_RANK use this if they do not qualify
        • 60 default to 60 but let then change it 1-100
          • no zero or blank
          • if there is no qualifier then this is 0
        • if these are not all the same send a message warning