# Reference Data Load Log DMO

## Object Properties

**Object API Name:** `ssot__ReferenceDataLoadLog__dlm`\
**Category:** Unassigned\
**Availability:** Available in 254 and later versions\
**Primary Key Field:** Id

## Relationships

- **LoadedById** has a FOREIGNKEY relationship with the [User DMO](/docs/data/data-cloud-dmo-mapping/guide/c360dm-si-userdmo-dmo.md) `Id` field.

## Fields

- [cdp_sys_record_currency](#cdp_sys_record_currency)
- [DatasetExternalIdentifier](#datasetexternalidentifier)
- [DatasetName](#datasetname)
- [DatasetType](#datasettype)
- [DataSourceId](#datasourceid)
- [DataSourceObjectId](#datasourceobjectid)
- [Description](#description)
- [ErrorMessageTxt](#errormessagetxt)
- [Id](#id)
- [InternalOrganizationId](#internalorganizationid)
- [KQ_Id](#kq_id)
- [KQ_LoadedById](#kq_loadedbyid)
- [LoadDateTime](#loaddatetime)
- [LoadedById](#loadedbyid)
- [LoadStatus](#loadstatus)
- [ProviderTxt](#providertxt)
- [SourceTxt](#sourcetxt)
- [TotalLoadedRecordCount](#totalloadedrecordcount)
- [TotalSkippedRecordCount](#totalskippedrecordcount)
- [TotalTimeQty](#totaltimeqty)
- [UsageType](#usagetype)
- [VersionNameTagTxt](#versionnametagtxt)
- [VersionNumber](#versionnumber)

### cdp_sys_record_currency

- **Field API Name:** `ssot__cdp_sys_record_currency__c`
- **Data Type:** TEXT
- **Description:** System-generated metadata field that stores a 3-letter ISO currency code.

### DatasetExternalIdentifier

- **Field API Name:** `ssot__DatasetExternalIdentifier__c`
- **Data Type:** TEXT
- **Description:** The unique external identifier for the dataset.

### DatasetName

- **Field API Name:** `ssot__DatasetName__c`
- **Data Type:** TEXT
- **Description:** The name of the dataset.

### DatasetType

- **Field API Name:** `ssot__DatasetType__c`
- **Data Type:** TEXT
- **Description:** Specifies the type of the dataset.

### DataSourceId

- **Field API Name:** `ssot__DataSourceId__c`
- **Data Type:** TEXT
- **Description:** A unique, system-generated identifier for this record.

### DataSourceObjectId

- **Field API Name:** `ssot__DataSourceObjectId__c`
- **Data Type:** TEXT
- **Description:** A unique, system-generated identifier for this record.

### Description

- **Field API Name:** `ssot__Description__c`
- **Data Type:** TEXT
- **Description:** The description of the dataset.

### ErrorMessageTxt

- **Field API Name:** `ssot__ErrorMessageTxt__c`
- **Data Type:** TEXT
- **Description:** The error messages generated while loading dataset, if any.

### Id

- **Field API Name:** `ssot__Id__c`
- **Data Type:** TEXT
- **Description:** Required. A unique, system-generated identifier for this ReferenceDataLoadLog record. Maximum size is 15 characters.

### InternalOrganizationId

- **Field API Name:** `ssot__InternalOrganizationId__c`
- **Data Type:** TEXT
- **Description:** A unique, system-generated identifier for this record.

### KQ_Id

- **Field API Name:** `KQ_Id__c`
- **Data Type:** TEXT
- **Description:** Key Qualifier system field for Id

### KQ_LoadedById

- **Field API Name:** `KQ_LoadedById__c`
- **Data Type:** TEXT
- **Description:** Key Qualifier system field for LoadedById

### LoadDateTime

- **Field API Name:** `ssot__LoadDateTime__c`
- **Data Type:** DATETIME
- **Description:** The date and time when the dataset was loaded.

### LoadedById

- **Field API Name:** `ssot__LoadedById__c`
- **Data Type:** TEXT
- **Description:** The user who loaded the dataset.

### LoadStatus

- **Field API Name:** `ssot__LoadStatus__c`
- **Data Type:** TEXT
- **Description:** Specifies the status of loading the dataset.

### ProviderTxt

- **Field API Name:** `ssot__ProviderTxt__c`
- **Data Type:** TEXT
- **Description:** The organization that's providing this dataset.

### SourceTxt

- **Field API Name:** `ssot__SourceTxt__c`
- **Data Type:** TEXT
- **Description:** The source of the dataset.

### TotalLoadedRecordCount

- **Field API Name:** `ssot__TotalLoadedRecordCount__c`
- **Data Type:** DOUBLE
- **Description:** The total number of records that were updated or inserted.

### TotalSkippedRecordCount

- **Field API Name:** `ssot__TotalSkippedRecordCount__c`
- **Data Type:** DOUBLE
- **Description:** The total number of records that were skipped.

### TotalTimeQty

- **Field API Name:** `ssot__TotalTimeQty__c`
- **Data Type:** DOUBLE
- **Description:** The time duration taken to load the dataset.

### UsageType

- **Field API Name:** `ssot__UsageType__c`
- **Data Type:** TEXT
- **Description:** Specifies the usage type of the data gap.

### VersionNameTagTxt

- **Field API Name:** `ssot__VersionNameTagTxt__c`
- **Data Type:** TEXT
- **Description:** The name tag of the dataset version.

### VersionNumber

- **Field API Name:** `ssot__VersionNumber__c`
- **Data Type:** TEXT
- **Description:** The version number for the dataset.
