SCHEDULE_C(SQL Table) |
Index Back |
---|---|
Profit /Loss From Business SchData Collection for Schedule C |
# | 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 |