| Updated July, 2001 | ||
| Object Name | Object Description | Defined By |
| ACADEMIC_DISCIPLINE | Code defined nationally to allow for more detailed reporting. Indicates the academic discipline, activity or function associated with a category or sub-category of expenditures within a uniform account structure. (See UAS_CODE). Not valid for every acc | ASD:BIS Team |
| ACCOUNT_GROUP_CODE | Code used to group accounts. An account group code can be associated with many account numbers and offers an easy method for focusing your analysis. An account group codes table is maintained in the General Ledger System by the Accounting Office. Prese | ASD:BIS Team |
| ACCOUNT_GROUP_DESC | Description associated with an account group code. Refer to LU_ACCOUNT_ROLLUP table for complete list of descriptions. | ASD:BIS Team |
| ACCOUNT_GROUP_ROLLUP0_SUB1 | Code built into BIS to allow higher level of grouping accounts. Rollup0_SUB1 is two levels above the account number. Refer to LU_ACCOUNT_ROLLUP table for complete list of valid values. Example: '10001' = Unexpended Plant Funds - Cash | ASD:BIS Team |
| ACCOUNT_GROUP_ROLLUP0_SUB1_DES | Description associated with an account group rollup0_sub1. Refer to LU_ACCOUNT_ROLLUP table for complete list of descriptions. | ASD:BIS Team |
| ACCOUNT_GROUP_ROLLUP0_SUB2 | Code built into BIS to allow higher level of grouping accounts. Rollup0_SUB2 is three levels above the account number. Refer to LU_ACCOUNT_ROLLUP table for complete list of valid values. Example: '1000' = Unexpended Plant Funds - Assets | ASD:BIS Team |
| ACCOUNT_GROUP_ROLLUP0_SUB2_DES | Description associated with an account group rollup0_sub2. Refer to LU_ACCOUNT_ROLLUP table for complete list of descriptions. | ASD:BIS Team |
| ACCOUNT_GROUP_ROLLUP1 | Code built into BIS allowing for a higher level grouping of accounts. Rollup1 is four levels above the account number. Refer to LU_ACCOUNT_ROLLUP table for complete list of valid values and descriptions. Example: '100' = Unexpended Plant Funds | ASD:BIS Team |
| ACCOUNT_GROUP_ROLLUP1_DESC | Description associated with an account group rollup1. Refer to LU_ACCOUNT_ROLLUP table for complete list of descriptions. | ASD:BIS Team |
| ACCOUNT_GROUP_ROLLUP2 | Code built into BIS to allow higher level of grouping accounts. Rollup2 is five levels above the account number. Refer to LU_ACCOUNT_ROLLUP table for complete list of valid values. Example: '10' = Plant Funds Group | ASD:BIS Team |
| ACCOUNT_GROUP_ROLLUP2_DESC | Description for account group rollup2. Refer to LU_ACCOUNT_ROLLUP table for complete list of descriptions. | ASD:BIS Team |
| ACCOUNT_GROUP_ROLLUP3 | Code built into BIS to allow higher level of grouping accounts. Rollup3 is six levels above the account number. Refer to LU_ACCOUNT_ROLLUP table for complete list of valid values. Example: '1' = Balance Sheet Accounts | ASD:BIS Team |
| ACCOUNT_GROUP_ROLLUP3_DESC | Description associated with an account group rollup3. Refer to LU_ACCOUNT_ROLLUP table for complete list of descriptions. | ASD:BIS Team |
| ACCOUNT_NO | Code representing a(n) balance sheet, revenue, or expenditure account. Refer to AFP_ACCOUNT table for complete list of valid values. Example: '100106' = Unexpended Plant Funds Receivable | ASD:BIS Team |
| ACCOUNT_RANGE_FROM | Beginning account number for a given range of accounts constituting a group. Refer to LU_ACCOUNT_RANGE table for complete list of valid values. | ASD:BIS Team |
| ACCOUNT_RANGE_TO | Ending account number for a given range of accounts constituting a group. Refer to LU_ACCOUNT_RANGE table for complete list of valid values. | ASD:BIS Team |
| ACCOUNT_SUB_TYPE | Special code available only in BIS identifying a particular account as a balance sheet, revenue or expenditure account. Note: Correctly classifying recharges as revenue. Normally they are identified as expenditure accounts because they have a sub accoun | ASD:BIS Team |
| ACCOUNT_SUB_TYPE_DESC | Description associated with a specific account sub type. Refer to LU_ACCOUNT_SUB_TYPE table for complete list of descriptions. | ASD:BIS Team |
| ACCOUNT_TITLE | Specific description associated with an account number. Refer to AFP_ACCOUNT table for complete list of valid values. Example: 'Unexpended Plant Funds Receivable' | ASD:BIS Team |
| ACCOUNT_TYPE | Code identifying the type of account. 1 = Balance Sheet, 2 = Revenue, 0 = Expenditure. Note: Recharge accounts are marked as expenditure accounts by this code. Refer to LU_ACCOUNT_TYPE table for complete list of valid values. Example: '0' = Expend | ASD:BIS Team |
| ACCOUNT_TYPE_DESC | Description associated with a specific account type. Refer to LU_ACCOUNT_TYPE table for complete list of descriptions. | ASD:BIS Team |
| ACCOUNTING_DATE | Date a transaction is recognized as opposed to the date the transaction actually occurred. Determines the period in the general ledger to which the transaction is to be posted. Defaulted to 1/1/1900 if not provided by the source system | ASD: BIS Team |
| ACTUAL_SALARY_AMOUNT | Derived amount field offers real salary dollars totalling into account fte. (Except for Provisional Positions where actual salary = annual salary) | ASD:BIS Team |
| ADJUSTED_AMOUNT | Adjusted Budgetary amount. | ASD:BIS Team |
| ADJUSTED_FTE | Adjusted FTE. | ASD:BIS Team |
| AFP_HOME_DEPT_CODE | Code indicating the department or other administrative unit associated with the account number for a distribution as defined in the Account/Fund Profile. | ASD:BIS Team |
| ANNUAL_ACTUAL_AMOUNT | Derived amount field representing actual annual salary for an employee payroll distribution, arrived by multiplying ANNUAL_AMOUNT by PAYROLL_FTE. | ASD:BIS Team |
| ANNUAL_AMOUNT | The full-time annual salary amount allocated to a given employee payroll distribution. (Payroll data element no. 2055-2) | ASD:BIS Team |
| ANNUAL_REPORT_CODE | Code defined locally to group expenditure accounts by function or administrative unit for fiscal year end reporting. Applies to current expenditure accounts only. Used to produce the general ledger system report. Offers organizational hierarchy. Refer | ASD:BIS Team |
| ANNUAL_REPORT_CODE_TITLE1 | Description associated with a specific annual report code. Represents the highest level of aggregation. Refer to LU_ANNUAL_REPORT_CODE table for complete list of descriptions. | ASD:BIS Team |
| ANNUAL_REPORT_CODE_TITLE2 | Description associated with a specific annual report code. Represents the second highest level of aggregation. Refer to LU_ANNUAL_REPORT_CODE table for complete list of descriptions. | ASD:BIS Team |
| ANNUAL_REPORT_CODE_TITLE3 | Description associated with a specific annual report code. Represent the third highest level of aggregation. Refer to LU_ANNUAL_REPORT_CODE table for complete list of description. | ASD:BIS Team |
| ANNUAL_REPORT_CODE_TITLE4 | Description associated with a specific annual report code. Represents the lowest level of aggregation. Refer to LU_ANNUAL_REPORT_CODE table for complete list of descriptions. | ASD:BIS Team |
| ANNUAL_SALARY_AMOUNT | Amount of salary on an annual basis associated with a given employee distribution record or provisional position. | ASD:BIS Team |
| APPT_ACADEMIC_DURATION_STATUS | "Derived description from third character of CTO/OSC code indicating duration status associated with academic appointments. Possible values include Tenure SOE, Non-Tenure regular ranks, Recalled, Visiting, Acting, Adjunct, and Other following CTO rules." | ASD:BIS Team |
| APPT_ACADEMIC_SENATE_STATUS | "Derived description from second character of CTO/OSC code indicating academic senate membership associated with academic appointments. If value = 1 then status is set to SENATE. If not = 1, then status is set to NON-SENATE, which includes student titles. | ASD:BIS Team |
| APPT_BASIS_CODE | Code denoting the service period on which an appointment is based. (See LU_APPOINTMENT_BASIS) Element EDB2010 | Payroll/Personnel |
| APPT_BASIS_DESC | Description associated with code denoting the service period on which an appointment is based. (See LU_APPOINTMENT_BASIS) Element EDB2010 | Payroll/Personnel |
| APPT_BEGIN_DATE | Date on which the employee's appointment is effective. Element EDB2002 | Payroll/Personnel |
| APPT_CAREER_STATUS | Code derived from the APPT_TYPE and third position of the CTO_OSC_CODE; indicates if the appointment is CAREER or NON-CAREER. | ASD:BIS Team |
| APPT_CTO_OSC_CODE | "Code indicating an occupation group to which a title, is assigned for reporting purposes. For Academic titles, each character of the code has specific meaning which has been translated in ACADEMIC GROUP, DURATION STATUS, ACADEMIC SENATE STATUS. TCT1220 | Payroll/Personnel |
| APPT_CTO_OSC_GROUP_CODE | "Code indicating the major occupation group to which a title is assigned for reporting purposes. First character of the CTO/OSC code. For Academic titles, this code known as the Academic Group Code. (See LU_CTO_OSC_GROUP) TCT1220A" | Payroll/Personnel |
| APPT_END_DATE | Date on which an appointment ended or is expected to end. Element EDB2003 | Payroll/Personnel |
| APPT_EXEMPT_STATUS_FLAG | Code indicating whether the section of the Fair Labor Standards Act covering overtime exemption applies to a title code. | Payroll/Personnel |
| APPT_FOC_CODE | "Code indicating the specific job classification in which a title code, associated with the appointment, is included for federal reporting purposes. Same as first character of FOCSUB code. (See LU_FOC_CODE) TCT1230" | Payroll/Personnel |
| APPT_FOCSUB_CODE | Federal Occupation SubCategory. Code indicating the occupational sub-category for specific job classification associated with the appointment. (See LU_FOCSUB_CODE) TCT1240 | Payroll/Personnel |
| APPT_GRADE_LEVEL | "The level, within a salary range, at which the appointment is based. EDB2018" | Payroll/Personnel |
| APPT_HOME_DEPT_CODE | Code indicating the department or other administrative unit associated with the appointment. Element EDB2032 | Payroll/Personnel |
| APPT_HOME_DEPT_DESC | Description associated with code indicating the department or other administrative unit associated with the appointment. | Payroll/Personnel |
| APPT_LEAVE_ACRRUAL_CODE | "Code indicating the vacation and sick leave eligibility, accrual rates, and accrual maximums associated with the appointment. Element EDB2018" | Payroll/Personnel |
| APPT_NO | Number used to identify a given appointment unique to the employee's personnel action form as of the extract date. First digit may be 1 - 9. Second digit is always 0. Element EDB2001 | Payroll/Personnel |
| APPT_OFF_SCALE_CODE | Code indicating relationship of salary to step and range for the title code of the appointment. | Payroll/Personnel |
| APPT_PAID_OVER | The paid over field is used by both appointment type 5 and 7 indicating the number of months over the year which the individuals salary for the appointment is paid. Element EDB2011 | Payroll/Personnel |
| APPT_PAY_RATE | "The full time rate of pay (annual, hourly, or by-agreement amount) associated with the appointment. element EDB2012" | Payroll/Personnel |
| APPT_PAY_SCHEDULE_CODE | Code indicating the pay schedule on which the appointment is paid. (See LU_APPOINTMENT_PAY_SCHEDULE) Element EDB2016 | Payroll/Personnel |
| APPT_PAY_SCHEDULE_DESC | Description of code indicating the pay schedule on which the appointment is based. | Payroll/Personnel |
| APPT_PERCENT_FULL_TIME | Percentage of full-time rate for a given appointment. EDB2012 | Payroll/Personnel |
| APPT_PERSONNEL_PROGRAM | Code identifying the personnel program under which the appointment is held. (See LU_APPOINTMENT_PERSONNEL_PGM) Element EDB2007 | Payroll/Personnel |
| APPT_PERSONNEL_PROGRAM_DESC | Description associated with code identifying the personnel program under which the appointment is held. | Payroll/Personnel |
| APPT_RATE_CODE | "Code indicating the nature of the rate of pay for the appointment. (e.g. Annual, Hourly, By-agreement) (See LU_APPOINTMENT_RATE) Element EDB2015" | Payroll/Personnel |
| APPT_RATE_DESC | "Description associated with code indicating the nature of the rate of pay for the appointment (e.g. Annual, Hourly, By-agreement)." | Payroll/Personnel |
| APPT_REPRESENTATION_CODE | Code indicating whether an appointment is eligible to be represented for collective bargaining purposes. Element EDB2032 | Payroll/Personnel |
| APPT_REPRESENTATION_DESC | "Description of code indicating whether an appointment is eligible to be represented, for collective bargaining purposes." | Payroll/Personnel |
| APPT_TITLE_CODE | Code denoting the position classification associated with an appointment. (See LU_EMPLOYEE_TITLE) Element EDB2006 | Payroll/Personnel |
| APPT_TITLE_DESC | Description of code denoting the position classification associated with an appointment. | Payroll/Personnel |
| APPT_TITLE_UNIT_CODE | Code denoting the collective bargainingh unit to which a title code belongs. (See LU_EMPLOYEE_TITLE_UNIT) Element EDB2029 | Payroll/Personnel |
| APPT_TITLE_UNIT_DESC | Description of code denoting the collective bargainingh unit to which a title code belongs. | Payroll/Personnel |
| APPT_TYPE | Code indicating the type of appointment. Ex. 2 = Career Staff; 5 = Academic. (See LU_APPOINTMENT_TYPE) Element EDB2020 | Payroll/Personnel |
| APPT_TYPE_DESC | Description of code indicating the type of appointment. | Payroll/Personnel |
| APPT_TYPE_GROUP | Code grouping appointment types into 'STAFF' and 'ACADEMIC'. | Payroll/Personnel |
| AWARD_TYPE | Code describing the types of awards or donations of funds to the university for a particular project as agreed to by the sponsor and the university. Valid codes are 1, 2, 3, 4. (System generated when necessary.) Used for auditing and reporting purposes | Payroll/Personnel |
| AWARD_TYPE_DESC | Description associated with a specific award type code. Refer to LU_AWARD_TYPE table for complete list of descriptions. | Payroll/Personnel |
| BALANCE_AMOUNT | The balance amount represents the year to date balance for a given entry. It is defined as: balance_amount = budget_amount + financial_amount + lien_amount For overhead accounts, the year to date budget amount is not defined, and therefore the balance i | Payroll/Personnel |
| BENEFIT_ANNUITANT_HEALTH | UC funded Annuitant benefit amount from the Payroll Personnel System (PPS) | Payroll/Personnel |
| BENEFIT_CORE_LIFE | UC funded Core Life benefit amount from the Payroll Personnel System (PPS) | Payroll/Personnel |
| BENEFIT_CORE_MEDICAL | UC funded Core Medical benefit amount from the Payroll Personnel System (PPS) | Payroll/Personnel |
| BENEFIT_DENT_HLTH_VIS_ANNU | UCOP summary of Annuitant Health, Core Medical, Dental, Health, Legal and Vision benefit amounts | Payroll/Personnel |
| BENEFIT_DENTAL | UC funded Dental benefit amount from the Payroll Personnel System (PPS) | Payroll/Personnel |
| BENEFIT_EMPLOYEE_SUPPORT | UC funded Employee Support benefit amount from the Payroll Personnel System (PPS) | Payroll/Personnel |
| BENEFIT_GRAD_STUDENT_FEE | UC funded Graduate Student Fee benefit amount from the Payroll Personnel System (PPS) | Payroll/Personnel |
| BENEFIT_GRAD_STUDENT_HEALTH | UC funded Graduate Student Health benefit amount from the Payroll Personnel System (PPS) | Payroll/Personnel |
| BENEFIT_GRAD_STUDENT_TUITION | UC funded Graduate Student Tuition benefit amount from the Payroll Personnel System (PPS) | Payroll/Personnel |
| BENEFIT_GROSS_AMOUNT | Total of the UC funded benefit amounts, which include: Retirement Match, OASDI, Medicare, Health, Core Medical, Dental, Vision, Annuitant Health, UC Paid Disability, UC Paid Life Insurance, Core Life Insurance, Legal, Worker’s Compensation, Employee Suppo | Payroll/Personnel |
| BENEFIT_GSTR_IAPOF | UCOP summary of Graduate Student Tuition and IAP Offset benefit amounts | Payroll/Personnel |
| BENEFIT_HEALTH | UC funded Health benefit amount from the Payroll Personnel System (PPS) | Payroll/Personnel |
| BENEFIT_IAP | UC funded IAP benefit amount from the Payroll Personnel System (PPS) | Payroll/Personnel |
| BENEFIT_IAP_LEAVE | UCOP summary of Leave Accrual and IAP benefit amounts | Payroll/Personnel |
| BENEFIT_IAP_OFFSET | UC funded IAP Offset benefit amount from the Payroll Personnel System (PPS) | Payroll/Personnel |
| BENEFIT_LEAVE_ACCRUAL | UC funded Leave Accrual benefit amount from the Payroll Personnel System (PPS) | Payroll/Personnel |
| BENEFIT_LEGAL | UC funded Legal benefit amount from the Payroll Personnel System (PPS) | Payroll/Personnel |
| BENEFIT_LIFE_UCDI_GSFR | UCOP summary of Core Life, Graduate Student Fee, UC Paid Life and UC Paid Disability benefit amounts | Payroll/Personnel |
| BENEFIT_MEDICARE | UC funded Medicare benefit amount from the Payroll Personnel System (PPS) | Payroll/Personnel |
| BENEFIT_OASDI | UC funded OASDI benefit amount from the Payroll Personnel System (PPS) | Payroll/Personnel |
| BENEFIT_OASDI_MEDCR | UCOP summary of OASDI and Medicare benefit amounts | Payroll/Personnel |
| BENEFIT_RETIREMENT_MATCH | UC funded Retirement Match benefit amount from the Payroll Personnel System (PPS) | Payroll/Personnel |
| BENEFIT_UC_PAID_DISIBILITY | UC paid Disability benefit amount from the Payroll Personnel System (PPS) | Payroll/Personnel |
| BENEFIT_UC_PAID_LIFE | UC paid Life Insurance benefit amount from the Payroll Personnel System (PPS) | Payroll/Personnel |
| BENEFIT_UI_GSH | UCOP summary of Unemployment Insurance and Graduate Student Health benefit amounts | Payroll/Personnel |
| BENEFIT_UNEMPLOYMENT_INSURANCE | UC funded Unemployment Insurance benefit amount from the Payroll Personnel System (PPS) | Payroll/Personnel |
| BENEFIT_VISION | UC funded Vision benefit amount from the Payroll Personnel System (PPS) | Payroll/Personnel |
| BENEFIT_WC_ESP | UCOP summary of Workers Compensation and Employee Support benefit amounts | Payroll/Personnel |
| BENEFIT_WORKERS_COMPENSATION | UC funded Worker's Compensation benefit amount from the Payroll Personnel System (PPS) | ASD:BIS Team |
| BUDGET_AMOUNT | Amount representing the total amount of budget dollars associated with a given budget entity. | ASD:BIS Team |
| BUDGET_CONTROL_UNIT | Special code available only in BIS created to identify the control unit having budgetary responsibility for a given account number. | ASD:BIS Team |
| BUDGET_DEPT | Special code available only in BIS created to identify the department having budgetary responsibility for a given account number. | ASD:BIS Team |
| BUDGET_DIVISION | Special code available only BIS created to identify the division having budgetary responsibility for a given account number. | ASD:BIS Team |
| BUDGET_DOCUMENT_NO | Document number authorizing a given budget transaction. | ASD:BIS Team |
| BUDGET_DOCUMENT_SUFFIX | ASD:BIS Team | |
| BUDGET_FTE | Total full time equivalent positions (FTE) permanently budgeted for a given account. | ASD:BIS Team |
| BUDGET_ORGID | ASD:BIS Team | |
| BUDGET_POST_DATE | Date a budget transaction is applied to budget system. | ASD:BIS Team |
| BUDGET_TRANS_CLASS | Code indicating the effect of a specific budget transaction. Valid values are 'I' (increment) or 'A' (adjustment). | ASD:BIS Team |
| BUDGET_TRANS_DESC | Description associated with a specific budget transaction. | ASD:BIS Team |
| BUDGET_TRANS_TYPE | Code classifying the nature of a given budget transaction. For example : Merit Increase, Range Adjustment. | ASD:BIS Team |
| COLLEGE_CODE | Code indicating the school, college or division associated with a given account number. Refer to LU_COLLEGE_CODE table for complete list of valid values and descriptions. Example: '03' = College of Agriculture/Agriculture Science | ASD:BIS Team |
| COLLEGE_DESC | Description associated with a specific college code. Refer to LU_COLLEGE_CODE table for complete list of values and descriptions. | ASD:BIS Team |
| CONTROL_UNIT_ID | Code indicating the administrative entity to which administrative responsibility for an account belongs. Derived from first position of organization id column on AFP (Account Fund Profile). Refer to LU_CONTROL_UNIT table for complete list of valid value | ASD:BIS Team |
| CONTROL_UNIT_NAME | Description associated with a specific control unit code. Refer to LU_CONTROL_UNIT table for complete list of control unit names. | ASD:BIS Team |
| CTO_OSC_CODE | "Code indicating an occupation group to which a title is assigned for reporting purposes. For Academic titles, each character of the code has specific meaning which has been translated in CTO_OSC_GROUP, DURATION STATUS, ACADEMIC SENATE STATUS . TCT1220 | Payroll/Personnel |
| CTO_OSC_DESC | Description associated with the Class Title Outline/Occupation Subcategory code which indicate the primary occupation group a title is assigned for reporting purposes. TCT1220 | Payroll/Personnel |
| CTO_OSC_GROUP_CODE | "Code indicating the major occupation group to which a title is assigned for reporting purposes. First character of the CTO/OSC code. For Academic titles, this code known as the Academic Group Code. (See LU_CTO_OSC_GROUP) TCT1220A" | Payroll/Personnel |
| CTO_OSC_GROUP_DESC | Description associated with the major occupation group which a title is assigned for reporting purposes. TCT1220A | Payroll/Personnel |
| CURRENT_FINANCIAL_AMOUNT | Represents the monthly financial activity for a given entry. | ASD:BIS Team |
| DATA_STEWARD | The campus office most responsible for the maintaining of a specific source of data. Refer to WAREHOUSE_INVENTORY_MASTER table for complete list of valid values. | ASD:BIS Team |
| DATE_ESTABLISHED | Indicates the beginning date of a fund. Used only with Contract and Grant funds. Refer to AFP_FUND table for complete list of valid values. | ASD:BIS Team |
| DATE_LOADED | The date when the data was loaded into the table in BIS. Refer to WAREHOUSE_INVENTORY_MASTER table for complete list of valid values. | ASD:BIS Team |
| DATE_OF_BIRTH | Date of birth for a given university employee. | ASD:BIS Team |
| DEPT_ID | Code indicating the academic or administrative department belonging to a particular control unit and division, for which administrative responsibility for an account lies. Derived from third and forth position of the organizational ID from AFP (Account F | ASD:BIS Team |
| DEPT_NAME | Description associated with a specific department ID code. Refer to LU_DEPARTMENT table for complete list of department names. | ASD:BIS Team |
| DEPT_REPORT_CODE | Code used to group current fund expenditure accounts by administrative unit for reporting purposes. Used to create general ledger system report. Refer to AFP_ACCOUNT table for complete list of valid values. | ASD:BIS Team |
| DESCRIPTION | Text describing a particular entry. Refer to WAREHOUSE_INVENTORY_MASTER table for complete list of descriptions. | ASD:BIS Team |
| DIST_ANNUALIZED_RATE | "Derived amount representing the full-time annual pay rate. Computed as Pay Rate x 174 x 12 for hourly rate types, and Pay Rate times Paid Over for Academic appts. For Staff appts equal to Pay Rate x 12. For by-Agreement rate types equal to the Pay Rate. | ASD:BIS Team |
| DIST_BEGIN_DATE | Date on appointment commenses to be charged against an associated distribution. Element EDB2053 | ASD:BIS Team |
| DIST_DOS_CODE | Code indicating the type of service or type of pay associated with the appointment. Element EDB2056 | Payroll/Personnel |
| DIST_DOS_DESC | Description associated with code indicating the type of service or type of pay associated with the appointment. Element EDB2056 | Payroll/Personnel |
| DIST_END_DATE | Date on appointment ceases to be charged against an associated distribution. Element EDB2054 | ASD:BIS Team |
| DIST_FTE | The percentage of the budgeted position which the distribution represents. Element EDB2051 | ASD:BIS Team |
| DIST_FTE_ANNUALIZED_RATE | Derived amount representing the full-time permenently budgeted annual pay rate. Computed as DIST_ANNUALIZED_RATE * DIST_FTE. | ASD:BIS Team |
| DIST_HOME_DEPT_CODE | Code indicating the department or other administrative unit associated with the account number for a distribution. Element EDB2061 | Payroll/Personnel |
| DIST_PAY_RATE | "The full-time hourly rate, pay period amount, or by agreement amount associated with the distribution. Element EDB2055" | Payroll/Personnel |
| DIST_PERCENT_FULL_TIME | Percentage of full-time rate for a given distribution. | ASD:BIS Team |
| DIST_STEP_LEVEL | "The level, within a salary range, at which the distribution is based." | ASD:BIS Team |
| DISTRIBUTION_LINE_NO | Number identifying a distribution line, a double-sided, balanced accounting transaction that has not been journalized. Carries the lowest level of information usually coded with the general ledger account to which they are eventually posted | ASD: BIS Team |
| DISTRIBUTION_NO | Unique number used to distinguish an employee's payroll distribution from any other distribution for the same employee. The value may be changed from time to time by routine payroll processes. | ASD:BIS Team |
| DIVISION_ID | Code indicating the academic or administrative division belonging to a particular control unit, and for which administrative responsibility for an account lies. In conjuction with Control Unit Id is used to define access rights in BIS through views on th | ASD:BIS Team |
| DIVISION_NAME | Description associated with a specific Division ID. Refer to LU_DIVISION table for complete list of division names. | ASD:BIS Team |
| DOCUMENT_DATE | Represents the date a transaction was posted to the source system of record. | ASD:BIS Team |
| DOCUMENT_NO | Code representing a voucher or a reference number in the case of lien entries associated with a GL transaction. This column represents a lien, reappropriation or financial entry type record. Contains spaces for a balance forward type entry. | ASD:BIS Team |
| DOCUMENT_SUFFIX | Code identifying a lien amount. This column is documented only with lien entries. For all other entries it is always equal to space. | ASD:BIS Team |
| DOS_FULL_DESC | Long description associated with code indicating the type of service or type of pay associated with the appointment. | Payroll/Personnel |
| DOS_HOURS_CODE | Code used to group hours into categories principally for determining productive vs non-productive time. | Payroll/Personnel |
| DOS_PAY_CATEGORY | Code used to group payment types into categories principally for determining Normal vs other type of pay. | Payroll/Personnel |
| EFA_BALANCE_AMOUNT | Represents the inception to date(itd) balance amount, or the balance from the beginning of the project, for a given budget entry. It is defined as: cg_balance_amount = cg_budget_amount + cg_financial_amount + cg_lien_amount | ASD:BIS Team |
| EFA_BUDGET_AMOUNT | Represents the budget amount carried forward from the beginning of the project to the current ledger period (for entries with a type entry '00'), or the monthly budget activity (for entries with a type entry different from '00'). | ASD:BIS Team |
| EFA_FINANCIAL_AMOUNT | Represents the financial amount carried forward from the beginning of the project to the current ledger period (for entries with a type entry '00'), or the monthly financial activity (for entries with a type entry different from '00'). | ASD:BIS Team |
| EFA_LIEN_AMOUNT | Represents the lien amount carried forward from the beginning of the project to the current ledger period (for entries with a type entry '00'), or the monthly lien activity (for entries with a type entry different from '00'). | ASD:BIS Team |
| EFA_PERCENT_SPENT | Represents the percentage of money spent for a given budget entry. It is described as: cg_percent_spent = (cg_budget_amount - cg_balance_amount) / cg_budget_amount * 100 | ASD:BIS Team |
| EFFECTIVE_DATE | The effective date for a specific provision. | ASD:BIS Team |
| EMPLOYEE_CBUC_CODE | Code indicating the collective bargaining unit of an individual. (See LU_EMPLOYEE_CBUC) Element EDB0161 | Payroll/Personnel |
| EMPLOYEE_CBUC_DESC | Description assocated with code indicating the collective bargaining unit of an individual. Element EDB0161 | Payroll/Personnel |
| EMPLOYEE_CITIZEN_STATUS | Code indicating an individuals citizenship status with respect to the United States. (See LU_EMPLOYEE_CITIZEN_STATUS) Element EDB0109 | Payroll/Personnel |
| EMPLOYEE_CITIZEN_STATUS_DESC | Description of code indicating an individuals citizenship status with respect to the United States. Element EDB0109 | Payroll/Personnel |
| EMPLOYEE_DATE_OF_BIRTH | The date on which the person was born. Element EDB0107 | Payroll/Personnel |
| EMPLOYEE_ETHNIC_CODE | Code indicating the ethnic background of an employee. This information will be released only to users belonging to Central Offices. Element EDB0112 | Payroll/Personnel |
| EMPLOYEE_HIRE_DATE | Date on which employee was most recently hired by the University. Element EDB0113 | Payroll/Personnel |
| EMPLOYEE_LAST_ACTION_CODE | "Code indicating the most recent, highest priority, personnel action to be applied to the employee record. (See LU_EMPLOYEE_LAST_ACTION) Element EDB0101" | Payroll/Personnel |
| EMPLOYEE_LAST_ACTION_DATE | The effective date of the last action taken. Element EDB0103 | Payroll/Personnel |
| EMPLOYEE_LAST_ACTION_DESC | "Description of code indicating the most recent, highest priority, personnel action to be applied to the employee record. Element EDB0101" | Payroll/Personnel |
| EMPLOYEE_LOA_BEGIN_DATE | The effective date on which an employee begins a leave of absence. EDB0137 | Payroll/Personnel |
| EMPLOYEE_LOA_RETURN_DATE | The date on which an employee is expected to return from a leave of absence. EDB0138 | Payroll/Personnel |
| EMPLOYEE_LOA_STATUS | Code indicating whether a leave of absence is with or without pay. EDB0154 | Payroll/Personnel |
| EMPLOYEE_LOA_STATUS_DESC | Description of code indicating whether a leave of absence is with or without pay. EDB0154 | Payroll/Personnel |
| EMPLOYEE_LOA_TYPE | Code indicating the type of leave taken b the employee. (See LU_EMPLOYEE_LOA_TYPE) Element EDB0139 | Payroll/Personnel |
| EMPLOYEE_LOA_TYPE_DESC | Description of code indicating the type of leave taken b the employee. Element EDB0139 | Payroll/Personnel |
| EMPLOYEE_NAME | "Name of employee in Last Name, First Name MI format. Element EDB0105" | Payroll/Personnel |
| EMPLOYEE_NEXT_REVIEW_CODE | Code indicating the type of salary review for which a staff appointment is due or eligible on the next salary review date. (See LU_EMPLOYEE_NEXT_REVIEW) Element EDB0135 | Payroll/Personnel |
| EMPLOYEE_NEXT_REVIEW_DATE | Date on which the staff employees next salary review is to occur. Element EDB136 | Payroll/Personnel |
| EMPLOYEE_NEXT_REVIEW_DESC | Description associated with code indicating the type of salary review for which a staff appointment is due or eligible on the next salary review date. Element EDB0135 | Payroll/Personnel |
| EMPLOYEE_NO | Unique identifyer assigned to an employees personnel action form. | Payroll/Personnel |
| EMPLOYEE_RELATIONS_CODE | Code indicating the designation of an individual for purposes of collective bargaining. (See LU_EMPLOYEE_RELATIONS) Element EDB0160 | Payroll/Personnel |
| EMPLOYEE_RELATIONS_DESC | Description associated withcode indicating the designation of an individual for purposes of collective bargaining. Element EDB0160 | Payroll/Personnel |
| EMPLOYEE_RETIREMENT_PLAN | Code indicating the retirement plan of the employee | Payroll/Personnel |
| EMPLOYEE_SEPERATION_CODE | Code indicating the reason for an employees separation from the university. (See LU_EMPLOYEE_SEPARATION) Element EDB0141 | Payroll/Personnel |
| EMPLOYEE_SEPERATION_DATE | Date on which an individuals employment affiliation with the university ends; for most this is the last day compensation is received. Element EDB0140 | Payroll/Personnel |
| EMPLOYEE_SEPERATION_DESC | Description of code indicating the reason for an employees separation from the university. Element EDB0141 | Payroll/Personnel |
| EMPLOYEE_SEX_CODE | Code identifying an employee as male or female. EDB0108 | Payroll/Personnel |
| EMPLOYEE_STATUS | Code indicating an individuals university employment status. (See LU_EMPLOYEE_STATUS) Element EDB0144 | Payroll/Personnel |
| EMPLOYEE_STATUS_DESC | Description associated with code indicating an individuals university employment status. Element EDB0144 | Payroll/Personnel |
| EMPLOYEE_STUDENT_STATUS | Code indicating whether an individual is a UC student. (See LU_EMPLOYEE_STUDENT_STATUS) Element EDB0119 | Payroll/Personnel |
| EMPLOYEE_STUDENT_STATUS_DESC | Description associated with code indicating whether an individual is a UC student. Element EDB0119 | Payroll/Personnel |
| EMPLOYEE_TITLE_CODE | Code used to indicate the position classification for a provision or for an employee's payroll appointment. (Payroll data element no. 2006-8) Refer to LU_EMPLOYEE_TITLE table for complete list of valid values and descriptions. Example: '0014' = SR V | ASD:BIS Team |
| EMPLOYEE_TITLE_DESC | Description associated with a specific employee title code. Refer to LU_EMPLOYEE_TITLE table for complete list of valid values and descriptions. | ASD:BIS Team |
| EMPLOYEE_TITLE_TYPE | Code used to identify the personnel program associated with an employee's payroll title. Refer to LU_EMPLOYEE_TITLE table for complete list of valid values. Example: 'E', 'M' | ASD:BIS Team |
| ENTRY_DESC | Narrative information about the nature or source of a transaction. | ASD:BIS Team |
| EXPENDITURE_ACCOUNT_NO | Represents the actual expenditure account, or an overhead and an intercampus transfer associated to a given expenditure entry. | ASD:BIS Team |
| EXPENDITURE_ACCOUNT_TITLE | Represents the expenditure account title. | ASD:BIS Team |
| EXPENDITURE_TYPE | Represents the type of an expenditure account. Is used to associate overhead and intercampus transfer accounts with an actual expenditure account. Valid values are: 'EXP' for an expenditure account, 'OVHD' for an overhead account, 'MEMO' for an intercam | ASD:BIS Team |
| EXPENSE_SEQUENCE_NO | Derived sequence number coorrelating to the payroll expense line item for a particular payroll compute activity. | ASD:BIS Team |
| EXTRACT_DATE | Indicates the date when data contained in a particular table was extracted from the source system of record. | ASD:BIS Team |
| FACILITIES_LIEN_AMOUNT | The summarized GL encumbrance amount for Object Codes 7150 and 9700. | ASD: BIS Team |
| FED_FLOW_THROUGH_CODE | ASD:BIS Team | |
| FED_FLOW_THROUGH_DESC | ASD:BIS Team | |
| FIN_PREENCUMBRANCE_AMOUNT | Represents Pre Encumbrance amount, which may be positive or negative, depending on which the side of the double-sided balancing transaction it represents | ASD: BIS Team |
| FINANCIAL_AMOUNT | Amount representing the year-to-date total of financial transactions for a given account. | ASD:BIS Team |
| FLSA_STATUS_CODE | Code indicating whether the section of the Fair Labor Standards Act covering overtime exemption applies to a title code. Element TCT1210 | Payroll/Personnel |
| FOC_CODE | Code indicating the specific job classification in which a title code is included for federal reporting purposes. Same as first character of FOCSUB code. (See LU_FOC_CODE) TCT1230 | Payroll/Personnel |
| FOC_DESC | Description associated with code indicating the specific job classification in which a title code is included for federal reporting purposes. TCT1230 | Payroll/Personnel |
| FOCSUB_CODE | Federal Occupation SubCategory. Code indicating the occupational sub-category for specific job classification. (See LU_FOCSUB_CODE) TCT1240 | Payroll/Personnel |
| FOCSUB_DESC | Description associtated with federal occupational subcategory indicating the specific job classification. TCT1240 | Payroll/Personnel |
| FOREIGN_FLAG | Value denoting foreign sponsor: Y = foreign, Blank = domestic | ASD:BIS Team |
| FUNCTION_CODE | Code used to further subdivide expenditure accounts into the major institutional functions they support. These 'budgetary functions' are derived from the first two digits of the account number. Refer to LU_FUNCTION_CODE table for complete list of valid | ASD:BIS Team |
| FUNCTION_DESC | Description associated with a particular function code. Refer to LU_FUNCTION_CODE table for complete list of descriptions. | ASD:BIS Team |
| FUND_GROUP_CODE | Code created and maintained by BIS, used to regroup fund numbers based on the fund ranges as defined by Accounting Services. This code represents the lowest level of fund grouping and is added to the financial tables to facilitate fund source analysis. | ASD:BIS Team |
| FUND_GROUP_DESC | Description associated with a specific fund group code. Refer to LU_FUND_ROLLUP_ACCOUNTING table for complete list of descriptions. | ASD:BIS Team |
| FUND_GROUP_ROLLUP1 | Code identifying the first level of aggregation for fund groups. BIS has developed two distinct 'rollup1' aggregation schemes, customized for financial (accounting view) or managerial (general view) analysis needs. The rollup1 code added to the financia | ASD:BIS Team |
| FUND_GROUP_ROLLUP1_DESC | Describes a particular fund_group_rollup1 code as defined in the Fund Rollup General and Fund Rollup Accounting lookup tables. Refer to LU_FUND_ROLLUP_ACCOUNTING table for complete list of descriptions. | ASD:BIS Team |
| FUND_GROUP_ROLLUP2 | Code identifying a second level of aggregation used for fund groups. BIS has developed two distinct 'rollup2' aggregation schemes, customized for financial (accounting view) or managerial (general view) analysis needs. The rollup2 code represents the hi | ASD:BIS Team |
| FUND_GROUP_ROLLUP2_DESC | Describes a particular fund_group_rollup2 code as defined in the Fund Rollup general and Fund Rollup accounting lookup tables. Refer to LU_FUND_ROLLUP_ACCOUNTING table for complete list of descriptions. | ASD:BIS Team |
| FUND_GROUP_ROLLUP3 | Code identifying a third level of aggregation used for fund groups. The rollup3 code represents the highest level of fund aggregation in the accounting fund rollup scheme. Refer to LU_FUND_ROLLUP_ACCOUNTING table for complete list of valid values. Examp | ASD:BIS Team |
| FUND_GROUP_ROLLUP3_DESC | Describes a particular fund_group_rollup3 code as defined in the Fund Rollup accounting lookup tables. Refer to LU_FUND_ROLLUP_ACCOUNTING table for complete list of descriptions. | ASD:BIS Team |
| FUND_NO | Number defined by the Office of the President and Accounting Services to identify a particular fund. Fund numbers are required for income and expenditure accounts, as well as certain balance sheet and unexpended balances accounts. Refer to AFP_FUND table | ASD:BIS Team |
| FUND_STATUS | Indicates the status of a given fund. Valid values are: 'A' for an active fund, 'F' for a fund for which the final report is submitted. The fund title ends with the string '11F11', 'I' for an inactive or closed fund. The fund title ends with the string ' | ASD:BIS Team |
| FUND_STATUS_DESC | Represents the description of the fund status. | ASD:BIS Team |
| FUND_TITLE | Describes a specific fund number. Refer to AFP_FUND table for complete list of valid values. | ASD:BIS Team |
| FUND_TYPE | This code indicates whether a particular fund is budgeted or non-budgeted. 'B' = Budgeted - permanently budgeted in the adjusted budget. 'N' = Non-budgeted. Refer to LU_FUND_TYPE table for complete list of valid values and descriptions. | ASD:BIS Team |
| FUND_TYPE_DESC | Describes a particular fund type. | ASD:BIS Team |
| FUTR_YR_AMT | Indicates the projected budgeted amount for the next fiscal year. It is not currently maintained in the Budget System. | ASD:BIS Team |
| FUTR_YR_FTE | Indicates the projected budgeted number of FTE (Full Time Equivalent) positions for the next fiscal year. It is not currently maintained in the Budget System. | ASD:BIS Team |
| GRANTING_AGENCY_CODE | ASD:BIS Team | |
| GRANTING_AGENCY_NAME | ASD:BIS Team | |
| GRANTING_SUB_AGENCY_CODE | Indicates the status of a given fund. Valid values are: 'A' for an active fund, 'F' for a fund for which the final report is submitted. The fund title ends with the string '11F11', 'I' for an inactive or closed fund. The fund title ends with the string ' | ASD:BIS Team |
| GRANTING_SUB_AGENCY_NAME | Represents the description of the fund status. | ASD:BIS Team |
| GROUP_CODE | Code allowing regrouping of locations and accounts for different reporting purposes. Used in internal GL processing. Code does not have a description. | ASD:BIS Team |
| HANDLING_CODE | Code allowing regrouping of locations and accounts for different reporting purposes. Used in internal GL processing. Code does not have a description. | ASD:BIS Team |
| HIRING_CODE | Code used by University Personnel as a basis for various types of reporting - including affirmative action and preferential rehire. Thought to be 4 middle digits of Home Dept Code. | ASD:BIS Team |
| HOME_DEPT_ADDRESS | Address assocated with the code indicating the one department or other administrative unit which has coordinating responsibility for an individual's employment and/or pay disposition. | Payroll/Personnel |
| HOME_DEPT_CHANGED_BY | User id of person who last updated the information associated with home dept in the legacy system. Refer to LU_HOME_DEPT table for complete list of valid values. | ASD:BIS Team |
| HOME_DEPT_CODE | Code indicating the one department or other administrative unit which has coordinating responsibility for an individual's employment and/or pay disposition. Element EDB0114 | Payroll/Personnel |
| HOME_DEPT_DESC | Description assocated with the code indicating the one department or other administrative unit which has coordinating responsibility for an individual's employment and/or pay disposition. | Payroll/Personnel |
| HOME_DEPT_FULL_DESC | Long description assocated with the code indicating the one department or other administrative unit which has coordinating responsibility for an individual's employment and/or pay disposition. | Payroll/Personnel |
| HOME_DEPT_LAST_CHANGED | Date home dept information was last changed in the legacy system. Refer to LU_HOME_DEPT table for complete list of valid values. | ASD:BIS Team |
| HOME_DEPT_NAME | Name associated with a given home dept. Refer to LU_HOME_DEPT table for complete list of valid names. | ASD:BIS Team |
| INITIAL_AMOUNT | Contains the budgeted amount for a particular account-fund-sub as of the beginning of the fiscal year (July 1st). This amount represents the budget amount in a GL transaction of type entry '11' associated with the account-fund-sub. | ASD:BIS Team |
| INITIAL_FTE | Contains the budgeted number of FTE (Full Time Equivalent) positions for a particular account-fund-sub as of the beginning of the fiscal year (July 1st). | ASD:BIS Team |
| INITIAL_LEDGER_MONTH | Indicates the month an entry was originally posted to the general ledger system. | ASD:BIS Team |
| INITIAL_LEDGER_YEAR | Indicates the year an entry was originally posted to the general ledger system. | ASD:BIS Team |
| INVOICE_DATE | Invoice date assigned by the vendor. | ASD: BIS Team |
| INVOICE_ENTRY_DATE | Invoice date when the voucher is entered into the BFS system. | ASD:BIS Team |
| INVOICE_NO | Number uniquely identifying an invoice. | ASD:BIS Team |
| INVOICE_STATUS_DESC | Description that identifies an invoice status as Approved, Hold or Pending. | ASD:BIS Team |
| INVOICE_TAX_CODE | Tax code associated with an invoice. Example values are 2, 3, 5, A. | ASD:BIS Team |
| INVOICE_TYPE_DESC | Description that identifies an invoice as Batch, Foreign Adjustment, PO Voucher, Regular Adjustment (Debit or Credit), Voucher (Express or Regular), Zero Adjustment. | ASD:BIS Team |
| ITD_BALANCE_AMOUNT | Represents the inception-to-date balance amount from the beginning of the project, for a given budget entry. | ASD:BIS Team |
| ITD_BUDGET_AMOUNT | Represents the inception-to-date budget amount from the beginning of the project, for a given budget entry. | ASD:BIS Team |
| ITD_FINANCIAL_AMOUNT | It represents the inception to date (itd) financial amount, or the financial amount from the beginning of the project, for a given budget entry. | ASD:BIS Team |
| ITD_LIEN_AMOUNT | Represents the inception-to-date lien amount from the beginning of the project, for a given budget entry. | ASD:BIS Team |
| ITD_PERCENT_SPENT | Represents the inception-to-date percent of funds spent from the beginning of the project, for a given budget entry. | ASD:BIS Team |
| ITEM_DESC | Description associated with a requisition line. Note: Also named TRANSACTION_ITEM_DESC is some tables where it provides the description associated with a requisition, PO or invoice. | ASD: BIS Team |
| JOURNAL_DATE | Date journal was generated. Determines the period to which a journal is posted. The date is defaulted to 1/1/1900 if not provided by the source system. | ASD: BIS Team |
| JOURNAL_ID | Code identifying a journal, a batch of accounting entries. Example: ‘PREENC’, ‘PREENC_CLO’, ‘PRENC_REV’. Refer to JOURNAL_ID_DESC for description mappings. Note: Also named TRANSACTION_TYPE in some tables that include pre-encumbrances, encumbrances and | ASD: BIS Team |
| JOURNAL_ID_DESC | Description associated with Journal_ID. Example: ‘PRENC’ = ‘PRE ENCUMBRANC’, ‘PRENC_CLO’ = ‘PRE ENCUMBRANCE CLOSURE’, ‘PRENC_REV’ = ‘PRE ENCUMBRANCE REVERSAL’ | ASD: BIS Team |
| LIEN_AMOUNT | Represents the dollar amount for an order of goods or services that should be charged temporarily against one account and fund combination until the actual invoice is received, paid and charged appropriately. Temporarily holds the funds in reserve (or en | ASD:BIS Team |
| LOCATION_CODE | One character code assigned to each U.C. campus. For Berkeley, '1' indicates accounts recording campus activities, and 'J' accounts recording activities under the Office of the President. Refer to LU_LOCATION_CODE table for complete list of valid values | ASD:BIS Team |
| LOCATION_DESC | Description for a particular location code. Refer to LU_LOCATION_CODE table for complete list of descriptions. | ASD:BIS Team |
| MONTHLY_AMOUNT | The full-time pay period amount associated with an employee payroll distribution. (Payroll data element no. 2055-2) | ASD:BIS Team |
| MTD_FINANCIAL_AMOUNT | Amount representing the monthly-to-date total of financial transactions for a given account. | ASD:BIS Team |
| NSF_CODE | Code denoting the National Science Foundation funding agency. | ASD:BIS Team |
| NSF_CODE_DESC | National Science Foundation funding agency name. | ASD:BIS Team |
| OBJECT_CODE | Code classifying the type of an expenditure transaction for fund balance account or capital asset number for construction account. Both object code and transaction code tables are maintained by the Accounting Office. Refer to LU_OBJECT_CODE table for co | ASD:BIS Team |
| OBJECT_DESC | Describes a particular object code. Object codes and descriptions are defined by Accounting Services. Refer to LU_OBJECT_CODE table for complete list of valid values and descriptions. Example: 'WAGES - STAFF' for OBJECT_CODE 1100 | ASD:BIS Team |
| OBJECT_GROUP_CODE | Code created and assigned in BIS for higher level of grouping of object codes for reporting and analysis purposes. The object code grouping is based on the codes defined in the campus Accounting manuals. Refer to LU_OBJECT_ROLLUP table for complete list | ASD:BIS Team |
| OBJECT_GROUP_DESC | Description associated with object group code for using on reports. Refer to LU_OBJECT_ROLLUP table for complete list of descriptions. | ASD:BIS Team |
| OBJECT_GROUP_ROLLUP1 | Code created and assigned in BIS defining a higher level of object code aggregation used for reporting and analysis purposes. (The rollup1 code represents the highest level of aggregation currently available in BIS) Refer to LU_OBJECT_ROLLUP table for co | ASD:BIS Team |
| OBJECT_GROUP_ROLLUP1_DESC | Describes a particular object_group_rollup1. Refer to LU_OBJECT_ROLLUP table for complete list of descriptions. | ASD:BIS Team |
| OBJECT_NAME | Describes the technical name of a BIS object. Example: name of a table, GL_MONTH1_DETAIL, BSL_MONTH1_SUMMARY, LU_OBJECT_CODE, .... Refer to WAREHOUSE_INVENTORY_MASTER table for actual values. | ASD:BIS Team |
| ORGID_CODE | Composite code identifying an academic or administrative entity to which an account belongs. Format: CDddxxxx, where: 'C' is the control unit, 'D' the division id, 'dd' the department code, and 'xxxx' a further subdivisions of the organizational unit, u | ASD:BIS Team |
| ORGID_POSITION_5 | Optional code used at the discretion of the control unit. Derived from the fifth position of organization id code on AFP. Example: For L&S, it indicates a Functional Unit (administrative unit, instructional unit, student services unit, ...). For BAS, it | ASD:BIS Team |
| ORGID_POSITION_6 | Optional code indicating a further subdivision of the organizational unit. Used at the discretion of a particular control unit. Example: L&S uses it to describe the activity in the account ('E' = permanent academic salaries, 'F' = departmment operating | ASD:BIS Team |
| ORGID_POSITION_7_8 | Optional code indicating a further subdivision of the organizational unit intended to be used at the discretion of a particular control unit. Refer to AFP_ACCOUNT table for actual values. | ASD:BIS Team |
| OUTSTANDING_AMOUNT | Outstanding monetary balance associated with a requisition or PO or monetary amount of vouchers since the last GL accounting cycle. | ASD:BIS Team |
| OUTSTANDING_ENCUMB_AMOUNT | Outstanding monetary balance associated with a PO. | ASD:BIS Team |
| OUTSTANDING_PREENCUMB_AMOUNT | Outstanding monetary balance associated with a requisition. | ASD:BIS Team |
| OUTSTANDING_VOUCHER_AMOUNT | Monetary amount of vouchers since the last GL accounting cycle. | ASD:BIS Team |
| OVERHEAD_CODE | Code used to identify the different types of expenditures that can be charged directly to a contract and grant fund upon which charges for general operating costs are prorated. Refer to LU_OVERHEAD_CODE table for complete list of valid values. Used only | ASD:BIS Team |
| OVERHEAD_CODE_DESC | Description associated with a specific overhead code. Refer to LU_OVERHEAD_CODE table for complete list of descriptions. | ASD:BIS Team |
| OVERHEAD_RATE | Represents the rate of overhead charge associated with a table entry. Used only with Contract & Grant table entries. | ASD:BIS Team |
| PAF_HOME_DEPT_CODE | Code indicating the one department or other administrative unit which has coordinating responsibility for an individual's employment and/or pay disposition. Element EDB0114 | Payroll/Personnel |
| PAF_HOME_DEPT_DESC | Description assocated with the code indicating the one department or other administrative unit which has coordinating responsibility for an individual's employment and/or pay disposition. Element EDB0114 | Payroll/Personnel |
| PARENT_UNIT_ID | Code uniquely available in BIS allowing grouping of control units for administrative reporting purposes. Example: The Vice Chancellor, College of Letters and Sciences, and Professional Schools and Colleges belong to the same parent unit. Refer to LU_PA | ASD:BIS Team |
| PARENT_UNIT_NAME | Description associated with a specific parent unit code. Refer to LU_PARENT_UNIT table for complete list of descriptions. | ASD:BIS Team |
| PAY_END_DATE | Date through which an employee payroll distribution is authorized. (Payroll data element no. 2054-1) | ASD:BIS Team |
| PAYMENT_METHOD | Code defined by the Office of the President representing the manner in which federal contract and grant funds are paid to the University. Refer to LU_PAYMENT_METHOD table for complete list of valid values. Descriptions unavailable. | ASD:BIS Team |
| PAYMENT_METHOD_DESC | Description associated with a specific payment method code. Refer to LU_PAYMENT_METHOD table for complete list of descriptions. | ASD:BIS Team |
| PAYROLL_APPT_TYPE | Code indicating the type of appointment. Ex. 2 = Career Staff; 5 = Academic. (See LU_APPOINTMENT_TYPE) Element EDB2020 | Payroll/Personnel |
| PAYROLL_APPT_TYPE_DESC | Description of code indicating the type of appointment. | Payroll/Personnel |
| PAYROLL_CYCLE_CODE | The cycle during which the payroll compute activity for the individual occurred. | Payroll/Personnel |
| PAYROLL_CYCLE_DESC | Description of the cycle during which the payroll compute activity for the individual occurred. Element PAR1970 | Payroll/Personnel |
| PAYROLL_CYCLE_END_DATE | "Indicates the dates associated with the different monthly computes corresponding to the different Payroll cycles: Monthly, Semi-monthly, Special." | Payroll/Personnel |
| PAYROLL_DISTRIBUTION_NO | Unique number used to distinguish an employee's payroll distribution from any other distribution for the same employee. The actual value may change from time to time. (Payroll data element no. 2041-1) | ASD:BIS Team |
| PAYROLL_DOS_CODE | Code indicating the type of service or type of pay associated with the earnings distribution. Element PAR3870 | Payroll/Personnel |
| PAYROLL_DOS_DESC | Description associated with code indicating the type of service or type of pay associated with the earnings distribution. Element PAR3870 | Payroll/Personnel |
| PAYROLL_FTE | Percent of one full-time budgeted position associated with an employee payroll distribution. (100% is represented as 1.00) (Payroll data element no. 2051-8) | ASD:BIS Team |
| PAYROLL_GROSS_AMOUNT | The total dollar amount of an earnings distribution. Element PAR3990 | Payroll/Personnel |
| PAYROLL_HOURLY_RATE | "The full-time hourly rate, pay period amount, or by agreement amount associated with the expense distribution. PAR3260" | Payroll/Personnel |
| PAYROLL_HOURS_WORKED | The total of all earnings distribution hours for the type of hours attributed to the specific DOS code. (See LU_DOS) Element PAR2246 | Payroll/Personnel |
| PAYROLL_MONTHLY_AMOUNT | Full-time hourly rate, pay period amount, or by agreement amount for an employee's payroll distribution. (Payroll data element no. 2055-2) | ASD:BIS Team |
| PAYROLL_MONTHLY_RATE | "The full-time monthly rate, pay period amount, or by agreement amount associated with the expense distribution. " | Payroll/Personnel |
| PAYROLL_PERCENT_FULL_TIME | The percent of time of an earnings distribution that an individual was on pay status during a pay period. Element PAR4000 | Payroll/Personnel |
| PAYROLL_PERIOD_END_DATE | The end date of the pay period during which an earnings distribution amount was earned. Element PAR3750 | Payroll/Personnel |
| PAYROLL_PERSONNEL_PROGRAM | Code identifying the personnel program under which the appointment is held. (See LU_APPOINTMENT_PERSONNEL_PGM) Element EDB2007 | Payroll/Personnel |
| PAYROLL_RATE_DESC | Description associated with the payroll rate type. PAR3300 | Payroll/Personnel |
| PAYROLL_RATE_TYPE | "Code indicating whether the associated distribution is an hourly rate or a pay period rate (A/B=pay period, H=hourly). Element PAR3300" | Payroll/Personnel |
| PAYROLL_SERVICE_DESC | Code used to indicate the service or type of pay for an employee's appointment. (Payroll data element no. 2056-3) | ASD:BIS Team |
| PAYROLL_TITLE_CODE | Code indicating the position classification associated with the earnings distribution. (See LU_EMPLOYEE_TITLE) Element PAR3846 | Payroll/Personnel |
| PAYROLL_TITLE_DESC | Description of code denoting the position classification associated with an earning distribution. Element EDB2006 | Payroll/Personnel |
| PAYROLL_TITLE_UNIT_CODE | Code indicating the title unit code of the predominant appointment of an individual for collective bargaining purposes (see LU_TITLE_UNIT). Element PAR2172 | Payroll/Personnel |
| PAYROLL_TRANSACTION_CODE | Code assigned to a payroll audit record for processing purposes. Element PAR0280 | Payroll/Personnel |
| PAYROLL_TRANSACTION_DESC | Description assocated with code assigned to a payroll audit record. Element PAR0280 | Payroll/Personnel |
| PERSONNEL_PROGRAM | Code identifying the personnel program under which the appointment is held. (See LU_APPOINTMENT_PERSONNEL_PGM) Element EDB2007 | Payroll/Personnel |
| PLANT_ACCOUNT_NO | Code used with Plant accounts. State Funds may be assigned by the State to different projects identified by account numbers. Refer to AFP_ACCOUNT_FUND_SUB table for valid values. | ASD:BIS Team |
| PO_DATE | Date a purchase order, a written authorization for a vendor to provide a product or service at a specified price, was generated. The date is defaulted to 1/1/1900 if not provided by the source system | ASD: BIS Team |
| PO_ID | Code identifying a purchase order, a written authorization for a vendor to provide a product or service at a specified price | ASD: BIS Team |
| PO_LINE_NO | Number uniquely identifying each line of a PO. | ASD:BIS Team |
| PO_REFERENCE | Reference description for a PO. | ASD:BIS Team |
| POST_DATE | Date a specific budgetary transaction was posted to the budget system. | ASD:BIS Team |
| POSTED_TOTAL_AMOUNT | ASD:BIS Team | |
| PREENCUMBRANCE_TYPE | Code describing the type of Pre Encumbrance. Values include ‘PRE ENCUMBRANCE’ and ‘SOFT LIEN’. | ASD: BIS Team |
| PREV_YR_ADJ_AMT | The adjusted budgeted amount from the previous fiscal year. | ASD:BIS Team |
| PREV_YR_ADJ_FTE | The adjusted FTE (Full Time Equivalent) from the previous fiscal year. Refer to BSL_FY1995_INIT_ADJ_BUDG_VIEW table for complete list of valid values. | ASD:BIS Team |
| PRIMARY_LOCATION_CODE | Derived indicating the campus an individual employee is primarily associated with. If first three characters of employees home department is '389' then primary location code = J (systemwide) otherwise it is set to 1 (Local - Berkeley). | Payroll/Personnel |
| PRIMARY_TITLE_CODE | The title code associated with the predominate appointment for the employee. Based on specific set of criteria embedded within Payroll/Personnel system. (See LU_EMPLOYEE_TITLE) Element EDB0460 | Payroll/Personnel |
| PRINCIPLE_INVESTIGATOR | Identifies the person, often an academician, with primary responsibility for the project for which a fund was designated. Used with Contract and Grants, Gifts, and Endowment funds. | ASD:BIS Team |
| PROCESS_MONTH | The calendar month when the source data in a BIS table was produced within the originating computer system. Example: '02'= February | ASD:BIS Team |
| PROCESS_YEAR | The calendar year when the source data in a BIS table was produced within the originating computer system. Example: 1998 | ASD:BIS Team |
| PROJECT_SITE_CODE | One character code indicating whether or not a project is considered on or off campus. A project is considered off campus if it pays its own rent. System generated when necessary. Refer to AFP_FUND table for complete list of valid values. | ASD:BIS Team |
| PROJECT_SITE_DESC | Description of project_site_code (on or off campus). | ASD:BIS Team |
| PROVISION_AMOUNT | The total annual pay amount for all FTE for a specific provision. | ASD:BIS Team |
| PROVISION_DESC | Description associated with a specific provision. | ASD:BIS Team |
| PROVISION_FTE | The number of FTE (full-time-equivalent employee count) associated with a specific provision. (1.00 indicates 100%) | ASD:BIS Team |
| PROVISION_NO | Number used to identify a specific provision. | ASD:BIS Team |
| PROVISION_RATE | The monthly pay amount for each 1.00 FTE for a specific provision. | ASD:BIS Team |
| PROVISION_TYPE | One character describing the type of a specific provision. Valid values are: 'R' - Regular , 'S' - Stipend | ASD:BIS Team |
| RATE_CODE | Code indicating the nature of the rate of pay for the employee payroll appointment. (Payroll data element no. 2015-4) Code interpretation: A - Annual, B - By-Agreement, H - Hourly | Payroll System |
| RECORDING_NO_PREFIX | Code related to general ledger system recording number database. Refer to AFP_ACCOUNT table for complete list of valid values. | ASD:BIS Team |
| REFERENCE_NO | Code used as an alternate identification of accounts. It can be an item number within a purchase order, or an invoice number, or a check number. This field is documented each time the record represents a lien entries. Contains spaces for a balance forwa | ASD:BIS Team |
| REPORT_ORDER | Sorting order for presenting fund groups. Refer to LU_FUND_ROLLUP_GENERAL table for complete list of valid values. | ASD:BIS Team |
| REQUISITION_DATE | Date a requisition, a request to purchase a product or service, was generated. The date is defaulted to 1/1/1900 if not provided by the source system | ASD: BIS Team |
| REQUISITION_DEPT_ID | Code identifying the department associated with a requisition line. Note: Also named TRANSACTION_PROECESSING_UNIT_ID in some tables where it provides the description associated with a requisition, PO or invoice. | ASD: BIS Team |
| REQUISITION_ID | Code identifying a requisition, a written request to purchase products or services. A requisition is made up of multiple requisition lines | ASD: BIS Team |
| REQUISITION_LINE_NO | Number uniquely identifying each line of a requisition | ASD: BIS Team |
| RESTRICTION_CODE | Code used only with Endowment funds representing type of restriction placed on the use of income earned by an endowment or similar type fund. The first 2 digits indicate the specific restriction placed on the fund. The second 2 digits specifiy the purpo | ASD:BIS Team |
| RESTRICTION_CODE_DESC | Description associcated with a specific restriction code. Refer to LU_RESTRICTION_CODE table for complete list of descriptions. | ASD:BIS Team |
| RESTRICTION_TYPE | A code indicating if a fund can be used for any operating purpose or is subject to special restrictions established by external agencies or the Regents. 'R' = Restricted - fund may only be utilized in accordance with the purposes established by the sourc | ASD:BIS Team |
| RESTRICTION_TYPE_DESC | Description associated with a specific restriction type. Refer to LU_RESTRICTION_TYPE table for complete list of descriptions. | ASD:BIS Team |
| RETENTION | The length of time that BIS retains the data in a given table. Refer to WAREHOUSE_INVENTORY_MASTER table for actual values. | ASD:BIS Team |
| ROW_COUNT | The number of rows (records) in a specific BIS table. Refer to WAREHOUSE_INVENTORY_DETAIL table for complete list of valid values. | ASD:BIS Team |
| SAU_CODE | Code indicating the particular systemwide unit responsible for administering a systemwide account. (Example: Office of the President, Division of Agricultural & Natural Resource, ...) Refer to LU_SAU_CODE table for complete list of valid values. Examp | ASD:BIS Team |
| SAU_CODE_DESC | Description associated with a specific SAU code. Refer to LU_SAU_CODE table for complete list of descriptions. | ASD:BIS Team |
| SCHEDULE_NO | Number identifying the requisition schedule associated with a requisition line | ASD: BIS Team |
| SERVICE_DESC | Description of service code, indicating the type of service or type of pay associated with an employee payroll appointment. (Payroll data element no. 2056-3) For code interpretation, refer to the payroll description of service (DOS) table. | Payroll System |
| SEX | Code indicating the gender of an employee. Valid values are 'M' = Male and 'F' = Female. | ASD:BIS Team |
| SOURCE_FILE | The name of the computer file in the source computer system used to populate the table in BIS. Refer to WAREHOUSE_INVENTORY_DETAIL table for complet list of valid values. | ASD:BIS Team |
| SPONSOR_CATEGORY | Code indicating the type of organization sponsoring the fund and required for funds 20600-33999 and 39300-59999. Used on Contract and Grants, Gifts, and Endowment funds. Valid codes are 01-11. Refer to LU_SPONSOR_CATEGORY table for complete list of val | ASD:BIS Team |
| SPONSOR_CATEGORY_DESC | Describes the sponsor category. Refer to LU_SPONSOR_CATEGORY table for complete list of descriptions. | ASD:BIS Team |
| SPONSOR_CODE | Code associated with individual organization sponsor name | ASD:BIS Team |
| SPONSOR_NAME | Name of the individual organization sponsoring the funds | ASD:BIS Team |
| SUB_ACCOUNT_NO | Expenditure accounts of current funds and plant funds are broken down by sub account, which represents the general class of the expenditure within a specific account. Provides a finer granularity for tracking use of funds. Refer to LU_SUB_ACCOUNT table | ASD:BIS Team |
| SUB_ACCOUNT_TITLE | Description associated with a specific sub account number. Refer to LU_SUB_ACCOUNT table for complete list of valid values. Example: '1' = General Campus | ASD:BIS Team |
| SUB_CAMPUS_DESC | Description associated with a specific sub campus id. Refer to LU_SUB_CAMPUS table for complete list of descriptions. | ASD:BIS Team |
| SUB_CAMPUS_ID | Code indicating the university organizational category associated with a budgeted account. Refer to LU_SUB_CAMPUS table for complete list of valid values and descriptions. Example: '1' = General Campus | ASD:BIS Team |
| TERMINATION_DATE | Indicates termination date of a fund. Date after which the fund will no longer be valid. Used only with Contract and Grant funds. Refer to AFP_FUND table for complete list of valid values. | ASD:BIS Team |
| TITLE_ALL_FLAG | Code indicating whether a title will have one set of rates applicable to all employees or two sets for covered and uncovered employee for collective bargaining. | Payroll/Personnel |
| TITLE_CODE | Code denoting the position classification associated with an appointment. (See LU_EMPLOYEE_TITLE) Element EDB2006 | Payroll/Personnel |
| TITLE_DESC | Description of code denoting the position classification associated with an appointment. Element EDB2006 | Payroll/Personnel |
| TITLE_LAST_UPDATED | Date upon which this title code information was last updated. | Payroll/Personnel |
| TITLE_LINKAGE_CODE | "Code used to indicate group of titles that have similarity of job content, or physical or organizational proximity, or similarity of job responsibility or career pathing. Element TCT1360" | Payroll/Personnel |
| TITLE_UNIT_CODE | Code denoting the collective bargainingh unit to which a title code belongs. (See LU_EMPLOYEE_TITLE_UNIT) Element EDB2029 | Payroll/Personnel |
| TITLE_UNIT_DESC | Description associated with a title unit code. Element EDB2029 | Payroll/Personnel |
| TRANS_AMOUNT | Dollar amount of a specfic transaction entry. | ASD:BIS Team |
| TRANS_CLASS | Code indicating nature of a specific budget transaction. Valid values are: 'A' = Adjustment, 'I' = Increment. Refer to LU_TRANS_CLASS table for complete list of valid values and descriptions. | ASD:BIS Team |
| TRANS_CLASS_DESC | Description associated with a specific transaction class. Refer to LU_TRANS_CLASS table for complete list of descriptions. | ASD:BIS Team |
| TRANS_DATE | Transaction date of a specific financial entry. | ASD:BIS Team |
| TRANS_DESC | Narrative information about the nature or source of a budgetary transaction. | ASD:BIS Team |
| TRANS_FTE | FTE (Full Time Equivalent) number associated with transaction entry. | ASD:BIS Team |
| TRANS_TYPE | Code indicating a specific budget entry's type of transaction. Refer to LU_TRANS_TYPE table for complete list of valid values and descriptions. Example: '1' = Detail Budget Worksheets | ASD:BIS Team |
| TRANS_TYPE_DESC | Description associated with a specific transaction type. Refer to LU_TRANS_TYPE table for complete list of descriptions. | ASD:BIS Team |
| TRANSACTION_COMMENTS | Comments associated with a requisition, PO or invoice. | ASD:BIS Team |
| TRANSACTION_DEPT | Department name associated with a requisition, PO or invoice. | ASD:BIS Team |
| TRANSACTION_ITEM_DESC | Description of requisition, PO or invoice. | ASD:BIS Team |
| TRANSACTION_PROCESSING_UNIT_ID | Organizational processing unit associated with the requisition, po or invoice/voucher. | ASD: BIS Team |
| TRANSACTION_TYPE | Identifies transactions as preencumbrances, encumbrances or vouchers. | ASD:BIS Team |
| TYPE_ENTRY | Code identifying the source of GL transaction entry. The GL system keeps a history of some particular types of entries: those representing reappropriations ('12') , financial journal ('53'), and liens ('61'). Refer to LU_TYPE_ENTRY table for complete l | ASD:BIS Team |
| TYPE_ENTRY_DESC | Description associated with a specific type entry code. Refer to LU_TYPE_ENTRY table for complete list of descriptions. | ASD:BIS Team |
| UAS_ACADEMIC_TITLE1 | Description associated with a specific UAS code. Represents the highest level of aggregation. Refer to LU_UAS_CODE table for complete list of valid values. | ASD:BIS Team |
| UAS_ACADEMIC_TITLE2 | Description associated with a specific UAS code. Represents the second highest level of aggregation. Refer to LU_UAS_CODE table for complete list of valid values. | ASD:BIS Team |
| UAS_ACADEMIC_TITLE3 | Description associated with a specific UAS code. Represents the second lowest level of aggregation. Refer to LU_UAS_CODE table for complete list of valid values. | ASD:BIS Team |
| UAS_ACADEMIC_TITLE4 | Description associated with a specific UAS code. Represents the lowest level of aggregation. Refer to LU_UAS_CODE table for complete list of valid values. | ASD:BIS Team |
| UAS_CODE | UAS (Uniform Accounting Structure) is a six digit code defined nationally to classify academic and administrative activities. Allows compatablity between educational institutions. Related to ARC (Annual Report Code) code and used for special processing d | ASD:BIS Team |
| UCOP_DEPT_CODE | Code indicating department used only for system wide accounts. Example: '21' = ASSOC VP ANR PROGRAMS. | ASD:BIS Team |
| UCOP_DEPT_SHORT_TITLE | Short department title used only for system wide accounts. Example: 'ANRPROGS'. | ASD:BIS Team |
| UCOP_DEPT_TITLE | Description associated with a specific UCOP_DEPT_CODE. Refer to LU_UCOP_ORG_MAPPING table for complete list of department names. | ASD:BIS Team |
| UCOP_DIV_CODE | Code indicating division used only for system wide accounts. Example: '12' = PROVOST & SR VP ACAD AFFAIRS. | ASD:BIS Team |
| UCOP_DIV_SHORT_TITLE | Short division title used only for system wide accounts. Example: 'SRVPACAD'. | ASD:BIS Team |
| UCOP_DIV_TITLE | Description associated with a specific UCOP_DIV_CODE. Refer to LU_UCOP_ORG_MAPPING table for complete list of division names. | ASD:BIS Team |
| UCOP_UNIT_CODE | Code indicating unit used only for system wide accounts. Example: '108' = ANR SPECIAL PROGRAMS. | ASD:BIS Team |
| UCOP_UNIT_SHORT_TITLE | Short unit title used only for system wide accounts. Example: 'ANRSPEC'. | ASD:BIS Team |
| UCOP_UNIT_TITLE | Description associated with a specific UCOP_UNIT_CODE. Refer to LU_UCOP_ORG_MAPPING table for complete list of unit names. | ASD:BIS Team |
| UPDATE_FREQUENCY | The frequency with which BIS refreshes the data in a specific table using a new copy from the source computer system. Refer to LU_UAS_CODE table for complete list of valid values. | ASD:BIS Team |
| VENDOR_CLASS | Code describing the class of vendor. Refer to VENDOR_CLASS_DESC for description mappings | ASD: BIS Team |
| VENDOR_CLASS_DESC | Description associated with VENDOR_CLASS. Example: ‘C’ = ‘CONTRACTOR’, ‘E’ = ‘EMPLOYEE’, ‘I’ = ‘INDIVIDUAL’, ‘R’ = ‘REFUND’, ‘S’ = ‘STUDENT’, ‘V’ = ‘VENDOR’ | ASD: BIS Team |
| VENDOR_GROUP_CODE | This code is only used in association with the vendor number and is method of grouping vendors. | ASD:BIS Team |
| VENDOR_ID | Code identifying a vendor, a company or individual that provides products or services to another company or individual | ASD: BIS Team |
| VENDOR_NAME | Name of vendor | ASD: BIS Team |
| VENDOR_NO | This field is documented for lien, reappropriation or financial entry type records. Identifies vendor associated with a given transaction. No transaction table of vendor numbers exists in BIS. Contains spaces for a balance forward type record. | ASD:BIS Team |
| VOUCHER_ID | Number identifying a voucher. A voucher is made up of multiple voucher lines. | ASD:BIS Team |
| VOUCHER_LINE_NO | Number identifying each line of a voucher. | ASD:BIS Team |
| VOUCHER_NO | This field is documented for each reappropriation or financial entry type records. Contains spaces for a balance forward type record. | ASD:BIS Team |
| YTD_AMT_ADJUSTMENTS | Year to date dollar adjustments to this account fund sub entry. | ASD:BIS Team |
| YTD_AMT_INCREMENTS | Year to date dollar increments to budgeted amount. | ASD:BIS Team |
| YTD_BALANCE_AMOUNT | Represents the year-to-date (ytd) balance amount from the beginning of the year, fora given budget entry. The ytd is not defined for overhead accounts. | ASD:BIS Team |
| YTD_BUDGET_AMOUNT | Represents the year-to-date (ytd) budget amount from the beginning of the year, fora given budget entry. The ytd is not defined for overhead accounts. | ASD:BIS Team |
| YTD_FINANCIAL_AMOUNT | Represents the year to date (ytd) financial amount, or the financial amount from the beginning of the year, for a given budget entry. The year to date financial amount is not defined for overhead account; ytd_financial_amount represents only the current | ASD:BIS Team |
| YTD_FTE_ADJUSTMENTS | Year to date adjustments to budget FTE amount. | ASD:BIS Team |
| YTD_FTE_INCREMENTS | Year to date increments to budgeted FTE amount. | ASD:BIS Team |