Organization Information VARCHAR(80) Organization Name Y Y NULLABLE Unique database ID for a user's specific instance of N/A N N N/A N/A an organization Organization's unique database ID (can be N/A N N N/A N/A shared multiple users) Organization's address, address1 line 1 for the logged in Y N N/A N/A user Organization's address, address2 line 2 for the logged in Y N N/A N/A user Organization's address, address3 line 3 for the logged in N/A N N N/A N/A user Organization's address, address4 line 4 for the logged in N/A N N N/A N/A user Organization's city for the logged in user; only used city Y N N/A N/A for US & Canadian addresses Organization's state for the logged in user; only state Dropdown Y N N/A N/A used for US & Canadian addresses Organization's zip/postal code for the logged in postalcode Y N N/A N/A user; only used for US & Canadian addresses Organization's country for the logged in user country N/A Y N N/A N/A User Contact Information (aka User Organization) Unique database ID for a user's specific instance of N/A N N N/A N/A an organization Telephone number of the Y Y logged in user NULLABLE Telephone extension of the logged in user N/A Y N N/A N/A (optional) Email address of the email Y Y NOT logged in user NULLABLE Authorization Information (program service / role / program ID) Program acronym (e.g., program N/A Y N N/A N/A NETDMR)
Organization Information Organization Name VARCHAR(80) Y Y NULLABLE Unique database ID for a user's specific instance of an organization N/A N N N/A N/A Organization's unique database ID (can be shared multiple users) N/A N N N/A N/A address1 Organization's address, line 1 for the logged in user Y N N/A N/A address2 Organization's address, line 2 for the logged in user Y N N/A N/A address3 Organization's address, line 3 for the logged in user N/A N N N/A N/A address4 Organization's address, line 4 for the logged in user N/A N N N/A N/A city Organization's city for the logged in user; only used for US & Canadian addresses Y N N/A N/A state Organization's state for the logged in user; only used for US & Canadian addresses Dropdown Y N N/A N/A postalcode Organization's zip/postal code for the logged in user; only used for US & Canadian addresses Y N N/A N/A country Organization's country for the logged in user N/A Y N N/A N/A User Contact Information (aka User Organization) Unique database ID for a user's specific instance of an organization N/A N N N/A N/A Telephone number of the logged in user Y Y NULLABLE Telephone extension of the logged in user (optional) N/A Y N N/A N/A email Email address of the logged in user Y Y NOT NULLABLE Authorization Information (program service / role / program ID) program Program acronym (e.g., NETDMR) N/A Y N N/A N/A
NetDMR_Design_5_System_Management_5.2.docx