PKG_MDL_ADD_CMP (SQL Table)	Index Back
Pkg Model Addnl Component Tbl Salary Packaging - Model Addnl Component Tbl

PKG_MDL_ADD_CMP

(SQL Table)

Pkg Model Addnl Component Tbl

Salary Packaging - Model Addnl Component Tbl

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
Prompt Table: PERSON

2 EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Rcd Nbr

3 EFFDT Date(10) DATE NOT NULL Effective Date
Default Value: %DATE

4 EFFSEQ Number(3,0) SMALLINT NOT NULL Effective Sequence

5 COMPONENT Character(8) VARCHAR2(8) NOT NULL Sal package - Package Component
Prompt Table: PKG_BSE_CMP_TBL

6 COMPONENT_START Date(10) DATE Sal Package - Component Start Date

7 ADD_COMPONENT Character(8) VARCHAR2(8) NOT NULL Sal Package - Additional Component
Prompt Table: PKG_ADD_CMP_TBL

8 ADD_CMP_AMT Signed Number(17,2) DECIMAL(15,2) NOT NULL Sal Package - Additional Component Amount

9 ADD_CMP_AMT_PER Signed Number(17,2) DECIMAL(15,2) NOT NULL Sal Package - Additional Component Period Amount

10 ADD_CMP_ENROL_AMT Signed Number(17,2) DECIMAL(15,2) NOT NULL Sal Package - Additional FBT Component Amount that will be enrolled into Payroll. This field stores the value of FBT component calculated according to the pre-GST FBT calculation formula. It is required because ATO EOY reporting cannot include GST components.

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID Prompt Table: PERSON
2	EMPL_RCD	Number(3,0)	SMALLINT NOT NULL	Empl Rcd Nbr
3	EFFDT	Date(10)	DATE NOT NULL	Effective Date Default Value: %DATE
4	EFFSEQ	Number(3,0)	SMALLINT NOT NULL	Effective Sequence
5	COMPONENT	Character(8)	VARCHAR2(8) NOT NULL	Sal package - Package Component Prompt Table: PKG_BSE_CMP_TBL
6	COMPONENT_START	Date(10)	DATE	Sal Package - Component Start Date
7	ADD_COMPONENT	Character(8)	VARCHAR2(8) NOT NULL	Sal Package - Additional Component Prompt Table: PKG_ADD_CMP_TBL
8	ADD_CMP_AMT	Signed Number(17,2)	DECIMAL(15,2) NOT NULL	Sal Package - Additional Component Amount
9	ADD_CMP_AMT_PER	Signed Number(17,2)	DECIMAL(15,2) NOT NULL	Sal Package - Additional Component Period Amount
10	ADD_CMP_ENROL_AMT	Signed Number(17,2)	DECIMAL(15,2) NOT NULL	Sal Package - Additional FBT Component Amount that will be enrolled into Payroll. This field stores the value of FBT component calculated according to the pre-GST FBT calculation formula. It is required because ATO EOY reporting cannot include GST components.