ORACLE - Auditing Table Changes (Trigger Template)
- Template Text:
-
- Text Description:
-
Auditing Tables Changes
-----------------------------------
This trigger is an example of how to audit changes
in a table. For each update or delete, the previous
and the current values are stored in an auxiliary table.
The values of the current user and date are also stored.
- GUID:
82d4babe-3b1c-11d5-a5f5-004095d229e6
ORACLE - Delete Cascade (Trigger Template)
- Template Text:
-
- Text Description:
-
DELETE Cascade Trigger for Parent Table:
This TRIGGER deletes the rows on the child(ren) table(s) for each deleted on the parent table.
- GUID:
82d4babf-3b1c-11d5-a5f5-004095d229e6
ORACLE - Foreign Key Child Tbls (Trigger Template)
- Template Text:
-
- Text Description:
-
Foreign Key Trigger for a Child Table:
-------------------------------------
If a row is inserted in a child table the Check_insert_#child
trigger is triggered to verify if the foreign key is present
in the parent table.
- GUID:
82d4bac0-3b1c-11d5-a5f5-004095d229e6
ORACLE - Referential Integrity (Trigger Template)
- Template Text:
-
- Text Description:
-
UPDATE / INSERT / DELETE Referential Integrity Constraints
This package includes four triggers enforcing constraints
between a parent table and its children tables.
Foreign Key Trigger for a Child Table:
-------------------------------------
If a row is inserted in a child table the vr_ins_#child
trigger is triggered to verify if the foreign key is present
in the parent table.
UPDATE / DELETE Cascade Triggers for a Parent Table:
---------------------------------------------------
If a row is deleted or updated in a parent table, the rows
in every child table referencing that foreign key are
also deleted or updated.
- GUID:
82d4bac1-3b1c-11d5-a5f5-004095d229e6
ORACLE - Update/Delete Restrict (Trigger Template)
- Template Text:
-
- Text Description:
-
UPDATE and DELETE RESTRICT Trigger for the Parent Table:
This TRIGGER is used to enforce UPDATE and DELETE RESTRICT
referential integrity constraints. When an update or delete
is executed on the parent table, the TRIGGER checks
if there are some children tables using the current key,
if there are, at least one, the transaction will be
rollbacked using the raise_application_error .
- GUID:
82d4bac2-3b1c-11d5-a5f5-004095d229e6
OrdningKode [SKAT.PAFAngivelse] (Class Attribute)
- GUID:
d81d47bd-df25-4083-a4b8-960346261ae2
- Description:
Angiver typen af pensionsordning
- Derived:
F
- Final:
F
- Static:
F
- Transient:
F
- Volatile:
F
- Access:
private
- PK:
F
- Class Name:
PAFAngivelse
- Source Data:
PAFAngivelseOrdningKode
- Package:
SKAT
- MinOccurs:
1
- MaxOccurs:
1
- Use:
optional
- Process Contents:
strict
- Keyed by Definitions:
-
PAFAngivelse (Class)
- Used By:
-
PAFAngivelse (Class)
OrdningKode (Data Domain)
- GUID:
b05c9fc6-02f5-4a82-b3df-7e6d0f3450ec
- Data Type:
character
- Data Type Qualifiers:
40
- Text Description:
Angiver typen af pensionsordning
- System Default:
F
- Character Type:
none
- Future Only:
F
- Full Name:
Ordning kode
- Allowed Values:
-
1 = Privattegnet ordning
2 = Arbejdsgiveradministreret ordning
- XSD Facet enumeration:
-
1PrivattegnetOrdning
2ArbejdsgiveradministreretOrdning
- Inherited By:
-
PAFAngivelseOrdningKode (Data Element)
OrganisatoriskEnhed [SKAT] (Class)
- GUID:
1ab9f21a-576a-43eb-8805-7c975c7183eb
- Description:
En organisatorisk enhed i SKAT dækker over skattecentre, faglige søjler og enheder.
- Programming Language:
Java
- Package:
SKAT
- Attributes:
-
Navn
Nummer
ÅbningTid
- Final:
F
- Abstract:
F
- Public:
T
- Generate static initializer:
F
- Generate finalizer:
F
- Model Interessent:
-
EKKO
EFI
eIndkomst
- Versions nr:
1.0
- Member Names:
qualified
- Mixed:
false
- MinOccurs:
1
- MaxOccurs:
1
- Derivation:
restriction
- Process Contents:
strict
- Identifies:
-
Navn (Class Attribute)
Nummer (Class Attribute)
ÅbningTid (Class Attribute)
- Keyed by Definitions:
-
SKAT (Package)
- Is Child In:
-
(Association End)
(Association End)
(Association End)
(Association End)
(Association End)
(Association End)
OrganisatoriskEnhedNavn (Data Element)
- GUID:
ebd4338a-418a-4e05-b3fc-f31f6d697937
- Domain:
Type
- Text Description:
Navn på virksomhed/organisation.
- Check Not for Replication:
F
- Beskrivelse:
-
Navnet på den organisatoriske enhed, f.eks. skattecentrets navn.
Eksempel: Hvis typen af organisation er Kundecenter, så vil navnet være Roskilde, så det er Kundecenter Roskilde.
- Allowed Values:
-
- Inddrivelsescentret
- IT-service
- Projektenhed
- SC Holbæk
- ...
- Model Interessent:
-
EKKO
EFI
eIndkomst
- System Default:
F
- Character Type:
none
- Used By:
-
Navn (Class Attribute)
- Inherits from Definitions:
-
Type (Data Domain)
OrganisatoriskEnhedNummer (Data Element)
- GUID:
60799565-e5a4-43a1-b4ea-55fb2c6f5b0f
- Domain:
Kode
- Text Description:
Et positivt heltal, der kan repræsenterer værdier i intervallet 0 til 999.999.999.999.999.999
- Check Not for Replication:
F
- Beskrivelse:
Dette er nummeret på den organisatoriske enhed, f.eks. nummeret på Skattecenteret.
- Model Interessent:
-
EKKO
EFI
eIndkomst
- System Default:
F
- Character Type:
none
- Used By:
-
Nummer (Class Attribute)
- Inherits from Definitions:
-
Kode (Data Domain)
OrganisatoriskEnhedType [SKAT] (Class)
- GUID:
fc58a682-5bec-4012-a8fd-a8350a5eb7e0
- Description:
Indeholder information om en organisationstype. SKATs organisatoriske enheder (typer) vil fx være Hovedcenter, Inddrivelsescentret, Intern Revision, IT service, Kundecenter mm.
- Programming Language:
Java
- Package:
SKAT
- Attributes:
Navn
- Final:
F
- Abstract:
F
- Public:
T
- Generate static initializer:
F
- Generate finalizer:
F
- Model Interessent:
-
EFI
EKKO
eIndkomst
- Member Names:
qualified
- Mixed:
false
- MinOccurs:
1
- MaxOccurs:
1
- Derivation:
restriction
- Process Contents:
strict
- Versions nr:
1.0
- Identifies:
-
Navn (Class Attribute)
- Keyed by Definitions:
-
SKAT (Package)
- Is Child In:
-
(Association End)
Er af typen (Association Class Link)
OrganisatoriskEnhedTypeNavn (Data Element)
- Domain:
Type
- Check Not for Replication:
F
- Beskrivelse:
Navnet på typen af organisatorisk enhed.
- Allowed Values:
-
Tilladte værdier er:
- Ankecenter
- Betalingscentret
- Center for Store Selskaber
- Hovedcenter
- Inddrivelsescentret
- Intern Revision
- IT-drift- og forvaltningscenter
- Kundecenter
- Midt- og Sydsjælland
- Midtjylland
- Nordjylland
- Nordsjælland-København
- Retssikkerhedschefen
- Spillemyndigheden
- Sydjylland-Fyn
- GUID:
c85d66d5-41a0-40d1-a7b6-33d95872a0bb
- Model Interessent:
-
EFI
EKKO
eIndkomst
- System Default:
F
- Character Type:
none
- Used By:
-
Navn (Class Attribute)
- Inherits from Definitions:
-
Type (Data Domain)
OrganisatoriskEnhedÅbningTid (Data Element)
- GUID:
09674641-4d31-473a-92c3-1b6e04bc112f
- Domain:
ÅbningTid
- Text Description:
En åbningstid defineret af Ugedag samt tid fra - tid til.
- Check Not for Replication:
F
- Beskrivelse:
RestanceInddrivelsesmyndighed: Det skal være muligt i forbindelse med ressoucestyring at kunne inddrage den organisatoriske enheds åbningstid.
- Model Interessent:
-
EKKO
EFI
eIndkomst
- System Default:
F
- Character Type:
none
- Used By:
-
ÅbningTid (Class Attribute)
- Inherits from Definitions:
-
ÅbningTid (Data Domain)
OrganisatoriskUnderEnhed [SKAT] (Class)
- GUID:
aa17d34e-dede-480e-a882-829e19de4a47
- Description:
-
Dækker over forskellige afdelinger, grupper og kontorer. Fx:
- Administration
- Inddrivelse 1
- Inddrivelse 2
- Kontrol 1
- Kundeservice
- Programming Language:
Java
- Package:
SKAT
- Attributes:
Navn
- Final:
F
- Abstract:
F
- Public:
T
- Generate static initializer:
F
- Generate finalizer:
F
- Model Interessent:
-
EFI
eIndkomst
- Member Names:
qualified
- Mixed:
false
- MinOccurs:
1
- MaxOccurs:
1
- Derivation:
restriction
- Process Contents:
strict
- Versions nr:
1.0
- Identifies:
-
Navn (Class Attribute)
- Keyed by Definitions:
-
SKAT (Package)
- Is Child In:
-
(Association End)
OrganisatoriskUnderEnhedNavn (Data Element)
- GUID:
47480401-5cf1-4a56-be2d-00916b3a7e62
- Domain:
Type
- Text Description:
Typer er karakteriseret af lister, hvorfra kan vælges vedtagne værdier.
- Check Not for Replication:
F
- Beskrivelse:
Navnet på den organisatoriske enhed enkelte afdelinger, grupper og kontorer.
- Allowed Values:
-
- Administration
- Inddrivelse 1
- Inddrivelse 2
- Kontrol 1
- Kundeservice
- ...
- Model Interessent:
-
EFI
eIndkomst
- System Default:
F
- Character Type:
none
- Used By:
-
Navn (Class Attribute)
- Inherits from Definitions:
-
Type (Data Domain)
Organizational Units without Roles (Analytic)
- Description:
-
This analytic displays an icon for organizational units without roles assigned to them.
You should run this analytic against the current Organization Chart.
Note: In order to see the icons you must select Show Analytic Depictions from the View menu.
- Project:
SAAuto
- Module:
Analytics
- Function:
LocateRoles
- Auto run on drag and drop:
T
- GUID:
d0ac599d-bf33-4b50-95ed-50f691a012c8