CA_MS_COND_H (SQL Table)	Index Back
Milestone Condition Table

CA_MS_COND_H

(SQL Table)

Milestone Condition Table

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 PSARCH_ID Character(8) VARCHAR2(8) NOT NULL Archive ID (see PSARCHTEMPLATE).

2 PSARCH_BATCHNUM Number(30,0) DECIMAL(30) NOT NULL Archive Batch Number

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

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

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

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

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

8 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

9 COMPLETION_DATE Date(10) DATE Completion Date

10 ESTIMATED_COMP_DT Date(10) DATE Estimated Completion Date

11 SYSTEM_COMP_DT Date(10) DATE System Completed Date

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

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

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

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

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

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

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

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

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

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