FORM_COLLKEY_VW (SQL View)	Index Back
Form Collate Search Search view for a collate key value within a form_proc_inst for the Forms Engine.

FORM_COLLKEY_VW

(SQL View)

Form Collate Search

Search view for a collate key value within a form_proc_inst for the Forms Engine.

SELECT A.FORM_PROC_INST ,B.FORM_COLLATE_KEY FROM PS_FORM_INSTANCES A , PS_FORM_COLLATEGRP B WHERE B.FORM_PROC_INST = A.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.

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.

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