CA_MS_COND_DEFN(SQL Table) |
Index Back |
|---|---|
Milestone Condtions Definition |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | Character(5) | VARCHAR2(5) NOT NULL | SetID | |
| 2 | Character(6) | VARCHAR2(6) NOT NULL | Milestone_ID identifies the milestones that can be referenced from multiple functional areas. | |
| 3 | 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. |