PO_STG_USER_VW (SQL View)	Index Back
PO Stage Status Prompt VW

PO_STG_USER_VW

(SQL View)

PO Stage Status Prompt VW

SELECT %Substring(X.fieldvalue, 1, 1) , X.xlatshortname , X.xlatlongname FROM PSXLATITEM X WHERE X.FIELDNAME = 'STAGE_STATUS' AND X.fieldvalue IN ('E' ,'R' ,'X' ,'B') AND %EffdtCheck(PSXLATITEM XX, X, %CurrentDateIn) AND X.EFF_STATUS = 'A'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 STAGE_STATUS Character(1) VARCHAR2(1) NOT NULL Stage Status
B=Ready to Create
C=Completed
D=Inv Demand Build in Process
E=Error
I=In Process
N=Needs Approval
P=PO Create in Process
R=Error Recycle
S=Staged
V=POCALC in Process
W=Warning Issued
X=Reset Req and Purge

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	STAGE_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Stage Status B=Ready to Create C=Completed D=Inv Demand Build in Process E=Error I=In Process N=Needs Approval P=PO Create in Process R=Error Recycle S=Staged V=POCALC in Process W=Warning Issued X=Reset Req and Purge
2	XLATSHORTNAME	Character(10)	VARCHAR2(10) NOT NULL	Translate Value Short Name
3	XLATLONGNAME	Character(30)	VARCHAR2(30) NOT NULL	Translate Long Name