GPIT_SQR_S_TBL(SQL Table) |
Index Back |
|---|---|
Body Strings for Sqr FormBody Strings for Sqr Form |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | Character(8) | VARCHAR2(8) NOT NULL | Process Job Name | |
| 2 | Number(4,0) | SMALLINT NOT NULL | Page # | |
| 3 | Character(8) | VARCHAR2(8) NOT NULL | Box ID | |
| 4 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 5 | PROGRAM_ID | Character(8) | VARCHAR2(8) NOT NULL |
Program ID
Prompt Table: STRINGS_VW |
| 6 | STRING_ID | Character(18) | VARCHAR2(18) NOT NULL |
String ID
Prompt Table: STRINGS_TBL |
| 7 | GPIT_LINE_INT_LIT | Number(3,0) | SMALLINT NOT NULL | Line |
| 8 | GPIT_COL_INT_LIT | Number(3,0) | SMALLINT NOT NULL | Column |
| 9 | GPIT_PRINT_FORMAT | Character(2) | VARCHAR2(2) NOT NULL |
Print Format
15=Shade 16=Underline 17=Wrap 2=Bold 3=Box 4=Center 7=Edit |
| 10 | GPIT_PRINT_MASK | Character(20) | VARCHAR2(20) NOT NULL | Print Mask |
| 11 | GPIT_LINE_LENG_LIT | Number(3,0) | SMALLINT NOT NULL | Line Length |
| 12 | GPIT_MAX_LINES_LIT | Number(3,0) | SMALLINT NOT NULL | Max Lines |
| 13 | GPIT_FONT | Number(2,0) | SMALLINT NOT NULL | Font |
| 14 | GPIT_FONT_SIZE | Number(5,1) | DECIMAL(4,1) NOT NULL | Font Size |
| 15 | GPIT_LINESPACE | Number(3,0) | SMALLINT NOT NULL | Line Space |
| 16 | GPIT_BREAK_LIST | Character(1) | VARCHAR2(1) NOT NULL | Break List |
| 17 | DESCRLONG | Long Character | CLOB | Long Description |