Skip to main content
Mitratech Success Center

TMilestone

TMilestone contains the general information for all milestone records.

This information includes the projected, extension, and completion dates, milestone description, the project the milestone belongs to, as well as the users who created and modified the milestone record. This table also links to the list of custom fields created for the milestone categories and other related information contained in other tables.

Object: TMilestone (T_MILESTONE)

Attribute

Database column name

Field in UI

End of path

Bridge

Links to object table:

Data type

Comments

application
-->

APPLICATON_
ID (NUMBER)

 

x

x

WObjd
Project
Info

object

8 The Custom Object definition to which this milestone belongs.

--> Links to the table that contains information that is not included in ZObjectDefinition because it is only necessary for Custom Object Definitions (such as phase definitions, object autonumbering, and object naming pattern).

completion
Date

COMPLETION_
DATE (DATE)

Completion Date (General block)

x

   

date

The date the milestone was completed.

completion
EventIID

COMPLETION_
EVENT_IID (NUMBER)

phase is Started/ Completed (General block)

x

   

Enum

Indicates whether the milestone should be automatically marked as completed when the related project phase (selected in the phase--> attribute) is started or completed.

0 - Started (STARTED)
1- Completed (COMPLETE D)

createdBy-->

CREATED_BY_
ID (NUMBER)

Created By (Security block)

x

x

YUser

object

8 User who created the milestone record.

--> Links to specific information about the user account.

createdOn

CREATEDON (DATE)

Created On (Security block)

x

   

date

Date the milestone record was created.

createdOn
BehalfOf

CREATED_ON_BEHALF_OF_ID

   

x

TContact

object

When not null, it indicates that the record was created through an e-billing system or other external application. The contact referenced will often be a vendor in TeamConnect.

default
Category-->

DEFAULT_
CATEGORY_ID (NUMBER)

Indicated by a blue diamond (Categories block)

x

x

YRecently
Viewed
Record

object

8 The default category for the milestone.

--> Links to specific information about the category.

detailList-->

n/a

 

x

x

EMileDetail

In Object Navigator, links to Category list which is displayed in the UI only.

 

8 The list of categories added to the current object.

--> In the object model, the added categories link to the values that have been added for custom fields, according to field type.

--> In Object Navigator, this attribute is enhanced. It links to a list of all categories defined for the object definition, rather than those added to the current object. From there, you can select a category and traverse to the list of custom fields that belong to it.

document
Folder-->

DOCUMENT_
FOLDER_ID (NUMBER)

   

x

TDocument

object

Links to specific information about the document folder.

extension
Date

EXTENSION_
DATE (DATE)

Extension 
(General block)

x

   

date

The extended date of the milestone.

group
AccessList
-->

n/a

   

x

EInvlGroup
Access

 

Links to the group security information entered through the Security block of the record.

historyList
-->

n/a

History tab

x

x

THistory

 

8 The list of histories that are related to the milestone record.

--> Links to specific history information for all of the milestone's history records.

isPhase
Used

IS_PHASE_ USED (NUMBER)

Mark this milestone complete when (check box - General block)

x

   

boolean

Indicates whether the milestone record is set to be marked as complete 

automatically when the related project record reaches a certain phase.

0 - Do not use phase to mark milestone as complete
1 - Use phase to mark milestone as complete

milestone Date

MILESTONE_
DATE (DATE)

 

x

   

date

This contains one of the last of the three dates for the milestone record in the following order.

Projected Date

Extended Date

Completion Date

For example, if the Projected Date and Extended Date have values, then the Milestone Date will be populated with the same date as the Extended Date.

modifiedBy
-->

MODIFIED_BY_
ID (NUMBER)

 

x

x

YUser

object

8 The user who last modified the record.

--> Links to specific information about the user account.

modifiedOn

MODIFIED_ ON (DATE)

 

x

   

date

The date on which the record was last modified.

note-->

NOTE_ID (NUMBER)

   

x

JNote

object

Links to the table that contains the text entered into the Notes field of the record.

phase-->

PHASE_ID (NUMBER)

 

x

x

WObjdPhaseType

object

8 The phase of the related project record at which the milestone will be automatically marked as complete.

--> Links to definition information for the phase.

primaryKey

PRIMARY_KEY (NUMBER)

 

x

   

int

The unique ID of the milestone record.

project-->

PROJECT_ID (NUMBER)

 

x

x

TProject

object

8 The project to which this milestone belongs.

--> Links to specific information about the project record.

projected
Date

PROJECTED_
DATE (DATE)

Projected Date 
(General block)

x

   

date

The projected date of completion of the milestone.

securityTypeIID

SECURITY_
TYPE_IID (NUMBER)

Public/
Private
(Security block)

x

   

Enum

Specifies whether the milestone record is public or private.

0 - Public (PUBLIC)
2 - Private (PRIVATE)

short
Description

SHORT_
DESCRIPTION (VARCHAR2) (250)

Subject 
(General block)

x

   

string (250)

The subject (or description) of the milestone record.

userAccessList-->

n/a

   

x

EInvlUser
Access

 

Links to the user security information entered through the Security block of the record.

version

VERSION (NUMBER)

 

x

   

int

Indicates how many times the milestone record has been updated.

  • Was this article helpful?