FS_SD_FORM_VW

(SQL View)
 Index Back

Display Group

Used in Form Wizard

SELECT A.SD_GRP_NAME ,A.SD_RECNAME ,A.SD_FLDNAME ,A.SD_GRP_COL ,A.SEQ_NUM ,B.LABEL18 ,B.SD_FLD_STATUS ,B.SD_FLDTYPE ,B.SD_FLDLEN ,B.FIELDNAME ,B.PROMPT_RECNAME ,B.BUS_UNIT_FIELD ,B.SETID ,B.FORM_LONG_LABEL ,B.SD_FLD_REQUIRED ,B.EOSD_INSTR ,B.EOSD_UPPER_CASE ,B.DESCR100 FROM PS_FS_SD_GRPFLD A , PS_FS_SD_RECFLD B WHERE A.SD_RECNAME = B.SD_RECNAME AND A.SD_FLDNAME = B.SD_FLDNAME

  • Related Language Record: FS_SD_FORM_LVW

    • # 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
    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
    7 SD_FLD_STATUS Character(1) VARCHAR2(1) NOT NULL Supplemental data field status
    A=Activated
    D=In Design

    Default Value: D

    8 SD_FLDTYPE Character(1) VARCHAR2(1) NOT NULL Use Type
    C=Code
    D=Date
    F=Yes/No
    L=Section
    M=Time
    N=Number
    P=Prompt
    S=Signed Number
    T=Text
    9 SD_FLDLEN Character(4) VARCHAR2(4) NOT NULL Field Length
    1=1
    10=10
    15=15
    15.4=15.4
    20=20
    254=254
    30=30
    4=4
    5=5
    50=50
    7.2=7.2
    9=9
    10 FIELDNAME Character(18) VARCHAR2(18) NOT NULL Field Name (see PSDBFIELD).

    Prompt Table: FS_SD_NONKEYFLD

    11 PROMPT_RECNAME Character(15) VARCHAR2(15) NOT NULL Prompt record name in Chart field template Prompt record name in Form and Approval Builder
    12 BUS_UNIT_FIELD Character(18) VARCHAR2(18) NOT NULL Business Unit Field
    13 SETID Character(5) VARCHAR2(5) NOT NULL SetID
    14 FORM_LONG_LABEL Character(100) VARCHAR2(100) NOT NULL Long Label
    15 SD_FLD_REQUIRED Character(1) VARCHAR2(1) NOT NULL Field Required
    16 EOSD_INSTR Long Character CLOB Instructions
    17 EOSD_UPPER_CASE Character(1) VARCHAR2(1) NOT NULL Uppercase
    N=N
    Y=Y
    18 DESCR100 Character(100) VARCHAR2(100) NOT NULL Length 100 Description