EODC_SD_RECFLD

(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 , A.FIELDNAME , A.SD_FLDNAME , A.LABEL18 , CASE WHEN A.FORM_LONG_LABEL <> ' ' THEN A.FORM_LONG_LABEL ELSE A.LABEL18 END FROM PS_FS_SD_RECFLD A , PS_FS_SD_REC B WHERE A.SD_RECNAME = B.SD_RECNAME AND SD_FLD_STATUS='A'

  • Related Language Record: EODC_SDRCFLD_LG

    • # 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

    Prompt Table: %EDITTABLE3

    4 SD_FLDNAME Character(18) VARCHAR2(18) NOT NULL Field Name
    5 LABEL18 Character(18) VARCHAR2(18) NOT NULL Label
    6 FORM_LONG_LABEL Character(100) VARCHAR2(100) NOT NULL Long Label