oats_alr_application_fees

-1 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
alr_application_fee_id int8 19 null

System generated sequence number to uniquely identify a ALR APPLICATION FEE
fee_amount float8 17,17 null

FEE AMOUNT is the amount in dollars the applicant must pay to have his application processed.
submit_to_lg_ind varchar 1 null

SUBMIT TO LG IND indicates whether an applcation of a certain type needs to be submitted to the local government for review.
alr_change_code varchar 10 null
oats_alr_change_codes.alr_change_code oats_aafs_alcc_fk R

System developer supplied value to uniquely identify an ALR CHANGE CODE
application_class_code varchar 10 null
oats_application_class_codes.application_class_code oats_aafs_apcc_fk R

System developer supplied value to uniquely identify an APPLICATION CLASS CODE
who_created varchar 32 null

WHO CREATED is the IDIR or Oracle userid of the person who created the record.
when_created timestamp 29,6 null

WHEN CREATED is the date/time that the record was created.
who_updated varchar 32 √ null

WHO UPDATED is the IDIR or Oracle userid of the person who last updated the record.
when_updated timestamp 29,6 √ null

WHEN UPDATED is the date/time that the record was last updated.
revision_count int8 19 0

REVISION COUNT is used by Hibernate to control optimistic locking

Indexes

Constraint Name Type Sort Column(s)
oats_alr_application_fees_pkey Primary key Asc alr_application_fee_id
aafs_alcc_fk_i Performance Asc alr_change_code
aafs_apcc_fk_i Performance Asc application_class_code
oats_aafs_uk Must be unique Asc/Asc application_class_code + alr_change_code
oats_alr_application_fees_application_class_code_alr_change_key Must be unique Asc/Asc application_class_code + alr_change_code

Check Constraints

Constraint Name Constraint
avcon_1362772157_submi_000 (((submit_to_lg_ind)::text = ANY ((ARRAY['Y'::character varying, 'N'::character varying])::text[])))

Relationships

Close relationships within degrees of separation