GPAU_EE_FBT

(SQL Table)
Index Back

Employee's FBT Record

This 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 GPAU_FBT_EX_ED Number(11,2) DECIMAL(10,2) NOT NULL FBT Exempt Amount from Earnings/ Deductions - End of Year Processing
11 GPAU_FBT_EX_NET Number(11,2) DECIMAL(10,2) NOT NULL FBTExempt Net Amount - from Earnings/Deductions - End of Year Processing
12 GPAU_FBT_EX_MNL Number(11,2) DECIMAL(10,2) NOT NULL FBT Exempt Amount from manual entries - End of Year Processing
13 GPAU_FBT_EX_MNLNET Number(11,2) DECIMAL(10,2) NOT NULL FBT Exempt Net Amount - Manually entered - End of Year Processing
14 DATETIME_STAMP DateTime(26) TIMESTAMP DateTime Stamp

Default Value: %DateTime