FS_SD_FLD_VW_LG

(SQL View)
 Index Back

Supplemental Data Fields

Supplemental Data Fields

SELECT B.BASE_RECNAME , A.SD_RECNAME , A.SD_FLDNAME , C.LANGUAGE_CD , C.DESCR100 FROM PS_FS_SD_RECFLD A ,PS_FS_SD_REC B , PS_FS_SD_RECFLD_LG C WHERE A.SD_RECNAME = B.SD_RECNAME AND A.SD_FLD_STATUS = 'A' AND A.SD_RECNAME = C.SD_RECNAME AND A.SD_FLDNAME = C.SD_FLDNAME

  • Related Language Record for FS_SD_FLD_VW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 BASE_RECNAME Character(15) VARCHAR2(15) NOT NULL Base record that enabled for the supplemental data.

    Prompt Table: FS_SD_BASE

    2 SD_RECNAME Character(15) VARCHAR2(15) NOT NULL Supplementa Data Record
    3 SD_FLDNAME Character(18) VARCHAR2(18) NOT NULL Field Name
    4 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    5 DESCR100 Character(100) VARCHAR2(100) NOT NULL Length 100 Description