RTBL_CAT_STA_VW (SQL View)	Index Back
Category Distribution Dropdown Scenario Category Distribution Dropdown

RTBL_CAT_STA_VW

(SQL View)

Category Distribution Dropdown

Scenario Category Distribution Dropdown

SELECT CATEGORY_SCENARIO ,STATUS_SCENARIO ,STATUS_SCENARIO ,0 ,STATUS_SCENARIO FROM PS_RTBL_SCENARIO

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

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

2 STATUS_SCENARIO Character(2) VARCHAR2(2) NOT NULL Status
CE=Complete with Errors
CS=Cancelled
CW=Complete with Warning
EE=Edit Errors
HS=On Hold
NS=No Success
NY=Not Yet Processed
PC=Paused for Checkpoint
PN=Processing Now
RA=Request Approved
RC=Request Cancelled
RD=Request Denied
RP=Request Pending
RY=Request Deployed
SC=Successfully Complete

3 STATUS_FULL Character(50) VARCHAR2(50) NOT NULL Status

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

5 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	STATUS_SCENARIO	Character(2)	VARCHAR2(2) NOT NULL	Status CE=Complete with Errors CS=Cancelled CW=Complete with Warning EE=Edit Errors HS=On Hold NS=No Success NY=Not Yet Processed PC=Paused for Checkpoint PN=Processing Now RA=Request Approved RC=Request Cancelled RD=Request Denied RP=Request Pending RY=Request Deployed SC=Successfully Complete
3	STATUS_FULL	Character(50)	VARCHAR2(50) NOT NULL	Status
4	SCE_COUNT	Number(3,0)	SMALLINT NOT NULL	Count
5	DATAHINT	Character(254)	VARCHAR2(254) NOT NULL	Internet URL (Universal Resource Locator)