GPUS_MMREFST_ID

(SQL Table)
Index Back

Idaho State EFW2

Idaho 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