GPIT_SQR_RF_LST

(SQL Table)
 Index Back

List Rec Fields for Sqr Form

List 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 PAGE_NUM Number(4,0) SMALLINT NOT NULL Page #
3 GPIT_BOX_ID Character(8) VARCHAR2(8) NOT NULL Box ID
4 GPIT_LIST_ITEM_ID Character(8) VARCHAR2(8) NOT NULL List Item ID
5 DESCR Character(30) VARCHAR2(30) NOT NULL Description
6 RECNAME Character(15) VARCHAR2(15) NOT NULL Record (Table) Name (see PSRECDEFN).

Prompt Table: PSRECDEFN

7 FIELDNAME Character(18) VARCHAR2(18) NOT NULL Field Name (see PSDBFIELD).

Prompt Table: PSRECFIELDALL

8 GPIT_LINE_INT_LIT Number(3,0) SMALLINT NOT NULL Line
9 GPIT_COL_INT_LIT Number(3,0) SMALLINT NOT NULL Column
10 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
11 GPIT_PRINT_MASK Character(20) VARCHAR2(20) NOT NULL Print Mask
12 GPIT_LINE_LENG_LIT Number(3,0) SMALLINT NOT NULL Line Length
13 GPIT_MAX_LINES_LIT Number(3,0) SMALLINT NOT NULL Max Lines
14 GPIT_FONT Number(2,0) SMALLINT NOT NULL Font
15 GPIT_FONT_SIZE Number(5,1) DECIMAL(4,1) NOT NULL Font Size
16 GPIT_LINESPACE Number(3,0) SMALLINT NOT NULL Line Space
17 GPIT_BREAK_LIST Character(1) VARCHAR2(1) NOT NULL Break List
18 DESCRLONG Long Character CLOB Long Description