GPIT_SQR_RF_FOO(SQL Table) |
Index Back |
---|---|
Footer Rec Fields for Sqr FormFooter Rec Fields for Sqr Form |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | PRCSJOBNAME | Character(8) | VARCHAR2(8) NOT NULL | Process Job Name |
2 | GPIT_BOX_ID | Character(8) | VARCHAR2(8) NOT NULL | Box ID |
3 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
4 | RECNAME | Character(15) | VARCHAR2(15) NOT NULL |
Record (Table) Name (see PSRECDEFN).
Prompt Table: PSRECDEFN |
5 | FIELDNAME | Character(18) | VARCHAR2(18) NOT NULL |
Field Name (see PSDBFIELD).
Prompt Table: PSRECFIELDALL |
6 | GPIT_LINE_INT_LIT | Number(3,0) | SMALLINT NOT NULL | Line |
7 | GPIT_COL_INT_LIT | Number(3,0) | SMALLINT NOT NULL | Column |
8 | 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 |
9 | GPIT_PRINT_MASK | Character(20) | VARCHAR2(20) NOT NULL | Print Mask |
10 | GPIT_LINE_LENG_LIT | Number(3,0) | SMALLINT NOT NULL | Line Length |
11 | GPIT_MAX_LINES_LIT | Number(3,0) | SMALLINT NOT NULL | Max Lines |
12 | GPIT_FONT | Number(2,0) | SMALLINT NOT NULL | Font |
13 | GPIT_FONT_SIZE | Number(5,1) | DECIMAL(4,1) NOT NULL | Font Size |
14 | GPIT_LINESPACE | Number(3,0) | SMALLINT NOT NULL | Line Space |
15 | GPIT_BREAK_LIST | Character(1) | VARCHAR2(1) NOT NULL | Break List |
16 | DESCRLONG | Long Character | CLOB | Long Description |