The transfer of expense record details the expenses (benefits and employee earnings) incurred during that pay cycle and associates them to the funding. Office of the President maintains up to six months of these transactions in the production payroll files. The data originates from the monthly-produced Expense Transfer Holding File (ETH), created by the same process that created the more-detailed Expense Distribution Workfile (EDWEXP). A more-detailed write-up covers the differences between these two tables.
Records in the ETHTOE table are summarized (benefits amounts combined) similar to the PPP5302 Distribution of Payroll Expense Report. Security for the ETHTOE table is controlled through views giving departments access to all payroll expenses incurred by their employees during the fiscal year. The table view is SG#TOE with the # being the Screen Group designation.
Similar to the other historical data tables (ie. PAR), the ETHTOE table has been split by fiscal year: the ETHTOE is for the current fiscal year while ETHTOE98 is for the 1997-98 fiscal year.
| Field Name | Business Name | Data Type | Description |
|---|---|---|---|
| FISCAL_PERIOD | FISCAL PERIOD/MONTH | VARCHAR2(2) | The Fiscal Period or Month during which this expense transaction was processed. |
| FISCAL_YEAR | FISCAL YEAR | VARCHAR2(4) | The four-digit Fiscal Year during which this expense transaction was processed. |
| TOE_APPT_TYPE_CODE | APPOINTMENT TYPE CODE | VARCHAR2(1) | The code indicating the type of appointment (1=Contract, 2=Regular/Career, 3=Limited (formerly casual), 4=Casual/Restricted, 5=Academic, 6=Per diem, or 7=Regular/Career partial year,8=Floater). |
| TOE_BEN_FICA_MEDCR | FICA/MEDICARE BENEFITS AMOUNT | NUMBER(7,2) | The total amount of the OASDI/MEDICARE benefits associated with the earnings distribution. |
| TOE_BEN_GSTUI | GRADUATE STUDENT TUITION REMISSION BENEFITS AMOUNT | NUMBER(7,2) | The total amount of the Graduate Student Tuition Remission and Incentive Award Program (IAP) offset benefits associated with the earnings distribution. |
| TOE_BEN_HLTH_DNTL | MEDICAL/DENTAL/OPTICAL BENEFITS AMOUNT | NUMBER(7,2) | The total amount of the Medical/Dental/Optical insurance and Annuitant Life benefits associated with the earnings distribution. |
| TOE_BEN_LEAVE | LEAVE BENEFITS AMOUNT | NUMBER(7,2) | The total amount of Leave Accrual assessments and Incentive Award Program (IAP) assessment benefits associated with the earnings distribution. |
| TOE_BEN_LI_NDI | LIFE INSURANCE/NDI BENEFITS AMOUNT | NUMBER(7,2) | The total amount of Life Insurance, Disability and Graduate Student Fee Remission benefits associated with the earnings distribution. |
| TOE_BEN_RETR | RETIREMENT BENEFITS AMOUNT | NUMBER(7,2) | The total amount of the Retirement (aka Matching Contributions) benefits associated with the earnings distribution. |
| TOE_BEN_UI_GSH | UNEMPLOYMENT INSURANCE/GSH BENEFITS AMOUNT | NUMBER(7,2) | The total amount of Unemployment Insurance/Graduate Student Health benefits associated with the earnings distribution. |
| TOE_BEN_WC_ESP | WORKERS COMPENSATION/ESP BENEFIT AMOUNT | NUMBER(7,2) | The total amount of Workers Compensation/Employee Support Program benefits associated with the earnings distribution. The ESP or employee assistance program is not currently used at UCD. |
| TOE_DIST_UNIT_CODE | DISTRIBUTION UNIT CODE | VARCHAR2(1) | The code indicating the distribution unit code of the predominant distribution of the predominant appointment of an individual for collective bargaining purposes (BLANK=No predominant distribution unit code, ?=Indeterminant, or *=To be determine) (translation in ctlbut table) |
| TOE_DOS | DESCRIPTION OF SERVICE CODE | VARCHAR2(3) | The code indicating the type of service or type of pay associated with the earnings distribution. (translation in ctldos table) |
| TOE_EMP_REL_CODE | EMPLOYEE RELATIONS CODE | VARCHAR2(1) | The code indicating the supervisory/confidential designation of an individual for purposes of collective bargaining. |
| TOE_EMPLOYEE_ID | EMPLOYEE ID NUMBER | VARCHAR2(9) | The unique employee identification number. |
| TOE_ET_MONTH | TRANSFER MONTH | NUMBER(5) | The expense transfer month, expressed in fiscal terms (I.E. June 1998 = 9812). This field has been divided into two individual fields: FISCAL_YEAR and FISCAL_PERIOD. |
| TOE_ET_PAGE_LINE | TRANSFER PAGE/LINE NUMBER | NUMBER(10) | The expense transfer page and line number. The line number is the last 2 digits of the number and the digits to the left of the line number are the page number (leading zeros don't show). (I.E. 588301 is line 01 on page 05883). |
| TOE_FAU | FULL ACCOUNTING UNIT | VARCHAR2(30) | The identifier of an account assigned by the department against which salary or wage expenses are charged. The full accounting unit (FAU) is composed of the chart of accounts number, account number, sub account number, object number, sub object number and project number. |
| TOE_FAU_CHART | CHART OF ACCOUNTS NUMBER | VARCHAR2(1) | The chart of accounts identifier. (translation in coacrt table) |
| TOE_FAU_ACCT | ACCOUNT NUMBER | VARCHAR2(7) | The organization-chosen identifier used to classify financial resources for accounting and reporting purposes. (translation in coaacr table) |
| TOE_FAU_SUBACCT | SUB ACCOUNT NUMBER | VARCHAR2(5) | The more-detailed code within the account (Cost Center) in order to better track detail transactions. The sub account takes on the attributes of the account it reports to, including account manager, fund group and function code. Assigned by account managers. (translation in coasac table) |
| TOE_FAU_OBJECT | OBJECT NUMBER | VARCHAR2(4) | The identifer used to classify accounting transactions by type. Examples are academic salaries, in-state travel, Reg Fee income. (translation in coaobj table) |
| TOE_FAU_SUBOBJ | SUB OBJECT NUMBER | VARCHAR2(3) | The code which provides for an object code to be broken down into greater detail. Assigned by account manager. (translation in coasob table) |
| TOE_FAU_PROJECT | PROJECT NUMBER | VARCHAR2(10) | The code used to track and accumulate transactions across multiple charts, accounts and fund groups. (translation in coaprj table) |
| TOE_FAU_COST_SHARING_IND | COST SHARING INDICATOR | VARCHAR2(1) | The code indicating the cost sharing requirements of an account. (Derived from look-up to the DaFIS Chart/Account table.) |
| TOE_FAU_FFT_CODE | FEDERAL-FLOW-THROUGH CODE | VARCHAR2(1) | The code indicating that this account is designated as a Federal-Flow-Through account. (Derived from look-up to the DaFIS Chart/Account table.) |
| TOE_FAU_HIGH_ED_FUNC_CD | HIGHER EDUCATION FUNCTION CODE | VARCHAR2(4) | The function code which is assigned to each account which match expenditures to the functionality of the account. Higher education examples are instruction, academic support, art and museums, etc. These names are the most detailed level of functional classification and are utilized in determining AICPA function codes, and federal function codes for indirect cost purposes. (Derived from look-up to the DaFIS Chart/Account table.) |
| TOE_FAU_HOME_DEPT_CD | HOME DEPARTMENT NUMBER | VARCHAR2(6) | The department to which the chart/account belongs. Currently used to identify campus departments for Payroll and report distribution. (Derived from look-up to the DaFIS Chart/Account table.) (translation in ctlhme table) |
| TOE_FAU_OBJ_CONSOLDTN | FAU OBJECT CONSOLIDATION | VARCHAR2(4) | The Consolidated Object Code for DaFIS which identifies a group of object levels for budgeting and Office of the President requirements. (Derived from look-up to the DaFIS Chart/Object table.) (translation in coaobj table) |
| TOE_FAU_OP_FUND | UCD/OP FUND NUMBER | VARCHAR2(6) | UCD pre-DAFIS fund number for reporting to Office of the President. (Derived from look-up to the DaFIS Chart/Account table.) |
| TOE_FAU_ORG_CD | ORGANIZATION CODE | VARCHAR2(4) | The identifier of the DaFIS organization to which the chart/account belongs. (Derived from look-up to the DaFIS Chart/Account table.) |
| TOE_FAU_SUB_FUND_GRP_TYP_CD | SUB FUND GROUP TYPE CODE | VARCHAR2(1) | Used to group similar sub funds. For example, Federal Contracts would be a sub fund group type with a number of associated sub fund groups. (Derived from look-up to the DaFIS Chart/Account table.) |
| TOE_NAME | EMPLOYEE NAME | VARCHAR2(26) | The name of the employee. Format is last,first m. (UCOP-provided employee name field was only 14 characters, this name field is updated from a look-up on the employee earnings records.) |
| TOE_ORIG_GROSS_ERN | ORIGINAL GROSS EARNINGS | NUMBER(7,2) | The total amount of the earnings distribution. |
| TOE_PAR_CNTL_NUM | PAR CONTROL NUMBER | NUMBER(5) | Under research |
| TOE_PAR_DIST_NUM | PAR DISTRIBUTION NUMBER | NUMBER(5) | The number uniquely identifying a payroll distribution associated with an appointment. |
| TOE_RATE | SALARY RATE | NUMBER(7,2) | The full time hourly rate, pay period amount, or by-agreement amount associated with the distribution. |
| TOE_RATE_TYPE | RATE TYPE CODE | VARCHAR2(1) | The code indicating whether the associated distribution pay rate is an hourly pay rate or a pay period pay rate. |
| TOE_RETR_PLN | RETIREMENT PLAN CODE | VARCHAR2(1) | The code indicating the retirement plan to which the individual belongs. |
| TOE_SEQ_NUM | SEQUENCE NUMBER | NUMBER(5) | Not used. |
| TOE_TIME | AMOUNT OF TIME | NUMBER(5) | The number of hours or percentage of time associated with the distribution. |
| TOE_TITLE | JOB TITLE CODE | VARCHAR2(4) | The code indicating the position classification associated with the earnings distribution. (translation in ctltci table) |
| TOE_TRANSFERED_GRS | TRANSFERRED GROSS | NUMBER(9,2) | Under research |
| TOE_TRANS_END_DATE | TRANSACTION END DATE | DATE | The ending date of the original pay cycle associated with the earnings distribution. |
| Top of this page | Data Dictionary | PPS Main Menu |
Sent Comment to: PPS Data Warehouse
Support
Last Updated: February 5, 2001