| Id |
Primary key the unique identification of a row in the table. |
| IdCase |
Foreign key to the table: Case |
| IdPersonContactInformation |
Foreign key to the table: Contactinformation Contains the reference to the primary address on the personal case. |
| IdSecondAddress |
Foreign key to the table: Contactinformation Contains the reference to the address of persons related to the primary address. |
| AuthorityCode |
Contains a textual description identifying the authority that handled the emigration. This field is copied to the database from an external register, when associating the personal cae whit an address from ix CPR-register. |
| EntryDate |
Date of today when the person arrived in the country. This field is copied to the database from an external register, when associating the personal cae whit an address from ix CPR-register. |
| NationalCitizenship |
A text describing the persons citizenship. This field is copied to the database from an external register, when associating the personal cae whit an address from ix CPR-register. |
| Comment |
Comment to the personal case. |
| SecondAddressPhonenumber |
Phone number that can reach persons at related address to the personal case. |
| SACaseLocation |
Use to map CaseLocation (CSTED) from S&A external system. |