dc_table_partition_versions: Data Cache Table Partition Versions
read only
- Katalog:
Cache - Schema:
Invantive - Primärschlüssel:
tpn_id - Label: Table Partition Versions
Data set replicated from a table for a specific partition at a specific moment in time.
Es können nur Daten abgerufen werden.
Tabellenspalten
Die Spalten der Tabelle dc_table_partition_versions sind unten aufgeführt. Jede Spalte hat einen SQL-Datentyp. Beim Einfügen und Aktualisieren muss für jede erforderliche Spalte jederzeit ein neuer Wert angegeben werden der nicht Null ist.
| Name | Datentyp | Label | Required | Marks | Documentation |
|---|---|---|---|---|---|
ptn_id |
decimal |
Partition ID | Reference to a partition. | ||
tbe_id |
decimal |
Tabellen ID | Reference to a table. | ||
tpn_ |
decimal |
Rows | Number of rows in the table partition version. | ||
tpn_ |
decimal |
Anzahl der gelöschten Zeilen | Number of rows deleted compared to previous table partition version. | ||
tpn_ |
decimal |
Differenz der Zeilenanzahl | Number of rows changed compared to previous table partition version. | ||
tpn_ |
decimal |
Anzahl der eingefügten Zeilen | Number of rows inserted compared to previous table partition version. | ||
tpn_ |
decimal |
Anzahl der vorherigen Zeilen | Number of rows in the previous table partition version. | ||
tpn_ |
decimal |
Anzahl der aktualisierten Zeilen | Number of rows updated compard to previous table partition version. | ||
tpn_ |
varchar2 |
Erstellt in | The code of the function in the modules table from within which the user created the record.This value will never change after creation of the record. | ||
tpn_ |
varchar2 |
Erstellt durch | Wer hat den Datensatz erstellt. | ||
tpn_ |
varchar2 |
Datendateiname Pfad | Storage location of the data on disk. | ||
tpn_ |
datetime |
Datum Löschbar | Date/time at which the data in the facts table may first be deleted (UTC). | ||
tpn_ |
datetime |
Datum Obsolet | Date/time at which the data in the facts table may first be declared obsolete (UTC). | ||
tpn_ |
datetime |
Erstellt bei | The system time in UTC at which the record was created.This value will never change after creation of the record. | ||
tpn_ |
datetime |
Datum Letzte Frischeprüfung | Date/time at which the facts table was last checked for freshness (UTC). | ||
tpn_ |
datetime |
Datum letzten Erstellung | Date/time at which the facts table was last created (UTC). | ||
tpn_ |
datetime |
Datum letzten Löschung | Date/time at which the data in the facts table was declared deleted (UTC). | ||
tpn_ |
datetime |
Datum letzten Veraltung | Date/time at which the data in the facts table was declared obsolete (UTC). | ||
tpn_ |
datetime |
Datum letzten Fertigstellung | Date/time at which the facts table was last made available for use (UTC). | ||
tpn_ |
datetime |
Datum letzten Setzung | Date/time at which the facts table was last seeded for new data (UTC). | ||
tpn_ |
datetime |
Datum letzter Ladebeginn | Date/time at which the facts table was last loaded with new data (UTC). | ||
tpn_ |
datetime |
Datum Metadaten Löschbar | Date/time at which the metadata on the facts table may first be declared deleted (UTC). | ||
tpn_ |
datetime |
Aktualisiert am | The system time in UTC at which the record was last updated.This value will change for every mutation of the record. | ||
tpn_ |
decimal |
Geschätzte Größe (Zeichen) | Estimates size of characters in the data for the table partition version. | ||
tpn_id |
decimal |
ID | Unique identifier. | ||
tpn_ |
datetime |
Datum Logische View Zuletzt erstellt | Date/time at which the overall and/or partition logical views were last maintained (UTC). | ||
tpn_ |
varchar2 |
Aktualisiert in | The code of the function in the modules table from within which the user last updated the record.This value will change for every mutation of the record. | ||
tpn_ |
varchar2 |
Aktualisiert von | The name of the user in the users table whom last updated the record.This value will change for every update of the record. | ||
tpn_ |
varchar2 |
Original System Gruppe | Reference for identifying the group of records on the system from which it originated.It is commonly used to group records for later validation in an application control. | ||
tpn_ |
varchar2 |
Ursprünglicher Systembezug | Referenz zur Identifikation des Datensatzes auf dem System, von dem er stamm. | ||
tpn_ |
varchar2 |
Aktualisierungsursprung | Origin of the refresh action leading to this version: 'S' for select, 'L' for load and 'R' for refresh. | ||
tpn_ |
char |
Verwendeter Code für den Seeding-Ansatz | Seeding approach to get a up-to-date data set.Seeding approaches include 'C' for 'Complete', 'S' for 'Smart Sampling' and ' T' for 'Trickle Loading'. | ||
tpn_ |
varchar2 |
Verwendeter Seeding-Ansatz Beschreibung | Description of the seeding approach. | ||
tpn_ |
varchar2 |
Verwendeter Startwert Nr. 1 | Value of a parameter used for the seeding process.Meaning depends on the seeding approach. | ||
tpn_ |
varchar2 |
Verwendeter Startwert Nr. 2 | Value of a parameter used for the seeding process.Meaning depends on the seeding approach. | ||
tpn_ |
varchar2 |
Verwendeter Startwert Nr. 3 | Value of a parameter used for the seeding process.Meaning depends on the seeding approach. | ||
tpn_ |
varchar2 |
Verwendeter Startwert Nr. 4 | Value of a parameter used for the seeding process.Meaning depends on the seeding approach. | ||
tpn_ |
varchar2 |
Verwendeter Startwert Nr. 5 | Value of a parameter used for the seeding process.Meaning depends on the seeding approach. | ||
tpn_ |
varchar2 |
Session erstellt | The ID of the session which created the record.This value will not change after insert. | ||
tpn_ |
varchar2 |
Sitzung aktualisiert | Die ID der Session, die den Datensatz zuletzt aktualisierte. | ||
tpn_ |
varchar2 |
Bundesland-Code | Code of the state in which the table partition version is. | ||
tpn_ |
varchar2 |
Zustandsbeschreibung | Description of the state in which the table partition version is. | ||
tpn_ |
varchar2 |
Anmerkung des Staates | Note on the state in which the table partition version is. | ||
tpn_ |
varchar2 |
Verhandlung angelegt | The ID of the transaction which created the record. | ||
tpn_ |
varchar2 |
Verhandlung aktualisiert | The ID of the transaction which last updated the record. | ||
tpn_ |
decimal |
Versionsnummer | Numeric incremental version of the table partition.Increased by 1 every time a new data set is downloaded and/or calculated. |
Anmerkungen zu dieser Version
Was hat sich in den Tabellen, Spalten, Attributen und Funktionen des Treibers mit jeder neuen Version geändert: