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

FORMCOLLATEVWLN

(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.LANGUAGE_CD ,B.DESCR FROM PS_FORM_COLLATEGRP A , PS_FORM_INST_LNG B WHERE A.FORM_PROC_INST = B.FORM_PROC_INST

Related Language Record for FORM_COLLATE_VW

# 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 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code

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

#	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	LANGUAGE_CD	Character(3)	VARCHAR2(3) NOT NULL	Language Code
5	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description