EO_ADDR_LKP_VW3

(SQL View)
 Index Back

Address Lookup Field Prompt

Address Lookup Field Prompt Object Owner ID marked as SCC

SELECT DISTINCT A.FIELDNAME, B.LONGNAME FROM PSXLATITEM A, PSDBFLDLABL B WHERE %EffdtCheck(PSXLATITEM, A, %CurrentDateIn) AND A.EFF_STATUS = 'A' AND B.FIELDNAME = A.FIELDNAME AND B.DEFAULT_LABEL = 1

  • Related Language Record: EO_ADDR_LKP_LW3

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 EO_ADDR_LKP_FLD Character(18) VARCHAR2(18) NOT NULL Address field lookup field Object Owner ID marked as SCC
    2 DESCR30 Character(30) VARCHAR2(30) NOT NULL Description