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 | EMPLID | Character(11) | VARCHAR2(11) NOT NULL |
Employee ID
Prompt Table: STUDENT_AID |
2 | INSTITUTION | Character(5) | VARCHAR2(5) NOT NULL |
Academic Institution
Prompt Table: INSTITUTION_TBL |
3 | AID_YEAR | Character(4) | VARCHAR2(4) NOT NULL |
Aid Year
Prompt Table: STUDENT_AID |
4 | SEQUENCE_NBR | Number(2,0) | SMALLINT NOT NULL | Sequence Number |
5 | SCH_NBR | 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 |