| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 STATE |
Character(6) |
VARCHAR2(6) NOT NULL |
State
Prompt Table:
STATE_US_VW
|
| 2 |
EFFDT |
Date(10) |
DATE NOT NULL |
Effective Date
Default Value: %date
|
| 3 |
EFF_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Effective Status
A=Active
I=Inactive
Default Value: A
|
| 4 |
ST_TAX_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
State Tax Calculation Type
A=Graduated Tax Tbls-Allowances
E=Graduated Tax Tbls-Annl Exem $
F=Percent of FWT (One)
G=Percent of Taxable Gross
N=Not Applicable
P=Percent of FWT (Many)
X=No State Withholding
Default Value: A
|
| 5 |
SUPPL_CON_METHOD |
Character(1) |
VARCHAR2(1) NOT NULL |
Supplemental Concurrent Method
D=Aggregate - No Annualize
G=Aggregate
M=Maryland Method
N=Aggregate-No Tax else Percent
P=Percent of Taxable Gross
Q=Non-Resident Supplemental
S=Special Table
T=Special Table with Exemptions
X=Not Applicable
Default Value: G
|
| 6 |
SUPPL_SEP_METHOD |
Character(1) |
VARCHAR2(1) NOT NULL |
Supplemental Separate Method
D=Aggregate - No Annualize
G=Aggregate
M=Maryland Method
N=Aggregate-No Tax else Percent
P=Percent of Taxable Gross
Q=Non-Resident Supplemental
S=Special Table
T=Special Table with Exemptions
X=Not Applicable
Default Value: P
|
| 7 |
SINGLE_STD_DED |
Number(6,0) |
INTEGER NOT NULL |
Single Standard Deduction
|
| 8 |
MARRIED_STD_DED |
Number(6,0) |
INTEGER NOT NULL |
Married Standard Deduction
|
| 9 |
ALLOWANCE_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Allowance Taken
|
| 10 |
SUPL_WAGE_RT |
Number(7,6) |
DECIMAL(6,6) NOT NULL |
Supplemental Wage Rate
|
| 11 |
FWT_CREDIT |
Character(1) |
VARCHAR2(1) NOT NULL |
FWT Credit
Y/N Table Edit
Default Value: N
|
| 12 |
FICA_CREDIT |
Character(1) |
VARCHAR2(1) NOT NULL |
FICA Credit
A=Actual FICA Credit
N=No FICA Credit
Y=Prorated FICA Credit
Default Value: N
|
| 13 |
SPECIAL_AMT_1 |
Signed Number(15,6) |
DECIMAL(13,6) NOT NULL |
Special Tax Amount 1
|
| 14 |
SPECIAL_AMT_2 |
Signed Number(15,6) |
DECIMAL(13,6) NOT NULL |
Special Tax Amount 2
|
| 15 |
SPECIAL_AMT_3 |
Signed Number(15,6) |
DECIMAL(13,6) NOT NULL |
Special Tax Amount 3
|
| 16 |
SPECIAL_AMT_4 |
Signed Number(15,6) |
DECIMAL(13,6) NOT NULL |
Special Tax Amount 4
|
| 17 |
SPECIAL_AMT_5 |
Signed Number(15,6) |
DECIMAL(13,6) NOT NULL |
Special Tax Amount 5
|
| 18 |
SPECIAL_DESCR_1 |
Character(15) |
VARCHAR2(15) NOT NULL |
Special Tax Amount Descr 1
|
| 19 |
SPECIAL_DESCR_2 |
Character(15) |
VARCHAR2(15) NOT NULL |
Special Tax Amount Descr 2
|
| 20 |
SPECIAL_DESCR_3 |
Character(15) |
VARCHAR2(15) NOT NULL |
Special Tax Amount Descr 3
|
| 21 |
SPECIAL_DESCR_4 |
Character(15) |
VARCHAR2(15) NOT NULL |
Special Tax Amount Descr 4
|
| 22 |
SPECIAL_DESCR_5 |
Character(15) |
VARCHAR2(15) NOT NULL |
Special Tax Amount Descr 5
|
| 23 |
RPT_NEG_WAGES |
Character(1) |
VARCHAR2(1) NOT NULL |
Report Negative Wages
I=Include
S=Separate
Default Value: I
|
| 24 |
TAX_RPT_INTERVAL |
Character(1) |
VARCHAR2(1) NOT NULL |
Tax Reporting
A=Annual
M=Monthly
Q=Quarterly
Default Value: M
|
| 25 |
EE_DTL_REQUIRED |
Character(1) |
VARCHAR2(1) NOT NULL |
Employee Detail Required
Y/N Table Edit
Default Value: Y
|
| 26 |
COMMON_PAY_IND |
Character(1) |
VARCHAR2(1) NOT NULL |
Use Common PayMaster for SUI?
Y/N Table Edit
Default Value: N
|
| 27 |
ALLOW_WH_REDUC |
Character(1) |
VARCHAR2(1) NOT NULL |
Allow Withholding Reduction
Y/N Table Edit
Default Value: N
|
| 28 |
NON_RES_DECLR_REQ |
Character(1) |
VARCHAR2(1) NOT NULL |
Non-Resident Declaration Req
Y/N Table Edit
Default Value: N
|
| 29 |
MINIMUM_WAGE |
Number(19,6) |
DECIMAL(18,6) NOT NULL |
State Statutory Minimum Hourly
|