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	FRRGRPI	FRRGRPI_ADDR_SEQNO
ADDRESS_TYPE	Address type associated with grant personnel.	VARCHAR2(63)	FRRGRPI	FRRGRPI_ADDR_TYPE
ADDRESS_TYPE_DESC	Address type description.	VARCHAR2(255)	STVATYP	STVATYP_DESC
ADMINISTRATIVE_GROUP	Organization-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(255)	NA	NA
BILL_FORMAT	Determines which bills or reports this person's name is printed.	VARCHAR2(63)	FRRGRPI	FRRGRPI_BFRM_CODE
BILL_FORMAT_DESC	Billing format description	VARCHAR2(255)	FRVBFRM	FRVBFRM_DESC
BILL_FORMAT_TYPE	Billing format type. (B)ill or (R)eport.	VARCHAR2(255)	FRVBFRM	FRVBFRM_TYPE_IND
BILL_FORMAT_TYPE_DESC	Billing format type description.	VARCHAR2(255)	CALCULATION	DECODE(FRVBFRM_TYPE_IND)
CARRIER_ROUTE	Address carrier route.	VARCHAR2(4)	SPRADDR	SPRADDR_CARRIER_ROUTE
CHART_OF_ACCOUNTS	Identifies the chart from other charts in a multi-chart environment.	VARCHAR2(63)	FRBGRNT	FRBGRNT_COAS_CODE
CHART_OF_ACCOUNTS_DESC	Chart of accounts code description or title.	VARCHAR2(255)	FTVCOAS	FTVCOAS_TITLE
CHART_OF_ACCOUNTS_STATUS	Status of the chart of accounts.	VARCHAR2(63)	FTVCOAS	FTVCOAS_STATUS_IND
CITY	Address city, town or municipality.	VARCHAR2(63)	SPRADDR	SPRADDR_CITY
CORRECTION_DIGIT	Correction digit associated with the address for bar code mailing.	NUMBER	SPRADDR	SPRADDR_CORRECTION_DIGIT
COUNTY	County for this address.	VARCHAR2(63)	SPRADDR	SPRADDR_CNTY_CODE
COUNTY_DESC	County name for the address.	VARCHAR2(255)	SPRADDR	STVCNTY_DESC
DELIVERY_POINT	Delivery point associated with the address for barcode mailings.	NUMBER	SPRADDR	SPRADDR_DELIVERY_POINT
EMAIL_ADDRESS	Personnel email address.	VARCHAR2(255)	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	FRRGRPI	FRRGRPI_FTE
GRANT_ID	Unique user-defined or system generated one-up number for this grant.	VARCHAR2(63)	FRRGRPI	FRRGRPI_GRNT_CODE
GRANT_SHORT_TITLE	Grant short title or description.	VARCHAR2(255)	FRBGRNT	FRBGRNT_TITLE
MULTI_SOURCE	Institution value for the record when the optional multi-institution facility feature has been applied.	VARCHAR2(63)	NA	NA
MULTI_SOURCE_DESC	Institution description when the optional multi-institution facility feature has been applied.	VARCHAR2(255)	NA	NA
NATION	Nation/country code associated with the address.	VARCHAR2(63)	SPRADDR	SPRADDR_NATN_CODE
NATION_DESC	Address nation/country description.	VARCHAR2(255)	STVNATN	STVNATN_NATION
ORGANIZATION_CODE	Identification accounting code used for the department.	VARCHAR2(63)	FRRGRPI	FRRGRPI_ORGN_CODE
ORGANIZATION_DESC	Organization description.	VARCHAR2(255)	FTVORGN	FTVORGN_TITLE
ORGANIZATION_STATUS	Current status of the associated organization.	VARCHAR2(63)	FTVORGN	FTVORGN_STATUS_IND
PERSONNEL_ACTIVITY_DATE	Date record was inserted or updated.	DATE	FRRGRPI	FRRGRPI_ACTIVITY_DATE
PERSONNEL_FIRST_NAME	Personnel current first name.	VARCHAR2(63)	FUNCTION SPRIDEN	MGKFUNC.F_GET_PERSON_INFO SPRIDEN_FIRST_NAME
PERSONNEL_ID	Identification number assigned to a person that is used externally for all communication and correspondence with the person.	VARCHAR2(63)	FUNCTION SPRIDEN	MGKFUNC.F_GET_PERSON_INFO SPRIDEN_ID
PERSONNEL_LAST_NAME	Personnel current last name.	VARCHAR2(63)	FUNCTION SPRIDEN	MGKFUNC.F_GET_PERSON_INFO SPRIDEN_LAST_NAME
PERSONNEL_MIDDLE_NAME	Personnel current middle name.	VARCHAR2(63)	FUNCTION SPRIDEN	MGKFUNC.F_GET_PERSON_INFO SPRIDEN_MI
PERSONNEL_NAME	Combination of the person's last name, first name, and middle initial into one value.	VARCHAR2(255)	FUNCTION SPRIDEN	MGKFUNC.F_GET_PERSON_INFO SPRIDEN_LAST_NAME || SPRIDEN_FIRST_NAME || SPRIDEN_MI
PERSONNEL_SALUTATION	User defined preferred salutation.	VARCHAR2(255)	FRRGRPI	FRRGRPI_SALUTATION
PERSONNEL_TITLE	Personnel title.	VARCHAR2(255)	FRRGRPI	FRRGRPI_TITLE
PERSONNEL_TYPE	Identifies type of personnel.	VARCHAR2(63)	FRRGRPI	FRRGRPI_ID_IND
PERSONNEL_TYPE_DESC	Personnel type description.	VARCHAR2(255)	FUNCTION	FOKODSF.F_GET_SDAT_TITLE
PERSONNEL_UID	System generated, unique, internal identification number assigned to this person.	NUMBER	FRRGRPI	FRRGRPI_ID_PIDM
PERSONNEL_USER_ID	Unique identification code of the user who entered or last touched the transaction.	VARCHAR2(63)	FRRGRPI	FRRGRPI_USER_ID
PHONE_AREA	Phone area.	VARCHAR2(63)	SPRTELE	SPRTELE_PHONE_AREA
PHONE_EXT	Phone extension.	VARCHAR2(63)	SPRTELE	SPRTELE_PHONE_EXT
PHONE_NUMBER	Phone number.	VARCHAR2(63)	SPRTELE	SPRTELE_PHONE_NUMBER
PHONE_NUMBER_COMBINED	All recorded pieces of the telephone number combined in a single field. International code, area code, number, extension.	VARCHAR2(63)	CALCULATION	SPRTELE_INTL_ACCESS||SPRTELE_PHONE_AREA||SPRTELE_PHONE_NUMBER||SPRTELE_PHONE_EXT
PHONE_SEQ_NUMBER	Sequence number associated with this specific phone type for this person.	NUMBER	FRRGRPI	FRRGRPI_TELE_SEQNO
PHONE_TYPE	Type of telephone information such as home phone, emergency contact.	VARCHAR2(63)	FRRGRPI	FRRGRPI_PHONE_TYPE
PHONE_TYPE_DESC	Telephone number type description.	VARCHAR2(255)	FUNCTION	GOKODSF.F_GET_DESC
POSTAL_CODE	Address postal code.	VARCHAR2(63)	SPRADDR	SPRADDR_ZIP
PROCESS_GROUP	Process-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(255)	NA	NA
STATE_PROVINCE	State or province associated with this address.	VARCHAR2(63)	SPRADDR	SPRADDR_STAT_CODE
STATE_PROVINCE_DESC	State or province name.	VARCHAR2(255)	SPRADDR	STVSTAT_DESC
STREET_LINE1	First line of the address.	VARCHAR2(255)	SPRADDR	SPRADDR_STREET_LINE1
STREET_LINE2	Second line of the address.	VARCHAR2(255)	SPRADDR	SPRADDR_STREET_LINE2
STREET_LINE3	Third line of the address.	VARCHAR2(255)	SPRADDR	SPRADDR_STREET_LINE3
STREET_LINE4	Fourth line of the address.	VARCHAR2(255)	SPRADDR	SPRADDR_STREET_LINE4

Ver: 9.1