SFA_SS_XLAT_VW

(SQL View)
 Index Back

XLAT values of Inst Group

This view contains all translate values of SFA_SS_INST_GROUP. This view is used as a prompt on SFA_SS_SETUP.

SELECT A.FIELDVALUE , A.EFFDT , A.XLATLONGNAME , A.XLATSHORTNAME FROM PSXLATITEM A WHERE FIELDNAME = 'SFA_SS_INST_GROUP' AND %EffdtCheck(PSXLATITEM A1, A, %CURRENTDATEIN) AND A.EFF_STATUS = 'A'

  • Related Language Record: XL_NAMEPRTVW_LN

    • # 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

    Default Value: %date

    3 XLATLONGNAME Character(30) VARCHAR2(30) NOT NULL Translate Long Name
    4 XLATSHORTNAME Character(10) VARCHAR2(10) NOT NULL Translate Value Short Name