XRF_LIST_INN_VW

(SQL View)
Index Back

List Include "RPN No" View

This view of the table XLATTABLE displays values for List Include Mode not equal to Complement (C).

SELECT FIELDVALUE , EFFDT , EFF_STATUS , XLATLONGNAME , XLATSHORTNAME FROM PSXLATITEM WHERE FIELDNAME = 'LIST_INCLUDE_MODE' AND FIELDVALUE <> 'C'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 FIELDVALUE Character(4) VARCHAR2(4) NOT NULL Field Value
2 EFFDT Date(10) DATE Effective Date
3 EFF_STATUS Character(1) VARCHAR2(1) NOT NULL Effective Status
A=Active
I=Inactive
4 XLATLONGNAME Character(30) VARCHAR2(30) NOT NULL Translate Long Name
5 XLATSHORTNAME Character(10) VARCHAR2(10) NOT NULL Translate Value Short Name