GPAR_GENRPT_TBL

(SQL Table)
 Index Back

ARG Generic Report Setup

GP ARG Main record for the generic report setup

  • Related Language Record: GPAR_GENRPT_LNG

  • Parent Record Of GPAR_GENRPT_ROW GPAR_RPTROW_LNG

    • # 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 GPAR_RPT_BRK_LVL1 Character(2) VARCHAR2(2) NOT NULL Break Code for Level 1
    CO=Company
    DE=Department
    4 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

    5 GPAR_RPT_BRK_LVL2 Character(2) VARCHAR2(2) NOT NULL Break Code for Level 2
    CO=Company
    DE=Department
    6 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

    7 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

    8 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

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

    Y/N Table Edit

    Default Value: N