GP_NRP_RSADM_AD

(SQL Table)
Index Back

Results Setup Detail

Payee Detail Fields for Administrator Results Summary Page

  • Parent record: GP_RSLT_ADM_SET
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 GP_PKG_ID Character(10) VARCHAR2(10) NOT NULL Field used for element packaging
    2 COUNTRY Character(3) VARCHAR2(3) NOT NULL Country
    3 GP_ELN_SET Character(15) VARCHAR2(15) NOT NULL Element Set
    4 SEQ_NO Number(2,0) SMALLINT NOT NULL Sequence Number
    5 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
    6 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
    7 ENTRY_TYPE_ID Character(3) VARCHAR2(3) NOT NULL Element Entry Type ID
    8 PIN_NUM Number(8,0) INTEGER NOT NULL PIN Number
    9 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
    10 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    11 MESSAGE_SET_NBR Number(5,0) INTEGER NOT NULL Message Set Number. This field refers to the Message Set Number in the Message Catalog.
    12 MESSAGE_NBR Number(5,0) INTEGER NOT NULL Message Number. This field refers to the Message Number in the Message Catalog.
    13 RECNAME Character(15) VARCHAR2(15) NOT NULL Record (Table) Name (see PSRECDEFN).
    14 FIELDNAME Character(18) VARCHAR2(18) NOT NULL Field Name (see PSDBFIELD).
    15 SYSPIN_SETID_IND Character(1) VARCHAR2(1) NOT NULL SetID Controlled