| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 COMPANY |
Character(3) |
VARCHAR2(3) NOT NULL |
Company
Prompt Table:
COMPANY_TBL
|
| 2 |
STATE |
Character(6) |
VARCHAR2(6) NOT NULL |
State
Prompt Table:
STATE_TAX_TBL
|
| 3 |
EFFDT |
Date(10) |
DATE NOT NULL |
Effective Date
Default Value: %date
|
| 4 |
EFF_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Effective Status
A=Active
I=Inactive
Default Value: A
|
| 5 |
SUT_EFF_TAX_YR |
Number(4,0) |
SMALLINT NOT NULL |
SUT Effective Tax Year.
|
| 6 |
DIS_EFF_TAX_YR |
Number(4,0) |
SMALLINT NOT NULL |
Disability Effective Tax Year.
|
| 7 |
SUT_EFF_TAX_QTR |
Character(1) |
VARCHAR2(1) NOT NULL |
SUT Effective Tax Quarter.
1=First Quarter
2=Second Quarter
3=Third Quarter
4=Fourth Quarter
|
| 8 |
DIS_EFF_TAX_QTR |
Character(1) |
VARCHAR2(1) NOT NULL |
Disability Effective Tax Quarter.
1=First Quarter
2=Second Quarter
3=Third Quarter
4=Fourth Quarter
|
| 9 |
BRANCH_CD |
Number(2,0) |
SMALLINT NOT NULL |
Branch Code.
|
| 10 |
EXEMPT_SUT |
Character(1) |
VARCHAR2(1) NOT NULL |
Exempt From SUT.
Y/N Table Edit
Default Value: N
|
| 11 |
EXEMPT_DIS |
Character(1) |
VARCHAR2(1) NOT NULL |
Exempt From ER Disability.
Y/N Table Edit
Default Value: N
|
| 12 |
EMPLOYER_ID_SWT |
Character(20) |
VARCHAR2(20) NOT NULL |
Employer ID (SWT).
|
| 13 |
EMPLOYER_ID_SUT |
Character(20) |
VARCHAR2(20) NOT NULL |
Employer ID (SUT).
|
| 14 |
SUT_EXPERIENCE_RT |
Number(8,5) |
DECIMAL(7,5) NOT NULL |
SUT Experience Rate.
|
| 15 |
DIS_EXPERIENCE_RT |
Number(8,5) |
DECIMAL(7,5) NOT NULL |
Disability Experience Rate.
|
| 16 |
GL_SWT |
Character(35) |
VARCHAR2(35) NOT NULL |
GL Account #-SWT.
Prompt Table:
GL_ACCOUNT_VW
|
| 17 |
GL_SUT |
Character(35) |
VARCHAR2(35) NOT NULL |
GL Account #-SUT.
Prompt Table:
GL_ACCOUNT_VW
|
| 18 |
GL_SDI |
Character(35) |
VARCHAR2(35) NOT NULL |
GL Account #-SDI.
Prompt Table:
GL_ACCOUNT_VW
|
| 19 |
GL_SUT_ER |
Character(35) |
VARCHAR2(35) NOT NULL |
GL-SUT (Employer).
Prompt Table:
GL_ACCOUNT_VW
|
| 20 |
GL_SDI_ER |
Character(35) |
VARCHAR2(35) NOT NULL |
GL-SDI (Employer).
Prompt Table:
GL_ACCOUNT_VW
|
| 21 |
SHI_OVERRIDE |
Character(1) |
VARCHAR2(1) NOT NULL |
State Health Insurance Override.
Y/N Table Edit
Default Value: N
|
| 22 |
SHI_RATE |
Signed Number(8,6) |
DECIMAL(6,6) NOT NULL |
State Health Insurance Override Rate.
|
| 23 |
NON_RES_DECLR_REQ |
Character(1) |
VARCHAR2(1) NOT NULL |
Non-Resident Declaration Request.
Y/N Table Edit
Default Value: N
|
| 24 |
VDI_PLAN |
Character(1) |
VARCHAR2(1) NOT NULL |
Voluntary Disability Plan.
Y/N Table Edit
Default Value: N
|
| 25 |
VDI_PLAN_NBR |
Character(10) |
VARCHAR2(10) NOT NULL |
VDI Plan Number.
|
| 26 |
VDI_ADMIN_CODE |
Character(10) |
VARCHAR2(10) NOT NULL |
VDI Administrator Code.
Prompt Table:
VDI_ADMIN_TBL
|
| 27 |
GL_VDI_EE |
Character(35) |
VARCHAR2(35) NOT NULL |
GL Account #- VDI/EE.
Prompt Table:
GL_ACCOUNT_VW
|
| 28 |
GL_VDI_ER |
Character(35) |
VARCHAR2(35) NOT NULL |
GL Account #-VDI/ER.
Prompt Table:
GL_ACCOUNT_VW
|
| 29 |
VDI_EFF_TAX_YR |
Number(4,0) |
SMALLINT NOT NULL |
VDI Effective Tax Year.
|
| 30 |
VDI_EFF_TAX_QTR |
Character(1) |
VARCHAR2(1) NOT NULL |
VDI Effective Tax Quarter.
1=First Quarter
2=Second Quarter
3=Third Quarter
4=Fourth Quarter
|
| 31 |
VDI_EE_RT |
Number(8,5) |
DECIMAL(7,5) NOT NULL |
VDI Employee Rate Percent.
|
| 32 |
VDI_ER_RT |
Number(8,5) |
DECIMAL(7,5) NOT NULL |
VDI Employer Rate Percent.
|
| 33 |
EMPLOYER_ID_DIS |
Character(20) |
VARCHAR2(20) NOT NULL |
Employer ID (DIS).
|
| 34 |
GL_ST_EIC |
Character(35) |
VARCHAR2(35) NOT NULL |
State GL Acct#-EIC
Prompt Table:
GL_ACCOUNT_VW
|
| 35 |
UBI_NUMBER |
Number(12,0) |
DECIMAL(12) NOT NULL |
Unified Business ID Number
|
| 36 |
EAF_RATE |
Number(8,5) |
DECIMAL(7,5) NOT NULL |
Employment Administration Fund Rate
|
| 37 |
HEALTH_CARE_COV |
Character(1) |
VARCHAR2(1) NOT NULL |
Health Care Coverage
Y/N Table Edit
Default Value: N
|
| 38 |
PNA_FLI_ADMIN_CODE |
Character(10) |
VARCHAR2(10) NOT NULL |
FLI Administrator Code.
Prompt Table:
VDI_ADMIN_TBL
|
| 39 |
PNA_EFF_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Effective Status.
A=Active
I=Inactive
|
| 40 |
PNA_FLI_EFF_TAX_YR |
Number(4,0) |
SMALLINT NOT NULL |
FLI Effective Tax Year.
|
| 41 |
PNA_FLI_EFF_TX_QTR |
Character(1) |
VARCHAR2(1) NOT NULL |
FLI Effective Tax Quarter.
1=First Quarter
2=Second Quarter
3=Third Quarter
4=Fourth Quarter
|
| 42 |
PNA_FLI_PLAN |
Character(1) |
VARCHAR2(1) NOT NULL |
FLI Plan.
E=Exempt
N=Subject
X=Not Applicable
Y=Voluntary
Default Value: X
|
| 43 |
PNA_FLI_PLAN_NBR |
Character(10) |
VARCHAR2(10) NOT NULL |
FLI Plan Number.
|
| 44 |
PNA_FLI_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
FLI Status
E=Exempt
N=Not Applicable
V=Voluntary Plan
Y=Subject
|
| 45 |
PNA_FLI_EE_RT |
Number(8,5) |
DECIMAL(7,5) NOT NULL |
FLI Employee Rate Percent.
|
| 46 |
PNA_FLI_ER_RT |
Number(8,5) |
DECIMAL(7,5) NOT NULL |
FLI Employer Rate Percent.
|
| 47 |
PNA_GL_FLI_EE |
Character(35) |
VARCHAR2(35) NOT NULL |
GL Account FLI Employee.
Prompt Table:
GL_ACCOUNT_VW
|
| 48 |
PNA_GL_VFLI_EE |
Character(35) |
VARCHAR2(35) NOT NULL |
GL Account Voluntary FLI (Employee).
Prompt Table:
GL_ACCOUNT_VW
|
| 49 |
PNA_GL_VFLI_ER |
Character(35) |
VARCHAR2(35) NOT NULL |
GL Account Voluntary FLI (Employer).
Prompt Table:
GL_ACCOUNT_VW
|
| 50 |
SUI_OVERRIDE |
Character(1) |
VARCHAR2(1) NOT NULL |
UI Taxable Wage Base Override
Y/N Table Edit
Default Value: N
|
| 51 |
SUI_MAX_GROSS |
Number(8,0) |
INTEGER NOT NULL |
UI Taxable Wage Base
|
| 52 |
GL_TRANSIT |
Character(35) |
VARCHAR2(35) NOT NULL |
GL Account #- Oregon Statewide Transit Tax
Prompt Table:
GL_ACCOUNT_VW
|
| 53 |
PNA_GL_FLI_ER |
Character(35) |
VARCHAR2(35) NOT NULL |
GL Account FLI Employer.
Prompt Table:
GL_ACCOUNT_VW
|
| 54 |
PNA_GL_MLI_EE |
Character(35) |
VARCHAR2(35) NOT NULL |
GL Account MLI Employee.
Prompt Table:
GL_ACCOUNT_VW
|
| 55 |
PNA_GL_MLI_ER |
Character(35) |
VARCHAR2(35) NOT NULL |
GL Account MLI Employer
Prompt Table:
GL_ACCOUNT_VW
|
| 56 |
PNA_GL_VMLI_EE |
Character(35) |
VARCHAR2(35) NOT NULL |
GL Account Vol MLI Employee.
Prompt Table:
GL_ACCOUNT_VW
|
| 57 |
PNA_GL_VMLI_ER |
Character(35) |
VARCHAR2(35) NOT NULL |
GL Account Vol MLI Employer.
Prompt Table:
GL_ACCOUNT_VW
|
| 58 |
PNA_MLI_PLAN |
Character(1) |
VARCHAR2(1) NOT NULL |
MLI Plan.
E=Exempt
N=Subject
X=Not Applicable
Y=Voluntary
Default Value: X
|
| 59 |
PNA_MLI_PLAN_NBR |
Character(10) |
VARCHAR2(10) NOT NULL |
MLI Plan Number.
|
| 60 |
PNA_MLI_ADMIN_CODE |
Character(10) |
VARCHAR2(10) NOT NULL |
MLI Administrator Code.
Prompt Table:
VDI_ADMIN_TBL
|
| 61 |
PNA_MLI_EFF_TAX_YR |
Number(4,0) |
SMALLINT NOT NULL |
MLI Effective Tax Year.
|
| 62 |
PNA_MLI_EFF_TX_QTR |
Character(1) |
VARCHAR2(1) NOT NULL |
MLI Effective Tax Quarter.
1=First Quarter
2=Second Quarter
3=Third Quarter
4=Fourth Quarter
|
| 63 |
PNA_MLI_EE_PCT |
Number(6,2) |
DECIMAL(5,2) NOT NULL |
MLI Employee Percent.
|
| 64 |
PNA_MLI_ER_PCT |
Number(6,2) |
DECIMAL(5,2) NOT NULL |
MLI Employer Rate Percent.
|
| 65 |
PNA_FLI_EE_PCT |
Number(6,2) |
DECIMAL(5,2) NOT NULL |
FLI Employee Percent. (specific to WA)
|
| 66 |
PNA_FLI_ER_PCT |
Number(6,2) |
DECIMAL(5,2) NOT NULL |
FLI Employer Percent. (specific to WA)
|
| 67 |
PFML_ACCOUNT_ID |
Character(14) |
VARCHAR2(14) NOT NULL |
PFML Account ID used in MA PFML report
|
| 68 |
PY_GL_FML_EE |
Character(35) |
VARCHAR2(35) NOT NULL |
GL Account FMLI Employee.
Prompt Table:
GL_ACCOUNT_VW
|
| 69 |
PY_GL_FML_ER |
Character(35) |
VARCHAR2(35) NOT NULL |
GL Account FMLI Employer.
Prompt Table:
GL_ACCOUNT_VW
|
| 70 |
PY_GL_VFML_EE |
Character(35) |
VARCHAR2(35) NOT NULL |
GL Account Voluntary FMLI (Employee).
Prompt Table:
GL_ACCOUNT_VW
|
| 71 |
PY_GL_VFML_ER |
Character(35) |
VARCHAR2(35) NOT NULL |
GL Account Voluntary FMLI (Employer).
Prompt Table:
GL_ACCOUNT_VW
|
| 72 |
PY_FML_ADMIN_CODE |
Character(10) |
VARCHAR2(10) NOT NULL |
FMLI Administrator Code.
Prompt Table:
VDI_ADMIN_TBL
|
| 73 |
PY_FML_EE_RT |
Number(8,5) |
DECIMAL(7,5) NOT NULL |
FML Employee Rate Percent.
|
| 74 |
PY_FML_ER_RT |
Number(8,5) |
DECIMAL(7,5) NOT NULL |
FML Employer Rate Percent.
|
| 75 |
PY_FML_EFF_TAX_YR |
Number(4,0) |
SMALLINT NOT NULL |
FMLI Effective Tax Year.
|
| 76 |
PY_FML_EFF_TX_QTR |
Character(1) |
VARCHAR2(1) NOT NULL |
FMLI Effective Tax Quarter.
1=First Quarter
2=Second Quarter
3=Third Quarter
4=Fourth Quarter
|
| 77 |
PY_FML_PLAN |
Character(1) |
VARCHAR2(1) NOT NULL |
FML Plan.
E=Exempt
N=Not Applicable
V=Voluntary
Y=Subject
Default Value: N
|
| 78 |
PY_FML_PLAN_NBR |
Character(10) |
VARCHAR2(10) NOT NULL |
FMLI Plan Number.
|
| 79 |
LTC_EFF_TAX_YR |
Number(4,0) |
SMALLINT NOT NULL |
LTC Effective Tax Year.
|
| 80 |
LTC_EFF_TAX_QTR |
Character(1) |
VARCHAR2(1) NOT NULL |
LTC Effective Tax Quarter.
1=First Quarter
2=Second Quarter
3=Third Quarter
4=Fourth Quarter
|
| 81 |
PY_LTC_NO_APPLIC |
Character(1) |
VARCHAR2(1) NOT NULL |
Not Applicable LTC for EE.
Y/N Table Edit
Default Value: N
|
| 82 |
PY_GL_LTC_EE |
Character(35) |
VARCHAR2(35) NOT NULL |
GL Account #- LTC Tax
Prompt Table:
GL_ACCOUNT_VW
|