CA_MS_STAT_VW (SQL View)	Index Back
Milestone Status View List the Milestone Status and the Number of Associated Contracts.

CA_MS_STAT_VW

(SQL View)

Milestone Status View

List the Milestone Status and the Number of Associated Contracts.

SELECT M.MILESTONE_STATUS , COUNT(*) , T.XLATSHORTNAME , 0 , 0 FROM PS_CA_MILESTONE_VW M , PSXLATITEM T WHERE T.FIELDNAME = 'MILESTONE_STATUS' AND M.MILESTONE_STATUS = T.FIELDVALUE AND T.EFF_STATUS = 'A' AND %EffdtCheck(PSXLATITEM XX, T, %CurrentDateIn) GROUP BY M.MILESTONE_STATUS, T.XLATSHORTNAME

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 MILESTONE_STATUS Character(2) VARCHAR2(2) NOT NULL Milestone Status
C=Completed
P=Pending
R=Ready
X=Cancelled

2 RECORD_COUNT Number(7,0) INTEGER NOT NULL Count of Records

3 XLATSHORTNAME Character(10) VARCHAR2(10) NOT NULL Translate Value Short Name

4 CA_AP_IMPACT_CNT Number(6,0) INTEGER NOT NULL Revenue Plan Impact Count

5 CA_BP_IMPACT_CNT Number(6,0) INTEGER NOT NULL Billing Plan Impact Count

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	MILESTONE_STATUS	Character(2)	VARCHAR2(2) NOT NULL	Milestone Status C=Completed P=Pending R=Ready X=Cancelled
2	RECORD_COUNT	Number(7,0)	INTEGER NOT NULL	Count of Records
3	XLATSHORTNAME	Character(10)	VARCHAR2(10) NOT NULL	Translate Value Short Name
4	CA_AP_IMPACT_CNT	Number(6,0)	INTEGER NOT NULL	Revenue Plan Impact Count
5	CA_BP_IMPACT_CNT	Number(6,0)	INTEGER NOT NULL	Billing Plan Impact Count