General informations
Name: CareRequestDrug
Label: Care Request Drug
Type: Standard Object
Deployed:
Fields Details (78)
Name | Id |
Label | Care Request Drug 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 | Strength |
Label | Strength |
Type | TEXT(255) |
Name | Dose |
Label | Dose |
Type | TEXT(255) |
Name | Frequency |
Label | Frequency |
Type | TEXT(255) |
Name | TherapyDuration |
Label | Therapy Duration |
Type | AUTO NUMBER |
Name | DaysSupply |
Label | Days Supply |
Type | AUTO NUMBER |
Name | Sig |
Label | Sig |
Type | TEXT AREA (LONG)(32000) |
Name | Units |
Label | Units |
Type | AUTO NUMBER |
Name | ModifiedUnits |
Label | Modified Units |
Type | AUTO NUMBER |
Name | ApprovedUnits |
Label | Approved Units |
Type | AUTO NUMBER |
Name | DeniedUnits |
Label | Denied Units |
Type | AUTO NUMBER |
Name | CodeType |
Label | Code Type |
Type | PICKLIST |
Picklist values | NDC RxNorm |
Name | Code |
Label | Code |
Type | TEXT(32) |
Name | PrescriptionDate |
Label | Prescription Date |
Type | DATE |
Name | PrescriptionFills |
Label | Prescription Fills |
Type | AUTO NUMBER |
Name | PrescriptionFillDate |
Label | Prescription Fill Date |
Type | DATE |
Name | PrescriptionNumber |
Label | Prescription Number |
Type | TEXT(32) |
Name | ModifiedName |
Label | Modified Name |
Type | TEXT(255) |
Name | ModifiedStrength |
Label | Modified Strength |
Type | TEXT(255) |
Name | ModifiedDose |
Label | Modified Dose |
Type | TEXT(255) |
Name | ModifiedFrequency |
Label | Modified Frequency |
Type | TEXT(255) |
Name | ModifiedTherapyDuration |
Label | Modified Therapy Duration |
Type | AUTO NUMBER |
Name | ModifiedDaysSupply |
Label | Modified Days Supply |
Type | AUTO NUMBER |
Name | ModifiedSig |
Label | Modified Sig |
Type | TEXT AREA (LONG)(32000) |
Name | ModifiedCodeType |
Label | Modified Code Type |
Type | PICKLIST |
Picklist values | NDC RxNorm |
Name | ModifiedCode |
Label | Modified Code |
Type | TEXT(32) |
Name | DispenserName |
Label | Dispenser Name |
Type | TEXT(255) |
Name | DispenserStreet |
Label | Dispenser Street |
Type | TEXT AREA(255) |
Name | DispenserCity |
Label | Dispenser City |
Type | TEXT(40) |
Name | DispenserState |
Label | Dispenser State |
Type | TEXT(80) |
Name | DispenserPostalCode |
Label | Dispenser Postal Code |
Type | TEXT(20) |
Name | DispenserCountry |
Label | Dispenser Country |
Type | TEXT(80) |
Name | DispenserStateCode |
Label | Dispenser State Code |
Type | PICKLIST |
Picklist values | AC AG AG 05 02 AL AL AK AB AL AP AM AN AN AP 34 23 AO AR AZ AR AR AP AS AT ACT AV BA BC BS BA BT 11 BL BN BG BI BR BO BZ BS BR BC CA CA CL CM CB CI CW CE CT CZ CN CE CH CT CS 12 CH CH 50 CE CO CL CO CO CT CO CS CR KR CN DN DD DE DL DC DF DL D DG 38 EN ES DF FM FE FI FL FG FC FR 35 18 40 07 G 62 GE GA 21 GA GO GO GR GT 44 45 GR 52 GJ 10 46 HR HI 13 23 41 HG HP 34 01 91 42 43 28 08 ID IL IM IN IA IS 17 03 JA JK JH 32 36 22 37 46 14 KS KA KY KL KY KE KK 39 43 26 AQ LD LS SP LT LE LC LM 21 LK LI LO LD LA LH LU 92 MC MP MH ME MN MB MN MA MD MS MA MT MT MS MO MH VS ML ME ME MI MI 24 MI MG MN MS MO 04 45 MZ MO MN MT MB MO NL 20 42 NA 29 NA NE 15 NV NB NL NH NJ NM NSW NY 15 64 NC ND NT NT NO NS NL NU NU OA OR OY OG OH 44 33 47 OK OT ON OR OR 27 PD PA PA PB PR PR PV PA PE PG PU PE PC PI PI PT PN PZ PO PE PY PB PB 63 QC QLD QE QR RG RJ RA RC RE RI RI RN RJ RN RS RM RO RR RN RO 41 11 SA SL SC SP SK SS SV SE 61 37 31 14 25 32 22 51 SI SK SI SO SO SO SA SC SD SR TB 71 TM TN TA TAS TG TN TE TR TX 12 TA TL TO 09 36 13 31 16 TP TN TV TS TR TO UD UT UT UP VA VE VE VB VC VT VR VV VI VIC VA VT 30 WA WD WB WA WH WV WX WW WI WY 65 54 06 35 19 YU YT 53 ZA 33 |
Name | DispenserCountryCode |
Label | Dispenser Country Code |
Type | PICKLIST |
Picklist values | AF AX AL DZ AD AO AI AQ AG AR AM AW AU AT AZ BS BH BD BB BY BE BZ BJ BM BT BO BQ BA BW BV BR IO BN BG BF BI KH CM CA CV KY CF TD CL CN CX CC CO KM CG CD CK CR CI HR CW CY CZ DK DJ DM DO EC EG SV GQ ER EE SZ ET FK FO FJ FI FR GF PF TF GA GM GE DE GH GI GR GL GD GP GT GG GN GW GY HT HM VA HN HU IS IN ID IQ IE IM IL IT JM JP JE JO KZ KE KI KR XK KW KG LA LV LB LS LR LY LI LT LU MO MG MW MY MV ML MT MQ MR MU YT MX MD MC MN ME MS MA MZ MM NA NR NP NL NC NZ NI NE NG NU NF MK NO OM PK PS PA PG PY PE PH PN PL PT QA RE RO RU RW BL SH KN LC MF PM VC WS SM ST SA SN RS SC SL SG SX SK SI SB SO ZA GS SS ES LK SR SJ SE CH TW TJ TZ TH TL TG TK TO TT TN TR TM TC TV UG UA AE GB US UY UZ VU VE VN VG WF EH YE ZM ZW |
Name | DispenserLatitude |
Label | Dispenser Latitude |
Type | NUMBER(3,15) |
Name | DispenserLongitude |
Label | Dispenser Longitude |
Type | NUMBER(3,15) |
Name | DispenserGeocodeAccuracy |
Label | Dispenser Geocode Accuracy |
Type | PICKLIST |
Picklist values | Address NearAddress Block Street ExtendedZip Zip Neighborhood City County State Unknown |
Name | DispenserAddress |
Label | Dispenser Address |
Type | AUTO NUMBER |
Name | DispenserFaxNumber |
Label | Dispenser Fax Number |
Type | PHONE |
Name | DispenserPhoneNumber |
Label | Dispenser Phone Number |
Type | PHONE |
Name | DispenserTaxIdentifier |
Label | Dispenser Tax ID |
Type | TEXT(32) |
Name | DispenserVerbalNotificationDateTime |
Label | Dispenser Verbal Notification Date |
Type | DATETIME |
Name | DispenserWrittenNotificationDateTime |
Label | Dispenser Written Notification Date |
Type | DATETIME |
Name | DispenserIdentifier |
Label | Dispenser ID |
Type | TEXT(32) |
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(255) |
Name | ServiceCategoryCode |
Label | Service Category Code |
Type | TEXT(32) |
Name | CareRequestId |
Label | Care Request ID |
Type | LOOKUP |
Foreign key | Yes |
Name | MedicationCodeId |
Label | Medication ID |
Type | LOOKUP |
Foreign key | Yes |
Name | ClinicalDeterminationReasonId |
Label | Code Set ID |
Type | LOOKUP |
Foreign key | Yes |
Name | DispensingPharmacyId |
Label | Dispensing Pharmacy ID |
Type | LOOKUP |
Foreign key | Yes |
Name | ClinicalDetermination |
Label | Clinical Determination |
Type | PICKLIST |
Picklist values | Approved Denied Partially Approved Stopped Reduced Suspended Medical Director Review Pending |
Name | ClinicalDeterminationNote |
Label | Clinical Determination Note |
Type | TEXT AREA (LONG)(32000) |
Name | DecisionDate |
Label | Decision Date |
Type | DATETIME |
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 | Status |
Label | Status |
Type | PICKLIST |
Picklist values | Active Cancelled Completed Draft Entered-in-Error On-Hold Stopped Unknown |
Name | StatusReason |
Label | Status Reason |
Type | PICKLIST |
Picklist values | Insufficient Information Medically Not Required Other |
Name | RequestType |
Label | Request Type |
Type | PICKLIST |
Picklist values | Filler Order Instance Order Option Order Original Order Plan Proposal Reflex Order |
Name | DrugAdministrationSetting |
Label | Drug Administration Setting |
Type | PICKLIST |
Picklist values | Inpatient Outpatient Community Discharge |
Name | Priority |
Label | Priority |
Type | PICKLIST |
Picklist values | Routine Stat Urgent |
Name | MedicationRefObjectId |
Label | Medication Reference Object ID |
Type | LOOKUP |
Foreign key | Yes |
Name | DrugCodeId |
Label | Drug Code ID |
Type | LOOKUP |
Foreign key | Yes |