HR_PER502_AET

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
2	SEQ_NUM	Number(3,0)	SMALLINT NOT NULL	Sequence
3	OPRID	Character(30)	VARCHAR2(30) NOT NULL	A user's ID (see PSOPRDEFN).
4	RUN_CNTL_ID	Character(30)	VARCHAR2(30) NOT NULL	Run Control ID
5	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID Prompt Table: PERS_SRCH_ALL
6	EMPLID_NEW	Character(11)	VARCHAR2(11) NOT NULL	ID
7	CHANGE_FLG	Character(1)	VARCHAR2(1) NOT NULL	Action C=Change PersonID D=Delete PersonID
8	RECNAME_EMPLID	Character(15)	VARCHAR2(15) NOT NULL	Used in the EMPLID Change/Delete process to list records that contain and emplid field
9	FIELD_EMPLID	Character(18)	VARCHAR2(18) NOT NULL	Used in the EMPLID Change/Delete process to list the Fieldname that contains an EMPLID
10	HR_PER502_COUNT	Number(3,0)	SMALLINT NOT NULL	Number of rows deleted or changed for the current table
11	FIELD_KEY_FLAG	Character(1)	VARCHAR2(1) NOT NULL	Used in the EMPLID Change/Delete process to track if the field being processed is a key on the record.
12	INSTALLED_FLAG	Character(1)	VARCHAR2(1) NOT NULL	Product Installed Flag
13	ENROLLED_FLAG	Character(1)	VARCHAR2(1) NOT NULL	Enrolled Flag
14	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.
15	TBH_SEQ	Number(12,0)	DECIMAL(12) NOT NULL	Template Sequence
16	HR_TOTAL_ROWS	Number(5,0)	INTEGER NOT NULL	Rows Changed
17	HR_PER502_WHERE	Long Character(8048)	CLOB	Where sql for Person ID Delete/Change
18	HR_PER502_WHERE1	Long Character(8048)	CLOB	Where sql for Person ID Delete/Change
19	WHERE_CLAUSE	Long Character(500)	VARCHAR2(500)	Where Clause
20	WHERE_CLAUSE1	Character(254)	VARCHAR2(254) NOT NULL	Where Clause