GPDE_CT_AET

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
2	RUN_CNTL_ID	Character(30)	VARCHAR2(30) NOT NULL	Run Control ID
3	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
4	EMPL_RCD	Number(3,0)	SMALLINT NOT NULL	Empl Record
5	GPDE_FM_FORM_ID	Character(12)	VARCHAR2(12) NOT NULL	ID of PDF Form
6	EFFDT	Date(10)	DATE	Effective Date Default Value: %date
7	GPDE_FM_LANG_CD	Character(3)	VARCHAR2(3) NOT NULL	language code of Form
8	GPDE_CT_REFDT	Date(10)	DATE	Certificates - Reference date of requested Certificate
9	AE_APPLID	Character(12)	VARCHAR2(12) NOT NULL	Program Name (see PSAEAPPLDEFN).
10	AE_SECTION	Character(8)	VARCHAR2(8) NOT NULL	Section
11	LAST_UPDATE_DTTM	DateTime(26)	TIMESTAMP	Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.
12	GPDE_AL_CONTACT_NM	Character(50)	VARCHAR2(50) NOT NULL	executing clerk
13	GPDE_AL_PHONE	Character(24)	VARCHAR2(24) NOT NULL	phone number of an employee
14	GPDE_CT_VERSION	Number(3,0)	SMALLINT NOT NULL	Current version of Certificate
15	GPDE_CT_FINALIZED	Character(1)	VARCHAR2(1) NOT NULL	Finalized Flag Y/N N=No Y=Yes
16	GPDE_CT_MODIFIED	Character(1)	VARCHAR2(1) NOT NULL	Modified Flag, Used on German Certificates. Indicates a form has been modified at least once by the clerk N=No Y=Yes
17	GPDE_FM_FLD_NBR	Number(4,0)	SMALLINT NOT NULL	Form Field Number
18	GPDE_FM_FLD_NAME	Character(254)	VARCHAR2(254) NOT NULL	Form Field Name
19	GPDE_FM_XML_TAG	Character(254)	VARCHAR2(254) NOT NULL	XML tag that should be used to create XML stream for Certificates
20	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
21	GPDE_CHR_LONG	Character(100)	VARCHAR2(100) NOT NULL	100 character char field used for certificates
22	DATE_VAL	Date(10)	DATE	Date Value
23	NUM_VAL	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Numeric Value
24	GPDE_CT_ENTRY_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Data entry type (M = Manual, P= by parameter, S = by system)
25	PAY_ENTITY	Character(10)	VARCHAR2(10) NOT NULL	Pay Entity
26	GPDE_AL_BGN_DT	Date(10)	DATE	Begin Date
27	GPDE_AL_END_DT	Date(10)	DATE	Begin Date