GP_NRP_ESD_AD

(SQL Table)
 Index Back

Setup by Element Detail

Setup by Element Detail Table

  • Related Language Record: GP_NRP_LDT_AD

  • Parent record: GP_ED_SETUP

    • # 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 PIN_NUM Number(8,0) INTEGER NOT NULL PIN Number
    4 PIN_ELEM_NUM Number(8,0) INTEGER NOT NULL Element Number
    5 SEQNUM Number(3,0) SMALLINT NOT NULL Sequence Number
    6 ENTRY_TYPE_ELEM2 Character(3) VARCHAR2(3) NOT NULL Entry (element) type field
    7 GP_ED_REQUIRED Character(2) VARCHAR2(2) NOT NULL Indicates whether something is required for ED assignment, for PI or for both. Has translate values
    10=Both
    20=Element Assignment
    30=Positive Input
    8 GP_EDITTYPE Character(2) VARCHAR2(2) NOT NULL Used for the Edit Type in Elemet setup page
    10=Prompt
    20=No Prompt
    30=Yes / No
    40=Xlat Value
    9 PROMPTVIEW Character(18) VARCHAR2(18) NOT NULL Element Entry Prompt View
    10 FLD_FMT Character(1) VARCHAR2(1) NOT NULL Field format for Global Payroll elements
    1=Character
    2=Date
    3=Monetary
    4=Decimal
    5=Element Pointer
    6=Not Applicable
    11 GP_LABEL_TYPE_D Character(2) VARCHAR2(2) NOT NULL Label Type D is used for labeling SOVR on configurable ED and PI pages.
    10=Static Text
    20=Use Element Name
    30=Use Description
    12 GP_ED_LABEL Character(30) VARCHAR2(30) NOT NULL User Field 1-Label, this label will be displayed in the E/D Assignment Pages
    13 GP_OVRD_TYPE Character(2) VARCHAR2(2) NOT NULL Indicates whether an override is used in Positive Input, ED Assignment or Both
    10=Both
    20=Element Assignment
    30=Positive Input