Tables and Views for TAISMGR as of 21-JUN-2004 08:26am
Date: 21-JUN-2004 Page: 1
TABLE: AR_HOLDTEMP1
CREATOR: TAISMGR
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
PIDM NUMBER 8 YES
HOLD_CODE VARCHAR2 2 YES
START_DATE DATE 7 YES
END_DATE DATE 7 YES
PID VARCHAR2 9 YES
Date: 21-JUN-2004 Page: 2
TABLE: AR_HOLDTEMP2
CREATOR: TAISMGR
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
PIDM NUMBER 8 YES
HOLD_CODE VARCHAR2 2 YES
START_DATE DATE 7 YES
END_DATE DATE 7 YES
PID VARCHAR2 9 YES
Date: 21-JUN-2004 Page: 3
TABLE: AR_TEMP1
CREATOR: TAISMGR
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
PIDM NUMBER 8 YES
TERM VARCHAR2 6 YES
DET_CODE VARCHAR2 4 YES
TRAN_AMT NUMBER 12 2 YES
TRAN_BAL NUMBER 12 2 YES
PID VARCHAR2 9 YES
CODE VARCHAR2 1 YES
BILL_DATE DATE 7 YES
BILL_DUE_DATE DATE 7 YES
Date: 21-JUN-2004 Page: 4
TABLE: AR_TEMP2
CREATOR: TAISMGR
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
PIDM NUMBER 8 YES
TERM VARCHAR2 6 YES
DET_CODE VARCHAR2 4 YES
TRAN_AMT NUMBER 12 2 YES
TRAN_BAL NUMBER 12 2 YES
TRAN_NBR NUMBER 8 YES
T_DESC VARCHAR2 30 YES
PID VARCHAR2 9 YES
CODE VARCHAR2 1 YES
BILL_DATE DATE 7 YES
BILL_DUE_DATE DATE 7 YES
Date: 21-JUN-2004 Page: 5
TABLE: CLT_TABLE
CREATOR: TAISMGR
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
PIDM NUMBER 8 YES
TERM VARCHAR2 6 YES
DET_CODE VARCHAR2 4 YES
TRAN_AMT NUMBER 12 2 YES
TRAN_BAL NUMBER 12 2 YES
TRAN_NBR NUMBER 8 YES
T_DESC VARCHAR2 30 YES
PID VARCHAR2 9 YES
CODE VARCHAR2 1 YES
BILL_DATE DATE 7 YES
BILL_DUE_DATE DATE 7 YES
Date: 21-JUN-2004 Page: 6
TABLE: COLLTEMP_01
CREATOR: TAISMGR
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
STDT_PID VARCHAR2 9 YES
ASGND_DATE DATE 7 YES
AGENCY_ID VARCHAR2 9 YES
Date: 21-JUN-2004 Page: 7
TABLE: COLLTEMP_02
CREATOR: TAISMGR
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
STDT_PID VARCHAR2 9 YES
ASGND_DATE DATE 7 YES
AGENCY_ID VARCHAR2 9 YES
STDT_PIDM NUMBER 8 YES
AGENCY_PIDM NUMBER 8 YES
Date: 21-JUN-2004 Page: 8
TABLE: EXCEPTIONS
CREATOR: TAISMGR
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
ROW_ID ROWID 10 YES
OWNER VARCHAR2 30 YES
TABLE_NAME VARCHAR2 30 YES
CONSTRAINT VARCHAR2 30 YES
Date: 21-JUN-2004 Page: 9
TABLE: GJBJOBS_INSTALL
CREATOR: TAISMGR
taismgr GJBJOBS rows used during install
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
GJBJOBS_NAME VARCHAR2 30 NO
GJBJOBS_TITLE VARCHAR2 30 NO
GJBJOBS_ACTIVITY_DATE DATE 7 NO
GJBJOBS_SYSI_CODE VARCHAR2 2 YES
GJBJOBS_JOB_TYPE_IND VARCHAR2 1 YES
GJBJOBS_DESC VARCHAR2 240 YES
GJBJOBS_COMMAND_NAME VARCHAR2 30 YES
GJBJOBS_PRNT_FORM VARCHAR2 30 YES
GJBJOBS_PRNT_CODE VARCHAR2 30 YES
GJBJOBS_LINE_COUNT NUMBER 3 YES
GJBJOBS_VALIDATION VARCHAR2 30 YES
Date: 21-JUN-2004 Page: 10
TABLE: GJBPDEF_INSTALL
CREATOR: TAISMGR
taismgr GJBPDEF rows used during install
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
GJBPDEF_JOB VARCHAR2 30 NO
GJBPDEF_NUMBER VARCHAR2 2 NO
GJBPDEF_DESC VARCHAR2 30 NO
GJBPDEF_LENGTH NUMBER 2 NO
GJBPDEF_TYPE_IND VARCHAR2 1 NO
GJBPDEF_OPTIONAL_IND VARCHAR2 1 NO
GJBPDEF_SINGLE_IND VARCHAR2 1 NO
GJBPDEF_ACTIVITY_DATE DATE 7 NO
GJBPDEF_LOW_RANGE VARCHAR2 30 YES
GJBPDEF_HIGH_RANGE VARCHAR2 30 YES
GJBPDEF_HELP_TEXT VARCHAR2 78 YES
GJBPDEF_VALIDATION VARCHAR2 30 YES
GJBPDEF_LIST_VALUES VARCHAR2 30 YES
Date: 21-JUN-2004 Page: 11
TABLE: GJBPDFT_INSTALL
CREATOR: TAISMGR
taismgr GJBPDFT rows used during install
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
GJBPDFT_JOB VARCHAR2 30 NO
GJBPDFT_NUMBER VARCHAR2 2 NO
GJBPDFT_ACTIVITY_DATE DATE 7 NO
GJBPDFT_USER_ID VARCHAR2 30 YES
GJBPDFT_VALUE VARCHAR2 30 YES
GJBPDFT_JPRM_CODE VARCHAR2 15 YES
Date: 21-JUN-2004 Page: 12
TABLE: GJBPVAL_INSTALL
CREATOR: TAISMGR
taismgr GJBPVAL rows used during install
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
GJBPVAL_JOB VARCHAR2 30 NO
GJBPVAL_NUMBER VARCHAR2 2 NO
GJBPVAL_VALUE VARCHAR2 30 NO
GJBPVAL_DESC VARCHAR2 30 NO
GJBPVAL_ACTIVITY_DATE DATE 7 NO
Date: 21-JUN-2004 Page: 13
TABLE: GUBBHLP_INSTALL
CREATOR: TAISMGR
taismgr GUBBHLP rows used during install
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
GUBBHLP_FORM_NAME VARCHAR2 30 NO
GUBBHLP_BLOCK_NAME VARCHAR2 30 YES
GUBBHLP_FIELD_NAME VARCHAR2 30 YES
GUBBHLP_TEXT LONG NO
GUBBHLP_ACTIVITY_DATE DATE 7 NO
Date: 21-JUN-2004 Page: 14
TABLE: GUBOBJS_INSTALL
CREATOR: TAISMGR
taismgr GUBOBJS rows used during install
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
GUBOBJS_NAME VARCHAR2 30 NO
GUBOBJS_DESC VARCHAR2 80 NO
GUBOBJS_OBJT_CODE VARCHAR2 10 NO
GUBOBJS_SYSI_CODE VARCHAR2 2 NO
GUBOBJS_USER_ID VARCHAR2 30 NO
GUBOBJS_ACTIVITY_DATE DATE 7 NO
GUBOBJS_HELP_IND VARCHAR2 1 NO
GUBOBJS_EXTRACT_ENABLED_IND VARCHAR2 1 NO
Date: 21-JUN-2004 Page: 15
TABLE: GURAOBJ_INSTALL
CREATOR: TAISMGR
taismgr GURAOBJ rows used during install
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
GURAOBJ_OBJECT VARCHAR2 30 NO
GURAOBJ_DEFAULT_ROLE VARCHAR2 30 NO
GURAOBJ_CURRENT_VERSION VARCHAR2 10 NO
GURAOBJ_SYSI_CODE VARCHAR2 2 NO
GURAOBJ_ACTIVITY_DATE DATE 7 NO
GURAOBJ_CHECKSUM VARCHAR2 30 YES
Date: 21-JUN-2004 Page: 16
TABLE: GURDMOD_INSTALL
CREATOR: TAISMGR
taismgr GURDMOD rows used during install
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
GURDMOD_CODE VARCHAR2 30 YES
GURDMOD_DATE DATE 7 YES
GURDMOD_APPLIED_BY_USER VARCHAR2 30 YES
GURDMOD_OBJECT VARCHAR2 30 YES
GURDMOD_DESC VARCHAR2 255 YES
Date: 21-JUN-2004 Page: 17
TABLE: GURMENU_INSTALL
CREATOR: TAISMGR
taismgr GURMENU rows used during install
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
GURMENU_NAME VARCHAR2 30 NO
GURMENU_OBJ_NAME VARCHAR2 30 NO
GURMENU_SORT_SEQ NUMBER NO
GURMENU_USER_ID VARCHAR2 30 NO
GURMENU_ACTIVITY_DATE DATE 7 NO
GURMENU_DESC VARCHAR2 80 YES
Date: 21-JUN-2004 Page: 18
TABLE: GUROPTM_INSTALL
CREATOR: TAISMGR
taismgr GUROPTM rows used during install
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
GUROPTM_SORT_SEQ NUMBER 5 2 YES
GUROPTM_TYPE_IND VARCHAR2 1 NO
GUROPTM_FORM_NAME VARCHAR2 30 NO
GUROPTM_NAME1 VARCHAR2 30 NO
GUROPTM_NAME1_DESC VARCHAR2 60 YES
GUROPTM_NAME2 VARCHAR2 61 YES
GUROPTM_CAPACITY VARCHAR2 1 YES
GUROPTM_TRG_NAME VARCHAR2 30 YES
GUROPTM_TRG_TYPE VARCHAR2 1 YES
GUROPTM_BLOCK_VALID VARCHAR2 30 YES
GUROPTM_ACTIVITY_DATE DATE 7 YES
GUROPTM_USER_ID VARCHAR2 30 NO
GUROPTM_FORM_TO_BE_CALLED VARCHAR2 30 YES
Date: 21-JUN-2004 Page: 19
TABLE: TBBACCT
CREATOR: TAISMGR
Account Header Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
TBBACCT_PIDM NUMBER 8 NO Internal Identification Number of person.
TBBACCT_DELI_CODE VARCHAR2 2 YES This field identifies the delinquency code associated
with the person"s account.
TBBACCT_BILL_IND VARCHAR2 1 YES This field indicates if the person"s account should
not be billed. Valid value is: N - Do not select
person for billing.
TBBACCT_ACTIVITY_DATE DATE 7 NO This field specifies the most current date record was
created or updated.
TBBACCT_BILL_CODE VARCHAR2 2 YES A code describing why a bill is on hold.
TBBACCT_REFUND_IND VARCHAR2 1 YES This field indicates whether the account, which has a
credit balance, is to be automatically refunded.
Valid values: Null, or "N" is no; "H", for hold, is
no;and "Y" is yes.
Date: 21-JUN-2004 Page: 20
TABLE: TBBCCLR
CREATOR: TAISMGR
Collector Table Used For Various Cashiering Operations
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
TBBCCLR_SESSIONID VARCHAR2 30 NO This field identifies the userid of the user who
entered a transaction on an account to generate a
cashiering session.
TBBCCLR_USER VARCHAR2 30 NO
TBBCCLR_SESSION_NUMBER NUMBER 5 NO
TBBCCLR_SESSION_IND VARCHAR2 1 NO
TBBCCLR_CSHR_END_DATE DATE 7 NO
TBBCCLR_DCAT_CODE VARCHAR2 3 YES This field identifies the detail catagory code (cash,
tuition, etc.) associated with the detail code.
TBBCCLR_ACTIVITY_DATE DATE 7 NO This field specifies the most current date record was
created or updated.
Date: 21-JUN-2004 Page: 21
TABLE: TBBCCTX
CREATOR: TAISMGR
Contract Text Table by Contract Number and Term
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
TBBCCTX_CONTRACT_PIDM NUMBER 8 NO PIDM: Internal Identification Number of the non-person
account assigned as a Third Party Contract.
TBBCCTX_CONTRACT_NUMBER NUMBER 8 NO CONTRACT NUMBER: This field identifies the contract
number associated with the third party for the term.
TBBCCTX_TERM_CODE VARCHAR2 6 NO TERM CODE: This field identifies the term associated
with the third party contract number.
TBBCCTX_SEQ_NUMBER NUMBER 23 20 NO SEQUENCE NUMBER: This field identifies the internal
sequence number associated with each line of text.
TBBCCTX_PRINT_IND VARCHAR2 1 NO PRINT INDICATOR: Indicates whether this comment should
print on the bill.
TBBCCTX_ACTIVITY_DATE DATE 7 NO ACTIVITY DATE: This field specifies the most current
date record was created or updated.
TBBCCTX_USER_ID VARCHAR2 30 NO USER IDENTIFICATION: The unique identification of the
user.
TBBCCTX_TEXT VARCHAR2 60 YES TEXT: This field specifies free-format text, further
describing the contract.
Date: 21-JUN-2004 Page: 22
TABLE: TBBCONT
CREATOR: TAISMGR
Contract Header Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
TBBCONT_PIDM NUMBER 8 NO Internal Identification Number of the non-person
account that is identified as a third party contract.
TBBCONT_CONTRACT_NUMBER NUMBER 8 NO This field identifies the contract number associated
with the third party for the term.
TBBCONT_TERM_CODE VARCHAR2 6 NO This field identifies the term associated with the
third party contract number.
TBBCONT_DESC VARCHAR2 30 NO This field specifies the free-format description of
the third party contract for the term.
TBBCONT_DETAIL_PAY_CODE VARCHAR2 4 NO This field identifies the detail code that has been
identified as a payment to be posted as the third
party payment on the student"s account.
TBBCONT_DETAIL_CHG_CODE VARCHAR2 4 NO This field identifies the detail code that has been
identified as a charge to be posted as the charge
against the third party"s account.
TBBCONT_ACTIVITY_DATE DATE 7 NO This field specifies the most current date record was
created or updated.
TBBCONT_CONTRACT_ROLL_IND VARCHAR2 1 NO Y denotes that the contract will be rolled when the
process TSRROLL is executed
TBBCONT_STUDENT_CONT_ROLL_IND VARCHAR2 1 NO Y denotes that when the process TSRROLL is executed,
if the contract the student is in rolls then the
student will also roll.
TBBCONT_TERM_CODE_EXPIRATION VARCHAR2 6 YES The process TSRROLL will check to see if this term is
greater than the term the contract is being rolled to
and if it is will consider the contract expired and
not roll it.
TBBCONT_TPRL_CODE VARCHAR2 10 YES TPRL CODE: This code is used to determine which
third-party print rule is to be used when running the
third-party contract billing.
Date: 21-JUN-2004 Page: 23
TABLE: TBBCPRF
CREATOR: TAISMGR
Customer Profile Attributes Table.
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
TBBCPRF_PIDM NUMBER 8 NO This column contains the internal reference number for
the account.
TBBCPRF_CREDIT_LIMIT NUMBER 12 2 YES This column contains the maximum amount which may be
incurred by the account.
TBBCPRF_ECAT_CODE VARCHAR2 2 YES This column defines the type of account. All values
are found in the TTVECAT validation table.
TBBCPRF_ACTIVITY_DATE DATE 7 NO This column contains the date this row was added or
updated.
TBBCPRF_ATYP_CODE_DEFAULT VARCHAR2 2 YES In combination with ATYP_SEQNO_DEFAULT, the default
address (in A/R) for this entity. (i.e. where the
bill will be sent)
TBBCPRF_ATYP_SEQNO_DEFAULT NUMBER 2 YES In combination with ATYP_CODE_DEFAULT, the default
address (in A/R) for this entity. (i.e. where the
bill will be sent)
Date: 21-JUN-2004 Page: 24
TABLE: TBBCSHR
CREATOR: TAISMGR
Cashier Session Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
TBBCSHR_USER VARCHAR2 30 NO This field specifies the userid that is identified as
a cashier.
TBBCSHR_SESSION_NUMBER NUMBER 5 NO This field specifies the session number associated
with the cashier.
TBBCSHR_START_DATE DATE 7 YES This field specifies the start date of the cashier"s
session. This date is determined by the entry date of
the first transaction in the session.
TBBCSHR_END_DATE DATE 7 YES This field specifies the end date of the cashier"s
session. This date is determined by the entry date of
the last transaction in the session.
TBBCSHR_SESSION_IND VARCHAR2 1 NO This field indicates the status of the cashiering
session. Valid values are: blank - Open, C - Closed,
F - Final, R - Reported.
TBBCSHR_ACTIVITY_DATE DATE 7 NO This field specifies the most current date record was
created or updated.
TBBCSHR_BANK_DEPOSIT_NUMBER VARCHAR2 8 YES A unique code used by a bank to identify a deposit.
TBBCSHR_BANK_CODE VARCHAR2 2 YES Bank code related to the bank deposit number.
Date: 21-JUN-2004 Page: 25
TABLE: TBBCSTT
CREATOR: TAISMGR
Contract Student Text Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
TBBCSTT_PIDM NUMBER 8 NO INTERNAL IDENTIFICATION NUMBER: Number of the person
account.
TBBCSTT_CONTRACT_PIDM NUMBER 8 NO PIDM: Internal Identification Number of the non-person
account assigned as a Third Party Contract.
TBBCSTT_CONTRACT_NUMBER NUMBER 8 NO CONTRACT NUMBER: This field identifies the contract
number associated with the third party for the term.
TBBCSTT_TERM_CODE VARCHAR2 6 NO TERM CODE: This field identifies the term associated
with the third party contract number.
TBBCSTT_SEQ_NUMBER NUMBER 23 20 NO SEQUENCE NUMBER: This field identifies the internal
sequence number associated with each line of text.
TBBCSTT_PRINT_IND VARCHAR2 1 NO PRINT INDICATOR: Indicates whether this comment should
print on the bill.
TBBCSTT_ACTIVITY_DATE DATE 7 NO ACTIVITY DATE: This field specifies the most current
date record was created or updated.
TBBCSTT_USER_ID VARCHAR2 30 NO USER IDENTIFICATION: The unique identification of the
user.
TBBCSTT_TEXT VARCHAR2 60 YES TEXT: This field specifies free-format text, further
describing the person on a contract.
Date: 21-JUN-2004 Page: 26
TABLE: TBBCSTU
CREATOR: TAISMGR
Contract Student Authorization Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
TBBCSTU_STU_PIDM NUMBER 8 NO Internal Identification Number of the student who has
been authorized to receive payment from the third
party contract.
TBBCSTU_CONTRACT_PRIORITY NUMBER 2 NO This indicates the priority of this contract for the
student, if the student is authorized for more than
one contract.
TBBCSTU_CONTRACT_PIDM NUMBER 8 NO Internal Identification Number of the non-person
account that is identified as a third party contract.
TBBCSTU_CONTRACT_NUMBER NUMBER 8 NO This field identifies the contract number associated
with the third party for the term.
TBBCSTU_TERM_CODE VARCHAR2 6 NO This field identifies the term associated with the
third party contract number.
TBBCSTU_ACTIVITY_DATE DATE 7 NO This field specifies the most current date record was
created or updated.
TBBCSTU_DEL_IND VARCHAR2 1 YES This field indiciates if the student should be deleted
from the contract and any money paid to the student be
backed out of the student"s account.
TBBCSTU_AUTH_NUMBER VARCHAR2 30 YES A number issued for a student by a third party when a
student is authorized to use a contract.
TBBCSTU_AUTH_IND VARCHAR2 1 YES An indicator signifying whether a student is
pre-authorized, authorized, or unauthorized to use a
contract.
TBBCSTU_STUDENT_CONT_ROLL_IND VARCHAR2 1 NO Y denotes that when the process TSRROLL is executed,
if the contract the student is in rolls then the
student will also roll, N will cause student not to
roll.
TBBCSTU_TERM_CODE_EXPIRATION VARCHAR2 6 YES The process TSRROLL will check to see if this term is
greater than the term the contract is being rolled to
and if it is will consider the student contract
expired and not roll it.
TBBCSTU_SPONSOR_REF_NUMBER VARCHAR2 30 YES Contains the number supplied by the agency.
TBBCSTU_USER_ID VARCHAR2 30 YES USER IDENTIFICATION: The unique identification of the
user.
TBBCSTU_MAX_STUDENT_AMOUNT NUMBER 7 2 YES MAXIMUM STUDENT_AMOUNT: This field indicates the
maximum amount a student can have for this contract.
Date: 21-JUN-2004 Page: 27
TABLE: TBBCTRL
CREATOR: TAISMGR
Accounts Receivable Billing Control Table.
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
TBBCTRL_PROCESS_ORDER_IND VARCHAR2 1 NO This field indicates the order that contracts and
exemptions should be processed on a student"s account.
Valid values are: C - Contracts first, E - Exemptions
first.
TBBCTRL_AUTO_RECEIPT_IND VARCHAR2 1 NO This field indicates if receipts should automatically
be printed for any transaction identified on the
detail code control form as having a receipt number
automatically generated. Valid values: Y - print, N -
Do not print.
TBBCTRL_EFFECTIVE_DATE_IND VARCHAR2 1 NO This field indicates the date that should be used when
charges are accepted on the Student Payment Form.
Valid values are: T - Today"s date, C - Date of the
charges.
TBBCTRL_COMM_FAID_IND VARCHAR2 1 NO This field indicates if committed (not yet disbursed)
financial aid should be subtracted from the student"s
amount due on the Student Payment Form. Valid values
are: Y - Subtract committed aid, N - Do not subtract
committed aid.
TBBCTRL_ACTIVITY_DATE DATE 7 NO This field specifies the most current date record was
created or updated.
TBBCTRL_AUTO_DISB_IND VARCHAR2 1 YES This column indicates to TSASPAY if the Banner
Financial Aid process should automatically be
performed, or if the user must manually request it
TBBCTRL_RESTRICT_IND VARCHAR2 1 YES This column will contain "Y" if userids are limited to
entering certain type of transaction (as defined on
TGAUPRF). If it contains an "N", there are no
restrictions and any user may enter any category
detail code, charge or payment.
TBBCTRL_HOLD VARCHAR2 3 YES
TBBCTRL_INV_PREFIX VARCHAR2 1 NO This column contains the prefix of the
system-generated invoice number.
TBBCTRL_CASN_EXISTS VARCHAR2 1 NO This column indicates if the installation is assigning
cashiers to supervisors. A values of "Y" means the
relationship is established, an "N" means it is not.
TBBCTRL_AUTH_REQD_IND VARCHAR2 1 NO This column indicates whether or not third party
authorization is required in order for a student to
use a contract.
TBBCTRL_FEED_FUTURES_IND VARCHAR2 1 NO This column indicates if the account feed job tgrfeed
should feed future effective dated transaction.
TBBCTRL_TRANS_OR_SYSDATE_IND VARCHAR2 1 NO This column only has meaning if
tbbctrl_feed_futures_ind = "Y". It tells the
accounting feed process tgrfeed if it should use the
transaction date or the system date as the date for
gurfeed_trans_date, which determines when it posts.
Date: 21-JUN-2004 Page: 28
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
TBBCTRL_MISD_RUCL_CODE VARCHAR2 4 YES This column contains the default rule class which will
be used when miscellaneous transactions are feed,
provided of course none has been entered for the
transaction.
TBBCTRL_RECALC_FINAID_VR VARCHAR2 1 YES Voice Response(VR) recalculate financial aid flag.
TBBCTRL_ACCEPT_CHARGES_VR VARCHAR2 1 YES Voice Response(VR) accept charges indicator.
TBBCTRL_MINIMUM_PAYMENT_VR NUMBER 7 2 YES Voice Response(VR) minimum payment amount.
TBBCTRL_BALANCE_TYPE_VR VARCHAR2 1 YES Voice Response(VR) balance type indicator. Values are
D (Account balance due), T (Total balance due), N (No
percentage).
TBBCTRL_BALANCE_PERCENT_VR NUMBER 5 2 YES Voice Response(VR) minimum balance percentage for
payment.
TBBCTRL_DEFAULT_TBDS_CODE VARCHAR2 2 YES DEFAULT TERM-BASED DETAIL CODE DESIGNATOR: The term
designator to apply to a miscellaneous transaction
whose detail code is term-based.
TBBCTRL_CONTRACT_ROLL_IND VARCHAR2 1 NO TSACONT will default in the contract roll value when
creating a new contract.
TBBCTRL_STUDENT_CONT_ROLL_IND VARCHAR2 1 NO TSACONT will default in the student roll value when
creating a new contract.
TBBCTRL_EXEMPTION_ROLL_IND VARCHAR2 1 NO TSAEXPT will default in the exemption roll value when
creating a new exemption.
TBBCTRL_STUDENT_EXPT_ROLL_IND VARCHAR2 1 NO TSAEXPT will default in the student roll value when
creating a new exemption.
TBBCTRL_ADDRESS_REQ_IND VARCHAR2 1 NO Denotes whether address is required on TFAMISC.
TBBCTRL_PRIOR_TRANS_OR_SYSDATE VARCHAR2 1 NO PRIOR TRANSACTION DATE OR SYSDATE: This column
indicates if the account feed job tgrfeed should feed
prior effective dated transactions using (T)ransaction
date or (S)YSDATE.
TBBCTRL_PREAUTH_ENTRY_IND VARCHAR2 1 NO PREAUTHORIZED ENTRY INDICATOR: This field indicates
whether or not authorization numbers can be entered on
the student contract form prior to entering the
student authorization.
TBBCTRL_AUTO_INSTALL_PLAN_IND VARCHAR2 1 NO This column will have a value of "Y" if institution is
using automated calculation of assigned installment
plans in Web, VR and TSAISTP.
TBBCTRL_AUTO_ASSIGN_PLAN_IND VARCHAR2 1 NO This column will have a value of "Y" if plan should
automatically be assigned in Web, VR and TSAISTP when
student inquires about installment plan payments and
is not assigned.
TBBCTRL_CSRV_SUM_DATE_IND VARCHAR2 1 NO Y indicates transactions on TSICSRV will be summed by
effective date in addition to pidm and term.
Date: 21-JUN-2004 Page: 29
TABLE: TBBDEPC
CREATOR: TAISMGR
Deposit Detail Definition Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
TBBDEPC_DETAIL_CODE_DEPOSIT VARCHAR2 4 NO This field identifies the detail code that has been
identified as a deposit.
TBBDEPC_DETAIL_CODE_PAYMENT VARCHAR2 4 YES This field identifies the detail code that is used to
indicate the method of payment of the deposit. This
will be the default value when a deposit is entered on
an account.
TBBDEPC_AUTO_RELEASE_IND VARCHAR2 1 YES This field indicates if the deposit should be
automatically released on an account after the release
date. Valid values: Y - Auto release, N - Do not rel.
This will be the default value when a deposit is
entered on an account.
TBBDEPC_RELEASE_DATE DATE 7 YES This field indicates the default release date for the
deposit.
TBBDEPC_MIN_AMOUNT NUMBER 7 2 YES This field specifies the default minimum amount that
must remain as a deposit and not be released until the
expiration date of the deposit.
TBBDEPC_EXPIRATION_DATE DATE 7 YES This field specifies the default expiration date of
the deposit.
TBBDEPC_ACTIVITY_DATE DATE 7 NO This field specifies the most current date record was
created or updated.
TBBDEPC_DTYP_CODE VARCHAR2 3 YES Deposit Type Code.
Date: 21-JUN-2004 Page: 30
TABLE: TBBDETC
CREATOR: TAISMGR
Detail Charge/Payment Code Definition Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
TBBDETC_DETAIL_CODE VARCHAR2 4 NO This field identifies the detail code associated with
every charge and payment that can be entered onto an
account.
TBBDETC_DESC VARCHAR2 30 NO This field specifies a free-format description of the
detail code.
TBBDETC_TYPE_IND VARCHAR2 1 NO This field indicates the whether the detail code is a
charge or a payment. Valid values are: C - Charge, P
- Payment.
TBBDETC_PRIORITY VARCHAR2 3 NO This field indicates the priority of the detail code
for use in the application of payments process.
TBBDETC_LIKE_TERM_IND VARCHAR2 1 YES This field indicates if a detail code can only be
applied to a detail code in the same term in the
application of payment process. Valid value is: Y -
Yes, only apply to a like term. Used primarily for
financial aid.
TBBDETC_DCAT_CODE VARCHAR2 3 YES This field identifies the catagory of the detail code.
Detail codes can be group for reporting purposes into
catagories like cash, tuition, etc.
TBBDETC_AMOUNT NUMBER 7 2 YES This field specifies the default amount associated
with the detail code.
TBBDETC_TERM_CODE VARCHAR2 6 YES This field identifies the default term code associated
with the detail code.
TBBDETC_EFFECTIVE_DATE DATE 7 YES This field specifies the default effective date
associated with the detail code.
TBBDETC_REFUNDABLE_IND VARCHAR2 1 YES Refundable Indicator: Y to include credit amount in
refund process (TFRRFND/TSRRFND) and to include in
Location Management refund calculations; null if not
selected.
TBBDETC_RECEIPT_IND VARCHAR2 1 YES This field indicates if a receipt number should be
automatically generated when the detail code is
entered on an account. Valid values are: Y - Yes,
generate a receipt, blank - No receipt number.
TBBDETC_REFUND_IND VARCHAR2 1 YES This field indicates if the detail code is identified
as refund detail code that will generate an accounts
payable transaction in the accounting feed. Valid
values are: Y - Generate accounts payable transaction,
blank - Do not.
TBBDETC_ACTIVITY_DATE DATE 7 NO This field specifies the most current date record was
created or updated.
TBBDETC_PAYT_CODE VARCHAR2 1 YES This field indicates the type of payment the detail
code is. Default value is N - Non-cash.
TBBDETC_PREBILL_PRINT_IND VARCHAR2 1 YES Should this detail code be printed on a student
invoice. Valid values are: N (Do not print) or blank.
TBBDETC_GL_NOS_ENTERABLE VARCHAR2 1 YES Can accounting distribution information be overridden
for miscellaneous transactions on the TFAMISC form.
Values are Y and N.
Date: 21-JUN-2004 Page: 31
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
TBBDETC_TAXT_CODE VARCHAR2 2 YES This field indicates that this tuition fee is eligible
for a specified tax type
TBBDETC_TBDC_IND VARCHAR2 1 YES Indicates whether a detail code is associated with a
term-based designator (Y/N).
TBBDETC_DETAIL_CODE_IND VARCHAR2 1 YES DETAIL CODE INDICATOR: This column defines a detail
code indicator. Valid values are : (B)ill, (P)ayment,
(T)ransfer, (R)efund, Null.
TBBDETC_DETC_ACTIVE_IND VARCHAR2 1 NO DETC_ACTIVE_IND: Active Status Indicator of the Detail
Code.
TBBDETC_DIRD_IND VARCHAR2 1 NO DIRECT DEPOSIT REFUND INDICATOR: Indicator used to
determine whether refund code is to be processed
through direct deposit payment, (Y)es and (N)o.
TBBDETC_TIV_IND VARCHAR2 1 NO TITLE IV INDICATOR: This field indicates if the detail
code is identified as Title IV detail code. Valid
value is: (Y)es, Title IV detail code, and (N)o. This
is used primarily by the application of payment
process and Refund Process.
TBBDETC_INST_CHG_IND VARCHAR2 1 NO INSTITUTION CHARGE INDICATOR: This field indicates if
the detail code is identified as Institutional Charges
detail code. Valid value is: (Y)es, Institutional
charge detail code, and (N)o. This is used by the
application of payment process.
TBBDETC_LIKE_AIDY_IND VARCHAR2 1 NO AID YEAR INDICATOR: This field indicates if a detail
code can only be applied to a transaction in the same
aid year in the application of payment process. Valid
value is: (Y)es, apply only to a like aid year, and
(N)o; Used primarily for financial aid t
ransactions.
Date: 21-JUN-2004 Page: 32
TABLE: TBBDETC_SCT1
CREATOR: TAISMGR
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
TBBDETC_DETAIL_CODE VARCHAR2 4 NO
TBBDETC_DESC VARCHAR2 30 NO
TBBDETC_TYPE_IND VARCHAR2 1 NO
TBBDETC_PRIORITY VARCHAR2 3 NO
TBBDETC_LIKE_TERM_IND VARCHAR2 1 YES
TBBDETC_DCAT_CODE VARCHAR2 3 YES
TBBDETC_AMOUNT NUMBER 7 2 YES
TBBDETC_TERM_CODE VARCHAR2 6 YES
TBBDETC_EFFECTIVE_DATE DATE 7 YES
TBBDETC_REFUNDABLE_IND VARCHAR2 1 YES
TBBDETC_RECEIPT_IND VARCHAR2 1 YES
TBBDETC_REFUND_IND VARCHAR2 1 YES
TBBDETC_ACTIVITY_DATE DATE 7 NO
TBBDETC_PAYT_CODE VARCHAR2 1 YES
TBBDETC_PREBILL_PRINT_IND VARCHAR2 1 YES
TBBDETC_GL_NOS_ENTERABLE VARCHAR2 1 YES
TBBDETC_TAXT_CODE VARCHAR2 2 YES
TBBDETC_TBDC_IND VARCHAR2 1 YES
TBBDETC_DETAIL_CODE_IND VARCHAR2 1 YES
TBBDETC_DETC_ACTIVE_IND VARCHAR2 1 NO
TBBDETC_DIRD_IND VARCHAR2 1 NO
TBBDETC_TIV_IND VARCHAR2 1 NO
TBBDETC_INST_CHG_IND VARCHAR2 1 NO
TBBDETC_LIKE_AIDY_IND VARCHAR2 1 NO
Date: 21-JUN-2004 Page: 33
TABLE: TBBEACT
CREATOR: TAISMGR
Effective Dated Detail Code Account Definition Base Table.
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
TBBEACT_DETAIL_CODE VARCHAR2 4 NO DETAIL CODE: This field identifies the detail code
associated with the account definition. The code is
validated against the TBBDETC table.
TBBEACT_EFF_DATE DATE 7 NO EFFECTIVE DATE: The effective date of this particular
record.
TBBEACT_NCHG_DATE DATE 7 NO NEXT CHANGE DATE: The change date for this particular
record. IE: If the record included a termination date
the next change date would reflect the date that the
termination date was entered. Requires a futu
re
change date.
TBBEACT_TBDC_IND VARCHAR2 1 NO TERM-BASED INDICATOR: Indicates whether a detail code
is associated with a term-based designator (Y/N).
TBBEACT_ACTIVITY_DATE DATE 7 NO ACTIVITY DATE: The date that the information for the
record was entered or updated.
TBBEACT_USER_ID VARCHAR2 30 NO USER IDENTIFICATION: The unique identification of the
user.
TBBEACT_TERM_DATE DATE 7 YES TERMINATION DATE: The date in which the record is no
longer in effect.
Date: 21-JUN-2004 Page: 34
TABLE: TBBEACT_SCT1
CREATOR: TAISMGR
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
TBBEACT_DETAIL_CODE VARCHAR2 4 NO
TBBEACT_EFF_DATE DATE 7 NO
TBBEACT_NCHG_DATE DATE 7 NO
TBBEACT_TBDC_IND VARCHAR2 1 NO
TBBEACT_ACTIVITY_DATE DATE 7 NO
TBBEACT_USER_ID VARCHAR2 30 NO
TBBEACT_TERM_DATE DATE 7 YES
Date: 21-JUN-2004 Page: 35
TABLE: TBBESTU
CREATOR: TAISMGR
Exemption Student Authorization Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
TBBESTU_EXEMPTION_CODE VARCHAR2 8 NO This field identifies the exemption code associated
with a registration exemption.
TBBESTU_PIDM NUMBER 8 NO Internal Identification Number of the student who has
been authorized to receive payment from the exemption.
TBBESTU_TERM_CODE VARCHAR2 6 NO This field identifies the term associated with the
exemption code authorization.
TBBESTU_ACTIVITY_DATE DATE 7 NO This field specifies the most current date record was
created or updated.
TBBESTU_DEL_IND VARCHAR2 1 YES This field indicates if the student should be deleted
from the exemption and any money paid to the student
be backed out of their account.
TBBESTU_STUDENT_EXPT_ROLL_IND VARCHAR2 1 NO Y denotes that when the process TSRROLL is executed,
if the exemption the student is in rolls then the
student will also roll, N will cause student not to
roll.
TBBESTU_TERM_CODE_EXPIRATION VARCHAR2 6 YES The process TSRROLL will check to see if this term is
greater than the term the exemption is being rolled to
and if it is will consider the student exemption
expired and not roll it.
TBBESTU_USER_ID VARCHAR2 30 NO USER IDENTIFICATION: The unique identification of the
user.
TBBESTU_EXEMPTION_PRIORITY NUMBER 2 NO EXEMPTION PRIORITY: This indicates the priority of
this exemption for the student, if the student is
authorized for more than one exemption.
TBBESTU_MAX_STUDENT_AMOUNT NUMBER 7 2 YES MAXIMUM STUDENT_AMOUNT: This field indicates the
maximum amount a student can be exempted from.
Date: 21-JUN-2004 Page: 36
TABLE: TBBETBD
CREATOR: TAISMGR
Effective Dated Term-Based Designator Definition Base Table.
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
TBBETBD_EFF_DATE DATE 7 NO EFFECTIVE DATE: The effective date of this particular
record.
TBBETBD_NCHG_DATE DATE 7 NO NEXT CHANGE DATE: The change date for this particular
record. IE: If the record included a termination date
the next change date would reflect the date that the
termination date was entered. Requires a futu
re
change date.
TBBETBD_ACTIVITY_DATE DATE 7 NO ACTIVITY DATE: The date that the information for the
record was entered or updated.
TBBETBD_USER_ID VARCHAR2 30 NO USER IDENTIFICATION: The unique identification of the
user.
TBBETBD_TERM_DATE DATE 7 YES TERMINATION DATE: The date in which the record is no
longer in effect.
Date: 21-JUN-2004 Page: 37
TABLE: TBBEXPT
CREATOR: TAISMGR
Exemption Header Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
TBBEXPT_EXEMPTION_CODE VARCHAR2 8 NO This field identifies the exemption code associated
with a registration exemption.
TBBEXPT_TERM_CODE VARCHAR2 6 NO This field identifies the term associated with the
exemption code.
TBBEXPT_DESC VARCHAR2 30 NO This field specifies a free-format description of the
exemption.
TBBEXPT_DETAIL_CODE VARCHAR2 4 NO This field identifies the detail code that has been
identified as a payment to be posted as an exemption
payment to the student"s account.
TBBEXPT_ACTIVITY_DATE DATE 7 NO This field specifies the most current date record was
created or updated.
TBBEXPT_EXEMPTION_ROLL_IND VARCHAR2 1 NO Y denotes that the exemption will be rolled when the
process TSRROLL is executed.
TBBEXPT_STUDENT_EXPT_ROLL_IND VARCHAR2 1 NO Y denotes that when the process TSRROLL is executed,
if the exemption the student is in rolls then the
student will also roll.
TBBEXPT_TERM_CODE_EXPIRATION VARCHAR2 6 YES The process TSRROLL will check to see if this term is
greater than the term the exemption is being rolled to
and if it is will consider the exemption expired and
not roll it.
Date: 21-JUN-2004 Page: 38
TABLE: TBBIAAC
CREATOR: TAISMGR
Base Plan/Term record for Automated Installment Plan assignment rules.
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
TBBIAAC_INSTALLMENT_PLAN VARCHAR2 2 NO This field identifies the installment plan code for
which rules to assign payment plans are defined.
TBBIAAC_TERM_CODE VARCHAR2 6 NO This field specifies the term associated with the plan
rule .
TBBIAAC_ACTIVE_IND VARCHAR2 1 NO Y if assignment rules are active
TBBIAAC_ACTIVE_UNTIL_DATE DATE 7 YES Date after which assignment rules can not be used
TBBIAAC_USER_ID VARCHAR2 35 NO User ID that created or updated the record.
TBBIAAC_ACTIVITY_DATE DATE 7 NO This field specifies the most current date record was
created or updated.
Date: 21-JUN-2004 Page: 39
TABLE: TBBIPLN
CREATOR: TAISMGR
Base Plan/Term record for Automated Installment Plan calculation rules.
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
TBBIPLN_INSTALLMENT_PLAN VARCHAR2 2 NO Installment Plan code for term payment information
TBBIPLN_TERM_CODE VARCHAR2 6 NO Term code for installment plan payment information
TBBIPLN_PAY_TYPE VARCHAR2 1 NO "D" if based on dates and number of payments. "P" if
based on percentages. If the value is "P", records
will be in TBRISTP
TBBIPLN_START_DATE DATE 7 YES
TBBIPLN_NBR_OF_PAYMENTS NUMBER 2 YES How many payments are in the payment plan
TBBIPLN_PAY_PERIOD NUMBER 3 YES Number of days between pay periods
TBBIPLN_MIN_AMOUNT NUMBER 22 2 YES Miniumum amount that must exist for installments to be
created.
TBBIPLN_EXCL_PMT1_IND VARCHAR2 1 NO "Y" if need to subtract first payment amount from
principal when determining service charge
TBBIPLN_AUTH_AID_IND VARCHAR2 1 NO "Y" if calculation of installment plan principal
should include Authorized Aid
TBBIPLN_FIN_AID_MEMO_IND VARCHAR2 1 NO "Y" if calculation of installment plan principal
should include Financial Aid memos
TBBIPLN_OTHER_MEMO_IND VARCHAR2 1 NO "Y" if calculation of installment plan principal
should include Other (non Financial Aid) memos
TBBIPLN_USER_ID VARCHAR2 35 NO User ID that changed or updated the record
TBBIPLN_ACTIVITY_DATE DATE 7 NO Date record was changed
Date: 21-JUN-2004 Page: 40
SEQUENCE: TBBISEQ
CREATOR: TAISMGR
===================================================================================================================
Minimum Value: 1
Maximum Value: 9999999
Increment: 1
Last Number: 235304
Cache Size: 20
Order Option: NOT ORDERED
Cycle Option: NOCYCLE
Date: 21-JUN-2004 Page: 41
TABLE: TBBISTC
CREATOR: TAISMGR
Installment Plan Definition Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
TBBISTC_INSTALLMENT_PLAN VARCHAR2 2 NO This field identifies the installment plan code.
Installment plans are identified as short term loans,
tution payment plans, etc.
TBBISTC_DESC VARCHAR2 30 NO This field specifies a free-format description of the
installment plan.
TBBISTC_NUMBER_OF_PAYMENTS NUMBER 2 YES This field specifies the default number of payments
for the installment plan.
TBBISTC_PAY_PERIOD NUMBER 3 YES This field indicates the default number of days within
the payment periods.
TBBISTC_PRIN_DETAIL_CODE VARCHAR2 4 YES This field identifies the default detail code that
will be posted on an account as the principle that
will be due.
TBBISTC_FIRST_INSTALL_DATE DATE 7 YES This field specifies the default date the first
installment is due.
TBBISTC_TERM_CODE VARCHAR2 6 YES This field specifies the default term associated with
the installment plan.
TBBISTC_PLAN_AMOUNT NUMBER 7 2 YES This field specifies the default amount of the
installment plan.
TBBISTC_PLAN_DETAIL_CODE VARCHAR2 4 YES This field identifies the default detail code that
will be posted on the account at the time of the
installment plan, which will allow the principle
payments to be posted into the future.
TBBISTC_INT_RATE NUMBER 5 3 YES This field identifies the default interest rate
percentage associated with the installment plan.
TBBISTC_INT_DETAIL_CODE VARCHAR2 4 YES This field identifies the default detail code that
will be posted on the account with the interest
charges.
TBBISTC_SERV_CHARGE NUMBER 7 2 YES This field identifies the default service charge that
will be posted to an account at the time of the
installment plan.
TBBISTC_SERV_DETAIL_CODE VARCHAR2 4 YES This field identifies the default detail code that
will be posted on the account with the service charge.
TBBISTC_FUND_BALANCE NUMBER 9 2 YES This field identifies the fund balance for the
installment plan. It is reduced when an installment
plan is posted to an account.
TBBISTC_ACTIVITY_DATE DATE 7 NO This field specifies the most current date record was
created or updated.
TBBISTC_SVC_CHG_PCT NUMBER 5 3 YES This field specifies the services charges for
installment plan to be calculated as a percentage
instaed of a flat rate.
TBBISTC_PRIORITY NUMBER 6 YES This field specifies the priotity number if there is a
possibilty a student can be assigned to more than one
plan.
TBBISTC_AUTO_CALC_PLAN_IND VARCHAR2 1 NO This field will have "Y" if plan could be used for
automatic calculation of installment principal and
payments.
Date: 21-JUN-2004 Page: 42
TABLE: TBBMISC
CREATOR: TAISMGR
Miscellaneous Transaction Receipt Header Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
TBBMISC_RECEIPT_NUMBER NUMBER 8 NO This field identifies the receipt number associated
with the miscellaneous transcation. A miscellaneous
transcation is identified as money being received that
is not posted to a specific billed person or
non-person account.
TBBMISC_USER VARCHAR2 30 NO This field identifies the userid of the cashier that
posted the miscellaneous transaction.
TBBMISC_NAME VARCHAR2 30 YES This field specifies a free-format name of the person
or office receiving the receipt of the miscellaneous
transaction.
TBBMISC_STREET_LINE1 VARCHAR2 30 YES This field identifies the first line of the street
address for the receipt of the miscellaneous
transaction.
TBBMISC_STREET_LINE2 VARCHAR2 30 YES This field identifies the second line of the street
address for the receipt of the miscellaneous
transaction.
TBBMISC_STREET_LINE3 VARCHAR2 30 YES This field identifies the third line of the street
address for the receipt of the miscellaneous
transaction.
TBBMISC_CITY VARCHAR2 20 YES This field identifies the city associated with the
address for the receipt of the miscellaneous
transaction.
TBBMISC_STAT_CODE VARCHAR2 3 YES This field identifies the state associated with the
address for the receipt of the miscellaneous
transaction.
TBBMISC_ZIP VARCHAR2 10 YES This field identifies the zip code associated with the
address for the receipt of the miscellaneous
transaction.
TBBMISC_NATN_CODE VARCHAR2 5 YES This field identifies the nation/country associated
with the address for the receipt of the miscellaneous
transaction.
TBBMISC_ACTIVITY_DATE DATE 7 NO This field specifies the most current date record was
created or updated.
Date: 21-JUN-2004 Page: 43
TABLE: TBBPIDM
CREATOR: TAISMGR
Pidm Collector Table for TBVAPPL view and various collector processes.
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
TBBPIDM_PIDM NUMBER 8 NO TBBPIDM_PIDM is the internal pidm of the account being
processed.
TBBPIDM_SESSIONID VARCHAR2 30 YES TBBPIDM_SESSIONID contains the Oracle sessionid which
was active when this row was inserted. Not all
processes use this column however. If this column is
valued and the activity date is in the past, the entry
may be deleted.
TBBPIDM_ACTIVITY_DATE DATE 7 NO TBBPIDM_ACTIVITY_DATE is the date the row was created.
See comment on column for tbbpidm_sessionid for more
info.
Date: 21-JUN-2004 Page: 44
TABLE: TBBRETC
CREATOR: TAISMGR
Returned Check Code Definition Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
TBBRETC_DETAIL_CODE VARCHAR2 4 NO This field specifies the detail code that has been
identified at the code to use for returned checks.
TBBRETC_CHARGE_DETAIL_CODE VARCHAR2 4 YES This field identifies the detail code associated with
the penalty that can be charged when a returned check
is entered on an account.
TBBRETC_AMOUNT NUMBER 7 2 YES This field identifies the amount associated with the
penalty detail code.
TBBRETC_ACTIVITY_DATE DATE 7 NO This field specifies the most current date record was
created or updated.
Date: 21-JUN-2004 Page: 45
TABLE: TBBRQST
CREATOR: TAISMGR
Reapplication of Payment Request Table.
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
TBBRQST_PIDM NUMBER 8 NO Internal Identification Number of the account that
requested unapplication of payments.
TBBRQST_USER VARCHAR2 30 NO This field identifies the userid of the cashier who
requested unapplication of payments for the account.
TBBRQST_TERM_CODE VARCHAR2 6 YES This field identifies the term for which unapplication
of payments was requested.
TBBRQST_ACTIVITY_DATE DATE 7 NO This field specifies the most current date record was
created or updated.
TBBRQST_TRAN_NUMBER NUMBER 8 YES Transaction number for which an unapplication is to be
performed
TBBRQST_UNAPPLY_DATE DATE 7 YES Date used as criteria for unapplying payments.
Date: 21-JUN-2004 Page: 46
TABLE: TBBSBRL
CREATOR: TAISMGR
Schedule/Bill Rules Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
TBBSBRL_SBRC_CODE VARCHAR2 6 NO Schedule/Bill Rules Code.
TBBSBRL_ACCT_BILLABLE_IND VARCHAR2 1 NO Consider any student whose account is eligible to be
billed (Y/N).
TBBSBRL_ACTIVITY_DATE DATE 7 NO The date the record was last changed.
TBBSBRL_CDE_IND VARCHAR2 1 NO Include contracts, deposits, and exemptions (Y/N).
TBBSBRL_CRSE_REQUIRED_IND VARCHAR2 1 NO At least one course is required for selection (Y/N).
TBBSBRL_CURR_CRED_PREV_DBT_IND VARCHAR2 1 NO Should a current credit balance be applied to a
brevious debit balance (Y/N).
TBBSBRL_CURRENT_DUE_DATE DATE 7 YES All charges and payments with effective dates not
greater than this date will be included in current due
amount.
TBBSBRL_EXCL_REG_IND VARCHAR2 1 NO Exclude students who are not allowed to register
(Y/N).
TBBSBRL_FINAID_MEMO_AFFECT_DUE VARCHAR2 1 NO Should Financial Aid memos affect the calculation of
current term balance and previous balance (Y/N).
TBBSBRL_FORM_TYPE VARCHAR2 1 NO Form type for Schedule/Bill (M = Pre-printed Mailer, B
= blank 8.5" x 11" paper or letterhead).
TBBSBRL_INCL_ENROLL_IND VARCHAR2 1 NO Include students who count in enrollment (Y/N).
TBBSBRL_PREAUTH_CRED_AFF_DUE VARCHAR2 1 NO Should pre-authorized credits affect the amount due
(Y/N).
TBBSBRL_PRINT_DEP_IND VARCHAR2 1 NO Print deposits on the Schedule/Bill (Y/N).
TBBSBRL_PRINT_HEADINGS_IND VARCHAR2 1 NO Print page headings (Y/N). Used to suppress page
headings when printing on letterhead (Ignored if
TBBSBRL_FORM_TYPE = "M").
TBBSBRL_PRINT_ORDER VARCHAR2 2 NO Print order: ZN=Zip Code, Name; ZI=Zip Code, ID;
N=Name; I=ID.
TBBSBRL_PRINT_SCHEDULE_IND VARCHAR2 1 NO Print Schedule portion of Schedule/Bill (Y/N).
TBBSBRL_PROC_FINAID_IND VARCHAR2 1 NO Process Financial Aid (Y/N).
TBBSBRL_SEL_TERM_CHARGES VARCHAR2 1 NO Select term charges by (C)ategory, (S)ource, or (A)ll
(see TBRSBRL table).
TBBSBRL_SUM_FINAID_MEMO_IND VARCHAR2 1 NO Summarize Financial Aid memos (Y/N).
TBBSBRL_SUM_PAYMENTS VARCHAR2 1 NO Summarize payments by (D)etail code, (C)ategory,
(T)otal charges, (N)o summarization.
TBBSBRL_SUM_TERM_CHARGES VARCHAR2 1 NO Summarize term charges by (D)etail code, (C)ategory,
(S)ource, (T)otal charges.
TBBSBRL_USE_RULES_IND VARCHAR2 1 NO Should rules selection criteria be used (Y/N).
TBBSBRL_CURR_CODE VARCHAR2 4 YES Currency conversion code.
TBBSBRL_PTRM_CODE_IND VARCHAR2 1 YES Print Part of Term on Schedule/Bill (Y/N).
TBBSBRL_CRN_IND VARCHAR2 1 YES Print CRN on Schedule/Bill (Y/N).
TBBSBRL_SUBJ_CODE_IND VARCHAR2 1 YES Print Subject Code on Schedule/Bill (Y/N).
TBBSBRL_CRSE_NUMB_IND VARCHAR2 1 YES Print Course Number on Schedule/Bill (Y/N).
TBBSBRL_SECT_IND VARCHAR2 1 YES Print Section on Schedule/Bill (Y/N).
TBBSBRL_CAMP_CODE_IND VARCHAR2 1 YES Print Campus Code on Schedule/Bill (Y/N).
TBBSBRL_CRSE_TITLE_IND VARCHAR2 1 YES Print Course Title on Schedule/Bill (Y/N).
TBBSBRL_CREDIT_HR_IND VARCHAR2 1 YES Print Credit Hours on Schedule/Bill (Y/N).
Date: 21-JUN-2004 Page: 47
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
TBBSBRL_LEVL_CODE_IND VARCHAR2 1 YES Print Course Level on Schedule/Bill (Y/N).
TBBSBRL_RSTS_CODE_IND VARCHAR2 1 YES Print Course Status on Schedule/Bill (Y/N).
TBBSBRL_MEET_DAY_IND VARCHAR2 1 YES Print Meeting Days on Schedule/Bill (Y/N).
TBBSBRL_MEET_TIME_IND VARCHAR2 1 YES Print Meeting Times on Schedule/Bill (Y/N).
TBBSBRL_BLDG_CODE_IND VARCHAR2 1 YES Print Building on Schedule/Bill (Y/N).
TBBSBRL_ROOM_CODE_IND VARCHAR2 1 YES Print Room on Schedule/Bill (Y/N).
TBBSBRL_INSTRUCTOR_IND VARCHAR2 1 YES Print Primary Instructor Name on Schedule/Bill (Y/N).
TBBSBRL_GMOD_CODE_IND VARCHAR2 1 YES Print Grading Mode on Schedule/Bill (Y/N).
TBBSBRL_PTRM_HDNG VARCHAR2 3 YES Column heading to print for Part of Term.
TBBSBRL_CRN_HDNG VARCHAR2 5 YES Column heading to print for CRN.
TBBSBRL_SUBJ_HDNG VARCHAR2 4 YES Column heading to print for Subject.
TBBSBRL_CRSE_HDNG VARCHAR2 5 YES Column heading to print for Course Number.
TBBSBRL_SECT_HDNG VARCHAR2 3 YES Column heading to print for Section.
TBBSBRL_CAMP_HDNG VARCHAR2 3 YES Column heading to print for Campus.
TBBSBRL_TITLE_HDNG VARCHAR2 30 YES Column heading to print for Course Title.
TBBSBRL_CREDIT_HR_HDNG VARCHAR2 5 YES Column heading to print for Credit Hours.
TBBSBRL_LEVL_HDNG VARCHAR2 2 YES Column heading to print for Course Level.
TBBSBRL_STAT_HDNG VARCHAR2 2 YES Column heading to print for Course Status.
TBBSBRL_MEET_DAY_HDNG VARCHAR2 7 YES Column heading to print for Meeting Days.
TBBSBRL_MEET_TIME_HDNG VARCHAR2 11 YES Column heading to print for Meeting Times.
TBBSBRL_BLDG_HDNG VARCHAR2 6 YES Column heading to print for Building.
TBBSBRL_ROOM_HDNG VARCHAR2 5 YES Column heading to print for Room.
TBBSBRL_INSTR_HDNG VARCHAR2 21 YES Column heading to print for Primary Instructor Name.
TBBSBRL_GMOD_HDNG VARCHAR2 1 YES Column heading to print for Grading Mode.
TBBSBRL_TITLE_LNTH NUMBER 2 YES Length of Course Title to print on Schedule/Bill.
TBBSBRL_INSTR_LNTH NUMBER 2 YES Length of Primary Instructor Name to print on
Schedule/Bill.
Date: 21-JUN-2004 Page: 48
TABLE: TBBTBDS
CREATOR: TAISMGR
Term-Based Designator Rules Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
TBBTBDS_TBDS_CODE VARCHAR2 2 NO The term-based designator code (From the TTVTBDS
table).
TBBTBDS_OPERATOR VARCHAR2 1 NO The relationship between term code and term-based
designator.
TBBTBDS_TERM_CODE VARCHAR2 6 NO The term code associated with the term-based
designator code.
TBBTBDS_PRIOR_SUM_OP VARCHAR2 2 YES Identifies whether a term code is a prior-non-summer
or prior-summer only.
TBBTBDS_PRIOR_SUM_TERM_SUFX VARCHAR2 2 YES The last two characters of the term code.
TBBTBDS_ACTIVITY_DATE DATE 7 NO Most recent date record was revised.
TBBTBDS_USER_ID VARCHAR2 30 NO USER IDENTIFICATION: The unique identification of the
user.
TBBTBDS_EFF_DATE DATE 7 NO EFFECTIVE DATE: The effective date of this particular
record.
Date: 21-JUN-2004 Page: 49
TABLE: TBBTPRL
CREATOR: TAISMGR
Third Party Billing Rules Definition Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
TBBTPRL_TPRC_CODE VARCHAR2 10 NO CODE: Third Party Billing Rules Code.
TBBTPRL_PRINT_SCHEDULE_IND VARCHAR2 1 NO DISPLAY STUDENT SCHEDULE INDICATOR: This field
indicates whether the student schedule should be
displayed on the bill.
TBBTPRL_PRINT_SUMMARY_IND VARCHAR2 1 NO DISPLAY STUDENT SUMMARY INDICATOR: This field
indicates whether the summary information should be
displayed on the bill.
TBBTPRL_INDIVIDUAL_BILL_IND VARCHAR2 1 NO PRINT INDIVIDUAL BILL PER STUDENT INDICATOR: This
field indicates whether each student on a bill should
be on a separate page.
TBBTPRL_AUTHORIZE_NUM_IND VARCHAR2 1 NO PRINT AUTHORIZATION NUMBER INDICATOR: This field
indicates whether the student authorization number
should be printed on the bill.
TBBTPRL_REF_NUM_IND VARCHAR2 1 NO PRINT STUDENT REFERENCE NUMBER INDICATOR: This field
indicates whether the student Reference Number should
be printed on the bill.
TBBTPRL_STUDENT_TEXT_IND VARCHAR2 1 NO PRINT STUDENT TEXT INDICATOR: This field indicates
whether the student specific comment text should be
printed on the bill.
TBBTPRL_NUM_OF_COPIES NUMBER 3 NO NUMBER OF COPIES: This field indicates how many copies
of each bill should be printed.
TBBTPRL_CONTRACT_TEXT_IND VARCHAR2 1 NO Print Contract text on the Third Party Bill (Y/N).
TBBTPRL_CNUMBER_TEXT_IND VARCHAR2 1 NO Print Contract number text on the Third Party Bill
(Y/N).
TBBTPRL_ACTIVITY_DATE DATE 7 NO ACTIVITY DATE: The date when the information for this
record on the table was entered or last updated.
TBBTPRL_USER_ID VARCHAR2 30 NO USER IDENTIFICATION: The unique indentification code
of the last user to create or modify this record.
TBBTPRL_PTRM_CODE_IND VARCHAR2 1 YES Print Part of Term on Third Party Bill (Y/N).
TBBTPRL_CRN_IND VARCHAR2 1 YES Print CRN on Third Party Bill (Y/N).
TBBTPRL_SUBJ_CODE_IND VARCHAR2 1 YES Print Subject Code on Third Party Bill (Y/N).
TBBTPRL_CRSE_NUMB_IND VARCHAR2 1 YES Print Course Number on Third Party Bill (Y/N).
TBBTPRL_SECT_IND VARCHAR2 1 YES Print Section on Third Party Bill (Y/N).
TBBTPRL_CAMP_CODE_IND VARCHAR2 1 YES Print Campus Code on Third Party Bill (Y/N).
TBBTPRL_CRSE_TITLE_IND VARCHAR2 1 YES Print Course Title on Third Party Bill (Y/N).
TBBTPRL_CREDIT_HR_IND VARCHAR2 1 YES Print Credit Hours on Third Party Bill (Y/N).
TBBTPRL_LEVL_CODE_IND VARCHAR2 1 YES Print Course Level on Third Party Bill (Y/N).
TBBTPRL_RSTS_CODE_IND VARCHAR2 1 YES Print Course Status on Third Party Bill (Y/N).
TBBTPRL_MEET_DAY_IND VARCHAR2 1 YES Print Meeting Days on Third Party Bill (Y/N).
TBBTPRL_MEET_TIME_IND VARCHAR2 1 YES Print Meeting Times on Third Party Bill (Y/N).
TBBTPRL_BLDG_CODE_IND VARCHAR2 1 YES Print Building on Third Party Bill (Y/N).
TBBTPRL_ROOM_CODE_IND VARCHAR2 1 YES Print Room on Third Party Bill (Y/N).
TBBTPRL_INSTRUCTOR_IND VARCHAR2 1 YES Print Primary Instructor Name on Third Party Bill
(Y/N).
Date: 21-JUN-2004 Page: 50
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
TBBTPRL_GMOD_CODE_IND VARCHAR2 1 YES Print Grading Mode on Third Party Bill (Y/N).
TBBTPRL_PTRM_HDNG VARCHAR2 3 YES Column heading to print for Part of Term.
TBBTPRL_CRN_HDNG VARCHAR2 5 YES Column heading to print for CRN.
TBBTPRL_SUBJ_HDNG VARCHAR2 4 YES Column heading to print for Subject.
TBBTPRL_CRSE_HDNG VARCHAR2 5 YES Column heading to print for Course Number.
TBBTPRL_SECT_HDNG VARCHAR2 3 YES Column heading to print for Section.
TBBTPRL_CAMP_HDNG VARCHAR2 3 YES Column heading to print for Campus.
TBBTPRL_TITLE_HDNG VARCHAR2 30 YES Column heading to print for Course Title.
TBBTPRL_CREDIT_HR_HDNG VARCHAR2 5 YES Column heading to print for Credit Hours.
TBBTPRL_LEVL_HDNG VARCHAR2 2 YES Column heading to print for Course Level.
TBBTPRL_STAT_HDNG VARCHAR2 2 YES Column heading to print for Course Status.
TBBTPRL_MEET_DAY_HDNG VARCHAR2 7 YES Column heading to print for Meeting Days.
TBBTPRL_MEET_TIME_HDNG VARCHAR2 11 YES Column heading to print for Meeting Times.
TBBTPRL_BLDG_HDNG VARCHAR2 6 YES Column heading to print for Building.
TBBTPRL_ROOM_HDNG VARCHAR2 5 YES Column heading to print for Room.
TBBTPRL_INSTR_HDNG VARCHAR2 21 YES Column heading to print for Primary Instructor Name.
TBBTPRL_GMOD_HDNG VARCHAR2 1 YES Column heading to print for Grading Mode.
TBBTPRL_TITLE_LNTH NUMBER 2 YES Length of Course Title to print on Third Party Bill.
TBBTPRL_INSTR_LNTH NUMBER 2 YES Length of Primary Instructor Name to print on Third
Party Bill.
TBBTPRL_CURR_CODE VARCHAR2 4 YES Currency conversion code.
Date: 21-JUN-2004 Page: 51
TABLE: TBBUPRF
CREATOR: TAISMGR
Accounts Receivable Userid Profile table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
TBBUPRF_USERID VARCHAR2 30 NO Accounts receivable userid.
TBBUPRF_USER_NAME VARCHAR2 50 NO Free Format name associated to the userid.
TBBUPRF_SUPERV_IND VARCHAR2 1 NO This column contains "Y" is the userid has supervisory
capabilities, otherwise it conatins an "N".
TBBUPRF_SYSTEM_IND VARCHAR2 1 NO This value determines which system the userid belong
to. "F" for Finance, "S" for student, or "A" for all
systems. This value is also used to navigate through
certain forms.
TBBUPRF_RESTRICT_IND VARCHAR2 1 NO This column indicates wether the userid has
restrictions on the type of transaction it is allowed
to enter. If this value is "N" the userid is allowed
to enter any type of transactions, if "Y" the
allowable transactions are defined in TBRUPRF.
TBBUPRF_ACTIVITY_DATE DATE 7 NO The date the row was inserted or last modified.
Date: 21-JUN-2004 Page: 52
TABLE: TBRACCD
CREATOR: TAISMGR
Account Charge/Payment Detail Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
TBRACCD_PIDM NUMBER 8 NO Internal Identification Number of the person or
non-person account.
TBRACCD_TRAN_NUMBER NUMBER 8 NO This field identifies the transaction number
associated with each detail transaction on the
account.
TBRACCD_TERM_CODE VARCHAR2 6 NO This field identifies the term associated with the
transaction.
TBRACCD_DETAIL_CODE VARCHAR2 4 NO This field identifies the detail code associated with
the transaction.
TBRACCD_USER VARCHAR2 30 NO This field identifies the userid of the cashier that
posted the transaction to the account.
TBRACCD_ENTRY_DATE DATE 7 NO This field specifies the date the transaction was
entered on the account.
TBRACCD_AMOUNT NUMBER 12 2 NO This field indicates the dollar amount of the
transaction.
TBRACCD_BALANCE NUMBER 12 2 NO This field indicates the balance remaining from the
amount of the transaction. This balance is adjusted
by the application of payment process. A negative
balance is a credit on the account. A positive
balance is a charge.
TBRACCD_EFFECTIVE_DATE DATE 7 NO This field specifies the date the transaction becomes
effective. As of this date the transaction will be
calculated into amount due and will be eligible to be
fed to accounting.
TBRACCD_BILL_DATE DATE 7 YES This field specifies the date the transaction was
processed the billing procedure in "Statement" mode.
TBRACCD_DUE_DATE DATE 7 YES This field specifies the date the transaction is due.
This is calculated during the billing procedure in
"Statement" mode.
TBRACCD_DESC VARCHAR2 30 YES This field specifies a free-format description of the
transaction.
TBRACCD_RECEIPT_NUMBER NUMBER 8 YES This field identifies the receipt number associated
with the transaction if a receipt number was generated
when the transaction was entered.
TBRACCD_TRAN_NUMBER_PAID NUMBER 8 YES This field identifies the transaction number of a
specific application of payment. This transaction was
used to directly apply to the transaction number
specified here.
TBRACCD_CROSSREF_PIDM NUMBER 8 YES This field identifies the internal identification
number associated with a third party contract payment.
For the third party account the pidm would be the
students. For the student account the pidm would be
the third party.
TBRACCD_CROSSREF_NUMBER NUMBER 8 YES This field identifies the number of the contract or
exemption associated with the transaction.
Date: 21-JUN-2004 Page: 53
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
TBRACCD_CROSSREF_DETAIL_CODE VARCHAR2 4 YES This field identifies the detail code which was the
basis for a contract or exemption credit.
TBRACCD_SRCE_CODE VARCHAR2 1 NO This field identifies the source of how the
transaction was entered onto the account. For example
- registration, deposit, user-entered transaction.
The default value is T - User entered transaction.
TBRACCD_ACCT_FEED_IND VARCHAR2 1 NO This field indicates if the status of the transaction
in the accounting feed. Valid values are: Y - Feed
transaction, F - Transaction fed, N - Do not feed
transaction.
TBRACCD_ACTIVITY_DATE DATE 7 NO This field specifies the most current date record was
created or updated.
TBRACCD_SESSION_NUMBER NUMBER 5 NO Cashiering session for this transaction (0 = current
session).
TBRACCD_CSHR_END_DATE DATE 7 YES The end date of the cashiering session for this
transaction
TBRACCD_CRN VARCHAR2 5 YES This field will contain the crn associated with the
charge when assessment by crn is used
TBRACCD_CROSSREF_SRCE_CODE VARCHAR2 1 YES This field identifies the source code which was the
basis for a contract or exemption credit.
TBRACCD_LOC_MDT VARCHAR2 1 YES This field contains an M for monthly charges, a T for
termly charges, or a D for daily charges
TBRACCD_LOC_MDT_SEQ NUMBER 2 YES This column contains a number corresponding to the
sequence in which a monthly charge was added. This
will be used in refunding processing to uniquely
identify the corresponding calculated refund
TBRACCD_RATE NUMBER 12 6 YES The rate at which an account is charged for a specific
detail code.
TBRACCD_UNITS NUMBER 12 6 YES The number of units for which an account is charged
for a specific detail code.
TBRACCD_DOCUMENT_NUMBER VARCHAR2 8 YES A unique number which identifies a specific charge or
payment.
TBRACCD_TRANS_DATE DATE 7 YES The date used by the Finance System to control posting
to the ledgers.
TBRACCD_PAYMENT_ID VARCHAR2 20 YES PAYMENT ID: Additional Information as to the method of
payment. May be set to
Credit Card Number by Web
and/or VR credit card payment processing.
TBRACCD_INVOICE_NUMBER VARCHAR2 8 YES A unique number identifying the document being
updated.
TBRACCD_STATEMENT_DATE DATE 7 YES The date a statement was generated.
TBRACCD_INV_NUMBER_PAID VARCHAR2 8 YES The invoice number of a specific application of
payment.
TBRACCD_CURR_CODE VARCHAR2 4 YES TBRACCD_CURR_CODE: contains the foreign currency code
used when making a payment.
TBRACCD_EXCHANGE_DIFF NUMBER 12 2 YES TBRACCD_EXCHANGE_DIFF: Contains the difference between
the currency as of the transaction date and the value
of it as of the bill date for the invoice to which it
was applied.
TBRACCD_FOREIGN_AMOUNT NUMBER 12 2 YES The amount of the transaction as stated in foreign
currency.
TBRACCD_LATE_DCAT_CODE VARCHAR2 3 YES The category of the late charge detail code.
Date: 21-JUN-2004 Page: 54
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
TBRACCD_FEED_DATE DATE 7 YES The feed date is the date this row was processed by
tgrfeed and inserted into the GENERAL.GURFEED table.
TBRACCD_FEED_DOC_CODE VARCHAR2 8 YES The document code generated by GURFEED to identify and
feed this transaction to Finance.
TBRACCD_ATYP_CODE VARCHAR2 2 YES In combination with ATYP_SEQNO, the address for this
account detail record. (i.e. where the bill will be
sent)
TBRACCD_ATYP_SEQNO NUMBER 2 YES In combination with ATYP_CODE, the address for this
account detail record. (i.e. where the bill will be
sent)
TBRACCD_CARD_TYPE_VR VARCHAR2 1 YES CREDIT CARD TYPE: Credit Card Type as maintained in
TTVCCRD. Can be updated by
VR and/or Web credit card
payment processing.
TBRACCD_CARD_EXP_DATE_VR DATE 7 YES CREDIT CARD EXPIRATION DATE: Credit Card Expiration
Date Can be updated by VR
and/or Web card payment
processing.
TBRACCD_CARD_AUTH_NUMBER_VR VARCHAR2 12 YES AUTHORIZATION NUMBER FOR CREDIT CARD PAYMENT:
Authorization Number for credit
card payment can be
updated bu VR and/or Web credit card payment
processing.
TBRACCD_CROSSREF_DCAT_CODE VARCHAR2 3 YES This field identifies the category code which was the
basis for a contract or exemption credit.
TBRACCD_ORIG_CHG_IND VARCHAR2 1 YES ORIGINAL TITLE IV INDICATOR: This field indicates if
the transaction is to be
considered as original during
the Title IV calculation process, as opposed
to
adjustments to subsequent withdrawal.
TBRACCD_CCRD_CODE VARCHAR2 10 YES CREDIT CARD TYPE CODE: Code associated with the Credit
Card Type.
TBRACCD_MERCHANT_ID VARCHAR2 20 YES MERCHANT ID: Merchant ID associated with the Process
Name Code, Credit Card Type Code, and System Code.
The Merchant ID is included in the credit card payment
request transmitted to the third-party vendor
handling credit card payments.
TBRACCD_TAX_REPT_YEAR NUMBER 4 YES TAX REPORT YEAR: Year when this transaction reported
TBRACCD_TAX_REPT_BOX VARCHAR2 2 YES TAX REPORT BOX: Box in which reported - CB Qualified
Charges Billed, AC Adjustments to Prior Charges, SG
Schol or Grant, AS Adjustments to Schol or Grant
TBRACCD_TAX_AMOUNT NUMBER 12 2 YES TAX REPORT AMOUNT: Amount reported - sign relates pay
type to report box, may be pro-rated based on
allocation rules in ttrtxpr
TBRACCD_TAX_FUTURE_IND VARCHAR2 1 YES TAX REPORT FUTURE INDICATOR: Y if transaction reported
as a term beginning in a future tax year, or NULL
Date: 21-JUN-2004 Page: 55
TABLE: TBRACCT
CREATOR: TAISMGR
Detail Code Account Definition Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
TBRACCT_DETAIL_CODE VARCHAR2 4 NO This field identifies the detail code associated with
the account definition.
TBRACCT_ACCOUNT_A VARCHAR2 60 YES This field identifies the actual account number from
the finance system associated with this detail code.
For a detailed description see the field usage notes.
TBRACCT_ACCOUNT_B VARCHAR2 60 YES This field identifies the actual account number from
the finance system associated with this detail code.
For a detailed description see the field usage notes.
TBRACCT_PERCENT NUMBER 8 5 NO This field identifies the percentage of the amount
associated with the detail that would be posted to
Account A and Account B.
TBRACCT_ACTIVITY_DATE DATE 7 NO This field specifies the most current date record was
created or updated.
TBRACCT_A_COAS_CODE VARCHAR2 1 YES Banner Finance Chart Of Accounts Code for account a
TBRACCT_A_ACCI_CODE VARCHAR2 6 YES Banner Finance Index Code for account a
TBRACCT_A_FUND_CODE VARCHAR2 6 YES Banner Finance Fund Code for account a
TBRACCT_A_ORGN_CODE VARCHAR2 6 YES Banner Finance Organization Code for account a
TBRACCT_A_ACCT_CODE VARCHAR2 6 YES Banner Finance Account Code for account a
TBRACCT_A_PROG_CODE VARCHAR2 6 YES Banner Finance Program Code for account a
TBRACCT_A_ACTV_CODE VARCHAR2 6 YES Banner Finance Activity Code for account a
TBRACCT_A_LOCN_CODE VARCHAR2 6 YES Banner Finance Location Code for account a
TBRACCT_B_COAS_CODE VARCHAR2 1 YES Banner Finance Chart Of Accounts Code for account b
TBRACCT_B_ACCI_CODE VARCHAR2 6 YES Banner Finance Index Code for account b
TBRACCT_B_FUND_CODE VARCHAR2 6 YES Banner Finance Fund Code for account b
TBRACCT_B_ORGN_CODE VARCHAR2 6 YES Banner Finance Organization Code for account b
TBRACCT_B_ACCT_CODE VARCHAR2 6 YES Banner Finance Account Code for account b
TBRACCT_B_PROG_CODE VARCHAR2 6 YES Banner Finance Program Code for account b
TBRACCT_B_ACTV_CODE VARCHAR2 6 YES Banner Finance Activity Code for account b
TBRACCT_B_LOCN_CODE VARCHAR2 6 YES Banner Finance Location Code for account b
TBRACCT_A_RUCL_CODE1 VARCHAR2 4 YES This is the rule class code for the A ACCOUNT to be
used when the transaction is initially fed to
accounting
TBRACCT_A_RUCL_CODE2 VARCHAR2 4 YES This is the rule class code for the A ACCOUNT to be
used when the application of payment transaction is
fed to accounting and the opposite side of the
transaction is the opposite type of detail code
TBRACCT_A_RUCL_CODE3 VARCHAR2 4 YES This is the rule class code for the A ACCOUNT to be
used when the application of payment transaction is
fed to accounting and the opposite side of the
transaction is the same type of detail code
TBRACCT_B_RUCL_CODE1 VARCHAR2 4 YES This is the rule class code for the B ACCOUNT to be
used when the transaction is initially fed to
accounting
TBRACCT_B_RUCL_CODE2 VARCHAR2 4 YES This is the rule class code for the B ACCOUNT to be
used when the application of payment transaction is
fed to accounting and the opposite side of the
transaction is the opposite type of detail code
Date: 21-JUN-2004 Page: 56
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
TBRACCT_B_RUCL_CODE3 VARCHAR2 4 YES This is the rule class code for the B ACCOUNT to be
used when the application of payment transaction is
fed to accounting and the opposite side of the
transaction is the same type of detail code
TBRACCT_TBDS_CODE VARCHAR2 2 YES Identifies the term-based designator for the detail
code (From TBBTBDS table).
TBRACCT_DETC_EFF_DATE DATE 7 NO EFFECTIVE DATE: The effective date of this particular
record.
TBRACCT_USER_ID VARCHAR2 30 NO USER IDENTIFICATION: The unique identification of the
user.
Date: 21-JUN-2004 Page: 57
TABLE: TBRACCT_SCT1
CREATOR: TAISMGR
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
TBRACCT_DETAIL_CODE VARCHAR2 4 NO
TBRACCT_ACCOUNT_A VARCHAR2 60 YES
TBRACCT_ACCOUNT_B VARCHAR2 60 YES
TBRACCT_PERCENT NUMBER 8 5 NO
TBRACCT_ACTIVITY_DATE DATE 7 NO
TBRACCT_A_COAS_CODE VARCHAR2 1 YES
TBRACCT_A_ACCI_CODE VARCHAR2 6 YES
TBRACCT_A_FUND_CODE VARCHAR2 6 YES
TBRACCT_A_ORGN_CODE VARCHAR2 6 YES
TBRACCT_A_ACCT_CODE VARCHAR2 6 YES
TBRACCT_A_PROG_CODE VARCHAR2 6 YES
TBRACCT_A_ACTV_CODE VARCHAR2 6 YES
TBRACCT_A_LOCN_CODE VARCHAR2 6 YES
TBRACCT_B_COAS_CODE VARCHAR2 1 YES
TBRACCT_B_ACCI_CODE VARCHAR2 6 YES
TBRACCT_B_FUND_CODE VARCHAR2 6 YES
TBRACCT_B_ORGN_CODE VARCHAR2 6 YES
TBRACCT_B_ACCT_CODE VARCHAR2 6 YES
TBRACCT_B_PROG_CODE VARCHAR2 6 YES
TBRACCT_B_ACTV_CODE VARCHAR2 6 YES
TBRACCT_B_LOCN_CODE VARCHAR2 6 YES
TBRACCT_A_RUCL_CODE1 VARCHAR2 4 YES
TBRACCT_A_RUCL_CODE2 VARCHAR2 4 YES
TBRACCT_A_RUCL_CODE3 VARCHAR2 4 YES
TBRACCT_B_RUCL_CODE1 VARCHAR2 4 YES
TBRACCT_B_RUCL_CODE2 VARCHAR2 4 YES
TBRACCT_B_RUCL_CODE3 VARCHAR2 4 YES
TBRACCT_TBDS_CODE VARCHAR2 2 YES
TBRACCT_DETC_EFF_DATE DATE 7 NO
TBRACCT_USER_ID VARCHAR2 30 NO
Date: 21-JUN-2004 Page: 58
TABLE: TBRACDT
CREATOR: TAISMGR
Account Charge/Payment Detail Text Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
TBRACDT_PIDM NUMBER 8 NO Internal Identification Number of the person or
non-person account.
TBRACDT_TRAN_NUMBER NUMBER 8 NO This field identifies the transaction number
associated with each detail transaction on the
account.
TBRACDT_SEQ_NUMBER NUMBER 23 20 NO This field identifies the internal sequence number
associated with each line of text.
TBRACDT_TEXT VARCHAR2 60 YES This field specifies free-format text, further
describing the transaction of the transaction.
TBRACDT_PRINT_IND VARCHAR2 1 NO Indicates whether this comment should print on the
bill.
TBRACDT_ACTIVITY_DATE DATE 7 NO This field specifies the most current date record was
created or updated.
Date: 21-JUN-2004 Page: 59
TABLE: TBRAPPL
CREATOR: TAISMGR
Detail Application of Payment Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
TBRAPPL_PIDM NUMBER 8 NO Internal Identification Number of the person or
non-person account with an application of payment
record.
TBRAPPL_PAY_TRAN_NUMBER NUMBER 8 NO This field identifies the transaction number of the
detail code used as the payment transaction in
application of payments.
TBRAPPL_CHG_TRAN_NUMBER NUMBER 8 NO This field identifies the transaction number of the
detail code used as the charge transaction in
application of payments.
TBRAPPL_AMOUNT NUMBER 12 2 NO This field indicates the amount of the payment that
paid off the charge.
TBRAPPL_DIRECT_PAY_IND VARCHAR2 1 YES This flag indicates that the transaction was a direct
application of payment specified when the transaction
was entered on the account. Valid value is: Y -
Direct application of payment.
TBRAPPL_REAPPL_IND VARCHAR2 1 YES This flag indicates that this application of payment
record was created because the unapplication of
payment process had been run for this account. Valid
value is: Y - this application of payment was due to a
reapplication.
TBRAPPL_USER VARCHAR2 30 NO This field identifies the userid of the cashier who
executed the application of payment process to
generate this record.
TBRAPPL_ACCT_FEED_IND VARCHAR2 1 NO This flad indicates the status of the application of
payment in the accounting feed process. Valid values
are: Y - Transaction is ready to feed, F - Transaction
has been fed.
TBRAPPL_ACTIVITY_DATE DATE 7 NO This field specifies the most current date record was
created or updated.
TBRAPPL_FEED_DATE DATE 7 YES The feed date is the date this row was processed by
tgrfeed and inserted into the GENERAL.GURFEED table.
TBRAPPL_FEED_DOC_CODE VARCHAR2 8 YES The document code generated by GURFEED to identify and
feed this transaction to Finance.
Date: 21-JUN-2004 Page: 60
TABLE: TBRCACC
CREATOR: TAISMGR
Contract Account Level Authorization Definition Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
TBRCACC_PIDM NUMBER 8 NO Internal Identification Number of the non-person
account that is identified as a third party contract.
TBRCACC_CONTRACT_NUMBER NUMBER 8 NO This field identifies the contract number associated
with the third party for the term.
TBRCACC_TERM_CODE VARCHAR2 6 NO This field identifies the term associated with the
third party contract number.
TBRCACC_MIN_AMOUNT NUMBER 7 2 YES This field indicates the minimum amount the student
must pay of the designated charges on a student"s
account that the third party doesn"t cover.
TBRCACC_MAX_AMOUNT NUMBER 7 2 YES This field indicates the maximum amount the third
party will pay of the designated source charges on a
student"s account.
TBRCACC_PERCENT NUMBER 3 YES This field indicates the percentage of the total
source charges the third partywill pay of the
student"s account.
TBRCACC_SRCE_CODE VARCHAR2 1 NO This field contains the source code which will be paid
by the contract.
TBRCACC_ACTIVITY_DATE DATE 7 NO This field specifies the most current date record was
created or updated.
TBRCACC_ACC_PRIORITY NUMBER 3 YES CATEGORY CODE PRIORITY: This indicates the priority of
this category for contract payment calculation for a
student. Used only when student maximum is applied.
Date: 21-JUN-2004 Page: 61
TABLE: TBRCASN
CREATOR: TAISMGR
Cashier Assignment Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
TBRCASN_SUPERVISOR_USERID VARCHAR2 30 NO The Accounts Receivable userid of the supervisor.
TBRCASN_CASHIER_USERID VARCHAR2 30 NO The Accounts Receivable userid of the cashier.
TBRCASN_ACTIVITY_DATE DATE 7 NO The most current date the record was created or
updated.
Date: 21-JUN-2004 Page: 62
TABLE: TBRCBRQ
CREATOR: TAISMGR
Collector Table Used For Recursive Invoice Processing
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
TBRCBRQ_PIDM NUMBER 8 NO
TBRCBRQ_TERM_CODE VARCHAR2 6 NO
TBRCBRQ_SESSIONID VARCHAR2 30 YES
TBRCBRQ_PRINTER VARCHAR2 30 YES
TBRCBRQ_ACTIVITY_DATE DATE 7 NO
Date: 21-JUN-2004 Page: 63
TABLE: TBRCCAT
CREATOR: TAISMGR
Contract Detail Category Level Authorization Definition Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
TBRCCAT_PIDM NUMBER 8 NO Internal Identification Number of the non-person
account that is identified as a third party account.
TBRCCAT_CONTRACT_NUMBER NUMBER 8 NO CONTRACT NUMBER: This field identifies the contract
number associated with the third party for the term.
TBRCCAT_TERM_CODE VARCHAR2 6 NO TERM CODE: This field identifies the term associated
with the third party contract number.
TBRCCAT_DCAT_CODE VARCHAR2 3 NO DETAIL CATEGORY CODE: This field identifies the detail
category code that the third party contract will apply
to.
TBRCCAT_ACTIVITY_DATE DATE 7 NO ACTIVITY DATE: This field specifies the most current
date record was created or updated.
TBRCCAT_USER_ID VARCHAR2 30 NO USER ID: This field identifies the system user signon
id initiating hold.
TBRCCAT_MIN_AMOUNT NUMBER 7 2 YES MINIMUM AMOUNT: This field indicates the minimum
amount the student must pay for the charge associated
with the detail category code, that the third party
will not cover.
TBRCCAT_MAX_AMOUNT NUMBER 7 2 YES MAXIMUM AMOUNT: This field indicates the maximum
amount the third party contract will cover of the
detail category code.
TBRCCAT_PERCENT NUMBER 3 YES PERCENT: This field identifies the percentage of the
charge associated with the detail category code that
the third party contract will cover.
TBRCCAT_I_E_SOURCE_IND VARCHAR2 1 YES INCLUDE EXCLUDE SOURCE INDICATOR: Indicator telling
whether the source codes in TBRCCSI should be included
or excluded. Value of Null indicates that all sources
in TTVSRCE are included.
TBRCCAT_DCAT_PRIORITY NUMBER 3 YES CATEGORY CODE PRIORITY: This indicates the priority of
this category for contract payment calculation for a
student. Used only when student maximum is applied.
Date: 21-JUN-2004 Page: 64
TABLE: TBRCCRC
CREATOR: TAISMGR
Collector table used by the TBVRCPT view
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
TBRCCRC_SESSIONID VARCHAR2 30 NO
TBRCCRC_RECEIPT_NUMBER NUMBER 8 NO
TBRCCRC_ACTIVITY_DATE DATE 7 NO
Date: 21-JUN-2004 Page: 65
TABLE: TBRCCSI
CREATOR: TAISMGR
Contract Detail Category Level Authorization Source Definition Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
TBRCCSI_PIDM NUMBER 8 NO Internal Identification Number of the non-person
account that is identified as a third party account.
TBRCCSI_CONTRACT_NUMBER NUMBER 8 NO CONTRACT NUMBER: This field identifies the contract
number associated with the third party for the term.
TBRCCSI_TERM_CODE VARCHAR2 6 NO TERM CODE: This field identifies the term associated
with the third party contract number.
TBRCCSI_DCAT_CODE VARCHAR2 3 NO DETAIL CATEGORY CODE: This field identifies the detail
category code that the third party contract will apply
to.
TBRCCSI_SOURCE_CODE VARCHAR2 1 NO SOURCE CODE: This field contains the source code which
will be paid by the contract.
TBRCCSI_ACTIVITY_DATE DATE 7 NO ACTIVITY DATE: This field specifies the most current
date record was created or updated.
TBRCCSI_USER_ID VARCHAR2 30 NO USER ID: This field identifies the system user signon
id initiating hold
Date: 21-JUN-2004 Page: 66
TABLE: TBRCDET
CREATOR: TAISMGR
Contract Detail Level Authorization Definition Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
TBRCDET_PIDM NUMBER 8 NO Internal Identification Number of the non-person
account that is identified as a third party account.
TBRCDET_CONTRACT_NUMBER NUMBER 8 NO This field identifies the contract number associated
with the third party for the term.
TBRCDET_TERM_CODE VARCHAR2 6 NO This field identifies the term associated with the
third party contract number.
TBRCDET_DETAIL_CODE VARCHAR2 4 NO This field identifies the registration detail code
that the third party contract will apply to.
TBRCDET_MIN_AMOUNT NUMBER 7 2 YES This field indicates the minimum amount the student
must pay for the registration charge associated with
the detail code, that the third party will not cover.
TBRCDET_MAX_AMOUNT NUMBER 7 2 YES This field indicates the maximum amount the third
party contract will cover of the registration detail
code.
TBRCDET_PERCENT NUMBER 3 YES This field identifies the percentage of the charge
associated with the detail code that the third party
contract will cover.
TBRCDET_CRHR NUMBER 4 2 YES This field is currently not used.
TBRCDET_ACTIVITY_DATE DATE 7 NO This field specifies the most current date record was
created or updated.
TBRCDET_SRCE_CODE VARCHAR2 1 NO This field contains the source code which will be paid
by the contract.
TBRCDET_I_E_SOURCE_IND VARCHAR2 1 YES INCLUDE EXCLUDE SOURCE INDICATOR: Indicator telling
whether the source codes in TBRCDSI should be included
or excluded. Value of Null indicates that all sources
in TTVSRCE are included.
TBRCDET_DETAIL_PRIORITY NUMBER 3 YES DETAIL CODE PRORITY: This indicates the priority of
this detail code for contract payment calculation for
a student. Used only when student maximum is applied.
Date: 21-JUN-2004 Page: 67
TABLE: TBRCDSI
CREATOR: TAISMGR
Contract Detail Level Authorization Source Definition Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
TBRCDSI_PIDM NUMBER 8 NO Internal Identification Number of the non-person
account that is identified as a third party account.
TBRCDSI_CONTRACT_NUMBER NUMBER 8 NO CONTRACT NUMBER: This field identifies the contract
number associated with the third party for the term.
TBRCDSI_TERM_CODE VARCHAR2 6 NO TERM CODE: This field identifies the term associated
with the third party contract number.
TBRCDSI_DETAIL_CODE VARCHAR2 4 NO DETAIL CODE: This field identifies the detail category
code that the third party contract will apply to.
TBRCDSI_SOURCE_CODE VARCHAR2 1 NO SOURCE CODE: This field contains the source code which
will be paid by the contract.
TBRCDSI_ACTIVITY_DATE DATE 7 NO ACTIVITY DATE: This field specifies the most current
date record was created or updated.
TBRCDSI_USER_ID VARCHAR2 30 NO USER ID: This field identifies the system user signon
id initiating hold
Date: 21-JUN-2004 Page: 68
TABLE: TBRCHLD
CREATOR: TAISMGR
Collector Table Used For Auto Hold Report Processing.
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
TBRCHLD_PIDM NUMBER 8 NO PIDM: Internal Identification Number of the person
account.
TBRCHLD_SESSIONID VARCHAR2 30 NO SESSION ID: This field identifies a unique internal
identification that is generated everytime a user
signs on.
TBRCHLD_HOLD_RULE_CODE VARCHAR2 6 NO HOLD RULE CODE: This field identifies the hold rule
code applied.
TBRCHLD_HOLD_CODE VARCHAR2 2 NO HOLD CODE: This field identifies the type of hold on
an account.
TBRCHLD_A_R_P_IND VARCHAR2 1 NO APPLY RELEASE PURGE INDICATOR: This field indicates
whether a hold on the account is being applied,
released, or purged.
TBRCHLD_FROM_DATE DATE 7 NO FROM DATE: This field identifies the effective begin
date of hold.
TBRCHLD_TO_DATE DATE 7 NO TO DATE: This field identifies the end date hold
expires.
TBRCHLD_ACTIVITY_DATE DATE 7 NO ACTIVITY DATE: Most recent date record was revised.
TBRCHLD_USER_ID VARCHAR2 30 NO USER ID: This field identifies the system user signon
id modifying hold.
TBRCHLD_ACCOUNT_BALANCE NUMBER 12 2 YES ACCOUNT BALANCE: This field is the calculated person
balance amount.
TBRCHLD_AGING_BALANCE NUMBER 12 2 YES AGING BALANCE: This field is the calculated aged
person balance amount.
TBRCHLD_FUT_BALANCE NUMBER 12 2 YES FUTURE DATED BALANCE: This field is the calculated
future dated balance amount.
TBRCHLD_FIN_AID_BALANCE NUMBER 12 2 YES FINANCIAL AID BALANCE: This field is the calculated
financial aid balance amount.
TBRCHLD_MEMO_BALANCE NUMBER 12 2 YES MEMO AID BALANCE: This field is the calculated memo
balance amount.
Date: 21-JUN-2004 Page: 69
TABLE: TBRCISP
CREATOR: TAISMGR
Automated Installment Plan collector table.
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
TBRCISP_SESSIONID VARCHAR2 30 NO SESSIONID : Oracle session ID that wrote the record
TBRCISP_PIDM NUMBER 8 NO PIDM : PIDM of person who payments are for
TBRCISP_INSTALLMENT_PLAN VARCHAR2 2 NO INSTALLMENT PLAN : Installment Plan code for term
percentage payment information
TBRCISP_TERM_CODE VARCHAR2 6 NO TERM CODE : Term Code for installment plan percentage
payment information
TBRCISP_SEQ_NO NUMBER 2 NO SEQ NO : Sequence Number of Payment
TBRCISP_DUE_DATE DATE 7 NO DUE DATE : Date payment is due
TBRCISP_AMOUNT NUMBER 22 2 NO PAYMENT Amount : Percentage of installment plan
Principal that is this payment amount
TBRCISP_TRAN_TYPE VARCHAR2 1 NO Transaction Type : P - Principal Y - Payment S -
Service Charge I - Interest. Use this field if only
want Payments.
TBRCISP_DETAIL_CODE VARCHAR2 4 NO Detail Code : Detail Code associated with this
transaction.
TBRCISP_REF_NUMBER NUMBER NO REF Number : The reference number of installment plan
from TBRISTL. Needed for TBRACCD_CROSSREF_NUMBER
TBRCISP_USER_ID VARCHAR2 35 NO The user id that inserted or updated the record in the
TBRCISP table.
TBRCISP_ACTIVITY_DATE DATE 7 NO ACTIVITY DATE: The date that the information for the
row was inserted or updated in the TBRCISP table.
Date: 21-JUN-2004 Page: 70
TABLE: TBRCLCT
CREATOR: TAISMGR
Collector File Used In Credit Calculations
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
TBRCLCT_PIDM NUMBER 8 NO Internal Identification Number of the student"s
account that has a financial aid credit.
TBRCLCT_TERM_CODE VARCHAR2 6 NO This field identifies the term the financial aid
credit is for.
TBRCLCT_SESSIONID VARCHAR2 30 NO This field identifies a unique internal identification
that is generated everytime a user signs on and off
the system.
TBRCLCT_ACTIVITY_DATE DATE 7 NO This field specifies the most current date record was
created or updated.
TBRCLCT_EXPT_PRTY VARCHAR2 1 NO The order in which the exemption is processed against
the account.
TBRCLCT_CONT_PRTY VARCHAR2 1 NO The order in which the contract is processed against
the account.
Date: 21-JUN-2004 Page: 71
TABLE: TBRCMIS
CREATOR: TAISMGR
Collector Table Used For Recursive Miscellaneous Receipt Printing
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
TBRCMIS_RECEIPT_NUMBER NUMBER 8 NO
TBRCMIS_PRINTER VARCHAR2 30 YES
TBRCMIS_DUPLICATE_IND VARCHAR2 1 NO
TBRCMIS_SESSIONID VARCHAR2 30 YES
TBRCMIS_MISC_IND VARCHAR2 1 YES
TBRCMIS_ACTIVITY_DATE DATE 7 NO
Date: 21-JUN-2004 Page: 72
TABLE: TBRCMNT
CREATOR: TAISMGR
Comment Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
TBRCMNT_PIDM NUMBER 8 NO Internal Idnetificattion Number of the person or
non-person account that has a comment.
TBRCMNT_FORM VARCHAR2 7 NO This field identifies the form identification where
the comment was entered. Valid values are: TBADETL,
TBAISTL, TBACOLC.
TBRCMNT_SEQ_NUMBER NUMBER 23 20 NO This field identifies the internal sequence number
associated with each line of comment.
TBRCMNT_ORIG_CODE VARCHAR2 4 NO This field identifies the code of the originator of
the comment. The originator could either be an office
or individual.
TBRCMNT_TEXT VARCHAR2 60 YES This field specifies the free-format comment text.
TBRCMNT_ACTIVITY_DATE DATE 7 NO This field specifies the most current date record was
created or updated.
TBRCMNT_USER VARCHAR2 30 YES This field denotes the user who entered the comment
text.
Date: 21-JUN-2004 Page: 73
TABLE: TBRCOLC
CREATOR: TAISMGR
Account Collection Repeating Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
TBRCOLC_PIDM NUMBER 8 NO Internal Identification Number of the person or
non-person account assigned to a collection agency.
TBRCOLC_COLC_AGENCY_PIDM NUMBER 8 NO This field identifies the internal identification
number of the collection agency.
TBRCOLC_COLC_AGENCY_DATE DATE 7 NO This field specifies the date the account was assigned
to the collection agency.
TBRCOLC_ACTIVITY_DATE DATE 7 NO This field specifies the most current date record was
created or updated.
TBRCOLC_LAST_REPORT_DATE DATE 7 YES Date last collection agency report was run. Used to
determine changes in student balance.
Date: 21-JUN-2004 Page: 74
TABLE: TBRCOLR
CREATOR: TAISMGR
Cashiering Collector Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
TBRCOLR_SESSIONID VARCHAR2 30 NO This field identifies a unique internal identification
that is generated everytime a user signs on and off
the system.
TBRCOLR_SESSION_USER VARCHAR2 30 NO This field identifies the userid of the cashier who
entered a charge or payment on an account to create a
cashiering session.
TBRCOLR_SESSION_NUMBER NUMBER 5 NO This field identifies the number of the session for
the cashier.
TBRCOLR_SESS_START_DATE DATE 7 NO This field specifies the start date of the cashier
session. The date is the first date a charge or
payment was entered into the session by the cashier.
TBRCOLR_SESS_END_DATE DATE 7 NO This field specifies the end date of the cashier
session. The date is the last date a charge or
payment was entered into the session by the cashier.
TBRCOLR_ACTIVITY_DATE DATE 7 NO This field specifies the most current date record was
created or updated.
Date: 21-JUN-2004 Page: 75
TABLE: TBRCRCP
CREATOR: TAISMGR
Collector Table Used For Recursive Receipt Printing
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
TBRCRCP_RECEIPT_NUMBER NUMBER 8 NO
TBRCRCP_PRINTER VARCHAR2 30 YES
TBRCRCP_DUPLICATE_IND VARCHAR2 1 NO
TBRCRCP_SESSIONID VARCHAR2 30 YES
TBRCRCP_MISC_IND VARCHAR2 1 YES
TBRCRCP_ACTIVITY_DATE DATE 7 NO
Date: 21-JUN-2004 Page: 76
TABLE: TBRCREQ
CREATOR: TAISMGR
Contracts Course Requirements Table.
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
TBRCREQ_PIDM NUMBER 8 NO CONTRACT PIDM: Internal Identification Number that is
identified as a third party account.
TBRCREQ_CONTRACT_NUMBER NUMBER 8 NO CONTRACT NUMBER: This field identifies the contract
number associated with the third party term.
TBRCREQ_TERM_CODE VARCHAR2 6 NO TERM CODE: This field identifies the term associated
with the third party contract number.
TBRCREQ_ACTIVITY_DATE DATE 7 NO ACTIVITY DATE: The date when the information for this
record on the table was entered or last updated.
TBRCREQ_USER_ID VARCHAR2 30 NO USER IDENTIFICATION: The unique identification code of
the last user to create or modify this record.
TBRCREQ_SEQNO NUMBER 23 20 YES SEQUENCE NUMBER: The sequnce number is used to insure
the records will be in the correct order.
TBRCREQ_TESC_CODE VARCHAR2 4 YES TESC CODE: The test code associated with the contract
restriction.
TBRCREQ_TEST_SCORE VARCHAR2 5 YES TEST SCORE: The minimum score of the test code.
TBRCREQ_SUBJ_CODE VARCHAR2 4 YES SUBJECT CODE: This field defines the subject area for
course contract restriction requirements.
TBRCREQ_CRSE_NUMB VARCHAR2 5 YES COURSE NUMBER: This field defines the course number
for course contract restriction requirements.
TBRCREQ_LEVL_CODE VARCHAR2 2 YES LEVEL CODE: The level code for grade.
TBRCREQ_CRN VARCHAR2 5 YES CRN: The course reference number of section student
must be registered for.
TBRCREQ_CONNECTOR VARCHAR2 1 YES CONNECTOR: The AND/OR connector used when restriction
for the subject/course/term can have an AND/OR
relation.
TBRCREQ_LPAREN VARCHAR2 1 YES LEFT PARENTHESIS: Left Parenthesis.
TBRCREQ_RPAREN VARCHAR2 1 YES RIGHT PARENTHESIS: Right Parenthesis.
Date: 21-JUN-2004 Page: 77
TABLE: TBRCSUM
CREATOR: TAISMGR
Collector Table Used For Recursive Student Summary Report Processing
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
TBRCSUM_PIDM NUMBER 8 NO Internal Identification Number of the person account.
TBRCSUM_TERM_CODE VARCHAR2 6 NO This field identifies the term associated with the
report.
TBRCSUM_ACTIVITY_DATE DATE 7 NO This field identifies the date the record was created.
TBRCSUM_SESSIONID VARCHAR2 30 YES This field identifies a unique internal identification
that is generated everytime a user signs on.
TBRCSUM_PRINTER VARCHAR2 30 YES This field identifies the printer location for output
on the report.
Date: 21-JUN-2004 Page: 78
TABLE: TBRCTEX
CREATOR: TAISMGR
Intermediate File Containing Credit Amounts
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
TBRCTEX_SESSIONID VARCHAR2 30 NO This field identifies a unique internal identification
that is generated everytime a user signs on and off
the system.
TBRCTEX_PIDM NUMBER 8 NO Internal Identification Number of the student account
that is having credits processed on TSASPAY.
TBRCTEX_TERM_CODE VARCHAR2 6 NO This field identifies the term credits are being
processed for.
TBRCTEX_CONTROL_PRIORITY NUMBER 1 NO This field indicates the overall priority of whether
exemptions or contracts should be calculated first.
Valid values are: E - Exemptions first, C - Contracts
first.
TBRCTEX_PRIORITY NUMBER 2 NO PRIORITY: This field indicates the priority of a
contract/exemption within all third party contracts a
student has for the term.
TBRCTEX_CROSSREF_PIDM NUMBER 8 YES This field identifies the internal identification
number of the third party contract"s non-person
account.
TBRCTEX_CROSSREF_NUMBER NUMBER 8 NO This field identifies the number of the third party"s
contract or the exemption that is being processed.
TBRCTEX_DETAIL_PAY_CODE VARCHAR2 4 NO This field identifies the payment detail code that
will be posted on the student"s account for the
calculated contract or exemption amount.
TBRCTEX_DETAIL_REG_CODE VARCHAR2 4 YES This field identifies a specific registration charge
code the third party or exemption is set up on a
detail level to pay.
TBRCTEX_DETAIL_CHG_CODE VARCHAR2 4 NO This field identifies the charge detail code that will
be posted on the third party"s account for the
calculated contract amount.
TBRCTEX_DESC VARCHAR2 30 NO This field identifies the description of the the
contract or exemption that will be posted on the
specfic account associated with the detail code.
TBRCTEX_AMOUNT NUMBER 12 2 NO This field identifies the amount of the third party
contract or exemption.
TBRCTEX_REG_AMOUNT NUMBER 12 2 NO This field specifies the amount of the registration
charge(s) that the contract or exemption will cover.
If it is an account level it will be the total
registration charges, if detail it will be the
specific charge.
TBRCTEX_USEABLE_AMOUNT NUMBER 12 2 NO This field specifies the amount the student is
entitled to from the contract or exemption. This
amount is before any adjustments based on the
priorities set up.
TBRCTEX_CREDIT_TYPE VARCHAR2 1 NO This field indicates the type of credit being
processed. Valid values are: E - Exemption, C -
Contract.
TBRCTEX_ACCOUNT_OR_DETAIL VARCHAR2 1 NO This field indicates if the contract or exemption is
an account level or detail level credit. Valid values
are: A - Account level based on total registration
charges, D - Detail level for specific registration
charge.
Date: 21-JUN-2004 Page: 79
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
TBRCTEX_EXCLUDE VARCHAR2 1 YES This field indicates that this specific credit should
be not be posted at this time. It is set on the
second page of the Student Payment Form - TSASPAY.
Valid value is: X - Exclude credit.
TBRCTEX_ACTIVITY_DATE DATE 7 NO This field specifies the most current date record was
created or updated.
TBRCTEX_SRCE_CODE VARCHAR2 1 YES Identifies how the transaction was entered onto the
account. Defaullt is T - user-entered transaction.
TBRCTEX_AUTH_IND VARCHAR2 1 YES An indicator signifying whether a student is
pre-authorized, authorized, or unauthorized to use a
contract.
TBRCTEX_USER_ID VARCHAR2 30 NO USER IDENTIFICATION: The unique identification of the
user.
TBRCTEX_DCAT_REG_CODE VARCHAR2 3 YES DETAIL CATEGORY REGISTRATION CODE: This field
identifies a specific registration charge category
code the third party or exemption is set up on a
category code level to pay.
TBRCTEX_USEABLE_AMOUNT_STU_MAX NUMBER 12 2 NO STUDENT MAX USEABLE AMOUNT: This field specifies the
amount the student is entitled to from the student
maximum field on the contract or exemption.
TBRCTEX_LEVEL_SMAX_PRIORITY NUMBER 3 YES STUDENT MAX LEVEL PRIORITY: This field indicates the
priority to use per contract/exemption when student
maximum is entered on a contract/exemption at the
account, detail or category level.
TBRCTEX_RULE_MIN_AMOUNT NUMBER 7 2 YES MINIMUM RULE: Minimum amount that student pays in
contract or exemption rules.
TBRCTEX_RULE_MAX_AMOUNT NUMBER 7 2 YES MAXIMUM RULE: Maximum amount that is credited in
contract or exemption rules.
TBRCTEX_RULE_PERCENT NUMBER 3 YES PERCENT RULE: Percent that is credited in contract or
exemption rules.
Date: 21-JUN-2004 Page: 80
TABLE: TBRDEPO
CREATOR: TAISMGR
Deposit Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
TBRDEPO_PIDM NUMBER 8 NO Internal Identification Number of the person or
non-person account that has a deposit.
TBRDEPO_TRAN_NUMBER NUMBER 8 NO This field identifies the transaction number
associated with the deposit. Each charge and payment
on an account has a one-up transaction number.
TBRDEPO_TERM_CODE VARCHAR2 6 NO This field identifies the term the deposit is
effective for.
TBRDEPO_DETAIL_CODE_DEPOSIT VARCHAR2 4 NO This field identifies the detail code associated with
the deposit. This detail code must have been set up
as a deposit on the Deposit Control Form - TGADEPC.
TBRDEPO_DESC VARCHAR2 30 NO This field specifies a free-format description of the
deposit detail code. The description defaults from
the Detail Code Control Form - TGADETC.
TBRDEPO_AMOUNT NUMBER 7 2 NO This field identifies the amount of the deposit.
TBRDEPO_DETAIL_CODE_PAYMENT VARCHAR2 4 NO This field identifies the detail code associated with
the method of how the deposit was paid - check, cash,
etc.
TBRDEPO_AUTO_RELEASE_IND VARCHAR2 1 NO This field indicates if the deposit should be
automatically released on the account after the
release date. Valid values are: Y - Automatically
release on TSASPAY, N - Release manually on TBADETL.
TBRDEPO_ACCT_FEED_IND VARCHAR2 1 NO This field indicates the status of the deposit in the
accounting feed. Valid values are: Y - Feed
transaction, F - Transaction fed, N - Do not feed
transaction.
TBRDEPO_USER VARCHAR2 30 NO This field identifies the userid of the cashier who
posted the deposit.
TBRDEPO_ENTRY_DATE DATE 7 NO This field specifies the date the deposit was entered
as a deposit on the account.
TBRDEPO_RECEIPT_NUMBER NUMBER 8 YES This field specifies the receipt number associated
with the deposit if a receipt number was system
generated when the deposit was entered.
TBRDEPO_MIN_AMOUNT NUMBER 7 2 YES This field specifies the minimum amount that must
remain as a deposit and not be released until the
expiration date of the deposit.
TBRDEPO_EXPIRATION_DATE DATE 7 YES This field specifies the expiration date of the
deposit.
TBRDEPO_RELEASE_DATE DATE 7 YES This field specifies the date the deposit may be
release. The deposit may not be release automatically
or manually before this date. If this field is blank
the deposit may be released at any time.
TBRDEPO_EFFECTIVE_DATE DATE 7 NO This field specifies the effective date of the
deposit. This date defaults to the date the deposit
was entered.
TBRDEPO_ACTIVITY_DATE DATE 7 NO This field specifies the most current date record was
created or updated.
Date: 21-JUN-2004 Page: 81
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
TBRDEPO_SESSION_NUMBER NUMBER 5 NO Cashiering session for this transaction (0 = current
session).
TBRDEPO_CSHR_END_DATE DATE 7 YES The end date of the cashiering session for this
transaction
TBRDEPO_CURR_CODE VARCHAR2 4 YES tbrdepo_CURR_CODE: contains the foreign currency code
used when making a payment.
TBRDEPO_TRANS_DATE DATE 7 YES The date used by the Finance System to control posting
to the ledgers.
TBRDEPO_FOREIGN_AMOUNT NUMBER 12 2 YES The amount of the transaction as stated in foreign
currency.
TBRDEPO_FEED_DATE DATE 7 YES The feed date is the date this row was processed by
tgrfeed and inserted into the GENERAL.GURFEED table.
TBRDEPO_FEED_DOC_CODE VARCHAR2 8 YES The document code generated by GURFEED to identify and
feed this transaction to Finance.
TBRDEPO_ATYP_CODE VARCHAR2 2 YES In combination with ATYP_SEQNO, the address for this
account detail record. (i.e. where the bill will be
sent)
TBRDEPO_ATYP_SEQNO NUMBER 2 YES In combination with ATYP_CODE, the address for this
account detail record. (i.e. where the bill will be
sent)
Date: 21-JUN-2004 Page: 82
TABLE: TBREACC
CREATOR: TAISMGR
Exemption Account Level Authorization Definition Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
TBREACC_EXEMPTION_CODE VARCHAR2 8 NO This field identifies the exemption code associated
with a registration exemption.
TBREACC_TERM_CODE VARCHAR2 6 NO This field identifies the term associated with the
exemption code.
TBREACC_MIN_AMOUNT NUMBER 7 2 YES This field indicates the minimum amount the student
must pay on their registration charges that the
exemption will not cover.
TBREACC_MAX_AMOUNT NUMBER 7 2 YES This field indicates the maximum amount the exemption
will cover of the student"s registration charges.
TBREACC_PERCENT NUMBER 3 YES This field identifies the percentage of the total of
the student"s registration charges the exemption will
pay.
TBREACC_SRCE_CODE VARCHAR2 1 NO This field contains the source code which will be paid
by the exemption.
TBREACC_ACTIVITY_DATE DATE 7 NO This field specifies the most current date record was
created or updated.
TBREACC_ACC_PRIORITY NUMBER 3 YES CATEGORY CODE PRIORITY: This indicates the priority of
this category for exemption payment calculation for a
student. Used only when student maximum is applied.
Date: 21-JUN-2004 Page: 83
TABLE: TBRECAT
CREATOR: TAISMGR
Exemption Detail Category Level Authorization Definition Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
TBRECAT_EXEMPTION_CODE NUMBER 8 NO EXEMPTION CODE: This field identifies the Exemption
Code associated with the third party for the term.
TBRECAT_TERM_CODE VARCHAR2 6 NO TERM CODE: This field identifies the term associated
with the third party Exemption Code.
TBRECAT_DCAT_CODE VARCHAR2 3 NO DETAIL CATEGORY CODE: This field identifies the detail
category code that the third party Exemption will
apply to.
TBRECAT_ACTIVITY_DATE DATE 7 NO ACTIVITY DATE: This field specifies the most current
date record was created or updated.
TBRECAT_USER_ID VARCHAR2 30 NO USER ID: This field identifies the system user signon
id initiating hold
TBRECAT_MIN_AMOUNT NUMBER 7 2 YES MINIMUM AMOUNT: This field indicates the minimum
amount the student must pay for the charge associated
with the detail category code, that the third party
will not cover.
TBRECAT_MAX_AMOUNT NUMBER 7 2 YES MAXIMUM AMOUNT: This field indicates the maximum
amount the third party Exemption will cover of the
detail category code.
TBRECAT_PERCENT NUMBER 3 YES PERCENT: This field identifies the percentage of the
charge associated with the detail category code that
the third party Exemption will cover.
TBRECAT_I_E_SOURCE_IND VARCHAR2 1 YES INCLUDE EXCLUDE SOURCE INDICATOR: Indicator telling
whether the source codes in TBRECSI should be included
or excluded. Value of Null indicates that all sources
in TTVSRCE are included.
TBRECAT_DCAT_PRIORITY NUMBER 3 YES CATEGORY CODE PRIORITY: This indicates the priority of
this category code for exemption payment calculation
for a student. Used only when student maximum is
applied.
Date: 21-JUN-2004 Page: 84
TABLE: TBRECSI
CREATOR: TAISMGR
Exemption Detail Category Level Authorization Source Definition Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
TBRECSI_EXEMPTION_CODE NUMBER 8 NO EXEMPTION CODE: This field identifies the Exemption
Code associated with the third party for the term.
TBRECSI_TERM_CODE VARCHAR2 6 NO TERM CODE: This field identifies the term associated
with the third party Exemption Code.
TBRECSI_DCAT_CODE VARCHAR2 3 NO DETAIL CATEGORY CODE: This field identifies the detail
category code that the third party Exemption will
apply to.
TBRECSI_SOURCE_CODE VARCHAR2 1 NO SOURCE CODE: This field contains the source code which
will be paid by the Exemption.
TBRECSI_ACTIVITY_DATE DATE 7 NO ACTIVITY DATE: This field specifies the most current
date record was created or updated.
TBRECSI_USER_ID VARCHAR2 30 NO USER ID: This field identifies the system user signon
id initiating hold
Date: 21-JUN-2004 Page: 85
TABLE: TBREDET
CREATOR: TAISMGR
Exemption Detail Level Authorization Definition Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
TBREDET_EXEMPTION_CODE VARCHAR2 8 NO This field identifies the exemption code associated
with a registration exemption.
TBREDET_TERM_CODE VARCHAR2 6 NO This field identifies the term associated with the
exemption code.
TBREDET_DETAIL_CODE VARCHAR2 4 NO This field identifies the registration detail code
that the exemption will apply to.
TBREDET_MIN_AMOUNT NUMBER 7 2 YES This field indicates the minimum amount the student
must pay for the registration charge associated with
the detail code, that the exemption will not cover.
TBREDET_MAX_AMOUNT NUMBER 7 2 YES This field indicates the maximum amount the exemption
will cover of the registration detail code.
TBREDET_PERCENT NUMBER 3 YES This field identifies the percentage of the charge
associated with the detail code that the exemption
will cover.
TBREDET_CRHR NUMBER 4 2 YES This field is currently not used.
TBREDET_ACTIVITY_DATE DATE 7 NO This field specifies the most current date record was
created or updated.
TBREDET_SRCE_CODE VARCHAR2 1 NO This field contains the source code which will be paid
by the exemption.
TBREDET_I_E_SOURCE_IND VARCHAR2 1 YES INCLUDE EXCLUDE SOURCE INDICATOR: Indicator telling
whether the source codes in TBREDSI should be included
or excluded. Value of Null indicates that all sources
in TTVSRCE are included.
TBREDET_DETAIL_PRIORITY NUMBER 3 YES DETAIL CODE PRORITY: This indicates the priority of
this detail code for contract payment calculation for
a student. Used only when student maximum is applied.
Date: 21-JUN-2004 Page: 86
TABLE: TBREDSI
CREATOR: TAISMGR
Exemption Detail Level Authorization Source Definition Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
TBREDSI_EXEMPTION_CODE NUMBER 8 NO EXEMPTION_CODE: This field identifies the Exemption
Code associated with the third party for the term.
TBREDSI_TERM_CODE VARCHAR2 6 NO TERM CODE: This field identifies the term associated
with the third party Exemption Code.
TBREDSI_DETAIL_CODE VARCHAR2 4 NO DETAIL CODE: This field identifies the detail category
code that the third party Exemption will apply to.
TBREDSI_SOURCE_CODE VARCHAR2 1 NO SOURCE CODE: This field contains the source code which
will be paid by the exemption.
TBREDSI_ACTIVITY_DATE DATE 7 NO ACTIVITY DATE: This field specifies the most current
date record was created or updated.
TBREDSI_USER_ID VARCHAR2 30 NO USER ID: This field identifies the system user signon
id initiating hold
Date: 21-JUN-2004 Page: 87
TABLE: TBREREQ
CREATOR: TAISMGR
Exemptions Course Requirements Table.
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
TBREREQ_EXEMPTION_CODE VARCHAR2 8 NO EXEMPTION CODE: This field identifies the exemption
code associated with the exemption for the term.
TBREREQ_TERM_CODE VARCHAR2 6 NO TERM CODE: This field identifies the term associated
with the third party exemption code.
TBREREQ_ACTIVITY_DATE DATE 7 NO ACTIVITY DATE: The date when the information for this
record on the table was entered or last updated.
TBREREQ_USER_ID VARCHAR2 30 NO USER IDENTIFICATION: The unique identification code of
the last user to create or modify this record.
TBREREQ_SEQNO NUMBER 23 20 YES SEQUENCE NUMBER: The sequnce number is used to insure
the records will be in the correct order.
TBREREQ_TESC_CODE VARCHAR2 4 YES TESC CODE: The test code associated with the exemption
restriction.
TBREREQ_TEST_SCORE VARCHAR2 5 YES TEST SCORE: The minimum score of the test code.
TBREREQ_SUBJ_CODE VARCHAR2 4 YES SUBJECT CODE: This field defines the subject area for
course exemption restriction requirements.
TBREREQ_CRSE_NUMB VARCHAR2 5 YES COURSE NUMBER: This field defines the course number
for course exemption restriction requirements.
TBREREQ_LEVL_CODE VARCHAR2 2 YES LEVEL CODE: The level code for grade.
TBREREQ_CRN VARCHAR2 5 YES CRN: The course reference number of section student
must be registered for.
TBREREQ_CONNECTOR VARCHAR2 1 YES CONNECTOR: The AND/OR connector used when restriction
for the subject/course/term can have an AND/OR
relation.
TBREREQ_LPAREN VARCHAR2 1 YES LEFT PARENTHESIS: Left Parenthesis.
TBREREQ_RPAREN VARCHAR2 1 YES RIGHT PARENTHESIS: Right Parenthesis.
Date: 21-JUN-2004 Page: 88
TABLE: TBRIACL
CREATOR: TAISMGR
Installment Assignment Rules for College
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
TBRIACL_INSTALLMENT_PLAN VARCHAR2 2 NO INSTALLMENT PLAN : Installment Plan code to assign
Payment Plans are defined based on college code
TBRIACL_TERM_CODE VARCHAR2 6 NO TERM CODE : Term Code for which assignment Plan Rules
based on college code are defined
TBRIACL_COLL_CODE VARCHAR2 2 NO COLLEGE CODE : College Code from General Student
record that will cause the student to be assigned to
the installment plan
TBRIACL_INCL_EXCL VARCHAR2 1 NO INCL EXCL : Indicator telling whether the college
codes in SGBSTDN should be included(I) or excluded(E)
TBRIACL_USER_ID VARCHAR2 35 NO The user ID that inserted or updated the record in the
TBRIACL table.
TBRIACL_ACTIVITY_DATE DATE 7 NO ACTIVITY DATE: The date that the information for the
row was inserted or updated in the TBRIACL table.
Date: 21-JUN-2004 Page: 89
TABLE: TBRIACM
CREATOR: TAISMGR
Installment Assignment Rules for Campus
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
TBRIACM_INSTALLMENT_PLAN VARCHAR2 2 NO INSTALLMENT PLAN : Installment Plan code to assign
Payment Plans are defined based on campus code
TBRIACM_TERM_CODE VARCHAR2 6 NO TERM CODE : Term Code for which assignment Plan Rules
based on campus code are defined
TBRIACM_CAMP_CODE VARCHAR2 3 NO CAMPUS CODE : Campus Code from General Student record
that will cause the student to be assigned to the
installment plan
TBRIACM_INCL_EXCL VARCHAR2 1 NO INCL EXCL : Indicator telling whether the campus codes
in SGBSTDN should be included(I) or excluded(E)
TBRIACM_USER_ID VARCHAR2 35 NO The User ID that entered information for the row was
inserted or updated in the TBRIACM table.
TBRIACM_ACTIVITY_DATE DATE 7 NO ACTIVITY DATE: The date that the information for the
row was inserted or
updated in the TBRIACM table.
Date: 21-JUN-2004 Page: 90
TABLE: TBRIADG
CREATOR: TAISMGR
Installment Assignment Rules for Degree
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
TBRIADG_INSTALLMENT_PLAN VARCHAR2 2 NO INSTALLMENT PLAN : Installment Plan code to assign
Payment Plans are defined based on degree code
TBRIADG_TERM_CODE VARCHAR2 6 NO TERM CODE : Term Code for which assignment Plan Rules
based on degree code are defined
TBRIADG_DEGC_CODE VARCHAR2 6 NO DEGREE CODE : Degree Code from General Student record
that will cause the student to be assigned to the
installment plan
TBRIADG_INCL_EXCL VARCHAR2 1 NO INCL EXCL : Indicator telling whether the degree codes
in SGBSTDN should be included(I) or excluded(E)
TBRIADG_USER_ID VARCHAR2 35 NO The User ID that entered the information for the row
was inserted or updated in the TBRIADG table.
TBRIADG_ACTIVITY_DATE DATE 7 NO ACTIVITY DATE: The date that the information for the
row was inserted or updated in the TBRIADG table.
Date: 21-JUN-2004 Page: 91
TABLE: TBRIALV
CREATOR: TAISMGR
Installment Assignment Rules for Level
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
TBRIALV_INSTALLMENT_PLAN VARCHAR2 2 NO INSTALLMENT PLAN : Installment Plan code to assign
Payment Plans are defined based on level code
TBRIALV_TERM_CODE VARCHAR2 6 NO TERM CODE : Term Code for which assignment Plan Rules
based on level code are defined
TBRIALV_LEVL_CODE VARCHAR2 2 NO LEVL CODE : Level Code from General Student record
that will cause the student to be assigned to the
installment plan
TBRIALV_INCL_EXCL VARCHAR2 1 NO INCL EXCL : Indicator telling whether the level codes
in SGBSTDN should be included(I) or excluded(E)
TBRIALV_USER_ID VARCHAR2 35 NO The User ID that entered the information for the row
was inserted or updated in the TBRIALV table.
TBRIALV_ACTIVITY_DATE DATE 7 NO ACTIVITY DATE: The date that the information for the
row was inserted or
updated in the TBRIALV table.
Date: 21-JUN-2004 Page: 92
TABLE: TBRIAMJ
CREATOR: TAISMGR
Installment Assignment Rules for Major
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
TBRIAMJ_INSTALLMENT_PLAN VARCHAR2 2 NO INSTALLMENT PLAN : Installment Plan code to assign
Payment Plans are defined based on major code
TBRIAMJ_TERM_CODE VARCHAR2 6 NO TERM CODE : Term Code for which assignment Plan Rules
based on major code are defined
TBRIAMJ_MAJR_CODE VARCHAR2 4 NO MAJOR CODE : Major Code from General Student record
that will cause the student to be assigned to the
installment plan
TBRIAMJ_INCL_EXCL VARCHAR2 1 NO INCL EXCL : Indicator telling whether the major codes
in SGBSTDN should be included(I) or excluded(E)
TBRIAMJ_USER_ID VARCHAR2 35 NO The User ID that the entered information for the row
was inserted or updated in the TBRIAMJ table.
TBRIAMJ_ACTIVITY_DATE DATE 7 NO ACTIVITY DATE: The date that the information for the
row was inserted or
updated in the TBRIAMJ table.
Date: 21-JUN-2004 Page: 93
TABLE: TBRIART
CREATOR: TAISMGR
Installment Assignment Rules for Rate
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
TBRIART_INSTALLMENT_PLAN VARCHAR2 2 NO INSTALLMENT PLAN : Installment Plan code to assign
Payment Plans are defined based on rate code
TBRIART_TERM_CODE VARCHAR2 6 NO TERM CODE : Term Code for which assignment Plan Rules
based on rate code are defined
TBRIART_RATE_CODE VARCHAR2 5 NO RATE CODE : Rate Code from General Student record that
will cause the student to be assigned to the
installment plan
TBRIART_INCL_EXCL VARCHAR2 1 NO INCL EXCL : Indicator telling whether the rate codes
in SGBSTDN should be included(I) or excluded(E)
TBRIART_USER_ID VARCHAR2 35 NO The User ID that entered the information for the row
was inserted or updated in the TBRIART table.
TBRIART_ACTIVITY_DATE DATE 7 NO ACTIVITY DATE: The date that the information for the
row was inserted or
updated in the TBRIART table.
Date: 21-JUN-2004 Page: 94
TABLE: TBRICBA
CREATOR: TAISMGR
Automated Installment Plan dynamic calculation reported on TSRCBIL
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
TBRICBA_PIDM NUMBER 8 NO PIDM : PIDM of person who had dynamic calculations on
TSRCBIL
TBRICBA_INSTALLMENT_PLAN VARCHAR2 2 NO INSTALLMENT PLAN : Installment Plan code for term
dynamic calc used on TSRCBIL
TBRICBA_TERM_CODE VARCHAR2 6 NO TERM CODE : Term Code for installment plan dynamnic
calc on TSRCBIL
TBRICBA_ISTL_REF_NUMBER NUMBER 8 NO ISTL REF NUMBER : The reference number for the plan
assignment in TBRISTL
TBRICBA_CBIL_DATE DATE 7 NO RUN DATE : Date calculations created on TSRCBIL
TBRICBA_PLAN_AMOUNT NUMBER 22 2 NO PLAN AMOUNT : Installlment plan amount used for
dynamic calculations on TSRCBIL
TBRICBA_AMOUNT_DUE NUMBER 22 2 NO AMOUNT DUE: Amount due reported in auto calc section
on TSRCBIL
TBRICBA_SERVICE_CHG NUMBER 22 2 NO SERVICE CHG : Service Charge reported on TSRCBIL when
using dynamic calc
TBRICBA_FIRST_PAYMENT NUMBER 22 2 NO FIRST PAYMENT: Amount of just installment payment for
first payment on auto calc section on TSRCBIL
TBRICBA_FIRST_INTEREST NUMBER 22 2 NO FIRST INTEREST: Amount of interest on first payment in
auto calc section on TSRCBIL
TBRICBA_PROCESSED_IND VARCHAR2 1 NO PROCESSED IND: Y if calculated plan information
written to TBRACCD.
TBRICBA_USER_ID VARCHAR2 35 NO The User ID that the entered information for the row
was inserted or updated in the TBRICBA table.
TBRICBA_ACTIVITY_DATE DATE 7 NO ACTIVITY DATE: The date that the information for the
row was inserted or updated in the TBRICBA table.
TBRICBA_PROCESSED_DATE DATE 7 YES NEW PLAN DATE: Date transactions were written to
TBRACCD with TBRICBA_NEW_PLAN_AMOUNT
TBRICBA_AMOUNT_PAID NUMBER 22 2 YES AMOUNT PAID: Amount paid calculated when running
TSPISTT to determine how to calculate installment
payments
TBRICBA_ELIG_BASE_AMOUNT NUMBER 22 2 YES ELIG BASE AMOUNT : Amount of charges from TBRACCD that
were eligible for installment plan
TBRICBA_WRITE_PLAN_AMOUNT NUMBER 22 2 YES WRITE PLAN AMOUNT : Installment plan amount used to
create transactions on TBRACCD
Date: 21-JUN-2004 Page: 95
TABLE: TBRIDCT
CREATOR: TAISMGR
Installment Calculation Include Category Code
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
TBRIDCT_INSTALLMENT_PLAN VARCHAR2 2 NO INSTALLMENT PLAN : Installment Plan code for which
rules to include transactions are defined
TBRIDCT_TERM_CODE VARCHAR2 6 NO TERM CODE : Term Code for which Plan Rules are defined
TBRIDCT_DCAT_CODE VARCHAR2 3 NO DETAIL CODE : Detail Code Ctegory to include in
installmnt Plan
TBRIDCT_USER_ID VARCHAR2 35 NO
TBRIDCT_ACTIVITY_DATE DATE 7 NO ACTIVITY DATE: The date that the information for the
row was inserted or updated in the TBRIDCT table.
Date: 21-JUN-2004 Page: 96
TABLE: TBRIDET
CREATOR: TAISMGR
Installment Calculation Include Detail Code
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
TBRIDET_INSTALLMENT_PLAN VARCHAR2 2 NO INSTALLMENT PLAN : Installment Plan code for which
rules to include transactions are defined
TBRIDET_TERM_CODE VARCHAR2 6 NO TERM CODE : Term Code for which Plan Rules are defined
TBRIDET_DETAIL_CODE VARCHAR2 4 NO DETAIL CODE : Detail Code to include in installmnt
Plan
TBRIDET_USER_ID VARCHAR2 35 NO The User ID that entered the information for the row
was inserted or updated in the TBRIDET table.
TBRIDET_ACTIVITY_DATE DATE 7 NO ACTIVITY DATE: The date that the information for the
row was inserted or updated in the TBRIDET table.
Date: 21-JUN-2004 Page: 97
TABLE: TBRIDTX
CREATOR: TAISMGR
Installment Calculation Exclude Detail Code
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
TBRIDTX_INSTALLMENT_PLAN VARCHAR2 2 NO INSTALLMENT PLAN : Installment Plan code for which
rules to include transactions are defined
TBRIDTX_TERM_CODE VARCHAR2 6 NO TERM CODE : Term Code for which Plan Rules are defined
TBRIDTX_DCAT_CODE VARCHAR2 3 NO DCAT CODE : DCAT Code
TBRIDTX_DETAIL_CODE VARCHAR2 4 NO DETAIL CODE : Detail Code to exclude in installmnt
Plan that have the same detail code category defined
in TBRIDCT
TBRIDTX_USER_ID VARCHAR2 35 NO The User ID that entered the information for the row
was inserted or updated in the TBRIDTX table.
TBRIDTX_ACTIVITY_DATE DATE 7 NO ACTIVITY DATE: The date that the information for the
row was inserted or updated in the TBRIDTX table.
Date: 21-JUN-2004 Page: 98
TABLE: TBRISTL
CREATOR: TAISMGR
Installment Plan Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
TBRISTL_PIDM NUMBER 8 NO Internal Identification Number of person or non-person
account that has an installment plan.
TBRISTL_REF_NUMBER NUMBER 8 NO This field identifies the internal reference number
assigned to each installment plan a person or
non-person account has.
TBRISTL_INSTALLMENT_PLAN VARCHAR2 2 NO This field identifies the installment plan code.
Installment plans are identified as short term loans,
tution payment plans, etc.
TBRISTL_DESC VARCHAR2 30 NO This field specifies a free-format description of the
installment plan.
TBRISTL_NUMBER_OF_PAYMENTS NUMBER 2 NO This field specifies the number of payments for paying
back the installment plan.
TBRISTL_PAY_PERIOD NUMBER 3 NO This field indicates the number of days within the
payment periods.
TBRISTL_PRIN_DETAIL_CODE VARCHAR2 4 NO This field identifies the detail code that will be
posted on an account as the principle that will be
due.
TBRISTL_FIRST_INSTALL_DATE DATE 7 NO This field specifies the date the first installment is
due.
TBRISTL_TERM_CODE VARCHAR2 6 NO This field specifies the term associated with the
installment plan.
TBRISTL_PLAN_AMOUNT NUMBER 7 2 NO This field specifies the amount of the installment
plan.
TBRISTL_PLAN_DETAIL_CODE VARCHAR2 4 YES This field identifies the detail code that will be
posted on the account at the time of the installment
plan, which will allow the principle payments to be
posted into the future.
TBRISTL_INT_RATE NUMBER 5 3 YES This field identifies the interest rate percentge
associated with the installment plan.
TBRISTL_INT_DETAIL_CODE VARCHAR2 4 YES This field identifies the detail code that will be
posted on the account with the interest charges.
TBRISTL_SERV_CHARGE NUMBER 7 2 YES This field identifies the service charge that will be
posted to the account at the time of the installment
plan.
TBRISTL_SERV_DETAIL_CODE VARCHAR2 4 YES This field identifies the detail code that will be
posted on the account with the service charge.
TBRISTL_ACTIVITY_DATE DATE 7 NO This field specifies the most current date record was
created or updated.
TBRISTL_AUTO_CALC_PLAN_IND VARCHAR2 1 NO Y if this plan can be used for automatic calculation
of installment principal and payments
TBRISTL_AUTO_CALC_ACTIVE_IND VARCHAR2 1 NO set to N if no longer want to do auto calc. Can only
set for AUTO_CALC_PLAN_IND=Y.
TBRISTL_SVC_CHG_PCT NUMBER 5 3 YES Service charge for installment plan is to be
calculated as a percentage instead of a flat rate, the
value will be entered here
Date: 21-JUN-2004 Page: 99
TABLE: TBRISTP
CREATOR: TAISMGR
Define Installment Plan by dates and percentages
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
TBRISTP_INSTALLMENT_PLAN VARCHAR2 2 NO Installment Plan code for term percentage payment
information
TBRISTP_TERM_CODE VARCHAR2 6 NO Term Code for installment plan percentage payment
information
TBRISTP_SEQ_NO NUMBER 5 NO Sequence number of payment
TBRISTP_DUE_DATE DATE 7 NO Date payment is due
TBRISTP_PAYMENT_PCT NUMBER 7 5 NO Percentage of installment plan Principal that is this
payment amount
TBRISTP_USER_ID VARCHAR2 35 NO The User ID that entered the information for the row
was inserted or updated in the TBRISTP table.
TBRISTP_ACTIVITY_DATE DATE 7 NO The date that the information for the row was inserted
or updated in the TBRISTP table.
Date: 21-JUN-2004 Page: 100
TABLE: TBRLBOX
CREATOR: TAISMGR
Lock Box Intermediate Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
TBRLBOX_REC_TYPE VARCHAR2 1 YES A field used to distinguish record types.
TBRLBOX_BATCH_NUMBER NUMBER 3 YES A number which uniquely identifies the batch.
TBRLBOX_ID_NUMBER VARCHAR2 9 YES External identification number used to access a
person/entity in the system.
TBRLBOX_NAME VARCHAR2 35 YES The name (as it appears on the tape) associated with
the ID number.
TBRLBOX_BATCH_TRANS_DATE DATE 7 YES On summary record, the date the batch was produced.
On detail record, the transaction/effective date used
when posting to an account.
TBRLBOX_AMOUNT NUMBER 12 2 YES On summary record, the batch total dollars. On detail
record, the transaction amount.
TBRLBOX_INVOICE_NUMBER_PAID VARCHAR2 8 YES The invoice number to which the transaction amount
should apply.
TBRLBOX_CHECK_DIGIT1 NUMBER 1 YES The result of an algorithm, used to verify that id
number is correct.
TBRLBOX_CHECK_DIGIT2 NUMBER 1 YES The result of an algorithm, used to verify that amount
is correct.
TBRLBOX_CHECK_DIGIT3 NUMBER 1 YES The result of an algorithm, used to verify that
invoice number paid is correct.
TBRLBOX_BATCH_VERIFY_IND VARCHAR2 1 YES A field used to indicate that the total dollar amount
on the control record equals the total of the detail
amounts.
TBRLBOX_ERROR_MESSAGE VARCHAR2 40 YES The reason why a transaction cannot be posted to the
Account Detail Table.
TBRLBOX_ACTIVITY_DATE DATE 7 YES The most current date the record was created or
updated.
Date: 21-JUN-2004 Page: 101
TABLE: TBRMEMO
CREATOR: TAISMGR
Charge/Payment Detail Memo Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
TBRMEMO_PIDM NUMBER 8 NO Internal Identification Number of the person or
non-person account that has a memo item.
TBRMEMO_TRAN_NUMBER NUMBER 8 NO This field identifies transaction number on the
account associated with the memo transaction.
TBRMEMO_TERM_CODE VARCHAR2 6 NO This field identifies the term the memo was entered
onto the account.
TBRMEMO_DETAIL_CODE VARCHAR2 4 NO This field identifies the detail code associated with
the memo transaction. A memo is a transaction that is
recorded but not ready to be posted directly onto an
account.
TBRMEMO_AMOUNT NUMBER 7 2 NO This field specifies the amount of the memo
transaction.
TBRMEMO_USER VARCHAR2 30 NO This field identifies the userid of the cashier that
entered the memo transaction.
TBRMEMO_ENTRY_DATE DATE 7 NO This field specifies the date the memo transaction was
entered onto the account.
TBRMEMO_BILLING_IND VARCHAR2 1 NO This field indicates if the memo transaction should be
printed and calculated into the amount due on the
account"s bill. This indicator will be used only if
the memo indicator on the Billing Control Form is set
to "Y".
TBRMEMO_DESC VARCHAR2 30 YES This field specifies the free-format description
associated with the memo detail code.
TBRMEMO_RELEASE_DATE DATE 7 YES This field is currently not used.
TBRMEMO_EXPIRATION_DATE DATE 7 YES This field specifies the date the memo item expires
and may not be released onto an account.
TBRMEMO_EFFECTIVE_DATE DATE 7 YES This field specifies the date the memo transaction was
entered on the account. It is system maintained.
TBRMEMO_ACTIVITY_DATE DATE 7 NO This field specifies the most current date record was
created or updated.
TBRMEMO_SRCE_CODE VARCHAR2 1 NO Identifies how the transaction was entered onto the
account. Defaullt is T - user-entered transaction.
TBRMEMO_CROSSREF_PIDM NUMBER 8 YES This field identifies the internal identification
number associated with a third party contract payment.
For the third party account the pidm would be the
student pidm. For the student account the pidm would
be the third party pidm.
TBRMEMO_CROSSREF_NUMBER NUMBER 8 YES This field identifies the number of the contract
associated with the transaction.
TBRMEMO_CROSSREF_DETAIL_CODE VARCHAR2 4 YES This field identifies the detail code that will be
paid by the contract.
TBRMEMO_CROSSREF_SRCE_CODE VARCHAR2 1 YES This field identifies the source code of the detail
code that will be paid by the contract.
TBRMEMO_ATYP_CODE VARCHAR2 2 YES In combination with ATYP_SEQNO, the address for this
account detail record. (i.e. where the bill will be
sent)
Date: 21-JUN-2004 Page: 102
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
TBRMEMO_ATYP_SEQNO NUMBER 2 YES In combination with ATYP_CODE, the address for this
account detail record. (i.e. where the bill will be
sent)
Date: 21-JUN-2004 Page: 103
TABLE: TBRMESG
CREATOR: TAISMGR
Billing Message Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
TBRMESG_DELI_CODE VARCHAR2 2 NO This field identifies the deliquency code associated
with the billing message.
TBRMESG_INSTALLMENT_PLAN VARCHAR2 2 NO This field identifies the installment plan code
associated with the billing message.
TBRMESG_COLC_AGENCY_PIDM NUMBER 8 NO This field identifies the internal identification
number of the collection agency associated with the
billing message.
TBRMESG_STU_PIDM NUMBER 8 NO This field identifies the internal identification
number of the specific person account associated with
the billing message.
TBRMESG_SEQ_NUMBER NUMBER 23 20 NO This field identifies the internal sequence number
associated with each line of billing text.
TBRMESG_TEXT VARCHAR2 60 YES This field specifies the free-format message that will
print on the bill of the account that matches the
selections. If no deliquency code, installment plan,
collection agency or account is specified, message is
for all accounts.
TBRMESG_ACTIVITY_DATE DATE 7 NO This field specifies the most current date record was
created or updated.
Date: 21-JUN-2004 Page: 104
TABLE: TBRMISD
CREATOR: TAISMGR
Miscellaneous Transaction Charge/Payment Detail Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
TBRMISD_PAY_DETAIL_CODE VARCHAR2 4 YES This field identifies the payment or debit detail code
associated with a miscellaneous transaction.
TBRMISD_CHARGE_DETAIL_CODE VARCHAR2 4 YES This field identifies the charge or credit detail code
associated with a miscellaneous transaction.
TBRMISD_AMOUNT NUMBER 12 2 NO This field specifies the amount of the miscellaneous
transaction.
TBRMISD_DESC VARCHAR2 30 YES This field specifies the free-format description
associated with the miscellaneous transaction.
TBRMISD_RECEIPT_NUMBER NUMBER 8 YES This field identifies the receipt number assigned to
the miscellaneous transaction when it was entered into
the system.
TBRMISD_USER VARCHAR2 30 NO This field identifies the userid of the cashier who
entered the miscellaneous transaction.
TBRMISD_TRAN_NUMBER NUMBER 8 NO This field identifies the transaction number
associated with each miscellaneous transaction.
TBRMISD_ACCT_FEED_IND VARCHAR2 1 NO This field indicates the status of the transaction in
the accounting feed. Valid values are: Y - Feed
transaction, F - Transaction fed.
TBRMISD_ACTIVITY_DATE DATE 7 NO This field specifies the most current date record was
created or updated.
TBRMISD_CHARGE_COAS VARCHAR2 1 YES Banner Finance Chart Of Accounts Code for the CHARGE
TBRMISD_CHARGE_ACCI VARCHAR2 6 YES Banner Finance Index Code for the CHARGE
TBRMISD_CHARGE_FUND VARCHAR2 6 YES Banner Finance Fund Code for the CHARGE
TBRMISD_CHARGE_ORGN VARCHAR2 6 YES Banner Finance Organization Code for the CHARGE
TBRMISD_CHARGE_ACCT VARCHAR2 6 YES Banner Finance Account Code for the CHARGE
TBRMISD_CHARGE_PROG VARCHAR2 6 YES Banner Finance Program Code for the CHARGE
TBRMISD_CHARGE_ACTV VARCHAR2 6 YES Banner Finance Activity Code for the CHARGE
TBRMISD_CHARGE_LOCN VARCHAR2 6 YES Banner Finance Location Code for the CHARGE
TBRMISD_PAY_COAS VARCHAR2 1 YES Banner Finance Chart Of Accounts Code for the Payment
TBRMISD_PAY_ACCI VARCHAR2 6 YES Banner Finance Index Code for the Payment
TBRMISD_PAY_FUND VARCHAR2 6 YES Banner Finance Fund Code for the Payment
TBRMISD_PAY_ORGN VARCHAR2 6 YES Banner Finance Organization Code for the Payment
TBRMISD_PAY_ACCT VARCHAR2 6 YES Banner Finance Account Code for the Payment
TBRMISD_PAY_PROG VARCHAR2 6 YES Banner Finance Program Code for the Payment
TBRMISD_PAY_ACTV VARCHAR2 6 YES Banner Finance Activity Code for the Payment
TBRMISD_PAY_LOCN VARCHAR2 6 YES Banner Finance Location Code for the Payment
TBRMISD_SESSION_NUMBER NUMBER 5 NO The Cashier Session number to which this row belongs
TBRMISD_CSHR_END_DATE DATE 7 YES This is the date the cashier session was closed
TBRMISD_CHARGE_ACCOUNT VARCHAR2 60 YES Free format account number for the charge code, used
when Banner Finance is not installed
TBRMISD_PAY_ACCOUNT VARCHAR2 60 YES Free format account number for the payment code, used
when Banner Finance is not installed
TBRMISD_PAY_RUCL_CODE VARCHAR2 4 YES This is the rule class code for the PAYMENT to be used
when the transaction is fed to accounting
Date: 21-JUN-2004 Page: 105
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
TBRMISD_CHARGE_RUCL_CODE VARCHAR2 4 YES This is the rule class code for the CHARGE to be used
when the transaction is fed to accounting
TBRMISD_TRANS_DATE DATE 7 YES The date used by the Finance System to control posting
to the ledgers.
TBRMISD_DOCUMENT_NUMBER VARCHAR2 8 YES A unique number which identifies a specific
miscellaneous transaction.
TBRMISD_DR_CR_IND VARCHAR2 1 YES An indicator used to specify the sign of the
transaction.
TBRMISD_CURR_CODE VARCHAR2 4 YES A code which uniquely identifies the type of currency
in which the transaction is being entered
TBRMISD_FOREIGN_AMOUNT NUMBER 12 2 YES The amount of the transaction as stated in foreign
currency.
TBRMISD_FEED_DATE DATE 7 YES The feed date is the date this row was processed by
tgrfeed and inserted into the GENERAL.GURFEED table.
TBRMISD_FEED_DOC_CODE VARCHAR2 8 YES The document code generated by GURFEED to identify and
feed this transaction to Finance.
TBRMISD_PIDM NUMBER 8 YES This optional pidm allows for tracking of student
miscellaneous transactions.
TBRMISD_CCRD_CODE VARCHAR2 10 YES CREDIT CARD TYPE CODE: Code associated with the Credit
Card Type.
TBRMISD_CARD_EXP_DATE DATE 7 YES CREDIT CARD EXPIRATION DATE: Credit card expiration
date supplied on web credit card payment.
TBRMISD_PAYMENT_ID VARCHAR2 20 YES PAYMENT ID: Additional information as to the method of
payment. May be set to Credit Card Number by Web
credit card payment processing.
TBRMISD_CARD_AUTH_NUMBER VARCHAR2 12 YES AUTHORIZATION NUMBER FOR CREDIT CARD PAYMENT:
Authorization Number for credit card payment on the
web.
TBRMISD_MERCHANT_ID VARCHAR2 20 YES MERCHANT ID: Merchant ID associated with the Process
Name Code, Credit Card Type Code, and System Code.
The Merchant ID is included in the credit card payment
request transmitted to the third-party vendor
handling credit card payments.
Date: 21-JUN-2004 Page: 106
TABLE: TBRRRAS
CREATOR: TAISMGR
Recurring Receivables Assignment Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
TBRRRAS_PIDM NUMBER 8 NO Internal Identification Number of the person or
non-person account.
TBRRRAS_DETAIL_CODE VARCHAR2 4 NO The detail code associated with the transaction.
TBRRRAS_AMOUNT NUMBER 12 2 NO The dollar amount of the transaction.
TBRRRAS_START_DATE DATE 7 NO The date to begin assessment of this charge.
TBRRRAS_ASSESS_DATE DATE 7 NO The date of the next assessment for this charge
(SYSTEM MAINTAINED).
TBRRRAS_FREQ VARCHAR2 1 NO The frequency of assessment: (W)eekly, (B)i-weekly,
(M)onthly, (Q)uarterly, (H) Semi-annual, (A)nnual, (O)
= other (enter number of days).
TBRRRAS_ACTIVITY_DATE DATE 7 NO This field specifies the most current date record was
created or updated.
TBRRRAS_END_DATE DATE 7 YES The date to stop assessment of this charge.
TBRRRAS_DAYS NUMBER 3 YES The number of days in the assessment cycle for the
charge (used only when Frequency = Other).
TBRRRAS_ATYP_CODE VARCHAR2 2 YES In combination with ATYP_SEQNO, the address for this
charge record. (i.e. where the bill will be sent)
TBRRRAS_ATYP_SEQNO NUMBER 2 YES In combination with ATYP_CODE, the address for this
charge record. (i.e. where the bill will be sent)
Date: 21-JUN-2004 Page: 107
TABLE: TBRSBMS
CREATOR: TAISMGR
Schedule/Bill Message Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
TBRSBMS_SBRC_CODE VARCHAR2 6 NO Schedule/Bill Rules Code.
TBRSBMS_SEQ_NUMBER NUMBER 2 NO Sequence Number
TBRSBMS_MESSAGE VARCHAR2 70 NO Message to appear on the Schedule/Bill report
TBRSBMS_ACTIVITY_DATE DATE 7 NO The date the record was last changed.
Date: 21-JUN-2004 Page: 108
TABLE: TBRSBRL
CREATOR: TAISMGR
Schedule/Bill Collector Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
TBRSBRL_SBRC_CODE VARCHAR2 6 NO Schedule/Bill Rules Code.
TBRSBRL_TYPE_IND VARCHAR2 1 NO Record Type: (C)ategory, (S)ource.
TBRSBRL_VALUE VARCHAR2 3 NO The Detail Category Code (or Source Code, depending on
TBRSBRL_TYPE_IND) for selection of term charges.
TBRSBRL_ACTIVITY_DATE DATE 7 NO The date the record was last changed.
Date: 21-JUN-2004 Page: 109
TABLE: TBRUPRF
CREATOR: TAISMGR
Accounts Receivable User Restrictions Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
TBRUPRF_USERID VARCHAR2 30 NO Accounts receivable userid.
TBRUPRF_DCAT_CODE VARCHAR2 3 YES This column contains the allowable categosy codes the
userid may enter.
TBRUPRF_TYPE_IND VARCHAR2 1 NO This column contains a "C" if the userid may enter
charges, "P" payments, or "B" both for the
corresponding category code. If category is null,
userid may enter any category but only for the type
specified.
TBRUPRF_ACTIVITY_DATE DATE 7 NO The date the row was inserted or last modified.
Date: 21-JUN-2004 Page: 110
TABLE: TBTFADB
CREATOR: TAISMGR
Fin. Aid Intermediate Disbursement Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
TBTFADB_PIDM NUMBER 8 NO Internal Identification Number of student who has
disbursed financial aid.
TBTFADB_DETAIL_CODE VARCHAR2 4 NO This field identifies the detail code associated with
the financial aid being disbursed. It is the SARTRAN
in SAM.
TBTFADB_PROC_YEAR VARCHAR2 4 NO This field identifies the financial aid processing
year from SAM that will be used with the financial aid
term to determine the term in BANNER for disbursement.
TBTFADB_SAM_TERM VARCHAR2 1 NO This field identifies the financial aid term from SAM
that will be used with the financial aid processing
year to determine the term in BANNER for disbursement.
TBTFADB_TERM_CODE VARCHAR2 6 YES This field identifies the BANNER term associated with
the financial aid disbursement.
TBTFADB_ENTRY_DATE DATE 7 NO This field specifies the date the financial aid
disbursement was entered into this record.
TBTFADB_AMOUNT NUMBER 7 2 NO This field indicates the amount of the financial aid
disbursement.
TBTFADB_EFFECTIVE_DATE DATE 7 YES This field specifies the date the financial aid
disbursement becomes effective on the student"s
account.
TBTFADB_EXPIRE_DATE DATE 7 YES This field is currently not used.
TBTFADB_TRAN_TYPE VARCHAR2 1 NO This field identifies if the financial aid detail code
is a payment or a charge transaction. Valid values
are: P - Payment, C - Charge.
TBTFADB_DESC VARCHAR2 30 YES This field specifies a free-format description
associated with the financial aid detail code.
TBTFADB_TRAN_NUMBER NUMBER 8 YES This field identifies a transaction number associated
with each charge and payment transaction entered on an
student"s account.
TBTFADB_SSN VARCHAR2 9 YES This field identifies the student"s identification
number that is associated with the student"s PIDM.
TBTFADB_ACTIVITY_DATE DATE 7 NO This field specifies the most current date record was
created or updated.
Date: 21-JUN-2004 Page: 111
TABLE: TGRCLR2
CREATOR: TAISMGR
Collector table used by tgrrcon to store summary information which is later used to produce the reconciliation
report.
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
TGRCLR2_SESSIONID VARCHAR2 30 NO
TGRCLR2_DETAIL_CODE VARCHAR2 4 YES
TGRCLR2_TYPE_IND VARCHAR2 1 YES
TGRCLR2_FED_AMOUNT NUMBER 14 2 YES
TGRCLR2_NOT_FED_AMOUNT NUMBER 14 2 YES
TGRCLR2_ACTIVITY_DATE DATE 7 NO
TGRCLR2_UNFED_APPL NUMBER 14 2 YES
TGRCLR2_TBDS_CODE VARCHAR2 2 YES TERM BASED DETAIL CODE DESIGNATOR: Designator
associated with current term with additional
refinement to detail codes.
TGRCLR2_FEED_DATE DATE 7 YES TRANSACTION FEED DATE: This column is used in process
tgrrcon for storing the feed date of transcation
Date: 21-JUN-2004 Page: 112
TABLE: TGRCLR3
CREATOR: TAISMGR
Collector table used to store the parameter entered chart of accounts.
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
TGRCLR3_SESSIONID VARCHAR2 30 NO
TGRCLR3_COAS_CODE VARCHAR2 1 YES
TGRCLR3_FUND_CODE VARCHAR2 6 YES
TGRCLR3_ACCT_CODE VARCHAR2 6 YES
TGRCLR3_ACCOUNT VARCHAR2 60 YES
TGRCLR3_ACTIVITY_DATE DATE 7 NO
Date: 21-JUN-2004 Page: 113
TABLE: TGRCOLR
CREATOR: TAISMGR
Collector table used by tgrrcon to produce the reconciliation report.
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
TGRCOLR_SESSIONID VARCHAR2 30 NO
TGRCOLR_DETAIL_CODE VARCHAR2 4 YES
TGRCOLR_COAS_CODE VARCHAR2 1 YES
TGRCOLR_FUND_CODE VARCHAR2 6 YES
TGRCOLR_ACCT_CODE VARCHAR2 6 YES
TGRCOLR_ACCOUNT VARCHAR2 60 YES
TGRCOLR_PERCENT NUMBER 8 5 YES
TGRCOLR_PRINT_IND VARCHAR2 1 YES
TGRCOLR_FED_AMOUNT NUMBER 14 2 YES
TGRCOLR_NOT_FED_AMOUNT NUMBER 14 2 YES
TGRCOLR_TYPE_IND VARCHAR2 1 YES
TGRCOLR_TBRACCT_ROWID VARCHAR2 26 YES
TGRCOLR_ACTIVITY_DATE DATE 7 NO
TGRCOLR_UNFED_APPL NUMBER 14 2 YES
TGRCOLR_TBDS_CODE VARCHAR2 2 YES TERM-BASED DETAIL CODE DESIGNATOR: Designator
associated with current term with additional
refinement to detail code.
Date: 21-JUN-2004 Page: 114
TABLE: TOTACCT
CREATOR: TAISMGR
Web for Executives Accounts Receivable Account Hierarchy Extract
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
TOTACCT_CHART_CODE VARCHAR2 15 NO CHART OF ACCOUNTS CODE: Finance chart of accounts code
for this hierarchy.
TOTACCT_ACCOUNT_CODE VARCHAR2 15 NO ACCOUNT CODE: Finance account code for this hierarchy.
TOTACCT_EFFECTIVE_DATE DATE 7 NO EFFECTIVE DATE: Effective date for this hierarchy.
TOTACCT_ACCOUNT_TYPE_1 VARCHAR2 15 YES ACCOUNT TYPE 1: Finance level 1 account type for this
hierarchy.
TOTACCT_ACCOUNT_TYPE_2 VARCHAR2 15 YES ACCOUNT TYPE 2: Finance level 2 account type for this
hierarchy.
TOTACCT_ACCOUNT_LEVEL_1 VARCHAR2 15 YES ACCOUNT LEVEL 1: Finance level 1 account for this
hierarchy.
TOTACCT_ACCOUNT_LEVEL_2 VARCHAR2 15 YES ACCOUNT LEVEL 2: Finance level 2 account for this
hierarchy.
TOTACCT_ACCOUNT_LEVEL_3 VARCHAR2 15 YES ACCOUNT LEVEL 3: Finance level 3 account for this
hierarchy.
TOTACCT_ACCOUNT_LEVEL_4 VARCHAR2 15 YES ACCOUNT LEVEL 4: Finance level 4 account for this
hierarchy.
Date: 21-JUN-2004 Page: 115
TABLE: TOTFUND
CREATOR: TAISMGR
Web for Executives Accounts Receivable Fund Hierarchy Extract
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
TOTFUND_CHART_CODE VARCHAR2 15 NO CHART OF ACCOUNTS CODE: Finance chart of accounts code
for this hierarchy.
TOTFUND_FUND_CODE VARCHAR2 15 NO FUND CODE: Finance fund code for this hierarchy.
TOTFUND_EFFECTIVE_DATE DATE 7 NO EFFECTIVE DATE: Effective date for this hierarchy.
TOTFUND_FUND_TYPE_1 VARCHAR2 15 YES FUND TYPE 1: Finance level 1 fund type for this
hierarchy.
TOTFUND_FUND_TYPE_2 VARCHAR2 15 YES FUND TYPE 2: Finance level 2 fund type for this
hierarchy.
TOTFUND_FUND_LEVEL_1 VARCHAR2 15 YES FUND LEVEL 1: Finance level 1 fund for this hierarchy.
TOTFUND_FUND_LEVEL_2 VARCHAR2 15 YES FUND LEVEL 2: Finance level 2 fund for this hierarchy.
TOTFUND_FUND_LEVEL_3 VARCHAR2 15 YES FUND LEVEL 3: Finance level 3 fund for this hierarchy.
TOTFUND_FUND_LEVEL_4 VARCHAR2 15 YES FUND LEVEL 4: Finance level 4 fund for this hierarchy.
TOTFUND_FUND_LEVEL_5 VARCHAR2 15 YES FUND LEVEL 5: Finance level 5 fund for this hierarchy.
Date: 21-JUN-2004 Page: 116
TABLE: TOTORGN
CREATOR: TAISMGR
Web for Executives Accounts Receivable Organization Hierarchy Extract
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
TOTORGN_CHART_CODE VARCHAR2 15 NO CHART OF ACCOUNTS CODE: Finance chart of accounts code
for this hierarchy.
TOTORGN_ORGANIZATION_CODE VARCHAR2 15 NO ORGANIZATION CODE: Finance organization code for this
hierarchy.
TOTORGN_EFFECTIVE_DATE DATE 7 NO EFFECTIVE DATE: Effective date for this hierarchy.
TOTORGN_ORGANIZATION_LEVEL_1 VARCHAR2 15 YES ORGANIZATION LEVEL 1: Finance level 1 organization for
this hierarchy.
TOTORGN_ORGANIZATION_LEVEL_2 VARCHAR2 15 YES ORGANIZATION LEVEL 2: Finance level 2 organization for
this hierarchy.
TOTORGN_ORGANIZATION_LEVEL_3 VARCHAR2 15 YES ORGANIZATION LEVEL 3: Finance level 3 organization for
this hierarchy.
TOTORGN_ORGANIZATION_LEVEL_4 VARCHAR2 15 YES ORGANIZATION LEVEL 4: Finance level 4 organization for
this hierarchy.
TOTORGN_ORGANIZATION_LEVEL_5 VARCHAR2 15 YES ORGANIZATION LEVEL 5: Finance level 5 organization for
this hierarchy.
TOTORGN_ORGANIZATION_LEVEL_6 VARCHAR2 15 YES ORGANIZATION LEVEL 6: Finance level 6 organization for
this hierarchy.
TOTORGN_ORGANIZATION_LEVEL_7 VARCHAR2 15 YES ORGANIZATION LEVEL 7: Finance level 7 organization for
this hierarchy.
TOTORGN_ORGANIZATION_LEVEL_8 VARCHAR2 15 YES ORGANIZATION LEVEL 8: Finance level 8 organization for
this hierarchy.
Date: 21-JUN-2004 Page: 117
TABLE: TOTPROG
CREATOR: TAISMGR
Web for Executives Accounts Receivable Program Hierarchy Extract
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
TOTPROG_CHART_CODE VARCHAR2 15 NO CHART OF ACCOUNTS CODE: Finance chart of accounts code
for this hierarchy.
TOTPROG_PROGRAM_CODE VARCHAR2 15 NO PROGRAM CODE: Finance program code for this hierarchy.
TOTPROG_EFFECTIVE_DATE DATE 7 NO EFFECTIVE DATE: Effective date for this hierarchy.
TOTPROG_PROGRAM_LEVEL_1 VARCHAR2 15 YES PROGRAM LEVEL 1: Finance level 1 program for this
hierarchy.
TOTPROG_PROGRAM_LEVEL_2 VARCHAR2 15 YES PROGRAM LEVEL 2: Finance level 2 program for this
hierarchy.
TOTPROG_PROGRAM_LEVEL_3 VARCHAR2 15 YES PROGRAM LEVEL 3: Finance level 3 program for this
hierarchy.
TOTPROG_PROGRAM_LEVEL_4 VARCHAR2 15 YES PROGRAM LEVEL 4: Finance level 4 program for this
hierarchy.
TOTPROG_PROGRAM_LEVEL_5 VARCHAR2 15 YES PROGRAM LEVEL 5: Finance level 5 program for this
hierarchy.
Date: 21-JUN-2004 Page: 118
TABLE: TOTWARE
CREATOR: TAISMGR
Web for Executives Accounts Receivable Extract
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
TOTWARE_SOURCE VARCHAR2 1 NO SOURCE: Identifies the original source of the data.
TOTWARE_EXTRACT_DATE DATE 7 NO EXTRACT DATE: Extract date for this transaction.
TOTWARE_TERM_SEQUENCE VARCHAR2 6 NO TERM SEQUENCE: This field identifies the sequence
associated with the this transaction.
TOTWARE_TERM_CODE VARCHAR2 15 NO TERM CODE: This field identifies the term associated
with this transaction.
TOTWARE_ACADEMIC_YEAR VARCHAR2 15 NO ACADEMIC YEAR: This field identifies the academic year
associated with this transaction.
TOTWARE_PIDM NUMBER 9 NO PIDM: Internal Identification Number of the person.
TOTWARE_USER VARCHAR2 30 NO USER: The user performing the extract.
TOTWARE_ACTIVITY_DATE DATE 7 NO ACTIVITY DATE: The date the record was added.
TOTWARE_DETAIL_CATEGORY VARCHAR2 15 YES DETAIL CATEGORY: Detail category code for this
transaction.
TOTWARE_DETAIL_CODE VARCHAR2 15 YES DETAIL CODE: Detail code for this transaction.
TOTWARE_CHART_CODE VARCHAR2 15 YES CHART CODE: Finance chart of accounts code for this
transaction.
TOTWARE_EFFECTIVE_DATE DATE 7 YES EFFECTIVE DATE: Effective date for this transaction.
This is equivalent to the account transaction date.
TOTWARE_ACCOUNTING_ID VARCHAR2 15 YES ACCOUNTING ID: Transaction number for this
transaction.
TOTWARE_FUND_CODE VARCHAR2 15 YES FUND CODE: Finance fund code for this transaction.
TOTWARE_ORGANIZATION_CODE VARCHAR2 15 YES ORGANIZATION CODE: Finance organization code for this
transaction.
TOTWARE_ACCOUNT_CODE VARCHAR2 15 YES ACCOUNT CODE: Finance account code for this
transaction.
TOTWARE_PROGRAM_CODE VARCHAR2 15 YES PROGRAM CODE: Finance program code for this
transaction.
TOTWARE_CAMPUS_CODE VARCHAR2 15 YES STUDENT CAMPUS CODE: Campus code for this transaction.
TOTWARE_COLLEGE_CODE VARCHAR2 15 YES STUDENT COLLEGE CODE: College code for this
transaction.
TOTWARE_DEPARTMENT_CODE VARCHAR2 15 YES STUDENT DEPARTMENT CODE: Department code for this
transaction.
TOTWARE_MAJOR_CODE VARCHAR2 15 YES STUDENT MAJOR CODE: Major code for this transaction.
TOTWARE_LEVEL_CODE VARCHAR2 15 YES STUDENT LEVEL CODE: Student level code for this
transaction.
TOTWARE_EFFECTIVE_DATE_AGING NUMBER 5 YES EFFECTIVE DATE AGING: Number of days between the
current date and the effective date of this
transaction.
TOTWARE_BILLING_DATE_AGING NUMBER 5 YES BILLING DATE AGING: Number of days between the current
date and the billing date of this transaction.
TOTWARE_CUSTOMER_BALANCE NUMBER 15 2 YES CUSTOMER BALANCE: Outstanding balance of this
transaction.
TOTWARE_AMOUNT_DUE NUMBER 15 2 YES AMOUNT DUE: Original amount of this transaction.
Date: 21-JUN-2004 Page: 119
TABLE: TPRRHLD
CREATOR: TAISMGR
Auto Hold/Release Rules Table.
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
TPRRHLD_HOLD_RULE_CODE VARCHAR2 6 NO HOLD RULE CODE: Auto Hold/Release Rule Code.
TPRRHLD_HLDD_CODE VARCHAR2 2 NO HOLD CODE: This field identifies the type of hold on
an account.
TPRRHLD_NONPERS_IND VARCHAR2 1 NO NON-PERSON INDICATOR: Indicator to tell process to
include nonpersons for hold application/release (Y/N).
TPRRHLD_FIN_AID_IND VARCHAR2 1 NO FINANCIAL AID INDICATOR: Include Authorized Financial
aid in Account Balance Calc (Y/N).
TPRRHLD_FUT_IND VARCHAR2 1 NO FUTURE INDICATOR: Include Future Dated Transactions in
Account Balance Calc (Y/N).
TPRRHLD_AR_MEMO_IND VARCHAR2 1 NO ACCOUNTS RECEIVABLE MEMO INDICATOR: Include AR Memos
in Account Balance calculation (Y/N).
TPRRHLD_CONT_MEMO_IND VARCHAR2 1 NO CONTRACTS MEMO INDICATOR: Include Contract Memos in
Account Balance calculation (Y/N).
TPRRHLD_FINAID_MEMO_IND VARCHAR2 1 NO FINANCIAL AID MEMOS INDICATOR: Include Financial Aid
Memos in Account Balance calculation (Y/N).
TPRRHLD_PURGE_PRIOR_IND VARCHAR2 1 NO PURGE PRIOR INDICATOR: Indicator to purge or release
prior holds (Y/N).
TPRRHLD_NONCON_HOLD_IND VARCHAR2 1 NO NON-CONDITIONAL HOLD INDICATOR: Indicator to tell
process to force a hold on/off an account (Y/N).
TPRRHLD_RELEASE_IND VARCHAR2 1 NO RELEASE INDICATOR: This field identifies that the only
the system user who entered the hold may release the
hold.
TPRRHLD_ACTIVITY_DATE DATE 7 NO ACTIVITY DATE: This field defines most current date
record is created or changed.
TPRRHLD_USER_ID VARCHAR2 30 NO USER ID: This field identifies the system user signon
id initiating hold.
TPRRHLD_FROM_DATE DATE 7 YES FROM DATE: This field identifies the effective begin
date of hold.
TPRRHLD_TO_DATE DATE 7 YES TO DATE: This field identifies the end date hold
expires.
TPRRHLD_REASON VARCHAR2 30 YES REASON: Free format field which identifies the reason
the hold was placed.
TPRRHLD_AMOUNT_OWED NUMBER 7 2 YES AMOUNT OWED: This field identifies a dollar amount
associated with hold.
TPRRHLD_ORIG_CODE VARCHAR2 4 YES ORIGINATOR CODE: This field identifies person/office
who authorized hold status.
TPRRHLD_FIN_AID_TERM_OP VARCHAR2 2 YES FINANCIAL AID TERM OPERATOR: Identifies the operator
for which terms to include in Account Balance for
Authorized FinAid.
TPRRHLD_FIN_AID_TERM_CODE VARCHAR2 6 YES FINANCIAL AID TERM CODE: Identifies which term codes
to include in Account Balance for Authorized FinAid.
TPRRHLD_MEMO_TERM_OP VARCHAR2 2 YES MEMO TERM OPERATOR: Identifies the operator for which
terms to include in Account Balance for Memos.
TPRRHLD_MEMO_TERM_CODE VARCHAR2 6 YES MEMO TERM CODE: Identifies which terms to include in
Account Balance for Memos.
Date: 21-JUN-2004 Page: 120
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
TPRRHLD_MIN_CURR_BALANCE NUMBER 7 2 YES MINIMUM CURRENT BALANCE: Minimum Current Balance for
Hold.
TPRRHLD_MAX_CURR_BALANCE NUMBER 7 2 YES MAXIMUM CURRENT BALANCE: Maximum Current Balance for
Hold.
TPRRHLD_AS_OF_DATE DATE 7 YES AS OF DATE: Date used to determine what transactions
are current.
TPRRHLD_AGING_DATE_CODE VARCHAR2 1 YES AGING DATE CODE: Date to use for Aging calculation.
TPRRHLD_MIN_AGING_DAYS NUMBER 7 YES MINIMUM DATE: Low end of Aging days range.
TPRRHLD_MAX_AGING_DAYS NUMBER 7 YES MAXIMUM DATE: High end of Aging days range.
TPRRHLD_MIN_AGING_BALANCE NUMBER 7 2 YES MINIMUM BALANCE: Minimum Aging balance for hold.
TPRRHLD_MAX_AGING_BALANCE NUMBER 7 2 YES MAXIMUM BALANCE: Maximum Aging balance for hold.
Date: 21-JUN-2004 Page: 121
TABLE: TRRACCD
CREATOR: TAISMGR
Research Accounting Account Detail Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
TRRACCD_GRNT_CODE VARCHAR2 9 NO GRANT CODE: The user-defined or system assigned Grant
identification code.
TRRACCD_TRAN_NUMBER NUMBER 8 NO TRANSACTION NUMBER: This field identifies the
transaction number associated with each detail
transaction on the account.
TRRACCD_COAS_CODE VARCHAR2 1 NO CHART OF ACCOUNTS CODE: The primary identification
code for any chart of accounts that is used to
uniquely identify that chart from any other in a
multi-chart environment.
TRRACCD_FUND_CODE VARCHAR2 6 NO FUND CODE: Identifies the fund code that appears on a
transaction.
TRRACCD_DETAIL_CODE VARCHAR2 4 NO DETAIL CODE: This field identifies the detail code
associated with the transaction.
TRRACCD_TRANS_DATE DATE 7 NO TRANSACTION DATE: This field specifies the date the
transaction becomes effective. As of this date the
transaction will be calculated into amount due and
will be eligible to be fed to accounting.
TRRACCD_EFFECTIVE_DATE DATE 7 NO EFFECTIVE DATE: This field specifies the date the
transaction becomes effective. As of this date the
transaction will be calculated into amount due and
will be eligible to be fed to accounting.
TRRACCD_AMOUNT NUMBER 12 2 NO AMOUNT: This field indicates the billed dollar amount
of the transaction.
TRRACCD_BALANCE NUMBER 12 2 NO BALANCE: This field indicates the balance remaining
from the amount of the transaction. This balance is
adjusted by the application of payment process. A
negative balance is a credit on the account. A
positi
ve balance is a charge.
TRRACCD_SRCE_CODE VARCHAR2 1 NO SOURCE CODE: This field identifies the source of how
the transaction was entered onto the account. For
example - registration, deposit, user-entered
transaction. The default value is T - User entered
transa
ction.
TRRACCD_ACCT_FEED_IND VARCHAR2 1 NO ACCOUNTING FEED INDICATOR: This field indicates if the
status of the transaction in the accounting feed.
Valid values are: Y - Feed transaction, F -
Transaction fed, N - Do not feed transaction.
TRRACCD_SESSION_NUMBER NUMBER 5 NO SESSION NUMBER: Cashiering session for this
transaction (0 = current session).
TRRACCD_ACTIVITY_DATE DATE 7 NO ACTIVITY DATE: This field specifies the most current
date record was created or updated.
TRRACCD_USER_ID VARCHAR2 30 NO USER ID: This field identifies the userid of the
cashier that posted the transaction to the account.
TRRACCD_RUCL_CODE VARCHAR2 4 YES RULE CLASS CODE: The four character alphanumeric code
identifying an accounting transaction rule class.
Date: 21-JUN-2004 Page: 122
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
TRRACCD_ACTUAL_COST_AMT NUMBER 12 2 YES ACTUAL COST AMOUNT: This field indicates the actual
cost dollar amount of the transaction.
TRRACCD_BILL_DATE DATE 7 YES BILL DATE: This field specifies the date the
transaction was processed the billing procedure in
"Update" mode.
TRRACCD_CSHR_END_DATE DATE 7 YES CASHIER END DATE: The end date of the cashiering
session for this transaction.
TRRACCD_DESC VARCHAR2 30 YES DESCRIPTION: This field specifies a free-format
description of the transaction.
TRRACCD_TRAN_NUMBER_PAID NUMBER 8 YES TRANSACTION NUMBER PAID: This field identifies the
transaction number of a specific application of
payment. This transaction was used to directly apply
to the transaction number specified here.
TRRACCD_BILL_INV_SEQ_NO NUMBER 5 YES BILLED INVOICE NUMBER: A unique number identifying the
document being updated.
TRRACCD_BILL_INV_ADJ_NO NUMBER 5 YES BILLED INV ADJ NO: A unique number identifying the
document being updated.
TRRACCD_PAID_INV_SEQ_NO NUMBER 5 YES PAID INVOICE NUMBER: The invoice number of a specific
application of payment.
TRRACCD_PAID_INV_ADJ_NO NUMBER 5 YES PAID INV ADJ NO: A unique number identifying the
document being updated.
TRRACCD_WITHHOLDING_IND VARCHAR2 1 YES WITHHOLDING INDICATOR: The indicator for withholding
to the agency.
TRRACCD_REBILL_IND VARCHAR2 1 YES REBILL INDICATOR: The indicator for payment rebill.
TRRACCD_FEED_DATE DATE 7 YES FEED DATE: The feed date is the date this row was
processed by tgrfeed and inserted into the
GENERAL.GURFEED table.
TRRACCD_FEED_DOC_CODE VARCHAR2 8 YES FEED DOCUMENT CODE: The document code generated by
GURFEED to identify and feed this transaction to
Finance.
TRRACCD_WITHHOLDING_AMT NUMBER 12 2 YES WITHHOLDING AMOUNT: The amount withheld to the agency.
TRRACCD_PAYMENT_ID VARCHAR2 20 YES PAYMENT ID: User defined field where they enter a
credit card number or check number or wire number when
they receive a payment.
TRRACCD_ENTRY_DATE DATE 7 YES ENTRY DATE: This field specifies the most current date
record was created.
Date: 21-JUN-2004 Page: 123
TABLE: TRRAGTC
CREATOR: TAISMGR
Research Accounting Aging Report Collector Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
TRRAGTC_SESS_ID VARCHAR2 8 NO SESSION IDENTIFICATION: The unique session
identification code of the user.
TRRAGTC_GRNT_CODE VARCHAR2 9 NO GRANT CODE: The user-defined or system assigned Grant
identification code.
TRRAGTC_TYPE_INDICATOR VARCHAR2 1 NO TYPE INDICATOR: This field indicates whether the
amounts stored for the particular grant code is for
unbilled/billed/withholding.
TRRAGTC_ACTIVITY_DATE DATE 7 NO ACTIVITY DATE: The date that the information for the
record was entered or updated.
TRRAGTC_USER_ID VARCHAR2 30 NO USER IDENTIFICATION: The unique identification of the
user.
TRRAGTC_AGENCY_PIDM NUMBER 8 YES AGENCY PIDM: The unique identifier assigned to the
Sponsor Agency which allows a process to retreive
pertinent information for this agency.
TRRAGTC_PMS_CODE VARCHAR2 16 YES PMS CODE: Payment Management System Code which is
associated with the particular grant.
TRRAGTC_DOC_CODE VARCHAR2 8 YES DOCUMENT CODE: The user-defined or system generated
document number of the transaction
TRRAGTC_BILL_INV_SEQ_NO NUMBER 5 YES BILLED INVOICE SEQUENCE NUMBER: A unique number
identifying the document being updated.
TRRAGTC_AMOUNT NUMBER 12 2 YES AMOUNT: This field indicates the
billed/unbilled/withhold dollar amount for the
specified date range.
TRRAGTC_DATE_RANGE VARCHAR2 1 YES DATE RANGE: This number indicates the date range
entered by the user.
Date: 21-JUN-2004 Page: 124
TABLE: TRRAPPL
CREATOR: TAISMGR
Research Accounting Application of Payment Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
TRRAPPL_GRNT_CODE VARCHAR2 9 NO GRANT CODE: The user-defined or system assigned Grant
identification code.
TRRAPPL_PAY_TRAN_NUMBER NUMBER 8 NO PAYMENT TRANS NUMBER: This field identifies the
transaction number of the detail code used as the
payment transaction in application of payments.
TRRAPPL_CHG_TRAN_NUMBER NUMBER 8 NO CHARGE TRANSACTION NUMBER: This field identifies the
transaction number of the detail code used as the
charge transaction in application of payments.
TRRAPPL_AMOUNT NUMBER 12 2 NO AMOUNT: This field indicates the amount of the payment
that paid off the charge.
TRRAPPL_ACCT_FEED_IND VARCHAR2 1 NO ACCOUNTING FEED INDICATOR: This flad indicates the
status of the application of payment in the accounting
feed process. Valid values are: Y - Transaction is
ready to feed, F - Transaction has been fed.
TRRAPPL_ACTIVITY_DATE DATE 7 NO ACTIVITY DATE: This field specifies the most current
date record was created or updated.
TRRAPPL_USER_ID VARCHAR2 30 NO USER ID: This field identifies the userid of the
cashier who executed the application of payment
process to generate this record.
TRRAPPL_DIRECT_PAY_IND VARCHAR2 1 YES DIRECT PAYMENT INDICATOR: This flag indicates that the
transaction was a direct application of payment
specified when the transaction was entered on the
account. Valid value is: Y - Direct application
of
payment.
TRRAPPL_REAPPL_IND VARCHAR2 1 YES REAPPLY INDICATOR: This flag indicates that this
application of payment record was created because the
unapplication of payment process had been run for this
account. Valid value is: Y - this application o
f
payment was due to a reapplication.
TRRAPPL_FEED_DATE DATE 7 YES FEED DATE: The feed date is the date this row was
processed by tgrfeed and inserted into the GURFEED
table.
TRRAPPL_FEED_DOC_CODE VARCHAR2 8 YES FEED DOCUMENT CODE: The document code generated by
GURFEED to identify and feed this transaction to
Finance.
Date: 21-JUN-2004 Page: 125
TABLE: TRRCOLL
CREATOR: TAISMGR
Grant Billing Collection Repeating Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
TRRCOLL_GRNT_CODE VARCHAR2 9 NO GRANT CODE: The field identifies the grant code that
the bill is associated with.
TRRCOLL_CODE VARCHAR2 5 NO COLLECTION CODE: This field indicates the collection
code related to the bill.
TRRCOLL_STATUS_IND VARCHAR2 1 NO STATUS IND: Status Indicator. Values are (O)pen or
(C)losed.
TRRCOLL_ACTIVITY_DATE DATE 7 NO Activity Date: Indicates the date the record was
changed or inserted.
TRRCOLL_USER_ID VARCHAR2 30 NO USER_ID: Default to the USER ID of the person who is
using this form.
TRRCOLL_BILL_INV_SEQ_NO NUMBER 5 YES BILL INVOICE NUMBER: This field identifies the bill
invoice number that you are contacting about.
TRRCOLL_BILL_INV_ADJ_NO NUMBER 5 YES BILL INVOICE Adjustment NUMBER: Indicates the latest
bill record incase bill reversals were done.
TRRCOLL_CONTACT VARCHAR2 60 YES CONTACT : This field indicates the name of the contact
person at the agency.
TRRCOLL_CONTACT_DATE DATE 7 YES CONTACT DATE: The date the contact was made. The date
can default to sysdate and can be overridable.
TRRCOLL_CONTACT_PHONE_AREA VARCHAR2 3 YES CONTACT PHONE AREA: This field identifies the phone
area number of the person that you have contacted from
the agency.
TRRCOLL_CONTACT_PHONE_NUMBER VARCHAR2 7 YES CONTACT PHONE NUMBER: This field identifies the phone
number of the person that you have contacted from the
agency.
TRRCOLL_CONTACT_PHONE_EXT VARCHAR2 4 YES CONTACT PHONE EXTENSION: This field identifies the
extension number of the person that you have contacted
from the agency.
TRRCOLL_CONTACT_EMAIL VARCHAR2 60 YES CONTACT EMAIL: Email of Contact Person at the agency.
TRRCOLL_DESCRIPTION VARCHAR2 132 YES DESCRIPTION: Free form description.
TRRCOLL_AMT NUMBER 12 2 YES Amount: Amount of the bill the collection agency is
being contacted for.
Date: 21-JUN-2004 Page: 126
TABLE: TRVCOLL
CREATOR: TAISMGR
Collection Code Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
TRVCOLL_CODE VARCHAR2 5 NO COLLECTION CODE.
TRVCOLL_DESCRIPTION VARCHAR2 35 NO DESCRIPTION: This field specifies the description for
the collection code.
TRVCOLL_ACTIVITY_DATE DATE 7 NO ACTIVITY DATE: The date of the activity takes place,
and this date will default to system date.
TRVCOLL_USER_ID VARCHAR2 30 NO USER_ID: Default to the USER ID of the person who is
using this form.
Date: 21-JUN-2004 Page: 127
TABLE: TSRCTPB
CREATOR: TAISMGR
Collector Table Used For TSRTBIL Report Processing.
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
TSRCTPB_SESSIONID VARCHAR2 30 NO SESSION ID: This field identifies a unique internal
identification that is generated everytime a user
signs on.
TSRCTPB_CONTRACT_PIDM NUMBER 8 NO CONTRACTOR PIDM: Internal Identification Number of the
non-person account that is identified as a third party
contract.
TSRCTPB_ACTIVITY_DATE DATE 7 NO ACTIVITY DATE: Most recent date record was revised.
TSRCTPB_USER_ID VARCHAR2 30 NO USER ID: This field identifies the system user signon
id.
TSRCTPB_CONTRACT_NUMBER NUMBER 8 YES CONTRACT NUMBER: This field identifies the Contract
number associated with the third party for the term.
TSRCTPB_TERM_CODE VARCHAR2 6 YES TERM CODE: This field identifies the term associated
with the third party contract number.
TSRCTPB_STUDENT_PIDM NUMBER 8 YES STUDENT PIDM: The pidm of the student whose schedule
should be printed in the session.
TSRCTPB_AMOUNT1 NUMBER 12 2 YES AMOUNT1: This field indicates the dollar amount one
field that will be used in processing
TSRCTPB_AMOUNT2 NUMBER 12 2 YES AMOUNT2: This field indicates the dollar amount two
field that will be used in processing
Date: 21-JUN-2004 Page: 128
TABLE: TSRTERM
CREATOR: TAISMGR
Voice Response Accounts Receivable Term Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
TSRTERM_PRIORITY NUMBER 4 NO Priority Sequence Number of Term in listing of terms
for Accounts Receivable information.
TSRTERM_TERM_CODE_HOST VARCHAR2 6 NO Accounts Receivable Term Code.
TSRTERM_YEAR VARCHAR2 4 NO Year for term code to be spoken during telephone
Accounts Receivable.
TSRTERM_TERM_MSG_ID NUMBER 6 NO VRU Message ID for the term to be spoken during
telephone Accounts Receivable.
TSRTERM_TERM_MSG_ID_MENU NUMBER 6 NO VRU Message ID for the term to be spoken when term is
used in a menu during telephone Accounts Receivable.
TSRTERM_ACTIVITY_DATE DATE 7 NO Most recent date record was revised.
TSRTERM_START_DATE_1 DATE 7 NO Beginning Date of the first telephone Accounts
Receivable period in which term code may be used.
TSRTERM_END_DATE_1 DATE 7 NO Ending Date of the first telephone Accounts Receivable
period in which term code may be used.
TSRTERM_START_DATE_2 DATE 7 YES Beginning Date of the second telephone Accounts
Receivable period in which term code may be used.
TSRTERM_END_DATE_2 DATE 7 YES Ending Date of the second telephone Accounts
Receivable period in which term code may be used.
TSRTERM_DLN_START_DATE DATE 7 YES Beginning Date to speak deadline information during
telephone Accounts Receivable transactions.
TSRTERM_DLN_END_DATE DATE 7 YES Ending Date to speak deadline information during
telephone Accounts Receivable transactions.
TSRTERM_LVL_1_MSG_ID NUMBER 6 YES First deadline message number for telephone Accounts
Receivable transactions.
TSRTERM_LVL_1_DLN_DATE DATE 7 YES Deadline date for first deadline message for telephone
Accounts Receivable applications.
TSRTERM_LVL_2_MSG_ID NUMBER 6 YES Second deadline message number for telephone Accounts
Receivable transactions.
TSRTERM_LVL_2_DLN_DATE DATE 7 YES Deadline date for second deadline message for
telephone Accounts Receivable applications.
TSRTERM_LVL_3_MSG_ID NUMBER 6 YES Third deadline message number for telephone Accounts
Receivable transactions.
TSRTERM_LVL_3_DLN_DATE DATE 7 YES Deadline date for third deadline message for telephone
Accounts Receivable applications.
TSRTERM_LVL_4_MSG_ID NUMBER 6 YES Fourth deadline message number for telephone Accounts
Receivable transactions.
TSRTERM_LVL_4_DLN_DATE DATE 7 YES Deadline date for fourth deadline message for
telephone Accounts Receivable applications.
TSRTERM_LVL_5_MSG_ID NUMBER 6 YES Fifth deadline message number for telephone Accounts
Receivable transactions.
TSRTERM_LVL_5_DLN_DATE DATE 7 YES Deadline date for fifth deadline message for telephone
Accounts Receivable applications.
TSRTERM_LVL_6_MSG_ID NUMBER 6 YES Sixth deadline message number for telephone Accounts
Receivable transactions.
Date: 21-JUN-2004 Page: 129
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
TSRTERM_LVL_6_DLN_DATE DATE 7 YES Deadline date for sixth deadline message for telephone
Accounts Receivable applications.
TSRTERM_LVL_7_MSG_ID NUMBER 6 YES Seventh deadline message number for telephone Accounts
Receivable transactions.
TSRTERM_LVL_7_DLN_DATE DATE 7 YES Deadline date for seventh deadline message for
telephone Accounts Receivable applications.
TSRTERM_LVL_8_MSG_ID NUMBER 6 YES Eighth deadline message number for telephone Accounts
Receivable transactions.
TSRTERM_LVL_8_DLN_DATE DATE 7 YES Deadline date for eighth deadline message for
telephone Accounts Receivable applications.
Date: 21-JUN-2004 Page: 130
TABLE: TTB1098
CREATOR: TAISMGR
1098-T Tax Information Form.
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
TTB1098_INST_TIN VARCHAR2 9 NO INSTITUTION TIN: Institutions Tax Identification
Number
TTB1098_INST_NAME1 VARCHAR2 40 NO INSTITUTION NAME: The name of the institution (payer)
associated with the TIN reported.
TTB1098_INST_ADDRESS1 VARCHAR2 40 NO INSTITUTION ADDRESS: The mailing address of the
institution (payer) associated with the TIN reported.
TTB1098_INST_CITY VARCHAR2 40 NO INSTITUTION CITY: The Institutions city, town, or post
office.
TTB1098_TRAN_TIN VARCHAR2 9 NO TRANSMITTER TIN: Transmitters Tax Identification
Number.
TTB1098_TRAN_CTRL_CODE VARCHAR2 5 NO TRANSMITTER CONTROL CODE: The five character
alpha/numeric Transmitter Control Code (TCC) assigned
by the IRS.
TTB1098_TRAN_NAME1 VARCHAR2 40 NO TRANSMITTER NAME: The name of the person transmitting
the magnetic tape.
TTB1098_TRAN_CO_NAME1 VARCHAR2 40 NO TRANSMITTER COMPANY NAME: The name of the transmitters
company to be associated with the address where
correspondence should be sent or media should be
returned due to processing problems.
TTB1098_TRAN_CO_ADDRESS VARCHAR2 40 NO TRANSMITTER COMPANY ADDRESS: The transmitters mailing
address where correspondence should be sent or media
should be returned in the event IRS is unable to
process.
TTB1098_TRAN_CO_CITY VARCHAR2 40 NO TRANSMITTER COMPANY CITY: The transmitters city, town,
or post office where correspondence should be sent or
media should be returned in the event IRS is unable to
process.
TTB1098_ACTIVITY_DATE DATE 7 NO ACTIVITY DATE: This field specifies the most current
date record was created or updated.
TTB1098_USER_ID VARCHAR2 30 NO USER ID: This field identifies the system user signon
id who last created or updated the record.
TTB1098_INST_NAME2 VARCHAR2 40 YES INSTITUTION NAME: Any additional information that may
be part of the name of the Institution.
TTB1098_INST_NAME_CTRL VARCHAR2 4 YES INSTITUTION NAME CONTROL: The Name Control Code is
obtained from the mail label on the package sent
containing instructions for paper filing that is
mailed to most payers each December.
TTB1098_INST_ADDRESS2 VARCHAR2 40 YES INSTITUTION ADDRESS: Any additional information that
may be part of the institutions address.
TTB1098_INST_ST_CODE VARCHAR2 3 YES INSTITUTION STATE CODE: The State/Province code where
the Institution resides.
TTB1098_INST_ZIP_CODE VARCHAR2 9 YES INSTITUTION ZIP CODE: The nine digit Zip for the
Institutions mailing address.
TTB1098_INST_NATN_CODE VARCHAR2 5 YES INSTITUTION NATION CODE: The nation code where the
Institution resides.
TTB1098_INST_FOREIGN_IND VARCHAR2 1 YES INSTITUTION FOREIGN INDICATOR: Indicator denoting if
an institution is a foreign entity. Null represents a
not foreign entity.
Date: 21-JUN-2004 Page: 131
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
TTB1098_INST_CONT_PH_AREA VARCHAR2 3 YES INSTITUTION CONTACT PHONE NUMBER: The telephone area
code of the institutions contact person.
TTB1098_INST_CONT_PH_NO VARCHAR2 7 YES INSTITUTION CONTACT PHONE NUMBER: The telephone number
of the institutions contact person.
TTB1098_INST_CONT_PH_EXT VARCHAR2 5 YES INSTITUTION CONTACT PHONE EXTENSION: The phone
extension to the institutions contact person
TTB1098_INST_OFFICE_CODE VARCHAR2 4 YES INSTITUTION OFFICE CODE: The office code of the
institution. For example, institutions with multiple
locations can use this field to identify the location
of the office submitting the information ret
urn.
This field is used for B record processing.
TTB1098_TRAN_FOREIGN_IND VARCHAR2 1 YES TRANSMITTER FOREIGN INDICATOR: Indicator denoting if a
transmitter is a foreign entity. Null represents a
not foreign entity.
TTB1098_TRAN_NAME2 VARCHAR2 40 YES TRANSMITTER NAME: Any additional information that may
be part of the transmitters name.
TTB1098_TRAN_CO_NAME2 VARCHAR2 40 YES TRANSMITTER COMPANY NAME: Any additional information
that may be part of the name of the transmitters
company where correspondence should be sent or media
should be returned due to processing problems.
TTB1098_TRAN_CO_ST_CODE VARCHAR2 3 YES TRANSMITTER COMPANY STATE CODE: The State/Province
code where the transmitters company resides.
TTB1098_TRAN_CO_ZIP_CODE VARCHAR2 9 YES TRANSMITTER COMPANY ZIP CODE: The Zip code for the
Transmitters Companys mailing address.
TTB1098_TRAN_CO_NATN_CODE VARCHAR2 5 YES TRANSMITTER COMPANY NATION CODE: The nation code where
the Transmitters Company resides.
TTB1098_TRAN_CONT_NAME VARCHAR2 40 YES TRANSMITTER CONTACT NAME: Enter the name of the person
to be contacted if IRS encounters problems with the
file or transmission.
TTB1098_TRAN_CONT_PH_AREA VARCHAR2 3 YES TRANSMITTER CONTACT PHONE AREA: The telephone area
code of the person to contact regarding magnetic
files.
TTB1098_TRAN_CONT_PH_NO VARCHAR2 7 YES TRANSMITTER CONTACT PHONE NUMBER: The telephone number
of the person to contact regarding magnetic files.
TTB1098_TRAN_CONT_PH_EXT VARCHAR2 5 YES TRANSMITTER CONTACT PHONE EXTENSION: The extension of
the person to contact regarding magnetic files.
TTB1098_TRAN_CONT_EMAIL VARCHAR2 35 YES CONTACT EMAIL: EMail address of the Transmitter
Contact
Date: 21-JUN-2004 Page: 132
TABLE: TTBIRSC
CREATOR: TAISMGR
Collector Table for IRS 1220 data.
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
TTBIRSC_DATA VARCHAR2 750 YES DATA: This column holds the 1220 data requirments for
IRS report.
TTBIRSC_RECORD_TYPE_IND VARCHAR2 1 YES RECORD TYPE INDICATOR: This field holds the record
type.
TTBIRSC_ACTIVITY_DATE DATE 7 YES ACTIVITY DATE:The date on which the form was last
updated.
TTBIRSC_USER_ID VARCHAR2 30 YES USER IDENTITY:The user id of the last person to modify
the form.
Date: 21-JUN-2004 Page: 133
TABLE: TTBPROC
CREATOR: TAISMGR
Collector table for tsp1098 process.
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
TTBPROC_PIDM NUMBER 8 YES PIDM: The Internal Identification Number of the person
or non-person account.
TTBPROC_LAST_NAME_ORIG VARCHAR2 60 YES SPRIDEN LAST NAME: The last name of the student.
TTBPROC_ID_WEB VARCHAR2 9 YES STUDENT TAXI ID: The student identification number
that is stored in the SPRIDEN table.
TTBPROC_LAST_NAME_WEB VARCHAR2 60 YES TAXI LAST NAME: The last name of the student in the
student tax notification table.
TTBPROC_FIRST_NAME_WEB VARCHAR2 15 YES TAXI FIRST Name: The first name of the student.
TTBPROC_ADDR_LINE1_WEB VARCHAR2 30 YES TAXI ADDRESS LINE1: The address line1 for the student.
TTBPROC_ADDR_LINE2_WEB VARCHAR2 30 YES TAXI ADDRESS LINE2: The address line2 for the student.
TTBPROC_ADDR_LINE3_WEB VARCHAR2 30 YES TAXI ADDRESS LINE3: The address line3 for the student.
TTBPROC_CITY_WEB VARCHAR2 25 YES TAXI CITY: The city details for the student.
TTBPROC_STAT_CODE_WEB VARCHAR2 3 YES TAXI STATE CODE: The state code for the student.
TTBPROC_ZIP_WEB VARCHAR2 10 YES TAXI ZIP: The students zip code.
TTBPROC_SSN_WEB VARCHAR2 9 YES TAXI SOCIAL SECURITY NUMBER: The students social
securtiy number.
TTBPROC_ID_ON VARCHAR2 9 YES TAXN STUDENT ID: The student identification number
that is stored in the SPRIDEN table.
TTBPROC_LAST_NAME_ON VARCHAR2 60 YES TAXN LAST NAME: The last name of the student in the
student tax notification table.
TTBPROC_FIRST_NAME_ON VARCHAR2 15 YES TAXN FIRST Name: The first name of the student.
TTBPROC_ADDR_LINE1_ON VARCHAR2 30 YES TAXN ADDRESS LINE1: The address line1 for the student.
TTBPROC_ADDR_LINE2_ON VARCHAR2 30 YES TAXN ADDRESS LINE2: The address line2 for the student.
TTBPROC_ADDR_LINE3_ON VARCHAR2 30 YES TAXN ADDRESS LINE3: The address line3 for the student.
TTBPROC_CITY_ON VARCHAR2 25 YES TAXN CITY: The city details for the student.
TTBPROC_STAT_CODE_ON VARCHAR2 3 YES TAXN STATE CODE: The state code for the student.
TTBPROC_ZIP_ON VARCHAR2 10 YES TAXN ZIP: The students zip code.
TTBPROC_SSN_ON VARCHAR2 9 YES TAXN SOCIAL SECURITY NUMBER: The students social
securtiy number.
TTBPROC_USER_ID VARCHAR2 30 YES USER IDENTIFICATION: This field stores the users
unique identification.
TTBPROC_ACTIVITY_DATE DATE 7 YES ACTIVITY DATE: The last time the table was populated
by the user.
Date: 21-JUN-2004 Page: 134
TABLE: TTBTAXI
CREATOR: TAISMGR
Student Tax Information Table.
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
TTBTAXI_PIDM NUMBER 8 NO The Internal Identification Number of the person or
non-person account.
TTBTAXI_TAX_YEAR NUMBER 4 NO TAX YEAR: The tax year the information will be applied
to.
TTBTAXI_ID VARCHAR2 9 NO STUDENT ID: The student identification number that is
stored in the SPRIDEN table.
TTBTAXI_LAST_NAME VARCHAR2 60 NO LAST NAME: The students last name.
TTBTAXI_ACTIVITY_DATE DATE 7 NO ACTIVITY DATE: The activity date is the last day the
form was modified.
TTBTAXI_USER_ID VARCHAR2 30 YES USER ID: The User Id of the person last to modify the
form.
TTBTAXI_SSN VARCHAR2 9 YES SOCIAL SECURITY NUMBER: The students Social Security
Number.
TTBTAXI_FIRST_NAME VARCHAR2 15 YES FIRST NAME: The students first name.
TTBTAXI_ADDR_LINE1 VARCHAR2 30 YES ADDRESS LINE1: The students address number or
apartment number stored in line1.
TTBTAXI_ADDR_LINE2 VARCHAR2 30 YES ADDRESS LINE2: The students address number or
apartment number stored in line2.
TTBTAXI_ADDR_LINE3 VARCHAR2 30 YES ADDRESS LINE3: The students address number or
apartment number stored in line3.
TTBTAXI_CITY VARCHAR2 25 YES CITY: The city where the student resides.
TTBTAXI_STAT_CODE VARCHAR2 3 YES STATE: The state where the student resides.
TTBTAXI_ZIP VARCHAR2 10 YES ZIP CODE: The associated zip code of the State where
the student resides.
TTBTAXI_LNAME_TAXP VARCHAR2 60 YES TAXPAYERS LAST NAME: The last name of the taxpayer.
May be different than the student.
TTBTAXI_FNAME_TAXP VARCHAR2 15 YES TAXPAYERS FIRST NAME: The first name of the taxpayer.
May be different than the student.
TTBTAXI_ADDR_TAXP VARCHAR2 60 YES TAXPAYERS ADDRESS: The street address and number or
apartment of the taxpayer. May be different than the
student stored in line1.
TTBTAXI_CITY_TAXP VARCHAR2 25 YES TAXPAYERS CITY: The city where the taxpayer resides.
May be different than the student.
TTBTAXI_STAT_CODE_TAXP VARCHAR2 3 YES TAXPAYERS STATE: The state where the taxpayer resides.
May be different than the student.
TTBTAXI_ZIP_TAXP VARCHAR2 10 YES TAXPAYERS ZIP CODE: The associated zip code of the
State where the taxpayer resides. May be different
than the student.
TTBTAXI_PHONE_AREA_TAXP VARCHAR2 3 YES TAXPAYERS AREA CODE: This field contains the taxpayers
phone area code.
TTBTAXI_PHONE_NUM_TAXP VARCHAR2 7 YES TAXPAYERS PHONE NUMBER: This field contains taxpayers
phone number.
TTBTAXI_TIN_TAXP VARCHAR2 9 YES TAXPAYERS TIN OR STUDENTS SSN: The taxpayers Tax
Identification Number or the Students Social Security
Number.
Date: 21-JUN-2004 Page: 135
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
TTBTAXI_WEB_LAST_UPDATE DATE 7 YES LAST UPDATE: The last day the Tax Information Web Page
was updated.
TTBTAXI_NATN_CODE VARCHAR2 5 YES NATION CODE: The nation where the student resides.
TTBTAXI_NATN_CODE_TAXP VARCHAR2 5 YES TAXPAYER NATION CODE: The nation where the taxpayer
resides. May be different than the student.
Date: 21-JUN-2004 Page: 136
TABLE: TTBTAXN
CREATOR: TAISMGR
Tax notification table for student. This is similar to the IRS 1098T form. This form enables students to apply for
tax relief for qualified fees.
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
TTBTAXN_PIDM NUMBER 8 NO PIDM: The Internal Identification number of the person
or a non-person account.
TTBTAXN_TAX_YEAR NUMBER 4 NO TAX YEAR: The tax year the information is reported on.
TTBTAXN_ID VARCHAR2 9 NO ID: is the Students Identfication number or STANDARD.
TTBTAXN_SEQ_NUM NUMBER 3 NO SEQUENCE NUMBER: is the one up number which enables to
track the current corrected record among the void
records for an individual student.
TTBTAXN_LAST_NAME VARCHAR2 60 NO STUDENT LAST NAME: This field contains the student
last name.
TTBTAXN_STUD_NOTIF_STATUS VARCHAR2 1 NO STUDENT NOTIFICATION: Indicates the status of the
student notification field.
TTBTAXN_IRS_REPORT_STATUS VARCHAR2 1 NO IRS REPORT: Indicates the status of the IRS
notification field.
TTBTAXN_VOID_IND VARCHAR2 1 NO VOID INDICATOR: The void indicator flags a record as
incorrect and indicates a new reord must be sent.
TTBTAXN_CORRECTED_IND VARCHAR2 1 NO CORRECT INDICATOR: The correct indicator informs the
user that this information has been updated.
TTBTAXN_TEST_MODE_IND VARCHAR2 1 NO TEST MODE INDICATOR: This field indicates if the table
was populated by a test run or an official run.
TTBTAXN_CREATED_STUD_IND VARCHAR2 1 NO STUDENT CREATED IN TAXN FORM: This field indicates if
the student was created in the taxn form while has no
records in the banner database.
TTBTAXN_HALF_TIME_ENRL_IND VARCHAR2 1 NO HALF TIME ENROLMENT: This field indicates if the
student per the instituions rules was at least a half
time status during a given tax year.
TTBTAXN_GRAD_STUD_IND VARCHAR2 1 NO GRADUATE STUDENT: This field inicates if the student
was exclusively a graduate student for a given tax
year.
TTBTAXN_REMOVE_NOTIF_IND VARCHAR2 1 NO REMOVE NOTIFICATION: This flag indicates if the user
no longer wants either a student or an IRS
notification going out for a student.
TTBTAXN_ACTIVITY_DATE DATE 7 NO ACTIVITY DATE: This is the date of last activity on
this form.
TTBTAXN_USER_ID VARCHAR2 30 YES USER IDENTIFICATION: This is the user ID of the last
person to update this form.
TTBTAXN_FIRST_NAME VARCHAR2 15 YES STUDENT FIRST NAME: This field contains the student
first name.
TTBTAXN_ADDR_LINE1 VARCHAR2 30 YES STUDENT ADDRESS LINE1: This field contains the student
address.
TTBTAXN_ADDR_LINE2 VARCHAR2 30 YES STUDENT ADDRESS LINE2: This field contains the student
address.
TTBTAXN_ADDR_LINE3 VARCHAR2 30 YES STUDENT ADDRESS LINE3: This field contains the student
address.
TTBTAXN_CITY VARCHAR2 25 YES CITY: This field is the students city.
Date: 21-JUN-2004 Page: 137
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
TTBTAXN_STAT_CODE VARCHAR2 3 YES STATE: This field is the students state code.
TTBTAXN_ZIP VARCHAR2 10 YES ZIP: This field is the students zip code.
TTBTAXN_SSN VARCHAR2 9 YES SSN: This field is the students social security
number.
TTBTAXN_STUD_NOTIF_DATE DATE 7 YES STUDENT NOTIFICATION DATE:Date the student
notification was set or last updated by the user.
TTBTAXN_IRS_REPORT_DATE DATE 7 YES IRS REPORT DATE: Date the IRS report was set or last
updated by the user.
TTBTAXN_REMOVE_NOTIF_DATE DATE 7 YES REMOVE NOTIFICATION DATE: Date the remove notif
indicator was set or last updated by the user.
TTBTAXN_LNAME_TAXP VARCHAR2 60 YES TAXPAYERS LAST NAME: This field contains the taxpayers
last name.
TTBTAXN_FNAME_TAXP VARCHAR2 15 YES TAXPAYERS FIRST NAME: This field contains the
taxpayers first name.
TTBTAXN_ADDR_TAXP VARCHAR2 60 YES TAXPAYERS ADDRESS: This field contains the taxpayers
address.
TTBTAXN_CITY_TAXP VARCHAR2 25 YES TAXPAYERS CITY: This field contains the taxpayers
city.
TTBTAXN_STAT_CODE_TAXP VARCHAR2 3 YES TAXPAYERS STATE CODE: This field contains taxpayers
state code.
TTBTAXN_ZIP_TAXP VARCHAR2 10 YES TAXPAYERS ZIP CODE: This field contains taxpayers zip
code.
TTBTAXN_PHONE_AREA_TAXP VARCHAR2 3 YES TAXPAYERS AREA CODE: This field contains the taxpayers
phone area code.
TTBTAXN_PHONE_NUM_TAXP VARCHAR2 7 YES TAXPAYERS PHONE NUMBER: This field contains taxpayers
phone number.
TTBTAXN_TIN_TAXP VARCHAR2 9 YES TAXPAYERS SSN: This field contains taxpayers social
security number.
TTBTAXN_NATN_CODE VARCHAR2 5 YES NATION CODE: The nation where the student resides.
TTBTAXN_NATN_CODE_TAXP VARCHAR2 5 YES TAXPAYER NATION CODE: The nation where the taxpayer
resides. May be different than the student.
TTBTAXN_MI VARCHAR2 15 YES STUDENT MIDDLE NAME: This field contains the students
middle name
TTBTAXN_AMOUNT_1 NUMBER 12 2 YES AMOUNT 1: Tax amount 1, currently not used
TTBTAXN_AMOUNT_2 NUMBER 12 2 YES AMOUNT 2: Total of Qualified Charges Billed
TTBTAXN_AMOUNT_3 NUMBER 12 2 YES AMOUNT 3: Total reductions to previously reported
Charges Billed
TTBTAXN_AMOUNT_4 NUMBER 12 2 YES AMOUNT 4: Total of Scholarships or Grants reported
TTBTAXN_AMOUNT_5 NUMBER 12 2 YES AMOUNT 5: Total reductions to previously reported
Scholarships or Grants
TTBTAXN_FUTURE_IND VARCHAR2 1 NO FUTURE INDICATOR: Y indicates that Charges Billed
includes amount from terms beginning in the first 3
months of the following Tax Year, or N
Date: 21-JUN-2004 Page: 138
TABLE: TTBTSPC
CREATOR: TAISMGR
Collector Table for tsp1098 process.
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
TTBTSPC_PIDM NUMBER 8 NO PIDM: The Internal Identification Number of the person
or non-person account.
TTBTSPC_ID VARCHAR2 9 NO STUDENT ID: The student identification number that is
stored in the SPRIDEN table.
TTBTSPC_LAST_NAME_ORIG VARCHAR2 60 NO SPRIDEN LAST NAME: The students last name.
TTBTSPC_MSG1 VARCHAR2 20 YES MESSAGE 1: This field holds Name if the students name
field is null.
TTBTSPC_MSG2 VARCHAR2 20 YES MESSAGE 2: This field holds Name if the students name
field is null.
TTBTSPC_MSG3 VARCHAR2 20 YES MESSAGE 3: This field holds Name if the students name
field is null.
Date: 21-JUN-2004 Page: 139
TABLE: TTBTXRN
CREATOR: TAISMGR
Tax Report Code for Student Notification. This table enables to maintain students report code with the total amount
for a single report code.
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
TTBTXRN_PIDM NUMBER 8 NO PIDM: Internal Identification number of the person or
a non person account.
TTBTXRN_TAX_YEAR NUMBER 4 NO TAX YEAR: This field holds the current tax year
applicable for the record.
TTBTXRN_REPT_CODE VARCHAR2 4 NO REPORT CODE: Report code for thestudent.
TTBTXRN_SEQ_NUM NUMBER 3 NO SEQUENCE NUMBER: This is same as the sequence number
in the taxn form, because this number is obtained from
the taxn form.
TTBTXRN_TOT_AMOUNT NUMBER 12 2 NO TOTAL AMOUNT: The total amount for a single report
code.
TTBTXRN_ACTIVITY_DATE DATE 7 NO ACTIVITY DATE: The date when the information for this
record on the table was entered or last updated.
TTBTXRN_CREATED_STUD_IND VARCHAR2 1 NO
TTBTXRN_USER_ID VARCHAR2 30 YES USER IDENTIFICATION: The unique identification code of
the last user to create or modify this record.
TTBTXRN_REPT_DESC VARCHAR2 30 YES REPORT CODE DESCRIPTION: This holds the description
for the report code.
Date: 21-JUN-2004 Page: 140
TABLE: TTBXSMC
CREATOR: TAISMGR
Collector table for the ttvxsum view.
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
TTBXSMC_SESSIONID NUMBER 8 NO SESSION ID: The uniques session identification number
for the user.
TTBXSMC_PIDM NUMBER 8 YES IDENTIFICATION NUMBER: The unique identification
number.
TTBXSMC_TAX_YEAR NUMBER 4 YES TAX YEAR: Tax year that applies to the detail codes.
TTBXSMC_REPT_CODE VARCHAR2 4 YES REPORT CODE: Report code that is stored in the ttvrept
table. This code is associated with category codes
and detail codes.
TTBXSMC_ACTIVITY_DATE DATE 7 YES ACTIVITY DATE:The date on which the form was last
updated.
TTBXSMC_USER_ID VARCHAR2 30 YES USER IDENTITY:The user id of the last person to modify
the form.
TTBXSMC_DCAT_CODE VARCHAR2 3 YES CATEGORY CODE:The category code that applies to the
report code for the tax year. This code is obtained
from the ttvdcat table.
TTBXSMC_DETC_CODE VARCHAR2 4 YES DETAIL CODE:Detail code that applies to the tax report
code for the tax year.This code is obtained from the
ttvdetc table.
TTBXSMC_DCAT_SUM_IND VARCHAR2 1 YES CATEGORY CODE SUM INDICATOR: The sum indicator at
category level.
TTBXSMC_DETC_SUM_IND VARCHAR2 1 YES DETAIL CODE SUM INDICATOR: The sum indicator at detail
code level.
Date: 21-JUN-2004 Page: 141
TABLE: TTRDTLC
CREATOR: TAISMGR
This collector table holds the student report code details with the total amount for a single report code.
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
TTRDTLC_PIDM NUMBER 8 NO PIDM: Internal Identification number of the person or
a non person account.
TTRDTLC_REPT_CODE VARCHAR2 4 YES REPORT CODE: Report code for thestudent.
TTRDTLC_LAST_NAME_ORIG VARCHAR2 60 YES ORIGINAL NAME AS IN SPRIDEN. This enables to sort the
collector table by last name and print the report.
TTRDTLC_AMOUNT NUMBER 12 2 YES TOTAL AMOUNT: The total amount for a single report
code.
TTRDTLC_DESC VARCHAR2 30 YES REPORT CODE DESCRIPTION: This holds the description
for the report code.
TTRDTLC_EFFECTIVE_DATE DATE 7 YES EFFECTIVE DATE: The date when the information for this
record on the tbraccd table was entered or last
updated.
Date: 21-JUN-2004 Page: 142
TABLE: TTRTAXR
CREATOR: TAISMGR
Rules table for terms and dates.
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
TTRTAXR_TAX_YEAR NUMBER 4 NO TAX YEAR: This is the tax year for which the rules
apply.
TTRTAXR_REPT_CODE VARCHAR2 4 NO REPORT CODE: This is the Tax Report Code from TTVREPT
table.
TTRTAXR_CHANGE_IND VARCHAR2 1 NO CHANGE INDICATOR: Indicates the tsp1098 process if
there were any changes made in this form.
TTRTAXR_CHRG_TYPE_IND VARCHAR2 1 NO TOTAL CHARGES:This field gives a hint to the TSP1098
process to total up all the charges in the tbraccd
table.
TTRTAXR_TOTAL_ACCESS_IND VARCHAR2 1 NO Total Access Indicator: This field enables the web to
popup the total info window.
TTRTAXR_DETAIL_ACCESS_IND VARCHAR2 1 NO Detail Access Indicator: This field enables the web to
popup the detail info window.
TTRTAXR_ACTIVITY_DATE DATE 7 NO ACTIVITY DATE: This is the date the form was last
modified.
TTRTAXR_USER_ID VARCHAR2 30 YES USER IDENTITY: The user id indicates who the last
person to modify this form was.
TTRTAXR_TERM_1 VARCHAR2 6 YES TERM1: This is the user defined term1 validated by the
stvterm table.
TTRTAXR_TERM_2 VARCHAR2 6 YES TERM2: This is the user defined term2 validated by the
stvterm table.
TTRTAXR_TERM_3 VARCHAR2 6 YES TERM3: This is the user defined term3 validated by the
stvterm table.
TTRTAXR_TERM_4 VARCHAR2 6 YES TERM4: This is the user defined term4 validated by the
stvterm table.
TTRTAXR_TERM_5 VARCHAR2 6 YES TERM5: This is the user defined term5 validated by the
stvterm table.
TTRTAXR_TERM_6 VARCHAR2 6 YES TERM6: This is the user defined term6 validated by the
stvterm table.
TTRTAXR_TERM_7 VARCHAR2 6 YES TERM7: This is the user defined term7 validated by the
stvterm table.
TTRTAXR_TERM_8 VARCHAR2 6 YES TERM8: This is the user defined term8 validated by the
stvterm table.
TTRTAXR_TERM_9 VARCHAR2 6 YES TERM9: This is the user defined term9 validated by the
stvterm table.
TTRTAXR_TERM_10 VARCHAR2 6 YES TERM10: This is the user defined term10 validated by
the stvterm table.
TTRTAXR_TERM_11 VARCHAR2 6 YES TERM11: This is the user defined term11 validated by
the stvterm table.
TTRTAXR_TERM_12 VARCHAR2 6 YES TERM12: This is the user defined term12 validated by
the stvterm table.
TTRTAXR_TERM_13 VARCHAR2 6 YES TERM13: This is the user defined term13 validated by
the stvterm table.
TTRTAXR_TERM_14 VARCHAR2 6 YES TERM14: This is the user defined term14 validated by
the stvterm table.
Date: 21-JUN-2004 Page: 143
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
TTRTAXR_TERM_15 VARCHAR2 6 YES TERM15: This is the user defined term15 validated by
the stvterm table.
TTRTAXR_START_DATE DATE 7 YES START DATE:This specifies the start date which the
tsp1098 process should consider while selecting
students for the tax relief eligibility.
TTRTAXR_END_DATE DATE 7 YES END DATE:This specifies the end date which the tsp1098
process should consider while selecting students for
the tax relief eligibility.
TTRTAXR_REPT_COMMENTS VARCHAR2 90 YES COMMENTS: Stores comments on the report code.
TTRTAXR_REPT_BOX VARCHAR2 2 YES REPORTING BOX: Form 1098-T box in which this rule is
reported.
Date: 21-JUN-2004 Page: 144
TABLE: TTRTAXT
CREATOR: TAISMGR
TRA Term Code Rule Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
TTRTAXT_TAX_YEAR NUMBER 4 NO TAX YEAR: This is the tax year for which the rules
apply.
TTRTAXT_REPT_CODE VARCHAR2 4 NO REPORT CODE: This field identifies the report code
that the will apply to.
TTRTAXT_TERM_CODE VARCHAR2 6 NO TERM CODE: This field identifies a term for which the
rules apply.
TTRTAXT_ACTIVITY_DATE DATE 7 NO ACTIVITY DATE: This field specifies the most current
date record was created or updated.
TTRTAXT_USER_ID VARCHAR2 30 NO USER ID: This field identifies the system user signon
id who last created or updated the record.
TTRTAXT_FUTURE_IND VARCHAR2 1 NO FUTURE INDICATOR: Y to indicate term starts in the
first 3 months of the following Tax Year, or N
Date: 21-JUN-2004 Page: 145
TABLE: TTRTXCD
CREATOR: TAISMGR
Rule table for Detail code and Category Code.
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
TTRTXCD_TAX_YEAR NUMBER 4 NO TAX YEAR: Tax year that applies to the detail and
category codes.
TTRTXCD_REPT_CODE VARCHAR2 4 NO REPORT CODE: Report code that is stored in the ttvrept
table. This code is associated with category codes
and detail codes.
TTRTXCD_DCAT_SUM_IND VARCHAR2 1 NO SUM INDICATOR:This enables tocheck if the user wants
to sum up all related detail codes falling under one
category code when they are displayed. This field
will prevent detail and category codes displayed
individually with their respective amounts.
TTRTXCD_DETC_SUM_IND VARCHAR2 1 NO SUM INDICATOR:This enables to check if the user wants
to sum up all related detail codes when they are
displayed. This field will prevent detail codes from
repeating and will display their respective tot
al
amounts.
TTRTXCD_ACTIVITY_DATE DATE 7 NO ACTIVITY DATE:The date on which the form was last
updated.
TTRTXCD_USER_ID VARCHAR2 30 YES USER IDENTITY:The user id of the last person to modify
the form.
TTRTXCD_DCAT_CODE VARCHAR2 3 YES CATEGORY CODE:The category code that applies to the
report code for the tax year. This code is obtained
from the ttvdcat table.
TTRTXCD_DETC_CODE VARCHAR2 4 YES DETAIL CODE:Detail code that applies to the tax report
code for the tax year.This code is obtained from the
ttvdetc table.
Date: 21-JUN-2004 Page: 146
TABLE: TTRTXEX
CREATOR: TAISMGR
Rule table for Excluded Detail codes.
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
TTRTXEX_TAX_YEAR NUMBER 4 NO TAX YEAR: Tax year that applies to the detail codes.
TTRTXEX_REPT_CODE VARCHAR2 4 NO REPORT CODE: Report code that is stored in the ttvrept
table. This code is associated with category codes
and detail codes.
TTRTXEX_ACTIVITY_DATE DATE 7 NO ACTIVITY DATE:The date on which the form was last
updated.
TTRTXEX_USER_ID VARCHAR2 30 YES USER IDENTITY:The user id of the last person to modify
the form.
TTRTXEX_DCAT_CODE VARCHAR2 3 YES CATEGORY CODE:The category code that applies to the
report code for the tax year. This code is obtained
from the ttvdcat table.
TTRTXEX_DETC_CODE VARCHAR2 4 YES DETAIL CODE:Detail code that applies to the tax report
code for the tax year.This code is obtained from the
ttvdetc table.
Date: 21-JUN-2004 Page: 147
TABLE: TTRTXPR
CREATOR: TAISMGR
Tax Report Proration Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
TTRTXPR_TAX_YEAR NUMBER 4 NO TAX YEAR: The tax year for which the rules apply.
TTRTXPR_REPT_CODE VARCHAR2 4 NO REPORT CODE: The report code for which the rules
apply.
TTRTXPR_DETC_CODE VARCHAR2 4 NO DETAIL CODE: The detail code for which the rules
apply.
TTRTXPR_FROM_TERM_CODE VARCHAR2 6 NO FROM TERM CODE: The first term of a range for which
the rules apply.
TTRTXPR_TO_TERM_CODE VARCHAR2 6 NO TO TERM CODE: The last term of a range for which the
rules apply.
TTRTXPR_PERCENT NUMBER 8 5 NO PERCENT: The percent of this detail code to include as
eligible for tax reporting.
TTRTXPR_ACTIVITY_DATE DATE 7 NO ACTIVITY DATE: The most recent date record was created
or updated.
TTRTXPR_USER_ID VARCHAR2 30 NO USER ID: The user who last created or updated the
record.
Date: 21-JUN-2004 Page: 148
TABLE: TTTTAXC
CREATOR: TAISMGR
Global Temporary Table used in calculating reportable amounts for 1098-T
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
TTTTAXC_PIDM NUMBER 8 NO PIDM: Internal Identification Number of the person
TTTTAXC_TAXR_YEAR NUMBER 4 NO RULE YEAR: Tax Year of the ttrtaxr rule associated
with the transaction
TTTTAXC_TAXR_BOX VARCHAR2 2 NO RULE BOX: Reporting Box of the ttrtaxr rule associated
with the transaction - CB Qualified Charges Billed or
SG Schol or Grant
TTTTAXC_TERM_CDE VARCHAR2 6 NO TERM CODE: Term Code of the transaction
TTTTAXC_TRAN_NUMBER NUMBER 8 NO TRANSACTION NUMBER: Transaction Number from tbraccd
TTTTAXC_DETC_CDE VARCHAR2 4 NO DETAIL CODE: Detail Code of the transaction
TTTTAXC_AMOUNT NUMBER 12 2 NO AMOUNT: Amount of the original transaction
TTTTAXC_FUTURE_IND VARCHAR2 1 NO FUTURE INDICATOR: Y if transaction reported as a term
beginning in a future tax year, or N
TTTTAXC_ACCD_ROWID ROWID 10 YES ROWID: The rowid of the source TBRACCD record, used to
update Tax fields
TTTTAXC_REPT_YEAR NUMBER 4 YES REPORT YEAR: Year when this transaction reported on
1098-T
TTTTAXC_REPT_BOX VARCHAR2 2 YES REPORT BOX: 1098-T box in which reported - CB
Qualified Charges Billed, AC Adjustments to Prior
Charges, SG Schol or Grant, AS Adjustments to Schol or
Grant
TTTTAXC_TAX_AMOUNT NUMBER 12 2 YES TAX AMOUNT: Amount reported - sign relates pay type to
report box, may be prorated according to allocation
rules in ttrtxpr
Date: 21-JUN-2004 Page: 149
TABLE: TTVBILL
CREATOR: TAISMGR
Bill Code Validation Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
TTVBILL_CODE VARCHAR2 2 NO This field identifies the bill code referenced by the
Account Review Form. The presence of a bill code on
the Account Review Form describes why no bill will be
generated by the billing process.
TTVBILL_DESC VARCHAR2 30 NO This field specifies the free-format description
associated with the bill code.
TTVBILL_ACTIVITY_DATE DATE 7 NO This field identifies the most recent date a record
was created or updated.
TTVBILL_SYSREQ_IND VARCHAR2 1 YES This field indicates that the corresponding code is
required by BANNER. Removal may cause unpredictble
results.
Date: 21-JUN-2004 Page: 150
TABLE: TTVCCRD
CREATOR: TAISMGR
Voice Response Credit Card Type Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
TTVCCRD_TYPE NUMBER 2 NO The credit card type is a unique numeric identifier
for each valid credit card type for Voice Response
applications.
TTVCCRD_VR_MSG_NO NUMBER 8 NO Voice Message number associated with credit card type
for Voice Response applications.
TTVCCRD_MSG_CONTENTS VARCHAR2 25 NO Text of message incorparated into Message assigned to
TTVCCRD_VR_MSG_NO.
TTVCCRD_EDIT_CHAR NUMBER 1 NO Used to verify that credit card number is of the type
chosen by student. Matched against first character of
CC number.
TTVCCRD_DETAIL_CODE VARCHAR2 4 NO Accounts Receivable detail code associated with credit
card payment.
TTVCCRD_ACTIVITY_DATE DATE 7 NO Most recent date record was revised.
Date: 21-JUN-2004 Page: 151
TABLE: TTVDCAT
CREATOR: TAISMGR
Detail Charge/Payment Category Code Validation Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
TTVDCAT_CODE VARCHAR2 3 NO This field identifies the detail charge/payment
category code referenced by Student Bill Mod. Reqd
vals: APF - Admis Applicatn Chgs, FA - Fin Aid, FEE -
Registr. Fees, HOU - Housing, TUI - Registr.
Tuition, TRN - Transcript Fee.
TTVDCAT_DESC VARCHAR2 30 NO This field specifies the free-format detail category
associated with the detail category code. Used to
group charges/payments together for billing reporting
purposes.
TTVDCAT_ACTIVITY_DATE DATE 7 NO This field identifies the most recent date a record
was created or updated.
TTVDCAT_SYSREQ_IND VARCHAR2 1 YES A "Y" indicates that the corresponding code is
required by BANNER. Removal may cause unpredictable
results.
TTVDCAT_VR_MSG_NO NUMBER 6 YES Voice Response(VR) message number assigned to the
recorded message that describes the category code.
Date: 21-JUN-2004 Page: 152
TABLE: TTVDELI
CREATOR: TAISMGR
Delinquency Code Validation Table.
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
TTVDELI_CODE VARCHAR2 2 NO This field identifies the delinquency code referenced
on the Account Review Form (TSAACCT) and Billing
Message Form (TGAMESG).
TTVDELI_DESC VARCHAR2 30 NO This field specifies the account status (e.g. 30 days
past due, referred to collection agency) associated
with the delinquency code.
TTVDELI_ACTIVITY_DATE DATE 7 NO This field identifies the most recent date a record
was created or updated.
TTVDELI_UPDATE_IND VARCHAR2 1 YES This field indicates whether this code may be updated
by the automated (batch) update of delinquency code.
Valid values: "N" this code may only be updated
online. Null, this code may be updated online and
batch.
Date: 21-JUN-2004 Page: 153
TABLE: TTVDTYP
CREATOR: TAISMGR
Deposit Type Validation Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
TTVDTYP_CODE VARCHAR2 3 NO Deposit Type Code.
TTVDTYP_DESC VARCHAR2 30 YES Description of the Deposit Type Code.
TTVDTYP_SYSREQ_IND VARCHAR2 1 YES A "Y" indicates that the corresponding code is
required by BANNER. Removal may cause unpredictable
results.
TTVDTYP_ACTIVITY_DATE DATE 7 NO This field identifies the most recent date a record
was created or updated.
Date: 21-JUN-2004 Page: 154
TABLE: TTVECAT
CREATOR: TAISMGR
Entity Category Code Validation Table.
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
TTVECAT_CODE VARCHAR2 2 NO Entity category code. Used to categorize accounts.
TTVECAT_DESC VARCHAR2 30 NO Description of the entity category code.
TTVECAT_ACTIVITY_DATE DATE 7 NO This column conatins the date the row was added or
last updated.
Date: 21-JUN-2004 Page: 155
TABLE: TTVPAYT
CREATOR: TAISMGR
Detail Code Payment Type Validation Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
TTVPAYT_CODE VARCHAR2 1 NO This field identifies the detail payment type code
referenced on the Detail Code Control Form
(TFADETC,TSADETC). Reqd value: N - Non-Cash Payment
Type.
TTVPAYT_DESC VARCHAR2 30 NO This field specifies the payment description (e.g.
cash, financial aid, non-cash) associated with the
detail payment type code. Used for billing purposes.
TTVPAYT_ACTIVITY_DATE DATE 7 NO This field identifies the most recent date a record
was created or updated.
TTVPAYT_SYSTEM_REQ_IND VARCHAR2 1 YES A "Y" indicates that the corresponding code is
required by BANNER. Removal may cause unpredictable
results.
Date: 21-JUN-2004 Page: 156
TABLE: TTVREPT
CREATOR: TAISMGR
Tax Report Code Validation Table.
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
TTVREPT_CODE VARCHAR2 4 NO REPORT CODE: Identifies the type of report code.
Qualified Tuition and Fees (QTF) or Grants and
scholarships (GRS).
TTVREPT_DESC VARCHAR2 30 NO DESCRIPTION: Description for the report code entered
in the rept_code column.
TTVREPT_ACTIVITY_DATE DATE 7 NO ACTIVITY DATE: The date when the information for this
record on the table was entered or last updated.
TTVREPT_USER_ID VARCHAR2 30 YES USER IDENTIFICATION: The unique identification code of
the last user to create or modify this record.
Date: 21-JUN-2004 Page: 157
TABLE: TTVRHLD
CREATOR: TAISMGR
Auto Hold/Release Rules Code Validation Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
TTVRHLD_CODE VARCHAR2 6 NO CODE: Unique code identifying a set of Hold/Release
parameter rules
TTVRHLD_DESC VARCHAR2 30 NO DESCRIPTION: Description of the Hold/Release Rules
Code
TTVRHLD_ACTIVITY_DATE DATE 7 NO ACTIVITY DATE: Most recent date record was revised
TTVRHLD_USER_ID VARCHAR2 30 NO USER ID: This field identifies the system user signon
id modifying hold
Date: 21-JUN-2004 Page: 158
TABLE: TTVSBRC
CREATOR: TAISMGR
Schedule/Bill Rules Code Validation Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
TTVSBRC_CODE VARCHAR2 6 NO Unique code identifying a set of Schedule/Bill
parameter rules.
TTVSBRC_DESC VARCHAR2 30 NO Description of the Schedule/Bill Rules Code.
TTVSBRC_ACTIVITY_DATE DATE 7 NO Most recent date record was revised.
Date: 21-JUN-2004 Page: 159
TABLE: TTVSRCE
CREATOR: TAISMGR
Billing Detail Source Validation Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
TTVSRCE_CODE VARCHAR2 1 NO Charge/Payment Source Code. Reqd val: A- Adm Mod, C-
Contract, D- Deposit, E- Exmptn, F-Fin Aid, H-Ac Hist,
I-Inst Proc, L-Bill Late Chg, M-Memo, N-Non-Suf Fund
Chg, P- Appl of Pymnt Proc, R- Reg Mod, S- Misc Trans,
T- Chg/Pymt Trans.
TTVSRCE_DESC VARCHAR2 30 YES This field specifies the charge/payment detail source
associated with the source code. Referenced in
Student Billing Module.
TTVSRCE_INPUT_IND VARCHAR2 1 YES This field indicates whether the associated
charge/payment detail source is entered on the detail
form.
TTVSRCE_ACTIVITY_DATE DATE 7 NO This field identifies the most recent date a record
was created or updated.
TTVSRCE_SYSREQ_IND VARCHAR2 1 YES A "Y" indicates that the corresponding code is
required by BANNER. Removal may cause unpredictable
results.
TTVSRCE_AUTO_CLOSE_IND VARCHAR2 1 NO C permits automatic closing, F permits automatic
finalizing, B permits both close and finalize, null
will not allow automatic close or finalize to occur.
Date: 21-JUN-2004 Page: 160
TABLE: TTVTAXT
CREATOR: TAISMGR
Tax Code Validation Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
TTVTAXT_CODE VARCHAR2 2 NO Tax Type Code.
TTVTAXT_DESC VARCHAR2 30 NO Description of the Tax Type Code.
TTVTAXT_ACTIVITY_DATE DATE 7 NO This field identifies the most recent date a record
was created or updated.
TTVTAXT_TAX_IND VARCHAR2 1 YES Indicates whether the Tax Type Code is eligible for
inclusion in the T2202A tax receipts.
Date: 21-JUN-2004 Page: 161
TABLE: TTVTBDS
CREATOR: TAISMGR
Term-Based Designator Validation Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
TTVTBDS_CODE VARCHAR2 2 NO The term-based designation code.
TTVTBDS_DESC VARCHAR2 30 NO The description of the term-based designation code.
TTVTBDS_ACTIVITY_DATE DATE 7 NO Most recent date record was revised.
Date: 21-JUN-2004 Page: 162
TABLE: TTVTPRC
CREATOR: TAISMGR
Third Party Billing Rules Code Validation Table.
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
TTVTPRC_CODE VARCHAR2 10 NO CODE: Unique code identifying a set of Third Party
Billing parameter rules.
TTVTPRC_DESC VARCHAR2 30 NO DESCRIPTION: Description of the Third Party Billing
parameter rules code.
TTVTPRC_ACTIVITY_DATE DATE 7 NO ACTIVITY DATE: The date when the information for this
record on the table was entered or last updated.
TTVTPRC_USER_ID VARCHAR2 30 NO USER IDENTIFICATION: The unique indentification code
of the last user to create or modify this record.
Date: 21-JUN-2004 Page: 163
TABLE: TURVERS
CREATOR: TAISMGR
Accounts Receivable Version Tracking Table.
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
TURVERS_RELEASE VARCHAR2 10 NO Version/Release number for the A/R system. Format is
V.RR.FF (Version.Release.Fix level).
TURVERS_STAGE_DATE DATE 7 NO The date the release was applied to the system.
Date: 21-JUN-2004 Page: 164
TABLE: TVRAUTH
CREATOR: TAISMGR
Title IV Authorization Maintenance Table.
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
TVRAUTH_PIDM NUMBER 8 NO PIDM: Internal Identification Number of the student
who is providing authorization.
TVRAUTH_TYPE_CODE VARCHAR2 3 NO TYPE CODE: Type of authorization being provided by the
student. Possible values for Title IV are TIV, PY and
HLD.
TVRAUTH_STATUS VARCHAR2 1 NO STATUS: Status of the authorization like authorized or
rescinded.
TVRAUTH_START_DATE DATE 7 NO START DATE: Start date of authorization.
TVRAUTH_END_DATE DATE 7 NO END DATE: End date of authorization.
TVRAUTH_AUTH_SOURCE VARCHAR2 1 NO SOURCE INDICATOR: Source of entry for the specific
type of authorization S for single entry form, M for
mass entry form, R for RRPTIVA process, W for Web.
TVRAUTH_USER_ID VARCHAR2 35 NO USER IDENTIFICATION: The unique identification of the
user.
TVRAUTH_ACTIVITY_DATE DATE 7 NO ACTIVITY DATE: The date that the information for the
record was created or updated.
Date: 21-JUN-2004 Page: 165
TABLE: TVRCREQ
CREATOR: TAISMGR
Title IV Requirement to Authorization Collector Table.
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
TVRCREQ_SESSIONID VARCHAR2 30 NO SESSIONID: User environment sessionid for this run.
TVRCREQ_AUTH_TYPE VARCHAR2 3 NO AUTH TYPE: Type of authorization (TIV, PY or HLD) for
which this row has data.
TVRCREQ_PIDM NUMBER 8 NO PIDM: Internal Identification Number of the student
with Requirement and Status matching parameter.
TVRCREQ_ACTIVITY_DATE DATE 7 NO ACTIVITY DATE: This field specifies the most current
date record was created or updated.
TVRCREQ_TRST_CODE VARCHAR2 2 YES TRST CODE: Value of Status Ind for associated
requirment (rrrareq_trst_code).
TVRCREQ_STAT_DATE DATE 7 YES STAT DATE: Status date of associated requirement
(rrrareq_stat_date).
TVRCREQ_CURRENT_AUTH VARCHAR2 1 YES CURRENT AUTHORIZATION: Current value for this
Authorization Type - (N)one, (A)uthorized,
(R)escinded.
TVRCREQ_MAX_START_DATE DATE 7 YES MAX START DATE: Latest Start Date which exists for
student for this Authorization Type.
TVRCREQ_END_DATE DATE 7 YES
Date: 21-JUN-2004 Page: 166
TABLE: TVVAUTH
CREATOR: TAISMGR
Title IV Authorization Validation Table.
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
TVVAUTH_TYPE_CODE VARCHAR2 3 NO AUTHORIZATION TYPE:This field specifies the type of
authorizations that can be provided by students. Reqd
val: TIV- Pay non-institutional charges with Title IV
funds, PY- Pay Prior Year minor institutional
c
harges, HLD- Hold excess Title IV funds for future
use.
TVVAUTH_DESC VARCHAR2 35 NO DESCRIPTION: Desription of the authorization type.
TVVAUTH_SYSREQ_IND VARCHAR2 1 NO SYSTEM REQUIREMENT INDICATOR: The system requirement
indicator. A "Y" indicates that the corresponding
code is required by BANNER and provided as seed data.
TVVAUTH_USER_ID VARCHAR2 35 NO USER IDENTIFICATION: The unique identification of the
user.
TVVAUTH_ACTIVITY_DATE DATE 7 NO ACTIVITY DATE: The date that the information for the
record was entered or updated.