The translation of valid Description of Service (DOS) codes. Each one of the employees'
distributions of pay contains this code which represents the type of service for which the
employee is being paid (i.e. REG - regular pay, BYA - by agreement). Codes within this
table indicate processing options such as whether deductions are to be taken from the pay
or whether this distribution should receive a range adjustment. The data originates from
the Payroll Control Table (CTL).
| Field Name | Business Name | Data Type | Description |
|---|---|---|---|
| DOS_ABBREV_DESC | ABBREVIATED DESCRIPTION | VARCHAR2(12) | The abbreviated description of the type of service associated with appointment pay activity. |
| DOS_ACAD_OBJ_CODE | ACADEMIC OBJECT CODE | VARCHAR2(4) | The object code associated with a Description of Service for academic salary expense activity. (values are currently the same as the earnings_type_code) |
| DOS_CALC_FUNCTION | CALCULATION FUNCTION CODE | VARCHAR2(1) | Alternate code indicating the routine used to calculated gross pay associated with a Description Service. (values are R=rate times time, F=rate times time times factor, A=amount added to gross, BLANK=no gross amount calculated) |
| DOS_CALC_PROCESS | PROCESSING ROUTINE NUMBER | VARCHAR2(2) | The identification number of the routine used to calculate gross pay associated with a Description of Service. (values are 01=rate times time, 02=rate times time times factor, 03=amount added to gross, 04=no gross amount calculated) |
| DOS_CSER_IND | CSER INDICATOR | VARCHAR2(1) | NOT USED. |
| DOS_DESCRIPTION | FULL DESCRIPTION | VARCHAR2(25) | The full description of the type of service associated with appointment pay activity. |
| DOS_DIST_PRIORITY | EXPENSE DISTRIBUTION PRIORITY CODE | VARCHAR2(1) | The code indicating the priority for distributing flat rated benefits for pay activity associated with a Description of Service. |
| DOS_DOLLAR_ELMT_1 | DOLLAR ELEMENT 1 | VARCHAR2(4) | The additional monetary EDB field number associated with a Description of Service. |
| DOS_DOLLAR_ELMT_2 | DOLLAR ELEMENT 2 | VARCHAR2(4) | NOT USED. |
| DOS_DOLLAR_ELMT_3 | DOLLAR ELEMENT 3 | VARCHAR2(4) | NOT USED. |
| DOS_DOLLAR_ELMT_4 | DOLLAR ELEMENT 4 | VARCHAR2(4) | NOT USED. |
| DOS_DOLLAR_ELMT_5 | DOLLAR ELEMENT 5 | VARCHAR2(4) | NOT USED. |
| DOS_EARNINGS_TYPE | DESCRIPTION OF SERVICE CODE | VARCHAR2(3) | The code indicating the type of service associated with appointment pay activity. (key) |
| DOS_FACTOR | CALCULATION FACTOR | NUMBER(7,3) | A numeric value applied as the factor in the calculation rate times time times factor. |
| DOS_FCP_DOS | FCP DOS CODE | VARCHAR2(2) | The code indicating the type of service or type of pay associated with an appointment for reporting to the Corporate Personnel System (FCP). |
| DOS_FICA_GROSS_IND | FICA GROSS INDICATOR | NUMBER(1) | The code indicating how the DOS earnings will affect the FICA gross. (values are +1=add to gross, shows on report as +, -1=subtract from gross, shows on report as -, 0=no effect, shows on report as N) |
| DOS_FLSA_IND | FAIR LABOR STANDARDS ACT INDICATOR | VARCHAR2(1) | NOT USED. |
| DOS_FWT_GROSS_IND | FEDERAL WITHHOLDING TAX GROSS INDICATOR | NUMBER(1) | The code indicating how the DOS earnings will affect the Federal Withholding Tax gross. (values are +1=add to gross, shows on report as +, -1=subtract from gross, shows on report as -, 0=no effect, shows on report as N or S if the value of DOS_SFWT_GROSS_IND=+1) |
| DOS_HOURS_CODE | TYPE OF HOURS CODE | VARCHAR2(1) | The code indicating the category to which the reported hours belong. (values are R=regular and leave hours, O=overtime hours, N=non-worked hours, P=overtime, premium portion, BLANK=hours not applicable) |
| DOS_HOUR_ELMT_1 | HOURS ELEMENT 1 | VARCHAR2(4) | The additional hours EDB field number associated with a Description of Service. |
| DOS_HOUR_ELMT_2 | HOURS ELEMENT 2 | VARCHAR2(4) | NOT USED. |
| DOS_HOUR_ELMT_3 | HOURS ELEMENT 3 | VARCHAR2(4) | NOT USED. |
| DOS_HOUR_ELMT_4 | HOURS ELEMENT 4 | VARCHAR2(4) | NOT USED. |
| DOS_HOUR_ELMT_5 | HOURS ELEMENT 5 | VARCHAR2(4) | NOT USED. |
| DOS_HRS_PAY_ST_IND | HOURS ON PAY STATUS INDICATOR | VARCHAR2(1) | The code indicating whether or not the hours associated with a Description of Service are included in Hours on Pay Status. (values are Y=yes, included, N=no, not included) |
| DOS_HS_COMP_IND | HS COMP INDICATOR | VARCHAR2(1) | The code indicating whether the Decription of Service is associated with the Health/Science compensation program. (values are Y=yes, included, BLANK=no, not included) |
| DOS_INS_BEN_IND | INSURANCE BENEFITS INDICATOR | VARCHAR2(1) | The code indicating whether the pay rate associated with a Description of Services is included in the annual recalculation of benefits bases. (values are Y=included, N=not included) |
| DOS_LAST_ACTION | LAST ACTION | VARCHAR2(1) | The code indicating the last action which affected the associated Description of Service Table entry. (values are A=add, D=delete, C=change) |
| DOS_LAST_ACTION_DT | LAST ACTION DATE | DATE | The date associated with the last table action taken code. |
| DOS_LEAVE_ASMT_IND | LEAVE ASSESSMENT INDICATOR | VARCHAR2(1) | The code indicating whether the payment associated with a Description of Service is included in the calculation and distribution of leave accrual expense. (values are Y=included, N=not included) |
| DOS_NSETC_CODE_1 | SPECIAL RETIREMENT CONTRIBUTION CODE 1 | VARCHAR2(1) | The code indicating whether a payment is subject to special retirement contributions. (values are N=not subject to any contributions, S=subject to basic contributions, E=not subject to any contributions but reportable to UCRS, T=subject to basic contributions and faculty benefit contributions, C=not subject to basic contributions but subject to medical faculty/summer salary contributions) |
| DOS_NSETC_CODE_2 | SPECIAL RETIREMENT CONTRIBUTION CODE 2 | VARCHAR2(1) | The code indicating whether a payment is subject to special retirement contributions. (values are N=not subject to any contributions, S=subject to basic contributions, E=not subject to any contributions but reportable to UCRS, T=subject to basic contributions and faculty benefit contributions, C=not subject to basic contributions but subject to medical faculty/summer salary contributions) |
| DOS_PAY_CATEGORY | PAY CATEGORY CODE | VARCHAR2(1) | The code indicating the payment category to which a Description of Service belongs. (values are N=regular, L=leave, A=additional, one-time pay, D=differential, P-prequisite, S=suspense item) |
| DOS_PERS_GROSS_IND | PERS RETIREMENT SYSTEM GROSS INDICATOR | NUMBER(1) | The code indicating how the DOS earnings will affect the PERS Retirement System gross. (values are +1=add to gross, shows on report as +, -1=subtract from gross, shows on report as -, 0=no effect, shows on report as N) |
| DOS_POST_PROCESS | POST-PROCESSING ROUTINE NUMBER | VARCHAR2(2) | The identification number of a routine invoked after calculation of gross pay associated with a Description of Service. (values are 03=update vacation leave hours balance, 04=update sick leave hours balance, 05=update comp time hours balance, BLANK=no post-processing routine) |
| DOS_PRE_PROCESS | PRE-PROCESSING FLAG | VARCHAR2(2) | The identification number of a routine invoked prior to calculation of gross pay associated with a Description of Service. (values are 2=establish a time on call factor, BLANK=no pre-processing) |
| DOS_RANGE_ADJ_IND | RANGE ADJUSTMENT INDICATOR | VARCHAR2(1) | The code indicating whether the pay rate associated with a Description of Service is eligible for range adjustment processing. (values are Y=eligible for processing, N=not eligible for processing) |
| DOS_SABB_IND | SABBATICAL INDICATOR | VARCHAR2(1) | The code indicating whether the Decription of Service is associated with Sabbatical payments. (values are Y=yes, BLANK=no) |
| DOS_SEQUENCE | DOS ENTRY SEQUENCE NUMBER | VARCHAR2(3) | A unique number which identifies the position of the record within the Description of Services (DOS) Table. |
| DOS_SFWT_GROSS_IND | SPECIAL FEDERAL WITHHOLDING TAX GROSS INDICATOR | NUMBER(1) | The code indicating how the DOS earnings will affect the Special Federal Withholding Tax gross. (values are +1=add to gross, shows on report as +, -1=subtract from gross, shows on report as -, 0=no effect, shows on report as N) |
| DOS_SSTA_GROSS_IND | SPECIAL STATE WITHHOLDING TAX GROSS INDICATOR - FLAT RATE | NUMBER(1) | The code indicating how the DOS earnings will affect the Special State Tax Withholding gross. (values are +1=add to gross, shows on report as +, -1=subtract from gross, shows on report as -, 0=no effect, shows on report as N) |
| DOS_STAFF_OBJ_CODE | STAFF OBJECT CODE | VARCHAR2(4) | The object code associated with a Description of Services for staff salary expense activity. (values are currently the same as the earnings_type_code) |
| DOS_STA_GROSS_IND | STATE WITHHOLDING TAX GROSS INDICATOR | NUMBER(1) | The code indicating how the DOS earnings will affect the State Withholding Tax gross. (values are +1=add to gross, shows on report as +, -1=subtract from gross, shows on report as -, 0=no affect, shows on report as N or S if the value of DOS_SSTA_GROSS_IND equal +1) |
| DOS_TIME_BEN_IND | TIME BENEFITS INDICATOR | VARCHAR2(1) | The code indicating whether or not the hours associated with a Description of Service are included in Hours toward leave accrual. (values are Y=yes - included, N=no - not included) |
| DOS_TIME_CODE | TIME CODE | VARCHAR2(1) | The code translating Description of Service code into former payroll system element time code. (values are 1=regular, 2=overtime, 3=overtime at one and one half, 4=overseas premium, 5=on call time, 7=terminal vacation, 8=regular at other than regular rate, 9=by agreement or perquisite, BLANK=no translation) |
| DOS_TOC_IND | TIME ON CALL INDICATOR | VARCHAR2(1) | The code translating the Time On Cal rates (i.e., 3=triple time). |
| DOS_TOT_GROSS_IND | TOTAL GROSS INDICATOR | NUMBER(1) | The code indicating how the DOS earnings will affect the total gross. (values are +1=add to gross, shows on report as +, -1=subtract from gross, shows on report as -, 0=no effect, shows on report as N) |
| DOS_UCRS_GROSS_IND | UCRS RETIREMENT SYSTEM GROSS INDICATOR | NUMBER(1) | The code indicating how the DOS earnings will affect the UCRS Retirement System gross. (values are +1=add to gross, shows on report as +, -1=subtract from gross, shows on report as -, 0=no effect, shows on report as N) |
| DOS_UI_GROSS_IND | UNEMPLOYMENT INSURANCE GROSS INDICATOR | NUMBER(1) | The code indicating how the DOS earnings will affect the Unemployment Insurance gross. (values are +1=add to gross, shows on report as +, -1=subtract from gross, shows on report as -, 0=no effect, shows on report as N) |
| DOS_WCR_GROSS_IND | WORKERS COMPENSATION GROSS INDICATOR | NUMBER(1) | The code indicating how the DOS earnings will affect the Workers Compensation gross. (values are +1=add to gross, shows on report as +, -1=subtract from gross, shows on report as -, 0=no effect, shows on report as N) |
| DOS_WSP_EXEMPT | WORK STUDY EXEMPT INDICATOR | VARCHAR2(1) | The code indicating exclusion of the Description of Service from the work study program. (values are X=yes, BLANK=no) |
| Top of this page | Data Dictionary | PPS Main Menu |
Sent Comment to: PPS Data
Warehouse Support
Last Updated: February 8, 1999