FORM_DATA_LONG

(SQL Table)
Index Back

Form Data Long

Holds all long varchar fields on a form.

  • Parent record: FORM_DATA
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 FORM_PROC_INST Number(31,0) DECIMAL(31) NOT NULL Form Process Instance collects one or more input jobs (or process instances) into a single output collection for processing. Typically, one form process instance is one batch of output to be printed together.

    Prompt Table: FORM_INSTANCES

    2 FORM_GROUP_SEQ Number(9,0) DECIMAL(9) NOT NULL Form Group Sequence enables the sequencing of form groups within a FORM_PROC_INST. Each time a group of forms begins to print, this value is incremented and stays the same within that form group. If the same form group prints again, it is incremented again, so that it is not the same value if the same form group prints twice.
    3 FORM_GROUP_SUB_SEQ Number(7,0) INTEGER NOT NULL Form Group Sub Sequence is a sequence number within a form group, one per form. When a new form group begins to print, this sequence number starts back at one.
    4 FORM_FIELD_NAME Character(18) VARCHAR2(18) NOT NULL Form Field Name corresponds to a page field name, only for a printed form instead of an online page.
    5 FORM_FIELD_LONG Long Character CLOB Forms Engine field to hold a long varchar.