GPSG_APP_8B_DTL

#	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	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.
3	GPSG_TAX_YEAR	Number(4,0)	SMALLINT NOT NULL	Tax Year for Singapore IRAS Reporting
4	GPSG_CPY_TAX_REF	Character(11)	VARCHAR2(11) NOT NULL	Singapore Company Tax Reference Number Prompt Table: GPSG_IRAS_CPY
5	SEQNUM	Number(3,0)	SMALLINT NOT NULL	Sequence Number
6	GPSG_8B_GRANT_DT	Date(10)	DATE	Singapore IRAS Appendix 8B form - Stock Option Grant Date
7	GPSG_8B_MKT_VAL	Signed Number(14,5)	DECIMAL(12,5) NOT NULL	Singapore IRAS Appendix 8B Form - Market value of stock options
8	GPSG_8B_EXER_DT	Date(10)	DATE NOT NULL	Singapore IRAS Appendix 8B form - Stock Option Exercise Date
9	GPSG_8B_EXER_VAL	Signed Number(14,5)	DECIMAL(12,5) NOT NULL	Singapore IRAS Appendix 8B Form - Market value of stock options when exercised
10	GPSG_8B_EXER_PRICE	Signed Number(14,5)	DECIMAL(12,5) NOT NULL	Singapore IRAS Appendix 8B Form - Exercise price of stock options
11	GPSG_8B_SHARES_ACQ	Signed Number(14,5)	DECIMAL(12,5) NOT NULL	Singapore IRAS Appendix 8B Form - Number of shares acquired
12	GPSG_8B_GROSS_GAIN	Signed Number(11,2)	DECIMAL(9,2) NOT NULL	Singapore IRAS Appendix 8B Form - Gross gain on stock options
13	GPSG_8B_EXEMPT_GN	Signed Number(11,2)	DECIMAL(9,2) NOT NULL	Singapore IRAS Appendix 8B Form - Gross gain exempted
14	GPSG_8B_NONEXEMPT	Signed Number(11,2)	DECIMAL(9,2) NOT NULL	Singapore IRAS Appendix 8B Form - Gross gain not exempted
15	GPSG_8B_RCB_NUM	Character(12)	VARCHAR2(12) NOT NULL	Singapore IRAS Appendix 8B reporting - RCB Number
16	GPSG_8B_STOCK_CPY	Character(40)	VARCHAR2(40) NOT NULL	Singapore IRAS Appendix 8B reporting - Company Name
17	GPSG_8B_STOCK_IND	Character(1)	VARCHAR2(1) NOT NULL	Singapore IRAS Appendix 8B reporting - Stock Option Indicator 1=Emp Equity-Based Remune 2=Entrepreneurial Emp Eq 3=Company Emp Equi B Rem 4=Equity Remun Incentive Scheme Default Value: 1
18	GPSG_8B_PLAN_IND	Character(1)	VARCHAR2(1) NOT NULL	Singapore IRAS Appendix 8B reporting - Stock Option Indicator 1=Employee Stock Options 2=Employee Share Ownership Default Value: 1