EODC_SD_RECFLD2

(SQL View)
 Index Back

Form SD Unique FieldNames

Listing the SD Unique FieldNames associated to the Form. This is the unique FieldName of the Field on the Form.

SELECT A.SD_RECNAME , B.RECNAME , A.SD_FLDNAME , A.FIELDNAME , 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_SDRCFLD2LG

    • # 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 SD_FLDNAME Character(18) VARCHAR2(18) NOT NULL Field Name
    4 EODC_FIELDNAME Character(18) VARCHAR2(18) NOT NULL Component FieldName

    Prompt Table: %EDITTABLE3

    5 LABEL18 Character(18) VARCHAR2(18) NOT NULL Label
    6 FORM_LONG_LABEL Character(100) VARCHAR2(100) NOT NULL Long Label