Page Name

Description:

A statutory designation of funds for a specific purpose. The lowest level line item of funding in the general appropriation act.

Coding Instructions:

On SCD tables: Only 010000 - Salary & Benefits is applicable

Algorithm:

Usage Type:

DERIVED

Begin Term:

192001

End Term:

Last Modified:

17-SEP-2008

SubmissionAscending	Table Name	Column name	Element ID	Tab column id	Table id	Submission name
Salary Category Detail (SCD)	EMPLOYEE_DATA (EDAT)	APPROP_CAT	389	1753	30	Salary Category Detail
Salary Category Detail (SCD)	EMPLOYEE_VACANTS (EVAC)	APPROP_CAT	389	1857	31	Salary Category Detail
University Employee/OPS (EMPL)	EMPLOYEE_DATA (EDAT)	APPROP_CAT	389	1753	30	University Employee/OPS

Excel code	Code	Description	Grouping
'.	.	MISSING	-
'000000	000000	PROGRAM GENERATED
'000100	000100	FEES
'000110	000110	RENTAL CAR SURCHARGE
'000115	000115	ROYALTIES
'000118	000118	TELEPHONE COMMISSIONS
'000120	000120	TOLLS AND ADMISSIONS
'000200	000200	MARKET TUITION RATE	-
'000300	000300	TAXES
'000400	000400	MISCELLANEOUS RECEIPTS
'000500	000500	INTEREST
'000700	000700	U S GRANTS
'000800	000800	CITY OR COUNTY GRANTS
'001000	001000	STATE GRANTS
'001100	001100	OTHER GRANTS AND DONATIONS
'001101	001101	DONATIONS/CONTRIBUTIONS GIVEN TO THE STATE
'001200	001200	FINES, FORFEITURES, AND JUDGEMENTS
'001202	001202	PENALTIES
'001203	001203	SALE OF CONFISCATED/FORFEITED PROPERTY
'001500	001500	TRANSFERS IN
'001510	001510	TRANSFER OF FEDERAL FUNDS
'001800	001800	REFUNDS
'001801	001801	REIMBURSEMENTS
'001901	001901	SALES OF GOODS/SERVICES OUTSIDE STATE GOV'T
'001903	001903	SALES OF GOODS/SERVICES TO STATE AGENCIES
'001904	001904	SALE OF GOODS OUTSIDE STATE GOVERNMENT
'001905	001905	SALE OF SERVICES OUTSIDE STATE GOVERNMENT
'001906	001906	SALE OF GOODS TO STATE EMPLOYEES
'001907	001907	SALE OF SERVICES TO STATE EMPLOYEES
'002101	002101	RENT

Select Pagination

Submission CodeAscending	Table name	Diagnostic Code	Diagnostic Message	Error Level	Error Description
EMPL	EMPLOYEE_DATA	6285	APPROP_CAT is nulled if SUB_TYP in ('F', 'R')	1	Generated or Modified during SUDS Edit Process
SCD	EMPLOYEE_DATA	0533	Appropriation Category must be equal to '010000' on all SCD records	9	Critical Error: may cause submission to be rejected
SCD	EMPLOYEE_DATA	6285	APPROP_CAT is nulled if SUB_TYP in ('F', 'R')	1	Generated or Modified during SUDS Edit Process
SCD	EMPLOYEE_VACANTS	0533	Appropriation Category must be equal to '010000' on all SCD records	9	Critical Error: may cause submission to be rejected

Physical Description:

VARCHAR2(6)

Short Name:

CATPOS

Column Name:

APPROP_CAT_POS

Associated Submissions, Tables, and Columns