GP_NRP_GRPIN_VW

(SQL View)
 Index Back

NRP Generic Report PINs

Non Rules Package View for Generic Report PINs

SELECT A.GP_GENRPT_ID ,A.GP_GENRPT_ROW_NUM ,A.PIN_NUM +50000000 ,A.ENTRY_TYPE_ID ,A.GP_GENRPT_SUB_PIN ,A.GP_GENRPT_LABEL FROM PS_GP_GENRPT_PIN A

  • Related Language Record: GP_RPTPIN_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 GP_GENRPT_ROW_NUM Number(5,0) INTEGER NOT NULL Used as counter for row or column number
    3 PIN_NUM Number(8,0) INTEGER NOT NULL PIN Number

    Prompt Table: %GP_EDIT_FLD7

    4 ENTRY_TYPE_ID Character(3) VARCHAR2(3) NOT NULL Element Entry Type ID

    Prompt Table: GP_ENT_GRPIN_VW

    5 GP_GENRPT_SUB_PIN Character(2) VARCHAR2(2) NOT NULL Indicates if the result must be added or subtract from the elements set
    10=Add
    20=Subtract
    6 GP_GENRPT_LABEL Character(15) VARCHAR2(15) NOT NULL Labels used in different Global Payroll France pages