| Data element |
Definition |
BBR_AWARD_NUMBER
Format VARCHAR2 (30)
Indexed? No
May be Null? No |
The alphanumeric identifier used internally by the BEN Billing and Receivable system to uniquely identify the proposal.
An Award Number is associated with only one INSTITUTION_NO. INSTITUTION_NO is the eight-digit sequence number used by the University to uniquely identify the proposal. For a given record, BBR_AWARD_NUMBER will not have the same value as the proposal's INSTITUTION_NO.
|
BBR_AWARD_ORG_CODE
Format CHAR(4)
Indexed? No
May be Null? No |
The 4-character code that identifies the organization responsible for the proposal associated with this transaction.
To facilitate Organization-based security, BBR_AWARD_ORG is set to '.' if it would otherwise be null.
Values:
Refer to the ORG_CODES table for values.
|
DELINQUENCY_ID
Format NUMBER (15)
Indexed? No
May be Null? No |
The numeric identifier used internally by the BEN Billing and Receivable system to uniquely identify the dunning transaction. |
LAST_UPDATE_DATE
Format DATE
Indexed? No
May be Null? No |
The date the dunning was last updated. |
TRX_ID
Format NUMBER (15)
Indexed? No
May be Null? No |
The numeric identifier used internally by the BEN Billing and Receivable system to uniquely identify the transaction |
TRX_NUMBER
Format VARCHAR2 (20)
Indexed? No
May be Null? No |
A numeric identifier used internally by the BEN Billing and Receivable system to identify the transaction. The TRX_NUMBER coupled with the TRX_SOURCE uniqely identify the transaction. Transactions from different sources may have the same TRX_NUMBER. |
TRX_SOURCE
Format VARCHAR2 (50)
Indexed? No
May be Null? No |
The name of the batch source in BEN Billing and Receivables that created the transaction. |
DELINQUENCY_STAUS
Format VARCHAR2 (30)
Indexed? No
May be Null? No |
The delinquency status.
Values:
CURRENT
DELINQUENT |
SCORE
Format NUMBER
Indexed? No
May be Null? No |
The last score value for this delinquency. |
UNPAID_REASON
Format VARCHAR2 (80)
Indexed? No
May be Null? No |
The unpaid reason for the transaction associated with this delinquency.
Values: See the Oracle Electronic Techincal Reference Manual for the list of unpaid reasons. |
UNPAID_REASON_CODE
Format VARCHAR2 (240)
Indexed? No
May be Null? No |
An alphanumberic identifier used to specify the unpaid reason.
Values: See the Oracle Electronic Techincal Reference Manual for the list of unpaid reasons. |
EXTRACT_DATE
Format DATE
Indexed? No
May be Null? No |
The date the transaction header record was extracted from BEN Billing and Receivables and loaded into the Data Warehouse.
This information is stored in the Warehouse in date format. In Business Objects, it is displayed as specified in the desktop operating system settings. It is recommended that users specify a date format that includes 4 digits for the year. |
