FORM_INST_SRCH (SQL View)	Index Back
Form Instance Search Search for a form instance.

FORM_INST_SRCH

(SQL View)

Form Instance Search

Search for a form instance.

SELECT A.FORM_PROC_INST ,A.DESCR ,A.EXPIRATION_DATE ,A.FORM_PRINT_DATE FROM PS_FORM_INSTANCES A

Related Language Record: FORMINSTSRCHLNG

# 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 DESCR Character(30) VARCHAR2(30) NOT NULL Description

3 EXPIRATION_DATE Date(10) DATE Expiration Date

4 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.
2	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description
3	EXPIRATION_DATE	Date(10)	DATE	Expiration Date
4	FORM_PRINT_DATE	Date(10)	DATE	The date that the form is printed.