AUDIT_TLRPTTIME

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	AUDIT_OPRID	Character(30)	VARCHAR2(30) NOT NULL	The OPRID of the user who made the changes audited on an audit record.
2	AUDIT_STAMP	DateTime(26)	TIMESTAMP	Date and Time Stamp
3	AUDIT_ACTN	Character(1)	VARCHAR2(1) NOT NULL	Audit Action Code for Application Messages. This tells the subscriber whether the row has been added, changed, or deleted. A=Add C=Change Old (PPR Only) D=Delete K=Change - Old Values N=Change - New Values O=Change - Original Values
4	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
5	EMPL_RCD	Number(3,0)	SMALLINT NOT NULL	Empl Record
6	DUR	Date(10)	DATE NOT NULL	Date Under Report associates time being reported, scheduled or paid, to a specific date.
7	SEQ_NBR	Number(15,0)	DECIMAL(15) NOT NULL	Sequence Number
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	PUNCH_TIME	Time(15)	TIMESTAMP	punch time
10	PUNCH_DTTM	DateTime(26)	TIMESTAMP	Date and time when the punch occurred.
11	PUNCH_END	DateTime(26)	TIMESTAMP	Field typically used to record the end of a given punch (which is generally defined as the time of the consecutive punch, unless it is an OUT punch in which case BEGIN and END time is set to the same time).
12	TIMEZONE	Character(9)	VARCHAR2(9) NOT NULL	Time Zone
13	TIMEZONE2	Character(9)	VARCHAR2(9) NOT NULL	Time Zone
14	ST_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Submit Time Instance
15	BADGE_ID	Character(20)	VARCHAR2(20) NOT NULL	Badge ID
16	TCD_ID	Character(10)	VARCHAR2(10) NOT NULL	Time Collection Device Identification.
17	RULE_ELEMENT_1	Character(10)	VARCHAR2(10) NOT NULL	Rule Element 1
18	RULE_ELEMENT_2	Character(10)	VARCHAR2(10) NOT NULL	Rule Element 2
19	RULE_ELEMENT_3	Character(10)	VARCHAR2(10) NOT NULL	Rule Element 3
20	RULE_ELEMENT_4	Character(10)	VARCHAR2(10) NOT NULL	Rule Element 4
21	RULE_ELEMENT_5	Character(10)	VARCHAR2(10) NOT NULL	Rule Element 5
22	TASKGROUP	Character(10)	VARCHAR2(10) NOT NULL	Taskgroup Prompt Table: TL_TASKGRP_TBL
23	OPRID	Character(30)	VARCHAR2(30) NOT NULL	A user's ID (see PSOPRDEFN).
24	TASK_PROFILE_ID	Character(10)	VARCHAR2(10) NOT NULL	Task Profile ID Prompt Table: TL_TSKPRF
25	TCD_SUPERVISR_ID	Character(20)	VARCHAR2(20) NOT NULL	TCD Supervisor ID
26	OVERRIDE_RSN_CD	Character(5)	VARCHAR2(5) NOT NULL	Override Reason Code Prompt Table: TL_OVRD_RSN_TBL
27	RT_SOURCE	Character(3)	VARCHAR2(3) NOT NULL	Reported Time Source. the originator of Reported Time AM=Absence Management MD=Mobile Device ONL=Online SCH=Schedule SYS=Time and Labor System TCD=Time Collection Device
28	REPORTED_STATUS	Character(2)	VARCHAR2(2) NOT NULL	Reported Status AP=Approved DN=Denied IP=Approval In Process NA=Needs Approval NW=New PB=Pushed Back PR=Processed SB=Submitted SV=Saved
29	OPRID_LAST_UPDT	Character(30)	VARCHAR2(30) NOT NULL	Last Operator to Update
30	DTTM_MODIFIED	DateTime(26)	TIMESTAMP	Datetime modified
31	DTTM_CREATED	DateTime(26)	TIMESTAMP	Datetime Created
32	TRC	Character(5)	VARCHAR2(5) NOT NULL	Time Reporting Code used to report time in Time and Labor Prompt Table: TL_TRC_TBL
33	TL_QUANTITY	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	This field represents the measure of Work in hrs,amount etc.,
34	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Currency Code Prompt Table: CURRENCY_CD_TBL
35	COUNTRY	Character(3)	VARCHAR2(3) NOT NULL	Country Prompt Table: COUNTRY_TBL
36	STATE	Character(6)	VARCHAR2(6) NOT NULL	State Prompt Table: STATE_TBL
37	LOCALITY	Character(10)	VARCHAR2(10) NOT NULL	Locality Prompt Table: LOCAL_TAX_TBL
38	COMP_RATECD	Character(6)	VARCHAR2(6) NOT NULL	Comp Rate Code Prompt Table: COMP_RT_REG_VW
39	BILLABLE_IND	Character(1)	VARCHAR2(1) NOT NULL	Billable Indicator N=No Y=Yes Y/N Table Edit Default Value: N
40	OVERRIDE_RATE	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Override Rate.
41	COMPANY	Character(3)	VARCHAR2(3) NOT NULL	Company
42	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
43	SETID_LOCATION	Character(5)	VARCHAR2(5) NOT NULL	Location Set ID
44	LOCATION	Character(10)	VARCHAR2(10) NOT NULL	Location Code
45	SETID_DEPT	Character(5)	VARCHAR2(5) NOT NULL	Department Set ID
46	DEPTID	Character(10)	VARCHAR2(10) NOT NULL	Department
47	SETID_JOBCODE	Character(5)	VARCHAR2(5) NOT NULL	Job Code Set ID
48	JOBCODE	Character(6)	VARCHAR2(6) NOT NULL	Job Code
49	POSITION_NBR	Character(8)	VARCHAR2(8) NOT NULL	Position Number
50	PRODUCT	Character(6)	VARCHAR2(6) NOT NULL	Product
51	CUSTOMER	Character(10)	VARCHAR2(10) NOT NULL	Customer
52	ACCT_CD	Character(25)	VARCHAR2(25) NOT NULL	Combination Code
53	BUSINESS_UNIT_PC	Character(5)	VARCHAR2(5) NOT NULL	Project Costing Business Unit
54	BUSINESS_UNIT_PF	Character(5)	VARCHAR2(5) NOT NULL	Perf Meas Business Unit
55	PROJECT_ID	Character(15)	VARCHAR2(15) NOT NULL	Project/Grant
56	SETID_ACTIVITY	Character(5)	VARCHAR2(5) NOT NULL	Activity Set ID
57	ACTIVITY_ID	Character(15)	VARCHAR2(15) NOT NULL	Activity ID
58	RESOURCE_TYPE	Character(5)	VARCHAR2(5) NOT NULL	Project Costing Resource Type
59	SETID_RESOURCE	Character(5)	VARCHAR2(5) NOT NULL	Resource Set ID
60	RESOURCE_CATEGORY	Character(5)	VARCHAR2(5) NOT NULL	Project Costing Resource Category
61	RESOURCE_SUB_CAT	Character(5)	VARCHAR2(5) NOT NULL	Project Costing Resource Sub Category
62	TASK	Character(5)	VARCHAR2(5) NOT NULL	Task
63	USER_FIELD_1	Character(10)	VARCHAR2(10) NOT NULL	User Field 1
64	USER_FIELD_2	Character(10)	VARCHAR2(10) NOT NULL	User Field 2
65	USER_FIELD_3	Character(15)	VARCHAR2(15) NOT NULL	User Field 3
66	USER_FIELD_4	Character(20)	VARCHAR2(20) NOT NULL	User Field 4
67	USER_FIELD_5	Character(20)	VARCHAR2(20) NOT NULL	User Field 5