ICM Commission overview

Regional managers information

tables:  

1.  SCC_REGION_COMMISSION_CODES  - defines:  SCC_SOP_M_021 Commissions Regions Changes

1. draw
2. minimum draw threshold 
3. Region adjustment percentage to apply to adjust the commissions based on the place in the country mostly
4. Region name (not the person)
5. Everybody is now marked as "OLD" sales commission code

2.  Salespersons  - only in SQL for now   1 record per region

• ***Top Ten the address fields will make it bomb if too large
• SCC_PROMOTION_DATE   - sort descending  - to get the regions in transition at the top of the list
• sys_address_4 has the sort name used in sort many places
• sys_address_3 has the next RM name who is going to be promoted into this region.  If in know in advance.
• 
  
• payee_number - used to get to the SCC_payee table
• SCC_COMMISSION_PRICE_CODE -use E/W commissions in ICM
  • the commissions in ICM are E/W the price code is "D" for most distributors.  This is the only place where we mark which commissions the RM gets.
• SCC_TT_INCLUDE_FLAG - included in Top Ten
• all address and phone info is garbage in this table

SELECT        TOP (200) GEM_DBKEY, SALESPERSON_CODE, SCC_PROMOTION_DATE, SCC_REGION_DESCRIPTION, COMPANY_CODE, CODE_DESCRIPTION, SALES_COMMISSION_CODE, SCC_COMMISSION_PRICE_CODE, PHONE, SYS_ADDRESS_1, SYS_ADDRESS_2, SYS_ADDRESS_3, SYS_ADDRESS_4, SYS_POSTAL_CODE, SYS_CITY, SYS_COUNTY, SYS_STATE, SYS_PROVINCE, SYS_COUNTRY, MP_SALESPERSON_TYPE, MP_STRUCTURE_CODE, MP_STRUCTURE_LEVEL, MP_PARENT_SALESPERSON, AP_DIVISION, PAYEE_NUMBER, VENDOR_NUMBER, LOCATION, FIRST_NAME, LAST_NAME, MOBILE, SCC_TT_INCLUDE_FLAG, SCC_RM_BONUS_INCLUDE_FLAG, SCC_ACTIVE_FLAG, EMAIL, SCC_AD_NAME, SCC_NEW_LOCATION, SCC_GOAL_PERCENT, SCC_TERMINATION_DATE, SCC_SORT_FIELD, SCC_NAME_NO_SPEC_CHAR, SCC_RM_GOAL_FACTOR, SCC_RM_GOAL_PRV_FACTOR, AGING_CUTOFF_METHOD

FROM            SALESPERSONS

ORDER BY SCC_PROMOTION_DATE DESC

3.  SCC_PAYEE  only in SQL for now        multiple records per region - Current Payee + history of changes by Payee

               Includes the Open regions

• PAYEE_NUMBER - for 
  • open regions  "O620" for Open region 620   "O800" for Open region 800
  • same field is in salespersons table for a real RM
• SCC_ICM_ACTIVE_CODE   "ACTIVE" "INACTIVE"   - needed for ICM to work
  • inactivate regions AFTER the last pay period
  • do not activate new Open regions until AFTER the last pay period for the RM is completed.
• SOP_ACTIVE O for Open A for Active RM I inactive and not Open
  • Open regions will be "O" all the time!!!! active or inactive 
• SCC_ZERO_RESERVE_FLAG

  • field used to zero the commissions for someone leaving

  • if they are leaving and received a commission check this pay period

    • you cannot use the "Y" zero commissions

    • instead use "N" and force the draw to 0 so they do not earn commissions if they did not make draw

• SCC_GROW_RESERVE_PERCENT

  
  

  • take 25% off the commissions earned over their draw to accumulate in the reserve

  • new RMs are encouraged to take this option

  • then they can request a reserve check when they need extra money

  • this keeps their reserve from going into the negative