CA_MS_COND_DEFN

(SQL Table)
Index Back

Milestone Condtions Definition

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 SETID Character(5) VARCHAR2(5) NOT NULL SetID
2 MILESTONE_ID Character(6) VARCHAR2(6) NOT NULL Milestone_ID identifies the milestones that can be referenced from multiple functional areas.
3 MS_COND_SEQ Number(3,0) SMALLINT NOT NULL Milestone Condition Number
4 DESCR Character(30) VARCHAR2(30) NOT NULL Description
5 MS_COND_TYPE Character(2) VARCHAR2(2) NOT NULL Translate values for milestone condition types
DT=Date
MS=Milestone
SQ=SQL
UI=User Initiated
6 MILESTONE_SOURCE Character(2) VARCHAR2(2) NOT NULL Milestone Source
CA=Contracts
PC=Projects
7 DAYS_LAG Number(3,0) SMALLINT NOT NULL A number of days lag before an activity/event occurs.
8 SQL_STMT Long Character(8192) CLOB An internal work field that contains SQL text that is to be utilized in treasury application processing.