FAM_DOC
Description:
This table stores data for a family document.

Primary Key
Column Name Ordinal Position
FAM_DOC_ID 1

Column Information
Name Type Discontinued?
1 FAM_DOC_ID NUMERIC No
The unique identifier (.1 item) for the family document record.
2 FAM_DOC_NAME VARCHAR No
The name of the family document.
3 LINKED_FAMILY_ID NUMERIC No
The unique ID of the family for which the family document was created.
4 ATTRIBUTED_TO_DATE DATETIME No
The attributed to date for this family document.
5 ATTRIBUTED_TO_USER_ID VARCHAR No
The unique ID associated with the user record for this row. This column is frequently used to link to the CLARITY_EMP table.
6 ATTRIBUTED_TO_USER_ID_NAME VARCHAR No
The name of the user record. This name may be hidden.
7 FAM_DOC_STATUS_C_NAME VARCHAR No
The status category ID of the family document.
May contain organization-specific values: Yes
Category Entries:
In Progress
Complete