GP_PI_MNL_TMPLT

(SQL Table)
 Index Back

Bulk PI Entry Template

Stores the definition of the templates used in Bulk PI data entry

  • Related Language Record: GP_PI_TMPLT_LNG

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

    Prompt Table: GP_PSLP_CTRY_VW

    2 PI_MNL_TEMPLATE_ID Character(10) VARCHAR2(10) NOT NULL Template ID for GP bulk Positive Input
    3 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    4 ENTRY_TYPE_VAL1 Character(3) VARCHAR2(3) NOT NULL Entry Type for Bracket Value

    Prompt Table: GP_ENT_E_D_VW

    5 PIN_VAL1_NUM Number(8,0) INTEGER NOT NULL Bracket Value Element Number

    Prompt Table: %GP_EDIT_FLD1

    6 PI_MNL_TMPLT_OVR1A Character(2) VARCHAR2(2) NOT NULL Overide type used for built template to enter Bulk Positive Input
    10=Unit
    20=Rate
    30=Amount
    40=Base
    50=Percent
    7 PI_MNL_TMPLT_OVR1B Character(2) VARCHAR2(2) NOT NULL Overide type used for built template to enter Bulk Positive Input
    10=Unit
    20=Rate
    30=Amount
    40=Base
    50=Percent
    8 ENTRY_TYPE_VAL2 Character(3) VARCHAR2(3) NOT NULL Entry Type for Bracket Value

    Prompt Table: GP_ENT_E_D_VW

    9 PIN_VAL2_NUM Number(8,0) INTEGER NOT NULL Bracket Value Element Number

    Prompt Table: %GP_EDIT_FLD2

    10 PI_MNL_TMPLT_OVR2A Character(2) VARCHAR2(2) NOT NULL Overide type used for built template to enter Bulk Positive Input
    10=Unit
    20=Rate
    30=Amount
    40=Base
    50=Percent
    11 PI_MNL_TMPLT_OVR2B Character(2) VARCHAR2(2) NOT NULL Overide type used for built template to enter Bulk Positive Input
    10=Unit
    20=Rate
    30=Amount
    40=Base
    50=Percent
    12 ENTRY_TYPE_VAL3 Character(3) VARCHAR2(3) NOT NULL Entry Type for Bracket Value

    Prompt Table: GP_ENT_E_D_VW

    13 PIN_VAL3_NUM Number(8,0) INTEGER NOT NULL Bracket Value Element Number

    Prompt Table: %GP_EDIT_FLD3

    14 PI_MNL_TMPLT_OVR3A Character(2) VARCHAR2(2) NOT NULL Overide type used for built template to enter Bulk Positive Input
    10=Unit
    20=Rate
    30=Amount
    40=Base
    50=Percent
    15 PI_MNL_TMPLT_OVR3B Character(2) VARCHAR2(2) NOT NULL Overide type used for built template to enter Bulk Positive Input
    10=Unit
    20=Rate
    30=Amount
    40=Base
    50=Percent
    16 ENTRY_TYPE_VAL4 Character(3) VARCHAR2(3) NOT NULL Entry Type for Bracket Value

    Prompt Table: GP_ENT_E_D_VW

    17 PIN_VAL4_NUM Number(8,0) INTEGER NOT NULL Bracket Value Element Number

    Prompt Table: %GP_EDIT_FLD4

    18 PI_MNL_TMPLT_OVR4A Character(2) VARCHAR2(2) NOT NULL Overide type used for built template to enter Bulk Positive Input
    10=Unit
    20=Rate
    30=Amount
    40=Base
    50=Percent
    19 PI_MNL_TMPLT_OVR4B Character(2) VARCHAR2(2) NOT NULL Overide type used for built template to enter Bulk Positive Input
    10=Unit
    20=Rate
    30=Amount
    40=Base
    50=Percent
    20 ENTRY_TYPE_VAL5 Character(3) VARCHAR2(3) NOT NULL Entry Type for Bracket Value

    Prompt Table: GP_ENT_E_D_VW

    21 PIN_VAL5_NUM Number(8,0) INTEGER NOT NULL Bracket Value Element Number

    Prompt Table: %GP_EDIT_FLD5

    22 PI_MNL_TMPLT_OVR5A Character(2) VARCHAR2(2) NOT NULL Overide type used for built template to enter Bulk Positive Input
    10=Unit
    20=Rate
    30=Amount
    40=Base
    50=Percent
    23 PI_MNL_TMPLT_OVR5B Character(2) VARCHAR2(2) NOT NULL Overide type used for built template to enter Bulk Positive Input
    10=Unit
    20=Rate
    30=Amount
    40=Base
    50=Percent
    24 ENTRY_TYPE_VAL6 Character(3) VARCHAR2(3) NOT NULL Entry Type for Bracket Value

    Prompt Table: GP_ENT_E_D_VW

    25 PIN_VAL6_NUM Number(8,0) INTEGER NOT NULL Bracket Value Element Number

    Prompt Table: %GP_EDIT_FLD6

    26 PI_MNL_TMPLT_OVR6A Character(2) VARCHAR2(2) NOT NULL Overide type used for built template to enter Bulk Positive Input
    10=Unit
    20=Rate
    30=Amount
    40=Base
    50=Percent
    27 PI_MNL_TMPLT_OVR6B Character(2) VARCHAR2(2) NOT NULL Overide type used for built template to enter Bulk Positive Input
    10=Unit
    20=Rate
    30=Amount
    40=Base
    50=Percent
    28 BGN_END_DT_YN Character(1) VARCHAR2(1) NOT NULL Begin End Date indicator, used in building the template for Bulk Positive Input

    Y/N Table Edit

    Default Value: N

    29 PIN_SOVR1_NUM Number(8,0) INTEGER NOT NULL SOVR Pin NUmber user to build the template to be used in Bulk Positive Input

    Prompt Table: %GP_EDIT_FLD7

    30 ENTRY_TYPE_SOVR_1 Character(3) VARCHAR2(3) NOT NULL SOVR Entry Type 1 used for building the template for entering Bulk Positive Input

    Prompt Table: GP_ENT_PISOV_VW

    31 SOVR_VAL_TYPE_1 Character(2) VARCHAR2(2) NOT NULL SOVR Value Type use in build up the Template for Bulk Positive Inpput
    32 PIN_SOVR1_SETID Number(3,0) SMALLINT NOT NULL Pin SOVR setid used to build the Template for Bulk Positive Input
    33 SETID_1 Character(5) VARCHAR2(5) NOT NULL Setid used to build the Template for entering Bulk Positive Input
    34 PIN_SOVR2_NUM Number(8,0) INTEGER NOT NULL SOVR Pin NUmber user to build the template to be used in Bulk Positive Input

    Prompt Table: %GP_EDIT_FLD8

    35 ENTRY_TYPE_SOVR_2 Character(3) VARCHAR2(3) NOT NULL SOVR Entry Type 1 used for building the template for entering Bulk Positive Input

    Prompt Table: GP_ENT_PISOV_VW

    36 SOVR_VAL_TYPE_2 Character(2) VARCHAR2(2) NOT NULL SOVR Value Type use in build up the Template for Bulk Positive Inpput
    37 PIN_SOVR2_SETID Number(3,0) SMALLINT NOT NULL Pin SOVR setid used to build the Template for Bulk Positive Input
    38 SETID_2 Character(5) VARCHAR2(5) NOT NULL Setid used to build the Template for entering Bulk Positive Input
    39 PIN_SOVR3_NUM Number(8,0) INTEGER NOT NULL SOVR Pin NUmber user to build the template to be used in Bulk Positive Input

    Prompt Table: %GP_EDIT_FLD9

    40 ENTRY_TYPE_SOVR_3 Character(3) VARCHAR2(3) NOT NULL SOVR Entry Type 1 used for building the template for entering Bulk Positive Input

    Prompt Table: GP_ENT_PISOV_VW

    41 SOVR_VAL_TYPE_3 Character(2) VARCHAR2(2) NOT NULL SOVR Value Type use in build up the Template for Bulk Positive Inpput
    42 PIN_SOVR3_SETID Number(3,0) SMALLINT NOT NULL Pin SOVR setid used to build the Template for Bulk Positive Input
    43 SETID_3 Character(5) VARCHAR2(5) NOT NULL Setid used to build the Template for entering Bulk Positive Input
    44 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code

    Prompt Table: CURRENCY_CD_TBL

    45 STORE_OPTN Character(1) VARCHAR2(1) NOT NULL Store Option - Indicator field to configure when data is stored (when element or results are non-zero, when element or results are zero, but component values are entered etc....) Introduced on Bulk PI template
    A=Always Store
    C=When Components are Non-Zero
    S=When Supporting Elements Exist

    Default Value: C