CCR_CONTENT



Column Section Relationship Section Top of Page


Table-level Detail

Description: Content
Definition: Defines a data grouping for content of the same type.
Table Type: REFERENCE





Column Detail - CCR_CONTENT


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_ID DOUBLE N Identifies the current content.
CONTENT_TYPE_CD DOUBLE N Reference to the type of content as defined by code set 28382.
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_CONTENT_ID DOUBLE N PREVIOUS CONTENT ID REQUIRED FOR RDDS VERSIONING
SEQUENCE_NBR DOUBLE N Orders the content within the SET it belongs to.
SET_ID DOUBLE N The reference to the SET 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.



Relationship Detail - CCR_CONTENT


Child Column in CCR_CONTENT(FK) Parent Table Name Parent Column Name
Parents: SET_ID CCR_SET SET_ID




Parent Column in CCR_CONTENT (PK) Child Table Name Child Column Name
Children: CONTENT_ID CCR_CONTENT_SECTION_RELTN CONTENT_ID
CCR_CONTENT_VIEW_FILTER CONTENT_ID
CCR_USER_FILTER CONTENT_ID


CCR_CONTENT_SECTION_RELTN



Column Section Relationship Section Top of Page


Table-level Detail

Description: Content Section Relationship
Definition: Defines the link between the CONENT and CONTENT_SECTION tables.
Table Type: REFERENCE





Column Detail - CCR_CONTENT_SECTION_RELTN


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_ID DOUBLE N ID value from table CCR_CONTENT
CONTENT_SECTION_RELTN_ID DOUBLE N Primary Key
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_CONTENT_SECTION_RELTN_ID DOUBLE N FK from this table - Versioning requirement to identify previous PK value
SECTION_ID DOUBLE N The reference to the CCR_SECTION table.
SEQUENCE_NBR DOUBLE N Orders the section within the Content it belongs to.
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_CONTENT_SECTION_RELTN


Child Column in CCR_CONTENT_SECTION_RELTN(FK) Parent Table Name Parent Column Name
Parents: CONTENT_ID CCR_CONTENT CONTENT_ID
SECTION_ID CCR_SECTION SECTION_ID


CCR_CONTENT_VIEW_FILTER



Column Section Relationship Section Top of Page


Table-level Detail

Description: Content and View Filter
Definition: Specifies filters for content relative to a specific view.
Table Type: REFERENCE





Column Detail - CCR_CONTENT_VIEW_FILTER


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_ID DOUBLE N Identifies the content this filter applies to.
CONTENT_VIEW_FILTER_ID DOUBLE N Identifies the current content filter identifier.PK for this table
DEFAULT_IND DOUBLE N Specifies if this is the default filter for the level of specificity defined by personnel, position, or org.
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.
FILTER_GRP_DISPLAY VARCHAR(40) N Specifies a display for the filters associated with this view/content relationship.
PREV_CONTENT_VIEW_FILTER_ID DOUBLE N FK from this table to satisfy versioning requirement.
PRSNL_ID DOUBLE N Specifies the filter is for a specific personnel 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.
VIEW_ID DOUBLE N Identifies the view this filter applies to.



Relationship Detail - CCR_CONTENT_VIEW_FILTER


Child Column in CCR_CONTENT_VIEW_FILTER(FK) Parent Table Name Parent Column Name
Parents: CONTENT_ID CCR_CONTENT CONTENT_ID
VIEW_ID CCR_VIEW VIEW_ID




Parent Column in CCR_CONTENT_VIEW_FILTER (PK) Child Table Name Child Column Name
Children: CONTENT_VIEW_FILTER_ID CCR_FILTER_VALUE CONTENT_VIEW_FILTER_ID
CCR_USER_FILTER CONTENT_VIEW_FILTER_ID


CCR_FILTER



Column Section Relationship Section Top of Page


Table-level Detail

Description: Filter
Definition: Defines the applicable filter types for content types in a view.
Table Type: REFERENCE





Column Detail - CCR_FILTER


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.
ALLOW_MULTIPLE_IND DOUBLE N Determines if this filter may have multiple values associated to it.
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.
CODE_SET_VALUE DOUBLE N If the filter type is code set, specifies the code set the filter values originate from.
CONTENT_TYPE_CD DOUBLE N Identifies the content type this filter supports.
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.
FILTER_ID DOUBLE N Identifies the current filter definition. FK from ccr_filter
FILTER_TYPE_CD DOUBLE N Identifies what this filter is.
FILTER_VALUE_TYPE_CD DOUBLE N Identifies the type of value this filter represents.
PREV_FILTER_ID DOUBLE N Previoius Filter Id - required for versioning
SRC_TABLE_NAME VARCHAR(40) N Identifies the source table for the value of this filter.
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_FILTER




Parent Column in CCR_FILTER (PK) Child Table Name Child Column Name
Children: FILTER_ID CCR_FILTER_VALUE FILTER_ID


CCR_FILTER_VALUE



Column Section Relationship Section Top of Page


Table-level Detail

Description: Filter Value
Definition: Specifies a value for a content filter.
Table Type: REFERENCE





Column Detail - CCR_FILTER_VALUE


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.
BOOLEAN_IND DOUBLE N The indicator value when applicable.
CODE_VALUE DOUBLE N Identifies the code value when applicable.
CONTENT_VIEW_FILTER_ID DOUBLE N Identifies the content filter this value applies to.
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.
FILTER_ID DOUBLE N Identifies the filter applied for this content.
FILTER_TYPE_CD DOUBLE N Identifies what this filter is.
FILTER_VALUE_ID DOUBLE N Identifies the current content filter value identifier.
LOOKBACK_UNIT_FLAG DOUBLE N Specifies the unit type for the date look back value when initially setting the filter value. 1 - Millisecond, 2 - Second, 3 - Minute, 4 - Hour, 5 - Day, 6 - Month, 7 -Year
LOOKBACK_VAL DOUBLE N Specifies the value for the lookback date in terms of the unit specified.
PREV_FILTER_VALUE_ID DOUBLE N Previous Filter Value ID - required for versioning
TABLE_ID_VALUE DOUBLE N The table id value when applicable.
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.
VALUE_TXT VARCHAR(255) N Text representation for values that are not IDs or Codes



Relationship Detail - CCR_FILTER_VALUE


Child Column in CCR_FILTER_VALUE(FK) Parent Table Name Parent Column Name
Parents: CONTENT_VIEW_FILTER_ID CCR_CONTENT_VIEW_FILTER CONTENT_VIEW_FILTER_ID
FILTER_ID CCR_FILTER FILTER_ID