EMPLIDDefault Value: GPAU_EE_TAX_TFN.EMPLID
Prompt Table: PERSON
EFFDTDefault Value: GPAU_EE_TAX_TFN.EFFDT
BALANCE_GRP_NUMPrompt Table: GPAU_EE_BLMLSVW
1=1
2=2
3=3
GPAU_EE_MED_LEV(SQL Table) |
Index Back |
|---|---|
Payee Tax Info - AustraliaThis table will be used to record the payee's tax information that would be used for the calculation of its tax withholding amount. This table record the payee's tax file number (TFN), tax scale, total rebates, Medicare levy exemptions, tax adjustments, etc. Each combination of Employee ID, Pay Entity, and Contract Num should have its own row of data in this record. This record is a child record of GPAU_EE_TAX_TFN |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | EMPLID |
Character(11) | VARCHAR2(11) NOT NULL |
Employee ID
Default Value: GPAU_EE_TAX_TFN.EMPLID Prompt Table: PERSON |
| 2 | EFFDT |
Date(10) | DATE NOT NULL |
Effective Date
Default Value: GPAU_EE_TAX_TFN.EFFDT |
| 3 | BALANCE_GRP_NUM |
Character(3) | VARCHAR2(3) NOT NULL |
This field will be used to determine the grouping of balances from the different jobs of the employee.
Prompt Table: GPAU_EE_BLMLSVW |
| 4 | GPAU_MED_LEV_SRCHG | Character(1) | VARCHAR2(1) NOT NULL |
Yes/No flag. This will identify if the payee is claiming medicare levy exemptions only for his/her spouse.
1=1 2=2 3=3 |