TL_ATTEND_AET

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
2	ATTENDANCE_PGM_ID	Character(10)	VARCHAR2(10) NOT NULL	Attendance Program
3	TRACKING_METHOD	Character(1)	VARCHAR2(1) NOT NULL	Tracking Method 1=Fixed Period 2=Rolling Period 3=Step Period
4	PERIOD_ID	Character(12)	VARCHAR2(12) NOT NULL	Time Period ID
5	AE_APPLID	Character(12)	VARCHAR2(12) NOT NULL	Program Name (see PSAEAPPLDEFN).
6	AE_SECTION	Character(8)	VARCHAR2(8) NOT NULL	Section
7	START_DT	Date(10)	DATE	Start Date
8	END_DT	Date(10)	DATE	end date
9	GRACE_PERIOD	Number(5,0)	INTEGER NOT NULL	Grace Period
10	MINUTES	Number(5,2)	DECIMAL(4,2) NOT NULL	Minutes
11	ACTION_RQRD	Character(30)	VARCHAR2(30) NOT NULL	Action Required
12	COMMENTSHORT	Character(30)	VARCHAR2(30) NOT NULL	Short Comment
13	ATTEND_POINTS	Number(6,2)	DECIMAL(5,2) NOT NULL	Points
14	DAYS	Number(3,0)	SMALLINT NOT NULL	Days
15	KEEP_GOING	Character(1)	VARCHAR2(1) NOT NULL	Keep Going Flag for App Engine....
16	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
17	DUR	Date(10)	DATE	Date Under Report associates time being reported, scheduled or paid, to a specific date.
18	PUNCH_BEGIN	DateTime(26)	TIMESTAMP	Punch In
19	DATE_CLEAR	Date(10)	DATE	Date Cleared
20	ACTION_NBR	Number(3,0)	SMALLINT NOT NULL	Action Number
21	ATTENDANCE_ACTION	Character(2)	VARCHAR2(2) NOT NULL	Attendance Action 1=Verbal Warning 2=Letter to File 3=Written Warning 1 4=Written Warning 2 5=Suspension 6=Written Warning 3 7=Termination 8=Other
22	EXCEPTION_ID	Character(8)	VARCHAR2(8) NOT NULL	Exception ID