FORM_TEXT_LONG (SQL Table)	Index Back
Form Text Long Form text long specifies a long variable character literal to be placed onto a form.

FORM_TEXT_LONG

(SQL Table)

Form Text Long

Form text long specifies a long variable character literal to be placed onto a form.

Related Language Record: FORM_TXLONG_LNG

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 FORM_FIELD_NBR Number(4,0) SMALLINT NOT NULL Form Field Number identifies on object on the form.
Prompt Table: FORM_DTL

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

4 FORM_FONT_NAME Character(40) VARCHAR2(40) NOT NULL Form Font Name
Prompt Table: FONT_NAME_TBL

5 FORM_FONT_STYLE Character(2) VARCHAR2(2) NOT NULL Form font style.
B=Bold
BI=Bold Italic
I=Italic
NM=Normal
Default Value: NM

6 FORM_FIELD_SCALE Number(4,0) SMALLINT NOT NULL Form field scaling factor. Multiplies the regular size of an object by this scaling factor when rendering the object on a form.

7 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.

8 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.

9 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.

10 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.

11 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.

12 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.

13 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.

14 FORM_LINE_SPACING Number(3,0) SMALLINT NOT NULL Form Line Spacing holds the number of vertical units between wrapped text lines. A unit is 1/72 of an inch. When a line wraps, this indicates where the next line starts. It should usually be 20 percent more than the font size. e.g. if the font size is 12, the spacing should be 14.

15 FORM_JUSTIFICATION Character(2) VARCHAR2(2) NOT NULL Form Field Justification.
C=Centered
L=Left
LR=Left and Right
R=Right
Default Value: L

16 FORM_TEXT_LONG Long Character CLOB NOT NULL Form Long Text is a long text literal to be placed onto a form. Form text may have imbedded form_field_name values within it. If they are, then they are bracketted by % before and after. A double % displays as a single percent.

#	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	FORM_FIELD_NBR	Number(4,0)	SMALLINT NOT NULL	Form Field Number identifies on object on the form. Prompt Table: FORM_DTL
3	EFFDT	Date(10)	DATE	Effective Date Default Value: %date
4	FORM_FONT_NAME	Character(40)	VARCHAR2(40) NOT NULL	Form Font Name Prompt Table: FONT_NAME_TBL
5	FORM_FONT_STYLE	Character(2)	VARCHAR2(2) NOT NULL	Form font style. B=Bold BI=Bold Italic I=Italic NM=Normal Default Value: NM
6	FORM_FIELD_SCALE	Number(4,0)	SMALLINT NOT NULL	Form field scaling factor. Multiplies the regular size of an object by this scaling factor when rendering the object on a form.
7	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.
8	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.
9	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.
10	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.
11	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.
12	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.
13	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.
14	FORM_LINE_SPACING	Number(3,0)	SMALLINT NOT NULL	Form Line Spacing holds the number of vertical units between wrapped text lines. A unit is 1/72 of an inch. When a line wraps, this indicates where the next line starts. It should usually be 20 percent more than the font size. e.g. if the font size is 12, the spacing should be 14.
15	FORM_JUSTIFICATION	Character(2)	VARCHAR2(2) NOT NULL	Form Field Justification. C=Centered L=Left LR=Left and Right R=Right Default Value: L
16	FORM_TEXT_LONG	Long Character	CLOB NOT NULL	Form Long Text is a long text literal to be placed onto a form. Form text may have imbedded form_field_name values within it. If they are, then they are bracketted by % before and after. A double % displays as a single percent.