RTBL_ALE_STA_VW

(SQL View)

SELECT FIELDVALUE AS STATUS_SCENARIO ,XLATLONGNAME AS STATUS_FULL FROM PSXLATITEM WHERE FIELDNAME='STATUS_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

#	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