EODI_TSK

(SQL Table)
Index Back

Task Information

Task Information

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 EODI_TSK_TRANS_ID Number(15,0) DECIMAL(15) NOT NULL Task Transaction ID
2 EODI_TSK_PROC_ID Character(15) VARCHAR2(15) NOT NULL Task Process ID

Prompt Table: EODI_TSK_REG_VW

3 EODI_TSK_SUBJECT Character(50) VARCHAR2(50) NOT NULL Task Subject
4 EODI_ENTRY_ID Character(150) VARCHAR2(150) NOT NULL Entry ID
5 EODI_TSK_START_DT DateTime(26) TIMESTAMP Task Start Date
6 EODI_TSK_DUE_DATE DateTime(26) TIMESTAMP Task Due Date
7 EODI_TSK_STATUS Character(1) VARCHAR2(1) NOT NULL Task Status
C=Completed
D=Deferred
I=In Progress
N=Not Started
W=Waiting on someone else

Default Value: N

8 EODI_TSK_PRIORITY Character(1) VARCHAR2(1) NOT NULL Task Priority
H=High
L=Low
N=Normal

Default Value: N

9 EODI_TSK_PERCENT Number(6,2) DECIMAL(5,2) NOT NULL Task Precent

Default Value: 0

10 EODI_TSK_REMINDER DateTime(26) TIMESTAMP Task Reminder Date Time
11 EODI_TSK_TOT_WORK Character(30) VARCHAR2(30) NOT NULL Total Work
12 EODI_TSK_MILEAGE Character(100) VARCHAR2(100) NOT NULL Task Mileage
13 EODI_TSK_ACT_WORK Character(30) VARCHAR2(30) NOT NULL Task Actual Work
14 EODI_TSK_BILL_INFO Character(100) VARCHAR2(100) NOT NULL Task Billing Info
15 EODI_TSK_COMPANY Character(150) VARCHAR2(150) NOT NULL Task Company
16 EODI_TSK_DEL_DTTM DateTime(26) TIMESTAMP Task Deleted Date Time
17 TIMEZONE Character(9) VARCHAR2(9) NOT NULL Time Zone
18 EODI_DELETED Character(1) VARCHAR2(1) NOT NULL Deleted Flag

Y/N Table Edit

Default Value: N

19 EODI_LAST_UP_DTTM DateTime(26) TIMESTAMP Last Update Date Time
20 EODI_MESSAGE Long Character CLOB Message