ESTABIDEFFDTDefault Value: %date
GPBR_PIN_MAN_NUMPrompt Table: %GP_PIN_E_D_VW
Prompt Table: GPBR_ENT_ED_VW
1=1-Monthly Salary
2=2-13th Salary
9=9-Other Income Tax Bases
Default Value: 01
GPBR_NRP_MIT_VW(SQL View) |
Index Back |
|---|---|
MANAD Income Tax BRAMANAD Income Tax BRA |
| SELECT ESTABID ,EFFDT ,GPBR_PIN_MAN_NUM + 50000000 ,ENTRY_TYPE_ELEM ,GPBR_IT_BASE_TYPE ,GPBR_BASE_FLG FROM PS_GPBR_MANAD_IT |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | ESTABID |
Character(12) | VARCHAR2(12) NOT NULL | Establishment ID |
| 2 | EFFDT |
Date(10) | DATE NOT NULL |
Effective Date
Default Value: %date |
| 3 | GPBR_PIN_MAN_NUM |
Number(8,0) | INTEGER NOT NULL |
MANAD Pin Number
Prompt Table: %GP_PIN_E_D_VW |
| 4 | ENTRY_TYPE_ELEM | Character(3) | VARCHAR2(3) NOT NULL |
entry type element
Prompt Table: GPBR_ENT_ED_VW |
| 5 | 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 Default Value: 01 |
| 6 | GPBR_BASE_FLG | Character(1) | VARCHAR2(1) NOT NULL | INSS Base Type |