Table Detail Report

AP_PROMPT



Column Section Relationship Section Top of Page


Table-level Detail

Description: AP Prompt
Definition: Prompt tests for specimen procedures.
Table Type: REFERENCE





Column Detail - AP_PROMPT


Column Name Type Null? Definition
ACTION_FLAG DOUBLE N Contains the value used for the prompt procedure action
AP_PROMPT_ID DOUBLE N Contains the identifier to uniquely identify an AP prompt.
CATALOG_CD DOUBLE N Contains the specimen order catalog item.
LONG_TEXT_ID DOUBLE N Contains the prompt template text.
TASK_ASSAY_CD DOUBLE N Contains the code for the specimen prompt procedure.
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 - AP_PROMPT


Child Column in AP_PROMPT(FK) Parent Table Name Parent Column Name
Parents: LONG_TEXT_ID LONG_TEXT_REFERENCE LONG_TEXT_ID




Parent Column in AP_PROMPT (PK) Child Table Name Child Column Name
Children: AP_PROMPT_ID AP_PROMPT_FIELD AP_PROMPT_ID


AP_PROMPT_FIELD



Column Section Relationship Section Top of Page


Table-level Detail

Description: AP Prompt Field
Definition: Defines the fields prompted for in the prompt tests for specimen procedures.
Table Type: REFERENCE





Column Detail - AP_PROMPT_FIELD


Column Name Type Null? Definition
ACTION_FLAG DOUBLE N Prompt field action.
AP_PROMPT_FIELD_ID DOUBLE N Contains the unique identifier for the AP Prompt Field
AP_PROMPT_ID DOUBLE N Contains the unique identifier of the AP prompt related to this field.
FIELD_NBR_SEQ DOUBLE N Contains the prompt field sequence number.
FIELD_TYPE_TXT VARCHAR(30) N Contains a textual description of the field type.
OE_FIELD_ID DOUBLE N Contains the identifier that links this prompt field to a specific order entry.
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 - AP_PROMPT_FIELD


Child Column in AP_PROMPT_FIELD(FK) Parent Table Name Parent Column Name
Parents: AP_PROMPT_ID AP_PROMPT AP_PROMPT_ID
OE_FIELD_ID ORDER_ENTRY_FIELDS OE_FIELD_ID


AP_PROMPT_TEST



Column Section Relationship Section Top of Page


Table-level Detail

Description: AP Prompt Test
Definition: This activity table contains prompt test information associated with a pathology case. Prompt test information is automatically moved to the appropriate pathology report when the report is modified via an AP result entry application.
Table Type: ACTIVITY





Column Detail - AP_PROMPT_TEST


Column Name Type Null? Definition
ACCESSION_ID DOUBLE N This field contains the foreign key value used to identify the accession value to which order is associated with.
ACTIVE_IND DOUBLE Y 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.
LONG_TEXT_ID DOUBLE N This field contains the value representing the entry on the LONG_TEXT table that contains the result information associated withthe prompt text. This internal, system-assigned number could be used to join to the result information stored on the LONG_TEXT table.
TASK_ASSAY_CD DOUBLE N This field contains the internal identification code of the discrete task that represents the prompt test. This value could be used to join to task-specific information stored on the DISCRETE_TASK_ASSAY 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 - AP_PROMPT_TEST


Child Column in AP_PROMPT_TEST(FK) Parent Table Name Parent Column Name
Parents: ACCESSION_ID ACCESSION ACCESSION_ID
TASK_ASSAY_CD DISCRETE_TASK_ASSAY TASK_ASSAY_CD
LONG_TEXT_ID LONG_TEXT LONG_TEXT_ID


AP_PRSNL_PRIV



Column Section Relationship Section Top of Page


Table-level Detail

Description: AP Personnel Privileges
Definition: This table allows AP personnel to grant privileges to other individuals or groups.
Table Type: REFERENCE





Column Detail - AP_PRSNL_PRIV


Column Name Type Null? Definition
PRIVILEGE_CD DOUBLE N This field defines the privilege that is being granted. Valid values are defined on code_set 21629
PRIVILEGE_ID DOUBLE N This field contains the unique identifier for this table
PRSNL_ID DOUBLE N This field contains the PERSON_ID of the person who is granting privileges.
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 - AP_PRSNL_PRIV


Child Column in AP_PRSNL_PRIV(FK) Parent Table Name Parent Column Name
Parents: PRSNL_ID PRSNL PERSON_ID


AP_PRSNL_PRIV_R



Column Section Top of Page


Table-level Detail

Description: AP Personnel Privileges Resolution
Definition: This table holds the individuals and/or user groups that an AP user has granted a specific privilege.
Table Type: REFERENCE





Column Detail - AP_PRSNL_PRIV_R


Column Name Type Null? Definition
PARENT_ENTITY_ID DOUBLE N The value of the primary identifier of the table to which the 'ap_prsnl_priv' row is related (PRSNL_GROUP_ID from the PRSNL_GROUP table, PERSON_ID from the PRSNL table).
PARENT_ENTITY_NAME VARCHAR(32) N The upper case name of the table to which this 'ap_prsnl_priv' row is related. Valid values for this column are PRSNL_GROUP and PRSNL.
PRIVILEGE_ID DOUBLE N This field contains the foreign key value used to join to AP_PRSNL_PRIV table.
PROXY_BEG_DT_TM DATETIME Y Displays the date when the assigned proxy begins.
PROXY_END_DT_TM DATETIME Y Displays the date when the assigned proxy ends.
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.