| Data element |
Definition |
| Allocation_Type_Id Indexed - no
Format - Number
May be Null? Y | Foreign key to the GF_ALLOCATION_TYPE table. |
| BRS_Subcode
Indexed - no
Format - Varchar2(20)
May be Null? Y | Code from the legacy billing system associated with this exemption |
| Coa_Bc Indexed - no
Format - Varchar2(4)
May be Null? Y | Budget Code to be used with this exemption |
| Coa_Cnac Indexed - no
Format - Varchar2(12)
May be Null? Y | CNAC code to be used with this exemption |
| Coa_Cref Indexed - no
Format - Varchar2(16)
May be Null? Y | Center Ref code to be used with this exemption |
| Coa_Fund Indexed - no
Format - Varchar2(24)
May be Null? Y | Fund code to be used with this exemption |
| Coa_Object Indexed - no
Format - Varchar2(16)
May be Null? Y | Object code to be used with this exemption |
| Coa_Org Indexed - no
Format - Varchar2(16)
May be Null? Y | Organization code to be used with this exemption |
| Coa_Program Indexed - no
Format - Varchar2(16)
May be Null? Y | Program code to be used with this exemption |
| Detail_Code Indexed - no
Format - Varchar2(16)
May be Null? Y | Pennant Accounts Detail Code to be used with this exemption |
| Exemption_Code Indexed - no
Format - Varchar2(32)
May be Null? Y | Numeric code which identifies the exemption to be used for the specified school and allocation type (described in the Exemption_Desc).
See explanation in GF_EXEMPTION Table |
| Exemption_Desc Indexed - no
Format - Varchar2(320)
May be Null? Y | The text descriptive name of the exemption, which usually contains an abbreviation of the school and degree that will use the exemption, and whether it is Service or Non-Service. For example:
ED, Ph.D., Non-Service
SW, Other Deg, Service
CGS, Non Degree, Non-Service
etc. |
| Exemption_Id Indexed - yes
Format - Number
May be Null? N | Primary key of the GF_EXEMPTION table. Generated by Hibernate Sequence |
| Legacy_Account Indexed - no
Format - Varchar2(36)
May be Null? Y | Old accounting number, used in the legacy system. |
| Ods_Etl_Update_Dt Indexed - no
Format - Date
May be Null? Y | Date the staging table was updated for this record. |
| Sam_Aid_Id Indexed - no
Format - Varchar2(16)
May be Null? Y | Alpha-numeric code for the AID ID from the Student Aid Management (SAM) system |
| School_Id Indexed - no
Format - Number
May be Null? Y | Foreign key to the GF_SCHOOL table. Indicates the school that uses this exemption |
| Stg_Merge_Dt Indexed - no
Format - Date
May be Null? Y | Date the warehouse was last updated for this record. |
| Type_Of_Student Indexed - no
Format - Varchar2(4)
May be Null? Y | One character code for the type of student for whom this exemption is used.
Values:
C - Certificate or non-degree student
P - PhD student
G - other graduate student
|
