SPB_METRIC_CODEPrompt Table: SPB_METRIC_VW
AMT=Currency Amount
AVG=Average
CNT=Count
DAY=Day
PCT=Percentage
TIM=Time
TOT=Total
SPB_METRIC_DFN(SQL Table) |
Index Back |
|---|---|
Analysis Metric Definition TblAnalysis Metric Definition Table for Graphs |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | SPB_METRIC_CODE |
Character(18) | VARCHAR2(18) NOT NULL |
Metric Code
Prompt Table: SPB_METRIC_VW |
| 2 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 3 | SPB_AGGREGATE | Character(3) | VARCHAR2(3) NOT NULL |
Aggregate
AMT=Currency Amount AVG=Average CNT=Count DAY=Day PCT=Percentage TIM=Time TOT=Total |
| 4 | SPB_METRIC_YN | Character(18) | VARCHAR2(18) NOT NULL | Field Name |