HRS_WRKFLOW_HST

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PSARCH_ID	Character(8)	VARCHAR2(8) NOT NULL	Archive ID (see PSARCHTEMPLATE).
2	PSARCH_BATCHNUM	Number(30,0)	DECIMAL(30) NOT NULL	Archive Batch Number
3	BUSPROCNAME	Character(30)	VARCHAR2(30) NOT NULL	Business Process Name (see PSBUSPROCDEFN). Prompt Table: PSBUSPROCDEFN
4	ACTIVITYNAME	Character(30)	VARCHAR2(30) NOT NULL	Name of a Business Process Activity (see PSACTIVITYDEFN). Prompt Table: PSACTIVITYDEFN
5	EVENTNAME	Character(30)	VARCHAR2(30) NOT NULL	Defines a routing event for PS Workflow Prompt Table: PSEVENTDEFN
6	EMAIL_TO	Character(254)	VARCHAR2(254) NOT NULL	EMAIL_TO
7	EMAIL_SUBJECT80	Character(80)	VARCHAR2(80) NOT NULL	Subject
8	EMAIL_TEXTLONG	Long Character	CLOB	Message Text
9	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
10	ORIGINATOR_ID	Character(11)	VARCHAR2(11) NOT NULL	Originator's ID
11	AUTHORIZATION_ID	Character(11)	VARCHAR2(11) NOT NULL	Authorization ID
12	RECRUITER_ID	Character(11)	VARCHAR2(11) NOT NULL	Recruiter ID
13	APPLID	Character(11)	VARCHAR2(11) NOT NULL	External Job Applicant ID
14	APP_DT	Date(10)	DATE	Date an application was submitted
15	HRS_JOB_OPENING_ID	Number(15,0)	DECIMAL(15) NOT NULL	Job Opening Clone
16	INTERVIEWER	Character(11)	VARCHAR2(11) NOT NULL	Interviewer
17	INTERVW_DT	Date(10)	DATE	Interview date
18	SEQ_NBR	Number(15,0)	DECIMAL(15) NOT NULL	Sequence Number
19	HRS_ROW_ADD_DTTM	DateTime(26)	TIMESTAMP	Row Added DateTime
20	HRS_ROW_ADD_OPRID	Character(30)	VARCHAR2(30) NOT NULL	Row Added Operator Id
21	HRS_ROW_UPD_DTTM	DateTime(26)	TIMESTAMP	Row Updated DateTime
22	HRS_ROW_UPD_OPRID	Character(30)	VARCHAR2(30) NOT NULL	Row Updated Operator Id