Compliance Document Master Extract This is a table of all Compliance requirements for each contract visible to the customer, showing when compliance documents have been submitted, when they expire and what the current status is of the compliance requirement. Data Dictionary Mandatory Name Type Length Precision Format Description DB / App CONTRACT_NO Integer 10 0 Foreign key. Unique identifier for each Contract M / M COMPLIANCE_NO String 20 - Unique identifier for each Compliance M / M Primary key. Document (concatenation of Insurance_Required_no + Insurance No + Document No for Insurance documents and Compliance No for Compliance documents. DOCUMENT_NO String 10 - Unique Identifier for each document uploaded O / O DOC_NAME String 200 - The Insurance Policy Type or the Contract Document M /M Name DOC_TYPE String 25 - The Insurance Compliance Type or the Contract Document M /M Type UPDATE_DATE Date 23 - yyyy/mm/dd The date and time at which the compliance document was O / M hh:mm:ss loaded UPDATE_USER String 71 - The full name of the user who uploaded the Compliance O / M document STATUS String 30 - The Status of the Compliance Document M / M COMMENT String 2000 - If the Compliance document was rejected, the reason for O / O the rejection DATA_REFRESH_DATE Date 23 - yyyy/mm/dd Data propagates from the application to the Datamart at M / M hh:mm:ss defined intervals. This field indicates the date at which this record was read from the application.
Compliance Document Master Extract This is a table of all Compliance requirements for each contract visible to the customer, showing when compliance documents have been submitted, when they expire and what the current status is of the compliance requirement. Data Dictionary Name Type Length Precision Format Description Mandatory DB / App CONTRACT_NO Integer 10 0 Foreign key. Unique identifier for each Contract M / M COMPLIANCE_NO String 20 - Primary key. Unique identifier for each Compliance Document (concatenation of Insurance_Required_no + Insurance No + Document No for Insurance documents and Compliance No for Compliance documents. M / M DOCUMENT_NO String 10 - Unique Identifier for each document uploaded O / O DOC_NAME String 200 - The Insurance Policy Type or the Contract Document Name M /M DOC_TYPE String 25 - The Insurance Compliance Type or the Contract Document Type M /M UPDATE_DATE Date 23 - yyyy/mm/dd hh:mm:ss The date and time at which the compliance document was loaded O / M UPDATE_USER String 71 - The full name of the user who uploaded the Compliance document O / M STATUS String 30 - The Status of the Compliance Document M / M COMMENT String 2000 - If the Compliance document was rejected, the reason for the rejection O / O 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
ConSol_Datamart_Specification_v6.0.docx