FS_SD_GLC_VW

(SQL View)
Index Back

Display Group Left Column

Supplemental data display group left column fields.

SELECT A.SD_GRP_NAME ,A.SD_RECNAME ,A.SD_FLDNAME ,A.SD_GRP_COL ,A.SEQ_NUM ,A.LABEL18 FROM PS_FS_SD_GRPFLD A WHERE A.SD_GRP_COL = 'L'

  • Related Language Record: FS_SD_GRPFLD_LG
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 SD_GRP_NAME Character(20) VARCHAR2(20) NOT NULL Display Group
    2 SD_RECNAME Character(15) VARCHAR2(15) NOT NULL Supplementa Data Record

    Prompt Table: FS_SD_REC_VW

    3 SD_FLDNAME Character(18) VARCHAR2(18) NOT NULL Field Name

    Prompt Table: FS_SD_FLD_VW

    4 SD_GRP_COL Character(1) VARCHAR2(1) NOT NULL Column
    L=Left Column
    R=Right Column

    Default Value: L

    5 SEQ_NUM Number(3,0) SMALLINT NOT NULL Sequence

    Default Value: 1

    6 LABEL18 Character(18) VARCHAR2(18) NOT NULL Label