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 | PRCSJOBNAME | Character(8) | VARCHAR2(8) NOT NULL | Process Job Name |
2 | PAGE_NUM | Number(4,0) | SMALLINT NOT NULL | Page # |
3 | GPIT_BOX_ID | 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 |