SCHEDULE_F

(SQL Table)
Index Back

Profit /Loss From Business Sch

Data Collection for Schedule F

  • Parent record: VERIFICATION
  • # 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