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

SGHE Banner Operational Data Store
Reporting View Target: PROGRAM_ATTRIBUTES

Description Contains a list of all the set codes, attribute types, attribute values, and attribute values begin and end date associated with a program.
Key & Frequency One row per chart of accounts per program per attribute type per attribute value per set code.
Recommended Search Columns CHART_OF_ACCOUNTS, PROGRAM, ATTRIBUTE_TYPE, ATTRIBUTE_VALUE
ATTRIBUTE_TYPE, ATTRIBUTE_VALUE, CHART_OF_ACCOUNTS

Target Column Business Name Business Definition Database Data Type Domain Value Source Name Source Column
ADMINISTRATIVE_GROUP Administrative Group Organization-oriented identifier for the record used to determine access authorization to this record. Institution defined. VARCHAR2(255)  

NA

NA

ATTRIBUTE_TYPE Attribute Type Set code that the attribute types are associated with. VARCHAR2(63)  

FTRPRGA

FTRPRGA_ATTT_CODE

ATTRIBUTE_TYPE_DESC Attribute Type Description Attribute type description associated with the set. VARCHAR2(255)  

FTVATTT

FTVATTT_DESC

ATTRIBUTE_TYPE_STATUS Attribute Type Status Attribute type status associated with the set. VARCHAR2(63)  

FTVATTT

FTVATTT_STATUS_IND

ATTRIBUTE_TYPE_STATUS_DESC Attribute Type Status Description Deciphers a description of the activity status of the attribute type. Values can be Active or Inactive. VARCHAR2(255)  

CALCULATION

DECODE(FTVATTT_STATUS_IND)

ATTRIBUTE_VALUE Attribute Value Code representing one of the values of the attribute type. VARCHAR2(63)  

FTRPRGA

FTRPRGA_ATTV_CODE

ATTRIBUTE_VALUE_BEGIN_DATE Attribute Value Begin Date Date from which this attribute value is valid. DATE  

FTRATTV

FTRATTV_BEGIN_DATE

ATTRIBUTE_VALUE_DESC Attribute Value Description Attribute type value description. VARCHAR2(255)  

FTRATTV

FTRATTV_DESC

ATTRIBUTE_VALUE_END_DATE Attribute Value End Date Date after which this attribute value is not longer valid. DATE  

FTRATTV

FTRATTV_END_DATE

CHART_OF_ACCOUNTS Chart Of Accounts Identifies the chart from other charts in a multi-chart environment. VARCHAR2(63)  

FTRPRGA

FTRPRGA_COAS_CODE

CHART_OF_ACCOUNTS_DESC Chart Of Accounts Description Chart of accounts code description or title. VARCHAR2(255)  

FTVCOAS

FTVCOAS_TITLE

CHART_OF_ACCOUNTS_STATUS Chart Of Accounts Status Status of the chart of accounts. VARCHAR2(63)  

FTVCOAS

FTVCOAS_STATUS_IND

MULTI_SOURCE Multi Source Institution value for the record when the optional multi-institution facility feature has been applied. VARCHAR2(63)  

NA

NA

MULTI_SOURCE_DESC Multi Source Description Institution description when the optional multi-institution facility feature has been applied. VARCHAR2(255)  

NA

NA

PROCESS_GROUP Process Group Process-oriented identifier for the record used to determine access authorization to this record. Institution defined. VARCHAR2(255)  

NA

NA

PROGRAM Program Identification accounting code use to identify the program classification structure or a subset or that structure as defined by the national council of higher education management systems. VARCHAR2(63)  

FTRPRGA

FTRPRGA_PROG_CODE

PROGRAM_DESC Program Description Program code description or title. VARCHAR2(255)  

FTVPROG

FTVPROG_TITLE

PROGRAM_STATUS Program Status Status of the program. VARCHAR2(63)  

FTVPROG

FTVPROG_STATUS_IND

SET_CODE Set Code Code defining a set with which the attribute types are associated. VARCHAR2(63)  

CALCULATION

NVL(FTRPRGA_ATTS_CODE,'NONE')

SET_CODE_DESC Set Code Description Set code description. VARCHAR2(255)  

FTVATTS

FTVATTS_DESC



Ver: 9.0