TL_TR_EE_TASK

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID Prompt Table: TL_EMPL_DATA
2	SEQ_NBR	Number(15,0)	DECIMAL(15) NOT NULL	Sequence Number
3	TASKGROUP	Character(10)	VARCHAR2(10) NOT NULL	Taskgroup Prompt Table: TL_TASKGRP_TBL
4	COMPANY	Character(3)	VARCHAR2(3) NOT NULL	Company Prompt Table: COMPANY_TBL
5	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit Prompt Table: TL_BUS_UNIT_VW
6	SETID_LOCATION	Character(5)	VARCHAR2(5) NOT NULL	Location SetID
7	LOCATION	Character(10)	VARCHAR2(10) NOT NULL	Location Code Prompt Table: TL_LOCATION_VW
8	SETID_DEPT	Character(5)	VARCHAR2(5) NOT NULL	Department SetID
9	DEPTID	Character(10)	VARCHAR2(10) NOT NULL	Department Prompt Table: TL_DEPT_TBL_VW
10	SETID_JOBCODE	Character(5)	VARCHAR2(5) NOT NULL	Job Code SetID
11	JOBCODE	Character(6)	VARCHAR2(6) NOT NULL	Job Code Prompt Table: TL_JOBCODE_VW
12	POSITION_NBR	Character(8)	VARCHAR2(8) NOT NULL	Position Number Prompt Table: POSITION_DATA
13	PRODUCT	Character(6)	VARCHAR2(6) NOT NULL	Product Prompt Table: TL_PRODUCT_TBL
14	CUSTOMER	Character(10)	VARCHAR2(10) NOT NULL	Customer Prompt Table: TL_CUSTOMER
15	ACCT_CD	Character(25)	VARCHAR2(25) NOT NULL	Combination Code Prompt Table: %EDITTABLE6
16	BUSINESS_UNIT_PC	Character(5)	VARCHAR2(5) NOT NULL	PC Business Unit Prompt Table: %EDITTABLE3
17	BUSINESS_UNIT_PF	Character(5)	VARCHAR2(5) NOT NULL	Perf Meas Business Unit Prompt Table: BUS_UNIT_TBL_PF
18	PROJECT_ID	Character(15)	VARCHAR2(15) NOT NULL	Project/Grant Prompt Table: %EDITTABLE
19	SETID_ACTIVITY	Character(5)	VARCHAR2(5) NOT NULL	Activity SetID
20	ACTIVITY_ID	Character(15)	VARCHAR2(15) NOT NULL	Activity ID Prompt Table: %EDITTABLE2
21	RESOURCE_TYPE	Character(5)	VARCHAR2(5) NOT NULL	Resource Type Prompt Table: TL_PROJ_RTYPE_V
22	SETID_RESOURCE	Character(5)	VARCHAR2(5) NOT NULL	Resource SetID
23	RESOURCE_CATEGORY	Character(5)	VARCHAR2(5) NOT NULL	Resource Category Prompt Table: %EDITTABLE4
24	RESOURCE_SUB_CAT	Character(5)	VARCHAR2(5) NOT NULL	Resource Sub Category Prompt Table: %EDITTABLE5
25	TASK	Character(5)	VARCHAR2(5) NOT NULL	Task Prompt Table: TL_TASK
26	USER_FIELD_1	Character(10)	VARCHAR2(10) NOT NULL	User Field 1 Prompt Table: TL_USER_FIELD_1
27	USER_FIELD_2	Character(10)	VARCHAR2(10) NOT NULL	User Field 2 Prompt Table: TL_USER_FIELD_2
28	USER_FIELD_3	Character(15)	VARCHAR2(15) NOT NULL	User Field 3 Prompt Table: TL_USER_FIELD_3
29	USER_FIELD_4	Character(20)	VARCHAR2(20) NOT NULL	User Field 4 Prompt Table: TL_USER_FIELD_4
30	USER_FIELD_5	Character(20)	VARCHAR2(20) NOT NULL	User Field 5 Prompt Table: TL_USER_FIELD_5