Reporting View Target: PLEDGE

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.
Recommended Search Columns ENTITY_UID, PLEDGE_NUMBER, SEQUENCE_NUMBER
ENTITY_UID, CONDITION_TYPE
CONDITION_TYPE
PLEDGE_NUMBER

Target Column Business Definition Database Data Type Source Name Source Column

ACTIVITY_DATE Date Pledge Condition was created or last updated. DATE
AGRPCON

AGRPCON_ACTIVITY_DATE

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

NA

CONDITION_COMMENT Comments related to this pledge condition record. CLOB
FUNCTION

GOKODSF.F_TRIM_LONGS

CONDITION_DATE Date the Pledge Condition was met or complied with. DATE
AGRPCON

AGRPCON_MET_DATE

CONDITION_MET Indicates if the Pledge Condition has been met. VARCHAR2(63)
AGRPCON

AGRPCON_MET_IND

CONDITION_MET_DESC Pledge Condition met description. VARCHAR2(255)
CALCULATION

DECODE(AGRPCON_MET_IND)

CONDITION_TYPE Pledge Condition Type Code. VARCHAR2(63)
AGRPCON

AGRPCON_CTYP_CODE

CONDITION_TYPE_DESC Description of the Pledge condition type. VARCHAR2(255)
FUNCTION

ATVCTYP_DESC

ENTITY_IND Indicates whether entity is a person or an organization. VARCHAR2(1)
FUNCTION

MAKFUNC.F_GET_ENTITY_IND

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

AGRPCON_PIDM

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

AGRPCON_EXPECTED_DATE

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

MULTI_SOURCE The institution value for the record when the optional multi-institution facility feature has been installed and applied for this table/column. VARCHAR2(63)
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. VARCHAR2(255)
NA

NA

NAME Name of the person (LFMI) or organization. VARCHAR2(255)
FUNCTION

MGKFUNC.F_GET_PERSON_INFO

PLEDGE_NUMBER Number of the pledge. VARCHAR2(63)
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. VARCHAR2(255)
NA

NA

SEQUENCE_NUMBER Sequence number of the condition of the Pledge. NUMBER
AGRPCON

AGRPCON_SEQ

USER_ID Unique identification code of the user who entered or last touched the transaction. VARCHAR2(63)
AGRPCON

AGRPCON_USER

Ver: 8.5

Description	Contains information pertaining to conditional pledges.
Key & Frequency	One row per pidm per pledge number per sequence number.
Recommended Search Columns	ENTITY_UID, PLEDGE_NUMBER, SEQUENCE_NUMBER ENTITY_UID, CONDITION_TYPE CONDITION_TYPE PLEDGE_NUMBER

Target Column	Business Definition	Database Data Type	Source Name	Source Column
ACTIVITY_DATE	Date Pledge Condition was created or last updated.	DATE	AGRPCON	AGRPCON_ACTIVITY_DATE
ADMINISTRATIVE_GROUP	Administrative-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(255)	NA	NA
CONDITION_COMMENT	Comments related to this pledge condition record.	CLOB	FUNCTION	GOKODSF.F_TRIM_LONGS
CONDITION_DATE	Date the Pledge Condition was met or complied with.	DATE	AGRPCON	AGRPCON_MET_DATE
CONDITION_MET	Indicates if the Pledge Condition has been met.	VARCHAR2(63)	AGRPCON	AGRPCON_MET_IND
CONDITION_MET_DESC	Pledge Condition met description.	VARCHAR2(255)	CALCULATION	DECODE(AGRPCON_MET_IND)
CONDITION_TYPE	Pledge Condition Type Code.	VARCHAR2(63)	AGRPCON	AGRPCON_CTYP_CODE
CONDITION_TYPE_DESC	Description of the Pledge condition type.	VARCHAR2(255)	FUNCTION	ATVCTYP_DESC
ENTITY_IND	Indicates whether entity is a person or an organization.	VARCHAR2(1)	FUNCTION	MAKFUNC.F_GET_ENTITY_IND
ENTITY_UID	System generated, unique, internal identification number assigned to this person or organization entity.	NUMBER	AGRPCON	AGRPCON_PIDM
EXPECTED_CONDITION_DATE	Date the Pledge Condition is expected to be met or complied with.	DATE	AGRPCON	AGRPCON_EXPECTED_DATE
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
MULTI_SOURCE	The institution value for the record when the optional multi-institution facility feature has been installed and applied for this table/column.	VARCHAR2(63)	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.	VARCHAR2(255)	NA	NA
NAME	Name of the person (LFMI) or organization.	VARCHAR2(255)	FUNCTION	MGKFUNC.F_GET_PERSON_INFO
PLEDGE_NUMBER	Number of the pledge.	VARCHAR2(63)	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.	VARCHAR2(255)	NA	NA
SEQUENCE_NUMBER	Sequence number of the condition of the Pledge.	NUMBER	AGRPCON	AGRPCON_SEQ
USER_ID	Unique identification code of the user who entered or last touched the transaction.	VARCHAR2(63)	AGRPCON	AGRPCON_USER