GPDE_CT_RUNCTL

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	OPRID	Character(30)	VARCHAR2(30) NOT NULL	A user's ID (see PSOPRDEFN).
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 Rcd Nbr
5	GPDE_FM_FORM_ID	Character(12)	VARCHAR2(12) NOT NULL	ID of PDF Form
6	GPDE_FM_LANG_CD	Character(3)	VARCHAR2(3) NOT NULL	language code of Form
7	EFFDT	Date(10)	DATE	Effective Date Default Value: %date
8	GPDE_CT_REFDT	Date(10)	DATE	Certificates - Reference date of requested Certificate
9	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.
10	PAY_ENTITY	Character(10)	VARCHAR2(10) NOT NULL	Pay Entity
11	GPDE_CT_OPRNAME	Character(30)	VARCHAR2(30) NOT NULL	Executing Clerk
12	GPDE_AL_OPRNAME	Character(11)	VARCHAR2(11) NOT NULL	Executing Clerk Prompt Table: PERS_SRCH_GBL
13	GPDE_AL_GENDER	Character(1)	VARCHAR2(1) NOT NULL	gender of an EE M=Mr W=Mrs
14	GPDE_AL_CONTACT_NM	Character(50)	VARCHAR2(50) NOT NULL	executing clerk
15	GPDE_AL_PHONE	Character(24)	VARCHAR2(24) NOT NULL	phone number of an employee Prompt Table: GPDE_AL_PH_SRCH
16	GPDE_AL_FAX	Character(24)	VARCHAR2(24) NOT NULL	Fax number of an employee Prompt Table: GPDE_AL_PH_SRCH
17	GPDE_AL_EMAIL	Character(70)	VARCHAR2(70) NOT NULL	email address of an employee Prompt Table: GPDE_AL_EM_SRCH