EODC_SDRCFLD_LG

(SQL View)
Index Back

Form FieldNames to store data

Listing the Form Fieldnames in which the form field data is being stored.

SELECT A.SD_RECNAME , B.RECNAME , A2.FIELDNAME , A.LANGUAGE_CD , A.LABEL18 , CASE WHEN A.FORM_LONG_LABEL <> ' ' THEN A.FORM_LONG_LABEL ELSE A.LABEL18 END FROM PS_FS_SD_RECFLD_LG A , PS_FS_SD_RECFLD A2 , PS_FS_SD_REC B WHERE A.SD_RECNAME = B.SD_RECNAME AND A.SD_RECNAME = A2.SD_RECNAME AND A.SD_FLDNAME = A2.SD_FLDNAME

  • Related Language Record for EODC_SD_RECFLD
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 SD_RECNAME Character(15) VARCHAR2(15) NOT NULL Supplementa Data Record
    2 EODC_PNGR_RECNAME Character(15) VARCHAR2(15) NOT NULL Component Record Name
    3 EODC_FIELDNAME Character(18) VARCHAR2(18) NOT NULL Component FieldName
    4 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    5 LABEL18 Character(18) VARCHAR2(18) NOT NULL Label
    6 FORM_LONG_LABEL Character(100) VARCHAR2(100) NOT NULL Long Label