Viewing 15 posts - 241 through 255 (of 285 total)
Thank you for spending your time on this!!!
May 24, 2012 at 9:29 am
Thank you for understanding.
I need these columns( all of them are tbl_doc_sctivity table) except status column …which has to be derived.
create Table Status_of_Enrollment
( Entry_id int,
event_type_id int,
Event_value varchar(30),
Event_time varchar(30),
Username ...
May 23, 2012 at 2:57 pm
I need a event_status table :
I want status for only those records which have sys_current_step(5) = "enrollmentanalyst"
and status will complete or pending.
I need to know the status of records which...
May 23, 2012 at 1:36 pm
Yep..new table with status column
May 23, 2012 at 12:54 pm
Entry_idevent_type_idEvent_valueevent_timelast_updated_userStatus
107141Initiated5/18/2012 16:01ADMIN
107145Customer Service5/18/2012 16:01ADMIN
107145Enrollment Technicia5/18/2012 16:07ADMIN
107145Customer Service5/18/2012 16:07ADMIN Pending
1071Imported5/12/2012 13:49ABD Pending
1075Enrollment Analyst5/12/2012 13:49ABD2 Pending
1071Routing5/12/2012 13:49ABD3 Pending
1073ENROLLMENT TECHNICIA5/12/2012 13:49ABD4 Pending
1081Routing5/18/2012 2:03ABDComplete
1085Enrollment Analyst5/18/2012 2:03ABD2Complete
1085Intake5/18/2012 2:03ABD3Complete
1083INDEXING5/18/2012 10:29ABD4Complete
1084Enrollment Analyst5/18/2012 10:53ABD5Complete
My status...
May 23, 2012 at 12:36 pm
Example of entries which has no current+step=5 and event_value=’enrollment anaylst”---------
Insert INTO [dbo].[tbl_doc_activity](Entry_id,Eventy_type_id ,Event_value ,Event_time,Username)
VALUES(10725,1,'Initiated','2012-05-18 16:26:02.987','ADMIN')
Insert INTO [dbo].[tbl_doc_activity](Entry_id,Eventy_type_id ,Event_value ,Event_time,Username)
VALUES(10725,5,'QA Technician','2012-05-18 16:26:02.987','ADMIN')
Insert INTO [dbo].[tbl_doc_activity](Entry_id,Eventy_type_id ,Event_value ,Event_time,Username)
VALUES(10725,1,'Carrier Exception','2012-05-18 16:27:56.870','ADMIN')
Insert INTO [dbo].[tbl_doc_activity](Entry_id,Eventy_type_id ,Event_value...
May 23, 2012 at 11:11 am
From your query i am getting all the records whose current_step is not "enrollment_analyst and setting sattus = "pending"
But I need only those records which are in Current_step ="Enrollment_Analsyt" and...
May 23, 2012 at 10:55 am
Sorry my criteria changed!!!
Entry_id Eventy_type_id( not unquie) Event_value( not unique)Event_datetimeusername
16pending05/17/2012 23:30ABC
16Pending letter05/17/2012 24:31DCBSA
11newinforecieevd05/17/2012 24:32Adsadhsa
18EA05/17/2012 24:33Asafcsd
16pending05/17/2012 24:33Asdsac
TABLE A scenario 1
TABLE A scenario 2
Entry_id Eventy_type_id( not unquie) Event_value( not unique)Event_datetimeusername
21carrierexception05/17/2012 23:30ABC
21newinforecieevd05/17/2012...
May 18, 2012 at 10:49 am
hi ,
Insert into dbo.Doc_Activity (Entry_Id,Event_Type_Id,Event_Value,Event_Time,User_Name_Event,Last_Updated_User,Last_Updated)
values ( 91,5, 'Indexing',2012-04-23 15:51:53.177,asdf,asdf,2012-04-23 15:51:53.177)
Insert into dbo.Doc_Activity (Entry_Id,Event_Type_Id,Event_Value,Event_Time,User_Name_Event,Last_Updated_User,Last_Updated)
values ( 91,4, 'Intake',2012-04-23 15:51:53.177,asdf,asdf,2012-04-23 15:51:53.177)
Insert into dbo.Doc_Activity (Entry_Id,Event_Type_Id,Event_Value,Event_Time,User_Name_Event,Last_Updated_User,Last_Updated)
values ( 298,5, 'Indexing',2012-05-05 23:31:22.660,asdf,asdf,2012-04-23 15:51:53.177)
Insert into...
May 11, 2012 at 11:55 am
sorry !! i am always thankful to the people for helping me out.
due to few situations..i am just copying from notepad what I typed.
Thank you , I worked out the...
May 11, 2012 at 11:18 am
entry_id sys_Routing_Action sys_WkfStep_Current
123 Indexing...
May 11, 2012 at 9:36 am
hi
event_type table has values
Event_DescriptionEvent_Type_Id
Status 1
foldername ...
May 11, 2012 at 9:08 am
Viewing 15 posts - 241 through 255 (of 285 total)