TL_PROFILE_AET

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
2	START_DATE	Date(10)	DATE	Start Date for Gen Standing PO
3	END_DATE	Date(10)	DATE	End Date
4	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
5	EMPL_RCD	Number(3,0)	SMALLINT NOT NULL	Empl Rcd Nbr
6	END_EFFDT	Date(10)	DATE	End Effdt
7	HOLIDAY_SCHEDULE	Character(6)	VARCHAR2(6) NOT NULL	Holiday Schedule
8	COMPANY	Character(3)	VARCHAR2(3) NOT NULL	Company
9	PAYGROUP	Character(3)	VARCHAR2(3) NOT NULL	Pay Group
10	EFFDT	Date(10)	DATE	Effective Date Default Value: %date
11	SETID	Character(5)	VARCHAR2(5) NOT NULL	SetID
12	SCH_ADHOC_IND	Character(1)	VARCHAR2(1) NOT NULL	This field is used on Schedule Definitions to indicate if a Schedule is Ad Hoc (i.e. belonging to a specific employee) or Common (used by many employees) 1=Common Schedule 2=Ad Hoc Primary Schedule 3=Ad Hoc Alternate Schedule
13	SCHEDULE_ID	Character(16)	VARCHAR2(16) NOT NULL	The Schedule ID is a field used to uniquely identify a Schedule Definition or Schedule Calendar (built out Schedule Definition).
14	ROTATION_ID	Character(10)	VARCHAR2(10) NOT NULL	Rotation ID
15	TIMEZONE	Character(9)	VARCHAR2(9) NOT NULL	Time Zone