TL_EXCEPTN_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	EXCEPTION_ID	Character(8)	VARCHAR2(8) NOT NULL	Exception ID
4	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
5	EMPL_RCD	Number(3,0)	SMALLINT NOT NULL	Empl Rcd Nbr
6	DUR	Date(10)	DATE NOT NULL	Date Under Report associates time being reported, scheduled or paid, to a specific date. Default Value: %date
7	SEQ_NBR	Number(15,0)	DECIMAL(15) NOT NULL	Sequence Number Default Value: 1
8	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
9	RUN_CNTL_ID	Character(30)	VARCHAR2(30) NOT NULL	Run Control ID
10	EXCEPTION_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Status of Exception A=Allowed R=Resolved U=Unresolved
11	RESOLVED_BY	Character(30)	VARCHAR2(30) NOT NULL	Resolved by whom?
12	ACTION_DTTM	DateTime(26)	TIMESTAMP	Override Date Time
13	EXCEPTION_SOURCE	Character(3)	VARCHAR2(3) NOT NULL	Identifies the process which generated the Exception. LD=Labor Distribution/Dilution PI=Payroll Interface TA=Time Administration TVE=Time Validation Elapsed TVP=Time Validation Punch
14	START_DT	Date(10)	DATE	Start Date
15	END_DT	Date(10)	DATE	end date
16	MSG_DATA1	Character(100)	VARCHAR2(100) NOT NULL	Message Data Text 1
17	MSG_DATA2	Character(100)	VARCHAR2(100) NOT NULL	Message Data Text 2
18	MSG_DATA3	Character(100)	VARCHAR2(100) NOT NULL	Message Data Text 3
19	MSG_DATA4	Character(100)	VARCHAR2(100) NOT NULL	Message Data Text 4
20	MSG_DATA5	Character(100)	VARCHAR2(100) NOT NULL	Message Data Text 5
21	COMMENTS	Long Character	CLOB	Comment