RTBL_CAT_ACC_VW (SQL View)	Index Back
Scenario Category Distribution Scenario Category Distribution

RTBL_CAT_ACC_VW

(SQL View)

Scenario Category Distribution

SELECT CATEGORY_SCENARIO ,COUNT(*) ,0 FROM %Table(RTBL_SCENARIO) WHERE ACTIVE_SCENARIO='Y' GROUP BY CATEGORY_SCENARIO

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 CATEGORY_SCENARIO Character(50) VARCHAR2(50) NOT NULL Category

2 SCE_COUNT Number(3,0) SMALLINT NOT NULL Count

3 DATAHINT Character(254) VARCHAR2(254) NOT NULL Internet URL (Universal Resource Locator)

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	CATEGORY_SCENARIO	Character(50)	VARCHAR2(50) NOT NULL	Category
2	SCE_COUNT	Number(3,0)	SMALLINT NOT NULL	Count
3	DATAHINT	Character(254)	VARCHAR2(254) NOT NULL	Internet URL (Universal Resource Locator)