Table Detail Report

REGIMEN_CAT_ATTRIBUTE_R



Column Section Relationship Section Top of Page


Table-level Detail

Description: Regimen catalog attribute relationship
Definition: Table is used to specify which regimen-level attributes are appropriate for each specific entry in the regimen catalog.
Table Type: REFERENCE





Column Detail - REGIMEN_CAT_ATTRIBUTE_R


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.
DEFAULT_VALUE_ID DOUBLE N Default value ID to indentify value from table identified in DEFAULT_VALUE_NAME. This is not a translatable value for RDDS purposes if the DEFAULT_VALUE_NAME field = BOOLEAN.
DEFAULT_VALUE_NAME VARCHAR(30) Y Used to indicate whether the value in DEFAULT_VALUE_ID column refers to an actual entity in the database (i.e. code value) or an application-specific value. DEFAULT_ENTITY set to BOOLEAN means that the value in DEFAULT_VALUE column is a 0/1 type Boolean.
DISPLAY_FLAG DOUBLE N Display mode for the attribute on the regimen 0 = Unknown 1 = Display Only 2 = Optional 3 = Required
REGIMEN_CATALOG_ID DOUBLE N The unique identifier for a REGIMEN_CATALOG. It will be used to uniquely identify a regimen. foreign key from REGIMEN_CATALOG
REGIMEN_CAT_ATTRIBUTE_ID DOUBLE N The unique identifier for a REGIMEN_CAT_ATTRIBUTE. It will be used to uniquely identify an attribute. foreign key from REGIMEN_CAT_ATTRIBUTE
REGIMEN_CAT_ATTRIBUTE_R_ID DOUBLE N sequence name: reference_seq Unique identifier for the REGIMEN_CAT_ATTRIBUTE_R table.
SEQUENCE DOUBLE N Sequence of Regimen Cat Attributes within Regimen Catalog
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 - REGIMEN_CAT_ATTRIBUTE_R


Child Column in REGIMEN_CAT_ATTRIBUTE_R(FK) Parent Table Name Parent Column Name
Parents: REGIMEN_CATALOG_ID REGIMEN_CATALOG REGIMEN_CATALOG_ID
REGIMEN_CAT_ATTRIBUTE_ID REGIMEN_CAT_ATTRIBUTE REGIMEN_CAT_ATTRIBUTE_ID




Parent Column in REGIMEN_CAT_ATTRIBUTE_R (PK) Child Table Name Child Column Name
Children: REGIMEN_CAT_ATTRIBUTE_R_ID REGIMEN_ATTRIBUTE REGIMEN_CAT_ATTRIBUTE_R_ID


REGIMEN_CAT_DETAIL



Column Section Relationship Section Top of Page


Table-level Detail

Description: Regimen Catalog Detail
Definition: Table is used to store data for individual components that make up a regimen. This table will serve as a definition of the regimen content. It will hold the number of actual components of the regimen and will point to rows on other tables that define those components.
Table Type: REFERENCE





Column Detail - REGIMEN_CAT_DETAIL


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.
CYCLE_NBR DOUBLE N Discrete numeric value for cycle number for each plan in the regimen
ENTITY_ID DOUBLE N Regimen may include plans and orders. This table will then have a row for each plan and order and point to PATHWAY_CATALOG and ORDER_CATALOG_SYNONYM tables as necessary.
ENTITY_NAME VARCHAR(40) N Regimen may include plans and orders. This table will then have a row for each plan and order and point to PATHWAY_CATALOG, ORDER_CATALOG_SYNONYM, or LONG_TEXT_REFERENCE tables as necessary.
REGIMEN_CATALOG_ID DOUBLE N The unique identifier for a REGIMEN_CATALOG. It will be used to uniquely identify a regimen. foreign key from REGIMEN_CATALOG
REGIMEN_CAT_DETAIL_ID DOUBLE N sequence name: reference_seq Unique identifier for the REGIMEN_CAT_DETAIL table.
REGIMEN_DETAIL_SEQUENCE DOUBLE N Regimen detail sequence
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 - REGIMEN_CAT_DETAIL


Child Column in REGIMEN_CAT_DETAIL(FK) Parent Table Name Parent Column Name
Parents: REGIMEN_CATALOG_ID REGIMEN_CATALOG REGIMEN_CATALOG_ID




Parent Column in REGIMEN_CAT_DETAIL (PK) Child Table Name Child Column Name
Children: REGIMEN_CAT_DETAIL_ID REGIMEN_CAT_DETAIL_R REGIMEN_CAT_DETAIL_S_ID
REGIMEN_CAT_DETAIL_R REGIMEN_CAT_DETAIL_T_ID
REGIMEN_DETAIL REGIMEN_CAT_DETAIL_ID


REGIMEN_CAT_DETAIL_R



Column Section Relationship Section Top of Page


Table-level Detail

Description: Regimen catalog detail relationship
Definition: Table used to store relationships such as offsets between different components of a regimen.
Table Type: REFERENCE





Column Detail - REGIMEN_CAT_DETAIL_R


Column Name Type Null? Definition
OFFSET_UNIT_CD DOUBLE N Identifies the offset unit (days, weeks, months).
OFFSET_VALUE DOUBLE N Offset quantity used to define a time offset for the relationship
REGIMEN_CATALOG_ID DOUBLE N The unique identifier for a REGIMEN_CATALOG. It will be used to uniquely identify a regimen. foreign key from REGIMEN_CATALOG
REGIMEN_CAT_DETAIL_R_ID DOUBLE N sequence name: reference_seq Unique identifier for the REGIMEN_CAT_DETAIL table.
REGIMEN_CAT_DETAIL_S_ID DOUBLE N This is the value of the unique primary identifier on the REGIMEN_CAT_DETAIL table. It is an internal system assigned number.
REGIMEN_CAT_DETAIL_T_ID DOUBLE N This is the value of the unique primary identifier on the REGIMEN_CAT_DETAIL table. It is an internal system assigned number.
TYPE_MEAN VARCHAR(12) N Identifies the type of relationship.
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 - REGIMEN_CAT_DETAIL_R


Child Column in REGIMEN_CAT_DETAIL_R(FK) Parent Table Name Parent Column Name
Parents: REGIMEN_CATALOG_ID REGIMEN_CATALOG REGIMEN_CATALOG_ID
REGIMEN_CAT_DETAIL_S_ID REGIMEN_CAT_DETAIL REGIMEN_CAT_DETAIL_ID
REGIMEN_CAT_DETAIL_T_ID REGIMEN_CAT_DETAIL REGIMEN_CAT_DETAIL_ID


REGIMEN_CAT_FACILITY_R



Column Section Relationship Section Top of Page


Table-level Detail

Description: Regimen Catalog Facility Relationship
Definition: Facility flexing definition / Facility access for regimen catalog.
Table Type: REFERENCE





Column Detail - REGIMEN_CAT_FACILITY_R


Column Name Type Null? Definition
LOCATION_CD DOUBLE N Location to which regimen is flexed to
REGIMEN_CATALOG_ID DOUBLE N The unique identifier for a REGIMEN_CATALOG. It will be used to uniquely identify a regimen. foreign key from REGIMEN_CATALOG
REGIMEN_CAT_FACILITY_R_ID DOUBLE N sequence name: reference_seq Unique identifier for the REGIMEN_CAT_FACILITY_R 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 - REGIMEN_CAT_FACILITY_R


Child Column in REGIMEN_CAT_FACILITY_R(FK) Parent Table Name Parent Column Name
Parents: REGIMEN_CATALOG_ID REGIMEN_CATALOG REGIMEN_CATALOG_ID


REGIMEN_CAT_SYNONYM



Column Section Relationship Section Top of Page


Table-level Detail

Description: Regimen Synonym
Definition: Display name synonyms for regimen catalog
Table Type: REFERENCE





Column Detail - REGIMEN_CAT_SYNONYM


Column Name Type Null? Definition
PRIMARY_IND DOUBLE N Indicates whether the entry is a primary synonym entry
REGIMEN_CATALOG_ID DOUBLE N The unique identifier for a REGIMEN_CATALOG. It will be used to uniquely identify a regimen. foreign key from REGIMEN_CATALOG
REGIMEN_CAT_SYNONYM_ID DOUBLE N sequence name: reference_seq Unique identifier for the REGIMEN_CAT_SYNONYM table.
SYNONYM_DISPLAY VARCHAR(100) N DISPLAY NAME FOR THE SYNONYM
SYNONYM_KEY VARCHAR(100) N Synonym key of the field synonym. This field has all capital letters and punctuation removed. It is used for indexing and searching for a regimen catalog.
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 - REGIMEN_CAT_SYNONYM


Child Column in REGIMEN_CAT_SYNONYM(FK) Parent Table Name Parent Column Name
Parents: REGIMEN_CATALOG_ID REGIMEN_CATALOG REGIMEN_CATALOG_ID




Parent Column in REGIMEN_CAT_SYNONYM (PK) Child Table Name Child Column Name
Children: REGIMEN_CAT_SYNONYM_ID ALT_SEL_LIST REGIMEN_CAT_SYNONYM_ID