GP_ED_SET_DTL_C

(SQL Table)
 Index Back

Setup by Category Detail

Setup by Category Detail Table

  • Related Language Record: GP_ED_DTL_C_LNG

  • Parent record: GP_ED_SETUP_CAT

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 COUNTRY Character(3) VARCHAR2(3) NOT NULL Country
    2 PIN_CATEGORY Character(4) VARCHAR2(4) NOT NULL Element Category
    3 ENTRY_TYPE_ELEM Character(3) VARCHAR2(3) NOT NULL entry type element
    4 PIN_ELEM_NUM Number(8,0) INTEGER NOT NULL Element Number

    Prompt Table: %GP_EDIT_FLD2

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

    Prompt Table: %GP_EDIT_FLD3

    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

    Default Value: 20

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

    Prompt Table: %GP_EDIT_FLD1

    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

    Default Value: 30

    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