oats_persons

-1 rows


Description

A BUSINESS PARTNER is a PERSON which is not a Ministry employee, or a Ministry employee who is acting as a business partner outside of employment function. A business partner includes contractors, clients and external organizations associated or partnered with the Ministry. An EMPLOYEE is a PERSON which is employed by the Ministry and not acting outside of that function. (An EMPLOYEE of the Ministry could also be considered as a BUSINESS PARTNER if involved with Ministry business activities outside the scope of normal job function.) A PERSON plays some role in resource inventory management for the BC Government and may belong to an ORGANIZATION.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
person_id int8 19 null
oats_person_organizations.person_id oats_pog_per_fk R

PERSON ID is the system generated unique identifier for PERSON
per_type varchar 10 null
first_name varchar 40 √ null

The FIRST NAME is the first name of a person.
middle_name varchar 40 √ null

The MIDDLE NAME is the middle name of a person.
last_name varchar 40 null

The LAST NAME is the last name of a person.
title varchar 40 √ null

The TITLE is the formal appellation attached to the PERSON’s name by virtue of office, rank, or attainment.
employee_id int8 19 √ null

The EMPLOYEE ID is the employee number assigned to the person
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 updated the record.
when_updated timestamp 29,6 √ null

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

REVISION COUNT is used by Hibernate to control optimistic locking

Indexes

Constraint Name Type Sort Column(s)
oats_persons_pkey Primary key Asc person_id

Check Constraints

Constraint Name Constraint
oats_per_chk (((((per_type)::text = 'BPA'::text) AND (employee_id IS NULL)) OR (((per_type)::text = 'EMP'::text) AND ((employee_id IS NULL) OR (employee_id IS NOT NULL)))))
avcon_1238100890_per_t_000 (((per_type)::text = ANY ((ARRAY['EMP'::character varying, 'BPA'::character varying])::text[])))

Relationships

Close relationships within degrees of separation