FORM_DTL (SQL Table)	Index Back
Form Detail List of objects on the form.

FORM_DTL

(SQL Table)

Form Detail

List of objects on the form.

Parent record: FORM_TBL

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 FORM_NAME Character(18) VARCHAR2(18) NOT NULL Form Name is the unique id of the form. This corresponds to a page name.
Prompt Table: FORM_TBL

2 EFFDT Date(10) DATE Effective Date
Default Value: %date

3 FORM_FIELD_NBR Number(4,0) SMALLINT NOT NULL Form Field Number identifies on object on the form.

4 FORM_FIELD_TYPE Character(4) VARCHAR2(4) NOT NULL Form Field Type designates the type of object on the form.
BOX=Box
FLD=Data Field
IMAG=Image
LINE=Line
LONG=Long Text
TEXT=Text

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	FORM_NAME	Character(18)	VARCHAR2(18) NOT NULL	Form Name is the unique id of the form. This corresponds to a page name. Prompt Table: FORM_TBL
2	EFFDT	Date(10)	DATE	Effective Date Default Value: %date
3	FORM_FIELD_NBR	Number(4,0)	SMALLINT NOT NULL	Form Field Number identifies on object on the form.
4	FORM_FIELD_TYPE	Character(4)	VARCHAR2(4) NOT NULL	Form Field Type designates the type of object on the form. BOX=Box FLD=Data Field IMAG=Image LINE=Line LONG=Long Text TEXT=Text