FORM_TEXT_FIELD (SQL Table)	Index Back
Form Text Field Form text field containing a FORM_FIELD_NAME, the contents of which are to be rendered onto a form.

FORM_TEXT_FIELD

(SQL Table)

Form Text Field

Form text field containing a FORM_FIELD_NAME, the contents of which are to be rendered onto 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 FORM_FIELD_NAME Character(18) VARCHAR2(18) NOT NULL Form Field Name corresponds to a page field name, only for a printed form instead of an online page.
Prompt Table: FORM_FIELD_NAME

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

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

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

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

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

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

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

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

13 FORM_FIELD_LENGTH Number(4,0) SMALLINT NOT NULL Form Field Length is the length of a form field 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

#	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	FORM_FIELD_NAME	Character(18)	VARCHAR2(18) NOT NULL	Form Field Name corresponds to a page field name, only for a printed form instead of an online page. Prompt Table: FORM_FIELD_NAME
5	FORM_FONT_NAME	Character(40)	VARCHAR2(40) NOT NULL	Form Font Name Prompt Table: FONT_NAME_TBL
6	FORM_FONT_STYLE	Character(2)	VARCHAR2(2) NOT NULL	Form font style. B=Bold BI=Bold Italic I=Italic NM=Normal Default Value: NM
7	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.
8	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.
9	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.
10	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.
11	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.
12	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.
13	FORM_FIELD_LENGTH	Number(4,0)	SMALLINT NOT NULL	Form Field Length is the length of a form field 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