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

Banner Operational Data Store
Reporting View Target: AUTHORIZATION_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 authorization 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
AUTHORIZATION_KEY

Target Column Business Name Business Definition Database Data Type Source Name Source Column
ADDITIONAL_APPROVER_IND Additional Approver Indicator 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 Group Administrative-oriented identifier for the record used to determine access authorization to this record. Institution defined. VARCHAR2(255)

NA

NA

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

FORCIRR

FORCIRR_DATA_ORIGIN

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

FUNCTION

MGKFUNC.F_GET_PERSON_INFO

APPROVER_NAME 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 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 Approver UID Personal identification number of the approver. NUMBER

FORCIRR

FORCIRR_RECIPIENT_PIDM

APPROVER_WORKFLOW_ID 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

AUTHORIZATION Authorization System generated code identifying the authorization. The prefix is defined by the client for system ID TRAVAUTH in the table fobfseq. VARCHAR2(63)

FTRBAUTH

DOC_CODE

AUTHORIZATION_DESC Authorization Description Authorization request description. VARCHAR2(255)

FTRBAUTH

DESCRIPTION

AUTHORIZATION_KEY Authorization KEY Unique internal identification number of the authorization record. NUMBER

FTRRACIR

FTRBAUTH_ID

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

FOBCIRH

FOBCIRH_ACTIVITY_DATE

CIRCULATION_BEGIN_DATE Circulation Begin Date Date and time that the circulation was started. DATE

FOBCIRH

FOBCIRH_START_DATE

CIRCULATION_COMPLETE_DATE Circulation Completion Date Date and time that the circulation was completed. DATE

FOBCIRH

FOBCIRH_COMPLETION_DATE

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

FTRRACIR

FOBCIRH_ID

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

FORCIRN

ID

CIRCULATION_ORDER Circulation Order Order of this step in the overall circulation. NUMBER

FORCIRS

FORCIRS_ORDER

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

FORCIRR

ID

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

FOBCIRH

FOBCIRH_STATUS

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

FORCIRS

ID

CIRCULATION_USER_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 Multi Source Institution value for the record when the optional multi-institution facility feature has been applied. VARCHAR2(63)

NA

NA

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

NA

NA

NOTIFICATION_CHANGE_HOURS 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 Notification Change Hours Total 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 Notification Comment Free-form approver comment. VARCHAR2(4000)

FORCIRN

FORCIRN_COMMENT

NOTIFICATION_STATUS 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 Notification Status Date Date the status of the notification was created from system activity. DATE

FORCIRN

FORCIRN_STATUS_DATE

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

FUNCTION

MGKFUNC.F_GET_PERSON_INFO

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

FUNCTION

MGKFUNC.F_GET_PERSON_INFO

OWNER_NAME 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 Owner UID Unique identification of the person who owns expenses in the authorization. NUMBER

FTRBAUTH

FTRBAUTH_OWNER_PIDM

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

NA

NA

STEP_COMPLETE_IND Step Completion Indicator 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: 9.2