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

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 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