index back

Translate Value

SELECT a.fieldname ,a.fieldvalue ,a.xlatshortname ,a.xlatlongname FROM PSXLATITEM a WHERE a.fieldname = 'TAX_CLASS_CAN' AND a.fieldvalue IN ('HTX','PYT') AND %EffdtCheck(PSXLATITEM, a, %CurrentDateIn) AND eff_status = 'A'

  • Related language record: CAN_TAX_HLT_LNG
  • PeopleSoft Field NameField TypeColumn TypeDescription
    FIELDNAMECharacter(18)VARCHAR2(18) NOT NULLField Name (see PSDBFIELD).
    FIELDVALUECharacter(4)VARCHAR2(4) NOT NULLField Value
    XLATSHORTNAMECharacter(10)VARCHAR2(10) NOT NULLTranslate Value Short Name
    XLATLONGNAMECharacter(30)VARCHAR2(30) NOT NULLTranslate Long Name
    index back(c)David Kurtz 2019, 8.54
    PTRef generated on 09-JUN-19