CA_MILESTONE_VW(SQL View) |
Index Back |
|---|---|
Milestone Condition Table |
| SELECT DISTINCT A.CONTRACT_NUM , A.MS_SEQNUM , A.MILESTONE_ID , A.DESCR , A.MILESTONE_STATUS , A.MS_COND_FLG , A.ESTIMATED_COMP_DT , A.COMPLETION_DATE , A.SYSTEM_COMP_DT , A.LASTUPDDTTM , A.LASTUPDOPRID , B.BUSINESS_UNIT , B.CONTRACT_TYPE , B.CA_RQST_SRC , B.BILL_TO_CUST_ID , B.REGION_CD , B.SOLD_TO_CUST_ID FROM PS_CA_MS_SECURITY E , PS_CA_MS_DEFN D , PS_SET_CNTRL_GROUP C , PS_CA_CONTR_HDR B , PS_CA_MILESTONE A WHERE A.CONTRACT_NUM = B.CONTRACT_NUM AND B.BUSINESS_UNIT = C.SETCNTRLVALUE AND C.REC_GROUP_ID = 'CA_03' AND C.SETID = D.SETID AND D.MILESTONE_ID = A.MILESTONE_ID AND D.SETID = E.SETID AND D.MILESTONE_CLASS = E.MILESTONE_CLASS |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  CONTRACT_NUM |
Character(25) | VARCHAR2(25) NOT NULL | Contract |
| 2 | MS_SEQNUM |
Number(3,0) | SMALLINT NOT NULL | Milestone Number |
| 3 | MILESTONE_ID | Character(6) | VARCHAR2(6) NOT NULL | Milestone_ID identifies the milestones that can be referenced from multiple functional areas. |
| 4 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 5 | MILESTONE_STATUS | Character(2) | VARCHAR2(2) NOT NULL |
Milestone Status
C=Completed P=Pending R=Ready X=Cancelled |
| 6 | MS_COND_FLG | Character(3) | VARCHAR2(3) NOT NULL |
# of Reqd Conditions
ALL=All conditions must be true ANY=One condition must be true |
| 7 | ESTIMATED_COMP_DT | Date(10) | DATE | Estimated Completion Date |
| 8 | COMPLETION_DATE | Date(10) | DATE | Completion Date |
| 9 | SYSTEM_COMP_DT | Date(10) | DATE | System Completed Date |
| 10 | LASTUPDDTTM | DateTime(26) | TIMESTAMP | Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts. |
| 11 | LASTUPDOPRID | Character(30) | VARCHAR2(30) NOT NULL | Specifies the User ID which made the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts. |
| 12 | BUSINESS_UNIT | Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 13 | CONTRACT_TYPE | Character(15) | VARCHAR2(15) NOT NULL | Contract Type |
| 14 | CA_RQST_SRC | Character(3) | VARCHAR2(3) NOT NULL |
Contract Classification
FED=Federal Reimbursable Agreement GEN=Generic Application GOV=Government INT=Internal OND=CRM Field Services On Demand STD=Standard |
| 15 | BILL_TO_CUST_ID | Character(15) | VARCHAR2(15) NOT NULL | Customer |
| 16 | REGION_CD | Character(10) | VARCHAR2(10) NOT NULL | Identifies the Sales Region. Populated on the Item Table to identify the Sales Region the Item is applied to. |
| 17 | SOLD_TO_CUST_ID | Character(15) | VARCHAR2(15) NOT NULL | Sold To Customer |