EMPLIDPrompt Table: PERS_SRCH_GBL
PAY_ENTITYPrompt Table: GPAU_EEPYENT_VW
BALANCE_GRP_NUMPrompt Table: GPAU_EEBLGRP_VW
GPAU_TAX_YEAR00=Entered
10=Created
20=Processed
30=Issued
40=Sent to ATO
Default Value: 00
Default Value: %DateTime
GPAU_EE_FBT(SQL Table) |
Index Back |
|---|---|
Employee's FBT RecordThis record holds employee's FBT record per Tax Year. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | EMPLID |
Character(11) | VARCHAR2(11) NOT NULL |
Employee ID
Prompt Table: PERS_SRCH_GBL |
| 2 | PAY_ENTITY |
Character(10) | VARCHAR2(10) NOT NULL |
Pay Entity
Prompt Table: GPAU_EEPYENT_VW |
| 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_EEBLGRP_VW |
| 4 | GPAU_TAX_YEAR |
Number(4,0) | SMALLINT NOT NULL | Tax Year - End of Year Processing |
| 5 | GPAU_STATUS | Character(2) | VARCHAR2(2) NOT NULL |
Additional Component - End of Year Processing
00=Entered 10=Created 20=Processed 30=Issued 40=Sent to ATO Default Value: 00 |
| 6 | GPAU_FBT_MNL | Number(11,2) | DECIMAL(10,2) NOT NULL | FBT Amount from manual entries - End of Year Processing |
| 7 | GPAU_FBT_ED | Number(11,2) | DECIMAL(10,2) NOT NULL | FBT Amount from Earnings/ Deductions - End of Year Processing |
| 8 | GPAU_FBT_MNL_NET | Number(11,2) | DECIMAL(10,2) NOT NULL | FBT Net Amount - Manually entered - End of Year Processing |
| 9 | GPAU_FBT_ED_NET | Number(11,2) | DECIMAL(10,2) NOT NULL | FBT Net Amount - from Earnings/Deductions - End of Year Processing |
| 10 | DATETIME_STAMP | DateTime(26) | TIMESTAMP |
DateTime Stamp
Default Value: %DateTime |