Go To View:  RETURN TO BANNER ODS META DATA REPORTS LIST
Travel And Expense Reporting View Reports

SGHE Banner Operational Data Store
Reporting View Target: REIMBURSEMENT_APPROVAL_HISTORY

Description Contains approval history information for the reimbursement for each change in notification. This includes the person who is approving the document, what action was taken and when, and when email notification was sent.
Key & Frequency One row per reimbursement per circulation step per circulation approver per circulation notification.
Recommended Search Columns CIRCULATION_KEY
CIRCULATION_NOTIFICATION_KEY
CIRCULATION_STEP_KEY, NOTIFICATION_STATUS_DATE
CIRCULATION_KEY, CIRCULATION_STEP_KEY
REIMBURSEMENT
REIMBURSEMENT_KEY

Target Column Business Definition Database Data Type Source Name Source Column
ADDITIONAL_APPROVER_IND Determines if the approver was added as an additional approver to the workflow approval circulation. VARCHAR2(1)

CALCULATION

DECODE(FORCIRR_DATA_ORIGIN)

ADMINISTRATIVE_GROUP Administrative-oriented identifier for the record used to determine access authorization to this record. Institution defined. VARCHAR2(255)

NA

NA

APPROVER_DATA_ORIGIN Source system that created or updated the approver data. VARCHAR2(63)

FORCIRR

FORCIRR_DATA_ORIGIN

APPROVER_ID User-defined or system generated one-up number of the workflow approver. VARCHAR2(63)

FUNCTION

MGKFUNC.F_GET_PERSON_INFO

APPROVER_NAME Combination of the workflow approver's last, first, and middle initial into one value. VARCHAR2(255)

FUNCTION

MGKFUNC.F_GET_PERSON_INFO

APPROVER_TYPE Indicates if the step record represents a (P)erson or a (G)roup of recipients or (C)ompany. VARCHAR2(63)

FORCIRS

FORCIRS_TYPE

APPROVER_UID Personal identification number of the approver. NUMBER

FORCIRR

FORCIRR_RECIPIENT_PIDM

APPROVER_WORKFLOW_ID Unique identifier for the workflow ID of the person added to the approval workflow of the reimbursement. VARCHAR2(255)

FORCIRR

FORCIRR_WORKFLOW_ID

CIRCULATION_ACTIVITY_DATE Date information for this record in the table was entered or last updated. DATE

FOBCIRH

FOBCIRH_ACTIVITY_DATE

CIRCULATION_BEGIN_DATE Date and time that the circulation was started. DATE

FOBCIRH

FOBCIRH_START_DATE

CIRCULATION_COMPLETE_DATE Date and time that the circulation was completed. DATE

FOBCIRH

FOBCIRH_COMPLETION_DATE

CIRCULATION_KEY Unique internal identification number of the approval circulation record. NUMBER

FTRRRCIR

FOBCIRH_ID

CIRCULATION_NOTIFICATION_KEY Unique internal identification number of the approval circulation notification record. NUMBER

FORCIRN

ID

CIRCULATION_ORDER Order of this step in the overall circulation. NUMBER

FORCIRS

FORCIRS_ORDER

CIRCULATION_RECIPIENT_KEY Unique internal identification number of the approval circulation recipient record. NUMBER

FORCIRR

ID

CIRCULATION_STATUS Current status of the circulation. Statuses are IN PROCESS, COMPLETED, and AVAILABLE. VARCHAR2(63)

FOBCIRH

FOBCIRH_STATUS

CIRCULATION_STEP_KEY Unique internal identification number of the approval circulation step record. NUMBER

FORCIRS

ID

CIRCULATION_USER_ID Unique identification code of the user who entered or last touched the transaction. VARCHAR2(63)

FOBCIRH

FOBCIRH_USER_ID

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

NA

NA

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

NA

NA

NOTIFICATION_CHANGE_HOURS Amount of time in hours between the prior notification status date and this notification status date for the approval cycle. NUMBER

FUNCTION

MEKFUNC.F_NOTIFICATION_CHANGE_HOURS

NOTIFICATION_CHANGE_HOURS_TOT Amount of time in hours between the first established notification status date and this notification status date for the approval cycle. NUMBER

FUNCTION

MEKFUNC.F_NOTIFICATION_CHANGE_HOURS

NOTIFICATION_COMMENT Free-form approver comment. VARCHAR2(4000)

FORCIRN

FORCIRN_COMMENT

NOTIFICATION_STATUS Indicates what the notification represents. For example, NOTIFY = an email message was sent to the approver to approve this document. RETURN = the document was returned for correction. DENIED = the document request was denied and no further action is to be taken. APPROVED = the document was approved. VARCHAR2(63)

FORCIRN

FORCIRN_STATUS

NOTIFICATION_STATUS_DATE Date the status of the notification was created from system activity. DATE

FORCIRN

FORCIRN_STATUS_DATE

OWNER_ENTITY_IND Indicates whether the expense owner is a person or an organization. VARCHAR2(1)

FUNCTION

MGKFUNC.F_GET_PERSON_INFO

OWNER_ID User-defined or system generated one-up number of the expense owner. VARCHAR2(63)

FUNCTION

MGKFUNC.F_GET_PERSON_INFO

OWNER_NAME Combination of the person's last, first, and middle initial into one value. VARCHAR2(255)

FUNCTION

MGKFUNC.F_GET_PERSON_INFO

OWNER_UID Unique identification of the person who owns expenses in the reimbursement. NUMBER

FTRBREMB

FTRBREMB_OWNER_PIDM

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

NA

NA

REIMBURSEMENT System generated code identifying the reimbursement. The prefix is defined by the client for system ID TRAVREIM in the table fobfseq. VARCHAR2(63)

FTRBREMB

DOC_CODE

REIMBURSEMENT_DESC Reimbursement request description. VARCHAR2(255)

FTRBREMB

DESCRIPTION

REIMBURSEMENT_KEY Unique internal identification number of the reimbursement record. NUMBER

FTRRRCIR

FTRBREMB_ID

STEP_COMPLETE_IND Indicates if the routing step is complete or not. (Y)es the routing step is complete. (N)o, the routing step is not complete. VARCHAR2(1)

FORCIRS

FORCIRS_COMPLETE_IND



Ver: 8.5