GP_ED_SET_DTL

(SQL Table)
 Index Back

Setup by Element Detail

Setup by Element Detail Table

  • Related Language Record: GP_ED_DTL_LNG

  • Parent record: GP_ED_SETUP

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

    Default Value: GP_ED_SETUP.COUNTRY

    2 PIN_NUM Number(8,0) INTEGER NOT NULL PIN Number
    3 PIN_ELEM_NUM Number(8,0) INTEGER NOT NULL Element Number

    Prompt Table: %GP_EDIT_FLD2

    4 SEQNUM Number(3,0) SMALLINT NOT NULL Sequence Number
    5 ENTRY_TYPE_ELEM2 Character(3) VARCHAR2(3) NOT NULL Entry (element) type field

    Default Value: VR7

    Prompt Table: %GP_EDIT_FLD3

    6 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
    7 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

    Default Value: 20

    8 PROMPTVIEW Character(18) VARCHAR2(18) NOT NULL Element Entry Prompt View

    Prompt Table: %GP_EDIT_FLD1

    9 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
    10 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

    Default Value: 30

    11 GP_ED_LABEL Character(30) VARCHAR2(30) NOT NULL User Field 1-Label, this label will be displayed in the E/D Assignment Pages
    12 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