GPDE_CT_ERG_AET

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
2	GPDE_FM_FORM_ID	Character(12)	VARCHAR2(12) NOT NULL	ID of PDF Form
3	GPDE_FM_FLD_NBR	Number(4,0)	SMALLINT NOT NULL	Form Field Number
4	GPDE_FM_FLD_NAME	Character(254)	VARCHAR2(254) NOT NULL	Form Field Name
5	GPDE_CT_FIELDTYPE	Character(1)	VARCHAR2(1) NOT NULL	Field type of entered Field (char, date, num etc) 0=Character 1=Long Character 2=Number 3=Signed Number 4=Date 5=Time 6=Datetime 7=Y/N Field
6	CHAR_VAL	Character(50)	VARCHAR2(50) NOT NULL	Character Value
7	DATE_VAL	Date(10)	DATE	Date Value
8	NUM_VAL	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Numeric Value
9	GPDE_CT_ENTRY_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Data entry type (M = Manual, P= by parameter, S = by system)