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

Ver: