GPUS_MMREFST_ID(SQL Table) |
Index Back |
---|---|
Idaho State EFW2Idaho State EFW2 Parameters for the 967 Form |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | OPRID | Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). |
2 | RUN_CNTL_ID | Character(30) | VARCHAR2(30) NOT NULL | Run Control ID |
3 | COMPANY | Character(3) | VARCHAR2(3) NOT NULL |
Company
Prompt Table: COMPANY_TBL |
4 | GPUS_FILING_CYCLE | Character(1) | VARCHAR2(1) NOT NULL |
Filing Cycle
A=Annual Filing M=Monthly Filing Q=Quarterly Filing S=Split Monthly Filing |
5 | GPUS_YE_ID967_LN3 | Number(14,2) | DECIMAL(13,2) NOT NULL | Idaho Form 967 Line 3 Amount |
6 | GPUS_YE_ID967_LN3A | Number(14,2) | DECIMAL(13,2) NOT NULL | Idaho Form 967 Line 3a Amount |
7 | GPUS_YE_ID967_LN3B | Number(14,2) | DECIMAL(13,2) NOT NULL | Idaho Form 967 Line 3b Amount |
8 | GPUS_YE_ID967_LN3C | Number(14,2) | DECIMAL(13,2) NOT NULL | Idaho Form 967 Line 3c Amount |
9 | GPUS_YE_ID967_LN3D | Number(14,2) | DECIMAL(13,2) NOT NULL | Idaho Form 967 Line 3d Amount |
10 | GPUS_YE_ID967_LN5 | Number(14,2) | DECIMAL(13,2) NOT NULL | Idaho Form 967 Line 5 Amount |
11 | GPUS_YE_ID967_LN6 | Number(14,2) | DECIMAL(13,2) NOT NULL | Idaho Form 967 Line 6 Amount |
12 | GPUS_YE_ID967_LN11 | Number(14,2) | DECIMAL(13,2) NOT NULL | Idaho Form 967 Line 11 Amount |
13 | GPUS_TAX_MONTH | Number(2,0) | SMALLINT NOT NULL | Tax Month |