| Col # | Column Name | Data Type | Not Null? | Data Def. | Comments |
|---|---|---|---|---|---|
| 1 | INSTRUCTIONAL_PROGRAM_TYPE | CHAR(1 BYTE) | Y | The single character code representing a type of Tuition Distribution Instructional Program. There are four (4) defined types as of roll-out in Fall 2006. The fifth type is present to trap errors. | |
| 2 | INSTRUCTIONAL_PROGRAM_DESC | VARCHAR2(60 BYTE) | The Description of the Instructional Program Type | ||
| 3 | FALL_SPRING_OBJECT_CODE | VARCHAR2(4 BYTE) | The Object Code for Tuition Revenue in either the Fall or Spring Terms. This field is only used by the Journal process to distribute tuition. | ||
| 4 | SUMMER_OBJECT_CODE | VARCHAR2(4 BYTE) | The Object Code for Tuition Revenue in the Summer Term. This field is only used by the process generating Journals. | ||
| 5 | DEFERRED_INCOME_OBJECT_CODE | VARCHAR2(4 BYTE) | The Object Code for Tax Revenue. This field is only used by the Journal process to distribute tuition. |
| Uniqueness | Index Name | Columns |
|---|---|---|
| UNIQUE | SYS_C00511914 | INSTRUCTIONAL_PROGRAM_TYPE |
--------- No Triggers on TD_PROGRAM_TYPE_LU ---------
| Name | Type | Condition | Status | Columns |
|---|---|---|---|---|
| SYS_C00511914 | Primary Key | ENABLED | INSTRUCTIONAL_PROGRAM_TYPE |
| 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 | ||
| DWST_SUPPORT | SELECT |
--------- TD_PROGRAM_TYPE_LU does not reference any objects ---------
--------- No objects reference TD_PROGRAM_TYPE_LU ---------