Table AD_Workflow

Diagram C

PRIMARY KEY
AD_Workflow_ID NUMBER (10, 0) NOT NULL

AD_Client_ID NUMBER (10, 0) NOT NULL		AD_Client
AD_Org_ID NUMBER (10, 0) NOT NULL		AD_Org
IsActive CHAR (1) default: 'Y' CHECK ( IsActive in ( 'Y' , 'N' )) NOT NULL
Created DATE default: SYSDATE NOT NULL
CreatedBy NUMBER (10, 0) NOT NULL
Updated DATE default: SYSDATE NOT NULL
UpdatedBy NUMBER (10, 0) NOT NULL
Name NVARCHAR2 (60) NOT NULL
Description NVARCHAR2 (255)
Help NVARCHAR2 (2000)
AccessLevel CHAR (1) NOT NULL
EntityType CHAR (1) default: 'D' NOT NULL
AD_WF_Node_ID NUMBER (10, 0)
DurationUnit CHAR (1) NOT NULL
Author NVARCHAR2 (20) NOT NULL
Version NUMBER (10, 0) NOT NULL
PublishStatus CHAR (1) NOT NULL
ValidFrom DATE
ValidTo DATE
Priority NUMBER (10, 0) NOT NULL
Limit NUMBER (10, 0) NOT NULL
Duration NUMBER (10, 0) NOT NULL
Cost NUMBER default: 0 NOT NULL
WorkingTime NUMBER (10, 0) NOT NULL
WaitingTime NUMBER (10, 0) NOT NULL
AD_WF_Responsible_ID NUMBER (10, 0) NOT NULL		AD_WF_Responsible
AD_WorkflowProcessor_ID NUMBER (10, 0)		AD_WorkflowProcessor
FOREIGN KEY ADWFResponsible_ADWorkflow: AD_WF_Responsible_ID => AD_WF_Responsible ADWorkflowProcessor_ADWF: AD_WorkflowProcessor_ID => AD_WorkflowProcessor WorkflowClient: AD_Client_ID => AD_Client WorkflowOrg: AD_Org_ID => AD_Org
REFERENCED BY AD_Menu, AD_WF_Block, AD_WF_Node, AD_WF_Node, AD_WF_Process, AD_Workflow_Access, AD_Workflow_Trl, C_Approval