CA_MS_SLC_SS_VW (SQL View)	Index Back
Contract Milestone Search View This is a Self-Service iClient search view for the CA_Milestone table

CA_MS_SLC_SS_VW

(SQL View)

Contract Milestone Search View

This is a Self-Service iClient search view for the CA_Milestone table

SELECT CONTRACT_NUM ,MS_SEQNUM FROM PS_CA_MILESTONE

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 CONTRACT_NUM Character(25) VARCHAR2(25) NOT NULL Contract
Prompt Table: CA_BU_SP_NONVW

2 MS_SEQNUM Number(3,0) SMALLINT NOT NULL Milestone Number

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	CONTRACT_NUM	Character(25)	VARCHAR2(25) NOT NULL	Contract Prompt Table: CA_BU_SP_NONVW
2	MS_SEQNUM	Number(3,0)	SMALLINT NOT NULL	Milestone Number