Oracle Designer

Report : ENTITY DEFINITION

Filename : D:\DOCUME~1\BARTNI~1.000\LOCALS~1\Temp\ckr7E.tmp.html

Run by : DES

Report Date : 20 September 2009

Total Pages : 63

Parameter Values

Workarea : GLOBAL SHARED WORKAREA

Container : BBS

Container Version:

N

Recurse Sub-Containers :

Entity Name : %

Include Notes : Yes

ER Diagram :

Entities Created

On/After :

On/Before : 20 September 2009

and

Entities Changed

On/After :

On/Before : 20 September 2009

20 September 2009 Page 2 of 63

Entity Definition

Container: BBS Version:

Entity

Name : ACC CUR PREF STEP

Short Name : ACS

Plural Name : ACC CUR PREF STEPS

Initial Volume : 250 Average Volume : 2500

Maximum Volume : 250000

Description

An Acc Cur Pref Step is a step in the Currency conversion process of the Account Cur Preference. The first step starts with the offered Currency while the last step ends with the requested Currency.

Notes

Examples( id, ACP-id, step, CRY-code offered, CRY-code requested )
- 1211, 1, 401, US.FL.MMD, US.FLD;
- 1212, 2, 401, US.FLD, US.OHD;
- 1213, 3, 401, US.OHD, US.OH.DTW;
- 1214, 1, 402, US.FL.MMD, USN;
- 1215, 2, 402, USN, US.OH.DTW;
- 1216, 1, 403, NL.SNF, NLN;
- 1217, 2, 403, NLN, USN;
- 1218, 3, 403, USN, US.FL.MMD;

Attributes * - Attributes in primary unique identifier

Name Domain Opt Format Length Scale

* ID ID09 N NUMBER 9 ,0

STEP RANKING N INTEGER 4

Relationships * - Relationships in primary unique identifier

Each Occurrence Of This Entity :

MUST BE AHR offers one and only one CURRENCY

MUST BE of one and only one ACCOUNT CUR PREFERENCE

MUST BE AHR requests one and only one CURRENCY

Oracle Designer Report : ckentdef

20 September 2009 Page 3 of 63

Entity Definition

Container: BBS Version:

Unique Identifiers

Name Primary? Attrib.Name Relationship To Entity Name

ACS Yes ID

ACS U01 No STEP

of ACCOUNT CUR PREFERENCE

ACS U02 No AHR requests CURRENCY

of ACCOUNT CUR PREFERENCE

ACS U03 No AHR offers CURRENCY

of ACCOUNT CUR PREFERENCE

Oracle Designer Report : ckentdef

20 September 2009 Page 4 of 63

Entity Definition

Container: BBS Version:

Entity

Name : ACCOUNT

Short Name : ACT

Plural Name : ACCOUNTS

Initial Volume : 1000 Average Volume : 10000

Maximum Volume : 1000000

Description

An Account is an Account at the bank which may contain balances of money in one or more Account Currencies. The Account Type of the Account determines the rights and obligations of the Account.

Notes

Examples( id, ATE-code, AHR-username, name, has base CRY-code, begindate, status, description, contractual enddate, enddate )
- 24191, CRACT, JHBAKE, JHBAKE1210, USN, 12-NOV-2011, O, -, -, -;
- 24192, CRACT, PHBROW, PHBROW0099, USN, 14-NOV-2011, O, -, -, -;
- 24193, CLACT, MIABAN, MIABAN1111, US.FL.MMD, 15-NOV-2011, O, Holding Tax, -, -;
- 24194, HTACT, MIACIT, MIACIT4389, US.FL.MMD, 15-NOV-2011, O, Holding Tax, -, -;

Attributes * - Attributes in primary unique identifier

Name Domain Opt Format Length Scale

ACCOUNT NUMBER ACCOUNT NUMBER N INTEGER 12

BEGINDATE DATE N DATE

* ID ID12 N NUMBER 12 ,0

NAME ACCOUNT NAME SHORT N CHAR 10

STATUS ACCOUNT STATUS N CHAR 1

CONTRACTUAL ENDDATE DATE Y DATE

DESCRIPTION NAME SHORT Y CHAR 40

ENDDATE DATE Y DATE

Relationships * - Relationships in primary unique identifier

Each Occurrence Of This Entity :

MAY BE has contra account one and only one ACCOUNT

MAY BE has one or more ACCOUNT NAME ALIASES

MAY BE has one or more BANK STATEMENTS

MAY BE is contra account of one or more ACCOUNTS

MAY BE of one or more ACCOUNT HOLDINGS

Oracle Designer Report : ckentdef

20 September 2009 Page 5 of 63

Entity Definition

Container: BBS Version:

MAY BE uses one or more ACCOUNT CURRENCIES

MUST BE has base currency one and only one CURRENCY

MUST BE has one or more LEGAL DOCUMENTS

MUST BE is of one and only one ACCOUNT TYPE

Unique Identifiers

Name Primary? Attrib.Name Relationship To Entity Name

ACT Yes ID

ACT U01 No NAME

Oracle Designer Report : ckentdef

20 September 2009 Page 6 of 63

Entity Definition

Container: BBS Version:

Entity

Name : ACCOUNT CUR BALANCE

Short Name : ACB

Plural Name : ACCOUNT CUR BALANCES

Initial Volume : 25000 Average Volume : 250000

Maximum Volume : 25000000

Description

An Account Currency Balance (ACB) represents the amount of money of a specific Account Currency (balance) in the Account at a specific moment (balance date).

Notes

Examples( id, balance date, registration date, ACY-code, jdc, balance journal, edc, balance effect )
- 717791, 22-NOV-2012, 23-NOV-2012 22:12:12, JHBAKE1210, USN, C, 707.12, C, 707.12;
- 717792, 22-NOV-2012, 23-NOV-2012 22:12:12, JHBAKE1210, US.FLD, C, 1181.55, C, 1181.55;
- 717793, 22-NOV-2012, 23-NOV-2012 22:12:12, JHBAKE1210, US.FL.MMD, C, 0.02, C, 0.02;
- 717794, 22-NOV-2012, 23-NOV-2012 22:12:12, PHBROW0099, US.FL.MMD, C, 564.00, C, 564.00;
- 717795, 22-NOV-2012, 23-NOV-2012 22:12:13, PHBROW0099, US.OHD, C, 1732.76, C, 1689.07;
- 717796, 22-NOV-2012, 23-NOV-2012 22:12:13, MIACIT4389, US.FL.MMD, C, 11298.33, C, 11274.19;

Attributes * - Attributes in primary unique identifier

Name Domain Opt Format Length Scale

BALANCE DATE DATE N DATE

BALANCE EFFECT AMOUNT OF MONEY N NUMBER 12 ,2

BALANCE JOURNAL AMOUNT OF MONEY N NUMBER 12 ,2

* ID ID12 N NUMBER 12 ,0

REGISTRATION DATE DATETIME N DATE

Relationships * - Relationships in primary unique identifier

Each Occurrence Of This Entity :

MAY BE is begin balance of one and only one BANK STATEMENT

MAY BE is end balance of one and only one BANK STATEMENT

MUST BE is in one and only one ACCOUNT CURRENCY

Oracle Designer Report : ckentdef

20 September 2009 Page 7 of 63

Entity Definition

Container: BBS Version:

Unique Identifiers

Name Primary? Attrib.Name Relationship To Entity Name

ABE Yes ID

ABE U01 No BALANCE DATE

is in ACCOUNT CURRENCY

Oracle Designer Report : ckentdef

20 September 2009 Page 8 of 63

Entity Definition

Container: BBS Version:

Entity

Name : ACCOUNT CUR PREFERENCE

Short Name : ACP

Plural Name : ACCOUNT CUR PREFERENCES

Initial Volume : 100 Average Volume : 1000

Maximum Volume : 100000

Description

An Account Currency Preference represents a preference in exchanging an offered Currency for a demanded Currency. Account Currency Preferences are set by the Account Holder if the Account Holder is not satisfied with the default Currency Preferences of the Bank.

Notes

Examples( id, ACY-code offered, CRY-code requested, begindate, ranking, maximum spread, maximum price, enddate )
- 401, US.FL.MMD, US.OH.DTW, 01-FEB-2011, 1, 1.5, 2.4,;
- 402, US.FL.MMD, US.OH.DTW, 01-FEB-2011, 2, 1.7, 2.6,;
- 403, NL.SNF, US.FL.MMD, 01-MAR-2011, 1, 2.2, 0.0625,;

Attributes * - Attributes in primary unique identifier

Name Domain Opt Format Length Scale

BEGINDATE DATE N DATE

* ID ID09 N NUMBER 9 ,0

MAXIMUM RATE RATE N NUMBER 12 ,5

RANKING RANKING N INTEGER 4

ENDDATE DATE Y DATE

MAXIMUM PRICE RATE Y NUMBER 12 ,5

Relationships * - Relationships in primary unique identifier

Each Occurrence Of This Entity :

MUST BE AHR offers one and only one ACCOUNT CURRENCY

MUST BE has one or more ACC CUR PREF STEPS

MUST BE AHR requests one and only one CURRENCY

Oracle Designer Report : ckentdef

20 September 2009 Page 9 of 63

Entity Definition

Container: BBS Version:

Unique Identifiers

Name Primary? Attrib.Name Relationship To Entity Name

ACP Yes ID

ACP U01 No RANKING

AHR offers ACCOUNT CURRENCY

AHR requests CURRENCY

Oracle Designer Report : ckentdef

20 September 2009 Page 10 of 63

Entity Definition

Container: BBS Version:

Entity

Name : ACCOUNT CURRENCY

Short Name : ACY

Plural Name : ACCOUNT CURRENCIES

Initial Volume : 2500 Average Volume : 25000

Maximum Volume : 2500000

Description

An Account Currency represents a Currency that can be used in the Account. Banks may offer multiple Account Currencies to be used for an Account Type.

Notes

Examples( id, ACT-name, CRY-code, begindate, ind fee contra account, int calc amount, int calc date, calculation startdate, balance calculation date, base correction amount, enddate ):
- 796, JHBAKE1210, USN, 25-NOV-2011, N, N, 707.12, 01-NOV-2012,,;
- 797, JHBAKE1210, US.FLD, 25-NOV-2011, N, N, 1181.55, 01-NOV-2012, 12-OCT-2012;
- 798, JHBAKE1210, US.FL.MMD, 26-NOV-2011, N, N, 0.02, 01-NOV-2012,;
- 799, PHBROW0099, US.FL.MMD, 26-NOV-2011, N, N, 564.00, 01-NOV-2012,;
- 800, PHBROW0099, US.OHD, 26-NOV-2011, N, N, 1732.76, 01-NOV-2012,;
- 801, MIACIT4389, US.FL.MMD, 27-NOV-2011, N, N, 11298.33, 01-NOV-2012,;

Attributes * - Attributes in primary unique identifier

Name Domain Opt Format Length Scale

BEGINDATE DATE N DATE

* ID ID12 N NUMBER 12 ,0

IND FEE CONTRA ACCOUNT YES NO N CHAR 1

STATUS ACCOUNT STATUS N CHAR 2

BALANCE CALCULATION DATE DATE Y DATE

Account Currency Balances for the Account Currency before this date have been correctly calculated. The balance calculation date may be changed when Transactions are added with a date effect before the balance calculation date. The balances effect of all Account Currency Balances after the balance calculation date have to be recalculated.

BASE CORRECTION AMOUNT AMOUNT OF MONEY Y NUMBER 18 ,2

The base correction amount may be used when an Account Holder has loaned a sum of money in the Account Currency to have additional spending room in the current account. Because it is not possible to have a negative balance in the current account, a separate loan agreement has to be made. The base correction amount can be set to the amount of money loaned, so the Account Holder can see the negative balance on the current account.

CALCULATION STARTDATE DATE Y DATE

The calculation startdate can be used to support holding tax or compensation calculations for the Account Currency. Holding tax or compensation for the

Oracle Designer Report : ckentdef

20 September 2009 Page 11 of 63

Entity Definition

Container: BBS Version:

Account Currency before this date has been correctly calculated and paid. The calculation startdate can be changed when Transactions are added with a date effect before the calculation startdate or when a Holding Tax Rate or Compensation Rate is changed with a begindate before the calculation startdate.

ENDDATE DATE Y DATE

INT CALC AMOUNT AMOUNT OF MONEY Y NUMBER 12 ,2

INT CALC DATE DATE Y DATE

Relationships * - Relationships in primary unique identifier

Each Occurrence Of This Entity :

MAY BE has one or more SPECIFIC RATES

MAY BE has one or more TRANSACTIONS

MAY BE is offered one or more ACCOUNT CUR PREFERENCES

MAY BE of one or more ACCOUNT CUR BALANCES

MUST BE is used in one and only one ACCOUNT

MUST BE uses one and only one CURRENCY

Unique Identifiers

Primary?

Attrib.Name

Relationship

To Entity Name

Name

ACY Yes ID

ACY U01 No is used in ACCOUNT

uses CURRENCY

Oracle Designer Report : ckentdef

20 September 2009 Page 12 of 63

Entity Definition

Container: BBS Version:

Entity

Name : ACCOUNT HOLDER

Short Name : AHR

Plural Name : ACCOUNT HOLDERS

Synonyms : BANK CUSTOMER

Initial Volume : 250 Average Volume :

Maximum Volume : 250000

2500

Description

An Account Holder is a natural person or a corporation that holds an Account at the Bank or is a Representative of another Account Holder.

Notes

Examples( id, username, legal person type, gender, status, ind under guardianship, birth or consitution date, begindate, name or last name, first name, initials, death or closing date, enddate ):
- 981, JHBAKE, N, M, A, N, 22-AUG-1984, 01-NOV-2011, Baker, John, JH,,;
- 982, PHBROW, N, F, A, N, 10-APR-1960, 01-NOV-2011, Brown, Phoebe, PDT,,;
- 983, MIABAN, C, N, A, D, 11-OCT-2011, 01-NOV-2011, Miami Bank,,,,;
- 984, MIACIT, C, N, A, D, 01-JAN-1950, 01-NOV-2011, Miami City Counsil,,,,;

Attributes * - Attributes in primary unique identifier

Name Domain Opt Format Length Scale

BEGINDATE DATE N DATE

BIRTH OR CONSTITUTION DATE DATE N DATE

GENDER GENDER N CHAR 1

* ID ID12 N NUMBER 12 ,0

IND UNDER GARDIANSHIP YES NO DNA N CHAR 1

LEGAL PERSON TYPE LEGAL PERSON TYPE N CHAR 1

NAME OR LAST NAME NAME LONG N CHAR 80

STATUS ACCOUNT HOLDER STATUS N CHAR 1

USERNAME USERNAME N CHAR 30

CREDIT SCORE CREDIT SCORE Y NUMBER 5 ,0

DEATH OR CLOSING DATE DATE Y DATE

ENDDATE DATE Y DATE

FIRST NAME NAME SHORT Y CHAR 40

INITIALS INITIALS Y CHAR 7

Oracle Designer Report : ckentdef

20 September 2009 Page 13 of 63

Entity Definition

Container: BBS Version:

LOAN LIMIT AMOUNT OF MONEY Y NUMBER 18 ,2

MORTGAGE LIMIT AMOUNT OF MONEY Y NUMBER 18 ,2

Relationships * - Relationships in primary unique identifier

Each Occurrence Of This Entity :

MAY BE has one and only one CREDIT QUALITY

MAY BE has one or more ACCOUNT HOLDINGS

MAY BE has one or more HOLDER ADRESSES

MAY BE has one or more REPRESENTATIVES

MAY BE is one or more REPRESENTATIVES

MAY BE is user for one and only one USER

MAY BE of one or more MESSAGES

MUST BE has one or more NATIONALITIES

Unique Identifiers

Name Primary? Attrib.Name Relationship To Entity Name

AHR Yes ID

AHR U01 No USERNAME

Oracle Designer Report : ckentdef

20 September 2009 Page 14 of 63

Entity Definition

Container: BBS Version:

Entity

Name : ACCOUNT HOLDING

Short Name : AHG

Plural Name : ACCOUNT HOLDINGS

Initial Volume : 300 Average Volume : 3000

Maximum Volume : 300000

Description

An Account Holding represents an Account Holder holding an Account at a Bank.

Notes

Examples( id, AHR-username, ACT-name, begindate, enddate )
- 928, JHBAKE, JHBAKE1210, 12-NOV-2011,;
- 929, PHBROW, PHBROW0099, 14-NOV-2011,;
- 930, MIABAN, MIABAN1111, 15-NOV-2011,;
- 931, MIACIT, MIACIT4389, 15-NOV-2011,;

Attributes * - Attributes in primary unique identifier

Name Domain Opt Format Length Scale

BEGINDATE DATE N DATE

* ID ID12 N NUMBER 12 ,0

ENDDATE DATE Y DATE

Relationships * - Relationships in primary unique identifier

Each Occurrence Of This Entity :

MUST BE of one and only one ACCOUNT HOLDER

MUST BE has one and only one ACCOUNT

Unique Identifiers

Name Primary? Attrib.Name Relationship To Entity Name

AHG Yes ID

AHG U01 No BEGINDATE

has ACCOUNT

of ACCOUNT HOLDER

Oracle Designer Report : ckentdef

20 September 2009 Page 15 of 63

Entity Definition

Container: BBS Version:

Entity

Name : ACCOUNT NAME ALIAS

Short Name : ANA

Plural Name : ACCOUNT NAME ALIASES

Initial Volume : 250 Average Volume : 2500

Maximum Volume : 250000

Description

An Account Name Alias is a name that refers to an Account and can be referred to in payments to the Account.

Notes

Examples( id, ACT-name, name ):
- 27793, PHBROW1221, PHBJDO2431;
- 27794, PHBROW1221, PHBROW5741;

Attributes * - Attributes in primary unique identifier

Name Domain Opt Format Length Scale

* ID ID12 N NUMBER 12 ,0

NAME ACCOUNT NAME SHORT N CHAR 10

Relationships * - Relationships in primary unique identifier

Each Occurrence Of This Entity :

MUST BE of one and only one ACCOUNT

Unique Identifiers

Name Primary? Attrib.Name Relationship To Entity Name

ANA Yes ID

ANA U01 No NAME

Oracle Designer Report : ckentdef

20 September 2009 Page 16 of 63

Entity Definition

Container: BBS Version:

Entity

Name : ACCOUNT TYPE

Short Name : ATE

Plural Name : ACCOUNT TYPES

Initial Volume : 5 Average Volume : 50

Maximum Volume : 500

Description

An Account Type is a product in the banking world. An Account Type identifies the handling of the account in detail, such as the Compensation Rate and the Currencies for which the Account Type is available.

Notes

Examples ( id, code, begindate, account super type, compensation type, ind discontinuable, ind depositable, ind only contra account, ind contractual enddate, name, duration, duration unit, enddate ):
- 11, CLACT, 01-DEC-2011, N, D, D, D, D, D, Collection Account,,,;
- 12, CPACC, 01-JUL-2011, N, D, D, D, D, D, Compensation Account,,,;
- 13, CRACT, 01-DEC-2011, C, N, D, D, D, D, Current Account,,,;
- 14, FLMGE, 01-DEC-2011, L, N, Y, D, Y, N, Flexible Mortgage,,,;
- 15, FLSAA, 01-DEC-2011, S, C, Y, Y, Y, N, Flexible Savings Account,,,;
- 16, HTACT, 01-DEC-2011, H, D, D, D, D, D, Holding Tax Account,,,;
- 17, SL20Y, 01-DEC-2011, L, N, Y, N, N, Y, Student loan 20 Year, 20, Year,;
- 18, TD10Y, 01-JAN-2012, S, S, N, N, Y, Y, Time Deposit 10 Year, 10, Year,;
- 19, FM30Y, 01-DEC-2011, L, N, N, D, Y, Y, Fixed Mortgage 30 Year, 30, Year,;

Attributes * - Attributes in primary unique identifier

Name Domain Opt Format Length Scale

ACCOUNT SUPERTYPE ACCOUNT SUPERTYPE N CHAR 1

BEGINDATE DATE N DATE

CODE CODE ACCOUNT TYPE N CHAR 8

COMPENSATION TYPE COMPENSATION TYPE N CHAR 1

* ID ID06 N NUMBER 6 ,0

IND CONTRACTUAL ENDDATE YES NO DNA N CHAR 1

IND DEPOSITABLE YES NO DNA N CHAR 1

IND DISCONTINUABLE YES NO DNA N CHAR 1

IND ONLY CONTRA ACCOUNT YES NO DNA N CHAR 1

NAME NAME SHORT N CHAR 40

DURATION TIME VALUE Y INTEGER 5

DURATION UNIT TIME UNIT Y CHAR 1

Oracle Designer Report : ckentdef

20 September 2009 Page 17 of 63

Entity Definition

Container: BBS Version:

ENDDATE DATE Y DATE

Relationships * - Relationships in primary unique identifier

Each Occurrence Of This Entity :

MAY BE has one or more ACCOUNT TYPE CURRENCIES

MAY BE of one or more ACCOUNTS

MUST BE has one or more ACCOUNT TYPE LEDGERS

Unique Identifiers

Name Primary? Attrib.Name Relationship To Entity Name

ATE Yes ID

ATE U01 No CODE

ATE U02 No NAME

Oracle Designer Report : ckentdef

20 September 2009 Page 18 of 63

Entity Definition

Container: BBS Version:

Entity

Name : ACCOUNT TYPE CURRENCY

Short Name : ATC

Plural Name : ACCOUNT TYPE CURRENCIES

Initial Volume : 10 Average Volume : 100

Maximum Volume : 1000

Description

Account Type Currency determines which Currencies are allowed for a specific Account Type and how they should be handled.

Notes

Examples ( id, ATE-code, CRY-code, begindate, minimum amount, maximum amount, enddate ):
- 113, CRACT, USN, 01-DEC-2011,,,;
- 114, CRACT, US.FLD, 01-DEC-2011,,,;
- 115, CRACT, US.FL.MMD, 01-DEC-2011,,,;
- 116, FLMGE, USN, 01-DEC-2011, 1000,,;
- 117, HTACT, US.FL.MMD, 01-DEC-2011,,,;
- 118, SL20Y, US.FLD, 01-DEC-2011,2500,30000,;
- 119, TD10Y, US.FLD, 01-JAN-2012,10000,,;

Attributes * - Attributes in primary unique identifier

Name Domain Opt Format Length Scale

BEGINDATE DATE N DATE

* ID ID09 N NUMBER 9 ,0

ENDDATE DATE Y DATE

MAXIMUM AMOUNT AMOUNT OF MONEY Y NUMBER 12 ,2

MINIMUM AMOUNT AMOUNT OF MONEY Y NUMBER 12 ,2

Relationships * - Relationships in primary unique identifier

Each Occurrence Of This Entity :

MAY BE has one or more COMPENSATION RATES

MUST BE of one and only one ACCOUNT TYPE

MUST BE has one and only one CURRENCY

Oracle Designer Report : ckentdef

20 September 2009 Page 19 of 63

Entity Definition

Container: BBS Version:

Unique Identifiers

Name Primary? Attrib.Name Relationship To Entity Name

ATC Yes ID

ATC U01 No BEGINDATE

has CURRENCY

of ACCOUNT TYPE

Oracle Designer Report : ckentdef

20 September 2009 Page 20 of 63

Entity Definition

Container: BBS Version:

Entity

Name : ACCOUNT TYPE LEDGER

Short Name : ATL

Plural Name : ACCOUNT TYPE LEDGERS

Initial Volume : 10 Average Volume : 100

Maximum Volume : 1000

Description

Account Type Ledger defines the General Ledger for all the Transactions of all the Accounts of the Account Type.

Notes

Examples ( id, ATE-code, GLR-code, begindate, enddate ):
- 21, CRACT, ACCUR, 01-JAN-2011,;
- 22, FLMGE, ACMGG, 01-JAN-2011,;
- 23, FM30Y, ACMGG, 01-JAN-2011,;
- 24, HTACT, ACHTX, 01-JAN-2011,;

Attributes * - Attributes in primary unique identifier

Name Domain Opt Format Length Scale

BEGINDATE DATE N DATE

* ID ID09 N NUMBER 9 ,0

ENDDATE DATE Y DATE

Relationships * - Relationships in primary unique identifier

Each Occurrence Of This Entity :

MUST BE for one and only one GENERAL LEDGER

MUST BE for one and only one ACCOUNT TYPE

Unique Identifiers

Name Primary? Attrib.Name Relationship To Entity Name

ALR Yes ID

ALR U01 No BEGINDATE

for GENERAL LEDGER

for ACCOUNT TYPE

Oracle Designer Report : ckentdef

20 September 2009 Page 21 of 63

Entity Definition

Container: BBS Version:

Entity

Name : ADDRESS

Short Name : ADS

Plural Name : ADRESSES

Initial Volume : 500 Average Volume : 5000

Maximum Volume : 500000

Description

An Address uniquely identifies the location of a house or an office.

Notes

Examples ( id, CTY-code, SOP-code, begindate, date verified, postal code, street location, address line 1, address line 2, city, enddate ):
242110, US, FL, 11-NOV-2011, 11-NOV-2011 11:11:11, 33133, 3027, 3027 South West 28th Street, Miami FL 33133, Miami,;
242111, US, FL, 11-NOV-2011, 11-NOV-2011 11:33:21, 33139, 1752, 1752 Bay Road, Miami Beach FL 33139, Miami Beach,;
242112, US, FL, 11-NOV-2011, 11-NOV-2011 11:43:12, 33146, 3802, 3802 Shipping Avenue, Miami FL 33146, Miami,;

Attributes * - Attributes in primary unique identifier

Name Domain Opt Format Length Scale

BEGINDATE DATE N DATE

* ID ID12 N NUMBER 12 ,0

ADDRESS LINE 1 ADDRESS LINE Y CHAR 80

ADDRESS LINE 2 ADDRESS LINE Y CHAR 80

CITY ADDRESS LINE Y CHAR 80

DATE VERIFIED DATETIME Y DATE

ENDDATE DATE Y DATE

POSTAL CODE POSTAL CODE Y CHAR 15

STREET LOCATION STREET LOCATION Y CHAR 15

Relationships * - Relationships in primary unique identifier

Each Occurrence Of This Entity :

MAY BE is in one and only one STATE OR PROVINCE

MAY BE of one or more HOLDER ADRESSES

MUST BE is in one and only one COUNTRY

Oracle Designer Report : ckentdef

20 September 2009 Page 22 of 63

Entity Definition

Container: BBS Version:

Unique Identifiers

Name Primary? Attrib.Name Relationship To Entity Name

ADS Yes ID

Oracle Designer Report : ckentdef

20 September 2009 Page 23 of 63

Entity Definition

Container: BBS Version:

Entity

Name : BANK

Short Name : BNK

Plural Name : BANKS

Initial Volume : 10000 Average Volume : 100000

Maximum Volume : 1000000

Description

A bank is an organisation that performs banking activities in the Natural Financial System under Natural Financial System legislation. A Bank must be a corporation residing in a Country. A bank can only have operations in one Country.

Notes

Examples ( id, (belongs to Country-code), account code, name, begindate, email address, email address2, contact, enddate ):
- 4140, CA, OTTAMAPL, Ottawa Maple Bank, 01-JUL-2012, trn@ottamapl.ca, trn2@ottamapl.ca, John Fingers, Room 205, phone: 401-1121098,;
- 4141, US, MIAMBANK, Miami Bank, trans@miambank.us, tran2@miambank.us, 01-JUL- 2011, Joe Sixpack, phone 322-5498231,;
- 4142, US, WESTAMPA, West Tampa Bank, 01-JUL-2011, trans@westampa.us, tran2@westampa.us, Sandra Oak, Room 8-17, phone: 319-8774321,;

Attributes * - Attributes in primary unique identifier

Name Domain Opt Format Length Scale

BANK CODE BANK ACCOUNT CODE N CHAR 8

BEGINDATE DATE N DATE

CONTACT CONTACT DATA N CHAR 2000

EMAIL ADDRESS EMAIL ADDRESS N CHAR 120

EMAIL ADDRESS2 EMAIL ADDRESS N CHAR 120

* ID ID09 N NUMBER 9 ,0

NAME NAME SHORT N CHAR 40

ENDDATE DATE Y DATE

Relationships * - Relationships in primary unique identifier

Each Occurrence Of This Entity :

MAY BE is contra bank of one or more TRANSACTIONS

MAY BE of one or more MESSAGES

MUST BE belongs to one and only one COUNTRY

Oracle Designer Report : ckentdef

20 September 2009 Page 24 of 63

Entity Definition

Container: BBS Version:

Unique Identifiers

Name Primary? Attrib.Name Relationship To Entity Name

BNK Yes ID

BNK U01 No BANK CODE

belongs to COUNTRY

Oracle Designer Report : ckentdef

20 September 2009 Page 25 of 63

Entity Definition

Container: BBS Version:

Entity

Name : BANK STATEMENT

Short Name : BST

Plural Name : BANK STATEMENTS

Synonyms : ACCOUNT STATEMENT

Initial Volume : 100000 Average Volume :

Maximum Volume : 50000000

500000

Description

A Bank Statement is a summary of all financial transactions occurring over a given period of time on a savings account, a current account, or any other type of account offered by a financial institution.

Notes

Examples ( id, ACT-name, year, seqno, has begin balance ACB-balance date, ACY- CRY-code, jdc, balance journal, has end balance ACB-balance date, ACY-CRY-code, jdc, balance journal ):
- 64429, PHBROW0099, 2012, 11, 31-MAY-2012, USN, C, 2009.00, 14-JUN-2012, USN, C, 2212.96;
- 64430, PHBROW0099, 2012, 11, 31-MAY-2012, US.OHD, C, 913.16, 14-JUN-2012, US.OHD, C, 913.16;
- 64431, PHBROW0099, 2012, 12, 14-JUN-2012, USN, C, 2212.96, 28-JUN-2012, USN, C, 1653.48;
- 64432, PHBROW0099, 2012, 12, 14-JUN-2012, US.OHD, C, 913.16, 28-JUN-2012, US.OHD, C, 1253.41;

Attributes * - Attributes in primary unique identifier

Name Domain Opt Format Length Scale

* ID ID15 N NUMBER 15 ,0

SEQNO BANK STATEMENT SEQNO N NUMBER 4 ,0

YEAR YEAR N INTEGER 4

Relationships * - Relationships in primary unique identifier

Each Occurrence Of This Entity :

MAY BE contains one or more TRANSACTIONS

MUST BE has end balance one or more ACCOUNT CUR BALANCES

MUST BE of one and only one ACCOUNT

MUST BE has begin balance one or more ACCOUNT CUR BALANCES

Oracle Designer Report : ckentdef

20 September 2009 Page 26 of 63

Entity Definition

Container: BBS Version:

Unique Identifiers

Name Primary? Attrib.Name Relationship To Entity Name

BST Yes ID

BST U01 No SEQNO

YEAR

of ACCOUNT

Oracle Designer Report : ckentdef

20 September 2009 Page 27 of 63

Entity Definition

Container: BBS Version:

Entity

Name : COMPENSATION RATE

Short Name : CRE

Plural Name : COMPENSATION RATES

Initial Volume : 100 Average Volume : 1000

Maximum Volume : 10000

Description

The Compensation Rate is used to determine the fee the the bank accepts for intermediary costs for all Account Currencies of a specific Account Type Currency. The Compensation Rate is only applied on savings and guarantee money.

Notes

Examples ( id, ATC-ATE-code, ATC-CRY-code, begindate, rate, computing interval, calculation scheme, disc rate type, discontinuation rate, enddate ):
- 242, FLSAA, USN, 01-JUL-2011, 0.25, M, M, F, 1.00, 01-JUL-2014;
- 243, LCSAA, USN, 01-JAN-2011, 0.33, Y, R,,,01-JAN-2012;
- 244, LCSAA, US.FLD, 01-JAN-2011, 0.4, Y, R,,,01-JAN-2012;
- 245, LCSAA, USN, 01-JAN-2012, 0.3, Y, R,,,;
- 246, LCSAA, US.FLD, 01-JAN-2012, 0.35, Y, R,,,;

Attributes * - Attributes in primary unique identifier

Name Domain Opt Format Length Scale

BEGINDATE DATE N DATE

CALCULATION SCHEME CALCULATION SCHEME N CHAR 1

COMPUTING INTERVAL COMPUTING INTERVAL N CHAR 1

DISC RATE TYPE DISCONTINUATION RATE TYPE N CHAR 1

DISCONTINUATION RATE RATE N NUMBER 12 ,5

* ID ID09 N NUMBER 9 ,0

RATE RATE N NUMBER 12 ,5

ENDDATE Y DATE

Enddate is helpful in processing Compensation Rates because the next instance of Compensation Rate does not have to be evaluated when determining the enddate.

Relationships * - Relationships in primary unique identifier

Each Occurrence Of This Entity :

MUST BE for one and only one ACCOUNT TYPE CURRENCY

Oracle Designer Report : ckentdef

20 September 2009 Page 28 of 63

Entity Definition

Container: BBS Version:

Unique Identifiers

Name Primary? Attrib.Name Relationship To Entity Name

CRE Yes ID

CRE U01 No BEGINDATE

for ACCOUNT TYPE CURRENCY

Oracle Designer Report : ckentdef

20 September 2009 Page 29 of 63

Entity Definition

Container: BBS Version:

Entity

Name : COUNTRY

Short Name : CTY

Plural Name : COUNTRIES

Initial Volume : 200 Average Volume : 200

Maximum Volume : 200

Description

A Country is a state of which legal citizenship can be attained. A Country can host natural persons and corporations. A country has a government which may get reports out of the BBS because of legal and regulartory requirements. Those reports will be sent using email.

Notes

Examples ( id, code, name, begindate, ind transnational, address system, government, email address, email address2, contact, postal code format, years of age, enddate ):
- 17, CA, Canada, 01-JUL-1867, N, P, Treasury Board of Canada Secretariat, banking@tbs-sct.gc.ca, controller@tbs-sct.gc.ca, <address and contact info>, A9A9A9, 19,;
- 117, NL, Netherlands, 16-MAR-1815, N, P, Ministerie van Financiën, banking@minfin.nl, oversight@minfin.nl, <address and contact info>, 9999AA, 18,;
- 177, US, United States, 04-JUL-1776, N, P, U.S. Department of the Treasury, banking@ustreas.gov, office@ustreas.gov, <address and contact info>, 99999, 18,;

Attributes * - Attributes in primary unique identifier

Name Domain Opt Format Length Scale

ADDRESS SYSTEM ADDRESS SYSTEM N CHAR 1

BEGINDATE DATE N DATE

CODE CODE COUNTRY N CHAR 2

CONTACT CONTACT DATA N CHAR 2000

EMAIL ADDRESS EMAIL ADDRESS N CHAR 120

EMAIL ADDRESS2 EMAIL ADDRESS N CHAR 120

GOVERNMENT NAME SHORT N CHAR 40

* ID ID06 N NUMBER 6 ,0

IND TRANSNATIONAL YES NO N CHAR 1

NAME NAME SHORT N CHAR 40

ENDDATE DATE Y DATE

POSTAL CODE FORMAT POSTAL CODE Y CHAR 15

YEARS OF AGE YEARS OF AGE Y NUMBER 3

Oracle Designer Report : ckentdef

20 September 2009 Page 30 of 63

Entity Definition

Container: BBS Version:

Relationships * - Relationships in primary unique identifier

Each Occurrence Of This Entity :

MAY BE govt has one or more MESSAGES

MAY BE has jur. over one or more CURRENCIES

MAY BE has national currency one and only one CURRENCY

MAY BE has one or more STATES AND PROVINCES

MAY BE has one or more BANKS

MAY BE has one or more NATIONALITIES

MAY BE has one or more ADRESSES

Unique Identifiers

Name Primary? Attrib.Name Relationship To Entity Name

CTY Yes ID

CTY U01 No CODE

CTY U02 No NAME

Oracle Designer Report : ckentdef

20 September 2009 Page 31 of 63

Entity Definition

Container: BBS Version:

Entity

Name : CREDIT QUALITY

Short Name : CQY

Plural Name : CREDIT QUALITIES

Initial Volume : 5 Average Volume : 10

Maximum Volume : 25

Description

Credit Quality is a category that determines the amount of money the Account Holder may borrow.

Notes

Examples ( id, code, credit scoring model, name, minimum credit score ):
- 1, A, V, Very Good, 901;
- 2, B, V, Good, 801;
- 3, C, V, Reasonable, 701;
- 4, D, V, Poor, 601;
- 5, F, V, Very Poor, 501;

Attributes * - Attributes in primary unique identifier

Name Domain Opt Format Length Scale

CODE CODE CREDIT QUALITY N CHAR 4

CREDIT SCORING MODEL CREDIT SCORING MODEL N CHAR 1

* ID ID06 N NUMBER 6 ,0

NAME NAME SHORT N CHAR 40

MINIMUM CREDIT SCORE CREDIT SCORE Y NUMBER 5 ,0

Relationships * - Relationships in primary unique identifier

Each Occurrence Of This Entity :

MAY BE of one or more ACCOUNT HOLDERS

Unique Identifiers

Name Primary? Attrib.Name Relationship To Entity Name

CQY Yes ID

CQY U01 No CODE

CQY U02 No NAME

Oracle Designer Report : ckentdef

20 September 2009 Page 32 of 63

Entity Definition

Container: BBS Version:

Entity

Name : CURRENCY

Short Name : CRY

Plural Name : CURRENCIES

Initial Volume : 1000 Average Volume : 100000

Maximum Volume : 1000000

Description

A Currency is a means of payment in a certain community, state, province or nation. Only Natural Money Currencies are allowed within the natural money financial system. If a payment in a usury Currency is done, the Natural Money Currency must be converted to the usury Currency at a Currency market and then sent to the receiving party.

Notes

Examples ( id, code, begindate, ind international, name, holding tax account, enddate ):
- 3847, NLN, 01-NOV-2012, N, New Dutch Guilder, DUTGOV1782.TRIODOS.NL,;
- 3848, NL.SNF, 01-DEC-2012, N, Sneker Foppen, GEMSNK3630.FRIEBANK.NL,;
- 3849, USN, 01-DEC-2010, Y, New US Dollar, USGVTX6578.WASDCBAN.US,;
- 3850, US.FLD, 01-DEC-2010, N, Florida Dollar, FLATAX0253.FLSTABAN.US,;
- 3851, US.FL.MMD, 01-DEC-2010, N, Miami Dollar, MIACIT8019.MIAMBANK.US,;
- 3852, US.OHD, 01-DEC-2010, N, Ohio Dollar, OHITAX9922.OHIONATB.US,;
- 3853, US.OH.DTW, 01-DEC-2010, N, Dayton Wrights, DAYTCC6721.DAYTFIBA.US,;

Attributes * - Attributes in primary unique identifier

Name Domain Opt Format Length Scale

BEGINDATE N DATE

CODE CODE CURRENCY N CHAR 15

CONTACT CONTACT DATA N CHAR 2000

EMAIL ADDRESS EMAIL ADDRESS N CHAR 120

EMAIL ADDRESS2 EMAIL ADDRESS N CHAR 120

HOLDING TAX ACCOUNT ACCOUNT NAME LONG N CHAR 22

* ID ID09 N NUMBER 9 ,0

IND INTERNATIONAL YES NO N CHAR 1

ISSUER NAME SHORT N CHAR 40

NAME NAME SHORT N CHAR 40

ENDDATE Y DATE

Relationships * - Relationships in primary unique identifier

Each Occurrence Of This Entity :

Oracle Designer Report : ckentdef

20 September 2009 Page 33 of 63

Entity Definition

Container: BBS Version:

MAY BE has one or more HOLDING TAX RATES

MAY BE is base currency of one or more ACCOUNTS

MAY BE is national currency of one or more COUNTRIES

MAY BE is offered one or more ACC CUR PREF STEPS

MAY BE is offered one or more CURRENCY PREF STEPS

MAY BE is requested one or more ACC CUR PREF STEPS

MAY BE is requested one or more ACCOUNT CUR PREFERENCES

MAY BE is requested one or more CURRENCY PREF STEPS

MAY BE is requested one or more CURRENCY PREFERENCES

MAY BE is used in one or more ACCOUNT CURRENCIES

MAY BE issuer has one or more MESSAGES

MAY BE of one or more ACCOUNT TYPE CURRENCIES

MAY BE of one or more PERIODIC TRANSFERS

MAY BE offered by one or more CURRENCY PREFERENCES

MAY BE used as base currency for one or more TRANSACTIONS

MUST BE is under jur. of one and only one COUNTRY

Unique Identifiers

Name Primary? Attrib.Name Relationship To Entity Name

CRY Yes ID

CRY U01 No CODE

CRY U02 No NAME

Oracle Designer Report : ckentdef

20 September 2009 Page 34 of 63

Entity Definition

Container: BBS Version:

Entity

Name : CURRENCY PREF STEP

Short Name : CPS

Plural Name : CURRENCY PREF STEPS

Initial Volume : 250 Average Volume : 2500

Maximum Volume : 250000

Description

A Currency Pref Step is a step in the Currency conversion process of the Currency Preference. The first step starts with the offered Currency while the last step ends with the requested Currency.

Notes

Examples( id, ACP-id, step, CRY-code offered, CRY-code requested ):
- 1211, 1, 401, US.FL.MMD, US.FLD;
- 1212, 2, 401, US.FLD, US.OHD;
- 1213, 3, 401, US.OHD, US.OH.DTW;
- 1214, 1, 402, US.FL.MMD, USN;
- 1215, 2, 402, USN, US.OH.DTW;
- 1216, 1, 403, NL.SNF, NLN;
- 1217, 2, 403, NLN, USN;
- 1218, 3, 403, USN, US.FL.MMD;

Attributes * - Attributes in primary unique identifier

Name Domain Opt Format Length Scale

* ID ID09 N NUMBER 9 ,0

STEP RANKING N INTEGER 4

Relationships * - Relationships in primary unique identifier

Each Occurrence Of This Entity :

MUST BE AHR offers one and only one CURRENCY

MUST BE of one and only one CURRENCY PREFERENCE

MUST BE AHR requests one and only one CURRENCY

Oracle Designer Report : ckentdef

20 September 2009 Page 35 of 63

Entity Definition

Container: BBS Version:

Unique Identifiers

Name Primary? Attrib.Name Relationship To Entity Name

CPS Yes ID

CPS U01 No STEP

of CURRENCY PREFERENCE

CPS U02 No AHR requests CURRENCY

of CURRENCY PREFERENCE

CPS U03 No AHR requests CURRENCY

of CURRENCY PREFERENCE

Oracle Designer Report : ckentdef

20 September 2009 Page 36 of 63