FORM_COLLATE_VW (SQL View)	Index Back
Form Collate View View form data by collate key.

FORM_COLLATE_VW

(SQL View)

Form Collate View

View form data by collate key.

SELECT A.FORM_PROC_INST ,A.FORM_COLLATE_KEY ,A.FORM_GROUP_SEQ ,B.DESCR ,B.EXPIRATION_DATE ,A.FORM_GROUP_ID ,A.FORM_INPUT_INST ,B.FORM_PRINT_DATE FROM PS_FORM_COLLATEGRP A , PS_FORM_INSTANCES B WHERE A.FORM_PROC_INST = B.FORM_PROC_INST

Related Language Record: FORMCOLLATEVWLN

# 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_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.

3 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.

4 DESCR Character(30) VARCHAR2(30) NOT NULL Description

5 EXPIRATION_DATE Date(10) DATE Expiration Date

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

7 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.

8 FORM_PRINT_DATE Date(10) DATE The date that the form is printed.

#	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_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.
3	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.
4	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description
5	EXPIRATION_DATE	Date(10)	DATE	Expiration Date
6	FORM_GROUP_ID	Character(18)	VARCHAR2(18) NOT NULL	Form Group ID groups forms together. Prompt Table: FORM_GROUP_TBL
7	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.
8	FORM_PRINT_DATE	Date(10)	DATE	The date that the form is printed.