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 Local Source Local Target
ADDRESS NUMBER Sequence used to identify different addresses within the same address type. NUMBER(2)

FRRGRPI

FRRGRPI_ADDR_SEQNO

NO

NO
ADDRESS_NUMBER   NUMBER       NO
ADDRESS_TYPE Address type associated with grant personnel. VARCHAR2(2)

FRRGRPI

FRRGRPI_ADDR_TYPE

NO

NO
BILL_FORMAT Determines which bills or reports this person's name is printed. VARCHAR2(4)

FRRGRPI

FRRGRPI_BFRM_CODE

NO

NO
BILL_FORMAT_DESC Billing format description VARCHAR2(35)

FRVBFRM

FRVBFRM_DESC

NO

NO
BILL_FORMAT_TYPE Billing format type. (B)ill or (R)eport. VARCHAR2(1)

FRVBFRM

FRVBFRM_TYPE_IND

NO

NO
BILL_FORMAT_TYPE_DESC Billing format type description. VARCHAR2(6)

CALCULATION

DECODE(FRVBFRM_TYPE_IND)

NO

NO
CHART_OF_ACCOUNTS Identifies the chart from other charts in a multi-chart environment. VARCHAR2(1)

FRBGRNT

FRBGRNT_COAS_CODE

NO

NO
CURRENT_DATE System current date (sysdate) or date the data was extracted. DATE

NA

SYSDATE

NO

NO
DOMAIN_VALUE Organization-oriented identifier for the record used to determine access authorization. Institution defined. VARCHAR2(6)

NA

NA

NO

NO
EMAIL_ADDRESS Personnel email address. VARCHAR2(128)

FRRGRPI

FRRGRPI_EMAIL

NO

NO
EMPLOYEE_IND Determines whether person is an employee. VARCHAR2(1)

FRRGRPI

FRRGRPI_EMPLOYEE_IND

NO

NO
FULL_TIME_EQUIVALENCY_PCT Proportion of time that the person spends working on the grant. NUMBER(3,2)

FRRGRPI

FRRGRPI_FTE

NO

NO
GRANT_ID Unique user-defined or system generated one-up number for this grant. VARCHAR2(9)

FRRGRPI

FRRGRPI_GRNT_CODE

NO

NO
MIF_DESC Institution description when the optional multi-institution facility feature has been applied. VARCHAR2(30)

NA

NA

NO

NO
MIF_VALUE Institution value for the record when the optional multi-institution facility feature has been applied. VARCHAR2(6)

NA

NA

NO

NO
ORGANIZATION_CODE Identification accounting code used for the department. VARCHAR2(6)

FRRGRPI

FRRGRPI_ORGN_CODE

NO

NO
PERSONNEL_ACTIVITY DATE Date record was inserted or updated. DATE

FRRGRPI

FRRGRPI_ACTIVITY_DATE

NO

NO
PERSONNEL_ACTIVITY_DATE   DATE       NO
PERSONNEL_SALUTATION User defined preferred salutation. VARCHAR2(35)

FRRGRPI

FRRGRPI_SALUTATION

NO

NO
PERSONNEL_TITLE Personnel title. VARCHAR2(35)

FRRGRPI

FRRGRPI_TITLE

NO

NO
PERSONNEL_TYPE Identifies type of personnel. VARCHAR2(3)

FRRGRPI

FRRGRPI_ID_IND

NO

NO
PERSONNEL_TYPE_DESC Personnel type description. VARCHAR2(35)

FUNCTION

FOKODSF.F_GET_SDAT_TITLE

NO

NO
PERSONNEL_UID System generated, unique, internal identification number assigned to this person. NUMBER(8)

FRRGRPI

FRRGRPI_ID_PIDM

NO

NO
PERSONNEL_USER_ID Unique identification code of the user who entered or last touched the transaction. VARCHAR2(30)

FRRGRPI

FRRGRPI_USER_ID

NO

NO
PHONE_SEQ_NUMBER Sequence number associated with this specific phone type for this person. NUMBER(2)

FRRGRPI

FRRGRPI_TELE_SEQNO

NO

NO
PHONE_TYPE Type of telephone information such as home phone, emergency contact. VARCHAR2(4)

FRRGRPI

FRRGRPI_PHONE_TYPE

NO

NO
ZONE_VALUE Process-oriented identifier for the record used to determine access authorization to this record. Institution defined. VARCHAR2(6)

NA

NA

NO

NO


Ver: