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 |