FAAWDINSTVWLNG

(SQL View)

SELECT DISTINCT A.FORM_PROC_INST ,B.LANGUAGE_CD ,B.DESCR FROM PS_FORM_COLLATEGRP A , PS_FORM_INST_LNG B WHERE A.FORM_GROUP_ID IN ('FA_AWD_COVER_LTR', 'FA_AWD_NOTIF_LTR', 'FA_AWD_MPNOTE', 'FA_AWD_SHORT_LTR') AND A.FORM_PROC_INST = B.FORM_PROC_INST

Related Language Record for FA_AWD_INST_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.

2 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code

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