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 |