Søgning » ECCAIRS2 » report
Tabel

report


Beskrivelse ?

Master table with all reports

Størrelse (Antal rækker) ?

247668

Indhold (Kolonner/variable) ?

Navn Indhold
e2_id Report e2 identifier
"version" version of the OR, VR, OC or SR that has been updated through the BO execution
blocked Flag if the report is blocked
version_type Report version type
reporting_method Report reporting method
or_initial_date The initial date of type OR
vr_initial_date The initial date if VR
oc_initial_date The initial date if OC
has_automatic_changes Report automatic changes
transferred_date The transferred date of the report
report_to_date The report to date
au_creation_date Audit field to save the creation date
au_creation_user Audit field to save the creation user
au_active Audit field to save logical deletion
au_modification_user Audit field to save the modification user
au_modification_date Audit field to save the modification date
responsible_entity_code Reference to the authority table
user_id Reference to the user table
transferred_from_authority_id Reference to the authority table
report_from_authority_id Reference to the authority table
report_to_from_authority_id Reference to the authority table
migration_file_id Reference to the migrationfile table
document_type OR, VR, OC or SR e2_id by the BO execution
status_id Reference to the reportstatus table
last_shared_ecr The last shared ECR date
reporting_entity_valuelist_id The ID of the valuelist the reporting entity belongs to
reporting_entity_listofvalue_id Reference to the listofvalue table