TIMESHEET_STATUS_VIEW |
||
| Column Name | Data Type | Nulls |
|---|---|---|
| person_key | decimal (15,0) | |
| last_name | varchar (50) | YES |
| first_name | varchar (50) | YES |
| middle_initial | varchar (1) | YES |
| suffix | varchar (10) | YES |
| varchar (50) | YES | |
| timesheet_email | varchar (1) | |
| time_period_key | decimal (15,0) | YES |
| status | varchar (25) | YES |
| begin_date | datetime | YES |
Tables Used |
| PERSON |
| MEMBER |
| PERSON_TIME |
SQL*Server Create Statement: |
CREATE VIEW timesheet_status_view AS
SELECT person.person_key, person.last_name, person.first_name,
person.middle_initial, person.suffix, person.email,
person.timesheet_email, person.time_period_key, person_time.status,
person_time.begin_date
FROM person, person_time, member
WHERE person.person_key *= person_time.person_key
AND person.active = 'Y'
AND member.person_key = person.person_key
AND member.role_key = 4
|