Audit events written for a job update

When a job is updated using the CCREGN—Update Job application and any field is updated, then each field change causes the creation of a job audit record, with all job audit records for one update considered one transaction.

The following table indicates the data that is common to the all of the job audit records in the job audit transaction resulting from a job update.

Field Content

Event Date

<System_DateTime>

User Id

<Current_Login_User_ID>

Audit Level

1

Correlation Id

<Unique_ID_per_transaction>

Application Name

CCREGN

Audit Type

UPD

Audit Event

Job Modified

Organisation Code

<Current_Login_Organisation_code>

Laboratory Code

<Current_Login_Laboratory_Code>

Job Id

<Existing_Job_ID>

Job Code

<Existing_Job_Code>

Job Name

<Existing_Job_Name>

Sample Id

 

Sample Code

 

Sample Name

 

Portion Code

 

Scheme Id

 

Scheme Code

 

Scheme Name

 

Scheme Version Id

 

Scheme Version

 

Scheme Version Analyte Id

 

Scheme Version Analyte Code

 

Scheme Version Analyte Name

 

Related Object Type

J

Related Object Id

 

Related Object Code

 

Related Object Name

 

Is Header?

Y for the FIRST record of the entire transaction, N for SUBSEQUENT records of the entire transaction. Since job audit records are only written for changed fields, then the header record of the transaction may vary each time a job update is done.

The following table indicates the data that is unique to the individual job audit record, by field, in the job audit transaction resulting from a job update.

Data Types can be either: 0 (Boolean), 1 (Integer), 2 (Real), 3 (String), 4 (Text), 5 (Link), 6 (Empty), 7 (DateTime).

Field

Data Type

From Id

From Code

From Name

From Description

To Id

To Code

To Name

To Description

Comment

AnalysisText

4 (Text)

 

 

 

 

 

 

 

 

CLOB content is trimmed to field length (default 2000 characters)

RegistrationText

4 (Text)

 

 

 

 

 

 

 

 

CLOB content is trimmed to field length (default 2000 characters)

ReportText

4 (Text)

 

 

 

 

 

 

 

 

CLOB content is trimmed to field length (default 2000 characters)

PreparationText

4 (Text)

 

 

 

 

 

 

 

 

CLOB content is trimmed to field length (default 2000 characters)

AgreedDate

7 (DateTime)

 

 

 

<Old_Agreed_Date>

 

 

 

<New_Agreed_Date>

 

AuthUserGroupId

5 (Link)

<Old_Id>

<Old_Code>

<Old_Name>

<Old_Auth_User_Group_Description>

<New_Id>

<New_Code>

<New_Name>

<New_Auth_User_Group_Description>

 

ClientCode

3 (String)

 

 

 

<Old_Client_Code>

 

 

 

<New_Client_Code>

 

ClientContactCode

3 (String)

 

 

 

<Old_Client_Contact_Code>

 

 

 

<New_Client_Contact_Code>

 

ClientContactId

5 (Link)

<Old_Id>

<Old_Code>

<Old_Name>

<Old_Client_Contact_Description>

<New_Id>

<New_Code>

<New_Name>

 

 

ClientId

5 (Link)

<Old_Id>

<Old_Code>

<Old_Name>

 

<New_Id>

<New_Code>

<New_Name>

 

 

ClientProjectCode

3 (String)

 

 

 

<Old_Client_Project_Code>

 

 

 

<New_Client_Project_Code>

 

ClientProjectId

5 (Link)

<Old_Id>

<Old_Code>

<Old_Name>

 

<New_Id>

<New_Code>

<New_Name>

 

 

ClientSubmissionNumber

3 (String)

 

 

 

<Old_Client_Submission_Number)

 

 

 

<New_Client_Submission_Number)

 

Contract

3 (String)

 

 

 

<Old_Contract>

 

 

 

<New_Contract>

 

ContractSubmissionNum

3 (String)

 

 

 

<Old_Contract_Submission_Number>

 

 

 

<New_Contract_Submission_Number>

 

CostCentreCode

3 (String)

 

 

 

<Old_Cost_Centre_Code>

 

 

 

<New_Cost_Centre_Code>

 

CostCentreId

5 (Link)

<Old_Id>

<Old_Code>

<Old_Name>

<Old_Cost_Centre_Description>

<New_Id>

<New_Code>

<New_Name>

<New_Cost_Centre_Description>

 

Description

3 (String)

 

 

 

<Old_Description>

 

 

 

<New_Description>

 

Discount

1 (Integer)

 

 

 

<Old_Discount>

 

 

 

<New_Discount>

 

IsAutoAppendQc

0 (Boolean)

 

 

 

<Old_Is_Auto_Append_QC>

 

 

 

<New_Is_Auto_Append_QC>

 

IsAutoPaperwork

0 (Boolean)

 

 

 

<Old_Is_Auto_Paperwork>

 

 

 

<New_Is_Auto_Paperwork>

 

IsAutoValidate

0 (Boolean)

 

 

 

<Old_Is_Auto_Validate>

 

 

 

<New_Is_Auto_Validate>

 

IsFixedPrice

0 (Boolean)

 

 

 

<Old_Is_Fixed_Price>

 

 

 

<New_Is_Fixed_Price>

 

IsRequireAuthorisation

0 (Boolean)

 

 

 

<Old_Is_Require_Authorisation>

 

 

 

<New_Is_Require_Authorisation>

 

JobCategoryId

5 (Link)

<Old_Id>

<Old_Code>

<Old_Name>

<Old_Job_Category_Description>

<New_Id>

<New_Code>

<New_Name>

<Old_Job_Category_Description>

 

PossibleDate

7 (DateTime)

 

 

 

<Old_Possible_Date>

 

 

 

<New_Possible_Date>

 

Priority

3 (String)

 

 

 

<Old_Priority>

 

 

 

<New_Priority>

 

PriorityInSecond

3 (String)

 

 

 

<Old_Priority_In_Second>

 

 

 

<New_Priority_In_Second>

 

ReceivedDate

7 (DateTime)

 

 

 

<Old_Received_Date>

 

 

 

<New_Received_Date>

 

ReceptionUserId

5 (Link)

<Old_Id>

<Old_Code>

<Old_Name>

<Old_Sign_User_Group_Description>

<New_Id>

<New_Code>

<New_Name>

<New_Sign_User_Group_Description>

 

RequiredDate

7 (DateTime)

 

 

 

<Old_Required_Date>

 

 

 

<New_Required_Date>

 

SignUserGroupId

5 (Link)

<Old_Id>

<Old_Code>

<Old_Name>

<Old_User_Group_Description>

<New_Id>

<New_Code>

<New_Name>

<New_User_Group_Description>

 

IsAutoReceive

0 (Boolean)

 

 

 

<Old_Is_Auto_Received>

 

 

 

<New_Is_Auto_Received>

 

RequiredFor

3 (String)

 

 

 

<Old_Required_For>

 

 

 

<New_Required_For>

 

JobNameScheduleOffset

3 (String)

 

 

 

<Old_Job_Name_Sched_Offset>

 

 

 

<New_Job_Name_Sched_Offset>

 

ProdJobDescSyntaxCode

3 (String)

 

 

 

<Old_Prod_Job_Desc_Syntax_Code>

 

 

 

<New_Prod_Job_Desc_Syntax_Code>

 

ProdJobDescSyntaxLabCode

3 (String)

 

 

 

<Old_Prod_Job_Desc_Syntax_Lab_Code>

 

 

 

<New_Prod_Job_Desc_Syntax_Lab_Code>

 

ProdJobNameSyntaxCode

3 (String)

 

 

 

<Old_Prod_Job_Name_Syntax_Code>

 

 

 

<New_Prod_Job_Name_Syntax_Code>

 

ProdJobNameSyntaxLabCode

3 (String)

 

 

 

<Old_Prod_Job_Name_Syntax_Lab_Code>

 

 

 

<New_Prod_Job_Name_Syntax_Lab_Code>

 

Schedule

3 (String)

 

 

 

<Old_Schedule>

 

 

 

<New_Schedule>

Schedule string is trimmed to field length (default 2000 characters)

ScheduleExpiresOnDate

7 (DateTime)

 

 

 

<Old_Schedule_Expires_On_Date>

 

 

 

<New_Schedule_Expires_On_Date>

 

ScheduleIsActiveAuto

0 (Boolean)

 

 

 

<Old_Schedule_Is_Active_Auto>

 

 

 

<New_Schedule_Is_Active_Auto>

 

ScheduleIsActiveManual

0 (Boolean)

 

 

 

<Old_Schedule_Is_Active_Manual>

 

 

 

<New_Schedule_Is_Active_Manual>