Target Column	Business Definition	Database Data Type	Source Name	Source Column
APPROVER_ACTION	Indicates the type of action that the recipient needs to take.	VARCHAR2(1)	FORCIRR	FORCIRR_ACTION
APPROVER_ACTIVITY_DATE	The date when the information for the recipient record was entered or last updated.	DATE	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.	VARCHAR2(1)	FORCIRR	FORCIRR_COAS_CODE
APPROVER_DATA_ORIGIN	Source system that created or updated the recipient row.	VARCHAR2(30)	FORCIRR	FORCIRR_DATA_ORIGIN
APPROVER_ORGN_CODE	Identifies the specific department to which the rule applies.	VARCHAR2(6)	FORCIRR	FORCIRR_ORGN_CODE
APPROVER_ROLE	Role that the recipient is providing in this step of the circulation.	VARCHAR2(50)	FORCIRR	FORCIRR_ROLE
APPROVER_ROLE_ORIGIN	Used for Circulation templates only.	VARCHAR2(50)	FORCIRR	FORCIRR_ROLE_ORIGIN
APPROVER_UID	Unique system assigned identification number for the user in this routing step.	NUMBER	FORCIRR	FORCIRR_RECIPIENT_PIDM
APPROVER_USER_ID	The unique identification code of the user who last touched this recipient record.	VARCHAR2(30)	FORCIRR	FORCIRR_USER_ID
APPROVER_WORKFLOW_ID	Unique identifier for the approval workflow associated with the routing recipient.	VARCHAR2(255)	FORCIRR	FORCIRR_WORKFLOW_ID
CIRCULATION_APPROVER_KEY	Unique internal identification number of the recipient record.	NUMBER	FORCIRR	FORCIRR_ID
CIRCULATION_NOTIFICATION_KEY	Unique internal identification number of the notification record.	NUMBER	FORCIRN	FORCIRN_ID
CIRCULATION_STEP_KEY	Unique internal identification number of the routing step record.	NUMBER	FORCIRR	FORCIRR_FORCIRS_ID
CURRENT_DATE	This is a the system current date (sysdate).	DATE	NA	SYSDATE
DOMAIN_VALUE	Domain column for future use, not currently populated.	VARCHAR2(6)	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.	VARCHAR2(30)	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.	VARCHAR2(6)	NA	NA
NOTIFICATION_ACTIVITY_DATE	The date when the information for the notification record was entered or last updated.	DATE	FORCIRN	FORCIRN_ACTIVITY_DATE
NOTIFICATION_COMMENT	Recipient comment.	VARCHAR2(4000)	FORCIRN	FORCIRN_COMMENT
NOTIFICATION_DATA_ORIGIN	Source system that created or updated the notification row.	VARCHAR2(30)	FORCIRN	FORCIRN_DATA_ORIGIN
NOTIFICATION_RESOLVED_IND	Indicates whether an issue that caused a delay or skip notification was resolved.	VARCHAR2(1)	FORCIRN	FORCIRN_RESOLVED_IND
NOTIFICATION_STATUS	The status of the notification .	VARCHAR2(50)	FORCIRN	FORCIRN_STATUS
NOTIFICATION_STATUS_DATE	The date of the status of the notification from the system activity .	DATE	FORCIRN	FORCIRN_STATUS_DATE
NOTIFICATION_USER_ID	The unique identification code of the user who last touched this notification record.	VARCHAR2(30)	FORCIRN	FORCIRN_USER_ID
ZONE_VALUE	Zone column for future use, not currently populated.	VARCHAR2(6)	NA	NA

Ver: