Scribd
Upload
28 views6 pages

API Visit Type and Follow-Up Services

The document outlines SQL queries for adding a column 'Visit_Type_Based_On_API' to the 'Branch_Based_Settings_List' table and specifies the API details for patient visit types and follow-up services. It describes the usage of these APIs in various processes such as quick registration, package handling, and payment updates. Additionally, it provides function details for handling visit type changes and follow-up service requests within the application code.

Uploaded by

yuva_1987
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
28 views6 pages

API Visit Type and Follow-Up Services

The document outlines SQL queries for adding a column 'Visit_Type_Based_On_API' to the 'Branch_Based_Settings_List' table and specifies the API details for patient visit types and follow-up services. It describes the usage of these APIs in various processes such as quick registration, package handling, and payment updates. Additionally, it provides function details for handling visit type changes and follow-up service requests within the application code.

Uploaded by

yuva_1987
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd

API

VISIT TYPE & SERVICE

Required sql query (to visit type)

"IF NOT EXISTS (SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE


TABLE_NAME='Branch_Based_Settings_List' AND COLUMN_NAME='Visit_Type_Based_On_API')
BEGIN
ALTER TABLE Branch_Based_Settings_List ADD Visit_Type_Based_On_API nvarchar(1) not null Default ('Y')
END"

Branch_Based_Settings_List column Visit_Type_Based_On_API is should 'Y'

Branch_Based_API_Details should Label_Name='patient_visit_type_api' and


Label_Value='[Link]

Label_Value Can be changed

Visit type changes Function Details

Visit type changes Function Details

Have a common function will called to visit type

local/app/Http/Controllers/[Link]

Function jsonArrayData(para1,para2,para3);

1. para1 >>> Patient Basic Details Serial No

2. para2 >>> Type (Action name for our reference (module name) )

3. para3 >>> (if necessary changed data or empty)

Followup & paid followup count details

Count has been taken at the branch master (below screenshot)


API

We take the count from this (Cash & insurance )

Used place

This process is currently used in 4 places.

1. Quick registration
[Link]
[Link] type and service was added when resource onchanged. (Datailed Visit Registration)
4. Payment type save&update (Datailed Visit Registration)

I set free follow up count 2 & paid follow up count 2.


You will get a response like this below attachment. (file name: Followup_api)
API

[Link] Registration

[Link]

When a new visit is created

[Link] type and service was added when resource onchanged. (Datailed Visit
Registration)

When resource change is made, service is added & visit type changed
API

4. Payment type save&update (Datailed Visit Registration)

Request sample data

filename : visittype_service_api
API

Followup service API

Required sql query (to Followup


service)

"IF NOT EXISTS (SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE


TABLE_NAME='Branch_Based_Settings_List' AND COLUMN_NAME='Visit_Type_Based_On_API')
BEGIN
ALTER TABLE Branch_Based_Settings_List ADD Visit_Type_Based_On_API nvarchar(1) not null Default ('Y')
END"

Branch_Based_Settings_List column Visit_Type_Based_On_API is should 'Y'

Branch_Based_API_Details should Label_Name='patient_followup_service_api' and


Label_Value='[Link]

Label_Value Can be changed

When saving this, the api is called to below master

BRANCH FREE/PAID FOLLOWUP SERVICES & INSURANCE COMPANY BRANCH BASED


FOLLOWUP SERVICES

api called (ADD & UPDATE)

local/app/Http/Controllers/[Link]
Function followupServiceApi(para1,para2,para3,para4)

1. para1 >>>> sussdbserialno

2. para1 >>>> unique serialno

3. para1 >>>> specialitycode

4. para1 >>>> Paidfreeservstaus


API

Request sample data

filename :followupserviceApi

You might also like