CS_APPSTAT_VW

(SQL View)
 Index Back

Approval Status Xlat VW


SELECT %Substring(FIELDVALUE,1 ,1) , XLATLONGNAME FROM PSXLATITEM WHERE FIELDNAME = 'EFF_STATUS'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 CS_APPROVAL_STATUS Character(1) VARCHAR2(1) NOT NULL Approval Status
A=Approved
I=Initial
P=Pending Approval
2 XLATLONGNAME Character(30) VARCHAR2(30) NOT NULL Translate Long Name