HR_PER502_AET (SQL Table)	Index Back
PersonID Change/Delete Pro AET PersonID Change/Delete Process AET

HR_PER502_AET

(SQL Table)

PersonID Change/Delete Pro AET

PersonID Change/Delete Process 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 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.

#	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	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.