Target Column	Business Definition	Database Data Type	Source Name	Source Column
COMMENTS	Free form comments recorded for an employee review.	VARCHAR2(4000)	PERREVW	PERREVW_COMMENT
CURRENT_DATE	System current date (sysdate) or date the data was extracted.	DATE	NA	SYSDATE
DOMAIN_VALUE	Organization-oriented identifier for the record used to determine access authorization. Institution defined.	VARCHAR2(6)	NA	NA
MIF_DESC	Institution description when the optional multi-institution facility feature has been applied.	VARCHAR2(30)	NA	NA
MIF_VALUE	Institution value for the record when the optional multi-institution facility feature has been applied.	VARCHAR2(6)	NA	NA
NEXT_REVIEW_DATE	Next review date.	DATE	FUNCTION	POKODSF.F_NEXT_REVIEW_DATE
PERSON_UID	System generated, unique, internal identification number assigned to this person.	NUMBER	PERREVW	PERREVW_PIDM
POSITION	Position.	VARCHAR2(0)	NA	NA
POSITION_CLASS	Position class.	VARCHAR2(0)	NA	NA
POSITION_CLASS_DESC	Position class description.	VARCHAR2(0)	NA	NA
POSITION_TITLE	Position description.	VARCHAR2(0)	NA	NA
REVIEWER_UID	Internal identification number of person responsible for the review.	NUMBER	PERREVW	PERREVW_REVIEWER_PIDM
REVIEW_COMPLETED_DATE	Date the review was completed.	DATE	PERREVW	PERREVW_COMPLETED_DATE
REVIEW_DATE	Date this review type is due for completion.	DATE	PERREVW	PERREVW_REVT_DATE
REVIEW_RATING	A user defined rating system for completed review types.	VARCHAR2(6)	PERREVW	PERREVW_REVT_RATING
REVIEW_TYPE	A code identifying the type of review.	VARCHAR2(2)	PERREVW	PERREVW_REVT_CODE
REVIEW_TYPE_COMPLETE_IND	Code used to identify if this review type has been completed.	VARCHAR2(1)	PERREVW	PERREVW_REVT_COMPLETE
REVIEW_TYPE_DESC	Review type description.	VARCHAR2(30)	FUNCTION	GOKODSF.F_GET_DESC
ZONE_VALUE	Process-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(6)	NA	NA

Ver: