Target Column	Business Definition	Database Data Type	Source Name	Source Column
ADDRESS NUMBER	Sequence used to identify different addresses within the same address type.	NUMBER(2)	FRRGRPI	FRRGRPI_ADDR_SEQNO
ADDRESS_NUMBER		NUMBER
ADDRESS_TYPE	Address type associated with grant personnel.	VARCHAR2(2)	FRRGRPI	FRRGRPI_ADDR_TYPE
BILL_FORMAT	Determines which bills or reports this person's name is printed.	VARCHAR2(4)	FRRGRPI	FRRGRPI_BFRM_CODE
BILL_FORMAT_DESC	Billing format description	VARCHAR2(35)	FRVBFRM	FRVBFRM_DESC
BILL_FORMAT_TYPE	Billing format type. (B)ill or (R)eport.	VARCHAR2(1)	FRVBFRM	FRVBFRM_TYPE_IND
BILL_FORMAT_TYPE_DESC	Billing format type description.	VARCHAR2(6)	CALCULATION	DECODE(FRVBFRM_TYPE_IND)
CHART_OF_ACCOUNTS	Identifies the chart from other charts in a multi-chart environment.	VARCHAR2(1)	FRBGRNT	FRBGRNT_COAS_CODE
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
EMAIL_ADDRESS	Personnel email address.	VARCHAR2(128)	FRRGRPI	FRRGRPI_EMAIL
EMPLOYEE_IND	Determines whether person is an employee.	VARCHAR2(1)	FRRGRPI	FRRGRPI_EMPLOYEE_IND
FULL_TIME_EQUIVALENCY_PCT	Proportion of time that the person spends working on the grant.	NUMBER(3,2)	FRRGRPI	FRRGRPI_FTE
GRANT_ID	Unique user-defined or system generated one-up number for this grant.	VARCHAR2(9)	FRRGRPI	FRRGRPI_GRNT_CODE
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
ORGANIZATION_CODE	Identification accounting code used for the department.	VARCHAR2(6)	FRRGRPI	FRRGRPI_ORGN_CODE
PERSONNEL_ACTIVITY DATE	Date record was inserted or updated.	DATE	FRRGRPI	FRRGRPI_ACTIVITY_DATE
PERSONNEL_ACTIVITY_DATE		DATE
PERSONNEL_SALUTATION	User defined preferred salutation.	VARCHAR2(35)	FRRGRPI	FRRGRPI_SALUTATION
PERSONNEL_TITLE	Personnel title.	VARCHAR2(35)	FRRGRPI	FRRGRPI_TITLE
PERSONNEL_TYPE	Identifies type of personnel.	VARCHAR2(3)	FRRGRPI	FRRGRPI_ID_IND
PERSONNEL_TYPE_DESC	Personnel type description.	VARCHAR2(35)	FUNCTION	FOKODSF.F_GET_SDAT_TITLE
PERSONNEL_UID	System generated, unique, internal identification number assigned to this person.	NUMBER(8)	FRRGRPI	FRRGRPI_ID_PIDM
PERSONNEL_USER_ID	Unique identification code of the user who entered or last touched the transaction.	VARCHAR2(30)	FRRGRPI	FRRGRPI_USER_ID
PHONE_SEQ_NUMBER	Sequence number associated with this specific phone type for this person.	NUMBER(2)	FRRGRPI	FRRGRPI_TELE_SEQNO
PHONE_TYPE	Type of telephone information such as home phone, emergency contact.	VARCHAR2(4)	FRRGRPI	FRRGRPI_PHONE_TYPE
ZONE_VALUE	Process-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(6)	NA	NA

Ver: