CCH DB fields of interest | Data Values | Why |
|---|
ch_accounts.Account_Status | active = Paid demo = Free frozen = Payment overdue deleted = Deleted merged = Merged po-create = PO-created, not paid
| Indicates who has paid us, who hasn’t, who owes us, etc. Can help onboarding, retention, etc. |
authority_documents.AD_live_status | 1 = Live 0 = Deprecated
| Indicates what ADs are live. Can help filter AD, List, Build usage. May only care about Live ADs. |
authority_documents.AD_Release_availability | For Subscribers = available for paid accounts Private = available to owning CCH account (client mapped or mapping services) Free = available to all cch accounts For purchase = available for an additional fee (only a handful exist and only 1 has sold a few copies - payments handled outside the CCH system) Null = Not Mapped OR Legacy document (mapped before release availability types existed)
*Keep DB Value in Hubspot, i.e. (For Subscribers, etc.) | Indicates who has access to use the AD mapping in the current CCH. Can help filter AD, List, Build usage. |
authority_documents.AD_Release_availabilitystatus | Released = available in CCH Restricted = available in the CCH to limited accounts
------ values we may not need to track---- Redacted = deprecated (NOT available in CCH) In Edit = in mapping, in a Mapper Tool project (NOT available in CCH) Re-Queued = needs to be mapped (NOT available in CCH) Recommended = cataloged, not mapped (NOT available in CCH) Not Applicable = will not map
---possible legacy values---- On Hold = needs to be mapped (NOT available in CCH) In Review = in mapping, (NOT available in CCH) Queued = Mapping Project
*Keep DB Value in Hubspot, i.e. (Released, etc.) | Indicates if the AD is available in the CCH. Can help filter AD, List, Build usage. May only care about Released, Restricted ADs. |
ch_authdoc_list.list_active_status | A = Active D = Deleted R = Archived
| Indicates if the list is current or not. |
ch_build_archive.build_type | xlsdoc = has additional compliance docs add on xls = regular build xlsdoc+ = has implementation controls & additional compliance docs, etc. addon xls+ = has implementation controls
| |