EMPLIDPrompt Table: PERSON
TAX_TYPE_BRA0=Not applicable
1=IRRF
2=INSS
3=FGTS
4=Union Contribution
PROC_NBR_BRADT_TX_EXEM_BRACODE_SUSP_BRAPERSON_INTX_BRA(SQL Table) |
Index Back |
|---|---|
Personal Info Tax TypePersonal Info Tax Type |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | EMPLID |
Character(11) | VARCHAR2(11) NOT NULL |
Employee ID
Prompt Table: PERSON |
| 2 | TAX_TYPE_BRA |
Character(1) | VARCHAR2(1) NOT NULL |
Tax Type Bra
0=Not applicable 1=IRRF 2=INSS 3=FGTS 4=Union Contribution |
| 3 | PROC_NBR_BRA |
Character(21) | VARCHAR2(21) NOT NULL | Proceeding Number BRA |
| 4 | DT_TX_EXEM_BRA |
Date(10) | DATE | Tax Exemption Date |
| 5 | CODE_SUSP_BRA |
Number(14,0) | DECIMAL(14) NOT NULL | Suspension Code |