GPIT_SQR_RF_FOO

(SQL Table)
Index Back

Footer Rec Fields for Sqr Form

Footer 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