GP_GENRPT_TBL

(SQL Table)
 Index Back

Generic Report Setup

Main record for the generic report setup

  • Related Language Record: GP_GENRPT_LNG

  • Parent Record Of GP_GENRPT_ROW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 GP_GENRPT_ID Character(10) VARCHAR2(10) NOT NULL Code of the generic report
    2 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    3 GP_GENRPT_TYPE Character(2) VARCHAR2(2) NOT NULL Pre-defined generic reports type
    10=List
    20=Summary
    30=Accumulators

    Default Value: 10

    4 GP_GENRPT_BRK_LVL1 Character(2) VARCHAR2(2) NOT NULL Break Code for Level 1

    Prompt Table: GP_GENRPT_BKLVL

    5 GP_GENRPT_PG_BRK1 Character(1) VARCHAR2(1) NOT NULL Indicates if a page break must be done or not

    Y/N Table Edit

    Default Value: N

    6 GP_GENRPT_BRK_LVL2 Character(2) VARCHAR2(2) NOT NULL Break Code for Level 2

    Prompt Table: GP_GENRPT_BKLVL

    7 GP_GENRPT_PG_BRK2 Character(1) VARCHAR2(1) NOT NULL Indicates if a page break must be done or not

    Y/N Table Edit

    Default Value: N

    8 GP_GENRPT_BRK_LVL3 Character(2) VARCHAR2(2) NOT NULL Break Code for Level 3

    Prompt Table: GP_GENRPT_BKLVL

    9 GP_GENRPT_PG_BRK3 Character(1) VARCHAR2(1) NOT NULL Indicates if a page break must be done or not

    Y/N Table Edit

    Default Value: N

    10 GP_GENRPT_PG_BRK4 Character(1) VARCHAR2(1) NOT NULL Indicates if a page break must be done or not

    Y/N Table Edit

    Default Value: N

    11 GP_GENRPT_SORT_OPT Character(2) VARCHAR2(2) NOT NULL Sort option for generic reports
    10=Employee ID, Employee Rcd Nbr
    20=Name, Employee Rcd Nbr

    Default Value: 10

    12 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code

    Prompt Table: CURRENCY_CD_TBL

    13 GP_GENRPT_NULL Character(1) VARCHAR2(1) NOT NULL Hide Null Lines

    Y/N Table Edit

    Default Value: N