ODS Column	ODS Business Definition	ODS Calculation Formula	ODS Data Type	Banner Source Name	Banner Source Column	Banner Form Name
APPROVER_ACTION	Indicates the type of action that the recipient needs to take.			FORCIRR	FORCIRR_ACTION
APPROVER_ACTIVITY_DATE	The date when the information for the recipient record was entered or last updated.			FORCIRR	FORCIRR_ACTIVITY_DATE
APPROVER_COAS_CODE	The primary identification code for any chart of accounts that uniquely indentifies that chart from any other in a multi-chart environment.			FORCIRR	FORCIRR_COAS_CODE
APPROVER_DATA_ORIGIN	Source system that created or updated the recipient row.			FORCIRR	FORCIRR_DATA_ORIGIN
APPROVER_ORGN_CODE	Identifies the specific department to which the rule applies.			FORCIRR	FORCIRR_ORGN_CODE
APPROVER_ROLE	Role that the recipient is providing in this step of the circulation.			FORCIRR	FORCIRR_ROLE
APPROVER_ROLE_ORIGIN	Used for Circulation templates only.			FORCIRR	FORCIRR_ROLE_ORIGIN
APPROVER_UID	Unique system assigned identification number for the user in this routing step.			FORCIRR	FORCIRR_RECIPIENT_PIDM
APPROVER_USER_ID	The unique identification code of the user who last touched this recipient record.			FORCIRR	FORCIRR_USER_ID
APPROVER_WORKFLOW_ID	Unique identifier for the approval workflow associated with the routing recipient.			FORCIRR	FORCIRR_WORKFLOW_ID
CIRCULATION_APPROVER_KEY	Unique internal identification number of the recipient record.			FORCIRR	FORCIRR_ID
CIRCULATION_NOTIFICATION_KEY	Unique internal identification number of the notification record.			FORCIRN	FORCIRN_ID
CIRCULATION_STEP_KEY	Unique internal identification number of the routing step record.			FORCIRR	FORCIRR_FORCIRS_ID
CURRENT_DATE	This is a the system current date (sysdate).			NA	SYSDATE
DOMAIN_VALUE	Domain column for future use, not currently populated.			NA	NA
MIF_DESC	The institution description for the record when the optional multi-institution facility feature has been installed and applied for this table/column.			NA	NA
MIF_VALUE	The institution value for the record when the optional multi-institution facility feature has been installed and applied for this table/column.			NA	NA
NOTIFICATION_ACTIVITY_DATE	The date when the information for the notification record was entered or last updated.			FORCIRN	FORCIRN_ACTIVITY_DATE
NOTIFICATION_COMMENT	Recipient comment.			FORCIRN	FORCIRN_COMMENT
NOTIFICATION_DATA_ORIGIN	Source system that created or updated the notification row.			FORCIRN	FORCIRN_DATA_ORIGIN
NOTIFICATION_RESOLVED_IND	Indicates whether an issue that caused a delay or skip notification was resolved.			FORCIRN	FORCIRN_RESOLVED_IND
NOTIFICATION_STATUS	The status of the notification .			FORCIRN	FORCIRN_STATUS
NOTIFICATION_STATUS_DATE	The date of the status of the notification from the system activity .			FORCIRN	FORCIRN_STATUS_DATE
NOTIFICATION_USER_ID	The unique identification code of the user who last touched this notification record.			FORCIRN	FORCIRN_USER_ID
ZONE_VALUE	Zone column for future use, not currently populated.			NA	NA

Ver: 8.3