GM_WC_MLSDUE_VW (SQL View)	Index Back
Milestones Dues To be used in Grants WorkCenter

GM_WC_MLSDUE_VW

(SQL View)

Milestones Dues

To be used in Grants WorkCenter

SELECT MLS.BUSINESS_UNIT ,MLS.CONTRACT_NUM ,MLS.MILESTONE_ID ,MLS.MILESTONE_TYPE ,MLS.MILESTONE_CODE ,MLS.MILESTONE_STAT ,MLS.GM_MLST_PRI ,MLS.DUE_DT ,%DateDiff(%CurrentDateIn, MLS.DUE_DT) ,AWD.BEGIN_DT ,AWD.END_DT ,AWD.EMPLID ,AWD.CUST_ID ,AWD.POST_ADMIN FROM PS_GM_AWD_MILE MLS ,PS_GM_AWARD AWD WHERE AWD.CONTRACT_NUM = MLS.CONTRACT_NUM AND MLS.MILESTONE_STAT <> 'COM' ORDER BY MLS.DUE_DT ASC,MLS.CONTRACT_NUM ASC

Parent Record Of GM_WC_MLSCNT_VW

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

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

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

4 MILESTONE_TYPE Character(5) VARCHAR2(5) NOT NULL Milestone Type

5 MILESTONE_CODE Character(15) VARCHAR2(15) NOT NULL Milestone Code

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

7 GM_MLST_PRI Character(1) VARCHAR2(1) NOT NULL GM_MLST_PRI
H=High
L=Low
M=Medium

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

9 DAYS_DUE Signed Number(5,0) DECIMAL(4) NOT NULL Due Days

10 BEGIN_DT Date(10) DATE Begin Date

11 END_DT Date(10) DATE End Date

12 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

13 CUST_ID Character(15) VARCHAR2(15) NOT NULL Uniquely identifies an organizational entity that purchases goods or services from the enterprise. Represents the sold-to customer which is the customer organization that places orders. The CUST_ID may or may not be the same as the identifiers for the bill-to and ship-to locations.

14 POST_ADMIN Character(11) VARCHAR2(11) NOT NULL Post Award Administrator

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
2	CONTRACT_NUM	Character(25)	VARCHAR2(25) NOT NULL	Contract
3	MILESTONE_ID	Character(6)	VARCHAR2(6) NOT NULL	Milestone_ID identifies the milestones that can be referenced from multiple functional areas.
4	MILESTONE_TYPE	Character(5)	VARCHAR2(5) NOT NULL	Milestone Type
5	MILESTONE_CODE	Character(15)	VARCHAR2(15) NOT NULL	Milestone Code
6	MILESTONE_STAT	Character(3)	VARCHAR2(3) NOT NULL	Milestone Status
7	GM_MLST_PRI	Character(1)	VARCHAR2(1) NOT NULL	GM_MLST_PRI H=High L=Low M=Medium
8	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.
9	DAYS_DUE	Signed Number(5,0)	DECIMAL(4) NOT NULL	Due Days
10	BEGIN_DT	Date(10)	DATE	Begin Date
11	END_DT	Date(10)	DATE	End Date
12	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
13	CUST_ID	Character(15)	VARCHAR2(15) NOT NULL	Uniquely identifies an organizational entity that purchases goods or services from the enterprise. Represents the sold-to customer which is the customer organization that places orders. The CUST_ID may or may not be the same as the identifiers for the bill-to and ship-to locations.
14	POST_ADMIN	Character(11)	VARCHAR2(11) NOT NULL	Post Award Administrator