GPIN_NRP_BRK_VW

(SQL View)
 Index Back

NRP for Generic Report Breaks

Non Rules Package View for GP_GENRPT_BKLVL

SELECT A.GP_GENRPT_BRK_LVL ,A.DESCR ,A.PIN_NUM +50000000 ,A.DATA_TYPE_CD ,A.ENTRY_TYPE_ID ,A.RECNAME ,A.FIELDNAME FROM PS_GPIN_PR_BRK_LVL A

  • Related Language Record: GP_GENRPT_BKLNG

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 GP_GENRPT_BRK_LVL Character(2) VARCHAR2(2) NOT NULL Break Level Code
    2 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    3 PIN_NUM Number(8,0) INTEGER NOT NULL PIN Number

    Prompt Table: %GP_EDIT_FLD7

    4 DATA_TYPE_CD Character(1) VARCHAR2(1) NOT NULL Data Type Code
    N=Customer Data
    S=Sample Data
    Y=System Data
    5 ENTRY_TYPE_ID Character(3) VARCHAR2(3) NOT NULL Element Entry Type ID

    Prompt Table: GP_ENT_GRBRK_VW

    6 RECNAME Character(15) VARCHAR2(15) NOT NULL Record (Table) Name (see PSRECDEFN).

    Prompt Table: GP_PSRECDEFN_VW

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

    Prompt Table: GP_FIELDNAME_VW