Table Detail Report

SA_REF_EXCLUDE_ITEM



Column Section Relationship Section Top of Page


Table-level Detail

Description: SA REF EXCLUDE ITEM
Definition: ANESTHESIA REFERENCE EXCLUDE ITEM
Table Type: REFERENCE





Column Detail - SA_REF_EXCLUDE_ITEM


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.
ACTIVE_STATUS_CD DOUBLE N Indicates the status of the row itself (not the data in the row) such as active, inactive, combined away, pending purge, etc.
ACTIVE_STATUS_DT_TM DATETIME N The date and time that the active_status_cd was set.
ACTIVE_STATUS_PRSNL_ID DOUBLE N The person who caused the active_status_cd to be set or change.
SA_REF_DOC_TYPE_ID DOUBLE N Doc Type that item is excluded from
SA_REF_EXCLUDE_ITEM_ID DOUBLE N Unique identifier for row
SA_REF_ITEM_ID DOUBLE N Item to be excluded from document type
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 - SA_REF_EXCLUDE_ITEM


Child Column in SA_REF_EXCLUDE_ITEM(FK) Parent Table Name Parent Column Name
Parents: SA_REF_DOC_TYPE_ID SA_REF_DOC_TYPE SA_REF_DOC_TYPE_ID
SA_REF_ITEM_ID SA_REF_ITEM SA_REF_ITEM_ID


SA_REF_EXCLUDE_MEDICATION



Column Section Relationship Section Top of Page


Table-level Detail

Description: SA REF EXCLUDE MED
Definition: ANESTHESIA EXCLUDE MEDICATION
Table Type: REFERENCE





Column Detail - SA_REF_EXCLUDE_MEDICATION


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.
ACTIVE_STATUS_CD DOUBLE N Indicates the status of the row itself (not the data in the row) such as active, inactive, combined away, pending purge, etc.
ACTIVE_STATUS_DT_TM DATETIME N The date and time that the active_status_cd was set.
ACTIVE_STATUS_PRSNL_ID DOUBLE N The person who caused the active_status_cd to be set or change.
SA_REF_DOC_TYPE_ID DOUBLE N Doc Type that medication is excluded from
SA_REF_EXCLUDE_MEDICATION_ID DOUBLE N Unique identifier for row
SA_REF_MEDICATION_ID DOUBLE N Medication to be excluded from document type
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 - SA_REF_EXCLUDE_MEDICATION


Child Column in SA_REF_EXCLUDE_MEDICATION(FK) Parent Table Name Parent Column Name
Parents: SA_REF_DOC_TYPE_ID SA_REF_DOC_TYPE SA_REF_DOC_TYPE_ID
SA_REF_MEDICATION_ID SA_REF_MEDICATION SA_REF_MEDICATION_ID


SA_REF_EXCLUDE_PARAMETER



Column Section Relationship Section Top of Page


Table-level Detail

Description: SA REF EXCLUDE PARAM
Definition: ANESTHESIA REFERENCE EXCLUDE PARAMETER
Table Type: REFERENCE





Column Detail - SA_REF_EXCLUDE_PARAMETER


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.
ACTIVE_STATUS_CD DOUBLE N Indicates the status of the row itself (not the data in the row) such as active, inactive, combined away, pending purge, etc.
ACTIVE_STATUS_DT_TM DATETIME N The date and time that the active_status_cd was set.
ACTIVE_STATUS_PRSNL_ID DOUBLE N The person who caused the active_status_cd to be set or change.
SA_REF_DOC_TYPE_ID DOUBLE N Doc Type that parameter is excluded from
SA_REF_EXCLUDE_PARAMETER_ID DOUBLE N Unique identifier for row
SA_REF_PARAMETER_ID DOUBLE N Parameter to be excluded from document type
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 - SA_REF_EXCLUDE_PARAMETER


Child Column in SA_REF_EXCLUDE_PARAMETER(FK) Parent Table Name Parent Column Name
Parents: SA_REF_DOC_TYPE_ID SA_REF_DOC_TYPE SA_REF_DOC_TYPE_ID
SA_REF_PARAMETER_ID SA_REF_PARAMETER SA_REF_PARAMETER_ID


SA_REF_EXCLUDE_POSITION



Column Section Relationship Section Top of Page


Table-level Detail

Description: SA Ref Exclude Prsnl Position
Definition: Define what positions will not be shown for given document type
Table Type: REFERENCE





Column Detail - SA_REF_EXCLUDE_POSITION


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.
ACTIVE_STATUS_CD DOUBLE N Indicates the status of the row itself (not the data in the row) such as active, inactive, combined away, pending purge, etc.
ACTIVE_STATUS_DT_TM DATETIME N The date and time that the active_status_cd was set.
ACTIVE_STATUS_PRSNL_ID DOUBLE N The person who caused the active_status_cd to be set or change.
POSITION_CD DOUBLE N Position that will be excluded from the doc type
SA_REF_DOC_TYPE_ID DOUBLE N Doc Type the position is excluded from
SA_REF_EXCLUDE_POSITION_ID DOUBLE N Unique Identifier for 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 - SA_REF_EXCLUDE_POSITION


Child Column in SA_REF_EXCLUDE_POSITION(FK) Parent Table Name Parent Column Name
Parents: SA_REF_DOC_TYPE_ID SA_REF_DOC_TYPE SA_REF_DOC_TYPE_ID


SA_REF_EXCLUDE_PROVIDER



Column Section Relationship Section Top of Page


Table-level Detail

Description: SA Ref Exclude Prsnl Provider
Definition: Define what providers will not be shown for given document type
Table Type: REFERENCE





Column Detail - SA_REF_EXCLUDE_PROVIDER


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.
ACTIVE_STATUS_CD DOUBLE N Indicates the status of the row itself (not the data in the row) such as active, inactive, combined away, pending purge, etc.
ACTIVE_STATUS_DT_TM DATETIME N The date and time that the active_status_cd was set.
ACTIVE_STATUS_PRSNL_ID DOUBLE N The person who caused the active_status_cd to be set or change.
PRSNL_ID DOUBLE N Provider that will be excluded from the doc type
SA_REF_DOC_TYPE_ID DOUBLE N Doc Type the position is excluded from
SA_REF_EXCLUDE_PROVIDER_ID DOUBLE N Unique Identifier for 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 - SA_REF_EXCLUDE_PROVIDER


Child Column in SA_REF_EXCLUDE_PROVIDER(FK) Parent Table Name Parent Column Name
Parents: PRSNL_ID PRSNL PERSON_ID
SA_REF_DOC_TYPE_ID SA_REF_DOC_TYPE SA_REF_DOC_TYPE_ID