CA_MS_CND_TAO

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
2	CONTRACT_NUM	Character(25)	VARCHAR2(25) NOT NULL	Contract
3	MS_SEQNUM	Number(3,0)	SMALLINT NOT NULL	Milestone Number
4	MS_COND_SEQ	Number(3,0)	SMALLINT NOT NULL	Milestone Condition Number
5	MS_COND_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Milestone Condition Status C=Completed R=Ready
6	MS_COND_TYPE	Character(2)	VARCHAR2(2) NOT NULL	Translate values for milestone condition types DT=Date MS=Milestone SQ=SQL UI=User Initiated
7	COMPLETION_DATE	Date(10)	DATE	Completion Date
8	SYSTEM_COMP_DT	Date(10)	DATE	System Completed Date
9	MILESTONE_SOURCE	Character(2)	VARCHAR2(2) NOT NULL	Milestone Source CA=Contracts PC=Projects
10	MS_ID_NEST_SEQ	Number(3,0)	SMALLINT NOT NULL	Milestone Sequence
11	DAYS_LAG	Number(3,0)	SMALLINT NOT NULL	A number of days lag before an activity/event occurs.
12	BUSINESS_UNIT_PC	Character(5)	VARCHAR2(5) NOT NULL	PC Business Unit
13	PROJECT_ID	Character(15)	VARCHAR2(15) NOT NULL	Project Id ChartField
14	ACTIVITY_ID	Character(15)	VARCHAR2(15) NOT NULL	Activity ID
15	ACTIVITY_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Activity Status
16	LASTUPDDTTM	DateTime(26)	TIMESTAMP	Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.
17	LASTUPDOPRID	Character(30)	VARCHAR2(30) NOT NULL	Specifies the User ID which made the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.