D:\DRGWork\AccessProj\DRGNational4.0\CD\1.SpecificatiiTehnice\DRGNation Tuesday, December 21, 2004 al4.0.mdb Table: Lista_Accidente Page: 1 Properties DatasheetFontHeight: 8 DatasheetFontItalic: False DatasheetFontName: Arial DatasheetFontUnderlin False DatasheetFontWeight: Normal DatasheetForeColor: 0 Date Created: 12/02/2004 1:08:52 AM GUID: Long binary data Last Updated: 12/17/2004 4:05:10 PM NameMap: Long binary data OrderByOn: False Orientation: 0 RecordCount: 5 TabularCharSet: 0 TabularFamily: 34 Updatable: True Columns Name Type Size IdAccident Byte 1 AllowZeroLength: False Attributes: Fixed Size Collating Order: 1048 ColumnHidden: False ColumnOrder: 1 ColumnWidth: 1020 Data Updatable: False DecimalPlaces: 0 DisplayControl: Text Box GUID: Long binary data Ordinal Position: 0 Required: True Source Field: IdAccident Source Table: Lista_Accidente DenAccident Text 100 AllowZeroLength: False Attributes: Variable Length Collating Order: 1048 ColumnHidden: False ColumnOrder: Default ColumnWidth: 3420 Data Updatable: False DisplayControl: Text Box GUID: Long binary data Ordinal Position: 1 Required: True Source Field: DenAccident Source Table: Lista_Accidente UnicodeCompression: True Relationships Lista_AccidentePacient_Fisa Lista_Accidente Pacient_Fisa IdAccident 1 IdAccident Attributes: Enforced RelationshipType: One-To-Many D:\DRGWork\AccessProj\DRGNational4.0\CD\1.SpecificatiiTehnice\DRGNation Tuesday, December 21, 2004 al4.0.mdb Table: Lista_Accidente Page: 2 Table Indexes Name Number of Fields PrimaryKey 1 Clustered: False DistinctCount: 5 Foreign: False Ignore Nulls: False Name: PrimaryKey Primary: True Required: True Unique: True Fields: Ascending User Permissions admin drgadmin Delete, Read Permissions, Set Permissions, Change Owner, Read Definition, Write Definition, Read Data, Insert Data, Update Data, drguser Group Permissions Admins Delete, Read Permissions, Set Permissions, Change Owner, Read Definition, Write Definition, Read Data, Insert Data, Update Data, DRGUsers Users Delete, Read Permissions, Set Permissions, Change Owner, Read Definition, Write Definition, Read Data, Insert Data, Update Data, D:\DRGWork\AccessProj\DRGNational4.0\CD\1.SpecificatiiTehnice\DRGNation Tuesday, December 21, 2004 al4.0.mdb Table: Lista_CAS Page: 3 Properties DatasheetFontHeight: 10 DatasheetFontItalic: False DatasheetFontName: Arial DatasheetFontUnderlin False DatasheetFontWeight: Normal DatasheetForeColor: 0 Date Created: 11/22/2004 12:44:17 PM GUID: Long binary data Last Updated: 12/17/2004 1:00:16 PM NameMap: Long binary data OrderByOn: False Orientation: 0 RecordCount: 4 TabularCharSet: 0 TabularFamily: 34 Updatable: True Columns Name Type Size IdCAS Byte 1 AllowZeroLength: False Attributes: Fixed Size Collating Order: 1048 ColumnHidden: False ColumnOrder: 1 ColumnWidth: 2310 Data Updatable: False DecimalPlaces: 0 DisplayControl: Text Box GUID: Long binary data Ordinal Position: 0 Required: True Source Field: IdCAS Source Table: Lista_CAS CASTip Text 50 AllowZeroLength: False Attributes: Variable Length Collating Order: 1048 ColumnHidden: False ColumnOrder: Default ColumnWidth: 4425 Data Updatable: False DisplayControl: Text Box GUID: Long binary data Ordinal Position: 1 Required: True Source Field: CASTip Source Table: Lista_CAS UnicodeCompression: True Relationships Lista_CASPacient_Fisa Lista_CAS Pacient_Fisa IdCAS 1 IdCAS Attributes: Enforced RelationshipType: One-To-Many D:\DRGWork\AccessProj\DRGNational4.0\CD\1.SpecificatiiTehnice\DRGNation Tuesday, December 21, 2004 al4.0.mdb Table: Lista_CAS Page: 4 Table Indexes Name Number of Fields CU_CAS 1 Clustered: False DistinctCount: 4 Foreign: False Ignore Nulls: False Name: CU_CAS Primary: False Required: False Unique: True Fields: Ascending PrimaryKey 1 Clustered: False DistinctCount: 4 Foreign: False Ignore Nulls: False Name: PrimaryKey Primary: True Required: True Unique: True Fields: Ascending User Permissions admin drgadmin Delete, Read Permissions, Set Permissions, Change Owner, Read Definition, Write Definition, Read Data, Insert Data, Update Data, drguser Group Permissions Admins Delete, Read Permissions, Set Permissions, Change Owner, Read Definition, Write Definition, Read Data, Insert Data, Update Data, DRGUsers Users Delete, Read Permissions, Set Permissions, Change Owner, Read Definition, Write Definition, Read Data, Insert Data, Update Data, D:\DRGWork\AccessProj\DRGNational4.0\CD\1.SpecificatiiTehnice\DRGNation Tuesday, December 21, 2004 al4.0.mdb Table: Lista_CoduriDRG Page: 5 Properties DatasheetFontHeight: 10 DatasheetFontItalic: False DatasheetFontName: Arial DatasheetFontUnderlin False DatasheetFontWeight: Normal DatasheetForeColor: 0 Date Created: 11/22/2004 12:44:17 PM GUID: Long binary data Last Updated: 12/21/2004 5:20:51 PM NameMap: Long binary data OrderByOn: False Orientation: 0 RecordCount: 499 TabularCharSet: 0 TabularFamily: 34 Updatable: True Columns Name Type Size CodDRG Text 6 AllowZeroLength: False Attributes: Variable Length Collating Order: 1048 ColumnHidden: False ColumnOrder: Default ColumnWidth: 810 Data Updatable: False DisplayControl: Text Box GUID: Long binary data Ordinal Position: 0 Required: True Source Field: CodDRG Source Table: Lista_CoduriDRG UnicodeCompression: True IdMDC Long Integer 4 AllowZeroLength: False Attributes: Fixed Size Collating Order: 1048 ColumnHidden: False ColumnOrder: Default ColumnWidth: 675 Data Updatable: False DecimalPlaces: 0 DisplayControl: Text Box GUID: Long binary data Ordinal Position: 1 Required: True Source Field: IdMDC Source Table: Lista_CoduriDRG MC_COD Text 1 AllowZeroLength: False Attributes: Variable Length Collating Order: 1048 ColumnHidden: False ColumnOrder: Default ColumnWidth: 855 Data Updatable: False DisplayControl: Text Box GUID: Long binary data Ordinal Position: 2 Required: False D:\DRGWork\AccessProj\DRGNational4.0\CD\1.SpecificatiiTehnice\DRGNation Tuesday, December 21, 2004 al4.0.mdb Table: Lista_CoduriDRG Page: 6 Source Field: MC_COD Source Table: Lista_CoduriDRG UnicodeCompression: True DenDRG Text 255 AllowZeroLength: False Attributes: Variable Length Collating Order: 1048 ColumnHidden: False ColumnOrder: Default ColumnWidth: 3840 Data Updatable: False DisplayControl: Text Box GUID: Long binary data Ordinal Position: 3 Required: True Source Field: DenDRG Source Table: Lista_CoduriDRG UnicodeCompression: True RV_MD : Delete Query 16 AllowZeroLength: False Attributes: Variable Length Collating Order: 18 ColumnHidden: False ColumnOrder: Default ColumnWidth: Default Data Updatable: False DecimalPlaces: Auto DisplayControl: Text Box GUID: Long binary data Ordinal Position: 5 Required: True Source Field: RV_MD Source Table: Lista_CoduriDRG Relationships Lista_CoduriMDCLista_CoduriDRG Lista_CoduriMDC Lista_CoduriDRG 1 IdMDC IdMDC Attributes: Enforced RelationshipType: One-To-Many Lista_CoduriDRGPacient_Grouper Lista_CoduriDRG Pacient_Grouper CodDRG 1 CodDRG Attributes: Enforced RelationshipType: One-To-Many Table Indexes Name Number of Fields D:\DRGWork\AccessProj\DRGNational4.0\CD\1.SpecificatiiTehnice\DRGNation Tuesday, December 21, 2004 al4.0.mdb Table: Lista_CoduriDRG Page: 7 {F687F5B4-55AE-42D7-978A-E07400E59375} 1 Clustered: False DistinctCount: 27 Foreign: True Ignore Nulls: False Name: {F687F5B4-55AE-42D7-978A-E07400E59375} Primary: False Required: False Unique: False Fields: Ascending CU_DenDRG 1 Clustered: False DistinctCount: 499 Foreign: False Ignore Nulls: False Name: CU_DenDRG Primary: False Required: False Unique: True Fields: Ascending ix_IdMDC 1 Clustered: False DistinctCount: 27 Foreign: False Ignore Nulls: False Name: ix_IdMDC Primary: False Required: False Unique: False Fields: Ascending PrimaryKey 1 Clustered: False DistinctCount: 499 Foreign: False Ignore Nulls: False Name: PrimaryKey Primary: True Required: True Unique: True Fields: Ascending User Permissions admin drgadmin Delete, Read Permissions, Set Permissions, Change Owner, Read Definition, Write Definition, Read Data, Insert Data, Update Data, drguser Group Permissions Admins Delete, Read Permissions, Set Permissions, Change Owner, Read Definition, Write Definition, Read Data, Insert Data, Update Data, DRGUsers D:\DRGWork\AccessProj\DRGNational4.0\CD\1.SpecificatiiTehnice\DRGNation Tuesday, December 21, 2004 al4.0.mdb Table: Lista_CoduriDRG Page: 8 Users Delete, Read Permissions, Set Permissions, Change Owner, Read Definition, Write Definition, Read Data, Insert Data, Update Data, D:\DRGWork\AccessProj\DRGNational4.0\CD\1.SpecificatiiTehnice\DRGNation Tuesday, December 21, 2004 al4.0.mdb Table: Lista_CoduriMDC Page: 9 Properties DatasheetFontHeight: 10 DatasheetFontItalic: False DatasheetFontName: Arial DatasheetFontUnderlin False DatasheetFontWeight: Normal DatasheetForeColor: 0 Date Created: 11/22/2004 12:44:17 PM GUID: Long binary data Last Updated: 11/22/2004 1:56:35 PM NameMap: Long binary data OrderByOn: False Orientation: 0 RecordCount: 27 TabularCharSet: 0 TabularFamily: 34 Updatable: True Columns Name Type Size IdMDC Long Integer 4 AllowZeroLength: False Attributes: Fixed Size Collating Order: 1048 ColumnHidden: False ColumnOrder: 1 ColumnWidth: Default Data Updatable: False DecimalPlaces: 0 DisplayControl: Text Box GUID: Long binary data Ordinal Position: 0 Required: True Source Field: IdMDC Source Table: Lista_CoduriMDC DenMDC Text 255 AllowZeroLength: False Attributes: Variable Length Collating Order: 1048 ColumnHidden: False ColumnOrder: Default ColumnWidth: 6345 Data Updatable: False DisplayControl: Text Box GUID: Long binary data Ordinal Position: 1 Required: True Source Field: DenMDC Source Table: Lista_CoduriMDC UnicodeCompression: True Relationships Lista_CoduriMDCLista_CoduriDRG Lista_CoduriMDC Lista_CoduriDRG IdMDC 1 IdMDC Attributes: Enforced RelationshipType: One-To-Many D:\DRGWork\AccessProj\DRGNational4.0\CD\1.SpecificatiiTehnice\DRGNation Tuesday, December 21, 2004 al4.0.mdb Table: Lista_CoduriMDC Page: 10 Table Indexes Name Number of Fields CU_DenMDC 1 Clustered: False DistinctCount: 27 Foreign: False Ignore Nulls: False Name: CU_DenMDC Primary: False Required: False Unique: True Fields: Ascending PrimaryKey 1 Clustered: False DistinctCount: 27 Foreign: False Ignore Nulls: False Name: PrimaryKey Primary: True Required: True Unique: True Fields: Ascending User Permissions admin drgadmin Delete, Read Permissions, Set Permissions, Change Owner, Read Definition, Write Definition, Read Data, Insert Data, Update Data, drguser Group Permissions Admins Delete, Read Permissions, Set Permissions, Change Owner, Read Definition, Write Definition, Read Data, Insert Data, Update Data, DRGUsers Users Delete, Read Permissions, Set Permissions, Change Owner, Read Definition, Write Definition, Read Data, Insert Data, Update Data, D:\DRGWork\AccessProj\DRGNational4.0\CD\1.SpecificatiiTehnice\DRGNation Tuesday, December 21, 2004 al4.0.mdb Table: Lista_Diagnostice Page: 11 Properties DatasheetFontHeight: 10 DatasheetFontItalic: False DatasheetFontName: Arial DatasheetFontUnderlin False DatasheetFontWeight: Normal DatasheetForeColor: 0 Date Created: 11/22/2004 12:44:17 PM GUID: Long binary data Last Updated: 11/22/2004 1:56:35 PM NameMap: Long binary data OrderByOn: False Orientation: 0 RecordCount: 12350 TabularCharSet: 0 TabularFamily: 34 Updatable: True Columns Name Type Size CodDiagnostic Text 5 AllowZeroLength: False Attributes: Variable Length Collating Order: 1048 ColumnHidden: False ColumnOrder: 1 ColumnWidth: 1335 Data Updatable: False DisplayControl: Text Box GUID: Long binary data Ordinal Position: 0 Required: True Source Field: CodDiagnostic Source Table: Lista_Diagnostice UnicodeCompression: True IdSubClasaDiagnostic Integer 2 AllowZeroLength: False Attributes: Fixed Size Collating Order: 1048 ColumnHidden: False ColumnOrder: Default ColumnWidth: 1920 Data Updatable: False DecimalPlaces: 0 DisplayControl: Text Box GUID: Long binary data Ordinal Position: 1 Required: True Source Field: IdSubClasaDiagnostic Source Table: Lista_Diagnostice NumeDiagnostic Text 255 AllowZeroLength: False Attributes: Variable Length Collating Order: 1048 ColumnHidden: False ColumnOrder: Default ColumnWidth: 5145 Data Updatable: False DisplayControl: Text Box GUID: Long binary data Ordinal Position: 2 Required: True D:\DRGWork\AccessProj\DRGNational4.0\CD\1.SpecificatiiTehnice\DRGNation Tuesday, December 21, 2004 al4.0.mdb Table: Lista_Diagnostice Page: 12 Source Field: NumeDiagnostic Source Table: Lista_Diagnostice UnicodeCompression: True Relationships Lista_DiagnosticePacient_DiagnosticeSecundare Lista_Diagnostice Pacient_DiagnosticeSecun CodDiagnostic 1 CodDiagnosticSecundar Attributes: Enforced RelationshipType: One-To-Many Lista_Diagnostice___SubClaseLista_Diagnostice Lista_Diagnostice___SubC Lista_Diagnostice 1 IdSubClasaDiagnostic IdSubClasaDiagnostic Attributes: Enforced RelationshipType: One-To-Many Lista_DiagnosticeLista_Diagnostice___Cod1Cod2 Lista_Diagnostice Lista_Diagnostice___Cod1 1 CodDiagnostic CodDiagnostic1 Attributes: Enforced RelationshipType: One-To-Many Lista_DiagnosticeLista_Diagnostice___Cod1Cod2 Lista_Diagnostice Lista_Diagnostice___Cod1 CodDiagnostic 1 CodDiagnostic2 Attributes: Enforced RelationshipType: One-To-Many Lista_DiagnosticePacient_Fisa Lista_Diagnostice Pacient_Fisa CodDiagnostic 1 CodDiagnosticLaInternare Attributes: Enforced RelationshipType: One-To-Many Table Indexes Name Number of Fields D:\DRGWork\AccessProj\DRGNational4.0\CD\1.SpecificatiiTehnice\DRGNation Tuesday, December 21, 2004 al4.0.mdb Table: Lista_Diagnostice Page: 13 {651ED3CF-DBAD-4183-994A-0630F8757C0E} 1 Clustered: False DistinctCount: 259 Foreign: True Ignore Nulls: False Name: {651ED3CF-DBAD-4183-994A-0630F8757C0E} Primary: False Required: False Unique: False Fields: Ascending CU_NumeDiagnostic 1 Clustered: False DistinctCount: 12350 Foreign: False Ignore Nulls: False Name: CU_NumeDiagnostic Primary: False Required: False Unique: True Fields: Ascending ix_IdSubClasaDiagnostic 1 Clustered: False DistinctCount: 259 Foreign: False Ignore Nulls: False Name: ix_IdSubClasaDiagnostic Primary: False Required: False Unique: False Fields: Ascending PrimaryKey 1 Clustered: False DistinctCount: 12350 Foreign: False Ignore Nulls: False Name: PrimaryKey Primary: True Required: True Unique: True Fields: Ascending User Permissions admin drgadmin Delete, Read Permissions, Set Permissions, Change Owner, Read Definition, Write Definition, Read Data, Insert Data, Update Data, drguser Group Permissions Admins Delete, Read Permissions, Set Permissions, Change Owner, Read Definition, Write Definition, Read Data, Insert Data, Update Data, DRGUsers D:\DRGWork\AccessProj\DRGNational4.0\CD\1.SpecificatiiTehnice\DRGNation Tuesday, December 21, 2004 al4.0.mdb Table: Lista_Diagnostice Page: 14 Users Delete, Read Permissions, Set Permissions, Change Owner, Read Definition, Write Definition, Read Data, Insert Data, Update Data, D:\DRGWork\AccessProj\DRGNational4.0\CD\1.SpecificatiiTehnice\DRGNation Tuesday, December 21, 2004 al4.0.mdb Table: Lista_Diagnostice___Clase Page: 15 Properties DatasheetFontHeight: 10 DatasheetFontItalic: False DatasheetFontName: Arial DatasheetFontUnderlin False DatasheetFontWeight: Normal DatasheetForeColor: 0 Date Created: 11/22/2004 12:44:17 PM GUID: Long binary data Last Updated: 12/02/2004 3:37:47 PM NameMap: Long binary data OrderByOn: False Orientation: 0 RecordCount: 21 TabularCharSet: 0 TabularFamily: 34 Updatable: True Columns Name Type Size IdClasaDiagnostic Byte 1 AllowZeroLength: False Attributes: Fixed Size Collating Order: 1048 ColumnHidden: False ColumnOrder: 1 ColumnWidth: Default Data Updatable: False DecimalPlaces: 0 DisplayControl: Text Box GUID: Long binary data Ordinal Position: 0 Required: True Source Field: IdClasaDiagnostic Source Table: Lista_Diagnostice___Clase DenClasaDiagnostic Text 250 AllowZeroLength: False Attributes: Variable Length Collating Order: 1048 ColumnHidden: False ColumnOrder: Default ColumnWidth: 7440 Data Updatable: False DisplayControl: Text Box GUID: Long binary data Ordinal Position: 1 Required: True Source Field: DenClasaDiagnostic Source Table: Lista_Diagnostice___Clase UnicodeCompression: True Relationships Lista_Diagnostice___ClaseLista_Diagnostice___SubClase Lista_Diagnostice___Clas Lista_Diagnostice___SubC IdClasaDiagnostic 1 IdClasaDiagnostic Attributes: Enforced RelationshipType: One-To-Many D:\DRGWork\AccessProj\DRGNational4.0\CD\1.SpecificatiiTehnice\DRGNation Tuesday, December 21, 2004 al4.0.mdb Table: Lista_Diagnostice___Clase Page: 16 Table Indexes Name Number of Fields CU_DenClasaDiagnostic 1 Clustered: False DistinctCount: 21 Foreign: False Ignore Nulls: False Name: CU_DenClasaDiagnostic Primary: False Required: False Unique: True Fields: Ascending PrimaryKey 1 Clustered: False DistinctCount: 21 Foreign: False Ignore Nulls: False Name: PrimaryKey Primary: True Required: True Unique: True Fields: Ascending User Permissions admin drgadmin Delete, Read Permissions, Set Permissions, Change Owner, Read Definition, Write Definition, Read Data, Insert Data, Update Data, drguser Group Permissions Admins Delete, Read Permissions, Set Permissions, Change Owner, Read Definition, Write Definition, Read Data, Insert Data, Update Data, DRGUsers Users Delete, Read Permissions, Set Permissions, Change Owner, Read Definition, Write Definition, Read Data, Insert Data, Update Data, D:\DRGWork\AccessProj\DRGNational4.0\CD\1.SpecificatiiTehnice\DRGNation Tuesday, December 21, 2004 al4.0.mdb Table: Lista_Diagnostice___Cod1Cod2 Page: 17 Properties DatasheetFontHeight: 10 DatasheetFontItalic: False DatasheetFontName: Arial DatasheetFontUnderlin False DatasheetFontWeight: Normal DatasheetForeColor: 0 Date Created: 11/22/2004 12:44:17 PM GUID: Long binary data Last Updated: 12/17/2004 4:17:35 PM NameMap: Long binary data OrderByOn: False Orientation: 0 RecordCount: 12235 TabularCharSet: 0 TabularFamily: 34 Updatable: True Columns Name Type Size CodDiagnostic1 Text 5 AllowZeroLength: False Attributes: Variable Length Collating Order: 1048 ColumnHidden: False ColumnOrder: Default ColumnWidth: 1425 Data Updatable: False DisplayControl: Text Box GUID: Long binary data Ordinal Position: 0 Required: True Source Field: CodDiagnostic1 Source Table: Lista_Diagnostice___Cod1Cod2 UnicodeCompression: True CodDiagnostic2 Text 5 AllowZeroLength: False Attributes: Variable Length Collating Order: 1048 ColumnHidden: False ColumnOrder: Default ColumnWidth: 1425 Data Updatable: False DisplayControl: Text Box GUID: Long binary data Ordinal Position: 1 Required: False Source Field: CodDiagnostic2 Source Table: Lista_Diagnostice___Cod1Cod2 UnicodeCompression: True Relationships D:\DRGWork\AccessProj\DRGNational4.0\CD\1.SpecificatiiTehnice\DRGNation Tuesday, December 21, 2004 al4.0.mdb Table: Lista_Diagnostice___Cod1Cod2 Page: 18 Lista_Diagnostice___Cod1Cod2Pacient_Fisa Lista_Diagnostice___Cod1 Pacient_Fisa CodDiagnostic1 1 CodDiagnosticPrincipalCo CodDiagnostic2 1 CodDiagnosticPrincipalCo Attributes: Enforced RelationshipType: One-To-Many Lista_DiagnosticeLista_Diagnostice___Cod1Cod2 Lista_Diagnostice Lista_Diagnostice___Cod1 CodDiagnostic 1 CodDiagnostic1 Attributes: Enforced RelationshipType: One-To-Many Lista_DiagnosticeLista_Diagnostice___Cod1Cod2 Lista_Diagnostice Lista_Diagnostice___Cod1 1 CodDiagnostic CodDiagnostic2 Attributes: Enforced RelationshipType: One-To-Many Table Indexes Name Number of Fields {B04F667E-94E8-4103-9C53-535FAFC1EB82} 1 Clustered: False DistinctCount: 12050 Foreign: True Ignore Nulls: False Name: {B04F667E-94E8-4103-9C53-535FAFC1EB82} Primary: False Required: False Unique: False Fields: Ascending {C151A3B6-5005-46A6-89BB-135F7A78668C} 1 Clustered: False DistinctCount: 87 Foreign: True Ignore Nulls: False Name: {C151A3B6-5005-46A6-89BB-135F7A78668C} Primary: False Required: False Unique: False Fields: Ascending CU_CodD1CodD2 2 Clustered: False DistinctCount: 12235 Foreign: False D:\DRGWork\AccessProj\DRGNational4.0\CD\1.SpecificatiiTehnice\DRGNation Tuesday, December 21, 2004 al4.0.mdb Table: Lista_Diagnostice___Cod1Cod2 Page: 19 Ignore Nulls: False Name: CU_CodD1CodD2 Primary: False Required: False Unique: True Fields: Ascending Ascending User Permissions admin drgadmin Delete, Read Permissions, Set Permissions, Change Owner, Read Definition, Write Definition, Read Data, Insert Data, Update Data, drguser Group Permissions Admins Delete, Read Permissions, Set Permissions, Change Owner, Read Definition, Write Definition, Read Data, Insert Data, Update Data, DRGUsers Users Delete, Read Permissions, Set Permissions, Change Owner, Read Definition, Write Definition, Read Data, Insert Data, Update Data, D:\DRGWork\AccessProj\DRGNational4.0\CD\1.SpecificatiiTehnice\DRGNation Tuesday, December 21, 2004 al4.0.mdb Table: Lista_Diagnostice___SubClase Page: 20 Properties DatasheetFontHeight: 10 DatasheetFontItalic: False DatasheetFontName: Arial DatasheetFontUnderlin False DatasheetFontWeight: Normal DatasheetForeColor: 0 Date Created: 11/22/2004 12:44:17 PM GUID: Long binary data Last Updated: 12/02/2004 3:37:47 PM NameMap: Long binary data OrderByOn: False Orientation: 0 RecordCount: 259 TabularCharSet: 0 TabularFamily: 34 Updatable: True Columns Name Type Size IdSubClasaDiagnostic Integer 2 AllowZeroLength: False Attributes: Fixed Size Collating Order: 1048 ColumnHidden: False ColumnOrder: 1 ColumnWidth: 1920 Data Updatable: False DecimalPlaces: 0 DisplayControl: Text Box GUID: Long binary data Ordinal Position: 0 Required: True Source Field: IdSubClasaDiagnostic Source Table: Lista_Diagnostice___SubClase IdClasaDiagnostic Byte 1 AllowZeroLength: False Attributes: Fixed Size Collating Order: 1048 ColumnHidden: False ColumnOrder: Default ColumnWidth: 1605 Data Updatable: False DecimalPlaces: 0 DisplayControl: Text Box GUID: Long binary data Ordinal Position: 1 Required: True Source Field: IdClasaDiagnostic Source Table: Lista_Diagnostice___SubClase DenSubClasaDiagnostic Text 255 AllowZeroLength: False Attributes: Variable Length Collating Order: 1048 ColumnHidden: False ColumnOrder: Default ColumnWidth: 6405 Data Updatable: False DisplayControl: Text Box GUID: Long binary data Ordinal Position: 2 Required: True D:\DRGWork\AccessProj\DRGNational4.0\CD\1.SpecificatiiTehnice\DRGNation Tuesday, December 21, 2004 al4.0.mdb Table: Lista_Diagnostice___SubClase Page: 21 Source Field: DenSubClasaDiagnostic Source Table: Lista_Diagnostice___SubClase UnicodeCompression: True Relationships Lista_Diagnostice___SubClaseLista_Diagnostice Lista_Diagnostice___SubC Lista_Diagnostice IdSubClasaDiagnostic 1 IdSubClasaDiagnostic Attributes: Enforced RelationshipType: One-To-Many Lista_Diagnostice___ClaseLista_Diagnostice___SubClase Lista_Diagnostice___Clas Lista_Diagnostice___SubC 1 IdClasaDiagnostic IdClasaDiagnostic Attributes: Enforced RelationshipType: One-To-Many Table Indexes Name Number of Fields {BFEA10F8-F382-4F67-B3DA-E3DA102C6CAD} 1 Clustered: False DistinctCount: 21 Foreign: True Ignore Nulls: False Name: {BFEA10F8-F382-4F67-B3DA-E3DA102C6CAD} Primary: False Required: False Unique: False Fields: Ascending CU_DenSubClasaDiagnostic 1 Clustered: False DistinctCount: 259 Foreign: False Ignore Nulls: False Name: CU_DenSubClasaDiagnostic Primary: False Required: False Unique: True Fields: Ascending IX_IdClasaDiagnostic 1 Clustered: False DistinctCount: 21 Foreign: False Ignore Nulls: False Name: IX_IdClasaDiagnostic Primary: False Required: False D:\DRGWork\AccessProj\DRGNational4.0\CD\1.SpecificatiiTehnice\DRGNation Tuesday, December 21, 2004 al4.0.mdb Table: Lista_Diagnostice___SubClase Page: 22 Unique: False Fields: Ascending PrimaryKey 1 Clustered: False DistinctCount: 259 Foreign: False Ignore Nulls: False Name: PrimaryKey Primary: True Required: True Unique: True Fields: Ascending User Permissions admin drgadmin Delete, Read Permissions, Set Permissions, Change Owner, Read Definition, Write Definition, Read Data, Insert Data, Update Data, drguser Group Permissions Admins Delete, Read Permissions, Set Permissions, Change Owner, Read Definition, Write Definition, Read Data, Insert Data, Update Data, DRGUsers Users Delete, Read Permissions, Set Permissions, Change Owner, Read Definition, Write Definition, Read Data, Insert Data, Update Data, D:\DRGWork\AccessProj\DRGNational4.0\CD\1.SpecificatiiTehnice\DRGNation Tuesday, December 21, 2004 al4.0.mdb Table: Lista_Judete Page: 23 Properties DatasheetFontHeight: 10 DatasheetFontItalic: False DatasheetFontName: Arial DatasheetFontUnderlin False DatasheetFontWeight: Normal DatasheetForeColor: 0 Date Created: 11/22/2004 12:44:17 PM GUID: Long binary data Last Updated: 11/22/2004 1:56:35 PM NameMap: Long binary data OrderByOn: False Orientation: 0 RecordCount: 42 TabularCharSet: 0 TabularFamily: 34 Updatable: True Columns Name Type Size IdJudet Byte 1 AllowZeroLength: False Attributes: Fixed Size Collating Order: 1048 ColumnHidden: False ColumnOrder: 1 ColumnWidth: Default Data Updatable: False DecimalPlaces: 0 DisplayControl: Text Box GUID: Long binary data Ordinal Position: 0 Required: True Source Field: IdJudet Source Table: Lista_Judete DenJudet Text 100 AllowZeroLength: False Attributes: Variable Length Collating Order: 1048 ColumnHidden: False ColumnOrder: Default ColumnWidth: Default Data Updatable: False DisplayControl: Text Box GUID: Long binary data Ordinal Position: 1 Required: True Source Field: DenJudet Source Table: Lista_Judete UnicodeCompression: True Relationships Lista_JudeteLista_Localitati Lista_Judete Lista_Localitati IdJudet 1 IdJudet Attributes: Enforced RelationshipType: One-To-Many D:\DRGWork\AccessProj\DRGNational4.0\CD\1.SpecificatiiTehnice\DRGNation Tuesday, December 21, 2004 al4.0.mdb Table: Lista_Judete Page: 24 Lista_JudetePacient_Fisa Lista_Judete Pacient_Fisa IdJudet 1 IdJudetCAS Attributes: Enforced RelationshipType: One-To-Many Table Indexes Name Number of Fields CU_DenJudet 1 Clustered: False DistinctCount: 42 Foreign: False Ignore Nulls: False Name: CU_DenJudet Primary: False Required: False Unique: True Fields: Ascending PrimaryKey 1 Clustered: False DistinctCount: 42 Foreign: False Ignore Nulls: False Name: PrimaryKey Primary: True Required: True Unique: True Fields: Ascending User Permissions admin drgadmin Delete, Read Permissions, Set Permissions, Change Owner, Read Definition, Write Definition, Read Data, Insert Data, Update Data, drguser Group Permissions Admins Delete, Read Permissions, Set Permissions, Change Owner, Read Definition, Write Definition, Read Data, Insert Data, Update Data, DRGUsers Users Delete, Read Permissions, Set Permissions, Change Owner, Read Definition, Write Definition, Read Data, Insert Data, Update Data, D:\DRGWork\AccessProj\DRGNational4.0\CD\1.SpecificatiiTehnice\DRGNation Tuesday, December 21, 2004 al4.0.mdb Table: Lista_Localitati Page: 25 Properties DatasheetFontHeight: 10 DatasheetFontItalic: False DatasheetFontName: Arial DatasheetFontUnderlin False DatasheetFontWeight: Normal DatasheetForeColor: 0 Date Created: 11/22/2004 12:44:17 PM GUID: Long binary data Last Updated: 11/25/2004 11:48:26 AM NameMap: Long binary data OrderByOn: False Orientation: 0 RecordCount: 13300 TabularCharSet: 0 TabularFamily: 34 Updatable: True Columns Name Type Size IdJudet Byte 1 AllowZeroLength: False Attributes: Fixed Size Collating Order: 1048 ColumnHidden: False ColumnOrder: 1 ColumnWidth: Default Data Updatable: False DecimalPlaces: 0 DisplayControl: Text Box GUID: Long binary data Ordinal Position: 0 Required: True Source Field: IdJudet Source Table: Lista_Localitati IdLocalitate Long Integer 4 AllowZeroLength: False Attributes: Fixed Size Collating Order: 1048 ColumnHidden: False ColumnOrder: Default ColumnWidth: 1095 Data Updatable: False DecimalPlaces: 0 DisplayControl: Text Box GUID: Long binary data Ordinal Position: 1 Required: True Source Field: IdLocalitate Source Table: Lista_Localitati DenLocalitate Text 200 AllowZeroLength: False Attributes: Variable Length Collating Order: 1048 ColumnHidden: False ColumnOrder: Default ColumnWidth: Default Data Updatable: False DisplayControl: Text Box GUID: Long binary data Ordinal Position: 2 Required: False D:\DRGWork\AccessProj\DRGNational4.0\CD\1.SpecificatiiTehnice\DRGNation Tuesday, December 21, 2004 al4.0.mdb Table: Lista_Localitati Page: 26 Source Field: DenLocalitate Source Table: Lista_Localitati UnicodeCompression: True UR Text 1 AllowZeroLength: False Attributes: Variable Length Collating Order: 1048 ColumnHidden: False ColumnOrder: Default ColumnWidth: Default Data Updatable: False DisplayControl: Text Box GUID: Long binary data Ordinal Position: 3 Required: False Source Field: UR Source Table: Lista_Localitati UnicodeCompression: True Relationships Lista_JudeteLista_Localitati Lista_Judete Lista_Localitati IdJudet 1 IdJudet Attributes: Enforced RelationshipType: One-To-Many Lista_LocalitatiPacient_Fisa Lista_Localitati Pacient_Fisa IdJudet 1 IdJudet IdLocalitate 1 IdLocalitate Attributes: Enforced RelationshipType: One-To-Many Lista_LocalitatiLista_Spitale Lista_Localitati Lista_Spitale IdJudet 1 IdJudet IdLocalitate 1 IdLocalitate Attributes: Enforced RelationshipType: One-To-Many Table Indexes Name Number of Fields D:\DRGWork\AccessProj\DRGNational4.0\CD\1.SpecificatiiTehnice\DRGNation Tuesday, December 21, 2004 al4.0.mdb Table: Lista_Localitati Page: 27 {7A808068-4E7D-4C6D-98DF-080530B33BE2} 1 Clustered: False DistinctCount: 42 Foreign: True Ignore Nulls: False Name: {7A808068-4E7D-4C6D-98DF-080530B33BE2} Primary: False Required: False Unique: False Fields: Ascending CU_IdJudetDenLocalitate 3 Clustered: False DistinctCount: 13300 Foreign: False Ignore Nulls: False Name: CU_IdJudetDenLocalitate Primary: False Required: False Unique: True Fields: Ascending Ascending Ascending PrimaryKey 2 Clustered: False DistinctCount: 13300 Foreign: False Ignore Nulls: False Name: PrimaryKey Primary: True Required: True Unique: True Fields: Ascending Ascending User Permissions admin drgadmin Delete, Read Permissions, Set Permissions, Change Owner, Read Definition, Write Definition, Read Data, Insert Data, Update Data, drguser Group Permissions Admins Delete, Read Permissions, Set Permissions, Change Owner, Read Definition, Write Definition, Read Data, Insert Data, Update Data, DRGUsers Users Delete, Read Permissions, Set Permissions, Change Owner, Read Definition, Write Definition, Read Data, Insert Data, Update Data, D:\DRGWork\AccessProj\DRGNational4.0\CD\1.SpecificatiiTehnice\DRGNation Tuesday, December 21, 2004 al4.0.mdb Table: Lista_Medici Page: 28 Properties DatasheetFontHeight: 10 DatasheetFontItalic: False DatasheetFontName: Arial DatasheetFontUnderlin False DatasheetFontWeight: Normal DatasheetForeColor: 0 Date Created: 11/22/2004 12:44:18 PM GUID: Long binary data Last Updated: 12/17/2004 4:22:45 PM NameMap: Long binary data OrderByOn: False Orientation: 0 RecordCount: 0 TabularCharSet: 0 TabularFamily: 34 Updatable: True Columns Name Type Size Spital_ID Text 6 AllowZeroLength: False Attributes: Variable Length Caption: Spital Collating Order: 1048 ColumnHidden: False ColumnOrder: Default ColumnWidth: Default Data Updatable: False DisplayControl: Text Box GUID: Long binary data Ordinal Position: 0 Required: True Source Field: Spital_ID Source Table: Lista_Medici UnicodeCompression: True CodMedic Text 7 AllowZeroLength: False Attributes: Variable Length Caption: Cod parafa Collating Order: 1048 ColumnHidden: False ColumnOrder: Default ColumnWidth: Default Data Updatable: False DisplayControl: Text Box GUID: Long binary data Ordinal Position: 1 Required: True Source Field: CodMedic Source Table: Lista_Medici UnicodeCompression: True DenMedic Text 50 AllowZeroLength: False Attributes: Variable Length Caption: Nume Collating Order: 1048 ColumnHidden: False ColumnOrder: Default ColumnWidth: Default Data Updatable: False DisplayControl: Text Box D:\DRGWork\AccessProj\DRGNational4.0\CD\1.SpecificatiiTehnice\DRGNation Tuesday, December 21, 2004 al4.0.mdb Table: Lista_Medici Page: 29 GUID: Long binary data Ordinal Position: 2 Required: True Source Field: DenMedic Source Table: Lista_Medici UnicodeCompression: True IdSpecialitate Long Integer 4 AllowZeroLength: False Attributes: Fixed Size Caption: Specialitate Collating Order: 1048 ColumnHidden: False ColumnOrder: Default ColumnWidth: Default Data Updatable: False DecimalPlaces: 0 DisplayControl: Text Box GUID: Long binary data Ordinal Position: 3 Required: True Source Field: IdSpecialitate Source Table: Lista_Medici Relationships Lista_Spitale___FiltratLista_Medici Lista_Spitale___Filtrat Lista_Medici Spital_ID 1 Spital_ID Attributes: Enforced RelationshipType: One-To-Many Lista_MediciPacient_Fisa Lista_Medici Pacient_Fisa Spital_ID Spital_ID CodMedic CodMedicOperator Attributes: Not Enforced, Right Join RelationshipType: One-To-Many Lista_MediciPacient_Fisa Lista_Medici Pacient_Fisa Spital_ID Spital_ID CodMedic CodMedicMana2 Attributes: Not Enforced, Left Join RelationshipType: One-To-Many D:\DRGWork\AccessProj\DRGNational4.0\CD\1.SpecificatiiTehnice\DRGNation Tuesday, December 21, 2004 al4.0.mdb Table: Lista_Medici Page: 30 Lista_MediciPacient_Fisa Lista_Medici Pacient_Fisa Spital_ID 1 Spital_ID CodMedic 1 CodMedic Attributes: Enforced, Left Join RelationshipType: One-To-Many Table Indexes Name Number of Fields {EA394758-A569-4132-AC7B-2CC381BA4665} 1 Clustered: False DistinctCount: 0 Foreign: True Ignore Nulls: False Name: {EA394758-A569-4132-AC7B-2CC381BA4665} Primary: False Required: False Unique: False Fields: Ascending IdSpecialitate 1 Clustered: False DistinctCount: 0 Foreign: False Ignore Nulls: False Name: IdSpecialitate Primary: False Required: False Unique: False Fields: Ascending PrimaryKey 2 Clustered: False DistinctCount: 0 Foreign: False Ignore Nulls: False Name: PrimaryKey Primary: True Required: True Unique: True Fields: Ascending Ascending User Permissions admin drgadmin Delete, Read Permissions, Set Permissions, Change Owner, Read Definition, Write Definition, Read Data, Insert Data, Update Data, drguser D:\DRGWork\AccessProj\DRGNational4.0\CD\1.SpecificatiiTehnice\DRGNation Tuesday, December 21, 2004 al4.0.mdb Table: Lista_Medici Page: 31 Group Permissions Admins Delete, Read Permissions, Set Permissions, Change Owner, Read Definition, Write Definition, Read Data, Insert Data, Update Data, DRGUsers Users Delete, Read Permissions, Set Permissions, Change Owner, Read Definition, Write Definition, Read Data, Insert Data, Update Data, D:\DRGWork\AccessProj\DRGNational4.0\CD\1.SpecificatiiTehnice\DRGNation Tuesday, December 21, 2004 al4.0.mdb Table: Lista_NumeRSA Page: 32 Properties Date Created: 11/22/2004 12:44:18 PM GUID: Long binary data Last Updated: 11/24/2004 1:33:39 PM NameMap: Long binary data OrderByOn: False Orientation: 0 RecordCount: 25 Updatable: True Columns Name Type Size RSANume Text 255 AllowZeroLength: False Attributes: Variable Length Collating Order: 1048 ColumnHidden: False ColumnOrder: Default ColumnWidth: Default Data Updatable: False DisplayControl: Text Box GUID: Long binary data Ordinal Position: 0 Required: False Source Field: RSANume Source Table: Lista_NumeRSA UnicodeCompression: True User Permissions admin drgadmin Delete, Read Permissions, Set Permissions, Change Owner, Read Definition, Write Definition, Read Data, Insert Data, Update Data, drguser Group Permissions Admins Delete, Read Permissions, Set Permissions, Change Owner, Read Definition, Write Definition, Read Data, Insert Data, Update Data, DRGUsers Users Delete, Read Permissions, Set Permissions, Change Owner, Read Definition, Write Definition, Read Data, Insert Data, Update Data, D:\DRGWork\AccessProj\DRGNational4.0\CD\1.SpecificatiiTehnice\DRGNation Tuesday, December 21, 2004 al4.0.mdb Table: Lista_Proceduri Page: 33 Properties DatasheetFontHeight: 10 DatasheetFontItalic: False DatasheetFontName: Arial DatasheetFontUnderlin False DatasheetFontWeight: Normal DatasheetForeColor: 0 Date Created: 11/22/2004 12:44:18 PM GUID: Long binary data Last Updated: 12/17/2004 12:06:13 AM NameMap: Long binary data OrderByOn: False Orientation: 0 RecordCount: 5926 TabularCharSet: 0 TabularFamily: 34 Updatable: True Columns Name Type Size CodProcedura Text 8 AllowZeroLength: False Attributes: Variable Length Collating Order: 1048 ColumnHidden: False ColumnOrder: 1 ColumnWidth: 1335 Data Updatable: False DisplayControl: Text Box GUID: Long binary data Ordinal Position: 0 Required: True Source Field: CodProcedura Source Table: Lista_Proceduri UnicodeCompression: True CodBloc Integer 2 AllowZeroLength: False Attributes: Fixed Size Collating Order: 1048 ColumnHidden: False ColumnOrder: Default ColumnWidth: 825 Data Updatable: False DecimalPlaces: 0 DisplayControl: Text Box GUID: Long binary data Ordinal Position: 1 Required: True Source Field: CodBloc Source Table: Lista_Proceduri DenProcedura Text 255 AllowZeroLength: False Attributes: Variable Length Collating Order: 1048 ColumnHidden: False ColumnOrder: Default ColumnWidth: 9990 Data Updatable: False DisplayControl: Text Box GUID: Long binary data Ordinal Position: 2 Required: True D:\DRGWork\AccessProj\DRGNational4.0\CD\1.SpecificatiiTehnice\DRGNation Tuesday, December 21, 2004 al4.0.mdb Table: Lista_Proceduri Page: 34 Source Field: DenProcedura Source Table: Lista_Proceduri UnicodeCompression: True Relationships Lista_Proceduri___BlocuriLista_Proceduri Lista_Proceduri___Blocur Lista_Proceduri CodBloc 1 CodBloc Attributes: Enforced RelationshipType: One-To-Many Lista_ProceduriPacient_Fisa Lista_Proceduri Pacient_Fisa 1 CodProcedura CodInterventieChirurgica Attributes: Enforced RelationshipType: One-To-Many Lista_ProceduriPacient_Proceduri Lista_Proceduri Pacient_Proceduri 1 CodProcedura CodProcedura Attributes: Enforced RelationshipType: One-To-Many Table Indexes Name Number of Fields {2C840B1A-6690-4F63-884C-2BB6C46A3197} 1 Clustered: False DistinctCount: 1424 Foreign: True Ignore Nulls: False Name: {2C840B1A-6690-4F63-884C-2BB6C46A3197} Primary: False Required: False Unique: False Fields: Ascending CU_DenProcedura 1 Clustered: False DistinctCount: 5926 Foreign: False Ignore Nulls: False Name: CU_DenProcedura Primary: False Required: False Unique: True D:\DRGWork\AccessProj\DRGNational4.0\CD\1.SpecificatiiTehnice\DRGNation Tuesday, December 21, 2004 al4.0.mdb Table: Lista_Proceduri Page: 35 Fields: Ascending ix_CodBloc 1 Clustered: False DistinctCount: 1424 Foreign: False Ignore Nulls: False Name: ix_CodBloc Primary: False Required: False Unique: False Fields: Ascending PrimaryKey 1 Clustered: False DistinctCount: 5926 Foreign: False Ignore Nulls: False Name: PrimaryKey Primary: True Required: True Unique: True Fields: Ascending User Permissions admin drgadmin Delete, Read Permissions, Set Permissions, Change Owner, Read Definition, Write Definition, Read Data, Insert Data, Update Data, drguser Group Permissions Admins Delete, Read Permissions, Set Permissions, Change Owner, Read Definition, Write Definition, Read Data, Insert Data, Update Data, DRGUsers Users Delete, Read Permissions, Set Permissions, Change Owner, Read Definition, Write Definition, Read Data, Insert Data, Update Data, D:\DRGWork\AccessProj\DRGNational4.0\CD\1.SpecificatiiTehnice\DRGNation Tuesday, December 21, 2004 al4.0.mdb Table: Lista_Proceduri___Blocuri Page: 36 Properties DatasheetFontHeight: 10 DatasheetFontItalic: False DatasheetFontName: Arial DatasheetFontUnderlin False DatasheetFontWeight: Normal DatasheetForeColor: 0 Date Created: 11/22/2004 12:44:18 PM GUID: Long binary data Last Updated: 11/24/2004 3:16:41 PM NameMap: Long binary data OrderByOn: False Orientation: 0 RecordCount: 1424 TabularCharSet: 0 TabularFamily: 34 Updatable: True Columns Name Type Size CodBloc Integer 2 AllowZeroLength: False Attributes: Fixed Size Collating Order: 1048 ColumnHidden: False ColumnOrder: 1 ColumnWidth: 825 Data Updatable: False DecimalPlaces: 0 DisplayControl: Text Box GUID: Long binary data Ordinal Position: 0 Required: True Source Field: CodBloc Source Table: Lista_Proceduri___Blocuri CodCapitol Byte 1 AllowZeroLength: False Attributes: Fixed Size Collating Order: 1048 ColumnHidden: False ColumnOrder: Default ColumnWidth: 1050 Data Updatable: False DecimalPlaces: 0 DisplayControl: Text Box GUID: Long binary data Ordinal Position: 1 Required: True Source Field: CodCapitol Source Table: Lista_Proceduri___Blocuri DenBloc Text 255 AllowZeroLength: False Attributes: Variable Length Collating Order: 1048 ColumnHidden: False ColumnOrder: Default ColumnWidth: 6765 Data Updatable: False DisplayControl: Text Box GUID: Long binary data Ordinal Position: 2 Required: True D:\DRGWork\AccessProj\DRGNational4.0\CD\1.SpecificatiiTehnice\DRGNation Tuesday, December 21, 2004 al4.0.mdb Table: Lista_Proceduri___Blocuri Page: 37 Source Field: DenBloc Source Table: Lista_Proceduri___Blocuri UnicodeCompression: True Relationships Lista_Proceduri___BlocuriLista_Proceduri Lista_Proceduri___Blocur Lista_Proceduri CodBloc 1 CodBloc Attributes: Enforced RelationshipType: One-To-Many Lista_Proceduri___CapitoleLista_Proceduri___Blocuri Lista_Proceduri___Capito Lista_Proceduri___Blocur 1 CodCapitol CodCapitol Attributes: Enforced RelationshipType: One-To-Many Table Indexes Name Number of Fields {594B03B9-FF85-4ED8-BE69-C7B01E21C4D3} 1 Clustered: False DistinctCount: 20 Foreign: True Ignore Nulls: False Name: {594B03B9-FF85-4ED8-BE69-C7B01E21C4D3} Primary: False Required: False Unique: False Fields: Ascending CU_DenBloc 1 Clustered: False DistinctCount: 1424 Foreign: False Ignore Nulls: False Name: CU_DenBloc Primary: False Required: False Unique: True Fields: Ascending ix_CodCapitol 1 Clustered: False DistinctCount: 20 Foreign: False Ignore Nulls: False Name: ix_CodCapitol Primary: False Required: False D:\DRGWork\AccessProj\DRGNational4.0\CD\1.SpecificatiiTehnice\DRGNation Tuesday, December 21, 2004 al4.0.mdb Table: Lista_Proceduri___Blocuri Page: 38 Unique: False Fields: Ascending PrimaryKey 1 Clustered: False DistinctCount: 1424 Foreign: False Ignore Nulls: False Name: PrimaryKey Primary: True Required: True Unique: True Fields: Ascending User Permissions admin drgadmin Delete, Read Permissions, Set Permissions, Change Owner, Read Definition, Write Definition, Read Data, Insert Data, Update Data, drguser Group Permissions Admins Delete, Read Permissions, Set Permissions, Change Owner, Read Definition, Write Definition, Read Data, Insert Data, Update Data, DRGUsers Users Delete, Read Permissions, Set Permissions, Change Owner, Read Definition, Write Definition, Read Data, Insert Data, Update Data, D:\DRGWork\AccessProj\DRGNational4.0\CD\1.SpecificatiiTehnice\DRGNation Tuesday, December 21, 2004 al4.0.mdb Table: Lista_Proceduri___Capitole Page: 39 Properties DatasheetFontHeight: 10 DatasheetFontItalic: False DatasheetFontName: Arial DatasheetFontUnderlin False DatasheetFontWeight: Normal DatasheetForeColor: 0 Date Created: 11/22/2004 12:44:18 PM GUID: Long binary data Last Updated: 11/24/2004 3:16:41 PM NameMap: Long binary data OrderByOn: False Orientation: 0 RecordCount: 20 TabularCharSet: 0 TabularFamily: 34 Updatable: True Columns Name Type Size CodCapitol Byte 1 AllowZeroLength: False Attributes: Fixed Size Collating Order: 1048 ColumnHidden: False ColumnOrder: 1 ColumnWidth: 1050 Data Updatable: False DecimalPlaces: 0 DisplayControl: Text Box GUID: Long binary data Ordinal Position: 0 Required: True Source Field: CodCapitol Source Table: Lista_Proceduri___Capitole DenCapitol Text 255 AllowZeroLength: False Attributes: Variable Length Collating Order: 1048 ColumnHidden: False ColumnOrder: Default ColumnWidth: 4890 Data Updatable: False DisplayControl: Text Box GUID: Long binary data Ordinal Position: 1 Required: True Source Field: DenCapitol Source Table: Lista_Proceduri___Capitole UnicodeCompression: True Relationships Lista_Proceduri___CapitoleLista_Proceduri___Blocuri Lista_Proceduri___Capito Lista_Proceduri___Blocur CodCapitol 1 CodCapitol Attributes: Enforced RelationshipType: One-To-Many D:\DRGWork\AccessProj\DRGNational4.0\CD\1.SpecificatiiTehnice\DRGNation Tuesday, December 21, 2004 al4.0.mdb Table: Lista_Proceduri___Capitole Page: 40 Table Indexes Name Number of Fields CU_DenCapitol 1 Clustered: False DistinctCount: 20 Foreign: False Ignore Nulls: False Name: CU_DenCapitol Primary: False Required: False Unique: True Fields: Ascending PrimaryKey 1 Clustered: False DistinctCount: 20 Foreign: False Ignore Nulls: False Name: PrimaryKey Primary: True Required: True Unique: True Fields: Ascending User Permissions admin drgadmin Delete, Read Permissions, Set Permissions, Change Owner, Read Definition, Write Definition, Read Data, Insert Data, Update Data, drguser Group Permissions Admins Delete, Read Permissions, Set Permissions, Change Owner, Read Definition, Write Definition, Read Data, Insert Data, Update Data, DRGUsers Users Delete, Read Permissions, Set Permissions, Change Owner, Read Definition, Write Definition, Read Data, Insert Data, Update Data, D:\DRGWork\AccessProj\DRGNational4.0\CD\1.SpecificatiiTehnice\DRGNation Tuesday, December 21, 2004 al4.0.mdb Table: Lista_Sectii Page: 41 Properties Date Created: 11/25/2004 11:34:03 AM GUID: Long binary data Last Updated: 11/25/2004 12:01:30 PM NameMap: Long binary data OrderByOn: False Orientation: 0 RecordCount: 147 Updatable: True Columns Name Type Size Sectie_ID Text 4 AllowZeroLength: False Attributes: Variable Length Collating Order: 1048 ColumnHidden: False ColumnOrder: Default ColumnWidth: 1050 Data Updatable: False DisplayControl: Text Box GUID: Long binary data Ordinal Position: 0 Required: True Source Field: Sectie_ID Source Table: Lista_Sectii UnicodeCompression: False SectieNume Text 100 AllowZeroLength: False Attributes: Variable Length Collating Order: 1048 ColumnHidden: False ColumnOrder: Default ColumnWidth: 4155 Data Updatable: False DisplayControl: Text Box GUID: Long binary data Ordinal Position: 1 Required: True Source Field: SectieNume Source Table: Lista_Sectii UnicodeCompression: False Acut Yes/No 1 AllowZeroLength: False Attributes: Fixed Size Collating Order: 1048 ColumnHidden: False ColumnOrder: Default ColumnWidth: 570 Data Updatable: False DisplayControl: Text Box GUID: Long binary data Ordinal Position: 2 Required: True Source Field: Acut Source Table: Lista_Sectii Relationships D:\DRGWork\AccessProj\DRGNational4.0\CD\1.SpecificatiiTehnice\DRGNation Tuesday, December 21, 2004 al4.0.mdb Table: Lista_Sectii Page: 42 Lista_SectiiLista_Sectii___Filtrat Lista_Sectii Lista_Sectii___Filtrat 1 Sectie_ID Sectie_ID Attributes: Enforced RelationshipType: One-To-Many Table Indexes Name Number of Fields CU_Sectie_Nume 1 Clustered: False DistinctCount: 147 Foreign: False Ignore Nulls: False Name: CU_Sectie_Nume Primary: False Required: False Unique: True Fields: Ascending PrimaryKey 1 Clustered: False DistinctCount: 147 Foreign: False Ignore Nulls: False Name: PrimaryKey Primary: True Required: True Unique: True Fields: Ascending User Permissions admin drgadmin Delete, Read Permissions, Set Permissions, Change Owner, Read Definition, Write Definition, Read Data, Insert Data, Update Data, drguser Group Permissions Admins Delete, Read Permissions, Set Permissions, Change Owner, Read Definition, Write Definition, Read Data, Insert Data, Update Data, DRGUsers Users Delete, Read Permissions, Set Permissions, Change Owner, Read Definition, Write Definition, Read Data, Insert Data, Update Data, D:\DRGWork\AccessProj\DRGNational4.0\CD\1.SpecificatiiTehnice\DRGNation Tuesday, December 21, 2004 al4.0.mdb Table: Lista_Sectii___Filtrat Page: 43 Properties DatasheetFontHeight: 10 DatasheetFontItalic: False DatasheetFontName: Arial DatasheetFontUnderlin False DatasheetFontWeight: Normal DatasheetForeColor: 0 Date Created: 11/22/2004 12:44:18 PM GUID: Long binary data Last Updated: 11/25/2004 11:41:19 AM NameMap: Long binary data OrderByOn: False Orientation: 0 RecordCount: 0 TabularCharSet: 0 TabularFamily: 34 Updatable: True Columns Name Type Size Spital_ID Text 6 AllowZeroLength: False Attributes: Variable Length Collating Order: 1048 ColumnHidden: False ColumnOrder: Default ColumnWidth: Default Data Updatable: False DisplayControl: Text Box GUID: Long binary data Ordinal Position: 0 Required: True Source Field: Spital_ID Source Table: Lista_Sectii___Filtrat UnicodeCompression: True Sectie_ID Text 4 AllowZeroLength: False Attributes: Variable Length Collating Order: 1048 ColumnHidden: False ColumnOrder: Default ColumnWidth: Default Data Updatable: False DisplayControl: Text Box GUID: Long binary data Ordinal Position: 1 Required: True Source Field: Sectie_ID Source Table: Lista_Sectii___Filtrat UnicodeCompression: True NumarSectie Long Integer 4 AllowZeroLength: False Attributes: Fixed Size Collating Order: 1048 ColumnHidden: False ColumnOrder: Default ColumnWidth: Default Data Updatable: False DecimalPlaces: 0 DisplayControl: Text Box GUID: Long binary data Ordinal Position: 2 D:\DRGWork\AccessProj\DRGNational4.0\CD\1.SpecificatiiTehnice\DRGNation Tuesday, December 21, 2004 al4.0.mdb Table: Lista_Sectii___Filtrat Page: 44 Required: True Source Field: NumarSectie Source Table: Lista_Sectii___Filtrat Implicit Yes/No 1 AllowZeroLength: False Attributes: Fixed Size Collating Order: 1048 ColumnHidden: False ColumnOrder: Default ColumnWidth: Default Data Updatable: False DisplayControl: 106 Format: Yes/No GUID: Long binary data Ordinal Position: 3 Required: False Source Field: Implicit Source Table: Lista_Sectii___Filtrat Relationships Lista_Spitale___FiltratLista_Sectii___Filtrat Lista_Spitale___Filtrat Lista_Sectii___Filtrat Spital_ID 1 Spital_ID Attributes: Enforced RelationshipType: One-To-Many Lista_Sectii___FiltratPacient_Sectii Lista_Sectii___Filtrat Pacient_Sectii Spital_ID 1 Spital_ID Sectie_ID 1 Sectie_ID NumarSectie 1 NumarSectie Attributes: Enforced RelationshipType: One-To-Many Lista_Sectii___FiltratPacient_Fisa Lista_Sectii___Filtrat Pacient_Fisa Spital_ID 1 Spital_ID Sectie_ID 1 Sectie_ID NumarSectie 1 NumarSectie Attributes: Enforced RelationshipType: One-To-Many D:\DRGWork\AccessProj\DRGNational4.0\CD\1.SpecificatiiTehnice\DRGNation Tuesday, December 21, 2004 al4.0.mdb Table: Lista_Sectii___Filtrat Page: 45 Lista_SectiiLista_Sectii___Filtrat Lista_Sectii Lista_Sectii___Filtrat Sectie_ID 1 Sectie_ID Attributes: Enforced RelationshipType: One-To-Many Table Indexes Name Number of Fields {B68E0DD5-864C-499B-8720-40ECCC3179EF} 1 Clustered: False DistinctCount: 0 Foreign: True Ignore Nulls: False Name: {B68E0DD5-864C-499B-8720-40ECCC3179EF} Primary: False Required: False Unique: False Fields: Ascending Lista_Sectii___FiltratSectie_ID 1 Clustered: False DistinctCount: 0 Foreign: False Ignore Nulls: False Name: Lista_Sectii___FiltratSectie_ID Primary: False Required: False Unique: False Fields: Ascending Lista_SectiiLista_Sectii___Filtrat 1 Clustered: False DistinctCount: 0 Foreign: True Ignore Nulls: False Name: Lista_SectiiLista_Sectii___Filtrat Primary: False Required: False Unique: False Fields: Ascending PrimaryKey 3 Clustered: False DistinctCount: 0 Foreign: False Ignore Nulls: False Name: PrimaryKey Primary: True Required: True Unique: True Fields: Ascending Ascending Ascending User Permissions D:\DRGWork\AccessProj\DRGNational4.0\CD\1.SpecificatiiTehnice\DRGNation Tuesday, December 21, 2004 al4.0.mdb Table: Lista_Sectii___Filtrat Page: 46 admin drgadmin Delete, Read Permissions, Set Permissions, Change Owner, Read Definition, Write Definition, Read Data, Insert Data, Update Data, drguser Group Permissions Admins Delete, Read Permissions, Set Permissions, Change Owner, Read Definition, Write Definition, Read Data, Insert Data, Update Data, DRGUsers Users Delete, Read Permissions, Set Permissions, Change Owner, Read Definition, Write Definition, Read Data, Insert Data, Update Data, D:\DRGWork\AccessProj\DRGNational4.0\CD\1.SpecificatiiTehnice\DRGNation Tuesday, December 21, 2004 al4.0.mdb Table: Lista_Specialitati Page: 47 Properties Date Created: 11/22/2004 12:44:18 PM GUID: Long binary data Last Updated: 12/17/2004 2:41:43 PM NameMap: Long binary data OrderByOn: False Orientation: 0 RecordCount: 56 Updatable: True Columns Name Type Size IdSpecialitate Integer 2 AllowZeroLength: False Attributes: Fixed Size Collating Order: 1048 ColumnHidden: False ColumnOrder: 1 ColumnWidth: Default Data Updatable: False DecimalPlaces: Auto DisplayControl: Text Box GUID: Long binary data Ordinal Position: 0 Required: False Source Field: IdSpecialitate Source Table: Lista_Specialitati DenSpecialitate Text 50 AllowZeroLength: False Attributes: Variable Length Collating Order: 1048 ColumnHidden: False ColumnOrder: Default ColumnWidth: 2835 Data Updatable: False DisplayControl: Text Box GUID: Long binary data Ordinal Position: 1 Required: False Source Field: DenSpecialitate Source Table: Lista_Specialitati UnicodeCompression: True Table Indexes Name Number of Fields PrimaryKey 1 Clustered: False DistinctCount: 56 Foreign: False Ignore Nulls: False Name: PrimaryKey Primary: True Required: True Unique: True Fields: Ascending Specialitate_ID 1 Clustered: False D:\DRGWork\AccessProj\DRGNational4.0\CD\1.SpecificatiiTehnice\DRGNation Tuesday, December 21, 2004 al4.0.mdb Table: Lista_Specialitati Page: 48 DistinctCount: 56 Foreign: False Ignore Nulls: False Name: Specialitate_ID Primary: False Required: False Unique: False Fields: Ascending User Permissions admin drgadmin Delete, Read Permissions, Set Permissions, Change Owner, Read Definition, Write Definition, Read Data, Insert Data, Update Data, drguser Group Permissions Admins Delete, Read Permissions, Set Permissions, Change Owner, Read Definition, Write Definition, Read Data, Insert Data, Update Data, DRGUsers Users Delete, Read Permissions, Set Permissions, Change Owner, Read Definition, Write Definition, Read Data, Insert Data, Update Data, D:\DRGWork\AccessProj\DRGNational4.0\CD\1.SpecificatiiTehnice\DRGNation Tuesday, December 21, 2004 al4.0.mdb Table: Lista_Spitale Page: 49 Properties DatasheetFontHeight: 8 DatasheetFontItalic: False DatasheetFontName: Arial DatasheetFontUnderlin False DatasheetFontWeight: Normal DatasheetForeColor: 0 Date Created: 11/25/2004 11:34:03 AM GUID: Long binary data Last Updated: 12/17/2004 4:26:31 PM NameMap: Long binary data OrderByOn: False Orientation: 0 RecordCount: 481 TabularCharSet: 0 TabularFamily: 34 Updatable: True Columns Name Type Size Spital_ID Text 6 AllowZeroLength: False Attributes: Variable Length Collating Order: 1048 ColumnHidden: False ColumnOrder: Default ColumnWidth: 840 Data Updatable: False DisplayControl: Text Box GUID: Long binary data Ordinal Position: 0 Required: True Source Field: Spital_ID Source Table: Lista_Spitale UnicodeCompression: False SpitalID_CNAS Text 10 AllowZeroLength: False Attributes: Variable Length Collating Order: 1048 ColumnHidden: False ColumnOrder: Default ColumnWidth: Default Data Updatable: False DisplayControl: Text Box GUID: Long binary data Ordinal Position: 1 Required: True Source Field: SpitalID_CNAS Source Table: Lista_Spitale UnicodeCompression: True SpitalDenumire Text 200 AllowZeroLength: False Attributes: Variable Length Collating Order: 1048 ColumnHidden: False ColumnOrder: Default ColumnWidth: 4995 Data Updatable: False DisplayControl: Text Box GUID: Long binary data Ordinal Position: 2 Required: True D:\DRGWork\AccessProj\DRGNational4.0\CD\1.SpecificatiiTehnice\DRGNation Tuesday, December 21, 2004 al4.0.mdb Table: Lista_Spitale Page: 50 Source Field: SpitalDenumire Source Table: Lista_Spitale UnicodeCompression: False IdJudet Byte 1 AllowZeroLength: False Attributes: Fixed Size Collating Order: 1048 ColumnHidden: False ColumnOrder: Default ColumnWidth: 765 Data Updatable: False DecimalPlaces: 0 DisplayControl: Text Box GUID: Long binary data Ordinal Position: 3 Required: True Source Field: IdJudet Source Table: Lista_Spitale IdLocalitate Long Integer 4 AllowZeroLength: False Attributes: Fixed Size Collating Order: 1048 ColumnHidden: False ColumnOrder: Default ColumnWidth: 1095 Data Updatable: False DecimalPlaces: 0 DisplayControl: Text Box GUID: Long binary data Ordinal Position: 4 Required: True Source Field: IdLocalitate Source Table: Lista_Spitale Principal Yes/No 1 AllowZeroLength: False Attributes: Fixed Size Collating Order: 1048 ColumnHidden: False ColumnOrder: Default ColumnWidth: 855 Data Updatable: False DisplayControl: Text Box GUID: Long binary data Ordinal Position: 6 Required: True Source Field: Principal Source Table: Lista_Spitale Relationships D:\DRGWork\AccessProj\DRGNational4.0\CD\1.SpecificatiiTehnice\DRGNation Tuesday, December 21, 2004 al4.0.mdb Table: Lista_Spitale Page: 51 Lista_LocalitatiLista_Spitale Lista_Localitati Lista_Spitale IdJudet 1 IdJudet IdLocalitate 1 IdLocalitate Attributes: Enforced RelationshipType: One-To-Many Lista_SpitaleLista_Spitale___Filtrat Lista_Spitale Lista_Spitale___Filtrat Spital_ID 1 1 Spital_ID Attributes: Unique, Enforced RelationshipType: One-To-One Table Indexes Name Number of Fields IdJudet 1 Clustered: False DistinctCount: 42 Foreign: False Ignore Nulls: False Name: IdJudet Primary: False Required: False Unique: False Fields: Ascending IdLocalitate 1 Clustered: False DistinctCount: 293 Foreign: False Ignore Nulls: False Name: IdLocalitate Primary: False Required: False Unique: False Fields: Ascending Lista_LocalitatiLista_Spitale 2 Clustered: False DistinctCount: 306 Foreign: True Ignore Nulls: False Name: Lista_LocalitatiLista_Spitale Primary: False Required: False Unique: False Fields: Ascending Ascending PrimaryKey 1 Clustered: False D:\DRGWork\AccessProj\DRGNational4.0\CD\1.SpecificatiiTehnice\DRGNation Tuesday, December 21, 2004 al4.0.mdb Table: Lista_Spitale Page: 52 DistinctCount: 481 Foreign: False Ignore Nulls: False Name: PrimaryKey Primary: True Required: True Unique: True Fields: Ascending User Permissions admin drgadmin Delete, Read Permissions, Set Permissions, Change Owner, Read Definition, Write Definition, Read Data, Insert Data, Update Data, drguser Group Permissions Admins Delete, Read Permissions, Set Permissions, Change Owner, Read Definition, Write Definition, Read Data, Insert Data, Update Data, DRGUsers Users Delete, Read Permissions, Set Permissions, Change Owner, Read Definition, Write Definition, Read Data, Insert Data, Update Data, D:\DRGWork\AccessProj\DRGNational4.0\CD\1.SpecificatiiTehnice\DRGNation Tuesday, December 21, 2004 al4.0.mdb Table: Lista_Spitale___Filtrat Page: 53 Properties DatasheetFontHeight: 10 DatasheetFontItalic: False DatasheetFontName: Arial DatasheetFontUnderlin False DatasheetFontWeight: Normal DatasheetForeColor: 0 Date Created: 11/22/2004 12:44:18 PM GUID: Long binary data Last Updated: 11/25/2004 11:40:49 AM NameMap: Long binary data OrderByOn: False Orientation: 0 RecordCount: 0 TabularCharSet: 0 TabularFamily: 34 Updatable: True Columns Name Type Size Spital_ID Text 6 AllowZeroLength: False Attributes: Variable Length Collating Order: 1048 ColumnHidden: False ColumnOrder: 1 ColumnWidth: Default Data Updatable: False DisplayControl: Text Box GUID: Long binary data Ordinal Position: 0 Required: True Source Field: Spital_ID Source Table: Lista_Spitale___Filtrat UnicodeCompression: False NumarPaturi Integer 2 AllowZeroLength: False Attributes: Fixed Size Collating Order: 1048 ColumnHidden: False ColumnOrder: Default ColumnWidth: Default Data Updatable: False DecimalPlaces: 0 DisplayControl: Text Box GUID: Long binary data Ordinal Position: 1 Required: False Source Field: NumarPaturi Source Table: Lista_Spitale___Filtrat Relationships Lista_Spitale___FiltratPacient_Fisa Lista_Spitale___Filtrat Pacient_Fisa Spital_ID 1 Spital_ID Attributes: Enforced RelationshipType: One-To-Many D:\DRGWork\AccessProj\DRGNational4.0\CD\1.SpecificatiiTehnice\DRGNation Tuesday, December 21, 2004 al4.0.mdb Table: Lista_Spitale___Filtrat Page: 54 Lista_Spitale___FiltratLista_Sectii___Filtrat Lista_Spitale___Filtrat Lista_Sectii___Filtrat Spital_ID 1 Spital_ID Attributes: Enforced RelationshipType: One-To-Many Lista_Spitale___FiltratLista_Medici Lista_Spitale___Filtrat Lista_Medici Spital_ID 1 Spital_ID Attributes: Enforced RelationshipType: One-To-Many Lista_SpitaleLista_Spitale___Filtrat Lista_Spitale Lista_Spitale___Filtrat 1 1 Spital_ID Spital_ID Attributes: Unique, Enforced RelationshipType: One-To-One Table Indexes Name Number of Fields Lista_SpitaleLista_Spitale___Filtrat 1 Clustered: False DistinctCount: 0 Foreign: True Ignore Nulls: False Name: Lista_SpitaleLista_Spitale___Filtrat Primary: False Required: False Unique: True Fields: Ascending NumarPaturi 1 Clustered: False DistinctCount: 0 Foreign: False Ignore Nulls: False Name: NumarPaturi Primary: False Required: False Unique: False Fields: Ascending PrimaryKey 1 Clustered: False DistinctCount: 0 Foreign: False Ignore Nulls: False D:\DRGWork\AccessProj\DRGNational4.0\CD\1.SpecificatiiTehnice\DRGNation Tuesday, December 21, 2004 al4.0.mdb Table: Lista_Spitale___Filtrat Page: 55 Name: PrimaryKey Primary: True Required: True Unique: True Fields: Ascending User Permissions admin drgadmin Delete, Read Permissions, Set Permissions, Change Owner, Read Definition, Write Definition, Read Data, Insert Data, Update Data, drguser Group Permissions Admins Delete, Read Permissions, Set Permissions, Change Owner, Read Definition, Write Definition, Read Data, Insert Data, Update Data, DRGUsers Users Delete, Read Permissions, Set Permissions, Change Owner, Read Definition, Write Definition, Read Data, Insert Data, Update Data, D:\DRGWork\AccessProj\DRGNational4.0\CD\1.SpecificatiiTehnice\DRGNation Tuesday, December 21, 2004 al4.0.mdb Table: Lista_StareExternare Page: 56 Properties DatasheetFontHeight: 10 DatasheetFontItalic: False DatasheetFontName: Arial DatasheetFontUnderlin False DatasheetFontWeight: Normal DatasheetForeColor: 0 Date Created: 11/22/2004 12:44:18 PM GUID: Long binary data Last Updated: 12/07/2004 1:29:48 PM NameMap: Long binary data OrderByOn: False Orientation: 0 RecordCount: 6 TabularCharSet: 0 TabularFamily: 34 Updatable: True Columns Name Type Size IdStareExternare Byte 1 AllowZeroLength: False Attributes: Fixed Size Collating Order: 1048 ColumnHidden: False ColumnOrder: 1 ColumnWidth: Default Data Updatable: False DecimalPlaces: 0 DisplayControl: Text Box GUID: Long binary data Ordinal Position: 0 Required: True Source Field: IdStareExternare Source Table: Lista_StareExternare StareExternare Text 20 AllowZeroLength: False Attributes: Variable Length Collating Order: 1048 ColumnHidden: False ColumnOrder: Default ColumnWidth: 6090 Data Updatable: False DisplayControl: Text Box GUID: Long binary data Ordinal Position: 1 Required: True Source Field: StareExternare Source Table: Lista_StareExternare UnicodeCompression: True Relationships Lista_StareExternarePacient_Fisa Lista_StareExternare Pacient_Fisa IdStareExternare 1 IdStareExternare Attributes: Enforced RelationshipType: One-To-Many D:\DRGWork\AccessProj\DRGNational4.0\CD\1.SpecificatiiTehnice\DRGNation Tuesday, December 21, 2004 al4.0.mdb Table: Lista_StareExternare Page: 57 Table Indexes Name Number of Fields CU_StareExternare 1 Clustered: False DistinctCount: 6 Foreign: False Ignore Nulls: False Name: CU_StareExternare Primary: False Required: False Unique: True Fields: Ascending PrimaryKey 1 Clustered: False DistinctCount: 6 Foreign: False Ignore Nulls: False Name: PrimaryKey Primary: True Required: True Unique: True Fields: Ascending User Permissions admin drgadmin Delete, Read Permissions, Set Permissions, Change Owner, Read Definition, Write Definition, Read Data, Insert Data, Update Data, drguser Group Permissions Admins Delete, Read Permissions, Set Permissions, Change Owner, Read Definition, Write Definition, Read Data, Insert Data, Update Data, DRGUsers Users Delete, Read Permissions, Set Permissions, Change Owner, Read Definition, Write Definition, Read Data, Insert Data, Update Data, D:\DRGWork\AccessProj\DRGNational4.0\CD\1.SpecificatiiTehnice\DRGNation Tuesday, December 21, 2004 al4.0.mdb Table: Lista_StareRecord Page: 58 Properties DatasheetFontHeight: 10 DatasheetFontItalic: False DatasheetFontName: Arial DatasheetFontUnderlin False DatasheetFontWeight: Normal DatasheetForeColor: 0 Date Created: 11/22/2004 12:44:18 PM GUID: Long binary data Last Updated: 11/22/2004 1:01:52 PM NameMap: Long binary data OrderByOn: False Orientation: 0 RecordCount: 4 TabularCharSet: 0 TabularFamily: 34 Updatable: True Columns Name Type Size IdStareRecord Byte 1 AllowZeroLength: False Attributes: Fixed Size Collating Order: 1048 ColumnHidden: False ColumnOrder: 1 ColumnWidth: 1320 Data Updatable: False DecimalPlaces: 0 DisplayControl: Text Box GUID: Long binary data Ordinal Position: 0 Required: True Source Field: IdStareRecord Source Table: Lista_StareRecord StareRecord Text 40 AllowZeroLength: False Attributes: Variable Length Collating Order: 1048 ColumnHidden: False ColumnOrder: Default ColumnWidth: 1170 Data Updatable: False DisplayControl: Text Box GUID: Long binary data Ordinal Position: 1 Required: True Source Field: StareRecord Source Table: Lista_StareRecord UnicodeCompression: True Relationships Lista_StareRecordPacient_Fisa Lista_StareRecord Pacient_Fisa IdStareRecord 1 IdStareRecord Attributes: Enforced RelationshipType: One-To-Many D:\DRGWork\AccessProj\DRGNational4.0\CD\1.SpecificatiiTehnice\DRGNation Tuesday, December 21, 2004 al4.0.mdb Table: Lista_StareRecord Page: 59 Table Indexes Name Number of Fields CU_StareRecord 1 Clustered: False DistinctCount: 4 Foreign: False Ignore Nulls: False Name: CU_StareRecord Primary: False Required: False Unique: True Fields: Ascending PrimaryKey 1 Clustered: False DistinctCount: 4 Foreign: False Ignore Nulls: False Name: PrimaryKey Primary: True Required: True Unique: True Fields: Ascending User Permissions admin drgadmin Delete, Read Permissions, Set Permissions, Change Owner, Read Definition, Write Definition, Read Data, Insert Data, Update Data, drguser Group Permissions Admins Delete, Read Permissions, Set Permissions, Change Owner, Read Definition, Write Definition, Read Data, Insert Data, Update Data, DRGUsers Users Delete, Read Permissions, Set Permissions, Change Owner, Read Definition, Write Definition, Read Data, Insert Data, Update Data, D:\DRGWork\AccessProj\DRGNational4.0\CD\1.SpecificatiiTehnice\DRGNation Tuesday, December 21, 2004 al4.0.mdb Table: Lista_TipAsigurare Page: 60 Properties DatasheetFontHeight: 10 DatasheetFontItalic: False DatasheetFontName: Arial DatasheetFontUnderlin False DatasheetFontWeight: Normal DatasheetForeColor: 0 Date Created: 11/22/2004 12:44:18 PM GUID: Long binary data Last Updated: 12/07/2004 12:25:35 PM NameMap: Long binary data OrderByOn: False Orientation: 0 RecordCount: 3 TabularCharSet: 0 TabularFamily: 34 Updatable: True Columns Name Type Size IdTipAsigurare Byte 1 AllowZeroLength: False Attributes: Fixed Size Collating Order: 1048 ColumnHidden: False ColumnOrder: 1 ColumnWidth: Default Data Updatable: False DecimalPlaces: 0 DisplayControl: Text Box GUID: Long binary data Ordinal Position: 0 Required: True Source Field: IdTipAsigurare Source Table: Lista_TipAsigurare TipAsigurare Text 50 AllowZeroLength: False Attributes: Variable Length Collating Order: 1048 ColumnHidden: False ColumnOrder: Default ColumnWidth: 3870 Data Updatable: False DisplayControl: Text Box GUID: Long binary data Ordinal Position: 1 Required: True Source Field: TipAsigurare Source Table: Lista_TipAsigurare UnicodeCompression: True Relationships Lista_TipAsigurarePacient_Fisa Lista_TipAsigurare Pacient_Fisa IdTipAsigurare 1 IdTipAsigurare Attributes: Enforced RelationshipType: One-To-Many D:\DRGWork\AccessProj\DRGNational4.0\CD\1.SpecificatiiTehnice\DRGNation Tuesday, December 21, 2004 al4.0.mdb Table: Lista_TipAsigurare Page: 61 Table Indexes Name Number of Fields CU_TipAsigurare 1 Clustered: False DistinctCount: 3 Foreign: False Ignore Nulls: False Name: CU_TipAsigurare Primary: False Required: False Unique: True Fields: Ascending PrimaryKey 1 Clustered: False DistinctCount: 3 Foreign: False Ignore Nulls: False Name: PrimaryKey Primary: True Required: True Unique: True Fields: Ascending User Permissions admin drgadmin Delete, Read Permissions, Set Permissions, Change Owner, Read Definition, Write Definition, Read Data, Insert Data, Update Data, drguser Group Permissions Admins Delete, Read Permissions, Set Permissions, Change Owner, Read Definition, Write Definition, Read Data, Insert Data, Update Data, DRGUsers Users Delete, Read Permissions, Set Permissions, Change Owner, Read Definition, Write Definition, Read Data, Insert Data, Update Data, D:\DRGWork\AccessProj\DRGNational4.0\CD\1.SpecificatiiTehnice\DRGNation Tuesday, December 21, 2004 al4.0.mdb Table: Lista_TipExternare Page: 62 Properties DatasheetFontHeight: 10 DatasheetFontItalic: False DatasheetFontName: Arial DatasheetFontUnderlin False DatasheetFontWeight: Normal DatasheetForeColor: 0 Date Created: 11/22/2004 12:44:18 PM GUID: Long binary data Last Updated: 11/22/2004 1:01:52 PM NameMap: Long binary data OrderByOn: False Orientation: 0 RecordCount: 4 TabularCharSet: 0 TabularFamily: 34 Updatable: True Columns Name Type Size IdTipExternare Byte 1 AllowZeroLength: False Attributes: Fixed Size Collating Order: 1048 ColumnHidden: False ColumnOrder: 1 ColumnWidth: Default Data Updatable: False DecimalPlaces: 0 DisplayControl: Text Box GUID: Long binary data Ordinal Position: 0 Required: True Source Field: IdTipExternare Source Table: Lista_TipExternare TipExternare Text 50 AllowZeroLength: False Attributes: Variable Length Collating Order: 1048 ColumnHidden: False ColumnOrder: Default ColumnWidth: 1920 Data Updatable: False DisplayControl: Text Box GUID: Long binary data Ordinal Position: 1 Required: True Source Field: TipExternare Source Table: Lista_TipExternare UnicodeCompression: True Relationships Lista_TipExternarePacient_Fisa Lista_TipExternare Pacient_Fisa IdTipExternare 1 IdTipExternare Attributes: Enforced RelationshipType: One-To-Many D:\DRGWork\AccessProj\DRGNational4.0\CD\1.SpecificatiiTehnice\DRGNation Tuesday, December 21, 2004 al4.0.mdb Table: Lista_TipExternare Page: 63 Table Indexes Name Number of Fields CU_TipExternare 1 Clustered: False DistinctCount: 4 Foreign: False Ignore Nulls: False Name: CU_TipExternare Primary: False Required: False Unique: True Fields: Ascending PrimaryKey 1 Clustered: False DistinctCount: 4 Foreign: False Ignore Nulls: False Name: PrimaryKey Primary: True Required: True Unique: True Fields: Ascending User Permissions admin drgadmin Delete, Read Permissions, Set Permissions, Change Owner, Read Definition, Write Definition, Read Data, Insert Data, Update Data, drguser Group Permissions Admins Delete, Read Permissions, Set Permissions, Change Owner, Read Definition, Write Definition, Read Data, Insert Data, Update Data, DRGUsers Users Delete, Read Permissions, Set Permissions, Change Owner, Read Definition, Write Definition, Read Data, Insert Data, Update Data, D:\DRGWork\AccessProj\DRGNational4.0\CD\1.SpecificatiiTehnice\DRGNation Tuesday, December 21, 2004 al4.0.mdb Table: Lista_TipInternare Page: 64 Properties DatasheetFontHeight: 10 DatasheetFontItalic: False DatasheetFontName: Arial DatasheetFontUnderlin False DatasheetFontWeight: Normal DatasheetForeColor: 0 Date Created: 11/22/2004 12:44:18 PM GUID: Long binary data Last Updated: 11/22/2004 1:01:52 PM NameMap: Long binary data OrderByOn: False Orientation: 0 RecordCount: 6 TabularCharSet: 0 TabularFamily: 34 Updatable: True Columns Name Type Size IdTipInternare Byte 1 AllowZeroLength: False Attributes: Fixed Size Collating Order: 1048 ColumnHidden: False ColumnOrder: 1 ColumnWidth: Default Data Updatable: False DecimalPlaces: 0 DisplayControl: Text Box GUID: Long binary data Ordinal Position: 0 Required: True Source Field: IdTipInternare Source Table: Lista_TipInternare TipInternare Text 50 AllowZeroLength: False Attributes: Variable Length Collating Order: 1048 ColumnHidden: False ColumnOrder: Default ColumnWidth: 2820 Data Updatable: False DisplayControl: Text Box GUID: Long binary data Ordinal Position: 1 Required: True Source Field: TipInternare Source Table: Lista_TipInternare UnicodeCompression: True Relationships Lista_TipInternarePacient_Fisa Lista_TipInternare Pacient_Fisa IdTipInternare 1 IdTipInternare Attributes: Enforced RelationshipType: One-To-Many D:\DRGWork\AccessProj\DRGNational4.0\CD\1.SpecificatiiTehnice\DRGNation Tuesday, December 21, 2004 al4.0.mdb Table: Lista_TipInternare Page: 65 Table Indexes Name Number of Fields CU_TipInternare 1 Clustered: False DistinctCount: 6 Foreign: False Ignore Nulls: False Name: CU_TipInternare Primary: False Required: False Unique: True Fields: Ascending PrimaryKey 1 Clustered: False DistinctCount: 6 Foreign: False Ignore Nulls: False Name: PrimaryKey Primary: True Required: True Unique: True Fields: Ascending User Permissions admin drgadmin Delete, Read Permissions, Set Permissions, Change Owner, Read Definition, Write Definition, Read Data, Insert Data, Update Data, drguser Group Permissions Admins Delete, Read Permissions, Set Permissions, Change Owner, Read Definition, Write Definition, Read Data, Insert Data, Update Data, DRGUsers Users Delete, Read Permissions, Set Permissions, Change Owner, Read Definition, Write Definition, Read Data, Insert Data, Update Data, D:\DRGWork\AccessProj\DRGNational4.0\CD\1.SpecificatiiTehnice\DRGNation Tuesday, December 21, 2004 al4.0.mdb Table: Log_AccesAplicatie Page: 66 Properties DatasheetFontHeight: 10 DatasheetFontItalic: False DatasheetFontName: Arial DatasheetFontUnderlin False DatasheetFontWeight: Normal DatasheetForeColor: 0 Date Created: 11/22/2004 12:44:18 PM GUID: Long binary data Last Updated: 12/20/2004 10:23:10 AM NameMap: Long binary data OrderByOn: False Orientation: 0 RecordCount: 0 TabularCharSet: 0 TabularFamily: 34 Updatable: True Columns Name Type Size Utilizator Text 50 AllowZeroLength: False Attributes: Variable Length Collating Order: 1048 ColumnHidden: False ColumnOrder: 1 ColumnWidth: Default Data Updatable: False DisplayControl: Text Box GUID: Long binary data Ordinal Position: 0 Required: False Source Field: Utilizator Source Table: Log_AccesAplicatie UnicodeCompression: True DataAcces Date/Time 8 AllowZeroLength: False Attributes: Fixed Size Collating Order: 1048 ColumnHidden: False ColumnOrder: Default ColumnWidth: Default Data Updatable: False Format: General Date GUID: Long binary data Ordinal Position: 1 Required: False Source Field: DataAcces Source Table: Log_AccesAplicatie User Permissions admin drgadmin Delete, Read Permissions, Set Permissions, Change Owner, Read Definition, Write Definition, Read Data, Insert Data, Update Data, drguser Group Permissions Admins Delete, Read Permissions, Set Permissions, Change Owner, Read D:\DRGWork\AccessProj\DRGNational4.0\CD\1.SpecificatiiTehnice\DRGNation Tuesday, December 21, 2004 al4.0.mdb Table: Log_AccesAplicatie Page: 67 Definition, Write Definition, Read Data, Insert Data, Update Data, Delete Data DRGUsers Users Delete, Read Permissions, Set Permissions, Change Owner, Read Definition, Write Definition, Read Data, Insert Data, Update Data, D:\DRGWork\AccessProj\DRGNational4.0\CD\1.SpecificatiiTehnice\DRGNation Tuesday, December 21, 2004 al4.0.mdb Table: Log_Modificari Page: 68 Properties DatasheetFontHeight: 10 DatasheetFontItalic: False DatasheetFontName: Arial DatasheetFontUnderlin False DatasheetFontWeight: Normal DatasheetForeColor: 0 Date Created: 11/22/2004 12:44:18 PM GUID: Long binary data Last Updated: 12/09/2004 11:35:07 AM NameMap: Long binary data OrderByOn: False Orientation: 0 RecordCount: 0 TabularCharSet: 0 TabularFamily: 34 Updatable: True Columns Name Type Size Caz_ID Text 70 AllowZeroLength: False Attributes: Variable Length Collating Order: 1048 ColumnHidden: False ColumnOrder: Default ColumnWidth: 4260 Data Updatable: False DisplayControl: Text Box GUID: Long binary data Ordinal Position: 1 Required: False Source Field: Caz_ID Source Table: Log_Modificari UnicodeCompression: True Utilizator Text 50 AllowZeroLength: False Attributes: Variable Length Collating Order: 1048 ColumnHidden: False ColumnOrder: Default ColumnWidth: Default Data Updatable: False DisplayControl: Text Box GUID: Long binary data Ordinal Position: 2 Required: False Source Field: Utilizator Source Table: Log_Modificari UnicodeCompression: True DenumireCampModificat Text 50 AllowZeroLength: False Attributes: Variable Length Collating Order: 1048 ColumnHidden: False ColumnOrder: Default ColumnWidth: 2505 Data Updatable: False DisplayControl: Text Box GUID: Long binary data Ordinal Position: 3 Required: False D:\DRGWork\AccessProj\DRGNational4.0\CD\1.SpecificatiiTehnice\DRGNation Tuesday, December 21, 2004 al4.0.mdb Table: Log_Modificari Page: 69 Source Field: DenumireCampModificat Source Table: Log_Modificari UnicodeCompression: True ValoareVeche Text 50 AllowZeroLength: False Attributes: Variable Length Collating Order: 1048 ColumnHidden: False ColumnOrder: Default ColumnWidth: 1500 Data Updatable: False DisplayControl: Text Box GUID: Long binary data Ordinal Position: 4 Required: False Source Field: ValoareVeche Source Table: Log_Modificari UnicodeCompression: True DataModificare Date/Time 8 AllowZeroLength: False Attributes: Fixed Size Collating Order: 1048 ColumnHidden: False ColumnOrder: Default ColumnWidth: 1920 Data Updatable: False GUID: Long binary data Ordinal Position: 5 Required: False Source Field: DataModificare Source Table: Log_Modificari Tabela Text 200 AllowZeroLength: False Attributes: Variable Length Collating Order: 1048 ColumnHidden: False ColumnOrder: Default ColumnWidth: Default Data Updatable: False DisplayControl: Text Box GUID: Long binary data Ordinal Position: 6 Required: False Source Field: Tabela Source Table: Log_Modificari UnicodeCompression: True IdLinie Byte 1 AllowZeroLength: False Attributes: Fixed Size Collating Order: 1048 ColumnHidden: False ColumnOrder: Default ColumnWidth: Default Data Updatable: False DecimalPlaces: Auto DisplayControl: Text Box D:\DRGWork\AccessProj\DRGNational4.0\CD\1.SpecificatiiTehnice\DRGNation Tuesday, December 21, 2004 al4.0.mdb Table: Log_Modificari Page: 70 GUID: Long binary data Ordinal Position: 7 Required: False Source Field: IdLinie Source Table: Log_Modificari TipModif Text 50 AllowZeroLength: False Attributes: Variable Length Collating Order: 1048 ColumnHidden: False ColumnOrder: Default ColumnWidth: Default Data Updatable: False DisplayControl: Text Box GUID: Long binary data Ordinal Position: 8 Required: False Source Field: TipModif Source Table: Log_Modificari UnicodeCompression: False Table Indexes Name Number of Fields Caz_ID 1 Clustered: False DistinctCount: 0 Foreign: False Ignore Nulls: False Name: Caz_ID Primary: False Required: False Unique: False Fields: Ascending IdLinie 1 Clustered: False DistinctCount: 0 Foreign: False Ignore Nulls: False Name: IdLinie Primary: False Required: False Unique: False Fields: Ascending IdTipModif 1 Clustered: False DistinctCount: 0 Foreign: False Ignore Nulls: False Name: IdTipModif Primary: False Required: False Unique: False Fields: Ascending User Permissions D:\DRGWork\AccessProj\DRGNational4.0\CD\1.SpecificatiiTehnice\DRGNation Tuesday, December 21, 2004 al4.0.mdb Table: Log_Modificari Page: 71 admin drgadmin Delete, Read Permissions, Set Permissions, Change Owner, Read Definition, Write Definition, Read Data, Insert Data, Update Data, drguser Group Permissions Admins Delete, Read Permissions, Set Permissions, Change Owner, Read Definition, Write Definition, Read Data, Insert Data, Update Data, DRGUsers Users Delete, Read Permissions, Set Permissions, Change Owner, Read Definition, Write Definition, Read Data, Insert Data, Update Data, D:\DRGWork\AccessProj\DRGNational4.0\CD\1.SpecificatiiTehnice\DRGNation Tuesday, December 21, 2004 al4.0.mdb Table: Pacient_DiagnosticeSecundare Page: 72 Properties DatasheetFontHeight: 10 DatasheetFontItalic: False DatasheetFontName: Arial DatasheetFontUnderlin False DatasheetFontWeight: Normal DatasheetForeColor: 0 Date Created: 11/22/2004 12:44:18 PM GUID: Long binary data Last Updated: 12/19/2004 9:23:23 PM NameMap: Long binary data OrderByOn: False Orientation: 0 RecordCount: 0 TabularCharSet: 0 TabularFamily: 34 Updatable: True Columns Name Type Size IdPacientDiagnosticSecundar Long Integer 4 AllowZeroLength: False Attributes: Fixed Size, Auto-Increment Collating Order: 1048 ColumnHidden: False ColumnOrder: Default ColumnWidth: 2955 Data Updatable: False GUID: Long binary data Ordinal Position: 0 Required: False Source Field: IdPacientDiagnosticSecundar Source Table: Pacient_DiagnosticeSecundare Caz_ID Text 52 AllowZeroLength: False Attributes: Variable Length Collating Order: 1048 ColumnHidden: False ColumnOrder: Default ColumnWidth: 5490 Data Updatable: False DisplayControl: Text Box GUID: Long binary data Ordinal Position: 1 Required: True Source Field: Caz_ID Source Table: Pacient_DiagnosticeSecundare UnicodeCompression: True CodDiagnosticSecundar Text 5 AllowZeroLength: False Attributes: Variable Length Collating Order: 1048 ColumnHidden: False ColumnOrder: Default ColumnWidth: 2115 Data Updatable: False DisplayControl: Text Box GUID: Long binary data Ordinal Position: 2 Required: True Source Field: CodDiagnosticSecundar Source Table: Pacient_DiagnosticeSecundare D:\DRGWork\AccessProj\DRGNational4.0\CD\1.SpecificatiiTehnice\DRGNation Tuesday, December 21, 2004 al4.0.mdb Table: Pacient_DiagnosticeSecundare Page: 73 UnicodeCompression: True CodValiditate Text 8 AllowZeroLength: False Attributes: Variable Length Collating Order: 1048 ColumnHidden: False ColumnOrder: Default ColumnWidth: 1245 Data Updatable: False DisplayControl: Text Box GUID: Long binary data Ordinal Position: 3 Required: False Source Field: CodValiditate Source Table: Pacient_DiagnosticeSecundare UnicodeCompression: True NrInGrouper Byte 1 AllowZeroLength: False Attributes: Fixed Size Collating Order: 1048 ColumnHidden: False ColumnOrder: Default ColumnWidth: 1170 Data Updatable: False DecimalPlaces: 0 DisplayControl: Text Box GUID: Long binary data Ordinal Position: 4 Required: False Source Field: NrInGrouper Source Table: Pacient_DiagnosticeSecundare Relationships Lista_DiagnosticePacient_DiagnosticeSecundare Lista_Diagnostice Pacient_DiagnosticeSecun CodDiagnostic 1 CodDiagnosticSecundar Attributes: Enforced RelationshipType: One-To-Many Pacient_FisaPacient_DiagnosticeSecundare Pacient_Fisa Pacient_DiagnosticeSecun Caz_ID 1 Caz_ID Attributes: Enforced RelationshipType: One-To-Many Table Indexes Name Number of Fields D:\DRGWork\AccessProj\DRGNational4.0\CD\1.SpecificatiiTehnice\DRGNation Tuesday, December 21, 2004 al4.0.mdb Table: Pacient_DiagnosticeSecundare Page: 74 {03AFF9CF-46F5-4A8C-BC88-B2AA920C4915} 1 Clustered: False DistinctCount: 0 Foreign: True Ignore Nulls: False Name: {03AFF9CF-46F5-4A8C-BC88-B2AA920C4915} Primary: False Required: False Unique: False Fields: Ascending {CA27A7CA-E6D1-4BE5-AAF6-88446C60884C} 1 Clustered: False DistinctCount: 0 Foreign: True Ignore Nulls: False Name: {CA27A7CA-E6D1-4BE5-AAF6-88446C60884C} Primary: False Required: False Unique: False Fields: Ascending ix_Caz_ID 2 Clustered: False DistinctCount: 0 Foreign: False Ignore Nulls: False Name: ix_Caz_ID Primary: False Required: False Unique: True Fields: Ascending Ascending PrimaryKey 1 Clustered: False DistinctCount: 0 Foreign: False Ignore Nulls: False Name: PrimaryKey Primary: True Required: True Unique: True Fields: Ascending User Permissions admin drgadmin Delete, Read Permissions, Set Permissions, Change Owner, Read Definition, Write Definition, Read Data, Insert Data, Update Data, drguser Group Permissions Admins Delete, Read Permissions, Set Permissions, Change Owner, Read Definition, Write Definition, Read Data, Insert Data, Update Data, DRGUsers Users Delete, Read Permissions, Set Permissions, Change Owner, Read D:\DRGWork\AccessProj\DRGNational4.0\CD\1.SpecificatiiTehnice\DRGNation Tuesday, December 21, 2004 al4.0.mdb Table: Pacient_DiagnosticeSecundare Page: 75 Definition, Write Definition, Read Data, Insert Data, Update Data, Delete Data D:\DRGWork\AccessProj\DRGNational4.0\CD\1.SpecificatiiTehnice\DRGNation Tuesday, December 21, 2004 al4.0.mdb Table: Pacient_Fisa Page: 76 Properties DatasheetFontHeight: 10 DatasheetFontItalic: False DatasheetFontName: Arial DatasheetFontUnderlin False DatasheetFontWeight: Normal DatasheetForeColor: 0 Date Created: 11/22/2004 12:44:18 PM GUID: Long binary data Last Updated: 12/21/2004 5:21:20 PM NameMap: Long binary data OrderByOn: False Orientation: 0 RecordCount: 0 TabularCharSet: 0 TabularFamily: 34 Updatable: True ValidationRule: Not [IdJudet] Is Null Or [IdLocalitate] Is Null Columns Name Type Size Caz_ID Text 52 AllowZeroLength: False Attributes: Variable Length Collating Order: 1048 ColumnHidden: False ColumnOrder: Default ColumnWidth: 690 Data Updatable: False DisplayControl: Text Box GUID: Long binary data Ordinal Position: 1 Required: True Source Field: Caz_ID Source Table: Pacient_Fisa UnicodeCompression: True IdAccident Byte 1 AllowZeroLength: False Attributes: Fixed Size Collating Order: 1048 ColumnHidden: False ColumnOrder: Default ColumnWidth: Default Data Updatable: False DecimalPlaces: 0 DisplayControl: Text Box GUID: Long binary data Ordinal Position: 2 Required: True Source Field: IdAccident Source Table: Pacient_Fisa Spital_ID Text 6 AllowZeroLength: False Attributes: Variable Length Collating Order: 1048 ColumnHidden: False ColumnOrder: Default ColumnWidth: 840 Data Updatable: False DisplayControl: Text Box GUID: Long binary data D:\DRGWork\AccessProj\DRGNational4.0\CD\1.SpecificatiiTehnice\DRGNation Tuesday, December 21, 2004 al4.0.mdb Table: Pacient_Fisa Page: 77 Ordinal Position: 3 Required: True Source Field: Spital_ID Source Table: Pacient_Fisa UnicodeCompression: True Sectie_ID Text 4 AllowZeroLength: False Attributes: Variable Length Collating Order: 1048 ColumnHidden: False ColumnOrder: Default ColumnWidth: 900 Data Updatable: False DisplayControl: Text Box GUID: Long binary data Ordinal Position: 4 Required: True Source Field: Sectie_ID Source Table: Pacient_Fisa UnicodeCompression: True NumarSectie Long Integer 4 AllowZeroLength: False Attributes: Fixed Size Collating Order: 1048 ColumnHidden: False ColumnOrder: Default ColumnWidth: 1200 Data Updatable: False DecimalPlaces: 0 DisplayControl: Text Box GUID: Long binary data Ordinal Position: 5 Required: True Source Field: NumarSectie Source Table: Pacient_Fisa NFO Long Integer 4 AllowZeroLength: False Attributes: Fixed Size Collating Order: 1048 ColumnHidden: False ColumnOrder: Default ColumnWidth: 465 Data Updatable: False DecimalPlaces: 0 DisplayControl: Text Box GUID: Long binary data Ordinal Position: 6 Required: True Source Field: NFO Source Table: Pacient_Fisa Nume Text 20 AllowZeroLength: False Attributes: Variable Length Collating Order: 1048 ColumnHidden: False ColumnOrder: Default ColumnWidth: 630 D:\DRGWork\AccessProj\DRGNational4.0\CD\1.SpecificatiiTehnice\DRGNation Tuesday, December 21, 2004 al4.0.mdb Table: Pacient_Fisa Page: 78 Data Updatable: False DisplayControl: Text Box GUID: Long binary data Ordinal Position: 7 Required: False Source Field: Nume Source Table: Pacient_Fisa UnicodeCompression: True Prenume Text 20 AllowZeroLength: False Attributes: Variable Length Collating Order: 1048 ColumnHidden: False ColumnOrder: Default ColumnWidth: 915 Data Updatable: False DisplayControl: Text Box GUID: Long binary data Ordinal Position: 8 Required: False Source Field: Prenume Source Table: Pacient_Fisa UnicodeCompression: True CNP Text 13 AllowZeroLength: False Attributes: Variable Length Collating Order: 1048 ColumnHidden: False ColumnOrder: Default ColumnWidth: 480 Data Updatable: False DisplayControl: Text Box GUID: Long binary data Ordinal Position: 9 Required: False Source Field: CNP Source Table: Pacient_Fisa UnicodeCompression: True IdJudet Byte 1 AllowZeroLength: False Attributes: Fixed Size Collating Order: 1048 ColumnHidden: False ColumnOrder: Default ColumnWidth: 765 Data Updatable: False DecimalPlaces: 0 DisplayControl: Text Box GUID: Long binary data Ordinal Position: 10 Required: False Source Field: IdJudet Source Table: Pacient_Fisa IdLocalitate Long Integer 4 AllowZeroLength: False Attributes: Fixed Size D:\DRGWork\AccessProj\DRGNational4.0\CD\1.SpecificatiiTehnice\DRGNation Tuesday, December 21, 2004 al4.0.mdb Table: Pacient_Fisa Page: 79 Collating Order: 1048 ColumnHidden: False ColumnOrder: Default ColumnWidth: 1095 Data Updatable: False DecimalPlaces: 0 DisplayControl: Text Box GUID: Long binary data Ordinal Position: 11 Required: False Source Field: IdLocalitate Source Table: Pacient_Fisa DataNastere Date/Time 8 AllowZeroLength: False Attributes: Fixed Size Collating Order: 1048 ColumnHidden: False ColumnOrder: Default ColumnWidth: 1140 Data Updatable: False Format: Short Date GUID: Long binary data Ordinal Position: 12 Required: True Source Field: DataNastere Source Table: Pacient_Fisa DataInternare Date/Time 8 AllowZeroLength: False Attributes: Fixed Size Collating Order: 1048 ColumnHidden: False ColumnOrder: Default ColumnWidth: 1260 Data Updatable: False Format: Short Date GUID: Long binary data Ordinal Position: 13 Required: True Source Field: DataInternare Source Table: Pacient_Fisa OraInternare Date/Time 8 AllowZeroLength: False Attributes: Fixed Size Collating Order: 1048 ColumnHidden: False ColumnOrder: Default ColumnWidth: 1515 Data Updatable: False Format: General Date GUID: Long binary data Ordinal Position: 14 Required: True Source Field: OraInternare Source Table: Pacient_Fisa DataExternare Date/Time 8 AllowZeroLength: False D:\DRGWork\AccessProj\DRGNational4.0\CD\1.SpecificatiiTehnice\DRGNation Tuesday, December 21, 2004 al4.0.mdb Table: Pacient_Fisa Page: 80 Attributes: Fixed Size Collating Order: 1048 ColumnHidden: False ColumnOrder: Default ColumnWidth: 1290 Data Updatable: False Format: Short Date GUID: Long binary data Ordinal Position: 15 Required: True Source Field: DataExternare Source Table: Pacient_Fisa OraExternare Date/Time 8 AllowZeroLength: False Attributes: Fixed Size Collating Order: 1048 ColumnHidden: False ColumnOrder: Default ColumnWidth: 1230 Data Updatable: False Format: General Date GUID: Long binary data Ordinal Position: 16 Required: True Source Field: OraExternare Source Table: Pacient_Fisa IdTipAsigurare Byte 1 AllowZeroLength: False Attributes: Fixed Size Collating Order: 1048 ColumnHidden: False ColumnOrder: Default ColumnWidth: 1380 Data Updatable: False DecimalPlaces: 0 DisplayControl: Text Box GUID: Long binary data Ordinal Position: 17 Required: True Source Field: IdTipAsigurare Source Table: Pacient_Fisa IdCAS Byte 1 AllowZeroLength: False Attributes: Fixed Size Collating Order: 1048 ColumnHidden: False ColumnOrder: Default ColumnWidth: 645 Data Updatable: False DecimalPlaces: 0 DisplayControl: Text Box GUID: Long binary data Ordinal Position: 18 Required: False Source Field: IdCAS Source Table: Pacient_Fisa D:\DRGWork\AccessProj\DRGNational4.0\CD\1.SpecificatiiTehnice\DRGNation Tuesday, December 21, 2004 al4.0.mdb Table: Pacient_Fisa Page: 81 IdJudetCAS Byte 1 AllowZeroLength: False Attributes: Fixed Size Collating Order: 1048 ColumnHidden: False ColumnOrder: Default ColumnWidth: 1110 Data Updatable: False DecimalPlaces: 0 DisplayControl: Text Box GUID: Long binary data Ordinal Position: 19 Required: False Source Field: IdJudetCAS Source Table: Pacient_Fisa Sex Yes/No 1 AllowZeroLength: False Attributes: Fixed Size Collating Order: 1048 ColumnHidden: False ColumnOrder: Default ColumnWidth: 450 Data Updatable: False DisplayControl: 106 Format: Yes/No GUID: Long binary data Ordinal Position: 20 Required: True Source Field: Sex Source Table: Pacient_Fisa GreutateNastere Integer 2 AllowZeroLength: False Attributes: Fixed Size Collating Order: 1048 ColumnHidden: False ColumnOrder: Default ColumnWidth: 1515 Data Updatable: False DecimalPlaces: Auto DisplayControl: Text Box GUID: Long binary data Ordinal Position: 21 Required: False Source Field: GreutateNastere Source Table: Pacient_Fisa IdTipInternare Byte 1 AllowZeroLength: False Attributes: Fixed Size Collating Order: 1048 ColumnHidden: False ColumnOrder: Default ColumnWidth: 1320 Data Updatable: False DecimalPlaces: 0 DisplayControl: Text Box GUID: Long binary data Ordinal Position: 22 Required: True D:\DRGWork\AccessProj\DRGNational4.0\CD\1.SpecificatiiTehnice\DRGNation Tuesday, December 21, 2004 al4.0.mdb Table: Pacient_Fisa Page: 82 Source Field: IdTipInternare Source Table: Pacient_Fisa IdTipExternare Byte 1 AllowZeroLength: False Attributes: Fixed Size Collating Order: 1048 ColumnHidden: False ColumnOrder: Default ColumnWidth: Default Data Updatable: False DecimalPlaces: 0 DisplayControl: Text Box GUID: Long binary data Ordinal Position: 23 Required: True Source Field: IdTipExternare Source Table: Pacient_Fisa IdStareExternare Byte 1 AllowZeroLength: False Attributes: Fixed Size Collating Order: 1048 ColumnHidden: False ColumnOrder: Default ColumnWidth: 1530 Data Updatable: False DecimalPlaces: 0 DisplayControl: Text Box GUID: Long binary data Ordinal Position: 24 Required: True Source Field: IdStareExternare Source Table: Pacient_Fisa CodMedic Text 7 AllowZeroLength: False Attributes: Variable Length Collating Order: 1048 ColumnHidden: False ColumnOrder: Default ColumnWidth: 975 Data Updatable: False DisplayControl: Text Box GUID: Long binary data Ordinal Position: 25 Required: True Source Field: CodMedic Source Table: Pacient_Fisa UnicodeCompression: True CodMedicOperator Text 7 AllowZeroLength: False Attributes: Variable Length Collating Order: 1048 ColumnHidden: False ColumnOrder: Default ColumnWidth: 1710 Data Updatable: False DisplayControl: Text Box D:\DRGWork\AccessProj\DRGNational4.0\CD\1.SpecificatiiTehnice\DRGNation Tuesday, December 21, 2004 al4.0.mdb Table: Pacient_Fisa Page: 83 GUID: Long binary data Ordinal Position: 26 Required: False Source Field: CodMedicOperator Source Table: Pacient_Fisa UnicodeCompression: True CodMedicMana2 Text 7 AllowZeroLength: False Attributes: Variable Length Collating Order: 1048 ColumnHidden: False ColumnOrder: Default ColumnWidth: 1500 Data Updatable: False DisplayControl: Text Box GUID: Long binary data Ordinal Position: 27 Required: False Source Field: CodMedicMana2 Source Table: Pacient_Fisa UnicodeCompression: True CodDiagnosticLaInternare Text 5 AllowZeroLength: False Attributes: Variable Length Collating Order: 1048 ColumnHidden: False ColumnOrder: Default ColumnWidth: 2295 Data Updatable: False DisplayControl: Text Box GUID: Long binary data Ordinal Position: 28 Required: False Source Field: CodDiagnosticLaInternare Source Table: Pacient_Fisa UnicodeCompression: True CodDiagnosticPrincipalCod1 Text 5 AllowZeroLength: False Attributes: Variable Length Collating Order: 1048 ColumnHidden: False ColumnOrder: Default ColumnWidth: 2460 Data Updatable: False DisplayControl: Text Box GUID: Long binary data Ordinal Position: 29 Required: True Source Field: CodDiagnosticPrincipalCod1 Source Table: Pacient_Fisa UnicodeCompression: True CodDiagnosticPrincipalCod2 Text 5 AllowZeroLength: False Attributes: Variable Length Collating Order: 1048 ColumnHidden: False D:\DRGWork\AccessProj\DRGNational4.0\CD\1.SpecificatiiTehnice\DRGNation Tuesday, December 21, 2004 al4.0.mdb Table: Pacient_Fisa Page: 84 ColumnOrder: Default ColumnWidth: 2460 Data Updatable: False DisplayControl: Text Box GUID: Long binary data Ordinal Position: 30 Required: False Source Field: CodDiagnosticPrincipalCod2 Source Table: Pacient_Fisa UnicodeCompression: True CodInterventieChirurgicala Text 8 AllowZeroLength: False Attributes: Variable Length Collating Order: 1048 ColumnHidden: False ColumnOrder: Default ColumnWidth: 2370 Data Updatable: False DisplayControl: Text Box GUID: Long binary data Ordinal Position: 31 Required: False Source Field: CodInterventieChirurgicala Source Table: Pacient_Fisa UnicodeCompression: True DataInterventieChirurgicalaPrincipala Date/Time 8 AllowZeroLength: False Attributes: Fixed Size Collating Order: 1048 ColumnHidden: False ColumnOrder: Default ColumnWidth: 3180 Data Updatable: False Format: Short Date GUID: Long binary data Ordinal Position: 32 Required: False Source Field: DataInterventieChirurgicalaPrincipala Source Table: Pacient_Fisa IdStareRecord Byte 1 AllowZeroLength: False Attributes: Fixed Size Collating Order: 1048 ColumnHidden: False ColumnOrder: Default ColumnWidth: 1320 Data Updatable: False DecimalPlaces: 0 DisplayControl: Text Box GUID: Long binary data Ordinal Position: 33 Required: True Source Field: IdStareRecord Source Table: Pacient_Fisa Flag_SelectieExport Yes/No 1 AllowZeroLength: False D:\DRGWork\AccessProj\DRGNational4.0\CD\1.SpecificatiiTehnice\DRGNation Tuesday, December 21, 2004 al4.0.mdb Table: Pacient_Fisa Page: 85 Attributes: Fixed Size Collating Order: 1048 ColumnHidden: False ColumnOrder: Default ColumnWidth: 1755 Data Updatable: False DisplayControl: 106 Format: Yes/No GUID: Long binary data Ordinal Position: 34 Required: False Source Field: Flag_SelectieExport Source Table: Pacient_Fisa Flag_Finalizat Yes/No 1 AllowZeroLength: False Attributes: Fixed Size Collating Order: 1048 ColumnHidden: False ColumnOrder: Default ColumnWidth: 1230 Data Updatable: False DisplayControl: 106 Format: Yes/No GUID: Long binary data Ordinal Position: 35 Required: False Source Field: Flag_Finalizat Source Table: Pacient_Fisa StareValidare Long Integer 4 AllowZeroLength: False Attributes: Fixed Size BoundColumn: 1 Collating Order: 1048 ColumnCount: 1 ColumnHeads: False ColumnHidden: False ColumnOrder: Default ColumnWidth: 1260 Data Updatable: False DecimalPlaces: 0 DisplayControl: Text Box GUID: Long binary data LimitToList: False ListRows: 8 ListWidth: 0twip Ordinal Position: 36 Required: False RowSource: IIf(IsNull([StareValidare])=False;NumeStareValidare([StareVali dare]);Null) RowSourceType: Table/Query Source Field: StareValidare Source Table: Pacient_Fisa Utilizator Text 50 AllowZeroLength: False Attributes: Variable Length Collating Order: 1048 D:\DRGWork\AccessProj\DRGNational4.0\CD\1.SpecificatiiTehnice\DRGNation Tuesday, December 21, 2004 al4.0.mdb Table: Pacient_Fisa Page: 86 ColumnHidden: False ColumnOrder: Default ColumnWidth: Default Data Updatable: False DisplayControl: Text Box GUID: Long binary data Ordinal Position: 37 Required: True Source Field: Utilizator Source Table: Pacient_Fisa UnicodeCompression: True DataOperare Date/Time 8 AllowZeroLength: False Attributes: Fixed Size Collating Order: 1048 ColumnHidden: False ColumnOrder: Default ColumnWidth: Default Data Updatable: False Format: General Date GUID: Long binary data Ordinal Position: 38 Required: True Source Field: DataOperare Source Table: Pacient_Fisa Data_Trimitere Date/Time 8 AllowZeroLength: False Attributes: Fixed Size Collating Order: 1048 ColumnHidden: False ColumnOrder: Default ColumnWidth: Default Data Updatable: False Format: Short Date GUID: Long binary data Ordinal Position: 39 Required: False Source Field: Data_Trimitere Source Table: Pacient_Fisa Data_Import Date/Time 8 AllowZeroLength: False Attributes: Fixed Size Collating Order: 1048 ColumnHidden: False ColumnOrder: Default ColumnWidth: Default Data Updatable: False Format: Short Date GUID: Long binary data Ordinal Position: 40 Required: False Source Field: Data_Import Source Table: Pacient_Fisa Relationships D:\DRGWork\AccessProj\DRGNational4.0\CD\1.SpecificatiiTehnice\DRGNation Tuesday, December 21, 2004 al4.0.mdb Table: Pacient_Fisa Page: 87 Lista_TipInternarePacient_Fisa Lista_TipInternare Pacient_Fisa IdTipInternare 1 IdTipInternare Attributes: Enforced RelationshipType: One-To-Many Lista_Spitale___FiltratPacient_Fisa Lista_Spitale___Filtrat Pacient_Fisa Spital_ID 1 Spital_ID Attributes: Enforced RelationshipType: One-To-Many Lista_Diagnostice___Cod1Cod2Pacient_Fisa Lista_Diagnostice___Cod1 Pacient_Fisa 1 CodDiagnostic1 CodDiagnosticPrincipalCo 1 CodDiagnostic2 CodDiagnosticPrincipalCo Attributes: Enforced RelationshipType: One-To-Many Lista_TipAsigurarePacient_Fisa Lista_TipAsigurare Pacient_Fisa 1 IdTipAsigurare IdTipAsigurare Attributes: Enforced RelationshipType: One-To-Many Lista_TipExternarePacient_Fisa Lista_TipExternare Pacient_Fisa IdTipExternare 1 IdTipExternare Attributes: Enforced RelationshipType: One-To-Many D:\DRGWork\AccessProj\DRGNational4.0\CD\1.SpecificatiiTehnice\DRGNation Tuesday, December 21, 2004 al4.0.mdb Table: Pacient_Fisa Page: 88 Lista_CASPacient_Fisa Lista_CAS Pacient_Fisa IdCAS 1 IdCAS Attributes: Enforced RelationshipType: One-To-Many Lista_JudetePacient_Fisa Lista_Judete Pacient_Fisa IdJudet 1 IdJudetCAS Attributes: Enforced RelationshipType: One-To-Many Lista_ProceduriPacient_Fisa Lista_Proceduri Pacient_Fisa 1 CodProcedura CodInterventieChirurgica Attributes: Enforced RelationshipType: One-To-Many Pacient_FisaPacient_Proceduri Pacient_Fisa Pacient_Proceduri 1 Caz_ID Caz_ID Attributes: Enforced RelationshipType: One-To-Many Lista_StareExternarePacient_Fisa Lista_StareExternare Pacient_Fisa IdStareExternare 1 IdStareExternare Attributes: Enforced RelationshipType: One-To-Many D:\DRGWork\AccessProj\DRGNational4.0\CD\1.SpecificatiiTehnice\DRGNation Tuesday, December 21, 2004 al4.0.mdb Table: Pacient_Fisa Page: 89 Lista_LocalitatiPacient_Fisa Lista_Localitati Pacient_Fisa IdJudet 1 IdJudet IdLocalitate 1 IdLocalitate Attributes: Enforced RelationshipType: One-To-Many Pacient_FisaPacient_DiagnosticeSecundare Pacient_Fisa Pacient_DiagnosticeSecun Caz_ID 1 Caz_ID Attributes: Enforced RelationshipType: One-To-Many Lista_DiagnosticePacient_Fisa Lista_Diagnostice Pacient_Fisa 1 CodDiagnostic CodDiagnosticLaInternare Attributes: Enforced RelationshipType: One-To-Many Lista_Sectii___FiltratPacient_Fisa Lista_Sectii___Filtrat Pacient_Fisa 1 Spital_ID Spital_ID 1 Sectie_ID Sectie_ID 1 NumarSectie NumarSectie Attributes: Enforced RelationshipType: One-To-Many Lista_StareRecordPacient_Fisa Lista_StareRecord Pacient_Fisa IdStareRecord 1 IdStareRecord Attributes: Enforced RelationshipType: One-To-Many D:\DRGWork\AccessProj\DRGNational4.0\CD\1.SpecificatiiTehnice\DRGNation Tuesday, December 21, 2004 al4.0.mdb Table: Pacient_Fisa Page: 90 Lista_AccidentePacient_Fisa Lista_Accidente Pacient_Fisa IdAccident 1 IdAccident Attributes: Enforced RelationshipType: One-To-Many Lista_MediciPacient_Fisa Lista_Medici Pacient_Fisa Spital_ID Spital_ID CodMedic CodMedicOperator Attributes: Not Enforced, Right Join RelationshipType: One-To-Many Lista_MediciPacient_Fisa Lista_Medici Pacient_Fisa Spital_ID Spital_ID CodMedic CodMedicMana2 Attributes: Not Enforced, Left Join RelationshipType: One-To-Many Lista_MediciPacient_Fisa Lista_Medici Pacient_Fisa 1 Spital_ID Spital_ID 1 CodMedic CodMedic Attributes: Enforced, Left Join RelationshipType: One-To-Many Pacient_FisaPacient_Grouper Pacient_Fisa Pacient_Grouper Caz_ID 1 1 Caz_ID Attributes: Unique, Enforced RelationshipType: One-To-One D:\DRGWork\AccessProj\DRGNational4.0\CD\1.SpecificatiiTehnice\DRGNation Tuesday, December 21, 2004 al4.0.mdb Table: Pacient_Fisa Page: 91 Pacient_FisaPacient_Sectii Pacient_Fisa Pacient_Sectii Caz_ID 1 Caz_ID Attributes: Enforced RelationshipType: One-To-Many Table Indexes Name Number of Fields {092C05F2-08C3-4F87-8BC8-036BC006FCFD} 1 Clustered: False DistinctCount: 0 Foreign: True Ignore Nulls: False Name: {092C05F2-08C3-4F87-8BC8-036BC006FCFD} Primary: False Required: False Unique: False Fields: Ascending {1D637F22-FC9F-4702-BA1E-7D84858D3419} 1 Clustered: False DistinctCount: 0 Foreign: True Ignore Nulls: False Name: {1D637F22-FC9F-4702-BA1E-7D84858D3419} Primary: False Required: False Unique: False Fields: Ascending {3F902627-9E2C-4898-BF46-F99C2C8C0616} 2 Clustered: False DistinctCount: 0 Foreign: True Ignore Nulls: False Name: {3F902627-9E2C-4898-BF46-F99C2C8C0616} Primary: False Required: False Unique: False Fields: Ascending Ascending {41C18A90-738B-4F65-915D-7708809A0F25} 1 Clustered: False DistinctCount: 0 Foreign: True Ignore Nulls: False Name: {41C18A90-738B-4F65-915D-7708809A0F25} Primary: False Required: False Unique: False Fields: Ascending {6B24F0C9-B0BA-400B-B102-32E076D7F846} 1 Clustered: False DistinctCount: 0 Foreign: True D:\DRGWork\AccessProj\DRGNational4.0\CD\1.SpecificatiiTehnice\DRGNation Tuesday, December 21, 2004 al4.0.mdb Table: Pacient_Fisa Page: 92 Ignore Nulls: False Name: {6B24F0C9-B0BA-400B-B102-32E076D7F846} Primary: False Required: False Unique: False Fields: Ascending {7B183129-27E4-4B2F-AAC1-DD3324CC2315} 1 Clustered: False DistinctCount: 0 Foreign: True Ignore Nulls: False Name: {7B183129-27E4-4B2F-AAC1-DD3324CC2315} Primary: False Required: False Unique: False Fields: Ascending {882803FA-4823-4C6A-8374-9A6D61FC695E} 1 Clustered: False DistinctCount: 0 Foreign: True Ignore Nulls: False Name: {882803FA-4823-4C6A-8374-9A6D61FC695E} Primary: False Required: False Unique: False Fields: Ascending {88B1E593-6FAB-484A-9A89-CFB64881D6E1} 1 Clustered: False DistinctCount: 0 Foreign: True Ignore Nulls: False Name: {88B1E593-6FAB-484A-9A89-CFB64881D6E1} Primary: False Required: False Unique: False Fields: Ascending {B45F5915-2B95-46F3-8B47-CED6A958B9E7} 1 Clustered: False DistinctCount: 0 Foreign: True Ignore Nulls: False Name: {B45F5915-2B95-46F3-8B47-CED6A958B9E7} Primary: False Required: False Unique: False Fields: Ascending {B78417C4-6F3A-4D32-859E-743EB89434FF} 2 Clustered: False DistinctCount: 0 Foreign: True Ignore Nulls: False Name: {B78417C4-6F3A-4D32-859E-743EB89434FF} Primary: False Required: False Unique: False D:\DRGWork\AccessProj\DRGNational4.0\CD\1.SpecificatiiTehnice\DRGNation Tuesday, December 21, 2004 al4.0.mdb Table: Pacient_Fisa Page: 93 Fields: Ascending Ascending {CB809322-1AF7-4FC1-95CD-B0973DD80F78} 1 Clustered: False DistinctCount: 0 Foreign: True Ignore Nulls: False Name: {CB809322-1AF7-4FC1-95CD-B0973DD80F78} Primary: False Required: False Unique: False Fields: Ascending {DB31E697-59D5-4DBF-B7A4-E2AF8F48D39C} 3 Clustered: False DistinctCount: 0 Foreign: True Ignore Nulls: False Name: {DB31E697-59D5-4DBF-B7A4-E2AF8F48D39C} Primary: False Required: False Unique: False Fields: Ascending Ascending Ascending {F8304678-AA8C-4757-8AF6-4EE2DFA81AA9} 1 Clustered: False DistinctCount: 0 Foreign: True Ignore Nulls: False Name: {F8304678-AA8C-4757-8AF6-4EE2DFA81AA9} Primary: False Required: False Unique: False Fields: Ascending CU_Foaie 5 Clustered: False DistinctCount: 0 Foreign: False Ignore Nulls: False Name: CU_Foaie Primary: False Required: False Unique: True Fields: Ascending Ascending Ascending Ascending Ascending ix_IdJudetIdLocalitate 2 Clustered: False DistinctCount: 0 Foreign: False Ignore Nulls: False Name: ix_IdJudetIdLocalitate Primary: False Required: False Unique: False D:\DRGWork\AccessProj\DRGNational4.0\CD\1.SpecificatiiTehnice\DRGNation Tuesday, December 21, 2004 al4.0.mdb Table: Pacient_Fisa Page: 94 Fields: Ascending Ascending ix_SpitalIDSectieIDNumarSectie 3 Clustered: False DistinctCount: 0 Foreign: False Ignore Nulls: False Name: ix_SpitalIDSectieIDNumarSectie Primary: False Required: False Unique: False Fields: Ascending Ascending Ascending Lista_AccidentePacient_Fisa 1 Clustered: False DistinctCount: 0 Foreign: True Ignore Nulls: False Name: Lista_AccidentePacient_Fisa Primary: False Required: False Unique: False Fields: Ascending Lista_MediciPacient_Fisa2 2 Clustered: False DistinctCount: 0 Foreign: True Ignore Nulls: False Name: Lista_MediciPacient_Fisa2 Primary: False Required: False Unique: False Fields: Ascending Ascending PrimaryKey 1 Clustered: False DistinctCount: 0 Foreign: False Ignore Nulls: False Name: PrimaryKey Primary: True Required: True Unique: True Fields: Ascending User Permissions admin drgadmin Delete, Read Permissions, Set Permissions, Change Owner, Read Definition, Write Definition, Read Data, Insert Data, Update Data, drguser D:\DRGWork\AccessProj\DRGNational4.0\CD\1.SpecificatiiTehnice\DRGNation Tuesday, December 21, 2004 al4.0.mdb Table: Pacient_Fisa Page: 95 Group Permissions Admins Delete, Read Permissions, Set Permissions, Change Owner, Read Definition, Write Definition, Read Data, Insert Data, Update Data, DRGUsers Users Delete, Read Permissions, Set Permissions, Change Owner, Read Definition, Write Definition, Read Data, Insert Data, Update Data, D:\DRGWork\AccessProj\DRGNational4.0\CD\1.SpecificatiiTehnice\DRGNation Tuesday, December 21, 2004 al4.0.mdb Table: Pacient_Grouper Page: 96 Properties Date Created: 12/21/2004 5:15:19 PM GUID: Long binary data Last Updated: 12/21/2004 5:18:28 PM NameMap: Long binary data OrderByOn: False Orientation: 0 RecordCount: 0 Updatable: True Columns Name Type Size Caz_ID Text 52 AllowZeroLength: False Attributes: Variable Length Collating Order: 1048 ColumnHidden: False ColumnOrder: Default ColumnWidth: Default Data Updatable: False DisplayControl: Text Box GUID: Long binary data Ordinal Position: 0 Required: True Source Field: Caz_ID Source Table: Pacient_Grouper UnicodeCompression: True CodDRG Text 6 AllowZeroLength: False Attributes: Variable Length Collating Order: 1048 ColumnHidden: False ColumnOrder: Default ColumnWidth: Default Data Updatable: False DisplayControl: Text Box GUID: Long binary data Ordinal Position: 1 Required: False Source Field: CodDRG Source Table: Pacient_Grouper UnicodeCompression: True DRG_VR : Delete Query 16 AllowZeroLength: False Attributes: Variable Length Collating Order: 18 ColumnHidden: False ColumnOrder: Default ColumnWidth: Default Data Updatable: False DecimalPlaces: Auto DisplayControl: Text Box GUID: Long binary data Ordinal Position: 2 Required: False Source Field: DRG_VR Source Table: Pacient_Grouper Tarif Long Integer 4 D:\DRGWork\AccessProj\DRGNational4.0\CD\1.SpecificatiiTehnice\DRGNation Tuesday, December 21, 2004 al4.0.mdb Table: Pacient_Grouper Page: 97 AllowZeroLength: False Attributes: Fixed Size Collating Order: 18 ColumnHidden: False ColumnOrder: Default ColumnWidth: Default Data Updatable: False DecimalPlaces: 0 DisplayControl: Text Box GUID: Long binary data Ordinal Position: 3 Required: False Source Field: Tarif Source Table: Pacient_Grouper Validitate_DRG_COD Byte 1 AllowZeroLength: False Attributes: Fixed Size Collating Order: 18 ColumnHidden: False ColumnOrder: Default ColumnWidth: Default Data Updatable: False DecimalPlaces: 0 DisplayControl: Text Box GUID: Long binary data Ordinal Position: 4 Required: False Source Field: Validitate_DRG_COD Source Table: Pacient_Grouper Validitate_IntPrinc Text 8 AllowZeroLength: False Attributes: Variable Length Collating Order: 1048 ColumnHidden: False ColumnOrder: Default ColumnWidth: Default Data Updatable: False DisplayControl: Text Box GUID: Long binary data Ordinal Position: 5 Required: False Source Field: Validitate_IntPrinc Source Table: Pacient_Grouper UnicodeCompression: True Validitate_DiagPrinc_Cod1 Text 8 AllowZeroLength: False Attributes: Variable Length Collating Order: 1048 ColumnHidden: False ColumnOrder: Default ColumnWidth: Default Data Updatable: False DisplayControl: Text Box GUID: Long binary data Ordinal Position: 6 Required: False Source Field: Validitate_DiagPrinc_Cod1 D:\DRGWork\AccessProj\DRGNational4.0\CD\1.SpecificatiiTehnice\DRGNation Tuesday, December 21, 2004 al4.0.mdb Table: Pacient_Grouper Page: 98 Source Table: Pacient_Grouper UnicodeCompression: True Validitate_DiagPrinc_Cod2 Text 8 AllowZeroLength: False Attributes: Variable Length Collating Order: 1048 ColumnHidden: False ColumnOrder: Default ColumnWidth: Default Data Updatable: False DisplayControl: Text Box GUID: Long binary data Ordinal Position: 7 Required: False Source Field: Validitate_DiagPrinc_Cod2 Source Table: Pacient_Grouper UnicodeCompression: True fRC1 Yes/No 1 AllowZeroLength: False Attributes: Fixed Size Caption: RC1 Collating Order: 18 ColumnHidden: False ColumnOrder: Default ColumnWidth: Default Data Updatable: False DisplayControl: 106 Format: Yes/No GUID: Long binary data Ordinal Position: 8 Required: False Source Field: fRC1 Source Table: Pacient_Grouper fRC2 Yes/No 1 AllowZeroLength: False Attributes: Fixed Size Caption: RC2 Collating Order: 18 ColumnHidden: False ColumnOrder: Default ColumnWidth: Default Data Updatable: False DisplayControl: 106 Format: Yes/No GUID: Long binary data Ordinal Position: 9 Required: False Source Field: fRC2 Source Table: Pacient_Grouper fRC3 Yes/No 1 AllowZeroLength: False Attributes: Fixed Size Caption: RC3 Collating Order: 18 ColumnHidden: False ColumnOrder: Default D:\DRGWork\AccessProj\DRGNational4.0\CD\1.SpecificatiiTehnice\DRGNation Tuesday, December 21, 2004 al4.0.mdb Table: Pacient_Grouper Page: 99 ColumnWidth: Default Data Updatable: False DisplayControl: 106 Format: Yes/No GUID: Long binary data Ordinal Position: 10 Required: False Source Field: fRC3 Source Table: Pacient_Grouper fRC4_D Yes/No 1 AllowZeroLength: False Attributes: Fixed Size Caption: RC4_D Collating Order: 18 ColumnHidden: False ColumnOrder: Default ColumnWidth: Default Data Updatable: False DisplayControl: 106 Format: Yes/No GUID: Long binary data Ordinal Position: 11 Required: False Source Field: fRC4_D Source Table: Pacient_Grouper fRC4_S Yes/No 1 AllowZeroLength: False Attributes: Fixed Size Caption: RC4_S Collating Order: 18 ColumnHidden: False ColumnOrder: Default ColumnWidth: Default Data Updatable: False DisplayControl: 106 Format: Yes/No GUID: Long binary data Ordinal Position: 12 Required: False Source Field: fRC4_S Source Table: Pacient_Grouper fRC5 Yes/No 1 AllowZeroLength: False Attributes: Fixed Size Caption: RC5 Collating Order: 18 ColumnHidden: False ColumnOrder: Default ColumnWidth: Default Data Updatable: False DisplayControl: 106 Format: Yes/No GUID: Long binary data Ordinal Position: 13 Required: False Source Field: fRC5 Source Table: Pacient_Grouper D:\DRGWork\AccessProj\DRGNational4.0\CD\1.SpecificatiiTehnice\DRGNation Tuesday, December 21, 2004 al4.0.mdb Table: Pacient_Grouper Page: 100 fRC6 Yes/No 1 AllowZeroLength: False Attributes: Fixed Size Caption: RC6 Collating Order: 18 ColumnHidden: False ColumnOrder: Default ColumnWidth: Default Data Updatable: False DisplayControl: 106 Format: Yes/No GUID: Long binary data Ordinal Position: 14 Required: False Source Field: fRC6 Source Table: Pacient_Grouper fRC7 Yes/No 1 AllowZeroLength: False Attributes: Fixed Size Caption: RC7 Collating Order: 18 ColumnHidden: False ColumnOrder: Default ColumnWidth: Default Data Updatable: False DisplayControl: 106 Format: Yes/No GUID: Long binary data Ordinal Position: 15 Required: False Source Field: fRC7 Source Table: Pacient_Grouper fRC8 Yes/No 1 AllowZeroLength: False Attributes: Fixed Size Caption: RC8 Collating Order: 18 ColumnHidden: False ColumnOrder: Default ColumnWidth: Default Data Updatable: False DisplayControl: 106 Format: Yes/No GUID: Long binary data Ordinal Position: 16 Required: False Source Field: fRC8 Source Table: Pacient_Grouper fRC9 Yes/No 1 AllowZeroLength: False Attributes: Fixed Size Caption: RC9 Collating Order: 18 ColumnHidden: False ColumnOrder: Default ColumnWidth: Default D:\DRGWork\AccessProj\DRGNational4.0\CD\1.SpecificatiiTehnice\DRGNation Tuesday, December 21, 2004 al4.0.mdb Table: Pacient_Grouper Page: 101 Data Updatable: False DisplayControl: 106 Format: Yes/No GUID: Long binary data Ordinal Position: 17 Required: False Source Field: fRC9 Source Table: Pacient_Grouper fRC10 Yes/No 1 AllowZeroLength: False Attributes: Fixed Size Caption: RC10 Collating Order: 18 ColumnHidden: False ColumnOrder: Default ColumnWidth: Default Data Updatable: False DisplayControl: 106 Format: Yes/No GUID: Long binary data Ordinal Position: 18 Required: False Source Field: fRC10 Source Table: Pacient_Grouper fRC11 Yes/No 1 AllowZeroLength: False Attributes: Fixed Size Caption: RC11 Collating Order: 18 ColumnHidden: False ColumnOrder: Default ColumnWidth: Default Data Updatable: False DisplayControl: 106 Format: Yes/No GUID: Long binary data Ordinal Position: 19 Required: False Source Field: fRC11 Source Table: Pacient_Grouper fRC12 Yes/No 1 AllowZeroLength: False Attributes: Fixed Size Caption: RC12 Collating Order: 18 ColumnHidden: False ColumnOrder: Default ColumnWidth: Default Data Updatable: False DisplayControl: 106 Format: Yes/No GUID: Long binary data Ordinal Position: 20 Required: False Source Field: fRC12 Source Table: Pacient_Grouper D:\DRGWork\AccessProj\DRGNational4.0\CD\1.SpecificatiiTehnice\DRGNation Tuesday, December 21, 2004 al4.0.mdb Table: Pacient_Grouper Page: 102 fRC13 Yes/No 1 AllowZeroLength: False Attributes: Fixed Size Caption: RC13 Collating Order: 18 ColumnHidden: False ColumnOrder: Default ColumnWidth: Default Data Updatable: False DisplayControl: 106 Format: Yes/No GUID: Long binary data Ordinal Position: 21 Required: False Source Field: fRC13 Source Table: Pacient_Grouper fRC14 Yes/No 1 AllowZeroLength: False Attributes: Fixed Size Caption: RC14 Collating Order: 18 ColumnHidden: False ColumnOrder: Default ColumnWidth: Default Data Updatable: False DisplayControl: 106 Format: Yes/No GUID: Long binary data Ordinal Position: 22 Required: False Source Field: fRC14 Source Table: Pacient_Grouper fRC15 Yes/No 1 AllowZeroLength: False Attributes: Fixed Size Caption: RC15 Collating Order: 18 ColumnHidden: False ColumnOrder: Default ColumnWidth: Default Data Updatable: False DisplayControl: 106 Format: Yes/No GUID: Long binary data Ordinal Position: 23 Required: False Source Field: fRC15 Source Table: Pacient_Grouper fRF2 Yes/No 1 AllowZeroLength: False Attributes: Fixed Size Caption: RF2 Collating Order: 18 ColumnHidden: False ColumnOrder: Default ColumnWidth: Default Data Updatable: False DisplayControl: 106 D:\DRGWork\AccessProj\DRGNational4.0\CD\1.SpecificatiiTehnice\DRGNation Tuesday, December 21, 2004 al4.0.mdb Table: Pacient_Grouper Page: 103 Format: Yes/No GUID: Long binary data Ordinal Position: 24 Required: False Source Field: fRF2 Source Table: Pacient_Grouper fRF3 Yes/No 1 AllowZeroLength: False Attributes: Fixed Size Caption: RF3 Collating Order: 18 ColumnHidden: False ColumnOrder: Default ColumnWidth: Default Data Updatable: False DisplayControl: 106 Format: Yes/No GUID: Long binary data Ordinal Position: 25 Required: False Source Field: fRF3 Source Table: Pacient_Grouper fRF4 Yes/No 1 AllowZeroLength: False Attributes: Fixed Size Caption: RF4 Collating Order: 18 ColumnHidden: False ColumnOrder: Default ColumnWidth: Default Data Updatable: False DisplayControl: 106 Format: Yes/No GUID: Long binary data Ordinal Position: 26 Required: False Source Field: fRF4 Source Table: Pacient_Grouper fRF5 Yes/No 1 AllowZeroLength: False Attributes: Fixed Size Caption: RF5 Collating Order: 18 ColumnHidden: False ColumnOrder: Default ColumnWidth: Default Data Updatable: False DisplayControl: 106 Format: Yes/No GUID: Long binary data Ordinal Position: 27 Required: False Source Field: fRF5 Source Table: Pacient_Grouper fRF6 Yes/No 1 AllowZeroLength: False D:\DRGWork\AccessProj\DRGNational4.0\CD\1.SpecificatiiTehnice\DRGNation Tuesday, December 21, 2004 al4.0.mdb Table: Pacient_Grouper Page: 104 Attributes: Fixed Size Caption: RF6 Collating Order: 18 ColumnHidden: False ColumnOrder: Default ColumnWidth: Default Data Updatable: False DisplayControl: 106 Format: Yes/No GUID: Long binary data Ordinal Position: 28 Required: False Source Field: fRF6 Source Table: Pacient_Grouper fRF7 Yes/No 1 AllowZeroLength: False Attributes: Fixed Size Caption: RF7 Collating Order: 18 ColumnHidden: False ColumnOrder: Default ColumnWidth: Default Data Updatable: False DisplayControl: 106 Format: Yes/No GUID: Long binary data Ordinal Position: 29 Required: False Source Field: fRF7 Source Table: Pacient_Grouper fRF8 Yes/No 1 AllowZeroLength: False Attributes: Fixed Size Caption: RF8 Collating Order: 18 ColumnHidden: False ColumnOrder: Default ColumnWidth: Default Data Updatable: False DisplayControl: 106 Format: Yes/No GUID: Long binary data Ordinal Position: 30 Required: False Source Field: fRF8 Source Table: Pacient_Grouper fRF9 Yes/No 1 AllowZeroLength: False Attributes: Fixed Size Caption: RF9 Collating Order: 18 ColumnHidden: False ColumnOrder: Default ColumnWidth: Default Data Updatable: False DisplayControl: 106 Format: Yes/No D:\DRGWork\AccessProj\DRGNational4.0\CD\1.SpecificatiiTehnice\DRGNation Tuesday, December 21, 2004 al4.0.mdb Table: Pacient_Grouper Page: 105 GUID: Long binary data Ordinal Position: 31 Required: False Source Field: fRF9 Source Table: Pacient_Grouper fRF10 Yes/No 1 AllowZeroLength: False Attributes: Fixed Size Caption: RF10 Collating Order: 18 ColumnHidden: False ColumnOrder: Default ColumnWidth: Default Data Updatable: False DisplayControl: 106 Format: Yes/No GUID: Long binary data Ordinal Position: 32 Required: False Source Field: fRF10 Source Table: Pacient_Grouper Transfer_Reinternare Text 50 AllowZeroLength: False Attributes: Variable Length Collating Order: 1048 ColumnHidden: False ColumnOrder: Default ColumnWidth: Default Data Updatable: False DisplayControl: Text Box GUID: Long binary data Ordinal Position: 33 Required: False Source Field: Transfer_Reinternare Source Table: Pacient_Grouper UnicodeCompression: True NrZileReinternare Integer 2 AllowZeroLength: False Attributes: Fixed Size Collating Order: 18 ColumnHidden: False ColumnOrder: Default ColumnWidth: Default Data Updatable: False DecimalPlaces: 0 DisplayControl: Text Box GUID: Long binary data Ordinal Position: 34 Required: False Source Field: NrZileReinternare Source Table: Pacient_Grouper Relationships D:\DRGWork\AccessProj\DRGNational4.0\CD\1.SpecificatiiTehnice\DRGNation Tuesday, December 21, 2004 al4.0.mdb Table: Pacient_Grouper Page: 106 Lista_CoduriDRGPacient_Grouper Lista_CoduriDRG Pacient_Grouper CodDRG 1 CodDRG Attributes: Enforced RelationshipType: One-To-Many Pacient_FisaPacient_Grouper Pacient_Fisa Pacient_Grouper Caz_ID 1 1 Caz_ID Attributes: Unique, Enforced RelationshipType: One-To-One Table Indexes Name Number of Fields CodDRG 1 Clustered: False DistinctCount: 0 Foreign: False Ignore Nulls: False Name: CodDRG Primary: False Required: False Unique: False Fields: Ascending Lista_CoduriDRGPacient_Grouper 1 Clustered: False DistinctCount: 0 Foreign: True Ignore Nulls: False Name: Lista_CoduriDRGPacient_Grouper Primary: False Required: False Unique: False Fields: Ascending Pacient_FisaPacient_Grouper 1 Clustered: False DistinctCount: 0 Foreign: True Ignore Nulls: False Name: Pacient_FisaPacient_Grouper Primary: False Required: False Unique: True Fields: Ascending PrimaryKey 1 Clustered: False DistinctCount: 0 Foreign: False Ignore Nulls: False D:\DRGWork\AccessProj\DRGNational4.0\CD\1.SpecificatiiTehnice\DRGNation Tuesday, December 21, 2004 al4.0.mdb Table: Pacient_Grouper Page: 107 Name: PrimaryKey Primary: True Required: True Unique: True Fields: Ascending User Permissions admin drgadmin Delete, Read Permissions, Set Permissions, Change Owner, Read Definition, Write Definition, Read Data, Insert Data, Update Data, drguser Group Permissions Admins Delete, Read Permissions, Set Permissions, Change Owner, Read Definition, Write Definition, Read Data, Insert Data, Update Data, DRGUsers Users Delete, Read Permissions, Set Permissions, Change Owner, Read Definition, Write Definition, Read Data, Insert Data, Update Data, D:\DRGWork\AccessProj\DRGNational4.0\CD\1.SpecificatiiTehnice\DRGNation Tuesday, December 21, 2004 al4.0.mdb Table: Pacient_Proceduri Page: 108 Properties DatasheetFontHeight: 10 DatasheetFontItalic: False DatasheetFontName: Arial DatasheetFontUnderlin False DatasheetFontWeight: Normal DatasheetForeColor: 0 Date Created: 11/22/2004 12:44:18 PM GUID: Long binary data Last Updated: 12/15/2004 1:30:53 PM NameMap: Long binary data OrderByOn: False Orientation: 0 RecordCount: 0 TabularCharSet: 0 TabularFamily: 34 Updatable: True Columns Name Type Size IdPacientProcedura Long Integer 4 AllowZeroLength: False Attributes: Fixed Size, Auto-Increment Collating Order: 1048 ColumnHidden: False ColumnOrder: Default ColumnWidth: Default Data Updatable: False GUID: Long binary data Ordinal Position: 0 Required: False Source Field: IdPacientProcedura Source Table: Pacient_Proceduri Caz_ID Text 52 AllowZeroLength: False Attributes: Variable Length Collating Order: 1048 ColumnHidden: False ColumnOrder: Default ColumnWidth: 690 Data Updatable: False DisplayControl: Text Box GUID: Long binary data Ordinal Position: 1 Required: True Source Field: Caz_ID Source Table: Pacient_Proceduri UnicodeCompression: True CodProcedura Text 8 AllowZeroLength: False Attributes: Variable Length Collating Order: 1048 ColumnHidden: False ColumnOrder: Default ColumnWidth: 1335 Data Updatable: False DisplayControl: Text Box GUID: Long binary data Ordinal Position: 2 Required: True Source Field: CodProcedura Source Table: Pacient_Proceduri D:\DRGWork\AccessProj\DRGNational4.0\CD\1.SpecificatiiTehnice\DRGNation Tuesday, December 21, 2004 al4.0.mdb Table: Pacient_Proceduri Page: 109 UnicodeCompression: True Cantitate Byte 1 AllowZeroLength: False Attributes: Fixed Size Collating Order: 1048 ColumnHidden: False ColumnOrder: Default ColumnWidth: 885 Data Updatable: False DecimalPlaces: 0 DisplayControl: Text Box GUID: Long binary data Ordinal Position: 3 Required: True Source Field: Cantitate Source Table: Pacient_Proceduri CodValiditate Text 8 AllowZeroLength: False Attributes: Variable Length Collating Order: 1048 ColumnHidden: False ColumnOrder: Default ColumnWidth: 1245 Data Updatable: False DisplayControl: Text Box GUID: Long binary data Ordinal Position: 4 Required: False Source Field: CodValiditate Source Table: Pacient_Proceduri UnicodeCompression: True NrInGrouper Byte 1 AllowZeroLength: False Attributes: Fixed Size Collating Order: 1048 ColumnHidden: False ColumnOrder: Default ColumnWidth: 1170 Data Updatable: False DecimalPlaces: 0 DisplayControl: Text Box GUID: Long binary data Ordinal Position: 5 Required: False Source Field: NrInGrouper Source Table: Pacient_Proceduri Relationships D:\DRGWork\AccessProj\DRGNational4.0\CD\1.SpecificatiiTehnice\DRGNation Tuesday, December 21, 2004 al4.0.mdb Table: Pacient_Proceduri Page: 110 Pacient_FisaPacient_Proceduri Pacient_Fisa Pacient_Proceduri Caz_ID 1 Caz_ID Attributes: Enforced RelationshipType: One-To-Many Lista_ProceduriPacient_Proceduri Lista_Proceduri Pacient_Proceduri CodProcedura 1 CodProcedura Attributes: Enforced RelationshipType: One-To-Many Table Indexes Name Number of Fields {9D45F877-9356-489E-8DED-CE36521E08D9} 1 Clustered: False DistinctCount: 0 Foreign: True Ignore Nulls: False Name: {9D45F877-9356-489E-8DED-CE36521E08D9} Primary: False Required: False Unique: False Fields: Ascending {AECE0AB0-FF74-4C48-8E00-E8970914989E} 1 Clustered: False DistinctCount: 0 Foreign: True Ignore Nulls: False Name: {AECE0AB0-FF74-4C48-8E00-E8970914989E} Primary: False Required: False Unique: False Fields: Ascending ix_CazIDCodProcedura 2 Clustered: False DistinctCount: 0 Foreign: False Ignore Nulls: False Name: ix_CazIDCodProcedura Primary: False Required: False Unique: True Fields: Ascending Ascending PrimaryKey 1 Clustered: False DistinctCount: 0 Foreign: False D:\DRGWork\AccessProj\DRGNational4.0\CD\1.SpecificatiiTehnice\DRGNation Tuesday, December 21, 2004 al4.0.mdb Table: Pacient_Proceduri Page: 111 Ignore Nulls: False Name: PrimaryKey Primary: True Required: True Unique: True Fields: Ascending User Permissions admin drgadmin Delete, Read Permissions, Set Permissions, Change Owner, Read Definition, Write Definition, Read Data, Insert Data, Update Data, drguser Group Permissions Admins Delete, Read Permissions, Set Permissions, Change Owner, Read Definition, Write Definition, Read Data, Insert Data, Update Data, DRGUsers Users Delete, Read Permissions, Set Permissions, Change Owner, Read Definition, Write Definition, Read Data, Insert Data, Update Data, D:\DRGWork\AccessProj\DRGNational4.0\CD\1.SpecificatiiTehnice\DRGNation Tuesday, December 21, 2004 al4.0.mdb Table: Pacient_Sectii Page: 112 Properties DatasheetFontHeight: 10 DatasheetFontItalic: False DatasheetFontName: Arial DatasheetFontUnderlin False DatasheetFontWeight: Normal DatasheetForeColor: 0 Date Created: 11/22/2004 12:44:18 PM GUID: Long binary data Last Updated: 12/17/2004 10:23:25 AM NameMap: Long binary data OrderByOn: False Orientation: 0 RecordCount: 0 TabularCharSet: 0 TabularFamily: 34 Updatable: True Columns Name Type Size IdPacientSectie Long Integer 4 AllowZeroLength: False Attributes: Fixed Size, Auto-Increment Collating Order: 1048 ColumnHidden: False ColumnOrder: 1 ColumnWidth: Default Data Updatable: False GUID: Long binary data Ordinal Position: 0 Required: False Source Field: IdPacientSectie Source Table: Pacient_Sectii Caz_ID Text 52 AllowZeroLength: False Attributes: Variable Length Collating Order: 1048 ColumnHidden: False ColumnOrder: Default ColumnWidth: 4995 Data Updatable: False DisplayControl: Text Box GUID: Long binary data Ordinal Position: 1 Required: True Source Field: Caz_ID Source Table: Pacient_Sectii UnicodeCompression: True Spital_ID Text 6 AllowZeroLength: False Attributes: Variable Length Collating Order: 1048 ColumnHidden: False ColumnOrder: Default ColumnWidth: Default Data Updatable: False DisplayControl: Text Box GUID: Long binary data Ordinal Position: 2 Required: True Source Field: Spital_ID Source Table: Pacient_Sectii D:\DRGWork\AccessProj\DRGNational4.0\CD\1.SpecificatiiTehnice\DRGNation Tuesday, December 21, 2004 al4.0.mdb Table: Pacient_Sectii Page: 113 UnicodeCompression: True Sectie_ID Text 4 AllowZeroLength: False Attributes: Variable Length Collating Order: 1048 ColumnHidden: False ColumnOrder: Default ColumnWidth: Default Data Updatable: False DisplayControl: Text Box GUID: Long binary data Ordinal Position: 3 Required: True Source Field: Sectie_ID Source Table: Pacient_Sectii UnicodeCompression: True NumarSectie Long Integer 4 AllowZeroLength: False Attributes: Fixed Size Collating Order: 1048 ColumnHidden: False ColumnOrder: Default ColumnWidth: Default Data Updatable: False DecimalPlaces: 0 DisplayControl: Text Box GUID: Long binary data Ordinal Position: 4 Required: True Source Field: NumarSectie Source Table: Pacient_Sectii DataInternare Date/Time 8 AllowZeroLength: False Attributes: Fixed Size Collating Order: 1048 ColumnHidden: False ColumnOrder: Default ColumnWidth: Default Data Updatable: False Format: Short Date GUID: Long binary data Ordinal Position: 5 Required: True Source Field: DataInternare Source Table: Pacient_Sectii DataExternare Date/Time 8 AllowZeroLength: False Attributes: Fixed Size Collating Order: 1048 ColumnHidden: False ColumnOrder: Default ColumnWidth: Default Data Updatable: False Format: Short Date GUID: Long binary data Ordinal Position: 6 D:\DRGWork\AccessProj\DRGNational4.0\CD\1.SpecificatiiTehnice\DRGNation Tuesday, December 21, 2004 al4.0.mdb Table: Pacient_Sectii Page: 114 Required: True Source Field: DataExternare Source Table: Pacient_Sectii NrZile Long Integer 4 AllowZeroLength: False Attributes: Fixed Size Collating Order: 1048 ColumnHidden: False ColumnOrder: Default ColumnWidth: Default Data Updatable: False DecimalPlaces: 0 DisplayControl: Text Box GUID: Long binary data Ordinal Position: 7 Required: True Source Field: NrZile Source Table: Pacient_Sectii Relationships Lista_Sectii___FiltratPacient_Sectii Lista_Sectii___Filtrat Pacient_Sectii Spital_ID 1 Spital_ID Sectie_ID 1 Sectie_ID NumarSectie 1 NumarSectie Attributes: Enforced RelationshipType: One-To-Many Pacient_FisaPacient_Sectii Pacient_Fisa Pacient_Sectii Caz_ID 1 Caz_ID Attributes: Enforced RelationshipType: One-To-Many Table Indexes Name Number of Fields {D47A2D2E-3B8B-4774-926F-ACCE587033F1} 3 Clustered: False DistinctCount: 0 Foreign: True Ignore Nulls: False Name: {D47A2D2E-3B8B-4774-926F-ACCE587033F1} Primary: False Required: False Unique: False D:\DRGWork\AccessProj\DRGNational4.0\CD\1.SpecificatiiTehnice\DRGNation Tuesday, December 21, 2004 al4.0.mdb Table: Pacient_Sectii Page: 115 Fields: Ascending Ascending Ascending Caz_ID 1 Clustered: False DistinctCount: 0 Foreign: False Ignore Nulls: False Name: Caz_ID Primary: False Required: False Unique: False Fields: Ascending NumarSectie 1 Clustered: False DistinctCount: 0 Foreign: False Ignore Nulls: False Name: NumarSectie Primary: False Required: False Unique: False Fields: Ascending Pacient_FisaPacient_Sectii 1 Clustered: False DistinctCount: 0 Foreign: True Ignore Nulls: False Name: Pacient_FisaPacient_Sectii Primary: False Required: False Unique: False Fields: Ascending PrimaryKey 1 Clustered: False DistinctCount: 0 Foreign: False Ignore Nulls: False Name: PrimaryKey Primary: True Required: True Unique: True Fields: Ascending Sectie_ID 1 Clustered: False DistinctCount: 0 Foreign: False Ignore Nulls: False Name: Sectie_ID Primary: False Required: False Unique: False Fields: Ascending Spital_ID 1 Clustered: False DistinctCount: 0 Foreign: False Ignore Nulls: False D:\DRGWork\AccessProj\DRGNational4.0\CD\1.SpecificatiiTehnice\DRGNation Tuesday, December 21, 2004 al4.0.mdb Table: Pacient_Sectii Page: 116 Name: Spital_ID Primary: False Required: False Unique: False Fields: Ascending User Permissions admin drgadmin Delete, Read Permissions, Set Permissions, Change Owner, Read Definition, Write Definition, Read Data, Insert Data, Update Data, drguser Group Permissions Admins Delete, Read Permissions, Set Permissions, Change Owner, Read Definition, Write Definition, Read Data, Insert Data, Update Data, DRGUsers Users Delete, Read Permissions, Set Permissions, Change Owner, Read Definition, Write Definition, Read Data, Insert Data, Update Data, D:\DRGWork\AccessProj\DRGNational4.0\CD\1.SpecificatiiTehnice\DRGNation Tuesday, December 21, 2004 al4.0.mdb Table: PacientiNeimportati Page: 117 Properties Date Created: 11/26/2004 2:25:34 PM GUID: Long binary data Last Updated: 11/26/2004 2:25:35 PM NameMap: Long binary data OrderByOn: False Orientation: 0 RecordCount: 0 Updatable: True Columns Name Type Size Pacienti_neimportati Text 70 AllowZeroLength: False Attributes: Variable Length Caption: Pacienti Neimportati - ID_Caz Collating Order: 1048 ColumnHidden: False ColumnOrder: Default ColumnWidth: 2940 Data Updatable: False DisplayControl: Text Box GUID: Long binary data Ordinal Position: 0 Required: False Source Field: Pacienti_neimportati Source Table: PacientiNeimportati UnicodeCompression: True Table Indexes Name Number of Fields Caz_ID 1 Clustered: False DistinctCount: 0 Foreign: False Ignore Nulls: False Name: Caz_ID Primary: False Required: False Unique: False Fields: Ascending User Permissions admin drgadmin Delete, Read Permissions, Set Permissions, Change Owner, Read Definition, Write Definition, Read Data, Insert Data, Update Data, drguser Group Permissions Admins Delete, Read Permissions, Set Permissions, Change Owner, Read Definition, Write Definition, Read Data, Insert Data, Update Data, DRGUsers Users Delete, Read Permissions, Set Permissions, Change Owner, Read D:\DRGWork\AccessProj\DRGNational4.0\CD\1.SpecificatiiTehnice\DRGNation Tuesday, December 21, 2004 al4.0.mdb Table: PacientiNeimportati Page: 118 Definition, Write Definition, Read Data, Insert Data, Update Data, Delete Data D:\DRGWork\AccessProj\DRGNational4.0\CD\1.SpecificatiiTehnice\DRGNation Tuesday, December 21, 2004 al4.0.mdb Table: TotalInterventii Page: 119 Properties Date Created: 12/06/2004 11:16:48 AM GUID: Long binary data Last Updated: 12/06/2004 11:16:54 AM NameMap: Long binary data OrderByOn: False Orientation: 0 RecordCount: 0 Updatable: True Columns Name Type Size Caz_ID Text 70 AllowZeroLength: False Attributes: Variable Length Collating Order: 1048 ColumnHidden: False ColumnOrder: Default ColumnWidth: Default Data Updatable: False DisplayControl: Text Box GUID: Long binary data Ordinal Position: 0 Required: True Source Field: Caz_ID Source Table: TotalInterventii UnicodeCompression: True Interventie_COD Text 6 AllowZeroLength: False Attributes: Variable Length Collating Order: 1048 ColumnHidden: False ColumnOrder: Default ColumnWidth: Default Data Updatable: False DisplayControl: Text Box GUID: Long binary data Ordinal Position: 1 Required: True Source Field: Interventie_COD Source Table: TotalInterventii UnicodeCompression: True Table Indexes Name Number of Fields Caz_ID 1 Clustered: False DistinctCount: 0 Foreign: False Ignore Nulls: False Name: Caz_ID Primary: False Required: False Unique: False Fields: Ascending Interventie_COD 1 Clustered: False D:\DRGWork\AccessProj\DRGNational4.0\CD\1.SpecificatiiTehnice\DRGNation Tuesday, December 21, 2004 al4.0.mdb Table: TotalInterventii Page: 120 DistinctCount: 0 Foreign: False Ignore Nulls: False Name: Interventie_COD Primary: False Required: False Unique: False Fields: Ascending User Permissions admin drgadmin Delete, Read Permissions, Set Permissions, Change Owner, Read Definition, Write Definition, Read Data, Insert Data, Update Data, drguser Group Permissions Admins Delete, Read Permissions, Set Permissions, Change Owner, Read Definition, Write Definition, Read Data, Insert Data, Update Data, DRGUsers Users Delete, Read Permissions, Set Permissions, Change Owner, Read Definition, Write Definition, Read Data, Insert Data, Update Data, D:\DRGWork\AccessProj\DRGNational4.0\CD\1.SpecificatiiTehnice\DRGNation Tuesday, December 21, 2004 al4.0.mdb Database: Page: 121 Properties AccessVersion: 08.50 AllowBreakIntoCode: False AllowBypassKey: False Auto Compact: 0 Build: 3822 Collating Order: 1048 Four-Digit Year 0 Log Name AutoCorrect 0 Perform Name 1 QueryTimeout: 60 RecordsAffected: 0 Row Limit: 10000 Show Values in 1 Show Values in 1 Show Values in 0 Show Values in 0 Show Values in 1 Show Values Limit: 1000 Track Name 1 Transactions: True Updatable: True Version : 4.0 User Permissions admin drgadmin drguser Group Permissions Admins DRGUsers Users D:\DRGWork\AccessProj\DRGNational4.0\CD\1.SpecificatiiTehnice\DRGNation Tuesday, December 21, 2004 al4.0.mdb Relationships Page: 122 Relationships Lista_DiagnosticePacient_DiagnosticeSecundare Lista_Diagnostice Pacient_DiagnosticeSecun 1 CodDiagnostic CodDiagnosticSecundar Attributes: Enforced RelationshipType: One-To-Many Lista_TipInternarePacient_Fisa Lista_TipInternare Pacient_Fisa 1 IdTipInternare IdTipInternare Attributes: Enforced RelationshipType: One-To-Many Lista_Spitale___FiltratPacient_Fisa Lista_Spitale___Filtrat Pacient_Fisa 1 Spital_ID Spital_ID Attributes: Enforced RelationshipType: One-To-Many Lista_Proceduri___BlocuriLista_Proceduri Lista_Proceduri___Blocur Lista_Proceduri CodBloc 1 CodBloc Attributes: Enforced RelationshipType: One-To-Many Lista_Diagnostice___Cod1Cod2Pacient_Fisa Lista_Diagnostice___Cod1 Pacient_Fisa CodDiagnostic1 1 CodDiagnosticPrincipalCo CodDiagnostic2 1 CodDiagnosticPrincipalCo Attributes: Enforced RelationshipType: One-To-Many D:\DRGWork\AccessProj\DRGNational4.0\CD\1.SpecificatiiTehnice\DRGNation Tuesday, December 21, 2004 al4.0.mdb Relationships Page: 123 Lista_TipAsigurarePacient_Fisa Lista_TipAsigurare Pacient_Fisa IdTipAsigurare 1 IdTipAsigurare Attributes: Enforced RelationshipType: One-To-Many Lista_Proceduri___CapitoleLista_Proceduri___Blocuri Lista_Proceduri___Capito Lista_Proceduri___Blocur CodCapitol 1 CodCapitol Attributes: Enforced RelationshipType: One-To-Many Lista_Diagnostice___SubClaseLista_Diagnostice Lista_Diagnostice___SubC Lista_Diagnostice 1 IdSubClasaDiagnostic IdSubClasaDiagnostic Attributes: Enforced RelationshipType: One-To-Many Lista_TipExternarePacient_Fisa Lista_TipExternare Pacient_Fisa 1 IdTipExternare IdTipExternare Attributes: Enforced RelationshipType: One-To-Many Lista_JudeteLista_Localitati Lista_Judete Lista_Localitati IdJudet 1 IdJudet Attributes: Enforced RelationshipType: One-To-Many Lista_CASPacient_Fisa Lista_CAS Pacient_Fisa IdCAS 1 IdCAS Attributes: Enforced RelationshipType: One-To-Many D:\DRGWork\AccessProj\DRGNational4.0\CD\1.SpecificatiiTehnice\DRGNation Tuesday, December 21, 2004 al4.0.mdb Relationships Page: 124 Lista_JudetePacient_Fisa Lista_Judete Pacient_Fisa IdJudet 1 IdJudetCAS Attributes: Enforced RelationshipType: One-To-Many Lista_ProceduriPacient_Fisa Lista_Proceduri Pacient_Fisa CodProcedura 1 CodInterventieChirurgica Attributes: Enforced RelationshipType: One-To-Many Pacient_FisaPacient_Proceduri Pacient_Fisa Pacient_Proceduri 1 Caz_ID Caz_ID Attributes: Enforced RelationshipType: One-To-Many Lista_ProceduriPacient_Proceduri Lista_Proceduri Pacient_Proceduri 1 CodProcedura CodProcedura Attributes: Enforced RelationshipType: One-To-Many Lista_DiagnosticeLista_Diagnostice___Cod1Cod2 Lista_Diagnostice Lista_Diagnostice___Cod1 CodDiagnostic 1 CodDiagnostic1 Attributes: Enforced RelationshipType: One-To-Many Lista_StareExternarePacient_Fisa Lista_StareExternare Pacient_Fisa IdStareExternare 1 IdStareExternare Attributes: Enforced RelationshipType: One-To-Many D:\DRGWork\AccessProj\DRGNational4.0\CD\1.SpecificatiiTehnice\DRGNation Tuesday, December 21, 2004 al4.0.mdb Relationships Page: 125 Lista_Spitale___FiltratLista_Sectii___Filtrat Lista_Spitale___Filtrat Lista_Sectii___Filtrat Spital_ID 1 Spital_ID Attributes: Enforced RelationshipType: One-To-Many Lista_LocalitatiPacient_Fisa Lista_Localitati Pacient_Fisa IdJudet 1 IdJudet IdLocalitate 1 IdLocalitate Attributes: Enforced RelationshipType: One-To-Many Lista_Diagnostice___ClaseLista_Diagnostice___SubClase Lista_Diagnostice___Clas Lista_Diagnostice___SubC 1 IdClasaDiagnostic IdClasaDiagnostic Attributes: Enforced RelationshipType: One-To-Many Lista_DiagnosticeLista_Diagnostice___Cod1Cod2 Lista_Diagnostice Lista_Diagnostice___Cod1 1 CodDiagnostic CodDiagnostic2 Attributes: Enforced RelationshipType: One-To-Many Pacient_FisaPacient_DiagnosticeSecundare Pacient_Fisa Pacient_DiagnosticeSecun Caz_ID 1 Caz_ID Attributes: Enforced RelationshipType: One-To-Many D:\DRGWork\AccessProj\DRGNational4.0\CD\1.SpecificatiiTehnice\DRGNation Tuesday, December 21, 2004 al4.0.mdb Relationships Page: 126 Lista_DiagnosticePacient_Fisa Lista_Diagnostice Pacient_Fisa CodDiagnostic 1 CodDiagnosticLaInternare Attributes: Enforced RelationshipType: One-To-Many Lista_Sectii___FiltratPacient_Sectii Lista_Sectii___Filtrat Pacient_Sectii Spital_ID 1 Spital_ID Sectie_ID 1 Sectie_ID NumarSectie 1 NumarSectie Attributes: Enforced RelationshipType: One-To-Many Lista_Sectii___FiltratPacient_Fisa Lista_Sectii___Filtrat Pacient_Fisa 1 Spital_ID Spital_ID 1 Sectie_ID Sectie_ID 1 NumarSectie NumarSectie Attributes: Enforced RelationshipType: One-To-Many Lista_Spitale___FiltratLista_Medici Lista_Spitale___Filtrat Lista_Medici 1 Spital_ID Spital_ID Attributes: Enforced RelationshipType: One-To-Many Lista_CoduriMDCLista_CoduriDRG Lista_CoduriMDC Lista_CoduriDRG IdMDC 1 IdMDC Attributes: Enforced RelationshipType: One-To-Many D:\DRGWork\AccessProj\DRGNational4.0\CD\1.SpecificatiiTehnice\DRGNation Tuesday, December 21, 2004 al4.0.mdb Relationships Page: 127 Lista_StareRecordPacient_Fisa Lista_StareRecord Pacient_Fisa IdStareRecord 1 IdStareRecord Attributes: Enforced RelationshipType: One-To-Many Lista_AccidentePacient_Fisa Lista_Accidente Pacient_Fisa IdAccident 1 IdAccident Attributes: Enforced RelationshipType: One-To-Many Lista_CoduriDRGPacient_Grouper Lista_CoduriDRG Pacient_Grouper 1 CodDRG CodDRG Attributes: Enforced RelationshipType: One-To-Many Lista_LocalitatiLista_Spitale Lista_Localitati Lista_Spitale 1 IdJudet IdJudet 1 IdLocalitate IdLocalitate Attributes: Enforced RelationshipType: One-To-Many Lista_MediciPacient_Fisa Lista_Medici Pacient_Fisa Spital_ID Spital_ID CodMedic CodMedicOperator Attributes: Not Enforced, Right Join RelationshipType: One-To-Many D:\DRGWork\AccessProj\DRGNational4.0\CD\1.SpecificatiiTehnice\DRGNation Tuesday, December 21, 2004 al4.0.mdb Relationships Page: 128 Lista_MediciPacient_Fisa Lista_Medici Pacient_Fisa Spital_ID Spital_ID CodMedic CodMedicMana2 Attributes: Not Enforced, Left Join RelationshipType: One-To-Many Lista_MediciPacient_Fisa Lista_Medici Pacient_Fisa Spital_ID 1 Spital_ID CodMedic 1 CodMedic Attributes: Enforced, Left Join RelationshipType: One-To-Many Lista_SectiiLista_Sectii___Filtrat Lista_Sectii Lista_Sectii___Filtrat 1 Sectie_ID Sectie_ID Attributes: Enforced RelationshipType: One-To-Many Lista_SpitaleLista_Spitale___Filtrat Lista_Spitale Lista_Spitale___Filtrat 1 1 Spital_ID Spital_ID Attributes: Unique, Enforced RelationshipType: One-To-One Pacient_FisaPacient_Grouper Pacient_Fisa Pacient_Grouper Caz_ID 1 1 Caz_ID Attributes: Unique, Enforced RelationshipType: One-To-One D:\DRGWork\AccessProj\DRGNational4.0\CD\1.SpecificatiiTehnice\DRGNation Tuesday, December 21, 2004 al4.0.mdb Relationships Page: 129 Pacient_FisaPacient_Sectii Pacient_Fisa Pacient_Sectii Caz_ID 1 Caz_ID Attributes: Enforced RelationshipType: One-To-Many