GPMX_NRP_SAL_AD(SQL Table) |
Index Back |
|---|---|
Salary LevelsSalary Levels - Earnings & Deductions Setup Record |
| # | 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 | BGN_DT |
Date(10) | DATE | Begin Date |
| 3 | END_DT |
Date(10) | DATE | end date |
| 4 | ENTRY_TYPE_ELEM |
Character(3) | VARCHAR2(3) NOT NULL | entry type element |
| 5 | PIN_NUM |
Number(8,0) | INTEGER NOT NULL | PIN Number |
| 6 | PIN_SOVR_NUM |
Number(8,0) | INTEGER NOT NULL | Supporting Element PIN Number |
| 7 | SOVR_VAL_NUM | Signed Number(20,6) | DECIMAL(18,6) NOT NULL | Supporting Element Numeric Value |
| 8 | SOVR_VAL_DT | Date(10) | DATE | Date Value |
| 9 | 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 |
| 10 | 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 |
| 11 | GPMX_TERM_VER_01 | Character(18) | VARCHAR2(18) NOT NULL | Termination Version |
| 12 | GPMX_TERM_VER_02 | Character(18) | VARCHAR2(18) NOT NULL | Termination Versions |
| 13 | GPMX_TERM_VER_03 | Character(18) | VARCHAR2(18) NOT NULL | Termination Versions |
| 14 | GPMX_TERM_VER_04 | Character(18) | VARCHAR2(18) NOT NULL | Termination Versions |
| 15 | GPMX_TERM_VER_05 | Character(18) | VARCHAR2(18) NOT NULL | Termination Versions |
| 16 | GPMX_TERM_VER_06 | Character(18) | VARCHAR2(18) NOT NULL | Termination Versions |
| 17 | GPMX_TERM_VER_07 | Character(18) | VARCHAR2(18) NOT NULL | Termination Versions |
| 18 | GPMX_TERM_VER_08 | Character(18) | VARCHAR2(18) NOT NULL | Termination Versions |
| 19 | GPMX_TERM_VER_09 | Character(18) | VARCHAR2(18) NOT NULL | Termination Versions |
| 20 | GPMX_TERM_VER_10 | Character(18) | VARCHAR2(18) NOT NULL | Termination Versions |
| 21 | COUNTRY | Character(3) | VARCHAR2(3) NOT NULL | Country |