GP_PKG_IDESTABIDEFFDTGPBR_PIN_MAN_NUM1=1-Monthly Salary
2=2-13th Salary
9=9-Other Income Tax Bases
GPBR_NRP_MIT_AD(SQL Table) |
Index Back |
|---|---|
MANAD Income Tax BRAMANAD Income Tax BRA |
| # | 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 | ESTABID |
Character(12) | VARCHAR2(12) NOT NULL | Establishment ID |
| 3 | EFFDT |
Date(10) | DATE | Effective Date |
| 4 | GPBR_PIN_MAN_NUM |
Number(8,0) | INTEGER NOT NULL | MANAD Pin Number |
| 5 | ENTRY_TYPE_ELEM | Character(3) | VARCHAR2(3) NOT NULL | entry type element |
| 6 | GPBR_IT_BASE_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Income Tax Base Type
1=1-Monthly Salary 2=2-13th Salary 9=9-Other Income Tax Bases |
| 7 | GPBR_BASE_FLG | Character(1) | VARCHAR2(1) NOT NULL | INSS Base Type |