CPCSSN Data Dictionary v4.0.5 (2019-Q2) General Information Table: Network

Field Data Type Constraints Definition Field Notes GroupInfo_ID BigInt Auto Primary Key Auto-incrementing integer Network_ID TinyInt Composite Foreign Key, Foreign Key from the Network table ● Only a Network_ID that exists in the Network table Not Null can be referenced here ● Forms a Composite Foreign Key with Site_ID Site_ID BigInt Composite Foreign Key Foreign Key from the Site table ● Only a S. [...] ‘123456’ Network_ID TinyInt Composite Foreign Key from Network table ● Only a Network_ID that exists in the Network table can be referenced Foreign Key, here Not Null ● Forms a Composite Foreign Key with Site_ID Site_ID BigInt Composite Foreign Key from Site table ● Only a Site_ID that exists in the Site table can be referenced here Foreign Key, ● Forms a Composite Foreign Key with Network_ID Not. [...] Field Data Type Constraints Definition Field Notes AllergyIntolerance_ID BigInt Auto Auto-incrementing integer Primary Key Network_ID TinyInt Composite Foreign Key from the Network table ● Only a Network_ID that exists in the Network table can be referenced Foreign Key, here Not Null ● Forms a Composite Foreign Key with Site_ID Site_ID BigInt Composite Foreign Key from the Site table ● Only a Site. [...] Field Data Type Constraints Definition Field Notes Billing_ID BigInt Auto Auto-incrementing integer Primary Key Network_ID TinyInt Composite Foreign Key from the Network table ● Only a Network_ID that exists in the Network table can be referenced Foreign Key, here Not Null ● Forms a Composite Foreign Key with Site_ID Site_ID BigInt Composite Foreign Key from the Site table ● Only a Site_ID that ex. [...] Field Data Type Constraints Definition Field Notes Exam_ID BigInt Auto Primary Auto-incrementing integer Key Network_ID TinyInt Composite Foreign Key from Network table ● Only a Network_ID that exists in the Network table can be referenced Foreign Key, here Not Null ● Forms a Composite Foreign Key with Site_ID Site_ID BigInt Composite Foreign Key from Site table ● Only a Site_ID that exists in the.