GPAU_KYENT_TBL

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	GPAU_SMART_KEY	Character(90)	VARCHAR2(90) NOT NULL	Primary Key used in SuperStream reporting
2	CAL_RUN_ID	Character(18)	VARCHAR2(18) NOT NULL	Calendar Run Id
3	PAY_ENTITY	Character(10)	VARCHAR2(10) NOT NULL	Pay Entity
4	RECIPIENT_ID	Character(8)	VARCHAR2(8) NOT NULL	Payment recipient ID
5	GPAU_LODGEMENT_REF	Character(50)	VARCHAR2(50) NOT NULL	This field is used in the AE program GPAU_EFT_CMX.
6	GP_PAYGROUP	Character(10)	VARCHAR2(10) NOT NULL	Global Payroll pay group
7	GPAU_SENDERID	Character(30)	VARCHAR2(30) NOT NULL	GPAUS - Stores the ID of the Sender for SuperEC processing.
8	GPAU_RECEIVERID	Character(30)	VARCHAR2(30) NOT NULL	GPAUS - Stores the ID of the Super Fund Administrator that is to receive a SuperEC message file.
9	GPAU_PAYERID	Character(9)	VARCHAR2(9) NOT NULL	Payer ID
10	GPAU_PAYEEID	Character(20)	VARCHAR2(20) NOT NULL	Payee ID
11	GPAU_SENDER_ABN	Character(11)	VARCHAR2(11) NOT NULL	Sender ABN
12	GPAU_SENDER_NAME	Character(76)	VARCHAR2(76) NOT NULL	Sender Name
13	GPAU_CON_FAMILY_NM	Character(30)	VARCHAR2(30) NOT NULL	Given family name
14	GPAU_CONTACT_GV_NM	Character(45)	VARCHAR2(45) NOT NULL	Given contact name
15	DISPLAY_NAME	Character(50)	VARCHAR2(50) NOT NULL	Used to display the person's name in the PERS_SRCH_SBP, EMPL_SRCH_SBP and the components that allow a person to be created
16	JOBCODE_DESCR	Character(30)	VARCHAR2(30) NOT NULL	Job Code Description
17	GPAU_EMAIL_ADDR	Character(76)	VARCHAR2(76) NOT NULL	Supplier E-mail address
18	GPAU_PHONE_SERVICE	Character(2)	VARCHAR2(2) NOT NULL	Phone Service Line
19	PHONE	Character(24)	VARCHAR2(24) NOT NULL	Telephone
20	GPAU_SENDER_URL	Character(254)	VARCHAR2(254) NOT NULL	Sender E-Service Address
21	GPAU_ERROR_ENABLED	Character(1)	VARCHAR2(1) NOT NULL	Error handling enabled indicator
22	GPAU_RECEIVER_ABN	Character(11)	VARCHAR2(11) NOT NULL	Receiver ABN
23	GPAU_RECEIVER_NAME	Character(76)	VARCHAR2(76) NOT NULL	Receiver Name
24	GPAU_PAYER_ABN	Character(11)	VARCHAR2(11) NOT NULL	Payer ABN
25	GPAU_PAYER_NM	Character(200)	VARCHAR2(200) NOT NULL	Payer Name
26	GPAU_BRANCH_EC_CD	Character(17)	VARCHAR2(17) NOT NULL	Branch Code
27	GPAU_ACCOUNT_EC_ID	Character(35)	VARCHAR2(35) NOT NULL	Account Number used in banking.
28	GPAU_ACCOUNT_NAME	Character(50)	VARCHAR2(50) NOT NULL	Account Name
29	GPAU_BRANCH_NAME	Character(30)	VARCHAR2(30) NOT NULL	Bank Branch Name
30	GPAU_BANK_NM	Character(40)	VARCHAR2(40) NOT NULL	Bank Name
31	GPAU_PAYEE_ABN	Character(11)	VARCHAR2(11) NOT NULL	Payee ABN
32	GPAU_PYMT_METHOD	Character(2)	VARCHAR2(2) NOT NULL	Payment Method 01=BPAY 02=DirectCredit 03=DirectDebit
33	DEBIT_DT	Date(10)	DATE	Debit Date
34	GPAU_CRN	Character(20)	VARCHAR2(20) NOT NULL	Customer Reference Number
35	GPAU_BILLER_CODE	Character(20)	VARCHAR2(20) NOT NULL	BPAY Biller Code
36	PAYMENT_AMT	Number(19,3)	DECIMAL(18,3) NOT NULL	Payment Amount
37	BRANCH_EC_CD	Character(17)	VARCHAR2(17) NOT NULL	Bank Branch ID
38	ACCOUNT_EC_ID	Character(35)	VARCHAR2(35) NOT NULL	Account Number used in banking.
39	ACCOUNT_NAME	Character(50)	VARCHAR2(50) NOT NULL	Account Name
40	BANK_NM	Character(40)	VARCHAR2(40) NOT NULL	Bank Name
41	GPAU_BRANCH_NM	Character(30)	VARCHAR2(30) NOT NULL	Bank branch bame
42	GPAU_TARGTPRODID	Character(14)	VARCHAR2(14) NOT NULL	GPAUS - Stores the target Superannuation Fund's Product ID. Used in SuperEC processing.
43	GPAU_TARGET_URL	Character(254)	VARCHAR2(254) NOT NULL	E-service address used in SuperStream reporting
44	GPAU_ER_ABN	Character(11)	VARCHAR2(11) NOT NULL	Employer ABN
45	GPAU_ER_NAME	Character(200)	VARCHAR2(200) NOT NULL	Name of the employer
46	GPAU_SUPER_EMPLID	Character(20)	VARCHAR2(20) NOT NULL	The ID provide by Super Fund to the employer
47	LOCATION_DESCR	Character(30)	VARCHAR2(30) NOT NULL	Location Description