GPAU_COMSUP_BD2(SQL Table) |
Index Back |
---|---|
Stores the Body for ComSuperThis records stores the first part of the body for Comsuper mainly the contribution information as listed in the PIF Body. |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | Number(10,0) | DECIMAL(10) NOT NULL | Process Instance | |
2 | Character(20) | VARCHAR2(20) NOT NULL | GPAUS - Stores the Scheme ID for ComSuper Employees - CSS or PSS. | |
3 | Number(8,0) | INTEGER NOT NULL | This is the Payroll run number for com-super | |
4 | Date(10) | DATE | End Date | |
5 | Character(11) | VARCHAR2(11) NOT NULL | Employee ID | |
6 | Character(18) | VARCHAR2(18) NOT NULL | The Membership Group ID is required for the file generated by GPAU_RCPFILE. | |
7 | GPAU_MBR_TYP | Character(1) | VARCHAR2(1) NOT NULL |
GPAUS - Stores the superannuation membership type for an employee - usually Spouse or Employee.
E=Employee Membership ID S=Spouse Membership ID |
8 | GPAU_TOTAL_MBR_CNT | Signed Number(20,6) | DECIMAL(18,6) NOT NULL | GPAUS - Stores the total reportable SuperEC contribution amount for an employee during the period for which SuperEC reporting has been run. |
9 | GPAU_COMSUP_ADCB | Signed Number(10,2) | DECIMAL(8,2) NOT NULL | Stores the Employer Additional Contribution for ComSuper |
10 | GPAU_COMSUP_BSCB | Signed Number(10,2) | DECIMAL(8,2) NOT NULL | Stores Employer Basic Contribution for comsuper |
11 | GPAU_COMSUP_SCCB | Signed Number(10,2) | DECIMAL(8,2) NOT NULL | Stores the Salary Sacrifice Contribution for ComSuper |
12 | GPAU_COMSUP_SHCB | Signed Number(10,2) | DECIMAL(8,2) NOT NULL | Stores the Employer Shortfall Contributio for ComSuper |
13 | GPAU_COMSUP_ADIC | Signed Number(10,2) | DECIMAL(8,2) NOT NULL | GP AUS - Stores ComSuper specific Additional Death and Invalidity Cover (ADIC) |