START_DATE Date 23 - yyyy/mm/dd The date that the Project is to start O / M hh:mm:ss END_DATE Date 23 - yyyy/mm/dd The date that the Project is to end O / M hh:mm:ss STATUS String 10 - The current status of the Project. O / M PROJECT_MANAGER String 71 - The name of the person who is currently managing O / O the Project in ConSol WORKGROUP_NAME String 50 - The name of the workgroup/area that is responsible O / M for the Project. The Project Manager must be a member of this workgroup PROJ_ESTIMATE Number 12 2 The estimated total cost of the Project. This is a value O / O entered by the Project Manager when the Project is created or updated by the Project Manager during the life of the Project. CREATE_DATE Date 23 - yyyy/mm/dd The date that the Project was created in ConSol O / M hh:mm:ss INV_ENTITY_NAME String 60 - The Invoiced Entity responsible for the Project O / M DATA_REFRESH_DATE Date 23 - yyyy/mm/dd Data propagates from the application to the Datamart M / M hh:mm:ss at defined intervals. This field indicates the date at which this record was read from the application. WORK_TYPE_NO Integer 10 0 Foreign key. Unique identifier for each Work Type O / M (see the Work Type Master table) WORK_TYPE_NAME String 35 - The Work Type Name O / M INTERFACED_PROJECT String 1 Identifies whether Project was created through a web O / O interface. 1 = Yes, or 0 = No (Mandatory column indicates whether the field is mandatory or optional at the database and application levels) Design Rules: Only Project Views that the customer has access to will be included in the extract. If the Project View is owned by another customer, certain fields in the extract will not display information (ie. Work_type_no) however the Project View will be listed.
START_DATE Date 23 - yyyy/mm/dd hh:mm:ss The date that the Project is to start O / M END_DATE Date 23 - yyyy/mm/dd hh:mm:ss The date that the Project is to end O / M STATUS String 10 - The current status of the Project. O / M PROJECT_MANAGER String 71 - The name of the person who is currently managing the Project in ConSol O / O WORKGROUP_NAME String 50 - The name of the workgroup/area that is responsible for the Project. The Project Manager must be a member of this workgroup O / M PROJ_ESTIMATE Number 12 2 The estimated total cost of the Project. This is a value entered by the Project Manager when the Project is created or updated by the Project Manager during the life of the Project. O / O CREATE_DATE Date 23 - yyyy/mm/dd hh:mm:ss The date that the Project was created in ConSol O / M INV_ENTITY_NAME String 60 - The Invoiced Entity responsible for the Project O / M DATA_REFRESH_DATE Date 23 - yyyy/mm/dd hh:mm:ss Data propagates from the application to the Datamart at defined intervals. This field indicates the date at which this record was read from the application. M / M WORK_TYPE_NO Integer 10 0 Foreign key. Unique identifier for each Work Type (see the Work Type Master table) O / M WORK_TYPE_NAME String 35 - The Work Type Name O / M INTERFACED_PROJECT String 1 Identifies whether Project was created through a web interface. 1 = Yes, or 0 = No O / O (Mandatory column indicates whether the field is mandatory or optional at the database and application levels) Design Rules: Only Project Views that the customer has access to will be included in the extract. If the Project View is owned by another customer, certain fields in the extract will not display information (ie. Work_type_no) however the Project View will be listed.
ConSol_Datamart_Specification_v5.1.docx