RTBL_SCE_STA_VW (SQL View)	Index Back
Scenario Status Distribution Scenario Status Distribution

RTBL_SCE_STA_VW

(SQL View)

Scenario Status Distribution

SELECT STATUS_SCENARIO ,STATUS_SCENARIO ,0 ,STATUS_SCENARIO FROM PS_RTBL_SCENARIO

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 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

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

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

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

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	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
2	STATUS_FULL	Character(50)	VARCHAR2(50) NOT NULL	Status
3	SCE_COUNT	Number(3,0)	SMALLINT NOT NULL	Count
4	DATAHINT	Character(254)	VARCHAR2(254) NOT NULL	Internet URL (Universal Resource Locator)