Annex D Lookup Tables and Values
pport tables used in this technical specification. These
codes define the acceptable values for lookup tables in the ITL database.
Figure D1: List of Lookup Tables
Table
Description
Account Type Code
Identifies the type of unit accounts in a registry.
Check Catalog Code
Identifies the type of check.
Commitment Period Code
Identifies the current Commitment Period.
Computation Type Code
Describes aggregate computation types for a registry. Typical codes
identify a registrys Commitment Period Reserve and Allowable
Quantity.
Crediting Period Type Code
Identifies crediting period types.
Criteria Type Code
Identifies eligibility types.
Data Source Code
Identifies the source from which the data was submitted.
Eligibility Status Code
Identifies eligibility status.
LULUCF Activity Code
Identifies Land Use, Land Use Change, and Forestry categories.
Notification Status Code
Identifies status of a registry notification.
Notification Type Code
Identifies notification type codes.
Party Type Code
Defines the role of the Party.
Project Action Code
Identifies action taken by CDM Executive Board.
Project Status Code
Identifies Project status.
Project Type Code
Identifies the type of project.
Reconciliation Phase Code
Identifies the phase of reconciliation to be initiated.
Reconciliation Status Code
Identifies the status of a reconciliation process.
Registry Status Code
Identifies the operational status of a registry.
Responsibility Type Code
Identifies the type of responsibility a person has to a registry.
Route Status Code
Identifies the status of a message routing.
Test Status Code
Identifies the status of a test.
Test Type Code
Identifies the type of test.
(cont.)
Annex D ITL Software Specification, Version <1.0>, Draft #8
Page D-1
Figure D1: List of Lookup Tables (cont.)
Table
Description
Trade Scheme Code
Lookup table of trade schemes.
Transaction Status Code
Identifies the status of a transaction.
Transaction Type Code
Identifies the type of transaction.
Unit Status Code
Identifies whether the units have been flagged for processing.
Unit Type Code
Identifies the type of unit.
Figure D2: Account Type Code
Code
Description
100 Holding
Account
110
Pending Account (CDM registry only)
120 Operator
Holding
Account
121 Person
Holding
Account
210
Net Source Cancellation Account (Type 1) (national registries only)
220
Non-compliance Cancellation Account (Type 2) (national registries only)
230
Voluntary Cancellation Account (Type 3) (national registries only)
240
Excess Issuance Cancellation Account (Type 4) (CDM registry only)
250
Mandatory Cancellation Account (Type 5)
300 Retirement
Account
411
tCER Replacement Account for Expiry (Type 1)
421
lCER Replacement Account for Expiry (Type 1)
422
lCER Replacement Account for Reversal in Storage (Type 2)
423
lCER Replacement Account for Non-submission of Certification Report (Type 3)
Annex D ITL Software Specification, Version <1.0>, Draft #8
Page D-2
Figure D3: Check Catalog Code
Code
Description
1 Message
Viability
2 Registry
Validation
3 Data
Integrity
4
Message Sequence for Registry Messages
5
Message Sequence for STL Messages
6
Message Sequence for Reconciliation
7
General Transaction Checks
10 Issuance
20 Conversion
30 External
transfer
40 Cancellation
50 Replacement
60 Retirement
70 Carry-over
80
Expiry Date Change
100 Reconciliation
Data
Integrity
110
Reconciliation Message Sequence for Registry Messages
120
Reconciliation Message Sequence for STL Messages
130 Reconciliation
Checks
140 Registry
Messages
150 Administrative
Messages
Annex D ITL Software Specification, Version <1.0>, Draft #8
Page D-3
Figure D4: Commitment Period Code
Code
Description
0
Supplementary Program Commitment Period (2005 - 2007)
1
First Commitment Period
2
Second Commitment Period
3
Third Commitment Period
4
Fourth Commitment Period
Figure D5: Computation Type Code
Code
Description
1
Unit Type Issuance Level
2 Commitment
Period
Holdings
3 Reserve
Limit
4
Unit Type Issuance Limit
5 Carry-over
Limit
6 Retirement
Limit
7 Converted
Level
8 Carry-over
Level
9 Project
Issuance
Level
10 Retirement
Level
11
Track 2 ERU First-time Transfer Level
12
Adjusted Commitment Period Holdings
Figure D6: Crediting Period Type Code
Code
Description
1
Non-renewable - Maximum of 30 years
2
Renewable - Maximum of 20 years
Annex D ITL Software Specification, Version <1.0>, Draft #8
Page D-4
Figure D7: Criteria Type Code
Code
Description
1
Kyoto Protocol Party (Add 2, paragraph 21 (a))
2
Completion of Assigned Amount calculation (Add 2, paragraph 21(b))
3
National System in place (Add 2, paragraph 21 (c))
4
National registry in place (Add 2, paragraph 21 (d))
5
Submission of most recent required Inventory (Add 2, paragraph 21 (e))
6
Submission of supplementary information on Assigned Amount (Add 2, paragraph 21
(f))
7
Suspension of eligibility to make transfers
Figure D8: Data Source Type Code
Code
Description
1
ITL Data for Reconciliation
2
ITL Data for Yearly Aggregated Totals Report
3
Registry data provided during reconciliation.
Figure D9: Eligibility Status Code
Code
Description
1 Approved
2 Approved
by
default
3 Not
approved
4 Suspended
5 Unknown
Annex D ITL Software Specification, Version <1.0>, Draft #8
Page D-5
Figure D10: LULUCF Activity Code
Code
Description
1
Afforestation and reforestation
2 Deforestation
3 Forest
management
4 Cropland
management
5 Grazing
land
management
6 Revegetation
Figure D11: Notification Status Code
Code
Description
1 Initial
2 Incomplete
3 Complete
Figure D12: Notification Type Code
Code
Description
1
Net Source Cancellation
2 Non-compliance
Cancellation
3
Impending Expiry of tCER or lCER
4
Reversal of Storage for CDM Project
5
Non-submission of Certification Report for CDM Project
6
Excess Issuance for CDM Project
7
Commitment Period Reserve
8 Unit
Carry-over
9 Notification
Update
Annex D ITL Software Specification, Version <1.0>, Draft #8
Page D-6
Figure D13: Party Type Code
Code
Description
1 Initiating
Registry
2 Acquiring
Registry
Figure D14: Project Action Code
Code
Description
1 Approved
2 Suspended
3 Closed
4 Issuance
5 Conversion
6 Reversal
of
Storage
7
Non-submission of Certification Report
8
Renewal of Crediting Period
Figure D15: Project Status Code
Code
Description
1 Pending
2 Approved
3 Unknown
4 Not
approved
Figure D16: Project Type Code
Code
Description
1
Joint Implementation (JI)
2
Clean Development Mechanism (CDM)
Annex D ITL Software Specification, Version <1.0>, Draft #8
Page D-7
Figure D17: Reconciliation Phase Code
Code
Description
1 Totals
2 Unit
Block
Detail
3 Audit
Trail
Figure D18: Reconciliation Status Code
Code
Description
0 Confirmed
1 Initiated
2 Validated
3
ITL Totals Inconsistent
4
ITL Unit Blocks Inconsistent
5 ITL
Completed
6
ITL Completed with Manual Intervention
7
ITL Start Request Denied
8
STL Totals Inconsistent
9
STL Unit Blocks Inconsistent
10 STL
Validated
11
STL Completed with Manual Intervention
Figure D19: Registry Status Code
Code
Description
0 Full
Operation
1 Reconciliation
Only
2 Not
Operating
3 Closed
Annex D ITL Software Specification, Version <1.0>, Draft #8
Page D-8
Figure D20: Responsibility Type Code
Code
Description
1 Registry
Manager
2
Database Administrator/System Manager
3 Contact
Figure D21: Route Status Code
Code
Description
1
Sent to STL
2 Received
from
STL
Figure D22: Test Status Code
Code
Description
1 In
Progress
2 Failed
3 Passed
4 Abandoned
Annex D ITL Software Specification, Version <1.0>, Draft #8
Page D-9
Figure D23: Test Type Code
Code
Description
1 Communication
Initialization
2 Website
Access
3 Information
Retrieval
4 Issuance
5 Conversion
6 Internal
Transfer
7 External
Transfer
8 Cancellation
9 Retirement
10 Carry-over
11 Replacement
12
Expiry Date Change
13 Reconciliation
Figure D24: Tickler Type Code
Code
Description
1 General
2 Transaction
3 Reconciliation
4 Notification
5 Reporting
6 Administrative
Figure D25: Trade Scheme Code
Code
Description
1
European Commission GHG Trading
Annex D ITL Software Specification, Version <1.0>, Draft #8
Page D-10
Figure D26: Transaction Status Code
Code
Description
1 Proposed
2
Checked (No Discrepancy)
3 Checked
(Discrepancy)
4 Completed
5 Terminated
6 Rejected
7 Cancelled
8 Accepted
9
STL Checked (No Discrepancy)
10 STL
Checked
(Discrepancy)
Figure D27: Transaction Type Code
Code
Description
1
Issuance - Initial creation of a unit
2
Conversion - Transformation of unit to create an ERU
3
External - External transfer of unit between registries
4
Cancellation - Internal transfer of unit
5
Retirement - Internal transfer of unit
6
Replacement - Internal transfer of unit
7
Carry-over - Change of validity to subsequent Commitment Period
8
Expiry Date Change
10
Internal - Internal transfer of unit/supplementary program transaction
Annex D ITL Software Specification, Version <1.0>, Draft #