The committed salaries table details the consolidated records that provide cumulative, current and committed employee expenditures (gross and benefits) incurred during a fiscal month. The data originates from the monthly process which produces the PPP5441/PPP544 Committed Salary Expenditure Report. This table is used to produce the PPS Decision Support Salary Liens report. Security for the CSECSR table is controlled through views giving departments access to all payroll liens for their department during the fiscal year. The table view is SG#CSR with the # being the Screen Group designation.
The CSECSR table is split into individual fiscal years: CSECSR98 is the 1997-98 fiscal year. The current fiscal year will not have the year appended but simply be named CSECSR. NOTE: The CSECSR98 table only contains 3 months of data: Apr 98, May 98 and June 98.
| Field Name | Business Name | Data Type | Description |
|---|---|---|---|
| CSER_ET_MONTH | TRANSFER MONTH AND YEAR | VARCHAR2(4) | The expense transfer month and year, expressed in fiscal terms (i.e. June 1998 = 9812). (key) Has been broken into 2 fields: FISCAL_YEAR and FISCAL_PERIOD. |
| CSER_FAU | FULL ACCOUNTING UNIT | VARCHAR2(30) | The identifier assigned by the department for the purpose 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, account number, sub account number, object number, sub-object number and project number. |
| CSER_FAU_CHART | CHART OF ACCOUNTS NUMBER | VARCHAR2(1) | The chart of accounts identifier. (translation in coacrt table) |
| CSER_FAU_ACCT | ACCOUNT NUMBER | VARCHAR2(7) | Organization chosen identifier used to classify financial resources for accounting and reporting purposes. (translation in coaacr table) |
| CSER_FAU_SUBACCT | SUB ACCOUNT NUMBER | VARCHAR2(5) | The more detailed account code (Cost Center) used to 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) |
| CSER_FAU_OBJECT | OBJECT CONSOLIDATION NUMBER | VARCHAR2(4) | The identifier for a group of object levels and their associated objected codes for budgeting and Office of the President requirements. (translation in coaobj table) |
| CSER_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. Currently, there is no data populated, reference to CSER_SUB_OBJ. |
| CSER_FAU_PROJECT | PROJECT NUMBER | VARCHAR2(10) | The code used to track and accumulate transactions across multiple charts, accounts and fund groups. Currently, there is no data populated, reference to CSER_PROJ_CD. |
| CSER_NAME | EMPLOYEE NAME | VARCHAR2(26) | The name of the employee. Format is "last,first m". |
| CSER_EMPLOYEE_ID | EMPLOYEE ID NUMBER | VARCHAR2(9) | The unique employee identification number. |
| CSER_TITLE_CD | JOB TITLE CODE | VARCHAR2(4) | The code indicating the position classification associated with the earnings distribution. (translation in ctltci table) |
| CSER_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) |
| CSER_SUB_OBJ | SUB OBJECT NUMBER | VARCHAR2(3) | The code that provides for an object code to be broken down into greater detail. Assigned by account manager. (translation in coasob table) |
| CSER_PROJ_CD | PROJECT NUMBER | VARCHAR2(10) | The code used to track and accumulate transactions across multiple charts, accounts and fund groups. (translation in coaprj table) |
| CSER_CUM_GRS_AMT | CUMULATIVE GROSS AMOUNT | NUMBER(13,2) | The cumulative amount of salary expenditures. |
| CSER_CUM_BEN_AMT | CUMULATIVE BENEFIT AMOUNT | NUMBER(13,2) | The cumulative amount of benefits expenditures. |
| CSER_CUR_GRS_AMT | CURRENT GROSS AMOUNT | NUMBER(13,2) | The current amount of salary expenditures. |
| CSER_CUR_BEN_AMT | CURRENT BENEFIT AMOUNT | NUMBER(13,2) | The current amount of benefits expenditures. |
| CSER_COMM_GRS_AMT | COMMITTED GROSS AMOUNT | NUMBER(13,2) | The total committed amount of salary expenditures. |
| CSER_COMM_BEN_AMT | COMMITTED BENEFIT AMOUNT | NUMBER(13,2) | The total committed amount of benefits expenditures. |
| CSER_BEG_DATE_ISO | COMMITTAL PERIOD BEGIN DATE | DATE | Beginning date of the committal period. |
| CSER_END_DATE_ISO | COMMITTAL PERIOD END DATE | DATE | Ending date of the committal period |
| CSER_DATE_FLAG | DATE FLAG | VARCHAR2(1) | Under research |
| CSER_DOS_ATTR | DOS ATTRIBUTE | VARCHAR2(2) | The Description of Service pay attribute code. |
| CSER_OBJECT_CD | OBJECT NUMBER | VARCHAR2(4) | Identifer used to classify accounting transactions by type. Examples are academic salaries, in-state travel, Reg Fee income. (translation in coaobj table) |
| CSER_PERSNL_PGM_BEN_ATTR | PERSONNEL PROGRAM BENEFIT ATTRIBUTE | VARCHAR2(1) | Under research |
| CSER_RET_CODE_BEN_ATTR | RETIREMENT CODE BENEFIT ATTRIBUTE | VARCHAR2(1) | Under research |
| CSER_FICA_ELIG_BEN_ATTR | FICA ELIGIBILITY BENEFIT ATTRIBUTE | VARCHAR2(1) | Under research |
| CSER_LEAVE_ACRU_BEN_ATTR | LEAVE ACCRUAL BENEFIT ATTRIBUTE | VARCHAR2(1) | Under research |
| CSER_LNP_NO_MONTHS | LEAVE WITHOUT PAY NUMBER OF MONTHS | NUMBER(2) | Number of months of leave without pay during this committal period. |
| CSER_FAU_ORG_CD | ORGANIZATION CODE | VARCHAR2(4) | The identifier of an organization. |
| CSER_FAU_HOME_DEPT_CD | HOME DEPARTMENT NUMBER | VARCHAR2(6) | The department associated with the funding. 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) |
| CSER_FAU_SUB_FUND_GRP_TYP_CD | SUB FUND GROUP TYPE CODE | VARCHAR2(1) | The code 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.) |
| CSER_FAU_HIGH_ED_FUNC_CD | HIGHER EDUCATION FUNCTION CODE | VARCHAR2(4) | The code for thefunctionality 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.) |
| CSER_FAU_OP_FUND | UCD/OP FUND NUMBER | VARCHAR2(6) | The UCD pre-DAFIS fund number for reporting to Office of the President. (Derived from look-up to the DaFIS Chart/Account table.) |
| CSER_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.) |
| CSER_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.) |
| FISCAL_YEAR | FISCAL YEAR | VARCHAR2(4) | The four-digit Fiscal Year during which this expense transaction was processed. |
| FISCAL_PERIOD | FISCAL PERIOD-MONTH | VARCHAR2(2) | The fiscal Period or Month during which this expense transaction was processed. |
| Top of this page | Data Dictionary | PPS Main Menu |
Send Comments to: PPS Data
Warehouse Support
Last Updated: November 11, 1998