CareRequestItem

Name	Label	Type	Description
Id	Care Request Item ID	ID
IsDeleted	Deleted	CHECKBOX
Name	Name	TEXT(255)
RecordTypeId	Record Type ID	LOOKUP
CreatedDate	Created Date	DATETIME
CreatedById	Created By ID	LOOKUP
LastModifiedDate	Last Modified Date	DATETIME
LastModifiedById	Last Modified By ID	LOOKUP
SystemModstamp	System Modstamp	DATETIME
LastViewedDate	Last Viewed Date	DATETIME
LastReferencedDate	Last Referenced Date	DATETIME
CareRequestCaseId	Case ID	MASTER-DETAIL
CodeTypeIdentifier	Code Type ID	TEXT(255)
CodeType	Code Type	PICKLIST
CodeDescription	Code Description	TEXT(255)
Modifier	Modifier	TEXT(32)
ModifierDescription	Modifier Description	TEXT(255)
EffectiveDate	Effective Date	DATE
EndDate	End Date	DATE
Quantity	Quantity	AUTO NUMBER
ModifiedQuantity	Modified Quantity	AUTO NUMBER
ApprovedQuantity	Approved Quantity	AUTO NUMBER
DeniedQuantity	Denied Quantity	AUTO NUMBER
ModifiedCodeTypeIdentifier	Modified Code Type ID	TEXT(255)
ModifiedCodeType	Modified Code Type	PICKLIST
ModifiedCodeIdentifier	Modified Code	TEXT(32)
ModifiedCodeDescription	Modified Code Description	TEXT(255)
ModifiedModifier	Modified Modifier	TEXT(32)
ModifiedModifierDescription	Modified Modifier Description	TEXT(255)
ModifiedEffectiveDate	Modified Effective Date	DATE
ModifiedEndDate	Modified End Date	DATE
SourceSystemIdentifier	Source System Identifier	TEXT(255)
SourceSystem	Source System	TEXT(255)
SourceSystemModified	Source System Modified	DATETIME
ServiceCategory	Service Category	TEXT(64)
ServiceCategoryCode	Service Category Code	TEXT(64)
CareRequestId	Care Request ID	LOOKUP
ProcedureCodeId	Health Care Procedure ID	LOOKUP
ModifiedProcedureCodeId	Health Care Procedure ID	LOOKUP
Modifier2Description	Modifier 2 Description	TEXT(255)
Modifier2	Modifier 2	TEXT(32)
Modifier3Description	Modifier 3 Description	TEXT(255)
Modifier3	Modifier 3	TEXT(32)
Modifier4Description	Modifier 4 Description	TEXT(255)
Modifier4	Modifier 4	TEXT(32)
FreeFormProcedureDescription	Free Form Procedure Description	TEXT AREA(255)
QuantityType	Quantity Type	PICKLIST
TransportLocationId	Account ID	LOOKUP
AmbulanceTransportType	Ambulance Transport Type	PICKLIST
AmbulanceTransportDistance	Ambulance Transport Distance	NUMBER(5,2)
AmbulanceTransportReason	Ambulance Transport Reason	PICKLIST
Status	Status	PICKLIST
StatusReason	Status Reason	PICKLIST
CumulativeLengthOfStay	Cumulative Length of Stay	AUTO NUMBER
ApprovedLengthOfStay	Approved Length of Stay	AUTO NUMBER
RequestedLengthOfStay	Requested Length of Stay	AUTO NUMBER
ApprovedLevelOfCare	Approved Level of Care	PICKLIST
CurrentLevelOfCare	Current Level of Care	PICKLIST
DeniedLevelOfCare	Denied Level of Care	PICKLIST
ModifiedLevelOfCare	Modified Level of Care	PICKLIST
RequestedLevelOfCare	Requested Level of Care	PICKLIST
ApprovedServiceEndDate	Approved Service End Date	DATE
ApprovedServiceStartDate	Approved Service Start Date	DATE
ClinicalDetermination	Clinical Determination	PICKLIST
DecisionDate	Decision Date	DATETIME
ClinicalDeterminationReasonId	Code Set ID	LOOKUP
RequestedServiceEndDate	Requested Service End Date	DATE
RequestedServiceStartDate	Requested Service Start Date	DATE
ClinicalDeterminationNotes	Clinical Determination Notes	TEXT AREA (LONG)(4000)
ModifierCodeSetId	Modifier Code Set ID	LOOKUP
ProcedureCodeSetId	Procedure Code Set ID	LOOKUP
ModifiedProcedureCodeSetId	Modified Procedure Code Set ID	LOOKUP
AuthApprovalIdentifier	Authorization Approval Identifier	TEXT(255)
AuthorizationRefIdentifier	Authorization Reference Identifier	TEXT(255)
ServicingFacilityId	Servicing Facility ID	LOOKUP
ServicingProviderId	Healthcare Provider ID	LOOKUP
ClinicalServiceRequestId	Clinical Service Request ID	LOOKUP
RequestType	Request Type	PICKLIST
Priority	Priority	PICKLIST
ReasonCodeId	Reason Code ID	LOOKUP

Name	Id
Label	Care Request Item ID
Type	ID
Required	Yes

Name	IsDeleted
Label	Deleted
Type	CHECKBOX
Required	Yes
Default value	false

Name	Name
Label	Name
Type	TEXT(255)
Required	Yes

Name	RecordTypeId
Label	Record Type ID
Type	LOOKUP
Foreign key	Yes

Name	CreatedDate
Label	Created Date
Type	DATETIME
Required	Yes

Name	CreatedById
Label	Created By ID
Type	LOOKUP
Foreign key	Yes
Required	Yes

Name	LastModifiedDate
Label	Last Modified Date
Type	DATETIME
Required	Yes

Name	LastModifiedById
Label	Last Modified By ID
Type	LOOKUP
Foreign key	Yes
Required	Yes

Name	SystemModstamp
Label	System Modstamp
Type	DATETIME
Required	Yes

Name	LastViewedDate
Label	Last Viewed Date
Type	DATETIME

Name	LastReferencedDate
Label	Last Referenced Date
Type	DATETIME

Name	CareRequestCaseId
Label	Case ID
Type	MASTER-DETAIL
Foreign key	Yes
Required	Yes

Name	CodeTypeIdentifier
Label	Code Type ID
Type	TEXT(255)

Name	CodeType
Label	Code Type
Type	PICKLIST
Picklist values	CPT HCPCS

Name	CodeDescription
Label	Code Description
Type	TEXT(255)

Name	Modifier
Label	Modifier
Type	TEXT(32)

Name	ModifierDescription
Label	Modifier Description
Type	TEXT(255)

Name	EffectiveDate
Label	Effective Date
Type	DATE

Name	EndDate
Label	End Date
Type	DATE

Name	Quantity
Label	Quantity
Type	AUTO NUMBER

Name	ModifiedQuantity
Label	Modified Quantity
Type	AUTO NUMBER

Name	ApprovedQuantity
Label	Approved Quantity
Type	AUTO NUMBER

Name	DeniedQuantity
Label	Denied Quantity
Type	AUTO NUMBER

Name	ModifiedCodeTypeIdentifier
Label	Modified Code Type ID
Type	TEXT(255)

Name	ModifiedCodeType
Label	Modified Code Type
Type	PICKLIST
Picklist values	CPT HCPCS

Name	ModifiedCodeIdentifier
Label	Modified Code
Type	TEXT(32)

Name	ModifiedCodeDescription
Label	Modified Code Description
Type	TEXT(255)

Name	ModifiedModifier
Label	Modified Modifier
Type	TEXT(32)

Name	ModifiedModifierDescription
Label	Modified Modifier Description
Type	TEXT(255)

Name	ModifiedEffectiveDate
Label	Modified Effective Date
Type	DATE

Name	ModifiedEndDate
Label	Modified End Date
Type	DATE

Name	SourceSystemIdentifier
Label	Source System Identifier
Type	TEXT(255)

Name	SourceSystem
Label	Source System
Type	TEXT(255)

Name	SourceSystemModified
Label	Source System Modified
Type	DATETIME

Name	ServiceCategory
Label	Service Category
Type	TEXT(64)

Name	ServiceCategoryCode
Label	Service Category Code
Type	TEXT(64)

Name	CareRequestId
Label	Care Request ID
Type	LOOKUP
Foreign key	Yes
Required	Yes

Name	ProcedureCodeId
Label	Health Care Procedure ID
Type	LOOKUP
Foreign key	Yes

Name	ModifiedProcedureCodeId
Label	Health Care Procedure ID
Type	LOOKUP
Foreign key	Yes

Name	Modifier2Description
Label	Modifier 2 Description
Type	TEXT(255)

Name	Modifier2
Label	Modifier 2
Type	TEXT(32)

Name	Modifier3Description
Label	Modifier 3 Description
Type	TEXT(255)

Name	Modifier3
Label	Modifier 3
Type	TEXT(32)

Name	Modifier4Description
Label	Modifier 4 Description
Type	TEXT(255)

Name	Modifier4
Label	Modifier 4
Type	TEXT(32)

Name	FreeFormProcedureDescription
Label	Free Form Procedure Description
Type	TEXT AREA(255)

Name	QuantityType
Label	Quantity Type
Type	PICKLIST
Picklist values	Days Units Visits

Name	TransportLocationId
Label	Account ID
Type	LOOKUP
Foreign key	Yes

Name	AmbulanceTransportType
Label	Ambulance Transport Type
Type	PICKLIST
Picklist values	Initial Trip Return Trip Transfer Trip Round Trip

Name	AmbulanceTransportDistance
Label	Ambulance Transport Distance
Type	NUMBER(5,2)

Name	AmbulanceTransportReason
Label	Ambulance Transport Reason
Type	PICKLIST
Picklist values	Patient was transported to nearest facility for care of symptoms, complaints, or both Patient was transported for the benefit of a preferred physician Patient was transported for the nearness of family members Patient was transported for the care of a specialist or for availability of specialized equipment Patient Transferred to Rehabilitation Facility Patient Transferred to Residential Facility

Name	Status
Label	Status
Type	PICKLIST
Picklist values	Certified in Total Certified - Partial Modified Not Certified Cancelled Contact Payer No Action Required Complete Term Expired

Name	StatusReason
Label	Status Reason
Type	PICKLIST
Picklist values	Authorized Quantity Exceeded Required application data missing Input Errors Authorization/Access Restrictions Unable to Respond at Current Time Invalid/Missing Provider Identification Invalid/Missing Provider Name Invalid/Missing Provider Specialty Invalid/Missing Provider Phone Number Invalid/Missing Provider State Invalid/Missing Referring Provider Identification Number Provider is Not Primary Care Physician Provider Ineligible for Inquiries Provider Not on File Service Dates Not Within Provider Plan Enrollment Inquired Benefit Inconsistent with Provider Type Inappropriate Product/Service ID Qualifier Inappropriate Product/Service ID Inappropriate Date Invalid/Missing Date(s) of Service Invalid/Missing Date-of-Birth Date of Birth Follows Date(s) of Service Date of Death Precedes Date(s) of Service Date of Service Not Within Allowable Inquiry Period Date of Service in Future Invalid/Missing Patient ID Invalid/Missing Patient Name Invalid/Missing Patient Gender Code Patient Not Found Duplicate Patient ID Number Inconsistent with Patient's Age Inconsistent with Patient's Gender Patient Birth Date Does Not Match That for the Patient on the Database Invalid/Missing Subscriber/Insured ID Invalid/Missing Subscriber/Insured Name Invalid/Missing Subscriber/Insured Gender Code Subscriber/Insured Not Found Duplicate Subscriber/Insured ID Number Subscriber Found, Patient Not Found Subscriber/Insured Not in Group/Plan Identified Invalid Participant Identification No Response received - Transaction Terminated Patient Not Eligible Invalid or Missing Provider Address Experimental Service or Procedure Authorization Number Not Found Requires Primary Care Physician Authorization Invalid/Missing Diagnosis Code(s) Invalid/Missing Procedure Code(s) Invalid/Missing Onset of Current Condition or Illness Date Invalid/Missing Accident Date Invalid/Missing Last Menstrual Period Date Invalid/Missing Expected Date of Birth Invalid/Missing Admission Date Invalid/Missing Discharge Date Additional Patient Condition Information Required Certification Information Does Not Match Patient Requires Medical Review Invalid Authorization Number Format Inappropriate Provider Role

Name	CumulativeLengthOfStay
Label	Cumulative Length of Stay
Type	AUTO NUMBER

Name	ApprovedLengthOfStay
Label	Approved Length of Stay
Type	AUTO NUMBER

Name	RequestedLengthOfStay
Label	Requested Length of Stay
Type	AUTO NUMBER

Name	ApprovedLevelOfCare
Label	Approved Level of Care
Type	PICKLIST
Picklist values	Hospital - Inpatient Hospital - Intensive Care Hospital - Rehabilitation SNF - Inpatient SNF - Specialized Care SNF - Rehabilitation Psychiatric Intensive Care Psychiatric Room and Board - Private Psychiatric Room - Semi-private Psychiatric Ward

Name	CurrentLevelOfCare
Label	Current Level of Care
Type	PICKLIST
Picklist values	Hospital - Inpatient Hospital - Intensive Care Hospital - Rehabilitation SNF - Inpatient SNF - Specialized Care SNF - Rehabilitation Psychiatric Intensive Care Psychiatric Room and Board - Private Psychiatric Room - Semi-private Psychiatric Ward

Name	DeniedLevelOfCare
Label	Denied Level of Care
Type	PICKLIST
Picklist values	Hospital - Inpatient Hospital - Intensive Care Hospital - Rehabilitation SNF - Inpatient SNF - Specialized Care SNF - Rehabilitation Psychiatric Intensive Care Psychiatric Room and Board - Private Psychiatric Room - Semi-private Psychiatric Ward

Name	ModifiedLevelOfCare
Label	Modified Level of Care
Type	PICKLIST
Picklist values	Hospital - Inpatient Hospital - Intensive Care Hospital - Rehabilitation SNF - Inpatient SNF - Specialized Care SNF - Rehabilitation Psychiatric Intensive Care Psychiatric Room and Board - Private Psychiatric Room - Semi-private Psychiatric Ward

Name	RequestedLevelOfCare
Label	Requested Level of Care
Type	PICKLIST
Picklist values	Hospital - Inpatient Hospital - Intensive Care Hospital - Rehabilitation SNF - Inpatient SNF - Specialized Care SNF - Rehabilitation Psychiatric Intensive Care Psychiatric Room and Board - Private Psychiatric Room - Semi-private Psychiatric Ward

Name	ApprovedServiceEndDate
Label	Approved Service End Date
Type	DATE

Name	ApprovedServiceStartDate
Label	Approved Service Start Date
Type	DATE

Name	ClinicalDetermination
Label	Clinical Determination
Type	PICKLIST
Picklist values	Approved Denied Partially Approved Stopped Reduced Suspended Medical Director Review Pending

Name	DecisionDate
Label	Decision Date
Type	DATETIME

Name	ClinicalDeterminationReasonId
Label	Code Set ID
Type	LOOKUP
Foreign key	Yes

Name	RequestedServiceEndDate
Label	Requested Service End Date
Type	DATE

Name	RequestedServiceStartDate
Label	Requested Service Start Date
Type	DATE

Name	ClinicalDeterminationNotes
Label	Clinical Determination Notes
Type	TEXT AREA (LONG)(4000)

Name	ModifierCodeSetId
Label	Modifier Code Set ID
Type	LOOKUP
Foreign key	Yes

Name	ProcedureCodeSetId
Label	Procedure Code Set ID
Type	LOOKUP
Foreign key	Yes

Name	ModifiedProcedureCodeSetId
Label	Modified Procedure Code Set ID
Type	LOOKUP
Foreign key	Yes

Name	AuthApprovalIdentifier
Label	Authorization Approval Identifier
Type	TEXT(255)

Name	AuthorizationRefIdentifier
Label	Authorization Reference Identifier
Type	TEXT(255)

Name	ServicingFacilityId
Label	Servicing Facility ID
Type	LOOKUP
Foreign key	Yes

Name	ServicingProviderId
Label	Healthcare Provider ID
Type	LOOKUP
Foreign key	Yes

Name	ClinicalServiceRequestId
Label	Clinical Service Request ID
Type	LOOKUP
Foreign key	Yes

Name	RequestType
Label	Request Type
Type	PICKLIST
Picklist values	Filler Order Instance Order Option Order Original Order Plan Proposal Reflex Order

Name	Priority
Label	Priority
Type	PICKLIST
Picklist values	Routine Stat Urgent

Name	ReasonCodeId
Label	Reason Code ID
Type	LOOKUP
Foreign key	Yes

Name
Utilization Management
Home Health

Name	Parent object	Child object	Parent object field	Child object field
ForecastContext	CareRequestItem	AdvAcctForecastSetUse	Id	ForecastContextId
ContentContext	CareRequestItem	AssessmentTaskContentDocument	Id	ContentContextId
ReferenceObject	CareRequestItem	CareProcessingError	Id	ReferenceObjectId
CareRequestReference	CareRequestItem	CareRequestReviewer	Id	CareRequestReferenceId
AuthorizationReference	CareRequestItem	CareServiceVisitPlan	Id	AuthorizationReferenceId
FirstPublishLocation	CareRequestItem	ContentVersion	Id	FirstPublishLocationId
ParentRecord	CareRequestItem	DocumentChecklistItem	Id	ParentRecordId
ReferenceObject	CareRequestItem	DocumentEnvelope	Id	ReferenceObjectId
RelatedTo	CareRequestItem	EmailMessage	Id	RelatedToId
What	CareRequestItem	Event	Id	WhatId
RelatedRecord	CareRequestItem	FlowOrchestrationWorkItem	Id	RelatedRecordId
ReferenceObject	CareRequestItem	GeneratedDocument	Id	ReferenceObjectId
Context	CareRequestItem	GenericVisitTaskContext	Id	ContextId
ParentRecord	CareRequestItem	Identifier	Id	ParentRecordId
What	CareRequestItem	Task	Id	WhatId
Relation	CareRequestItem	TaskRelation	Id	RelationId

Name	Parent object	Child object	Parent object field	Child object field
RecordType	RecordType	CareRequestItem	Id	RecordTypeId
CreatedBy	User	CareRequestItem	Id	CreatedById
LastModifiedBy	User	CareRequestItem	Id	LastModifiedById
CareRequestCase	Case	CareRequestItem	Id	CareRequestCaseId
CareRequest	CareRequest	CareRequestItem	Id	CareRequestId
ProcedureCode	HealthCareProcedure	CareRequestItem	Id	ProcedureCodeId
ModifiedProcedureCode	HealthCareProcedure	CareRequestItem	Id	ModifiedProcedureCodeId
TransportLocation	Account	CareRequestItem	Id	TransportLocationId
ClinicalDeterminationReason	CodeSet	CareRequestItem	Id	ClinicalDeterminationReasonId
ModifierCodeSet	CodeSet	CareRequestItem	Id	ModifierCodeSetId
ModifierCodeSet	CodeSetBundle	CareRequestItem	Id	ModifierCodeSetId
ProcedureCodeSet	CodeSet	CareRequestItem	Id	ProcedureCodeSetId
ProcedureCodeSet	CodeSetBundle	CareRequestItem	Id	ProcedureCodeSetId
ModifiedProcedureCodeSet	CodeSet	CareRequestItem	Id	ModifiedProcedureCodeSetId
ModifiedProcedureCodeSet	CodeSetBundle	CareRequestItem	Id	ModifiedProcedureCodeSetId
ServicingFacility	HealthcareFacility	CareRequestItem	Id	ServicingFacilityId
ServicingFacility	HealthcarePractitionerFacility	CareRequestItem	Id	ServicingFacilityId
ServicingProvider	HealthcareProvider	CareRequestItem	Id	ServicingProviderId
ClinicalServiceRequest	ClinicalServiceRequest	CareRequestItem	Id	ClinicalServiceRequestId
ReasonCode	CareDiagnosis	CareRequestItem	Id	ReasonCodeId
ReasonCode	CodeSet	CareRequestItem	Id	ReasonCodeId
ReasonCode	CodeSetBundle	CareRequestItem	Id	ReasonCodeId

Label	Value