Reporting View Target: GRANT

Go To View:	RETURN TO BANNER ODS META DATA REPORTS LIST
	Finance Reporting View Reports

SGHE Banner Operational Data Store
Reporting View Target: GRANT_PERSONNEL

Description Contains information about personnel associated to the grant, each person's contact information.
Key & Frequency One row per grant ID per personnel type per personnel UID.
Recommended Search Columns PHONE_SEQ_NUMBER
PHONE_TYPE, PHONE_SEQ_NUMBER
ADDRESS_TYPE
GRANT_ID
CHART_OF_ACCOUNTS
GRANT_ID, PERSONNEL_TYPE, PERSONNEL_UID
PERSONNEL_UID, GRANT_ID

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
FRRGRPI

FRRGRPI_ADDR_SEQNO

ADDRESS_TYPE Address Type Address type associated with grant personnel. VARCHAR2(63)
FRRGRPI

FRRGRPI_ADDR_TYPE

ADDRESS_TYPE_DESC Address Type Description Address type description. VARCHAR2(255)
STVATYP

STVATYP_DESC

ADMINISTRATIVE_GROUP Administrative Group Organization-oriented identifier for the record used to determine access authorization to this record. Institution defined. VARCHAR2(255)
NA

NA

BILL_FORMAT Bill Format Determines which bills or reports this person's name is printed. VARCHAR2(63)
FRRGRPI

FRRGRPI_BFRM_CODE

BILL_FORMAT_DESC Bill Format Description Billing format description VARCHAR2(255)
FRVBFRM

FRVBFRM_DESC

BILL_FORMAT_TYPE Bill Format Type Billing format type. (B)ill or (R)eport. VARCHAR2(255)
FRVBFRM

FRVBFRM_TYPE_IND

BILL_FORMAT_TYPE_DESC Bill Format Type Description Billing format type description. VARCHAR2(255)
CALCULATION

DECODE(FRVBFRM_TYPE_IND)

CARRIER_ROUTE Carrier Route Address carrier route. VARCHAR2(4)
SPRADDR

SPRADDR_CARRIER_ROUTE

CHART_OF_ACCOUNTS 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 Description Chart of accounts code description or title. VARCHAR2(255)
FTVCOAS

FTVCOAS_TITLE

CHART_OF_ACCOUNTS_STATUS Chart Of Accounts Status Status of the chart of accounts. VARCHAR2(63)
FTVCOAS

FTVCOAS_STATUS_IND

CITY City Address city, town or municipality. VARCHAR2(63)
SPRADDR

SPRADDR_CITY

CORRECTION_DIGIT Correction Digit Correction digit associated with the address for bar code mailing. NUMBER
SPRADDR

SPRADDR_CORRECTION_DIGIT

COUNTY County County for this address. VARCHAR2(63)
SPRADDR

SPRADDR_CNTY_CODE

COUNTY_DESC County Description County name for the address. VARCHAR2(255)
SPRADDR

STVCNTY_DESC

DELIVERY_POINT Delivery Point Delivery point associated with the address for barcode mailings. NUMBER
SPRADDR

SPRADDR_DELIVERY_POINT

EMAIL_ADDRESS Email Address Personnel email address. VARCHAR2(255)
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
FRRGRPI

FRRGRPI_FTE

GRANT_ID 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 Grant short title or description. VARCHAR2(255)
FRBGRNT

FRBGRNT_TITLE

MULTI_SOURCE Multi Source Institution value for the record when the optional multi-institution facility feature has been applied. VARCHAR2(63)
NA

NA

MULTI_SOURCE_DESC Multi Source Description Institution description when the optional multi-institution facility feature has been applied. VARCHAR2(255)
NA

NA

NATION Nation Nation/country code associated with the address. VARCHAR2(63)
SPRADDR

SPRADDR_NATN_CODE

NATION_DESC Nation Description Address nation/country description. VARCHAR2(255)
STVNATN

STVNATN_NATION

ORGANIZATION_CODE Organization Code Identification accounting code used for the department. VARCHAR2(63)
FRRGRPI

FRRGRPI_ORGN_CODE

ORGANIZATION_DESC Organization Description Organization description. VARCHAR2(255)
FTVORGN

FTVORGN_TITLE

ORGANIZATION_STATUS Organization Status Current status of the associated organization. VARCHAR2(63)
FTVORGN

FTVORGN_STATUS_IND

PERSONNEL_ACTIVITY_DATE Personnel Activity Date Date record was inserted or updated. DATE
FRRGRPI

FRRGRPI_ACTIVITY_DATE

PERSONNEL_FIRST_NAME Personnel First Name Personnel current first name. VARCHAR2(63)
FUNCTION

MGKFUNC.F_GET_PERSON_INFO

PERSONNEL_ID Personnel ID Identification number assigned to a person that is used externally for all communication and correspondence with the person. VARCHAR2(63)
FUNCTION

MGKFUNC.F_GET_PERSON_INFO

PERSONNEL_LAST_NAME Personnel Last Name Personnel current last name. VARCHAR2(63)
FUNCTION

MGKFUNC.F_GET_PERSON_INFO

PERSONNEL_MIDDLE_NAME Personnel Middle Name Personnel current middle name. VARCHAR2(63)
FUNCTION

MGKFUNC.F_GET_PERSON_INFO

PERSONNEL_NAME Personnel Name Combination of the person's last name, first name, and middle initial into one value. VARCHAR2(255)
FUNCTION

MGKFUNC.F_GET_PERSON_INFO

PERSONNEL_SALUTATION Personnel Salutation User defined preferred salutation. VARCHAR2(255)
FRRGRPI

FRRGRPI_SALUTATION

PERSONNEL_TITLE Personnel Title Personnel title. VARCHAR2(255)
FRRGRPI

FRRGRPI_TITLE

PERSONNEL_TYPE Personnel Type Identifies type of personnel. VARCHAR2(63)
FRRGRPI

FRRGRPI_ID_IND

PERSONNEL_TYPE_DESC Personnel Type Description Personnel type description. VARCHAR2(255)
FUNCTION

FOKODSF.F_GET_SDAT_TITLE

PERSONNEL_UID Personnel UID System generated, unique, internal identification number assigned to this person. NUMBER
FRRGRPI

FRRGRPI_ID_PIDM

PERSONNEL_USER_ID 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 Phone area. VARCHAR2(63)
SPRTELE

SPRTELE_PHONE_AREA

PHONE_EXT Phone Extension Phone extension. VARCHAR2(63)
SPRTELE

SPRTELE_PHONE_EXT

PHONE_NUMBER Phone Number Phone number. VARCHAR2(63)
SPRTELE

SPRTELE_PHONE_NUMBER

PHONE_NUMBER_COMBINED 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 Phone Sequence Number Sequence number associated with this specific phone type for this person. NUMBER
FRRGRPI

FRRGRPI_TELE_SEQNO

PHONE_TYPE Phone Type Type of telephone information such as home phone, emergency contact. VARCHAR2(63)
FRRGRPI

FRRGRPI_PHONE_TYPE

PHONE_TYPE_DESC Phone Type Description Telephone number type description. VARCHAR2(255)
FUNCTION

GOKODSF.F_GET_DESC

POSTAL_CODE Postal Code Address postal code. VARCHAR2(63)
SPRADDR

SPRADDR_ZIP

PROCESS_GROUP 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 Province State or province associated with this address. VARCHAR2(63)
SPRADDR

SPRADDR_STAT_CODE

STATE_PROVINCE_DESC State Province Description State or province name. VARCHAR2(255)
SPRADDR

STVSTAT_DESC

STREET_LINE1 Street Line 1 First line of the address. VARCHAR2(255)
SPRADDR

SPRADDR_STREET_LINE1

STREET_LINE2 Street Line 2 Second line of the address. VARCHAR2(255)
SPRADDR

SPRADDR_STREET_LINE2

STREET_LINE3 Street Line 3 Third line of the address. VARCHAR2(255)
SPRADDR

SPRADDR_STREET_LINE3

STREET_LINE4 Street Line 4 Fourth line of the address. VARCHAR2(255)
SPRADDR

SPRADDR_STREET_LINE4

Ver: 9.0

Description	Contains information about personnel associated to the grant, each person's contact information.
Key & Frequency	One row per grant ID per personnel type per personnel UID.
Recommended Search Columns	PHONE_SEQ_NUMBER PHONE_TYPE, PHONE_SEQ_NUMBER ADDRESS_TYPE GRANT_ID CHART_OF_ACCOUNTS GRANT_ID, PERSONNEL_TYPE, PERSONNEL_UID PERSONNEL_UID, GRANT_ID

Target Column	Business Name	Business Definition	Database Data Type	Source Name	Source Column
ADDRESS_NUMBER	Address Number	Sequence used to identify different addresses within the same address type.	NUMBER	FRRGRPI	FRRGRPI_ADDR_SEQNO
ADDRESS_TYPE	Address Type	Address type associated with grant personnel.	VARCHAR2(63)	FRRGRPI	FRRGRPI_ADDR_TYPE
ADDRESS_TYPE_DESC	Address Type Description	Address type description.	VARCHAR2(255)	STVATYP	STVATYP_DESC
ADMINISTRATIVE_GROUP	Administrative Group	Organization-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(255)	NA	NA
BILL_FORMAT	Bill Format	Determines which bills or reports this person's name is printed.	VARCHAR2(63)	FRRGRPI	FRRGRPI_BFRM_CODE
BILL_FORMAT_DESC	Bill Format Description	Billing format description	VARCHAR2(255)	FRVBFRM	FRVBFRM_DESC
BILL_FORMAT_TYPE	Bill Format Type	Billing format type. (B)ill or (R)eport.	VARCHAR2(255)	FRVBFRM	FRVBFRM_TYPE_IND
BILL_FORMAT_TYPE_DESC	Bill Format Type Description	Billing format type description.	VARCHAR2(255)	CALCULATION	DECODE(FRVBFRM_TYPE_IND)
CARRIER_ROUTE	Carrier Route	Address carrier route.	VARCHAR2(4)	SPRADDR	SPRADDR_CARRIER_ROUTE
CHART_OF_ACCOUNTS	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 Description	Chart of accounts code description or title.	VARCHAR2(255)	FTVCOAS	FTVCOAS_TITLE
CHART_OF_ACCOUNTS_STATUS	Chart Of Accounts Status	Status of the chart of accounts.	VARCHAR2(63)	FTVCOAS	FTVCOAS_STATUS_IND
CITY	City	Address city, town or municipality.	VARCHAR2(63)	SPRADDR	SPRADDR_CITY
CORRECTION_DIGIT	Correction Digit	Correction digit associated with the address for bar code mailing.	NUMBER	SPRADDR	SPRADDR_CORRECTION_DIGIT
COUNTY	County	County for this address.	VARCHAR2(63)	SPRADDR	SPRADDR_CNTY_CODE
COUNTY_DESC	County Description	County name for the address.	VARCHAR2(255)	SPRADDR	STVCNTY_DESC
DELIVERY_POINT	Delivery Point	Delivery point associated with the address for barcode mailings.	NUMBER	SPRADDR	SPRADDR_DELIVERY_POINT
EMAIL_ADDRESS	Email Address	Personnel email address.	VARCHAR2(255)	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	FRRGRPI	FRRGRPI_FTE
GRANT_ID	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	Grant short title or description.	VARCHAR2(255)	FRBGRNT	FRBGRNT_TITLE
MULTI_SOURCE	Multi Source	Institution value for the record when the optional multi-institution facility feature has been applied.	VARCHAR2(63)	NA	NA
MULTI_SOURCE_DESC	Multi Source Description	Institution description when the optional multi-institution facility feature has been applied.	VARCHAR2(255)	NA	NA
NATION	Nation	Nation/country code associated with the address.	VARCHAR2(63)	SPRADDR	SPRADDR_NATN_CODE
NATION_DESC	Nation Description	Address nation/country description.	VARCHAR2(255)	STVNATN	STVNATN_NATION
ORGANIZATION_CODE	Organization Code	Identification accounting code used for the department.	VARCHAR2(63)	FRRGRPI	FRRGRPI_ORGN_CODE
ORGANIZATION_DESC	Organization Description	Organization description.	VARCHAR2(255)	FTVORGN	FTVORGN_TITLE
ORGANIZATION_STATUS	Organization Status	Current status of the associated organization.	VARCHAR2(63)	FTVORGN	FTVORGN_STATUS_IND
PERSONNEL_ACTIVITY_DATE	Personnel Activity Date	Date record was inserted or updated.	DATE	FRRGRPI	FRRGRPI_ACTIVITY_DATE
PERSONNEL_FIRST_NAME	Personnel First Name	Personnel current first name.	VARCHAR2(63)	FUNCTION	MGKFUNC.F_GET_PERSON_INFO
PERSONNEL_ID	Personnel ID	Identification number assigned to a person that is used externally for all communication and correspondence with the person.	VARCHAR2(63)	FUNCTION	MGKFUNC.F_GET_PERSON_INFO
PERSONNEL_LAST_NAME	Personnel Last Name	Personnel current last name.	VARCHAR2(63)	FUNCTION	MGKFUNC.F_GET_PERSON_INFO
PERSONNEL_MIDDLE_NAME	Personnel Middle Name	Personnel current middle name.	VARCHAR2(63)	FUNCTION	MGKFUNC.F_GET_PERSON_INFO
PERSONNEL_NAME	Personnel Name	Combination of the person's last name, first name, and middle initial into one value.	VARCHAR2(255)	FUNCTION	MGKFUNC.F_GET_PERSON_INFO
PERSONNEL_SALUTATION	Personnel Salutation	User defined preferred salutation.	VARCHAR2(255)	FRRGRPI	FRRGRPI_SALUTATION
PERSONNEL_TITLE	Personnel Title	Personnel title.	VARCHAR2(255)	FRRGRPI	FRRGRPI_TITLE
PERSONNEL_TYPE	Personnel Type	Identifies type of personnel.	VARCHAR2(63)	FRRGRPI	FRRGRPI_ID_IND
PERSONNEL_TYPE_DESC	Personnel Type Description	Personnel type description.	VARCHAR2(255)	FUNCTION	FOKODSF.F_GET_SDAT_TITLE
PERSONNEL_UID	Personnel UID	System generated, unique, internal identification number assigned to this person.	NUMBER	FRRGRPI	FRRGRPI_ID_PIDM
PERSONNEL_USER_ID	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	Phone area.	VARCHAR2(63)	SPRTELE	SPRTELE_PHONE_AREA
PHONE_EXT	Phone Extension	Phone extension.	VARCHAR2(63)	SPRTELE	SPRTELE_PHONE_EXT
PHONE_NUMBER	Phone Number	Phone number.	VARCHAR2(63)	SPRTELE	SPRTELE_PHONE_NUMBER
PHONE_NUMBER_COMBINED	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	Phone Sequence Number	Sequence number associated with this specific phone type for this person.	NUMBER	FRRGRPI	FRRGRPI_TELE_SEQNO
PHONE_TYPE	Phone Type	Type of telephone information such as home phone, emergency contact.	VARCHAR2(63)	FRRGRPI	FRRGRPI_PHONE_TYPE
PHONE_TYPE_DESC	Phone Type Description	Telephone number type description.	VARCHAR2(255)	FUNCTION	GOKODSF.F_GET_DESC
POSTAL_CODE	Postal Code	Address postal code.	VARCHAR2(63)	SPRADDR	SPRADDR_ZIP
PROCESS_GROUP	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 Province	State or province associated with this address.	VARCHAR2(63)	SPRADDR	SPRADDR_STAT_CODE
STATE_PROVINCE_DESC	State Province Description	State or province name.	VARCHAR2(255)	SPRADDR	STVSTAT_DESC
STREET_LINE1	Street Line 1	First line of the address.	VARCHAR2(255)	SPRADDR	SPRADDR_STREET_LINE1
STREET_LINE2	Street Line 2	Second line of the address.	VARCHAR2(255)	SPRADDR	SPRADDR_STREET_LINE2
STREET_LINE3	Street Line 3	Third line of the address.	VARCHAR2(255)	SPRADDR	SPRADDR_STREET_LINE3
STREET_LINE4	Street Line 4	Fourth line of the address.	VARCHAR2(255)	SPRADDR	SPRADDR_STREET_LINE4