FA_AWD_INST_VW

(SQL View)

SELECT DISTINCT A.FORM_PROC_INST ,B.DESCR ,B.EXPIRATION_DATE ,B.FORM_PRINT_DATE FROM PS_FORM_COLLATEGRP A , PS_FORM_INSTANCES B WHERE A.FORM_GROUP_ID IN ( SELECT C.FORM_GROUP_ID FROM PS_FANLTR_FORM_TYP C ) AND A.FORM_PROC_INST = B.FORM_PROC_INST

Related Language Record: FAAWDINSTVWLNG

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