SCHEDULE_C

(SQL Table)
Index Back

Profit /Loss From Business Sch

Data Collection for Schedule C

  • 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 C_BUSN_TYPE Character(20) VARCHAR2(20) NOT NULL A Principal Business
    7 C_BUSN_CODE Character(4) VARCHAR2(4) NOT NULL B Principal Busn. Code
    8 C_BUSN_NAME Character(25) VARCHAR2(25) NOT NULL C Business Name
    9 C_EIN Character(9) VARCHAR2(9) NOT NULL D Employer ID No.(EIN)
    10 C_ACCT_MTHD Character(1) VARCHAR2(1) NOT NULL F Accounting Method
    A=Accrual
    C=Cash
    O=Other

    Default Value: O

    11 C_PARTICIPATE Character(1) VARCHAR2(1) NOT NULL G Materially Participate

    Y/N Table Edit

    Default Value: N

    12 C_START_TAX_YR Character(1) VARCHAR2(1) NOT NULL H Started or Accuired

    Y/N Table Edit

    Default Value: N

    13 C_GROSS_RCPTS Signed Number(7,0) DECIMAL(6) NOT NULL 1 Gross Receipts or Sales
    14 C_ALLOWANCES Signed Number(7,0) DECIMAL(6) NOT NULL 2 Returns and Allowances
    15 C_ADJ_GROSS_RCPTS Signed Number(7,0) DECIMAL(6) NOT NULL 3 Line 1 Minus Line 2
    16 C_COST_GOODS Signed Number(7,0) DECIMAL(6) NOT NULL 4 Cost of Goods Sold
    17 C_GROSS_PROFIT Signed Number(7,0) DECIMAL(6) NOT NULL 5 Gross Profit
    18 C_OTHER_INCOME Signed Number(7,0) DECIMAL(6) NOT NULL 6 Other Income
    19 C_GROSS_INCOME Signed Number(7,0) DECIMAL(6) NOT NULL 7 Gross Income
    20 C_TOTAL_EXPENSES Signed Number(7,0) DECIMAL(6) NOT NULL 28 Total Expenses
    21 C_TNT_PROFIT Signed Number(7,0) DECIMAL(6) NOT NULL 29 Tentative Profit( loss)
    22 C_HOME_EXPENSES Signed Number(7,0) DECIMAL(6) NOT NULL 30 Home Expenses for Business
    23 C_NET_PROFIT Signed Number(7,0) DECIMAL(6) NOT NULL 31 Net Profit or (Loss)
    24 C_AT_RISK Character(1) VARCHAR2(1) NOT NULL Investment In This Activity
    A=All Investment Is At Risk
    S=Some Investment Not At Risk

    Default Value: A