FS_SD_FORM_R_VW

(SQL View)
 Index Back

Supplemental Data Field

Supplemental data field. Used in Form Wizard. Bridge View.

SELECT SD_RECNAME , SD_FLDNAME , DESCR100 , LABEL18 , SD_FLD_STATUS , SD_FLDTYPE , SD_FLDLEN , FIELDNAME , PROMPT_RECNAME , BUS_UNIT_FIELD , SETID , FORM_LONG_LABEL , SD_FLD_REQUIRED , EOSD_INSTR , EOSD_UPPER_CASE FROM PS_FS_SD_RECFLD

  • Related Language Record: FS_SD_RECFLD_LG

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 SD_RECNAME Character(15) VARCHAR2(15) NOT NULL Supplementa Data Record
    2 SD_FLDNAME Character(18) VARCHAR2(18) NOT NULL Field Name
    3 DESCR100 Character(100) VARCHAR2(100) NOT NULL Length 100 Description
    4 LABEL18 Character(18) VARCHAR2(18) NOT NULL Label
    5 SD_FLD_STATUS Character(1) VARCHAR2(1) NOT NULL Supplemental data field status
    A=Activated
    D=In Design

    Default Value: D

    6 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
    7 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
    8 FIELDNAME Character(18) VARCHAR2(18) NOT NULL Field Name (see PSDBFIELD).

    Prompt Table: FS_SD_NONKEYFLD

    9 PROMPT_RECNAME Character(15) VARCHAR2(15) NOT NULL Prompt record name in Chart field template Prompt record name in Form and Approval Builder

    Prompt Table: FS_SD_PROMPT_VW

    10 BUS_UNIT_FIELD Character(18) VARCHAR2(18) NOT NULL Business Unit Field
    11 SETID Character(5) VARCHAR2(5) NOT NULL SetID

    Prompt Table: SETID_TBL

    12 FORM_LONG_LABEL Character(100) VARCHAR2(100) NOT NULL Long Label
    13 SD_FLD_REQUIRED Character(1) VARCHAR2(1) NOT NULL Field Required
    14 EOSD_INSTR Long Character CLOB Instructions
    15 EOSD_UPPER_CASE Character(1) VARCHAR2(1) NOT NULL Uppercase
    N=N
    Y=Y

    Default Value: N