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. |