1
UID
INT4
10
0
2
ID
INT4
10
0
3
NAME
CHAR
512
0
4
TYPE
INT4
10
0
5
IS_NULL
DPR_TV_MSP_BOOL
DPR_MSP_BOOL
CHAR
1
0
MS Project Type for Boolean
6
CREATE_DATE
DPR_TV_MSP_DATE
DPR_TV_MSP_DATE
DATS
8
0
Converted Dates for MSP Project
7
CONTACT
CHAR
512
0
8
WBS
STRG
0
0
9
WBSLEVEL
STRG
0
0
10
OUTLINE_NUMBER
CHAR
512
0
11
OUTLINE_LEVEL
INT4
10
0
12
PRIORITY
INT4
10
0
13
START
DPR_TV_MSP_DATE
DPR_TV_MSP_DATE
DATS
8
0
Converted Dates for MSP Project
14
FINISH
DPR_TV_MSP_DATE
DPR_TV_MSP_DATE
DATS
8
0
Converted Dates for MSP Project
15
DURATION
DPR_TV_MSP_DURATION
DEC
10
2
MS Project Duration
16
DURATION_FORMAT
INT4
10
0
17
DURATION_NUMBER
DPR_TV_MSP_WORK
DPR_TV_MSP_WORK
QUAN
16
3
MSP Work Effort
18
WORK
DPR_TV_MSP_WORK
DPR_TV_MSP_WORK
QUAN
16
3
MSP Work Effort
19
STOP
DPR_TV_MSP_DATE
DPR_TV_MSP_DATE
DATS
8
0
Converted Dates for MSP Project
20
RESUME
DPR_TV_MSP_DATE
DPR_TV_MSP_DATE
DATS
8
0
Converted Dates for MSP Project
21
RESUME_VALID
DPR_TV_MSP_BOOL
DPR_MSP_BOOL
CHAR
1
0
MS Project Type for Boolean
22
EFFORT_DRIVEN
DPR_TV_MSP_BOOL
DPR_MSP_BOOL
CHAR
1
0
MS Project Type for Boolean
23
RECURRING
DPR_TV_MSP_BOOL
DPR_MSP_BOOL
CHAR
1
0
MS Project Type for Boolean
24
OVER_ALLOCATED
DPR_TV_MSP_BOOL
DPR_MSP_BOOL
CHAR
1
0
MS Project Type for Boolean
25
ESTIMATED
DPR_TV_MSP_BOOL
DPR_MSP_BOOL
CHAR
1
0
MS Project Type for Boolean
26
MILESTONE
DPR_TV_MSP_BOOL
DPR_MSP_BOOL
CHAR
1
0
MS Project Type for Boolean
27
SUMMARY
DPR_TV_MSP_BOOL
DPR_MSP_BOOL
CHAR
1
0
MS Project Type for Boolean
28
CRITICAL
DPR_TV_MSP_BOOL
DPR_MSP_BOOL
CHAR
1
0
MS Project Type for Boolean
29
IS_SUBPROJECT
DPR_TV_MSP_BOOL
DPR_MSP_BOOL
CHAR
1
0
MS Project Type for Boolean
30
IS_SUBPROJECT_READ_ONLY
DPR_TV_MSP_BOOL
DPR_MSP_BOOL
CHAR
1
0
MS Project Type for Boolean
31
SUBPROJECT_NAME
CHAR
512
0
32
EXTERNAL_TASK
DPR_TV_MSP_BOOL
DPR_MSP_BOOL
CHAR
1
0
MS Project Type for Boolean
33
EXTERNAL_TASK_PROJECT
CHAR
512
0
34
EARLY_START
DPR_TV_MSP_DATE
DPR_TV_MSP_DATE
DATS
8
0
Converted Dates for MSP Project
35
EARLY_FINISH
DPR_TV_MSP_DATE
DPR_TV_MSP_DATE
DATS
8
0
Converted Dates for MSP Project
36
LATE_START
DPR_TV_MSP_DATE
DPR_TV_MSP_DATE
DATS
8
0
Converted Dates for MSP Project
37
LATE_FINISH
DPR_TV_MSP_DATE
DPR_TV_MSP_DATE
DATS
8
0
Converted Dates for MSP Project
38
START_VARIANCE
INT4
10
0
39
FINISH_VARIANCE
INT4
10
0
40
WORK_VARIANCE
STRG
0
0
41
FREE_SLACK
INT4
10
0
42
TOTAL_SLACK
INT4
10
0
43
FIXED_COST
STRG
0
0
44
FIXED_COST_ACCRUAL
STRG
0
0
45
PERCENT_COMPLETE
INT4
10
0
46
PERCENT_WORK_COMPLETE
INT4
10
0
47
COST
STRG
0
0
48
OVERTIME_COST
STRG
0
0
49
OVERTIME_WORK
DPR_TV_MSP_WORK
DPR_TV_MSP_WORK
QUAN
16
3
MSP Work Effort
50
ACTUAL_START
DPR_TV_MSP_DATE
DPR_TV_MSP_DATE
DATS
8
0
Converted Dates for MSP Project
51
ACTUAL_FINISH
DPR_TV_MSP_DATE
DPR_TV_MSP_DATE
DATS
8
0
Converted Dates for MSP Project
52
ACTUAL_DURATION
STRG
0
0
53
ACTUAL_COST
STRG
0
0
54
ACTUAL_OVERTIME_COST
STRG
0
0
55
ACTUAL_WORK
DPR_TV_MSP_WORK
DPR_TV_MSP_WORK
QUAN
16
3
MSP Work Effort
56
ACTUAL_OVERTIME_WORK
DPR_TV_MSP_WORK
DPR_TV_MSP_WORK
QUAN
16
3
MSP Work Effort
57
REGULAR_WORK
DPR_TV_MSP_WORK
DPR_TV_MSP_WORK
QUAN
16
3
MSP Work Effort
58
REMAINING_DURATION
STRG
0
0
59
REMAINING_COST
STRG
0
0
60
REMAINING_WORK
DPR_TV_MSP_WORK
DPR_TV_MSP_WORK
QUAN
16
3
MSP Work Effort
61
REMAINING_OVERTIME_COST
STRG
0
0
62
REMAINING_OVERTIME_WORK
DPR_TV_MSP_WORK
DPR_TV_MSP_WORK
QUAN
16
3
MSP Work Effort
63
ACWP
STRG
0
0
64
CV
STRG
0
0
65
CONSTRAINT_TYPE
INT4
10
0
66
CALENDAR_UID
DPR_TV_MSP_CALENDAR_ID
WFCID
CHAR
2
0
Calendar
*
67
CONSTRAINT_DATE
DPR_TV_MSP_DATE
DPR_TV_MSP_DATE
DATS
8
0
Converted Dates for MSP Project
68
DEADLINE
DPR_TV_MSP_DATE
DPR_TV_MSP_DATE
DATS
8
0
Converted Dates for MSP Project
69
LEVEL_ASSIGNMENTS
DPR_TV_MSP_BOOL
DPR_MSP_BOOL
CHAR
1
0
MS Project Type for Boolean
70
LEVELING_CAN_SPLIT
DPR_TV_MSP_BOOL
DPR_MSP_BOOL
CHAR
1
0
MS Project Type for Boolean
71
LEVELING_DELAY
INT4
10
0
72
LEVELING_DELAY_FORMAT
INT4
10
0
73
PRE_LEVELED_START
DPR_TV_MSP_DATE
DPR_TV_MSP_DATE
DATS
8
0
Converted Dates for MSP Project
74
PRE_LEVELED_FINISH
DPR_TV_MSP_DATE
DPR_TV_MSP_DATE
DATS
8
0
Converted Dates for MSP Project
75
HYPERLINK
CHAR
512
0
76
HYPERLINK_ADDRESS
CHAR
512
0
77
HYPERLINK_SUB_ADDRESS
CHAR
512
0
78
IGNORE_RESOURCE_CALENDAR
DPR_TV_MSP_BOOL
DPR_MSP_BOOL
CHAR
1
0
MS Project Type for Boolean
79
NOTES
STRG
0
0
80
HIDE_BAR
DPR_TV_MSP_BOOL
DPR_MSP_BOOL
CHAR
1
0
MS Project Type for Boolean
81
ROLLUP
DPR_TV_MSP_BOOL
DPR_MSP_BOOL
CHAR
1
0
MS Project Type for Boolean
82
BCWS
STRG
0
0
83
BCWP
STRG
0
0
84
PHYSICAL_PERCENT_COMPLETE
INT4
10
0
85
EARNED_VALUE_METHOD
INT4
10
0
86
ACTUAL_WORK_PROTECTED
STRG
0
0
87
ACTUAL_OVERTIME_WORK_PROTECTED
STRG
0
0
88
WORK_UNIT
UNIT
3
0
89
DURATION_UNIT
UNIT
3
0
90
PHASE_DESCRIPTION
STRG
0
0
91
GUID_CHAR
DPR_TV_OBJECT_GUID_CHAR
SYSUUID_C
CHAR
32
0
Unique Object Key
92
.INCLUDE
0
0
Enterprise Fields in MSP Client4
93
TEXT1
STRG
0
0
94
TEXT2
STRG
0
0
95
TEXT3
STRG
0
0
96
TEXT4
STRG
0
0
97
TEXT5
STRG
0
0
98
TEXT6
STRG
0
0
99
TEXT7
STRG
0
0
100
TEXT8
STRG
0
0
101
TEXT9
STRG
0
0
102
TEXT10
STRG
0
0
103
TEXT11
STRG
0
0
104
TEXT12
STRG
0
0
105
TEXT13
STRG
0
0
106
TEXT14
STRG
0
0
107
TEXT15
STRG
0
0
108
TEXT16
STRG
0
0
109
TEXT17
STRG
0
0
110
TEXT18
STRG
0
0
111
TEXT19
STRG
0
0
112
TEXT20
STRG
0
0
113
TEXT21
STRG
0
0
114
TEXT22
STRG
0
0
115
TEXT23
STRG
0
0
116
TEXT24
STRG
0
0
117
TEXT25
STRG
0
0
118
TEXT26
STRG
0
0
119
TEXT27
STRG
0
0
120
TEXT28
STRG
0
0
121
TEXT29
STRG
0
0
122
TEXT30
STRG
0
0
123
NUMBER1
NUMC
128
0
124
NUMBER2
NUMC
128
0
125
NUMBER3
NUMC
128
0
126
NUMBER4
NUMC
128
0
127
NUMBER5
NUMC
128
0
128
NUMBER6
NUMC
128
0
129
NUMBER7
NUMC
128
0
130
NUMBER8
NUMC
128
0
131
NUMBER9
NUMC
128
0
132
NUMBER10
NUMC
128
0
133
NUMBER11
NUMC
128
0
134
NUMBER12
NUMC
128
0
135
NUMBER13
NUMC
128
0
136
NUMBER14
NUMC
24
0
137
NUMBER15
NUMC
24
0
138
NUMBER16
NUMC
24
0
139
NUMBER17
NUMC
24
0
140
NUMBER18
NUMC
24
0
141
NUMBER19
NUMC
24
0
142
NUMBER20
NUMC
24
0
143
DATE1
DPR_TV_MSP_DATE
DPR_TV_MSP_DATE
DATS
8
0
Converted Dates for MSP Project
144
DATE2
DPR_TV_MSP_DATE
DPR_TV_MSP_DATE
DATS
8
0
Converted Dates for MSP Project
145
DATE3
DPR_TV_MSP_DATE
DPR_TV_MSP_DATE
DATS
8
0
Converted Dates for MSP Project
146
DATE4
DPR_TV_MSP_DATE
DPR_TV_MSP_DATE
DATS
8
0
Converted Dates for MSP Project
147
DATE5
DPR_TV_MSP_DATE
DPR_TV_MSP_DATE
DATS
8
0
Converted Dates for MSP Project
148
DATE6
DPR_TV_MSP_DATE
DPR_TV_MSP_DATE
DATS
8
0
Converted Dates for MSP Project
149
DATE7
DPR_TV_MSP_DATE
DPR_TV_MSP_DATE
DATS
8
0
Converted Dates for MSP Project
150
DATE8
DPR_TV_MSP_DATE
DPR_TV_MSP_DATE
DATS
8
0
Converted Dates for MSP Project
151
DATE9
DPR_TV_MSP_DATE
DPR_TV_MSP_DATE
DATS
8
0
Converted Dates for MSP Project
152
DATE10
DPR_TV_MSP_DATE
DPR_TV_MSP_DATE
DATS
8
0
Converted Dates for MSP Project
153
OUTLINECODE1
STRG
0
0
154
OUTLINECODE2
STRG
0
0
155
OUTLINECODE3
STRG
0
0
156
OUTLINECODE4
STRG
0
0
157
OUTLINECODE5
STRG
0
0
158
OUTLINECODE6
STRG
0
0
159
OUTLINECODE7
STRG
0
0
160
OUTLINECODE8
STRG
0
0
161
OUTLINECODE9
STRG
0
0
162
OUTLINECODE10
STRG
0
0
163
DISPLAY_AS_SUMMARY
CHAR
5
0
164
START_SLACK
INT4
10
0
165
FINISH_SLACK
INT4
10
0
166
ACTIVE
CHAR
5
0
167
MANUAL
CHAR
5
0
168
MANUAL_START
STRG
0
0
169
MANUAL_FINISH
STRG
0
0
170
MANUAL_DURATION
STRG
0
0
171
START_TEXT
STRG
0
0
172
FINISH_TEXT
STRG
0
0