FO_COMP_OPRTR

(SQL View)
Index Back

SELECT FIELDVALUE , XLATSHORTNAME , XLATLONGNAME FROM PSXLATITEM A WHERE FIELDNAME ='COMP_OPERATOR' AND %EffdtCheck(PSXLATITEM, A, %currentdatein) AND EFF_STATUS= 'A' AND FIELDVALUE IN ('<','>','=', '<=', '>=')

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 FIELDVALUE Character(4) VARCHAR2(4) NOT NULL Field Value
2 XLATSHORTNAME Character(10) VARCHAR2(10) NOT NULL Translate Value Short Name
3 XLATLONGNAME Character(30) VARCHAR2(30) NOT NULL Translate Long Name