FORM_LINE (SQL Table)	Index Back
Form Line Definition of a line on a Form.

FORM_LINE

(SQL Table)

Form Line

Definition of a line on a Form.

Parent record: FORM_DTL

# 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.
Prompt Table: FORM_DTL

4 LINE_THICKNESS Number(4,0) SMALLINT NOT NULL Line Thickness indicates the thickness of a line in units of 1/72 of an inch.

5 FORM_COLOR_RED Number(9,7) DECIMAL(8,7) NOT NULL Form RGB color red is a number between zero and one inclusive indicating the portion of the color that is red. See setrgbcolor postscript command for details.

6 FORM_COLOR_GREEN Number(9,7) DECIMAL(8,7) NOT NULL Form RGB color green is a number between zero and one inclusive indicating the portion of the color that is green. See setrgbcolor postscript command for details.

7 FORM_COLOR_BLUE Number(9,7) DECIMAL(8,7) NOT NULL Form RGB color blue is a number between zero and one inclusive indicating the portion of the color that is blue. See setrgbcolor postscript command for details.

8 SETDASH_PARM Character(8) VARCHAR2(8) NOT NULL Postscript setdash parameter value, passed directly to postscript. i.e.: ' ' (blank) means a solid line. '[] 0' also means a solid line. '[3] 0' means a dashed line. '[1] 0' means a dotted line.

9 START_X Number(4,0) SMALLINT NOT NULL Form object start position, X coordinate in the postscript (X,Y) cartesian system wherein (0,0) is the lower left corner and X goes positively to the right in units of 1/72 of an inch.

10 START_Y Number(4,0) SMALLINT NOT NULL Form object start position, Y coordinate in the postscript (X,Y) cartesian system wherein (0,0) is the lower left corner and Y goes positively upward in units of 1/72 of an inch.

11 END_X Number(4,0) SMALLINT NOT NULL Form object end position, X coordinate in the postscript (X,Y) cartesian system wherein (0,0) is the lower left corner and X goes positively to the right in units of 1/72 of an inch.

12 END_Y Number(4,0) SMALLINT NOT NULL Form object end position, Y coordinate in the postscript (X,Y) cartesian system wherein (0,0) is the lower left corner and Y goes positively upward in units of 1/72 of an inch.

#	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. Prompt Table: FORM_DTL
4	LINE_THICKNESS	Number(4,0)	SMALLINT NOT NULL	Line Thickness indicates the thickness of a line in units of 1/72 of an inch.
5	FORM_COLOR_RED	Number(9,7)	DECIMAL(8,7) NOT NULL	Form RGB color red is a number between zero and one inclusive indicating the portion of the color that is red. See setrgbcolor postscript command for details.
6	FORM_COLOR_GREEN	Number(9,7)	DECIMAL(8,7) NOT NULL	Form RGB color green is a number between zero and one inclusive indicating the portion of the color that is green. See setrgbcolor postscript command for details.
7	FORM_COLOR_BLUE	Number(9,7)	DECIMAL(8,7) NOT NULL	Form RGB color blue is a number between zero and one inclusive indicating the portion of the color that is blue. See setrgbcolor postscript command for details.
8	SETDASH_PARM	Character(8)	VARCHAR2(8) NOT NULL	Postscript setdash parameter value, passed directly to postscript. i.e.: ' ' (blank) means a solid line. '[] 0' also means a solid line. '[3] 0' means a dashed line. '[1] 0' means a dotted line.
9	START_X	Number(4,0)	SMALLINT NOT NULL	Form object start position, X coordinate in the postscript (X,Y) cartesian system wherein (0,0) is the lower left corner and X goes positively to the right in units of 1/72 of an inch.
10	START_Y	Number(4,0)	SMALLINT NOT NULL	Form object start position, Y coordinate in the postscript (X,Y) cartesian system wherein (0,0) is the lower left corner and Y goes positively upward in units of 1/72 of an inch.
11	END_X	Number(4,0)	SMALLINT NOT NULL	Form object end position, X coordinate in the postscript (X,Y) cartesian system wherein (0,0) is the lower left corner and X goes positively to the right in units of 1/72 of an inch.
12	END_Y	Number(4,0)	SMALLINT NOT NULL	Form object end position, Y coordinate in the postscript (X,Y) cartesian system wherein (0,0) is the lower left corner and Y goes positively upward in units of 1/72 of an inch.