Table Detail Report

PL_CLIENT_DEFAULTS



Column Section Relationship Section Top of Page


Table-level Detail

Description: PL CLIENT DEFAULTS
Definition: This table stores client level default settings.
Table Type: REFERENCE





Column Detail - PL_CLIENT_DEFAULTS


Column Name Type Null? Definition
ABN_COPIES DOUBLE Y Notifies Pahtlink Applications of how many ABN forms to print.
BILL_TYPE_FLAG DOUBLE Y Determines the need for bill type in ePathLink Applications.
BILL_TYPE_IND DOUBLE Y Indicates whether client or patient bill type will be selected by default
CLIENT_BILL_ENCNTR_TYPE_CD DOUBLE N This represents the encounter type that is used when client bill type is chosen.
CLIENT_BILL_FIN_CLASS_CD DOUBLE N The financial class to be used when client bill type is selected.
CLIENT_SEQUENCE DOUBLE Y Used to determine if a default row exists.
COLLECTION_PRIORITY_CD DOUBLE N This determines the default COLLECT PRIORITY.
COLLECT_BY_PERSON_ID DOUBLE N Indicates the default person id to appear in the Collected By field.
COLLECT_BY_USER_IND DOUBLE Y Indicates whether or not to default the current user's user ID into the Collected By field.
CREATE_MRN_IND DOUBLE Y Indicates a new MRN should be created if one has not already been created.
CURDATE_IND DOUBLE Y Indicates whether or not to default the current date into the collection date field
CURTIME_IND DOUBLE Y Indicates whether or not to default the current time into the collection time field.
DIAGNOSIS_FLAG DOUBLE Y Indicates whether order level diagnosis are required based on bill type.
FINANCIAL_CLASS_LABEL VARCHAR(30) Y User-defined label for the data field receiving financial class.
FIN_ASSIGNMENT_FLAG DOUBLE Y Indicates how the financial number is assigned
FIN_BY_PLAN_FLAG DOUBLE Y Indicate3s whether or not to default the financial class based on the selected primary insurance health plan (0 - Do not default, 1 - Default if client bill, 2 - Default if patient bill, or 3 - Default).
FIN_CLASS_FLAG DOUBLE Y Indicates when the field should be enabled, required, or disabled.
INSURANCE_CO_FLAG DOUBLE Y Indicates whether or not the insurance company field on the insurance tab in ePathlink should be required, enabled but not required, or disabled based on bill type.
LOCATION_FLAG DOUBLE Y Determines whether or not buildings or ambulatory locations are used to populate the location list in the app.
MRN_ASSIGNMENT_FLAG DOUBLE Y Indicates how the medical record number should get assigned
NEW_REG_FLAG DOUBLE Y Indicates how the person and encounter is selected or created during and ordering conversation.
ORDERING_PHYS_DISPLAY VARCHAR(30) Y Indicates the default ordering physician
ORDERING_PHYS_ID DOUBLE N Indicates the default ordering physician's ID
ORGANIZATION_ID DOUBLE N Organization id is the key to the table, which identifies the client for which these defaults will be used.
ORG_SECURITY_IND DOUBLE Y Indicates whether organization level security is turned on if Lab organization security is off.
PATIENT_ALIAS_FLAG DOUBLE Y Indicates whether or not this field is required or disabled.
PATIENT_BILL_ENCNTR_TYPE_CD DOUBLE N Indicates the encounter type to use when patient bill type is selected.
PATIENT_BILL_FIN_CLASS_CD DOUBLE N Indicates the financial class to use when patient bill type is selected.
PERSON_SECURITY_IND DOUBLE Y Indicates whether person level security is turned on or not.
PHONE_TYPE_CD DOUBLE N Indicates the default call back phone type
REG_PHYSICIAN_TYPE_CD DOUBLE N Indicates the physician type to be used for the registering physicians.
REG_PHYS_TYPE_DISPLAY VARCHAR(30) Y Indicates the label to be used above the registering physician selection field.
REPORTING_PRIORITY_CD DOUBLE N Indicates the default reporting priority to be used
REQUIRED_DIAGNOSIS_FLAG DOUBLE Y Indicates whether or not an encounter level diagnosis is required based on the selected bill type.
SEARCH_START_FLAG DOUBLE Y Detremines the need for this field in PathLink Applications.
TRIGGER_ADT_IND DOUBLE Y Indicates whether or not person/encounter updates will trigger an ADT.
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 - PL_CLIENT_DEFAULTS


Child Column in PL_CLIENT_DEFAULTS(FK) Parent Table Name Parent Column Name
Parents: ORGANIZATION_ID ORGANIZATION ORGANIZATION_ID
COLLECT_BY_PERSON_ID PRSNL PERSON_ID


PL_DEFAULTS



Column Section Top of Page


Table-level Detail

Description: This table stores global default settings
Definition: This table stores global default settings for
Table Type: REFERENCE





Column Detail - PL_DEFAULTS


Column Name Type Null? Definition
ACTIVATE_PERSON_IND DOUBLE Y Indicates whether person level security is turned on or not.
ADDRESS_FLAG DOUBLE Y Indicates when the field should be enabled, required, or disabled.
ADD_PHYS_IND DOUBLE Y Indicates whether or not the user will be allowed to add free text physicians.
AGE_FLAG DOUBLE Y Indicates when the field should be enabled, required, or disabled.
BIRTH_DATE_FLAG DOUBLE Y Indicates when the field should be enabled, required, or disabled.
BIRTH_TIME_FLAG DOUBLE Y Indicates when the field should be enabled, required, or disabled.
BUSINESS_PHONE_FLAG DOUBLE Y Indicates when the field should be enabled, required, or disabled.
CITY_FLAG DOUBLE Y Indicates when the field should be enabled, required, or disabled.
FIRST_NAME_FLAG DOUBLE Y Indicates when the field should be enabled, required, or disabled.
HOME_PHONE_FLAG DOUBLE Y Indicates when the field should be enabled, required, or disabled.
LANGUAGE_FLAG DOUBLE Y This field contains a flag indicating whether language is a required field during registration for client and patient bill types. 0 - Neither, 1 - Client, 2 - Patient, 3 - Both, 4 - Disable
MIDDLE_NAME_FLAG DOUBLE Y Indicates when the field should be enabled, required, or disabled.
ORDER_COMMENT_FLAG DOUBLE Y Indicates comments and/or notes can be added or modfied.
PL_DEFAULTS_KEY VARCHAR(10) N Table Key
RACE_FLAG DOUBLE Y Indicates when the field should be enabled, required, or disabled.
ROOT_MENU_NODE VARCHAR(20) Y Custom description for the root menu node for Webtop
SEX_FLAG DOUBLE Y Indicates when the field should be enabled, required, or disabled.
SSN_FLAG DOUBLE Y Indicates when the field should be enabled, required, or disabled.
STATE_FLAG DOUBLE Y Indicates when the field should be enabled, required, or disabled.
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.
ZIP_FLAG DOUBLE Y Indicates when the field should be enabled, required, or disabled.


PL_DEMOGRAPHICS



Column Section Relationship Section Top of Page


Table-level Detail

Description: PL DEMOGRAPHICS
Definition: This table the demographic elements to be displayed for each client.
Table Type: REFERENCE





Column Detail - PL_DEMOGRAPHICS


Column Name Type Null? Definition
DEMOGRAPHIC_CD DOUBLE N Indicates the demographic element to be displayed for the associated client
DEMO_SEQUENCE DOUBLE Y Indicates the order inwhich this demographic element appears.
DISPLAY_LABEL CHAR(30) Y The display label for the demographic element.
ORGANIZATION_ID DOUBLE N Indicates the client that the demographic element should appear for in the demographics display
PL_DEMOGRAPHICS_ID DOUBLE N Unique identifier for the row.
SEQUENCE DOUBLE Y The order of the selected demographics.
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 - PL_DEMOGRAPHICS


Child Column in PL_DEMOGRAPHICS(FK) Parent Table Name Parent Column Name
Parents: ORGANIZATION_ID ORGANIZATION ORGANIZATION_ID


PL_EXCHANGE_DEFAULTS



Column Section Relationship Section Top of Page


Table-level Detail

Description: PL EXCHANGE DEFAULTS
Definition: This table stores application fields that are required by the performing lab.
Table Type: REFERENCE





Column Detail - PL_EXCHANGE_DEFAULTS


Column Name Type Null? Definition
EXCHANGE_FIELD_CD DOUBLE N The code value of the field that is required by the performing lab for the order being placed.
ORGANIZATION_ID DOUBLE N Organizatgion id is the key to the table, which identifies the exchange lab for which these defaults will be used.
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 - PL_EXCHANGE_DEFAULTS


Child Column in PL_EXCHANGE_DEFAULTS(FK) Parent Table Name Parent Column Name
Parents: ORGANIZATION_ID ORGANIZATION ORGANIZATION_ID


PL_INSURANCE_DEFAULTS



Column Section Relationship Section Top of Page


Table-level Detail

Description: This table stores the configuration of the insurance fields based on ins co
Definition: This table stores the configuration of the insurance fields based on insurance companies.
Table Type: REFERENCE





Column Detail - PL_INSURANCE_DEFAULTS


Column Name Type Null? Definition
DISPLAY_LABEL CHAR(30) Y Customized label for this field and insurance combination.
FIELD_CD DOUBLE N Insurance field that is being customized.
FIELD_TYPE_FLAG DOUBLE Y Indicates the type of insurance field being customized.
ORGANIZATION_ID DOUBLE N Organizatgion id is the key to the table, which identifies the insurance organization for which these defaults will be used.
PL_INSURANCE_DEFAULTS_ID DOUBLE N Unique identifier for each row on the table.
REQUIRED_IND DOUBLE Y Indicates whether the insurance field should be required or not.
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 - PL_INSURANCE_DEFAULTS


Child Column in PL_INSURANCE_DEFAULTS(FK) Parent Table Name Parent Column Name
Parents: ORGANIZATION_ID ORGANIZATION ORGANIZATION_ID