FORM_TYPE

(SQL Table)
 Index Back

Form Type

Form Type Form Type field 1) search edit on 2) no prompt defined

  • Related Language Record: FORM_TYPE_LG

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 FORM_TYPE Character(10) VARCHAR2(10) NOT NULL Form and Builder Field
    2 FORM_TYPE_STATUS Character(1) VARCHAR2(1) NOT NULL Status
    A=Application Designer Form
    D=In Design
    I=Inactivated
    S=Supplemental Data Form

    Default Value: D

    3 PORTAL_NAME Character(30) VARCHAR2(30) NOT NULL Portal Name (see PSPRDMDEFN).
    4 PORTAL_LABEL Character(30) VARCHAR2(30) NOT NULL Portal Label
    5 FORM_OWNER_ID Character(30) VARCHAR2(30) NOT NULL Owner Id

    Prompt Table: PSOPRDEFN_VW

    6 EFFDT_FROM Date(10) DATE NOT NULL Effective Date From
    7 EFFDT_TO Date(10) DATE Effective Date To
    8 FORM_INSTRUCTIONS Long Character CLOB Instructions
    9 DESCR254 Character(254) VARCHAR2(254) NOT NULL Description of length 254
    10 PORTAL_OBJNAME Character(30) VARCHAR2(30) NOT NULL Portal Object Name
    11 LONG_LABEL_FLAG Character(1) VARCHAR2(1) NOT NULL Single column style
    12 EOFM_LOCKDOWN Character(1) VARCHAR2(1) NOT NULL Lockdown Options
    1=Do Not Lockdown
    2=Lockdown After Submit
    3=Lockdown After Approval

    Default Value: 1

    13 REPORTING_VIEW Character(15) VARCHAR2(15) NOT NULL Form and Approval Builder Field
    14 CREATED_BY Character(30) VARCHAR2(30) NOT NULL Created By
    15 CREATED_DTTM DateTime(26) TIMESTAMP Created Datetime
    16 LASTUPDOPRID Character(30) VARCHAR2(30) NOT NULL Specifies the User ID which made the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.
    17 LASTUPDDTTM DateTime(26) TIMESTAMP Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.
    18 FLUIDMODE Number(1,0) SMALLINT NOT NULL Fluid Mode

    Default Value: 0