FORM_NAMEEFFDTDefault Value: %date
A=Active
I=Inactive
Default Value: A
MANL=Manually Entered
PAGE=Page Definition
Default Value: MANL
Default Value: 612
Default Value: 792
Y/N Table Edit
Default Value: Y
FORM_TBL(SQL Table) |
Index Back |
|---|---|
Form TableForms for printing via the Forms Engine. |
| # | 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. |
| 2 | EFFDT |
Date(10) | DATE NOT NULL |
Effective Date
Default Value: %date |
| 3 | EFF_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Effective Status
A=Active I=Inactive Default Value: A |
| 4 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 5 | FORM_SOURCE | Character(4) | VARCHAR2(4) NOT NULL |
Form Source indicates the origin of a Form layout definition.
MANL=Manually Entered PAGE=Page Definition Default Value: MANL |
| 6 | RELATED_PAGE_NAME | Character(18) | VARCHAR2(18) NOT NULL | The name of the online page from which this form page is derived. |
| 7 | LAST_IMPORT_DTTM | DateTime(26) | TIMESTAMP | The datetime that this form's contents were imported from the source specified by the FORM_SOURCE field. |
| 8 | FORM_BKCOLOR_RED | Number(9,7) | DECIMAL(8,7) NOT NULL | Background color, red component. |
| 9 | FORM_BKCOLOR_GREEN | Number(9,7) | DECIMAL(8,7) NOT NULL | Background color, green component. |
| 10 | FORM_BKCOLOR_BLUE | Number(9,7) | DECIMAL(8,7) NOT NULL | Background color, blue component. |
| 11 | FORM_IMAGE_NAME | Character(30) | VARCHAR2(30) NOT NULL | Form Image Name is the name of an image to be placed onto a form. |
| 12 | FORM_WIDTH | Number(4,0) | SMALLINT NOT NULL |
Width of the form in units of 1/72 of an inch.
Default Value: 612 |
| 13 | FORM_HEIGHT | Number(4,0) | SMALLINT NOT NULL |
Height of the form in units of 1/72 of an inch.
Default Value: 792 |
| 14 | LAST_FORM_FIELDNBR | Number(4,0) | SMALLINT NOT NULL | Last form field number. See FORM_FIELD_NBR. |
| 15 | SETPAGEDEVICE | Character(1) | VARCHAR2(1) NOT NULL |
Set Page Device is a Y/N indicator. If Y then the postscript for a page sends the setpagedevice command to the printer every time that the page is printed. If it is N, then it never sends the setpagedevice postscript command. It is important to not send a setpagedevice command when printing the second page of a duplex page. If you do, then the 2nd page does not come out duplex, if duplex was specified.
This field is used by the FORMS ENGINE.
Y/N Table Edit Default Value: Y |