SETIDDefault Value: OPR_DEF_TBL_FS.SETID
Prompt Table: SP_SETID_NONVW
REGION_CDPrompt Table: RS_REGION
RS_REG_UTIL_PCT(SQL View) |
Index Back |
|---|---|
Utilization PercentagesActual Utilization percentage, Group by Setid and Region Code |
| SELECT SETID ,REGION_CD ,(100-SUM(UTIL_PCT)) ,(100-SUM(UTIL_PCT)) FROM PS_RS_REGION_UTIL GROUP BY SETID ,REGION_CD |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | SETID |
Character(5) | VARCHAR2(5) NOT NULL |
SetID
Default Value: OPR_DEF_TBL_FS.SETID Prompt Table: SP_SETID_NONVW |
| 2 | REGION_CD |
Character(10) | VARCHAR2(10) NOT NULL |
Identifies the Sales Region. Populated on the Item Table to identify the Sales Region the Item is applied to.
Prompt Table: RS_REGION |
| 3 | UTIL_PCT | Signed Number(4,0) | DECIMAL(3) NOT NULL | Utilization Percentage |
| 4 | UTIL_PCT_HIST | Signed Number(4,0) | DECIMAL(3) NOT NULL | Historical Utilization Percentage |