S_TX_DISTRICT_FIN_S (ver 15.11.1)
This table is a standalone table that stores the information for District Finance information for TSDS PEIMS.
Column Name | Version | Data Type | Description |
|---|---|---|---|
ID | 15.11.1 | Number(10,0) | The Primary Key for the record. |
Bud_Act_Amount | 15.11.1 | Number(10,0) | The budgeted amount for the 030 record or the actual amount for the 032 record. |
| Function_Code | 15.11.1 | Varchar2(2) | The function code for the 030/032 record. |
| Fund_Code | 15.11.1 | Varchar2(3) | The fund code for the 030/032 record. |
| Object_Code | 15.11.1 | Varchar2(4) | The object code for the 030/032 record. |
| Organizaton_Code | 15.11.1 | Varchar2(3) | The organization code for the 030/032 record. |
| Program_Intent_Code | 15.11.1 | Varchar2(2) | The program intent code for the 030/032/055 record. |
| Record_Type | 15.11.1 | Varchar2(3) | Indicates if the record is an 030, 032 or 055 record. |
| Total_Contract_inst_Staff_FTE | 15.11.1 | Number(25,10) | The Total Contracted Instructional Staff FTE for the 055 record. |
| YearID | 15.11.1 | Number(10,0) | Indicates the year for this 030, 032 or 055 record. |