Go To View:  RETURN TO BANNER COMP META DATA REPORTS LIST
Finance Composite View Reports

Banner Operational Data Store
Composite View Target: AF_GRANT_PERSONNEL

Description Source composite view contains grant personnel and associated information.

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: