| Attribute |
Entity |
Description |
| Account Allocation PCT |
ACCOUNT INTEREST ACCOUNT |
The percentage of the interest earned to be allocated to the account. |
| Account CDE |
ACCOUNT |
A categorization used to arrange and classify dollars controlled by the university. |
| Account Custodian Type CDE |
ACCOUNT CUSTODIAN TYPE |
A code representing a type of custodian. EXAMPLE: Principal Investigator, Account
Custodian. |
| Account Custodian Type DSC |
ACCOUNT CUSTODIAN TYPE |
A description of an account custodian type. |
| Account ID |
ACCOUNT |
The identifier of the account. |
| Account Long DSC |
ACCOUNT |
The description of the account. |
| Account Object ID |
ACCOUNT OBJECT |
The unique method of identifying an account object code. This is just a surrogate key
instead of all the elements that make up the candidate key. |
| Account Object NME |
ACCOUNT OBJECT |
The name or title of this account object combination. |
| Account Object TXT |
ACCOUNT OBJECT |
The format of an account object number to use for display and printing purposes. |
| Account Short NME |
ACCOUNT |
The name of the account. |
| Accounting Period CDE |
ACCOUNTING PERIOD |
A listing of valid accounting periods, this loosely resembles a calendar month. |
| Accounting Period DSC |
ACCOUNTING PERIOD |
The description of the accounting period. |
| Alpha Abbreviation ID |
ORGANIZATION |
An alphabetic abbreviation, unique to each organization. Can be used in place of the
numeric identifier. |
| Begin DTE |
ACCOUNT |
The creation date of an account. |
| Begin DTE |
FISCAL YEAR |
The first day of a fiscal year. |
| Begin DTE |
INTEREST ALLOCATION CODE |
The date the interest allocation code was/will be effective. |
| Begin DTE |
ORGANIZATION |
The date the organization was officially recognized by the university. |
| Begin DTE |
SPONSOR |
The date this contract or grant starts. |
| Birth DTE |
PERSON |
The person's date of birth. |
| Budget Position Control FLG |
REVENUE EXPENSE ACCOUNT |
Indicates whether or not the account must have a position approved by the budget
office to pay salaries from |
| Budget_Require_FTE_FLG |
REVENUE EXPENSE OBJECT TYPE |
Whether or not an FTE is required to budget money for the object type. This attribute
applies to revenue and expense types which are members of the General Personal Services
object class. |
| Budget_Require_Job_Class_FLG |
REVENUE EXPENSE OBJECT TYPE |
Whether or not a Job Class is required to budget money for the object type. This
attribute applies to revenue and expense types which are members of the General Personal
Services object class. |
| Budgetable FLG |
REVENUE EXPENSE ACCOUNT |
An indicator of whether or not the account is available to be budgeted. |
| Charge CDE |
CHARGE TYPE |
A code defining the type of a charge. EXAMPLE: personal, direct, indirect. |
| Charge DSC |
CHARGE TYPE |
A description of the charge type. |
| Current FLG |
FUND |
An indicator of whether or not the fund is current. |
| Current NME |
PERSON |
The name a person is currently using. Previous names are stored in PERSON NAME
HISTORY. EXAMPLE: When a person marries and assumes their spouse's LAST NAME. |
| Custodian Type Begin DTE |
ACCOUNT CUSTODIAN TYPE |
The begin date of this custodian type. |
| Custodian Type End DTE |
ACCOUNT CUSTODIAN TYPE |
The end date of this custodian type. |
| Debit Credit CDE |
LEDGER TRANSACTION |
A code used to identify the transaction as being a debit or a credit. |
| Deceased FLG |
PERSON |
A flag indicating whether or not the person is deceased. |
| Deficit Due DTE |
BALANCE SHEET ACCOUNT |
The due date upon which the deficit amount is no longer a deficit. |
| Deficit Limit AMT |
BALANCE SHEET ACCOUNT |
Amount of money an account can go over budget. |
| Delete CDE |
DELETE CODE |
A code used to define when the account is to be deleted. |
| Delete DSC |
DELETE CODE |
A description of the delete code. Which year it is to be deleted. |
| Dependant CNT |
EMPLOYEE |
A count of the number of dependents for an employee. |
| DFSR CDE |
DFSR CODE |
Development fund status report code. |
| DFSR DSC |
DFSR CODE |
Development fund status report code description. |
| Display Account TXT |
ACCOUNT |
The format of an account number to use for display and printing purposes. |
| Drop FLG |
ACCOUNT |
An indicator that the account is to be dropped. |
| Earned Income Credit FLG |
EMPLOYEE |
A flag used to identify whether or not the employee has filed a W5 form. |
| End DTE |
ACCOUNT |
The last date transactions are to be registered against an account. |
| End DTE |
FISCAL YEAR |
The last day of a fiscal year. |
| End DTE |
INTEREST ALLOCATION CODE |
The date the interest allocation code is/will no longer be valid. |
| End DTE |
ORGANIZATION |
The date the organization was no longer officially recognized by the university. |
| End DTE |
SPONSOR |
The ending date of this contract or grant. |
| FAS Account NBR |
ACCOUNT |
The old accounting system account number. |
| FAS Account Object NBR |
ACCOUNT OBJECT |
The old account number used in the old accounting system. |
| Federal Withholding FLG |
EMPLOYEE |
A flag used to identify the employee as being subject to federal income tax
withholding. |
| FICA FLG |
EMPLOYEE |
A flag used to define an employee as being subject to FICA tax. |
| First NME |
PERSON |
A person's first given name. |
| Fiscal YR |
FISCAL YEAR |
A listing of the accounting years. |
| Fixed Price FLG |
ACCOUNT |
An indicator that this account can only have fixed priced contracts applied against
it. |
| Freeze FLG |
ACCOUNT |
An indicator that the account has been frozen to future activity. |
| Freeze FLG |
ACCOUNT OBJECT |
A flag used to identify the account as being frozen to new transactions. |
| Fund DSC |
FUND |
The description of the fund type. |
| Fund NBR |
FUND |
An identifier of the fund type. |
| HARCO Card NBR |
PERSON |
A number assigned by the HARCO system. HARCO is the vendor of student identification
validiation hardware and software in use at the university. |
| Interest Allocation CDE |
INTEREST ALLOCATION CODE |
A code used to define how to allocate interest to an account. |
| Interest Allocation DSC |
INTEREST ALLOCATION CODE |
A description of the interest allocation method. |
| International Registration DTE |
PERSON |
The date the person received his or her alien registration number. |
| International Registration NBR |
PERSON |
A number assigned to a person by the government if they are not a US citizen. |
| Last NME |
PERSON |
A person's family (sur-) name. |
| Letter Of Credit AMT |
LETTER OF CREDIT |
The stated amount of this letter of credit. |
| Letter Of Credit DSC |
LETTER OF CREDIT |
The description of this letter of credit. |
| Letter Of Credit NBR |
LETTER OF CREDIT |
The unique identifier of this letter of credit. |
| Mail CDE |
MAIL CODE |
A code used to describe the destination of mail as delivered by mailing bureau. |
| Mail Type CDE |
PERSON MAIL TYPE |
A listing of types of mail a person could be sent. |
| Mail Type DSC |
PERSON MAIL TYPE |
A description of types of mail a person could be sent. |
| Middle NME |
PERSON |
A person's given middle name. |
| Month To Date AMT |
REVENUE EXPENSE LEDGER |
The summation of transactions for the specified period. |
| NACUBO Class CDE |
NACUBO CLASS |
The identifier of the National Association of Colleges and University Business
Officers. |
| NACUBO Class DSC |
NACUBO CLASS |
The description of the NACUBO class. |
| NACUBO Function CDE |
NACUBO FUNCTION |
A code used to define the NACUBO classifications. |
| NACUBO Function DSC |
NACUBO FUNCTION |
A description of the NACUBO functions as NACUBO has defined them. |
| Object CDE |
OBJECT CODE |
A further classification of the account. |
| Object Class CDE |
OBJECT_CLASS |
The code to indentify an object class. For example, ICM for Income, CS for Cost of
Sales, NPS for Non Personal Services, and so forth. |
| Object Class NME |
OBJECT_CLASS |
The Name of the object class. Examples inlcude Income, Cost of Sales, General Personal
Services, and so forth. |
| Object Type CDE |
OBJECT TYPE |
A code used to group accounts into related areas. |
| Object Type Long DSC |
OBJECT TYPE |
A description of the object type. |
| Object Type Short NME |
OBJECT TYPE |
The description of the account object type. |
| Org Structure Type CDE |
ORGANIZATION STRUCTURE TYPE |
A code representing a type of organizational roll-up (Hierarchy). Example: FI =
Financial Roll-up, BU = Budget Roll-up |
| Org Structure Type DSC |
ORGANIZATION STRUCTURE TYPE |
A textual description of an organizational structure (roll-up or hierarchy) code. |
| Organization ID |
ORGANIZATION |
A sequential number assigned by the system to a university organization for the
ppurposes of identification. Each organization across the university has a unique
identifying number. |
| Organization NME |
ORGANIZATION |
The name of the organization (key shop, English department, etc.). |
| Organization Type CDE |
ORGANIZATION TYPE |
A code used to define the various types of an organization. |
| Organization Type DSC |
ORGANIZATION TYPE |
The description of the organization type. |
| Other Ethnic Category NME |
PERSON |
An ethnic category a person indicates he or she is a member of that is not part of the
ETHNIC CATEGORY table. |
| Overhead CDE |
OVERHEAD RATE |
A code used to identify the overhead level for a specific charge. |
| Overhead Class CDE |
OVERHEAD CLASS |
A code used to identify the type of overhead. |
| Overhead Class DSC |
OVERHEAD CLASS |
A description of the overhead class. |
| Overhead RTE |
OVERHEAD RATE |
The rate (as a percentage) that is charged to a given transaction for overhead
purposes. |
| Pension Plan FLG |
EMPLOYEE |
A flag used to identify the employee as belonging to a private pension plan. |
| Person ID |
PERSON |
A sequential number assigned to a person by the system for purposes of identification.
Each individual who has a relationship with the university has a unique identifier. |
| Personal Identification NBR |
PERSON |
A number assigned to a person by the system which he or she uses as verification for
permission to act in the systems. |
| Point In Time AMT |
BALANCE SHEET LEDGER |
The actual transaction amount accumulated at a specific point in time. |
| Posted TS |
LEDGER TRANSACTION |
A time-stamp indicating when the transaction was posted to the account balances. |
| Preferred NME |
PERSON |
The name a person prefers to be referred to as. |
| Project To Date AMT |
REVENUE EXPENSE LEDGER |
The amount of money accumulated for this account from its inception. |
| Restricted FLG |
ACCOUNT |
An indicator that the account has been restricted to further processing against it. |
| Social Security NBR |
PERSON |
The number the government assigns a citizen of the US. |
| Sponsor ID |
SPONSOR |
The identifier of the contract or grant. |
| State Withholding FLG |
EMPLOYEE |
A flag used to identify the employee as being subject to state withholding tax. |
| Statement Type CDE |
STATEMENT TYPE CODE |
A code used to define an account as being a general ledger or subsidiary ledger. |
| Statement Type DSC |
STATEMENT TYPE CODE |
A description of the general ledger/subsidiary ledger code. |
| Sub Fund ID |
SUB FUND |
The identifier of an independent fiscal and accounting entity with a self-balancing
set of accounts. The typical fund is of eight different funds and two groups of accounts.
Each fund is defined by the fund type. |
| Sub Fund NME |
SUB FUND |
The name of the fund. |
| Suffix NME |
PERSON |
A suffix that is appended to the end of a person's name. EXAMPLE: Esquire, III |
| Transaction AMT |
LEDGER TRANSACTION |
The amount of this transaction for this account. |
| Transaction AMT75 |
PAYROLL JOURNAL |
The amount of transaction. |
| Transaction DSC |
LEDGER TRANSACTION |
A textual description of this specific transaction. |
| Transaction TS |
LEDGER TRANSACTION |
The transaction time stamp. |
| VISA Expiration DTE |
EMPLOYEE |
The date this person's visa expires. |
| VISA Original Issue DTE |
EMPLOYEE |
The date this person's visa was issued. |
| Year End Processing CDE |
YEAR END PROCESSING CODE |
The identifier of the type of processing to occur at year end based on a specified
account. |
| Year End Processing DSC |
YEAR END PROCESSING CODE |
The description of the processing code. |
| Year To Date AMT |
REVENUE EXPENSE LEDGER |
The actual amount of transactions accumulated year-to-date. |
