Table TD_INSTRUCTOR_APPOINTMENT in DWST@WHSE.ISC-AIT.UPENN.EDU

Tables

*This table is used to store employment appointments for instructors.*
Col #	Column Name	Data Type	Not Null?	Data Def.	Comments
1	INSTRUCTOR_APPT_KEY	INTEGER	Y		The primary key of the table.
2	DEPT_ORG	CHAR(4 BYTE)			The department to which the instructor belongs.
3	ORGANIZATION_DESC	VARCHAR2(60 BYTE)			The description of the organization to which the instructor belongs.
4	JOB_CLASS	VARCHAR2(6 BYTE)			The class of the job which the instructor holds.
5	JOB_TITLE	VARCHAR2(25 BYTE)			The title of the job which the instructor holds.
6	BEGIN_EFF_DATE	DATE	Y	SYSDATE	Begin Eff Date is populated when a new row is added.
7	END_EFF_DATE	DATE			End Eff Date is populated only when a newer version of this dimension record is added. The default is null.
8	CURRENT_RECORD	VARCHAR2(1 BYTE)	Y	'T'	Current Record is a T(rue)/ F(alse) Flag, indicating which of the dimension records are current. This is used for all lookups when loading the fact table.
9	PERSONNEL_CLASS	VARCHAR2(2 BYTE)			The personnel class to which the instructor belongs.
10	FACULTY_CLASS	VARCHAR2(3 BYTE)			The faculty class to which the instructor belongs.
11	STANDING_FACULTY_RANK	VARCHAR2(5 BYTE)			The standing faculty rank of the instructor.

**Indexes on TD_INSTRUCTOR_APPOINTMENT**
Uniqueness	Index Name	Columns
NON-UNIQUE	TD_ORG_CLASS_IDX	DEPT_ORG, JOB_CLASS
UNIQUE	SYS_C00511907	INSTRUCTOR_APPT_KEY

Triggers on TD_INSTRUCTOR_APPOINTMENT

Trigger Name

Status

Triggering Event

When Clause

Trigger Type

Body

TD_INSTRUCTOR_APPT_PK_TRIG

ENABLED

INSERT

BEFORE EACH ROW

BEGIN

    SELECT TD_INSTRUCTOR_APPT_PK_SEQ.NEXTVAL INTO :NEW.INSTRUCTOR_APPT_KEY FROM dual;

   EXCEPTION
     WHEN OTHERS THEN
       -- Consider logging the error and then re-raise
       RAISE;
END ;

**PK, UK, & Check Constraints on TD_INSTRUCTOR_APPOINTMENT**
Name	Type	Condition	Status	Columns
SYS_C00511907	Primary Key		ENABLED	INSTRUCTOR_APPT_KEY

**Granted Privileges on TD_INSTRUCTOR_APPOINTMENT**
Column	Grantee	Grantable Privilege(s)	Non-Grantable Privilege(s)
	ESTEMMLE		SELECT
	DWADMIN		ALTER, DELETE, INDEX, INSERT, REFERENCES, SELECT, UPDATE, ON COMMIT REFRESH, QUERY REWRITE, DEBUG, FLASHBACK
	YALINGX		SELECT
	DWST_SUPPORT		SELECT
	TUITION_DIST_RL		SELECT

--------- TD_INSTRUCTOR_APPOINTMENT does not reference any objects ---------

**Objects which reference table TD_INSTRUCTOR_APPOINTMENT**
Object Owner	Object Name	Object Type
DWST	TD_DISTRIBUTION_FACT	Table (FK)
DWST	TD_INSTRUCTOR_SECTION_FACT	Table (FK)
DWST	TD_INSTRUCTOR_APPT_PK_TRIG	Trigger