EMPLIDPrompt Table: PERSON
EMPL_RCDEFFDTDefault Value: %date
TAX_TYPE_BRA0=Not applicable
1=IRRF
2=INSS
3=FGTS
4=Union Contribution
PROC_NBR_BRAPrompt Table: EMP_PROC_VW_BRA
Prompt Table: EMP_CODE_VW_BRA
PER_INT_DTL_BRA(SQL Table) |
Index Back |
|---|---|
Personal Info Tax TypePersonal Info Tax Type Details |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | EMPLID |
Character(11) | VARCHAR2(11) NOT NULL |
Employee ID
Prompt Table: PERSON |
| 2 | EMPL_RCD |
Number(3,0) | SMALLINT NOT NULL | Empl Record |
| 3 | EFFDT |
Date(10) | DATE |
Effective Date
Default Value: %date |
| 4 | TAX_TYPE_BRA |
Character(1) | VARCHAR2(1) NOT NULL |
Tax Type Bra
0=Not applicable 1=IRRF 2=INSS 3=FGTS 4=Union Contribution |
| 5 | PROC_NBR_BRA |
Character(21) | VARCHAR2(21) NOT NULL |
Proceeding Number BRA
Prompt Table: EMP_PROC_VW_BRA |
| 6 | CODE_SUSP_BRA | Number(14,0) | DECIMAL(14) NOT NULL |
Suspension Code
Prompt Table: EMP_CODE_VW_BRA |