EODI_TSK(SQL Table) |
Index Back |
---|---|
Task InformationTask 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 |