| Data element |
Definition |
| Account_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 |
| Account_Group_Id Indexed - no
Format - Number
May be Null? Y | The foreign key to the GF_ACCOUNT_GROUP table |
| 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. |
| Account_Id Indexed - yes
Format - Number
May be Null? N | The primary key of the GF_ACCOUNT table, generated by the hibernate sequence. |
| Account_Name Indexed - no
Format - Varchar2(70)
May be Null? Y | The name/description of this combination of COA segments. Account Names will appear in the Distribution screen, to help users identify the account combination |
| Coa_Bc Indexed - no
Format - Varchar2(1)
May be Null? Y | The budget control portion of the Chart of Account |
| Coa_Cnac Indexed - no
Format - Varchar2(3)
May be Null? Y | The CNAC of the account |
| Coa_Cref Indexed - no
Format - Varchar2(4)
May be Null? Y | The Center Ref of the account, may be used to identify Principal Investigator funding |
| Coa_Fund Indexed - no
Format - Varchar2(6)
May be Null? Y | The COA fund of the account |
| Coa_Org Indexed - no
Format - Varchar2(4)
May be Null? Y | The Organization code of the account, used for security |
| Coa_Program Indexed - no
Format - Varchar2(4)
May be Null? Y | The COA Program Code, may be used to track specific student grad groups |
| Distributed Indexed - no
Format - Varchar2(1)
May be Null? Y | A boolean field which is set when this account is used for a distribution fed to GL. The field is set during the ESB flow. 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. |
| Match_Eligible Indexed - no
Format - Varchar2(1)
May be Null? Y | This field set by gl.fund_codes@whse where purpose_code not in ('30','01') Values: T, F |
| Ods_Etl_Update_Dt Indexed - no
Format - Date
May be Null? Y | Date the staging table was updated for this record. |
| Pay_Fees Indexed - no
Format - Varchar2(1)
May be Null? Y | A boolean indicating whether the account reimburses fees. Values: T, F |
| Pay_Health Indexed - no
Format - Varchar2(1)
May be Null? Y | A boolean which indicates if the account reimburses health. Values: T, F |
| Pay_Stipend Indexed - no
Format - Varchar2(1)
May be Null? Y | A boolean which indicates whether the account reimburses stipend. Values: T, F |
| Pay_Tuition Indexed - no
Format - Varchar2(1)
May be Null? Y | A boolean to indicate if the account pays tuition. Valus: T, F |
| Research_Match Indexed - no
Format - Varchar2(1)
May be Null? Y | A boolean which indicates if this account is a research match account. Research match accounts are used to match tuition only for grants with purpose codes of 10 or 12. Values: T, F |
| Stg_Merge_Dt Indexed - no
Format - Date
May be Null? Y | Date the warehouse was last updated for this record. |
| Use_Program Indexed - no
Format - Varchar2(1)
May be Null? Y | The indicator of whether the COA Program Code will be used when distributing money to a student. Each student department record has a program code assigned to link accounts to students. Values: T, F |
| Valid Indexed - no
Format - Varchar2(1)
May be Null? Y | A boolean of whether this account combination was valid after the account was validated against Ben. Accounts will be validated when journals will be created - if an account is invalid, no journals will be processed against it. Values: T, NULL |
| Validation_Date Indexed - no
Format - Timestamp(6)
May be Null? Y | The date the last validation was run. This date will be updated if the account failed validation when journals are created. |
