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

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