TL_PUNCH_ERR

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	SUBSCRIBE_DTTM	DateTime(26)	TIMESTAMP	Subscription Date Time
2	TRANSACTIONID	Number(10,0)	DECIMAL(10) NOT NULL	Transaction Identifier
3	BADGE_ID	Character(20)	VARCHAR2(20) NOT NULL	Badge ID
4	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID Prompt Table: TL_ADM_NAME_VW
5	EMPL_RCD	Number(3,0)	SMALLINT NOT NULL	Empl Record Prompt Table: TL_ADM_EERCD_VW
6	PUNCH_DTTM	DateTime(26)	TIMESTAMP	Date and time when the punch occurred.
7	DELETE_DATE	Date(10)	DATE	Date for deletion in TCD Interface
8	PUNCH_TYPE	Character(2)	VARCHAR2(2) NOT NULL	Global Punch Types 0=Elapsed 1=In 2=Out 3=Meal 4=Break 5=Transfer
9	TCD_ID	Character(10)	VARCHAR2(10) NOT NULL	Time Collection Device Identification.
10	TIMEZONE	Character(9)	VARCHAR2(9) NOT NULL	Time Zone
11	TCD_SUPERVISR_ID	Character(20)	VARCHAR2(20) NOT NULL	TCD Supervisor ID
12	OPRID	Character(30)	VARCHAR2(30) NOT NULL	A user's ID (see PSOPRDEFN).
13	OVERRIDE_RSN_CD	Character(5)	VARCHAR2(5) NOT NULL	Override Reason Code
14	ADD_DELETE_IND	Character(1)	VARCHAR2(1) NOT NULL	Add / Delete Indicator A=Add D=Delete
15	ACTION_DTTM	DateTime(26)	TIMESTAMP	Override Date Time
16	TASK_PROFILE_ID	Character(10)	VARCHAR2(10) NOT NULL	Task Profile ID
17	TASK_PRFL_TMPLT_ID	Character(10)	VARCHAR2(10) NOT NULL	Task Template ID
18	COUNTRY	Character(3)	VARCHAR2(3) NOT NULL	Country
19	STATE	Character(6)	VARCHAR2(6) NOT NULL	State
20	LOCALITY	Character(10)	VARCHAR2(10) NOT NULL	Locality
21	TL_COMMENTS	Character(254)	VARCHAR2(254) NOT NULL	Comments
22	TRC	Character(5)	VARCHAR2(5) NOT NULL	Time Reporting Code used to report time in Time and Labor
23	OVERRIDE_RATE	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Override Rate.