RETURN TO COMPOSITE VIEW REPORTS LIST
Accounts Receivable Composite View Reports

SGHE Operational Data Store
Composite View Target: AT_INSTALLMENT_PLAN

Description Source composite view contains installment plan information. (short term loans, tuition payment plans, etc.)

Target Column Business Definition Database Data Type Source Name Source Column
ACADEMIC_PERIOD Academic period associated with the installment plan. VARCHAR2(6)

TBRISTL

TBRISTL_TERM_CODE

ACADEMIC_PERIOD_DESC Academic period description. VARCHAR2(30)

STVTERM

STVTERM_DESC

ACADEMIC_YEAR Academic year associated with the academic period on this record. VARCHAR2(4)

STVTERM

STVTERM_ACYR_CODE

ACADEMIC_YEAR_DESC Academic year description. VARCHAR2(30)

FUNCTION

GOKODSF.F_GET_DESC

ACCOUNT_UID System generated, unique, internal identification number assigned to this person or organization entity. NUMBER(8)

TBRISTL

TBRISTL_PIDM

AUTO_PLAN_ACTIVE_IND Indicates whether the plan is to remain active for additional transaction. VARCHAR2(1)

TBRISTL

TBRISTL_AUTO_CALC_ACTIVE_IND

AUTO_PLAN_IND Indicates whether the plan amount was automatically calculated. VARCHAR2(1)

TBRISTL

TBRISTL_AUTO_CALC_PLAN_IND

CURRENT_DATE System current date (sysdate) or date the data was extracted. DATE

NA

SYSDATE

DOMAIN_VALUE Organization-oriented identifier for the record used to determine access authorization. Institution defined. VARCHAR2(6)

NA

NA

FIRST_INSTALLMENT_DATE Date the first installment is due. DATE

TBRISTL

TBRISTL_FIRST_INSTALL_DATE

INSTALLMENT_PLAN Installment plan code. VARCHAR2(2)

TBRISTL

TBRISTL_INSTALLMENT_PLAN

INSTALLMENT_PLAN_DESC Installment plan description. VARCHAR2(30)

TBRISTL

TBRISTL_DESC

INTEREST_RATE Interest rate percentage associated with the installment plan. NUMBER(5, 3)

TBRISTL

TBRISTL_INT_RATE

LATE_FEE_AMOUNT Late fee amount. NUMBER

NA

NA

LATE_FEE_EXEMPTION_IND Late fee exemption. VARCHAR2(0)

NA

NA

MIF_DESC Institution description when the optional multi-institution facility feature has been applied. VARCHAR2(30)

NA

NA

MIF_VALUE Institution value for the record when the optional multi-institution facility feature has been applied. VARCHAR2(6)

NA

NA

NUMBER_OF_PAYMENTS Number of payments for paying back the installment plan. NUMBER(2)

TBRISTL

TBRISTL_NUMBER_OF_PAYMENTS

PAY_PERIOD Number of days within the payment periods. NUMBER(3)

TBRISTL

TBRISTL_PAY_PERIOD

PLAN_AMOUNT Calculates total amount due paid off and changed to installment payments. NUMBER

FUNCTION

TOKODSF.F_PLAN_AMOUNT

REFERENCE_NUMBER Internal reference number assigned to each installment plan a person or non-person account has. NUMBER(8)

TBRISTL

TBRISTL_REF_NUMBER

SERVICE_FEE Service charge that is posted to the account at the time of the installment plan. NUMBER(7, 2)

TBRISTL

TBRISTL_SERV_CHARGE

SERVICE_PERCENTAGE Percent of the plan amount to be charged in service fee. NUMBER(5, 3)

TBRISTL

TBRISTL_SVC_CHG_PCT

SUB_ACADEMIC_PERIOD A session, portion or part of the academic period. VARCHAR2(0)

NA

NA

SUB_ACADEMIC_PERIOD_DESC A session, portion or part of the academic period. VARCHAR2(0)

NA

NA

ZONE_VALUE Process-oriented identifier for the record used to determine access authorization to this record. Institution defined. VARCHAR2(6)

NA

NA



Ver: 3.1