Penn Computing

University of Pennsylvania
Penn Computing << go backback
GF_ACCOUNT_GROUP Table . Tables and Data Elements . Grad Funding Home . Data Warehouse Home

GF_ACCOUNT_GROUP Table - Data Element Index

Select a data element to view its definition and its indexed, format, and null values.

Data element Definition
Account_Group_Id

Indexed - yes
Format - Number
May be Null? N

The primary key of the GF_ACCOUNT_GROUP table, generated by the hibernate sequence.

Account_Group_Name

Indexed - no
Format - Varchar2(60)
May be Null? Y

The Account Group name is a way to categorize Accounts. A set of Account groups are owned by a single org, which allows editing and retirement of this account group.

Active

Indexed - no
Format - Varchar2(1)
May be Null? Y

The indicator on whether an account is active. This is used for managing the account lists. Values: T, F

Entered_By

Indexed - no
Format - Varchar2(8)
May be Null? Y

The Penn ID of the user who created the record

Entered_On

Indexed - no
Format - Date
May be Null? Y

The date the record was created

Last_Edited_By

Indexed - no
Format - Varchar2(8)
May be Null? Y

The Penn ID of the last user who edited the record

Last_Edited_On

Indexed - no
Format - Date
May be Null? Y

The date when the record was last edited.

Ods_Etl_Update_Dt

Indexed - no
Format - Date
May be Null? Y

Date the staging table was updated for this record.

Owning_Org

Indexed - no
Format - Varchar2(4)
May be Null? Y

The organization code which has responsibility for or is the creator of an account group

Stg_Merge_Dt

Indexed - no
Format - Date
May be Null? Y

Date the warehouse was last updated for this record.

GF_ACCOUNT_GROUP Table . Tables and Data Elements . Grad Funding Home . Data Warehouse Home

Questions about this page? Email us at da-staff@isc.upenn.edu

Information Systems and Computing
University of Pennsylvania
Information Systems and Computing, University of Pennsylvania