The detail earnings record contains accounting, rate, description of service and other
distribution-type information associated with the payment for an employee during the pay
cycle on the payment date. The data originates from the payment cycle-produced Payroll
Audit Record (PAR). The PAR tables have been split into individual fiscal year: PARERN96
is the 1995-96 fiscal year. The current fiscal year will not have the year appended but
simply be named PARERN.
| Field Name | Business Name | Data Type | Description |
|---|---|---|---|
| APPT_REP_CODE | APPOINTMENT REPRESENTATION CODE | VARCHAR2(1) | The code indicating whether the predominant appointment of an individual is eligible to be represented, for collective bargaining purposes (C=covered, S=supervisor-uncovered, U=uncovered, ?=indeterminant, or *=to be determined). |
| APPT_SPCL_HNDLG | APPOINTMENT SPECIAL HANDLING CODE | VARCHAR2(1) | The code indicating the title special handling code of the predominant appointment of an individual for collective bargaining purposes (BLANK=No predominant title special handling code, ?=indeterminate or *=to be determined). |
| APPT_TYPE | APPOINTMENT TYPE CODE | VARCHAR2(1) | The code indicating the type of appointment for this earning distribution. (values are 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) |
| CLASS_TTL_OUTLINE | CLASS TITLE OUTLINE | VARCHAR2(3) | The code indicating the primary occupation group to which a title is assigned for reporting purposes. For staff titles, this element is known as the Occupational Subgroup Code. For academic titles, the component characters of the CTO have been assigned specific values. |
| CURR_STUD_FLAG | CURRENT STUDENT FLAG | VARCHAR2(1) | The code indicating that an employee is classified as a student according to financial aid definitions during the current fiscal year. (values are Y=student or BLANK) |
| DIST_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) |
| DIST_NO | DISTRIBUTION NUMBER | NUMBER(5) | The number uniquely identifying a payroll distribution associated with an appointment. |
| DIST_PAYRATE | DISTRIBUTION PAY RATE | NUMBER(9,4) | The full-time hourly rate, pay period amount, or by agreement amount associated with the distribution. |
| 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. (values are BLANK=no predominant distribution code, ?=indeterminant, or *=to be determined) |
| EMP_REL_CODE | EMPLOYEE RELATIONS CODE | VARCHAR2(1) | The code indicating whether the predominant appointment of an individual is eligible to be represented, for collective bargaining purposes. (values are C=covered, S=supervisor-uncovered, U=uncovered, ?=indeterminate, or *=to be determined) |
| EMPLOYEE_ID | EMPLOYEE ID NUMBER | VARCHAR2(9) | The unique employee identification number. (primary key) |
| ENTRY_SEQ_NO | ENTRY SEQUENCE NUMBER | NUMBER(5) | Under research |
| EXEC_BEN_IND | EXECUTIVE BENEFIT CODE | VARCHAR2(1) | The code indicating how a special benefits contribution code was applied. (values are 0=not eligible, 1=total amount of contribution applied to tax-deferred fixed annuity program, 2=total amount of contribution applied to tax-deferred variable equity program, 3=total amount of contribution applied to tax-deferred variable bond program, 4=total amount of contribution applied to tax-deferred saving fund, 5=total amount of contribution applied to tax-deferred equity fund, 6=total amount of contribution applied to tax-deferred bond fund, 7=total amount of contribution applied to tax-deferred guaranteed insurance contract fund, 8=total amount of contribution applied to tax-deferred money market fund, 9=reserved for a future contribution applied to a tax deferred fund) |
| FAU | FULL ACCOUNTING UNIT | VARCHAR2(30) | The identifier assigned by the department for the purposes of identifying a specific expenditure. For payroll purposes, this is the identifier of an account 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. (This field has been split into its individual components during the update/load process) |
| FAU_CHART | CHART OF ACCOUNTS NUMBER | VARCHAR2(1) | Identifer of a chart of accounts. (created from FAU field during update/load process) (translation in COACRT table) |
| FAU_ACCT | ACCOUNT NUMBER | VARCHAR2(7) | Organization chosen identifier used to classify financial resources for accounting and reporting purposes. (created from FAU field during update/load process) (translation in COAACR table) |
| FAU_SUBACCT | SUB ACCOUNT NUMBER | VARCHAR2(5) | Allows an account to be broken down in more detail (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 manager. (created from FAU field during update/load process) (translation in COASAC table) |
| FAU_OBJECT | OBJECT NUMBER | VARCHAR2(4) | Identifier used to classify accounting transactions by type. Examples are academic salaries, in-state travel, Reg Fee income. (created from FAU field during update/load process) (translation in COAOBJ table) |
| FAU_SUBOBJ | SUB OBJECT NUMBER | VARCHAR2(3) | Provides for an object code to be broken down into greater detail. Assigned by account manager. (created from FAU field during update/load process) (translation in COASOB table) |
| FAU_PROJECT | PROJECT NUMBER | VARCHAR2(10) | The code used to track and accumulate transactions across multiple charts, accounts and fund groups. (created from FAU field during update/load process) (translation in COAPRJ table) |
| FAU_COST_SHARING_IND | COST SHARING INDICATOR | VARCHAR2(1) | The code indicating the cost sharing requirements of an account. (added from DaFIS Account table during update/load process) |
| FAU_FFT_CODE | FEDERAL-FLOW-THROUGH CODE | VARCHAR2(1) | The code indicating that this account is designated as a Federal-Flow-Through account. (added from DaFIS Account table during update/load process) |
| FAU_HIGH_ED_FUNC_CD | HIGHER EDUCATION FUNCTION CODE | VARCHAR2(4) | Function codes which are 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. (added from DaFIS Account table during update/load process) |
| FAU_HOME_DEPT_CD | HOME DEPARTMENT NUMBER | VARCHAR2(6) | Currently used to identify campus departments for Payroll and report distribution. (added from DaFIS Account table during update/load process) (translation in CTLHME table) |
| FAU_OP_FUND | UCD/OP FUND NUMBER | VARCHAR2(6) | UCD pre-DAFIS fund number for reporting to Office of the President. (added from DaFIS Account table during update/load process) |
| FAU_ORG_CD | ORGANIZATION CODE | VARCHAR2(4) | The identifier of a DaFIS-established organization. (added from DaFIS Account table during update/load process) |
| FAU_SUB_FUND_GRP_TYP_CD | SUB FUND GROUP TYPE CODE | VARCHAR2(1) | Used to group like sub funds. For example, Federal Contracts would be a sub fund group type with a number of associated sub fund groups. (added from DaFIS Account table during update/load process) |
| FINAID_CATEGORY | FINANCIAL AID CATEGORY | VARCHAR2(1) | The code indicating the category of student employment of the associated earnings. (values are R=Research assistant, T=Teaching assistant, Z=Other student employee or BLANK) |
| FINAID_TYPE | FINANCIAL AID TYPE CODE | VARCHAR2(1) | The code indicating how the associated earnings distribution relates to a work study limit. (values are D=earnings entirely within work study limit charged to department, P=earnings partially within work study limit charged to work study, S=earnings partially within work study limit charged to department, W=earnings entirely within work study limit charged to work study, X=earnings completely beyond limit, or no limit was set, or no room to split, therefore charged to department, Y=earnings partially beyond limit, therefore charged to department and not accumulated as a work study, or BLANK) |
| LEAVE_ACRUCODE | LEAVE ACCRUAL CODE | VARCHAR2(1) | The code indicating the rate which vacation and sick leave were accrued by the individual for the distribution. (translation in DVTLVC table) |
| LEAVE_ASSESS_IND | LEAVE ASSESSMENT INDICATOR | VARCHAR2(1) | The code indicating for an earnings distribution, whether it is to be subject to a leave benefits assessment or not. (values are Y=assess leave or BLANK) |
| PAID_AMT | AMOUNT PAID | NUMBER(7,2) | The total dollar amount of an earnings distribution. |
| PAID_HOURS | HOURS PAID | NUMBER(5,2) | The number of hours paid. |
| PAID_PERCENT | PERCENT PAID | NUMBER(5,4) | The percent of time of an earnings distribution that an individual was on pay status during a pay period. |
| PAY_CYCLE_CODE | PAY CYCLE CODE | VARCHAR2(2) | The code indicating the pay cycle for which the payroll audit record was generated. (values are BW=bi-weekly, SM=semi-monthly, MO=monthly current, or MA=monthly arrears) (primary key) |
| PAY_CYCLE_END_DATE | PAY CYCLE END DATE | DATE | The last date in the pay cycle for which the payroll audit record was generated. (primary key) |
| PAY_PER_END_DATE | PAY PERIOD END DATE | DATE | The end date of the pay period during which an earnings distribution amount was earned. |
| PAY_SCHED_CODE | PAY SCHEDULE CODE | VARCHAR2(1) | The code indicating the employees pay schedule at the time of pay computation. |
| PRI_GROSS_CTL | PAYROLL AUDIT RECORD GENERATION NUMBER | VARCHAR2(3) | The number identifying the payroll audit record generation produced for the individual. |
| PRI_GROSS_NO | PRIORITY GROSS NUMBER | VARCHAR2(1) | The priority, from the Description of Service (DOS) Table, associated with the Description of Service Code. |
| RATE_ADJ_IND | RATE ADJUSTMENT INDICATOR | VARCHAR2(1) | The code indicating whether an earnings distribution was an adjustment to the pay rate previously paid earnings. (values are A=no, hours not posted to hours balances or BLANK=yes, hours posted to hours balances) |
| RATE_TYPE_CODE | PAY 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. (values are 2=pay period pay rate, 4=hourly pay rate) |
| RECORD_TYPE | PAR RECORD TYPE | VARCHAR2(2) | The code indicating the process that generated the PAR record. (values are 65=expense transfers, 70=cancellations, 75=overpayments, 80=hand-drawn checks, 82=rush hand-drawn checks, 85=current activity) |
| SPCL_BEN_CODE | SPECIAL BENEFITS CODE | VARCHAR2(1) | The code indicating whether the individual was eligible for special benefits plans under this distribution. (values are 0=not eligible for special contributions, 2=safety title eligibility) |
| TITLE_CODE | TITLE CODE | VARCHAR2(4) | The code indicating the position classification associated with the earnings distribution. (translation in CTLTCI table) |
| TITLE_UNIT_CODE | TITLE UNIT CODE | VARCHAR2(2) | The code indicating the collective bargaining unit to which a title code belongs. (translation in CTLBUT table) |
| TRANS_CODE | TRANSACTION CODE | VARCHAR2(2) | The code indicating the type of transaction associated with the earnings distribution. (values are AP=additional pay, AU=automatic pay, C2=cancellation, E1=expense transfer 1, E3=expense transfer 3, FT=one-time payment, H2=hamd-drawn, LX=late time or leave, O2=overpayment, RA=retroactive pay, RX=reduction in pay or leave, ST=payment in lieu of notice, TE=exception time, TX=positive time) |
| UCD_EMP_NAME | EMPLOYEE NAME | VARCHAR2(26) | The name of the employee. Format is last,first m. (added to the record from EDBPER.EMP_NAME during update/load process) |
| WORK_STUDY_PGM | WORK STUDY PROGRAM CODE | VARCHAR2(1) | The code indicating the type of work study program associated with an earnings distribution. (translation in CTLWSP table) |
| WSP_EXEMPT_SW | DOS WORK STUDY EXEMPT SWITCH | VARCHAR2(1) | The code indicating whether the associated earnings are subject to split charging between the department funds and work study funds. (values are X=DOS code is exempt from work study splitting or BLANK) |
| XFER_REASON_CODE | TRANSFER REASON CODE | VARCHAR2(1) | The code indicating the reason for transfer of an earnings expense. (values are A=late receipt of information, one time only adjustment, B=late receipt of information, C=transfer of accumulated vacation, D=other) |
| Top of this page | Data Dictionary | PPS Main Menu |
Sent Comment to: PPS Data Warehouse
Support
Last Updated: February 5, 2001