Col # | Column Name | Data Type | Not Null? | Data Def. | Comments |
---|---|---|---|---|---|
1 | ID | INTEGER | Y | The primary key for the table. | |
2 | DATE_KEY | INTEGER | Y | The foreign key to the td_time_dimension table. | |
3 | STATUS | VARCHAR2(3 BYTE) | Always "NEW". | ||
4 | SET_OF_BOOKS_ID | VARCHAR2(9 BYTE) | Always "01". | ||
5 | USER_JE_SOURCE_NAME | VARCHAR2(15 BYTE) | The source name of the feeder which indicates the feeder type. | ||
6 | USER_JE_CATEGORY_NAME | VARCHAR2(10 BYTE) | Always "Feeder". | ||
7 | ACCOUNTING_DATE | VARCHAR2(8 BYTE) | The date upon which the feeder applies to accounting. | ||
8 | CURRENCY_CODE | VARCHAR2(3 BYTE) | Always "USD". | ||
9 | DATE_CREATED | VARCHAR2(8 BYTE) | The date upon which the feeder was created. | ||
10 | CREATED_BY | VARCHAR2(1 BYTE) | Always "1". | ||
11 | ACTUAL_FLAG | VARCHAR2(1 BYTE) | Always "A". | ||
12 | ENCUMBRANCE_TYPE_ID | VARCHAR2(4 BYTE) | Always empty. | ||
13 | DEBIT_SEGMENT_1 | VARCHAR2(3 BYTE) | Debit cnac of the row. | ||
14 | DEBIT_SEGMENT_2 | VARCHAR2(4 BYTE) | Debit org of the row. | ||
15 | DEBIT_SEGMENT_3 | VARCHAR2(1 BYTE) | Debit BC of the row. | ||
16 | DEBIT_SEGMENT_4 | VARCHAR2(6 BYTE) | Debit fund of the row. | ||
17 | DEBIT_SEGMENT_5 | VARCHAR2(4 BYTE) | Debit object code of the row. | ||
18 | DEBIT_SEGMENT_6 | VARCHAR2(4 BYTE) | Debit program of the row. | ||
19 | DEBIT_SEGMENT_7 | VARCHAR2(4 BYTE) | Debit cref of the row. | ||
20 | AMOUNT | VARCHAR2(13 BYTE) | Dollar amount of the row, always including two decimals with an implied decimal place. | ||
21 | REFERENCE_1 | VARCHAR2(30 BYTE) | Concatenation of feeder type, 001, and date in YYYMMDD format. | ||
22 | REFERENCE_4 | VARCHAR2(30 BYTE) | Journal entry name. | ||
23 | REFERENCE_7 | VARCHAR2(3 BYTE) | Always blank. | ||
24 | REFERENCE_8 | VARCHAR2(6 BYTE) | Always blank. | ||
25 | REFERENCE_10 | VARCHAR2(30 BYTE) | Description of the feeder, including term. | ||
26 | BUDGET_VERSION_ID | VARCHAR2(2 BYTE) | Always blank. | ||
27 | PERIOD_NAME | VARCHAR2(6 BYTE) | Always blank. | ||
28 | CONTEXT | VARCHAR2(15 BYTE) | Same value as source name. | ||
29 | ATTRIBUTE_1 | VARCHAR2(15 BYTE) | Always blank. | ||
30 | ATTRIBUTE_2 | VARCHAR2(15 BYTE) | Always blank. | ||
31 | ATTRIBUTE_3 | VARCHAR2(15 BYTE) | Always blank. | ||
32 | ATTRIBUTE_4 | VARCHAR2(15 BYTE) | Always blank. | ||
33 | ATTRIBUTE_5 | VARCHAR2(15 BYTE) | Always blank. | ||
34 | ATTRIBUTE_6 | VARCHAR2(30 BYTE) | Always blank. | ||
35 | CREDIT_SEGMENT_1 | VARCHAR2(3 BYTE) | Credit cnac of the row. | ||
36 | CREDIT_SEGMENT_2 | VARCHAR2(4 BYTE) | Credit org code of the row. | ||
37 | CREDIT_SEGMENT_3 | VARCHAR2(1 BYTE) | Credit bc of the row. | ||
38 | CREDIT_SEGMENT_4 | VARCHAR2(6 BYTE) | Credit fund of the row. | ||
39 | CREDIT_SEGMENT_5 | VARCHAR2(4 BYTE) | Credit object code of the row. | ||
40 | CREDIT_SEGMENT_6 | VARCHAR2(4 BYTE) | Credit program of the row. | ||
41 | CREDIT_SEGMENT_7 | VARCHAR2(4 BYTE) | Credit cref of the row. | ||
42 | TERM | VARCHAR2(5 BYTE) | The term in which the feeder took place. | ||
43 | DISCRIMINATOR | VARCHAR2(30 BYTE) | This field is used by Hibernate (java relational persistance program) in order to determin the type of java class which should be instantiated when this row is loaded into the Tuition Distribution program. | ||
44 | FINAL_SNAP | VARCHAR2(1 BYTE) | 'F' | Whether the time dimension for this feeder was a final term snapshot. |
Uniqueness | Index Name | Columns |
---|---|---|
UNIQUE | TD_FEEDER_PK | ID |
--------- No Triggers on TD_FEEDER ---------
Name | Columns | Ref Table Owner | Ref Table Name | Ref Columns | Delete Rule | Status | Deferrable | Deferred |
---|---|---|---|---|---|---|---|---|
TD_FEEDER_R01 | DATE_KEY | DWST | TD_TIME_DIMENSION | DATE_KEY | NO ACTION | ENABLED | No | No |
Name | Type | Condition | Status | Columns |
---|---|---|---|---|
TD_FEEDER_PK | Primary Key | ENABLED | ID |
Column | Grantee | Grantable Privilege(s) | Non-Grantable Privilege(s) |
---|---|---|---|
SEIDITA | SELECT | ||
TUITION_DIST_RL | SELECT |
Object Owner | Object Name | Object Type |
---|---|---|
DWST | TD_TIME_DIMENSION | Table |
--------- No objects reference TD_FEEDER ---------