Target Column	Business Name	Business Definition	Database Data Type	Domain Value	Source Name	Source Column
ADDRESS NUMBER	Address Number	Sequence used to identify different addresses within the same address type.	NUMBER(2)		FRRGRPI	FRRGRPI_ADDR_SEQNO
ADDRESS_NUMBER	Address Number		NUMBER
ADDRESS_TYPE	Address Type	Address type associated with grant personnel.	VARCHAR2(2)		FRRGRPI	FRRGRPI_ADDR_TYPE
BILL_FORMAT	Bill Format	Determines which bills or reports this person's name is printed.	VARCHAR2(4)		FRRGRPI	FRRGRPI_BFRM_CODE
BILL_FORMAT_DESC	Bill Format Description	Billing format description	VARCHAR2(35)		FRVBFRM	FRVBFRM_DESC
BILL_FORMAT_TYPE	Bill Format Type	Billing format type. (B)ill or (R)eport.	VARCHAR2(1)		FRVBFRM	FRVBFRM_TYPE_IND
BILL_FORMAT_TYPE_DESC	Bill Format Type Description	Billing format type description.	VARCHAR2(6)		CALCULATION	DECODE(FRVBFRM_TYPE_IND)
CHART_OF_ACCOUNTS	Chart Of Accounts	Identifies the chart from other charts in a multi-chart environment.	VARCHAR2(1)		FRBGRNT	FRBGRNT_COAS_CODE
CURRENT_DATE	Current Date	System current date (sysdate) or date the data was extracted.	DATE		NA	SYSDATE
DOMAIN_VALUE	Domain Value	Organization-oriented identifier for the record used to determine access authorization. Institution defined.	VARCHAR2(6)		NA	NA
EMAIL_ADDRESS	Email Address	Personnel email address.	VARCHAR2(128)		FRRGRPI	FRRGRPI_EMAIL
EMPLOYEE_IND	Employee Indicator	Determines whether person is an employee.	VARCHAR2(1)		FRRGRPI	FRRGRPI_EMPLOYEE_IND
FULL_TIME_EQUIVALENCY_PCT	Full Time Equivalency Percent	Proportion of time that the person spends working on the grant.	NUMBER(3,2)		FRRGRPI	FRRGRPI_FTE
GRANT_ID	Grant ID	Unique user-defined or system generated one-up number for this grant.	VARCHAR2(9)		FRRGRPI	FRRGRPI_GRNT_CODE
MIF_DESC	MIF Description	Institution description when the optional multi-institution facility feature has been applied.	VARCHAR2(30)		NA	NA
MIF_VALUE	MIF Value	Institution value for the record when the optional multi-institution facility feature has been applied.	VARCHAR2(6)		NA	NA
ORGANIZATION_CODE	Organization Code	Identification accounting code used for the department.	VARCHAR2(6)		FRRGRPI	FRRGRPI_ORGN_CODE
PERSONNEL_ACTIVITY DATE	Personnel Activity Date	Date record was inserted or updated.	DATE		FRRGRPI	FRRGRPI_ACTIVITY_DATE
PERSONNEL_ACTIVITY_DATE	Personnel Activity Date		DATE
PERSONNEL_SALUTATION	Personnel Salutation	User defined preferred salutation.	VARCHAR2(35)		FRRGRPI	FRRGRPI_SALUTATION
PERSONNEL_TITLE	Personnel Title	Personnel title.	VARCHAR2(35)		FRRGRPI	FRRGRPI_TITLE
PERSONNEL_TYPE	Personnel Type	Identifies type of personnel.	VARCHAR2(3)		FRRGRPI	FRRGRPI_ID_IND
PERSONNEL_TYPE_DESC	Personnel Type Description	Personnel type description.	VARCHAR2(35)		FUNCTION	FOKODSF.F_GET_SDAT_TITLE
PERSONNEL_UID	Personnel UID	System generated, unique, internal identification number assigned to this person.	NUMBER(8)		FRRGRPI	FRRGRPI_ID_PIDM
PERSONNEL_USER_ID	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	Phone Sequence Number	Sequence number associated with this specific phone type for this person.	NUMBER(2)		FRRGRPI	FRRGRPI_TELE_SEQNO
PHONE_TYPE	Phone Type	Type of telephone information such as home phone, emergency contact.	VARCHAR2(4)		FRRGRPI	FRRGRPI_PHONE_TYPE
ZONE_VALUE	Zone Value	Process-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(6)		NA	NA

Ver: