RSFD_LOAD_DEL(SQL Table) |
Index Back |
|---|---|
Control Dashboard Load DeleteControl values for loading and deleting sales data objects from Dashboard |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | BEGIN_DATE | Date(10) | DATE | Begin Date |
| 2 | DEL_CRPT_DAYS | Number(4,0) | SMALLINT NOT NULL | Days after which to delete Call Reports from Dashboard |
| 3 | DEL_FCST_DAYS | Number(4,0) | SMALLINT NOT NULL | Days after which to delete Forecast from Dashboard |
| 4 | DEL_LE_DAYS | Number(4,0) | SMALLINT NOT NULL | Days after which to delete leads from Dashboard |
| 5 | DEL_OPP_DAYS | Number(4,0) | SMALLINT NOT NULL | Days after which to delete Opportunities from Dashboard |
| 6 | DEL_PLAN_DAYS | Number(4,0) | SMALLINT NOT NULL | Days after which to delete Plans from Dashboard |
| 7 | DEL_TASK_DAYS | Number(4,0) | SMALLINT NOT NULL | Days after which to delete Tasks from Dashboard |
| 8 | KEEP_OPEN | Character(1) | VARCHAR2(1) NOT NULL |
Keep all records which are in an Open Status
N=Keep On Y=Keep Off |
| 9 | ADD_OPEN | Character(1) | VARCHAR2(1) NOT NULL |
Add all records which are in an Open Status
N=Add Off Y=Add On |