| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 STATE |
Character(6) |
VARCHAR2(6) NOT NULL |
State
|
| 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 Taxable Gross(Many)
P=Percent of FWT (Many)
T=Tiered Tax Table - YTD
X=No State Withholding
Default Value: A
|
| 5 |
SUPPL_CON_METHOD |
Character(1) |
VARCHAR2(1) NOT NULL |
Supplemental Concurrent Method
D=Aggregate - No Annualize
E=Percent of Taxable Gross(Many)
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
E=Percent of Taxable Gross(Many)
G=Aggregate
M=Maryland Method
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 |
Number(6,0) |
INTEGER NOT NULL |
Allowance Amount
|
| 10 |
SUPL_WAGE_RT |
Number(11,10) |
DECIMAL(10,10) 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(17,6) |
DECIMAL(15,6) NOT NULL |
Special Tax Amount 1
|
| 14 |
SPECIAL_AMT_2 |
Signed Number(17,6) |
DECIMAL(15,6) NOT NULL |
Special Tax Amount 2
|
| 15 |
SPECIAL_AMT_3 |
Signed Number(17,6) |
DECIMAL(15,6) NOT NULL |
Special Tax Amount 3
|
| 16 |
SPECIAL_AMT_4 |
Signed Number(17,6) |
DECIMAL(15,6) NOT NULL |
Special Tax Amount 4
|
| 17 |
SPECIAL_AMT_5 |
Signed Number(17,6) |
DECIMAL(15,6) NOT NULL |
Special Tax Amount 5
|
| 18 |
SPECIAL_DESCR_1 |
Character(30) |
VARCHAR2(30) NOT NULL |
Special Tax Amount Descr 1
|
| 19 |
SPECIAL_DESCR_2 |
Character(30) |
VARCHAR2(30) NOT NULL |
Special Tax Amount Descr 2
|
| 20 |
SPECIAL_DESCR_3 |
Character(30) |
VARCHAR2(30) NOT NULL |
Special Tax Amount Descr 3
|
| 21 |
SPECIAL_DESCR_4 |
Character(30) |
VARCHAR2(30) NOT NULL |
Special Tax Amount Descr 4
|
| 22 |
SPECIAL_DESCR_5 |
Character(30) |
VARCHAR2(30) 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?
1=Payee
2=Common Pay Master
3=Common ID
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 Request.
Y/N Table Edit
Default Value: N
|
| 29 |
MINIMUM_WAGE |
Number(19,6) |
DECIMAL(18,6) NOT NULL |
State Statutory Minimum Hourly
|
| 30 |
TIPS_MTD_THRESHOLD |
Number(19,6) |
DECIMAL(18,6) NOT NULL |
State Tips W/H Threshold
|
| 31 |
TIPS_DELAY_WTHLD |
Character(1) |
VARCHAR2(1) NOT NULL |
Delay Withholding of Taxes
Y/N Table Edit
|
| 32 |
SPECIAL_AMT_6 |
Signed Number(17,6) |
DECIMAL(15,6) NOT NULL |
Special Tax Amount 6
|
| 33 |
SPECIAL_AMT_7 |
Signed Number(17,6) |
DECIMAL(15,6) NOT NULL |
Special Tax Amount 7
|
| 34 |
SPECIAL_AMT_8 |
Signed Number(17,6) |
DECIMAL(15,6) NOT NULL |
Special Tax Amount 8
|
| 35 |
SPECIAL_AMT_9 |
Signed Number(17,6) |
DECIMAL(15,6) NOT NULL |
Special Tax Amount 9
|
| 36 |
SPECIAL_AMT_10 |
Signed Number(17,6) |
DECIMAL(15,6) NOT NULL |
Special Tax Amount 10
|
| 37 |
SPECIAL_AMT_11 |
Signed Number(17,6) |
DECIMAL(15,6) NOT NULL |
Special Tax Amount 11
|
| 38 |
SPECIAL_AMT_12 |
Signed Number(17,6) |
DECIMAL(15,6) NOT NULL |
Special Tax Amount 12
|
| 39 |
SPECIAL_AMT_13 |
Signed Number(17,6) |
DECIMAL(15,6) NOT NULL |
Special Tax Amount 13
|
| 40 |
SPECIAL_AMT_14 |
Signed Number(17,6) |
DECIMAL(15,6) NOT NULL |
Special Tax Amount 6
|
| 41 |
SPECIAL_AMT_15 |
Signed Number(17,6) |
DECIMAL(15,6) NOT NULL |
Special Tax Amount 6
|
| 42 |
SPECIAL_DESCR_6 |
Character(30) |
VARCHAR2(30) NOT NULL |
Special Tax Amount Descr 6
|
| 43 |
SPECIAL_DESCR_7 |
Character(30) |
VARCHAR2(30) NOT NULL |
Special Tax Amount Descr 7
|
| 44 |
SPECIAL_DESCR_8 |
Character(30) |
VARCHAR2(30) NOT NULL |
Special Tax Amount Descr 8
|
| 45 |
SPECIAL_DESCR_9 |
Character(30) |
VARCHAR2(30) NOT NULL |
Special Tax Amount Descr 9
|
| 46 |
SPECIAL_DESCR_10 |
Character(30) |
VARCHAR2(30) NOT NULL |
Special Tax Amount Descr 10
|
| 47 |
SPECIAL_DESCR_11 |
Character(30) |
VARCHAR2(30) NOT NULL |
Special Tax Amount Descr 11
|
| 48 |
SPECIAL_DESCR_12 |
Character(30) |
VARCHAR2(30) NOT NULL |
Special Tax Amount Descr 12
|
| 49 |
SPECIAL_DESCR_13 |
Character(30) |
VARCHAR2(30) NOT NULL |
Special Tax Amount Descr 13
|
| 50 |
SPECIAL_DESCR_14 |
Character(30) |
VARCHAR2(30) NOT NULL |
Special Tax Amount Descr 14
|
| 51 |
SPECIAL_DESCR_15 |
Character(30) |
VARCHAR2(30) NOT NULL |
Special Tax Amount Descr 15
|