EO_ADDR_SBR_VW

(SQL View)
 Index Back

Editable Address Fields

View that retrieves only the fields in ADDRESS_SBR.

SELECT A.FIELDNAME , B.LONGNAME FROM PSDBFIELD A , PSDBFLDLABL B WHERE A.FIELDNAME IN ( SELECT R.FIELDNAME FROM PSRECFIELD R WHERE R.RECNAME = 'ADDRESS_SBR') AND B.FIELDNAME = A.FIELDNAME AND B.DEFAULT_LABEL = 1

  • Related Language Record: EO_ADDR_SBR_LW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 EO_ADDRESS_FIELD Character(18) VARCHAR2(18) NOT NULL Address field
    2 DESCR30 Character(30) VARCHAR2(30) NOT NULL Field Description