GB_XLAT_FLD_VW (SQL View)	Index Back
GB Xlat Fields View This view returns all the fields that are defined as Xlat

GB_XLAT_FLD_VW

(SQL View)

GB Xlat Fields View

This view returns all the fields that are defined as Xlat

SELECT A.FIELDNAME FROM PSDBFIELD A , PSXLATITEM B WHERE A.FIELDNAME = B.FIELDNAME AND A.FIELDTYPE = 0 AND A.LENGTH <= 4 AND %EffdtCheck(PSXLATITEM, B, %CurrentDateIn) AND B.EFF_STATUS = 'A'

Related Language Record: GB_XLAT_FLD_LNG

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 FIELDNAME Character(18) VARCHAR2(18) NOT NULL Field Name (see PSDBFIELD).