GP_PKG_IDESTABIDEFFDTGPBR_PIN_MAN_NUM1=1-Monthly Salary Base
2=2-13th Salary Base
3=3-Payee Discounted Amount
4=4-Family Salary Paid
5=5-Maternity Salary Base
6=6-Exclusive for FGTS Base
7=7-Base Discount
9=9-Other INSS Bases
GPBR_NRP_MIN_AD(SQL Table) |
Index Back |
|---|---|
MANAD INSS Base BRAMANAD INSS Base 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_INSS_BSE_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
INSS Base Type
1=1-Monthly Salary Base 2=2-13th Salary Base 3=3-Payee Discounted Amount 4=4-Family Salary Paid 5=5-Maternity Salary Base 6=6-Exclusive for FGTS Base 7=7-Base Discount 9=9-Other INSS Bases |
| 7 | GPBR_BASE_FLG | Character(1) | VARCHAR2(1) NOT NULL | INSS Base Type |