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

SGHE Banner Operational Data Store
Reporting View Target: PLEDGE_KSU

Target Column Business Definition Database Data Type Source Name Source Column
ADMINISTRATIVE_GROUP   VARCHAR2(255)    
CAMPAIGN   VARCHAR2(63)    
CAMPAIGN_NAME   VARCHAR2(255)    
CAMPAIGN_TYPE   VARCHAR2(63)    
CAMPAIGN_TYPE_DESC   VARCHAR2(255)    
CTYP_CODE   VARCHAR2(5)    
DECEASED_DATE   DATE    
DECEASED_STATUS   VARCHAR2(1)    
DESG_ACCOUNT   VARCHAR2(63)    
DESG_ACCOUNT_DESC   VARCHAR2(255)    
DESG_ACCOUNT_INDEX   VARCHAR2(63)    
DESG_ACCOUNT_INDEX_DESC   VARCHAR2(255)    
DESG_ACTIVITY   VARCHAR2(63)    
DESG_ACTIVITY_DESC   VARCHAR2(255)    
DESG_CHART_OF_ACCOUNT   VARCHAR2(63)    
DESG_CHART_OF_ACCOUNT_DESC   VARCHAR2(255)    
DESG_COLLEGE   VARCHAR2(63)    
DESG_COLLEGE_DESC   VARCHAR2(255)    
DESG_DEPARTMENT   VARCHAR2(63)    
DESG_DEPARTMENT_DESC   VARCHAR2(255)    
DESG_FUND   VARCHAR2(63)    
DESG_FUND_DESC   VARCHAR2(255)    
DESG_GENERAL_LEDGER_NUMBER   VARCHAR2(63)    
DESG_GROUP   VARCHAR2(63)    
DESG_GROUP_DESC   VARCHAR2(255)    
DESG_LOCATION   VARCHAR2(63)    
DESG_LOCATION_DESC   VARCHAR2(255)    
DESG_ORGANIZATION   VARCHAR2(63)    
DESG_ORGANIZATION_DESC   VARCHAR2(255)    
DESG_PROGRAM   VARCHAR2(63)    
DESG_PROGRAM_DESC   VARCHAR2(255)    
DESG_STATUS   VARCHAR2(63)    
DESG_STATUS_DESC   VARCHAR2(255)    
DESG_TYPE   VARCHAR2(63)    
DESG_TYPE_DESC   VARCHAR2(255)    
DESG_VSE   VARCHAR2(63)    
DESG_VSE_DESC   VARCHAR2(255)    
DESIGNATION   VARCHAR2(63)    
DESIGNATION_NAME   VARCHAR2(255)    
ENTITY_IND   VARCHAR2(1)    
ENTITY_UID   NUMBER    
EXPECTED_DATE   DATE    
FINANCE_FEED_IND   VARCHAR2(1)    
FISCAL_YEAR   NUMBER    
FISCAL_YEAR_DESC   VARCHAR2(255)    
ID   VARCHAR2(63)    
MATCHING_PLEDGE_COUNT   NUMBER    
MATCHING_PLEDGE_IND   VARCHAR2(1)    
MET_DATE   DATE    
MET_IND   VARCHAR2(1)    
MULTI_SOURCE   VARCHAR2(63)    
MULTI_SOURCE_DESC   VARCHAR2(255)    
NAME   VARCHAR2(94)    
PLEDGE_ACKNOWLEDGED_IND   VARCHAR2(1)    
PLEDGE_ACTIVE_IND   VARCHAR2(1)    
PLEDGE_ADJUSTMENT_IND   VARCHAR2(1)    
PLEDGE_AMOUNT   NUMBER    
PLEDGE_AMOUNT_PAID   NUMBER    
PLEDGE_ANONYMOUS_IND   VARCHAR2(1)    
PLEDGE_BALANCE   NUMBER    
PLEDGE_CATEGORY   VARCHAR2(63)    
PLEDGE_CATEGORY_DESC   VARCHAR2(255)    
PLEDGE_CLASS   VARCHAR2(63)    
PLEDGE_CLASS2   VARCHAR2(63)    
PLEDGE_CLASS3   VARCHAR2(63)    
PLEDGE_CLASS_DESC   VARCHAR2(255)    
PLEDGE_CLASS_DESC2   VARCHAR2(255)    
PLEDGE_CLASS_DESC3   VARCHAR2(255)    
PLEDGE_COMMENT   VARCHAR2(400)    
PLEDGE_CONDITIONAL_IND   VARCHAR2(1)    
PLEDGE_CREDIT   NUMBER    
PLEDGE_DATE   DATE    
PLEDGE_DURATION   VARCHAR2(63)    
PLEDGE_DURATION_DESC   VARCHAR2(255)    
PLEDGE_FULLY_PAID_IND   VARCHAR2(1)    
PLEDGE_INSTALLMENT_IND   VARCHAR2(1)    
PLEDGE_NUMBER   VARCHAR2(63)    
PLEDGE_PARTIAL_PAID_IND   VARCHAR2(1)    
PLEDGE_RANGE   VARCHAR2(63)    
PLEDGE_RANGE_DESC   VARCHAR2(255)    
PLEDGE_REMINDER   VARCHAR2(63)    
PLEDGE_REMINDER_COUNT   NUMBER    
PLEDGE_REMINDER_DATE   DATE    
PLEDGE_REMINDER_DESC   VARCHAR2(255)    
PLEDGE_STATUS   VARCHAR2(63)    
PLEDGE_STATUS_DESC   VARCHAR2(255)    
PLEDGE_TYPE   VARCHAR2(63)    
PLEDGE_TYPE_DESC   VARCHAR2(255)    
PLEDGE_VEHICLE   VARCHAR2(63)    
PLEDGE_VEHICLE_DESC   VARCHAR2(255)    
POST_BATCH_ID   VARCHAR2(63)    
POST_DATE   DATE    
POST_USER   VARCHAR2(63)    
PROCESS_GROUP   VARCHAR2(255)    
RECEIPT_DATE   DATE    
RECEIPT_REQUIRED_IND   VARCHAR2(1)    
REMINDER_FREQUENCY   VARCHAR2(63)    
REMINDER_FREQUENCY_DESC   VARCHAR2(255)    
SEQUENCE_NUMBER   NUMBER    
SOLICITATION_COUNT   NUMBER    
SOLICITATION_TYPE   VARCHAR2(63)    
SOLICITATION_TYPE_DESC   VARCHAR2(255)    
SOLICITOR_FIRST_NAME   VARCHAR2(15)    
SOLICITOR_ID   VARCHAR2(63)    
SOLICITOR_LAST_NAME   VARCHAR2(60)    
SOLICITOR_ORG   VARCHAR2(63)    
SOLICITOR_UID   NUMBER    
TEXT   VARCHAR2(4000)    


Ver: 8.4.1