FORM_DATA (SQL Table)	Index Back
Form Data Tracks each instance of a form field name within a FORM_PROC_INST. Used by the Forms Engine to store form data.

FORM_DATA

(SQL Table)

Form Data

Tracks each instance of a form field name within a FORM_PROC_INST. Used by the Forms Engine to store 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_NAME Character(18) VARCHAR2(18) NOT NULL Form Name is the unique id of the form. This corresponds to a page name.
Prompt Table: FORM_TBL

6 FORM_FIELD_LTYPE Character(4) VARCHAR2(4) NOT NULL Form Field Length Type indicates which child form data table contains the data, depending on the length type (xlat).
C040=Char 40
C128=Char 128
C254=Char 254
CLNG=Char Long

7 FORM_FIELD_C040 Character(40) VARCHAR2(40) NOT NULL Form field char 40 holds all 40 char or less fields to be placed onto a form.

#	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_NAME	Character(18)	VARCHAR2(18) NOT NULL	Form Name is the unique id of the form. This corresponds to a page name. Prompt Table: FORM_TBL
6	FORM_FIELD_LTYPE	Character(4)	VARCHAR2(4) NOT NULL	Form Field Length Type indicates which child form data table contains the data, depending on the length type (xlat). C040=Char 40 C128=Char 128 C254=Char 254 CLNG=Char Long
7	FORM_FIELD_C040	Character(40)	VARCHAR2(40) NOT NULL	Form field char 40 holds all 40 char or less fields to be placed onto a form.