CDS_BATCH



Column Section Relationship Section Top of Page


Table-level Detail

Description: Commissioning Data Set - Batch
Definition: Identifies information about each batch generated.
Table Type: ACTIVITY





Column Detail - CDS_BATCH


Column Name Type Null? Definition
CDS_BATCH_DT_TM DATETIME N The date and time the batch was run.
CDS_BATCH_END_DT_TM DATETIME N Contains the end date of date range of updates or activity that the batch contains.
CDS_BATCH_FILENAME VARCHAR(50) Y The main filename for this batch.
CDS_BATCH_ID DOUBLE N Uniquely Identifies a given batch.
CDS_BATCH_SIZE DOUBLE Y Contains the number of items in this batch.
CDS_BATCH_START_DT_TM DATETIME N Contains the start date of date range of updates or activity that the batch contains (usually equals the cds_batch_end_date of the last batch of this type for this organization.)
CDS_BATCH_STATUS_CD DOUBLE N Denotes the status of the batch run. Uses Code Set # 254591.
CDS_BATCH_TYPE_CD DOUBLE N Describes the type of batch.
ORGANIZATION_ID DOUBLE N Contains the organization id of the trust.
UPDT_APPLCTX DOUBLE N The application context number from the record info block.
UPDT_CNT DOUBLE N Set to 0 on insert. Incremented by 1 on update. Used to recognize update conflict where data in a row updated by one application is at risk of being lost by a second application attempting to update the row.
UPDT_DT_TM DATETIME N The date and time the row was last inserted or updated.
UPDT_ID DOUBLE N The person_id of the person from the personnel table (prsnl) that caused the last insert or update of the row in the table.
UPDT_TASK DOUBLE N The registered (assigned) task number for the process that inserted or updated the row.



Relationship Detail - CDS_BATCH




Parent Column in CDS_BATCH (PK) Child Table Name Child Column Name
Children: CDS_BATCH_ID CDS_BATCH_CONTENT CDS_BATCH_ID
CDS_BATCH_HIST CDS_BATCH_ID


CDS_BATCH_CONTENT



Column Section Relationship Section Top of Page


Table-level Detail

Description: Commissioning Data Set - Batch Content
Definition: Contains information about the contents of each batch.
Table Type: ACTIVITY





Column Detail - CDS_BATCH_CONTENT


Column Name Type Null? Definition
ACTIVITY_DT_TM DATETIME N Denotes the date the activity occurred.
CDS_BATCH_CONTENT_ID DOUBLE N Unique identifier for each cds item. This is the unique CDS ID reported to the NHS.
CDS_BATCH_ID DOUBLE N Reflects the ID of the latest batch this in which this item appeared.
CDS_ROW_ERROR_IND DOUBLE Y Indicator to denote inability to add this item to a CDS (usually because we can't determine its trust.)
CDS_TYPE_CD DOUBLE N Code value that describes the type of CDS activity item.
ENCNTR_ID DOUBLE N Uniquely identifies the encounter related to this batch content.
FS_PARENT_ENTITY_IDENT VARCHAR(36) Y Contains the identifier of the table from the foreign system to which this CDS activity is related.
FS_PARENT_ENTITY_NAME VARCHAR(30) Y Contains the name of the table from the foreign system to which this CDS activity is related.
ORGANIZATION_ID DOUBLE N Uniquely identifies the organization related to this batch content.
PARENT_ENTITY_ID DOUBLE N Contains the identifier of the table that from which the activity comes.
PARENT_ENTITY_NAME VARCHAR(30) N Table Name related to the activity of this batch content.
PERMANENT_DEL_IND DOUBLE N Indicator to denote whether this CDS activity can ever be changed from a 'delete' (UPDATE_DEL_FLAG of 1) row to an 'update/insert' (UPDATE_DEL_FLAG of 9) row. The indicator being 1 denotes the activity should never be updated to an 'upate/insert' status.
SUPPRESS_IND DOUBLE N Indicator field to denote whether a row of CDS activity is currentyl suppressed from publication or not.
TRANSACTION_TYPE_CD DOUBLE N The transaction type of the last transaction to occur against this CDS activity.
UPDATE_DEL_FLAG DOUBLE Y Denotes whether this is a CDS update or delete. 9 = Update; 1 = Delete
UPDT_APPLCTX DOUBLE N The application context number from the record info block. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.
UPDT_CNT DOUBLE N Set to 0 on insert. Incremented by 1 on update. Used to recognize update conflict where data in a row updated by one application is at risk of being lost by a second application attempting to update the row. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.
UPDT_DT_TM DATETIME N The date and time the row was last inserted or updated. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.
UPDT_ID DOUBLE N The person_id of the person from the personnel table (prsnl) that caused the last insert or update of the row in the table. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.
UPDT_TASK DOUBLE N The registered (assigned) task number for the process that inserted or updated the row. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.



Relationship Detail - CDS_BATCH_CONTENT


Child Column in CDS_BATCH_CONTENT(FK) Parent Table Name Parent Column Name
Parents: CDS_BATCH_ID CDS_BATCH CDS_BATCH_ID




Parent Column in CDS_BATCH_CONTENT (PK) Child Table Name Child Column Name
Children: CDS_BATCH_CONTENT_ID CDS_BATCH_CONTENT_ALIAS CDS_BATCH_CONTENT_ID
CDS_BATCH_CONTENT_HIST CDS_BATCH_CONTENT_ID


CDS_BATCH_CONTENT_ALIAS



Column Section Relationship Section Top of Page


Table-level Detail

Description: Commissioning Data Set - Batch Content Alias
Definition: An alias table to allow identification and reporting of CDS activity by an identifier other than the unique key on the CDS_BATCH_CONTENT table
Table Type: ACTIVITY





Column Detail - CDS_BATCH_CONTENT_ALIAS


Column Name Type Null? Definition
ACTIVE_IND DOUBLE N The table row is active or inactive. A row is generally active unless it is in an inactive state such as logically deleted, combined away, pending purge, etc.
ACTIVE_STATUS_CD DOUBLE N Indicates the status of the row itself (not the data in the row) such as active, inactive, combined away, pending purge, etc.
ACTIVE_STATUS_DT_TM DATETIME N The date and time that the active_status_cd was set.
ACTIVE_STATUS_PRSNL_ID DOUBLE N The person who caused the active_status_cd to be set or change.
ALIAS VARCHAR(35) N The alias is an identifier for a row in the CDS_batch_content table.
BEG_EFFECTIVE_DT_TM DATETIME N The date and time for which this table row becomes effective. Normally, this will be the date and time the row is added, but could be a past or future date and time.
CDS_BATCH_CONTENT_ALIAS_ID DOUBLE N PRIMARY KEY
CDS_BATCH_CONTENT_ID DOUBLE N Foreign key to the parent row in the CDS_BATCH_CONTENT table
CDS_BAT_CONT_ALIAS_TYPE_CD DOUBLE N Defines the kind or type of alias to the row on the CDS_BATCH_CONTENT table
END_EFFECTIVE_DT_TM DATETIME N The date/time after which the row is no longer valid as active current data. This may be valued with the date that the row became inactive.
UPDT_APPLCTX DOUBLE N The application context number from the record info block.
UPDT_CNT DOUBLE N Set to 0 on insert. Incremented by 1 on update. Used to recognize update conflict where data in a row updated by one application is at risk of being lost by a second application attempting to update the row.
UPDT_DT_TM DATETIME N The date and time the row was last inserted or updated.
UPDT_ID DOUBLE N The person_id of the person from the personnel table (prsnl) that caused the last insert or update of the row in the table.
UPDT_TASK DOUBLE N The registered (assigned) task number for the process that inserted or updated the row.



Relationship Detail - CDS_BATCH_CONTENT_ALIAS


Child Column in CDS_BATCH_CONTENT_ALIAS(FK) Parent Table Name Parent Column Name
Parents: CDS_BATCH_CONTENT_ID CDS_BATCH_CONTENT CDS_BATCH_CONTENT_ID


CDS_BATCH_CONTENT_HIST



Column Section Relationship Section Top of Page


Table-level Detail

Description: Commissioning Data Set - Batch Content History
Definition: Maintains audit information about each CDS batch content activity item.
Table Type: ACTIVITY





Column Detail - CDS_BATCH_CONTENT_HIST


Column Name Type Null? Definition
ACTIVITY_DT_TM DATETIME N Denotes the date that the activity occurred.
CDS_BATCH_CNT_HIST_ID DOUBLE N Uniquely Identifies each history batch content for each CDS item. This is the unique CDS id reported to the NHS.
CDS_BATCH_CONTENT_ID DOUBLE N Uniquely identifies the batch content record related to this historical record.
CDS_BATCH_ID DOUBLE N Uniquely identifies the CDS Batch related to the Batch Content.
CDS_ROW_ERROR_IND DOUBLE Y Indicator to denote inability to add this item to a CDS (usually because we can't determine its trust)
CDS_TYPE_CD DOUBLE N Denotes the type of CDS activity item.
ENCOUNTER_ID DOUBLE N Uniquely identifies the encounter related to this specific batch content.
FS_PARENT_ENTITY_IDENT VARCHAR(36) Y Contains the identifier of the table from the foreign system to which this CDS activity is related.
FS_PARENT_ENTITY_NAME VARCHAR(30) Y Contains the name of the table from the foreign system to which this CDS activity is related.
ORGANIZATION_ID DOUBLE N Uniquely identifies the organization related to this specific batch_content.
PARENT_ENTITY_ID DOUBLE N Contains the identifier of the table from which the activity comes.
PARENT_ENTITY_NAME VARCHAR(30) N Contains the name of the table from which the activity comes.
PERMANENT_DEL_IND DOUBLE N Indicator to denote whether this CDS activity can ever be changed from a 'delete' (UPDATE_DEL_FLAG of 1) row to an 'update/insert' (UPDATE_DEL_FLAG of 9) row. The indicator being 1 denotes the activity should never be updated to an 'upate/insert' status.
SUPPRESS_IND DOUBLE N Indicator field to denote whether a row of CDS activity is currentyl suppressed from publication or not.
TRANSACTION_DT_TM DATETIME N The date this row was added to history.
TRANSACTION_TYPE_CD DOUBLE N The transaction type of the last transaction to occur against this CDS activity.
UPDATE_DEL_FLAG DOUBLE Y Denotes whether this is a CDS update or delete. 9 = Update; 1 = Delete
UPDT_APPLCTX DOUBLE N The application context number from the record info block. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.
UPDT_CNT DOUBLE N Set to 0 on insert. Incremented by 1 on update. Used to recognize update conflict where data in a row updated by one application is at risk of being lost by a second application attempting to update the row. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.
UPDT_DT_TM DATETIME N The date and time the row was last inserted or updated. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.
UPDT_ID DOUBLE N The person_id of the person from the personnel table (prsnl) that caused the last insert or update of the row in the table. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.
UPDT_TASK DOUBLE N The registered (assigned) task number for the process that inserted or updated the row. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.



Relationship Detail - CDS_BATCH_CONTENT_HIST


Child Column in CDS_BATCH_CONTENT_HIST(FK) Parent Table Name Parent Column Name
Parents: CDS_BATCH_CONTENT_ID CDS_BATCH_CONTENT CDS_BATCH_CONTENT_ID


CDS_BATCH_HIST



Column Section Relationship Section Top of Page


Table-level Detail

Description: Commissioning Data Set - Batch History
Definition: Maintains audit information about each batch generated.
Table Type: ACTIVITY





Column Detail - CDS_BATCH_HIST


Column Name Type Null? Definition
CDS_BATCH_DT_TM DATETIME N Contains the Date and Time the batch was run.
CDS_BATCH_END_DT_TM DATETIME N Contains the end date of the date range of udates or activity that the batch contains.
CDS_BATCH_FILENAME VARCHAR(50) Y The main filename for this batch.
CDS_BATCH_HIST_ID DOUBLE N Uniquely identifies a history batch.
CDS_BATCH_ID DOUBLE N Uniquely identifies the batch related to this history record.
CDS_BATCH_SIZE DOUBLE Y Number of items in this given batch.
CDS_BATCH_START_DT_TM DATETIME N Contains the start date of date range of updates or activity that the batch contains ( usually equal to the cds_batch_end_dt_tm of the last batch of this type for this organization.)
CDS_BATCH_STATUS_CD DOUBLE N Denotes the status of the batch run. Uses the codeset 254591.
CDS_BATCH_TYPE_CD DOUBLE N Contains a code value that describes the type of batch.
ORGANIZATION_ID DOUBLE N Uniquely identifies the organization related to this batch.
UPDT_APPLCTX DOUBLE N The application context number from the record info block.
UPDT_CNT DOUBLE N Set to 0 on insert. Incremented by 1 on update. Used to recognize update conflict where data in a row updated by one application is at risk of being lost by a second application attempting to update the row.
UPDT_DT_TM DATETIME N The date and time the row was last inserted or updated.
UPDT_ID DOUBLE N The person_id of the person from the personnel table (prsnl) that caused the last insert or update of the row in the table.
UPDT_TASK DOUBLE N The registered (assigned) task number for the process that inserted or updated the row.



Relationship Detail - CDS_BATCH_HIST


Child Column in CDS_BATCH_HIST(FK) Parent Table Name Parent Column Name
Parents: CDS_BATCH_ID CDS_BATCH CDS_BATCH_ID