GPIT_SQR_RF_TBL(SQL Table) | 
Index Back | 
|---|---|
Body Record Fields for SqrFormBody Record Fields for SqrForm | 
| # | 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 | RECNAME | Character(15) | VARCHAR2(15) NOT NULL | 
Record (Table) Name (see PSRECDEFN).
 Prompt Table: PSRECDEFN  | 
| 6 | FIELDNAME | Character(18) | VARCHAR2(18) NOT NULL | 
Field Name (see PSDBFIELD).
 Prompt Table: PSRECFIELDALL  | 
| 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 |