Target Column |
Business Definition |
Database Data Type |
Source Name |
Source Column |
Local Source |
Local Target |
ACADEMIC_PERIOD
|
Represents an academic period or a portion of the academic year. Academic periods may divide the year into terms, quarters or some other portion of time. This is usually set up to track the academic data like enrollment to a more finite level than the academic year.
|
VARCHAR2(6)
|
RPRLADB
|
RPRLADB_TERM_CODE
|
NO
|
NO
|
ACADEMIC_PERIOD_DESC
|
Academic period description.
|
VARCHAR2(30)
|
STVTERM
|
STVTERM_DESC
|
NO
|
NO
|
ACTIVITY_DATE
|
Date record was inserted or updated.
|
DATE
|
RPRLADB
|
RPRLADB_ACTIVITY_DATE
|
NO
|
NO
|
AID_ENROLLMENT_PERIOD
|
|
VARCHAR2(15)
|
|
|
|
NO
|
AID_YEAR
|
Represents a financial aid year. Aid years may follow the academic year or the fiscal year or another variation.
|
VARCHAR2(6)
|
RPRLADB
|
RPRLADB_AIDY_CODE
|
NO
|
NO
|
AID_YEAR_DESC
|
Description of the aid year.
|
VARCHAR2(30)
|
FUNCTION
|
GOKODSF.F_GET_DESC
|
NO
|
NO
|
APPLICATION_NUMBER
|
System assigned number is assigned when the application is added.
|
NUMBER
|
RPRLADB
|
RPRLADB_APPL_NO
|
NO
|
NO
|
APPROVED_AMOUNT
|
The approved loan amount for this particular academic period.
|
NUMBER
|
RPRLATR
|
RPRLATR_APPROVE_AMT
|
NO
|
NO
|
BORROWER_DIRECT_CHECK_AMOUNT
|
Direct disbursement amount received by borrower enrolled in a study-abroad program.
|
NUMBER
|
RPRLADB
|
RPRLADB_EL_DIRECT_CHECK_AMT
|
NO
|
NO
|
BORROWER_DIRECT_DISBURSE_IND
|
Requests the direct disbursement of funds to borrower or to indicate receipt of funds for borrowers enrolled in a study-abroad program.
|
VARCHAR2(1)
|
RPRLADB
|
RPRLADB_EL_BOR_DIRECT_DISB_IND
|
NO
|
NO
|
CALC_EXPECTED_DISBURSEMENT_AMT
|
For Electronic and Manual Loans, the calculated net amount of the disbursement using the Round Schedule indicator from the Fund Management form and is based on the approved amount if it exists, else the certified (expected) amount if it exists, else the requested amount. The last disbursement of the loan is adjusted so the sum of all the disbursements equals the total amount for the loan. For Direct Loans, the net amount of the disbursement based on the gross disbursement amount, the fee and rebate percent for the loan.
|
NUMBER
|
FUNCTION
|
ROKODSF.F_GET_CALC_DISBURSE_AMT
|
NO
|
NO
|
CANCEL_DATE
|
Displays the date the cancel indicator field was checked to cancel a pending disbursement.
|
DATE
|
RPRLADB
|
RPRLADB_CANCEL_DATE
|
NO
|
NO
|
CANCEL_IND
|
Check to cancel a pending disbursement or uncheck to reinstate the disbursement amount.
|
VARCHAR2(1)
|
RPRLADB
|
RPRLADB_CANCEL_IND
|
NO
|
NO
|
CERTIFIED_CREDIT_HOURS
|
Displays the loan application credit hours for loan eligibility.
|
NUMBER
|
RPRLATR
|
RPRLATR_CERT_HR
|
NO
|
NO
|
CHECK_DATE_RECEIVED
|
Indicates the date the check amount was received.
|
DATE
|
RPRLADB
|
RPRLADB_CHECK_DATE
|
NO
|
NO
|
CHECK_RETURNED_LENDER_DATE
|
The date that the original unsigned/unprocessed loan check was returned to the lender by the school.
|
DATE
|
RPRLADB
|
RPRLADB_RET_LNDR_DATE
|
NO
|
NO
|
CHECK_RETURN_AMOUNT
|
Amount of the loan that was returned during an adjustment.
|
NUMBER
|
RPRLADB
|
RPRLADB_CHECK_RETURN_AMT
|
NO
|
NO
|
CHECK_RETURN_DATE
|
The date that the adjusted loan amount was returned.
|
DATE
|
RPRLADB
|
RPRLADB_CHECK_RETURN_DATE
|
NO
|
NO
|
COLLEGE
|
First level of the institution organization structure that owns the student or the academic instruction for a student course.
|
VARCHAR2(6)
|
RPRLADB
|
RPRLADB_SCHOOL_CODE
|
NO
|
NO
|
CONFIRMATION_IND
|
Indicates that the student has authorized the disbursement of Direct Loan funds under the Master Promissory Note or the borrower has confirmed the loan disbursement for CommonLine processing.
|
VARCHAR2(1)
|
RPRLADB
|
RPRLADB_AFFIRM_FLAG
|
NO
|
NO
|
CURRENT_DATE
|
System current date (sysdate) or date the data was extracted.
|
DATE
|
NA
|
SYSDATE
|
NO
|
NO
|
DIRECT_DISBURSEMENT_NUMBER
|
Direct loan disbursement number.
|
NUMBER
|
RPRLADB
|
RPRLADB_DL_DISB_NO
|
NO
|
NO
|
DIRECT_LOAN_BATCH_NUMBER
|
Batch number related to the disbursement acknowledgement file for this individual disbursement.
|
VARCHAR2(23)
|
RPRLADB
|
RPRLADB_BATCH_NO
|
NO
|
NO
|
DIRECT_LOAN_COD_ADJUSTED_NET
|
The net disbursement adjustment amount recorded in the Account Statement with COD. The value in this field may be either positive or negative reflecting the net amount of the adjustment processed for this individual disbursement.
|
NUMBER
|
RPRLADB
|
RPRLADB_SERV_NET_ADJ_AMT
|
NO
|
NO
|
DIRECT_LOAN_COD_BOOK_DATE
|
Date the individual disbursement is booked at COD.
|
DATE
|
RPRLADB
|
RPRLADB_SERV_BOOKED_DATE
|
NO
|
NO
|
DIRECT_LOAN_COD_GROSS_AMOUNT
|
The gross amount recorded in the Account Statement with COD.
|
NUMBER
|
RPRLADB
|
RPRLADB_SERV_GROSS_AMT
|
NO
|
NO
|
DIRECT_LOAN_COD_NET_AMOUNT
|
The net disbursement amount recorded in the Account Statement with COD.
|
NUMBER
|
RPRLADB
|
RPRLADB_SERV_NET_AMT
|
NO
|
NO
|
DIRECT_LOAN_COD_REBATE_AMOUNT
|
The rebate Amount recorded in the Account Statement with COD.
|
NUMBER
|
RPRLADB
|
RPRLADB_SERV_REBATE_AMT
|
NO
|
NO
|
DIRECT_LOAN_COD_RECEIPT_DATE
|
The actual date COD acknowledged receipt of this disbursement record.
|
DATE
|
RPRLADB
|
RPRLADB_DL_ACKN_DATE
|
NO
|
NO
|
DIRECT_LOAN_DOCUMENT_ID
|
Associated with the student's Direct Loan award record and indicates the document in which the origination record was initially extracted and sent to COD.
|
VARCHAR2(30)
|
RPRLADB
|
RPRLADB_DOCUMENT_ID
|
NO
|
NO
|
DIRECT_LOAN_FEE_AMOUNT
|
Amount of Direct Loan fees.
|
NUMBER
|
RPRLADB
|
RPRLADB_DL_FEE_AMT
|
NO
|
NO
|
DIRECT_LOAN_GROSS_AMOUNT
|
Gross Amount of Direct Loan disbursement .
|
NUMBER
|
RPRLADB
|
RPRLADB_DL_GROSS_AMT
|
NO
|
NO
|
DIRECT_LOAN_MONTH_END_DATE
|
The month end date of the Direct Loan School Account Statement for the month in which this loan disbursement booked.
|
DATE
|
RPRLADB
|
RPRLADB_SAS_END_DATE
|
NO
|
NO
|
DIRECT_LOAN_MONTH_PROCESS_DATE
|
The month process date of the Direct Loan School Account Statement for the month in which this loan disbursement booked.
|
DATE
|
RPRLADB
|
RPRLADB_SAS_PROCESS_DATE
|
NO
|
NO
|
DIRECT_LOAN_REBATE_AMOUNT
|
The Direct Loan interest rebate amount calculated for this disbursement.
|
NUMBER
|
RPRLADB
|
RPRLADB_DL_REBATE_AMT
|
NO
|
NO
|
DIRECT_LOAN_RECORD_COUNT_NO
|
The record number assigned in the School Account Statement with COD for this loan detail record.
|
NUMBER
|
RPRLADB
|
RPRLADB_SAS_RECORD_COUNT_SEQ
|
NO
|
NO
|
DIRECT_LOAN_REJECT_CODE1
|
The first reject code sent from LOC / COD for this loan disbursement.
|
VARCHAR2(3)
|
RPRLADB
|
RPRLADB_DL_REJECT_CODE_1
|
NO
|
NO
|
DIRECT_LOAN_REJECT_CODE1_DESC
|
Description for the first reject code sent from LOC / COD.
|
VARCHAR2(65)
|
RTVRJCT
|
RTVRJCT_DESC
|
NO
|
NO
|
DIRECT_LOAN_REJECT_CODE2
|
The second reject code sent from LOC / COD for this loan disbursement.
|
VARCHAR2(3)
|
RPRLADB
|
RPRLADB_DL_REJECT_CODE_2
|
NO
|
NO
|
DIRECT_LOAN_REJECT_CODE2_DESC
|
Description for the second reject code sent from LOC / COD.
|
VARCHAR2(65)
|
RTVRJCT
|
RTVRJCT_DESC
|
NO
|
NO
|
DIRECT_LOAN_REJECT_CODE3
|
The third reject code sent from LOC / COD for this loan disbursement.
|
VARCHAR2(3)
|
RPRLADB
|
RPRLADB_DL_REJECT_CODE_3
|
NO
|
NO
|
DIRECT_LOAN_REJECT_CODE3_DESC
|
Description for the third reject code sent from LOC / COD.
|
VARCHAR2(65)
|
RTVRJCT
|
RTVRJCT_DESC
|
NO
|
NO
|
DIRECT_LOAN_REJECT_CODE4
|
The fourth reject code sent from LOC / COD for this loan disbursement.
|
VARCHAR2(3)
|
RPRLADB
|
RPRLADB_DL_REJECT_CODE_4
|
NO
|
NO
|
DIRECT_LOAN_REJECT_CODE4_DESC
|
Description for the fourth reject code sent from LOC / COD.
|
VARCHAR2(65)
|
RTVRJCT
|
RTVRJCT_DESC
|
NO
|
NO
|
DIRECT_LOAN_REJECT_CODE5
|
The fifth reject code sent from LOC / COD for this loan disbursement.
|
VARCHAR2(3)
|
RPRLADB
|
RPRLADB_DL_REJECT_CODE_5
|
NO
|
NO
|
DIRECT_LOAN_REJECT_CODE5_DESC
|
Description for the fifth reject code sent from LOC / COD.
|
VARCHAR2(65)
|
RTVRJCT
|
RTVRJCT_DESC
|
NO
|
NO
|
DIRECT_LOAN_SEQUENCE_NUMBER
|
Starts at one for each scheduled loan disbursement, and is incremented by one each time an adjustment is made to the disbursement.
|
NUMBER
|
RPRLADB
|
RPRLADB_DL_SEQ_NO
|
NO
|
NO
|
DIRECT_LOAN_SERVICE_FEE_AMOUNT
|
The fees amount recorded in the Account Statement with COD.
|
NUMBER
|
RPRLADB
|
RPRLADB_SERV_FEE_AMT
|
NO
|
NO
|
DISBURSEMENT_BYPASS_IND
|
Indicates lender transactions are to be bypassed for a payment during disbursement.
|
VARCHAR2(1)
|
RPRLADB
|
RPRLADB_DISB_BYPASS
|
NO
|
NO
|
DISBURSEMENT_COMMENT
|
Contains any special processing comments or instructions entered by the user.
|
VARCHAR2(60)
|
RPRLADB
|
RPRLADB_COMMENT
|
NO
|
NO
|
DISBURSEMENT_FEED
|
Displays whether disbursement should be fed to accounts receivable.
|
VARCHAR2(1)
|
RPRLADB
|
RPRLADB_FEED_IND
|
NO
|
NO
|
DISBURSEMENT_FEED_DATE
|
Indicates the date the disbursement was fed to the student's account's receivable account.
|
DATE
|
RPRLADB
|
RPRLADB_FEED_DATE
|
NO
|
NO
|
DISBURSEMENT_FEED_DESC
|
Indicates whether disbursement should be fed to accounts receivable.
|
VARCHAR2(10)
|
CALCULATION
|
DECODE(RPRLADB_FEED_IND)
|
NO
|
NO
|
DISBURSEMENT_PROCESSING_STATUS
|
The processing status of the disbursement.
|
VARCHAR2(1)
|
RPRLADB
|
RPRLADB_DISB_STATUS
|
NO
|
NO
|
DISBURSEMENT_PROC_STATUS_DESC
|
Disbursement processing status description.
|
VARCHAR2(25)
|
|
|
|
NO
|
DISBURSEMENT_SEQUENCE_NUMBER
|
Starts at one for each scheduled loan disbursement, and is incremented by one each time an adjustment is made to the disbursement.
|
NUMBER
|
RPRLADB
|
RPRLADB_SEQ_NO
|
NO
|
NO
|
DOMAIN_VALUE
|
Domain column for future use, not currently populated.
|
VARCHAR2(6)
|
NA
|
NA
|
NO
|
NO
|
ELECTRONIC_DISBURSEMENT_NUMBER
|
Disbursement number associated with this electronic loan disbursement record.
|
NUMBER
|
RPRLADB
|
RPRLADB_EL_DISB_NO
|
NO
|
NO
|
ELECTRONIC_REFERENCE_ID
|
The check number or electronic batch number of the financial aid payment.
|
VARCHAR2(15)
|
RPRLADB
|
RPRLADB_REF_ID
|
NO
|
NO
|
ELECTRONIC_SERVICE_NET_AMOUNT
|
The net disbursement amount that has been scheduled by the lender-servicer at the time of guarantee for this disbursement. This amount is uploaded from the CommonLine Response File.
|
NUMBER
|
RPRLADB
|
RPRLADB_EL_SERV_NET_AMT
|
NO
|
NO
|
ELECTRONIC_TRANSFER_IND
|
Indicates when an electronic disbursement is received, rather than a paper check.
|
VARCHAR2(1)
|
RPRLADB
|
RPRLADB_EFT_IND
|
NO
|
NO
|
ENROLLMENT_LOAD
|
Displays the student's enrollment load calculated at the time of disbursement.
|
VARCHAR2(1)
|
RPRLADB
|
RPRLADB_DISBURSE_LOAD
|
NO
|
NO
|
ENROLLMENT_LOAD_DESC
|
Enrollment Load Description.
|
VARCHAR2(20)
|
CALCULATION
|
DECODE(RPRLADB_DISBURSE_LOAD)
|
NO
|
NO
|
ENROLLMENT_LOAD_OPTION
|
Financial Aid calculates a student's enrollment option used for the disbursement load.
|
VARCHAR2(1)
|
RPRLADB
|
RPRLADB_DISBURSE_LOAD_OPT
|
NO
|
NO
|
ENROLLMENT_LOAD_OPTION_DESC
|
Displays the enrollment load option used for the disbursement.
|
VARCHAR2(15)
|
|
|
|
NO
|
ENROLLMENT_STATUS
|
Student's enrollment status.
|
VARCHAR2(1)
|
RPRLADB
|
RPRLADB_ENROLLMENT_STATUS
|
NO
|
NO
|
ENROLLMENT_STATUS_DESC
|
Enrollment status description.
|
VARCHAR2(120)
|
FUNCTION
|
ROKODSF.F_GET_RORMVAL_DESC
|
NO
|
NO
|
EXCLUDE_EXCEPTION_REPORT_IND
|
Indicates that the exception report should not display a line for this loan and term, even if there was a discrepancy in the amounts.
|
VARCHAR2(1)
|
CALCULATION
|
NVL(RPRLATR_EXCLUDE_LNEX_FLAG,'N')
|
NO
|
NO
|
EXPECTED_LOAN_AMOUNT
|
Expected loan amount associated with the application scheduled by academic periods.
|
NUMBER
|
RPRLATR
|
RPRLATR_EXPECT_AMT
|
NO
|
NO
|
FUND
|
Financial Aid Fund code to be associated with information in this record.
|
VARCHAR2(6)
|
RPRLADB
|
RPRLADB_FUND_CODE
|
NO
|
NO
|
FUND_TITLE
|
Full title of the financial aid fund code.
|
VARCHAR2(30)
|
FUNCTION
|
GOKODSF.F_GET_DESC
|
NO
|
NO
|
GUARANTEE_FEE_AMOUNT
|
Amount of the guarantee fee charged for this disbursement.
|
NUMBER
|
RPRLADB
|
RPRLADB_EL_SERV_GUAR_FEE
|
NO
|
NO
|
HOLD_RELEASE_DATE
|
The most recent date the Hold / Release status was sent or acknowledged.
|
DATE
|
RPRLADB
|
RPRLADB_EL_HOLD_REL_DATE
|
NO
|
NO
|
HOLD_RELEASE_STATUS
|
A code indicating the status of the school's requested disbursement hold or release.
|
VARCHAR2(2)
|
RPRLADB
|
RPRLADB_HOLD_REL_STATUS
|
NO
|
NO
|
HOLD_RELEASE_STATUS_DESC
|
Hold / Release status description.
|
VARCHAR2(20)
|
CALCULATION
|
DECODE(RPRLADB_HOLD_REL_STATUS)
|
NO
|
NO
|
LOAN_PERCENTAGE_ACAD_PERIOD
|
Represents the percentage of the loan that is scheduled for the associated academic period.
|
NUMBER
|
RPRLATR
|
RPRLATR_LOAN_PCT
|
NO
|
NO
|
LOAN_PERCENTAGE_DISBURSEMENT
|
The percentage of total loan that this disbursement represents.
|
NUMBER
|
RPRLADB
|
RPRLADB_LOAN_PCT
|
NO
|
NO
|
MEMO_EXPIRATION_DAYS
|
The number of days until the memo expires.
|
NUMBER
|
RPRLADB
|
RPRLADB_MEMO_EXP_DAYS
|
NO
|
NO
|
MIF_DESC
|
The institution description for the record when the optional multi-institution facility feature has been installed and applied for this table/column.
|
VARCHAR2(30)
|
NA
|
NA
|
NO
|
NO
|
MIF_VALUE
|
The institution value for the record when the optional multi-institution facility feature has been installed and applied for this table/column.
|
VARCHAR2(6)
|
NA
|
NA
|
NO
|
NO
|
MPN_DISBURSEMENT_DATE
|
Disbursement Date printed on the Promissory Note. No longer required for MPN processing.
|
DATE
|
RPRLADB
|
RPRLADB_PN_DISB_DATE
|
NO
|
NO
|
NET_CHECK_AMOUNT
|
The net amount of this particular disbursement.
|
NUMBER
|
RPRLADB
|
RPRLADB_CHECK_AMT
|
NO
|
NO
|
ORIGINATION_FEE_AMOUNT
|
Amount of the origination fee charged for this disbursement.
|
NUMBER
|
RPRLADB
|
RPRLADB_EL_SERV_ORIG_FEE
|
NO
|
NO
|
OVERRIDE_IND
|
Allows the override of the disbursement edit for loans that prevents disbursement when sum of the loan term disbursements is greater than the sum of the loan term expected amount.
|
VARCHAR2(1)
|
RPRLADB
|
RPRLADB_DISB_OVERRIDE_IND
|
NO
|
NO
|
PAYMENT_PERIOD_START_DATE
|
Disbursement payment period start date.
|
DATE
|
RPRLADB
|
RPRLADB_PAY_PD_START_DATE
|
NO
|
NO
|
PERSON_UID
|
System generated, unique, internal identification number assigned to this person.
|
NUMBER
|
RPRLADB
|
RPRLADB_PIDM
|
NO
|
NO
|
PREVIOUS_DISBURSEMENT_NUMBER
|
The previous disbursement sequence number on the COD database for the disbursement number.
|
NUMBER
|
RPRLADB
|
RPRLADB_PREV_DISB_SEQ_NO
|
NO
|
NO
|
PRIOR_DISBURSEMENT_DATE
|
Prior Disbursement Date when the scheduled disbursement date is manually changed. After the change information is sent to the Lender or Lender's Agent, this date is set to null.
|
DATE
|
RPRLADB
|
RPRLADB_PRIOR_DISB_DATE
|
NO
|
NO
|
PROGRAM_CLASSIFICATION
|
Classification of Instructional Program (CIP) codes assigned to an area of study and used for governmental reporting.
|
VARCHAR2(20)
|
RPRLADB
|
RPRLADB_CIP_CODE
|
NO
|
NO
|
PROGRAM_CLASSIFICATION_DESC
|
Program classification description.
|
VARCHAR2(260)
|
FUNCTION
|
ROKODSF.F_GET_CIPC_DESC
|
NO
|
NO
|
PROGRAM_SEQUENCE_LOCK_IND
|
Indicates if the student program information sequence is locked for the loan disbursement record.
|
VARCHAR2(1)
|
RLRDLDD
|
RLRDLDD_SPGM_LOCK_IND
|
NO
|
NO
|
PROGRAM_SEQUENCE_NUMBER
|
Sequence of the program information record used on this disbursement.
|
NUMBER
|
RLRDLDD
|
RLRDLDD_SPGM_SEQ_NO
|
NO
|
NO
|
RECOMMENDED_AMOUNT
|
Recommended amount of the loan associated with the loan application scheduled by academic period.
|
NUMBER
|
RPRLATR
|
RPRLATR_RECOMMEND_AMT
|
NO
|
NO
|
RECONCILIATION_BATCH_NUMBER
|
Cash reconciliation batch number in which this direct loan disbursement was included.
|
VARCHAR2(23)
|
RPRLADB
|
RPRLADB_RECON_BATCH_NO
|
NO
|
NO
|
REQUESTED_AMOUNT
|
Amount of requested loan for this particular academic period.
|
NUMBER
|
RPRLATR
|
RPRLATR_REQUEST_AMT
|
NO
|
NO
|
REVISED_GROSS_AMOUNT
|
The revised gross disbursement amount for this EL disbursement record.
|
NUMBER
|
RPRLADB
|
RPRLADB_EL_REV_GROSS_AMT
|
NO
|
NO
|
REVISED_NET_AMOUNT
|
The revised disbursement amount excluding all fees retained by the lender (i.e. net amount).
|
NUMBER
|
RPRLADB
|
RPRLADB_REV_DISB_AMT
|
NO
|
NO
|
SCHEDULED_DATE
|
Used by the disbursement process as the first date on which this disbursement may occur.
|
DATE
|
RPRLADB
|
RPRLADB_DISBURSE_DATE
|
NO
|
NO
|
SERVICER_DISBURSEMENT_DATE
|
The disbursement date scheduled by the guarantor/servicer for this disbursement.
|
DATE
|
RPRLADB
|
RPRLADB_EL_SERV_DISB_DATE
|
NO
|
NO
|
SERVICER_DISBURSEMENT_GROSS
|
The amount guaranteed by the guarantor/servicer for this disbursement including all applicable fees and minus any cancellations.
|
NUMBER
|
RPRLADB
|
RPRLADB_EL_SERV_GROSS_AMT
|
NO
|
NO
|
STUDENT_ACADEMIC_PERIOD
|
|
VARCHAR2(6)
|
|
|
|
NO
|
STUDENT_ACADEMIC_PERIOD_DESC
|
|
VARCHAR2(30)
|
|
|
|
NO
|
STUDENT_RECEIVE_DATE
|
The date the loan proceeds were delivered to the student.
|
DATE
|
RPRLADB
|
RPRLADB_STU_RECEIVE_DATE
|
NO
|
NO
|
SUBSIDIZED_FEES_PAID
|
Total amount of fees subsidized by the guarantor or lender on behalf of the borrower for the disbursement.
|
NUMBER
|
RPRLADB
|
RPRLADB_FEES_PAID
|
NO
|
NO
|
TRANSACTION_NUMBER
|
Displays the number on the student's account's receivable account where the disbursement was applied.
|
NUMBER
|
RPRLADB
|
RPRLADB_TRAN_NUMBER
|
NO
|
NO
|
TRANSACTION_TYPE
|
This is the type of transaction record found for the disbursement.
|
VARCHAR2(1)
|
RPRLADB
|
RPRLADB_SERV_TRANS_TYPE
|
NO
|
NO
|
TRANSACTION_TYPE_DESC
|
Transaction record description.
|
VARCHAR2(25)
|
CALCULATION
|
DECODE(RPRLADB_SERV_TRANS_TYPE)
|
NO
|
NO
|
USER_ID
|
Unique identification code of the user who entered or last touched the transaction.
|
VARCHAR2(30)
|
RPRLADB
|
RPRLADB_USER_ID
|
NO
|
NO
|
ZONE_VALUE
|
Zone column for future use, not currently populated.
|
VARCHAR2(6)
|
NA
|
NA
|
NO
|
NO
|