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 |