FORM_COLLATEGRP (SQL Table)	Index Back
Form Collate Group Collects and organizes form data of one or more input sets into a single collated output stream.

FORM_COLLATEGRP

(SQL Table)

Form Collate Group

Collects and organizes form data of one or more input sets into a single collated output stream.

# 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_COLLATE_KEY Character(250) VARCHAR2(250) NOT NULL Form Collate Key is the overall sort order key for the output of a set of forms, typically within a single FORM_PROC_INST.

4 FORM_GROUP_ID Character(18) VARCHAR2(18) NOT NULL Form Group ID groups forms together.
Prompt Table: FORM_GROUP_TBL

5 FORM_INPUT_INST Number(10,0) DECIMAL(10) NOT NULL Form Input Instance is the process instance of the job that appended or initially loaded data into a set of output forms being grouped by the same FORM_PROC_INST.

#	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_COLLATE_KEY	Character(250)	VARCHAR2(250) NOT NULL	Form Collate Key is the overall sort order key for the output of a set of forms, typically within a single FORM_PROC_INST.
4	FORM_GROUP_ID	Character(18)	VARCHAR2(18) NOT NULL	Form Group ID groups forms together. Prompt Table: FORM_GROUP_TBL
5	FORM_INPUT_INST	Number(10,0)	DECIMAL(10) NOT NULL	Form Input Instance is the process instance of the job that appended or initially loaded data into a set of output forms being grouped by the same FORM_PROC_INST.