Schema Index

 

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

Tables
Feeder holds the data which is used to populate the feeder files which are sent to the bursar system for Tuition Distribution.
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.

 

Indexes on TD_FEEDER
Uniqueness Index Name Columns
UNIQUE TD_FEEDER_PK ID

--------- No Triggers on TD_FEEDER ---------

Foreign Key Constraints 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

 

PK, UK, & Check Constraints on TD_FEEDER
Name Type Condition Status Columns
TD_FEEDER_PK Primary Key   ENABLED ID

 

 

Granted Privileges on TD_FEEDER
Column Grantee Grantable Privilege(s) Non-Grantable Privilege(s)
  SEIDITA   SELECT
  TUITION_DIST_RL   SELECT

 

 

Objects referenced by table TD_FEEDER
Object Owner Object Name Object Type
DWST TD_TIME_DIMENSION Table

--------- No objects reference TD_FEEDER ---------