GM_MLS_SRCH_VW (SQL View)	Index Back
Milestone Prompt View Milestone Prompt View

GM_MLS_SRCH_VW

(SQL View)

Milestone Prompt View

SELECT CONTRACT_NUM , MILESTONE_ID , MILESTONE_TYPE , MILESTONE_CODE , DUE_DT , MILESTONE_STAT FROM PS_GM_AWD_MILE

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 CONTRACT_NUM Character(25) VARCHAR2(25) NOT NULL Award ID

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

3 MILESTONE_TYPE Character(5) VARCHAR2(5) NOT NULL Milestone Type
Prompt Table: GM_MILE_TYPE

4 MILESTONE_CODE Character(15) VARCHAR2(15) NOT NULL Milestone Code
Prompt Table: GM_MILE_CODE

5 DUE_DT Date(10) DATE Specifies the date that a transaction is due. It is a generic field used in multiple PeopleSoft applications including Receivables Payables and Purchasing. For example it represents the date that payment is due for a voucher or the date that a scheduled shipment is due to be received.

6 MILESTONE_STAT Character(3) VARCHAR2(3) NOT NULL Milestone Status

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	CONTRACT_NUM	Character(25)	VARCHAR2(25) NOT NULL	Award ID
2	MILESTONE_ID	Character(6)	VARCHAR2(6) NOT NULL	Milestone_ID identifies the milestones that can be referenced from multiple functional areas.
3	MILESTONE_TYPE	Character(5)	VARCHAR2(5) NOT NULL	Milestone Type Prompt Table: GM_MILE_TYPE
4	MILESTONE_CODE	Character(15)	VARCHAR2(15) NOT NULL	Milestone Code Prompt Table: GM_MILE_CODE
5	DUE_DT	Date(10)	DATE	Specifies the date that a transaction is due. It is a generic field used in multiple PeopleSoft applications including Receivables Payables and Purchasing. For example it represents the date that payment is due for a voucher or the date that a scheduled shipment is due to be received.
6	MILESTONE_STAT	Character(3)	VARCHAR2(3) NOT NULL	Milestone Status