PO_NTFYTYPE_VW2

(SQL View)
Index Back

Includes PO notify types

Includes all notify types except spend.

SELECT %Substring(X.FIELDVALUE, 1, 1) , X.XLATSHORTNAME , X.XLATLONGNAME FROM PSXLATITEM X WHERE X.FIELDNAME = 'NOTIFY_TYPE' AND X.EFF_STATUS = 'A' AND X.FIELDVALUE <> 'S' AND %EffdtCheck(PSXLATITEM XX, X, %CurrentDateIn)

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 NOTIFY_TYPE Character(1) VARCHAR2(1) NOT NULL Notification Type
A=Maximum Amount
D=Approval Due Date
E=Expiration
R=Renewal
S=Spend Threshold
2 XLATSHORTNAME Character(10) VARCHAR2(10) NOT NULL Translate Value Short Name
3 XLATLONGNAME Character(30) VARCHAR2(30) NOT NULL Translate Long Name