uh_api_medical

Open

Stored Procedures

• p_create: Adds record to sprmedi table where pidm and medical code combination does not exist.

• p_update: Updated record on sprmedi table where pidm and medical code combination exists.

UH_API_MEDICAL.p_create:

JSON name:value pair input. Note: the name must always be in ALL CAPS

JSON name:value pair output: (Overall status of API submittal returned to STAR)

{ "status": "ERROR"}

• ERROR

• SUCCESS

{ "messages": “PIDM does not exist”}

• ERROR: Message to why record was not created

• SUCCESS: Message stating record was created

Error Messages:

• No data submitted: No data provided on submit.

• PIDM does not exist: The PIDM submitted is not a valid PIDM on the spriden table.

• Medical Code not given: The medi_code submitted is null.

• Medical Code not valid: The medi_code submitted is not one of the following: MR, TB, VC, TD, or MC.

• Onset Age not give: The onset_age submitted is null.

• Onset Age not valid: The onset_age submitted is not one of the following: 1, 2, 3, 4, 5, 6.

• Disability Service Code not given: The spsr_code submitted is null.

• Disability Service Code not valid: the spsr_code submitted does not exist in the stvspsr table.

• Record already exists: The pidm and medi_code already exists on sprmedi table.

Successful creation add the following data:

UH_API_MEDICAL.p_update:

JSON name:value pair input. Note: the name must always be in ALL CAPS

JSON name:value pair output: (Overall status of API submittal returned to STAR)

{ "status": "ERROR"}

• ERROR

• SUCCESS

{ "messages": “PIDM does not exist”}

• ERROR: Message to why record was not created

• SUCCESS: Message stating record was created

Error Messages:

• No data submitted: No data provided on submit.

• PIDM does not exist: The PIDM submitted is not a valid PIDM on the spriden table.

• Medical Code not given: The medi_code submitted is null.

• Medical Code not valid: The medi_code submitted is not one of the following: MR, TB, VC, TD, or MC.

• Onset Age not give: The onset_age submitted is null.

• Onset Age not valid: The onset_age submitted is not one of the following: 1, 2, 3, 4, 5, 6.

• Disability Service Code not given: The spsr_code submitted is null.

• Disability Service Code not valid: the spsr_code submitted does not exist in the stvspsr table.

• Record does not exist: The pidm and medi_code does not exist on sprmedi table.

• Record NOT created: Error inserting record.

Successful update updates the following data: