SCHEDULE_F(SQL Table) |
Index Back |
|---|---|
Profit /Loss From Business SchData Collection for Schedule F |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | Character(11) | VARCHAR2(11) NOT NULL |
Employee ID
Prompt Table: STUDENT_AID |
|
| 2 | Character(5) | VARCHAR2(5) NOT NULL |
Academic Institution
Prompt Table: INSTITUTION_TBL |
|
| 3 | Character(4) | VARCHAR2(4) NOT NULL |
Aid Year
Prompt Table: STUDENT_AID |
|
| 4 | Number(2,0) | SMALLINT NOT NULL | Sequence Number | |
| 5 | Character(4) | VARCHAR2(4) NOT NULL | Schedule Number | |
| 6 | F_ACCT_METHOD | Character(1) | VARCHAR2(1) NOT NULL |
Accounting Method
A=Accrual C=Cash Default Value: C |
| 7 | F_SLS_LVSTCK_RSL | Signed Number(7,0) | DECIMAL(6) NOT NULL | 1 Sales of Livestock |
| 8 | F_COST_LIVESTOCK | Signed Number(7,0) | DECIMAL(6) NOT NULL | 2 Cost of Livestock |
| 9 | F_LINE_3 | Signed Number(7,0) | DECIMAL(6) NOT NULL | 3 Subtract Line2 From Line1 |
| 10 | F_SLS_LVSTCK_RAISE | Signed Number(7,0) | DECIMAL(6) NOT NULL | 4 Sales of Livestock U Raise |
| 11 | F_TOT_COPRTVE_DIST | Signed Number(7,0) | DECIMAL(6) NOT NULL | 5a Total Cooperative Distrib |
| 12 | F_LINE_5B | Signed Number(7,0) | DECIMAL(6) NOT NULL | 5b Taxable Amount |
| 13 | F_AGR_PAY | Signed Number(7,0) | DECIMAL(6) NOT NULL | 6a Agricultural Payments |
| 14 | F_LINE_6B | Signed Number(7,0) | DECIMAL(6) NOT NULL | 6b Taxable Amount |
| 15 | F_CCC_ELECTION | Signed Number(7,0) | DECIMAL(6) NOT NULL | 7a CCC Loans Election |
| 16 | F_CCC_FORFEITED | Signed Number(7,0) | DECIMAL(6) NOT NULL | 7b CCC Loans Forfeited |
| 17 | F_LINE_7C | Signed Number(7,0) | DECIMAL(6) NOT NULL | 7c Taxable Amount |
| 18 | F_LINE_8A | Signed Number(7,0) | DECIMAL(6) NOT NULL | 8a Amount Received in 1996 |
| 19 | F_LINE_8B | Signed Number(7,0) | DECIMAL(6) NOT NULL | 8b Taxable Amount |
| 20 | F_LINE_8D | Signed Number(7,0) | DECIMAL(6) NOT NULL | 8d Amount Defered from 1995 |
| 21 | F_CUSTOM_HIRE_INC | Signed Number(7,0) | DECIMAL(6) NOT NULL | 9 Custom Hire Income |
| 22 | F_OTHER_INCOME | Signed Number(7,0) | DECIMAL(6) NOT NULL | 10 Other Income |
| 23 | F_GROSS_INCOME | Signed Number(7,0) | DECIMAL(6) NOT NULL | 11 Gross Income |
| 24 | F_CAR_EXP | Signed Number(7,0) | DECIMAL(6) NOT NULL | 12 Car and Truck Expenses |
| 25 | F_CHEMICALS | Signed Number(7,0) | DECIMAL(6) NOT NULL | 13 Chemicals |
| 26 | F_CONSERVATION_EXP | Signed Number(7,0) | DECIMAL(6) NOT NULL | 14 Conservation Expenses |
| 27 | F_P2_CUSTOM_HIRE | Signed Number(7,0) | DECIMAL(6) NOT NULL | 15 Custom Hire |
| 28 | F_DEPRECIATION | Signed Number(7,0) | DECIMAL(6) NOT NULL | 16 Depreciation |
| 29 | F_EMP_BENEFIT | Signed Number(7,0) | DECIMAL(6) NOT NULL | 17 Employee Benefit |
| 30 | F_FEED_PURCHASE | Signed Number(7,0) | DECIMAL(6) NOT NULL | 18 Feed Purchase |
| 31 | F_FERTILIZERS | Signed Number(7,0) | DECIMAL(6) NOT NULL | 19 Fertilizers and Lime |
| 32 | F_FREIGHT_TRUCKING | Signed Number(7,0) | DECIMAL(6) NOT NULL | 20 Freight and Trucking |
| 33 | F_GAS_FUEL_OIL | Signed Number(7,0) | DECIMAL(6) NOT NULL | 21 Gasoline,Fuel,and Oil |
| 34 | F_INSURANCE | Signed Number(7,0) | DECIMAL(6) NOT NULL | 22 Insurance |
| 35 | F_MRTG_INTEREST | Signed Number(7,0) | DECIMAL(6) NOT NULL | 23a Mortg Interest |
| 36 | F_OTHER_INTEREST | Signed Number(7,0) | DECIMAL(6) NOT NULL | 23b Other Interest |
| 37 | F_LABOR_HIRED | Signed Number(7,0) | DECIMAL(6) NOT NULL | 24 Labor Hired |
| 38 | F_PENSION_PLANS | Signed Number(7,0) | DECIMAL(6) NOT NULL | 25 Pension Plan |
| 39 | F_RENT_VEHICLES | Signed Number(7,0) | DECIMAL(6) NOT NULL | 26a Rent Vehicles |
| 40 | F_RENT_OTHER | Signed Number(7,0) | DECIMAL(6) NOT NULL | 26b Other Rent |
| 41 | F_REPAIRS | Signed Number(7,0) | DECIMAL(6) NOT NULL | 27 Repairs and Maintenance |
| 42 | F_SEEDS_PUR | Signed Number(7,0) | DECIMAL(6) NOT NULL | 28 Seeds & plants purchased |
| 43 | F_STORAGE_WARE | Signed Number(7,0) | DECIMAL(6) NOT NULL | 29 Storage and Warehousing |
| 44 | F_SUPPLIES_PUR | Signed Number(7,0) | DECIMAL(6) NOT NULL | 30 Supplies Purchased |
| 45 | F_TAXES | Signed Number(7,0) | DECIMAL(6) NOT NULL | 31 Taxes |
| 46 | F_UTILITIES | Signed Number(7,0) | DECIMAL(6) NOT NULL | 32 Utilities |
| 47 | F_VETERINARY | Signed Number(7,0) | DECIMAL(6) NOT NULL | 33 Veterinary |
| 48 | F_LINE_34A | Signed Number(7,0) | DECIMAL(6) NOT NULL | 34a |
| 49 | F_LINE_34B | Signed Number(7,0) | DECIMAL(6) NOT NULL | 34b |
| 50 | F_LINE_34C | Signed Number(7,0) | DECIMAL(6) NOT NULL | 34c |
| 51 | F_LINE_34D | Signed Number(7,0) | DECIMAL(6) NOT NULL | 34d |
| 52 | F_LINE_34E | Signed Number(7,0) | DECIMAL(6) NOT NULL | 34e |
| 53 | F_LINE_34F | Signed Number(7,0) | DECIMAL(6) NOT NULL | 34f |
| 54 | F_TOT_EXP | Signed Number(7,0) | DECIMAL(6) NOT NULL | 35 Total Expenses |
| 55 | F_NET_FARM | Signed Number(7,0) | DECIMAL(6) NOT NULL | 36 Net Farm Profit or Loss |
| 56 | F_LINE_37A | Character(1) | VARCHAR2(1) NOT NULL |
37a All Investment At Risk
Y/N Table Edit Default Value: N |
| 57 | F_LINE_37B | Character(1) | VARCHAR2(1) NOT NULL |
37b Some Investment No Risk
Y/N Table Edit Default Value: N |
| 58 | F_P3_SALES_LVSTCK | Signed Number(7,0) | DECIMAL(6) NOT NULL | 38 Sales of Livestock |
| 59 | F_P3_TOT_COOP_DIST | Signed Number(7,0) | DECIMAL(6) NOT NULL | 39a Total Cooperative |
| 60 | F_LINE_39B | Signed Number(7,0) | DECIMAL(6) NOT NULL | 39b Taxable Amount |
| 61 | F_P3_AGR_PAY | Signed Number(7,0) | DECIMAL(6) NOT NULL | 40a Agricultural Payments |
| 62 | F_LINE_40B | Signed Number(7,0) | DECIMAL(6) NOT NULL | 40b Taxable Amount |
| 63 | F_P3_CCC_ELECTION | Signed Number(7,0) | DECIMAL(6) NOT NULL | 41a CCC Loans Election |
| 64 | F_P3_CCC_FORFEITED | Signed Number(7,0) | DECIMAL(6) NOT NULL | 41b CCC Loans Forfeited |
| 65 | F_P3_TAXABLE_AMT | Signed Number(7,0) | DECIMAL(6) NOT NULL | 41c Taxable Amount |
| 66 | F_P3_CROP_INSURNCE | Signed Number(7,0) | DECIMAL(6) NOT NULL | 42 Crop Insurance proceeds |
| 67 | F_P3_CUSTOM_HIR_IN | Signed Number(7,0) | DECIMAL(6) NOT NULL | 43 Custom Hire Income |
| 68 | F_P3_OTHER_INC | Signed Number(7,0) | DECIMAL(6) NOT NULL | 44 Other Income |
| 69 | F_TOT_LINE_45 | Signed Number(7,0) | DECIMAL(6) NOT NULL | 45 Add Lines 38 through 44 |
| 70 | F_INV_LIVESTOCK_BE | Signed Number(7,0) | DECIMAL(6) NOT NULL | 46 Inventory of Livestock |
| 71 | F_P3_COST_LIVESTOC | Signed Number(7,0) | DECIMAL(6) NOT NULL | 47 Cost of Livestock |
| 72 | F_TOT_LINE_48 | Signed Number(7,0) | DECIMAL(6) NOT NULL | 48 Add lines 46 and 47 |
| 73 | F_INV_LIVESTOC_END | Signed Number(7,0) | DECIMAL(6) NOT NULL | 49 Inventory of Livestock |
| 74 | F_LINE_50 | Signed Number(7,0) | DECIMAL(6) NOT NULL | 50 Subtract L49 from L48 |
| 75 | F_P3_GROSS_INCOME | Signed Number(7,0) | DECIMAL(6) NOT NULL | 51 Gross Income |