FORM_ADD_VW (SQL View)	Index Back
Form Add View Form Add View

FORM_ADD_VW

(SQL View)

Form Add View

SELECT SEQ_NBR , FORM_TYPE FROM PS_FORM

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 SEQ_NBR Number(15,0) DECIMAL(15) NOT NULL Sequence Number

2 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
Prompt Table: FORM_TYPE_DVW

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	SEQ_NBR	Number(15,0)	DECIMAL(15) NOT NULL	Sequence Number
2	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 Prompt Table: FORM_TYPE_DVW