EODI_TSK(SQL Table) |
Index Back |
|---|---|
Task InformationTask Information |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | 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 |