Det Danske CO2-kvoteregister

Tabeloversigt ?
CORRELATION_PEOPLE
CR2012_USER
UB_MI
PEOPLE
CR2012_INSTALLATION
PERIOD_CODE
TRANSACTION_BLOCK
TX_PROPOSAL_BLOCK
USERS
CORRELATION_INSTALLATION
CR2012_ACCOUNT_HOLDER
INSTALLATION
UNIT_BLOCK
CR2012_AH_REP
CR2012_CONTACT_PERSON
CR2012_AH_REP_VIS
COMPLIANCE_STATUS_BL
CR2012_CONTACT_PERSON_VIS
TRANSACTION_LOG
TRANSACTION_PROPOSAL
CR2012_ACCOUNT
REPORT_TRANSACTION_SNAPSHOT
SNAPSHOT_UNIT
NOTIFICATION
ACCOUNT
BACKUP_ACCOUNT
CORRELATION_INVOICING_INFO
CORRELATION_LOG
INVOICING_INFORMATION
REPORT_SNAPSHOT
MESSAGE_LOG
NAP_HISTORY
RESPONSE_CATALOG
ART16_RESTRICTION
COMPLIANCE_STATUS_HISTORY
CORRELATION_ACCOUNT
FEE
FEE_HISTORY
NAP
NAP_INSTALLATION
RECONCILIATION_LOG
SURRENDER
UNIT_HOLDING_PERMISSION_RULES
CORRELATION_FEE
CORRELATION_NAP_INSTALLATION
CORRELATION_PEOPLE_VISIBILITY
CORRELATION_RESPONSE_LOG
NOTIFICATION_HISTORY
RETIREMENT
SEF_TABLE_2A
SEF_TABLE_2B_MAIN
SEF_TABLE_5A_STARTING_VALUES
SMS_LOGGING
VERIFIED_EMISSION
WELCOME
APPROVED_PROJECTS
CODE_TRANSLATION
CORRELATION_LOG_HISTORY
CORRELATION_NAP
CORRELATION_PEOPLE_DOC
CORRELATION_VERIFIED_EMISSION
EMAIL_SENT
NAP_INSTALLATION_HISTORY
NOT_ALLOWED_PROJECTS
PERMIT
PERMIT_HISTORY
RECONCILIATION_LOG_HISTORY
RMU_ISSUANCE
SEF_ACCOUNT_HOLDINGS
SEF_TABLE_2C
SEF_TABLE_3_REPLACEMENT
SEF_TABLE_5A_ANNUAL_TX
ALLOWANCE_TO_AAU
ANNEX16_VISIBILITY
ANNEX16_VISIBILITY_20101401
CORRELATION_ANNEX16_VISIBILITY
CORRELATION_CALLBACK
PEOPLE_ACCOUNT
SEF_TABLE_2B_TRACK2
SEF_TABLE_3_REQUIREMENT
SEF_TABLE_5B_REPLACEMENT
SEF_TABLE_5B_REQUIREMENT
SEF_TABLE_5C
SNAPSHOT_DESC
SURRENDER_HISTORY
SURRENDER_LIMIT
TRANSACTION_BLOCK_RESPONSE
TRANSACTION_LOG_HISTORY
TX_PROPOSAL_STATUS_HISTORY
VERIFIED_EMISSION_HISTORY
CR2012_USER_ACCOUNT_REL
GROUP_MEMBER
RECONCILIATION_RESPONSE
TIME_SYNC
TRANSACTION_RESPONSE
TRANSFERRING_FROM_DK
ACCOUNT_MGMT_PROCESS_CODE
ACCOUNT_TYPE_CODE
ACCOUNT_UPDATE_TYPE_CODE
ACTION_CODE
ACTIVITY_TYPE_CODE
AUTOMATED_WARNING_TYPE_CODE
CHECK_CATALOG_CODE
CHECK_CATEGORY
COMPLIANCE_STATUS_CODE
CORR_MGMT_PROCESS_CODE
CORR_STATUS_CODE
COUNTRY_CODE
CREDENTIALS_TYPE
CREDIT_PERIOD_TYPE
CR2012_ACCOUNT_GROUP
CR2012_CORR_DATA
DOCUMENT_TYPE_CODE
ECAS_DOMAIN
EVENT_TYPE_CODE
GROUP_CODE
INFORMATION_TYPE_CODE
INSTALLATION_STATUS_CODE
ISO6391_CODE
LULUCF_CODE
NAP_INST_ACTION_CODE
NOTIFICATION_STATUS_CODE
NOTIFICATION_TYPE_CODE
OPENING_DATES
OUTCOME_CODE
RECONCILIATION_STATUS_CODE
REGISTRY_CODE
RELATIONSHIP_TYPE_CODE
SEQ_BLOCK
SMS_ACTIVITY_CODE
SUPP_TRANSACTION_TYPE_CODE
SUPP_UNIT_TYPE_CODE
TABLE_CODE
TRACK_CODE
TRANSACTION_STATUS_CODE
TRANSACTION_TYPE_CODE
TX_PROPOSAL_STATUS_CODE
UNIT_STATUS_CODE
UNIT_TYPE_CODE
VERIFIED_EMISSION_STATUS_CODE
VISIBILITY_TYPE_CODE
WEB_SERVICE_OPERATION_CODE
INTERVENTION_CODE
CR2012_ACCOUNT_STATUS_CODE
CR2012_USER_ACC_ROLE_CODE
Tabel

CR2012_USER


Beskrivelse ?

List of users to be exported in the CSEUR

Størrelse (Antal rækker) ?

2971

Indhold (Kolonner/variable) ?

Navn Indhold
ID Identifier of the entry
ECAS_USERNAME ECAS username
ECAS_DOMAIN ECAS domain
PROPOSED_ECAS_USERNAME Proposed ECAS usermane in case the user does not have one yet
ECAS_USER_EMAIL Email link or to be linked to ecas account
ECAS_MOBILE_NUMBER_1 First mobile phone number for ECAS
ECAS_MOBILE_NUMBER_2 Second mobile phone number for ecas
ECAS_MOBILE_NUMBER_3 Third mobile phone number for ecas
ECAS_FIRST_NAME first name recorded in ecas
ECAS_LAST_NAME last name recorded in ecas
BIRTH_DATE birth date
BIRTH_PLACE birth place
BIRTH_COUNTRY birth country
CREDENTIALS_ID credentials id, credentials is ID document, passport etc.
CREDENTIALS_TYPE credentials type
CREDENTIALS_DESCRIPTION credentials description
CREDENTIALS_EXP_DATE expiry date of credentials
FIRST_NAME First name of user
LAST_NAME Last name of user
TITLE Title of the user
PREFERRED_LANGUAGE Preferred language of the user
SECRET_QUESTION Secret question of the user
SECRET_ANSWER Secret answer of the user
DELETED Flag indicating where the user has been deleted or no
PHONE_NUMBER Phone number of the user
PEOPLE_ID Identifier of the related people entry