GPIT_SQR_RF_TBL

(SQL Table)
Index Back

Body Record Fields for SqrForm

Body 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