Scheduled Activity

Added On: 08/24/12

SQL Table: SCHEDULED_ACTIVITY

Module: UniSell

Type: Entity Status: Active

Java Class: ScheduledActivity

Predefined contact arrangement that automatically occurs when indicated condition is met. For example, an e-mail is sent 3 days after a Case is created.

Available Fields:

Action CL
Activity Reason Code
Age
Case Reminder Code

Case State Code
Contact Origin FK
Create Date
Creator Code

Id
Is Active
Merchant Account Code
Scheduled Activity Content FK

Subject
Template Code

Action CL

Added On: 08/24/12

SQL Column: ACTION_CL

Java Field: actionCl

Status: Active

SQL Type: varchar(2)

Java Type: String

References Action Classifier

Attributes: Required

Represents the type of action for which the activity is defined.

Activity Reason Code

Added On: 11/12/12

SQL Column: ACTIVITY_REASON_CODE

Java Field: activityReasonCode

Status: Active

SQL Type: varchar(2)

Java Type: String

Attributes:

Code of the reason which states the purpose and
the goal of scheduled activity.

Age

Added On: 08/24/12

SQL Column: AGE

Java Field: age

Status: Active

SQL Type: int(11)

Java Type: Integer

Attributes:

Number of days from the moment when case is transitioned into the state (associated with this template) that should pass before a contact is made. For example, a value of 3 for a state 'Visit Made' indicates that the contact (e.g. email) should happen on day 3 from the day when the (hypothetical) visit was made.

Case Reminder Code

Added On: 08/24/12

SQL Column: CASE_REMINDER_CODE

Java Field: caseReminderCode

Status: Active

SQL Type: varchar(10)

Java Type: String

References Case Reminder Code

Attributes:

Reminder code that this template is associated with. The system will act on this template (e.g. send an email) only when specification conditions associated with the reminder are met.

A template must be associated with either Case State Code or Case Reminder Code.

Case State Code

Added On: 08/24/12

SQL Column: CASE_STATE_CODE

Java Field: caseStateCode

Status: Active

SQL Type: varchar(10)

Java Type: String

References Case State Code

Attributes:

State code that this template is associated with. The system will act on this template (e.g. send an email) only when a case is in this state.

A template must be associated with either Case State Code or Case Reminder Code.

Contact Origin FK

Added On: 08/24/12

SQL Column: CONTACT_ORIGIN_FK

Java Field:

Status: Active

SQL Type: bigint(20)

Java Type: Long

References Contact Origin

Attributes:

Contact origin to use for the contact resulting from this template.

Create Date

Added On: 08/24/12

SQL Column: CREATE_DATE

Java Field: createDate

Status: Active

SQL Type: datetime

Java Type: Date

Attributes:

Date when the record was created

Creator Code

Added On: 08/24/12

SQL Column: CREATOR_CODE

Java Field: creatorCode

Status: Active

SQL Type: varchar(60)

Java Type: String

References User

Attributes: Required

User that created this record.

Added On: 08/24/12

SQL Column: ID

Java Field: id

Status: Active

SQL Type: bigint(20)

Java Type: Long

Identifier / Primary Key

Attributes: Unique, Required, CreateOnly, ReadOnly

Identifier of the object used for references; auto-incremented integer value.

Is Active

Added On: 08/24/12

SQL Column: IS_ACTIVE

Java Field: isActive

Status: Active

SQL Type: tinyint(1)

Java Type: Integer

Attributes: Default:1

Indicates whether the record is currently active.

Merchant Account Code

Added On: 08/24/12

SQL Column: MERCHANT_ACCOUNT_CODE

Java Field: merchantAccountCode

Status: Active

SQL Type: int(11)

Java Type: Integer

Attributes: Required, CreateOnly

Code of Merchant Account to which instance of this object is attributed to. Depending on the context, Merchant Account Code field may contain either Merchant Code or Merchant Account Code.
The field is primarily used for data partitioning and data management, to make it easy to determine the ownership of a record within the database.

Scheduled Activity Content FK

Added On: 08/24/12

SQL Column: SCHEDULED_ACTIVITY_CONTENT_FK

Java Field:

Status: Active

SQL Type: bigint(20)

Java Type:

References Scheduled Activity Content

Attributes:

Reference to the activity's content. The content is defined for cases when automatic communication is required and no external template is used. When external template is used, Template Code field is used instead.

Subject

Added On: 08/24/12

SQL Column: SUBJECT

Java Field: subject

Status: Active

SQL Type: varchar(255)

Java Type: String

Attributes:

Subject line to use for email contacts.

Template Code

Added On: 08/24/12

SQL Column: TEMPLATE_CODE

Java Field: templateCode

Status: Active

SQL Type: varchar(30)

Java Type: String

Attributes:

Code of template in the external system (for letter or automated phone calls) that should be used for contact when this Contact Template is processed. For example, the value can be a letter code defined in a print house.