CA_MS_COND (SQL Table)	Index Back
Milestone Condition Table

CA_MS_COND

(SQL Table)

Milestone Condition Table

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

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

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

3 MS_COND_SEQ Number(3,0) SMALLINT NOT NULL Milestone Condition Number
Default Value: 1

4 MS_COND_STATUS Character(1) VARCHAR2(1) NOT NULL Milestone Condition Status
C=Completed
R=Ready
Default Value: R

5 DESCR Character(30) VARCHAR2(30) NOT NULL Description

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
Default Value: UI

7 COMPLETION_DATE Date(10) DATE Completion Date

8 ESTIMATED_COMP_DT Date(10) DATE Estimated Completion Date

9 SYSTEM_COMP_DT Date(10) DATE System Completed Date

10 MILESTONE_SOURCE Character(2) VARCHAR2(2) NOT NULL Milestone Source
CA=Contracts
PC=Projects
Default Value: CA

11 MS_ID_NEST_SEQ Number(3,0) SMALLINT NOT NULL Pre-requisite Milestone
Prompt Table: CA_MS_NST_SN_VW

12 DAYS_LAG Number(3,0) SMALLINT NOT NULL A number of days lag before an activity/event occurs.
Default Value: 0

13 BUSINESS_UNIT_PC Character(5) VARCHAR2(5) NOT NULL PC Business Unit
Prompt Table: SP_BU_PC_NONVW

14 PROJECT_ID Character(15) VARCHAR2(15) NOT NULL Project Id ChartField
Prompt Table: SP_CAPRJ3_NONVW

15 ACTIVITY_ID Character(15) VARCHAR2(15) NOT NULL Activity ID
Prompt Table: CA_ACT_MS_VW

16 ACTIVITY_STATUS Character(1) VARCHAR2(1) NOT NULL Activity Status
Prompt Table: PROJ_STATUS_TBL

17 SQL_STMT Long Character(8192) CLOB An internal work field that contains SQL text that is to be utilized in treasury application processing.

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

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

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	CONTRACT_NUM	Character(25)	VARCHAR2(25) NOT NULL	Contract Prompt Table: CA_CONTR_HDR
2	MS_SEQNUM	Number(3,0)	SMALLINT NOT NULL	Milestone Number
3	MS_COND_SEQ	Number(3,0)	SMALLINT NOT NULL	Milestone Condition Number Default Value: 1
4	MS_COND_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Milestone Condition Status C=Completed R=Ready Default Value: R
5	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description
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 Default Value: UI
7	COMPLETION_DATE	Date(10)	DATE	Completion Date
8	ESTIMATED_COMP_DT	Date(10)	DATE	Estimated Completion Date
9	SYSTEM_COMP_DT	Date(10)	DATE	System Completed Date
10	MILESTONE_SOURCE	Character(2)	VARCHAR2(2) NOT NULL	Milestone Source CA=Contracts PC=Projects Default Value: CA
11	MS_ID_NEST_SEQ	Number(3,0)	SMALLINT NOT NULL	Pre-requisite Milestone Prompt Table: CA_MS_NST_SN_VW
12	DAYS_LAG	Number(3,0)	SMALLINT NOT NULL	A number of days lag before an activity/event occurs. Default Value: 0
13	BUSINESS_UNIT_PC	Character(5)	VARCHAR2(5) NOT NULL	PC Business Unit Prompt Table: SP_BU_PC_NONVW
14	PROJECT_ID	Character(15)	VARCHAR2(15) NOT NULL	Project Id ChartField Prompt Table: SP_CAPRJ3_NONVW
15	ACTIVITY_ID	Character(15)	VARCHAR2(15) NOT NULL	Activity ID Prompt Table: CA_ACT_MS_VW
16	ACTIVITY_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Activity Status Prompt Table: PROJ_STATUS_TBL
17	SQL_STMT	Long Character(8192)	CLOB	An internal work field that contains SQL text that is to be utilized in treasury application processing.
18	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.
19	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.