TL_EMPL_TAO

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
2	MSGNODENAME	Character(30)	VARCHAR2(30) NOT NULL	Application Message Node Name. Name of the Application Message Node Definition. (see PSMSGNODEDEFN).
3	TCD_ID	Character(10)	VARCHAR2(10) NOT NULL	Time Collection Device Identification.
4	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
5	EMPL_RCD	Number(3,0)	SMALLINT NOT NULL	Empl Rcd Nbr
6	IN_PROCESS_FLG	Character(1)	VARCHAR2(1) NOT NULL	In Process
7	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
8	TCD_NETWORK_ID	Character(20)	VARCHAR2(20) NOT NULL	Network ID
9	TCD_NODE_ID	Character(20)	VARCHAR2(20) NOT NULL	Terminal ID
10	BADGE_ID	Character(20)	VARCHAR2(20) NOT NULL	Badge ID
11	TIME_RPTG_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Time Reporter Status A=Active I=Inactive
12	LAST_NAME	Character(30)	VARCHAR2(30) NOT NULL	Last Name
13	FIRST_NAME	Character(30)	VARCHAR2(30) NOT NULL	First Name
14	HIRE_DT	Date(10)	DATE	First Start Date
15	SERVICE_DT	Date(10)	DATE	Service Date
16	BIRTHDATE	Date(10)	DATE	Date of Birth
17	RESTRICTION_PRF_ID	Character(10)	VARCHAR2(10) NOT NULL	Restriction Profile ID
18	TASK_PRFL_TMPLT_ID	Character(10)	VARCHAR2(10) NOT NULL	Task Template ID
19	TASK_PROFILE_ID	Character(10)	VARCHAR2(10) NOT NULL	Task Profile ID