FORM_TYPE_LVW (SQL View)	Index Back
Form Type View Form Type View

FORM_TYPE_LVW

(SQL View)

Form Type View

SELECT a.form_type ,b.language_cd ,b.portal_label ,b.portal_label ,a.form_owner_id FROM PS_FORM_TYPE a , PS_FORM_TYPE_lg b , PSPRSMDEFNLANG c WHERE a.form_type = b.form_type AND c.portal_objname = a.portal_objname AND c.language_cd = b.language_cd AND c.PORTAL_REFTYPE = 'F'

Related Language Record for FORM_TYPE_VW

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 FORM_TYPE Character(10) VARCHAR2(10) NOT NULL Form and Builder Field
ADV=Remittance Advice Only
CAV=Check with Separate Advice
CRA=Crystal Check w/Advice
CRW=Crystal Check
CSA=Check over Stub with Advice
CSO=Check over Stub with Overflow
EFA=EFT File with Advice
EFT=EFT File
SCA=Stub over Check with Advice
SCO=Stub over Check with Overflow

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

3 PORTAL_LABEL Character(30) VARCHAR2(30) NOT NULL Portal Label

4 PORTAL_LABEL1 Character(30) VARCHAR2(30) NOT NULL Label 1

5 FORM_OWNER_ID Character(30) VARCHAR2(30) NOT NULL Owner Id

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	FORM_TYPE	Character(10)	VARCHAR2(10) NOT NULL	Form and Builder Field ADV=Remittance Advice Only CAV=Check with Separate Advice CRA=Crystal Check w/Advice CRW=Crystal Check CSA=Check over Stub with Advice CSO=Check over Stub with Overflow EFA=EFT File with Advice EFT=EFT File SCA=Stub over Check with Advice SCO=Stub over Check with Overflow
2	LANGUAGE_CD	Character(3)	VARCHAR2(3) NOT NULL	Language Code
3	PORTAL_LABEL	Character(30)	VARCHAR2(30) NOT NULL	Portal Label
4	PORTAL_LABEL1	Character(30)	VARCHAR2(30) NOT NULL	Label 1
5	FORM_OWNER_ID	Character(30)	VARCHAR2(30) NOT NULL	Owner Id