seedlot_owner_quantity

0 rows


Description

A Seedlot may be owned by more than one owner. Each owner owns a specific quantity of seed which may be reserved for the use of that owner and/or surplus and available for use by others.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
seedlot_number varchar 5 null
seedlot.seedlot_number seedlot_owner_qty_seedlot_fk R

The unique number (key) assigned to a quantity of seed of a particular species and quality from a given location collected at a given time.
owner_client_number varchar 8 null

A sequentially assigned number which uniquely identifies a Ministry client (owner).
owner_locn_code varchar 2 null

A code to uniquely identify, within each client (owner), the addresses of different divisions or locations at which the client operates. The location code is sequentially assigned starting with “00” for the client´s permanent address.
original_pct_owned numeric 4,1 null

The original percentage of seed that was owned by a client.
original_pct_rsrvd numeric 4,1 null

The original percentage of seed from an owner´s portion of a Seedlot that has been declared reserved.
original_pct_srpls numeric 4,1 null

The original percentage of seed from an owner´s portion of a Seedlot that has been declared surplus.
method_of_payment_code varchar 3 √ null
method_of_payment_list.method_of_payment_code seedlot_own_qnt_meth_pay_cd_fk R

A code which represents the method of payment for services where payment is required.
spar_fund_srce_code varchar 3 √ null

A code which represents the source funds for payment of the request.
entry_userid varchar 30 null

The userid of the individual that entered the Seedlot owner quantity.
entry_timestamp timestamp 29,6 null

The time and date a Seedlot owner quantity was entered onto the system.
update_userid varchar 30 null

The userid of the individual that changed the Seedlot owner quantity.
update_timestamp timestamp 29,6 CURRENT_TIMESTAMP

The time and date a Seedlot owner quantity was last updated on the system.
revision_count int4 10 null

A counter used to ensure data integrity. This item should be incremented during each update.

Indexes

Constraint Name Type Sort Column(s)
seedlot_owner_quantity_pk Primary key Asc/Asc/Asc seedlot_number + owner_client_number + owner_locn_code

Relationships

Close relationships within degrees of separation