# Application Review DMO

## Object Properties

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

## Relationships

- **ApplicationId** has a FOREIGNKEY relationship with the [Application DMO](/docs/data/data-cloud-dmo-mapping/guide/c360dm-si-applicationdmo-dmo.md) `Id` field.
- **InstitutionId** has a FOREIGNKEY relationship with the [Account DMO](/docs/data/data-cloud-dmo-mapping/guide/c360dm-si-accountdmo-dmo.md) `Id` field.
- **AcademicTermId** has a FOREIGNKEY relationship with the [Academic Term DMO](/docs/data/data-cloud-dmo-mapping/guide/c360dm-si-academictermdmo-dmo.md) `Id` field.
- **AssignedUserId** has a FOREIGNKEY relationship with the [User DMO](/docs/data/data-cloud-dmo-mapping/guide/c360dm-si-userdmo-dmo.md) `Id` field.
- **ApplicationItemId** has a FOREIGNKEY relationship with the [Application Item DMO](/docs/data/data-cloud-dmo-mapping/guide/c360dm-si-applicationitemdmo-dmo.md) `Id` field.
- **ReviewedById** has a FOREIGNKEY relationship with the [User DMO](/docs/data/data-cloud-dmo-mapping/guide/c360dm-si-userdmo-dmo.md) `Id` field.

## Fields

- [AcademicTermId](#academictermid)
- [ApplicationCategory](#applicationcategory)
- [ApplicationId](#applicationid)
- [ApplicationItemId](#applicationitemid)
- [ApplicationReviewRecommendation](#applicationreviewrecommendation)
- [ApplicationReviewStatus](#applicationreviewstatus)
- [AssignedDate](#assigneddate)
- [AssignedUserId](#assigneduserid)
- [cdp_sys_record_currency](#cdp_sys_record_currency)
- [Comment](#comment)
- [Condition](#condition)
- [DataSourceId](#datasourceid)
- [DataSourceObjectId](#datasourceobjectid)
- [DisplayOrderCount](#displayordercount)
- [DueDate](#duedate)
- [EndDate](#enddate)
- [Id](#id)
- [InstitutionId](#institutionid)
- [InternalOrganizationId](#internalorganizationid)
- [IsAssignedToMe](#isassignedtome)
- [IsRequired](#isrequired)
- [IsSubmitted](#issubmitted)
- [KQ_AcademicTermId](#kq_academictermid)
- [KQ_ApplicationId](#kq_applicationid)
- [KQ_ApplicationItemId](#kq_applicationitemid)
- [KQ_AssignedUserId](#kq_assigneduserid)
- [KQ_Id](#kq_id)
- [KQ_InstitutionId](#kq_institutionid)
- [KQ_ReviewedById](#kq_reviewedbyid)
- [Name](#name)
- [ReviewedById](#reviewedbyid)
- [Score](#score)
- [StartDate](#startdate)
- [SubmissionDate](#submissiondate)
- [Title](#title)
- [Type](#type)

### AcademicTermId

- **Field API Name:** `ssot__AcademicTermId__c`
- **Data Type:** TEXT
- **Description:** The academic term associated with the application.

### ApplicationCategory

- **Field API Name:** `ssot__ApplicationCategory__c`
- **Data Type:** TEXT
- **Description:** The category of the application based on the decision period.

### ApplicationId

- **Field API Name:** `ssot__ApplicationId__c`
- **Data Type:** TEXT
- **Description:** Reference to the application for which the review is done.

### ApplicationItemId

- **Field API Name:** `ssot__ApplicationItemId__c`
- **Data Type:** TEXT
- **Description:** Reference to the related application item.

### ApplicationReviewRecommendation

- **Field API Name:** `ssot__ApplicationReviewRecommendation__c`
- **Data Type:** TEXT
- **Description:** The recommendation provided by the reviewer for the application into the institution. Sample values are Pending, Admit, Admit with Conditions, and Deny.

### ApplicationReviewStatus

- **Field API Name:** `ssot__ApplicationReviewStatus__c`
- **Data Type:** TEXT
- **Description:** The status of application review.

### AssignedDate

- **Field API Name:** `ssot__AssignedDate__c`
- **Data Type:** DATEONLY
- **Description:** The date when the application was assigned to the reviewer.

### AssignedUserId

- **Field API Name:** `ssot__AssignedUserId__c`
- **Data Type:** TEXT
- **Description:** Identifies the user assigned to perform the review.

### 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.

### Comment

- **Field API Name:** `ssot__Comment__c`
- **Data Type:** TEXT
- **Description:** The information added by the reviewer about the application that's in review.

### Condition

- **Field API Name:** `ssot__Condition__c`
- **Data Type:** TEXT
- **Description:** The condition that's applicable to an applicant.

### 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.

### DisplayOrderCount

- **Field API Name:** `ssot__DisplayOrderCount__c`
- **Data Type:** DOUBLE
- **Description:** The order in which the application review shows.

### DueDate

- **Field API Name:** `ssot__DueDate__c`
- **Data Type:** DATEONLY
- **Description:** The last date when the application review must be completed.

### EndDate

- **Field API Name:** `ssot__EndDate__c`
- **Data Type:** DATEONLY
- **Description:** The date when the application review was completed.

### Id

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

### InstitutionId

- **Field API Name:** `ssot__InstitutionId__c`
- **Data Type:** TEXT
- **Description:** The institution's account related to the application review.

### InternalOrganizationId

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

### IsAssignedToMe

- **Field API Name:** `ssot__IsAssignedToMe__c`
- **Data Type:** BOOLEAN
- **Description:** Whether the application review is assigned to the user that's logged in.

### IsRequired

- **Field API Name:** `ssot__IsRequired__c`
- **Data Type:** BOOLEAN
- **Description:** Whether the application review is required.

### IsSubmitted

- **Field API Name:** `ssot__IsSubmitted__c`
- **Data Type:** BOOLEAN
- **Description:** Whether the application review was submitted.

### KQ_AcademicTermId

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

### KQ_ApplicationId

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

### KQ_ApplicationItemId

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

### KQ_AssignedUserId

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

### KQ_Id

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

### KQ_InstitutionId

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

### KQ_ReviewedById

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

### Name

- **Field API Name:** `ssot__Name__c`
- **Data Type:** TEXT
- **Description:** Name of the application being reviewed.

### ReviewedById

- **Field API Name:** `ssot__ReviewedById__c`
- **Data Type:** TEXT
- **Description:** The user who reviewed the application.

### Score

- **Field API Name:** `ssot__Score__c`
- **Data Type:** DOUBLE
- **Description:** A number that represents the total calculated score for all assessments associated with an Application Review.

### StartDate

- **Field API Name:** `ssot__StartDate__c`
- **Data Type:** DATEONLY
- **Description:** The date when the application review started.

### SubmissionDate

- **Field API Name:** `ssot__SubmissionDate__c`
- **Data Type:** DATEONLY
- **Description:** The date when the applicant submitted the application.

### Title

- **Field API Name:** `ssot__Title__c`
- **Data Type:** TEXT
- **Description:** The detailed name of the preliminary application reference.

### Type

- **Field API Name:** `ssot__Type__c`
- **Data Type:** TEXT
- **Description:** The type of review. Example values include Staff Review.