CA_MS_MAINT_VW

(SQL View)
 Index Back

SELECT CONTRACT_NUM ,MS_SEQNUM ,MS_COND_SEQ ,DESCR ,MS_COND_TYPE FROM PS_CA_MS_COND WHERE MS_COND_TYPE = 'UI'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 CONTRACT_NUM Character(25) VARCHAR2(25) NOT NULL Contract
2 MS_SEQNUM Number(3,0) SMALLINT NOT NULL Milestone Number
3 MS_COND_SEQ Number(3,0) SMALLINT NOT NULL Milestone Condition Number
4 DESCR Character(30) VARCHAR2(30) NOT NULL Description
5 MS_COND_TYPE Character(2) VARCHAR2(2) NOT NULL Translate values for milestone condition types
DT=Date
MS=Milestone
SQ=SQL
UI=User Initiated