GM_WC_MLSCNT_VW (SQL View)	Index Back
Milestone Contacts To be used for Grants WorkCenter

GM_WC_MLSCNT_VW

(SQL View)

Milestone Contacts

To be used for Grants WorkCenter

SELECT MLS.CONTRACT_NUM ,MLS.MILESTONE_ID ,CNT.CONTACT_ID FROM PS_GM_AWD_MILE_CNT CNT ,PS_GM_WC_MLSDUE_VW MLS WHERE MLS.CONTRACT_NUM = CNT.CONTRACT_NUM AND MLS.MILESTONE_ID=CNT.MILESTONE_ID

Parent record: GM_WC_MLSDUE_VW

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 CONTRACT_NUM Character(25) VARCHAR2(25) NOT NULL Contract

2 MILESTONE_ID Character(6) VARCHAR2(6) NOT NULL Milestone_ID identifies the milestones that can be referenced from multiple functional areas.

3 CONTACT_ID Character(15) VARCHAR2(15) NOT NULL Contact Identifier for Treasury Contacts

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	CONTRACT_NUM	Character(25)	VARCHAR2(25) NOT NULL	Contract
2	MILESTONE_ID	Character(6)	VARCHAR2(6) NOT NULL	Milestone_ID identifies the milestones that can be referenced from multiple functional areas.
3	CONTACT_ID	Character(15)	VARCHAR2(15) NOT NULL	Contact Identifier for Treasury Contacts