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 |