Table Detail Report

CCR_SECTION



Column Section Relationship Section Top of Page


Table-level Detail

Description: Section
Definition: Identifies a section of date within its current content type.
Table Type: REFERENCE





Column Detail - CCR_SECTION


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.
BEG_EFFECTIVE_DT_TM DATETIME Y 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.
CONTENT_TYPE_CD DOUBLE N Identifies the content type for this section as specified by code set 28382.
DYNAMIC_IND DOUBLE N Indicates if this section has been created by a user on the fly.
END_EFFECTIVE_DT_TM DATETIME Y 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.
PREV_SECTION_ID DOUBLE N Previous Section ID - required for versioning
SECTION_DISPLAY VARCHAR(40) N A non-unique display value.
SECTION_DISPLAY_KEY VARCHAR(40) N The section display value in all CAPS.
SECTION_ID DOUBLE N Identifies the current section. PK for this table
SECTION_NAME VARCHAR(40) N Defines a unique name for the section.
SECTION_NAME_KEY VARCHAR(40) N Defines a unique name for the section in all CAPS.
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 - CCR_SECTION




Parent Column in CCR_SECTION (PK) Child Table Name Child Column Name
Children: SECTION_ID CCR_CONTENT_SECTION_RELTN SECTION_ID
CCR_SECTION_CRITERIA SECTION_ID


CCR_SECTION_CRITERIA



Column Section Relationship Section Top of Page


Table-level Detail

Description: Section Criteria
Definition: Specifies the type of data in a section.
Table Type: REFERENCE





Column Detail - CCR_SECTION_CRITERIA


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.
BEG_EFFECTIVE_DT_TM DATETIME Y 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.
CRITERIA_TYPE_FLAG DOUBLE N 0 = NO VALUE, 1 = Event SET, 2 = FORM REF Description, 3 = Non Med Catalog, 4 = Originally Ordered AS, 5 = DATE TYPE
CRITERIA_VALUE_TXT VARCHAR(255) N Criteria Value Text
END_EFFECTIVE_DT_TM DATETIME Y 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.
PREV_SECTION_CRITERIA_ID DOUBLE N Previous Section Criteria ID - required for versioning
SECTION_CRITERIA_ID DOUBLE N Identifies the current section criteria. PK for this table
SECTION_ID DOUBLE N Identifies the section this criteria defines.
SEQUENCE_NBR DOUBLE N Sequence Number
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 - CCR_SECTION_CRITERIA


Child Column in CCR_SECTION_CRITERIA(FK) Parent Table Name Parent Column Name
Parents: SECTION_ID CCR_SECTION SECTION_ID


CCR_SET



Column Section Relationship Section Top of Page


Table-level Detail

Description: Set
Definition: Defines a data grouping from multiple content areas.
Table Type: REFERENCE





Column Detail - CCR_SET


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.
BEG_EFFECTIVE_DT_TM DATETIME Y 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.
END_EFFECTIVE_DT_TM DATETIME Y 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.
PREV_SET_ID DOUBLE N Previous Set ID - required for versioning
SET_DISPLAY VARCHAR(40) N A non-unique display value.
SET_ID DOUBLE N Identifies the current set. PK for this table
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.
VIEW_TYPE_CD DOUBLE N Identifies the view type this set is compatible with



Relationship Detail - CCR_SET




Parent Column in CCR_SET (PK) Child Table Name Child Column Name
Children: SET_ID CCR_CONTENT SET_ID
CCR_VIEW_SET_RELTN SET_ID


CCR_USER_FILTER



Column Section Relationship Section Top of Page


Table-level Detail

Description: User Filter
Definition: Defines a user's primary filter for a content
Table Type: REFERENCE





Column Detail - CCR_USER_FILTER


Column Name Type Null? Definition
CONTENT_ID DOUBLE N Previous Content ID on CCR Content
CONTENT_VIEW_FILTER_ID DOUBLE N Previous Content View Filter ID on CCR_CONTENT_VIEW_FILTER
PRSNL_ID DOUBLE N The personnel that specifies this content filter as their primary for the current content ID
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 - CCR_USER_FILTER


Child Column in CCR_USER_FILTER(FK) Parent Table Name Parent Column Name
Parents: CONTENT_ID CCR_CONTENT CONTENT_ID
CONTENT_VIEW_FILTER_ID CCR_CONTENT_VIEW_FILTER CONTENT_VIEW_FILTER_ID
PRSNL_ID PRSNL PERSON_ID


CCR_VIEW



Column Section Relationship Section Top of Page


Table-level Detail

Description: View
Definition: Defines a grouping of data for many disparate entities.
Table Type: REFERENCE





Column Detail - CCR_VIEW


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.
BEG_EFFECTIVE_DT_TM DATETIME Y 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.
END_EFFECTIVE_DT_TM DATETIME Y 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.
LAST_MODIFIED_DT_TM DATETIME Y Specifies the last time any subcomponent of the view is updated.
OWNER_PRSNL_ID DOUBLE N The unique identifier from the PRSNL table.
PREV_VIEW_ID DOUBLE N Previous View ID - required for versioning
SHARED_IND DOUBLE N Indicates if this view may be used by anyone.
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.
VIEW_DISPLAY VARCHAR(40) N A non-unique display value.
VIEW_DISPLAY_KEY VARCHAR(40) N The view_display value in all CAPS.
VIEW_ID DOUBLE N Identifies the current view.
VIEW_NAME VARCHAR(40) N Defines a unique name for the view.
VIEW_NAME_KEY VARCHAR(40) N A unique name that is the VIEW_NAME in all caps.
VIEW_TYPE_CD DOUBLE N Identifies the type of view this defines.



Relationship Detail - CCR_VIEW




Parent Column in CCR_VIEW (PK) Child Table Name Child Column Name
Children: VIEW_ID CCR_CONTENT_VIEW_FILTER VIEW_ID
CCR_VIEW_SET_RELTN VIEW_ID