Go To View:  RETURN TO BANNER COMP META DATA REPORTS LIST
Finance Composite View Reports

SGHE Banner Operational Data Store
Composite View Target: AF_CLAUSE

Description Contains text lines associated to a clause number.
Key & Frequency One row per clause per each line of text.

ODS Column ODS Business Definition ODS Calculation Formula ODS Data Type Banner Source Name Banner Source Column Banner Form Name
CLAUSE Unique user-defined code used to identify purchasing clauses.    

FOBCLAU

FOBCLAU_CLA_NUM

 
CLAUSE_ACTIVITY_DATE Date information for this record in the table was entered or last updated.    

FORCLAU

FORCLAU_ACTIVITY_DATE

 
CLAUSE_DESC Clause description.    

FOBCLAU

FOBCLAU_DESC

 
CLAUSE_SEQUENCE_NUMBER Sequence number used to order lines of text related to the clause.    

FORCLAU

FORCLAU_TEXT_SEQ_NUM

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

FORCLAU

FORCLAU_USER_ID

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

NA

SYSDATE

 
DOMAIN_VALUE Organization-oriented identifier for the record used to determine access authorization. Institution defined.    

NA

NA

 
MIF_DESC Institution description when the optional multi-institution facility feature has been applied.    

NA

NA

 
MIF_VALUE Institution value for the record when the optional multi-institution facility feature has been applied.    

NA

NA

 
TEXT User-defined text stored for the clause.    

FORCLAU

FORCLAU_TEXT

 
ZONE_VALUE Process-oriented identifier for the record used to determine access authorization to this record. Institution defined.    

NA

NA

 


Ver: 8.3