| 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.
|
DUNNING_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 dunning transaction. |
LAST_UPDATE_DATE
Format DATE
Indexed? No
May be Null? No |
The date the dunning was last updated. |
LAST_UPDATE_DATE_XML_REQ_HIST
Format DATE
Indexed? No
May be Null? No |
The date the delivery history was last updated. |
DUNNING_NUMBER
Format NUMBER (15)
Indexed? No
May be Null? No |
A numeric identifier used internally by the BEN Billing and Receivable system to identify the dunning notice. |
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. |
ACTIVITY
Format VARCHAR2 (80)
Indexed? No
May be Null? No |
The dunning level of this dunning transaction.
Values:
Account
Bill To
Customer
Delinquency |
ACTIVITY_CODE
Format VARCHAR2 (30)
Indexed? No
May be Null? No |
An alphanumberic identifier used to specify the dunning level of this dunning transaction.
Values:
BILL_TO
CUSTOMER
ACCOUNT
DELINQUENCY |
CREATION_DATE
Format DATE
Indexed? No
May be Null? No |
The creation date of the dunning notice associated with this dunning transaction. |
DUNNING_AMOUNT_OVERDUE
Format NUMBER
Indexed? No
May be Null? No |
The amount due remainng on the deliquency associated with the dunning notice associated with this dunning transaction. |
DUNNING_ERROR
Format VARCHAR2 (30)
Indexed? No
May be Null? No |
A message indicating the delivery status of the dunning notice assocaited with this dunning transaction. |
DUNNING_METHOD
Format VARCHAR2 (30)
Indexed? No
May be Null? No |
The method used to send the dunning notice assocaited with this dunning transaction. |
DUNNING_PLAN_ID
Format NUMBER (10)
Indexed? No
May be Null? No |
The numeric identifier used internally by the BEN Billing and Receivable system to uniquely identify the dunning plan associated with this dunning transaction |
DUNNING_PLAN_NAME
Format VARCHAR2 (240)
Indexed? No
May be Null? No |
The name assigned to the dunning plan associated with this dunning transaction. |
DUNNING_TYPE
Format VARCHAR2 (80)
Indexed? No
May be Null? No |
The dunning plan type of this dunning transaction.
Possible values are "Days Overdue" if dunning is based on days that items are past due, or "Staged Dunning" if dunning is based on dunning levels. |
DUNNING_TYPE_CODE
Format VARCHAR2 (30)
Indexed? No
May be Null? No |
An alphanumberic identifier used to specify the dunning plan type of this dunning transaction.
Values:
BILL_TO
CUSTOMER
ACCOUNT
DELINQUENCY |
FINANCE_CHARGE
Format NUMBER
Indexed? No
May be Null? No |
The amount of the finance charge for this dunning notice. |
INTEREST_AMOUNT
Format NUMBER
Indexed? No
May be Null? No |
The interest amount charged for this dunning notice. |
PRELIMINARY_STATUS
Format VARCHAR2 (80)
Indexed? No
May be Null? No |
The preliminary status of the dunning notice associated with this dunning transaction.
Values:
Draft
Final |
PRELIMINARY_STATUS_CODE
Format VARCHAR2 (10)
Indexed? No
May be Null? No |
An alphanumberic identifier used to specify the preliminary status of the dunning notice associated with this dunning transaction.
Values:
DRAFT
FINAL |
PREVIEWED
Format VARCHAR2 (5)
Indexed? No
May be Null? No |
A message indicating whether the dunning notice associated with this dunning ransaction has been previewed.
Values:
Yes
No |
PREVIOUS_DUNNING_NUMBER
Format NUMBER (15)
Indexed? No
May be Null? No |
A numeric identifier used internally by the BEN Billing and Receivable system to identify the original dunning notice if the current notice is a "resend". |
STATUS
Format VARCHAR2 (80)
Indexed? No
May be Null? No |
The status of the dunning notice associated with this dunning transaction.
Values:
Open
Closed |
STATUS_CODE
Format VARCHAR2 (240)
Indexed? No
May be Null? No |
An alphanumberic identifier used to specify the status of the dunning notice associated with this dunning transaction.
Values:
OPEN
CLOSE |
TEMPLATE_NAME
Format VARCHAR2 (120)
Indexed? No
May be Null? No |
The name of the document template used to create the dunning notice associated with this dunning transaction. |
XML_TEMPLATE_ID
Format NUMBER (15)
Indexed? No
May be Null? No |
A numeric identifier used internally by the BEN Billing and Receivable system to identify the XML publisher template used to create the dunning notice asscoiated with this dunning transaction. |
DOCUMENT_TYPE
Format VARCHAR2 (80)
Indexed? No
May be Null? No |
The document type of the dunning notice associated with this dunning transaction.
Values:
Attachment - PDF
Attachment - RTF
Attachment - XLS
Inline |
DOCUMENT_TYPE_CODE
Format VARCHAR2 (80)
Indexed? No
May be Null? No |
An alphanumberic identifier used to specify the document type of the dunning notice associated with this dunning transaction.
Values:
ATTACHMENT
WORD
EXCEL
INLINE |
DELIVERY_STATUS
Format VARCHAR2 (40)
Indexed? No
May be Null? No |
The delivery status of the dunning notice associated with this dunning transaction. |
FAILURE_REASON
Format VARCHAR2 (240)
Indexed? No
May be Null? No |
The delivery failure reason for the dunning notice associated with this dunning transaction. |
INVOICE_COPY_DELIVERY_STATUS
Format VARCHAR2 (75)
Indexed? No
May be Null? No |
The delivery status of the invoice copy associated with this dunning transaction. |
SEND_TO_DESTINATION
Format VARCHAR2 (2000)
Indexed? No
May be Null? No |
The delivery destination of the dunning notice associated with this dunning transaction. |
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. |
