# Features — rgbc_projects_net

Evidence date: 2026-10-05.

Source: `master` at `08268a8` (2021-03-08).

Status words:

- **Current** — present and reachable from a menu, startup, or cron case on this revision.
- **Completed** — described as finished in a version comment and still present.
- **In development** — none identified. No TODO project, no branch other than `master`.
- **Planned** — none identified in docs or open work items. Old comments that say "STILL need to" are historical; they are listed under uncertain, not as a live plan.
- **Changed** — differs between the first commit (2019-08-19) and `08268a8`.
- **Removed / inactive** — code or menu entries that are commented out or explicitly disabled.

There is no features document in the source repository.

## Current — Forecast (`RGBC_Forecast_2018`)

| Feature | Where |
|---|---|
| Windows-identity login and usage log | `Index.aspx.vb`, `App_Code/VB/SystemFunctions.vb` |
| Home, Planning, Adjustments, Reports, Open Season, My Brands | `Admin.Master` |
| Sandbox page for group `Dev` only | `Admin.Master.vb` removes the item otherwise; page `zSandbox.aspx` |
| Brand QF jobs queued for the cron program | `ProjectFunctions.sql_insert_BrandQF_Job` |
| Help and comment pages | `Help.aspx`, `HelpPlanning.aspx`, `Comments.aspx`, `AdjustmentsComments.aspx` |

Version label on the master page: 1.0.3, 4 April 2012. Later comments in the same file (2015) say all QFs were unlocked. **Implemented** as comments; the unlock itself was not re-traced.

## Current — Promotions (`RGBC_Promotions_2018`)

| Feature | Where |
|---|---|
| Login and usage log | `Index.aspx.vb`, `SystemFunctions.vb` |
| Home, Planning, Promotions, My Brands, Audit Log | `Admin.Master` |
| Import page | `Import.aspx` (not on the admin menu; page exists) |
| Duration and rep fields | Comment in `Admin.Master.vb` (2015-01-15, v1.0.3) |

`Account/Login.aspx`, Register, and Change Password are the ASP.NET template. They are not on the admin menu.

## Current — Score Card (`RGBC_ScoreCard_2018`)

| Feature | Where |
|---|---|
| Login, including `OVERRIDE_USERNAME` | `SystemFunctions.LogginUser` |
| Home | `Home.aspx` |
| Edit Team Setup, Edit Surveys, Edit Questionnaires | `TeamSetup.aspx`, `Survey.aspx`, `Questionnaire.aspx`, `QuestionEdit.aspx`, `TeamSetupEdit.aspx` |
| Overall Performance | `OverallPerformance.aspx` |
| People Balance Sheet pages and RDLC reports | `PeopleBalanceSheet.aspx`, `PeopleBalanceSheetNew.aspx`, `PeopleBalanceSheetReport.rdlc`, `PeopleBalanceSheetSubReport_Questions.rdlc` |
| Help page | `HelpPeopleBalanceSheet.aspx` |
| Mobile master selection | `SystemFunctions.setMasterPage`, `Mobile.Master`, `Mobile/Default.aspx` |
| Group-based menu | `Admin.Master.vb` |

Title: HR: People Development Tool. Assembly: RGBC ScoreCard.

## Current — Stock Control (`RGBC_Stock Control_2018`)

| Feature | Where |
|---|---|
| Login | `index.aspx.vb` |
| Product-period grid, including Direct Sales row | `ProductPeriod.aspx` |
| Imports list and import | `ImportList.aspx`, `Import.aspx` |
| Variance report (BMA) | `BMAReport.aspx` |
| Stock control report | `SCReport.aspx` |
| Brand list and details | `BrandList.aspx`, `BrandDetails.aspx` |
| User list and details | `UserList.aspx`, `UserDetails.aspx` |

Brand, shipping/order, and admin edits are enforced in `sql_Update_PP` and `setSecurity`. See business rules.

## Current — Superbowl Web (`RGBC_Superbowl Web_2018`)

Master data maintenance for customers (including key accounts, Snell areas, AdCheck, and non-RGBC customers), brands, companies, principals, products, product archive, reps, rep managers, branches, channels, segments, and users.

Operational pages: Export Sales, Audit Log, Daily Log, Integrity Test, Month End BFBE, Usage Log.

`[Sales QF]` is on the menu with an empty URL. `SalesRepQF.aspx` is in the project.

## Current — Superbowl Daily (`RGBC_Superbowl_Daily_2018`)

File import of customers, sales, stock, segmentation, AdCheck, exports, SALBA, rep calls, on/off consumption surveys and promos, and AdSpend. Posting, retotal, sales-charter query CSV, email of the log, and BFBE / Mondayly export. Auto-run when not in the debug setting.

Data access is split across `sqlDB_daily.vb`, `sqlDB_stockcontrol.vb`, and `sqlDB_superbowl.vb`.

## Current — Superbowl Daily 2 (`RGBC_Superbowl Daily 2_2018`)

Imports: off-consumption promo and survey, on-consumption promo and survey, rep calls, vendor (from view `vwAPVendors`), GL codes (from view `vwGLAccounts`).

Exports: PDA CRM, exposure CRM, PDA products, planned promotions.

Local folders `Imports`, `Imported`, and `Exports` beside the executable.

## Current — Cronjob (`RGBC_Superbowl_Cronjob_2018`)

Queue worker for `sysCronJob` types `BrandQF`, `ArchiveProduct`, freestock new/approved mail, and purchase-order new, approved, receipted, declined, cancelled, and completed mail. See the case list in [prd.md](prd.md) FR-010.

## Completed (commented as delivered, still in tree)

These are historical notes, not a release register.

- Forecast planning interface and live stock-control QF update (comments 2010–2011 in `Admin.Master.vb`).
- Promotions audit log (2012) and import facility (2012).
- Score Card replacement of Score Card by People Balance Sheet (2017-02-16) and dynamic survey engine (2017-05-03).
- Stock Control BMA import section (comment 2016-11-09).
- Superbowl Web product archive via cron (comment 2013-11-05).
- Daily 2 vendor import (2017) and GL import (2018) and planned promotions export (2019).

## Planned

No backlog, issue list, or uncommented "phase 2" implementation plan is in the repository.

Forecast `Admin.Master.vb` says phase 2 is a planning interface "to generate future QF". The same file later says the planning interface ended in October 2010. Treat phase 2 as **Completed** in comments, not as open work.

Score Card and Promotions headers say "PHASE 2: Dev" with no further text. **Unknown** whether that phase finished.

## Changed since the first Bitbucket commit

| Date | Commit | Change |
|---|---|---|
| 2021-02-09 | `1f7583a` | Cron case `POR_CompletedRequisition` in `frmCronjob.vb`. Emails a completed purchase-order requisition. Body query is `sysQuery` id `61` |
| 2021-03-08 | `08268a8` | Stock Control product-period grid gains a Direct Sales row (`lblDSales1`–`lblDSales15`) filled from `dwfSales` |

No other files changed after the 2019 import.

## Removed or inactive

| Item | Evidence |
|---|---|
| Score Card menu entries for New Score Card, New People Development Tool, New Sales Capabilities | Commented out in `Admin.Master`. Pages remain |
| Promotions Sandbox menu | `Selectable="False"` |
| Superbowl Web admin-only menu toggle | Commented out in `Admin.Master.vb` |
| Daily Monday email for un-invoiced requisitions | Comment 2016-01-28 in Daily 2: "disabled function, no longer needed". Button method `btnEmailRequisitions_Click` still exists |
| On/off consumption survey import in Daily | Comments show enable and disable cycles (v1.19 / v1.19x). The file names are still in `gFile` |
| Mint import and Mint sales-charter export | Comment v1.27 in `Main.vb`: removed / deactivated |
| Stock Control password on user insert | Functions `sql_insert_Users_OLD_WITH_PASSWORD` and `sql_update_Users_OLD_WITH_PASSWORD` remain in `sqlDB.vb`. Current insert does not write `strPassword` |
| Forecast login diagnostic block | Commented out in `Index.aspx.vb` |

## Not features of this repository

- SonarQube project files. Named on OVER-258, absent from git.
- CI pipeline.
- Automated tests.
- Free Stock and Purchase Order data-entry screens. Only the email/export worker is here.
- A shared component used by all eight solutions. Each solution compiles alone.

## Cross-reference

People Development Tool behaviour after 2018 is documented under `silicon_ark/RGBC_ScoreCard/`, from repository `rgbc_scorecard`, not from this archive.