GPMX_SUBFAC_AET

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
2	COMPANY	Character(3)	VARCHAR2(3) NOT NULL	Company
3	GPMX_BALANCE_YEAR	Number(4,0)	SMALLINT NOT NULL	Balance Year GP Mexico
4	GPMX_PIN_ERN_NUM	Number(8,0)	INTEGER NOT NULL	Earning Pin Num
5	GPMX_PIN_TAX_NUM	Number(8,0)	INTEGER NOT NULL	Tax amount Pin Num
6	GPMX_PIN_TOTER_NUM	Number(8,0)	INTEGER NOT NULL	Total Earnings Pin Num
7	GPMX_PIN_TOTTX_NUM	Number(8,0)	INTEGER NOT NULL	Total Taxable Pin Number
8	GPMX_CON_PIN_NM	Character(18)	VARCHAR2(18) NOT NULL	Concatenate Pin Name
9	PIN_MBR_NUM	Number(8,0)	INTEGER NOT NULL	Element number field
10	PIN_MBR_NM	Character(18)	VARCHAR2(18) NOT NULL	Element Name field
11	YTD_AMT_SFX	Character(5)	VARCHAR2(5) NOT NULL	Element YTD Suffix
12	GPMX_SBEG_DT	Date(10)	DATE	System Begin Date
13	GPMX_SEND_DT	Date(10)	DATE	System End Date
14	CALC_RSLT_VAL	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Calculation Numeric Result
15	GPMX_TOT_EARN_AMT	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Total Earnings Amount
16	GPMX_TAXABLE_AMT	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Taxable Amount
17	GPMX_OTH_PAY_AMT	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Total Earnings Amount
18	GPMX_SUB_NON_ACR	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Non Creditable Subsidy Amount
19	GPMX_SUB_ACRED_AMT	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Creditable Subsidy Amount
20	GPMX_PROPORTION	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Proportion Amount
21	EXISTS_FLAG	Character(1)	VARCHAR2(1) NOT NULL	This Flag tells if we should use Exists, or Not Exists as a predicate prefixing the SubQuery. 0=Exists 1=Not Exists
22	AE_APPLID	Character(12)	VARCHAR2(12) NOT NULL	Program Name (see PSAEAPPLDEFN).
23	AE_SECTION	Character(8)	VARCHAR2(8) NOT NULL	Section