Skip to content

aws.transcribe.list_medical_transcription_jobs

Example SQL Queries

SELECT * FROM
aws.transcribe.list_medical_transcription_jobs;

Description

Provides a list of medical transcription jobs that match the specified criteria. If no criteria are specified, all medical transcription jobs are returned.

To get detailed information about a specific medical transcription job, use the operation.

Table Definition

Column NameColumn Data Type
job_name_contains Input Column

Returns only the medical transcription jobs that contain the specified string. The search is not case sensitive.

VARCHAR
max_results Input Column

The maximum number of medical transcription jobs to return in each page of results. If there are fewer results than the value that you specify, only the actual results are returned. If you do not specify a value, a default of 5 is used.

BIGINT
next_token Input Column

If NextToken is present in your response, it indicates that not all results are displayed. To view the next set of results, copy the string associated with the NextToken parameter in your results output, then run your request again including NextToken with the value of the copied string. Repeat as needed to view all your results.

VARCHAR
status Input Column

Lists all medical transcription jobs that have the status specified in your request. Jobs are ordered by creation date, with the newest job first.

VARCHAR
_aws_profile Input Column

The AWS profile defines the AWS identity used. It can be defined via credentials or by assuming a IAM role.

STRUCT(
"type" VARCHAR,
"name" VARCHAR,
"account_id" VARCHAR,
"via_profile_name" VARCHAR,
"assumed_role_arn" VARCHAR,
"organization" STRUCT(
"account_name" VARCHAR,
"id" VARCHAR,
"tags" STRUCT(
"key" VARCHAR,
"value" VARCHAR
)[],
"master_account" STRUCT(
"id" VARCHAR,
"email" VARCHAR
),
"parents" STRUCT(
"type" VARCHAR,
"id" VARCHAR,
"name" VARCHAR,
"tags" STRUCT(
"key" VARCHAR,
"value" VARCHAR
)[]
)[]
)
)
Show child fields
_aws_profile.account_id

The AWS account id

_aws_profile.assumed_role_arn

The ARN of the assumed role

_aws_profile.name

The unique name of the profile.

_aws_profile.organization

Information about this profile's membership in the AWS organization.

Show child fields
_aws_profile.organization.account_name

The name of account speciifed by the organization

_aws_profile.organization.id

The organization id

_aws_profile.organization.master_account
Show child fields
_aws_profile.organization.master_account.email

The organization master account email address

_aws_profile.organization.master_account.id

The organization master account id

_aws_profile.organization.parents[]
Show child fields
_aws_profile.organization.parents[].id

The id of the parent

_aws_profile.organization.parents[].name

The name of the parent

_aws_profile.organization.parents[].tags[]
Show child fields
_aws_profile.organization.parents[].tags[].key
_aws_profile.organization.parents[].tags[].value
_aws_profile.organization.parents[].type

The type of parent can be an organization unit or a root

_aws_profile.organization.tags[]
Show child fields
_aws_profile.organization.tags[].key
_aws_profile.organization.tags[].value
_aws_profile.type

The type of profile, either 'credentials' or 'assumed_role'

_aws_profile.via_profile_name

This IAM role for this profile is assumed by first utilizing another profile with this name to obtain credentials.

_aws_region Input Column

The AWS region to use.

VARCHAR
medical_transcription_job_summaries

Provides a summary of information about each result.

STRUCT(
"medical_transcription_job_name" VARCHAR,
"creation_time" TIMESTAMP_S,
"start_time" TIMESTAMP_S,
"completion_time" TIMESTAMP_S,
"language_code" VARCHAR,
"transcription_job_status" VARCHAR,
"failure_reason" VARCHAR,
"output_location_type" VARCHAR,
"specialty" VARCHAR,
"content_identification_type" VARCHAR,
"type" VARCHAR
)[]
Show child fields
medical_transcription_job_summaries[]
Show child fields
medical_transcription_job_summaries[].completion_time

The date and time the specified medical transcription job finished processing.

Timestamps are in the format YYYY-MM-DD'T'HH:MM:SS.SSSSSS-UTC. For example, 2022-05-04T12:33:13.922000-07:00 represents a transcription job that started processing at 12:33 PM UTC-7 on May 4, 2022.

medical_transcription_job_summaries[].content_identification_type

Labels all personal health information (PHI) identified in your transcript. For more information, see Identifying personal health information (PHI) in a transcription.

medical_transcription_job_summaries[].creation_time

The date and time the specified medical transcription job request was made.

Timestamps are in the format YYYY-MM-DD'T'HH:MM:SS.SSSSSS-UTC. For example, 2022-05-04T12:32:58.761000-07:00 represents a transcription job that started processing at 12:32 PM UTC-7 on May 4, 2022.

medical_transcription_job_summaries[].failure_reason

If TranscriptionJobStatus is FAILED, FailureReason contains information about why the transcription job failed. See also: Common Errors.

medical_transcription_job_summaries[].language_code

The language code used to create your medical transcription. US English (en-US) is the only supported language for medical transcriptions.

medical_transcription_job_summaries[].medical_transcription_job_name

The name of the medical transcription job. Job names are case sensitive and must be unique within an Amazon Web Services account.

medical_transcription_job_summaries[].output_location_type

Indicates where the specified medical transcription output is stored.

If the value is CUSTOMER_BUCKET, the location is the Amazon S3 bucket you specified using the OutputBucketName parameter in your request. If you also included OutputKey in your request, your output is located in the path you specified in your request.

If the value is SERVICE_BUCKET, the location is a service-managed Amazon S3 bucket. To access a transcript stored in a service-managed bucket, use the URI shown in the TranscriptFileUri field.

medical_transcription_job_summaries[].specialty

Provides the medical specialty represented in your media.

medical_transcription_job_summaries[].start_time

The date and time your medical transcription job began processing.

Timestamps are in the format YYYY-MM-DD'T'HH:MM:SS.SSSSSS-UTC. For example, 2022-05-04T12:32:58.789000-07:00 represents a transcription job that started processing at 12:32 PM UTC-7 on May 4, 2022.

medical_transcription_job_summaries[].transcription_job_status

Provides the status of your medical transcription job.

If the status is COMPLETED, the job is finished and you can find the results at the location specified in TranscriptFileUri. If the status is FAILED, FailureReason provides details on why your transcription job failed.

medical_transcription_job_summaries[].type

Indicates whether the input media is a dictation or a conversation, as specified in the StartMedicalTranscriptionJob request.