GP_NRP_RSADM_VW

(SQL View)
 Index Back

Admin Results Setup Detail NRP

Non Rules Packager View of Payee Detail Fields for Administrator Results Summary Page

SELECT A.COUNTRY ,A.GP_ELN_SET ,A.SEQ_NO ,A.GP_RSLT_ADM_FLDTYP ,A.GP_RSLT_ADM_PMTKEY ,A.ENTRY_TYPE_ID ,A.PIN_NUM +50000000 ,A.GP_RSLT_ADM_LBLTYP ,A.DESCR ,A.MESSAGE_SET_NBR ,A.MESSAGE_NBR ,A.RECNAME ,A.FIELDNAME ,A.SYSPIN_SETID_IND FROM PS_GP_RSLT_ADM_DTL A

  • Related Language Record: GP_NRP_RSAD_LNG

  • Parent record: GP_RSLT_ADM_SET

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 COUNTRY Character(3) VARCHAR2(3) NOT NULL Country

    Prompt Table: GP_COUNTRY

    2 GP_ELN_SET Character(15) VARCHAR2(15) NOT NULL Element Set
    3 SEQ_NO Number(2,0) SMALLINT NOT NULL Sequence Number
    4 GP_RSLT_ADM_FLDTYP Character(2) VARCHAR2(2) NOT NULL The type of Payee Detail field defined for the Administrator Summary page.
    01=Payment Key
    02=Absence/Payroll Results
    5 GP_RSLT_ADM_PMTKEY Character(2) VARCHAR2(2) NOT NULL This field defines which payment key will be displayed in the Payee Details grid on the Administrator Results Summary page.
    01=Payment Key 1
    02=Payment Key 2
    03=Payment Key 3
    04=Payment Key 4
    6 ENTRY_TYPE_ID Character(3) VARCHAR2(3) NOT NULL Element Entry Type ID

    Prompt Table: GP_ENT_GRBRK_VW

    7 PIN_NUM Number(8,0) INTEGER NOT NULL PIN Number

    Prompt Table: %GP_EDIT_FLD7

    8 GP_RSLT_ADM_LBLTYP Character(2) VARCHAR2(2) NOT NULL Defines what to use as label in result adminstrator view. Has XLATs
    01=Element Name
    02=Element Description
    03=Message Catalog
    04=Text
    9 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    10 MESSAGE_SET_NBR Number(5,0) INTEGER NOT NULL Message Set Number. This field refers to the Message Set Number in the Message Catalog.

    Prompt Table: PSMSGSETDEFN

    11 MESSAGE_NBR Number(5,0) INTEGER NOT NULL Message Number. This field refers to the Message Number in the Message Catalog.

    Prompt Table: PSMSGCATDEFN

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

    Prompt Table: GP_PSRECDEFN_VW

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

    Prompt Table: GP_FIELDNAME_VW

    14 SYSPIN_SETID_IND Character(1) VARCHAR2(1) NOT NULL SetID Controlled

    Y/N Table Edit

    Default Value: N