GPMX_NRP_SAL_VW

(SQL View)
 Index Back

Salary Levels

Salary Levels - Earnings & Deductions Setup Record

SELECT BGN_DT ,END_DT ,PIN_NUM + 50000000 ,ENTRY_TYPE_ELEM ,SOVR_VAL_NUM ,SOVR_VAL_DT ,GPMX_LEVEL_ERN_DED ,GPMX_TAX_METHOD_VR ,GPMX_TERM_VER_01 ,GPMX_TERM_VER_02 ,GPMX_TERM_VER_03 ,GPMX_TERM_VER_04 ,GPMX_TERM_VER_05 ,GPMX_TERM_VER_06 ,GPMX_TERM_VER_07 ,GPMX_TERM_VER_08 ,GPMX_TERM_VER_09 ,GPMX_TERM_VER_10 ,PIN_SOVR_NUM ,COUNTRY FROM PS_GPMX_SAL_ERNDED

  • Parent record: GPMX_SAL_ERNDED

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 BGN_DT Date(10) DATE NOT NULL Begin Date
    2 END_DT Date(10) DATE end date
    3 PIN_NUM Number(8,0) INTEGER NOT NULL PIN Number

    Prompt Table: %RECNAME_EDIT

    4 ENTRY_TYPE_ELEM Character(3) VARCHAR2(3) NOT NULL entry type element

    Prompt Table: GP_ENT_E_D_VW
    Set Control Field: DESCRSHORT

    5 SOVR_VAL_NUM Signed Number(20,6) DECIMAL(18,6) NOT NULL Supporting Element Numeric Value
    6 SOVR_VAL_DT Date(10) DATE Date Value
    7 GPMX_LEVEL_ERN_DED Character(2) VARCHAR2(2) NOT NULL This field help us to identify to which row each earning/deductions should be added in a Report called: Salary Levels
    01=Salaries
    02=Overtime
    03=PTU
    04=Christmas Bonus
    05=Vacation Premium
    06=Savings Fund
    07=Food & Meal Allowance
    08=Transportation Allowance
    09=Other Income
    8 GPMX_TAX_METHOD_VR Character(3) VARCHAR2(3) NOT NULL Tax Method SOVR's
    112=Article 95
    113=Article 96
    142=Article 174
    148=Article 163
    79=Article 79
    80=Article 80
    86=Article 86
    91=Article 91
    9 GPMX_TERM_VER_01 Character(18) VARCHAR2(18) NOT NULL Termination Version

    Prompt Table: GPMX_TERM_VERS

    10 GPMX_TERM_VER_02 Character(18) VARCHAR2(18) NOT NULL Termination Versions

    Prompt Table: GPMX_TERM_VERS

    11 GPMX_TERM_VER_03 Character(18) VARCHAR2(18) NOT NULL Termination Versions

    Prompt Table: GPMX_TERM_VERS

    12 GPMX_TERM_VER_04 Character(18) VARCHAR2(18) NOT NULL Termination Versions

    Prompt Table: GPMX_TERM_VERS

    13 GPMX_TERM_VER_05 Character(18) VARCHAR2(18) NOT NULL Termination Versions

    Prompt Table: GPMX_TERM_VERS

    14 GPMX_TERM_VER_06 Character(18) VARCHAR2(18) NOT NULL Termination Versions

    Prompt Table: GPMX_TERM_VERS

    15 GPMX_TERM_VER_07 Character(18) VARCHAR2(18) NOT NULL Termination Versions

    Prompt Table: GPMX_TERM_VERS

    16 GPMX_TERM_VER_08 Character(18) VARCHAR2(18) NOT NULL Termination Versions

    Prompt Table: GPMX_TERM_VERS

    17 GPMX_TERM_VER_09 Character(18) VARCHAR2(18) NOT NULL Termination Versions

    Prompt Table: GPMX_TERM_VERS

    18 GPMX_TERM_VER_10 Character(18) VARCHAR2(18) NOT NULL Termination Versions

    Prompt Table: GPMX_TERM_VERS

    19 PIN_SOVR_NUM Number(8,0) INTEGER NOT NULL Supporting Element PIN Number
    20 COUNTRY Character(3) VARCHAR2(3) NOT NULL Country

    Default Value: MEX