ROLENAMEEIP_CTL_IDSETIDDefault Value: %DateTime
IN_ITMEXP_CI(SQL Table) |
Index Back |
|---|---|
EDI Workflow Itemloader CIEDI Workflow Itemloader Temp Tbl |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | ROLENAME |
Character(30) | VARCHAR2(30) NOT NULL | The name of a Role in the Role Definition Table (see PSROLEDEFN). |
| 2 | EIP_CTL_ID |
Character(25) | VARCHAR2(25) NOT NULL | Enterprise Components EIP (enterprise integration point) control field |
| 3 | SETID |
Character(5) | VARCHAR2(5) NOT NULL | SetID |
| 4 | INV_ITEM_ID | Character(18) | VARCHAR2(18) NOT NULL | Item ID |
| 5 | DESCR60 | Character(60) | VARCHAR2(60) NOT NULL | Description |
| 6 | MESSAGE_TEXT | Character(100) | VARCHAR2(100) NOT NULL | Message Text This field refers to the Text for a particular Message Number in the Message Catalog. |
| 7 | ACTIONDTTM | DateTime(26) | TIMESTAMP |
Datetime action was taken on a worklist
Default Value: %DateTime |
| 8 | EMAILID | Character(70) | VARCHAR2(70) NOT NULL | A user's E-mail address |
| 9 | EMAIL_SUBJECT_LONG | Character(85) | VARCHAR2(85) NOT NULL | Email Subject |
| 10 | EMAIL_TEXTLONG | Long Character | CLOB | Message Text |