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

SGHE Banner Operational Data Store
Reporting View Target: PLEDGE_CONDITIONAL

Description Contains information pertaining to conditional pledges.
Key & Frequency One row per pidm per pledge number per sequence number.

ODS Column ODS Business Definition ODS Calculation Formula ODS Data Type Banner Source Name Banner Source Column Banner Form Name
ACTIVITY_DATE Date Pledge Condition was created or last updated.    

AGRPCON

AGRPCON_ACTIVITY_DATE

 
ADMINISTRATIVE_GROUP The institution value of the organization-oriented identifier for the record used to determine access authorization to this record.    

NA

NA

 
CONDITION_COMMENT Comments related to this pledge condition record.    

FUNCTION

GOKODSF.F_TRIM_LONGS

 
CONDITION_DATE Date the Pledge Condition was met or complied with.    

AGRPCON

AGRPCON_MET_DATE

 
CONDITION_MET Indicates if the Pledge Condition has been met.    

AGRPCON

AGRPCON_MET_IND

 
CONDITION_MET_DESC Pledge Condition met description.    

CALCULATION

DECODE(AGRPCON_MET_IND)

 
CONDITION_TYPE Pledge Condition Type Code.    

AGRPCON

AGRPCON_CTYP_CODE

 
CONDITION_TYPE_DESC Description of the Pledge condition type.    

FUNCTION

ATVCTYP_DESC

 
ENTITY_IND Indicates whether entity is a person or an organization.    

FUNCTION

MAKFUNC.F_GET_ENTITY_IND

 
ENTITY_UID System generated, unique, internal identification number assigned to this person or organization entity.    

AGRPCON

AGRPCON_PIDM

 
EXPECTED_CONDITION_DATE Date the Pledge Condition is expected to be met or complied with.    

AGRPCON

AGRPCON_EXPECTED_DATE

 
ID Person's or organization's current identification number.    

FUNCTION

MGKFUNC.F_GET_PERSON_INFO

 
MULTI_SOURCE The institution value for the record when the optional multi-institution facility feature has been installed and applied for this table/column.    

NA

NA

 
MULTI_SOURCE_DESC The institution description for the record when the optional multi-institution facility feature has been installed and applied for this table/column.    

NA

NA

 
NAME Name of the person (LFMI) or organization.    

FUNCTION

MGKFUNC.F_GET_PERSON_INFO

 
PLEDGE_NUMBER Number of the pledge.    

AGRPCON

AGRPCON_PLEDGE_NO

 
PROCESS_GROUP The institution value of the process-oriented identifier for the record used to determine access authorization to this record.    

NA

NA

 
SEQUENCE_NUMBER Sequence number of the condition of the Pledge.    

AGRPCON

AGRPCON_SEQ

 
USER_ID Unique identification code of the user who entered or last touched the transaction.    

AGRPCON

AGRPCON_USER

 


Ver: 8.3