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