Case State Code

Added On: 08/24/12

SQL Table: CASE_STATE_CODE

Module: UniSell

Type: Code Status: Active

Java Class: CaseStateCode

Represents possible case states based on a case objective (e.g. for membership sale it could be no visit, visit made, trial membership, trial expired, membership sold).

Available Fields:

Case Objective Code
Code

Create Date
Id

Is Active
Merchant Account Code

Name
Sequence Number

Case Objective Code

Added On: 08/24/12

SQL Column: CASE_OBJECTIVE_CODE

Java Field: caseObjectiveCode

Status: Active

SQL Type: varchar(2)

Java Type: String

References Case Objective Code

Attributes: Required, Min Length:2

Reference to a case objective for which this state is defined.

Code

Added On: 08/24/12

SQL Column: CODE

Java Field: code

Status: Active

SQL Type: varchar(10)

Java Type: String

Attributes:

Unique code identifying the state with a case objective

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

Added On: 08/24/12

SQL Column: ID

Java Field: id

Status: Active

SQL Type: bigint(20)

Java Type: Long

Attributes: Required

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: Boolean

Attributes:

Indicates whether the code is used and thus can be used in new cases.

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.

Name

Added On: 08/24/12

SQL Column: NAME

Java Field: name

Status: Active

SQL Type: varchar(100)

Java Type: String

Attributes:

Name (description) of the code, defining its meaning

Sequence Number

Added On: 10/25/12

SQL Column: SEQUENCE_NUMBER

Java Field: sequenceNumber

Status: Active

SQL Type: int(11)

Java Type: Integer

Attributes: