JPM_WF_STAT_VW (SQL View)	Index Back
JPM Searchable Statuses View of X'lat table to select values that can be used on the Approvals search page (i.e. all statuses except "S" - Saved can be searched on)

JPM_WF_STAT_VW

(SQL View)

JPM Searchable Statuses

View of X'lat table to select values that can be used on the Approvals search page (i.e. all statuses except "S" - Saved can be searched on)

SELECT %Substring(X.FIELDVALUE, 1, 2) , X.XLATSHORTNAME , X.XLATLONGNAME FROM PSXLATITEM X WHERE X.FIELDNAME = 'JPM_WF_STATUS' AND %EffdtCheck(PSXLATITEM X1, X, %CurrentDateIn) AND EFF_STATUS = 'A' AND X.FIELDVALUE NOT IN ('S', 'N')

Related Language Record: JPM_WFSTAT_LNVW

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 JPM_WF_STATUS Character(2) VARCHAR2(2) NOT NULL JPM Workflow Status field
A=Approved
D=Denied
N=New
P=Pending
S=Saved

2 XLATSHORTNAME Character(10) VARCHAR2(10) NOT NULL Translate Value Short Name

3 XLATLONGNAME Character(30) VARCHAR2(30) NOT NULL Translate Long Name

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	JPM_WF_STATUS	Character(2)	VARCHAR2(2) NOT NULL	JPM Workflow Status field A=Approved D=Denied N=New P=Pending S=Saved
2	XLATSHORTNAME	Character(10)	VARCHAR2(10) NOT NULL	Translate Value Short Name
3	XLATLONGNAME	Character(30)	VARCHAR2(30) NOT NULL	Translate Long Name