OPRIDRUN_CNTL_IDCOMPANYPrompt Table: COMPANY_TBL
A=Annual Filing
M=Monthly Filing
Q=Quarterly Filing
S=Split Monthly Filing
GPUS_ID967_VW(SQL View) |
Index Back |
|---|---|
Idaho State EFW2Idaho State EFW2 Parameters for the 967 Form |
| SELECT OPRID , RUN_CNTL_ID , COMPANY , GPUS_FILING_CYCLE , GPUS_YE_ID967_LN3 , GPUS_YE_ID967_LN3A , GPUS_YE_ID967_LN3B , GPUS_YE_ID967_LN3C , GPUS_YE_ID967_LN3D , GPUS_YE_ID967_LN5 , GPUS_YE_ID967_LN6 , GPUS_YE_ID967_LN11 , GPUS_TAX_MONTH FROM PS_GPUS_MMREFST_ID |
| # | 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 |