JPM_ACK_REQ_AET

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
2	OPRID	Character(30)	VARCHAR2(30) NOT NULL	A user's ID (see PSOPRDEFN).
3	RUN_CNTL_ID	Character(30)	VARCHAR2(30) NOT NULL	Run Control ID
4	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
5	JPM_PROF_SOURCE	Character(1)	VARCHAR2(1) NOT NULL	Profile Source B=Both G=Profile Group P=Profile
6	JPM_NOTIFY_EE	Character(1)	VARCHAR2(1) NOT NULL	Generate Notifications
7	JPM_PROFILE_ID	Character(12)	VARCHAR2(12) NOT NULL	The id, autoassigned or user assigned of the profile. This id is used to group items and other related material together into one coherent profile.
8	JPM_JP_GRP_TYPE	Character(12)	VARCHAR2(12) NOT NULL	Group type to which a JPM profile group belongs
9	JPM_JP_GROUP	Character(12)	VARCHAR2(12) NOT NULL	ID of the Profile Group to which a JPM profile belongs
10	JPM_RLAT_NAME	Character(30)	VARCHAR2(30) NOT NULL	Name of the relationship being established between JPM Data and External Data. Example - JOB CODE might be used to indicate that the relationship is between a JPM Profile of Job and External Data such as the Job Code on the Job Code table.
11	JPM_SETID_FLG	Character(1)	VARCHAR2(1) NOT NULL	Set ID Flag
12	JPM_KEY1_FLD	Character(18)	VARCHAR2(18) NOT NULL	Key 1 Field Name
13	JPM_KEY2_FLD	Character(18)	VARCHAR2(18) NOT NULL	Key 2 Field Name
14	JPM_SELECT_LIST	Character(100)	VARCHAR2(100) NOT NULL	Select
15	JPM_FROM_CLAUSE	Character(40)	VARCHAR2(40) NOT NULL	From
16	JPM_JOIN_CLAUSE	Character(150)	VARCHAR2(150) NOT NULL	Join
17	JPM_ACK_PROCESSED	Character(1)	VARCHAR2(1) NOT NULL	Processed
18	JPM_REMIND_DAYS	Number(3,0)	SMALLINT NOT NULL	Acknowledgement Reminder Days
19	URL	Character(254)	VARCHAR2(254) NOT NULL	Internet URL (Universal Resource Locator)
20	AE_TEST_FLAG	Character(1)	VARCHAR2(1) NOT NULL	Test Flag