TL_TA0006_AET

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
2	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
3	EMPL_RCD	Number(3,0)	SMALLINT NOT NULL	Empl Rcd Nbr
4	OFFSET_MIN_DB	Signed Number(10,0)	DECIMAL(9) NOT NULL	Offset in minutes till DayBreaker
5	TIME_RPTG_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Time Reporting Type E=Exception Time Reporting P=Positive Time Reporting
6	DAYBREAKER_OPTIONS	Character(1)	VARCHAR2(1) NOT NULL	Day Breaker Options B=Begin Time Of Shift E=End Time Of Shift M=Majority Of Shift S=Split By Day Breaker Default Value: B
7	DAYBREAKER	Time(15)	TIMESTAMP	Day Breaker Time
8	DAYBREAKER_RANGE	Character(1)	VARCHAR2(1) NOT NULL	The Day Breaker Range defines how to determine which date to allocate the day's hours to, in conjunction with the time of the Day Breaker. The options are to apply the hours to the date when the day begins or the date when the day ends. For example, if the Day Breaker is set to 2:00PM, should the hours prior to 2:00PM be considered part of this day (End option for Day Breaker range), or the previous day (Begin option for Day Breaker Range). B=Range Start Day E=Range End Day
9	DUR	Date(10)	DATE	Date Under Report associates time being reported, scheduled or paid, to a specific date.
10	ROUNDING_OPTIONS	Character(1)	VARCHAR2(1) NOT NULL	Rounding Options D=Day N=None S=Segment Default Value: N
11	ROUNDING_OPTS_PCH	Character(1)	VARCHAR2(1) NOT NULL	Round Punches Before Rules D=Day N=None P=Punch S=Segment
12	ROUNDING_INTERVALS	Number(6,2)	DECIMAL(5,2) NOT NULL	Rounding interval configuration used on Workgroup
13	ROUNDING_OPTS_DAY	Character(1)	VARCHAR2(1) NOT NULL	Used for Rounding by day in workgroup
14	PERIOD_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Sequence Number
15	TL_QUANTITY	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	This field represents the measure of Work in hrs,amount etc.,
16	ROUNDING_MARKER	Number(6,2)	DECIMAL(5,2) NOT NULL	Rounding Marker (Mins)
17	PUNCH_IN	DateTime(26)	TIMESTAMP	Punch In
18	PUNCH_OUT	DateTime(26)	TIMESTAMP	Punch out
19	START_TIME	Time(15)	TIMESTAMP	Interview Start Time
20	STOP_TIME	Time(15)	TIMESTAMP	Period End Time
21	RECORD_NAME	Character(18)	VARCHAR2(18) NOT NULL	Record Name
22	SEQ_NBR	Number(15,0)	DECIMAL(15) NOT NULL	Sequence Number
23	PUNCH_DTTM	DateTime(26)	TIMESTAMP	Date and time when the punch occurred.
24	START_DT	Date(10)	DATE	Start Date
25	ROUNDING_INT_SIGN	Signed Number(7,2)	DECIMAL(5,2) NOT NULL
26	ROUNDING_MARK_SIGN	Signed Number(7,2)	DECIMAL(5,2) NOT NULL